From Agri4castWiki
Revision as of 15:23, 14 February 2014 by Henk (talk | contribs)
Jump to: navigation, search


CMETEO stands for CORINE-meteo. The softwaretool CMETEO can be seen an application suite to aggregate data of meteo indicators as found in e.g. the CGMS_EUR_08.GRID_WEATHER dataset or similar data sets at grid resolutions. Think of meteo indicators on temperature (maximum, minimum, mean or daily), windspeed, precipitation, radiation, potential transpiration, evaporation etc. In the context of MARS, the weather indicators are given at a regular grid. These indicators will be aggregated to spatial resolutions like administrative regions (NUTS level 3-0) or agri-environmental regions according to 1) a general area weighted algorithm and 2) a landcover (or even crop) specific area weighted algorithm.

The process

The process can be described in a short way as:

After starting, use the supplied interface to initialise some more parameters holding values that are valid during the execution of the process.

  • parameters according the user name, theme and spatial type: ROI, type of aggregation {plain, median -- in case of weather forecast members}, type of interval {day, dekad}, indication to include a crop specific aggregation {yes,no}, thresholds whether to include a grid cell based on its landcover or crop specific area {a comma seperated list of integer for each threshold needed, integers are in the range of: 0 up to 99}
  • get a list of all days to process
  • get a list of all landcovers that are relevant for the ROI
  • get a list of all cmeteo-members, being day-offsets (days in forecast depth) and members of meteo-ensembles. Mostly, the cmeteo-members refers to only one member and no day-offset (e.g. data sets like GRID_WEATHER).

