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

Revision as of 16:53, 28 January 2016

__NOTO C__

content
1. CROP-datasets
2. GLOBAL-datasets
3. LINK-datasets
4. SIM-datasets
5. SOIL-datasets
6. WEATHER-datasets
7. other datasets

CROP-datasets

content
1.1 CROP_AGGREGATIONS
1.2 CROP_CALENDARS
1.3 CROP_CALENDARS_OLD
1.4 CROP_PARAMETRIZATIONS
1.5 CROP_PARAMETRIZATION_PARAMETER
1.6 CROP_REGIMES
1.7 CROP_SPATIALIZATIONS
1.8 CROP_SUITABILITY_RULES
1.9 CROP_VARIETIES
1.10 CROP_VARIETY_PARAMETERS
1.11 CROP_VARIETY_PARAMETERS_OLD
1.12 CROP_VARIETY_REGIMES

CROP_AGGREGATIONS

Table.

Description:
Use:
Type: Permanent table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDCROP	NOT NULL	NUMBER(22, 12)
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)

CROP_CALENDARS

Table.

Description: where and when crops are grown. crop, crop variety and growing season per grid.
Use: determines which crops are simulated for a grid, and simulation period
Type: Permanent table
Remarks: user defined, one of the ‘driving’ tables of the system

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
YEAR	NOT NULL	NUMBER(22, 4)	-	calendar year
START_PERIOD	NOT NULL	VARCHAR2(20)
END_PERIOD	NOT NULL	VARCHAR2(20)
EMERGENCE		DATE
SOWING		DATE
HARVESTING		DATE
MATURITY		DATE
DURATION		NUMBER(22)
START_DOY		NUMBER(22)

* possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category).
** possible values: HARVEST, MATURITY, EARLIEST (see Spatial/temporal variation category).

CROP_CALENDARS_OLD

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
YEAR	NOT NULL	NUMBER(22, 4)
START_PERIOD	NOT NULL	VARCHAR2(20)
END_PERIOD	NOT NULL	VARCHAR2(20)
EMERGENCE		DATE
SOWING		DATE
HARVESTING		DATE
MATURITY		DATE
DURATION		NUMBER(22)
START_DOY		NUMBER(22)

CROP_PARAMETRIZATIONS

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDMODEL	NOT NULL	NUMBER(22, 12)
IDCOVER	NOT NULL	NUMBER(22, 12)
ACTIVE_PARAMETRIZATION	NOT NULL	VARCHAR2(1)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
DESCRIPTOR		VARCHAR2(255)

CROP_PARAMETRIZATION_PARAMETER

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

CROP_REGIMES

Table.

Structure

Attribute	Constraint	Type
IDCROP_REGIME	NOT NULL	NUMBER(22, 12)
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 2)
SOWING_REGIME	NOT NULL	VARCHAR2(30)
REGIME_DETAIL	NOT NULL	VARCHAR2(30)
DETAIL_VALUE	NOT NULL	VARCHAR2(30)
DETAIL_DIMENSION	NOT NULL	VARCHAR2(60)
DESCRIPTION		VARCHAR2(256)

CROP_SPATIALIZATIONS

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDVARIETY	NOT NULL	NUMBER(22, 12)

CROP_SUITABILITY_RULES

Table.

Structure

Attribute	Constraint	Type
IDCROP	NOT NULL	NUMBER(22, 12)
IDSUITABILITY_PROPERTY	NOT NULL	NUMBER(22, 12)
VALUEC		VARCHAR2(30)
VALUEN_MIN		NUMBER(22)
VALUEN_MAX		NUMBER(22)

CROP_VARIETIES

Table.

Structure

Attribute	Constraint	Type
IDVARIETY	NOT NULL	NUMBER(22, 12)
VARIETY	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(255)

CROP_VARIETY_PARAMETERS

Table.

Structure

Attribute	Constraint	Type
IDVARIETY	NOT NULL	NUMBER(22, 12)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

CROP_VARIETY_PARAMETERS_OLD

Table.

Structure

Attribute	Constraint	Type
IDVARIETY	NOT NULL	NUMBER(22, 12)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

CROP_VARIETY_REGIMES

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
IDVARIETY	NOT NULL	NUMBER(22, 12)
DECADE	NOT NULL	NUMBER(22)
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)

GLOBAL-datasets

content
2.1 GLOBAL_CATEGORIES
2.2 GLOBAL_COVERS
2.3 GLOBAL_COVER_SOURCES
2.4 GLOBAL_CROPS
2.5 GLOBAL_CROP_PARAMETERS
2.6 GLOBAL_GRIDS
2.7 GLOBAL_GRID_SOURCES
2.8 GLOBAL_LINK_COVERWINDOW_SOURCE
2.9 GLOBAL_MODELS
2.10 GLOBAL_REGIONS
2.11 GLOBAL_REGION_ELEMENTS
2.12 GLOBAL_REGION_SOURCES
2.13 GLOBAL_SOIL_SOURCES
2.14 GLOBAL_STATISTIC_SOURCES
2.15 GLOBAL_SUITABILITY_PROPERTIES
2.16 GLOBAL_THRESHOLDS
2.17 GLOBAL_TIME_DIMENSIONS
2.18 GLOBAL_TREATMENTS
2.19 GLOBAL_WINDOWS

GLOBAL_CATEGORIES

Table.

Structure

Attribute	Constraint	Type
IDCATEGORY	NOT NULL	NUMBER(22, 12)
CATEGORY	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(1000)

GLOBAL_COVERS

View.

Structure

Attribute	Constraint	Type
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(1000)

definition:

select
    c.idcover
  , c.cover
  , c.descriptor
from covers@CGMS14SYS_ASSISTSAN c

GLOBAL_COVER_SOURCES

View.

Structure

Attribute	Constraint	Type
IDCOVER_SOURCE	NOT NULL	NUMBER(22, 12)
COVER_SOURCE	NOT NULL	VARCHAR2(30)
DESCRIPTOR		VARCHAR2(255)
UNC		VARCHAR2(255)

definition:

select
  c.idcover_source
  , c.cover_source
  , c.descriptor
  , c.unc
from cover_sources@CGMS14SYS_ASSISTSAN c

GLOBAL_CROPS

View.

Structure

Attribute	Constraint	Type
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

GLOBAL_CROP_PARAMETERS

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
MULTI	NOT NULL	VARCHAR2(1)
IDCATEGORY	NOT NULL	NUMBER(22, 12)
CATEGORY	NOT NULL	VARCHAR2(30)

GLOBAL_GRIDS

View.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
IDGRID_SOURCE	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(20)
LATITUDE	NOT NULL	NUMBER(22)
LONGITUDE	NOT NULL	NUMBER(22)
ALTITUDE	NOT NULL	NUMBER(22)
ALTITUDE_16		NUMBER(22)
ALTITUDE_25		NUMBER(22)
X	NOT NULL	NUMBER(22)
Y	NOT NULL	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)

definition:

select
    g.idgrid
  , g.idgrid_source
  , idoriginal_code
  , latitude
  , longitude
  , altitude
  , altitude_16
  , altitude_25
  , x
  , y
  , distance_from_coast
  , climate_barrier
  , has_land
  , grid_source
  , resolution
  , unit
from grids@CGMS14SYS_ASSISTSAN g
  , windows@CGMS14SYS_ASSISTSAN w
  , grid_sources@CGMS14SYS_ASSISTSAN gs
where g.idgrid_source = gs.idgrid_source
  and gs.idwindow = w.idwindow

GLOBAL_GRID_SOURCES

View.

Structure

Attribute	Constraint	Type
IDGRID_SOURCE	NOT NULL	NUMBER(22, 12)
IDWINDOW	NOT NULL	NUMBER(22, 12)
WINDOW	NOT NULL	VARCHAR2(10)
NAME	NOT NULL	VARCHAR2(255)
RESOLUTION	NOT NULL	NUMBER(22)
UNIT	NOT NULL	VARCHAR2(20)
DESCRIPTION		VARCHAR2(255)
UNC		VARCHAR2(255)

definition:

select
    idgrid_source
  , gs.idwindow
  , w.window
  , w.name
  , gs.resolution
  , gs.unit
  , gs.description
  , gs.unc
from grid_sources@CGMS14SYS_ASSISTSAN gs
  , windows@CGMS14SYS_ASSISTSAN w
where gs.idwindow = w.idwindow

GLOBAL_LINK_COVERWINDOW_SOURCE

View.

Structure

Attribute	Constraint	Type
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)
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

GLOBAL_MODELS

View.

Structure

Attribute	Constraint	Type
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(1000)

definition:

select
    m.idmodel
  , m.model
  , m.descriptor
from models@CGMS14SYS_ASSISTSAN m

GLOBAL_REGIONS

View.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
REGION	NOT NULL	VARCHAR2(20)
NAME	NOT NULL	VARCHAR2(255)
CONTINENT	NOT NULL	VARCHAR2(20)
POPULATION		NUMBER(22)

definition:

select
    r.idregion
  , r.region
  , r.name
  , r.continent
  , r.population
from regions@CGMS14SYS_ASSISTSAN r

GLOBAL_REGION_ELEMENTS

View.

Structure

Attribute	Constraint	Type
IDREGION_ELEMENT	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(20)
IDREGION	NOT NULL	VARCHAR2(20)
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)
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

GLOBAL_REGION_SOURCES

View.

Structure

Attribute	Constraint	Type
IDREGION_SOURCE	NOT NULL	NUMBER(22, 12)
REGION_SOURCE	NOT NULL	VARCHAR2(20)
DESCRIPTION		VARCHAR2(255)
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

GLOBAL_SOIL_SOURCES

View.

Structure

Attribute	Constraint	Type
IDSOIL_SOURCE	NOT NULL	NUMBER(22, 12)
SOIL_SOURCE	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(255)

definition:

select
    s.idsoil_source
  , s.soil_source
  , s.descriptor
from soil_sources@CGMS14SYS_ASSISTSAN s

GLOBAL_STATISTIC_SOURCES

View.

Structure

Attribute	Constraint	Type
IDSTATISTIC_SOURCE	NOT NULL	NUMBER(22, 12)
STATISTIC_SOURCE	NOT NULL	VARCHAR2(60)
DESCRIPTOR	NOT NULL	VARCHAR2(255)

definition:

select
    s.idstatistic_source
  , s.statistic_source
  , s.descriptor
from statistic_sources@CGMS14SYS_ASSISTSAN s

GLOBAL_SUITABILITY_PROPERTIES

View.

Structure

Attribute	Constraint	Type
IDSUITABILITY_PROPERTY	NOT NULL	NUMBER(22, 12)
SUITABILITY_PROPERTY	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(255)

definition:

select
    p.idsuitability_property
  , p.suitability_property
  , p.descriptor
from suitability_properties@CGMS14SYS_ASSISTSAN p

GLOBAL_THRESHOLDS

View.

Structure

Attribute	Constraint	Type
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
THRESHOLD	NOT NULL	VARCHAR2(30)
INDICATOR	NOT NULL	VARCHAR2(30)
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

GLOBAL_TIME_DIMENSIONS

View.

Structure

Attribute	Constraint	Type
DAY	NOT NULL	DATE
DECADE		NUMBER(22)
DECADE_ID		NUMBER(22)
MONTH		NUMBER(22)
MONTH_ID		NUMBER(22)
QUARTER		NUMBER(22)
QUARTER_ID		NUMBER(22)
YEAR		NUMBER(22)
LAST_DAY_DECADE		VARCHAR2(1)

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

GLOBAL_TREATMENTS

View.

Structure

Attribute	Constraint	Type
IDTREATMENT	NOT NULL	NUMBER(22, 12)
TREATMENT	NOT NULL	VARCHAR2(60)
DESCRIPTOR	NOT NULL	VARCHAR2(255)

definition:

select
    t.idtreatment
  , t.treatment
  , t.descriptor
from treatments@cgms14sys_assistsan t

GLOBAL_WINDOWS

View.

Structure

Attribute	Constraint	Type
IDWINDOW	NOT NULL	NUMBER(22, 12)
WINDOW	NOT NULL	VARCHAR2(10)
NAME	NOT NULL	VARCHAR2(255)
REFERENCE_SYSTEM	NOT NULL	VARCHAR2(2000)
DESCRIPTOR		VARCHAR2(255)
MAX_LAT	NOT NULL	NUMBER(22)
MAX_LON	NOT NULL	NUMBER(22)
MIN_LAT	NOT NULL	NUMBER(22)
MIN_LON	NOT NULL	NUMBER(22)
MAX_X	NOT NULL	NUMBER(22)
MAX_Y	NOT NULL	NUMBER(22)
MIN_X	NOT NULL	NUMBER(22)
MIN_Y	NOT NULL	NUMBER(22)
ROI		NUMBER(22, 3)

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

