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_CROP_PARAMETERS|2.2 GLOBAL_CROP_PARAMETERS}}
+
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
 +
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
 +
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
 +
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
 +
{{TocRow|#GLOBAL_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 397: Line 414:
  
 
<!-- start -->
 
<!-- start -->
=== GLOBAL_CROP_PARAMETERS ===
+
=== GLOBAL_COVERS ===
''Materialized_View''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 407: Line 424:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
+
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
|-
 
| MULTI || NOT NULL || VARCHAR2(1) ||  ||
 
|-
 
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
Line 424: Line 435:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parameter
+
     c.idcover
   , cp.crop_parameter
+
   , c.cover
   , cp.descriptor
+
   , c.descriptor
  , cp.multi
+
  from covers@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 -->
=== LINK_CROP_PARAMETERS ===
+
=== GLOBAL_COVER_SOURCES ===
''Materialized_View''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 464: Line 453:
 
! 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) ||  ||
+
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| UNC ||  || VARCHAR2(255) ||  ||
|-
+
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
  c.idcover_source
 +
  , c.cover_source
 +
  , c.descriptor
 +
  , c.unc
 +
from cover_sources@CGMS14SYS_ASSISTSAN c
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== GLOBAL_CROPS ===
 +
''View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
 +
|-
 +
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
 +
|-
 +
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||
 +
|-
 +
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  ||
 +
|-
 +
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    c.idcrop
 +
  , c.crop
 +
  , c.descriptor
 +
  , c.eurostat
 +
from crops@CGMS14SYS_ASSISTSAN c
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== GLOBAL_CROP_PARAMETERS ===
 +
''Materialized_View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
Line 481: Line 522:
 
|-
 
|-
 
| 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) ||  ||
 
 
|-
 
|-
 
|}
 
|}
Line 495: Line 534:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     cp.idcrop_parameter
   , cp.crop_parametrization
+
   , cp.crop_parameter
   , m.idmodel
+
   , cp.descriptor
   , m.model
+
   , cp.multi
   , c.idcover
+
   , cp.idcategory
   , c.cover
+
   , c.category
  , cps.idcrop_parameter
 
  , cps.crop_parameter
 
  , cps.descriptor
 
  , cps.idcategory
 
  , cps.category
 
  , cpp.xvalue
 
  , cpp.yvalue
 
 
  from
 
  from
     global_models m
+
     crop_parameters@CGMS14SYS_ASSISTSAN cp
   , global_covers c
+
   , categories@CGMS14SYS_ASSISTSAN c
  , crop_parametrization_parameter cpp
+
  where cp.idcategory = c.idcategory
  , crop_parametrizations cp
 
  , global_crop_parameters cps
 
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
and  cp.idcover                = c.idcover
 
and  cp.idmodel                = m.idmodel
 
and  cp.active_parametrization  = 'Y'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS_CROP ===
+
=== GLOBAL_GRIDS ===
''Materialized_View''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 534: Line 558:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| ALTITUDE_16 || || NUMBER(22) ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| ALTITUDE_25 || || NUMBER(22) ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| X || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
+
| Y || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| YVALUE ||  || NUMBER(22) ||  ||  
+
| DISTANCE_FROM_COAST ||  || 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 561: Line 595:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     g.idgrid
   , cp.crop_parametrization
+
   , g.idgrid_source
   , m.idmodel
+
   , idoriginal_code
   , m.model
+
   , latitude
   , c.idcover
+
   , longitude
   , c.cover
+
   , altitude
   , cps.idcrop_parameter
+
   , altitude_16
   , cps.crop_parameter
+
   , altitude_25
   , cps.descriptor
+
   , x
   , cpp.xvalue
+
   , y
   , cpp.yvalue
+
   , distance_from_coast
from
+
  , climate_barrier
    global_models m
+
   , has_land
   , global_covers c
+
   , grid_source
   , crop_parametrization_parameter cpp
+
   , resolution
   , crop_parametrizations cp
+
   , unit
   , global_crop_parameters cps
+
  from grids@CGMS14SYS_ASSISTSAN g
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
+
  , windows@CGMS14SYS_ASSISTSAN w
and  cpp.idcrop_parameter      = cps.idcrop_parameter
+
  , grid_sources@CGMS14SYS_ASSISTSAN gs
and  cp.idcover                = c.idcover
+
  where g.idgrid_source = gs.idgrid_source
  and  cp.idmodel                = m.idmodel
+
  and gs.idwindow = w.idwindow
and   cp.active_parametrization  = 'Y'
 
and  cps.category              = 'CROP'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_PARAMETERS_MODEL ===
+
=== GLOBAL_GRID_SOURCES ===
''Materialized_View''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 599: Line 630:
 
! 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) ||  ||
+
| IDGRID_SOURCE || 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 626: Line 651:
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
     cp.idcrop_parametrization
