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

From Agri4castWiki
Jump to: navigation, search
(generated page)
Line 363: Line 363:
 
{{TocTable|content=
 
{{TocTable|content=
 
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
 
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
+
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.2 GLOBAL_CROP_PARAMETERS}}
{{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_GRIDS|2.6 GLOBAL_GRIDS}}
 
{{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}}
 
 
}}
 
}}
  
Line 386: Line 369:
 
<!-- start -->
 
<!-- start -->
 
=== GLOBAL_CATEGORIES ===
 
=== GLOBAL_CATEGORIES ===
''Table''.  
+
''Materialized_View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 398: Line 381:
 
|-
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||
 
|-
 
|}
 
 
|}
 
<!-- end -->
 
 
<!-- start -->
 
=== GLOBAL_COVERS ===
 
''View''.
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
|-
 
|
 
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
 
|-
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
Line 428: Line 389:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     c.idcover
+
     idcategory
   , c.cover
+
   , category
   , c.descriptor
+
   , descriptor
  from covers@CGMS14SYS_ASSISTSAN c
+
  from categories@CGMS14SYS_ASSISTSAN
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_COVER_SOURCES ===
+
=== GLOBAL_CROP_PARAMETERS ===
''View''.  
+
''Materialized_View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 446: Line 407:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| MULTI || NOT NULL || VARCHAR2(1) ||  ||  
 
|-
 
|-
| UNC ||  || VARCHAR2(255) ||  ||  
+
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 459: Line 424:
 
