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

From Agri4castWiki
Jump to: navigation, search
(CROP_PARAMETRIZATION_PARAMETER)
 
(14 intermediate revisions by the same user not shown)
Line 38: Line 38:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || False || NUMBER || ||  
+
| IDCROP_AGGREGATION || False || NUMBER || - || identifier for aggregated crop
 
|-
 
|-
| IDCROP || False || NUMBER || ||  
+
| IDCROP || False || NUMBER || - || identifier to link statistical crop (EUROSTAT)
 
|-
 
|-
| IDCROP_PARAMETRIZATION || False || NUMBER || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
 
|}
 
|}
Line 65: Line 65:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
|-
 
| IDGRID || False || NUMBER ||  ||  
 
 
|-
 
|-
| YEAR || False || NUMBER || - || calendar year
+
| IDGRID || False || NUMBER || - || identifier for agro-climatic grid
 
|-
 
|-
| START_PERIOD || False || VARCHAR2 || ||  
+
| YEAR || False || NUMBER || - || calendar year (year of sowing/emergence)
 
|-
 
|-
| END_PERIOD || False || VARCHAR2 || ||  
+
| START_EVENT || False || VARCHAR2 || - || identifier for start event (SOWING, EMERGENCE)
 
|-
 
|-
| EMERGENCE || True || DATE || ||  
+
| END_EVENT || False || VARCHAR2 || - || identifier for end event (MATURITY, HARVESTING)
 
|-
 
|-
| SOWING || True || DATE ||  ||  
+
| EMERGENCE || True || DATE ||  || date of emergence
 
|-
 
|-
| HARVESTING || True || DATE ||  ||  
+
| SOWING || True || DATE ||  || date of sowing
 
|-
 
|-
| MATURITY || True || DATE ||  ||  
+
| HARVESTING || True || DATE ||  || date of harvesting
 
|-
 
|-
| DURATION || True || NUMBER ||  ||  
+
| MATURITY || True || DATE ||  || date of maturity
 
|-
 
|-
| START_DOY || True || NUMBER || ||  
+
| WINDOW_DURATION || True || NUMBER || days || maximum duration of the season
 
|-
 
|-
 
|}
 
|}
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br>
+
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br>
&lt;nowiki>**&lt;/nowiki> possible values: HARVEST, MATURITY, EARLIEST (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
+
<nowiki>**</nowiki> possible values: HARVEST or MATURITY (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 96: Line 94:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_PARAMETRIZATIONS ===
 
=== CROP_PARAMETRIZATIONS ===
 
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
 
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
Line 108: Line 107:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || False || NUMBER || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
| IDMODEL || False || NUMBER || ||  
+
| IDMODEL || False || NUMBER || - || identifier for crop model
 
|-
 
|-
| IDCOVER || False || NUMBER || ||  
+
| IDCOVER || False || NUMBER || - || identifier for linked landcover/cropmask
 
|-
 
|-
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N || switch to enable/disable parametrization simulations
 
|-
 
|-
| VIEWER_ENABLED || False || VARCHAR2 || Y/N ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N || switch to enable/disable parametrization in viewer
 
|-
 
|-
| CROP_PARAMETRIZATION || False || VARCHAR2 || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| DESCRIPTOR || True || VARCHAR2 || ||  
+
| DESCRIPTOR || True || VARCHAR2 || - || description for simulated crop
 
|-
 
|-
 
| TAG || True || VARCHAR2 ||  ||  
 
| TAG || True || VARCHAR2 ||  ||  
Line 146: Line 145:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || False || NUMBER || || crop number
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDCROP_PARAMETER || False || NUMBER || || parameter number
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
 
| XVALUE || False || NUMBER || depending on parameter || parameter x-value
 
| XVALUE || False || NUMBER || depending on parameter || parameter x-value
Line 359: Line 358:
 
{{TocRow|#GLOBAL_WINDOWS|2.21 GLOBAL_WINDOWS}}
 
{{TocRow|#GLOBAL_WINDOWS|2.21 GLOBAL_WINDOWS}}
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
Line 1,330: Line 1,326:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== LINK-datasets ==
 
== LINK-datasets ==
Line 1,356: Line 1,350:
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_AGGREGATION ===
 
=== LINK_CROP_AGGREGATION ===
* Description:  
+
* Description: relation between simulated crop parameterizations and crop aggregation areas.
 
* Use:  
 
* Use:  
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: One simulated crop parametetrization can be combined with multiple aggregation areas to create alternative aggregated crops. The object contains records from {{Object|CROP_AGGREGATIONS}}, with extra descriptive fields.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,373: Line 1,364:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_AGGREGATION || False || NUMBER || ||  
+
| IDCROP_AGGREGATION || False || NUMBER || - || aggregated crop number
 
|-
 
|-
| IDCROP || False || NUMBER || ||  
+
| IDCROP || False || NUMBER || - || global crop number
 
|-
 
|-
| CROP || False || VARCHAR2 || ||  
+
| CROP || False || VARCHAR2 || - || global crop name
 
|-
 
|-
| CROP_DESCRIPTOR || False || VARCHAR2 || ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 || - || global crop description
 
|-
 
|-
| IDMODEL || False || NUMBER || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || False || VARCHAR2 || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| MODEL_DESCRIPTOR || False || VARCHAR2 || ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 || - || crop model description
 
|-
 
|-
| IDCROP_PARAMETRIZATION || False || NUMBER || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || simulated crop number
 
|-
 
|-
| CROP_PARAMETRIZATION || False || VARCHAR2 || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 || ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 || - || simulated crop description
 
|-
 
|-
 
|}
 
|}
Line 1,422: Line 1,413:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_CALENDARS ===
 
=== LINK_CROP_CALENDARS ===
 
* Description:  
 
* Description:  
Line 2,201: Line 2,193:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_SMU_STU ===
 
=== LINK_SMU_STU ===
* Description:  
+
* Description: Relative area of each STU inside a SMU.
* Use:  
+
* Use: used to find unique simulation units in elementary mapping units (see [[Spatial_schematization]]).
 
* Type: ''Table''
 
* Type: ''Table''
* Remarks:  
+
* Remarks: The total percentage per SMU adds up to 100%.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,212: Line 2,204:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSMU || False || NUMBER || ||  
+
| IDSMU || False || NUMBER || - || unique identifier for the soil map unit
 
|-
 
|-
| IDSTU || False || NUMBER || ||  
+
| IDSTU || False || NUMBER || - || identifier to the soil typologic unit
 
|-
 
|-
| PERCENTAGE || False || NUMBER || ||  
+
| PERCENTAGE || False || NUMBER || - || % of area inside the SMU, covered by the STU
 
|-
 
|-
 
|}
 
|}
Line 2,223: Line 2,215:
 
<!-- end -->
 
<!-- end -->
  
 +
<!-- start -->
  
 
<!-- start -->
 
 
=== LINK_STU_HORIZONS ===
 
=== LINK_STU_HORIZONS ===
 
* Description:  
 
* Description:  
Line 2,395: Line 2,386:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== SIM-datasets ==
 
== SIM-datasets ==
Line 4,435: Line 4,424:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_SMU ===
 
=== SOIL_SMU ===
* Description:  
+
* Description: Spatially available unique Soil Map Units (SMU's).
* Use:  
+
* Use: The soil map units are one of the layers used in the [[Spatial_schematization]]
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 4,446: Line 4,435:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSMU || False || NUMBER || ||  
+
| IDSMU || False || NUMBER || - || unique identifier for the soil map unit
 
|-
 
|-
| IDORIGINAL_CODE || False || VARCHAR2 || ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 || - || legacy identifier
 
|-
 
|-
| IDSOIL_SOURCE || False || NUMBER || ||  
+
| IDSOIL_SOURCE || False || NUMBER || - || soil source number
 
|-
 
|-
 
|}
 
|}
Line 4,460: Line 4,449:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== SOIL_STU ===
 
=== SOIL_STU ===
* Description:  
+
* Description: distinct soil types that have been identified and described by attributes (variables) specifying the nature and properties of the soils (e.g. name, texture, the moisture regime, the stoniness, depth to bedrock etc.).
 
* Use:  
 
* Use:  
 
* Type: ''Table''
 
* Type: ''Table''
Line 4,472: Line 4,462:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || False || NUMBER || ||  
+
| IDSTU || False || NUMBER || - || unique identifier for soil typologic unit
 
|-
 
|-
| IDORIGINAL_CODE || False || VARCHAR2 || ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 || - || legacy identifier
 
|-
 
|-
| IDSOIL_SOURCE || False || NUMBER || ||  
+
| IDSOIL_SOURCE || False || NUMBER || - || soil source number
 
|-
 
|-
| STU || False || VARCHAR2 || ||  
+
| STU || False || VARCHAR2 || - || resulution
 
|-
 
|-
| DESCRIPTOR || False || VARCHAR2 || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || resolution description
 
|-
 
|-
| SOIL_WRB || True || VARCHAR2 || ||  
+
| SOIL_WRB || True || VARCHAR2 || - || World Reference Base soil code
 
|-
 
|-
| SOIL_WRB_CL || True || VARCHAR2 || ||  
+
| SOIL_WRB_CL || True || VARCHAR2 || - || World Reference Base soil code
 
|-
 
|-
| SOIL_FAO90 || True || VARCHAR2 || ||  
+
| SOIL_FAO90 || True || VARCHAR2 || - || FAO 1990 soil code
 
|-
 
|-
| SOIL_FAO90_CL || True || VARCHAR2 || ||  
+
| SOIL_FAO90_CL || True || VARCHAR2 || - || FAO 1990 soil code
 
|-
 
|-
| SOIL_FAO85 || True || VARCHAR2 || ||  
+
| SOIL_FAO85 || True || VARCHAR2 || - || FAO 1985 soil code
 
|-
 
|-
| SOIL_FAO85_CL || True || VARCHAR2 || ||  
+
| SOIL_FAO85_CL || True || VARCHAR2 || - || FAO 1985 soil code
 
|-
 
|-
| SLOPE || True || VARCHAR2 || ||  
+
| SLOPE || True || VARCHAR2 || - || slope
 
|-
 
|-
| TEXTURE || True || VARCHAR2 || ||  
+
| TEXTURE || True || VARCHAR2 || - || texture of the soil
 
|-
 
|-
| PHASE || True || VARCHAR2 || ||  
+
| PHASE || True || VARCHAR2 || - || agricultural limitation
 
|-
 
|-
| LAYERS || True || NUMBER || ||  
+
| LAYERS || True || NUMBER || - || number of soil layers
 
|-
 
|-
| CALCULATED_ROOTING_DEPTH || True || NUMBER || ||  
+
| CALCULATED_ROOTING_DEPTH || True || NUMBER || - || rooting depth class
 
|-
 
|-
| DRAINAGE || True || NUMBER || ||  
+
| DRAINAGE || True || NUMBER || - || the drainage of the soil
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE1 || True || NUMBER || ||  
+
| LIMITATION_TO_AGRIC_USE1 || True || NUMBER || - || first limitation for agricultural usage
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE2 || True || NUMBER || ||  
+
| LIMITATION_TO_AGRIC_USE2 || True || NUMBER || - || second limitation for agricultural usage
 
|-
 
|-
| OBSTACLE_TO_ROOTS || True || NUMBER || ||  
+
| OBSTACLE_TO_ROOTS || True || NUMBER || - || obstacle to root
 
|-
 
|-
| IMPERMEABLE_DEPTH_LAYER || True || NUMBER || ||  
+
| IMPERMEABLE_DEPTH_LAYER || True || NUMBER || - || impermeable layer number
 
|-
 
|-
| SOIL_WATER_REGIME || True || NUMBER || ||  
+
| SOIL_WATER_REGIME || True || NUMBER || - || soil water regime
 
|-
 
|-
| DEPTH_TO_BEDROCK || True || VARCHAR2 || ||  
+
| DEPTH_TO_BEDROCK || True || VARCHAR2 || - || depth to bedrock
 
|-
 
|-
| SOIL_FAO74 || True || VARCHAR2 || ||  
+
| SOIL_FAO74 || True || VARCHAR2 || - || FAO 1974 soil code
 
|-
 
|-
| SOIL_FAO74_CL || True || VARCHAR2 || ||  
+
| SOIL_FAO74_CL || True || VARCHAR2 || - || FAO 1974 soil code
 
|-
 
|-
 
|}
 
|}
Line 4,526: Line 4,516:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
Line 7,139: Line 7,127:
 
<!-- start -->
 
<!-- start -->
 
=== STAT_REGION_AREAS ===
 
=== STAT_REGION_AREAS ===
* Description:  
+
* Description: year specific crop areas for aggregated crops, their source and calculation method.
* Use:  
+
* Use: Used to aggregate simulated crop results to aggregated crops
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 7,150: Line 7,138:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP || False || NUMBER || ||  
+
| IDCROP || False || NUMBER || - || aggregated crop number
 
|-
 
|-
| IDREGION || False || VARCHAR2 || ||  
+
| IDREGION || False || VARCHAR2 || - || region number
 
|-
 
|-
| YEAR || False || NUMBER || ||  
+
| YEAR || False || NUMBER || - || year for which the area is valid
 
|-
 
|-
| IDSTATISTIC_SOURCE || False || NUMBER || ||  
+
| IDSTATISTIC_SOURCE || False || NUMBER || - || source of the area
 
|-
 
|-
| IDTREATMENT || False || NUMBER || ||  
+
| IDTREATMENT || False || NUMBER || - || method how area is derived
 
|-
 
|-
| AREA_CALCULATED || False || NUMBER || ||  
+
| AREA_CALCULATED || False || NUMBER || - || area expressed as fraction of the total area of the region
 