LINK-datasets

content
3.1 LINK_CROP_AGGREGATION
3.2 LINK_CROP_CALENDARS
3.3 LINK_CROP_PARAMETERS
3.4 LINK_CROP_PARAMETERS_CROP
3.5 LINK_CROP_PARAMETERS_MODEL
3.6 LINK_CROP_PARAMETRIZATION
3.7 LINK_CROP_SPATIALIZATIONS
3.8 LINK_CROP_STU
3.9 LINK_CROP_VARIETY_PARAMETERS
3.10 LINK_GRID_COVER
3.11 LINK_GRID_REGION_COVER
3.12 LINK_REGION_COVER
3.13 LINK_SIMULATION_UNIT
3.14 LINK_SIMULATION_UNIT_CROP
3.15 LINK_SMU_GRID_COVER
3.16 LINK_SMU_GRID_REGION_COVER
3.17 LINK_SMU_STU
3.18 LINK_STU_HORIZONS
3.19 LINK_STU_WEIGHTED_PARAMETERS
3.20 LINK_SUITABILITY_RULES

LINK_CROP_AGGREGATION

View.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDCROP	NOT NULL	NUMBER(22, 12)
CROP	NOT NULL	VARCHAR2(30)
CROP_DESCRIPTOR	NOT NULL	VARCHAR2(255)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
MODEL_DESCRIPTOR	NOT NULL	VARCHAR2(1000)
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
PARAMETRIZATION_DESCRIPTOR		VARCHAR2(255)

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

LINK_CROP_CALENDARS

View.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDGRID	NOT NULL	NUMBER(22, 12)
YEAR	NOT NULL	NUMBER(22, 4)
START_PERIOD	NOT NULL	VARCHAR2(20)
START_DATE		DATE
END_DATE		DATE
DURATION		NUMBER(22)
START_DOY		NUMBER(22)

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

LINK_CROP_PARAMETERS

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
IDCATEGORY	NOT NULL	NUMBER(22, 12)
CATEGORY	NOT NULL	VARCHAR2(30)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

LINK_CROP_PARAMETERS_CROP

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

LINK_CROP_PARAMETERS_MODEL

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

LINK_CROP_PARAMETRIZATION

View.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
PARAMETRIZATION_DESCRIPTOR		VARCHAR2(255)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
MODEL_DESCRIPTOR	NOT NULL	VARCHAR2(1000)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
COVER_DESCRIPTOR	NOT NULL	VARCHAR2(1000)

definition:

select
    cp.idcrop_parametrization
  , cp.crop_parametrization
  , cp.descriptor
  , cp.idmodel
  , m.model
  , m.descriptor
  , c.idcover
  , c.cover
  , c.descriptor
from crop_parametrizations cp
  , global_models m
  , global_covers c
where cp.idmodel = m.idmodel
  and   cp.idcover = c.idcover
order by cp.idcrop_parametrization

LINK_CROP_SPATIALIZATIONS

View.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDGRID	NOT NULL	NUMBER(22, 12)
IDVARIETY	NOT NULL	NUMBER(22, 12)
VARIETY	NOT NULL	VARCHAR2(30)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

definition:

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

LINK_CROP_STU

Table.

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	NUMBER(22, 12)

LINK_CROP_VARIETY_PARAMETERS

View.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
IDCOVER	NOT NULL	NUMBER(22, 12)
COVER	NOT NULL	VARCHAR2(30)
IDVARIETY	NOT NULL	NUMBER(22, 12)
VARIETY	NOT NULL	VARCHAR2(30)
IDCROP_PARAMETER	NOT NULL	NUMBER(22, 12)
CROP_PARAMETER	NOT NULL	VARCHAR2(40)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
XVALUE	NOT NULL	NUMBER(22)
YVALUE		NUMBER(22)

definition:

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

LINK_GRID_COVER

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
IDCOVER	NOT NULL	NUMBER(22, 12)
AREA	NOT NULL	NUMBER(22)

LINK_GRID_REGION_COVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
AREA	NOT NULL	NUMBER(22)

LINK_REGION_COVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
AREA	NOT NULL	NUMBER(22)

LINK_SIMULATION_UNIT

View.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	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

LINK_SIMULATION_UNIT_CROP

View.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	NUMBER(22, 12)

definition:

select
distinct
    ca.idcrop_parametrization
  , lgsc.idgrid
  , lss.idstu
from
    link_crop_stu lcs
  , link_smu_grid_cover lgsc
  , link_smu_stu lss
  , crop_aggregations ca
  , crop_parametrizations cp
where lcs.idstu                 = lss.idstu
and   lss.idsmu                 = lgsc.idsmu
and   lcs.idcrop                = ca.idcrop
and   ca.idcrop_parametrization = cp.idcrop_parametrization
and   cp.idcover                = lgsc.idcover
order by
    ca.idcrop_parametrization
  , lgsc.idgrid
  , lss.idstu

LINK_SMU_GRID_COVER

Table.

Structure

Attribute	Constraint	Type
IDCOVER	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSMU	NOT NULL	NUMBER(22, 12)
AREA	NOT NULL	NUMBER(22)

LINK_SMU_GRID_REGION_COVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSMU	NOT NULL	NUMBER(22, 12)
AREA	NOT NULL	NUMBER(22)

LINK_SMU_STU

Table.

Structure

Attribute	Constraint	Type
IDSMU	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	NUMBER(22, 12)
PERCENTAGE	NOT NULL	NUMBER(22)

LINK_STU_HORIZONS

Table.

Structure

Attribute	Constraint	Type
IDSTU	NOT NULL	NUMBER(22, 12)
IDHORIZON	NOT NULL	NUMBER(22, 12)
DEPTH_MIN	NOT NULL	NUMBER(22, 5)
DEPTH_MAX	NOT NULL	NUMBER(22, 5)
HORIZON_LEVEL	NOT NULL	NUMBER(22, 1)

LINK_STU_WEIGHTED_PARAMETERS

View.

Structure

Attribute	Constraint	Type
IDSTU	NOT NULL	NUMBER(22, 12)
SAND		NUMBER(22)
SILT		NUMBER(22)
CLAY		NUMBER(22)
SOIL_MOISTURE_WP		NUMBER(22)
SOIL_MOISTURE_FC		NUMBER(22)
SOIL_MOISTURE_SAT		NUMBER(22)
BULK_DENSITY		NUMBER(22)
ORGANIC_CARBON		NUMBER(22)
DEPTH		NUMBER(22)

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

LINK_SUITABILITY_RULES

View.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDCROP	NOT NULL	NUMBER(22, 12)
CROP	NOT NULL	VARCHAR2(30)
CROP_DESCRIPTOR	NOT NULL	VARCHAR2(255)
IDMODEL	NOT NULL	NUMBER(22, 12)
MODEL	NOT NULL	VARCHAR2(30)
MODEL_DESCRIPTOR	NOT NULL	VARCHAR2(1000)
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
CROP_PARAMETRIZATION	NOT NULL	VARCHAR2(20)
PARAMETRIZATION_DESCRIPTOR		VARCHAR2(255)
IDSUITABILITY_PROPERTY	NOT NULL	NUMBER(22, 12)
SUITABILITY_PROPERTY	NOT NULL	VARCHAR2(30)
SUITABILITY_DESCRIPTOR	NOT NULL	VARCHAR2(255)
SUITABILITY_PROPERTY_MIN		NUMBER(22)
SUITABILITY_PROPERTY_MAX		NUMBER(22)
SUITABILITY_PROPERTY_VALUE		VARCHAR2(30)

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

SIM-datasets

content
4.1 SIM_BLAST_HRES_GRID
4.2 SIM_BLAST_HRES_GRID_LTA
4.3 SIM_BLAST_HRES_REGION
4.4 SIM_BLAST_HRES_REGION_LTA
4.5 SIM_WARM_HRES_GRID
4.6 SIM_WARM_HRES_GRID_LTA
4.7 SIM_WARM_HRES_REGION
4.8 SIM_WARM_HRES_REGION_LTA
4.9 SIM_WOFOST_HRES_EMU
4.10 SIM_WOFOST_HRES_EMU_LTA
4.11 SIM_WOFOST_HRES_GRID
4.12 SIM_WOFOST_HRES_GRID_LTA
4.13 SIM_WOFOST_HRES_REGION
4.14 SIM_WOFOST_HRES_REGION_LTA
4.15 SIM_WOFOST_HRES_STU

SIM_BLAST_HRES_GRID

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIM_BLAST_HRES_GRID_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_BLASTRISKLEVEL		NUMBER(22, 8)
AVG_BLASTINFECTION		NUMBER(22, 1)
AVG_BLASTSPORULATION		NUMBER(22, 1)
AVG_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
AVG_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
AVG_GAIPOTENTIAL		NUMBER(22, 12)
AVG_GAIWITHBLAST		NUMBER(22, 12)
AVG_AGBPOTENTIAL		NUMBER(22, 12)
AVG_AGBWITHBLAST		NUMBER(22, 12)
AVG_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
AVG_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
AVG_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
AVG_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_RUE_POTENTIAL		NUMBER(22, 12)
AVG_RUE_WITH_BLAST		NUMBER(22, 12)
AVG_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
AVG_HUMIDITYMINIMUM		NUMBER(22, 12)
AVG_HUMIDITYMAXIMUM		NUMBER(22, 12)
MIN_BLASTRISKLEVEL		NUMBER(22, 8)
MIN_BLASTINFECTION		NUMBER(22, 1)
MIN_BLASTSPORULATION		NUMBER(22, 1)
MIN_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MIN_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MIN_GAIPOTENTIAL		NUMBER(22, 12)
MIN_GAIWITHBLAST		NUMBER(22, 12)
MIN_AGBPOTENTIAL		NUMBER(22, 12)
MIN_AGBWITHBLAST		NUMBER(22, 12)
MIN_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MIN_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MIN_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MIN_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_RUE_POTENTIAL		NUMBER(22, 12)
MIN_RUE_WITH_BLAST		NUMBER(22, 12)
MIN_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MIN_HUMIDITYMINIMUM		NUMBER(22, 12)
MIN_HUMIDITYMAXIMUM		NUMBER(22, 12)
MAX_BLASTRISKLEVEL		NUMBER(22, 8)
MAX_BLASTINFECTION		NUMBER(22, 1)
MAX_BLASTSPORULATION		NUMBER(22, 1)
MAX_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MAX_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MAX_GAIPOTENTIAL		NUMBER(22, 12)
MAX_GAIWITHBLAST		NUMBER(22, 12)
MAX_AGBPOTENTIAL		NUMBER(22, 12)
MAX_AGBWITHBLAST		NUMBER(22, 12)
MAX_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MAX_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MAX_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MAX_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_RUE_POTENTIAL		NUMBER(22, 12)
MAX_RUE_WITH_BLAST		NUMBER(22, 12)
MAX_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MAX_HUMIDITYMINIMUM		NUMBER(22, 12)
MAX_HUMIDITYMAXIMUM		NUMBER(22, 12)
STD_BLASTRISKLEVEL		NUMBER(22, 8)
STD_BLASTINFECTION		NUMBER(22, 1)
STD_BLASTSPORULATION		NUMBER(22, 1)
STD_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
STD_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
STD_GAIPOTENTIAL		NUMBER(22, 12)
STD_GAIWITHBLAST		NUMBER(22, 12)
STD_AGBPOTENTIAL		NUMBER(22, 12)
STD_AGBWITHBLAST		NUMBER(22, 12)
STD_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STD_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
STD_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
STD_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_RUE_POTENTIAL		NUMBER(22, 12)
STD_RUE_WITH_BLAST		NUMBER(22, 12)
STD_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
STD_HUMIDITYMINIMUM		NUMBER(22, 12)
STD_HUMIDITYMAXIMUM		NUMBER(22, 12)
NUM_BLASTRISKLEVEL		NUMBER(22, 2)
NUM_BLASTINFECTION		NUMBER(22, 2)
NUM_BLASTSPORULATION		NUMBER(22, 2)
NUM_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 2)
NUM_LEAVESBIOMASSWITHBLAST		NUMBER(22, 2)
NUM_GAIPOTENTIAL		NUMBER(22, 2)
NUM_GAIWITHBLAST		NUMBER(22, 2)
NUM_AGBPOTENTIAL		NUMBER(22, 2)
NUM_AGBWITHBLAST		NUMBER(22, 2)
NUM_STORAGEORGANSPOTENTIAL		NUMBER(22, 2)
NUM_STORAGEORGANSWITHBLAST		NUMBER(22, 2)
NUM_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 2)
NUM_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_RUE_POTENTIAL		NUMBER(22, 2)
NUM_RUE_WITH_BLAST		NUMBER(22, 2)
NUM_BLAST_EFFECT_ON_RUE		NUMBER(22, 2)
NUM_HUMIDITYMINIMUM		NUMBER(22, 2)
NUM_HUMIDITYMAXIMUM		NUMBER(22, 2)

SIM_BLAST_HRES_REGION

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
BLASTRISKLEVEL		NUMBER(22, 8)
BLASTINFECTION		NUMBER(22, 1)
BLASTSPORULATION		NUMBER(22, 1)
LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
GAIPOTENTIAL		NUMBER(22, 12)
GAIWITHBLAST		NUMBER(22, 12)
AGBPOTENTIAL		NUMBER(22, 12)
AGBWITHBLAST		NUMBER(22, 12)
STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STORAGEORGANSWITHBLAST		NUMBER(22, 12)
DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
DAYSWITHMEDIUMINFECTIONRISK		NUMBER(22, 8)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
RUE_POTENTIAL		NUMBER(22, 12)
RUE_WITH_BLAST		NUMBER(22, 12)
BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
HUMIDITYMINIMUM		NUMBER(22, 12)
HUMIDITYMAXIMUM		NUMBER(22, 12)

SIM_BLAST_HRES_REGION_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_BLASTRISKLEVEL		NUMBER(22, 8)
AVG_BLASTINFECTION		NUMBER(22, 1)
AVG_BLASTSPORULATION		NUMBER(22, 1)
AVG_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
AVG_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
AVG_GAIPOTENTIAL		NUMBER(22, 12)
AVG_GAIWITHBLAST		NUMBER(22, 12)
AVG_AGBPOTENTIAL		NUMBER(22, 12)
AVG_AGBWITHBLAST		NUMBER(22, 12)
AVG_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
AVG_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
AVG_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
AVG_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_RUE_POTENTIAL		NUMBER(22, 12)
AVG_RUE_WITH_BLAST		NUMBER(22, 12)
AVG_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
AVG_HUMIDITYMINIMUM		NUMBER(22, 12)
AVG_HUMIDITYMAXIMUM		NUMBER(22, 12)
MIN_BLASTRISKLEVEL		NUMBER(22, 8)
MIN_BLASTINFECTION		NUMBER(22, 1)
MIN_BLASTSPORULATION		NUMBER(22, 1)
MIN_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MIN_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MIN_GAIPOTENTIAL		NUMBER(22, 12)
MIN_GAIWITHBLAST		NUMBER(22, 12)
MIN_AGBPOTENTIAL		NUMBER(22, 12)
MIN_AGBWITHBLAST		NUMBER(22, 12)
MIN_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MIN_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MIN_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MIN_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_RUE_POTENTIAL		NUMBER(22, 12)
MIN_RUE_WITH_BLAST		NUMBER(22, 12)
MIN_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MIN_HUMIDITYMINIMUM		NUMBER(22, 12)
MIN_HUMIDITYMAXIMUM		NUMBER(22, 12)
MAX_BLASTRISKLEVEL		NUMBER(22, 8)
MAX_BLASTINFECTION		NUMBER(22, 1)
MAX_BLASTSPORULATION		NUMBER(22, 1)
MAX_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
MAX_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
MAX_GAIPOTENTIAL		NUMBER(22, 12)
MAX_GAIWITHBLAST		NUMBER(22, 12)
MAX_AGBPOTENTIAL		NUMBER(22, 12)
MAX_AGBWITHBLAST		NUMBER(22, 12)
MAX_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
MAX_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
MAX_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
MAX_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_RUE_POTENTIAL		NUMBER(22, 12)
MAX_RUE_WITH_BLAST		NUMBER(22, 12)
MAX_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
MAX_HUMIDITYMINIMUM		NUMBER(22, 12)
MAX_HUMIDITYMAXIMUM		NUMBER(22, 12)
STD_BLASTRISKLEVEL		NUMBER(22, 8)
STD_BLASTINFECTION		NUMBER(22, 1)
STD_BLASTSPORULATION		NUMBER(22, 1)
STD_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 12)
STD_LEAVESBIOMASSWITHBLAST		NUMBER(22, 12)
STD_GAIPOTENTIAL		NUMBER(22, 12)
STD_GAIWITHBLAST		NUMBER(22, 12)
STD_AGBPOTENTIAL		NUMBER(22, 12)
STD_AGBWITHBLAST		NUMBER(22, 12)
STD_STORAGEORGANSPOTENTIAL		NUMBER(22, 12)
STD_STORAGEORGANSWITHBLAST		NUMBER(22, 12)
STD_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 8)
STD_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 8)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_RUE_POTENTIAL		NUMBER(22, 12)
STD_RUE_WITH_BLAST		NUMBER(22, 12)
STD_BLAST_EFFECT_ON_RUE		NUMBER(22, 12)
STD_HUMIDITYMINIMUM		NUMBER(22, 12)
STD_HUMIDITYMAXIMUM		NUMBER(22, 12)
NUM_BLASTRISKLEVEL		NUMBER(22, 2)
NUM_BLASTINFECTION		NUMBER(22, 2)
NUM_BLASTSPORULATION		NUMBER(22, 2)
NUM_LEAVESBIOMASSPOTENTIAL		NUMBER(22, 2)
NUM_LEAVESBIOMASSWITHBLAST		NUMBER(22, 2)
NUM_GAIPOTENTIAL		NUMBER(22, 2)
NUM_GAIWITHBLAST		NUMBER(22, 2)
NUM_AGBPOTENTIAL		NUMBER(22, 2)
NUM_AGBWITHBLAST		NUMBER(22, 2)
NUM_STORAGEORGANSPOTENTIAL		NUMBER(22, 2)
NUM_STORAGEORGANSWITHBLAST		NUMBER(22, 2)
NUM_DAYSWITHLOWINFECTIONRISK		NUMBER(22, 2)
NUM_DAYSWITHMEDIUMINFECTIONRSK		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_RUE_POTENTIAL		NUMBER(22, 2)
NUM_RUE_WITH_BLAST		NUMBER(22, 2)
NUM_BLAST_EFFECT_ON_RUE		NUMBER(22, 2)
NUM_HUMIDITYMINIMUM		NUMBER(22, 2)
NUM_HUMIDITYMAXIMUM		NUMBER(22, 2)

SIM_WARM_HRES_GRID

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIM_WARM_HRES_GRID_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 12)
AVG_SPIKELET_STERILITY		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_TRANSPIRATION		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 12)
MIN_SPIKELET_STERILITY		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_TRANSPIRATION		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 12)
MAX_SPIKELET_STERILITY		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_TRANSPIRATION		NUMBER(22, 12)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
STD_DEVELOPMENT_STAGE		NUMBER(22, 12)
STD_SPIKELET_STERILITY		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
STD_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_TRANSPIRATION		NUMBER(22, 12)
NUM_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_POTENTIAL_YIELD_STORAGE		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 2)
NUM_DEVELOPMENT_STAGE		NUMBER(22, 2)
NUM_SPIKELET_STERILITY		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_TRANSPIRATION		NUMBER(22, 2)

SIM_WARM_HRES_REGION

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DEVELOPMENT_STAGE		NUMBER(22, 12)
SPIKELET_STERILITY		NUMBER(22, 12)
BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_BIOMASS		NUMBER(22, 12)
BLAST_ABIOTIC_LIM_YI_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
FORC_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
FORC_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
TRANSPIRATION		NUMBER(22, 12)

SIM_WARM_HRES_REGION_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
AVG_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 12)
AVG_SPIKELET_STERILITY		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
AVG_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
AVG_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
AVG_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
AVG_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
AVG_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
AVG_TRANSPIRATION		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MIN_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 12)
MIN_SPIKELET_STERILITY		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MIN_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MIN_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MIN_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MIN_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MIN_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MIN_TRANSPIRATION		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
MAX_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 12)
MAX_SPIKELET_STERILITY		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
MAX_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
MAX_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
MAX_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
MAX_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
MAX_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
MAX_TRANSPIRATION		NUMBER(22, 12)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 12)
STD_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 12)
STD_DEVELOPMENT_STAGE		NUMBER(22, 12)
STD_SPIKELET_STERILITY		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 12)
STD_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 12)
STD_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 12)
STD_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 12)
STD_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 12)
STD_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 8)
STD_TRANSPIRATION		NUMBER(22, 12)
NUM_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_POTENTIAL_YIELD_STORAGE		NUMBER(22, 2)
NUM_ABIOTIC_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 2)
NUM_DEVELOPMENT_STAGE		NUMBER(22, 2)
NUM_SPIKELET_STERILITY		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_BIOMASS		NUMBER(22, 2)
NUM_BLAST_LIM_YIELD_STORAGE		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYIBIOMASS		NUMBER(22, 2)
NUM_BLAST_ABIOTIC_LIMYISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YIBIOMASS		NUMBER(22, 2)
NUM_FORC_POTENTIAL_YISTORAGE		NUMBER(22, 2)
NUM_FORC_POTENTIAL_LEAFAREAIDX		NUMBER(22, 2)
NUM_DAYSWITHHIGHINFECTIONRISK		NUMBER(22, 2)
NUM_TRANSPIRATION		NUMBER(22, 2)

SIM_WOFOST_HRES_EMU

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSMU	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
DEVELOPMENT_STAGE		NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
FSM		NUMBER(22, 3)
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)

SIM_WOFOST_HRES_EMU_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSMU	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 4)
AVG_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
AVG_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
AVG_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
AVG_FSM		NUMBER(22, 3)
AVG_FSMUR		NUMBER(22, 3)
AVG_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
AVG_RUNOFF		NUMBER(22, 8)
AVG_SOIL_EVAPORATION		NUMBER(22, 8)
AVG_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 4)
MIN_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MIN_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MIN_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MIN_FSM		NUMBER(22, 3)
MIN_FSMUR		NUMBER(22, 3)
MIN_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MIN_RUNOFF		NUMBER(22, 8)
MIN_SOIL_EVAPORATION		NUMBER(22, 8)
MIN_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 4)
MAX_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MAX_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MAX_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MAX_FSM		NUMBER(22, 3)
MAX_FSMUR		NUMBER(22, 3)
MAX_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MAX_RUNOFF		NUMBER(22, 8)
MAX_SOIL_EVAPORATION		NUMBER(22, 8)
MAX_LOSS_TO_SUBSOIL		NUMBER(22, 8)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
STD_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
STD_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_DEVELOPMENT_STAGE		NUMBER(22, 4)
STD_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
STD_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
STD_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
STD_FSM		NUMBER(22, 3)
STD_FSMUR		NUMBER(22, 3)
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)
NUM_TOTAL_WATER_REQUIREMENT		NUMBER(22, 2)
NUM_FSM		NUMBER(22, 2)
NUM_FSMUR		NUMBER(22, 2)
NUM_LEAVES_DIED_BY_COLD		NUMBER(22, 2)
NUM_RUNOFF		NUMBER(22, 2)
NUM_SOIL_EVAPORATION		NUMBER(22, 2)
NUM_LOSS_TO_SUBSOIL		NUMBER(22, 2)

SIM_WOFOST_HRES_GRID

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
DEVELOPMENT_STAGE		NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
FSM		NUMBER(22, 3)
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)

SIM_WOFOST_HRES_GRID_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 4)
AVG_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
AVG_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
AVG_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
AVG_FSM		NUMBER(22, 3)
AVG_FSMUR		NUMBER(22, 3)
AVG_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
AVG_RUNOFF		NUMBER(22, 8)
AVG_SOIL_EVAPORATION		NUMBER(22, 8)
AVG_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 4)
MIN_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MIN_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MIN_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MIN_FSM		NUMBER(22, 3)
MIN_FSMUR		NUMBER(22, 3)
MIN_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MIN_RUNOFF		NUMBER(22, 8)
MIN_SOIL_EVAPORATION		NUMBER(22, 8)
MIN_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 4)
MAX_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MAX_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MAX_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MAX_FSM		NUMBER(22, 3)
MAX_FSMUR		NUMBER(22, 3)
MAX_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MAX_RUNOFF		NUMBER(22, 8)
MAX_SOIL_EVAPORATION		NUMBER(22, 8)
MAX_LOSS_TO_SUBSOIL		NUMBER(22, 8)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
STD_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
STD_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_DEVELOPMENT_STAGE		NUMBER(22, 4)
STD_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
STD_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
STD_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
STD_FSM		NUMBER(22, 3)
STD_FSMUR		NUMBER(22, 3)
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)
NUM_TOTAL_WATER_REQUIREMENT		NUMBER(22, 2)
NUM_FSM		NUMBER(22, 2)
NUM_FSMUR		NUMBER(22, 2)
NUM_LEAVES_DIED_BY_COLD		NUMBER(22, 2)
NUM_RUNOFF		NUMBER(22, 2)
NUM_SOIL_EVAPORATION		NUMBER(22, 2)
NUM_LOSS_TO_SUBSOIL		NUMBER(22, 2)

SIM_WOFOST_HRES_REGION

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
DAY	NOT NULL	DATE
YEAR	NOT NULL	NUMBER(22, 4)
DOY	NOT NULL	NUMBER(22, 3)
POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
DEVELOPMENT_STAGE		NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
FSM		NUMBER(22, 3)
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)

SIM_WOFOST_HRES_REGION_LTA

Table.

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
AVG_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
AVG_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
AVG_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
AVG_DEVELOPMENT_STAGE		NUMBER(22, 4)
AVG_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
AVG_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
AVG_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
AVG_FSM		NUMBER(22, 3)
AVG_FSMUR		NUMBER(22, 3)
AVG_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
AVG_RUNOFF		NUMBER(22, 8)
AVG_SOIL_EVAPORATION		NUMBER(22, 8)
AVG_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MIN_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MIN_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MIN_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MIN_DEVELOPMENT_STAGE		NUMBER(22, 4)
MIN_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MIN_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MIN_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MIN_FSM		NUMBER(22, 3)
MIN_FSMUR		NUMBER(22, 3)
MIN_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MIN_RUNOFF		NUMBER(22, 8)
MIN_SOIL_EVAPORATION		NUMBER(22, 8)
MIN_LOSS_TO_SUBSOIL		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
MAX_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
MAX_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
MAX_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
MAX_DEVELOPMENT_STAGE		NUMBER(22, 4)
MAX_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
MAX_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
MAX_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
MAX_FSM		NUMBER(22, 3)
MAX_FSMUR		NUMBER(22, 3)
MAX_LEAVES_DIED_BY_COLD		NUMBER(22, 8)
MAX_RUNOFF		NUMBER(22, 8)
MAX_SOIL_EVAPORATION		NUMBER(22, 8)
MAX_LOSS_TO_SUBSOIL		NUMBER(22, 8)
STD_POTENTIAL_YIELD_BIOMASS		NUMBER(22, 8)
STD_POTENTIAL_YIELD_STORAGE		NUMBER(22, 8)
STD_WATER_LIM_YIELD_BIOMASS		NUMBER(22, 8)
STD_WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
STD_POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
STD_DEVELOPMENT_STAGE		NUMBER(22, 4)
STD_RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
STD_TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
STD_TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
STD_FSM		NUMBER(22, 3)
STD_FSMUR		NUMBER(22, 3)
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)
NUM_TOTAL_WATER_REQUIREMENT		NUMBER(22, 2)
NUM_FSM		NUMBER(22, 2)
NUM_FSMUR		NUMBER(22, 2)
NUM_LEAVES_DIED_BY_COLD		NUMBER(22, 2)
NUM_RUNOFF		NUMBER(22, 2)
NUM_SOIL_EVAPORATION		NUMBER(22, 2)
NUM_LOSS_TO_SUBSOIL		NUMBER(22, 2)

SIM_WOFOST_HRES_STU

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
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)
WATER_LIM_YIELD_STORAGE		NUMBER(22, 8)
POTENTIAL_LEAF_AREA_INDEX		NUMBER(22, 5)
WATER_LIM_LEAF_AREA_INDEX		NUMBER(22, 5)
DEVELOPMENT_STAGE		NUMBER(22, 4)
RELATIVE_SOIL_MOISTURE		NUMBER(22, 8)
TOTAL_WATER_CONSUMPTION		NUMBER(22, 8)
TOTAL_WATER_REQUIREMENT		NUMBER(22, 8)
FSM		NUMBER(22, 3)
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)

SOIL-datasets

content
5.1 SOIL_HORIZONS
5.2 SOIL_INITIAL_WATER
5.3 SOIL_SMU
5.4 SOIL_STU

SOIL_HORIZONS

Table.

Structure

Attribute	Constraint	Type
IDHORIZON	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(30)
IDSOIL_SOURCE	NOT NULL	NUMBER(22, 12)
HORIZON	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
ORIGINAL_LEVEL		NUMBER(22, 1)
SOIL_MOISTURE_CONTENT_WP		NUMBER(22)
SOIL_MOISTURE_CONTENT_FC		NUMBER(22)
SOIL_MOISTURE_CONTENT_SAT		NUMBER(22)
DEPTH		NUMBER(22, 5)
USDA_CLASS#		NUMBER(22, 3)
USDA_CLASS		VARCHAR2(8)
GRAVEL		NUMBER(22, 3)
SAND		NUMBER(22, 3)
SILT		NUMBER(22, 3)
CLAY		NUMBER(22, 3)
BULK_DENSITY		NUMBER(22, 5)
ORGANIC_CARBON		NUMBER(22, 5)
PH_H2O		NUMBER(22, 5)
CLAY_CATION_EXCNG_CAPCTY		NUMBER(22, 3)
SOIL_CATION_EXCNG_CAPCTY		NUMBER(22, 3)
SOIL_BASE_SATURATION		NUMBER(22, 3)
TOTAL_EXCHANGEABLE_BASE		NUMBER(22, 5)
CALCIUM_CARBONATE		NUMBER(22, 5)
CALCIUM_SULPHATE		NUMBER(22, 5)
EXCHANGEABLE_SODIUM		NUMBER(22, 3)
ELECTRICAL_CONDUCTIVITY		NUMBER(22, 5)

SOIL_INITIAL_WATER

Table.

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	NOT NULL	NUMBER(22, 12)
IDGRID	NOT NULL	NUMBER(22, 12)
IDSTU	NOT NULL	NUMBER(22, 12)
YEAR	NOT NULL	NUMBER(22, 4)
INITIAL_DEPTH_GROUND_WATER		NUMBER(22, 4)
DRAINAGE_DEPTH		NUMBER(22, 3)
ROOTING_DEPTH_POTENTIAL_WATER		NUMBER(22, 3)
POTENTIAL_WATER_STARTDATE		DATE

SOIL_SMU

Table.

Structure

Attribute	Constraint	Type
IDSMU	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(30)
IDSOIL_SOURCE	NOT NULL	NUMBER(22, 12)

SOIL_STU

Table.

Structure

Attribute	Constraint	Type
IDSTU	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(30)
IDSOIL_SOURCE	NOT NULL	NUMBER(22, 12)
STU	NOT NULL	VARCHAR2(30)
DESCRIPTOR	NOT NULL	VARCHAR2(255)
SOIL_WRB		VARCHAR2(8)
SOIL_WRB_CL		VARCHAR2(1)
SOIL_FAO90		VARCHAR2(8)
SOIL_FAO90_CL		VARCHAR2(1)
SOIL_FAO85		VARCHAR2(8)
SOIL_FAO85_CL		VARCHAR2(1)
SLOPE		VARCHAR2(1)
TEXTURE		VARCHAR2(1)
PHASE		VARCHAR2(2)
LAYERS		NUMBER(22, 1)
CALCULATED_ROOTING_DEPTH		NUMBER(22, 5)
DRAINAGE		NUMBER(22, 1)
LIMITATION_TO_AGRIC_USE1		NUMBER(22, 2)
LIMITATION_TO_AGRIC_USE2		NUMBER(22, 2)
OBSTACLE_TO_ROOTS		NUMBER(22, 1)
IMPERMEABLE_DEPTH_LAYER		NUMBER(22, 1)
SOIL_WATER_REGIME		NUMBER(22, 1)
DEPTH_TO_BEDROCK		VARCHAR2(8)
SOIL_FAO74		VARCHAR2(8)
SOIL_FAO74_CL		VARCHAR2(1)

WEATHER-datasets

content
6.1 WEATHER_ERA_GRID
6.2 WEATHER_ERA_GRID_LTA
6.3 WEATHER_ERA_REGIONCOVER
6.4 WEATHER_ERA_REGIONCOVER_LTA
6.5 WEATHER_HIS_GRID
6.6 WEATHER_HIS_REGIONCOVER
6.7 WEATHER_HRES_GRID
6.8 WEATHER_HRES_REGIONCOVER
6.9 WEATHER_OBS_GRID
6.10 WEATHER_OBS_GRID_INFO
6.11 WEATHER_OBS_GRID_LTA
6.12 WEATHER_OBS_GRID_LTA_MISS
6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD
6.14 WEATHER_OBS_REGCOV_THRESHOLDS
6.15 WEATHER_OBS_REGIONCOVER
6.16 WEATHER_OBS_REGIONCOVER_LTA
6.17 WEATHER_OBS_STATION
6.18 WEATHER_OBS_STATION_AVAIL
6.19 WEATHER_OBS_STATION_CALCULATED
6.20 WEATHER_OBS_STATION_ERRAIN
6.21 WEATHER_OBS_STATION_ERRORS
6.22 WEATHER_OBS_STATION_INFO
6.23 WEATHER_OBS_STATION_LTA
6.24 WEATHER_OBS_STATION_RAW
6.25 WEATHER_OPE_GRID
6.26 WEATHER_OPE_REGIONCOVER

WEATHER_ERA_GRID

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22)

WEATHER_ERA_GRID_LTA

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
AVG_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
AVG_WINDSPEED	NOT NULL	NUMBER(22, 5)
AVG_PRECIPITATION	NOT NULL	NUMBER(22, 4)
AVG_E0	NOT NULL	NUMBER(22, 4)
AVG_ES0	NOT NULL	NUMBER(22, 4)
AVG_ET0	NOT NULL	NUMBER(22, 4)
AVG_RADIATION	NOT NULL	NUMBER(22, 6)
AVG_SNOWDEPTH		NUMBER(22, 6)
AVG_SNOWWEQ		NUMBER(22, 6)
AVG_TOTALCLOUD		NUMBER(22, 3)
MIN_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
MIN_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
MIN_WINDSPEED	NOT NULL	NUMBER(22, 5)
MIN_PRECIPITATION	NOT NULL	NUMBER(22, 4)
MIN_E0	NOT NULL	NUMBER(22, 4)
MIN_ES0	NOT NULL	NUMBER(22, 4)
MIN_ET0	NOT NULL	NUMBER(22, 4)
MIN_RADIATION	NOT NULL	NUMBER(22, 6)
MIN_SNOWDEPTH		NUMBER(22, 6)
MIN_SNOWWEQ		NUMBER(22, 6)
MIN_TOTALCLOUD		NUMBER(22, 3)
MAX_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
MAX_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
MAX_WINDSPEED	NOT NULL	NUMBER(22, 5)
MAX_PRECIPITATION	NOT NULL	NUMBER(22, 4)
MAX_E0	NOT NULL	NUMBER(22, 4)
MAX_ES0	NOT NULL	NUMBER(22, 4)
MAX_ET0	NOT NULL	NUMBER(22, 4)
MAX_RADIATION	NOT NULL	NUMBER(22, 6)
MAX_SNOWDEPTH		NUMBER(22, 6)
MAX_SNOWWEQ		NUMBER(22, 6)
MAX_TOTALCLOUD		NUMBER(22, 3)
STD_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
STD_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
STD_WINDSPEED	NOT NULL	NUMBER(22, 5)
STD_PRECIPITATION	NOT NULL	NUMBER(22, 4)
STD_E0	NOT NULL	NUMBER(22, 4)
STD_ES0	NOT NULL	NUMBER(22, 4)
STD_ET0	NOT NULL	NUMBER(22, 4)
STD_RADIATION	NOT NULL	NUMBER(22, 6)
STD_SNOWDEPTH		NUMBER(22, 6)
STD_SNOWWEQ		NUMBER(22, 6)
STD_TOTALCLOUD		NUMBER(22, 3)
NUM_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 6)
NUM_TEMPERATURE_MIN	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)

