Difference between revisions of "Appendix 5: Database objects/CGMS12old"

From Agri4castWiki
Jump to: navigation, search
m (Wimdewinter moved page Appendix 5: CGMS tables to Appendix 5: Database objects/CGMS12old: consisten url for automated processing)
(header level 3)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 
{{Expert}}
 
{{Expert}}
==AEZ==
+
===AEZ===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: use to references the tables {{Object|REGION_DESCRIPTIONS}} and {{Object|REGION_MAPPINGS}}
 
*Use: use to references the tables {{Object|REGION_DESCRIPTIONS}} and {{Object|REGION_MAPPINGS}}
Line 34: Line 34:
 
<br>
 
<br>
  
==AGGREGATION_AREAS==
+
===AGGREGATION_AREAS===
 
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 
*Use: used for weighting during aggregating crop indicators towards regional crop indicators
 
*Use: used for weighting during aggregating crop indicators towards regional crop indicators
Line 84: Line 84:
 
<br>
 
<br>
  
==CGMS_SYSLOG==
+
===CGMS_SYSLOG===
 
*Description: logging of run options.
 
*Description: logging of run options.
 
*Use: output table containing information on the run executed
 
*Use: output table containing information on the run executed
Line 126: Line 126:
 
<br>
 
<br>
  
==CMETEO_ADMIN==
+
===CMETEO_ADMIN===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use:  
 
*Use:  
Line 133: Line 133:
 
<br>
 
<br>
  
==CMETEO_AEZ_GRID_LANDCOVERS==
+
===CMETEO_AEZ_GRID_LANDCOVERS===
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Use: input for cmeteo with standardized attribute names
 
*Use: input for cmeteo with standardized attribute names
Line 157: Line 157:
 
<br>
 
<br>
  
==CMETEO_AGGREGATION_AREAS==
+
===CMETEO_AGGREGATION_AREAS===
 
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 
*Use: input for cmeteo, converting names of columns for use in cmeteo package
 
*Use: input for cmeteo, converting names of columns for use in cmeteo package
Line 183: Line 183:
 
<br>
 
<br>
  
==CMETEO_CROPS==
+
===CMETEO_CROPS===
 
*Description: description of crops. Crop name, number, associated crop group and general month.
 
*Description: description of crops. Crop name, number, associated crop group and general month.
 
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
 
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
Line 213: Line 213:
 
<br>
 
<br>
  
==CMETEO_GRID_LANDCOVER_AREAS==
+
===CMETEO_GRID_LANDCOVER_AREAS===
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Use: input for cmeteo with standardized attribute names
 
*Use: input for cmeteo with standardized attribute names
Line 237: Line 237:
 
<br>
 
<br>
  
==CMETEO_GRID_WEATHER==
+
===CMETEO_GRID_WEATHER===
 
*Description: weather indicators per grid
 
*Description: weather indicators per grid
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 287: Line 287:
 
<br>
 
<br>
  
==CMETEO_LANDCOVERS==
+
===CMETEO_LANDCOVERS===
 
*List of landcovers or crops to be evaluated in [[CMETEO]]
 
*List of landcovers or crops to be evaluated in [[CMETEO]]
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 307: Line 307:
 
<br>
 
<br>
  
==CMETEO_PROCESS==
+
===CMETEO_PROCESS===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use:  
 
*Use:  
Line 314: Line 314:
 
<br>
 
<br>
  
==CMETEO_REGION_GRID_LANDCOVERS==
+
===CMETEO_REGION_GRID_LANDCOVERS===
 
*Description: landcover areas for each intersection of grid and administartive region (only level 3).
 
*Description: landcover areas for each intersection of grid and administartive region (only level 3).
 
*Use: input for cmeteo with standardized attribute names
 
*Use: input for cmeteo with standardized attribute names
Line 338: Line 338:
 
<br>
 
<br>
  
==CMETEO_REGION_MAPPINGS==
+
===CMETEO_REGION_MAPPINGS===
 
*Description: regions and their relations (mappings)
 
*Description: regions and their relations (mappings)
 
*Use: input for cmeteo
 
*Use: input for cmeteo
Line 384: Line 384:
 
<br>
 
<br>
  
==CMETEO_REGION_WEATHER==
+
===CMETEO_REGION_WEATHER===
 
*Description: weather indicators per region
 
*Description: weather indicators per region
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 438: Line 438:
 
<br>
 
<br>
  
==CMETEO_REGIONS==
+
===CMETEO_REGIONS===
 
*Description:  
 
*Description:  
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 474: Line 474:
 
<br>
 
<br>
  
==CMETEO_REJECTED_WEATHER==
+
===CMETEO_REJECTED_WEATHER===
 
*Description: rejected weather
 
*Description: rejected weather
 
*Use: log table for cmeteo
 
*Use: log table for cmeteo
Line 532: Line 532:
 
<br>
 
<br>
  
==CMETEO_WEATHER_OBS_AEZ==
+
===CMETEO_WEATHER_OBS_AEZ===
 
*Description: weather indicators per agri-environmental region
 
*Description: weather indicators per agri-environmental region
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 585: Line 585:
 
<br>
 
<br>
  
==CMETEO_WEATHER_OBS_GRID==
+
===CMETEO_WEATHER_OBS_GRID===
 
*Description: weather indicators per grid
 
*Description: weather indicators per grid
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 634: Line 634:
 
<br>
 
<br>
  
==CMETEO_WEATHER_OBS_REGION==
+
===CMETEO_WEATHER_OBS_REGION===
 
*Description: weather indicators per region
 
*Description: weather indicators per region
 
*Use: input for cmeteo, renaming columns to a standardized naming
 
*Use: input for cmeteo, renaming columns to a standardized naming
Line 687: Line 687:
 
<br>
 
<br>
  
==CROP==
+
===CROP===
 
*Description: description of crops. Crop name, number, associated crop group and general month.
 
*Description: description of crops. Crop name, number, associated crop group and general month.
 
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
 
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
Line 724: Line 724:
 
<br>
 
<br>
  
==CROP_CALENDAR==
+
===CROP_CALENDAR===
 
*Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
 
*Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
 
*Use: determines which crops are simulated for a grid, and simulation period
 
*Use: determines which crops are simulated for a grid, and simulation period
Line 762: Line 762:
 
<br>
 
<br>
  
==CROP_GROUP==
+
===CROP_GROUP===
 
*Description: description of crop groups
 
*Description: description of crop groups
 
*Use: input table for the crop group number and name where crop belongs to
 
*Use: input table for the crop group number and name where crop belongs to
Line 782: Line 782:
 
<br>
 
<br>
  
==CROP_LANDCOVER==
+
===CROP_LANDCOVER===
 
*List of crop and landcovers  
 
*List of crop and landcovers  
 
*Use: source for various views & synonyms
 
*Use: source for various views & synonyms
Line 811: Line 811:
 
<br>
 
<br>
  
==CROP_PARAMETER_VALUE==
+
===CROP_PARAMETER_VALUE===
 
*Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
 
*Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
 
*Use: input table for the crop simulation process
 
*Use: input table for the crop simulation process
Line 835: Line 835:
 
<br>
 
<br>
  
==CROP_YIELD==
+
===CROP_YIELD===
 
*Description:  
 
*Description:  
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
Line 896: Line 896:
 
<br>
 
<br>
  
==DATA_FOR_YIELD_FORECAST==
+
===DATA_FOR_YIELD_FORECAST===
 
*Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).  
 
*Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).  
 
*Use: table for storing the indicators values that can be used for regression and scenario-analysis (see [[Yield_Forecasting|Yield Forecasting]]).
 
*Use: table for storing the indicators values that can be used for regression and scenario-analysis (see [[Yield_Forecasting|Yield Forecasting]]).
Line 922: Line 922:
 
<br>
 
<br>
  
==DATE_GENERATOR==
+
===DATE_GENERATOR===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: view on [[DATE_GENERATOR]] package
 
*Use: view on [[DATE_GENERATOR]] package
Line 929: Line 929:
 
<br>
 
<br>
  
==DATES_75_15==
+
===DATES_75_15===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: view on [[DATE_GENERATOR]] package
 
*Use: view on [[DATE_GENERATOR]] package
Line 968: Line 968:
 
<br>
 
<br>
  
==DAY_DECADEYEAR==
+
===DAY_DECADEYEAR===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: view on [[DATE_GENERATOR]] package
 
*Use: view on [[DATE_GENERATOR]] package
Line 992: Line 992:
  
  
==GRID_<MODEL>==
+
===GRID_<MODEL>===
 
*Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
 
*Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
 
*Use: input for downscaling.
 
*Use: input for downscaling.
Line 1,029: Line 1,029:
  
  
==EMU==
+
===EMU===
 
*Description: the intersection of the soil map and the grid
 
*Description: the intersection of the soil map and the grid
 
*Use: input/reference table for the crop simulation process
 
*Use: input/reference table for the crop simulation process
Line 1,051: Line 1,051:
 
<br>
 
<br>
  
==FOREYIELD_HIS_REGION==
+
===FOREYIELD_HIS_REGION===
 
*Description: End of season forecast  
 
*Description: End of season forecast  
 
*Use: to store forecast results from the [[Software_Tools#CGMS_statistical_tool|CST]] operational batch mode.  
 
*Use: to store forecast results from the [[Software_Tools#CGMS_statistical_tool|CST]] operational batch mode.  
Line 1,074: Line 1,074:
 
<br>
 
<br>
  
==GRID==
+
===GRID===
 
*Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
 
*Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
 
*Use: input/reference table for both level 1 and level 2
 
*Use: input/reference table for both level 1 and level 2
Line 1,108: Line 1,108:
  
  
==GRID_SEA_DOWN_ALGORITHMS==
+
===GRID_SEA_DOWN_ALGORITHMS===
 
*Description: grid specific downscaling equations per OPE grid cell.
 
*Description: grid specific downscaling equations per OPE grid cell.
 
*Use: Downscaling SEA model data.
 
*Use: Downscaling SEA model data.
Line 1,213: Line 1,213:
  
  
==GRID_YIELD==
+
===GRID_YIELD===
 
*Description:  
 
*Description:  
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
Line 1,272: Line 1,272:
 
<br>
 
<br>
  
==INITIAL_SOIL_WATER==
+
===INITIAL_SOIL_WATER===
 
*Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
 
*Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
 
*Use: input for level 2
 
*Use: input for level 2
Line 1,305: Line 1,305:
 
<br>
 
<br>
  
==JSOW==
+
===JSOW===
 
*Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
 
*Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
 
*Use:  Input table for calculating one of the [[Crop Simulation]] indicators.
 
*Use:  Input table for calculating one of the [[Crop Simulation]] indicators.
Line 1,327: Line 1,327:
 
<br>
 
<br>
  
==LINK_AEZ_GRID_LANDCOVER==
+
===LINK_AEZ_GRID_LANDCOVER===
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 
*Use: input for cmeteo
 
*Use: input for cmeteo
Line 1,351: Line 1,351:
 
<br>
 
<br>
  
==LINK_EMU_REGION==
+
===LINK_EMU_REGION===
 
*Description: intersection of grid, administrative regions and soil mapping units, and their area.
 
*Description: intersection of grid, administrative regions and soil mapping units, and their area.
 
*Use: input/reference table for the crop simulation process
 
*Use: input/reference table for the crop simulation process
Line 1,375: Line 1,375:
 
<br>
 
<br>
  
==LINK_EMU_REGION_LANDCOVER==
+
===LINK_EMU_REGION_LANDCOVER===
 
*Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
 
*Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
 
*Use: input/reference table for the crop simulation process
 
*Use: input/reference table for the crop simulation process
Line 1,401: Line 1,401:
 
<br>
 
<br>
  
==LINK_REGION_GRID_LANDCOVER==
+
===LINK_REGION_GRID_LANDCOVER===
 
*Description: landcover areas for each intersection of grid and NUTS region (only level 3).
 
*Description: landcover areas for each intersection of grid and NUTS region (only level 3).
 
*Use: input for cmeteo
 
*Use: input for cmeteo
Line 1,425: Line 1,425:
 
<br>
 
<br>
  
==LINK_STATION_GRID==
+
===LINK_STATION_GRID===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 1,445: Line 1,445:
 
<br>
 
<br>
  
==LINK_STATION_REGION==
+
===LINK_STATION_REGION===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 1,467: Line 1,467:
 
<br>
 
<br>
  
==LTA_CROP_YIELDS==
+
===LTA_CROP_YIELDS===
 
*Description:  
 
*Description:  
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
Line 1,526: Line 1,526:
 
<br>
 
<br>
  
==LTA_GRID_YIELDS==
+
===LTA_GRID_YIELDS===
 
*Description:  
 
*Description:  
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
Line 1,711: Line 1,711:
 
<br>
 
<br>
  
==LTA_NUTS_YIELDS==
+
===LTA_NUTS_YIELDS===
 
*Description:  
 
*Description:  
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
Line 1,896: Line 1,896:
 
<br>
 
<br>
  
==LTA_YIELD_REGIONS==
+
===LTA_YIELD_REGIONS===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: table for [[LTA_YIELD]] package
 
*Use: table for [[LTA_YIELD]] package
Line 1,917: Line 1,917:
 
<br>
 
<br>
  
==LTA_YIELD==
+
===LTA_YIELD===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: link to [[LTA_YIELD]] package
 
*Use: link to [[LTA_YIELD]] package
Line 1,924: Line 1,924:
 
<br>
 
<br>
  
==MODEL_EXCL_YEARS==
+
===MODEL_EXCL_YEARS===
 
*Description: By default the years for which no statistical observations are available. But also outliers could be excluded.  
 
*Description: By default the years for which no statistical observations are available. But also outliers could be excluded.  
 
*Use: Output of level 3.
 
*Use: Output of level 3.
Line 1,944: Line 1,944:
 
<br>
 
<br>
  
==MODEL_INCL_INDICATORS==
+
===MODEL_INCL_INDICATORS===
 
*Description: Indicators that are included in the regression model.
 
*Description: Indicators that are included in the regression model.
 
*Use: Output of level 3.
 
*Use: Output of level 3.
Line 1,972: Line 1,972:
 
<br>
 
<br>
  
==MODEL_REGR_INDICATIFS==
+
===MODEL_REGR_INDICATIFS===
 
*Description: The table stores the models:  
 
*Description: The table stores the models:  
 
*Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
 
*Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
Line 2,024: Line 2,024:
 
<br>
 
<br>
  
==MODEL_SCEN_INDICATIFS==
+
===MODEL_SCEN_INDICATIFS===
 
*Description:
 
*Description:
 
*Use:  
 
*Use:  
Line 2,072: Line 2,072:
 
<br>
 
<br>
  
==MODEL_SCEN_SIM_YEARS==
+
===MODEL_SCEN_SIM_YEARS===
 
*Description:
 
*Description:
 
*Use:  
 
*Use:  
Line 2,094: Line 2,094:
 
<br>
 
<br>
  
==MODEL_SETTINGS==
+
===MODEL_SETTINGS===
 
*Description:
 
*Description:
 
*Use:  
 
*Use:  
Line 2,118: Line 2,118:
 
<br>
 
<br>
  
==MONTHDAYTODECADE==
+
===MONTHDAYTODECADE===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
 
*Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
Line 2,128: Line 2,128:
 
<br>
 
<br>
  
==NUTS_YIELD==
+
===NUTS_YIELD===
 
*Description:  
 
*Description:  
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
Line 2,186: Line 2,186:
 
|}
 
|}
  
==PARAMETER_DESCRIPTION==
+
===PARAMETER_DESCRIPTION===
 
*Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
 
*Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
 
*Use: used during system initialisation to correctly interpret the parameter tables
 
*Use: used during system initialisation to correctly interpret the parameter tables
Line 2,208: Line 2,208:
 
<br>
 
<br>
  
==RAIN_OBS_STATION==
+
===RAIN_OBS_STATION===
 
*Description: contains the station based 6-hourly rainfall data
 
*Description: contains the station based 6-hourly rainfall data
 
*Use: input level 1
 
*Use: input level 1
Line 2,232: Line 2,232:
 
<br>
 
<br>
  
==RAIN_OBS_STATION_INFO==
+
===RAIN_OBS_STATION_INFO===
 
*Description: table for storing specific metadata for 6-hourly rainfall data (flags)
 
*Description: table for storing specific metadata for 6-hourly rainfall data (flags)
 
*Use: meta data
 
*Use: meta data
Line 2,264: Line 2,264:
 
<br>
 
<br>
  
==RAIN_OBS_STATION_RAW==
+
===RAIN_OBS_STATION_RAW===
 
*Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
 
*Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
 
*Use: input level 1
 
*Use: input level 1
Line 2,288: Line 2,288:
 
<br>
 
<br>
  
==REGION==
+
===REGION===
 
*Description: Administrative regions
 
*Description: Administrative regions
 
*Use: input for monitoring extreme weather events
 
*Use: input for monitoring extreme weather events
Line 2,322: Line 2,322:
 
<br>
 
<br>
  
==REGION_MAPPINGS==
+
===REGION_MAPPINGS===
 
*Description: regions and their relations (mappings)
 
*Description: regions and their relations (mappings)
 
*Use: used by many object to find relation between regions of different levels.
 
*Use: used by many object to find relation between regions of different levels.
Line 2,369: Line 2,369:
 
<br>
 
<br>
  
==REGLISTS==
+
===REGLISTS===
 
*Description: synonym to oracle package
 
*Description: synonym to oracle package
 
*Use: link to [[REGLISTS]]
 
*Use: link to [[REGLISTS]]
Line 2,376: Line 2,376:
 
<br>
 
<br>
  
==ROOTING_DEPTH==  
+
===ROOTING_DEPTH===  
 
*Description: the rooting depth classes and associated rooting depth limits
 
*Description: the rooting depth classes and associated rooting depth limits
 
*Use: reference table used in crop simulation
 
*Use: reference table used in crop simulation
Line 2,396: Line 2,396:
 
<br>
 
<br>
  
==RUN==  
+
===RUN===  
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 2,426: Line 2,426:
 
<br>
 
<br>
  
==SIMULATION_LOG==
+
===SIMULATION_LOG===
 
*Description: contains information about simulation
 
*Description: contains information about simulation
 
*Use: reference table
 
*Use: reference table
Line 2,480: Line 2,480:
 
<br>
 
<br>
  
==SIMULATION_UNIT==
+
===SIMULATION_UNIT===
 
*Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
 
*Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
 
*Use: lookup table used during crop simulation
 
*Use: lookup table used during crop simulation
Line 2,502: Line 2,502:
 
<br>
 
<br>
  
==SIMYIELD_<MODEL>_EMU==
+
===SIMYIELD_<MODEL>_EMU===
 
*Description: results of the crop simulation per emu. Level 2 output based on forecast weather
 
*Description: results of the crop simulation per emu. Level 2 output based on forecast weather
 
*Use: output table for the crop simulation process
 
*Use: output table for the crop simulation process
Line 2,561: Line 2,561:
 
<br>
 
<br>
  
==SIMYIELD_EMU==
+
===SIMYIELD_EMU===
 
*Description: results of the crop simulation per emu. Level 2 output based on weather observations
 
*Description: results of the crop simulation per emu. Level 2 output based on weather observations
 
*Use: output table for the crop simulation process
 
*Use: output table for the crop simulation process
Line 2,617: Line 2,617:
 
<br>
 
<br>
  
==SIMYIELD_EMU_LTA==
+
===SIMYIELD_EMU_LTA===
 
*Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
 
*Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 2,673: Line 2,673:
 
<br>
 
<br>
  
==SIMYIELD_<MODEL>_GRID==
+
===SIMYIELD_<MODEL>_GRID===
 
*Description: results of the crop simulation per grid. Level 2 output, based on forecast weather.
 
*Description: results of the crop simulation per grid. Level 2 output, based on forecast weather.
 
*Use: output table for the crop simulation process
 
*Use: output table for the crop simulation process
Line 2,730: Line 2,730:
 
<br>
 
<br>
  
==SIMYIELD_GRID==
+
===SIMYIELD_GRID===
 
*Description: results of the crop simulation per grid. Level 2 output, based observed weather.
 
*Description: results of the crop simulation per grid. Level 2 output, based observed weather.
 
*Use: output table for the crop simulation process
 
*Use: output table for the crop simulation process
Line 2,784: Line 2,784:
 
<br>
 
<br>
  
==SIMYIELD_GRID_LTA==
+
===SIMYIELD_GRID_LTA===
 
*Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
 
*Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 2,966: Line 2,966:
 
<br>
 
<br>
  
==SIMYIELD_HIS_EMU_LTA==
+
===SIMYIELD_HIS_EMU_LTA===
 
*Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
 
*Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 3,022: Line 3,022:
 
<br>
 
<br>
  
==SIMYIELD_HIS_GRID_LTA==
+
===SIMYIELD_HIS_GRID_LTA===
 
*Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
 
*Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 3,204: Line 3,204:
 
<br>
 
<br>
  
==SIMYIELD_HIS_REGION_LTA==
+
===SIMYIELD_HIS_REGION_LTA===
 
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
 
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 3,386: Line 3,386:
 
<br>
 
<br>
  
==SIMYIELD_REGION==
+
===SIMYIELD_REGION===
 
*Description: results of the crop simulation per administrative region. Level 2 output
 
*Description: results of the crop simulation per administrative region. Level 2 output
 
*Use: output table for the crop simulation process
 
*Use: output table for the crop simulation process
Line 3,440: Line 3,440:
 
<br>
 
<br>
  
==SIMYIELD_REGION_LTA==
+
===SIMYIELD_REGION_LTA===
 
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
 
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
 
*Use:  Output table for the crop simulation process.
 
*Use:  Output table for the crop simulation process.
Line 3,622: Line 3,622:
 
<br>
 
<br>
  
==SITE==
+
===SITE===
 
*Description: Contains some soil model parameters on a system wide basis
 
*Description: Contains some soil model parameters on a system wide basis
 
*Use: input table for the crop simulation process
 
*Use: input table for the crop simulation process
Line 3,643: Line 3,643:
 
|}
 
|}
  
==SMU_SUITABILITY==
+
===SMU_SUITABILITY===
 
*Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
 
*Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
 
*Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
 
*Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
Line 3,665: Line 3,665:
 
<br>
 
<br>
  
==SOIL_ASSOCIATION_COMPOSITION==
+
===SOIL_ASSOCIATION_COMPOSITION===
 
*Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
 
*Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
 
*Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
 
*Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
Line 3,687: Line 3,687:
 
<br>
 
<br>
  
==SOIL_MAPPING_UNIT==  
+
===SOIL_MAPPING_UNIT===  
 
*Description: listing of unique soil mapping units and related countries
 
*Description: listing of unique soil mapping units and related countries
 
*Use: used by the crop growth model
 
*Use: used by the crop growth model
Line 3,708: Line 3,708:
 
<br>
 
<br>
  
==SOIL_PHYSICAL_GROUP==
+
===SOIL_PHYSICAL_GROUP===
 
*Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
 
*Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
 
*Use: used by the crop growth model
 
*Use: used by the crop growth model
Line 3,732: Line 3,732:
 
<br>
 
<br>
  
==SOIL_TYPOLOGIC_UNIT==  
+
===SOIL_TYPOLOGIC_UNIT===  
 
*Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
 
*Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
 
*Use: used by the crop growth model
 
*Use: used by the crop growth model
Line 3,778: Line 3,778:
 
<br>
 
<br>
  
==STAT_CROP==
+
===STAT_CROP===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 3,806: Line 3,806:
 
<br>
 
<br>
  
==STAT_REGION==
+
===STAT_REGION===
 
*Description: official observed cultivated area and yield  
 
*Description: official observed cultivated area and yield  
 
*Use: to derive regression models in [[Yield Forecasting]] module
 
*Use: to derive regression models in [[Yield Forecasting]] module
Line 3,834: Line 3,834:
 
<br>
 
<br>
  
==STATION==
+
===STATION===
 
*Description: the weather stations and weather station characteristics to be used by the system
 
*Description: the weather stations and weather station characteristics to be used by the system
 
*Use: used by all of the level 1 steps (additional weather, availability, grid weather)
 
*Use: used by all of the level 1 steps (additional weather, availability, grid weather)
Line 3,904: Line 3,904:
 
<br>
 
<br>
  
==STATIONS_PER_GRID==
+
===STATIONS_PER_GRID===
 
*Description: the stations used for the grid weather interpolation of the historic year.
 
*Description: the stations used for the grid weather interpolation of the historic year.
 
*Use: output table for the level 1 grid weather calculation
 
*Use: output table for the level 1 grid weather calculation
Line 3,956: Line 3,956:
 
<br>
 
<br>
  
==STATION_REFERENCE_COEFFICIENTS==
+
===STATION_REFERENCE_COEFFICIENTS===
 
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe
 
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe
 
*Use: is used by view SUPIT_REFERENCE_STATIONS
 
*Use: is used by view SUPIT_REFERENCE_STATIONS
Line 3,992: Line 3,992:
 
<br>
 
<br>
  
==STU_LAYER==
+
===STU_LAYER===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 4,016: Line 4,016:
 
<br>
 
<br>
  
==SUITABILITY==
+
===SUITABILITY===
 
*Description: the suitable STUs for each crop _ group
 
*Description: the suitable STUs for each crop _ group
 
*Use: used to derive the simulation_unit table
 
*Use: used to derive the simulation_unit table
Line 4,036: Line 4,036:
 
<br>
 
<br>
  
==SUPIT_CONSTANTS==
+
===SUPIT_CONSTANTS===
 
*Description: the regression constants per weather station used for the estimation of global radiation for the station
 
*Description: the regression constants per weather station used for the estimation of global radiation for the station
 
*Use: support table program SupitConstant; results are copied to table STATION
 
*Use: support table program SupitConstant; results are copied to table STATION
Line 4,067: Line 4,067:
 
|}
 
|}
  
==SUPIT_REFERENCE_STATIONS ==
+
===SUPIT_REFERENCE_STATIONS ===
 
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
 
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
 
*Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
 
*Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
Line 4,105: Line 4,105:
 
<br>
 
<br>
  
==SYE==
+
===SYE===
 
*Description: table for storing temporary results during [[Crop_Simulation]]. When the calculation is finshed, all records are inserted into {{Object|SIMYIELD_EMU}} overwriting old results.
 
