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

From Agri4castWiki
Jump to: navigation, search
(CROP_PARAMETRIZATION_PARAMETER)
 
(62 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''.
 
  
 +
=== CROP_SUITABILITY_RULES ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 229: 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_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| VALUEC || True || VARCHAR2 ||  ||
 +
|-
 +
| VALUEN_MIN || True || NUMBER ||  ||
 +
|-
 +
| VALUEN_MAX || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 239: Line 248:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_SUITABILITY_RULES ===
+
=== 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 251: 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
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) || ||  
+
| IDVARIETY || False || NUMBER || - || unique identifier for variety
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) || ||  
+
| VARIETY || False || VARCHAR2 || - || variety name
 
|-
 
|-
| VALUEC || || VARCHAR2(30) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 || - || variety description
|-
 
| VALUEN_MIN ||  || NUMBER(22) ||  ||
 
|-
 
| VALUEN_MAX ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 265: Line 274:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETIES ===
 
''Table''.
 
  
 +
=== CROP_VARIETY_PARAMETERS ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 277: 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 || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| YVALUE || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 287: Line 303:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_PARAMETERS ===
+
=== CROP_VARIETY_REGIMES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 299: 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 311: 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_PARAMETERS_OLD ===
+
=== 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 323: 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
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| YVALUE ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    idcategory
 +
  , category
 +
  , descriptor
 +
from categories@cgms14sys_assistdas
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== CROP_VARIETY_REGIMES ===
+
=== GLOBAL_COVERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 347: 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
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCOVER || False || NUMBER ||  ||  
|-
 
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| DECADE || NOT NULL || NUMBER(22) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
|}
 
<!-- end -->
 
  
== GLOBAL-datasets ==
+
'''definition:'''
{{TocTable|content=
+
select
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
+
    c.idcover
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
+
  , c.cover
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
+
  , c.descriptor
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
+
from covers@CGMS14SYS_ASSISTDAS c
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
+
|}
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
+
<!-- end -->
{{TocRow|#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES}}
+
 
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE}}
 
{{TocRow|#GLOBAL_MODELS|2.9 GLOBAL_MODELS}}
 
{{TocRow|#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS}}
 
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS}}
 
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
 
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
 
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES}}
 
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES}}
 
{{TocRow|#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS}}
 
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS}}
 
{{TocRow|#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS}}
 
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
 
}}
 
  
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CATEGORIES ===
+
=== GLOBAL_COVER_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 395: 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
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||
 +
|-
 +
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
  c.idcover_source
 +
  , c.cover_source
 +
  , c.descriptor
 +
  , c.unc
 +
from cover_sources@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVERS ===
+
=== GLOBAL_CROPS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 417: 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
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||
 +
|-
 +
| EUROSTAT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 428: Line 487:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     c.idcover
+
     c.idcrop
   , c.cover
+
   , c.crop
 
   , c.descriptor
 
   , c.descriptor
  from covers@CGMS14SYS_ASSISTSAN c
+
  , c.eurostat
 +
  from crops@CGMS14SYS_ASSISTDAS c
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVER_SOURCES ===
+
=== GLOBAL_CROP_PARAMETERS ===
''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 446: 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
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || -
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || -
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || -
 
|-
 
|-
| UNC || || VARCHAR2(255) || ||  
+
| MULTI || False || VARCHAR2 || Y/N || single value (x) or AFGEN function (xy)
 +
|-
 +
| IDCATEGORY || False || NUMBER || - || -
 +
|-
 +
| CATEGORY || False || VARCHAR2 || - || CROP/MODEL
 
|-
 
|-
 
|}
 
|}
 
  
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
   c.idcover_source
+
    cp.idcrop_parameter
   , c.cover_source
+
  , cp.crop_parameter
   , c.descriptor
+
   , cp.descriptor
   , c.unc
+
   , cp.multi
  from cover_sources@CGMS14SYS_ASSISTSAN c
+
   , cp.idcategory
 +
   , c.category
 +
  from
 +
    crop_parameters@CGMS14SYS_ASSISTDAS cp
 +
  , categories@CGMS14SYS_ASSISTDAS c
 +
where cp.idcategory = c.idcategory
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROPS ===
+
=== GLOBAL_EVENTS ===
''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 478: 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 || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDEVENT || False || NUMBER || - || unique identifier for event
|-
 
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| EVENT || False || VARCHAR2 || - || event name
 
|-
 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || description of event
 
|-
 
|-
 
|}
 
|}
 
  
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    c.idcrop
+
    idevent
  , c.crop
+
  , event
  , c.descriptor
+
  , c.descriptor
  , c.eurostat
+
  from events@cgms14sys_assistdas c
  from crops@CGMS14SYS_ASSISTSAN c
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROP_PARAMETERS ===
 
''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_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| MULTI || NOT NULL || VARCHAR2(1) ||  ||
 
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
|}
 
 
|}
 
<!-- end -->
 
 
<!-- start -->
 
 
=== GLOBAL_GRIDS ===
 
=== GLOBAL_GRIDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 538: 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
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_16 || || NUMBER(22) ||  ||  
+
| ALTITUDE_16 || True || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_25 || || NUMBER(22) ||  ||  
+
| ALTITUDE_25 || True || NUMBER ||  ||  
 
|-
 
|-
| X || NOT NULL || NUMBER(22) ||  ||  
+
| X || False || NUMBER ||  ||  
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| Y || False || NUMBER ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST || || NUMBER(22) ||  ||  
+
| DISTANCE_FROM_COAST || True || NUMBER ||  ||  
 
|-
 
|-
| CLIMATE_BARRIER || || NUMBER(22) ||  ||  
+
| CLIMATE_BARRIER || True || NUMBER ||  ||  
 
|-
 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||  
+
| HAS_LAND || False || VARCHAR2 ||  ||  
 
|-
 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| GRID_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 591: Line 638:
 
   , resolution
 
   , resolution
 
   , unit
 
   , unit
  from grids@CGMS14SYS_ASSISTSAN g
+
  from grids@CGMS14SYS_ASSISTDAS g
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , grid_sources@CGMS14SYS_ASSISTSAN gs
+
   , grid_sources@CGMS14SYS_ASSISTDAS gs
 
  where g.idgrid_source = gs.idgrid_source
 
  where g.idgrid_source = gs.idgrid_source
 
   and gs.idwindow = w.idwindow
 
   and gs.idwindow = w.idwindow
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_GRID_SOURCES ===
 
=== GLOBAL_GRID_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 610: 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
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 639: Line 690:
 
   , gs.description
 
   , gs.description
 
   , gs.unc
 
   , gs.unc
  from grid_sources@CGMS14SYS_ASSISTSAN gs
+
  from grid_sources@CGMS14SYS_ASSISTDAS gs
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
 
  where gs.idwindow = w.idwindow
 
  where gs.idwindow = w.idwindow
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
 
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 656: 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
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| COVER_SOURCE_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| COVER_SOURCE_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 685: Line 740:
 
   , cover_source
 
   , cover_source
 
   , cs.descriptor as cover_source_descriptor
 
   , cs.descriptor as cover_source_descriptor
  from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
+
  from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
   , windows@CGMS14SYS_ASSISTSAN w
+
   , windows@CGMS14SYS_ASSISTDAS w
   , covers@CGMS14SYS_ASSISTSAN c
+
   , covers@CGMS14SYS_ASSISTDAS c
   , cover_sources@CGMS14SYS_ASSISTSAN cs
+
   , cover_sources@CGMS14SYS_ASSISTDAS cs
 
  where lcws.idwindow = w.idwindow
 
  where lcws.idwindow = w.idwindow
 
   and lcws.idcover = c.idcover
 
   and lcws.idcover = c.idcover
Line 697: Line 752:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_MODELS ===
 
=== GLOBAL_MODELS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 709: 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
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 723: Line 782:
 
   , m.model
 
   , m.model
 
   , m.descriptor
 
   , m.descriptor
  from models@CGMS14SYS_ASSISTSAN m
+
  from models@CGMS14SYS_ASSISTDAS m
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGIONS ===
 
=== GLOBAL_REGIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 738: 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 ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POPULATION || || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 758: Line 821:
 
   , r.continent
 
   , r.continent
 
   , r.population
 
   , r.population
  from regions@CGMS14SYS_ASSISTSAN r
+
  from regions@CGMS14SYS_ASSISTDAS r
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_ELEMENTS ===
 
=== GLOBAL_REGION_ELEMENTS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 773: 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
 
|-
 
|-
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_ELEMENT || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| GLOBAL_NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| GLOBAL_NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LOCAL_NAME || || VARCHAR2(255) ||  ||  
+
| LOCAL_NAME || True || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  ||  
+
| REGION_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| POPULATION || || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
| STANDARD || NOT NULL || VARCHAR2(20) ||  ||  
+
| STANDARD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDFATHER || || NUMBER(22, 12) ||  ||  
+
| IDFATHER || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 817: Line 884:
 
   , re.idregion_source
 
   , re.idregion_source
 
   , rs.region_source
 
   , rs.region_source
  from region_elements@CGMS14SYS_ASSISTSAN re
+
  from region_elements@CGMS14SYS_ASSISTDAS re
   , regions@CGMS14SYS_ASSISTSAN r
+
   , regions@CGMS14SYS_ASSISTDAS r
   , region_sources@CGMS14SYS_ASSISTSAN rs
+
   , region_sources@CGMS14SYS_ASSISTDAS rs
 
  where re.idregion = r.idregion
 
  where re.idregion = r.idregion
 
   and re.idregion_source = rs.idregion_source
 
   and re.idregion_source = rs.idregion_source
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_REGION_SOURCES ===
 
=== GLOBAL_REGION_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 836: 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
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 853: Line 924:
 
   , r.description
 
   , r.description
 
   , r.unc
 
   , r.unc
  from region_sources@CGMS14SYS_ASSISTSAN r
+
  from region_sources@CGMS14SYS_ASSISTDAS r
 
  order by idregion_source
 
  order by idregion_source
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_SOIL_SOURCES ===
 
=== GLOBAL_SOIL_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 869: Line 944:
 
! 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
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| SOIL_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| SOIL_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 883: Line 958:
 
   , s.soil_source
 
   , s.soil_source
 
   , s.descriptor
 
   , s.descriptor
  from soil_sources@CGMS14SYS_ASSISTSAN s
+
  from soil_sources@CGMS14SYS_ASSISTDAS s
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
+
=== GLOBAL_STATIONS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 898: 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
 
|-
 
|-
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATION || False || NUMBER ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| STATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| ORGANIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
|}
+
| IDWMO || True || NUMBER || ||
 
+
|-
 
+
| WMO || True || VARCHAR2 || ||
'''definition:'''
+
|-
  select
+
| LATITUDE || False || NUMBER ||  ||
    s.idstatistic_source
 
  , s.statistic_source
 
  , s.descriptor
 
  from statistic_sources@CGMS14SYS_ASSISTSAN s
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== GLOBAL_SUITABILITY_PROPERTIES ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| LONGITUDE || False || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| Y_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| X_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
|}
+
| IDCLIMATE_ZONE || False || NUMBER ||  ||
 
+
|-
 
+
| COUNTRY || False || VARCHAR2 ||  ||
'''definition:'''
+
|-
  select
+
| DISTANCE_TO_COAST || False || NUMBER || ||
    p.idsuitability_property
+
|-
  , p.suitability_property
+
| ANGSTROM_A || False || NUMBER ||  ||
  , p.descriptor
+
|-
  from suitability_properties@CGMS14SYS_ASSISTSAN p
+
| ANGSTROM_B || False || NUMBER || ||
|}
+
|-
<!-- end -->
+
| SUPIT_A || False || NUMBER ||  ||
 
+
|-
<!-- start -->
+
| SUPIT_B || False || NUMBER ||  ||
=== GLOBAL_THRESHOLDS ===
+
|-
''View''.
+
| SUPIT_C || False || NUMBER ||  ||
 
+
|-
{|class="collapsing_table collapsible collapsed"
+
| HARGREAVES_A || False || NUMBER ||  ||
!Structure
+
|-
 +
| HARGREAVES_B || False || NUMBER ||  ||
 
|-
 
|-
|
+
| RELIABLE_STATION || False || NUMBER ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  ||  
+
| ACTIVE_STATION || False || NUMBER ||  ||  
 
|-
 
|-
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVAIL_PRECIPITATION_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVAIL_SNOWDEPTH_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVAIL_TEMPERATURE_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  ||  
+
| AVAIL_HUMIDITY_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  ||  
+
| AVAIL_REST_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 973: Line 1,036:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     t.idthreshold
+
     IDSTATION
   , t.threshold
+
   , STATION
   , t.indicator
+
   , ORGANIZATION
   , t.operator
+
   , IDWMO
   , t.value_min
+
   , WMO
   , t.value_max
+
   , LATITUDE
from thresholds@CGMS14SYS_ASSISTSAN t
+
  , LONGITUDE
   , windows@CGMS14SYS_ASSISTSAN w
+
  , Y_COORDINATE
  where t.idwindow = w.idwindow
+
  , 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 -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_TIME_DIMENSIONS ===
+
=== GLOBAL_STATISTIC_SOURCES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 996: Line 1,082:
 
! 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
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| IDSTATISTIC_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| DECADE || || NUMBER(22) ||  ||  
+
| STATISTIC_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DECADE_ID || || NUMBER(22) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MONTH ||  || NUMBER(22) ||  ||
+
|}
|-
+
 
| MONTH_ID ||  || NUMBER(22) ||  ||
+
 
|-
 
| QUARTER ||  || NUMBER(22) ||  ||
 
|-
 
| QUARTER_ID ||  || NUMBER(22) ||  ||
 
|-
 
| YEAR ||  || NUMBER(22) ||  ||
 
|-
 
| LAST_DAY_DECADE ||  || VARCHAR2(1) ||  ||
 
|-
 
|}
 
 
 
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     t.day
+
     s.idstatistic_source
   , t.decade
+
   , s.statistic_source
   , t.decade_id
+
   , s.descriptor
  , t.month
+
  from statistic_sources@CGMS14SYS_ASSISTDAS s
  , t.month_id
 
  , t.quarter
 
  , t.quarter_id
 
  , t.year
 
  , t.last_day_decade
 
  from time_dimensions@CGMS14SYS_ASSISTSAN t
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_TREATMENTS ===
+
=== GLOBAL_SUITABILITY_PROPERTIES ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,043: Line 1,115:
 
! 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
 
|-
 
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| TREATMENT || NOT NULL || VARCHAR2(60) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,054: Line 1,126:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     t.idtreatment
+
     p.idsuitability_property
   , t.treatment
+
   , p.suitability_property
   , t.descriptor
+
   , p.descriptor
  from treatments@cgms14sys_assistsan t
+
  from suitability_properties@CGMS14SYS_ASSISTDAS p
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_WINDOWS ===
+
=== GLOBAL_THRESHOLDS ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,072: Line 1,148:
 
! 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
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDTHRESHOLD || False || NUMBER ||  ||  
|-
 
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||
 
|-
 
| NAME || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  ||
 
|-
 
| DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
 
|-
 
|-
| MAX_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| THRESHOLD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_LON || NOT NULL || NUMBER(22) ||  ||  
+
| INDICATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| OPERATOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MIN_LON || NOT NULL || NUMBER(22) ||  ||  
+
| VALUE_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_X || NOT NULL || NUMBER(22) ||  ||
+
| VALUE_MAX || False || NUMBER ||  ||  
|-
 
| MAX_Y || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| MIN_X || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| MIN_Y || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| ROI ||  || NUMBER(22, 3) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,105: Line 1,165:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     w.idwindow
+
     t.idthreshold
   , w.window
+
   , t.threshold
   , w.name
+
   , t.indicator
   , w.reference_system
+
   , t.operator
   , w.descriptor
+
   , t.value_min
   , w.max_lat
+
   , t.value_max
  , w.max_lon
+
from thresholds@CGMS14SYS_ASSISTDAS t
   , w.min_lat
+
   , windows@CGMS14SYS_ASSISTDAS w
  , w.min_lon
+
where t.idwindow = w.idwindow
  , w.max_x
 
  , w.max_y
 
  , w.min_x
 
  , w.min_y
 
  , w.roi
 
from windows@CGMS14SYS_ASSISTSAN w
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
== LINK-datasets ==
+
 
{{TocTable|content=
+
 
{{TocRow|#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION}}
+
<!-- start -->
{{TocRow|#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS}}
+
=== GLOBAL_TIME_DIMENSIONS ===
{{TocRow|#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS}}
+
* Description:
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP}}
+
* Use:
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL}}
+
* Type: ''View''
{{TocRow|#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION}}
+
* Remarks:
{{TocRow|#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS}}
+
{|class="collapsing_table collapsible collapsed"
{{TocRow|#LINK_CROP_STU|3.8 LINK_CROP_STU}}
+
!Structure
{{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}}
+
{|class="wikitable"
{{TocRow|#LINK_REGION_COVER|3.12 LINK_REGION_COVER}}
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
{{TocRow|#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT}}
+
|-
{{TocRow|#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP}}
+
| DAY || False || DATE || ||  
{{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 -->
 
=== LINK_CROP_AGGREGATION ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| DECADE || 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) ||  ||  
+
| DECADE_ID || True || NUMBER ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MONTH || True || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| MONTH_ID || True || NUMBER ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| QUARTER || True || NUMBER ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| QUARTER_ID || True || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| YEAR || True || NUMBER ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||
+
| LAST_DAY_DECADE || True || VARCHAR2 ||  ||  
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,184: Line 1,215:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     ca.idcrop_aggregation
+
     t.day
   , ca.idcrop
+
   , t.decade
   , c.crop
+
   , t.decade_id
   , c.descriptor
+
   , t.month
   , cp.idmodel
+
   , t.month_id
   , m.model
+
   , t.quarter
   , m.descriptor
+
   , t.quarter_id
   , ca.idcrop_parametrization
+
   , t.year
   , cp.crop_parametrization
+
   , t.last_day_decade
  , cp.descriptor as parametrization_descriptor
+
  from time_dimensions@CGMS14SYS_ASSISTDAS t
  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 -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_CALENDARS ===
+
=== GLOBAL_TREATMENTS ===
''View''.  
+
* 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
 +
|-
 +
| IDTREATMENT || False || NUMBER ||  ||
 +
|-
 +
| TREATMENT || False || VARCHAR2 ||  ||
 +
|-
 +
| DESCRIPTOR || False || VARCHAR2 ||  ||
 +
|-
 +
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    t.idtreatment
 +
  , t.treatment
 +
  , t.descriptor
 +
from treatments@cgms14sys_ASSISTDAS t
 +
|}
 +
<!-- end -->
 +
 
 +
 
  
 +
<!-- start -->
 +
=== GLOBAL_WINDOWS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,216: Line 1,276:
 
! 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) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||
 +
|-
 +
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REFERENCE_SYSTEM || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_LON || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_LON || False || NUMBER ||  ||  
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_X || False || NUMBER ||  ||  
 
|-
 
|-
| START_DATE || || DATE ||  ||  
+
| MAX_Y || False || NUMBER ||  ||  
 
|-
 
|-
| END_DATE || || DATE ||  ||  
+
| MIN_X || False || NUMBER ||  ||  
 
|-
 
|-
| DURATION || || NUMBER(22) ||  ||  
+
| MIN_Y || False || NUMBER ||  ||  
 
|-
 
|-
| START_DOY || || NUMBER(22) ||  ||  
+
| ROI || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,247: Line 1,309:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     w.idwindow
   , cp.crop_parametrization
+
   , w.window
   , m.idmodel
+
   , w.name
   , m.model
+
   , w.reference_system
   , c.idcover
+
   , w.descriptor
   , c.cover
+
   , w.max_lat
   , cc.idgrid
+
   , w.max_lon
   , cc.year
+
   , w.min_lat
   , cc.start_period
+
   , w.min_lon
   ,
+
   , w.max_x
  case
+
   , w.max_y
      when start_period = 'emergence' then emergence
+
   , w.min_x
      when start_period = 'sowing' then sowing
+
   , w.min_y
  end
+
   , w.roi
    start_date
+
from windows@CGMS14SYS_ASSISTDAS w
   ,
 
  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 -->
+
== LINK-datasets ==
=== LINK_CROP_PARAMETERS ===
+
{{TocTable|content=
''Table''.  
+
{{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 -->
 +
=== LINK_CROP_AGGREGATION ===
 +
* Description: relation between simulated crop parameterizations and crop aggregation areas.
 +
* Use:
 +
* Type: ''Materialized View''
 +
* Remarks: One simulated crop parametetrization can be combined with multiple aggregation areas to create alternative aggregated crops. The object contains records from {{Object|CROP_AGGREGATIONS}}, with extra descriptive fields.
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,295: 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_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCROP_AGGREGATION || False || NUMBER || - || aggregated crop number
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP || False || NUMBER || - || global crop number
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| CROP || False || VARCHAR2 || - || global crop name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 || - || global crop description
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) || ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 || - || crop model description
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || simulated crop number
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || simulated crop name
 
|-
 
|-
| YVALUE || || NUMBER(22) || ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 || - || simulated crop description
 
|-
 
|-
 
|}
 
|}
  
|}
 
<!-- end -->
 
  
<!-- start -->
+
'''definition:'''
=== LINK_CROP_PARAMETERS_CROP ===
+
select
''Table''.
+
    ca.idcrop_aggregation
 
+
  , ca.idcrop
{|class="collapsing_table collapsible collapsed"
+
  , c.crop
!Structure
+
  , c.descriptor
|-
+
  , cp.idmodel
|
+
  , m.model
{|class="wikitable"
+
  , m.descriptor
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
+
  , ca.idcrop_parametrization
|-
+
  , cp.crop_parametrization
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
+
  , cp.descriptor as parametrization_descriptor
|-
+
  from cgms14chn.crop_aggregations ca
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
+
  , cgms14chn.crop_parametrizations cp
|-
+
  , cgms14chn.global_models m
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||
+
  , cgms14chn.global_crops c
|-
+
  where ca.idcrop = c.idcrop
| MODEL || NOT NULL || VARCHAR2(30) || ||
+
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
|-
+
  and  cp.idmodel = m.idmodel
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
+
  order by ca.idcrop_aggregation
|-
 
| 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) ||  ||
 
|-
 
 
|}
 
|}
 +
<!-- end -->
 +
  
|}
 
<!-- end -->
 
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS_MODEL ===
 
''Table''.
 
  
 +
=== LINK_CROP_CALENDARS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,375: Line 1,426:
 
! 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_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| START_PERIOD || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| START_DATE || True || DATE ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| END_DATE || True || DATE ||  ||
 +
|-
 +
| DURATION || True || NUMBER ||  ||
 +
|-
 +
| START_DOY || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
  
|}
 
<!-- end -->
 
 
<!-- start -->
 
=== LINK_CROP_PARAMETRIZATION ===
 
''View''.
 
  
 +
'''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 -->
 +
 +
 +
 +
<!-- start -->
 +
=== LINK_CROP_PARAMETERS ===
 +
* Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
 +
* Use: default crop parameter values in case no variety specific crop parameters are available.
 +
* Type: ''Materialized View''
 +
* Remarks: Contains records from {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,413: 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_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 +
|-
 +
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 +
|-
 +
| IDMODEL || False || NUMBER || - || crop model number
 +
|-
 +
| MODEL || False || VARCHAR2 || - || crop model name
 +
|-
 +
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) || ||  
+
| IDCATEGORY || False || NUMBER || - || parameter category number
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| CATEGORY || False || VARCHAR2 || - || parameter category name
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
 
     cp.idcrop_parametrization
 
     cp.idcrop_parametrization
 
   , cp.crop_parametrization
 
   , cp.crop_parametrization
   , cp.descriptor
+
   , m.idmodel
  , cp.idmodel
 
 
   , m.model
 
   , m.model
  , m.descriptor
 
 
   , c.idcover
 
   , c.idcover
 
   , c.cover
 
   , c.cover
   , c.descriptor
+
   , cps.idcrop_parameter
  from crop_parametrizations cp
+
  , cps.crop_parameter
  , global_models m
+
  , cps.descriptor
 +
  , cps.idcategory
 +
  , cps.category
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
  from
 +
    global_models m
 
   , global_covers c
 
   , global_covers c
  where cp.idmodel = m.idmodel
+
  , crop_parametrization_parameter cpp
  and  cp.idcover = c.idcover
+
  , crop_parametrizations cp
  order by cp.idcrop_parametrization
+
  , 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 -->
 
<!-- end -->
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_SPATIALIZATIONS ===
 
''View''.
 
  
 +
=== 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"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,465: Line 1,581:
 
! 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
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
|-
 
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
| YVALUE ||  || NUMBER(22) ||  ||
 
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
Line 1,504: Line 1,612:
 
   , c.idcover
 
   , c.idcover
 
   , c.cover
 
   , c.cover
  , cs.idgrid
 
  , v.idvariety
 
  , v.variety
 
 
   , cps.idcrop_parameter
 
   , cps.idcrop_parameter
 
   , cps.crop_parameter
 
   , cps.crop_parameter
 
   , cps.descriptor
 
   , cps.descriptor
   , cvp.xvalue
+
   , cpp.xvalue
   , cvp.yvalue
+
   , cpp.yvalue
  from global_models m
+
  from
 +
    global_models m
 
   , global_covers c
 
   , global_covers c
   , crop_varieties v
+
   , crop_parametrization_parameter cpp
 
   , crop_parametrizations cp
 
   , crop_parametrizations cp
  , crop_spatializations cs
 
 
   , global_crop_parameters cps
 
   , global_crop_parameters cps
  , crop_variety_parameters cvp
+
  where cpp.idcrop_parametrization       = cp.idcrop_parametrization
  where cs.idcrop_parametrization = cp.idcrop_parametrization
+
and   cpp.idcrop_parameter              = cps.idcrop_parameter
  and cp.idcover = c.idcover
+
and   cp.idcover                        = c.idcover
  and cs.idvariety = v.idvariety
+
and   cp.idmodel                       = m.idmodel
  and cp.idmodel = m.idmodel
+
and   lower(cp.active_parametrization)  = lower('Y')
  and cs.idvariety = cvp.idvariety
+
and   lower(cps.category)              = lower('CROP')
  and cvp.idcrop_parameter = cps.idcrop_parameter
+
  order by cpp.idcrop_parametrization, cps.crop_parameter
  and cp.active_parametrization = 'y'
 
  order by cs.idcrop_parametrization
 
  , cs.idgrid
 
  , cps.crop_parameter
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_STU ===
 
''Table''.
 
  
 +
=== 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"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,543: Line 1,649:
 
! 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_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 +
|-
 +
| IDMODEL || False || NUMBER || - || crop model number
 +
|-
 +
| MODEL || False || VARCHAR2 || - || crop model name
 +
|-
 +
| IDCOVER || False || NUMBER || - || crop mask number
 +
|-
 +
| COVER || False || VARCHAR2 || - || crop mask name
 +
|-
 +
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 +
|-
 +
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 +
|-
 +
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 +
|-
 +
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 +
|-
 +
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
+
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , 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('MODEL')
 +
order by cpp.idcrop_parametrization, cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_VARIETY_PARAMETERS ===
 
''View''.
 
  
 +
=== 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"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,563: Line 1,717:
 
! 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_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| TAG || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| ACTIVE_PARAMETRIZATION || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) || ||  
+
| VIEWER_ENABLED || False || VARCHAR2 || Y/N ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||
+
| COVER_DESCRIPTOR || False || VARCHAR2 ||  ||  
|-
 
| YVALUE ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,594: Line 1,746:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    "IDCROP_PARAMETRIZATION","CROP_PARAMETRIZATION","IDMODEL","MODEL","IDCOVER","COVER","IDVARIETY","VARIETY","IDCROP_PARAMETER","CROP_PARAMETER","DESCRIPTOR","XVALUE","YVALUE"
+
    cp.idcrop_parametrization
  from
+
  , cp.crop_parametrization
    (
+
  , cp.descriptor as parametrization_descriptor
    select distinct
+
  , cp.tag
        cp.idcrop_parametrization
+
  , cp.active_parametrization
      , cp.crop_parametrization
+
  , cp.viewer_enabled
      , m.idmodel
+
  , cp.idmodel
      , m.model
+
  , m.model
      , c.idcover
+
  , m.descriptor as model_descriptor
      , c.cover
+
  , c.idcover
      , v.idvariety
+
  , c.cover
      , v.variety
+
  , c.descriptor as cover_descriptor
      , cps.idcrop_parameter
+
from
      , cps.crop_parameter
+
    crop_parametrizations cp
      , cps.descriptor
+
  , global_models        m
      , cvp.xvalue
+
  , global_covers        c
      , cvp.yvalue
+
where cp.idmodel = m.idmodel
    from cgms14chn.global_models m
+
and   cp.idcover = c.idcover
      , global_covers c
+
order by cp.idcrop_parametrization
      , 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'
 
    ) a
 
  order by idcrop_parametrization
 
    , idvariety
 
    , crop_parameter
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_GRID_COVER ===
 
''Table''.
 
  
 +
=== LINK_CROP_SPATIALIZATIONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,643: 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
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
 +
|-
 +
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||
 +
|-
 +
| IDMODEL || False || NUMBER ||  ||
 +
|-
 +
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
|}
+
| IDGRID || False || NUMBER ||  ||
 
+
|-
|}
+
| IDVARIETY || False || NUMBER ||  ||
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_GRID_REGION_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| VARIETY || False || VARCHAR2 ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || False || NUMBER ||  ||  
 
|-
 
|-
|}
+
| YVALUE || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_REGION_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
|}
 
<!-- end -->
 
  
<!-- start -->
+
'''definition:'''
=== LINK_SIMULATION_UNIT ===
+
select
''View''.
+
    cp.idcrop_parametrization
 
+
  , cp.crop_parametrization
{|class="collapsing_table collapsible collapsed"
+
  , m.idmodel
!Structure
+
  , 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
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
 
! 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) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
 +
 +
|}
 +
<!-- end -->
 +
  
  
'''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 -->
 
<!-- start -->
=== LINK_SIMULATION_UNIT_CROP ===
+
=== LINK_CROP_VARIETY_PARAMETERS ===
''View''.
+
* 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,748: 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
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 +
|-
 +
| MODEL || False || VARCHAR2 || - || crop model name
 +
|-
 +
| IDCOVER || False || NUMBER || - || crop mask number
 +
|-
 +
| COVER || False || VARCHAR2 || - || crop mask name
 +
|-
 +
| IDVARIETY || False || NUMBER || - || variety number
 +
|-
 +
| VARIETY || False || VARCHAR2 || - || variety name
 +
|-
 +
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 +
|-
 +
| CROP_PARAMETER || False || VARCHAR2 ||  || parameter name
 +
|-
 +
| DESCRIPTOR || False || VARCHAR2 ||  || parameter description and unit
 +
|-
 +
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 +
|-
 +
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
Line 1,758: Line 1,920:
  
 
'''definition:'''
 
'''definition:'''
  select
+
  select  
distinct
+
    *
    ca.idcrop_parametrization
 
  , lgsc.idgrid
 
  , lss.idstu
 
 
  from
 
  from
    link_crop_stu lcs
+
    (
  , link_smu_grid_cover lgsc
+
    select distinct
  , link_smu_stu lss
+
        cp.idcrop_parametrization
  , crop_aggregations ca
+
      , cp.crop_parametrization
  , crop_parametrizations cp
+
      , m.idmodel
where lcs.idstu                = lss.idstu
+
      , m.model
and   lss.idsmu                = lgsc.idsmu
+
      , c.idcover
and   lcs.idcrop                = ca.idcrop
+
      , c.cover
and   ca.idcrop_parametrization = cp.idcrop_parametrization
+
      , v.idvariety
and   cp.idcover                = lgsc.idcover
+
      , v.variety
  order by
+
      , cps.idcrop_parameter
    ca.idcrop_parametrization
+
      , cps.crop_parameter
  , lgsc.idgrid
+
      , cps.descriptor
  , lss.idstu
+
      , cvp.xvalue
|}
+
      , cvp.yvalue
<!-- end -->
+
    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 -->
 
<!-- start -->
=== LINK_SMU_GRID_COVER ===
 
''Table''.
 
  
 +
=== LINK_GRID_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,792: Line 1,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
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
+
| AREA || False || NUMBER ||  ||  
|-
 
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,804: Line 1,987:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SMU_GRID_REGION_COVER ===
+
=== LINK_GRID_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,816: Line 2,003:
 
! 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) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
+
| AREA || False || NUMBER ||  ||  
|-
 
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,830: Line 2,015:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SMU_STU ===
+
=== LINK_REGION_COVER ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,842: Line 2,031:
 
! 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 || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,852: Line 2,041:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_STU_HORIZONS ===
+
=== LINK_SIMULATION_UNIT ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,864: Line 2,057:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDSTU || False || NUMBER ||  ||  
|-
 
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||
 
|-
 
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||
 
|-
 
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
|}
 
<!-- end -->
 
 
<!-- start -->
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
 
''View''.
 
  
 +
'''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"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,890: Line 2,098:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| SAND || || NUMBER(22) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| SILT || || NUMBER(22) ||  ||
+
| IDSTU || False || NUMBER ||  ||  
|-
 
| CLAY ||  || NUMBER(22) ||  ||
 
|-
 
| SOIL_MOISTURE_WP ||  || NUMBER(22) ||  ||
 
|-
 
| SOIL_MOISTURE_FC ||  || NUMBER(22) ||  ||
 
|-
 
| SOIL_MOISTURE_SAT ||  || NUMBER(22) ||  ||
 
|-
 
| BULK_DENSITY ||  || NUMBER(22) ||  ||
 
|-
 
| ORGANIC_CARBON ||  || NUMBER(22) ||  ||
 
|-
 
| DEPTH ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 1,915: Line 2,109:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
    idstu                                                                                idstu
+
  distinct
  , sum(sand                      * (depth_max - depth_min)) / sum(depth_max - depth_min) sand
+
    ca.idcrop_parametrization
  , sum(silt                      * (depth_max - depth_min)) / sum(depth_max - depth_min) silt
+
   , lgsc.idgrid
  , sum(clay                      * (depth_max - depth_min)) / sum(depth_max - depth_min) clay
+
   , lss.idstu
  , 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
 
  from
     link_stu_horizons  lsh
+
     link_crop_stu lcs
   , soil_horizons      sh
+
  , link_smu_grid_cover lgsc
  where lsh.idhorizon = sh.idhorizon
+
  , link_smu_stu lss
  group by idstu
+
  , 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 -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== LINK_SUITABILITY_RULES ===
+
=== LINK_SMU_GRID_COVER ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,944: Line 2,146:
 
! 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) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| AREA || False || NUMBER ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_SMU_GRID_REGION_COVER ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| IDSMU || False || NUMBER ||  ||  
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||
+
| AREA || False || NUMBER ||  ||  
|-
 
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| SUITABILITY_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| SUITABILITY_PROPERTY_MIN ||  || NUMBER(22) ||  ||
 
|-
 
| SUITABILITY_PROPERTY_MAX ||  || NUMBER(22) ||  ||
 
|-
 
| SUITABILITY_PROPERTY_VALUE ||  || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
 +
 +
|}
 +
<!-- end -->
  
  
'''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 -->
 
  
== SIM-datasets ==
+
<!-- start -->
{{TocTable|content=
+
=== LINK_SMU_STU ===
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
+
* Description: Relative area of each STU inside a SMU.
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
+
* Use: used to find unique simulation units in elementary mapping units (see [[Spatial_schematization]]).
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
+
* Type: ''Table''
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
+
* Remarks: The total percentage per SMU adds up to 100%.
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
+
{|class="collapsing_table collapsible collapsed"
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
+
!Structure
{{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}}
+
{|class="wikitable"
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
+
|-
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
+
| IDSMU || False || NUMBER || - || unique identifier for the soil map unit
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
+
|-
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
+
| IDSTU || False || NUMBER || - || identifier to the soil typologic unit
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
+
|-
}}
+
| PERCENTAGE || False || NUMBER || - || % of area inside the SMU, covered by the STU
 +
|-
 +
|}
  
 +
|}
 +
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_GRID ===
 
''Table''.
 
  
 +
=== LINK_STU_HORIZONS ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,045: Line 2,229:
 
! 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) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DEPTH_MIN || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| DEPTH_MAX || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| HORIZON_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== LINK_STU_WEIGHTED_PARAMETERS ===
 +
* Description:
 +
* Use:
 +
* Type: ''View''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| IDSTU || False || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| SAND || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| SILT || True || NUMBER ||  ||  
 
|-
 
|-
| GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| CLAY || True || NUMBER ||  ||  
 
|-
 
|-
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| SOIL_MOISTURE_WP || True || NUMBER ||  ||  
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| SOIL_MOISTURE_FC || True || NUMBER ||  ||  
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| SOIL_MOISTURE_SAT || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| BULK_DENSITY || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| ORGANIC_CARBON || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DEPTH || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
+
|}
|-
+
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
|}
 
  
 +
'''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_BLAST_HRES_GRID_LTA ===
+
=== LINK_SUITABILITY_RULES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,109: 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_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| CROP_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MODEL_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY_MIN || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY_MAX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| SUITABILITY_PROPERTY_VALUE || True || VARCHAR2 ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||
+
|}
|-
+
 
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
+
 
|-
+
'''definition:'''
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) || ||
+
  select
|-
+
    ca.idcrop_aggregation
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
+
  , ca.idcrop
|-
+
  , c.crop
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
+
  , c.descriptor
|-
+
  , cp.idmodel
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
+
  , m.model
|-
+
  , m.descriptor
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
+
  , ca.idcrop_parametrization
|-
+
  , cp.crop_parametrization
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||
+
  , cp.descriptor
|-
+
  , sp.idsuitability_property
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||
+
  , sp.suitability_property
|-
+
  , sp.descriptor
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||
+
  , csr.valuen_min
|-
+
  , csr.valuen_max
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) || ||
+
  , csr.valuec
|-
+
  from global_suitability_properties sp
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
  , crop_suitability_rules        csr
|-
+
  , global_crops                  c
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
  , crop_aggregations              ca
|-
+
  , crop_parametrizations          cp
| MIN_GAIWITHBLAST || || NUMBER(22, 12) || ||
+
  , global_models                  m
|-
+
  where  ca.idcrop                  = c.idcrop
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
|-
+
  and  cp.idmodel                = m.idmodel
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||
+
  and  ca.idcrop                  = csr.idcrop
|-
+
  and  csr.idsuitability_property = sp.idsuitability_property
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
  order by ca.idcrop_aggregation
|-
+
  , ca.idcrop
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
  , csr.idsuitability_property
|-
+
|}
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) || ||  
+
<!-- end -->
|-
+
 
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
== SIM-datasets ==
|-
+
{{TocTable|content=
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) || ||  
+
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
|-
+
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
+
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
|-
+
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
+
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
|-
+
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
+
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
|-
+
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
+
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
|-
+
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
+
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
|-
+
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||
+
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
|-
+
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||
+
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
|-
+
}}
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||
+
 
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_GRID ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
|}
|-
+
 
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
|}
|-
+
<!-- end -->
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
+
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_GRID_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMAXIMUM || || NUMBER(22, 2) ||  ||  
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_LEAVESBIOMASSPOTENTIAL || 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) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_BLAST_HRES_REGION_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_STORAGEORGANSWITHBLAST || 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_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| NUM_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
|}
|-
+
 
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
|}
|-
+
<!-- end -->
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
+
 
|-
+
 
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
+
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_REGION ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_BLAST_HRES_REGION_LTA ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| AVG_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| AVG_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| AVG_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL || || NUMBER(22, 2) ||  ||  
+
| AVG_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
+
| AVG_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
+
| AVG_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMAXIMUM || || NUMBER(22, 2) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MIN_BLASTRISKLEVEL || True || NUMBER ||  ||
 
+
|-
|}
+
| MIN_BLASTINFECTION || True || NUMBER ||  ||
<!-- end -->
+
|-
 
+
| MIN_BLASTSPORULATION || True || NUMBER ||  ||
<!-- start -->
 
=== SIM_WARM_HRES_GRID ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_LEAVESBIOMASSPOTENTIAL || 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) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| MIN_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MAX_GAIWITHBLAST || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WARM_HRES_GRID_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_AGBPOTENTIAL || 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) ||  ||  
+
| MAX_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| STD_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| STD_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| STD_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTRISKLEVEL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTINFECTION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_BLASTSPORULATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| NUM_GAIPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_GAIWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_AGBPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_AGBWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_RUE_POTENTIAL || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_RUE_WITH_BLAST || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_HUMIDITYMINIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_HUMIDITYMAXIMUM || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_GRID ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
|
|-
+
{|class="wikitable"
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) || ||  
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||
+
| TRANSPIRATION || True || NUMBER ||  ||  
|-
 
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,831: Line 3,040:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION ===
+
=== SIM_WARM_HRES_GRID_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 2,843: Line 3,056:
 
! 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 ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||
 
+
|-
|}
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WARM_HRES_REGION_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_ABIOTIC_LIM_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) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| MAX_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY || || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 12) ||  ||  
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== SIM_WARM_HRES_REGION ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || False || NUMBER ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 12) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 12) ||  ||  
+
| YEAR || False || NUMBER ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| DOY || False || NUMBER ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION || || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 2) ||  ||  
+
| DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE || || NUMBER(22, 2) ||  ||  
+
| SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY || || NUMBER(22, 2) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE || || NUMBER(22, 2) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX || || NUMBER(22, 2) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||
+
| TRANSPIRATION || True || NUMBER ||  ||  
|-
 
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 3,073: Line 3,290:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU ===
+
=== SIM_WARM_HRES_REGION_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 3,085: Line 3,306:
 
! 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) ||  ||  
+
| MONTH || False || NUMBER ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAYMONTH || False || NUMBER ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| FSMUR || || NUMBER(22, 3) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| RUNOFF || || NUMBER(22, 8) ||  ||  
+
| AVG_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
|}
+
| MIN_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SIM_WOFOST_HRES_EMU_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE || 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) ||  ||
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||
 
|-
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||
 
|-
 
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||
 
|-
 
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||
 
|-
 
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||
 
|-
 
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||
 
|-
 
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||
 
|-
 
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||
 
|-
 
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MIN_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| MAX_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| STD_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| STD_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_TRANSPIRATION || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| NUM_DEVELOPMENT_STAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| NUM_SPIKELET_STERILITY || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS || True || NUMBER ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || True || NUMBER ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||
+
| NUM_TRANSPIRATION || True || NUMBER ||  ||  
|-
 
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_FSM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_FSMUR ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 3,319: Line 3,478:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_GRID ===
+
=== SIM_WOFOST_HRES_EMU ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks: