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

From Agri4castWiki
Jump to: navigation, search
(WOG)
(generated page)
Line 1: Line 1:
 
  
 
{{expert}}
 
{{expert}}
Line 37: Line 36:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_AGGREGATIONS ===
 
=== CROP_AGGREGATIONS ===
''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 64: Line 62:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_CALENDARS ===
 
=== CROP_CALENDARS ===
''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 108: Line 105:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_CALENDARS_OLD ===
 
=== CROP_CALENDARS_OLD ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 148: Line 147:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_PARAMETRIZATIONS ===
 
=== CROP_PARAMETRIZATIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 178: Line 179:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_PARAMETRIZATION_PARAMETER ===
 
=== CROP_PARAMETRIZATION_PARAMETER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 204: Line 207:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_REGIMES ===
 
=== CROP_REGIMES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 236: Line 241:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_SPATIALIZATIONS ===
 
=== CROP_SPATIALIZATIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 260: Line 267:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_SUITABILITY_RULES ===
 
=== CROP_SUITABILITY_RULES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 288: Line 297:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETIES ===
 
=== CROP_VARIETIES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 312: Line 323:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETY_PARAMETERS ===
 
=== CROP_VARIETY_PARAMETERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 338: Line 351:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETY_PARAMETERS_OLD ===
 
=== CROP_VARIETY_PARAMETERS_OLD ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 364: Line 379:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETY_REGIMES ===
 
=== CROP_VARIETY_REGIMES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 416: Line 433:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CATEGORIES ===
 
=== GLOBAL_CATEGORIES ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 447: Line 466:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_COVERS ===
 
=== GLOBAL_COVERS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 478: Line 499:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_COVER_SOURCES ===
 
=== GLOBAL_COVER_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 512: Line 535:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CROPS ===
 
=== GLOBAL_CROPS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 546: Line 571:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CROP_PARAMETERS ===
 
=== GLOBAL_CROP_PARAMETERS ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 589: Line 616:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_GRIDS ===
 
=== GLOBAL_GRIDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 663: Line 692:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_GRID_SOURCES ===
 
=== GLOBAL_GRID_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 711: Line 742:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 766: Line 799:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_MODELS ===
 
=== GLOBAL_MODELS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 797: Line 832:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGIONS ===
 
=== GLOBAL_REGIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 834: Line 871:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_ELEMENTS ===
 
=== GLOBAL_REGION_ELEMENTS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 899: Line 938:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_SOURCES ===
 
=== GLOBAL_REGION_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 934: Line 975:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_SOIL_SOURCES ===
 
=== GLOBAL_SOIL_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 965: Line 1,008:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_STATISTIC_SOURCES ===
 
=== GLOBAL_STATISTIC_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 996: Line 1,041:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_SUITABILITY_PROPERTIES ===
 
=== GLOBAL_SUITABILITY_PROPERTIES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,027: Line 1,074:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_THRESHOLDS ===
 
=== GLOBAL_THRESHOLDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,069: Line 1,118:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_TIME_DIMENSIONS ===
 
=== GLOBAL_TIME_DIMENSIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,118: Line 1,169:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_TREATMENTS ===
 
=== GLOBAL_TREATMENTS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,149: Line 1,202:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_WINDOWS ===
 
=== GLOBAL_WINDOWS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,240: Line 1,295:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_AGGREGATION ===
 
=== LINK_CROP_AGGREGATION ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,299: Line 1,356:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_CALENDARS ===
 
=== LINK_CROP_CALENDARS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,380: Line 1,439:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS ===
 
=== LINK_CROP_PARAMETERS ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,452: Line 1,513:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS_CROP ===
 
=== LINK_CROP_PARAMETERS_CROP ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,519: Line 1,582:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS_MODEL ===
 
=== LINK_CROP_PARAMETERS_MODEL ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,586: Line 1,651:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_PARAMETRIZATION ===
 
=== LINK_CROP_PARAMETRIZATION ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,640: Line 1,707:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_SPATIALIZATIONS ===
 
=== LINK_CROP_SPATIALIZATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,720: Line 1,789:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_STU ===
 
=== LINK_CROP_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,742: Line 1,813:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_VARIETY_PARAMETERS ===
 
=== LINK_CROP_VARIETY_PARAMETERS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,824: Line 1,897:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_GRID_COVER ===
 
=== LINK_GRID_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,848: Line 1,923:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_GRID_REGION_COVER ===
 
=== LINK_GRID_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,874: Line 1,951:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_REGION_COVER ===
 
=== LINK_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,898: Line 1,977:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT ===
 
=== LINK_SIMULATION_UNIT ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,937: Line 2,018:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT_CROP ===
 
=== LINK_SIMULATION_UNIT_CROP ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,983: Line 2,066:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_GRID_COVER ===
 
=== LINK_SMU_GRID_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,009: Line 2,094:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_GRID_REGION_COVER ===
 
=== LINK_SMU_GRID_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,037: Line 2,124:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_STU ===
 
=== LINK_SMU_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,061: Line 2,150:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_STU_HORIZONS ===
 
=== LINK_STU_HORIZONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,089: Line 2,180:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,145: Line 2,238:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SUITABILITY_RULES ===
 
=== LINK_SUITABILITY_RULES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,250: Line 2,345:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_GRID ===
 
=== SIM_BLAST_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,316: Line 2,413:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_GRID_LTA ===
 
=== SIM_BLAST_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,532: Line 2,631:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION ===
 
=== SIM_BLAST_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,598: Line 2,699:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION_LTA ===
 
=== SIM_BLAST_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,814: Line 2,917:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_GRID ===
 
=== SIM_WARM_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,874: Line 2,979:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_GRID_LTA ===
 
=== SIM_WARM_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,060: Line 3,167:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_REGION ===
 
=== SIM_WARM_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,120: Line 3,229:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WARM_HRES_REGION_LTA ===
 
=== SIM_WARM_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,306: Line 3,417:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_EMU ===
 
=== SIM_WOFOST_HRES_EMU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,368: Line 3,481:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_EMU_LTA ===
 
=== SIM_WOFOST_HRES_EMU_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,556: Line 3,671:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID ===
 
=== SIM_WOFOST_HRES_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,616: Line 3,733:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID_LTA ===
 
=== SIM_WOFOST_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,802: Line 3,921:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION ===
 
=== SIM_WOFOST_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,862: Line 3,983:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION_LTA ===
 
=== SIM_WOFOST_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,048: Line 4,171:
 
<!-- start -->
 
<!-- start -->
 
=== SIM_WOFOST_HRES_STU ===
 
=== SIM_WOFOST_HRES_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,123: Line 4,248:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_HORIZONS ===
 
=== SOIL_HORIZONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,195: Line 4,322:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_INITIAL_WATER ===
 
=== SOIL_INITIAL_WATER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,229: Line 4,358:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_SMU ===
 
=== SOIL_SMU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,253: Line 4,384:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_STU ===
 
=== SOIL_STU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,354: Line 4,487:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_ERA_GRID ===
 
=== WEATHER_ERA_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,404: Line 4,539:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_ERA_GRID_LTA ===
 
=== WEATHER_ERA_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,568: Line 4,705:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_ERA_REGIONCOVER ===
 
=== WEATHER_ERA_REGIONCOVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,620: Line 4,759:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_ERA_REGIONCOVER_LTA ===
 
=== WEATHER_ERA_REGIONCOVER_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,786: Line 4,927:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_HIS_GRID ===
 
=== WEATHER_HIS_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,836: Line 4,979:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_HIS_REGIONCOVER ===
 
=== WEATHER_HIS_REGIONCOVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,888: Line 5,033:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_HRES_GRID ===
 
=== WEATHER_HRES_GRID ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,044: Line 5,191:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_HRES_REGIONCOVER ===
 
=== WEATHER_HRES_REGIONCOVER ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,171: Line 5,320:
 
<!-- 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 5,227: Line 5,376:
 
<!-- 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 5,293: Line 5,442:
 
<!-- 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 5,429: Line 5,578:
 
<!-- 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 5,462: Line 5,610:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGCOV_LTA_THRSHLD ===
 
=== WEATHER_OBS_REGCOV_LTA_THRSHLD ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,492: Line 5,642:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGCOV_THRESHOLDS ===
 
=== WEATHER_OBS_REGCOV_THRESHOLDS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 5,520: Line 5,672:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGIONCOVER ===
 
=== WEATHER_OBS_REGIONCOVER ===
''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 5,568: Line 5,720:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OBS_REGIONCOVER_LTA ===
 
=== WEATHER_OBS_REGIONCOVER_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 5,706: Line 5,858:
 
<!-- 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 5,794: Line 5,945:
 
<!-- 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 5,821: Line 5,971:
 
<!-- 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 5,854: Line 6,003:
 
<!-- 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 5,883: Line 6,031:
 
<!-- 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 5,968: Line 6,115:
 
<!-- 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 6,059: Line 6,205:
 
<!-- 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 6,106: Line 6,251:
 
<!-- 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 6,253: Line 6,397:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OPE_GRID ===
 
=== WEATHER_OPE_GRID ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,307: Line 6,453:
 
<!-- start -->
 
<!-- start -->
 
=== WEATHER_OPE_REGIONCOVER ===
 
=== WEATHER_OPE_REGIONCOVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,382: Line 6,530:
 
<!-- 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 6,429: Line 6,576:
 
<!-- 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 6,472: Line 6,618:
 
<!-- start -->
 
<!-- start -->
 
=== GRIDS ===
 
=== GRIDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,532: Line 6,680:
 
<!-- start -->
 
<!-- start -->
 
=== HRES_YEARS ===
 
=== HRES_YEARS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,558: Line 6,708:
 
<!-- start -->
 
<!-- start -->
 
=== INTERPOLATION_PARAMETERS ===
 
=== INTERPOLATION_PARAMETERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,582: Line 6,734:
 
<!-- start -->
 
<!-- start -->
 
=== REGIONS ===
 
=== REGIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,639: Line 6,793:
 
<!-- start -->
 
<!-- start -->
 
=== STATIONS ===
 
=== STATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,742: Line 6,898:
 
<!-- start -->
 
<!-- start -->
 
=== STAT_REGION_AREAS ===
 
=== STAT_REGION_AREAS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 6,778: Line 6,936:
 
<!-- 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,803: Line 6,960:
 
<!-- start -->
 
<!-- start -->
 
=== TASKS ===
 
=== TASKS ===
''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,838: Line 6,994:
 
<!-- start -->
 
<!-- start -->
 
=== WOG ===
 
