Cmeteo stands for CORINE-meteo. Cmeteo can be seen an application suite to aggregate weather indicators from grid resolution to a regional type of division. These indicators will be aggregated to spatial themas like NUTS or agri environmental regions, or translated/adjusted for landcovers of interest like crops, etc. Translation will be accompanied by aggregation. The cmeteo package is designed to operate in several environments which may differ in both input as output datasets. All these environments need to have the basic data (both input and output) available for the CMeteo process.
Software tools needed by cmeteo
Cmeteo uses functionality which is implemented in several other software tools. The major ones are listed in the following table.
|REGLISTS||supplies specific lists of regions directed by input parameters.|
|MRS_PROCESS||contains common used functionality for processing more complex programs like cmeteo.|
|ADD_PROCESS_LOG||procedure to send some info to a logtable.|
|ADD_PROCESS_METRICS||procedure to send some data, retrieved during processing, to a logtable.|
|MRS_STATS||generic tool to collect some metrics during processing.|
|MRS_HTTP||generic tool to handle some messages.|
|DATE_GENERATOR||generic tool to generate specific lists of dates according to the input paramaters.|
Cmeteo uses many database objects. The objects that contain the primary datasets like weather data, landcover types and aggregation areas are listed in the table below:
|CMETEO_GRID_WEATHER||Weather indicators per grid||CGMS / CGFS / ASIA / GWSI|
|CMETEO_EPS_GRID_WEATHER||Weather indicators per grid (ECMWF EPS model)||CGFS|
|CMETEO_HIS_GRID_WEATHER||Weather indicators per grid (ECMWF HIS model)||CGFS|
|CMETEO_OPE_GRID_WEATHER||Weather indicators per grid (ECMWF OPE model)||CGFS|
|CMETEO_NUTS_WEATHER||Weather indicators per NUTS region||CGMS|
|CMETEO_EPS_NUTS_WEATHER||Weather indicators per NUTS region (ECMWF EPS model)||CGFS|
|CMETEO_HIS_NUTS_WEATHER||Weather indicators per NUTS region (ECMWF HIS model)||CGFS|
|CMETEO_OPE_NUTS_WEATHER||Weather indicators per NUTS region (ECMWF OPE model)||CGFS|
|CMETEO_ZONAL_WEATHER||Weather indicators per Agri-environmental region||CGMS|
|CMETEO_EPS_ZONAL_WEATHER||Weather indicators per Agri-environmental region (ECMWF EPS model)||CGFS|
|CMETEO_HIS_ZONAL_WEATHER||Weather indicators per Agri-environmental region (ECMWF HIS model)||CGFS|
|CMETEO_OPE_ZONAL_WEATHER||Weather indicators per Agri-environmental region (ECMWF OPE model)||CGFS|
|CMETEO_REGION_WEATHER||Weather indicators per administrative region||CGMS / CGFS / ASIA / GWSI|
|CMETEO_AGGREGATION_AREAS||Cultivated areas per crop for Administrative region per year||CGMS / CGFS / ASIA / GWSI|
|CMETEO_GRID_LANDCOVER_AREAS||Areas for intersections of grid and administrative region||CGMS / CGFS / ASIA / GWSI|
|CMETEO_LANDCOVERS||Landcovers types or crops to be evaluated||CGMS / CGFS / ASIA / GWSI|
|CMETEO_GRID_NUTS_LCV_AREAS||Areas for intersections of grid and NUTS region||CGMS|
|CMETEO_GRID_ZONAL_LCV_AREAS||Areas for intersections of grid and Agri-environmental region||CGMS|
|CMETEO_REJECTED_WEATHER||Weather indicators per region that could not be stored via CMETEO_REGION_WEATHER||CGMS / CGFS / ASIA / GWSI|
|CMETEO_REGION_MAPPINGS||Administrative regions and their mappings (relations)||CGMS / CGFS / ASIA / GWSI|
Supporting objects that are required by Cmeteo:
|CMETEO_PROCESS||CGMS / CGFS / ASIA / GWSI|
|CMETEO||CGMS / CGFS / ASIA / GWSI|
|CMET_REGION_WTH||ASIA / GWSI|
|PRCMN_PARAMETERS||CGMS / CGFS / ASIA / GWSI|
|PRCMN_PROCEDURES||CGMS / CGFS / ASIA / GWSI|
|PRCMN_PROCESS_OBJECTS||CGMS / CGFS / ASIA / GWSI|
|PRCMN_PROCESS_RUNS||CGMS / CGFS / ASIA / GWSI|
|PRCMN_PROCESSES||CGMS / CGFS / ASIA / GWSI|
|PROCMAN||CGMS / CGFS / ASIA / GWSI|
CMETEO_GRID_WEATHER is the object that contains the weather indicators in grid resolution that are needed as input for Cmeteo in a unified structure and with a uniform object name. In each environment (cgms / cgfs / asia / gwsi) the weather indicators in grid resolution are stored in tables with different names and structures. Also the collection of the attributes may vary. Cmeteo requires that the weather indicators in grid resolution are stored in an object with a specific structure and specific object name. Therefore some logic must be applied to transform the sets from various environments into a unified structure. This transformation is implemented by using views and/or synonyms on the original datasets while renaming the attributes and eventually suppliyng neutral or valuable data for missing attributes. The unified object CMETEO_GRID_WEATHER is composed of the most wide combination of attributes of the various underlying datasets.
CMETEO_EPS_GRID_WEATHER is a view to convert the structure of the primary data source into a unified structure
|Summery of structure conversion|
1) If an attribute for the offset of the day isn't available, the day-offset in cmeteo grid weather will be filled with a neutral value (0). This value doesn't influence the processing.
|Specifications of cmeteo_region_weather|
Cmeteo_region_weather is a replacement for a variety of datasets, both for themes (e.g. cgfs-his, cgms) and for resolutions (e.g. NUTS regions, agri-environmental zones), to which cmeteo need to fill up with output. In general, datasets for NUTS-regions are pre- or postfixed with 'nuts'; datasets for agri_environmental zones are pre- or postfixed with 'zonal'.
Below a summary of some sets in various schemas and the definition of cmeteo_region_weather
1) The value for the offset of the day as produced by cmeteo will not be inserted into indicated sets.
|Specifications of cmeteo_aggregation_areas|
Cmeteo_aggregation_areas is a replacement for a some of datasets from which cmeteo need to gather input concerning sizes of surfaces.
Below a summary of some sets in various schemas and the definition of cmeteo_aggregation_areas
1) CGFS_EUR_09 uses the dataset of CGMS_EUR_08.
|Specifications of cmeteo_grid_landcover_areas|
Cmeteo_grid_landcover_areas is a replacement for a some of datasets from which cmeteo need to gather input concerning sizes of surfaces.
Below a summary of some sets in various schemas and the definition of cmeteo_grid_landcover_areas
1) CGFS_EUR_09 uses the dataset of CGMS_EUR_08.