|-
 
|-
| AREA_ORIGINAL || True || NUMBER || ||  
+
| AREA_ORIGINAL || True || NUMBER || - || column to keep original area_calculated incase area_calculated is manually updated
 
|-
 
|-
| NOTE || True || VARCHAR2 || ||  
+
| NOTE || True || VARCHAR2 || - || optional column for comments
 
|-
 
|-
| ELABORATION || False || DATE || ||  
+
| ELABORATION || False || DATE || - || date when area_calculated was calculated
 
|-
 
|-
 
|}
 
|}
Line 7,176: Line 7,164:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== SYSTABLES ===
 
=== SYSTABLES ===
 
* Description:  
 
* Description:  

Latest revision as of 14:40, 8 March 2019




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_PARAMETRIZATIONS
1.4 CROP_PARAMETRIZATION_PARAMETER
1.5 CROP_REGIMES
1.6 CROP_SPATIALIZATIONS
1.7 CROP_SUITABILITY_RULES
1.8 CROP_VARIETIES
1.9 CROP_VARIETY_PARAMETERS
1.10 CROP_VARIETY_REGIMES


CROP_AGGREGATIONS

  • Description: Link between simulated and aggregated crops.
  • Use: To aggregate simulation results at EMU resolution (IDCROP_PARAMETRIZATION) to regional resolution (IDCROP_AGGREGATION). A single simulated crop (IDCROP_PARAMETERIZATION) can be aggregated to different aggregated crops (IDCROP_AGGREGATION) using different aggregation areas.
  • 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_PARAMETRIZATIONS

  • Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
  • Use:
  • Type: Table
  • Remarks:



CROP_PARAMETRIZATION_PARAMETER

  • Description: crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Table
  • Remarks:


CROP_REGIMES

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


CROP_SPATIALIZATIONS

  • Description: Storing for each grid and crop the variety that should be used to simulate the crop
  • Use: used for calibrations, the find the grid belonging to a variety and calibrating variety specific crop parameters. Used in in simulations to find variety specific crop parameter values.
  • Type: Table
  • Remarks: usually the spatial coverage per crop is the same is in object CROP_CALENDARS, except now without the season identifier. The specified spatial variety is static over years.



CROP_SUITABILITY_RULES

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


CROP_VARIETIES

  • Description: list of all unique valrieties
  • Use: lookup table for various link_* objects.
  • Type: Table
  • Remarks:



