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

From Agri4castWiki
Jump to: navigation, search
(SOIL-datasets)
(generated tocs)
Line 1: Line 1:
 +
 +
 
__NOTOC__
 
__NOTOC__
* [[#CROP|1. CROP]]
+
{{TocTable|content=
* [[#GLOBAL|2. GLOBAL]]
+
{{TocRow|#CROP-datasets|1. CROP-datasets}}
* [[#LINK|3. LINK]]
+
{{TocRow|#GLOBAL-datasets|2. GLOBAL-datasets}}
* [[#SIM|4. SIM]]
+
{{TocRow|#LINK-datasets|3. LINK-datasets}}
* [[#SOIL|5. SOIL]]
+
{{TocRow|#SIM-datasets|4. SIM-datasets}}
* [[#WEATHER|6. WEATHER]]
+
{{TocRow|#SOIL-datasets|5. SOIL-datasets}}
* [[#other datasets|7. other datasets]]
+
{{TocRow|#WEATHER-datasets|6. WEATHER-datasets}}
 +
{{TocRow|#other datasets|7. other datasets}}
 +
}}
 +
 
  
 
== CROP-datasets ==
 
== CROP-datasets ==
* [[#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS]]
+
{{TocTable|content=
* [[#CROP_CALENDARS|1.2 CROP_CALENDARS]]
+
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
* [[#CROP_CALENDARS_OLD|1.3 CROP_CALENDARS_OLD]]
+
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
* [[#CROP_PARAMETRIZATIONS|1.4 CROP_PARAMETRIZATIONS]]
+
{{TocRow|#CROP_CALENDARS_OLD|1.3 CROP_CALENDARS_OLD}}
* [[#CROP_PARAMETRIZATION_PARAMETER|1.5 CROP_PARAMETRIZATION_PARAMETER]]
+
{{TocRow|#CROP_PARAMETRIZATIONS|1.4 CROP_PARAMETRIZATIONS}}
* [[#CROP_REGIMES|1.6 CROP_REGIMES]]
+
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.5 CROP_PARAMETRIZATION_PARAMETER}}
* [[#CROP_SPATIALIZATIONS|1.7 CROP_SPATIALIZATIONS]]
+
{{TocRow|#CROP_REGIMES|1.6 CROP_REGIMES}}
* [[#CROP_SUITABILITY_RULES|1.8 CROP_SUITABILITY_RULES]]
+
{{TocRow|#CROP_SPATIALIZATIONS|1.7 CROP_SPATIALIZATIONS}}
* [[#CROP_VARIETIES|1.9 CROP_VARIETIES]]
+
{{TocRow|#CROP_SUITABILITY_RULES|1.8 CROP_SUITABILITY_RULES}}
* [[#CROP_VARIETY_PARAMETERS|1.10 CROP_VARIETY_PARAMETERS]]
+
{{TocRow|#CROP_VARIETIES|1.9 CROP_VARIETIES}}
* [[#CROP_VARIETY_PARAMETERS_OLD|1.11 CROP_VARIETY_PARAMETERS_OLD]]
+
{{TocRow|#CROP_VARIETY_PARAMETERS|1.10 CROP_VARIETY_PARAMETERS}}
* [[#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES]]
+
{{TocRow|#CROP_VARIETY_PARAMETERS_OLD|1.11 CROP_VARIETY_PARAMETERS_OLD}}
 +
{{TocRow|#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->
Line 352: Line 360:
  
 
== GLOBAL-datasets ==
 
== GLOBAL-datasets ==
* [[#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES]]
+
{{TocTable|content=
* [[#GLOBAL_COVERS|2.2 GLOBAL_COVERS]]
+
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
* [[#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES]]
+
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
* [[#GLOBAL_CROPS|2.4 GLOBAL_CROPS]]
+
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
* [[#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS]]
+
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
* [[#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS]]
+
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
* [[#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES]]
+
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
* [[#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE]]
+
{{TocRow|#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES}}
* [[#GLOBAL_MODELS|2.9 GLOBAL_MODELS]]
+
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE}}
* [[#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS]]
+
{{TocRow|#GLOBAL_MODELS|2.9 GLOBAL_MODELS}}
* [[#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS]]
+
{{TocRow|#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS}}
* [[#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES]]
+
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS}}
* [[#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES]]
+
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
* [[#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES]]
+
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
* [[#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES]]
+
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES}}
* [[#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS]]
+
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES}}
* [[#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS]]
+
{{TocRow|#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS}}
* [[#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS]]
+
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS}}
* [[#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS]]
+
{{TocRow|#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS}}
 +
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->
Line 1,112: Line 1,123:
  
 
== LINK-datasets ==
 
== LINK-datasets ==
* [[#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION]]
+
{{TocTable|content=
* [[#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS]]
+
{{TocRow|#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION}}
* [[#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS]]
+
{{TocRow|#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS}}
* [[#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP]]
+
{{TocRow|#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS}}
* [[#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL]]
+
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP}}
* [[#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION]]
+
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL}}
* [[#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS]]
+
{{TocRow|#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION}}
* [[#LINK_CROP_STU|3.8 LINK_CROP_STU]]
+
{{TocRow|#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS}}
* [[#LINK_CROP_VARIETY_PARAMETERS|3.9 LINK_CROP_VARIETY_PARAMETERS]]
+
{{TocRow|#LINK_CROP_STU|3.8 LINK_CROP_STU}}
* [[#LINK_GRID_COVER|3.10 LINK_GRID_COVER]]
+
{{TocRow|#LINK_CROP_VARIETY_PARAMETERS|3.9 LINK_CROP_VARIETY_PARAMETERS}}
* [[#LINK_GRID_REGION_COVER|3.11 LINK_GRID_REGION_COVER]]
+
{{TocRow|#LINK_GRID_COVER|3.10 LINK_GRID_COVER}}
* [[#LINK_REGION_COVER|3.12 LINK_REGION_COVER]]
+
{{TocRow|#LINK_GRID_REGION_COVER|3.11 LINK_GRID_REGION_COVER}}
* [[#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT]]
+
{{TocRow|#LINK_REGION_COVER|3.12 LINK_REGION_COVER}}
* [[#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP]]
+
{{TocRow|#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT}}
* [[#LINK_SMU_GRID_COVER|3.15 LINK_SMU_GRID_COVER]]
+
{{TocRow|#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP}}
* [[#LINK_SMU_GRID_REGION_COVER|3.16 LINK_SMU_GRID_REGION_COVER]]
+
{{TocRow|#LINK_SMU_GRID_COVER|3.15 LINK_SMU_GRID_COVER}}
* [[#LINK_SMU_STU|3.17 LINK_SMU_STU]]
+
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.16 LINK_SMU_GRID_REGION_COVER}}
* [[#LINK_STU_HORIZONS|3.18 LINK_STU_HORIZONS]]
+
{{TocRow|#LINK_SMU_STU|3.17 LINK_SMU_STU}}
* [[#LINK_STU_WEIGHTED_PARAMETERS|3.19 LINK_STU_WEIGHTED_PARAMETERS]]
+
{{TocRow|#LINK_STU_HORIZONS|3.18 LINK_STU_HORIZONS}}
* [[#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES]]
+
{{TocRow|#LINK_STU_WEIGHTED_PARAMETERS|3.19 LINK_STU_WEIGHTED_PARAMETERS}}
 +
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->
Line 2,000: Line 2,014:
  
 
== SIM-datasets ==
 
== SIM-datasets ==
* [[#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID]]
+
{{TocTable|content=
* [[#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA]]
+
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
* [[#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION]]
+
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
* [[#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA]]
+
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
* [[#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID]]
+
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
* [[#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA]]
+
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
* [[#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION]]
+
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
* [[#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA]]
+
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
* [[#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU]]
+
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
* [[#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA]]
+
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
* [[#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID]]
+
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
* [[#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA]]
+
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
* [[#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION]]
+
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
* [[#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA]]
+
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
* [[#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU]]
+
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->
Line 3,850: Line 3,867:
 
== SOIL-datasets ==
 
== SOIL-datasets ==
 
{{TocTable|content=
 
{{TocTable|content=
| style="border-style: None"| [[#SOIL_HORIZONS|5.1 SOIL_HORIZONS]]
+
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
|-
+
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
| style="border-style: None"| [[#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER]]
+
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
|-
+
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
| style="border-style: None"|[[#SOIL_SMU|5.3 SOIL_SMU]]
 
|-
 
| style="border-style: None"| [[#SOIL_STU|5.4 SOIL_STU]]
 
|-
 
 
}}
 
}}
 +
  
 
<!-- start -->
 
<!-- start -->
Line 4,051: Line 4,065:
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
* [[#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID]]
+
{{TocTable|content=
* [[#WEATHER_ERA_GRID_LTA|6.2 WEATHER_ERA_GRID_LTA]]
+
{{TocRow|#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID}}
* [[#WEATHER_ERA_REGIONCOVER|6.3 WEATHER_ERA_REGIONCOVER]]
+
{{TocRow|#WEATHER_ERA_GRID_LTA|6.2 WEATHER_ERA_GRID_LTA}}
* [[#WEATHER_ERA_REGIONCOVER_LTA|6.4 WEATHER_ERA_REGIONCOVER_LTA]]
+
{{TocRow|#WEATHER_ERA_REGIONCOVER|6.3 WEATHER_ERA_REGIONCOVER}}
* [[#WEATHER_HIS_GRID|6.5 WEATHER_HIS_GRID]]
+
{{TocRow|#WEATHER_ERA_REGIONCOVER_LTA|6.4 WEATHER_ERA_REGIONCOVER_LTA}}
* [[#WEATHER_HIS_REGIONCOVER|6.6 WEATHER_HIS_REGIONCOVER]]
+
{{TocRow|#WEATHER_HIS_GRID|6.5 WEATHER_HIS_GRID}}
* [[#WEATHER_HRES_GRID|6.7 WEATHER_HRES_GRID]]
+
{{TocRow|#WEATHER_HIS_REGIONCOVER|6.6 WEATHER_HIS_REGIONCOVER}}
* [[#WEATHER_HRES_REGIONCOVER|6.8 WEATHER_HRES_REGIONCOVER]]
+
{{TocRow|#WEATHER_HRES_GRID|6.7 WEATHER_HRES_GRID}}
* [[#WEATHER_OBS_GRID|6.9 WEATHER_OBS_GRID]]
+
{{TocRow|#WEATHER_HRES_REGIONCOVER|6.8 WEATHER_HRES_REGIONCOVER}}
* [[#WEATHER_OBS_GRID_INFO|6.10 WEATHER_OBS_GRID_INFO]]
+
{{TocRow|#WEATHER_OBS_GRID|6.9 WEATHER_OBS_GRID}}
* [[#WEATHER_OBS_GRID_LTA|6.11 WEATHER_OBS_GRID_LTA]]
+
{{TocRow|#WEATHER_OBS_GRID_INFO|6.10 WEATHER_OBS_GRID_INFO}}
* [[#WEATHER_OBS_GRID_LTA_MISS|6.12 WEATHER_OBS_GRID_LTA_MISS]]
+
{{TocRow|#WEATHER_OBS_GRID_LTA|6.11 WEATHER_OBS_GRID_LTA}}
* [[#WEATHER_OBS_REGCOV_LTA_THRSHLD|6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD]]
+
{{TocRow|#WEATHER_OBS_GRID_LTA_MISS|6.12 WEATHER_OBS_GRID_LTA_MISS}}
* [[#WEATHER_OBS_REGCOV_THRESHOLDS|6.14 WEATHER_OBS_REGCOV_THRESHOLDS]]
+
{{TocRow|#WEATHER_OBS_REGCOV_LTA_THRSHLD|6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD}}
* [[#WEATHER_OBS_REGIONCOVER|6.15 WEATHER_OBS_REGIONCOVER]]
+
{{TocRow|#WEATHER_OBS_REGCOV_THRESHOLDS|6.14 WEATHER_OBS_REGCOV_THRESHOLDS}}
* [[#WEATHER_OBS_REGIONCOVER_LTA|6.16 WEATHER_OBS_REGIONCOVER_LTA]]
+
{{TocRow|#WEATHER_OBS_REGIONCOVER|6.15 WEATHER_OBS_REGIONCOVER}}
* [[#WEATHER_OBS_STATION|6.17 WEATHER_OBS_STATION]]
+
{{TocRow|#WEATHER_OBS_REGIONCOVER_LTA|6.16 WEATHER_OBS_REGIONCOVER_LTA}}
* [[#WEATHER_OBS_STATION_AVAIL|6.18 WEATHER_OBS_STATION_AVAIL]]
+
{{TocRow|#WEATHER_OBS_STATION|6.17 WEATHER_OBS_STATION}}
* [[#WEATHER_OBS_STATION_CALCULATED|6.19 WEATHER_OBS_STATION_CALCULATED]]
+
{{TocRow|#WEATHER_OBS_STATION_AVAIL|6.18 WEATHER_OBS_STATION_AVAIL}}
* [[#WEATHER_OBS_STATION_ERRAIN|6.20 WEATHER_OBS_STATION_ERRAIN]]
+
{{TocRow|#WEATHER_OBS_STATION_CALCULATED|6.19 WEATHER_OBS_STATION_CALCULATED}}
* [[#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS]]
+
{{TocRow|#WEATHER_OBS_STATION_ERRAIN|6.20 WEATHER_OBS_STATION_ERRAIN}}
* [[#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO]]
+
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS}}
* [[#WEATHER_OBS_STATION_LTA|6.23 WEATHER_OBS_STATION_LTA]]
+
{{TocRow|#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO}}
* [[#WEATHER_OBS_STATION_RAW|6.24 WEATHER_OBS_STATION_RAW]]
+
{{TocRow|#WEATHER_OBS_STATION_LTA|6.23 WEATHER_OBS_STATION_LTA}}
* [[#WEATHER_OPE_GRID|6.25 WEATHER_OPE_GRID]]
+
{{TocRow|#WEATHER_OBS_STATION_RAW|6.24 WEATHER_OBS_STATION_RAW}}
* [[#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER]]
+
{{TocRow|#WEATHER_OPE_GRID|6.25 WEATHER_OPE_GRID}}
 +
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->
Line 6,036: Line 6,053:
  
 
== other datasets ==
 
== other datasets ==
* [[#GRIDS|7.1 GRIDS]]
+
{{TocTable|content=
* [[#REGIONS|7.2 REGIONS]]
+
{{TocRow|#GRIDS|7.1 GRIDS}}
* [[#STATIONS|7.3 STATIONS]]
+
{{TocRow|#REGIONS|7.2 REGIONS}}
* [[#SYSTABLES|7.4 SYSTABLES]]
+
{{TocRow|#STATIONS|7.3 STATIONS}}
* [[#TASKS|7.5 TASKS]]
+
{{TocRow|#SYSTABLES|7.4 SYSTABLES}}
* [[#WOG|7.6 WOG]]
+
{{TocRow|#TASKS|7.5 TASKS}}
* [[#WOSC|7.7 WOSC]]
+
{{TocRow|#WOG|7.6 WOG}}
* [[#CGMS_SYSLOG|7.8 CGMS_SYSLOG]]
+
{{TocRow|#WOSC|7.7 WOSC}}
* [[#DATES_75_15|7.9 DATES_75_15]]
+
{{TocRow|#CGMS_SYSLOG|7.8 CGMS_SYSLOG}}
* [[#HRES_YEARS|7.10 HRES_YEARS]]
+
{{TocRow|#DATES_75_15|7.9 DATES_75_15}}
* [[#INTERPOLATION_PARAMETERS|7.11 INTERPOLATION_PARAMETERS]]
+
{{TocRow|#HRES_YEARS|7.10 HRES_YEARS}}
* [[#STAT_REGION_AREAS|7.12 STAT_REGION_AREAS]]
+
{{TocRow|#INTERPOLATION_PARAMETERS|7.11 INTERPOLATION_PARAMETERS}}
 +
{{TocRow|#STAT_REGION_AREAS|7.12 STAT_REGION_AREAS}}
 +
}}
 +
 
  
 
<!-- start -->
 
<!-- start -->

Revision as of 16:50, 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

Table.

GLOBAL_COVERS

View.

GLOBAL_COVER_SOURCES

View.

GLOBAL_CROPS

View.

GLOBAL_CROP_PARAMETERS

Table.

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

Table.

LINK_CROP_PARAMETERS_CROP

Table.

LINK_CROP_PARAMETERS_MODEL

Table.

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 GRIDS
7.2 REGIONS
7.3 STATIONS
7.4 SYSTABLES
7.5 TASKS
7.6 WOG
7.7 WOSC
7.8 CGMS_SYSLOG
7.9 DATES_75_15
7.10 HRES_YEARS
7.11 INTERPOLATION_PARAMETERS
7.12 STAT_REGION_AREAS



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.