WEATHER_ERA_REGIONCOVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22)

WEATHER_ERA_REGIONCOVER_LTA

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
AVG_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
AVG_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
AVG_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
AVG_WINDSPEED	NOT NULL	NUMBER(22, 5)
AVG_PRECIPITATION	NOT NULL	NUMBER(22, 4)
AVG_E0	NOT NULL	NUMBER(22, 4)
AVG_ES0	NOT NULL	NUMBER(22, 4)
AVG_ET0	NOT NULL	NUMBER(22, 4)
AVG_RADIATION	NOT NULL	NUMBER(22, 6)
AVG_SNOWDEPTH		NUMBER(22, 6)
AVG_SNOWWEQ		NUMBER(22, 6)
AVG_TOTALCLOUD		NUMBER(22, 3)
MIN_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
MIN_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
MIN_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
MIN_WINDSPEED	NOT NULL	NUMBER(22, 5)
MIN_PRECIPITATION	NOT NULL	NUMBER(22, 4)
MIN_E0	NOT NULL	NUMBER(22, 4)
MIN_ES0	NOT NULL	NUMBER(22, 4)
MIN_ET0	NOT NULL	NUMBER(22, 4)
MIN_RADIATION	NOT NULL	NUMBER(22, 6)
MIN_SNOWDEPTH		NUMBER(22, 6)
MIN_SNOWWEQ		NUMBER(22, 6)
MIN_TOTALCLOUD		NUMBER(22, 3)
MAX_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
MAX_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
MAX_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
MAX_WINDSPEED	NOT NULL	NUMBER(22, 5)
MAX_PRECIPITATION	NOT NULL	NUMBER(22, 4)
MAX_E0	NOT NULL	NUMBER(22, 4)
MAX_ES0	NOT NULL	NUMBER(22, 4)
MAX_ET0	NOT NULL	NUMBER(22, 4)
MAX_RADIATION	NOT NULL	NUMBER(22, 6)
MAX_SNOWDEPTH		NUMBER(22, 6)
MAX_SNOWWEQ		NUMBER(22, 6)
MAX_TOTALCLOUD		NUMBER(22, 3)
STD_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
STD_TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
STD_VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
STD_WINDSPEED	NOT NULL	NUMBER(22, 5)
STD_PRECIPITATION	NOT NULL	NUMBER(22, 4)
STD_E0	NOT NULL	NUMBER(22, 4)
STD_ES0	NOT NULL	NUMBER(22, 4)
STD_ET0	NOT NULL	NUMBER(22, 4)
STD_RADIATION	NOT NULL	NUMBER(22, 6)
STD_SNOWDEPTH		NUMBER(22, 6)
STD_SNOWWEQ		NUMBER(22, 6)
STD_TOTALCLOUD		NUMBER(22)
NUM_TEMPERATURE_MAX	NOT NULL	NUMBER(22, 6)
NUM_TEMPERATURE_MIN	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)

WEATHER_HIS_GRID

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22)

WEATHER_HIS_REGIONCOVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22, 3)

WEATHER_HRES_GRID

View.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID		NUMBER(22, 12)
DAY		DATE
TEMPERATURE_MAX		NUMBER(22, 3)
TEMPERATURE_MIN		NUMBER(22, 3)
TEMPERATURE_AVG		NUMBER(22, 3)
TEMPERATURE_DEW		NUMBER(22, 3)
VAPOURPRESSURE		NUMBER(22, 4)
WINDSPEED		NUMBER(22, 5)
PRECIPITATION		NUMBER(22, 4)
E0		NUMBER(22, 4)
ES0		NUMBER(22, 4)
ET0		NUMBER(22, 4)
RADIATION		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDENSITY		VARCHAR2
TOTALCLOUD		NUMBER(22)
GEOPOTENTIAL350		VARCHAR2
GEOPOTENTIAL500		VARCHAR2
GEOPOTENTIAL800		VARCHAR2
HUMIDITY_06H		VARCHAR2
HUMIDITY_09H		VARCHAR2
HUMIDITY_12H		VARCHAR2
HUMIDITY_15H		VARCHAR2
HUMIDITY_18H		VARCHAR2

definition:

select
    idgrid
  , day
  , temperature_max
  , temperature_min
  , temperature_avg
  , temperature_dew
  , vapourpressure
  , windspeed
  , precipitation
  , e0
  , es0
  , et0
  , radiation
  , snowdepth
  , snowweq
  , null snowdensity
  , totalcloud
  , null geopotential350
  , null geopotential500
  , null geopotential800
  , null humidity_06h
  , null humidity_09h
  , null humidity_12h
  , null humidity_15h
  , null humidity_18h
from weather_era_grid
where day <= to_date('31-12-2013','dd-mm-yyyy')
union all
 select
    idgrid
  , day
  , temperature_max
  , temperature_min
  , temperature_avg
  , temperature_dew
  , vapourpressure
  , windspeed
  , precipitation
  , e0
  , es0
  , et0
  , radiation
  , snowdepth
  , snowweq
  , null snowdensity
  , totalcloud
  , null geopotential350
  , null geopotential500
  , null geopotential800
  , null humidity_06h
  , null humidity_09h
  , null humidity_12h
  , null humidity_15h
  , null humidity_18h
from weather_his_grid
where day > to_date('31-12-2013','dd-mm-yyyy')
union all
select
    idgrid
  , day + dayoffset day
  , temperature_max
  , temperature_min
  , temperature_avg
  , temperature_dew
  , vapourpressure
  , windspeed
  , precipitation
  , e0
  , es0
  , et0
  , radiation
  , snowdepth
  , snowweq
  , null snowdensity
  , totalcloud
  , null geopotential350
  , null geopotential500
  , null geopotential800
  , null humidity_06h
  , null humidity_09h
  , null humidity_12h
  , null humidity_15h
  , null humidity_18h
from weather_ope_grid
where day+dayoffset > (select max(day) from weather_his_grid)

WEATHER_HRES_REGIONCOVER

View.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID		NUMBER(22, 12)
DAY		DATE
TEMPERATURE_MAX		NUMBER(22, 3)
TEMPERATURE_MIN		NUMBER(22, 3)
TEMPERATURE_AVG		NUMBER(22, 3)
TEMPERATURE_DEW		NUMBER(22, 3)
VAPOURPRESSURE		NUMBER(22, 4)
WINDSPEED		NUMBER(22, 5)
PRECIPITATION		NUMBER(22, 4)
E0		NUMBER(22, 4)
ES0		NUMBER(22, 4)
ET0		NUMBER(22, 4)
RADIATION		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDENSITY		VARCHAR2
TOTALCLOUD		NUMBER(22)
GEOPOTENTIAL350		VARCHAR2
GEOPOTENTIAL500		VARCHAR2
GEOPOTENTIAL800		VARCHAR2
HUMIDITY_06H		VARCHAR2
HUMIDITY_09H		VARCHAR2
HUMIDITY_12H		VARCHAR2
HUMIDITY_15H		VARCHAR2
HUMIDITY_18H		VARCHAR2

definition:

select
    idgrid
  , day
  , temperature_max
  , temperature_min
  , temperature_avg
  , temperature_dew
  , vapourpressure
  , windspeed
  , precipitation
  , e0
  , es0
  , et0
  , radiation
  , snowdepth
  , snowweq
  , null snowdensity
  , totalcloud
  , null geopotential350
  , null geopotential500
  , null geopotential800
  , null humidity_06h
  , null humidity_09h
  , null humidity_12h
  , null humidity_15h
  , null humidity_18h
from weather_his_grid
union all
select
    idgrid
  , day + dayoffset day
  , temperature_max
  , temperature_min
  , temperature_avg
  , temperature_dew
  , vapourpressure
  , windspeed
  , precipitation
  , e0
  , es0
  , et0
  , radiation
  , snowdepth
  , snowweq
  , null snowdensity
  , totalcloud
  , null geopotential350
  , null geopotential500
  , null geopotential800
  , null humidity_06h
  , null humidity_09h
  , null humidity_12h
  , null humidity_15h
  , null humidity_18h
from weather_ope_grid
where idmember = 0
and day+dayoffset > (select max(day) from weather_his_grid)

WEATHER_OBS_GRID

Table.

Description: interpolated weather data per grid per day
Use: output for level 1, input for level 2
Type: Permanent table

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)	°C	maximum air temperature
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)	°C	minimum air temperature
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)	°C	average air temperature
HUMIDITY_06H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)	m.s-1	mean daily vapour pressure
WINDSPEED	NOT NULL	NUMBER(22, 5)	hPa	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

WEATHER_OBS_GRID_INFO

Table.

Description:
Use:
Type: Permanent table

Structure

Attribute	Constraint	Type	Unit
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-
TEMPERATURE_GROUP_SOURCE	NOT NULL	VARCHAR2(10)
TEMPERATURE_STATION_1	NOT NULL	NUMBER(22, 7)
TEMPERATURE_STATION_2		NUMBER(22, 7)
TEMPERATURE_STATION_3		NUMBER(22, 7)
TEMPERATURE_STATION_4		NUMBER(22, 7)
TEMPERATURE_SCORE	NOT NULL	NUMBER(22, 6)
PRECIPITATION_SOURCE	NOT NULL	VARCHAR2(10)
PRECIPITATION_STATION	NOT NULL	NUMBER(22, 7)
PRECIPITATION_SCORE	NOT NULL	NUMBER(22, 6)
SNOWDEPTH_SOURCE		VARCHAR2(10)
SNOW_STATION		NUMBER(22, 7)
SNOW_SCORE		NUMBER(22, 6)
HUMIDITY_GROUP_SOURCE		VARCHAR2(10)
HUMIDITY_STATION		NUMBER(22, 7)
HUMIDITY_SCORE		NUMBER(22, 6)
REST_GROUP_SOURCE	NOT NULL	VARCHAR2(10)
REST_STATION_1	NOT NULL	NUMBER(22, 7)
REST_STATION_2		NUMBER(22, 7)
REST_STATION_3		NUMBER(22, 7)
REST_STATION_4		NUMBER(22, 7)
REST_SCORE	NOT NULL	NUMBER(22, 6)

WEATHER_OBS_GRID_LTA

Table.