CROP_VARIETY_PARAMETERS

  • 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_EVENTS
2.7 GLOBAL_GRIDS
2.8 GLOBAL_GRID_SOURCES
2.9 GLOBAL_LINK_COVERWINDOW_SOURCE
2.10 GLOBAL_MODELS
2.11 GLOBAL_REGIONS
2.12 GLOBAL_REGION_ELEMENTS
2.13 GLOBAL_REGION_SOURCES
2.14 GLOBAL_SOIL_SOURCES
2.15 GLOBAL_STATIONS
2.16 GLOBAL_STATISTIC_SOURCES
2.17 GLOBAL_SUITABILITY_PROPERTIES
2.18 GLOBAL_THRESHOLDS
2.19 GLOBAL_TIME_DIMENSIONS
2.20 GLOBAL_TREATMENTS
2.21 GLOBAL_WINDOWS


GLOBAL_CATEGORIES

  • Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
  • 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: snapshot table for snapshot GLOBAL_CROP_PARAMETERS. List of all crop parameters, description, unit, type (single value or AFGEN function) and category (crop- or model parameters).
  • Use:
  • Type: Materialized View
  • Remarks: source objects exist in a different tennent, available via dblink.


GLOBAL_EVENTS

  • Description: list of season events
  • Use: lookup table for events in CROP_CALENDARS
  • Type: Materialized View
  • Remarks: values in column EVENT are case sensitive recognized by the crop model and should not be changed unless the mapping is also changed in the crop model.


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_STATIONS

  • 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: relation between simulated crop parameterizations and crop aggregation areas.
  • Use:
  • Type: Materialized View
  • Remarks: One simulated crop parametetrization can be combined with multiple aggregation areas to create alternative aggregated crops. The object contains records from CROP_AGGREGATIONS, with extra descriptive fields.



LINK_CROP_CALENDARS

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


LINK_CROP_PARAMETERS

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields


LINK_CROP_PARAMETERS_CROP

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'CROP'



LINK_CROP_PARAMETERS_MODEL

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'MODEL'



LINK_CROP_PARAMETRIZATION

  • Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
  • Use:
  • Type: View
  • Remarks: contains the same records as CROP_PARAMETRIZATIONS, with additional descriptive fields.



LINK_CROP_SPATIALIZATIONS

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


LINK_CROP_STU

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


LINK_CROP_VARIETY_PARAMETERS



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: Relative area of each STU inside a SMU.
  • Use: used to find unique simulation units in elementary mapping units (see Spatial_schematization).
  • Type: Table
  • Remarks: The total percentage per SMU adds up to 100%.


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: Spatially available unique Soil Map Units (SMU's).
  • Use: The soil map units are one of the layers used in the Spatial_schematization
  • Type: Table
  • Remarks:



SOIL_STU

  • Description: distinct soil types that have been identified and described by attributes (variables) specifying the nature and properties of the soils (e.g. name, texture, the moisture regime, the stoniness, depth to bedrock etc.).
  • 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_INFO_ERR
6.24 WEATHER_OBS_STATION_LTA
6.25 WEATHER_OBS_STATION_RAW
6.26 WEATHER_OBS_STATION_TEMP
6.27 WEATHER_OPE_GRID
6.28 WEATHER_OPE_REGIONCOVER




WEATHER_ERA_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


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: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


WEATHER_HIS_REGIONCOVER

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


WEATHER_HRES_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: View
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


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_INFO_ERR

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


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_OBS_STATION_TEMP

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


WEATHER_OPE_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


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: definition of agroclimatic grid.
  • Use: target grid for interpolation of weather- and crop indicators
  • Type: Materialized View
  • Remarks:



HRES_YEARS

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


INTERPOLATION_PARAMETERS

  • Description: list of interpolation parameters
  • Use:
  • Type: Table
  • Remarks:


REGIONS

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


STATIONS

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


STAT_REGION_AREAS

  • Description: year specific crop areas for aggregated crops, their source and calculation method.
  • Use: Used to aggregate simulated crop results to aggregated crops
  • 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: