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

From Agri4castWiki
Jump to: navigation, search
(generated page)
(CROP_PARAMETRIZATION_PARAMETER)
 
(61 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
 
 
{{expert}}
 
{{expert}}
 
__NOTOC__
 
__NOTOC__
Line 12: Line 10:
 
{{TocRow|#other datasets|7. other datasets}}
 
{{TocRow|#other datasets|7. other datasets}}
 
}}
 
}}
 
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 18: Line 15:
 
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
 
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
 
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
 
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
{{TocRow|#CROP_CALENDARS_OLD|1.3 CROP_CALENDARS_OLD}}
+
{{TocRow|#CROP_PARAMETRIZATIONS|1.3 CROP_PARAMETRIZATIONS}}
{{TocRow|#CROP_PARAMETRIZATIONS|1.4 CROP_PARAMETRIZATIONS}}
+
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.4 CROP_PARAMETRIZATION_PARAMETER}}
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.5 CROP_PARAMETRIZATION_PARAMETER}}
+
{{TocRow|#CROP_REGIMES|1.5 CROP_REGIMES}}
{{TocRow|#CROP_REGIMES|1.6 CROP_REGIMES}}
+
{{TocRow|#CROP_SPATIALIZATIONS|1.6 CROP_SPATIALIZATIONS}}
{{TocRow|#CROP_SPATIALIZATIONS|1.7 CROP_SPATIALIZATIONS}}
+
{{TocRow|#CROP_SUITABILITY_RULES|1.7 CROP_SUITABILITY_RULES}}
{{TocRow|#CROP_SUITABILITY_RULES|1.8 CROP_SUITABILITY_RULES}}
+
{{TocRow|#CROP_VARIETIES|1.8 CROP_VARIETIES}}
{{TocRow|#CROP_VARIETIES|1.9 CROP_VARIETIES}}
+
{{TocRow|#CROP_VARIETY_PARAMETERS|1.9 CROP_VARIETY_PARAMETERS}}
{{TocRow|#CROP_VARIETY_PARAMETERS|1.10 CROP_VARIETY_PARAMETERS}}
+
{{TocRow|#CROP_VARIETY_REGIMES|1.10 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 -->
 
=== CROP_AGGREGATIONS ===
 
=== CROP_AGGREGATIONS ===
''Table''.
+
* Description: Link between simulated and aggregated crops.
*Description:  
+
* 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.
*Use:  
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 45: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_AGGREGATION || False || NUMBER || - || identifier for aggregated crop
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP || False || NUMBER || - || identifier to link statistical crop (EUROSTAT)
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
 
|}
 
|}
Line 55: Line 48:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_CALENDARS ===
 
=== CROP_CALENDARS ===
''Table''.
+
* Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
*Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
+
* Use: determines which crops are simulated for a grid, and simulation period
*Use: determines which crops are simulated for a grid, and simulation period
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, one of the ‘driving’ tables of the system
*Remarks: user defined, one of the ‘driving’ tables of the system
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 70: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| IDGRID || False || NUMBER || - || identifier for agro-climatic grid
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || - || calendar year
+
| YEAR || False || NUMBER || - || calendar year (year of sowing/emergence)
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| START_EVENT || False || VARCHAR2 || - || identifier for start event (SOWING, EMERGENCE)
 
|-
 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| END_EVENT || False || VARCHAR2 || - || identifier for end event (MATURITY, HARVESTING)
 
|-
 
|-
| EMERGENCE || || DATE ||  ||  
+
| EMERGENCE || True || DATE ||  || date of emergence
 
|-
 
|-
| SOWING || || DATE ||  ||  
+
| SOWING || True || DATE ||  || date of sowing
 
|-
 
|-
| HARVESTING || || DATE ||  ||  
+
| HARVESTING || True || DATE ||  || date of harvesting
 
|-
 
|-
| MATURITY || || DATE ||  ||  
+
| MATURITY || True || DATE ||  || date of maturity
 
|-
 
|-
| DURATION || || NUMBER(22) || ||
+
| WINDOW_DURATION || True || NUMBER || days || maximum duration of the season
|-
 
| START_DOY ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
<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>
<nowiki>**</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 -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_CALENDARS_OLD ===
 
''Table''.
 
  
 +
=== 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:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 109: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || identifier for crop model
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || ||  
+
| IDCOVER || False || NUMBER || - || identifier for linked landcover/cropmask
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N || switch to enable/disable parametrization simulations
 
|-
 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N || switch to enable/disable parametrization in viewer
 
|-
 
|-
| EMERGENCE || || DATE || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| SOWING || || DATE || ||  
+
| DESCRIPTOR || True || VARCHAR2 || - || description for simulated crop
 
|-
 
|-
| HARVESTING || || DATE ||  ||
+
| TAG || True || VARCHAR2 ||  ||  
|-
 
| MATURITY ||  || DATE ||  ||
 
|-
 
| DURATION ||  || NUMBER(22) ||  ||
 
|-
 
| START_DOY ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 +
 
|}
 
|}
  
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_PARAMETRIZATIONS ===
 
''Table''.
 
  
 +
=== 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:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 147: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x-value
 
|-
 
|-
| ACTIVE_PARAMETRIZATION || NOT NULL || VARCHAR2(1) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y-value in case of AFGEN function
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| DESCRIPTOR ||  || VARCHAR2(255) ||  ||
 
 
|-
 
|-
 
|}
 
|}
Line 163: Line 157:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_PARAMETRIZATION_PARAMETER ===
 
''Table''.
 
  
 +
=== CROP_REGIMES ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 175: Line 173:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_REGIME || False || NUMBER ||  ||
 +
|-
 +
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
 +
|-
 +
| SOWING_REGIME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGIME_DETAIL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| DETAIL_VALUE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| DETAIL_DIMENSION || False || VARCHAR2 ||  ||  
 +
|-
 +
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 187: Line 191:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_REGIMES ===
+
=== CROP_SPATIALIZATIONS ===
''Table''.  
+
* 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 {{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 199: 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_REGIME || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 2) || ||  
+
| IDGRID || False || NUMBER || - || grid number
 
|-
 
|-
| SOWING_REGIME || NOT NULL || VARCHAR2(30) ||  ||
+
| IDVARIETY || False || NUMBER || - || variety number
|-
 
| REGIME_DETAIL || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| DETAIL_VALUE || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| DETAIL_DIMENSION || NOT NULL || VARCHAR2(60) ||  ||
 
|-
 
| DESCRIPTION ||  || VARCHAR2(256) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 217: Line 217:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SPATIALIZATIONS ===
 
''Table''.
 
  
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|}
 
 
|}
 
<!-- end -->
 
 
<!-- start -->
 
 
=== CROP_SUITABILITY_RULES ===
 
=== CROP_SUITABILITY_RULES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 251: Line 234:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| VALUEC || || VARCHAR2(30) ||  ||  
+
| VALUEC || True || VARCHAR2 ||  ||  
 
|-
 
|-
| VALUEN_MIN || || NUMBER(22) ||  ||  
+
| VALUEN_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| VALUEN_MAX || || NUMBER(22) ||  ||  
+
| VALUEN_MAX || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 265: Line 248:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== CROP_VARIETIES ===
 
=== CROP_VARIETIES ===
''Table''.
+
* Description: list of all unique valrieties
 
+
* Use: lookup table for various link_* objects.
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 277: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDVARIETY || False || NUMBER || - || unique identifier for variety
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || variety description
 
|-
 
|-
 
|}
 
|}
Line 287: Line 274:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== CROP_VARIETY_PARAMETERS ===
 
=== CROP_VARIETY_PARAMETERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 299: Line 291:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 311: Line 303:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS_OLD ===
+
=== CROP_VARIETY_REGIMES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 323: Line 319:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| DECADE || False || NUMBER ||  ||  
 
|-
 
|-
| YVALUE || || NUMBER(22) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 335: Line 331:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
 +
 +
== GLOBAL-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
 +
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
 +
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
 +
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
 +
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
 +
{{TocRow|#GLOBAL_EVENTS|2.6 GLOBAL_EVENTS}}
 +
{{TocRow|#GLOBAL_GRIDS|2.7 GLOBAL_GRIDS}}
 +
{{TocRow|#GLOBAL_GRID_SOURCES|2.8 GLOBAL_GRID_SOURCES}}
 +
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.9 GLOBAL_LINK_COVERWINDOW_SOURCE}}
 +
{{TocRow|#GLOBAL_MODELS|2.10 GLOBAL_MODELS}}
 +
{{TocRow|#GLOBAL_REGIONS|2.11 GLOBAL_REGIONS}}
 +
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.12 GLOBAL_REGION_ELEMENTS}}
 +
{{TocRow|#GLOBAL_REGION_SOURCES|2.13 GLOBAL_REGION_SOURCES}}
 +
{{TocRow|#GLOBAL_SOIL_SOURCES|2.14 GLOBAL_SOIL_SOURCES}}
 +
{{TocRow|#GLOBAL_STATIONS|2.15 GLOBAL_STATIONS}}
 +
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.16 GLOBAL_STATISTIC_SOURCES}}
 +
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.17 GLOBAL_SUITABILITY_PROPERTIES}}
 +
{{TocRow|#GLOBAL_THRESHOLDS|2.18 GLOBAL_THRESHOLDS}}
 +
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.19 GLOBAL_TIME_DIMENSIONS}}
 +
{{TocRow|#GLOBAL_TREATMENTS|2.20 GLOBAL_TREATMENTS}}
 +
{{TocRow|#GLOBAL_WINDOWS|2.21 GLOBAL_WINDOWS}}
 +
}}
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_REGIMES ===
+
=== GLOBAL_CATEGORIES ===
''Table''.
+
* Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
 
+
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 347: Line 372:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DECADE || NOT NULL || NUMBER(22) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    idcategory
 +
  , category
 +
  , descriptor
 +
from categories@cgms14sys_assistdas
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
== GLOBAL-datasets ==
 
{{TocTable|content=
 
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
 
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.2 GLOBAL_CROP_PARAMETERS}}
 
}}
 
  
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CATEGORIES ===
+
=== GLOBAL_COVERS ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 378: Line 405:
 
! 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
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 389: Line 416:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     idcategory
+
     c.idcover
   , category
+
   , c.cover
   , descriptor
+
   , c.descriptor
  from categories@CGMS14SYS_ASSISTSAN
+
  from covers@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROP_PARAMETERS ===
+
=== GLOBAL_COVER_SOURCES ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 407: Line 438:
 
! 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_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MULTI || NOT NULL || VARCHAR2(1) ||  ||
+
| UNC || True || VARCHAR2 ||  ||  
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 424: Line 451:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    cp.idcrop_parameter
+
  c.idcover_source
   , cp.crop_parameter
+
   , c.cover_source
   , cp.descriptor
+
   , c.descriptor
  , cp.multi
+
   , c.unc
  , cp.idcategory
+
  from cover_sources@CGMS14SYS_ASSISTDAS c
   , c.category
 
  from
 
    crop_parameters@CGMS14SYS_ASSISTSAN cp
 
  , categories@CGMS14SYS_ASSISTSAN c
 
where cp.idcategory = c.idcategory
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
== LINK-datasets ==
 
{{TocTable|content=
 
{{TocRow|#LINK_CROP_PARAMETERS|3.1 LINK_CROP_PARAMETERS}}
 
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.2 LINK_CROP_PARAMETERS_CROP}}
 
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.3 LINK_CROP_PARAMETERS_MODEL}}
 
{{TocRow|#LINK_CROP_STU|3.4 LINK_CROP_STU}}
 
{{TocRow|#LINK_GRID_COVER|3.5 LINK_GRID_COVER}}
 
{{TocRow|#LINK_GRID_REGION_COVER|3.6 LINK_GRID_REGION_COVER}}
 
{{TocRow|#LINK_REGION_COVER|3.7 LINK_REGION_COVER}}
 
{{TocRow|#LINK_SMU_GRID_COVER|3.8 LINK_SMU_GRID_COVER}}
 
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.9 LINK_SMU_GRID_REGION_COVER}}
 
{{TocRow|#LINK_SMU_STU|3.10 LINK_SMU_STU}}
 
{{TocRow|#LINK_STU_HORIZONS|3.11 LINK_STU_HORIZONS}}
 
}}
 
  
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS ===
+
=== GLOBAL_CROPS ===
''Materialized_View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 464: Line 474:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| EUROSTAT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
+
|}
|-
+
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| XVALUE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| YVALUE ||  || NUMBER(22) ||  ||
 
|-
 
|}
 
 
 
  
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     c.idcrop
  , cp.crop_parametrization
+
   , c.crop
  , m.idmodel
+
   , c.descriptor
  , m.model
+
   , c.eurostat
   , c.idcover
+
  from crops@CGMS14SYS_ASSISTDAS c
   , c.cover
 
  , cps.idcrop_parameter
 
  , cps.crop_parameter
 
  , cps.descriptor
 
   , cps.idcategory
 
  , cps.category
 
  , cpp.xvalue
 
  , cpp.yvalue
 
  from
 
    global_models m
 
  , global_covers c
 
  , crop_parametrization_parameter cpp
 
  , crop_parametrizations cp
 
  , global_crop_parameters cps
 
where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
and  cp.idcover                = c.idcover
 
and  cp.idmodel                = m.idmodel
 
and  cp.active_parametrization  = 'Y'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS_CROP ===
+
=== GLOBAL_CROP_PARAMETERS ===
''Materialized_View''.  
+
* 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.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 534: Line 510:
 
! 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || -
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || -
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || -
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| MULTI || False || VARCHAR2 || Y/N || single value (x) or AFGEN function (xy)
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCATEGORY || False || NUMBER || - || -
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| CATEGORY || False || VARCHAR2 || - || CROP/MODEL
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||
+
|}
|-
+
 
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| XVALUE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| YVALUE ||  || NUMBER(22) ||  ||
 
|-
 
|}
 
 
 
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     cp.idcrop_parameter
   , cp.crop_parametrization
+
   , cp.crop_parameter
   , m.idmodel
+
   , cp.descriptor
   , m.model
+
   , cp.multi
   , c.idcover
+
   , cp.idcategory
   , c.cover
+
   , c.category
  , cps.idcrop_parameter
 
  , cps.crop_parameter
 
  , cps.descriptor
 
  , cpp.xvalue
 
  , cpp.yvalue
 
 
  from
 
  from
     global_models m
+
     crop_parameters@CGMS14SYS_ASSISTDAS cp
   , global_covers c
+
   , categories@CGMS14SYS_ASSISTDAS c
  , crop_parametrization_parameter cpp
+
  where cp.idcategory = c.idcategory
  , crop_parametrizations cp
 
  , global_crop_parameters cps
 
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
and  cp.idcover                = c.idcover
 
and  cp.idmodel                = m.idmodel
 
and  cp.active_parametrization  = 'Y'
 
and  cps.category              = 'CROP'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS_MODEL ===
+
=== GLOBAL_EVENTS ===
''Materialized_View''.  
+
* Description: list of season events
 
+
* Use: lookup table for events in {{Object|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.  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 599: 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
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) || ||  
+
| IDEVENT || False || NUMBER || - || unique identifier for event
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| EVENT || False || VARCHAR2 || - || event name
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || description of event
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||
+
|}
|-
+
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| XVALUE || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| YVALUE ||  || NUMBER(22) ||  ||
 
|-
 
|}
 
 
 
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    cp.idcrop_parametrization
+
    idevent
  , cp.crop_parametrization
+
  , event
  , m.idmodel
+
  , c.descriptor
  , m.model
+
  from events@cgms14sys_assistdas c
  , c.idcover
 
  , c.cover
 
  , cps.idcrop_parameter
 
  , cps.crop_parameter
 
  , cps.descriptor
 
  , cpp.xvalue
 
  , cpp.yvalue
 
  from
 
    global_models m
 
  , global_covers c
 
  , crop_parametrization_parameter cpp
 
  , crop_parametrizations cp
 
  , global_crop_parameters cps
 
where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
and  cp.idcover                = c.idcover
 
and  cp.idmodel                = m.idmodel
 
and  cp.active_parametrization  = 'Y'
 
and  cps.category              = 'MODEL'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_STU ===
 
''Table''.
 
  
 +
=== GLOBAL_GRIDS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 664: Line 585:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
|}
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||
 
+
|-
|}
+
| LATITUDE || False || NUMBER ||  ||
<!-- end -->
+
|-
 
+
| LONGITUDE || False || NUMBER ||  ||
<!-- start -->
+
|-
=== LINK_GRID_COVER ===
+
| ALTITUDE || False || NUMBER ||  ||
''Table''.
+
|-
 
+
| ALTITUDE_16 || True || NUMBER ||  ||
{|class="collapsing_table collapsible collapsed"
+
|-
!Structure
+
| ALTITUDE_25 || True || NUMBER ||  ||
 +
|-
 +
| X || False || NUMBER ||  ||
 +
|-
 +
| Y || False || NUMBER ||  ||
 +
|-
 +
| DISTANCE_FROM_COAST || True || NUMBER ||  ||
 +
|-
 +
| CLIMATE_BARRIER || True || NUMBER ||  ||
 
|-
 
|-
|
+
| HAS_LAND || False || VARCHAR2 ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| GRID_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    g.idgrid
 +
  , g.idgrid_source
 +
  , idoriginal_code
 +
  , latitude
 +
  , longitude
 +
  , altitude
 +
  , altitude_16
 +
  , altitude_25
 +
  , x
 +
  , y
 +
  , distance_from_coast
 +
  , climate_barrier
 +
  , has_land
 +
  , grid_source
 +
  , resolution
 +
  , unit
 +
from grids@CGMS14SYS_ASSISTDAS g
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
  , grid_sources@CGMS14SYS_ASSISTDAS gs
 +
where g.idgrid_source = gs.idgrid_source
 +
  and gs.idwindow = w.idwindow
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_GRID_REGION_COVER ===
+
=== GLOBAL_GRID_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 706: Line 661:
 
! 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
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| IDWINDOW || False || NUMBER ||  ||
 +
|-
 +
| WINDOW || False || VARCHAR2 ||  ||
 +
|-
 +
| NAME || False || VARCHAR2 ||  ||
 +
|-
 +
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    idgrid_source
 +
  , gs.idwindow
 +
  , w.window
 +
  , w.name
 +
  , gs.resolution
 +
  , gs.unit
 +
  , gs.description
 +
  , gs.unc
 +
from grid_sources@CGMS14SYS_ASSISTDAS gs
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
where gs.idwindow = w.idwindow
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_REGION_COVER ===
+
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 730: Line 711:
 
! 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
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||
 +
|-
 +
| IDCOVER || False || NUMBER ||  ||
 +
|-
 +
| COVER || False || VARCHAR2 ||  ||
 +
|-
 +
| IDCOVER_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| COVER_SOURCE || False || VARCHAR2 ||  ||
 +
|-
 +
| COVER_SOURCE_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    lcws.idwindow
 +
  , w.window
 +
  , w.name
 +
  , lcws.idcover
 +
  , c.cover
 +
  , lcws.idcover_source
 +
  , cover_source
 +
  , cs.descriptor as cover_source_descriptor
 +
from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
  , covers@CGMS14SYS_ASSISTDAS c
 +
  , cover_sources@CGMS14SYS_ASSISTDAS cs
 +
where lcws.idwindow = w.idwindow
 +
  and lcws.idcover = c.idcover
 +
  and lcws.idcover_source = cs.idcover_source
 +
order by w.idwindow
 +
  , c.idcover
 +
  , cs.idcover_source
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SMU_GRID_COVER ===
+
=== GLOBAL_MODELS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 752: Line 768:
 
! 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
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    m.idmodel
 +
  , m.model
 +
  , m.descriptor
 +
from models@CGMS14SYS_ASSISTDAS m
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SMU_GRID_REGION_COVER ===
+
=== GLOBAL_REGIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 776: Line 801:
 
! 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
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    r.idregion
 +
  , r.region
 +
  , r.name
 +
  , r.continent
 +
  , r.population
 +
from regions@CGMS14SYS_ASSISTDAS r
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SMU_STU ===
+
=== GLOBAL_REGION_ELEMENTS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 802: Line 840:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_ELEMENT || False || NUMBER ||  ||
 +
|-
 +
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
|}
+
| REGION || False || VARCHAR2 ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_STU_HORIZONS ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| GLOBAL_NAME || False || VARCHAR2 ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| LOCAL_NAME || True || VARCHAR2 ||  ||  
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGION_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||  
+
| STANDARD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
+
| IDFATHER || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| IDREGION_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| REGION_SOURCE || False || VARCHAR2 ||  ||
 +
|-
 +
|}
  
 +
 +
'''definition:'''
 +
select
 +
    re.idregion_element
 +
  , re.idoriginal_code
 +
  , re.idregion
 +
  , r.continent
 +
  , r.region
 +
  , r.name global_name
 +
  , re.name local_name
 +
  , re.region_level
 +
  , r.population
 +
  , re.standard
 +
  , re.idfather
 +
  , re.idregion_source
 +
  , rs.region_source
 +
from region_elements@CGMS14SYS_ASSISTDAS re
 +
  , regions@CGMS14SYS_ASSISTDAS r
 +
  , region_sources@CGMS14SYS_ASSISTDAS rs
 +
where re.idregion = r.idregion
 +
  and re.idregion_source = rs.idregion_source
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
== SIM-datasets ==
 
{{TocTable|content=
 
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
 
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
 
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
 
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
 
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
 
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
 
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
 
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
 
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
 
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
 
{{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 -->
=== SIM_BLAST_HRES_GRID ===
+
=== GLOBAL_REGION_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 870: Line 907:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    r.idregion_source
 +
  , r.region_source
 +
  , r.description
 +
  , r.unc
 +
from region_sources@CGMS14SYS_ASSISTDAS r
 +
  order by idregion_source
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_SOIL_SOURCES ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||
+
|
|-
+
{|class="wikitable"
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
 
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||
 
|-
 
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) || ||  
 
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| SOIL_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    s.idsoil_source
 +
  , s.soil_source
 +
  , s.descriptor
 +
from soil_sources@CGMS14SYS_ASSISTDAS s
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_GRID_LTA ===
+
=== GLOBAL_STATIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 934: Line 977:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| ORGANIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| IDWMO || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| WMO || True || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| Y_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| X_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCLIMATE_ZONE || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| COUNTRY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DISTANCE_TO_COAST || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| ANGSTROM_A || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| ANGSTROM_B || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| SUPIT_A || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| SUPIT_B || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| SUPIT_C || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| HARGREAVES_A || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| HARGREAVES_B || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| RELIABLE_STATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| ACTIVE_STATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| AVAIL_PRECIPITATION_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| AVAIL_SNOWDEPTH_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| AVAIL_TEMPERATURE_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| AVAIL_HUMIDITY_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AVAIL_REST_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
  select
 +
    IDSTATION
 +
  , STATION
 +
  , ORGANIZATION
 +
  , IDWMO
 +
  , WMO
 +
  , LATITUDE
 +
  , LONGITUDE
 +
  , Y_COORDINATE
 +
  , X_COORDINATE
 +
  , ALTITUDE
 +
  , IDCLIMATE_ZONE
 +
  , COUNTRY
 +
  , DISTANCE_TO_COAST
 +
  , ANGSTROM_A
 +
  , ANGSTROM_B
 +
  , SUPIT_A
 +
  , SUPIT_B
 +
  , SUPIT_C
 +
  , HARGREAVES_A
 +
  , HARGREAVES_B
 +
  , RELIABLE_STATION
 +
  , ACTIVE_STATION
 +
  , AVAIL_PRECIPITATION_THRESHOLD
 +
  , AVAIL_SNOWDEPTH_THRESHOLD
 +
  , AVAIL_TEMPERATURE_THRESHOLD
 +
  , AVAIL_HUMIDITY_THRESHOLD
 +
  , AVAIL_REST_THRESHOLD
 +
  from stations@cgms14sys_assistdas s
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_STATISTIC_SOURCES ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDSTATISTIC_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STATISTIC_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
  select
 +
    s.idstatistic_source
 +
  , s.statistic_source
 +
  , s.descriptor
 +
  from statistic_sources@CGMS14SYS_ASSISTDAS s
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_SUITABILITY_PROPERTIES ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
  select
 +
    p.idsuitability_property
 +
  , p.suitability_property
 +
  , p.descriptor
 +
  from suitability_properties@CGMS14SYS_ASSISTDAS p
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_THRESHOLDS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDTHRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| THRESHOLD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| INDICATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| OPERATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| VALUE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| VALUE_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||
+
|}
|-
+
 
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||
+
 
|-
+
'''definition:'''
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
  select
 +
    t.idthreshold
 +
  , t.threshold
 +
  , t.indicator
 +
  , t.operator
 +
  , t.value_min
 +
  , t.value_max
 +
  from thresholds@CGMS14SYS_ASSISTDAS t
 +
  , windows@CGMS14SYS_ASSISTDAS w
 +
  where t.idwindow = w.idwindow
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_TIME_DIMENSIONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DECADE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DECADE_ID || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MONTH || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MONTH_ID || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| QUARTER || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| QUARTER_ID || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| YEAR || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| LAST_DAY_DECADE || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
  select
 +
    t.day
 +
  , t.decade
 +
  , t.decade_id
 +
  , t.month
 +
  , t.month_id
 +
  , t.quarter
 +
  , t.quarter_id
 +
  , t.year
 +
  , t.last_day_decade
 +
  from time_dimensions@CGMS14SYS_ASSISTDAS t
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_TREATMENTS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| IDTREATMENT || False || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| TREATMENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) || ||
+
|}
|-
+
 
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
 
|-
+
'''definition:'''
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
  select
|-
+
    t.idtreatment
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
  , t.treatment
|-
+
  , t.descriptor
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
  from treatments@cgms14sys_ASSISTDAS t
|-
+
|}
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GLOBAL_WINDOWS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
|
|-
+
{|class="wikitable"
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
 
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) || ||  
 
 
|-
 
|-
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| REFERENCE_SYSTEM || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| MAX_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| MAX_LON || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| MIN_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| MIN_LON || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| MAX_X || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| MAX_Y || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| MIN_X || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| MIN_Y || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||
+
| ROI || True || NUMBER ||  ||  
|-
 
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    w.idwindow
 +
  , w.window
 +
  , w.name
 +
  , w.reference_system
 +
  , w.descriptor
 +
  , w.max_lat
 +
  , w.max_lon
 +
  , w.min_lat
 +
  , w.min_lon
 +
  , w.max_x
 +
  , w.max_y
 +
  , w.min_x
 +
  , w.min_y
 +
  , w.roi
 +
from windows@CGMS14SYS_ASSISTDAS w
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
== LINK-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION}}
 +
{{TocRow|#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS}}
 +
{{TocRow|#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS}}
 +
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP}}
 +
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL}}
 +
{{TocRow|#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION}}
 +
{{TocRow|#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS}}
 +
{{TocRow|#LINK_CROP_STU|3.8 LINK_CROP_STU}}
 +
{{TocRow|#LINK_CROP_VARIETY_PARAMETERS|3.9 LINK_CROP_VARIETY_PARAMETERS}}
 +
{{TocRow|#LINK_GRID_COVER|3.10 LINK_GRID_COVER}}
 +
{{TocRow|#LINK_GRID_REGION_COVER|3.11 LINK_GRID_REGION_COVER}}
 +
{{TocRow|#LINK_REGION_COVER|3.12 LINK_REGION_COVER}}
 +
{{TocRow|#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT}}
 +
{{TocRow|#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP}}
 +
{{TocRow|#LINK_SMU_GRID_COVER|3.15 LINK_SMU_GRID_COVER}}
 +
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.16 LINK_SMU_GRID_REGION_COVER}}
 +
{{TocRow|#LINK_SMU_STU|3.17 LINK_SMU_STU}}
 +
{{TocRow|#LINK_STU_HORIZONS|3.18 LINK_STU_HORIZONS}}
 +
{{TocRow|#LINK_STU_WEIGHTED_PARAMETERS|3.19 LINK_STU_WEIGHTED_PARAMETERS}}
 +
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 +
}}
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_REGION ===
+
=== LINK_CROP_AGGREGATION ===
''Table''.  
+
* 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 {{Object|CROP_AGGREGATIONS}}, with extra descriptive fields.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,148: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_AGGREGATION || False || NUMBER || - || aggregated crop number
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) || ||  
+
| IDCROP || False || NUMBER || - || global crop number
 
|-
 
|-
| DAY || NOT NULL || DATE || ||  
+
| CROP || False || VARCHAR2 || - || global crop name
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 || - || global crop description
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| BLASTRISKLEVEL || || NUMBER(22, 8) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) || ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 || - || crop model description
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || simulated crop number
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 || - || simulated crop description
 
|-
 
|-
| GAIPOTENTIAL || || NUMBER(22, 12) || ||
+
|}
|-
+
 
| GAIWITHBLAST || || NUMBER(22, 12) || ||  
+
 
|-
+
'''definition:'''
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
  select
 +
    ca.idcrop_aggregation
 +
  , ca.idcrop
 +
  , c.crop
 +
  , c.descriptor
 +
  , cp.idmodel
 +
  , m.model
 +
  , m.descriptor
 +
  , ca.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , cp.descriptor as parametrization_descriptor
 +
  from cgms14chn.crop_aggregations ca
 +
  , cgms14chn.crop_parametrizations cp
 +
  , cgms14chn.global_models m
 +
  , cgms14chn.global_crops c
 +
  where ca.idcrop = c.idcrop
 +
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
 +
  and  cp.idmodel = m.idmodel
 +
  order by ca.idcrop_aggregation
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== LINK_CROP_CALENDARS ===
 +
* 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
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| START_PERIOD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| START_DATE || True || DATE ||  ||  
 
|-
 
|-
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| END_DATE || True || DATE ||  ||
 +
|-
 +
| DURATION || True || NUMBER ||  ||
 +
|-
 +
| START_DOY || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cc.idgrid
 +
  , cc.year
 +
  , cc.start_period
 +
  ,
 +
  case
 +
      when start_period = 'EMERGENCE' then emergence
 +
      when start_period = 'SOWING' then sowing
 +
  end
 +
    start_date
 +
  ,
 +
  case
 +
      when end_period = 'HARVESTING' then harvesting
 +
      when end_period = 'MATURITY' then maturity
 +
  end
 +
    end_date
 +
  , cc.duration
 +
  , cc.start_doy
 +
from global_models m
 +
  , global_covers c
 +
  , crop_parametrizations cp
 +
  , crop_calendars cc
 +
where cc.idcrop_parametrization = cp.idcrop_parametrization
 +
  and cp.idmodel = m.idmodel
 +
  and cp.idcover = c.idcover
 +
  and cp.active_parametrization = 'Y'
 +
  order by cc.idcrop_parametrization
 +
    , cc.idgrid
 +
    , cc.year
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_REGION_LTA ===
+
=== LINK_CROP_PARAMETERS ===
''Table''.
+
* 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 {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,212: Line 1,509:
 
! 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) || ||  
+
| IDCATEGORY || False || NUMBER || - || parameter category number
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) || ||  
+
| CATEGORY || False || VARCHAR2 || - || parameter category name
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) || ||
+
|}
|-
+
'''definition:'''
| AVG_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cps.idcategory
 +
  , cps.category
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
where cpp.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 +
and  cp.idcover                = c.idcover
 +
and  cp.idmodel                = m.idmodel
 +
and  lower(cp.active_parametrization) = lower('Y')
 +
  order by cpp.idcrop_parametrization, cps.crop_parameter
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== 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 {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'CROP'
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| MIN_BLASTSPORULATION || || NUMBER(22, 1) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||
+
|}
|-
+
'''definition:'''
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) || ||
+
select
|-
+
    cp.idcrop_parametrization
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
where cpp.idcrop_parametrization        = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter              = cps.idcrop_parameter
 +
and  cp.idcover                        = c.idcover
 +
and  cp.idmodel                        = m.idmodel
 +
  and  lower(cp.active_parametrization= lower('Y')
 +
  and  lower(cps.category)              = lower('CROP')
 +
  order by cpp.idcrop_parametrization, cps.crop_parameter
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== 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 {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'MODEL'
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) || ||
+
|}
|-
+
'''definition:'''
| MAX_BLASTINFECTION || || NUMBER(22, 1) || ||
+
  select
|-
+
    cp.idcrop_parametrization
| MAX_BLASTSPORULATION || || NUMBER(22, 1) || ||
+
  , cp.crop_parametrization
|-
+
  , m.idmodel
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) || ||
+
  , m.model
|-
+
  , c.idcover
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
  from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
where cpp.idcrop_parametrization        = cp.idcrop_parametrization
 +
  and  cpp.idcrop_parameter              = cps.idcrop_parameter
 +
  and  cp.idcover                        = c.idcover
 +
and  cp.idmodel                        = m.idmodel
 +
  and  lower(cp.active_parametrization= lower('Y')
 +
  and  lower(cps.category)              = lower('MODEL')
 +
  order by cpp.idcrop_parametrization, cps.crop_parameter
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== 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 {{Object|CROP_PARAMETRIZATIONS}}, with additional descriptive fields.
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| TAG || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||
+
| COVER_DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||
 
|-
 
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||
 
|-
 
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
|}
+
 
<!-- end -->
+
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , cp.descriptor as parametrization_descriptor
 +
  , cp.tag
 +
  , cp.active_parametrization
 +
  , cp.viewer_enabled
 +
  , cp.idmodel
 +
  , m.model
 +
  , m.descriptor as model_descriptor
 +
  , c.idcover
 +
  , c.cover
 +
  , c.descriptor as cover_descriptor
 +
from
 +
    crop_parametrizations cp
 +
  , global_models        m
 +
  , global_covers        c
 +
where cp.idmodel = m.idmodel
 +
and  cp.idcover = c.idcover
 +
order by cp.idcrop_parametrization
 +
|}
 +
<!-- end -->
 +
 
 +
 
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_GRID ===
 
''Table''.
 
  
 +
=== LINK_CROP_SPATIALIZATIONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,426: Line 1,784:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDVARIETY || False || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| VARIETY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cs.idgrid
 +
  , v.idvariety
 +
  , v.variety
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cvp.xvalue
 +
  , cvp.yvalue
 +
  from global_models m
 +
  , global_covers c
 +
  , crop_varieties v
 +
  , crop_parametrizations cp
 +
  , crop_spatializations cs
 +
  , global_crop_parameters cps
 +
  , crop_variety_parameters cvp
 +
where cs.idcrop_parametrization = cp.idcrop_parametrization
 +
  and cp.idcover = c.idcover
 +
  and cs.idvariety = v.idvariety
 +
  and cp.idmodel = m.idmodel
 +
  and cs.idvariety = cvp.idvariety
 +
  and cvp.idcrop_parameter = cps.idcrop_parameter
 +
  and cp.active_parametrization = 'Y'
 +
  order by cs.idcrop_parametrization
 +
  , cs.idgrid
 +
  , cps.crop_parameter
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_CROP_STU ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||
+
| IDSTU || False || NUMBER ||  ||  
|-
 
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||
 
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,472: Line 1,874:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_GRID_LTA ===
+
=== LINK_CROP_VARIETY_PARAMETERS ===
''Table''.
+
* Description: Optimized parameters for a variety.
 
+
* 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: ''Materialized View''
 +
* 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,484: 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 || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) || ||  
+
| IDVARIETY || False || NUMBER || - || variety number
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  || parameter name
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  || parameter description and unit
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) || ||
+
|}
|-
+
 
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||
+
 
 +
'''definition:'''
 +
select
 +
    *
 +
  from
 +
    (  
 +
    select distinct
 +
        cp.idcrop_parametrization
 +
      , cp.crop_parametrization
 +
      , m.idmodel
 +
      , m.model
 +
      , c.idcover
 +
      , c.cover
 +
      , v.idvariety
 +
      , v.variety
 +
      , cps.idcrop_parameter
 +
      , cps.crop_parameter
 +
      , cps.descriptor
 +
      , cvp.xvalue
 +
      , cvp.yvalue
 +
    from
 +
        global_models m
 +
      , global_covers c
 +
      , crop_varieties v
 +
      , crop_parametrizations cp
 +
      , crop_spatializations cs
 +
      , global_crop_parameters cps
 +
      , crop_variety_parameters cvp
 +
    where cs.idcrop_parametrization        = cp.idcrop_parametrization
 +
      and cp.idcover                      = c.idcover
 +
      and cs.idvariety                    = v.idvariety
 +
      and cp.idmodel                      = m.idmodel
 +
      and cs.idvariety                    = cvp.idvariety
 +
      and cvp.idcrop_parameter            = cps.idcrop_parameter
 +
      and lower(cp.active_parametrization) = lower('Y')
 +
    ) a       
 +
  order by
 +
      idcrop_parametrization
 +
    , idvariety
 +
    , crop_parameter
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
 
 +
=== LINK_GRID_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_GRID_REGION_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
|}
|-
+
 
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||
+
|}
|-
+
<!-- end -->
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||
+
 
|-
+
 
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||
+
 
|-
+
<!-- start -->
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||
+
=== LINK_REGION_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_SIMULATION_UNIT ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    distinct lgsc.idgrid
 +
  , lss.idstu
 +
  from link_crop_stu lcs
 +
  , link_smu_grid_cover lgsc
 +
  , link_smu_stu lss
 +
  , crop_aggregations ca
 +
  , crop_parametrizations cp
 +
where lcs.idstu = lss.idstu
 +
  and  lss.idsmu = lgsc.idsmu
 +
  and  lcs.idcrop = ca.idcrop
 +
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
 +
  and  cp.idcover = lgsc.idcover
 +
  order by lgsc.idgrid
 +
  , lss.idstu
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_SIMULATION_UNIT_CROP ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
|
|-
+
{|class="wikitable"
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) || ||  
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
distinct
 +
    ca.idcrop_parametrization
 +
  , lgsc.idgrid
 +
  , lss.idstu
 +
  from
 +
    link_crop_stu lcs
 +
  , link_smu_grid_cover lgsc
 +
  , link_smu_stu lss
 +
  , crop_aggregations ca
 +
  , crop_parametrizations cp
 +
where lcs.idstu                = lss.idstu
 +
and  lss.idsmu                = lgsc.idsmu
 +
and  lcs.idcrop                = ca.idcrop
 +
and  ca.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cp.idcover                = lgsc.idcover
 +
  order by
 +
    ca.idcrop_parametrization
 +
  , lgsc.idgrid
 +
  , lss.idstu
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_SMU_GRID_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_SMU_GRID_REGION_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
|}
|-
+
 
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||
+
|}
|-
+
<!-- end -->
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||
+
 
 +
 
 +
 
 +
<!-- start -->
 +
=== 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%.
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) || ||  
+
| IDSMU || False || NUMBER || - || unique identifier for the soil map unit
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) || ||  
+
| IDSTU || False || NUMBER || - || identifier to the soil typologic unit
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) || ||  
+
| PERCENTAGE || False || NUMBER || - || % of area inside the SMU, covered by the STU
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
 
 +
=== LINK_STU_HORIZONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| DEPTH_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| DEPTH_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| HORIZON_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_STU_WEIGHTED_PARAMETERS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY || || NUMBER(22, 2) ||  ||  
+
| SAND || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| SILT || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| CLAY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| SOIL_MOISTURE_WP || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 2) ||  ||  
+
| SOIL_MOISTURE_FC || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| SOIL_MOISTURE_SAT || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 2) ||  ||  
+
| BULK_DENSITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 2) ||  ||  
+
| ORGANIC_CARBON || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||
+
| DEPTH || True || NUMBER ||  ||  
|-
 
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    idstu                                                                                idstu
 +
  , sum(sand                      * (depth_max - depth_min)) / sum(depth_max - depth_min) sand
 +
  , sum(silt                      * (depth_max - depth_min)) / sum(depth_max - depth_min) silt
 +
  , sum(clay                      * (depth_max - depth_min)) / sum(depth_max - depth_min) clay
 +
  , sum(soil_moisture_content_wp  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_wp
 +
  , sum(soil_moisture_content_fc  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_fc
 +
  , sum(soil_moisture_content_sat * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_sat
 +
  , sum(bulk_density              * (depth_max - depth_min)) / sum(depth_max - depth_min) bulk_density
 +
  , sum(organic_carbon            * (depth_max - depth_min)) / sum(depth_max - depth_min) organic_carbon
 +
  , sum(depth_max - depth_min)                                                            depth
 +
from
 +
    link_stu_horizons  lsh
 +
  , soil_horizons      sh
 +
where lsh.idhorizon = sh.idhorizon
 +
group by idstu
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION ===
+
=== LINK_SUITABILITY_RULES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,668: Line 2,317:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
|-
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| DAY || NOT NULL || DATE ||  ||
 
|-
 
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY_MAX || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||
+
| SUITABILITY_PROPERTY_VALUE || True || VARCHAR2 ||  ||  
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    ca.idcrop_aggregation
 +
  , ca.idcrop
 +
  , c.crop
 +
  , c.descriptor
 +
  , cp.idmodel
 +
  , m.model
 +
  , m.descriptor
 +
  , ca.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , cp.descriptor
 +
  , sp.idsuitability_property
 +
  , sp.suitability_property
 +
  , sp.descriptor
 +
  , csr.valuen_min
 +
  , csr.valuen_max
 +
  , csr.valuec
 +
from global_suitability_properties sp
 +
  , crop_suitability_rules        csr
 +
  , global_crops                  c
 +
  , crop_aggregations              ca
 +
  , crop_parametrizations          cp
 +
  , global_models                  m
 +
where  ca.idcrop                  = c.idcrop
 +
  and  ca.idcrop_parametrization  = cp.idcrop_parametrization
 +
  and  cp.idmodel                = m.idmodel
 +
  and  ca.idcrop                  = csr.idcrop
 +
  and  csr.idsuitability_property = sp.idsuitability_property
 +
order by ca.idcrop_aggregation
 +
  , ca.idcrop
 +
  , csr.idsuitability_property
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
<!-- start -->
+
== SIM-datasets ==
=== SIM_WARM_HRES_REGION_LTA ===
+
{{TocTable|content=
''Table''.  
+
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
 +
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
 +
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
 +
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
 +
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
 +
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
 +
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
 +
{{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 -->
 +
=== SIM_BLAST_HRES_GRID ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,726: Line 2,422:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
 +
|-
 +
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_GRID_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY || || NUMBER(22, 2) ||  ||  
+
| MAX_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 2) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TRANSPIRATION || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||
 
+
|-
|}
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||
<!-- end -->
+
|-
 
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||
<!-- start -->
+
|-
=== SIM_WOFOST_HRES_EMU ===
+
| STD_BLASTINFECTION || True || NUMBER ||  ||
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||
 
+
|-
|}
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||
 +
|-
 +
| NUM_AGBWITHBLAST || True || NUMBER ||  ||
 +
|-
 +
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||
 +
|-
 +
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||
 +
|-
 +
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||
 +
|-
 +
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||
 +
|-
 +
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||
 +
|-
 +
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||
 +
|-
 +
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||
 +
|-
 +
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||
 +
|-
 +
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||
 +
|-
 +
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||
 +
|-
 +
|}
 +
 
 +
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU_LTA ===
+
=== SIM_BLAST_HRES_REGION ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,970: Line 2,708:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_REGION_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||
 
+
|-
|}
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||
<!-- end -->
+
|-
 
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| STD_BLASTINFECTION || True || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WOFOST_HRES_GRID_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| NUM_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_GRID ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_GRID_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WOFOST_HRES_REGION_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_REGION ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_REGION_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 2) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSM || || NUMBER(22, 2) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUNOFF || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SOIL_EVAPORATION || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LOSS_TO_SUBSOIL || || NUMBER(22, 2) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||
 
+
|-
|}
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WOFOST_HRES_STU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||
{|class="wikitable"
+
|-
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||
 +
|-
 +
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||
 +
|-
 +
| MAX_TRANSPIRATION || True || NUMBER ||  ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||
 +
|-
 +
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||
 +
|-
 +
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||
 +
|-
 +
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||
 +
|-
 +
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 +
|-
 +
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER || ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,691: Line 3,479:
 
<!-- end -->
 
<!-- end -->
  
== SOIL-datasets ==
 
{{TocTable|content=
 
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
 
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
 
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
 
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 
}}
 
  
  
 
<!-- start -->
 
<!-- start -->
=== SOIL_HORIZONS ===
+
=== SIM_WOFOST_HRES_EMU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,711: Line 3,494:
 
! 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
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
|-
 
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| HORIZON || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| ORIGINAL_LEVEL || || NUMBER(22, 1) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_WP || || NUMBER(22) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_FC || || NUMBER(22) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_SAT || || NUMBER(22) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| DEPTH || || NUMBER(22, 5) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| USDA_CLASS# || || NUMBER(22, 3) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| USDA_CLASS || || VARCHAR2(8) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| GRAVEL || || NUMBER(22, 3) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| SAND || || NUMBER(22, 3) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| SILT || || NUMBER(22, 3) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || True || NUMBER ||  ||  
 
|-
 
|-
| CLAY || || NUMBER(22, 3) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || True || NUMBER ||  ||  
 
|-
 
|-
| BULK_DENSITY || || NUMBER(22, 5) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || True || NUMBER ||  ||  
 
|-
 
|-
| ORGANIC_CARBON || || NUMBER(22, 5) ||  ||  
+
| FSM || True || NUMBER ||  ||  
 
|-
 
|-
| PH_H2O || || NUMBER(22, 5) ||  ||  
+
| FSMUR || True || NUMBER ||  ||  
 
|-
 
|-
| CLAY_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| LEAVES_DIED_BY_COLD || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| RUNOFF || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_BASE_SATURATION || || NUMBER(22, 3) ||  ||  
+
| SOIL_EVAPORATION || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_EXCHANGEABLE_BASE || || NUMBER(22, 5) ||  ||
+
| LOSS_TO_SUBSOIL || True || NUMBER ||  ||  
|-
 
| CALCIUM_CARBONATE ||  || NUMBER(22, 5) ||  ||
 
|-
 
| CALCIUM_SULPHATE ||  || NUMBER(22, 5) ||  ||
 
|-
 
| EXCHANGEABLE_SODIUM ||  || NUMBER(22, 3) ||  ||
 
|-
 
| ELECTRICAL_CONDUCTIVITY ||  || NUMBER(22, 5) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,769: Line 3,542:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SOIL_INITIAL_WATER ===
+
=== SIM_WOFOST_HRES_EMU_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,781: Line 3,558:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| INITIAL_DEPTH_GROUND_WATER || || NUMBER(22, 4) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DRAINAGE_DEPTH || || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| ROOTING_DEPTH_POTENTIAL_WATER || || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_WATER_STAR