'''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_ASSISTSAN cp
 +
  , categories@CGMS14SYS_ASSISTSAN c
 +
where cp.idcategory = c.idcategory
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
== LINK-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#LINK_CROP_PARAMETERS|3.1 LINK_CROP_PARAMETERS}}
 +
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.2 LINK_CROP_PARAMETERS_CROP}}
 +
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.3 LINK_CROP_PARAMETERS_MODEL}}
 +
{{TocRow|#LINK_CROP_STU|3.4 LINK_CROP_STU}}
 +
{{TocRow|#LINK_GRID_COVER|3.5 LINK_GRID_COVER}}
 +
{{TocRow|#LINK_GRID_REGION_COVER|3.6 LINK_GRID_REGION_COVER}}
 +
{{TocRow|#LINK_REGION_COVER|3.7 LINK_REGION_COVER}}
 +
{{TocRow|#LINK_SMU_GRID_COVER|3.8 LINK_SMU_GRID_COVER}}
 +
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.9 LINK_SMU_GRID_REGION_COVER}}
 +
{{TocRow|#LINK_SMU_STU|3.10 LINK_SMU_STU}}
 +
{{TocRow|#LINK_STU_HORIZONS|3.11 LINK_STU_HORIZONS}}
 +
}}
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROPS ===
+
=== LINK_CROP_PARAMETERS ===
''View''.  
+
''Materialized_View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 478: Line 464:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
|}
+
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
 
 
 
 
'''definition:'''
 
select
 
    c.idcrop
 
  , c.crop
 
  , c.descriptor
 
  , c.eurostat
 
  from crops@CGMS14SYS_ASSISTSAN c
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== GLOBAL_CROP_PARAMETERS ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
Line 515: Line 481:
 
|-
 
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
|-
 
| MULTI || NOT NULL || VARCHAR2(1) ||  ||
 
 
|-
 
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 +
|-
 +
| XVALUE || NOT NULL || NUMBER(22) ||  ||
 +
|-
 +
| YVALUE ||  || NUMBER(22) ||  ||
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cps.idcategory
 +
  , cps.category
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
where cpp.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 +
and  cp.idcover                = c.idcover
 +
and  cp.idmodel                = m.idmodel
 +
and  cp.active_parametrization  = 'Y'
 +
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_GRIDS ===
+
=== LINK_CROP_PARAMETERS_CROP ===
''View''.  
+
''Materialized_View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 538: Line 534:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| ALTITUDE_16 || || NUMBER(22) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| ALTITUDE_25 || || NUMBER(22) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| X || NOT NULL || NUMBER(22) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST ||  || NUMBER(22) ||  ||
+
| YVALUE ||  || NUMBER(22) ||  ||  
|-
 
| CLIMATE_BARRIER ||  || NUMBER(22) ||  ||
 
|-
 
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||
 
|-
 
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 575: Line 561:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     g.idgrid
+
     cp.idcrop_parametrization
   , g.idgrid_source
+
   , cp.crop_parametrization
   , idoriginal_code
+
   , m.idmodel
   , latitude
+
   , m.model
   , longitude
+
   , c.idcover
   , altitude
+
   , c.cover
   , altitude_16
+
   , cps.idcrop_parameter
   , altitude_25
+
   , cps.crop_parameter
   , x
+
   , cps.descriptor
   , y
+
   , cpp.xvalue
   , distance_from_coast
+
   , cpp.yvalue
  , climate_barrier
+
from
   , has_land
+
    global_models m
   , grid_source
+
   , global_covers c
   , resolution
+
   , crop_parametrization_parameter cpp
   , unit
+
   , crop_parametrizations cp
  from grids@CGMS14SYS_ASSISTSAN g
+
   , global_crop_parameters cps
  , windows@CGMS14SYS_ASSISTSAN w
+
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
  , grid_sources@CGMS14SYS_ASSISTSAN gs
+
and  cpp.idcrop_parameter      = cps.idcrop_parameter
  where g.idgrid_source = gs.idgrid_source
+
and  cp.idcover                = c.idcover
  and gs.idwindow = w.idwindow
+
  and  cp.idmodel                = m.idmodel
 +
and   cp.active_parametrization  = 'Y'
 +
and  cps.category              = 'CROP'
 +
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_GRID_SOURCES ===
+
=== LINK_CROP_PARAMETERS_MODEL ===
''View''.  
+
''Materialized_View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 610: Line 599:
 
! 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) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
 +
|-
 +
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| UNC ||  || VARCHAR2(255) ||  ||  
+
| YVALUE ||  || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 631: Line 626:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     idgrid_source
+
     cp.idcrop_parametrization
   , gs.idwindow
+
   , cp.crop_parametrization
   , w.window
+
   , m.idmodel
   , w.name
+
   , m.model
   , gs.resolution
+
   , c.idcover
   , gs.unit
+
   , c.cover
   , gs.description
+
   , cps.idcrop_parameter
   , gs.unc
+
   , cps.crop_parameter
  from grid_sources@CGMS14SYS_ASSISTSAN gs
+
  , cps.descriptor
   , windows@CGMS14SYS_ASSISTSAN w
+
  , cpp.xvalue
  where gs.idwindow = w.idwindow
+
  , cpp.yvalue
|}
+
  from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
   , global_crop_parameters cps
 +
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 +
and  cp.idcover                = c.idcover
 +
and  cp.idmodel                = m.idmodel
 +
and  cp.active_parametrization  = 'Y'
 +
and  cps.category              = 'MODEL'
 +
 +
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
+
=== LINK_CROP_STU ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 656: Line 664:
 
! 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) ||  ||  
+
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| NAME || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| COVER_SOURCE_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    lcws.idwindow
 
  , w.window
 
  , w.name
 
  , lcws.idcover
 
  , c.cover
 
  , lcws.idcover_source
 
  , cover_source
 
  , cs.descriptor as cover_source_descriptor
 
from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
 
  , windows@CGMS14SYS_ASSISTSAN w
 
  , covers@CGMS14SYS_ASSISTSAN c
 
  , cover_sources@CGMS14SYS_ASSISTSAN cs
 
where lcws.idwindow = w.idwindow
 
  and lcws.idcover = c.idcover
 
  and lcws.idcover_source = cs.idcover_source
 
order by w.idwindow
 
  , c.idcover
 
  , cs.idcover_source
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_MODELS ===
+
=== LINK_GRID_COVER ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 709: Line 684:
 
! 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) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    m.idmodel
 
  , m.model
 
  , m.descriptor
 
from models@CGMS14SYS_ASSISTSAN m
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_REGIONS ===
+
=== LINK_GRID_REGION_COVER ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 740: Line 708:
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||
+
| AREA || NOT NULL || NUMBER(22) ||  ||  
|-
 
| POPULATION ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    r.idregion
 
  , r.region
 
  , r.name
 
  , r.continent
 
  , r.population
 
from regions@CGMS14SYS_ASSISTSAN r
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_REGION_ELEMENTS ===
+
=== LINK_REGION_COVER ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 772: Line 729:
 
{|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
|-
 
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||
 
 
|-
 
|-
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||
+
| AREA || NOT NULL || NUMBER(22) ||  ||  
|-
 
| GLOBAL_NAME || NOT NULL || VARCHAR2(255) ||  ||
 
|-
 
| LOCAL_NAME ||  || VARCHAR2(255) ||  ||
 
|-
 
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  ||
 
|-
 
| POPULATION ||  || NUMBER(22) ||  ||
 
|-
 
| STANDARD || NOT NULL || VARCHAR2(20) ||  ||
 
|-
 
| IDFATHER ||  || NUMBER(22, 12) ||  ||
 
|-
 
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    re.idregion_element
 
  , re.idoriginal_code
 
  , re.idregion
 
  , r.continent
 
  , r.region
 
  , r.name global_name
 
  , re.name local_name
 
  , re.region_level
 
  , r.population
 
  , re.standard
 
  , re.idfather
 
  , re.idregion_source
 
  , rs.region_source
 
from region_elements@CGMS14SYS_ASSISTSAN re
 
  , regions@CGMS14SYS_ASSISTSAN r
 
  , region_sources@CGMS14SYS_ASSISTSAN rs
 
where re.idregion = r.idregion
 
  and re.idregion_source = rs.idregion_source
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_REGION_SOURCES ===
+
=== LINK_SMU_GRID_COVER ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 836: Line 752:
 
! 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) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    r.idregion_source
 
  , r.region_source
 
  , r.description
 
  , r.unc
 
from region_sources@CGMS14SYS_ASSISTSAN r
 
order by idregion_source
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_SOIL_SOURCES ===
+
=== LINK_SMU_GRID_REGION_COVER ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 869: Line 776:
 
! 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) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||
 +
|-
 +
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| AREA || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    s.idsoil_source
 
  , s.soil_source
 
  , s.descriptor
 
from soil_sources@CGMS14SYS_ASSISTSAN s
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
+
=== LINK_SMU_STU ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 898: Line 802:
 
! 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) ||  ||  
+
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    s.idstatistic_source
 
  , s.statistic_source
 
  , s.descriptor
 
from statistic_sources@CGMS14SYS_ASSISTSAN s
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_SUITABILITY_PROPERTIES ===
+
=== LINK_STU_HORIZONS ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 927: Line 824:
 
! 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
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||
 +
|-
 +
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    p.idsuitability_property
 
  , p.suitability_property
 
  , p.descriptor
 
from suitability_properties@CGMS14SYS_ASSISTSAN p
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
== SIM-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
 +
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
 +
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
 +
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
 +
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
 +
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
 +
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
 +
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
 +
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
 +
}}
 +
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_THRESHOLDS ===
+
=== SIM_BLAST_HRES_GRID ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 956: Line 870:
 
! 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
 
|-
 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| DAY || NOT NULL || DATE ||  ||
 +
|-
 +
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  ||  
+
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  ||  
+
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||  
 
 
 
 
'''definition:'''
 
  select
 
    t.idthreshold
 
  , t.threshold
 
  , t.indicator
 
  , t.operator
 
  , t.value_min
 
  , t.value_max
 
from thresholds@CGMS14SYS_ASSISTSAN t
 
  , windows@CGMS14SYS_ASSISTSAN w
 
  where t.idwindow = w.idwindow
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== GLOBAL_TIME_DIMENSIONS ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DECADE ||  || NUMBER(22) ||  ||  
+
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DECADE_ID ||  || NUMBER(22) ||  ||  
+
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MONTH ||  || NUMBER(22) ||  ||  
+
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MONTH_ID ||  || NUMBER(22) ||  ||  
+
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| QUARTER ||  || NUMBER(22) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| QUARTER_ID ||  || NUMBER(22) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| YEAR ||  || NUMBER(22) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| LAST_DAY_DECADE ||  || VARCHAR2(1) ||  ||  
+
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| RUE_WITH_BLAST || || NUMBER(22, 12) || ||  
 
 
 
 
'''definition:'''
 
  select
 
    t.day
 
  , t.decade
 
  , t.decade_id
 
  , t.month
 
  , t.month_id
 
  , t.quarter
 
  , t.quarter_id
 
  , t.year
 
  , t.last_day_decade
 
  from time_dimensions@CGMS14SYS_ASSISTSAN t
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== GLOBAL_TREATMENTS ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TREATMENT || NOT NULL || VARCHAR2(60) ||  ||  
+
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
|-
 
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    t.idtreatment
 
  , t.treatment
 
  , t.descriptor
 
from treatments@cgms14sys_assistsan t
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_WINDOWS ===
+
=== SIM_BLAST_HRES_GRID_LTA ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 1,072: Line 934:
 
! 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) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  ||  
+
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||
 +
|-
 +
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
+
| AVG_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_LON || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||
 +
|-
 +
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AVG_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LON || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_X || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_Y || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_X || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_Y || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ROI ||  || NUMBER(22, 3) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
|}
+
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) || ||  
 
+
|-
 
+
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
'''definition:'''
+
|-
  select
+
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) || ||  
    w.idwindow
+
|-
  , w.window
+
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) || ||  
  , w.name
 
  , w.reference_system
 
  , w.descriptor
 
  , w.max_lat
 
  , w.max_lon
 
  , w.min_lat
 
  , w.min_lon
 
  , w.max_x
 
  , w.max_y
 
  , w.min_x
 
  , w.min_y
 
  , w.roi
 
from windows@CGMS14SYS_ASSISTSAN w
 
|}
 
<!-- end -->
 
 
 
== LINK-datasets ==
 
{{TocTable|content=
 
{{TocRow|#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION}}
 
{{TocRow|#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS}}
 
{{TocRow|#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS}}
 
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP}}
 
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL}}
 
{{TocRow|#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION}}
 
{{TocRow|#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS}}
 
{{TocRow|#LINK_CROP_STU|3.8 LINK_CROP_STU}}
 
{{TocRow|#LINK_CROP_VARIETY_PARAMETERS|3.9 LINK_CROP_VARIETY_PARAMETERS}}
 
{{TocRow|#LINK_GRID_COVER|3.10 LINK_GRID_COVER}}
 
{{TocRow|#LINK_GRID_REGION_COVER|3.11 LINK_GRID_REGION_COVER}}
 
{{TocRow|#LINK_REGION_COVER|3.12 LINK_REGION_COVER}}
 
{{TocRow|#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT}}
 
{{TocRow|#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP}}
 
{{TocRow|#LINK_SMU_GRID_COVER|3.15 LINK_SMU_GRID_COVER}}
 
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.16 LINK_SMU_GRID_REGION_COVER}}
 
{{TocRow|#LINK_SMU_STU|3.17 LINK_SMU_STU}}
 
{{TocRow|#LINK_STU_HORIZONS|3.18 LINK_STU_HORIZONS}}
 
{{TocRow|#LINK_STU_WEIGHTED_PARAMETERS|3.19 LINK_STU_WEIGHTED_PARAMETERS}}
 
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
 
}}
 
 
 
 
 
<!-- start -->
 
=== LINK_CROP_AGGREGATION ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
+
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||
 
+
|-
 
+
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||
'''definition:'''
+
|-
  select
+
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
    ca.idcrop_aggregation
+
|-
  , ca.idcrop
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) || ||  
  , c.crop
 
  , c.descriptor
 
  , cp.idmodel
 
  , m.model
 
  , m.descriptor
 
  , ca.idcrop_parametrization
 
  , cp.crop_parametrization
 
  , cp.descriptor as parametrization_descriptor
 
  from cgms14chn.crop_aggregations ca
 
  , cgms14chn.crop_parametrizations cp
 
  , cgms14chn.global_models m
 
  , cgms14chn.global_crops c
 
  where ca.idcrop = c.idcrop
 
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
 
  and  cp.idmodel = m.idmodel
 
order by ca.idcrop_aggregation
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_CROP_CALENDARS ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
{|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_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| START_DATE ||  || DATE ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| END_DATE ||  || DATE ||  ||  
+
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DURATION ||  || NUMBER(22) ||  ||  
+
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| START_DOY ||  || NUMBER(22) ||  ||  
+
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MAX_AGBWITHBLAST || || NUMBER(22, 12) || ||  
 
 
 
 
'''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 ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
{|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_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||
 +
|-
 +
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_CROP_PARAMETERS_CROP ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
 
+
|-
|}
+
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||
<!-- end -->
+
|-
 