Continue to process regions of level 0 (=countries) belonging to the ROI:

  • get a region (country)
  • get all subregions of all levels contained in that region.
  • gather input for each subregion:
    • initialise an array of weather indicators for all days, all landcovers and all members of cmeteo (day-offsets and member_no's).
    • for each day:
      • collect available weather indicators of all cmeteo-members for the grid cells contained in the subregion.
      • for each threshold:
        • if the size of area is above the threshold, summarise them per cmeteo-member and landcover. The values are weighted with the landcover specific area of the grid cell.
        • optionally, add a crop specific aggregation, weighted for the area of the crop in the region (note that crop area statistics are only available at administrative/region level and thus can only be used in aggregations from NUTS level 3 to higher levels)
        • add this collection of data to the region that contains this subregion to facilitate the aggregation of the regions at higher levels.

As a result an array is filled with aggregated weather indicators per (sub)region, landcover (or even crop), day and cmeteo-member. The records of the array will be merged into the database according the rules:

  • if the record does not contain any result (no aggregation), then delete it's former representation from the database if one exists
  • if the record contains a result (an aggregation), then update it's former representation in the database if one exists
  • if the record contains a result (an aggregation), then insert it into the database if no former representation exists

The procedure stops after processing all indicated regions of level 0 belonging to the ROI.


The CMETEO package is designed to operate in several environments (i.e. database schemas) which may differ in both input (different tables names, definitions, structure, interval of time, etc.) as output datasets (different type of spatial resolutions, agri-environmental zones etc). All these environments need to have the basic data (gridded weather, list of regions, land cover or even crop specific areas per grid cell) and a number of CMETEO database objects available for the CMETEO process.

Software tools needed by CMETEO

The essential functionality of the process is implemented in the packages: CMETEO_admin and CMETEO_process. CMETEO uses functionality which is implemented in several other software tools. The major ones are listed in the following table.

tool remarks
REGLISTS supplies specific lists of regions directed by input parameters.
DATE_GENERATOR generic tool to generate lists of dates and some additional attributed based on the input parameters.
PROCMAN package serving configurations for processing executed by complex programs like CMETEO.
PROCESS LOGGING set of procedures to send info to the user interface (you may extend these to send to log tables).
UPDATE_EVENTS_ARCHIVE procedure to signal the PMB (Project Management Board) that the processing ended successfully.

Installation of CMETEO

To install CMETEO you need to follow steps as

  • check the environment, if the objects needed by the CMETEO package are available
  • install the objects of the CMETEO package
  • add configurations to PROCMAN for any schema you wish to process CMETEO on

In the next paragraphs these steps will be detailed.

CMETEO will be installed in the database. So you need to decide in which schema you wish to install. Currently, CMETEO is installed in the MRSMAN schema, which is intended to be the base of applications to process on datasets that are in other schemas. As CMETEO is such an application, it is a good choice to install it in the MRSMAN schema. However, it should not be installed in a schema that is to be processed by CMETEO.

Tools or objects needed by CMETEO do't be installed necessarily in the same schema as CMETEO. It is sufficient to grant access to these objects to the owner/schema in which CMETEO will be installed.

Installation of CMETEO, check the environment

Check that the following tools or objects are valid and available:

Tools, currently installed in the FORALL schema:


Tools, currently installed in the MRSMAN schema:


Tool, currently installed in the PMB schema:



Before the process will be executed, some checks and tasks, mainly administrative, are done.

  • The module checks if no other instance of CMETEO is active in it's schema and registers itself as active. At any one moment only at most one process per schema can be active.
  • After registering, it checks if all objects are available that are needed for the selected theme (including the ROI).
  • It also redefines some synonyms (dynamic synonyms like CMETEO_REGION_WEATHER and CMETEO_GRID_LANDCOVER_AREAS) according to the demands of the theme.
  • Before processing, it checks the availability of weather indicators for the selected interval.
  • After processing, it collects counts of processed data and some other items and stores them into the metrics table (DB schema XMRSMAN).
  • It signals the Project Management Board that the process has successfully ended.
  • Finally it releases the lock on active processes.


The CMETEO package is designed to act in a batch file, or to start from a commandline. Both methods use the same procedure, CMETEO_ADMIN.DO_AGGREGATION to start with. This procedure defines the interface consisting of parameters, both obligatory or optional.

To get CMETEO working properly, you supply:

  • the name of the database schema that holds the data to be processed. Although the schema name is not defined as a parameter, this name is part of the interface. You supply this name as the user name when you login to the database to process CMETEO.
  • p_theme: theme, an indication of the group of meteo indicators you wish to process. See the list below for possible themes.
  • p_spatial: spatial indicator, e.g. 'Regions', 'agri-environmental zones'. See the list below for possible alternatives.

N.B. you must supply the parameters for theme and spatial indicators exactly as they are defined.

Optionally, you can supply:

  • qry_region: a set identifiers of regions to be processed.
  • p_yr2start,p_yr2end,p_dy2start,p_dy2end: a day or an interval of days to be processed.
  • p_refresh: an indicator whether or not to refresh the previously aggregated weather indicators.

Details of the interface

Themes and spatial indicators used by cmeteo process performed in schema:
schema: process: theme: spatial indicator:
cgfs_eur_09 cmeteo-cgfs-eps-nuts weather(simulated) eps NUTS
cgfs_eur_09 cmeteo-cgfs-eps-zones weather(simulated) eps agri-environmental zones
cgfs_eur_09 cmeteo-cgfs-his-nuts weather(simulated) his NUTS
cgfs_eur_09 cmeteo-cgfs-his-zones weather(simulated) his agri-environmental zones
cgfs_eur_09 cmeteo-cgfs-ope-nuts weather(simulated) ope NUTS
cgfs_eur_09 cmeteo-cgfs-ope-zones weather(simulated) ope agri-environmental zones
cgfs14eu cmeteo-cgfs14eu-his-regions weather(simulated) his Regions
cgfs14eu cmeteo-cgfs14eu-his-zones weather(simulated) his agri-environmental zones
cgms12eu cmeteo-cgms12eu-regions weather(observed) Regions
cgms12eu cmeteo-cgms12eu-zones weather(observed) agri-environmental zones
cgms_asia_08 cmeteo-cgms-asia Weather - CGMS - Analysis Regions
cgms_eur_08 cmeteo-cgms-nuts weather(observed) NUTS
cgms_eur_08 cmeteo-cgms-zones weather(observed) agri-environmental zones
gwsi_e_12 cmeteo-gwsi_e Weather - GWSI - Analysis Regions
gwsi_t_12 cmeteo-gwsi_t Weather - GWSI - Analysis Regions

  • The theme must be supplied in p_theme. See the table above for possible alternatives. It is an extraction of the process table in MRSMAN.
  • The spatial indicator must be supplied in p_spc_res. See the table above for possible alternatives. It is an extraction of the process table in MRSMAN.
  • (Optional) An interval or day to process in the set of: p_yr2start,p_dy2start,p_yr2end,p_dy2end. CMETEO uses several possibilities to define an interval. A coarse way is to mention a year to start and a year to end. In this case all days from the first of January of the starting year to the last day of December of the ending year will be processed. A more fine grained way is to provide a date to start and a date to end in which case only the days in between will be processed, or even one day if both entered dates are the same. You may supply any combination of years and dates. If you don't supply any, the default interval will be chosen, which starts at the first of January of the current year and runs up to the day before today. In fact, no day in the future will be processed.
  • (Optional) an indicator to enable replacement of previously aggregated weather indicators in p_refresh, being one of 'yes', 'no'. The default is 'yes'. This one will be used when no value for this parameter has been supplied.
  • A set identifiers of regions to be processed in qry_region. You may add a query or sql statement that delivers the preferred subset of regions for which you need cmeteo. The regions must be identified by their reg_map_id as found in table REGION_MAPPINGS.

If supplied, the selected set must contain some or all reg_map_ids of level 0 (!) for the relevant ROI, e.g.: select rm.reg_map_id from region_mappings rm where rm.reg_level = 0 and rm.reg_code in ('LU', 'BE', 'NL'); You also may supply a limited list of ids of region mappings which must be comma separated. If you leave this parameter empty, all regions of the ROI will be processed.

Several datasources work with the generic interface of CMETEO. The most important ones are listed in the table below.

Datasets used by cmeteo:
dataset containing: base set in CGMS_EUR_08 intermediate set for cmeteo name in cmeteo remarks
weather indicators per grid GRID_WEATHER CMETEO_GRID_WEATHER CMETEO_GRID_WEATHER input for cmeteo; intermediate set contains standardized attribute names
weather indicators per NUTS-region NUTS_WEATHER CMETEO_NUTS_WEATHER CMETEO_REGION_WEATHER output of cmeteo; intermediate set contains standardized attribute names
weather indicators per agri-environmental region ZONAL_WEATHER CMETEO_ZONAL_WEATHER CMETEO_REGION_WEATHER output of cmeteo; intermediate set contains standardized attribute names
landcovers or crops to be evaluated CROP_LANDCOVER CMETEO_LANDCOVERS CMETEO_LANDCOVERS input for cmeteo; intermediate set contains standardized attribute names
landcover areas intersection of grid and NUTS region GRID_PLUS_NUTS_LANDCOVER CMETEO_GRID_NUTS_LCV_AREAS CMETEO_GRID_LANDCOVER_AREAS input for cmeteo; intermediate set contains standardized attribute names
areas/surfaces for landcovers per grid and per agri-env. region GRID_PLUS_ENS_LANDCOVER CMETEO_GRID_ZONAL_LCV_AREAS CMETEO_GRID_LANDCOVER_AREAS input for cmeteo; intermediate set contains standardized attribute names
weather indicators per region which are rejected CMETEO_REJECTED_WEATHER output of cmeteo, containing weather indicators per region and date that could not be stored in regular output dataset via cmeteo_region_weather
regions and their mappings CMETEO_REGION_MAPPINGS CMETEO_REGIONS input for cmeteo