=== WOG ===
{{databaseObjectDescription
+
* 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,895: Line 7,049:
  
 
<!-- start -->
 
<!-- start -->
 
 
=== WOSC ===
 
=== WOSC ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure

Revision as of 22:03, 28 January 2016




content
1. CROP-datasets
2. GLOBAL-datasets
3. LINK-datasets
4. SIM-datasets
5. SOIL-datasets
6. WEATHER-datasets
7. other datasets




CROP-datasets

content
1.1 CROP_AGGREGATIONS
1.2 CROP_CALENDARS
1.3 CROP_CALENDARS_OLD
1.4 CROP_PARAMETRIZATIONS
1.5 CROP_PARAMETRIZATION_PARAMETER
1.6 CROP_REGIMES
1.7 CROP_SPATIALIZATIONS
1.8 CROP_SUITABILITY_RULES
1.9 CROP_VARIETIES
1.10 CROP_VARIETY_PARAMETERS
1.11 CROP_VARIETY_PARAMETERS_OLD
1.12 CROP_VARIETY_REGIMES




CROP_AGGREGATIONS

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


CROP_CALENDARS

  • 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_CALENDARS_OLD

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


CROP_PARAMETRIZATIONS

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


CROP_PARAMETRIZATION_PARAMETER

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


CROP_REGIMES

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


CROP_SPATIALIZATIONS

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


CROP_SUITABILITY_RULES

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


CROP_VARIETIES

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


CROP_VARIETY_PARAMETERS

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


CROP_VARIETY_PARAMETERS_OLD

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


CROP_VARIETY_REGIMES

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


GLOBAL-datasets

content
2.1 GLOBAL_CATEGORIES
2.2 GLOBAL_COVERS
2.3 GLOBAL_COVER_SOURCES
2.4 GLOBAL_CROPS
2.5 GLOBAL_CROP_PARAMETERS
2.6 GLOBAL_GRIDS
2.7 GLOBAL_GRID_SOURCES
2.8 GLOBAL_LINK_COVERWINDOW_SOURCE
2.9 GLOBAL_MODELS
2.10 GLOBAL_REGIONS
2.11 GLOBAL_REGION_ELEMENTS
2.12 GLOBAL_REGION_SOURCES
2.13 GLOBAL_SOIL_SOURCES
2.14 GLOBAL_STATISTIC_SOURCES
2.15 GLOBAL_SUITABILITY_PROPERTIES
2.16 GLOBAL_THRESHOLDS
2.17 GLOBAL_TIME_DIMENSIONS
2.18 GLOBAL_TREATMENTS
2.19 GLOBAL_WINDOWS




GLOBAL_CATEGORIES

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


GLOBAL_COVERS

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


GLOBAL_COVER_SOURCES

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


GLOBAL_CROPS

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


GLOBAL_CROP_PARAMETERS

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


GLOBAL_GRIDS

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


GLOBAL_GRID_SOURCES

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


GLOBAL_LINK_COVERWINDOW_SOURCE

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


GLOBAL_MODELS

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


GLOBAL_REGIONS

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


GLOBAL_REGION_ELEMENTS

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


GLOBAL_REGION_SOURCES

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


GLOBAL_SOIL_SOURCES

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


GLOBAL_STATISTIC_SOURCES

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


GLOBAL_SUITABILITY_PROPERTIES

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


GLOBAL_THRESHOLDS

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


GLOBAL_TIME_DIMENSIONS

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


GLOBAL_TREATMENTS

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


GLOBAL_WINDOWS

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


LINK-datasets

content
3.1 LINK_CROP_AGGREGATION
3.2 LINK_CROP_CALENDARS
3.3 LINK_CROP_PARAMETERS
3.4 LINK_CROP_PARAMETERS_CROP
3.5 LINK_CROP_PARAMETERS_MODEL
3.6 LINK_CROP_PARAMETRIZATION
3.7 LINK_CROP_SPATIALIZATIONS
3.8 LINK_CROP_STU
3.9 LINK_CROP_VARIETY_PARAMETERS
3.10 LINK_GRID_COVER
3.11 LINK_GRID_REGION_COVER
3.12 LINK_REGION_COVER
3.13 LINK_SIMULATION_UNIT
3.14 LINK_SIMULATION_UNIT_CROP
3.15 LINK_SMU_GRID_COVER
3.16 LINK_SMU_GRID_REGION_COVER
3.17 LINK_SMU_STU
3.18 LINK_STU_HORIZONS
3.19 LINK_STU_WEIGHTED_PARAMETERS
3.20 LINK_SUITABILITY_RULES




LINK_CROP_AGGREGATION

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


LINK_CROP_CALENDARS

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


LINK_CROP_PARAMETERS

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


LINK_CROP_PARAMETERS_CROP

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


LINK_CROP_PARAMETERS_MODEL

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


LINK_CROP_PARAMETRIZATION

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


LINK_CROP_SPATIALIZATIONS

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


LINK_CROP_STU

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


LINK_CROP_VARIETY_PARAMETERS

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


LINK_GRID_COVER

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


LINK_GRID_REGION_COVER

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


LINK_REGION_COVER

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


LINK_SIMULATION_UNIT

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


LINK_SIMULATION_UNIT_CROP

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


LINK_SMU_GRID_COVER

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


LINK_SMU_GRID_REGION_COVER

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


LINK_SMU_STU

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


LINK_STU_HORIZONS

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


LINK_STU_WEIGHTED_PARAMETERS

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


LINK_SUITABILITY_RULES

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


SIM-datasets

content
4.1 SIM_BLAST_HRES_GRID
4.2 SIM_BLAST_HRES_GRID_LTA
4.3 SIM_BLAST_HRES_REGION
4.4 SIM_BLAST_HRES_REGION_LTA
4.5 SIM_WARM_HRES_GRID
4.6 SIM_WARM_HRES_GRID_LTA
4.7 SIM_WARM_HRES_REGION
4.8 SIM_WARM_HRES_REGION_LTA
4.9 SIM_WOFOST_HRES_EMU
4.10 SIM_WOFOST_HRES_EMU_LTA
4.11 SIM_WOFOST_HRES_GRID
4.12 SIM_WOFOST_HRES_GRID_LTA
4.13 SIM_WOFOST_HRES_REGION
4.14 SIM_WOFOST_HRES_REGION_LTA
4.15 SIM_WOFOST_HRES_STU




SIM_BLAST_HRES_GRID

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


SIM_BLAST_HRES_GRID_LTA

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


SIM_BLAST_HRES_REGION

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


SIM_BLAST_HRES_REGION_LTA

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


SIM_WARM_HRES_GRID

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


SIM_WARM_HRES_GRID_LTA

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


SIM_WARM_HRES_REGION

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


SIM_WARM_HRES_REGION_LTA

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


SIM_WOFOST_HRES_EMU

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


SIM_WOFOST_HRES_EMU_LTA

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


SIM_WOFOST_HRES_GRID

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


SIM_WOFOST_HRES_GRID_LTA

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


SIM_WOFOST_HRES_REGION

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


SIM_WOFOST_HRES_REGION_LTA

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


SIM_WOFOST_HRES_STU

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


SOIL-datasets

content
5.1 SOIL_HORIZONS
5.2 SOIL_INITIAL_WATER
5.3 SOIL_SMU
5.4 SOIL_STU




SOIL_HORIZONS

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


SOIL_INITIAL_WATER

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


SOIL_SMU

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


SOIL_STU

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


WEATHER-datasets

content
6.1 WEATHER_ERA_GRID
6.2 WEATHER_ERA_GRID_LTA
6.3 WEATHER_ERA_REGIONCOVER
6.4 WEATHER_ERA_REGIONCOVER_LTA
6.5 WEATHER_HIS_GRID
6.6 WEATHER_HIS_REGIONCOVER
6.7 WEATHER_HRES_GRID
6.8 WEATHER_HRES_REGIONCOVER
6.9 WEATHER_OBS_GRID
6.10 WEATHER_OBS_GRID_INFO
6.11 WEATHER_OBS_GRID_LTA
6.12 WEATHER_OBS_GRID_LTA_MISS
6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD
6.14 WEATHER_OBS_REGCOV_THRESHOLDS
6.15 WEATHER_OBS_REGIONCOVER
6.16 WEATHER_OBS_REGIONCOVER_LTA
6.17 WEATHER_OBS_STATION
6.18 WEATHER_OBS_STATION_AVAIL
6.19 WEATHER_OBS_STATION_CALCULATED
6.20 WEATHER_OBS_STATION_ERRAIN
6.21 WEATHER_OBS_STATION_ERRORS
6.22 WEATHER_OBS_STATION_INFO
6.23 WEATHER_OBS_STATION_LTA
6.24 WEATHER_OBS_STATION_RAW
6.25 WEATHER_OPE_GRID
6.26 WEATHER_OPE_REGIONCOVER




WEATHER_ERA_GRID

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


WEATHER_ERA_GRID_LTA

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


WEATHER_ERA_REGIONCOVER

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


WEATHER_ERA_REGIONCOVER_LTA

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


WEATHER_HIS_GRID

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


WEATHER_HIS_REGIONCOVER

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


WEATHER_HRES_GRID

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


WEATHER_HRES_REGIONCOVER

  • Description:
  • Use:
  • Type: View
  • 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_REGCOV_LTA_THRSHLD

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


WEATHER_OBS_REGCOV_THRESHOLDS

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


WEATHER_OBS_REGIONCOVER

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


WEATHER_OBS_REGIONCOVER_LTA

  • Description: long term average interpolated weather data per administrative region per day
  • Use: Monitoring extreme weather events
  • 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_OPE_GRID

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


WEATHER_OPE_REGIONCOVER

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


other datasets

content
7.1 CGMS_SYSLOG
7.2 DATES_75_15
7.3 GRIDS
7.4 HRES_YEARS
7.5 INTERPOLATION_PARAMETERS
7.6 REGIONS
7.7 STATIONS
7.8 STAT_REGION_AREAS
7.9 SYSTABLES
7.10 TASKS
7.11 WOG
7.12 WOSC




CGMS_SYSLOG

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


DATES_75_15

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


GRIDS

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


HRES_YEARS

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


INTERPOLATION_PARAMETERS

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


REGIONS

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


STATIONS

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


STAT_REGION_AREAS

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


SYSTABLES

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


TASKS

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


WOSC

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