+
     idgrid_source
   , cp.crop_parametrization
+
   , gs.idwindow
   , m.idmodel
+
   , w.window
   , m.model
+
   , w.name
   , c.idcover
+
   , gs.resolution
   , c.cover
+
   , gs.unit
   , cps.idcrop_parameter
+
   , gs.description
   , cps.crop_parameter
+
   , gs.unc
  , cps.descriptor
+
  from grid_sources@CGMS14SYS_ASSISTSAN gs
  , cpp.xvalue
+
   , windows@CGMS14SYS_ASSISTSAN w
  , cpp.yvalue
+
  where gs.idwindow = w.idwindow
  from
 
    global_models m
 
  , global_covers c
 
  , crop_parametrization_parameter cpp
 
  , crop_parametrizations cp
 
   , global_crop_parameters cps
 
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 
and  cp.idcover                = c.idcover
 
and  cp.idmodel                = m.idmodel
 
and  cp.active_parametrization  = 'Y'
 
and  cps.category              = 'MODEL'
 
 
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_CROP_STU ===
+
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 664: Line 676:
 
! 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) ||  ||  
+
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||
 +
|-
 +
| 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) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| 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 -->
=== LINK_GRID_COVER ===
+
=== GLOBAL_MODELS ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 684: Line 729:
 
! 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) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    m.idmodel
 +
  , m.model
 +
  , m.descriptor
 +
from models@CGMS14SYS_ASSISTSAN m
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_GRID_REGION_COVER ===
+
=== GLOBAL_REGIONS ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 708: Line 760:
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGION || NOT NULL || VARCHAR2(20) ||  ||
 +
|-
 +
| 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 -->
=== LINK_REGION_COVER ===
+
=== GLOBAL_REGION_ELEMENTS ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 729: Line 792:
 
{|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) ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||
 +
|-
 +
| REGION || NOT NULL || VARCHAR2(20) ||  ||
 +
|-
 +
| 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) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| 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 -->
=== LINK_SMU_GRID_COVER ===
+
=== GLOBAL_REGION_SOURCES ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 752: Line 856:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DESCRIPTION || || VARCHAR2(255) ||  ||  
 
|-
 
|-
| AREA || NOT NULL || NUMBER(22) ||  ||  
+
| UNC || || VARCHAR2(255) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''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 -->
=== LINK_SMU_GRID_REGION_COVER ===
+
=== GLOBAL_SOIL_SOURCES ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 776: Line 889:
 
! 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) ||  ||
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
|-
 
| 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 -->
=== LINK_SMU_STU ===
+
=== GLOBAL_STATISTIC_SOURCES ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 802: Line 918:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
 
|-
 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    s.idstatistic_source
 +
  , s.statistic_source
 +
  , s.descriptor
 +
from statistic_sources@CGMS14SYS_ASSISTSAN s
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== LINK_STU_HORIZONS ===
+
=== GLOBAL_SUITABILITY_PROPERTIES ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 824: Line 947:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
|-
 
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||
 
|-
 
| 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 ==
+
<!-- start -->
{{TocTable|content=
+
=== GLOBAL_THRESHOLDS ===
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
+
''View''.
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
+
 
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
+
{|class="collapsing_table collapsible collapsed"
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
+
!Structure
{{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}}
+
{|class="wikitable"
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
+
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
+
|-
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
+
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  ||
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
+
|-
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
+
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  ||
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
+
|-
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
+
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
+
|-
}}
+
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||
 +
|-
 +
| VALUE_MIN || NOT NULL || NUMBER(22) || ||  
 +
|-
 +
| VALUE_MAX || NOT NULL || NUMBER(22) || ||  
 +
|-
 +
|}
 +
 
  
 +
'''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 -->
 
<!-- start -->
=== SIM_BLAST_HRES_GRID ===
+
=== GLOBAL_TIME_DIMENSIONS ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 869: Line 1,015:
 
{|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
|-
 
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||
 
|-
 
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||
 
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| DECADE || || NUMBER(22) ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DECADE_ID || || NUMBER(22) ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
+
| MONTH ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
+
| MONTH_ID ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| QUARTER ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| QUARTER_ID ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| YEAR ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| LAST_DAY_DECADE ||  || VARCHAR2(1) ||  ||  
 
|-
 
|-
| GAIWITHBLAST || || 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
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| TREATMENT || NOT NULL || VARCHAR2(60) ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
|-
 
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
 
|-
 
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 
|-
 
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||
 
|-
 
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    t.idtreatment
 +
  , t.treatment
 +
  , t.descriptor
 +
from treatments@cgms14sys_assistsan t
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_GRID_LTA ===
+
=== GLOBAL_WINDOWS ===
''Table''.  
+
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 934: Line 1,092:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
 
|-
 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
+
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  ||  
 
|-
 
|-
| 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) ||  ||  
+
| MIN_LON || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MAX_X || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MAX_Y || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MIN_X || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MIN_Y || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| ROI ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    w.idwindow
 +
  , w.window
 +
  , w.name
 +
  , w.reference_system
 +
  , w.descriptor
 +
  , w.max_lat
 +
  , w.max_lon
 +
  , w.min_lat
 +
  , w.min_lon
 +
  , w.max_x
 +
  , w.max_y
 +
  , w.min_x
 +
  , w.min_y
 +
  , w.roi
 +
from windows@CGMS14SYS_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_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| AVG_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| AVG_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
|-
 
|-
| MIN_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''definition:'''
 +
select
 +
    ca.idcrop_aggregation
 +
  , ca.idcrop
 +
  , c.crop
 +
  , c.descriptor
 +
  , cp.idmodel
 +
  , m.model
 +
  , m.descriptor
 +
  , ca.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , cp.descriptor 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_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| 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) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| START_DATE ||  || DATE ||  ||  
 
