Difference between revisions of "CMETEO"

From Agri4castWiki
Jump to: navigation, search
(Interface)
Line 122: Line 122:
 
3) If an attribute for the mean or daily temperature doesn't exist, this value will be estimated as the mean value of minimum and maximum temperature of the day. Cmeteo will process this value and produces a result for it.<br>
 
3) If an attribute for the mean or daily temperature doesn't exist, this value will be estimated as the mean value of minimum and maximum temperature of the day. Cmeteo will process this value and produces a result for it.<br>
 
4) A dummy value (0) for the dew temperature wil be supplied to cmeteo grid weather for sets lacking such an attribute. Cmeteo will process this value and produces a result for it, so precautions must be taken to supply these results to the output table.<br>
 
4) A dummy value (0) for the dew temperature wil be supplied to cmeteo grid weather for sets lacking such an attribute. Cmeteo will process this value and produces a result for it, so precautions must be taken to supply these results to the output table.<br>
 +
|}
 +
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Specifications of cmeteo_region_weather
 +
|-
 +
|
 +
Cmeteo_region_weather is a replacement for a variety of datasets to which cmeteo need to fill up with output.<br>
 +
In various schemas, datasets containing weather indicators do vary both in name of the set and in names of the attributes. Also the collection of the attributes may vary. However, all the sets contain the essential indicators for which cmeteo delivers output. As cmeteo only can use one structure for region weather, some logic must be applied to transform the various sets into unified representations. This transformation is implemented as a view (with the possibility to insert/update values) on each of the original datasets while renaming the attributes. As the dataset cmeteo_region_weather delivers the most wide combination of attributes of the various underlying datasets, some precautions must be taken to prevent some useless attributes being placed into final dataset. Functionality for this is located in a technical construct (triggers) which is connected with the views.
 +
 +
Below a summary of some sets in various schemas and the definition of cmeteo_region_weather
 +
 +
{|class="wikitable"
 +
! !! !! !! !! !! !!domain
 +
|-
 +
!schema:
 +
|CGMS_EUR_08
 +
|CGFS_EUR_09
 +
|CGFS_EUR_09
 +
|CGMS_ASIA_08
 +
|-
 +
!dataset:
 +
|nuts_weather
 +
|ecmwf_his_downscaled_nuts
 +
|ecmwf_eps_downscaled_nuts
 +
|nuts_weather
 +
|cmeteo_region_weather
 +
|-
 +
!attributes:
 +
  |reg_map_id          || reg_map_id      ||reg_map_id      ||reg_map_id        ||reg_map_id      ||NN number(10)
 +
|-                     
 +
| ||landcover_id        || landcover_id    ||landcover_id    ||landcover_id      ||landcover_id    ||NN number(10)
 +
|-                     
 +
| ||threshold            || threshold        ||threshold        ||threshold        ||threshold        ||NN number(3)
 +
|-                     
 +
| ||day                  || mdate            ||mdate            ||day              ||day              ||NN date
 +
|-                     
 +
| || - 1)                || - 1)            ||date_offset      || - 1)            ||day_offset      ||NN number(10)
 +
|-                     
 +
| || - 2)                || - 2)            ||member_no        || - 2)            ||member_no        ||NN number(10)
 +
|-                     
 +
| ||maximum_temperature  || temperature_max  ||temperature_max  ||max_temperature  ||max_temperature  ||NN number(3,1)
 +
|-                     
 +
| ||minimum_temperature  || temperature_min  ||temperature_min  ||min_temperature  ||min_temperature  ||NN number(3,1)
 +
|-                     
 +
| ||daily_temperature    || temperature_mean ||temperature_mean ||daily_temperature ||mean_temperature ||NN number(3,1)
 +
|-                     
 +
| || - 3)                || temperature_dew  ||temperature_dew  ||dew_temperature  ||dew_temperature  ||NN number(3,1)
 +
|-                     
 +
| ||vapour_pressure      || vapour_pressure  ||vapour_pressure  ||vapour_pressure  ||vapour_pressure  ||NN number(4,2)
 +
|-                     
 +
| ||windspeed            || wind_speed      ||wind_speed      ||wind_speed        ||wind_speed      ||NN number(5,1)
 +
|-                     
 +
| ||rainfall            || precipitation    ||precipitation    ||precipitation    ||precipitation    ||NN number(4,1)
 +
|-                     
 +
| ||e0                  || e0              ||e0              ||e0              ||e0              ||NN number(4,2)
 +
|-                     
 +
| ||es0                  || es0              ||es0              ||es0              ||es0              ||NN number(4,2)
 +
|-                     
 +
| ||et0                  || et0              ||et0              ||et0              ||et0              ||NN number(4,2)
 +
|-                     
 +
| ||calculated_radiation || radiation_global ||radiation_global ||global_radiation ||global_radiation ||NN number(6)
 +
|-                     
 +
| ||snow_depth          || snow_depth      ||snow_depth      ||snow_depth      ||snow_depth      ||number(6,2)
 +
|}
 +
 +
1) The value for the offset of the day as produced by cmeteo will not be inserted into indicated sets.<br>
 +
2) The value for the member as produced by cmeteo will not be inserted into indicated sets.<br>
 +
3) As input for this attribute was lacking cmeteo produced a dummy value (0). This value must be omitted.<br>
 
|}
 
|}
  

Revision as of 19:17, 31 January 2011



Introduction

Cmeteo stands for CORINE-meteo. Cmeteo can be seen an application suite to process meteo data as found in e.g. the CGMS.grid_weather dataset. It aggregates and translates meteo indicators according to some spatial and thematic specs. Think of meteo indicators on temperature (maximum, minimum, mean or daily), windspeed, precipitation, radiation. Also indicators as potential transpiration, evaporation may be included. In the context of MARS, the weather indicators are given per grid. 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. See ..(somewhere else in this wiki).. for more detailed description of cmeteo.

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.

tool remarks
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.

Interface

Datasets used by cmeteo
dataset containing example in CGMS_EUR_08 name in cmeteo remarks
weather indicators per grid grid_weather cmeteo_grid_weather input for cmeteo, renaming some columns to a standardized naming
weather indicators per NUTS-region nuts_weather cmeteo_region_weather output for cmeteo, renaming some columns to a standardized naming
weather indicators per agri-environmental region (stratum, zone) zonal_weather cmeteo_zonal_weather output for cmeteo, renaming some columns to a standardized naming
landcovers or crops to be evaluated crop_landcover cmeteo_landcovers input for cmeteo, renaming some columns to a standardized naming
areas/surfaces for landcovers per grid and per NUTS region grid_plus_nuts_landcover cmeteo_grid_nuts_lcv_areas input for cmeteo, renaming some columns to a standardized naming
areas/surfaces for landcovers per grid and per agri-env. region grid_plus_ens_landcover cmeteo_grid_zonal_lcv_areas input for cmeteo, renaming some columns to a standardized naming
areas/surfaces for crops per NUTS region aggregation_areas cmeteo_aggregation_areas input for cmeteo, renaming some columns to a standardized naming
weather indicators per region which are rejected cmeteo_rejected_weather output for cmeteo, containing weather indicators per region that could not be stored in regular output
regions and their mappings cmeteo_region_mappings input for cmeteo



Examples