*Description: table for storing temporary results during [[Crop_Simulation]]. When the calculation is finshed, all records are inserted into {{Object|SIMYIELD_EMU}} overwriting old results.
 
*Use: temporary output table for the calculation of crop indicators.
 
*Use: temporary output table for the calculation of crop indicators.
Line 4,161: Line 4,161:
 
<br>
 
<br>
  
==SYSCON==
+
===SYSCON===
 
*Description: contains system parameters
 
*Description: contains system parameters
 
*Use: upon system initialisation
 
*Use: upon system initialisation
Line 4,180: Line 4,180:
 
|}
 
|}
  
==SYSTABLES==
+
===SYSTABLES===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 4,200: Line 4,200:
 
<br>
 
<br>
  
==TASKS==
+
===TASKS===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 4,234: Line 4,234:
 
<br>
 
<br>
  
==VARIETY_PARAMETER_VALUE==
+
===VARIETY_PARAMETER_VALUE===
 
*Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
 
*Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
 
*Use: input table for the crop simulation process
 
*Use: input table for the crop simulation process
Line 4,261: Line 4,261:
 
<br>
 
<br>
  
==VIEWER_REQUESTS==
+
===VIEWER_REQUESTS===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 4,292: Line 4,292:
  
  
==WEATHER_HIS_GRID_LTA==
+
===WEATHER_HIS_GRID_LTA===
 
*Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
 
*Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
 
*Use: Monitoring extreme weather events.
 
*Use: Monitoring extreme weather events.
Line 4,380: Line 4,380:
 
<br>
 
<br>
  
==WEATHER_HIS_REGION_LTA==
+
===WEATHER_HIS_REGION_LTA===
 
*Description: long term average forecasted weather per day and administrative region.
 
*Description: long term average forecasted weather per day and administrative region.
 
*Use: Monitoring extreme weather events.
 
*Use: Monitoring extreme weather events.
Line 4,472: Line 4,472:
 
<br>
 
<br>
  
==WEATHER_HIS_AEZ_LTA==
+
===WEATHER_HIS_AEZ_LTA===
 
*Description: long term average forecasted weather per day and agri-environmental region.
 
*Description: long term average forecasted weather per day and agri-environmental region.
 
*Use: Monitoring extreme weather events.
 
*Use: Monitoring extreme weather events.
Line 4,565: Line 4,565:
  
  
==WEATHER_<MODEL>_AEZ==
+
===WEATHER_<MODEL>_AEZ===
 
*Description: forecasted weather per day and agro-environmental region.
 
*Description: forecasted weather per day and agro-environmental region.
 
*Use: Monitoring extreme weather events.
 
*Use: Monitoring extreme weather events.
Line 4,664: Line 4,664:
  
  
==WEATHER_<MODEL>_GRID==
+
===WEATHER_<MODEL>_GRID===
 
*Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
 
*Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
 
*Use: input for crop simulation.
 
*Use: input for crop simulation.
Line 4,717: Line 4,717:
  
  
==WEATHER_<MODEL>_GRID_RAW==
+
===WEATHER_<MODEL>_GRID_RAW===
 
*Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
 
*Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
 
*Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
 
*Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
Line 4,762: Line 4,762:
  
  
==WEATHER_<MODEL>_REGION==
+
===WEATHER_<MODEL>_REGION===
 
*Description: forecasted weather per day and administrative region.
 
*Description: forecasted weather per day and administrative region.
 
*Use: Monitoring extreme weather events.
 
*Use: Monitoring extreme weather events.
Line 4,861: Line 4,861:
  
  
==WEATHER_OBS_AEZ==
+
===WEATHER_OBS_AEZ===
 
*Description: interpolated weather data per grid per agro-environmental egion
 
*Description: interpolated weather data per grid per agro-environmental egion
 
*Use: input for monitoring extreme weather events
 
*Use: input for monitoring extreme weather events
Line 4,948: Line 4,948:
 
<br>
 
<br>
  
==WEATHER_OBS_AEZ_LTA==
+
===WEATHER_OBS_AEZ_LTA===
 
*Description: long term average interpolated weather data per agri-environmental region per day
 
*Description: long term average interpolated weather data per agri-environmental region per day
 
*Use: Monitoring extreme weather events
 
*Use: Monitoring extreme weather events
Line 5,123: Line 5,123:
 
<br>
 
<br>
  
==WEATHER_OBS_GRID==
+
===WEATHER_OBS_GRID===
 
*Description: interpolated weather data per grid per day
 
*Description: interpolated weather data per grid per day
 
*Use: output for level 1, input for level 2
 
*Use: output for level 1, input for level 2
Line 5,174: Line 5,174:
 
<br>
 
<br>
  
==WEATHER_OBS_GRID_INFO==
+
===WEATHER_OBS_GRID_INFO===
 
*Description:  
 
*Description:  
 
*Use:  
 
*Use:  
Line 5,203: Line 5,203:
 
<br>
 
<br>
  
==WEATHER_OBS_GRID_LTA==
+
===WEATHER_OBS_GRID_LTA===
 
*Description: long term average interpolated weather data per grid cell per day
 
*Description: long term average interpolated weather data per grid cell per day
 
*Use: Monitoring extreme weather events
 
*Use: Monitoring extreme weather events
Line 5,375: Line 5,375:
 
<br>
 
<br>
  
==WEATHER_OBS_GRID_LTA_MISS==
+
===WEATHER_OBS_GRID_LTA_MISS===
 
*Description: long term average number of grid cells per country.
 
*Description: long term average number of grid cells per country.
 