|-
 
|-
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
+
| END_DATE ||  || DATE ||  ||  
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
+
| DURATION ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
+
| START_DOY ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || 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 ===
 +
''Materialized_View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| MAX_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| YVALUE ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| MAX_RUE_POTENTIAL || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''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 -->
 +
 
 +
<!-- start -->
 +
=== LINK_CROP_PARAMETERS_CROP ===
 +
''Materialized_View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| MAX_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
| YVALUE ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) || ||
+
|}
|-
+
 
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) || ||
+
 
|-
+
'''definition:'''
| STD_STORAGEORGANSWITHBLAST || || NUMBER(22, 12) || ||
+
  select
|-
+
    cp.idcrop_parametrization
| STD_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) || ||
+
  , cp.crop_parametrization
|-
+
  , m.idmodel
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||
+
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
  from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 +
  and  cp.idcover                = c.idcover
 +
  and  cp.idmodel                = m.idmodel
 +
and  cp.active_parametrization  = 'Y'
 +
  and  cps.category              = 'CROP'
 +
   
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_CROP_PARAMETERS_MODEL ===
 +
''Materialized_View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| STD_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STD_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLASTRISKLEVEL || || NUMBER(22, 2) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| NUM_BLASTINFECTION || || NUMBER(22, 2) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLASTSPORULATION || || NUMBER(22, 2) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
+
| YVALUE ||  || NUMBER(22) ||  ||  
|-
 
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||
 
|-
 
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
 
 
|-
 
|-
 
|}
 
|}
  
|}
+
 
<!-- end -->
+
'''definition:'''
 
+
select
<!-- start -->
+
    cp.idcrop_parametrization
=== SIM_BLAST_HRES_REGION ===
+
  , cp.crop_parametrization
''Table''.  
+
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cpp.xvalue
 +
  , cpp.yvalue
 +
from
 +
    global_models m
 +
  , global_covers c
 +
  , crop_parametrization_parameter cpp
 +
  , crop_parametrizations cp
 +
  , global_crop_parameters cps
 +
where cpp.idcrop_parametrization = cp.idcrop_parametrization
 +
and  cpp.idcrop_parameter      = cps.idcrop_parameter
 +
and  cp.idcover                = c.idcover
 +
and  cp.idmodel                = m.idmodel
 +
and  cp.active_parametrization  = 'Y'
 +
and  cps.category              = 'MODEL'
 +
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_CROP_PARAMETRIZATION ===
 +
''View''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 1,148: Line 1,515:
 
! 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) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR || || VARCHAR2(255) ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
|-
 
|-
| BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
|-
 
|-
| LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) || ||  
+
|}
 +
 
 +
 
 +
'''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 -->
 +
 
 +
<!-- start -->
 +
=== LINK_CROP_SPATIALIZATIONS ===
 +
''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
 
|-
 
|-
| GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STORAGEORGANSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| DAYSWITHMEDIUMINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RUE_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
| VARIETY || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
 
|-
 
|-
| HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
+
| XVALUE || NOT NULL || NUMBER(22) ||  ||
 +
|-
 +
| YVALUE ||  || NUMBER(22) ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
    cp.idcrop_parametrization
 +
  , cp.crop_parametrization
 +
  , m.idmodel
 +
  , m.model
 +
  , c.idcover
 +
  , c.cover
 +
  , cs.idgrid
 +
  , v.idvariety
 +
  , v.variety
 +
  , cps.idcrop_parameter
 +
  , cps.crop_parameter
 +
  , cps.descriptor
 +
  , cvp.xvalue
 +
  , cvp.yvalue
 +
from global_models m
 +
  , global_covers c
 +
  , crop_varieties v
 +
  , crop_parametrizations cp
 +
  , crop_spatializations cs
 +
  , global_crop_parameters cps
 +
  , crop_variety_parameters cvp
 +
where cs.idcrop_parametrization = cp.idcrop_parametrization
 +
  and cp.idcover = c.idcover
 +
  and cs.idvariety = v.idvariety
 +
  and cp.idmodel = m.idmodel
 +
  and cs.idvariety = cvp.idvariety
 +
  and cvp.idcrop_parameter = cps.idcrop_parameter
 +
  and cp.active_parametrization = 'y'
 +
order by cs.idcrop_parametrization
 +
  , cs.idgrid
 +
  , cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_BLAST_HRES_REGION_LTA ===
+
=== LINK_CROP_STU ===
 
''Table''.  
 
''Table''.  
  
Line 1,212: Line 1,645:
 
! 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 || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| 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
 
|-
 
|-
| AVG_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| AVG_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| AVG_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| IDCOVER || NOT NULL || 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) || ||
+
|}
 +
 
 +
 
 +
'''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_POTENTIAL || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| AVG_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_GRID_REGION_COVER ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_BLASTRISKLEVEL || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_REGION_COVER ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_AGBPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_SIMULATION_UNIT ===
 +
''View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MIN_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK || || NUMBER(22, 8) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 8) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUE_POTENTIAL || || 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_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MIN_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMINIMUM || || NUMBER(22, 12) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_HUMIDITYMAXIMUM || || NUMBER(22, 12) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLASTRISKLEVEL || || NUMBER(22, 8) || ||
+
|}
|-
+
 
| MAX_BLASTINFECTION || || 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_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_SMU_GRID_REGION_COVER ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_SMU_STU ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| MAX_RUE_WITH_BLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| MAX_BLAST_EFFECT_ON_RUE || || NUMBER(22, 12) ||  ||  
+
| 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) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_STU_HORIZONS ===
 +
''Table''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_BLASTINFECTION || || NUMBER(22, 1) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_BLASTSPORULATION || || NUMBER(22, 1) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_GAIPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_GAIWITHBLAST || || NUMBER(22, 12) ||  ||  
+
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
+
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
<!-- start -->
 +
=== LINK_STU_WEIGHTED_PARAMETERS ===
 +
''View''.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
| STD_AGBWITHBLAST || || NUMBER(22, 12) ||  ||  
+
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| STD_STORAGEORGANSPOTENTIAL || || NUMBER(22, 12) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
+
| SAND ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| SILT ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
+
| CLAY ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||
+
| SOIL_MOISTURE_WP ||  || NUMBER(22) ||  ||  
|-
 
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
 
|-
 
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
 
|-
 
|-
| 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) || ||  
+
|}
 +
 
 +
 
 +
'''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
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| NUM_LEAVESBIOMASSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_LEAVESBIOMASSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_GAIPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| NUM_GAIWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| NUM_AGBPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_AGBWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSPOTENTIAL || || NUMBER(22, 2) ||  ||  
+
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
 
|-
 
|-
| NUM_STORAGEORGANSWITHBLAST || || NUMBER(22, 2) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHLOWINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||  
+
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK || || NUMBER(22, 2) ||  ||  
+
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_RUE_POTENTIAL || || NUMBER(22, 2) ||  ||  
+
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| NUM_RUE_WITH_BLAST || || NUMBER(22, 2) ||  ||  
+
| SUITABILITY_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  ||  
+
| SUITABILITY_PROPERTY_MIN ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  ||  
+
| SUITABILITY_PROPERTY_MAX ||  || NUMBER(22) ||  ||  
 
|-
 
|-
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  ||  
+
| 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 -->
  
<!-- start -->
+
== SIM-datasets ==
=== SIM_WARM_HRES_GRID ===
+
{{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 -->
 +
=== SIM_BLAST_HRES_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 1,436: Line 2,157:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL ||  || 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) ||  ||
 +
|-
 +
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,474: Line 2,201:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_GRID_LTA ===
+
=== SIM_BLAST_HRES_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 1,492: Line 2,219:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| 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_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
+
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  ||  
+
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
|}
+
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 
+
|-
|}
+
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
<!-- end -->
+
|-
 +
| 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 -->
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION ===
+
=== SIM_BLAST_HRES_REGION ===
 
''Table''.  
 
''Table''.  
  
Line 1,678: Line 2,435:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,716: Line 2,479:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WARM_HRES_REGION_LTA ===
+
=== SIM_BLAST_HRES_REGION_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 1,734: Line 2,497:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| 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_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
+
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
+
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
+
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
+
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
+
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  ||  
+
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
+
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  ||  
+
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  ||
 +
|-
 +
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  ||  
+
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TRANSPIRATION ||  || 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) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,900: Line 2,693:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU ===
+
=== SIM_WARM_HRES_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 1,913: Line 2,706:
 
|-
 
|-
 
| 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 1,922: Line 2,713:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FSM ||  || NUMBER(22, 3) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 1,960: Line 2,751:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_EMU_LTA ===
+
=== SIM_WARM_HRES_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 1,973: Line 2,764:
 
|-
 
|-
 
| 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 1,980: Line 2,769:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FSM ||  || NUMBER(22, 3) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| 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_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  ||  
+
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FSM ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_FSMUR ||  || NUMBER(22, 2) ||  ||  
+
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||  
+
| NUM_FORC_POTENTIAL_YISTORAGE ||  || 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,146: Line 2,935:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_GRID ===
+
=== SIM_WARM_HRES_REGION ===
 
''Table''.  
 
''Table''.  
  
Line 2,156: Line 2,945:
 
! 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) ||  ||  
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
Line 2,166: Line 2,955:
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FSM ||  || NUMBER(22, 3) ||  ||  
+
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,204: Line 2,993:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_GRID_LTA ===
+
=== SIM_WARM_HRES_REGION_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,214: Line 3,003:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| 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) ||  ||  
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 2,222: Line 3,011:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
+
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
+
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FSM ||  || NUMBER(22, 3) ||  ||  
+
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
+
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
+
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  ||  
+
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  ||  
+
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||  
+
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
+
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
+
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  ||  
 
|-
 
|-
 
| 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,388: Line 3,177:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_REGION ===
+
=== SIM_WOFOST_HRES_EMU ===
 
''Table''.  
 
''Table''.  
  
Line 2,398: Line 3,187:
 
! 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) ||  ||
 +
|-
 +
| 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 2,446: Line 3,237:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_REGION_LTA ===
+
=== SIM_WOFOST_HRES_EMU_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,456: Line 3,247:
 
! 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) ||  ||
 +
|-
 +
| 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 2,630: Line 3,423:
  
 
<!-- start -->
 
<!-- start -->
=== SIM_WOFOST_HRES_STU ===
+
=== SIM_WOFOST_HRES_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 2,643: Line 3,436:
 
|-
 
|-
 
| 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 2,651: Line 3,442:
 
|-
 
|-
 
| 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 2,690: Line 3,479:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 
== SOIL-datasets ==
 
{{TocTable|content=
 
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
 
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
 
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
 
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
 
}}
 
 
  
 
<!-- start -->
 
<!-- start -->
=== SOIL_HORIZONS ===
+
=== SIM_WOFOST_HRES_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,711: Line 3,491:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| IDGRID || 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_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ORIGINAL_LEVEL ||  || NUMBER(22, 1) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_WP ||  || NUMBER(22) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_FC ||  || NUMBER(22) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SOIL_MOISTURE_CONTENT_SAT ||  || NUMBER(22) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| DEPTH ||  || NUMBER(22, 5) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| USDA_CLASS# ||  || NUMBER(22, 3) ||  ||  
+
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| USDA_CLASS ||  || VARCHAR2(8) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| GRAVEL ||  || NUMBER(22, 3) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SAND ||  || NUMBER(22, 3) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SILT ||  || NUMBER(22, 3) ||  ||  
+
| AVG_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| CLAY ||  || NUMBER(22, 3) ||  ||  
+
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| BULK_DENSITY ||  || NUMBER(22, 5) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ORGANIC_CARBON ||  || NUMBER(22, 5) ||  ||  
+
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| PH_H2O ||  || NUMBER(22, 5) ||  ||  
+
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CLAY_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SOIL_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SOIL_BASE_SATURATION ||  || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TOTAL_EXCHANGEABLE_BASE ||  || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CALCIUM_CARBONATE ||  || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| CALCIUM_SULPHATE ||  || NUMBER(22, 5) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| EXCHANGEABLE_SODIUM ||  || NUMBER(22, 3) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| ELECTRICAL_CONDUCTIVITY ||  || NUMBER(22, 5) ||  ||  
+
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
|}
+
| 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
 
 
|-
 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_FSM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_FSMUR || || NUMBER(22, 3) ||  ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| INITIAL_DEPTH_GROUND_WATER ||  || NUMBER(22, 4) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| DRAINAGE_DEPTH ||  || NUMBER(22, 3) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ROOTING_DEPTH_POTENTIAL_WATER ||  || NUMBER(22, 3) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| POTENTIAL_WATER_STARTDATE ||  || DATE ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
|}
+
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SOIL_SMU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
|}
+
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
 
|}
 
<!-- end -->
 
 
 
<!-- start -->
 
=== SOIL_STU ===
 
''Table''.
 
 
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
 
|-
 
|-
|
+
| MAX_FSM || || NUMBER(22, 3) ||  ||  
{|class="wikitable"
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
 
|-
 
|-
| 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) ||  ||
 +
|-
 +
| STD_RUNOFF ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| 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) ||  ||  
 
|-
 
|-
| LIMITATION_TO_AGRIC_USE2 ||  || NUMBER(22, 2) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| OBSTACLE_TO_ROOTS ||  || NUMBER(22, 1) ||  ||  
+
| NUM_FSM ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| IMPERMEABLE_DEPTH_LAYER ||  || NUMBER(22, 1) ||  ||  
+
| NUM_FSMUR ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SOIL_WATER_REGIME ||  || NUMBER(22, 1) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| DEPTH_TO_BEDROCK ||  || VARCHAR2(8) ||  ||  
+
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SOIL_FAO74 ||  || VARCHAR2(8) ||  ||  
+
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| SOIL_FAO74_CL ||  || VARCHAR2(1) ||  ||  
+
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 2,890: Line 3,664:
 
<!-- end -->
 
<!-- end -->
  
== WEATHER-datasets ==
+
<!-- start -->
{{TocTable|content=
+
=== SIM_WOFOST_HRES_REGION ===
{{TocRow|#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID}}
+
''Table''.  
{{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''.  
 
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 2,930: Line 3,675:
 
! 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_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
 
| DAY || NOT NULL || DATE ||  ||  
 
| DAY || NOT NULL || DATE ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DOY || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| 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 2,968: Line 3,723:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_ERA_GRID_LTA ===
+
=== SIM_WOFOST_HRES_REGION_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 2,978: Line 3,733:
 
! 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_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
 
|-
 
|-
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| MONTH || NOT NULL || NUMBER(22, 2) ||  ||  
Line 2,984: Line 3,741:
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| AVG_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| AVG_FSM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| AVG_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MIN_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MIN_RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MIN_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MIN_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| MIN_FSM ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| MIN_FSMUR ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_RUNOFF || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MIN_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MAX_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| MAX_DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_FSM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_FSMUR || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| MAX_RUNOFF || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| MAX_SOIL_EVAPORATION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| MAX_LOSS_TO_SUBSOIL || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_POTENTIAL_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_POTENTIAL_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_WATER_LIM_YIELD_BIOMASS || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| STD_WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| STD_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_FSM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_FSMUR || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_RUNOFF || || NUMBER(22, 8) ||  ||
 +
|-
 +
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  ||
 +
|-
 +
| 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_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TOTAL_WATER_CONSUMPTION || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TOTAL_WATER_REQUIREMENT || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_FSM || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_FSMUR || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_LEAVES_DIED_BY_COLD || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  ||  
+
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,130: Line 3,907:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_ERA_REGIONCOVER ===
+
=== SIM_WOFOST_HRES_STU ===
 
''Table''.  
 
''Table''.  
  
Line 3,140: Line 3,917:
 
! 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) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || 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 ||  ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||
 +
|-
 +
| DOY || NOT NULL || NUMBER(22, 3) ||  ||
 +
|-
 +
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  ||
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  ||
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| WATER_LIM_YIELD_STORAGE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| POTENTIAL_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| WATER_LIM_LEAF_AREA_INDEX || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| DEVELOPMENT_STAGE || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| RELATIVE_SOIL_MOISTURE || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| TOTAL_WATER_CONSUMPTION || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| TOTAL_WATER_REQUIREMENT || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| FSM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| FSMUR || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| LEAVES_DIED_BY_COLD || || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| RUNOFF ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  ||  
+
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 3,179: Line 3,968:
 
<!-- end -->
 
<!-- end -->
  
<!-- start -->
+
== SOIL-datasets ==
=== WEATHER_ERA_REGIONCOVER_LTA ===
+
{{TocTable|content=
''Table''.  
+
{{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''.  
  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 3,190: Line 3,988:
 
! 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) ||  ||  
+
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| IDCOVER || 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_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| ORIGINAL_LEVEL || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| SOIL_MOISTURE_CONTENT_WP || || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| SOIL_MOISTURE_CONTENT_FC || || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SOIL_MOISTURE_CONTENT_SAT || || NUMBER(22) ||  ||  
 
|-
 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| DEPTH || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| USDA_CLASS# || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| USDA_CLASS || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| GRAVEL || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SAND || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| SILT || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| CLAY ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| BULK_DENSITY ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| ORGANIC_CARBON ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| PH_H2O || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| CLAY_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| SOIL_CATION_EXCNG_CAPCTY || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| SOIL_BASE_SATURATION || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| TOTAL_EXCHANGEABLE_BASE || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| CALCIUM_CARBONATE || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| CALCIUM_SULPHATE || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| EXCHANGEABLE_SODIUM || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| ELECTRICAL_CONDUCTIVITY || || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| 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
 
|-
 
|-
| MIN_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
+
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MIN_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| YEAR || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| INITIAL_DEPTH_GROUND_WATER || || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DRAINAGE_DEPTH || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| ROOTING_DEPTH_POTENTIAL_WATER || || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| POTENTIAL_WATER_STARTDATE || || DATE ||  ||  
 
|-
 
|-
| 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
 
|-
 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| IDSMU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| 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
 
|-
 
|-
| MAX_SNOWWEQ || || NUMBER(22, 6) ||  ||  
+
| IDSTU || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| MAX_TOTALCLOUD || || NUMBER(22, 3) ||  ||  
+
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
+
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| STU || NOT NULL || VARCHAR2(30) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
 
|-
 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| SOIL_WRB || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SOIL_WRB_CL || || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| SOIL_FAO90 || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SOIL_FAO90_CL || || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SOIL_FAO85 || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SOIL_FAO85_CL || || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| SLOPE || || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| TEXTURE || || VARCHAR2(1) ||  ||  
 
|-
 
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| PHASE ||  || VARCHAR2(2) ||  ||  
 
|-
 
|-
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| LAYERS ||  || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| STD_TOTALCLOUD ||  || NUMBER(22) ||  ||  
+
| CALCULATED_ROOTING_DEPTH ||  || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
+
| DRAINAGE || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
+
| LIMITATION_TO_AGRIC_USE1 || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  ||  
+
| LIMITATION_TO_AGRIC_USE2 || || NUMBER(22, 2) ||  ||  
 
|-
 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  ||  
+
| OBSTACLE_TO_ROOTS || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| IMPERMEABLE_DEPTH_LAYER || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  ||  
+
| SOIL_WATER_REGIME || || NUMBER(22, 1) ||  ||  
 
|-
 
|-
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| DEPTH_TO_BEDROCK || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  ||  
+
| SOIL_FAO74 || || VARCHAR2(8) ||  ||  
 
|-
 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  ||
+
| SOIL_FAO74_CL ||  || VARCHAR2(1) ||  ||  
|-
 
| 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 3,342: Line 4,166:
 
|}
 
|}
 
<!-- 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_HIS_GRID ===
+
=== WEATHER_ERA_GRID ===
 
''Table''.  
 
''Table''.  
  
Line 3,392: Line 4,247:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_HIS_REGIONCOVER ===
+
=== WEATHER_ERA_GRID_LTA ===
 
''Table''.  
 
''Table''.  
  
Line 3,402: Line 4,257:
 
! 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) ||  ||  
+
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
+
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
+
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
+
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
+
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
+
| AVG_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
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE || - || calendar day
+
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || °C || maximum air temperature
+
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || °C || minimum air temperature
+
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
 
|-
 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || °C || average air temperature
+
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| HUMIDITY_06H || || NUMBER(22, 6) || - ||  
+
| MIN_E0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| HUMIDITY_09H || || NUMBER(22, 6) || - ||  
+
| MIN_ES0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| HUMIDITY_12H || || NUMBER(22, 6) || - ||  
+
| MIN_ET0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| HUMIDITY_15H || || NUMBER(22, 6) || - ||  
+
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) || ||  
 
|-
 
|-
| HUMIDITY_18H ||  || NUMBER(22, 6) ||  ||  
+
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || m.s-1 || mean daily vapour pressure
+
| MIN_SNOWWEQ || || NUMBER(22, 6) || ||  
 
|-
 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) || hPa || mean daily wind speed at 10 m height
+
| MIN_TOTALCLOUD || || NUMBER(22, 3) || ||  
 
|-
 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily rainfall
+
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| E0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
+
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| ES0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
+
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| ET0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
+
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) || KJ.m-2.d-1 || daily radiation at surface
+
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) || cm || daily mean snow depth
+
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
 
|-
 
|-
|}
+
| 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
 
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| DAY || NOT NULL || DATE || - ||  
+
| MAX_ET0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| TEMPERATURE_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
+
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_1 || NOT NULL || NUMBER(22, 7) ||  ||  
+
| MAX_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_2 ||  || NUMBER(22, 7) ||  ||  
+
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_3 ||  || NUMBER(22, 7) ||  ||  
+
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TEMPERATURE_STATION_4 || || NUMBER(22, 7) ||  ||  
+
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| TEMPERATURE_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| PRECIPITATION_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
+
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| PRECIPITATION_STATION || NOT NULL || NUMBER(22, 7) ||  ||  
+
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| PRECIPITATION_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SNOWDEPTH_SOURCE || || VARCHAR2(10) ||  ||  
+
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  ||  
 
|-
 
|-
| SNOW_STATION || || NUMBER(22, 7) ||  ||  
+
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| SNOW_SCORE || || NUMBER(22, 6) ||  ||  
+
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| HUMIDITY_GROUP_SOURCE || || VARCHAR2(10) ||  ||  
+
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| HUMIDITY_STATION || || NUMBER(22, 7) ||  ||  
+
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  ||  
 
|-
 
|-
| HUMIDITY_SCORE || || NUMBER(22, 6) ||  ||  
+
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| REST_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  ||  
+
| STD_SNOWDEPTH || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| REST_STATION_1 || NOT NULL || NUMBER(22, 7) ||  ||  
+
| STD_SNOWWEQ || || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| REST_STATION_2 ||  || NUMBER(22, 7) ||  ||  
+
| STD_TOTALCLOUD ||  || NUMBER(22, 3) ||  ||  
 
|-
 
|-
| REST_STATION_3 || || NUMBER(22, 7) ||  ||  
+
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| REST_STATION_4 || || NUMBER(22, 7) ||  ||  
+
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  ||  
 
|-
 
|-
| REST_SCORE || NOT NULL || NUMBER(22, 6) ||  ||  
+
| NUM_TEMPERATURE_AVG || 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 3,560: Line 4,409:
  
 
<!-- start -->
 
<!-- start -->
=== WEATHER_OBS_GRID_LTA ===
+
=== WEATHER_ERA_REGIONCOVER ===
 
''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 3,572: Line 4,419:
 
! 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 ||  ||  
 
|-
 
|-
| TEMPERATURE_MIN || || NUMBER(22, 3) || °C || average maximum air temperature
+
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| TEMPERATURE_MAX || || NUMBER(22, 3) || °C || average minimum air temperature
+
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| TEMPERATURE_AVG || || NUMBER(22, 3) || °C || average mean air temperature
+
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| PRECIPITATION || || NUMBER(22, 4) || mm.d-1 || average daily rainfall
+
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| RADIATION || || NUMBER(22, 7) || KJ.m-2.d-1 || average daily radiation at surface
+
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| VAPOURPRESSURE || || NUMBER(22, 4) || hPa || average mean daily vapour pressure
+
| WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
 
|-
 
|-
| WINDSPEED || || NUMBER(22, 5) || m.s-1 || average mean daily wind speed at 10 m height
+
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| E0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of water surface
+
| E0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| ES0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of wet bare soil
+
| ES0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| ET0 || || NUMBER(22, 4) || mm.d-1 || average daily transpiration of crop canopy
+
| ET0 || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| SNOWDEPTH || || NUMBER(22, 6) || cm || average daily mean snow depth
+
| RADIATION || NOT NULL || NUMBER(22, 6) || ||  
 
|-
 
|-
| MIN_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || minimum minimum air temperature
+
| SNOWWEQ ||  || NUMBER(22, 6) || ||  
 
|-
 
|-
| MIN_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || minimum maximum air temperature
+
| SNOWDEPTH ||  || NUMBER(22, 6) || ||  
 
|-
 
|-
| MIN_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || minimum mean air temperature
+
| TOTALCLOUD ||  || NUMBER(22) || ||  
 
|-
 
|-
| 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
 
|-
 
|-
| MIN_VAPOURPRESSURE || || NUMBER(22, 4) || hPa || minimum mean daily vapour pressure
+
| IDREGION || NOT NULL || VARCHAR2(20) || ||  
 
|-
 
|-
| MIN_WINDSPEED || || NUMBER(22, 5) || m.s-1 || minimum mean daily wind speed at 10 m height
+
| IDCOVER || NOT NULL || NUMBER(22, 12) || ||  
 
|-
 
|-
| MIN_E0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of water surface
+
| MONTH || NOT NULL || NUMBER(22, 2) || ||  
 
|-
 
|-
| MIN_ES0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of wet bare soil
+
| DAYMONTH || NOT NULL || NUMBER(22, 2) || ||  
 
|-
 
|-
| MIN_ET0 || || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of crop canopy
+
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| MIN_SNOWDEPTH || || NUMBER(22, 6) || cm || minimum daily mean snow depth
+
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| MAX_TEMPERATURE_MIN || || NUMBER(22, 3) || °C || maximum maximum air temperature
+
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| MAX_TEMPERATURE_MAX || || NUMBER(22, 3) || °C || maximum maximum air temperature
+
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) || ||  
 
|-
 
|-
| MAX_TEMPERATURE_AVG || || NUMBER(22, 3) || °C || maximum mean air temperature
+
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| MAX_PRECIPITATION || || NUMBER(22, 4) || mm.d-1 || maximum daily rainfall
+
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) || ||  
 
|-
 
|-
| MAX_RADIATION || || NUMBER(22, 6) || KJ.m-2.d-1 || maximum daily radiation at surface
+
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) || ||  
 
|-
 
|-
| MAX_VAPOURPRESSURE || || NUMBER(22, 4) || hPa || maximum mean daily vapour pressure
+
| AVG_E0 || NOT NULL || NUMBER(22, 4) || ||