Description: long term average interpolated weather data per grid cell per day
Use: Monitoring extreme weather events
Type: Permanent table

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
TEMPERATURE_MIN		NUMBER(22, 3)	°C	average maximum air temperature
TEMPERATURE_MAX		NUMBER(22, 3)	°C	average minimum air temperature
TEMPERATURE_AVG		NUMBER(22, 3)	°C	average mean air temperature
PRECIPITATION		NUMBER(22, 4)	mm.d-1	average daily rainfall
RADIATION		NUMBER(22, 7)	KJ.m-2.d-1	average daily radiation at surface
VAPOURPRESSURE		NUMBER(22, 4)	hPa	average mean daily vapour pressure
WINDSPEED		NUMBER(22, 5)	m.s-1	average mean daily wind speed at 10 m height
E0		NUMBER(22, 4)	mm.d-1	average daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	average daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	average daily transpiration of crop canopy
SNOWDEPTH		NUMBER(22, 6)	cm	average daily mean snow depth
MIN_TEMPERATURE_MIN		NUMBER(22, 3)	°C	minimum minimum air temperature
MIN_TEMPERATURE_MAX		NUMBER(22, 3)	°C	minimum maximum air temperature
MIN_TEMPERATURE_AVG		NUMBER(22, 3)	°C	minimum mean air temperature
MIN_PRECIPITATION		NUMBER(22, 4)	mm.d-1	minimum daily rainfall
MIN_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	minimum daily radiation at surface
MIN_VAPOURPRESSURE		NUMBER(22, 4)	hPa	minimum mean daily vapour pressure
MIN_WINDSPEED		NUMBER(22, 5)	m.s-1	minimum mean daily wind speed at 10 m height
MIN_E0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of water surface
MIN_ES0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of wet bare soil
MIN_ET0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of crop canopy
MIN_SNOWDEPTH		NUMBER(22, 6)	cm	minimum daily mean snow depth
MAX_TEMPERATURE_MIN		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_MAX		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_AVG		NUMBER(22, 3)	°C	maximum mean air temperature
MAX_PRECIPITATION		NUMBER(22, 4)	mm.d-1	maximum daily rainfall
MAX_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	maximum daily radiation at surface
MAX_VAPOURPRESSURE		NUMBER(22, 4)	hPa	maximum mean daily vapour pressure
MAX_WINDSPEED		NUMBER(22, 5)	m.s-1	maximum mean daily wind speed at 10 m height
MAX_E0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of water surface
MAX_ES0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of wet bare soil
MAX_ET0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of crop canopy
MAX_SNOWDEPTH		NUMBER(22, 6)
STD_TEMPERATURE_MIN		NUMBER(22, 4)	°C	standard deviation of minimum air temperature
STD_TEMPERATURE_MAX		NUMBER(22, 4)	°C	standard deviation of maximum air temperature
STD_TEMPERATURE_AVG		NUMBER(22, 4)	°C	standard deviation of mean air temperature
STD_PRECIPITATION		NUMBER(22, 5)	mm.d-1	standard deviation of daily rainfall
STD_RADIATION		NUMBER(22, 8)	KJ.m-2.d-1	standard deviation of daily radiation at surface
STD_VAPOURPRESSURE		NUMBER(22, 6)	hPa	standard deviation of mean daily vapour pressure
STD_WINDSPEED		NUMBER(22, 6)	m.s-1	standard deviation of mean daily wind speed at 10 m height
STD_E0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of water surface
STD_ES0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of wet bare soil
STD_ET0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of crop canopy
STD_SNOWDEPTH		NUMBER(22, 7)	cm	standard deviation of daily mean snow depth
NUM_TEMPERATURE_MIN		NUMBER(22, 6)	-	count of air temperature
NUM_TEMPERATURE_MAX		NUMBER(22, 6)	-	count of maximum air temperature
NUM_TEMPERATURE_AVG		NUMBER(22, 6)	-	count of mean air temperature
NUM_PRECIPITATION		NUMBER(22, 6)	-	count of daily rainfall
NUM_RADIATION		NUMBER(22, 6)	-	count of daily radiation at surface
NUM_VAPOURPRESSURE		NUMBER(22, 6)	-	count of mean daily vapour pressure
NUM_WINDSPEED		NUMBER(22, 6)	-	count of mean daily wind speed at 10 m height
NUM_E0		NUMBER(22, 6)	-	count of daily transpiration of water surface
NUM_ES0		NUMBER(22, 6)	-	count of daily transpiration of wet bare soil
NUM_ET0		NUMBER(22, 6)	-	count of daily transpiration of crop canopy
NUM_SNOWDEPTH		NUMBER(22, 6)	-	count of daily mean snow depth

* In script changed to 4,2. Not yet installed.

WEATHER_OBS_GRID_LTA_MISS

Table.

Description: long term average number of grid cells per country.
Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
Type: permanent table
Remarks: filled with procedure lta_missing_grid_weather.sql

Structure

Attribute	Constraint	Type	Unit	Comment
IDREGION	NOT NULL	VARCHAR2(20)
TOTAL_GRIDS		NUMBER(22, 10)	-	total number of grid cells
TOTAL_GRIDS_CC		NUMBER(22, 10)	-	total number of grid cells with at least 1 crop calendar
MISSING_GRIDS		NUMBER(22, 10)
MISSING_GRIDS_CC		NUMBER(22, 10)	-	total number of missing grid cells with at least 1 crop calendar
MISSING_GRIDS_ORIGINAL		NUMBER(22, 10)	-	total number of missing grid cells

* When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL.

WEATHER_OBS_REGCOV_LTA_THRSHLD

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_REGCOV_THRESHOLDS

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	NUMBER(22, 10)
IDCOVER	NOT NULL	NUMBER(22, 12)
IDTHRESHOLD	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
VALUE	NOT NULL	NUMBER(22)

WEATHER_OBS_REGIONCOVER

Table.

Description: interpolated weather data per grid per administrative region
Use: input for monitoring extreme weather events
Type: Permanent table

Structure

Attribute	Constraint	Type	Unit	Comment
IDCOVER	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)	°C	maximum daily air temperature
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)	°C	minimum daily air temperature
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)	°C	average daily air temperature
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)	hPa	mean daily vapour pressure
WINDSPEED	NOT NULL	NUMBER(22, 5)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22, 4)	mm.d-1	daily rainfall
E0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22, 6)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

WEATHER_OBS_REGIONCOVER_LTA

Table.

Description: long term average interpolated weather data per administrative region per day
Use: Monitoring extreme weather events
Type: Permanent table

Structure

Attribute	Constraint	Type	Unit	Comment
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
TEMPERATURE_MIN		NUMBER(22, 3)	°C	average maximum air temperature
TEMPERATURE_MAX		NUMBER(22, 3)	°C	average minimum air temperature
TEMPERATURE_AVG		NUMBER(22, 3)	°C	average mean air temperature
PRECIPITATION		NUMBER(22, 4)	mm.d-1	average daily rainfall
RADIATION		NUMBER(22, 7)	KJ.m-2.d-1	average daily radiation at surface
VAPOURPRESSURE		NUMBER(22, 4)	hPa	average mean daily vapour pressure
WINDSPEED		NUMBER(22, 5)	m.s-1	average mean daily wind speed at 10 m height
E0		NUMBER(22, 4)	mm.d-1	average daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	average daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	average daily transpiration of crop canopy
SNOWDEPTH		NUMBER(22, 6)	cm	average daily mean snow depth
MIN_TEMPERATURE_MIN		NUMBER(22, 3)	°C	minimum minimum air temperature
MIN_TEMPERATURE_MAX		NUMBER(22, 3)	°C	minimum maximum air temperature
MIN_TEMPERATURE_AVG		NUMBER(22, 3)	°C	minimum mean air temperature
MIN_PRECIPITATION		NUMBER(22, 4)	mm.d-1	minimum daily rainfall
MIN_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	minimum daily radiation at surface
MIN_VAPOURPRESSURE		NUMBER(22, 4)	hPa	minimum mean daily vapour pressure
MIN_WINDSPEED		NUMBER(22, 5)	m.s-1	minimum mean daily wind speed at 10 m height
MIN_E0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of water surface
MIN_ES0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of wet bare soil
MIN_ET0		NUMBER(22, 4)	mm.d-1	minimum daily transpiration of crop canopy
MIN_SNOWDEPTH		NUMBER(22, 6)	cm	minimum daily mean snow depth
MAX_TEMPERATURE_MIN		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_MAX		NUMBER(22, 3)	°C	maximum maximum air temperature
MAX_TEMPERATURE_AVG		NUMBER(22, 3)	°C	maximum mean air temperature
MAX_PRECIPITATION		NUMBER(22, 4)	mm.d-1	maximum daily rainfall
MAX_RADIATION		NUMBER(22, 6)	KJ.m-2.d-1	maximum daily radiation at surface
MAX_VAPOURPRESSURE		NUMBER(22, 4)	hPa	maximum mean daily vapour pressure
MAX_WINDSPEED		NUMBER(22, 5)	m.s-1	maximum mean daily wind speed at 10 m height
MAX_E0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of water surface
MAX_ES0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of wet bare soil
MAX_ET0		NUMBER(22, 4)	mm.d-1	maximum daily transpiration of crop canopy
MAX_SNOWDEPTH		NUMBER(22, 6)
STD_TEMPERATURE_MIN		NUMBER(22, 4)	°C	standard deviation of minimum air temperature
STD_TEMPERATURE_MAX		NUMBER(22, 4)	°C	standard deviation of maximum air temperature
STD_TEMPERATURE_AVG		NUMBER(22, 4)	°C	standard deviation of mean air temperature
STD_PRECIPITATION		NUMBER(22, 5)	mm.d-1	standard deviation of daily rainfall
STD_RADIATION		NUMBER(22, 8)	KJ.m-2.d-1	standard deviation of daily radiation at surface
STD_VAPOURPRESSURE		NUMBER(22, 6)	hPa	standard deviation of mean daily vapour pressure
STD_WINDSPEED		NUMBER(22, 6)	m.s-1	standard deviation of mean daily wind speed at 10 m height
STD_E0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of water surface
STD_ES0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of wet bare soil
STD_ET0		NUMBER(22, 4)	mm.d-1	standard deviation of daily transpiration of crop canopy
STD_SNOWDEPTH		NUMBER(22, 7)	cm	standard deviation of daily mean snow depth
NUM_TEMPERATURE_MIN		NUMBER(22, 6)	-	count of air temperature
NUM_TEMPERATURE_MAX		NUMBER(22, 6)	-	count of maximum air temperature
NUM_TEMPERATURE_AVG		NUMBER(22, 6)	-	count of mean air temperature
NUM_PRECIPITATION		NUMBER(22, 6)	-	count of daily rainfall
NUM_RADIATION		NUMBER(22, 6)	-	count of daily radiation at surface
NUM_VAPOURPRESSURE		NUMBER(22, 6)	-	count of mean daily vapour pressure
NUM_WINDSPEED		NUMBER(22, 6)	-	count of mean daily wind speed at 10 m height
NUM_E0		NUMBER(22, 6)	-	count of daily transpiration of water surface
NUM_ES0		NUMBER(22, 6)	-	count of daily transpiration of wet bare soil
NUM_ET0		NUMBER(22, 6)	-	count of daily transpiration of crop canopy
NUM_SNOWDEPTH		NUMBER(22, 6)	-	count of daily mean snow depth

WEATHER_OBS_STATION

Table.

Description: contains the station based daily meteorological data
Use: input for level 1
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTATION	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-	calendar day
CLOUD_TOTAL_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_LOW_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_MIDDLE_24H		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_HIGH_24H		NUMBER(22, 6)	oktas	not used in CGMS
SUNSHINE		NUMBER(22, 6)	h	daily sunshine duration (2
RADIATION		NUMBER(22, 11)	KJ.m-2.d-1	daily global radiation at surface (1
TEMPERATURE_MIN		NUMBER(22, 6)	°C	minimum air temperature (3,4
TEMPERATURE_MAX		NUMBER(22, 6)	°C	maximum air temperature (3,4
VAPOURPRESSURE		NUMBER(22, 6)	hPa	daily mean vapour pressure
WINDSPEED		NUMBER(22, 6)	m.s-1	not used in CGMS
WINDSPEED_10M		NUMBER(22, 6)	m.s-1	daily mean wind speed at 10 m height
PRECIPITATION		NUMBER(22, 6)	mm.d-1	daily rainfall
TEMPERATURE_06H		NUMBER(22, 6)	°C	air temperature 6 UTC
HUMIDITY_06H		NUMBER(22, 6)	%	humidity 6 UTC
TEMPERATURE_09H		NUMBER(22, 6)	°C	air temperature 9 UTC
HUMIDITY_09H		NUMBER(22, 6)	%	humidity 9 UTC
TEMPERATURE_12H		NUMBER(22, 6)	°C	air temperature 12 UTC
HUMIDITY_12H		NUMBER(22, 6)	%	humidity 12 UTC
TEMPERATURE_15H		NUMBER(22, 6)	°C	air temperature 15 UTC
HUMIDITY_15H		NUMBER(22, 6)	%	humidity 15 UTC
TEMPERATURE_18H		NUMBER(22, 6)	°C	air temperature 18 UTC
HUMIDITY_18H		NUMBER(22, 6)	%	humidity 18 UTC
STATE_SOIL		NUMBER(22, 6)	-	not used in CGMS
VAPOURPRESSURE_DEF		NUMBER(22, 6)	hPa	not used in CGMS
SLOPE_VP_VS_T		NUMBER(22, 6)	hPa.°C-1	not used in CGMS
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	oktas	daily mean of total cloud cover (3
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	oktas	not used in CGMS
CLOUD_SHADOW		NUMBER(22, 6)	oktas	not used in CGMS
VISIBILITY		NUMBER(22, 6)	-	not used in CGMS
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

1 this variable returns directly radiation
2 this variable can be used to derive radiation via the angstrom formula
3 these variables can be used to derive radiation via the Supit formula
4 these variables can be used to derive radiation via the Hargreaves formula

WEATHER_OBS_STATION_AVAIL

Table.

Description: available weather stations for interpolation per station and per year.
Use: output of the weather data availability calculation, used by the grid weather interpolation
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
YEAR	NOT NULL	NUMBER(22, 4)	-	historic year
IDSTATION	NOT NULL	NUMBER(22, 12)
AVAILABILITY_TYPE	NOT NULL	VARCHAR2(30)	-	class e.g. temperature

WEATHER_OBS_STATION_CALCULATED

Table.

Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
Use: output table for additional weather calculation, input for grid weather
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTATION	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-	calendar day
E0		NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	daily transpiration of crop canopy
RADIATION		NUMBER(22, 9)	KJ.m-2.d-1	daily radiation at surface

WEATHER_OBS_STATION_ERRAIN

Table.

Description: contains deleted wrongly rain records of the station based daily meteorological data
Use: archive reasons
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
IDSTATION	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-
PRECIPITATION		NUMBER(22, 6)	-
REASON		VARCHAR2(4000)	-

WEATHER_OBS_STATION_ERRORS

Table.

Description: contains deleted wrongly weather records of the station based daily meteorological data
Use: archive reasons
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
IDSTATION	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-
CLOUD_TOTAL_24H		NUMBER(22, 6)	-
CLOUD_LOW_24H		NUMBER(22, 6)	-
CLOUD_MIDDLE_24H		NUMBER(22, 6)	-
CLOUD_HIGH_24H		NUMBER(22, 6)	-
SUNSHINE		NUMBER(22, 6)	-
RADIATION		NUMBER(22, 11)	-
TEMPERATURE_MIN		NUMBER(22, 6)	-
TEMPERATURE_MAX		NUMBER(22, 6)	-
VAPOURPRESSURE		NUMBER(22, 6)	-
WINDSPEED		NUMBER(22, 6)	-
WINDSPEED_10M		NUMBER(22, 6)	-
PRECIPITATION		NUMBER(22, 6)	-
TEMPERATURE_06H		NUMBER(22, 6)	-
HUMIDITY_06H		NUMBER(22, 6)	-
TEMPERATURE_09H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
TEMPERATURE_12H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
TEMPERATURE_15H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
TEMPERATURE_18H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)	-
STATE_SOIL		NUMBER(22, 6)	-
VAPOURPRESSURE_DEF		NUMBER(22, 6)	-
SLOPE_VP_VS_T		NUMBER(22, 6)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	-
CLOUD_SHADOW		NUMBER(22, 6)	-
VISIBILITY		NUMBER(22, 6)	-
SNOWDEPTH		NUMBER(22, 6)	-

WEATHER_OBS_STATION_INFO

Table.

Description: table for storing specific metadata on daily weather data (flags)
Use: meta data
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTATION	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE	-	calendar day
CLOUD_TOTAL_24H		NUMBER(22, 2)	-
CLOUD_LOW_24H		NUMBER(22, 2)	-
CLOUD_MIDDLE_24H		NUMBER(22, 2)	-
CLOUD_HIGH_24H		NUMBER(22, 2)	-
SUNSHINE		NUMBER(22, 2)	-
RADIATION		NUMBER(22, 2)	-
TEMPERATURE_MIN		NUMBER(22, 2)	-
TEMPERATURE_MAX		NUMBER(22, 2)	-
VAPOURPRESSURE		NUMBER(22, 2)	-
WINDSPEED		NUMBER(22, 2)	-
WINDSPEED_10M		NUMBER(22, 2)	-
PRECIPITATION		NUMBER(22, 2)	-
TEMPERATURE_06H		NUMBER(22, 2)	-
HUMIDITY_06H		NUMBER(22, 2)	-
TEMPERATURE_09H		NUMBER(22, 2)	-
HUMIDITY_09H		NUMBER(22, 2)	-
TEMPERATURE_12H		NUMBER(22, 2)	-
HUMIDITY_12H		NUMBER(22, 2)	-
TEMPERATURE_15H		NUMBER(22, 2)	-
HUMIDITY_15H		NUMBER(22, 2)	-
TEMPERATURE_18H		NUMBER(22, 2)	-
HUMIDITY_18H		NUMBER(22, 2)	-
STATE_SOIL		NUMBER(22, 2)	-
VAPOURPRESSURE_DEF		NUMBER(22, 2)	-
SLOPE_VP_VS_T		NUMBER(22, 2)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 2)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 2)	-
CLOUD_SHADOW		NUMBER(22, 2)	-
VISIBILITY		NUMBER(22, 2)	-
SNOWDEPTH		NUMBER(22, 2)	-

In case of precipitation:

0=real observation 06-06 UTC
1=MOS estimate 06-06 UTC
2=real observation 00-00 UTC
3=real observation 03-03 UTC
4=real observation 12-12 UTC
5=real observation 18-18 UTC

WEATHER_OBS_STATION_LTA

Table.

Description: contains the long term average weather data per station per day
Use: substitute data in case of missing data during level 1 processing
Type: permanent table
Remarks: filled by software tool ReferenceWeather

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTATION	NOT NULL	NUMBER(22, 12)
MONTH	NOT NULL	NUMBER(22, 2)
DAYMONTH	NOT NULL	NUMBER(22, 2)
TEMPERATURE_MAX		NUMBER(22, 6)	°C	maximum air temperature
TEMPERATURE_MIN		NUMBER(22, 6)	°C	minimum air temperature
VAPOURPRESSURE		NUMBER(22, 6)	hPa	mean daily vapour pressure
WINDSPEED		NUMBER(22, 6)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION		NUMBER(22, 6)	mm.d-1	daily rainfall
E0		NUMBER(22, 4)	mm.d-1	daily transpiration of water surface
ES0		NUMBER(22, 4)	mm.d-1	daily transpiration of wet bare soil
ET0		NUMBER(22, 4)	mm.d-1	daily transpiration of closed crop canopy
RADIATION		NUMBER(22, 9)	KJ.m-2.d-1	daily radiation at surface
SNOWDEPTH		NUMBER(22, 6)	cm	daily mean snow depth

WEATHER_OBS_STATION_RAW

Table.

Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
Use: input level 1
Type: permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
IDSTATION	NOT NULL	NUMBER(22, 12)
DOY	NOT NULL	NUMBER(22, 3)
DAY		DATE	-
CLOUD_TOTAL_24H		NUMBER(22, 6)	-
CLOUD_LOW_24H		NUMBER(22, 6)	-
CLOUD_MIDDLE_24H		NUMBER(22, 6)	-
CLOUD_HIGH_24H		NUMBER(22, 6)	-
SUNSHINE		NUMBER(22, 6)	-
RADIATION		NUMBER(22, 11)	-
TEMPERATURE_MIN		NUMBER(22, 6)	-
TEMPERATURE_MAX		NUMBER(22, 6)	-
VAPOURPRESSURE		NUMBER(22, 6)	-
WINDSPEED		NUMBER(22, 6)	-
WINDSPEED_10M		NUMBER(22, 6)	-
PRECIPITATION		NUMBER(22, 6)	-
TEMPERATURE_06H		NUMBER(22, 6)	-
HUMIDITY_06H		NUMBER(22, 6)	-
TEMPERATURE_09H		NUMBER(22, 6)	-
HUMIDITY_09H		NUMBER(22, 6)	-
TEMPERATURE_12H		NUMBER(22, 6)	-
HUMIDITY_12H		NUMBER(22, 6)	-
TEMPERATURE_15H		NUMBER(22, 6)	-
HUMIDITY_15H		NUMBER(22, 6)	-
TEMPERATURE_18H		NUMBER(22, 6)	-
HUMIDITY_18H		NUMBER(22, 6)	-
STATE_SOIL		NUMBER(22, 6)	-
VAPOURPRESSURE_DEF		NUMBER(22, 6)	-
SLOPE_VP_VS_T		NUMBER(22, 6)	-
CLOUD_TOTAL_DAYTIME		NUMBER(22, 6)	-
CLOUD_LOW_DAYTIME		NUMBER(22, 6)	-
CLOUD_SHADOW		NUMBER(22, 6)	-
VISIBILITY		NUMBER(22, 6)	-
SNOWDEPTH		NUMBER(22, 6)	-
CLOUD_TOTAL_24H_INFO		NUMBER(22, 2)	-
CLOUD_LOW_24H_INFO		NUMBER(22, 2)	-
CLOUD_MIDDLE_24H_INFO		NUMBER(22, 2)	-
CLOUD_HIGH_24H_INFO		NUMBER(22, 2)	-
SUNSHINE_INFO		NUMBER(22, 2)	-
RADIATION_INFO		NUMBER(22, 2)	-
TEMPERATURE_MIN_INFO		NUMBER(22, 2)	-
TEMPERATURE_MAX_INFO		NUMBER(22, 2)	-
VAPOURPRESSURE_INFO		NUMBER(22, 2)	-
WINDSPEED_INFO		NUMBER(22, 2)	-
WINDSPEED_10M_INFO		NUMBER(22, 2)	-
PRECIPITATION_INFO		NUMBER(22, 2)	-
TEMPERATURE_06H_INFO		NUMBER(22, 2)	-
HUMIDITY_06H_INFO		NUMBER(22, 2)	-
TEMPERATURE_09H_INFO		NUMBER(22, 2)	-
HUMIDITY_09H_INFO		NUMBER(22, 2)	-
TEMPERATURE_12H_INFO		NUMBER(22, 2)	-
HUMIDITY_12H_INFO		NUMBER(22, 2)	-
TEMPERATURE_15H_INFO		NUMBER(22, 2)	-
HUMIDITY_15H_INFO		NUMBER(22, 2)	-
TEMPERATURE_18H_INFO		NUMBER(22, 2)	-
HUMIDITY_18H_INFO		NUMBER(22, 2)	-
STATE_SOIL_INFO		NUMBER(22, 2)	-
VAPOURPRESSURE_DEF_INFO		NUMBER(22, 2)	-
SLOPE_VP_VS_T_INFO		NUMBER(22, 2)	-
CLOUD_TOTAL_DAYTIME_INFO		NUMBER(22, 2)	-
CLOUD_LOW_DAYTIME_INFO		NUMBER(22, 2)	-
CLOUD_SHADOW_INFO		NUMBER(22, 2)	-
VISIBILITY_INFO		NUMBER(22, 2)	-
SNOWDEPTH_INFO		NUMBER(22, 2)	-

WEATHER_OPE_GRID

Table.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
DAYOFFSET	NOT NULL	NUMBER(22, 2)
IDMEMBER	NOT NULL	NUMBER(22, 2)
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22)

WEATHER_OPE_REGIONCOVER

Table.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDCOVER	NOT NULL	NUMBER(22, 12)
DAY	NOT NULL	DATE
DAYOFFSET	NOT NULL	NUMBER(22, 2)
IDMEMBER	NOT NULL	NUMBER(22, 2)
TEMPERATURE_MAX	NOT NULL	NUMBER(22, 3)
TEMPERATURE_MIN	NOT NULL	NUMBER(22, 3)
TEMPERATURE_AVG	NOT NULL	NUMBER(22, 3)
TEMPERATURE_DEW	NOT NULL	NUMBER(22, 3)
VAPOURPRESSURE	NOT NULL	NUMBER(22, 4)
WINDSPEED	NOT NULL	NUMBER(22, 5)
PRECIPITATION	NOT NULL	NUMBER(22, 4)
E0	NOT NULL	NUMBER(22, 4)
ES0	NOT NULL	NUMBER(22, 4)
ET0	NOT NULL	NUMBER(22, 4)
RADIATION	NOT NULL	NUMBER(22, 6)
SNOWWEQ		NUMBER(22, 6)
SNOWDEPTH		NUMBER(22, 6)
TOTALCLOUD		NUMBER(22, 3)

other datasets

content
7.1 GRIDS
7.2 REGIONS
7.3 STATIONS
7.4 SYSTABLES
7.5 TASKS
7.6 WOG
7.7 WOSC
7.8 CGMS_SYSLOG
7.9 DATES_75_15
7.10 HRES_YEARS
7.11 INTERPOLATION_PARAMETERS
7.12 STAT_REGION_AREAS

CGMS_SYSLOG

Table.

Description: logging of run options.
Use: output table containing information on the run executed
Type: Permanent table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
RUNID	NOT NULL	NUMBER(22)	-	identification number of run
DBUSER		VARCHAR2(20)	-	username
RUNDATE		DATE	-	run date
RUNINFO		VARCHAR2(50)	-	codes explaining kind of run executed
CAMPAIGN_START		VARCHAR2(20)	-	start month of campaign (agricultural season
WEATHER_START		DATE	-	start date of weather calculations
WEATHER_END		DATE	-	end date of weather calculations
START_YEAR	NOT NULL	NUMBER(22)	-	year for which simulation is executed
CAMPAIGN_YEARS	NOT NULL	NUMBER(22)	-	number of campaign years the model is run for
RUNSTATUS		VARCHAR2(20)	-	final status of run
WEATHER_DATA_SOURCE		VARCHAR2(20)	-	source type used for simulation crop yield
INITIALISATION_WATER_BALANCE	NOT NULL	NUMBER(22)	-	code indication type of water balance initialisations
GROUND_WATER_BALANCE	NOT NULL	NUMBER(22)	-	code indication usage of ground water balance

DATES_75_15

Table.

Description: synonym to oracle package
Use: view on DATE_GENERATOR package
Type: synonym on forall.dates_75_15
Remarks: none

Structure

Attribute	Constraint	Type	Unit
DAY	NOT NULL	DATE
DAYNO_WK	NOT NULL	NUMBER(22, 1)
WEEK	NOT NULL	NUMBER(22, 2)
DAYNO_MON	NOT NULL	NUMBER(22, 2)
MONTH	NOT NULL	NUMBER(22, 2)
DAYNO_YR	NOT NULL	NUMBER(22, 3)
YEAR	NOT NULL	NUMBER(22, 4)
DAYNO_DEC	NOT NULL	NUMBER(22, 2)
DECADE	NOT NULL	NUMBER(22, 2)
DEC_MONTH	NOT NULL	VARCHAR2(10)
JULIAN	NOT NULL	NUMBER(22)	-

GRIDS

View.

Structure

Attribute	Constraint	Type
IDGRID	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(20)
LATITUDE	NOT NULL	NUMBER(22)
LONGITUDE	NOT NULL	NUMBER(22)
ALTITUDE	NOT NULL	NUMBER(22)
ALTITUDE_16		NUMBER(22)
ALTITUDE_25		NUMBER(22)
HAS_LAND	NOT NULL	VARCHAR2(1)
DISTANCE_FROM_COAST		NUMBER(22)
CLIMATE_BARRIER		NUMBER(22)
RESOLUTION	NOT NULL	NUMBER(22)
UNIT	NOT NULL	VARCHAR2(20)

definition:

select
    g.idgrid
  , g.idoriginal_code
  , g.latitude
  , g.longitude
  , g.altitude
  , g.altitude_16
  , g.altitude_25
  , g.has_land
  , g.distance_from_coast
  , g.climate_barrier
  , g.resolution
  , g.unit
from global_grids g
where grid_source = 'CHN'
order by idgrid

HRES_YEARS

View.

Structure

Attribute	Constraint	Type	Unit	Comment
YEAR		NUMBER(22)

definition:

select
    1988 + level year
from dual
connect by level <= (to_number (to_char (sysdate, 'yyyy')) - 1988)

INTERPOLATION_PARAMETERS

Table.

Structure

Attribute	Constraint	Type
IDINTERPOLATION_PARAMETER	NOT NULL	NUMBER(22, 12)
NAME	NOT NULL	VARCHAR2(30)
VALUE	NOT NULL	VARCHAR2(30)

REGIONS

View.

Structure

Attribute	Constraint	Type
IDREGION	NOT NULL	VARCHAR2(20)
IDFATHER		NUMBER(22, 12)
REGION	NOT NULL	VARCHAR2(20)
GLOBAL_NAME	NOT NULL	VARCHAR2(255)
LOCAL_NAME		VARCHAR2(255)
REGION_LEVEL	NOT NULL	NUMBER(22)
CONTINENT	NOT NULL	VARCHAR2(20)
POPULATION		NUMBER(22)
IDREGION_ELEMENT	NOT NULL	NUMBER(22, 12)
IDORIGINAL_CODE	NOT NULL	VARCHAR2(20)

definition:

select
    lrc.idregion
  , idfather
  , region
  , global_name
  , local_name
  , region_level
  , continent
  , population
  , idregion_element
  , idoriginal_code
from
    global_region_elements re
  , link_region_cover      lrc
where region_source = 'GAUL'
and lrc.idregion    = re.idregion
and lrc.idcover     = 1000

STATIONS

View.

Structure

Attribute	Constraint	Type
IDSTATION	NOT NULL	NUMBER(22, 12)
STATION	NOT NULL	VARCHAR2(32)
ORGANIZATION	NOT NULL	VARCHAR2(32)
IDWMO		NUMBER(22, 12)
WMO		VARCHAR2(32)
LATITUDE	NOT NULL	NUMBER(22, 7)
LONGITUDE	NOT NULL	NUMBER(22, 8)
Y_COORDINATE	NOT NULL	NUMBER(22, 13)
X_COORDINATE	NOT NULL	NUMBER(22, 13)
ALTITUDE	NOT NULL	NUMBER(22, 5)
IDCLIMATE_ZONE	NOT NULL	NUMBER(22, 12)
COUNTRY	NOT NULL	VARCHAR2(26)
DISTANCE_TO_COAST	NOT NULL	NUMBER(22, 4)
ANGSTROM_A	NOT NULL	NUMBER(22, 18)
ANGSTROM_B	NOT NULL	NUMBER(22, 18)
SUPIT_A	NOT NULL	NUMBER(22, 18)
SUPIT_B	NOT NULL	NUMBER(22, 18)
SUPIT_C	NOT NULL	NUMBER(22, 18)
HARGREAVES_A	NOT NULL	NUMBER(22, 18)
HARGREAVES_B	NOT NULL	NUMBER(22, 18)
RELIABLE_STATIONS	NOT NULL	NUMBER(22, 1)
ACTIVE_STATIONS	NOT NULL	NUMBER(22, 1)
AVAIL_PRECIPITATION_THRESHOLD	NOT NULL	NUMBER(22, 4)
AVAIL_SNOWDEPTH_THRESHOLD	NOT NULL	NUMBER(22, 4)
AVAIL_TEMPERATURE_THRESHOLD	NOT NULL	NUMBER(22, 4)
AVAIL_HUMIDITY_THRESHOLD	NOT NULL	NUMBER(22, 4)
AVAIL_REST_THRESHOLD	NOT NULL	NUMBER(22, 4)

definition:

select
       idstation
     , station
     , organization
     , idwmo
     , wmo
     , latitude
     , longitude
     , y_coordinate
     , x_coordinate
     , altitude
     , idclimate_zone
     , country
     , distance_to_coast
     , angstrom_a
     , angstrom_b
     , supit_a
     , supit_b
     , supit_c
     , hargreaves_a
     , hargreaves_b
     , reliable_stations
     , active_stations
     , avail_precipitation_threshold
     , avail_snowdepth_threshold
     , avail_temperature_threshold
     , avail_humidity_threshold
     , avail_rest_threshold
from stations@cgms14sys_assistsan

STAT_REGION_AREAS

Table.

Structure

Attribute	Constraint	Type
IDCROP	NOT NULL	NUMBER(22, 12)
IDREGION	NOT NULL	VARCHAR2(20)
YEAR	NOT NULL	NUMBER(22, 4)
IDSTATISTIC_SOURCE	NOT NULL	NUMBER(22, 12)
IDTREATMENT	NOT NULL	NUMBER(22, 12)
AREA_CALCULATED	NOT NULL	NUMBER(22)
AREA_ORIGINAL		NUMBER(22)
NOTE		VARCHAR2(255)
ELABORATION	NOT NULL	DATE

SYSTABLES

Table.

Description:
Use:
Type: permanent table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
TABLE_NAME	NOT NULL	VARCHAR2(31)	-
HIGHEST_ID	NOT NULL	NUMBER(22, 38)	-

TASKS

Table.

Description:
Use:
Type: permanent table
Remarks:

Structure

Attribute	Constraint	Type	Unit
TASK_ID	NOT NULL	NUMBER(22, 8)	-
MODEL	NOT NULL	VARCHAR2(12)	-
DAY	NOT NULL	DATE
STATUS	NOT NULL	NUMBER(22, 2)
TIMESTAMP	NOT NULL	DATE
FRACTION		NUMBER(22)
MCOMMENT		VARCHAR2(255)	-

WOG

Table.

Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
Type: Permanent table
Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	NOT NULL	NUMBER(22)
DAY	NOT NULL	DATE	-	calendar day
TEMPERATURE_MAX	NOT NULL	NUMBER(22)
TEMPERATURE_MIN	NOT NULL	NUMBER(22)
TEMPERATURE_AVG	NOT NULL	NUMBER(22)
VAPOURPRESSURE	NOT NULL	NUMBER(22)
WINDSPEED	NOT NULL	NUMBER(22)	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	NOT NULL	NUMBER(22)
E0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of water surface
ES0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of wet bare soil
ET0	NOT NULL	NUMBER(22)	mm.d-1	daily transpiration of crop canopy
RADIATION	NOT NULL	NUMBER(22)
SNOWDEPTH		NUMBER(22)
HUMIDITY_06H		NUMBER(22)
HUMIDITY_09H		NUMBER(22)
HUMIDITY_12H		NUMBER(22)
HUMIDITY_15H		NUMBER(22)
HUMIDITY_18H		NUMBER(22)

WOSC

Table.

Structure

Attribute	Constraint	Type
IDSTATION	NOT NULL	NUMBER(22)
DAY	NOT NULL	DATE
E0		NUMBER(22)
ES0		NUMBER(22)
ET0		NUMBER(22)
RADIATION		NUMBER(22)

@@ Line 1: / Line 1: @@
-__NOTOC__
+__NOTO C__
 {{TocTable|content=
 {{TocRow|#CROP-datasets|1. CROP-datasets}}

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

Revision as of 16:53, 28 January 2016

Contents

CROP-datasets

CROP_AGGREGATIONS

CROP_CALENDARS

CROP_CALENDARS_OLD

CROP_PARAMETRIZATIONS

CROP_PARAMETRIZATION_PARAMETER

CROP_REGIMES

CROP_SPATIALIZATIONS

CROP_SUITABILITY_RULES

CROP_VARIETIES

CROP_VARIETY_PARAMETERS

CROP_VARIETY_PARAMETERS_OLD

CROP_VARIETY_REGIMES

GLOBAL-datasets

GLOBAL_CATEGORIES

GLOBAL_COVERS

GLOBAL_COVER_SOURCES

GLOBAL_CROPS

GLOBAL_CROP_PARAMETERS

GLOBAL_GRIDS

GLOBAL_GRID_SOURCES

GLOBAL_LINK_COVERWINDOW_SOURCE

GLOBAL_MODELS

GLOBAL_REGIONS

GLOBAL_REGION_ELEMENTS

GLOBAL_REGION_SOURCES

GLOBAL_SOIL_SOURCES

GLOBAL_STATISTIC_SOURCES

GLOBAL_SUITABILITY_PROPERTIES

GLOBAL_THRESHOLDS

GLOBAL_TIME_DIMENSIONS

GLOBAL_TREATMENTS

GLOBAL_WINDOWS

LINK-datasets

LINK_CROP_AGGREGATION

LINK_CROP_CALENDARS

LINK_CROP_PARAMETERS

LINK_CROP_PARAMETERS_CROP

LINK_CROP_PARAMETERS_MODEL

LINK_CROP_PARAMETRIZATION

LINK_CROP_SPATIALIZATIONS

LINK_CROP_STU

LINK_CROP_VARIETY_PARAMETERS

LINK_GRID_COVER

LINK_GRID_REGION_COVER

LINK_REGION_COVER

LINK_SIMULATION_UNIT

LINK_SIMULATION_UNIT_CROP

LINK_SMU_GRID_COVER

LINK_SMU_GRID_REGION_COVER

LINK_SMU_STU

LINK_STU_HORIZONS

LINK_STU_WEIGHTED_PARAMETERS

LINK_SUITABILITY_RULES

SIM-datasets

SIM_BLAST_HRES_GRID

SIM_BLAST_HRES_GRID_LTA

SIM_BLAST_HRES_REGION

SIM_BLAST_HRES_REGION_LTA

SIM_WARM_HRES_GRID

SIM_WARM_HRES_GRID_LTA

SIM_WARM_HRES_REGION

SIM_WARM_HRES_REGION_LTA

SIM_WOFOST_HRES_EMU

SIM_WOFOST_HRES_EMU_LTA

SIM_WOFOST_HRES_GRID

SIM_WOFOST_HRES_GRID_LTA

SIM_WOFOST_HRES_REGION

SIM_WOFOST_HRES_REGION_LTA

SIM_WOFOST_HRES_STU

SOIL-datasets

SOIL_HORIZONS

SOIL_INITIAL_WATER

SOIL_SMU

SOIL_STU

WEATHER-datasets

WEATHER_ERA_GRID