*Use: input for check on {{Object|WEATHER_OBS_GRID}} table (see section [[Interpolation of observed weather#Check_on_missing_grid_weather|Check on missing grid weather]]).
 
*Use: input for check on {{Object|WEATHER_OBS_GRID}} table (see section [[Interpolation of observed weather#Check_on_missing_grid_weather|Check on missing grid weather]]).
Line 5,406: Line 5,406:
 
<br>
 
<br>
  
==WEATHER_OBS_REGION==
+
===WEATHER_OBS_REGION===
 
*Description: interpolated weather data per grid per administrative region
 
*Description: interpolated weather data per grid per administrative region
 
*Use: input for monitoring extreme weather events
 
*Use: input for monitoring extreme weather events
Line 5,493: Line 5,493:
 
<br>
 
<br>
  
==WEATHER_OBS_REGION_LTA==
+
===WEATHER_OBS_REGION_LTA===
 
*Description: long term average interpolated weather data per administrative region per day
 
*Description: long term average interpolated weather data per administrative region per day
 
*Use: Monitoring extreme weather events
 
*Use: Monitoring extreme weather events
Line 5,668: Line 5,668:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION==
+
===WEATHER_OBS_STATION===
 
*Description: contains the station based daily meteorological data
 
*Description: contains the station based daily meteorological data
 
*Use: input for level 1
 
*Use: input for level 1
Line 5,752: Line 5,752:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_AVAIL==
+
===WEATHER_OBS_STATION_AVAIL===
 
*Description: available weather stations for interpolation per station and per year.
 
*Description: available weather stations for interpolation per station and per year.
 
*Use: output of the weather data availability calculation, used by the grid weather interpolation
 
*Use: output of the weather data availability calculation, used by the grid weather interpolation
Line 5,774: Line 5,774:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_CALCULATED==
+
===WEATHER_OBS_STATION_CALCULATED===
 
*Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
 
*Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
 
*Use: output table for additional weather calculation, input for grid weather
 
*Use: output table for additional weather calculation, input for grid weather
Line 5,802: Line 5,802:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_ERRAIN==
+
===WEATHER_OBS_STATION_ERRAIN===
 
*Description: contains deleted wrongly rain records of the station based daily meteorological data
 
*Description: contains deleted wrongly rain records of the station based daily meteorological data
 
*Use: archive reasons
 
*Use: archive reasons
Line 5,826: Line 5,826:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_ERRORS==
+
===WEATHER_OBS_STATION_ERRORS===
 
*Description: contains deleted wrongly weather records of the station based daily meteorological data
 
*Description: contains deleted wrongly weather records of the station based daily meteorological data
 
*Use: archive reasons
 
*Use: archive reasons
Line 5,906: Line 5,906:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_INFO==
+
===WEATHER_OBS_STATION_INFO===
 
*Description: table for storing specific metadata on daily weather data (flags)
 
*Description: table for storing specific metadata on daily weather data (flags)
 
*Use: meta data
 
*Use: meta data
Line 5,993: Line 5,993:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_LTA==  
+
===WEATHER_OBS_STATION_LTA===  
 
*Description: contains the long term average weather data per station per day
 
*Description: contains the long term average weather data per station per day
 
*Use: substitute data in case of missing data during level 1 processing
 
*Use: substitute data in case of missing data during level 1 processing
Line 6,033: Line 6,033:
 
<br>
 
<br>
  
==WEATHER_OBS_STATION_RAW==  
+
===WEATHER_OBS_STATION_RAW===  
 
*Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)  
 
*Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)  
 
*Use: input level 1
 
*Use: input level 1
Line 6,175: Line 6,175:
 
<br>
 
<br>
  
==WEATHER_STATION==
+
===WEATHER_STATION===
 
*Description:  
 
*Description:  
 
*Use: interface between the CGMS12EU database and the [[SupitConstants]] software
 
*Use: interface between the CGMS12EU database and the [[SupitConstants]] software
Line 6,215: Line 6,215:
 
<br>
 
<br>
  
==WOG==
+
===WOG===
 
*Description: table for storing temporary results during interpolation of grid weather as part of the  [[Weather Monitoring ]] module. When the calculation is finshed, all records are inserted into {{Object|WEATHER_OBS_GRID}}.
 
*Description: table for storing temporary results during interpolation of grid weather as part of the  [[Weather Monitoring ]] module. When the calculation is finshed, all records are inserted into {{Object|WEATHER_OBS_GRID}}.
 
*Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
 
*Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
Line 6,255: Line 6,255:
 
<br>
 
<br>
  
==WOGC==
+
===WOGC===
 
*Description: table for storing temporary results during [[Meteorological_data_from_ ground_stations#Calculation_of_advanced_parameters|calculation of advanced parameters]]. When the calculation is finshed, all records are inserted into {{Object|WEATHER_OBS_STATION_CALCULATED}}, overwriting old results.  
 
*Description: table for storing temporary results during [[Meteorological_data_from_ ground_stations#Calculation_of_advanced_parameters|calculation of advanced parameters]]. When the calculation is finshed, all records are inserted into {{Object|WEATHER_OBS_STATION_CALCULATED}}, overwriting old results.  
 
*Use: temporary output table for the calculation of advanced parameters.
 
*Use: temporary output table for the calculation of advanced parameters.
Line 6,283: Line 6,283:
 
<br>
 
<br>
  
==DAY_DECADE==
+
===DAY_DECADE===
 
*Description: link between and decade, for mapping purposes
 
*Description: link between and decade, for mapping purposes
 
*Use: sytem table used in level 2
 
*Use: sytem table used in level 2
Line 6,317: Line 6,317:
 
<br>
 
<br>
  
==STATIONS_PER_GRID_CURRENTYEAR==
+
===STATIONS_PER_GRID_CURRENTYEAR===
 
*Description: the stations used for the grid weather interpolation of the current year.
 
*Description: the stations used for the grid weather interpolation of the current year.
 
*Use: output table for the level 1 grid weather calculation
 
*Use: output table for the level 1 grid weather calculation

Revision as of 13:52, 7 March 2016



AEZ


AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: used for weighting during aggregating crop indicators towards regional crop indicators
  • Type: Permanent table
  • Remarks: none


CGMS_SYSLOG

  • Description: logging of run options.
  • Use: output table containing information on the run executed
  • Type: Permanent table
  • Remarks: none


CMETEO_ADMIN

  • Description: synonym to oracle package
  • Use:
  • Type: synonym on mrsman.cmeteo_admin
  • Remarks: none


CMETEO_AEZ_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: view on LINK_ AEZ_GRID_LANDCOVER
  • Remarks: user defined, derived from GIS


CMETEO_AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: input for cmeteo, converting names of columns for use in cmeteo package
  • Type: view on tables AGGREGATION_AREAS and REGION
  • Remarks: none


CMETEO_CROPS

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: synonym on table mrsman.cmeteo_crops
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CMETEO_GRID_LANDCOVER_AREAS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: synonym on view CMETEO_AEZ_GRID_LANDCOVERS
  • Remarks: none


CMETEO_GRID_WEATHER

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on view CMETEO_WEATHER_OBS_GRID


CMETEO_LANDCOVERS

  • List of landcovers or crops to be evaluated in CMETEO
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / CROP_LANDCOVER


CMETEO_PROCESS

  • Description: synonym to oracle package
  • Use:
  • Type: synonym on mrsman.cmeteo_process
  • Remarks: none


CMETEO_REGION_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and administartive region (only level 3).
  • Use: input for cmeteo with standardized attribute names
  • Type: view on LINK_REGION_GRID_LANDCOVER
  • Remarks: user defined, derived from GIS


CMETEO_REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: input for cmeteo
  • Type: synonym on table REGION_MAPPINGS
  • Remark: none


CMETEO_REGION_WEATHER

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on view CMETEO_WEATHER_OBS_AEZ
  • Remark: none


CMETEO_REGIONS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on mrsman.cmeteo_regions
  • Remark: none


CMETEO_REJECTED_WEATHER

  • Description: rejected weather
  • Use: log table for cmeteo
  • Type: synonym on mrsman.cmeteo_rejected_weather
  • Remark: none


CMETEO_WEATHER_OBS_AEZ

  • Description: weather indicators per agri-environmental region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on WEATHER_OBS_AEZ


CMETEO_WEATHER_OBS_GRID

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on table WEATHER_OBS_GRID


CMETEO_WEATHER_OBS_REGION

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on WEATHER_OBS_REGION


CROP

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: view on from forall.crop_landcover (subset of FORALL.CROP_LANDCOVER table).
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CROP_CALENDAR

  • Description: where and when crops are grown. crop, crop variety and growing season per grid.
  • Use: determines which crops are simulated for a grid, and simulation period
  • Type: Permanent table
  • Remarks: user defined, one of the ‘driving’ tables of the system


CROP_GROUP

  • Description: description of crop groups
  • Use: input table for the crop group number and name where crop belongs to
  • Type: synonym on permanent table FORALL.CROP_GROUP
  • Remarks: none


CROP_LANDCOVER

  • List of crop and landcovers
  • Use: source for various views & synonyms
  • Type: synonym & table


CROP_PARAMETER_VALUE

  • Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: Permanent table
  • Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


CROP_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_EMU
  • Remarks:


DATA_FOR_YIELD_FORECAST

  • Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).
  • Use: table for storing the indicators values that can be used for regression and scenario-analysis (see Yield Forecasting).
  • Type: Permanent table.
  • Remarks: The table is filled and regularly updated with indicator values from table SIMYIELD_REGION. The table contains the same data as stored in SIMYIELD_REGION, but in a different structure. This way also new indicators can be added without having to change the structure.


DATE_GENERATOR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.date_generator
  • Remarks: none


DATES_75_15

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.dates_75_15
  • Remarks: none


DAY_DECADEYEAR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on FORALL.DAY_DECADEYEAR
  • Remarks: none



GRID_<MODEL>

  • Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
  • Use: input for downscaling.
  • Type: Permanent table
  • Remarks: Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name. The calculation resolution of ECMWF models changes over time and/or forecast depth. In that case different derived elevation models are used stored in separate altitude Attributes with a reference to the ECMWF calculation resolution.



EMU

  • Description: the intersection of the soil map and the grid
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS


FOREYIELD_HIS_REGION

  • Description: End of season forecast
  • Use: to store forecast results from the CST operational batch mode.
  • Type: Permanent table
  • Remarks: Not used by the user interface and regular batch mode of the CST that stores the forecast in table FORECASTED_NUTS_YIELD.


GRID

  • Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
  • Use: input/reference table for both level 1 and level 2
  • Type: permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS



GRID_SEA_DOWN_ALGORITHMS

  • Description: grid specific downscaling equations per OPE grid cell.
  • Use: Downscaling SEA model data.
  • Type: Permanent table
  • Remarks: A similar table exists for the ERA model data. That table is called CGMS_GRID_METH_C.



GRID_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_GRID
  • Remarks:


INITIAL_SOIL_WATER

  • Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
  • Use: input for level 2
  • Type: Permanent table
  • Remarks: user defined


JSOW

  • Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
  • Use: Input table for calculating one of the Crop Simulation indicators.
  • Type: Permanent table, provided by JRC.
  • Remark: Even if the table CROP_CALENDAR specifies fixed sowing per crop per year, the JSOW table is used to calculate 'rainfall around sowing'.


LINK_AEZ_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo
  • Type: Permanent table
  • Remarks: user defined, derived from GIS


LINK_EMU_REGION

  • Description: intersection of grid, administrative regions and soil mapping units, and their area.
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks:


LINK_EMU_REGION_LANDCOVER

  • Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
  • Use: input/reference table for the crop simulation process
  • Type: Permanent table
  • Remarks:


LINK_REGION_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and NUTS region (only level 3).
  • Use: input for cmeteo
  • Type: Permanent table
  • Remarks: user defined, derived from GIS


LINK_STATION_GRID

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


LINK_STATION_REGION

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


LTA_CROP_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_EMU_LTA
  • Remarks:


LTA_GRID_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_GRID_LTA
  • Remarks:


LTA_NUTS_YIELDS


LTA_YIELD_REGIONS

  • Description: synonym to oracle package
  • Use: table for LTA_YIELD package
  • Type: synonym on mrsman.lta_yield_regions
  • Remarks: none


LTA_YIELD

  • Description: synonym to oracle package
  • Use: link to LTA_YIELD package
  • Type: synonym on mrsman.lta_yield
  • Remarks: none


MODEL_EXCL_YEARS

  • Description: By default the years for which no statistical observations are available. But also outliers could be excluded.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the excluded years need to be known.


MODEL_INCL_INDICATORS

  • Description: Indicators that are included in the regression model.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the included indicators need to be known.


MODEL_REGR_INDICATIFS

  • Description: The table stores the models:
  • Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
  • Type: permanent table.
  • Remarks:


MODEL_SCEN_INDICATIFS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MODEL_SCEN_SIM_YEARS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MODEL_SETTINGS

  • Description:
  • Use:
  • Type: permanent table.
  • Remarks:


MONTHDAYTODECADE

  • Description: synonym to oracle package
  • Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
  • Type: synonym on forall.monthday2decade
  • Remarks:
Both month and day must be numeric: month {1..12}, day {1..31}.
No check is performed on valid COMBINATIONS of month and day
If one or both parameters seem invalid then a null-value will be returned


NUTS_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_REGION
  • Remarks:

PARAMETER_DESCRIPTION

  • Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
  • Use: used during system initialisation to correctly interpret the parameter tables
  • Type: permanent table
  • Remarks: do not change this table


RAIN_OBS_STATION

  • Description: contains the station based 6-hourly rainfall data
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


RAIN_OBS_STATION_INFO

  • Description: table for storing specific metadata for 6-hourly rainfall data (flags)
  • Use: meta data
  • Type: permanent table
  • Remarks: none


RAIN_OBS_STATION_RAW

  • Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


REGION

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Synonym on view FORALL.REGIONS_EUR12EU which references the FORALL tables REGION_DESCRIPTIONS and REGION_MAPPINGS


REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: synonyms on forall.region_mappings_eur
  • Remarks: none


REGLISTS

  • Description: synonym to oracle package
  • Use: link to REGLISTS
  • Type: synonym on forall.reglists
  • Remarks: none


ROOTING_DEPTH

  • Description: the rooting depth classes and associated rooting depth limits
  • Use: reference table used in crop simulation
  • Type: permanent table
  • Remarks: part of the soil model, can be changed or extended if necessary


RUN

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


SIMULATION_LOG

  • Description: contains information about simulation
  • Use: reference table
  • Type: permanent table
  • Remarks: none


SIMULATION_UNIT

  • Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
  • Use: lookup table used during crop simulation
  • Type: permanent table
  • Remarks: the content of this table is based on the intersection of soil map and climatic grid, excluding intersections (STU's) that are unsuitable for crop growth.


SIMYIELD_<MODEL>_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on forecast weather
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on weather observations
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_<MODEL>_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based on forecast weather.
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based observed weather.
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_REGION

  • Description: results of the crop simulation per administrative region. Level 2 output
  • Use: output table for the crop simulation process
  • Type: Permanent table
  • Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.


SIMYIELD_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SITE

  • Description: Contains some soil model parameters on a system wide basis
  • Use: input table for the crop simulation process
  • Type: permanent table
  • Remarks: supplied by the user, but rarely changed

SMU_SUITABILITY

  • Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
  • Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
  • Type: permanent table
  • Remarks: this table needs to be recalculated whenever the simulation_unit table changes


SOIL_ASSOCIATION_COMPOSITION

  • Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
  • Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
  • Type: permanent table
  • Remarks: derived from the soil map


SOIL_MAPPING_UNIT

  • Description: listing of unique soil mapping units and related countries
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map

* not filled/used

SOIL_PHYSICAL_GROUP

  • Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map


SOIL_TYPOLOGIC_UNIT

  • Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
  • Use: used by the crop growth model
  • Type: permanent table
  • Remarks: user defined, derived from the soil map


STAT_CROP

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


STAT_REGION

  • Description: official observed cultivated area and yield
  • Use: to derive regression models in Yield Forecasting module
  • Type: Permanent table
  • Remarks: none


STATION

  • Description: the weather stations and weather station characteristics to be used by the system
  • Use: used by all of the level 1 steps (additional weather, availability, grid weather)
  • Type: permanent table
  • Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated


STATIONS_PER_GRID

  • Description: the stations used for the grid weather interpolation of the historic year.
  • Use: output table for the level 1 grid weather calculation
  • Type: permanent table
  • Remarks: contains both information produced by historical interpolation and current year interpolation.


STATION_REFERENCE_COEFFICIENTS

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe
  • Use: is used by view SUPIT_REFERENCE_STATIONS
  • Type: permanent table
  • Remarks: none


STU_LAYER

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:


SUITABILITY

  • Description: the suitable STUs for each crop _ group
  • Use: used to derive the simulation_unit table
  • Type: Permanent table
  • Remarks: user defined, derived from the soil map


SUPIT_CONSTANTS

  • Description: the regression constants per weather station used for the estimation of global radiation for the station
  • Use: support table program SupitConstant; results are copied to table STATION
  • Type: permanent table
  • Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)

SUPIT_REFERENCE_STATIONS

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
  • Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
  • Type: view on table station_reference_coefficients
  • Remarks: not normally changed by the user but supplied by the JRC


SYE

  • Description: table for storing temporary results during Crop_Simulation. When the calculation is finshed, all records are inserted into SIMYIELD_EMU overwriting old results.
  • Use: temporary output table for the calculation of crop indicators.
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


SYSCON

  • Description: contains system parameters
  • Use: upon system initialisation
  • Type: permanent table
  • Remarks: user defined

SYSTABLES

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


TASKS

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:


VARIETY_PARAMETER_VALUE

  • Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: permanent table
  • Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in CROP_PARAMETER_VALUE table). In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


VIEWER_REQUESTS

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:



WEATHER_HIS_GRID_LTA

  • Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_REGION_LTA

  • Description: long term average forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_AEZ_LTA

  • Description: long term average forecasted weather per day and agri-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).



WEATHER_<MODEL>_AEZ

  • Description: forecasted weather per day and agro-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. ERA, MON and SEA are not available for agro-environmental regions



WEATHER_<MODEL>_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.



WEATHER_<MODEL>_GRID_RAW

  • Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
  • Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.



WEATHER_<MODEL>_REGION

  • Description: forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. MON and SEA are not available for administrative regions



WEATHER_OBS_AEZ

  • Description: interpolated weather data per grid per agro-environmental egion
  • Use: input for monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_AEZ_LTA

  • Description: long term average interpolated weather data per agri-environmental region per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_GRID

  • Description: interpolated weather data per grid per day
  • Use: output for level 1, input for level 2
  • Type: Permanent table


WEATHER_OBS_GRID_INFO

  • Description:
  • Use:
  • Type: Permanent table


WEATHER_OBS_GRID_LTA

  • Description: long term average interpolated weather data per grid cell per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_GRID_LTA_MISS

  • Description: long term average number of grid cells per country.
  • Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
  • Type: permanent table
  • Remarks: filled with procedure lta_missing_grid_weather.sql


WEATHER_OBS_REGION

  • Description: interpolated weather data per grid per administrative region
  • Use: input for monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_REGION_LTA

  • Description: long term average interpolated weather data per administrative region per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table


WEATHER_OBS_STATION

  • Description: contains the station based daily meteorological data
  • Use: input for level 1
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_AVAIL

  • Description: available weather stations for interpolation per station and per year.
  • Use: output of the weather data availability calculation, used by the grid weather interpolation
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_CALCULATED

  • Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
  • Use: output table for additional weather calculation, input for grid weather
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_ERRAIN

  • Description: contains deleted wrongly rain records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_ERRORS

  • Description: contains deleted wrongly weather records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_INFO

  • Description: table for storing specific metadata on daily weather data (flags)
  • Use: meta data
  • Type: permanent table
  • Remarks: none


WEATHER_OBS_STATION_LTA

  • Description: contains the long term average weather data per station per day
  • Use: substitute data in case of missing data during level 1 processing
  • Type: permanent table
  • Remarks: filled by software tool ReferenceWeather


WEATHER_OBS_STATION_RAW

  • Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: permanent table
  • Remarks: none


WEATHER_STATION

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: view on table STATION
  • Remarks:


WOG

  • Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
  • Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


WOGC

  • Description: table for storing temporary results during calculation of advanced parameters. When the calculation is finshed, all records are inserted into WEATHER_OBS_STATION_CALCULATED, overwriting old results.
  • Use: temporary output table for the calculation of advanced parameters.
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the advanced parameters are calculated.


DAY_DECADE

  • Description: link between and decade, for mapping purposes
  • Use: sytem table used in level 2
  • Type: synonym on view FORALL.DAY_DECADE (based on DATE_GENERATOR)


STATIONS_PER_GRID_CURRENTYEAR

  • Description: the stations used for the grid weather interpolation of the current year.
  • Use: output table for the level 1 grid weather calculation
  • Type: permanent table
  • Remarks: will contain the information produced by current run for every day