Difference between revisions of "Appendix 5: Database objects/CGMS12old"
Wimdewinter (talk | contribs) m (Wimdewinter moved page Appendix 5: CGMS tables to Appendix 5: Database objects/CGMS12old: consisten url for automated processing) |
Wimdewinter (talk | contribs) (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
- Description: synonym to oracle package
- Use: use to references the tables REGION_DESCRIPTIONS and REGION_MAPPINGS
- Type: synonym on FORALL.REGIONS_ZONES_08
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* 'SOURCE' can have the following values:
|
CGMS_SYSLOG
- Description: logging of run options.
- Use: output table containing information on the run executed
- Type: Permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions ** Not in view, only in table |
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.
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions |
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
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions |
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REGION_MAPPINGS
- Description: regions and their relations (mappings)
- Use: input for cmeteo
- Type: synonym on table REGION_MAPPINGS
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REGIONS
- Description:
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: synonym on mrsman.cmeteo_regions
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REJECTED_WEATHER
- Description: rejected weather
- Use: log table for cmeteo
- Type: synonym on mrsman.cmeteo_rejected_weather
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* CROP_NO in (1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51)
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category). |
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
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_LANDCOVER
- List of crop and landcovers
- Use: source for various views & synonyms
- Type: synonym & table
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_YIELD
- Description:
- Use: used as interface between the CGMS12EU database and the viewers
- Type: view on table SIMYIELD_EMU
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DAY_DECADEYEAR
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: synonym on FORALL.DAY_DECADEYEAR
- Remarks: none
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Available in SEA. Derived from N128 gaussian grid |
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Forecasts that are based on ECMWF EPS, Montly and Seasonal weather data have multiple weather forecasts (ensembles) that result in just as many different yield forecasts. The different yield forecasts are stored under different member numbers. |
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
Structure | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not a simple average (see 'Similarity score' in paragraph Qualification of weather stations). |
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* No real equations do exist for rainfall therefore simple equation y = x is applied |
GRID_YIELD
- Description:
- Use: used as interface between the CGMS12EU database and the viewers
- Type: view on table SIMYIELD_GRID
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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'.
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LINK_STATION_GRID
- Description:
- Use:
- Type: Permanent table
- Remarks:
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LINK_STATION_REGION
- Description:
- Use:
- Type: Permanent table
- Remarks:
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LTA_CROP_YIELDS
- Description:
- Use: interface between the CGMS12EU database and the LTA_YIELD package
- Type: view on table SIMYIELD_EMU_LTA
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LTA_GRID_YIELDS
- Description:
- Use: interface between the CGMS12EU database and the LTA_YIELD package
- Type: view on table SIMYIELD_GRID_LTA
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LTA_NUTS_YIELDS
- Description:
- Use: interface between the CGMS12EU database and the LTA_YIELD package
- Type: view on table SIMYIELD_REGION_LTA
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LTA_YIELD_REGIONS
- Description: synonym to oracle package
- Use: table for LTA_YIELD package
- Type: synonym on mrsman.lta_yield_regions
- Remarks: none
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* In general one or more of the four level 2 indicators:
|
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:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MODEL_SCEN_INDICATIFS
- Description:
- Use:
- Type: permanent table.
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MODEL_SCEN_SIM_YEARS
- Description:
- Use:
- Type: permanent table.
- Remarks:
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MODEL_SETTINGS
- Description:
- Use:
- Type: permanent table.
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RAIN_OBS_STATION
- Description: contains the station based 6-hourly rainfall data
- Use: input level 1
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RAIN_OBS_STATION_INFO
- Description: table for storing specific metadata for 6-hourly rainfall data (flags)
- Use: meta data
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Possible values for precipitation (flags): |
RAIN_OBS_STATION_RAW
- Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
- Use: input level 1
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* According to the 'NUTS' nomenclature (see Administrative_regions). |
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS. |
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
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
RUN
- Description:
- Use:
- Type: permanent table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SIMULATION_LOG
- Description: contains information about simulation
- Use: reference table
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Possible status messeges:
|
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.
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not in SIMYIELD_HIS_EMU table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_EMU has the attribute although also the OPE model does not have members. |
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not in SIMYIELD_HIS_GRID table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_GRID has the attribute although also the OPE model does not have members. |
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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: -
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
* 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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
STAT_CROP
- Description:
- Use:
- Type: Permanent table
- Remarks:
Structure | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
STAT_REGION
- Description: official observed cultivated area and yield
- Use: to derive regression models in Yield Forecasting module
- Type: Permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
STU_LAYER
- Description:
- Use:
- Type: Permanent table
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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)
Structure | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SYSCON
- Description: contains system parameters
- Use: upon system initialisation
- Type: permanent table
- Remarks: user defined
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SYSTABLES
- Description:
- Use:
- Type: permanent table
- Remarks:
Structure | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
TASKS
- Description:
- Use:
- Type: permanent table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
(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:
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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).
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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).
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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).
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not available (relevant) in HIS products |
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not available (relevant) in HIS product |
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not available (relevant) in HIS product |
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not available (relevant) in HIS products |
WEATHER_OBS_AEZ
- Description: interpolated weather data per grid per agro-environmental egion
- Use: input for monitoring extreme weather events
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_GRID
- Description: interpolated weather data per grid per day
- Use: output for level 1, input for level 2
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_GRID_INFO
- Description:
- Use:
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_GRID_LTA
- Description: long term average interpolated weather data per grid cell per day
- Use: Monitoring extreme weather events
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* In script changed to 4,2. Not yet installed. |
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
Structure | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL. |
WEATHER_OBS_REGION
- Description: interpolated weather data per grid per administrative region
- Use: input for monitoring extreme weather events
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_REGION_LTA
- Description: long term average interpolated weather data per administrative region per day
- Use: Monitoring extreme weather events
- Type: Permanent table
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_STATION
- Description: contains the station based daily meteorological data
- Use: input for level 1
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 this variable returns directly radiation |
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
Structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_STATION_INFO
- Description: table for storing specific metadata on daily weather data (flags)
- Use: meta data
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
In case of precipitation:
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_OBS_STATION_RAW
- Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
- Use: input level 1
- Type: permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WEATHER_STATION
- Description:
- Use: interface between the CGMS12EU database and the SupitConstants software
- Type: view on table STATION
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.
Structure | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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)
Script and structure | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CREATE OR REPLACE VIEW "FORALL"."DAY_DECADE" ("DAY", "MONTH", "DECADE") AS select dayno_mon day ,month month ,decade decade from table(date_generator.dates(2000,null,null,null,null -- leapyear ,date_generator.ind_dayno_mon + date_generator.ind_month + date_generator.ind_decade ,date_generator.step_day ) );
|
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
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|