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

From Agri4castWiki
Jump to: navigation, search
(LINK_CROP_PARAMETERS_MODEL)
(CROP_PARAMETRIZATION_PARAMETER)
 
(29 intermediate revisions by the same user not shown)
Line 10: Line 10:
 
{{TocRow|#other datasets|7. other datasets}}
 
{{TocRow|#other datasets|7. other datasets}}
 
}}
 
}}
 
 
 
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 27: Line 24:
 
{{TocRow|#CROP_VARIETY_REGIMES|1.10 CROP_VARIETY_REGIMES}}
 
{{TocRow|#CROP_VARIETY_REGIMES|1.10 CROP_VARIETY_REGIMES}}
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
Line 44: 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 71: 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 || ||  
+
| IDGRID || False || NUMBER || - || identifier for agro-climatic grid
 
|-
 
|-
| YEAR || False || NUMBER || - || calendar year
+
| YEAR || False || NUMBER || - || calendar year (year of sowing/emergence)
 
|-
 
|-
| START_PERIOD || False || VARCHAR2 || ||  
+
| START_EVENT || False || VARCHAR2 || - || identifier for start event (SOWING, EMERGENCE)
 
|-
 
|-
| END_PERIOD || False || VARCHAR2 || ||  
+
| END_EVENT || False || VARCHAR2 || - || identifier for end event (MATURITY, HARVESTING)
 
|-
 
|-
| EMERGENCE || True || DATE ||  ||  
+
| EMERGENCE || True || DATE ||  || date of emergence
 
|-
 
|-
| SOWING || True || DATE ||  ||  
+
| SOWING || True || DATE ||  || date of sowing
 
|-
 
|-
| HARVESTING || True || DATE ||  ||  
+
| HARVESTING || True || DATE ||  || date of harvesting
 
|-
 
|-
| MATURITY || True || DATE ||  ||  
+
| MATURITY || True || DATE ||  || date of maturity
 
|-
 
|-
| DURATION || True || NUMBER || ||
+
| WINDOW_DURATION || True || NUMBER || days || maximum duration of the season
|-
 
| START_DOY || True || NUMBER ||  ||  
 
 
|-
 
|-
 
|}
 
|}
&lt;nowiki>*&lt;/nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).&lt;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 102: 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 114: 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 152: 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 203: Line 196:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_SPATIALIZATIONS ===
 
=== CROP_SPATIALIZATIONS ===
* Description:  
+
* Description: Storing for each grid and crop the variety that should be used to simulate the crop
* Use:  
+
* 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''
 
* Type: ''Table''
* Remarks:  
+
* Remarks: usually the spatial coverage per crop is the same is in object {{Object|CROP_CALENDARS}}, except now without the season identifier. The specified spatial variety is static over years.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 214: Line 207:
 
! 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 || - || crop number
 
|-
 
|-
| IDGRID || False || NUMBER || ||  
+
| IDGRID || False || NUMBER || - || grid number
 
|-
 
|-
| IDVARIETY || False || NUMBER || ||  
+
| IDVARIETY || False || NUMBER || - || variety number
 
|-
 
|-
 
|}
 
|}
Line 228: Line 221:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_SUITABILITY_RULES ===
 
=== CROP_SUITABILITY_RULES ===
 
* Description:  
 
* Description:  
Line 259: Line 253:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETIES ===
 
=== CROP_VARIETIES ===
* Description:  
+
* Description: list of all unique valrieties
* Use:  
+
* Use: lookup table for various link_* objects.
 
* Type: ''Table''
 
* Type: ''Table''
 
* Remarks:  
 
* Remarks:  
Line 270: Line 264:
 
! 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
 
|-
 
|-
| IDVARIETY || False || NUMBER || ||  
+
| IDVARIETY || False || NUMBER || - || unique identifier for variety
 
|-
 
|-
| VARIETY || False || VARCHAR2 || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| DESCRIPTOR || False || VARCHAR2 || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || variety description
 
|-
 
|-
 
|}
 
|}
Line 284: Line 278:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_VARIETY_PARAMETERS ===
 
=== CROP_VARIETY_PARAMETERS ===
 
* Description:  
 
* Description:  
Line 346: Line 341:
 
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
 
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
 
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
 
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
+
{{TocRow|#GLOBAL_EVENTS|2.6 GLOBAL_EVENTS}}
{{TocRow|#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES}}
+
{{TocRow|#GLOBAL_GRIDS|2.7 GLOBAL_GRIDS}}
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE}}
+
{{TocRow|#GLOBAL_GRID_SOURCES|2.8 GLOBAL_GRID_SOURCES}}
{{TocRow|#GLOBAL_MODELS|2.9 GLOBAL_MODELS}}
+
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.9 GLOBAL_LINK_COVERWINDOW_SOURCE}}
{{TocRow|#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS}}
+
{{TocRow|#GLOBAL_MODELS|2.10 GLOBAL_MODELS}}
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS}}
+
{{TocRow|#GLOBAL_REGIONS|2.11 GLOBAL_REGIONS}}
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
+
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.12 GLOBAL_REGION_ELEMENTS}}
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
+
{{TocRow|#GLOBAL_REGION_SOURCES|2.13 GLOBAL_REGION_SOURCES}}
{{TocRow|#GLOBAL_STATIONS|2.14 GLOBAL_STATIONS}}
+
{{TocRow|#GLOBAL_SOIL_SOURCES|2.14 GLOBAL_SOIL_SOURCES}}
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.15 GLOBAL_STATISTIC_SOURCES}}
+
{{TocRow|#GLOBAL_STATIONS|2.15 GLOBAL_STATIONS}}
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.16 GLOBAL_SUITABILITY_PROPERTIES}}
+
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.16 GLOBAL_STATISTIC_SOURCES}}
{{TocRow|#GLOBAL_THRESHOLDS|2.17 GLOBAL_THRESHOLDS}}
+
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.17 GLOBAL_SUITABILITY_PROPERTIES}}
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.18 GLOBAL_TIME_DIMENSIONS}}
+
{{TocRow|#GLOBAL_THRESHOLDS|2.18 GLOBAL_THRESHOLDS}}
{{TocRow|#GLOBAL_TREATMENTS|2.19 GLOBAL_TREATMENTS}}
+
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.19 GLOBAL_TIME_DIMENSIONS}}
{{TocRow|#GLOBAL_WINDOWS|2.20 GLOBAL_WINDOWS}}
+
{{TocRow|#GLOBAL_TREATMENTS|2.20 GLOBAL_TREATMENTS}}
 +
{{TocRow|#GLOBAL_WINDOWS|2.21 GLOBAL_WINDOWS}}
 
}}
 
}}
 
 
 
  
 
<!-- start -->
 
<!-- start -->
Line 545: Line 538:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
  
  
 
<!-- start -->
 
<!-- start -->
 
+
=== GLOBAL_EVENTS ===
=== GLOBAL_GRIDS ===
+
* Description: list of season events
* Description:  
+
* Use: lookup table for events in {{Object|CROP_CALENDARS}}
* Use:  
+
* Type: ''Materialized View''
* Type: ''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.
* Remarks:  
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 562: Line 553:
 
! 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
 
|-
 
|-
| IDGRID || False || NUMBER || ||  
+
| IDEVENT || False || NUMBER || - || unique identifier for event
 
|-
 
|-
| IDGRID_SOURCE || False || NUMBER || ||  
+
| EVENT || False || VARCHAR2 || - || event name
 
|-
 
|-
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || description of event
 +
|-
 +
|}
 +
 
 +
'''definition:'''
 +
select
 +
    idevent
 +
  , event
 +
  , c.descriptor
 +
from events@cgms14sys_assistdas c
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== GLOBAL_GRIDS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| IDGRID || False || NUMBER ||  ||
 +
|-
 +
| IDGRID_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
| LATITUDE || False || NUMBER ||  ||  
 
| LATITUDE || False || NUMBER ||  ||  
Line 1,303: Line 1,326:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== LINK-datasets ==
 
== LINK-datasets ==
Line 1,329: 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,346: 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,395: Line 1,413:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_CALENDARS ===
 
=== LINK_CROP_CALENDARS ===
 
* Description:  
 
* Description:  
Line 1,482: Line 1,501:
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks: Contains the same records as {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,554: Line 1,573:
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks: Contains the same records as {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'CROP'
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'CROP'
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,622: Line 1,641:
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks: Contains the same records as {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'MODEL'
+
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'MODEL'
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,860: Line 1,879:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_CROP_VARIETY_PARAMETERS ===
 
=== LINK_CROP_VARIETY_PARAMETERS ===
* Description:  
+
* Description: Optimized parameters for a variety.
* Use:  
+
* Use: If a parameter exist in this object it overwrites the default value stored in {{Object|LINK_CROP_PARAMETERS_CROP}} and {{Object|LINK_CROP_PARAMETERS_MODEL}}.
* Type: ''View''
+
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains records from {{Object|CROP_VARIETY_PARAMETERS}}, with extra descriptive fields
{|class="collapsing_table collapsible collapsed"
+
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
 
|-
 
|-
Line 1,871: Line 1,890:
 
! 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 || - || crop number
 
|-
 
|-
| CROP_PARAMETRIZATION || False || VARCHAR2 || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || False || NUMBER || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || False || VARCHAR2 || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || False || NUMBER || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || False || VARCHAR2 || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDVARIETY || False || NUMBER || ||  
+
| IDVARIETY || False || NUMBER || - || variety number
 
|-
 
|-
| VARIETY || False || VARCHAR2 || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| IDCROP_PARAMETER || False || NUMBER || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  || parameter name
 
|-
 
|-
| DESCRIPTOR || False || VARCHAR2 ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  || parameter description and unit
 
|-
 
|-
| XVALUE || False || NUMBER || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || True || NUMBER || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
Line 1,901: Line 1,920:
  
 
'''definition:'''
 
'''definition:'''
  select
+
  select  
    "IDCROP_PARAMETRIZATION","CROP_PARAMETRIZATION","IDMODEL","MODEL","IDCOVER","COVER","IDVARIETY","VARIETY","IDCROP_PARAMETER","CROP_PARAMETER","DESCRIPTOR","XVALUE","YVALUE"
+
    *
  from
+
from
    (
+
    (  
    select distinct
+
    select distinct
        cp.idcrop_parametrization
+
        cp.idcrop_parametrization
      , cp.crop_parametrization
+
      , cp.crop_parametrization
      , m.idmodel
+
      , m.idmodel
      , m.model
+
      , m.model
      , c.idcover
+
      , c.idcover
      , c.cover
+
      , c.cover
      , v.idvariety
+
      , v.idvariety
      , v.variety
+
      , v.variety
      , cps.idcrop_parameter
+
      , cps.idcrop_parameter
      , cps.crop_parameter
+
      , cps.crop_parameter
      , cps.descriptor
+
      , cps.descriptor
      , cvp.xvalue
+
      , cvp.xvalue
      , cvp.yvalue
+
      , cvp.yvalue
    from cgms14chn.global_models m
+
    from
      , global_covers c
+
        global_models m
      , crop_varieties v
+
      , global_covers c
      , crop_parametrizations cp
+
      , crop_varieties v
      , crop_spatializations cs
+
      , crop_parametrizations cp
      , global_crop_parameters cps
+
      , crop_spatializations cs
      , crop_variety_parameters cvp
+
      , global_crop_parameters cps
    where cs.idcrop_parametrization = cp.idcrop_parametrization
+
      , crop_variety_parameters cvp
      and cp.idcover = c.idcover
+
    where cs.idcrop_parametrization       = cp.idcrop_parametrization
      and cs.idvariety = v.idvariety
+
      and cp.idcover                       = c.idcover  
      and cp.idmodel = m.idmodel
+
      and cs.idvariety                     = v.idvariety
      and cs.idvariety = cvp.idvariety
+
      and cp.idmodel                       = m.idmodel
      and cvp.idcrop_parameter = cps.idcrop_parameter
+
      and cs.idvariety                     = cvp.idvariety
      and cp.active_parametrization = 'Y'
+
      and cvp.idcrop_parameter             = cps.idcrop_parameter
    ) a
+
      and lower(cp.active_parametrization) = lower('Y')
  order by idcrop_parametrization
+
    ) a      
    , idvariety
+
order by
    , crop_parameter
+
      idcrop_parametrization
 +
    , idvariety
 +
    , crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,943: Line 1,964:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_GRID_COVER ===
 
=== LINK_GRID_COVER ===
 
* Description:  
 
* Description:  
Line 2,171: 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,182: 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,193: Line 2,215:
 
<!-- end -->
 
<!-- end -->
  
 +
<!-- start -->
  
 
<!-- start -->
 
 
=== LINK_STU_HORIZONS ===
 
=== LINK_STU_HORIZONS ===
 
* Description:  
 
* Description:  
Line 2,365: Line 2,386:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== SIM-datasets ==
 
== SIM-datasets ==
Line 4,405: 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,416: 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,430: 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,442: 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,496: Line 4,516:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
 
  
 
== WEATHER-datasets ==
 
== WEATHER-datasets ==
Line 6,825: Line 6,843:
 
<!-- start -->
 
<!-- start -->
 
=== GRIDS ===
 
=== GRIDS ===
* Description:  
+
* Description: definition of agroclimatic grid.
* Use:  
+
* Use: target grid for interpolation of weather- and crop indicators
* Type: ''View''
+
* Type: ''Materialized View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 6,836: Line 6,854:
 
! 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
 
|-
 
|-
| IDGRID || False || NUMBER || ||  
+
| IDGRID || False || NUMBER || - || unique identifier
 
|-
 
|-
| IDORIGINAL_CODE || False || VARCHAR2 || ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 || - || unique identifier in CGMS12XXX schema's
 
|-
 
|-
| LATITUDE || False || NUMBER || ||  
+
| LATITUDE || False || NUMBER || decimal degree WGS84 ||  
 
|-
 
|-
| LONGITUDE || False || NUMBER || ||  
+
| LONGITUDE || False || NUMBER || decimal degree WGS84 ||  
 
|-
 
|-
| ALTITUDE || False || NUMBER || ||  
+
| ALTITUDE || False || NUMBER || meter || average agricultural altitude
 
|-
 
|-
| ALTITUDE_16 || True || NUMBER || ||  
+
| ALTITUDE_16 || True || NUMBER || meter || average altitude, calculated from 0.50 dd resolution
 
|-
 
|-
| ALTITUDE_25 || True || NUMBER || ||  
+
| ALTITUDE_25 || True || NUMBER || meter || average  altitude, calculated from 0.25 dd resolution
 
|-
 
|-
| HAS_LAND || False || VARCHAR2 || ||  
+
| HAS_LAND || False || VARCHAR2 || Y/N || boolean to distinguish land from sea grids
 
|-
 
|-
| DISTANCE_FROM_COAST || True || NUMBER || ||  
+
| DISTANCE_FROM_COAST || True || NUMBER || km || distance of grid to coastline or large water body
 
|-
 
|-
| CLIMATE_BARRIER || True || NUMBER || ||  
+
| CLIMATE_BARRIER || True || NUMBER || - || unique identifier of uniform weather region where grid belongs to
 
|-
 
|-
| RESOLUTION || False || NUMBER || ||  
+
| RESOLUTION || False || NUMBER || depending on unit || value of grid resolution
 
|-
 
|-
| UNIT || False || VARCHAR2 || ||  
+
| UNIT || False || VARCHAR2 || - || unit of grid resolution
 
|-
 
|-
 
|}
 
|}
 
  
 
'''definition:'''
 
'''definition:'''
Line 6,869: Line 6,886:
 
   , g.latitude
 
   , g.latitude
 
   , g.longitude
 
   , g.longitude
 +
  , g.x
 +
  , g.y
 
   , g.altitude
 
   , g.altitude
 
   , g.altitude_16
 
   , g.altitude_16
Line 6,878: Line 6,897:
 
   , g.unit
 
   , g.unit
 
  from global_grids g
 
  from global_grids g
  where grid_source = 'CHN'
+
  where lower(grid_source) = lower('EUR')
 
  order by idgrid
 
  order by idgrid
 
|}
 
|}
Line 6,886: Line 6,905:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== HRES_YEARS ===
 
=== HRES_YEARS ===
 
* Description:  
 
* Description:  
Line 7,107: 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,118: 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,144: 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: