Changes between Version 10 and Version 11 of WorkingGrid/DataProviderSetup/PMLOct06


Ignore:
Timestamp:
02/10/06 17:48:03 (13 years ago)
Author:
mhenning
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • WorkingGrid/DataProviderSetup/PMLOct06

    v10 v11  
    1515  Currently, the database has one MOLES record for each year of data for a particular sensor and area: 
    1616 
    17 ||'''Sensor'''||'''Record Count'''|| 
    18 ||MERIS||32|| 
    19 ||MODIS||81|| 
    20 ||AVHRR||617|| 
    21 ||SeaWiFS||260|| 
    22 ||'''Total'''||'''1054'''|| 
     17{{{ 
     18mhen=# SELECT production_tool.description AS Sensor, COUNT(data_entity.*) AS RecordCount FROM ndg.data_entity, ndg.data_entity_deployment, ndg.production_tool, ndg.deployment WHERE deployment.production_tool_id = production_tool.production_tool_id AND data_entity_deployment.data_entity_id = data_entity.data_entity_id AND data_entity_deployment.deployment_id = deployment.deployment_id GROUP BY(production_tool.description); 
     19 sensor  | recordcount  
     20---------+------------- 
     21 AVHRR   |         617 
     22 MERIS   |          32 
     23 MODIS   |          81 
     24 SeaWiFS |         260 
     25(4 rows) 
     26 
     27mhen=#  
     28}}} 
     29'''(Total 1054''') 
    2330 
    2431 * DIFs can now be generated using sed in combination with a [http://wwwdev.npm.ac.uk/rsg/staff/mhen/ndg/NDG-DIF_pml.xq slightly modified XQuery]. An example DIF is available here: [http://wwwdev.npm.ac.uk/rsg/staff/mhen/ndg/DIF_500.xml DIF500]