+
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||
<!-- start -->
+
|-
=== LINK_CROP_PARAMETERS_MODEL ===
+
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
|}
+
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_CROP_PARAMETRIZATION ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||
+
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
|-
 
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||
 
|-
 
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| MODEL || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||
 
|-
 
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| COVER || NOT NULL || VARCHAR2(30) ||  ||
 
|-
 
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    cp.idcrop_parametrization
 
  , cp.crop_parametrization
 
  , cp.descriptor
 
  , cp.idmodel
 
  , m.model
 
  , m.descriptor
 
  , c.idcover
 
  , c.cover
 
  , c.descriptor
 
from crop_parametrizations cp
 
  , global_models m
 
  , global_covers c
 
where cp.idmodel = m.idmodel
 
  and  cp.idcover = c.idcover
 
order by cp.idcrop_parametrization
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_SPATIALIZATIONS ===
+
=== SIM_BLAST_HRES_REGION ===
''View''.  
+
''Table''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 1,465: 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
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||
 +
|-
 +
| DOY || NOT NULL || NUMBER(22, 3) ||  ||
 +
|-
 +
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||
 +
|-
 +
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||
 +
|-
 +
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
|}
 +
<!-- end -->
  
'''definition:'''
+
<!-- start -->
select
+
=== SIM_BLAST_HRES_REGION_LTA ===
    cp.idcrop_parametrization
 
  , cp.crop_parametrization
 
  , m.idmodel
 
  , m.model
 
  , c.idcover
 
  , c.cover
 
  , cs.idgrid
 
  , v.idvariety
 
  , v.variety
 
  , cps.idcrop_parameter
 
  , cps.crop_parameter
 
  , cps.descriptor
 
  , cvp.xvalue
 
  , cvp.yvalue
 
from global_models m
 
  , global_covers c
 
  , crop_varieties v
 
  , crop_parametrizations cp
 
  , crop_spatializations cs
 
  , global_crop_parameters cps
 
  , crop_variety_parameters cvp
 
where cs.idcrop_parametrization = cp.idcrop_parametrization
 
  and cp.idcover = c.idcover
 
  and cs.idvariety = v.idvariety
 
  and cp.idmodel = m.idmodel
 
  and cs.idvariety = cvp.idvariety
 
  and cvp.idcrop_parameter = cps.idcrop_parameter
 
  and cp.active_parametrization = 'y'
 
order by cs.idcrop_parametrization
 
  , cs.idgrid
 
  , cps.crop_parameter
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_CROP_STU ===
 
 
''Table''.  
 
''Table''.  
  
Line 1,543: Line 1,212:
 
! 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_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
|}
+
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_CROP_VARIETY_PARAMETERS ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||
 +
|-
 +
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
+
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| AVG_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
|}
+
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) || ||
 
 
 
 
'''definition:'''
 
  select
 
    "IDCROP_PARAMETRIZATION","CROP_PARAMETRIZATION","IDMODEL","MODEL","IDCOVER","COVER","IDVARIETY","VARIETY","IDCROP_PARAMETER","CROP_PARAMETER","DESCRIPTOR","XVALUE","YVALUE"
 
  from
 
    (
 
    select distinct
 
        cp.idcrop_parametrization
 
      , cp.crop_parametrization
 
      , m.idmodel
 
      , m.model
 
      , c.idcover
 
      , c.cover
 
      , v.idvariety
 
      , v.variety
 
      , cps.idcrop_parameter
 
      , cps.crop_parameter
 
      , cps.descriptor
 
      , cvp.xvalue
 
      , cvp.yvalue
 
    from cgms14chn.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'
 
    ) a
 
  order by idcrop_parametrization
 
    , idvariety
 
    , crop_parameter
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_GRID_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_GRID_REGION_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_REGION_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
+
|-
|}
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) || ||  
 
 
 
 
'''definition:'''
 
  select
 
    distinct lgsc.idgrid
 
  , lss.idstu
 
  from link_crop_stu lcs
 
  , link_smu_grid_cover lgsc
 
  , link_smu_stu lss
 
  , crop_aggregations ca
 
  , crop_parametrizations cp
 
where lcs.idstu = lss.idstu
 
  and  lss.idsmu = lgsc.idsmu
 
  and  lcs.idcrop = ca.idcrop
 
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
 
  and  cp.idcover = lgsc.idcover
 
order by lgsc.idgrid
 
  , lss.idstu
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SIMULATION_UNIT_CROP ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
{|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_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
|}
+
| MAX_BLASTSPORULATION || || NUMBER(22, 1) || ||  
 
 
 
 
'''definition:'''
 
  select
 
distinct
 
    ca.idcrop_parametrization
 
  , lgsc.idgrid
 
  , lss.idstu
 
from
 
    link_crop_stu lcs
 
  , link_smu_grid_cover lgsc
 
  , link_smu_stu lss
 
  , crop_aggregations ca
 
  , crop_parametrizations cp
 
where lcs.idstu                = lss.idstu
 
and  lss.idsmu                = lgsc.idsmu
 
and  lcs.idcrop                = ca.idcrop
 
  and  ca.idcrop_parametrization = cp.idcrop_parametrization
 
and  cp.idcover                = lgsc.idcover
 
order by
 
    ca.idcrop_parametrization
 
  , lgsc.idgrid
 
  , lss.idstu
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SMU_GRID_COVER ===
 
''Table''.
 
 
 
{|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
 
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SMU_GRID_REGION_COVER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SMU_STU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
+
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
|}
+
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_STU_HORIZONS ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||
 +
|-
 +
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||  
+
| STD_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||  
+
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
 
|-
 
|-
|}
+
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_STU_WEIGHTED_PARAMETERS ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SAND ||  || NUMBER(22) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SILT ||  || NUMBER(22) ||  ||  
+
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CLAY ||  || NUMBER(22) ||  ||  
+
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_WP ||  || NUMBER(22) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_FC ||  || NUMBER(22) ||  ||  
+
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_SAT ||  || NUMBER(22) ||  ||  
+
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BULK_DENSITY ||  || NUMBER(22) ||  ||  
+
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| ORGANIC_CARBON ||  || NUMBER(22) ||  ||  
+
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| DEPTH ||  || NUMBER(22) ||  ||  
+
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
|}
+
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) || ||  
 
 
 
 
'''definition:'''
 
  select
 
    idstu                                                                                idstu
 
  , sum(sand                      * (depth_max - depth_min)) / sum(depth_max - depth_min) sand
 
  , sum(silt                      * (depth_max - depth_min)) / sum(depth_max - depth_min) silt
 
  , sum(clay                      * (depth_max - depth_min)) / sum(depth_max - depth_min) clay
 
  , sum(soil_moisture_content_wp  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_wp
 
  , sum(soil_moisture_content_fc  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_fc
 
  , sum(soil_moisture_content_sat * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_sat
 
  , sum(bulk_density              * (depth_max - depth_min)) / sum(depth_max - depth_min) bulk_density
 
  , sum(organic_carbon            * (depth_max - depth_min)) / sum(depth_max - depth_min) organic_carbon
 
  , sum(depth_max - depth_min)                                                            depth
 
from
 
    link_stu_horizons  lsh
 
  , soil_horizons      sh
 
where lsh.idhorizon = sh.idhorizon
 
  group by idstu
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== LINK_SUITABILITY_RULES ===
 
''View''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
+
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| NUM_BLAST_EFFECT_ON_RUE || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SUITABILITY_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| NUM_HUMIDITYMINIMUM || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY_MIN ||  || NUMBER(22) ||  ||
+
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
|-
 
| SUITABILITY_PROPERTY_MAX ||  || NUMBER(22) ||  ||
 
|-
 
| SUITABILITY_PROPERTY_VALUE ||  || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 
'''definition:'''
 
select
 
    ca.idcrop_aggregation
 
  , ca.idcrop
 
  , c.crop
 
  , c.descriptor
 
  , cp.idmodel
 
  , m.model
 
  , m.descriptor
 
  , ca.idcrop_parametrization
 
  , cp.crop_parametrization
 
  , cp.descriptor
 
  , sp.idsuitability_property
 
  , sp.suitability_property
 
  , sp.descriptor
 
  , csr.valuen_min
 
  , csr.valuen_max
 
  , csr.valuec
 
from global_suitability_properties sp
 
  , crop_suitability_rules        csr
 
  , global_crops                  c
 
  , crop_aggregations              ca
 
  , crop_parametrizations          cp
 
  , global_models                  m
 
where  ca.idcrop                  = c.idcrop
 
  and  ca.idcrop_parametrization  = cp.idcrop_parametrization
 
  and  cp.idmodel                = m.idmodel
 
  and  ca.idcrop                  = csr.idcrop
 
  and  csr.idsuitability_property = sp.idsuitability_property
 
order by ca.idcrop_aggregation
 
  , ca.idcrop
 
  , csr.idsuitability_property
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
== SIM-datasets ==
+
<!-- start -->
{{TocTable|content=
+
=== SIM_WARM_HRES_GRID ===
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
+
''Table''.  
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
 
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
 
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
 
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
 
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
 
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
 
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
 
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
 
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
 
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
 
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
 
}}
 
 
 
 
 
<!-- start -->
 
=== SIM_BLAST_HRES_GRID ===
 
''Table''.  
 
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 2,055: Line 1,436:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
+
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
|-
 
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,099: Line 1,474:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_GRID_LTA ===
+
=== SIM_WARM_HRES_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,117: Line 1,492:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
+
|}
|-
+
 
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  ||
+
|}
|-
 
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
|}
 
 
 
|}
 
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_REGION ===
+
=== SIM_WARM_HRES_REGION ===
 
''Table''.  
 
''Table''.  
  
Line 2,333: Line 1,678:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
+
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
|-
 
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,377: Line 1,716:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_REGION_LTA ===
+
=== SIM_WARM_HRES_REGION_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,395: Line 1,734:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||
+
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
|-
 
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||
+
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
|-
 
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,591: Line 1,900:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_GRID ===
+
=== SIM_WOFOST_HRES_EMU ===
 
''Table''.  
 
''Table''.  
  
Line 2,604: Line 1,913:
 
|-
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 +
|-
 +
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
Line 2,611: Line 1,922:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,649: Line 1,960:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_GRID_LTA ===
+
=== SIM_WOFOST_HRES_EMU_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,662: Line 1,973:
 
|-
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 +
|-
 +
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 2,667: Line 1,980:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
 
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
 
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || 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_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
+
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FSM ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FSMUR ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
+
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
+
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  ||  
|-
 
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 2,833: Line 2,146:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION ===
+
=== SIM_WOFOST_HRES_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 2,843: Line 2,156:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
Line 2,853: Line 2,166:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,891: Line 2,204:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION_LTA ===
+
=== SIM_WOFOST_HRES_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,901: Line 2,214:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 2,909: Line 2,222:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
 
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
 
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || 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_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
+
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FSM ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FSMUR ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
+
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
+
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  ||  
|-
 
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 3,075: Line 2,388:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU ===
+
=== SIM_WOFOST_HRES_REGION ===
 
''Table''.  
 
''Table''.  
  
Line 3,085: Line 2,398:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
|-
 
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
Line 3,135: Line 2,446:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU_LTA ===
+
=== SIM_WOFOST_HRES_REGION_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 3,145: Line 2,456:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
|-
 
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 3,321: Line 2,630:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_GRID ===
+
=== SIM_WOFOST_HRES_STU ===
 
''Table''.  
 
''Table''.  
  
Line 3,334: Line 2,643:
 
|-
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 +
|-
 +
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
Line 3,340: Line 2,651:
 
|-
 
|-
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 +
|-
 +
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
|-
 
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
Line 3,377: Line 2,690:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
== SOIL-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
 +
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
 +
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
 +
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 +
}}
 +
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_GRID_LTA ===
+
=== SOIL_HORIZONS ===
 
''Table''.  
 
''Table''.  
  
Line 3,389: Line 2,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
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| HORIZON || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| ORIGINAL_LEVEL ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_MOISTURE_CONTENT_WP ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_MOISTURE_CONTENT_FC ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| SOIL_MOISTURE_CONTENT_SAT ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| DEPTH ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| USDA_CLASS# ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| USDA_CLASS ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| GRAVEL ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| SAND ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
+
| SILT ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| CLAY ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| BULK_DENSITY ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| ORGANIC_CARBON ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| PH_H2O ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| CLAY_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_BASE_SATURATION ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| TOTAL_EXCHANGEABLE_BASE ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| CALCIUM_CARBONATE ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| CALCIUM_SULPHATE ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| EXCHANGEABLE_SODIUM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| ELECTRICAL_CONDUCTIVITY ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== SOIL_INITIAL_WATER ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSM || || NUMBER(22, 3) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSMUR || || NUMBER(22, 3) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| INITIAL_DEPTH_GROUND_WATER ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| DRAINAGE_DEPTH ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| ROOTING_DEPTH_POTENTIAL_WATER ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_WATER_STARTDATE ||  || DATE ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== SOIL_SMU ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
|}
|-
+
 
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||
+
|}
|-
+
<!-- end -->
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||
+
 
 +
<!-- start -->
 +
=== SOIL_STU ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STU || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_WRB ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_WRB_CL ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_FAO90 ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_FAO90_CL ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_FAO85 ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| SOIL_FAO85_CL ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| SLOPE ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| TEXTURE ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| PHASE ||  || VARCHAR2(2) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| LAYERS ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| CALCULATED_ROOTING_DEPTH ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  ||  
+
| DRAINAGE ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| LIMITATION_TO_AGRIC_USE1 ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| LIMITATION_TO_AGRIC_USE2 ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| OBSTACLE_TO_ROOTS ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| IMPERMEABLE_DEPTH_LAYER ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| SOIL_WATER_REGIME ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| DEPTH_TO_BEDROCK ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| SOIL_FAO74 ||  || VARCHAR2(8) ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
+
| SOIL_FAO74_CL ||  || VARCHAR2(1) ||  ||  
|-
 
| 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,562: Line 2,890:
 
<!-- end -->
 
<!-- end -->
  
<!-- start -->
+
== WEATHER-datasets ==
=== SIM_WOFOST_HRES_REGION ===
+
{{TocTable|content=
 +
{{TocRow|#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID}}
 +
{{TocRow|#WEATHER_ERA_GRID_LTA|6.2 WEATHER_ERA_GRID_LTA}}
 +
{{TocRow|#WEATHER_ERA_REGIONCOVER|6.3 WEATHER_ERA_REGIONCOVER}}
 +
{{TocRow|#WEATHER_ERA_REGIONCOVER_LTA|6.4 WEATHER_ERA_REGIONCOVER_LTA}}
 +
{{TocRow|#WEATHER_HIS_GRID|6.5 WEATHER_HIS_GRID}}
 +
{{TocRow|#WEATHER_HIS_REGIONCOVER|6.6 WEATHER_HIS_REGIONCOVER}}
 +
{{TocRow|#WEATHER_OBS_GRID|6.7 WEATHER_OBS_GRID}}
 +
{{TocRow|#WEATHER_OBS_GRID_INFO|6.8 WEATHER_OBS_GRID_INFO}}
 +
{{TocRow|#WEATHER_OBS_GRID_LTA|6.9 WEATHER_OBS_GRID_LTA}}
 +
{{TocRow|#WEATHER_OBS_GRID_LTA_MISS|6.10 WEATHER_OBS_GRID_LTA_MISS}}
 +
{{TocRow|#WEATHER_OBS_REGCOV_LTA_THRSHLD|6.11 WEATHER_OBS_REGCOV_LTA_THRSHLD}}
 +
{{TocRow|#WEATHER_OBS_REGCOV_THRESHOLDS|6.12 WEATHER_OBS_REGCOV_THRESHOLDS}}
 +
{{TocRow|#WEATHER_OBS_REGIONCOVER|6.13 WEATHER_OBS_REGIONCOVER}}
 +
{{TocRow|#WEATHER_OBS_REGIONCOVER_LTA|6.14 WEATHER_OBS_REGIONCOVER_LTA}}
 +
{{TocRow|#WEATHER_OBS_STATION|6.15 WEATHER_OBS_STATION}}
 +
{{TocRow|#WEATHER_OBS_STATION_AVAIL|6.16 WEATHER_OBS_STATION_AVAIL}}
 +
{{TocRow|#WEATHER_OBS_STATION_CALCULATED|6.17 WEATHER_OBS_STATION_CALCULATED}}
 +
{{TocRow|#WEATHER_OBS_STATION_ERRAIN|6.18 WEATHER_OBS_STATION_ERRAIN}}
 +
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.19 WEATHER_OBS_STATION_ERRORS}}
 +
{{TocRow|#WEATHER_OBS_STATION_INFO|6.20 WEATHER_OBS_STATION_INFO}}
 +
{{TocRow|#WEATHER_OBS_STATION_LTA|6.21 WEATHER_OBS_STATION_LTA}}
 +
{{TocRow|#WEATHER_OBS_STATION_RAW|6.22 WEATHER_OBS_STATION_RAW}}
 +
{{TocRow|#WEATHER_OPE_GRID|6.23 WEATHER_OPE_GRID}}
 +
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.24 WEATHER_OPE_REGIONCOVER}}
 +
}}
 +
 
 +
 
 +
<!-- start -->
 +
=== WEATHER_ERA_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 3,573: Line 2,930:
 
! 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) ||  ||
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| FSM ||  || NUMBER(22, 3) ||  ||  
+
| SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| TOTALCLOUD ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||
+
|}
|-
+
 
| RUNOFF ||  || NUMBER(22, 8) ||  ||
 
|-
 
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||
 
|-
 
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||
 
|-
 
|}
 
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_REGION_LTA ===
+
=== WEATHER_ERA_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 3,631: Line 2,978:
 
! 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) ||  ||
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 3,639: Line 2,984:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_FSM || || NUMBER(22, 3) ||  ||  
+
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
+
| MIN_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| MIN_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FSM || || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
+
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| STD_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
+
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
+
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_FSM || || NUMBER(22, 3) ||  ||  
+
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
+
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
+
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_RUNOFF || || NUMBER(22, 8) ||  ||  
+
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
+
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
+
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 2) ||  ||  
+
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 2) ||  ||  
+
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||  
+
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||
+
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  ||  
|-
 
| 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,805: Line 3,130:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_STU ===
+
=== WEATHER_ERA_REGIONCOVER ===
 
''Table''.  
 
''Table''.  
  
Line 3,815: Line 3,140:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  ||  
+
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
+
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
+
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
+
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
+
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
+
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| FSM ||  || NUMBER(22, 3) ||  ||
+
| TOTALCLOUD ||  || NUMBER(22) ||  ||  
|-
 
| FSMUR ||  || NUMBER(22, 3) ||  ||
 
|-
 
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||
 
|-
 
| RUNOFF ||  || NUMBER(22, 8) ||  ||
 
|-
 
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||
 
|-
 
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 3,866: Line 3,179:
 
<!-- end -->
 
<!-- end -->
  
== SOIL-datasets ==
+
<!-- start -->
{{TocTable|content=
+
=== WEATHER_ERA_REGIONCOVER_LTA ===
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
 
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
 
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
 
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 
}}
 
 
 
 
 
<!-- start -->
 
=== SOIL_HORIZONS ===
 
 
''Table''.  
 
''Table''.  
  
Line 3,886: Line 3,190:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| HORIZON || NOT NULL || VARCHAR2(30) ||  ||  
+
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| ORIGINAL_LEVEL || || NUMBER(22, 1) ||  ||  
+
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_WP || || NUMBER(22) ||  ||  
+
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_FC || || NUMBER(22) ||  ||  
+
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_SAT || || NUMBER(22) ||  ||  
+
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| DEPTH || || NUMBER(22, 5) ||  ||  
+
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| USDA_CLASS# || || NUMBER(22, 3) ||  ||  
+
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| USDA_CLASS || || VARCHAR2(8) ||  ||  
+
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| GRAVEL || || NUMBER(22, 3) ||  ||  
+
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SAND || || NUMBER(22, 3) ||  ||  
+
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SILT || || NUMBER(22, 3) ||  ||  
+
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| CLAY ||  || NUMBER(22, 3) ||  ||  
+
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| BULK_DENSITY ||  || NUMBER(22, 5) ||  ||  
+
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| ORGANIC_CARBON ||  || NUMBER(22, 5) ||  ||  
+
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| PH_H2O || || NUMBER(22, 5) ||  ||  
+
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| CLAY_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_BASE_SATURATION || || NUMBER(22, 3) ||  ||  
+
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TOTAL_EXCHANGEABLE_BASE || || NUMBER(22, 5) ||  ||  
+
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| CALCIUM_CARBONATE || || NUMBER(22, 5) ||  ||  
+
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| CALCIUM_SULPHATE || || NUMBER(22, 5) ||  ||  
+
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| EXCHANGEABLE_SODIUM || || NUMBER(22, 3) ||  ||  
+
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| ELECTRICAL_CONDUCTIVITY || || NUMBER(22, 5) ||  ||  
+
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
|}
+
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SOIL_INITIAL_WATER ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
{|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_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_SNOWWEQ || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| INITIAL_DEPTH_GROUND_WATER || || NUMBER(22, 4) ||  ||  
+
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| DRAINAGE_DEPTH || || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| ROOTING_DEPTH_POTENTIAL_WATER || || NUMBER(22, 3) ||  ||  
+
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_WATER_STARTDATE || || DATE ||  ||  
+
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
|}
+
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SOIL_SMU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
|}
+
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SOIL_STU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_SNOWWEQ || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STU || NOT NULL || VARCHAR2(30) ||  ||  
+
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_WRB || || VARCHAR2(8) ||  ||  
+
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| SOIL_WRB_CL || || VARCHAR2(1) ||  ||  
+
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SOIL_FAO90 || || VARCHAR2(8) ||  ||  
+
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| SOIL_FAO90_CL || || VARCHAR2(1) ||  ||  
+
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SOIL_FAO85 || || VARCHAR2(8) ||  ||  
+
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SOIL_FAO85_CL || || VARCHAR2(1) ||  ||  
+
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SLOPE || || VARCHAR2(1) ||  ||  
+
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| TEXTURE || || VARCHAR2(1) ||  ||  
+
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| PHASE ||  || VARCHAR2(2) ||  ||  
+
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| LAYERS ||  || NUMBER(22, 1) ||  ||  
+
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| CALCULATED_ROOTING_DEPTH ||  || NUMBER(22, 5) ||  ||  
+
| STD_TOTALCLOUD ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| DRAINAGE || || NUMBER(22, 1) ||  ||  
+
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE1 || || NUMBER(22, 2) ||  ||  
+
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE2 || || NUMBER(22, 2) ||  ||  
+
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| OBSTACLE_TO_ROOTS || || NUMBER(22, 1) ||  ||  
+
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| IMPERMEABLE_DEPTH_LAYER || || NUMBER(22, 1) ||  ||  
+
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| SOIL_WATER_REGIME || || NUMBER(22, 1) ||  ||  
+
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| DEPTH_TO_BEDROCK || || VARCHAR2(8) ||  ||  
+
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| SOIL_FAO74 ||  || VARCHAR2(8) ||  ||  
+
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||
 +
|-
 +
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||
 +
|-
 +
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||
 +
|-
 +
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||
 +
|-
 +
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||
 +
|-
 +
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| SOIL_FAO74_CL ||  || VARCHAR2(1) ||  ||  
+
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 4,064: Line 3,342:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
== WEATHER-datasets ==
 
{{TocTable|content=
 
{{TocRow|#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID}}
 
{{TocRow|#WEATHER_ERA_GRID_LTA|6.2 WEATHER_ERA_GRID_LTA}}
 
{{TocRow|#WEATHER_ERA_REGIONCOVER|6.3 WEATHER_ERA_REGIONCOVER}}
 
{{TocRow|#WEATHER_ERA_REGIONCOVER_LTA|6.4 WEATHER_ERA_REGIONCOVER_LTA}}
 
{{TocRow|#WEATHER_HIS_GRID|6.5 WEATHER_HIS_GRID}}
 
{{TocRow|#WEATHER_HIS_REGIONCOVER|6.6 WEATHER_HIS_REGIONCOVER}}
 
{{TocRow|#WEATHER_HRES_GRID|6.7 WEATHER_HRES_GRID}}
 
{{TocRow|#WEATHER_HRES_REGIONCOVER|6.8 WEATHER_HRES_REGIONCOVER}}
 
{{TocRow|#WEATHER_OBS_GRID|6.9 WEATHER_OBS_GRID}}
 
{{TocRow|#WEATHER_OBS_GRID_INFO|6.10 WEATHER_OBS_GRID_INFO}}
 
{{TocRow|#WEATHER_OBS_GRID_LTA|6.11 WEATHER_OBS_GRID_LTA}}
 
{{TocRow|#WEATHER_OBS_GRID_LTA_MISS|6.12 WEATHER_OBS_GRID_LTA_MISS}}
 
{{TocRow|#WEATHER_OBS_REGCOV_LTA_THRSHLD|6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD}}
 
{{TocRow|#WEATHER_OBS_REGCOV_THRESHOLDS|6.14 WEATHER_OBS_REGCOV_THRESHOLDS}}
 
{{TocRow|#WEATHER_OBS_REGIONCOVER|6.15 WEATHER_OBS_REGIONCOVER}}
 
{{TocRow|#WEATHER_OBS_REGIONCOVER_LTA|6.16 WEATHER_OBS_REGIONCOVER_LTA}}
 
{{TocRow|#WEATHER_OBS_STATION|6.17 WEATHER_OBS_STATION}}
 
{{TocRow|#WEATHER_OBS_STATION_AVAIL|6.18 WEATHER_OBS_STATION_AVAIL}}
 
{{TocRow|#WEATHER_OBS_STATION_CALCULATED|6.19 WEATHER_OBS_STATION_CALCULATED}}
 
{{TocRow|#WEATHER_OBS_STATION_ERRAIN|6.20 WEATHER_OBS_STATION_ERRAIN}}
 
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS}}
 
{{TocRow|#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO}}
 
{{TocRow|#WEATHER_OBS_STATION_LTA|6.23 WEATHER_OBS_STATION_LTA}}
 
{{TocRow|#WEATHER_OBS_STATION_RAW|6.24 WEATHER_OBS_STATION_RAW}}
 
{{TocRow|#WEATHER_OPE_GRID|6.25 WEATHER_OPE_GRID}}
 
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
 
}}
 
 
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_ERA_GRID ===
+
=== WEATHER_HIS_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 4,145: Line 3,392:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_ERA_GRID_LTA ===
+
=== WEATHER_HIS_REGIONCOVER ===
 
''Table''.  
 
''Table''.  
  
Line 4,155: Line 3,402:
 
! 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) ||  ||  
+
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== WEATHER_OBS_GRID ===
 +
''Table''.
 +
*Description: interpolated weather data per grid per day
 +
*Use: output for level 1, input for level 2
 +
*Type: Permanent table
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
+
| DAY || NOT NULL || DATE || - || calendar day
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
+
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || °C || maximum air temperature
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
+
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || °C || minimum air temperature
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
+
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || °C || average air temperature
 
|-
 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) || ||  
+
| HUMIDITY_06H || || NUMBER(22, 6) || - ||  
 
|-
 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) || ||  
+
| HUMIDITY_09H || || NUMBER(22, 6) || - ||  
 
|-
 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) || ||  
+
| HUMIDITY_12H || || NUMBER(22, 6) || - ||  
 
|-
 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) || ||  
+
| HUMIDITY_15H || || NUMBER(22, 6) || - ||  
 
|-
 
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| HUMIDITY_18H ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| MIN_SNOWWEQ || || NUMBER(22, 6) || ||  
+
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || m.s-1 || mean daily vapour pressure
 
|-
 
|-
| MIN_TOTALCLOUD || || NUMBER(22, 3) || ||  
+
| WINDSPEED || NOT NULL || NUMBER(22, 5) || hPa || mean daily wind speed at 10 m height
 
|-
 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
+
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily rainfall
 
|-
 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
+
| E0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
 
|-
 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
+
| ES0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
 
|-
 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
+
| ET0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
 
|-
 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
+
| RADIATION || NOT NULL || NUMBER(22, 6) || KJ.m-2.d-1 || daily radiation at surface
 
|-
 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
+
| SNOWDEPTH || || NUMBER(22, 6) || cm || daily mean snow depth
 
|-
 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== WEATHER_OBS_GRID_INFO ===
 +
''Table''.
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) || ||  
+
| DAY || NOT NULL || DATE || - ||  
 
|-
 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| TEMPERATURE_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
 
|-
 
|-
| MAX_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| TEMPERATURE_STATION_1 || NOT NULL || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| TEMPERATURE_STATION_2 ||  || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_STATION_3 ||  || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_STATION_4 || || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| TEMPERATURE_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| PRECIPITATION_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| PRECIPITATION_STATION || NOT NULL || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| PRECIPITATION_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| SNOWDEPTH_SOURCE || || VARCHAR2(10) ||  ||  
 
|-
 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SNOW_STATION || || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SNOW_SCORE || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| HUMIDITY_GROUP_SOURCE || || VARCHAR2(10) ||  ||  
 
|-
 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| HUMIDITY_STATION || || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| HUMIDITY_SCORE || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| STD_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| REST_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
 
|-
 
|-
| STD_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| REST_STATION_1 || NOT NULL || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| STD_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| REST_STATION_2 ||  || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
+
| REST_STATION_3 || || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
+
| REST_STATION_4 || || NUMBER(22, 7) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||
+
| REST_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
|-
 
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  ||
 
|-
 
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 4,307: Line 3,560:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_ERA_REGIONCOVER ===
+
=== WEATHER_OBS_GRID_LTA ===
 
''Table''.  
 
''Table''.  
 
+
*Description: long term average interpolated weather data per grid cell per day
 +
*Use: Monitoring extreme weather events
 +
*Type: Permanent table
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 4,317: Line 3,572:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
+
| TEMPERATURE_MIN || || NUMBER(22, 3) || °C || average maximum air temperature
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
+
| TEMPERATURE_MAX || || NUMBER(22, 3) || °C || average minimum air temperature
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
+
| TEMPERATURE_AVG || || NUMBER(22, 3) || °C || average mean air temperature
 
|-
 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
+
| PRECIPITATION || || NUMBER(22, 4) || mm.d-1 || average daily rainfall
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
+
| RADIATION || || NUMBER(22, 7) || KJ.m-2.d-1 || average daily radiation at surface
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
+
| VAPOURPRESSURE || || NUMBER(22, 4) || hPa || average mean daily vapour pressure
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
+
| WINDSPEED || || NUMBER(22, 5) || m.s-1 || average mean daily wind speed at 10 m height
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) || ||  
+
| E0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of water surface
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) || ||  
+
| ES0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of wet bare soil
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) || ||  
+
| ET0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of crop canopy
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) || ||  
+
| SNOWDEPTH || || NUMBER(22, 6) || cm || average daily mean snow depth
 
|-
 
|-
| SNOWWEQ ||  || NUMBER(22, 6) || ||  
+
| MIN_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || minimum minimum air temperature
 
|-
 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || ||  
+
| MIN_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || minimum maximum air temperature
 
|-
 
|-
| TOTALCLOUD ||  || NUMBER(22) || ||  
+
| MIN_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || minimum mean air temperature
 
|-
 
|-
|}
+
| MIN_PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || minimum daily rainfall
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== WEATHER_ERA_REGIONCOVER_LTA ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MIN_RADIATION || || NUMBER(22, 6) || KJ.m-2.d-1 || minimum daily radiation at surface
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) || ||  
+
| MIN_VAPOURPRESSURE || || NUMBER(22, 4) || hPa || minimum mean daily vapour pressure
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
+
| MIN_WINDSPEED || || NUMBER(22, 5) || m.s-1 || minimum mean daily wind speed at 10 m height
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| MIN_E0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of water surface
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) || ||  
+
| MIN_ES0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of wet bare soil
 
|-
 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
+
| MIN_ET0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of crop canopy
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
+
| MIN_SNOWDEPTH || || NUMBER(22, 6) || cm || minimum daily mean snow depth
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
+
| MAX_TEMPERATURE_MIN || || NUMBER(22, 3) || °C || maximum maximum air temperature
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
+
| MAX_TEMPERATURE_MAX || || NUMBER(22, 3) || °C || maximum maximum air temperature
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
+
| MAX_TEMPERATURE_AVG || || NUMBER(22, 3) || °C || maximum mean air temperature
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
+
| MAX_PRECIPITATION || || NUMBER(22, 4) || mm.d-1 || maximum daily rainfall
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
+
| MAX_RADIATION || || NUMBER(22, 6) || KJ.m-2.d-1 || maximum daily radiation at surface
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) || ||  
+
| MAX_VAPOURPRESSURE || || NUMBER(22, 4) || hPa || maximum mean daily vapour pressure
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) || ||  
+
| MAX_WINDSPEED || || NUMBER(22, 5) || m.s-1 || maximum mean daily wind speed at 10 m height
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) || ||  
+
| MAX_E0 || || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of water surface
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) || ||  
+
| MAX_ES0 || || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of wet bare soil
 
|-
 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) || ||  
+
| MAX_ET0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of crop canopy
 
|-
 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) || ||  
+
| STD_TEMPERATURE_MIN ||  || NUMBER(22, 4) || °C || standard deviation of minimum air temperature
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
+
| STD_TEMPERATURE_MAX || || NUMBER(22, 4) || °C || standard deviation of maximum air temperature
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
+
| STD_TEMPERATURE_AVG || || NUMBER(22, 4) || °C || standard deviation of mean air temperature
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
+
| STD_PRECIPITATION || || NUMBER(22, 5) || mm.d-1 || standard deviation of daily rainfall
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
+
| STD_RADIATION || || NUMBER(22, 8) || KJ.m-2.d-1 || standard deviation of daily radiation at surface
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
+
| STD_VAPOURPRESSURE || || NUMBER(22, 6) || hPa || standard deviation of mean daily vapour pressure
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
+
| STD_WINDSPEED || || NUMBER(22, 6) || m.s-1 || standard deviation of mean daily wind speed at 10 m height
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
+
| STD_E0 || || NUMBER(22, 4) ||