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

From Agri4castWiki
Jump to: navigation, search
(note added)
(generated page)
 
Line 17: Line 17:
 
{{TocRow|#synonyms|12. synonyms}}
 
{{TocRow|#synonyms|12. synonyms}}
 
}}
 
}}
 +
 +
  
  
Line 30: Line 32:
 
{{TocRow|#CMETEO_WEATHER_OBS_REGION|1.8 CMETEO_WEATHER_OBS_REGION}}
 
{{TocRow|#CMETEO_WEATHER_OBS_REGION|1.8 CMETEO_WEATHER_OBS_REGION}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_AEZ_GRID_LANDCOVERS ===
 
=== CMETEO_AEZ_GRID_LANDCOVERS ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on {{Object|LINK_ AEZ_GRID_LANDCOVER}}
+
* Remarks: user defined, derived from GIS
*Remarks: user defined, derived from GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 66: Line 69:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_AGGREGATION_AREAS ===
 
=== CMETEO_AGGREGATION_AREAS ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on tables {{Object|AGGREGATION_AREAS}} and {{Object|REGION}}
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 105: Line 109:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_CROPS ===
 
=== CMETEO_CROPS ===
''View''.
+
* 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
+
* Type: ''View''
*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.
*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.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 150: Line 155:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_LANDCOVERS ===
 
=== CMETEO_LANDCOVERS ===
''View''.
+
* Description:
*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
+
* Type: ''View''
*Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / {{Object|CROP_LANDCOVER}}
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 193: Line 200:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_REGION_GRID_LANDCOVERS ===
 
=== CMETEO_REGION_GRID_LANDCOVERS ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on {{Object|LINK_REGION_GRID_LANDCOVER}}
+
* Remarks: user defined, derived from GIS
*Remarks: user defined, derived from GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 228: Line 236:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_WEATHER_OBS_AEZ ===
 
=== CMETEO_WEATHER_OBS_AEZ ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on {{Object|WEATHER_OBS_AEZ}}
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 332: Line 342:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_WEATHER_OBS_GRID ===
 
=== CMETEO_WEATHER_OBS_GRID ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on table {{Object|WEATHER_OBS_GRID}}
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 405: Line 417:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_WEATHER_OBS_REGION ===
 
=== CMETEO_WEATHER_OBS_REGION ===
''View''.
+
* 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
+
* Type: ''View''
*Type: view on {{Object|WEATHER_OBS_REGION}}
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 509: Line 523:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== COMPLETE-datasets ==
 
== COMPLETE-datasets ==
Line 515: Line 531:
 
{{TocRow|#COMPLETE_LIST_OF_SIM_UNITS_X|2.2 COMPLETE_LIST_OF_SIM_UNITS_X}}
 
{{TocRow|#COMPLETE_LIST_OF_SIM_UNITS_X|2.2 COMPLETE_LIST_OF_SIM_UNITS_X}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== COMPLETE_LIST_OF_SIM_UNITS ===
 
=== COMPLETE_LIST_OF_SIM_UNITS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 540: Line 560:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== COMPLETE_LIST_OF_SIM_UNITS_X ===
 
=== COMPLETE_LIST_OF_SIM_UNITS_X ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 587: Line 611:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 595: Line 621:
 
{{TocRow|#CROP_PARAMETER_VALUE|3.4 CROP_PARAMETER_VALUE}}
 
{{TocRow|#CROP_PARAMETER_VALUE|3.4 CROP_PARAMETER_VALUE}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_CALENDAR ===
 
=== CROP_CALENDAR ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, one of the ‘driving’ tables of the system
*Remarks: user defined, one of the ‘driving’ tables of the system
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 640: Line 667:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_GROUP ===
 
=== CROP_GROUP ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: synonym on permanent table FORALL.CROP_GROUP
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 663: Line 691:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_LANDCOVER ===
 
=== CROP_LANDCOVER ===
''Table''.
+
* Description:
*List of crop and landcovers
+
* Use: source for various views & synonyms
*Use: source for various views & synonyms
+
* Type: ''Table''
*Type: synonym & table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 693: Line 723:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_PARAMETER_VALUE ===
 
=== CROP_PARAMETER_VALUE ===
''Table''.
+
* 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
+
* Type: ''Table''
*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.
*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.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 720: Line 751:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== LINK-datasets ==
 
== LINK-datasets ==
Line 729: Line 762:
 
{{TocRow|#LINK_STATION_GRID|4.5 LINK_STATION_GRID}}
 
{{TocRow|#LINK_STATION_GRID|4.5 LINK_STATION_GRID}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_AEZ_GRID_LANDCOVER ===
 
=== LINK_AEZ_GRID_LANDCOVER ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, derived from GIS
*Remarks: user defined, derived from GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 757: Line 791:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_EMU_REGION ===
 
=== LINK_EMU_REGION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 784: Line 819:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_EMU_REGION_LANDCOVER ===
 
=== LINK_EMU_REGION_LANDCOVER ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 813: Line 849:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_REGION_GRID_LANDCOVER ===
 
=== LINK_REGION_GRID_LANDCOVER ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, derived from GIS
*Remarks: user defined, derived from GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 840: Line 877:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_STATION_GRID ===
 
=== LINK_STATION_GRID ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 865: Line 903:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== RAIN-datasets ==
 
== RAIN-datasets ==
Line 872: Line 912:
 
{{TocRow|#RAIN_OBS_STATION_RAW|5.3 RAIN_OBS_STATION_RAW}}
 
{{TocRow|#RAIN_OBS_STATION_RAW|5.3 RAIN_OBS_STATION_RAW}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== RAIN_OBS_STATION ===
 
=== RAIN_OBS_STATION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 902: Line 943:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== RAIN_OBS_STATION_INFO ===
 
=== RAIN_OBS_STATION_INFO ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 937: Line 979:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== RAIN_OBS_STATION_RAW ===
 
=== RAIN_OBS_STATION_RAW ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 964: Line 1,007:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SIMULATION-datasets ==
 
== SIMULATION-datasets ==
Line 971: Line 1,016:
 
{{TocRow|#SIMULATION_UNIT_ALL|6.3 SIMULATION_UNIT_ALL}}
 
{{TocRow|#SIMULATION_UNIT_ALL|6.3 SIMULATION_UNIT_ALL}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMULATION_LOG ===
 
=== SIMULATION_LOG ===
''Table''.
+
* Description: contains information about simulation
*Description: contains information about simulation
+
* Use: reference table
*Use: reference table
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,027: Line 1,073:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMULATION_UNIT ===
 
=== SIMULATION_UNIT ===
''View''.
+
* 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
+
* Type: ''View''
*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.
*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.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,056: Line 1,103:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMULATION_UNIT_ALL ===
 
=== SIMULATION_UNIT_ALL ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,078: Line 1,129:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SIMYIELD-datasets ==
 
== SIMYIELD-datasets ==
Line 1,104: Line 1,157:
 
{{TocRow|#SIMYIELD_WARM_REGION_LTA|7.22 SIMYIELD_WARM_REGION_LTA}}
 
{{TocRow|#SIMYIELD_WARM_REGION_LTA|7.22 SIMYIELD_WARM_REGION_LTA}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_GRID ===
 
=== SIMYIELD_BLAST_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,169: Line 1,226:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_GRID_LOG ===
 
=== SIMYIELD_BLAST_GRID_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,235: Line 1,296:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_GRID_LTA ===
 
=== SIMYIELD_BLAST_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,449: Line 1,514:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_REGION ===
 
=== SIMYIELD_BLAST_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,511: Line 1,580:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_REGION_LOG ===
 
=== SIMYIELD_BLAST_REGION_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,575: Line 1,648:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_BLAST_REGION_LTA ===
 
=== SIMYIELD_BLAST_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,789: Line 1,866:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_EMU ===
 
=== SIMYIELD_EMU ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,854: Line 1,932:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_EMU_LOG ===
 
=== SIMYIELD_EMU_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,912: Line 1,994:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_EMU_LTA ===
 
=== SIMYIELD_EMU_LTA ===
''Table''.
+
* 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.
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remark: -
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,971: Line 2,054:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_GRID ===
 
=== SIMYIELD_GRID ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,028: Line 2,112:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_GRID_LOG ===
 
=== SIMYIELD_GRID_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,084: Line 2,172:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_GRID_LTA ===
 
=== SIMYIELD_GRID_LTA ===
''Table''.
+
* 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.
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remark: -
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,269: Line 2,358:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_REGION ===
 
=== SIMYIELD_REGION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: This table contains aggregated simulation results for all CROP_NO's in {{Object|STAT_CROP}}.
*Remarks: This table contains aggregated simulation results for all CROP_NO's in {{Object|STAT_CROP}}.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,326: Line 2,416:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_REGION_LOG ===
 
=== SIMYIELD_REGION_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,382: Line 2,476:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_REGION_LTA ===
 
=== SIMYIELD_REGION_LTA ===
''Table''.
+
* 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.
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remark: -
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,567: Line 2,662:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_STU ===
 
=== SIMYIELD_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,635: Line 2,734:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_GRID ===
 
=== SIMYIELD_WARM_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,693: Line 2,796:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_GRID_LOG ===
 
=== SIMYIELD_WARM_GRID_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,753: Line 2,860:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_GRID_LTA ===
 
=== SIMYIELD_WARM_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,937: Line 3,048:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_REGION ===
 
=== SIMYIELD_WARM_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,993: Line 3,108:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_REGION_LOG ===
 
=== SIMYIELD_WARM_REGION_LOG ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,051: Line 3,170:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SIMYIELD_WARM_REGION_LTA ===
 
=== SIMYIELD_WARM_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,235: Line 3,358:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SOIL-datasets ==
 
== SOIL-datasets ==
Line 3,244: Line 3,369:
 
{{TocRow|#SOIL_TYPOLOGIC_UNIT|8.5 SOIL_TYPOLOGIC_UNIT}}
 
{{TocRow|#SOIL_TYPOLOGIC_UNIT|8.5 SOIL_TYPOLOGIC_UNIT}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_ASSOCIATION_COMPOSITION ===
 
=== SOIL_ASSOCIATION_COMPOSITION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: derived from the soil map
*Remarks: derived from the soil map
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,270: Line 3,396:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_DATA_FOR_BIOMA ===
 
=== SOIL_DATA_FOR_BIOMA ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,352: Line 3,482:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_MAPPING_UNIT ===
 
=== SOIL_MAPPING_UNIT ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined, derived from the soil map
*Remarks: user defined, derived from the soil map
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,375: Line 3,506:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_PHYSICAL_GROUP ===
 
=== SOIL_PHYSICAL_GROUP ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined, derived from the soil map
*Remarks: user defined, derived from the soil map
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,402: Line 3,534:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_TYPOLOGIC_UNIT ===
 
=== SOIL_TYPOLOGIC_UNIT ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined, derived from the soil map
*Remarks: user defined, derived from the soil map
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,451: Line 3,584:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SUPIT-datasets ==
 
== SUPIT-datasets ==
Line 3,457: Line 3,592:
 
{{TocRow|#SUPIT_REFERENCE_STATIONS|9.2 SUPIT_REFERENCE_STATIONS}}
 
{{TocRow|#SUPIT_REFERENCE_STATIONS|9.2 SUPIT_REFERENCE_STATIONS}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== SUPIT_CONSTANTS ===
 
=== SUPIT_CONSTANTS ===
''Table''.
+
* 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
+
* Type: ''Table''
*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)
*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)
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,493: Line 3,629:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SUPIT_REFERENCE_STATIONS ===
 
=== SUPIT_REFERENCE_STATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,546: Line 3,686:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
Line 3,572: Line 3,714:
 
{{TocRow|#WEATHER_STATION|10.22 WEATHER_STATION}}
 
{{TocRow|#WEATHER_STATION|10.22 WEATHER_STATION}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_AEZ ===
 
=== WEATHER_OBS_AEZ ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,663: Line 3,807:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_AEZ_LTA ===
 
=== WEATHER_OBS_AEZ_LTA ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,841: Line 3,987:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_AEZ_LTA_THRES ===
 
=== WEATHER_OBS_AEZ_LTA_THRES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,869: Line 4,019:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_AEZ_THRES ===
 
=== WEATHER_OBS_AEZ_THRES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,895: Line 4,049:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_GRID ===
 
=== WEATHER_OBS_GRID ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,949: Line 4,105:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_GRID_INFO ===
 
=== WEATHER_OBS_GRID_INFO ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,981: Line 4,139:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_GRID_LTA ===
 
=== WEATHER_OBS_GRID_LTA ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,155: Line 4,315:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_GRID_LTA_MISS ===
 
=== WEATHER_OBS_GRID_LTA_MISS ===
''Table''.
+
* 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]]).
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: filled with procedure lta_missing_grid_weather.sql
*Remarks: filled with procedure lta_missing_grid_weather.sql
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,188: Line 4,349:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_HIS_OPE_GRID ===
 
=== WEATHER_OBS_HIS_OPE_GRID ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,248: Line 4,413:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGION ===
 
=== WEATHER_OBS_REGION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,338: Line 4,505:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGION_LTA ===
 
=== WEATHER_OBS_REGION_LTA ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,516: Line 4,685:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGION_LTA_THRES ===
 
=== WEATHER_OBS_REGION_LTA_THRES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,544: Line 4,717:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGION_THRES ===
 
=== WEATHER_OBS_REGION_THRES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,570: Line 4,747:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION ===
 
=== WEATHER_OBS_STATION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,656: Line 4,834:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_AVAIL ===
 
=== WEATHER_OBS_STATION_AVAIL ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,683: Line 4,862:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_CALCULATED ===
 
=== WEATHER_OBS_STATION_CALCULATED ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,714: Line 4,894:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_ERRAIN ===
 
=== WEATHER_OBS_STATION_ERRAIN ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,741: Line 4,922:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_ERRORS ===
 
=== WEATHER_OBS_STATION_ERRORS ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,824: Line 5,006:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_INFO ===
 
=== WEATHER_OBS_STATION_INFO ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,913: Line 5,096:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_LTA ===
 
=== WEATHER_OBS_STATION_LTA ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: filled by software tool [[Software Tools#ReferenceWeather|ReferenceWeather]]
*Remarks: filled by software tool [[Software Tools#ReferenceWeather|ReferenceWeather]]
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,956: Line 5,140:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_STATION_RAW ===
 
=== WEATHER_OBS_STATION_RAW ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,101: Line 5,286:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_STATION ===
 
=== WEATHER_STATION ===
''View''.
+
* Description:  
*Description:  
+
* Use: interface between the CGMS12EU database and the [[SupitConstants]] software
*Use: interface between the CGMS12EU database and the [[SupitConstants]] software
+
* Type: ''View''
*Type: view on table {{Object|STATION}}
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,160: Line 5,346:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== other datasets ==
 
== other datasets ==
 
{{TocTable|content=
 
{{TocTable|content=
 
{{TocRow|#AEZ|11.1 AEZ}}
 
{{TocRow|#AEZ|11.1 AEZ}}
{{TocRow|#CROP|11.2 CROP}}
+
{{TocRow|#AGGREGATION_AREAS|11.2 AGGREGATION_AREAS}}
{{TocRow|#CROPSUSE|11.3 CROPSUSE}}
+
{{TocRow|#ALL_SIMULATION_UNITS|11.3 ALL_SIMULATION_UNITS}}
{{TocRow|#CW|11.4 CW}}
+
{{TocRow|#CGMS_SYSLOG|11.4 CGMS_SYSLOG}}
{{TocRow|#EMU|11.5 EMU}}
+
{{TocRow|#CROP|11.5 CROP}}
{{TocRow|#GRID|11.6 GRID}}
+
{{TocRow|#CROPSUSE|11.6 CROPSUSE}}
{{TocRow|#JSOW|11.7 JSOW}}
+
{{TocRow|#CW|11.7 CW}}
{{TocRow|#REGION|11.8 REGION}}
+
{{TocRow|#DATES_75_15|11.8 DATES_75_15}}
{{TocRow|#SITE|11.9 SITE}}
+
{{TocRow|#EMU|11.9 EMU}}
{{TocRow|#STATION|11.10 STATION}}
+
{{TocRow|#GRID|11.10 GRID}}
{{TocRow|#SUITABILITY|11.11 SUITABILITY}}
+
{{TocRow|#GRID_ALL|11.11 GRID_ALL}}
{{TocRow|#SYE|11.12 SYE}}
+
{{TocRow|#INITIAL_SOIL_WATER|11.12 INITIAL_SOIL_WATER}}
{{TocRow|#SYSCON|11.13 SYSCON}}
+
{{TocRow|#JSOW|11.13 JSOW}}
{{TocRow|#SYSTABLES|11.14 SYSTABLES}}
+
{{TocRow|#ORDER_EAST_EUROPE|11.14 ORDER_EAST_EUROPE}}
{{TocRow|#TASKS|11.15 TASKS}}
+
{{TocRow|#PARAMETER_DESCRIPTION|11.15 PARAMETER_DESCRIPTION}}
{{TocRow|#WOG|11.16 WOG}}
+
{{TocRow|#REGION|11.16 REGION}}
{{TocRow|#WOGINFO|11.17 WOGINFO}}
+
{{TocRow|#REGION_GRIDS_EMU|11.17 REGION_GRIDS_EMU}}
{{TocRow|#WOSC|11.18 WOSC}}
+
{{TocRow|#ROOTING_DEPTH|11.18 ROOTING_DEPTH}}
{{TocRow|#AGGREGATION_AREAS|11.19 AGGREGATION_AREAS}}
+
{{TocRow|#SITE|11.19 SITE}}
{{TocRow|#ALL_SIMULATION_UNITS|11.20 ALL_SIMULATION_UNITS}}
+
{{TocRow|#SMU_SUITABILITY|11.20 SMU_SUITABILITY}}
{{TocRow|#CGMS_SYSLOG|11.21 CGMS_SYSLOG}}
+
{{TocRow|#STATION|11.21 STATION}}
{{TocRow|#DATES_75_15|11.22 DATES_75_15}}
+
{{TocRow|#STATIONS_PER_GRID|11.22 STATIONS_PER_GRID}}
{{TocRow|#GRID_ALL|11.23 GRID_ALL}}
+
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|11.23 STATION_REFERENCE_COEFFICIENTS}}
{{TocRow|#INITIAL_SOIL_WATER|11.24 INITIAL_SOIL_WATER}}
+
{{TocRow|#STAT_CROP|11.24 STAT_CROP}}
{{TocRow|#ORDER_EAST_EUROPE|11.25 ORDER_EAST_EUROPE}}
+
{{TocRow|#STU_LAYER|11.25 STU_LAYER}}
{{TocRow|#PARAMETER_DESCRIPTION|11.26 PARAMETER_DESCRIPTION}}
+
{{TocRow|#SUITABILITY|11.26 SUITABILITY}}
{{TocRow|#REGION_GRIDS_EMU|11.27 REGION_GRIDS_EMU}}
+
{{TocRow|#SYE|11.27 SYE}}
{{TocRow|#ROOTING_DEPTH|11.28 ROOTING_DEPTH}}
+
{{TocRow|#SYSCON|11.28 SYSCON}}
{{TocRow|#SMU_SUITABILITY|11.29 SMU_SUITABILITY}}
+
{{TocRow|#SYSTABLES|11.29 SYSTABLES}}
{{TocRow|#STAT_CROP|11.30 STAT_CROP}}
+
{{TocRow|#TASKS|11.30 TASKS}}
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|11.31 STATION_REFERENCE_COEFFICIENTS}}
+
{{TocRow|#VARIETY_PARAMETER_VALUE|11.31 VARIETY_PARAMETER_VALUE}}
{{TocRow|#STATIONS_PER_GRID|11.32 STATIONS_PER_GRID}}
+
{{TocRow|#VIEWER_REQUESTS|11.32 VIEWER_REQUESTS}}
{{TocRow|#STU_LAYER|11.33 STU_LAYER}}
+
{{TocRow|#WOG|11.33 WOG}}
{{TocRow|#VARIETY_PARAMETER_VALUE|11.34 VARIETY_PARAMETER_VALUE}}
+
{{TocRow|#WOGINFO|11.34 WOGINFO}}
{{TocRow|#VIEWER_REQUESTS|11.35 VIEWER_REQUESTS}}
+
{{TocRow|#WOSC|11.35 WOSC}}
 
}}
 
}}
 +
 +
  
  
 
<!-- start -->
 
<!-- start -->
 
=== AEZ ===
 
=== AEZ ===
''Table''.
+
* 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}}
+
* Type: ''Table''
*Type: synonym on FORALL.REGIONS_ZONES_08
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,235: Line 5,424:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== AGGREGATION_AREAS ===
 
=== AGGREGATION_AREAS ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,282: Line 5,472:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== ALL_SIMULATION_UNITS ===
 
=== ALL_SIMULATION_UNITS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,308: Line 5,502:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CGMS_SYSLOG ===
 
=== CGMS_SYSLOG ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,353: Line 5,548:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP ===
 
=== CROP ===
''Table''.
+
* 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
+
* Type: ''Table''
*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.
*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.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,391: Line 5,587:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROPSUSE ===
 
=== CROPSUSE ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,433: Line 5,633:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CW ===
 
=== CW ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,461: Line 5,665:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== DATES_75_15 ===
 
=== DATES_75_15 ===
''Table''.
+
* Description: synonym to oracle package
*Description: synonym to oracle package
+
* Use: view on [[DATE_GENERATOR]] package
*Use: view on [[DATE_GENERATOR]] package
+
* Type: ''Table''
*Type: synonym on forall.dates_75_15
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,502: Line 5,707:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== EMU ===
 
=== EMU ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, derived from GIS, provides the link to the GIS
*Remarks: user defined, derived from GIS, provides the link to the GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,527: Line 5,733:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GRID ===
 
=== GRID ===
''View''.
+
* 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
+
* Type: ''View''
*Type: permanent table
+
* Remarks: user defined, derived from GIS, provides the link to the GIS
*Remarks: user defined, derived from GIS, provides the link to the GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,566: Line 5,773:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GRID_ALL ===
 
=== GRID_ALL ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,598: Line 5,809:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== INITIAL_SOIL_WATER ===
 
=== INITIAL_SOIL_WATER ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined
*Remarks: user defined
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,633: Line 5,845:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== JSOW ===
 
=== JSOW ===
''Table''.
+
* 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.
+
* Type: ''Table''
*Type: Permanent table, provided by JRC.
+
* Remarks:  
*Remark: Even if the table {{Object|CROP_CALENDAR}} specifies fixed sowing per crop per year, the JSOW table is used to calculate 'rainfall around sowing'.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,658: Line 5,871:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== ORDER_EAST_EUROPE ===
 
=== ORDER_EAST_EUROPE ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,680: Line 5,897:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== PARAMETER_DESCRIPTION ===
 
=== PARAMETER_DESCRIPTION ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: do not change this table
*Remarks: do not change this table
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,705: Line 5,923:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== REGION ===
 
=== REGION ===
''Table''.
+
* Description: Administrative regions
*Description: Administrative regions
+
* Use: input for monitoring extreme weather events
*Use: input for monitoring extreme weather events
+
* Type: ''Table''
*Type: Synonym on view FORALL.REGIONS_EUR12EU which references the FORALL tables {{Object|REGION_DESCRIPTIONS}} and {{Object|REGION_MAPPINGS}}
+
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,743: Line 5,963:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== REGION_GRIDS_EMU ===
 
=== REGION_GRIDS_EMU ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,867: Line 6,091:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== ROOTING_DEPTH ===
 
=== ROOTING_DEPTH ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: part of the soil model, can be changed or extended if necessary
*Remarks: part of the soil model, can be changed or extended if necessary
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,890: Line 6,115:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SITE ===
 
=== SITE ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: supplied by the user, but rarely changed
*Remarks: supplied by the user, but rarely changed
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,915: Line 6,141:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SMU_SUITABILITY ===
 
=== SMU_SUITABILITY ===
''Table''.
+
* 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)
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: this table needs to be recalculated whenever the simulation_unit table changes
*Remarks: this table needs to be recalculated whenever the simulation_unit table changes
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,940: Line 6,167:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== STATION ===
 
=== STATION ===
''Table''.
+
* 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)
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated
*Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,017: Line 6,245:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== STATIONS_PER_GRID ===
 
=== STATIONS_PER_GRID ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: contains both information produced by historical interpolation and current year interpolation.
*Remarks: contains both information produced by historical interpolation and current year interpolation.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,072: Line 6,301:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== STATION_REFERENCE_COEFFICIENTS ===
 
=== STATION_REFERENCE_COEFFICIENTS ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,111: Line 6,341:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== STAT_CROP ===
 
=== STAT_CROP ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,142: Line 6,373:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== STU_LAYER ===
 
=== STU_LAYER ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,169: Line 6,401:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SUITABILITY ===
 
=== SUITABILITY ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, derived from the soil map
*Remarks: user defined, derived from the soil map
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,192: Line 6,425:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SYE ===
 
=== SYE ===
''Table''.
+
* 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.
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
*Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,251: Line 6,485:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SYSCON ===
 
=== SYSCON ===
''Table''.
+
* Description: contains system parameters
*Description: contains system parameters
+
* Use: upon system initialisation
*Use: upon system initialisation
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined
*Remarks: user defined
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,274: Line 6,509:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== SYSTABLES ===
 
=== SYSTABLES ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,297: Line 6,533:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== TASKS ===
 
=== TASKS ===
''View''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''View''
*Type: permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,343: Line 6,580:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== VARIETY_PARAMETER_VALUE ===
 
=== VARIETY_PARAMETER_VALUE ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in {{Object|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.
*Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in {{Object|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.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,374: Line 6,612:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== VIEWER_REQUESTS ===
 
=== VIEWER_REQUESTS ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,407: Line 6,646:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WOG ===
 
=== WOG ===
''Table''.
+
* 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
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
*Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,462: Line 6,702:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WOGINFO ===
 
=== WOGINFO ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,492: Line 6,736:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== WOSC ===
 
=== WOSC ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,520: Line 6,768:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== synonyms ==
 
== synonyms ==
Line 6,528: Line 6,778:
  
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== CMETEO_ADMIN ===
 
=== CMETEO_ADMIN ===
''Synonym &#x279e; CMETEO@ADMIN_MRSMAN''.
+
* Description: synonym to oracle package
*Description: synonym to oracle package
+
* Use:  
*Use:  
+
* Type: ''Synonym &#x279e; CMETEO@ADMIN_MRSMAN''
*Type: synonym on mrsman.cmeteo_admin
+
* Remarks: none
*Remarks: none
 
 
<br>
 
<br>
  
 
<!-- end -->
 
<!-- end -->
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== REGION_MAPPINGS ===
 
=== REGION_MAPPINGS ===
''Synonym &#x279e; REGION@MAPPINGS_EURMAN''.
+
* 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.
+
* Type: ''Synonym &#x279e; REGION@MAPPINGS_EURMAN''
*Type: synonyms on forall.region_mappings_eur
+
* Remarks: none
*Remarks: none
 
 
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}.
 
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}.
 
<!-- end -->
 
<!-- end -->

Latest revision as of 22:05, 28 January 2016



note: this page was generated as a round trip of Appendix_5:_CGMS_tables and therefore shoul be identical except for the lay-out.


content
1. CMETEO-datasets
2. COMPLETE-datasets
3. CROP-datasets
4. LINK-datasets
5. RAIN-datasets
6. SIMULATION-datasets
7. SIMYIELD-datasets
8. SOIL-datasets
9. SUPIT-datasets
10. WEATHER-datasets
11. other datasets
12. synonyms




CMETEO-datasets

content
1.1 CMETEO_AEZ_GRID_LANDCOVERS
1.2 CMETEO_AGGREGATION_AREAS
1.3 CMETEO_CROPS
1.4 CMETEO_LANDCOVERS
1.5 CMETEO_REGION_GRID_LANDCOVERS
1.6 CMETEO_WEATHER_OBS_AEZ
1.7 CMETEO_WEATHER_OBS_GRID
1.8 CMETEO_WEATHER_OBS_REGION




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
  • Remarks: user defined, derived from GIS


CMETEO_AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: input for cmeteo, converting names of columns for use in cmeteo package
  • Type: View
  • Remarks: none


CMETEO_CROPS

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


CMETEO_LANDCOVERS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


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
  • Remarks: user defined, derived from GIS


CMETEO_WEATHER_OBS_AEZ

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


CMETEO_WEATHER_OBS_GRID

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


CMETEO_WEATHER_OBS_REGION

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


COMPLETE-datasets

content
2.1 COMPLETE_LIST_OF_SIM_UNITS
2.2 COMPLETE_LIST_OF_SIM_UNITS_X




COMPLETE_LIST_OF_SIM_UNITS

  • Description:
  • Use:
  • Type: Table
  • Remarks:


COMPLETE_LIST_OF_SIM_UNITS_X

  • Description:
  • Use:
  • Type: View
  • Remarks:


CROP-datasets

content
3.1 CROP_CALENDAR
3.2 CROP_GROUP
3.3 CROP_LANDCOVER
3.4 CROP_PARAMETER_VALUE




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: Table
  • Remarks: user defined, one of the ‘driving’ tables of the system


CROP_GROUP

  • Description: description of crop groups
  • Use: input table for the crop group number and name where crop belongs to
  • Type: Table
  • Remarks: none


CROP_LANDCOVER

  • Description:
  • Use: source for various views & synonyms
  • Type: Table
  • Remarks:


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: 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.


LINK-datasets

content
4.1 LINK_AEZ_GRID_LANDCOVER
4.2 LINK_EMU_REGION
4.3 LINK_EMU_REGION_LANDCOVER
4.4 LINK_REGION_GRID_LANDCOVER
4.5 LINK_STATION_GRID




LINK_AEZ_GRID_LANDCOVER

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


LINK_EMU_REGION

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


LINK_EMU_REGION_LANDCOVER

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


LINK_REGION_GRID_LANDCOVER

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


LINK_STATION_GRID

  • Description:
  • Use:
  • Type: Table
  • Remarks:


RAIN-datasets

content
5.1 RAIN_OBS_STATION
5.2 RAIN_OBS_STATION_INFO
5.3 RAIN_OBS_STATION_RAW




RAIN_OBS_STATION

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


RAIN_OBS_STATION_INFO

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


RAIN_OBS_STATION_RAW

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


SIMULATION-datasets

content
6.1 SIMULATION_LOG
6.2 SIMULATION_UNIT
6.3 SIMULATION_UNIT_ALL




SIMULATION_LOG

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


SIMULATION_UNIT

  • Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
  • Use: lookup table used during crop simulation
  • Type: View
  • 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.


SIMULATION_UNIT_ALL

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD-datasets

content
7.1 SIMYIELD_BLAST_GRID
7.2 SIMYIELD_BLAST_GRID_LOG
7.3 SIMYIELD_BLAST_GRID_LTA
7.4 SIMYIELD_BLAST_REGION
7.5 SIMYIELD_BLAST_REGION_LOG
7.6 SIMYIELD_BLAST_REGION_LTA
7.7 SIMYIELD_EMU
7.8 SIMYIELD_EMU_LOG
7.9 SIMYIELD_EMU_LTA
7.10 SIMYIELD_GRID
7.11 SIMYIELD_GRID_LOG
7.12 SIMYIELD_GRID_LTA
7.13 SIMYIELD_REGION
7.14 SIMYIELD_REGION_LOG
7.15 SIMYIELD_REGION_LTA
7.16 SIMYIELD_STU
7.17 SIMYIELD_WARM_GRID
7.18 SIMYIELD_WARM_GRID_LOG
7.19 SIMYIELD_WARM_GRID_LTA
7.20 SIMYIELD_WARM_REGION
7.21 SIMYIELD_WARM_REGION_LOG
7.22 SIMYIELD_WARM_REGION_LTA




SIMYIELD_BLAST_GRID

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_BLAST_GRID_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_BLAST_GRID_LTA

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_BLAST_REGION

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_BLAST_REGION_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_BLAST_REGION_LTA

  • Description:
  • Use:
  • Type: Table
  • Remarks:


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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


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: Table
  • Remarks:


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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


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: Table
  • Remarks:


SIMYIELD_REGION

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


SIMYIELD_REGION_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


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: Table
  • Remarks:


SIMYIELD_STU

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_GRID

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_GRID_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_GRID_LTA

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_REGION

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_REGION_LOG

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SIMYIELD_WARM_REGION_LTA

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SOIL-datasets

content
8.1 SOIL_ASSOCIATION_COMPOSITION
8.2 SOIL_DATA_FOR_BIOMA
8.3 SOIL_MAPPING_UNIT
8.4 SOIL_PHYSICAL_GROUP
8.5 SOIL_TYPOLOGIC_UNIT




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: Table
  • Remarks: derived from the soil map


SOIL_DATA_FOR_BIOMA

  • Description:
  • Use:
  • Type: View
  • Remarks:


SOIL_MAPPING_UNIT

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


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: Table
  • Remarks: user defined, derived from the soil map


SOIL_TYPOLOGIC_UNIT

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


SUPIT-datasets

content
9.1 SUPIT_CONSTANTS
9.2 SUPIT_REFERENCE_STATIONS




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: Table
  • Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)


SUPIT_REFERENCE_STATIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


WEATHER-datasets

content
10.1 WEATHER_OBS_AEZ
10.2 WEATHER_OBS_AEZ_LTA
10.3 WEATHER_OBS_AEZ_LTA_THRES
10.4 WEATHER_OBS_AEZ_THRES
10.5 WEATHER_OBS_GRID
10.6 WEATHER_OBS_GRID_INFO
10.7 WEATHER_OBS_GRID_LTA
10.8 WEATHER_OBS_GRID_LTA_MISS
10.9 WEATHER_OBS_HIS_OPE_GRID
10.10 WEATHER_OBS_REGION
10.11 WEATHER_OBS_REGION_LTA
10.12 WEATHER_OBS_REGION_LTA_THRES
10.13 WEATHER_OBS_REGION_THRES
10.14 WEATHER_OBS_STATION
10.15 WEATHER_OBS_STATION_AVAIL
10.16 WEATHER_OBS_STATION_CALCULATED
10.17 WEATHER_OBS_STATION_ERRAIN
10.18 WEATHER_OBS_STATION_ERRORS
10.19 WEATHER_OBS_STATION_INFO
10.20 WEATHER_OBS_STATION_LTA
10.21 WEATHER_OBS_STATION_RAW
10.22 WEATHER_STATION




WEATHER_OBS_AEZ

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


WEATHER_OBS_AEZ_LTA

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


WEATHER_OBS_AEZ_LTA_THRES

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WEATHER_OBS_AEZ_THRES

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WEATHER_OBS_GRID

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


WEATHER_OBS_GRID_INFO

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WEATHER_OBS_GRID_LTA

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


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: Table
  • Remarks: filled with procedure lta_missing_grid_weather.sql


WEATHER_OBS_HIS_OPE_GRID

  • Description:
  • Use:
  • Type: View
  • Remarks:


WEATHER_OBS_REGION

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


WEATHER_OBS_REGION_LTA

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


WEATHER_OBS_REGION_LTA_THRES

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WEATHER_OBS_REGION_THRES

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WEATHER_OBS_STATION

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


WEATHER_OBS_STATION_AVAIL

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


WEATHER_OBS_STATION_CALCULATED

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


WEATHER_OBS_STATION_ERRAIN

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


WEATHER_OBS_STATION_ERRORS

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


WEATHER_OBS_STATION_INFO

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


WEATHER_OBS_STATION_LTA

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


WEATHER_OBS_STATION_RAW

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


WEATHER_STATION

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: View
  • Remarks:


other datasets

content
11.1 AEZ
11.2 AGGREGATION_AREAS
11.3 ALL_SIMULATION_UNITS
11.4 CGMS_SYSLOG
11.5 CROP
11.6 CROPSUSE
11.7 CW
11.8 DATES_75_15
11.9 EMU
11.10 GRID
11.11 GRID_ALL
11.12 INITIAL_SOIL_WATER
11.13 JSOW
11.14 ORDER_EAST_EUROPE
11.15 PARAMETER_DESCRIPTION
11.16 REGION
11.17 REGION_GRIDS_EMU
11.18 ROOTING_DEPTH
11.19 SITE
11.20 SMU_SUITABILITY
11.21 STATION
11.22 STATIONS_PER_GRID
11.23 STATION_REFERENCE_COEFFICIENTS
11.24 STAT_CROP
11.25 STU_LAYER
11.26 SUITABILITY
11.27 SYE
11.28 SYSCON
11.29 SYSTABLES
11.30 TASKS
11.31 VARIETY_PARAMETER_VALUE
11.32 VIEWER_REQUESTS
11.33 WOG
11.34 WOGINFO
11.35 WOSC




AEZ


AGGREGATION_AREAS

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


ALL_SIMULATION_UNITS

  • Description:
  • Use:
  • Type: View
  • Remarks:


CGMS_SYSLOG

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


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: 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.


CROPSUSE

  • Description:
  • Use:
  • Type: Table
  • Remarks:


CW

  • Description:
  • Use:
  • Type: Table
  • Remarks:


DATES_75_15

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: Table
  • Remarks: none


EMU

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


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: View
  • Remarks: user defined, derived from GIS, provides the link to the GIS


GRID_ALL

  • Description:
  • Use:
  • Type: Table
  • Remarks:


INITIAL_SOIL_WATER

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


JSOW

  • Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
  • Use: Input table for calculating one of the Crop Simulation indicators.
  • Type: Table
  • Remarks:


ORDER_EAST_EUROPE

  • Description:
  • Use:
  • Type: Table
  • Remarks:


PARAMETER_DESCRIPTION

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


REGION

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Table
  • Remarks:


REGION_GRIDS_EMU

  • Description:
  • Use:
  • Type: View
  • Remarks:


ROOTING_DEPTH

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


SITE

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


SMU_SUITABILITY

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


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: Table
  • Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated


STATIONS_PER_GRID

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


STATION_REFERENCE_COEFFICIENTS

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


STAT_CROP

  • Description:
  • Use:
  • Type: Table
  • Remarks:


STU_LAYER

  • Description:
  • Use:
  • Type: Table
  • Remarks:


SUITABILITY

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


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: Table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


SYSCON

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


SYSTABLES

  • Description:
  • Use:
  • Type: Table
  • Remarks:


TASKS

  • Description:
  • Use:
  • Type: View
  • Remarks:


VARIETY_PARAMETER_VALUE

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


VIEWER_REQUESTS

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WOG

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


WOGINFO

  • Description:
  • Use:
  • Type: Table
  • Remarks:


WOSC

  • Description:
  • Use:
  • Type: Table
  • Remarks:


synonyms

content
12.1 CMETEO_ADMIN
12.2 REGION_MAPPINGS




CMETEO_ADMIN

  • Description: synonym to oracle package
  • Use:
  • Type: Synonym ➞ CMETEO@ADMIN_MRSMAN
  • Remarks: none




REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: Synonym ➞ REGION@MAPPINGS_EURMAN
  • Remarks: none

* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.