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

From Agri4castWiki
Jump to: navigation, search
Line 12: Line 12:
 
{{TocRow|#other datasets|7. other datasets}}
 
{{TocRow|#other datasets|7. other datasets}}
 
}}
 
}}
 +
 +
  
  
Line 29: Line 31:
 
{{TocRow|#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES}}
 
{{TocRow|#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES}}
 
}}
 
}}
 +
 +
  
  
Line 55: Line 59:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 97: Line 103:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 135: Line 143:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 163: Line 173:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 187: Line 199:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 217: Line 231:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 239: Line 255:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 265: Line 283:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 287: Line 307:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 311: Line 333:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 335: Line 359:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 359: Line 385:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== GLOBAL-datasets ==
 
== GLOBAL-datasets ==
Line 382: Line 410:
 
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
 
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
 
}}
 
}}
 +
 +
  
  
Line 412: Line 442:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 441: Line 473:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 473: Line 507:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 505: Line 541:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 546: Line 584:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 618: Line 658:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 664: Line 706:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 717: Line 761:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 746: Line 792:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 781: Line 829:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 844: Line 894:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 877: Line 929:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 906: Line 960:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 935: Line 991:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 964: Line 1,022:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,004: Line 1,064:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,051: Line 1,113:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,080: Line 1,144:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,142: Line 1,208:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== LINK-datasets ==
 
== LINK-datasets ==
Line 1,166: Line 1,234:
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
}}
 
}}
 +
 +
  
  
Line 1,224: Line 1,294:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,303: Line 1,375:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,373: Line 1,447:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,438: Line 1,514:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,503: Line 1,581:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,555: Line 1,635:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,633: Line 1,715:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,653: Line 1,737:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,733: Line 1,819:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,755: Line 1,843:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,779: Line 1,869:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,801: Line 1,893:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,838: Line 1,932:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,882: Line 1,978:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,906: Line 2,004:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,932: Line 2,032:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,954: Line 2,056:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,980: Line 2,084:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,034: Line 2,140:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,115: Line 2,223:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SIM-datasets ==
 
== SIM-datasets ==
Line 2,134: Line 2,244:
 
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
 
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
 
}}
 
}}
 +
 +
  
  
Line 2,199: Line 2,311:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,413: Line 2,527:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,477: Line 2,593:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,691: Line 2,809:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,749: Line 2,869:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,933: Line 3,055:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 2,991: Line 3,115:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,175: Line 3,301:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,235: Line 3,363:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,421: Line 3,551:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,479: Line 3,611:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,663: Line 3,797:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,721: Line 3,857:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,905: Line 4,043:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 3,967: Line 4,107:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SOIL-datasets ==
 
== SOIL-datasets ==
Line 3,975: Line 4,117:
 
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 
}}
 
}}
 +
 +
  
  
Line 4,046: Line 4,190:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,078: Line 4,224:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,100: Line 4,248:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,166: Line 4,316:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
Line 4,196: Line 4,348:
 
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
 
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
 
}}
 
}}
 +
 +
  
  
Line 4,245: Line 4,399:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,407: Line 4,563:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,457: Line 4,615:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,621: Line 4,781:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,669: Line 4,831:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,719: Line 4,883:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,873: Line 5,039:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,998: Line 5,166:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,052: Line 5,222:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,116: Line 5,288:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,250: Line 5,424:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,281: Line 5,457:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,309: Line 5,487:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,335: Line 5,515:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,381: Line 5,563:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,517: Line 5,701:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,603: Line 5,789:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,628: Line 5,816:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,659: Line 5,849:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,686: Line 5,878:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,769: Line 5,963:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,858: Line 6,054:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 5,903: Line 6,101:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,048: Line 6,248:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,100: Line 6,302:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,154: Line 6,358:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== other datasets ==
 
== other datasets ==
Line 6,170: Line 6,376:
 
{{TocRow|#WOSC|7.12 WOSC}}
 
{{TocRow|#WOSC|7.12 WOSC}}
 
}}
 
}}
 +
 +
  
  
Line 6,216: Line 6,424:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,257: Line 6,467:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,315: Line 6,527:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,339: Line 6,553:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,361: Line 6,577:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,416: Line 6,634:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,517: Line 6,737:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,551: Line 6,773:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,574: Line 6,798:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,607: Line 6,833:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 6,662: Line 6,890:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->

Revision as of 21:24, 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

Table.

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


CROP_CALENDARS

Table.

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


CROP_CALENDARS_OLD

Table.


CROP_PARAMETRIZATIONS

Table.


CROP_PARAMETRIZATION_PARAMETER

Table.


CROP_REGIMES

Table.


CROP_SPATIALIZATIONS

Table.


CROP_SUITABILITY_RULES

Table.


CROP_VARIETIES

Table.


CROP_VARIETY_PARAMETERS

Table.


CROP_VARIETY_PARAMETERS_OLD

Table.


CROP_VARIETY_REGIMES

Table.


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

Materialized_View.


GLOBAL_COVERS

View.


GLOBAL_COVER_SOURCES

View.


GLOBAL_CROPS

View.


GLOBAL_CROP_PARAMETERS

Materialized_View.


GLOBAL_GRIDS

View.


GLOBAL_GRID_SOURCES

View.


GLOBAL_LINK_COVERWINDOW_SOURCE

View.


GLOBAL_MODELS

View.


GLOBAL_REGIONS

View.


GLOBAL_REGION_ELEMENTS

View.


GLOBAL_REGION_SOURCES

View.


GLOBAL_SOIL_SOURCES

View.


GLOBAL_STATISTIC_SOURCES

View.


GLOBAL_SUITABILITY_PROPERTIES

View.


GLOBAL_THRESHOLDS

View.


GLOBAL_TIME_DIMENSIONS

View.


GLOBAL_TREATMENTS

View.


GLOBAL_WINDOWS

View.


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

View.


LINK_CROP_CALENDARS

View.


LINK_CROP_PARAMETERS

Materialized_View.


LINK_CROP_PARAMETERS_CROP

Materialized_View.


LINK_CROP_PARAMETERS_MODEL

Materialized_View.


LINK_CROP_PARAMETRIZATION

View.


LINK_CROP_SPATIALIZATIONS

View.


LINK_CROP_STU

Table.


LINK_CROP_VARIETY_PARAMETERS

View.


LINK_GRID_COVER

Table.


LINK_GRID_REGION_COVER

Table.


LINK_REGION_COVER

Table.


LINK_SIMULATION_UNIT

View.


LINK_SIMULATION_UNIT_CROP

View.


LINK_SMU_GRID_COVER

Table.


LINK_SMU_GRID_REGION_COVER

Table.


LINK_SMU_STU

Table.


LINK_STU_HORIZONS

Table.


LINK_STU_WEIGHTED_PARAMETERS

View.


LINK_SUITABILITY_RULES

View.


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

Table.


SIM_BLAST_HRES_GRID_LTA

Table.


SIM_BLAST_HRES_REGION

Table.


SIM_BLAST_HRES_REGION_LTA

Table.


SIM_WARM_HRES_GRID

Table.


SIM_WARM_HRES_GRID_LTA

Table.


SIM_WARM_HRES_REGION

Table.


SIM_WARM_HRES_REGION_LTA

Table.


SIM_WOFOST_HRES_EMU

Table.


SIM_WOFOST_HRES_EMU_LTA

Table.


SIM_WOFOST_HRES_GRID

Table.


SIM_WOFOST_HRES_GRID_LTA

Table.


SIM_WOFOST_HRES_REGION

Table.


SIM_WOFOST_HRES_REGION_LTA

Table.


SIM_WOFOST_HRES_STU

Table.


SOIL-datasets

content
5.1 SOIL_HORIZONS
5.2 SOIL_INITIAL_WATER
5.3 SOIL_SMU
5.4 SOIL_STU




SOIL_HORIZONS

Table.


SOIL_INITIAL_WATER

Table.


SOIL_SMU

Table.


SOIL_STU

Table.


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

Table.


WEATHER_ERA_GRID_LTA

Table.


WEATHER_ERA_REGIONCOVER

Table.


WEATHER_ERA_REGIONCOVER_LTA

Table.


WEATHER_HIS_GRID

Table.


WEATHER_HIS_REGIONCOVER

Table.


WEATHER_HRES_GRID

View.


WEATHER_HRES_REGIONCOVER

View.


WEATHER_OBS_GRID

Table.

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


WEATHER_OBS_GRID_INFO

Table.

  • Description:
  • Use:
  • Type: Permanent table


WEATHER_OBS_GRID_LTA

Table.

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


WEATHER_OBS_GRID_LTA_MISS

Table.

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


WEATHER_OBS_REGCOV_LTA_THRSHLD

Table.


WEATHER_OBS_REGCOV_THRESHOLDS

Table.


WEATHER_OBS_REGIONCOVER

Table.

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


WEATHER_OBS_REGIONCOVER_LTA

Table.

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


WEATHER_OBS_STATION

Table.

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


WEATHER_OBS_STATION_AVAIL

Table.

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


WEATHER_OBS_STATION_CALCULATED

Table.

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


WEATHER_OBS_STATION_ERRAIN

Table.

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


WEATHER_OBS_STATION_ERRORS

Table.

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


WEATHER_OBS_STATION_INFO

Table.

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


WEATHER_OBS_STATION_LTA

Table.

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


WEATHER_OBS_STATION_RAW

Table.

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


WEATHER_OPE_GRID

Table.


WEATHER_OPE_REGIONCOVER

Table.


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

Table.

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


DATES_75_15

Table.

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


GRIDS

View.


HRES_YEARS

View.


INTERPOLATION_PARAMETERS

Table.


REGIONS

View.


STATIONS

View.


STAT_REGION_AREAS

Table.


SYSTABLES

Table.

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


TASKS

Table.

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


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 WEATHER_OBS_GRID.
  • Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


WOSC

Table.