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

Revision as of 15:09, 8 March 2019

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_PARAMETRIZATIONS
1.4 CROP_PARAMETRIZATION_PARAMETER
1.5 CROP_REGIMES
1.6 CROP_SPATIALIZATIONS
1.7 CROP_SUITABILITY_RULES
1.8 CROP_VARIETIES
1.9 CROP_VARIETY_PARAMETERS
1.10 CROP_VARIETY_REGIMES

CROP_AGGREGATIONS

Description: Link between simulated and aggregated crops.
Use: To aggregate simulation results at EMU resolution (IDCROP_PARAMETRIZATION) to regional resolution (IDCROP_AGGREGATION). A single simulated crop (IDCROP_PARAMETERIZATION) can be aggregated to different aggregated crops (IDCROP_AGGREGATION) using different aggregation areas.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_AGGREGATION	False	NUMBER	-	identifier for aggregated crop
IDCROP	False	NUMBER	-	identifier to link statistical crop (EUROSTAT)
IDCROP_PARAMETRIZATION	False	NUMBER	-	identifier for simulated crop

CROP_CALENDARS

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: Table
Remarks: user defined, one of the ‘driving’ tables of the system

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
YEAR	False	NUMBER	-	calendar year (year of sowing/emergence)
START_PERIOD	False	VARCHAR2
END_PERIOD	False	VARCHAR2
EMERGENCE	True	DATE
SOWING	True	DATE
HARVESTING	True	DATE
MATURITY	True	DATE
DURATION	True	NUMBER
START_DOY	True	NUMBER

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

CROP_PARAMETRIZATIONS

Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
IDCROP_PARAMETRIZATION	False	NUMBER
IDMODEL	False	NUMBER
IDCOVER	False	NUMBER
ACTIVE_PARAMETRIZATION	False	VARCHAR2
VIEWER_ENABLED	False	VARCHAR2	Y/N
CROP_PARAMETRIZATION	False	VARCHAR2
DESCRIPTOR	True	VARCHAR2
TAG	True	VARCHAR2

CROP_PARAMETRIZATION_PARAMETER

Description: crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
Use: default crop parameter values in case no variety specific crop parameters are available.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER		crop number
IDCROP_PARAMETER	False	NUMBER		parameter number
XVALUE	False	NUMBER	depending on parameter	parameter x-value
YVALUE	True	NUMBER	depending on parameter	parameter y-value in case of AFGEN function

CROP_REGIMES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_REGIME	False	NUMBER
IDCROP_PARAMETRIZATION	False	NUMBER
SOWING_REGIME	False	VARCHAR2
REGIME_DETAIL	False	VARCHAR2
DETAIL_VALUE	False	VARCHAR2
DETAIL_DIMENSION	False	VARCHAR2
DESCRIPTION	True	VARCHAR2

CROP_SPATIALIZATIONS

Description: Storing for each grid and crop the variety that should be used to simulate the crop
Use: used for calibrations, the find the grid belonging to a variety and calibrating variety specific crop parameters. Used in in simulations to find variety specific crop parameter values.
Type: Table
Remarks: usually the spatial coverage per crop is the same is in object CROP_CALENDARS, except now without the season identifier. The specified spatial variety is static over years.

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER	-	crop number
IDGRID	False	NUMBER	-	grid number
IDVARIETY	False	NUMBER	-	variety number

CROP_SUITABILITY_RULES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP	False	NUMBER
IDSUITABILITY_PROPERTY	False	NUMBER
VALUEC	True	VARCHAR2
VALUEN_MIN	True	NUMBER
VALUEN_MAX	True	NUMBER

CROP_VARIETIES

Description: list of all unique valrieties
Use: lookup table for various link_* objects.
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDVARIETY	False	NUMBER	-	unique identifier for variety
VARIETY	False	VARCHAR2	-	variety name
DESCRIPTOR	False	VARCHAR2	-	variety description

CROP_VARIETY_PARAMETERS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDVARIETY	False	NUMBER
IDCROP_PARAMETER	False	NUMBER
XVALUE	False	NUMBER
YVALUE	True	NUMBER

CROP_VARIETY_REGIMES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDGRID	False	NUMBER
IDVARIETY	False	NUMBER
DECADE	False	NUMBER
IDCROP_PARAMETRIZATION	False	NUMBER

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_EVENTS
2.7 GLOBAL_GRIDS
2.8 GLOBAL_GRID_SOURCES
2.9 GLOBAL_LINK_COVERWINDOW_SOURCE
2.10 GLOBAL_MODELS
2.11 GLOBAL_REGIONS
2.12 GLOBAL_REGION_ELEMENTS
2.13 GLOBAL_REGION_SOURCES
2.14 GLOBAL_SOIL_SOURCES
2.15 GLOBAL_STATIONS
2.16 GLOBAL_STATISTIC_SOURCES
2.17 GLOBAL_SUITABILITY_PROPERTIES
2.18 GLOBAL_THRESHOLDS
2.19 GLOBAL_TIME_DIMENSIONS
2.20 GLOBAL_TREATMENTS
2.21 GLOBAL_WINDOWS

GLOBAL_CATEGORIES

Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
Use:
Type: Materialized View
Remarks:

Structure

Attribute	Constraint	Type
IDCATEGORY	False	NUMBER
CATEGORY	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

select
    idcategory
  , category
  , descriptor
from categories@cgms14sys_assistdas

GLOBAL_COVERS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCOVER	False	NUMBER
COVER	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_COVER_SOURCES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCOVER_SOURCE	False	NUMBER
COVER_SOURCE	False	VARCHAR2
DESCRIPTOR	True	VARCHAR2
UNC	True	VARCHAR2

definition:

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

GLOBAL_CROPS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCROP	False	NUMBER
CROP	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2
EUROSTAT	False	VARCHAR2

definition:

select
    c.idcrop
  , c.crop
  , c.descriptor
  , c.eurostat
from crops@CGMS14SYS_ASSISTDAS c

GLOBAL_CROP_PARAMETERS

Description: snapshot table for snapshot GLOBAL_CROP_PARAMETERS. List of all crop parameters, description, unit, type (single value or AFGEN function) and category (crop- or model parameters).
Use:
Type: Materialized View
Remarks: source objects exist in a different tennent, available via dblink.

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETER	False	NUMBER	-	-
CROP_PARAMETER	False	VARCHAR2	-	-
DESCRIPTOR	False	VARCHAR2	-	-
MULTI	False	VARCHAR2	Y/N	single value (x) or AFGEN function (xy)
IDCATEGORY	False	NUMBER	-	-
CATEGORY	False	VARCHAR2	-	CROP/MODEL

definition:

select
    cp.idcrop_parameter
  , cp.crop_parameter
  , cp.descriptor
  , cp.multi
  , cp.idcategory
  , c.category
from
    crop_parameters@CGMS14SYS_ASSISTDAS cp
  , categories@CGMS14SYS_ASSISTDAS c
where cp.idcategory = c.idcategory

GLOBAL_EVENTS

Description: list of season events
Use: lookup table for events in CROP_CALENDARS
Type: Materialized View
Remarks: values in column EVENT are case sensitive recognized by the crop model and should not be changed unless the mapping is also changed in the crop model.

Structure

Attribute	Constraint	Type	Unit	Comment
IDEVENT	False	NUMBER	-	unique identifier for event
EVENT	False	VARCHAR2	-	event name
DESCRIPTOR	False	VARCHAR2	-	description of event

definition:

select
   idevent
 , event
 , c.descriptor
from events@cgms14sys_assistdas c

GLOBAL_GRIDS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDGRID	False	NUMBER
IDGRID_SOURCE	False	NUMBER
IDORIGINAL_CODE	False	VARCHAR2
LATITUDE	False	NUMBER
LONGITUDE	False	NUMBER
ALTITUDE	False	NUMBER
ALTITUDE_16	True	NUMBER
ALTITUDE_25	True	NUMBER
X	False	NUMBER
Y	False	NUMBER
DISTANCE_FROM_COAST	True	NUMBER
CLIMATE_BARRIER	True	NUMBER
HAS_LAND	False	VARCHAR2
GRID_SOURCE	False	VARCHAR2
RESOLUTION	False	NUMBER
UNIT	False	VARCHAR2

definition:

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

GLOBAL_GRID_SOURCES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDGRID_SOURCE	False	NUMBER
IDWINDOW	False	NUMBER
WINDOW	False	VARCHAR2
NAME	False	VARCHAR2
RESOLUTION	False	NUMBER
UNIT	False	VARCHAR2
DESCRIPTION	True	VARCHAR2
UNC	True	VARCHAR2

definition:

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

GLOBAL_LINK_COVERWINDOW_SOURCE

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDWINDOW	False	NUMBER
WINDOW	False	VARCHAR2
NAME	False	VARCHAR2
IDCOVER	False	NUMBER
COVER	False	VARCHAR2
IDCOVER_SOURCE	False	NUMBER
COVER_SOURCE	False	VARCHAR2
COVER_SOURCE_DESCRIPTOR	True	VARCHAR2

definition:

select
    lcws.idwindow
  , w.window
  , w.name
  , lcws.idcover
  , c.cover
  , lcws.idcover_source
  , cover_source
  , cs.descriptor as cover_source_descriptor
from link_cover_window_source@CGMS14SYS_ASSISTDAS lcws
  , windows@CGMS14SYS_ASSISTDAS w
  , covers@CGMS14SYS_ASSISTDAS c
  , cover_sources@CGMS14SYS_ASSISTDAS cs
where lcws.idwindow = w.idwindow
  and lcws.idcover = c.idcover
  and lcws.idcover_source = cs.idcover_source
order by w.idwindow
  , c.idcover
  , cs.idcover_source

GLOBAL_MODELS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDMODEL	False	NUMBER
MODEL	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_REGIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
REGION	False	VARCHAR2
NAME	False	VARCHAR2
CONTINENT	False	VARCHAR2
POPULATION	True	NUMBER

definition:

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

GLOBAL_REGION_ELEMENTS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDREGION_ELEMENT	False	NUMBER
IDORIGINAL_CODE	False	VARCHAR2
IDREGION	False	VARCHAR2
CONTINENT	False	VARCHAR2
REGION	False	VARCHAR2
GLOBAL_NAME	False	VARCHAR2
LOCAL_NAME	True	VARCHAR2
REGION_LEVEL	False	NUMBER
POPULATION	True	NUMBER
STANDARD	False	VARCHAR2
IDFATHER	True	NUMBER
IDREGION_SOURCE	False	NUMBER
REGION_SOURCE	False	VARCHAR2

definition:

select
    re.idregion_element
  , re.idoriginal_code
  , re.idregion
  , r.continent
  , r.region
  , r.name global_name
  , re.name local_name
  , re.region_level
  , r.population
  , re.standard
  , re.idfather
  , re.idregion_source
  , rs.region_source
from region_elements@CGMS14SYS_ASSISTDAS re
  , regions@CGMS14SYS_ASSISTDAS r
  , region_sources@CGMS14SYS_ASSISTDAS rs
where re.idregion = r.idregion
  and re.idregion_source = rs.idregion_source

GLOBAL_REGION_SOURCES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDREGION_SOURCE	False	NUMBER
REGION_SOURCE	False	VARCHAR2
DESCRIPTION	True	VARCHAR2
UNC	True	VARCHAR2

definition:

select
    r.idregion_source
  , r.region_source
  , r.description
  , r.unc
from region_sources@CGMS14SYS_ASSISTDAS r
order by idregion_source

GLOBAL_SOIL_SOURCES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSOIL_SOURCE	False	NUMBER
SOIL_SOURCE	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_STATIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSTATION	False	NUMBER
STATION	False	VARCHAR2
ORGANIZATION	False	VARCHAR2
IDWMO	True	NUMBER
WMO	True	VARCHAR2
LATITUDE	False	NUMBER
LONGITUDE	False	NUMBER
Y_COORDINATE	False	NUMBER
X_COORDINATE	False	NUMBER
ALTITUDE	False	NUMBER
IDCLIMATE_ZONE	False	NUMBER
COUNTRY	False	VARCHAR2
DISTANCE_TO_COAST	False	NUMBER
ANGSTROM_A	False	NUMBER
ANGSTROM_B	False	NUMBER
SUPIT_A	False	NUMBER
SUPIT_B	False	NUMBER
SUPIT_C	False	NUMBER
HARGREAVES_A	False	NUMBER
HARGREAVES_B	False	NUMBER
RELIABLE_STATION	False	NUMBER
ACTIVE_STATION	False	NUMBER
AVAIL_PRECIPITATION_THRESHOLD	False	NUMBER
AVAIL_SNOWDEPTH_THRESHOLD	False	NUMBER
AVAIL_TEMPERATURE_THRESHOLD	False	NUMBER
AVAIL_HUMIDITY_THRESHOLD	False	NUMBER
AVAIL_REST_THRESHOLD	False	NUMBER

definition:

select
    IDSTATION
  , STATION
  , ORGANIZATION
  , IDWMO
  , WMO
  , LATITUDE
  , LONGITUDE
  , Y_COORDINATE
  , X_COORDINATE
  , ALTITUDE
  , IDCLIMATE_ZONE
  , COUNTRY
  , DISTANCE_TO_COAST
  , ANGSTROM_A
  , ANGSTROM_B
  , SUPIT_A
  , SUPIT_B
  , SUPIT_C
  , HARGREAVES_A
  , HARGREAVES_B
  , RELIABLE_STATION
  , ACTIVE_STATION
  , AVAIL_PRECIPITATION_THRESHOLD
  , AVAIL_SNOWDEPTH_THRESHOLD
  , AVAIL_TEMPERATURE_THRESHOLD
  , AVAIL_HUMIDITY_THRESHOLD
  , AVAIL_REST_THRESHOLD
from stations@cgms14sys_assistdas s

GLOBAL_STATISTIC_SOURCES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSTATISTIC_SOURCE	False	NUMBER
STATISTIC_SOURCE	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_SUITABILITY_PROPERTIES

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSUITABILITY_PROPERTY	False	NUMBER
SUITABILITY_PROPERTY	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_THRESHOLDS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDTHRESHOLD	False	NUMBER
THRESHOLD	False	VARCHAR2
INDICATOR	False	VARCHAR2
OPERATOR	False	VARCHAR2
VALUE_MIN	False	NUMBER
VALUE_MAX	False	NUMBER

definition:

select
    t.idthreshold
  , t.threshold
  , t.indicator
  , t.operator
  , t.value_min
  , t.value_max
from thresholds@CGMS14SYS_ASSISTDAS t
  , windows@CGMS14SYS_ASSISTDAS w
where t.idwindow = w.idwindow

GLOBAL_TIME_DIMENSIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
DAY	False	DATE
DECADE	True	NUMBER
DECADE_ID	True	NUMBER
MONTH	True	NUMBER
MONTH_ID	True	NUMBER
QUARTER	True	NUMBER
QUARTER_ID	True	NUMBER
YEAR	True	NUMBER
LAST_DAY_DECADE	True	VARCHAR2

definition:

select
    t.day
  , t.decade
  , t.decade_id
  , t.month
  , t.month_id
  , t.quarter
  , t.quarter_id
  , t.year
  , t.last_day_decade
from time_dimensions@CGMS14SYS_ASSISTDAS t

GLOBAL_TREATMENTS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDTREATMENT	False	NUMBER
TREATMENT	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2

definition:

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

GLOBAL_WINDOWS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDWINDOW	False	NUMBER
WINDOW	False	VARCHAR2
NAME	False	VARCHAR2
REFERENCE_SYSTEM	False	VARCHAR2
DESCRIPTOR	True	VARCHAR2
MAX_LAT	False	NUMBER
MAX_LON	False	NUMBER
MIN_LAT	False	NUMBER
MIN_LON	False	NUMBER
MAX_X	False	NUMBER
MAX_Y	False	NUMBER
MIN_X	False	NUMBER
MIN_Y	False	NUMBER
ROI	True	NUMBER

definition:

select
    w.idwindow
  , w.window
  , w.name
  , w.reference_system
  , w.descriptor
  , w.max_lat
  , w.max_lon
  , w.min_lat
  , w.min_lon
  , w.max_x
  , w.max_y
  , w.min_x
  , w.min_y
  , w.roi
from windows@CGMS14SYS_ASSISTDAS w

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

Description: relation between simulated crop parameterizations and crop aggregation areas.
Use:
Type: Materialized View
Remarks: One simulated crop parametetrization can be combined with multiple aggregation areas to create alternative aggregated crops. The object contains records from CROP_AGGREGATIONS, with extra descriptive fields.

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_AGGREGATION	False	NUMBER	-	aggregated crop number
IDCROP	False	NUMBER	-	global crop number
CROP	False	VARCHAR2	-	global crop name
CROP_DESCRIPTOR	False	VARCHAR2	-	global crop description
IDMODEL	False	NUMBER	-	crop model number
MODEL	False	VARCHAR2	-	crop model name
MODEL_DESCRIPTOR	False	VARCHAR2	-	crop model description
IDCROP_PARAMETRIZATION	False	NUMBER	-	simulated crop number
CROP_PARAMETRIZATION	False	VARCHAR2	-	simulated crop name
PARAMETRIZATION_DESCRIPTOR	True	VARCHAR2	-	simulated crop description

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

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
CROP_PARAMETRIZATION	False	VARCHAR2
IDMODEL	False	NUMBER
MODEL	False	VARCHAR2
IDCOVER	False	NUMBER
COVER	False	VARCHAR2
IDGRID	False	NUMBER
YEAR	False	NUMBER
START_PERIOD	False	VARCHAR2
START_DATE	True	DATE
END_DATE	True	DATE
DURATION	True	NUMBER
START_DOY	True	NUMBER

definition:

select
    cp.idcrop_parametrization
  , cp.crop_parametrization
  , m.idmodel
  , m.model
  , c.idcover
  , c.cover
  , cc.idgrid
  , cc.year
  , cc.start_period
  ,
  case
     when start_period = 'EMERGENCE' then emergence
     when start_period = 'SOWING' then sowing
  end
    start_date
  ,
  case
     when end_period = 'HARVESTING' then harvesting
     when end_period = 'MATURITY' then maturity
  end
    end_date
  , cc.duration
  , cc.start_doy
from global_models m
  , global_covers c
  , crop_parametrizations cp
  , crop_calendars cc
where cc.idcrop_parametrization = cp.idcrop_parametrization
  and cp.idmodel = m.idmodel
  and cp.idcover = c.idcover
  and cp.active_parametrization = 'Y'
 order by cc.idcrop_parametrization
   , cc.idgrid
   , cc.year

LINK_CROP_PARAMETERS

Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
Use: default crop parameter values in case no variety specific crop parameters are available.
Type: Materialized View
Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER	-	crop number
CROP_PARAMETRIZATION	False	VARCHAR2	-	crop name
IDMODEL	False	NUMBER	-	crop model number
MODEL	False	VARCHAR2	-	crop model name
IDCOVER	False	NUMBER	-	crop mask number
COVER	False	VARCHAR2	-	crop mask name
IDCROP_PARAMETER	False	NUMBER	-	parameter number
CROP_PARAMETER	False	VARCHAR2	-	parameter name
DESCRIPTOR	False	VARCHAR2	-	parameter description and unit
IDCATEGORY	False	NUMBER	-	parameter category number
CATEGORY	False	VARCHAR2	-	parameter category name
XVALUE	False	NUMBER	depending on parameter	parameter x value
YVALUE	True	NUMBER	depending on parameter	parameter y value (in case of AFGEN function)

definition:

select
    cp.idcrop_parametrization
  , cp.crop_parametrization
  , m.idmodel
  , m.model
  , c.idcover
  , c.cover
  , cps.idcrop_parameter
  , cps.crop_parameter
  , cps.descriptor
  , cps.idcategory
  , cps.category
  , cpp.xvalue
  , cpp.yvalue
from
    global_models m
  , global_covers c
  , crop_parametrization_parameter cpp
  , crop_parametrizations cp
  , global_crop_parameters cps
where cpp.idcrop_parametrization = cp.idcrop_parametrization
and   cpp.idcrop_parameter       = cps.idcrop_parameter
and   cp.idcover                 = c.idcover 
and   cp.idmodel                 = m.idmodel
and   lower(cp.active_parametrization)  = lower('Y')
order by cpp.idcrop_parametrization, cps.crop_parameter

LINK_CROP_PARAMETERS_CROP

Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
Use: default crop parameter values in case no variety specific crop parameters are available.
Type: Materialized View
Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'CROP'

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER	-	crop number
CROP_PARAMETRIZATION	False	VARCHAR2	-	crop name
IDMODEL	False	NUMBER	-	crop model number
MODEL	False	VARCHAR2	-	crop model name
IDCOVER	False	NUMBER	-	crop mask number
COVER	False	VARCHAR2	-	crop mask name
IDCROP_PARAMETER	False	NUMBER	-	parameter number
CROP_PARAMETER	False	VARCHAR2	-	parameter name
DESCRIPTOR	False	VARCHAR2	-	parameter description and unit
XVALUE	False	NUMBER	depending on parameter	parameter x value
YVALUE	True	NUMBER	depending on parameter	parameter y value (in case of AFGEN function)

definition:

select
    cp.idcrop_parametrization
  , cp.crop_parametrization
  , m.idmodel
  , m.model
  , c.idcover
  , c.cover
  , cps.idcrop_parameter
  , cps.crop_parameter
  , cps.descriptor
  , cpp.xvalue
  , cpp.yvalue
from
    global_models m
  , global_covers c
  , crop_parametrization_parameter cpp
  , crop_parametrizations cp
  , global_crop_parameters cps
where cpp.idcrop_parametrization        = cp.idcrop_parametrization
and   cpp.idcrop_parameter              = cps.idcrop_parameter
and   cp.idcover                        = c.idcover 
and   cp.idmodel                        = m.idmodel
and   lower(cp.active_parametrization)  = lower('Y')
and   lower(cps.category)               = lower('CROP')
order by cpp.idcrop_parametrization, cps.crop_parameter

LINK_CROP_PARAMETERS_MODEL

Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
Use: default crop parameter values in case no variety specific crop parameters are available.
Type: Materialized View
Remarks: Contains records from CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'MODEL'

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER	-	crop number
CROP_PARAMETRIZATION	False	VARCHAR2	-	crop name
IDMODEL	False	NUMBER	-	crop model number
MODEL	False	VARCHAR2	-	crop model name
IDCOVER	False	NUMBER	-	crop mask number
COVER	False	VARCHAR2	-	crop mask name
IDCROP_PARAMETER	False	NUMBER	-	parameter number
CROP_PARAMETER	False	VARCHAR2	-	parameter name
DESCRIPTOR	False	VARCHAR2	-	parameter description and unit
XVALUE	False	NUMBER	depending on parameter	parameter x value
YVALUE	True	NUMBER	depending on parameter	parameter y value (in case of AFGEN function)

definition:

select
    cp.idcrop_parametrization
  , cp.crop_parametrization
  , m.idmodel
  , m.model
  , c.idcover
  , c.cover
  , cps.idcrop_parameter
  , cps.crop_parameter
  , cps.descriptor
  , cpp.xvalue
  , cpp.yvalue
from
    global_models m
  , global_covers c
  , crop_parametrization_parameter cpp
  , crop_parametrizations cp
  , global_crop_parameters cps
where cpp.idcrop_parametrization        = cp.idcrop_parametrization
and   cpp.idcrop_parameter              = cps.idcrop_parameter
and   cp.idcover                        = c.idcover 
and   cp.idmodel                        = m.idmodel
and   lower(cp.active_parametrization)  = lower('Y')
and   lower(cps.category)               = lower('MODEL')
order by cpp.idcrop_parametrization, cps.crop_parameter

LINK_CROP_PARAMETRIZATION

Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
Use:
Type: View
Remarks: contains the same records as CROP_PARAMETRIZATIONS, with additional descriptive fields.

Structure

Attribute	Constraint	Type	Unit
IDCROP_PARAMETRIZATION	False	NUMBER
CROP_PARAMETRIZATION	False	VARCHAR2
PARAMETRIZATION_DESCRIPTOR	True	VARCHAR2
TAG	False	VARCHAR2
ACTIVE_PARAMETRIZATION	False	VARCHAR2	Y/N
VIEWER_ENABLED	False	VARCHAR2	Y/N
IDMODEL	False	NUMBER
MODEL	False	VARCHAR2
MODEL_DESCRIPTOR	False	VARCHAR2
IDCOVER	False	NUMBER
COVER	False	VARCHAR2
COVER_DESCRIPTOR	False	VARCHAR2

definition:

select
   cp.idcrop_parametrization
 , cp.crop_parametrization
 , cp.descriptor as parametrization_descriptor
 , cp.tag
 , cp.active_parametrization
 , cp.viewer_enabled
 , cp.idmodel
 , m.model
 , m.descriptor as model_descriptor
 , c.idcover
 , c.cover
 , c.descriptor as cover_descriptor
from
   crop_parametrizations cp
 , global_models         m
 , global_covers         c
where cp.idmodel = m.idmodel
and   cp.idcover = c.idcover
order by cp.idcrop_parametrization

LINK_CROP_SPATIALIZATIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
CROP_PARAMETRIZATION	False	VARCHAR2
IDMODEL	False	NUMBER
MODEL	False	VARCHAR2
IDCOVER	False	NUMBER
COVER	False	VARCHAR2
IDGRID	False	NUMBER
IDVARIETY	False	NUMBER
VARIETY	False	VARCHAR2
IDCROP_PARAMETER	False	NUMBER
CROP_PARAMETER	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2
XVALUE	False	NUMBER
YVALUE	True	NUMBER

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

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP	False	NUMBER
IDSTU	False	NUMBER

LINK_CROP_VARIETY_PARAMETERS

Description: Optimized parameters for a variety.
Use: If a parameter exist in this object it overwrites the default value stored in LINK_CROP_PARAMETERS_CROP and LINK_CROP_PARAMETERS_MODEL.
Type: Materialized View
Remarks: Contains records from CROP_VARIETY_PARAMETERS, with extra descriptive fields

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP_PARAMETRIZATION	False	NUMBER	-	crop number
CROP_PARAMETRIZATION	False	VARCHAR2	-	crop name
IDMODEL	False	NUMBER	-	crop model number
MODEL	False	VARCHAR2	-	crop model name
IDCOVER	False	NUMBER	-	crop mask number
COVER	False	VARCHAR2	-	crop mask name
IDVARIETY	False	NUMBER	-	variety number
VARIETY	False	VARCHAR2	-	variety name
IDCROP_PARAMETER	False	NUMBER	-	parameter number
CROP_PARAMETER	False	VARCHAR2		parameter name
DESCRIPTOR	False	VARCHAR2		parameter description and unit
XVALUE	False	NUMBER	depending on parameter	parameter x value
YVALUE	True	NUMBER	depending on parameter	parameter y value (in case of AFGEN function)

definition:

select 
   * 
from
   ( 
   select distinct
       cp.idcrop_parametrization
     , cp.crop_parametrization
     , m.idmodel
     , m.model
     , c.idcover
     , c.cover
     , v.idvariety
     , v.variety
     , cps.idcrop_parameter
     , cps.crop_parameter
     , cps.descriptor
     , cvp.xvalue
     , cvp.yvalue
   from
       global_models m
     , global_covers c
     , crop_varieties v
     , crop_parametrizations cp
     , crop_spatializations cs
     , global_crop_parameters cps
     , crop_variety_parameters cvp
   where cs.idcrop_parametrization        = cp.idcrop_parametrization
     and cp.idcover                       = c.idcover 
     and cs.idvariety                     = v.idvariety
     and cp.idmodel                       = m.idmodel
     and cs.idvariety                     = cvp.idvariety
     and cvp.idcrop_parameter             = cps.idcrop_parameter
     and lower(cp.active_parametrization) = lower('Y')
   ) a        
order by
     idcrop_parametrization
   , idvariety
   , crop_parameter

LINK_GRID_COVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDGRID	False	NUMBER
IDCOVER	False	NUMBER
AREA	False	NUMBER

LINK_GRID_REGION_COVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
IDGRID	False	NUMBER
AREA	False	NUMBER

LINK_REGION_COVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
AREA	False	NUMBER

LINK_SIMULATION_UNIT

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	False	NUMBER
IDSTU	False	NUMBER

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

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
IDSTU	False	NUMBER

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

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCOVER	False	NUMBER
IDGRID	False	NUMBER
IDSMU	False	NUMBER
AREA	False	NUMBER

LINK_SMU_GRID_REGION_COVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
IDGRID	False	NUMBER
IDSMU	False	NUMBER
AREA	False	NUMBER

LINK_SMU_STU

Description: Relative area of each STU inside a SMU.
Use: used to find unique simulation units in elementary mapping units (see Spatial_schematization).
Type: Table
Remarks: The total percentage per SMU adds up to 100%.

Structure

Attribute	Constraint	Type	Unit	Comment
IDSMU	False	NUMBER	-	unique identifier for the soil map unit
IDSTU	False	NUMBER	-	identifier to the soil typologic unit
PERCENTAGE	False	NUMBER	-	% of area inside the SMU, covered by the STU

LINK_STU_HORIZONS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDSTU	False	NUMBER
IDHORIZON	False	NUMBER
DEPTH_MIN	False	NUMBER
DEPTH_MAX	False	NUMBER
HORIZON_LEVEL	False	NUMBER

LINK_STU_WEIGHTED_PARAMETERS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSTU	False	NUMBER
SAND	True	NUMBER
SILT	True	NUMBER
CLAY	True	NUMBER
SOIL_MOISTURE_WP	True	NUMBER
SOIL_MOISTURE_FC	True	NUMBER
SOIL_MOISTURE_SAT	True	NUMBER
BULK_DENSITY	True	NUMBER
ORGANIC_CARBON	True	NUMBER
DEPTH	True	NUMBER

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

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	False	NUMBER
IDCROP	False	NUMBER
CROP	False	VARCHAR2
CROP_DESCRIPTOR	False	VARCHAR2
IDMODEL	False	NUMBER
MODEL	False	VARCHAR2
MODEL_DESCRIPTOR	False	VARCHAR2
IDCROP_PARAMETRIZATION	False	NUMBER
CROP_PARAMETRIZATION	False	VARCHAR2
PARAMETRIZATION_DESCRIPTOR	True	VARCHAR2
IDSUITABILITY_PROPERTY	False	NUMBER
SUITABILITY_PROPERTY	False	VARCHAR2
SUITABILITY_DESCRIPTOR	False	VARCHAR2
SUITABILITY_PROPERTY_MIN	True	NUMBER
SUITABILITY_PROPERTY_MAX	True	NUMBER
SUITABILITY_PROPERTY_VALUE	True	VARCHAR2

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

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
BLASTRISKLEVEL	True	NUMBER
BLASTINFECTION	True	NUMBER
BLASTSPORULATION	True	NUMBER
LEAVESBIOMASSPOTENTIAL	True	NUMBER
LEAVESBIOMASSWITHBLAST	True	NUMBER
GAIPOTENTIAL	True	NUMBER
GAIWITHBLAST	True	NUMBER
AGBPOTENTIAL	True	NUMBER
AGBWITHBLAST	True	NUMBER
STORAGEORGANSPOTENTIAL	True	NUMBER
STORAGEORGANSWITHBLAST	True	NUMBER
DAYSWITHLOWINFECTIONRISK	True	NUMBER
DAYSWITHMEDIUMINFECTIONRISK	True	NUMBER
DAYSWITHHIGHINFECTIONRISK	True	NUMBER
RUE_POTENTIAL	True	NUMBER
RUE_WITH_BLAST	True	NUMBER
BLAST_EFFECT_ON_RUE	True	NUMBER
HUMIDITYMINIMUM	True	NUMBER
HUMIDITYMAXIMUM	True	NUMBER

SIM_BLAST_HRES_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

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

SIM_BLAST_HRES_REGION

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	False	NUMBER
IDREGION	False	VARCHAR2
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
BLASTRISKLEVEL	True	NUMBER
BLASTINFECTION	True	NUMBER
BLASTSPORULATION	True	NUMBER
LEAVESBIOMASSPOTENTIAL	True	NUMBER
LEAVESBIOMASSWITHBLAST	True	NUMBER
GAIPOTENTIAL	True	NUMBER
GAIWITHBLAST	True	NUMBER
AGBPOTENTIAL	True	NUMBER
AGBWITHBLAST	True	NUMBER
STORAGEORGANSPOTENTIAL	True	NUMBER
STORAGEORGANSWITHBLAST	True	NUMBER
DAYSWITHLOWINFECTIONRISK	True	NUMBER
DAYSWITHMEDIUMINFECTIONRISK	True	NUMBER
DAYSWITHHIGHINFECTIONRISK	True	NUMBER
RUE_POTENTIAL	True	NUMBER
RUE_WITH_BLAST	True	NUMBER
BLAST_EFFECT_ON_RUE	True	NUMBER
HUMIDITYMINIMUM	True	NUMBER
HUMIDITYMAXIMUM	True	NUMBER

SIM_BLAST_HRES_REGION_LTA

Description:
Use:
Type: Table
Remarks:

Structure

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

SIM_WARM_HRES_GRID

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
ABIOTIC_LIM_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
ABIOTIC_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
SPIKELET_STERILITY	True	NUMBER
BLAST_LIM_YIELD_BIOMASS	True	NUMBER
BLAST_LIM_YIELD_STORAGE	True	NUMBER
BLAST_ABIOTIC_LIM_YI_BIOMASS	True	NUMBER
BLAST_ABIOTIC_LIM_YI_STORAGE	True	NUMBER
FORC_POTENTIAL_YIELD_BIOMASS	True	NUMBER
FORC_POTENTIAL_YIELD_STORAGE	True	NUMBER
FORC_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
DAYSWITHHIGHINFECTIONRISK	True	NUMBER
TRANSPIRATION	True	NUMBER

SIM_WARM_HRES_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

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

SIM_WARM_HRES_REGION

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	False	NUMBER
IDREGION	False	VARCHAR2
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
ABIOTIC_LIM_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
ABIOTIC_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
SPIKELET_STERILITY	True	NUMBER
BLAST_LIM_YIELD_BIOMASS	True	NUMBER
BLAST_LIM_YIELD_STORAGE	True	NUMBER
BLAST_ABIOTIC_LIM_YI_BIOMASS	True	NUMBER
BLAST_ABIOTIC_LIM_YI_STORAGE	True	NUMBER
FORC_POTENTIAL_YIELD_BIOMASS	True	NUMBER
FORC_POTENTIAL_YIELD_STORAGE	True	NUMBER
FORC_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
DAYSWITHHIGHINFECTIONRISK	True	NUMBER
TRANSPIRATION	True	NUMBER

SIM_WARM_HRES_REGION_LTA

Description:
Use:
Type: Table
Remarks:

Structure

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

SIM_WOFOST_HRES_EMU

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
IDSMU	False	NUMBER
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
WATER_LIM_YIELD_BIOMASS	True	NUMBER
WATER_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
RELATIVE_SOIL_MOISTURE	True	NUMBER
TOTAL_WATER_CONSUMPTION	True	NUMBER
TOTAL_WATER_REQUIREMENT	True	NUMBER
FSM	True	NUMBER
FSMUR	True	NUMBER
LEAVES_DIED_BY_COLD	True	NUMBER
RUNOFF	True	NUMBER
SOIL_EVAPORATION	True	NUMBER
LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_EMU_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
IDSMU	False	NUMBER
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
AVG_POTENTIAL_YIELD_BIOMASS	True	NUMBER
AVG_POTENTIAL_YIELD_STORAGE	True	NUMBER
AVG_WATER_LIM_YIELD_BIOMASS	True	NUMBER
AVG_WATER_LIM_YIELD_STORAGE	True	NUMBER
AVG_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
AVG_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
AVG_DEVELOPMENT_STAGE	True	NUMBER
AVG_RELATIVE_SOIL_MOISTURE	True	NUMBER
AVG_TOTAL_WATER_CONSUMPTION	True	NUMBER
AVG_TOTAL_WATER_REQUIREMENT	True	NUMBER
AVG_FSM	True	NUMBER
AVG_FSMUR	True	NUMBER
AVG_LEAVES_DIED_BY_COLD	True	NUMBER
AVG_RUNOFF	True	NUMBER
AVG_SOIL_EVAPORATION	True	NUMBER
AVG_LOSS_TO_SUBSOIL	True	NUMBER
MIN_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MIN_POTENTIAL_YIELD_STORAGE	True	NUMBER
MIN_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MIN_WATER_LIM_YIELD_STORAGE	True	NUMBER
MIN_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MIN_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MIN_DEVELOPMENT_STAGE	True	NUMBER
MIN_RELATIVE_SOIL_MOISTURE	True	NUMBER
MIN_TOTAL_WATER_CONSUMPTION	True	NUMBER
MIN_TOTAL_WATER_REQUIREMENT	True	NUMBER
MIN_FSM	True	NUMBER
MIN_FSMUR	True	NUMBER
MIN_LEAVES_DIED_BY_COLD	True	NUMBER
MIN_RUNOFF	True	NUMBER
MIN_SOIL_EVAPORATION	True	NUMBER
MIN_LOSS_TO_SUBSOIL	True	NUMBER
MAX_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MAX_POTENTIAL_YIELD_STORAGE	True	NUMBER
MAX_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MAX_WATER_LIM_YIELD_STORAGE	True	NUMBER
MAX_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MAX_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MAX_DEVELOPMENT_STAGE	True	NUMBER
MAX_RELATIVE_SOIL_MOISTURE	True	NUMBER
MAX_TOTAL_WATER_CONSUMPTION	True	NUMBER
MAX_TOTAL_WATER_REQUIREMENT	True	NUMBER
MAX_FSM	True	NUMBER
MAX_FSMUR	True	NUMBER
MAX_LEAVES_DIED_BY_COLD	True	NUMBER
MAX_RUNOFF	True	NUMBER
MAX_SOIL_EVAPORATION	True	NUMBER
MAX_LOSS_TO_SUBSOIL	True	NUMBER
STD_POTENTIAL_YIELD_BIOMASS	True	NUMBER
STD_POTENTIAL_YIELD_STORAGE	True	NUMBER
STD_WATER_LIM_YIELD_BIOMASS	True	NUMBER
STD_WATER_LIM_YIELD_STORAGE	True	NUMBER
STD_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
STD_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
STD_DEVELOPMENT_STAGE	True	NUMBER
STD_RELATIVE_SOIL_MOISTURE	True	NUMBER
STD_TOTAL_WATER_CONSUMPTION	True	NUMBER
STD_TOTAL_WATER_REQUIREMENT	True	NUMBER
STD_FSM	True	NUMBER
STD_FSMUR	True	NUMBER
STD_LEAVES_DIED_BY_COLD	True	NUMBER
STD_RUNOFF	True	NUMBER
STD_SOIL_EVAPORATION	True	NUMBER
STD_LOSS_TO_SUBSOIL	True	NUMBER
NUM_POTENTIAL_YIELD_BIOMASS	True	NUMBER
NUM_POTENTIAL_YIELD_STORAGE	True	NUMBER
NUM_WATER_LIM_YIELD_BIOMASS	True	NUMBER
NUM_WATER_LIM_YIELD_STORAGE	True	NUMBER
NUM_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
NUM_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
NUM_DEVELOPMENT_STAGE	True	NUMBER
NUM_RELATIVE_SOIL_MOISTURE	True	NUMBER
NUM_TOTAL_WATER_CONSUMPTION	True	NUMBER
NUM_TOTAL_WATER_REQUIREMENT	True	NUMBER
NUM_FSM	True	NUMBER
NUM_FSMUR	True	NUMBER
NUM_LEAVES_DIED_BY_COLD	True	NUMBER
NUM_RUNOFF	True	NUMBER
NUM_SOIL_EVAPORATION	True	NUMBER
NUM_LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_GRID

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
WATER_LIM_YIELD_BIOMASS	True	NUMBER
WATER_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
RELATIVE_SOIL_MOISTURE	True	NUMBER
TOTAL_WATER_CONSUMPTION	True	NUMBER
TOTAL_WATER_REQUIREMENT	True	NUMBER
FSM	True	NUMBER
FSMUR	True	NUMBER
LEAVES_DIED_BY_COLD	True	NUMBER
RUNOFF	True	NUMBER
SOIL_EVAPORATION	True	NUMBER
LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
AVG_POTENTIAL_YIELD_BIOMASS	True	NUMBER
AVG_POTENTIAL_YIELD_STORAGE	True	NUMBER
AVG_WATER_LIM_YIELD_BIOMASS	True	NUMBER
AVG_WATER_LIM_YIELD_STORAGE	True	NUMBER
AVG_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
AVG_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
AVG_DEVELOPMENT_STAGE	True	NUMBER
AVG_RELATIVE_SOIL_MOISTURE	True	NUMBER
AVG_TOTAL_WATER_CONSUMPTION	True	NUMBER
AVG_TOTAL_WATER_REQUIREMENT	True	NUMBER
AVG_FSM	True	NUMBER
AVG_FSMUR	True	NUMBER
AVG_LEAVES_DIED_BY_COLD	True	NUMBER
AVG_RUNOFF	True	NUMBER
AVG_SOIL_EVAPORATION	True	NUMBER
AVG_LOSS_TO_SUBSOIL	True	NUMBER
MIN_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MIN_POTENTIAL_YIELD_STORAGE	True	NUMBER
MIN_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MIN_WATER_LIM_YIELD_STORAGE	True	NUMBER
MIN_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MIN_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MIN_DEVELOPMENT_STAGE	True	NUMBER
MIN_RELATIVE_SOIL_MOISTURE	True	NUMBER
MIN_TOTAL_WATER_CONSUMPTION	True	NUMBER
MIN_TOTAL_WATER_REQUIREMENT	True	NUMBER
MIN_FSM	True	NUMBER
MIN_FSMUR	True	NUMBER
MIN_LEAVES_DIED_BY_COLD	True	NUMBER
MIN_RUNOFF	True	NUMBER
MIN_SOIL_EVAPORATION	True	NUMBER
MIN_LOSS_TO_SUBSOIL	True	NUMBER
MAX_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MAX_POTENTIAL_YIELD_STORAGE	True	NUMBER
MAX_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MAX_WATER_LIM_YIELD_STORAGE	True	NUMBER
MAX_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MAX_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MAX_DEVELOPMENT_STAGE	True	NUMBER
MAX_RELATIVE_SOIL_MOISTURE	True	NUMBER
MAX_TOTAL_WATER_CONSUMPTION	True	NUMBER
MAX_TOTAL_WATER_REQUIREMENT	True	NUMBER
MAX_FSM	True	NUMBER
MAX_FSMUR	True	NUMBER
MAX_LEAVES_DIED_BY_COLD	True	NUMBER
MAX_RUNOFF	True	NUMBER
MAX_SOIL_EVAPORATION	True	NUMBER
MAX_LOSS_TO_SUBSOIL	True	NUMBER
STD_POTENTIAL_YIELD_BIOMASS	True	NUMBER
STD_POTENTIAL_YIELD_STORAGE	True	NUMBER
STD_WATER_LIM_YIELD_BIOMASS	True	NUMBER
STD_WATER_LIM_YIELD_STORAGE	True	NUMBER
STD_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
STD_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
STD_DEVELOPMENT_STAGE	True	NUMBER
STD_RELATIVE_SOIL_MOISTURE	True	NUMBER
STD_TOTAL_WATER_CONSUMPTION	True	NUMBER
STD_TOTAL_WATER_REQUIREMENT	True	NUMBER
STD_FSM	True	NUMBER
STD_FSMUR	True	NUMBER
STD_LEAVES_DIED_BY_COLD	True	NUMBER
STD_RUNOFF	True	NUMBER
STD_SOIL_EVAPORATION	True	NUMBER
STD_LOSS_TO_SUBSOIL	True	NUMBER
NUM_POTENTIAL_YIELD_BIOMASS	True	NUMBER
NUM_POTENTIAL_YIELD_STORAGE	True	NUMBER
NUM_WATER_LIM_YIELD_BIOMASS	True	NUMBER
NUM_WATER_LIM_YIELD_STORAGE	True	NUMBER
NUM_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
NUM_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
NUM_DEVELOPMENT_STAGE	True	NUMBER
NUM_RELATIVE_SOIL_MOISTURE	True	NUMBER
NUM_TOTAL_WATER_CONSUMPTION	True	NUMBER
NUM_TOTAL_WATER_REQUIREMENT	True	NUMBER
NUM_FSM	True	NUMBER
NUM_FSMUR	True	NUMBER
NUM_LEAVES_DIED_BY_COLD	True	NUMBER
NUM_RUNOFF	True	NUMBER
NUM_SOIL_EVAPORATION	True	NUMBER
NUM_LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_REGION

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	False	NUMBER
IDREGION	False	VARCHAR2
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
WATER_LIM_YIELD_BIOMASS	True	NUMBER
WATER_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
RELATIVE_SOIL_MOISTURE	True	NUMBER
TOTAL_WATER_CONSUMPTION	True	NUMBER
TOTAL_WATER_REQUIREMENT	True	NUMBER
FSM	True	NUMBER
FSMUR	True	NUMBER
LEAVES_DIED_BY_COLD	True	NUMBER
RUNOFF	True	NUMBER
SOIL_EVAPORATION	True	NUMBER
LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_REGION_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_AGGREGATION	False	NUMBER
IDREGION	False	VARCHAR2
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
AVG_POTENTIAL_YIELD_BIOMASS	True	NUMBER
AVG_POTENTIAL_YIELD_STORAGE	True	NUMBER
AVG_WATER_LIM_YIELD_BIOMASS	True	NUMBER
AVG_WATER_LIM_YIELD_STORAGE	True	NUMBER
AVG_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
AVG_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
AVG_DEVELOPMENT_STAGE	True	NUMBER
AVG_RELATIVE_SOIL_MOISTURE	True	NUMBER
AVG_TOTAL_WATER_CONSUMPTION	True	NUMBER
AVG_TOTAL_WATER_REQUIREMENT	True	NUMBER
AVG_FSM	True	NUMBER
AVG_FSMUR	True	NUMBER
AVG_LEAVES_DIED_BY_COLD	True	NUMBER
AVG_RUNOFF	True	NUMBER
AVG_SOIL_EVAPORATION	True	NUMBER
AVG_LOSS_TO_SUBSOIL	True	NUMBER
MIN_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MIN_POTENTIAL_YIELD_STORAGE	True	NUMBER
MIN_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MIN_WATER_LIM_YIELD_STORAGE	True	NUMBER
MIN_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MIN_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MIN_DEVELOPMENT_STAGE	True	NUMBER
MIN_RELATIVE_SOIL_MOISTURE	True	NUMBER
MIN_TOTAL_WATER_CONSUMPTION	True	NUMBER
MIN_TOTAL_WATER_REQUIREMENT	True	NUMBER
MIN_FSM	True	NUMBER
MIN_FSMUR	True	NUMBER
MIN_LEAVES_DIED_BY_COLD	True	NUMBER
MIN_RUNOFF	True	NUMBER
MIN_SOIL_EVAPORATION	True	NUMBER
MIN_LOSS_TO_SUBSOIL	True	NUMBER
MAX_POTENTIAL_YIELD_BIOMASS	True	NUMBER
MAX_POTENTIAL_YIELD_STORAGE	True	NUMBER
MAX_WATER_LIM_YIELD_BIOMASS	True	NUMBER
MAX_WATER_LIM_YIELD_STORAGE	True	NUMBER
MAX_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
MAX_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
MAX_DEVELOPMENT_STAGE	True	NUMBER
MAX_RELATIVE_SOIL_MOISTURE	True	NUMBER
MAX_TOTAL_WATER_CONSUMPTION	True	NUMBER
MAX_TOTAL_WATER_REQUIREMENT	True	NUMBER
MAX_FSM	True	NUMBER
MAX_FSMUR	True	NUMBER
MAX_LEAVES_DIED_BY_COLD	True	NUMBER
MAX_RUNOFF	True	NUMBER
MAX_SOIL_EVAPORATION	True	NUMBER
MAX_LOSS_TO_SUBSOIL	True	NUMBER
STD_POTENTIAL_YIELD_BIOMASS	True	NUMBER
STD_POTENTIAL_YIELD_STORAGE	True	NUMBER
STD_WATER_LIM_YIELD_BIOMASS	True	NUMBER
STD_WATER_LIM_YIELD_STORAGE	True	NUMBER
STD_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
STD_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
STD_DEVELOPMENT_STAGE	True	NUMBER
STD_RELATIVE_SOIL_MOISTURE	True	NUMBER
STD_TOTAL_WATER_CONSUMPTION	True	NUMBER
STD_TOTAL_WATER_REQUIREMENT	True	NUMBER
STD_FSM	True	NUMBER
STD_FSMUR	True	NUMBER
STD_LEAVES_DIED_BY_COLD	True	NUMBER
STD_RUNOFF	True	NUMBER
STD_SOIL_EVAPORATION	True	NUMBER
STD_LOSS_TO_SUBSOIL	True	NUMBER
NUM_POTENTIAL_YIELD_BIOMASS	True	NUMBER
NUM_POTENTIAL_YIELD_STORAGE	True	NUMBER
NUM_WATER_LIM_YIELD_BIOMASS	True	NUMBER
NUM_WATER_LIM_YIELD_STORAGE	True	NUMBER
NUM_POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
NUM_WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
NUM_DEVELOPMENT_STAGE	True	NUMBER
NUM_RELATIVE_SOIL_MOISTURE	True	NUMBER
NUM_TOTAL_WATER_CONSUMPTION	True	NUMBER
NUM_TOTAL_WATER_REQUIREMENT	True	NUMBER
NUM_FSM	True	NUMBER
NUM_FSMUR	True	NUMBER
NUM_LEAVES_DIED_BY_COLD	True	NUMBER
NUM_RUNOFF	True	NUMBER
NUM_SOIL_EVAPORATION	True	NUMBER
NUM_LOSS_TO_SUBSOIL	True	NUMBER

SIM_WOFOST_HRES_STU

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
IDSTU	False	NUMBER
DAY	False	DATE
YEAR	False	NUMBER
DOY	False	NUMBER
IDSERIES	False	NUMBER
POTENTIAL_YIELD_BIOMASS	True	NUMBER
POTENTIAL_YIELD_STORAGE	True	NUMBER
WATER_LIM_YIELD_BIOMASS	True	NUMBER
WATER_LIM_YIELD_STORAGE	True	NUMBER
POTENTIAL_LEAF_AREA_INDEX	True	NUMBER
WATER_LIM_LEAF_AREA_INDEX	True	NUMBER
DEVELOPMENT_STAGE	True	NUMBER
RELATIVE_SOIL_MOISTURE	True	NUMBER
TOTAL_WATER_CONSUMPTION	True	NUMBER
TOTAL_WATER_REQUIREMENT	True	NUMBER
FSM	True	NUMBER
FSMUR	True	NUMBER
LEAVES_DIED_BY_COLD	True	NUMBER
RUNOFF	True	NUMBER
SOIL_EVAPORATION	True	NUMBER
LOSS_TO_SUBSOIL	True	NUMBER

SOIL-datasets

content
5.1 SOIL_HORIZONS
5.2 SOIL_INITIAL_WATER
5.3 SOIL_SMU
5.4 SOIL_STU

SOIL_HORIZONS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDHORIZON	False	NUMBER
IDORIGINAL_CODE	False	VARCHAR2
IDSOIL_SOURCE	False	NUMBER
HORIZON	False	VARCHAR2
DESCRIPTOR	False	VARCHAR2
ORIGINAL_LEVEL	True	NUMBER
SOIL_MOISTURE_CONTENT_WP	True	NUMBER
SOIL_MOISTURE_CONTENT_FC	True	NUMBER
SOIL_MOISTURE_CONTENT_SAT	True	NUMBER
DEPTH	True	NUMBER
USDA_CLASS#	True	NUMBER
USDA_CLASS	True	VARCHAR2
GRAVEL	True	NUMBER
SAND	True	NUMBER
SILT	True	NUMBER
CLAY	True	NUMBER
BULK_DENSITY	True	NUMBER
ORGANIC_CARBON	True	NUMBER
PH_H2O	True	NUMBER
CLAY_CATION_EXCNG_CAPCTY	True	NUMBER
SOIL_CATION_EXCNG_CAPCTY	True	NUMBER
SOIL_BASE_SATURATION	True	NUMBER
TOTAL_EXCHANGEABLE_BASE	True	NUMBER
CALCIUM_CARBONATE	True	NUMBER
CALCIUM_SULPHATE	True	NUMBER
EXCHANGEABLE_SODIUM	True	NUMBER
ELECTRICAL_CONDUCTIVITY	True	NUMBER

SOIL_INITIAL_WATER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDCROP_PARAMETRIZATION	False	NUMBER
IDGRID	False	NUMBER
IDSTU	False	NUMBER
YEAR	False	NUMBER
INITIAL_DEPTH_GROUND_WATER	True	NUMBER
DRAINAGE_DEPTH	True	NUMBER
ROOTING_DEPTH_POTENTIAL_WATER	True	NUMBER
POTENTIAL_WATER_STARTDATE	True	DATE

SOIL_SMU

Description: Spatially available unique Soil Map Units (SMU's).
Use: The soil map units are one of the layers used in the Spatial_schematization
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDSMU	False	NUMBER	-	unique identifier for the soil map unit
IDORIGINAL_CODE	False	VARCHAR2	-	legacy identifier
IDSOIL_SOURCE	False	NUMBER	-	soil source number

SOIL_STU

Description: distinct soil types that have been identified and described by attributes (variables) specifying the nature and properties of the soils (e.g. name, texture, the moisture regime, the stoniness, depth to bedrock etc.).
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTU	False	NUMBER	-	unique identifier for soil typologic unit
IDORIGINAL_CODE	False	VARCHAR2	-	legacy identifier
IDSOIL_SOURCE	False	NUMBER	-	soil source number
STU	False	VARCHAR2	-	resulution
DESCRIPTOR	False	VARCHAR2	-	resolution description
SOIL_WRB	True	VARCHAR2	-	World Reference Base soil code
SOIL_WRB_CL	True	VARCHAR2	-	World Reference Base soil code
SOIL_FAO90	True	VARCHAR2	-	FAO 1990 soil code
SOIL_FAO90_CL	True	VARCHAR2	-	FAO 1990 soil code
SOIL_FAO85	True	VARCHAR2	-	FAO 1985 soil code
SOIL_FAO85_CL	True	VARCHAR2	-	FAO 1985 soil code
SLOPE	True	VARCHAR2	-	slope
TEXTURE	True	VARCHAR2	-	texture of the soil
PHASE	True	VARCHAR2	-	agricultural limitation
LAYERS	True	NUMBER	-	number of soil layers
CALCULATED_ROOTING_DEPTH	True	NUMBER	-	rooting depth class
DRAINAGE	True	NUMBER	-	the drainage of the soil
LIMITATION_TO_AGRIC_USE1	True	NUMBER	-	first limitation for agricultural usage
LIMITATION_TO_AGRIC_USE2	True	NUMBER	-	second limitation for agricultural usage
OBSTACLE_TO_ROOTS	True	NUMBER	-	obstacle to root
IMPERMEABLE_DEPTH_LAYER	True	NUMBER	-	impermeable layer number
SOIL_WATER_REGIME	True	NUMBER	-	soil water regime
DEPTH_TO_BEDROCK	True	VARCHAR2	-	depth to bedrock
SOIL_FAO74	True	VARCHAR2	-	FAO 1974 soil code
SOIL_FAO74_CL	True	VARCHAR2	-	FAO 1974 soil code

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_INFO_ERR
6.24 WEATHER_OBS_STATION_LTA
6.25 WEATHER_OBS_STATION_RAW
6.26 WEATHER_OBS_STATION_TEMP
6.27 WEATHER_OPE_GRID
6.28 WEATHER_OPE_REGIONCOVER

WEATHER_ERA_GRID

Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
Use: input for crop simulation.
Type: Table
Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	False	NUMBER
DAY	False	DATE
TEMPERATURE_MAX	False	NUMBER	°C	maximum air temperature at 2 m height
TEMPERATURE_MIN	False	NUMBER	°C	minimum air temperature at 2 m height
TEMPERATURE_AVG	False	NUMBER	°C	average air temperature at 2 m height
TEMPERATURE_DEW	False	NUMBER	°C	dewpoint air temperature at 2 m height
VAPOURPRESSURE	False	NUMBER	hPa	mean daily vapour pressure
WINDSPEED	False	NUMBER	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	False	NUMBER	mm.d-1	daily rainfall
E0	False	NUMBER	mm.d-1	daily transpiration of water surface
ES0	False	NUMBER	mm.d-1	daily transpiration of wet bare soil
ET0	False	NUMBER	mm.d-1	daily transpiration of crop canopy
RADIATION	False	NUMBER	kJ.m-2.d-1	daily radiation at surface
SNOWWEQ	True	NUMBER	cm	daily mean snow water equivalent
SNOWDEPTH	True	NUMBER	cm	daily mean snow depth**
TOTALCLOUD	True	NUMBER

<nowiki>*</nowiki> Not available (relevant) in HIS product <nowiki>**</nowiki> Not available in EPS, MON and SEA products

WEATHER_ERA_GRID_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDGRID	False	NUMBER
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
AVG_TEMPERATURE_MAX	False	NUMBER
AVG_TEMPERATURE_MIN	False	NUMBER
AVG_TEMPERATURE_AVG	False	NUMBER
AVG_TEMPERATURE_DEW	False	NUMBER
AVG_VAPOURPRESSURE	False	NUMBER
AVG_WINDSPEED	False	NUMBER
AVG_PRECIPITATION	False	NUMBER
AVG_E0	False	NUMBER
AVG_ES0	False	NUMBER
AVG_ET0	False	NUMBER
AVG_RADIATION	False	NUMBER
AVG_SNOWDEPTH	True	NUMBER
AVG_SNOWWEQ	True	NUMBER
AVG_TOTALCLOUD	True	NUMBER
MIN_TEMPERATURE_MAX	False	NUMBER
MIN_TEMPERATURE_MIN	False	NUMBER
MIN_TEMPERATURE_AVG	False	NUMBER
MIN_TEMPERATURE_DEW	False	NUMBER
MIN_VAPOURPRESSURE	False	NUMBER
MIN_WINDSPEED	False	NUMBER
MIN_PRECIPITATION	False	NUMBER
MIN_E0	False	NUMBER
MIN_ES0	False	NUMBER
MIN_ET0	False	NUMBER
MIN_RADIATION	False	NUMBER
MIN_SNOWDEPTH	True	NUMBER
MIN_SNOWWEQ	True	NUMBER
MIN_TOTALCLOUD	True	NUMBER
MAX_TEMPERATURE_MAX	False	NUMBER
MAX_TEMPERATURE_MIN	False	NUMBER
MAX_TEMPERATURE_AVG	False	NUMBER
MAX_TEMPERATURE_DEW	False	NUMBER
MAX_VAPOURPRESSURE	False	NUMBER
MAX_WINDSPEED	False	NUMBER
MAX_PRECIPITATION	False	NUMBER
MAX_E0	False	NUMBER
MAX_ES0	False	NUMBER
MAX_ET0	False	NUMBER
MAX_RADIATION	False	NUMBER
MAX_SNOWDEPTH	True	NUMBER
MAX_SNOWWEQ	True	NUMBER
MAX_TOTALCLOUD	True	NUMBER
STD_TEMPERATURE_MAX	False	NUMBER
STD_TEMPERATURE_MIN	False	NUMBER
STD_TEMPERATURE_AVG	False	NUMBER
STD_TEMPERATURE_DEW	False	NUMBER
STD_VAPOURPRESSURE	False	NUMBER
STD_WINDSPEED	False	NUMBER
STD_PRECIPITATION	False	NUMBER
STD_E0	False	NUMBER
STD_ES0	False	NUMBER
STD_ET0	False	NUMBER
STD_RADIATION	False	NUMBER
STD_SNOWDEPTH	True	NUMBER
STD_SNOWWEQ	True	NUMBER
STD_TOTALCLOUD	True	NUMBER
NUM_TEMPERATURE_MAX	False	NUMBER
NUM_TEMPERATURE_MIN	False	NUMBER
NUM_TEMPERATURE_AVG	False	NUMBER
NUM_TEMPERATURE_DEW	False	NUMBER
NUM_VAPOURPRESSURE	False	NUMBER
NUM_WINDSPEED	False	NUMBER
NUM_PRECIPITATION	False	NUMBER
NUM_E0	False	NUMBER
NUM_ES0	False	NUMBER
NUM_ET0	False	NUMBER
NUM_RADIATION	False	NUMBER
NUM_SNOWDEPTH	True	NUMBER
NUM_SNOWWEQ	True	NUMBER
NUM_TOTALCLOUD	True	NUMBER

WEATHER_ERA_REGIONCOVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
DAY	False	DATE
TEMPERATURE_MAX	False	NUMBER
TEMPERATURE_MIN	False	NUMBER
TEMPERATURE_AVG	False	NUMBER
TEMPERATURE_DEW	False	NUMBER
VAPOURPRESSURE	False	NUMBER
WINDSPEED	False	NUMBER
PRECIPITATION	False	NUMBER
E0	False	NUMBER
ES0	False	NUMBER
ET0	False	NUMBER
RADIATION	False	NUMBER
SNOWWEQ	True	NUMBER
SNOWDEPTH	True	NUMBER
TOTALCLOUD	True	NUMBER

WEATHER_ERA_REGIONCOVER_LTA

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
AVG_TEMPERATURE_MAX	False	NUMBER
AVG_TEMPERATURE_MIN	False	NUMBER
AVG_TEMPERATURE_AVG	False	NUMBER
AVG_TEMPERATURE_DEW	False	NUMBER
AVG_VAPOURPRESSURE	False	NUMBER
AVG_WINDSPEED	False	NUMBER
AVG_PRECIPITATION	False	NUMBER
AVG_E0	False	NUMBER
AVG_ES0	False	NUMBER
AVG_ET0	False	NUMBER
AVG_RADIATION	False	NUMBER
AVG_SNOWDEPTH	True	NUMBER
AVG_SNOWWEQ	True	NUMBER
AVG_TOTALCLOUD	True	NUMBER
MIN_TEMPERATURE_MAX	False	NUMBER
MIN_TEMPERATURE_MIN	False	NUMBER
MIN_TEMPERATURE_AVG	False	NUMBER
MIN_TEMPERATURE_DEW	False	NUMBER
MIN_VAPOURPRESSURE	False	NUMBER
MIN_WINDSPEED	False	NUMBER
MIN_PRECIPITATION	False	NUMBER
MIN_E0	False	NUMBER
MIN_ES0	False	NUMBER
MIN_ET0	False	NUMBER
MIN_RADIATION	False	NUMBER
MIN_SNOWDEPTH	True	NUMBER
MIN_SNOWWEQ	True	NUMBER
MIN_TOTALCLOUD	True	NUMBER
MAX_TEMPERATURE_MAX	False	NUMBER
MAX_TEMPERATURE_MIN	False	NUMBER
MAX_TEMPERATURE_AVG	False	NUMBER
MAX_TEMPERATURE_DEW	False	NUMBER
MAX_VAPOURPRESSURE	False	NUMBER
MAX_WINDSPEED	False	NUMBER
MAX_PRECIPITATION	False	NUMBER
MAX_E0	False	NUMBER
MAX_ES0	False	NUMBER
MAX_ET0	False	NUMBER
MAX_RADIATION	False	NUMBER
MAX_SNOWDEPTH	True	NUMBER
MAX_SNOWWEQ	True	NUMBER
MAX_TOTALCLOUD	True	NUMBER
STD_TEMPERATURE_MAX	False	NUMBER
STD_TEMPERATURE_MIN	False	NUMBER
STD_TEMPERATURE_AVG	False	NUMBER
STD_TEMPERATURE_DEW	False	NUMBER
STD_VAPOURPRESSURE	False	NUMBER
STD_WINDSPEED	False	NUMBER
STD_PRECIPITATION	False	NUMBER
STD_E0	False	NUMBER
STD_ES0	False	NUMBER
STD_ET0	False	NUMBER
STD_RADIATION	False	NUMBER
STD_SNOWDEPTH	True	NUMBER
STD_SNOWWEQ	True	NUMBER
STD_TOTALCLOUD	True	NUMBER
NUM_TEMPERATURE_MAX	False	NUMBER
NUM_TEMPERATURE_MIN	False	NUMBER
NUM_TEMPERATURE_AVG	False	NUMBER
NUM_TEMPERATURE_DEW	False	NUMBER
NUM_VAPOURPRESSURE	False	NUMBER
NUM_WINDSPEED	False	NUMBER
NUM_PRECIPITATION	False	NUMBER
NUM_E0	False	NUMBER
NUM_ES0	False	NUMBER
NUM_ET0	False	NUMBER
NUM_RADIATION	False	NUMBER
NUM_SNOWDEPTH	True	NUMBER
NUM_SNOWWEQ	True	NUMBER
NUM_TOTALCLOUD	True	NUMBER

WEATHER_HIS_GRID

Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
Use: input for crop simulation.
Type: Table
Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	False	NUMBER
DAY	False	DATE
TEMPERATURE_MAX	False	NUMBER	°C	maximum air temperature at 2 m height
TEMPERATURE_MIN	False	NUMBER	°C	minimum air temperature at 2 m height
TEMPERATURE_AVG	False	NUMBER	°C	average air temperature at 2 m height
TEMPERATURE_DEW	False	NUMBER	°C	dewpoint air temperature at 2 m height
VAPOURPRESSURE	False	NUMBER	hPa	mean daily vapour pressure
WINDSPEED	False	NUMBER	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	False	NUMBER	mm.d-1	daily rainfall
E0	False	NUMBER	mm.d-1	daily transpiration of water surface
ES0	False	NUMBER	mm.d-1	daily transpiration of wet bare soil
ET0	False	NUMBER	mm.d-1	daily transpiration of crop canopy
RADIATION	False	NUMBER	kJ.m-2.d-1	daily radiation at surface
SNOWWEQ	True	NUMBER	cm	daily mean snow water equivalent
SNOWDEPTH	True	NUMBER	cm	daily mean snow depth**
TOTALCLOUD	True	NUMBER

<nowiki>*</nowiki> Not available (relevant) in HIS product <nowiki>**</nowiki> Not available in EPS, MON and SEA products

WEATHER_HIS_REGIONCOVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
DAY	False	DATE
TEMPERATURE_MAX	False	NUMBER
TEMPERATURE_MIN	False	NUMBER
TEMPERATURE_AVG	False	NUMBER
TEMPERATURE_DEW	False	NUMBER
VAPOURPRESSURE	False	NUMBER
WINDSPEED	False	NUMBER
PRECIPITATION	False	NUMBER
E0	False	NUMBER
ES0	False	NUMBER
ET0	False	NUMBER
RADIATION	False	NUMBER
SNOWWEQ	True	NUMBER
SNOWDEPTH	True	NUMBER
TOTALCLOUD	True	NUMBER

WEATHER_HRES_GRID

Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
Use: input for crop simulation.
Type: View
Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	True	NUMBER
DAY	True	DATE
TEMPERATURE_MAX	True	NUMBER	°C	maximum air temperature at 2 m height
TEMPERATURE_MIN	True	NUMBER	°C	minimum air temperature at 2 m height
TEMPERATURE_AVG	True	NUMBER	°C	average air temperature at 2 m height
TEMPERATURE_DEW	True	NUMBER	°C	dewpoint air temperature at 2 m height
VAPOURPRESSURE	True	NUMBER	hPa	mean daily vapour pressure
WINDSPEED	True	NUMBER	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	True	NUMBER	mm.d-1	daily rainfall
E0	True	NUMBER	mm.d-1	daily transpiration of water surface
ES0	True	NUMBER	mm.d-1	daily transpiration of wet bare soil
ET0	True	NUMBER	mm.d-1	daily transpiration of crop canopy
RADIATION	True	NUMBER	kJ.m-2.d-1	daily radiation at surface
SNOWDEPTH	True	NUMBER	cm	daily mean snow depth**
SNOWWEQ	True	NUMBER	cm	daily mean snow water equivalent
SNOWDENSITY	True	VARCHAR2
TOTALCLOUD	True	NUMBER
GEOPOTENTIAL350	True	VARCHAR2
GEOPOTENTIAL500	True	VARCHAR2
GEOPOTENTIAL800	True	VARCHAR2
HUMIDITY_06H	True	VARCHAR2
HUMIDITY_09H	True	VARCHAR2
HUMIDITY_12H	True	VARCHAR2
HUMIDITY_15H	True	VARCHAR2
HUMIDITY_18H	True	VARCHAR2

<nowiki>*</nowiki> Not available (relevant) in HIS product <nowiki>**</nowiki> Not available in EPS, MON and SEA products

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

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	True	VARCHAR2
IDCOVER	True	NUMBER
DAY	True	DATE
TEMPERATURE_MAX	True	NUMBER
TEMPERATURE_MIN	True	NUMBER
TEMPERATURE_AVG	True	NUMBER
TEMPERATURE_DEW	True	NUMBER
VAPOURPRESSURE	True	NUMBER
WINDSPEED	True	NUMBER
PRECIPITATION	True	NUMBER
E0	True	NUMBER
ES0	True	NUMBER
ET0	True	NUMBER
RADIATION	True	NUMBER
SNOWDEPTH	True	NUMBER
SNOWWEQ	True	NUMBER
SNOWDENSITY	True	VARCHAR2
TOTALCLOUD	True	NUMBER
GEOPOTENTIAL350	True	VARCHAR2
GEOPOTENTIAL500	True	VARCHAR2
GEOPOTENTIAL800	True	VARCHAR2
HUMIDITY_06H	True	VARCHAR2
HUMIDITY_09H	True	VARCHAR2
HUMIDITY_12H	True	VARCHAR2
HUMIDITY_15H	True	VARCHAR2
HUMIDITY_18H	True	VARCHAR2
SOURCE	True	VARCHAR2

definition:

select
    idregion
  , idcover
  , 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
  , 'ERA REANALISYS'
from weather_era_regioncover
union
select
    idregion
  , idcover
  , 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
  , 'HIS ANALISYS'
from weather_his_regioncover
where day between (select max(day)+1 from weather_era_regioncover) and (select min(day)-1 from weather_ope_regioncover)
union
select
    idregion
  , idcover
  , 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
  , 'OPE DETERMINISTIC FORECAST'
from weather_ope_regioncover

WEATHER_OBS_GRID

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

Structure

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

WEATHER_OBS_GRID_INFO

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
IDGRID	False	NUMBER
DAY	False	DATE	-
TEMPERATURE_GROUP_SOURCE	False	VARCHAR2
TEMPERATURE_STATION_1	False	NUMBER
TEMPERATURE_STATION_2	True	NUMBER
TEMPERATURE_STATION_3	True	NUMBER
TEMPERATURE_STATION_4	True	NUMBER
TEMPERATURE_SCORE	False	NUMBER
PRECIPITATION_SOURCE	False	VARCHAR2
PRECIPITATION_STATION	False	NUMBER
PRECIPITATION_SCORE	False	NUMBER
SNOWDEPTH_SOURCE	True	VARCHAR2
SNOW_STATION	True	NUMBER
SNOW_SCORE	True	NUMBER
HUMIDITY_GROUP_SOURCE	True	VARCHAR2
HUMIDITY_STATION	True	NUMBER
HUMIDITY_SCORE	True	NUMBER
REST_GROUP_SOURCE	False	VARCHAR2
REST_STATION_1	False	NUMBER
REST_STATION_2	True	NUMBER
REST_STATION_3	True	NUMBER
REST_STATION_4	True	NUMBER
REST_SCORE	False	NUMBER

WEATHER_OBS_GRID_LTA

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

Structure

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

<nowiki>*</nowiki> In script changed to 4,2. Not yet installed.

WEATHER_OBS_GRID_LTA_MISS

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: Table
Remarks: filled with procedure lta_missing_grid_weather.sql

Structure

Attribute	Constraint	Type	Unit	Comment
IDREGION	False	VARCHAR2
TOTAL_GRIDS	True	NUMBER	-	total number of grid cells
TOTAL_GRIDS_CC	True	NUMBER	-	total number of grid cells with at least 1 crop calendar
MISSING_GRIDS	True	NUMBER
MISSING_GRIDS_CC	True	NUMBER	-	total number of missing grid cells with at least 1 crop calendar
MISSING_GRIDS_ORIGINAL	True	NUMBER	-	total number of missing grid cells

<nowiki>*</nowiki> 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

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	NUMBER
IDCOVER	False	NUMBER
IDTHRESHOLD	False	NUMBER
MONTH	False	NUMBER
DAYMONTH	False	NUMBER
VALUE	False	NUMBER

WEATHER_OBS_REGCOV_THRESHOLDS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	NUMBER
IDCOVER	False	NUMBER
IDTHRESHOLD	False	NUMBER
DAY	False	DATE
VALUE	False	NUMBER

WEATHER_OBS_REGIONCOVER

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

Structure

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

WEATHER_OBS_REGIONCOVER_LTA

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

Structure

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

WEATHER_OBS_STATION

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

Structure

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

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: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
YEAR	False	NUMBER	-	historic year
IDSTATION	False	NUMBER
AVAILABILITY_TYPE	False	VARCHAR2	-	class e.g. temperature

WEATHER_OBS_STATION_CALCULATED

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: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit	Comment
IDSTATION	False	NUMBER
DAY	False	DATE	-	calendar day
E0	True	NUMBER	mm.d-1	daily transpiration of water surface
ES0	True	NUMBER	mm.d-1	daily transpiration of wet bare soil
ET0	True	NUMBER	mm.d-1	daily transpiration of crop canopy
RADIATION	True	NUMBER	KJ.m-2.d-1	daily radiation at surface

WEATHER_OBS_STATION_ERRAIN

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

Structure

Attribute	Constraint	Type	Unit
IDSTATION	False	NUMBER
DAY	False	DATE	-
PRECIPITATION	True	NUMBER	-
REASON	True	VARCHAR2	-

WEATHER_OBS_STATION_ERRORS

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

Structure

Attribute	Constraint	Type	Unit
IDSTATION	False	NUMBER
DAY	False	DATE	-
CLOUD_TOTAL_24H	True	NUMBER	-
CLOUD_LOW_24H	True	NUMBER	-
CLOUD_MIDDLE_24H	True	NUMBER	-
CLOUD_HIGH_24H	True	NUMBER	-
SUNSHINE	True	NUMBER	-
RADIATION	True	NUMBER	-
TEMPERATURE_MIN	True	NUMBER	-
TEMPERATURE_MAX	True	NUMBER	-
VAPOURPRESSURE	True	NUMBER	-
WINDSPEED	True	NUMBER	-
WINDSPEED_10M	True	NUMBER	-
PRECIPITATION	True	NUMBER	-
TEMPERATURE_06H	True	NUMBER	-
HUMIDITY_06H	True	NUMBER	-
TEMPERATURE_09H	True	NUMBER	-
HUMIDITY_09H	True	NUMBER	-
TEMPERATURE_12H	True	NUMBER	-
HUMIDITY_12H	True	NUMBER	-
TEMPERATURE_15H	True	NUMBER	-
HUMIDITY_15H	True	NUMBER	-
TEMPERATURE_18H	True	NUMBER	-
HUMIDITY_18H	True	NUMBER	-
STATE_SOIL	True	NUMBER	-
VAPOURPRESSURE_DEF	True	NUMBER	-
SLOPE_VP_VS_T	True	NUMBER	-
CLOUD_TOTAL_DAYTIME	True	NUMBER	-
CLOUD_LOW_DAYTIME	True	NUMBER	-
CLOUD_SHADOW	True	NUMBER	-
VISIBILITY	True	NUMBER	-
SNOWDEPTH	True	NUMBER	-

WEATHER_OBS_STATION_INFO

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

Structure

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

In case of precipitation:

0=real observation 06 UTC - 06 UTC next day
1=MOS estimate 06 UTC - 06 UTC next day
2=real observation 00 UTC - 00 UTC
3=real observation 03 UTC - 03 UTC next day
4=real observation 12 UTC previous day - 12 UTC
5=real observation 18 UTC previous day - 18 UTC
6=real observation 21 UTC previous day – 21 UTC

WEATHER_OBS_STATION_INFO_ERR

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDSTATION	False	NUMBER
DAY	False	DATE
CLOUD_TOTAL_24H	True	NUMBER
CLOUD_LOW_24H	True	NUMBER
CLOUD_MIDDLE_24H	True	NUMBER
CLOUD_HIGH_24H	True	NUMBER
SUNSHINE	True	NUMBER
RADIATION	True	NUMBER
TEMPERATURE_MIN	True	NUMBER
TEMPERATURE_MAX	True	NUMBER
VAPOURPRESSURE	True	NUMBER
WINDSPEED	True	NUMBER
WINDSPEED_10M	True	NUMBER
PRECIPITATION	True	NUMBER
TEMPERATURE_06H	True	NUMBER
HUMIDITY_06H	True	NUMBER
TEMPERATURE_09H	True	NUMBER
HUMIDITY_09H	True	NUMBER
TEMPERATURE_12H	True	NUMBER
HUMIDITY_12H	True	NUMBER
TEMPERATURE_15H	True	NUMBER
HUMIDITY_15H	True	NUMBER
TEMPERATURE_18H	True	NUMBER
HUMIDITY_18H	True	NUMBER
STATE_SOIL	True	NUMBER
VAPOURPRESSURE_DEF	True	NUMBER
SLOPE_VP_VS_T	True	NUMBER
CLOUD_TOTAL_DAYTIME	True	NUMBER
CLOUD_LOW_DAYTIME	True	NUMBER
CLOUD_SHADOW	True	NUMBER
VISIBILITY	True	NUMBER
SNOWDEPTH	True	NUMBER

WEATHER_OBS_STATION_LTA

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: Table
Remarks: filled by software tool ReferenceWeather

Structure

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

WEATHER_OBS_STATION_RAW

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

Structure

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

WEATHER_OBS_STATION_TEMP

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDSTATION	False	NUMBER
DAY	False	DATE
PRECIPITATION	True	NUMBER
PRECIPITATION_INFO	True	NUMBER

WEATHER_OPE_GRID

Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
Use: input for crop simulation.
Type: Table
Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	False	NUMBER
DAY	False	DATE
DAYOFFSET	False	NUMBER
IDMEMBER	False	NUMBER
TEMPERATURE_MAX	False	NUMBER	°C	maximum air temperature at 2 m height
TEMPERATURE_MIN	False	NUMBER	°C	minimum air temperature at 2 m height
TEMPERATURE_AVG	False	NUMBER	°C	average air temperature at 2 m height
TEMPERATURE_DEW	False	NUMBER	°C	dewpoint air temperature at 2 m height
VAPOURPRESSURE	False	NUMBER	hPa	mean daily vapour pressure
WINDSPEED	False	NUMBER	m.s-1	mean daily wind speed at 10 m height
PRECIPITATION	False	NUMBER	mm.d-1	daily rainfall
E0	False	NUMBER	mm.d-1	daily transpiration of water surface
ES0	False	NUMBER	mm.d-1	daily transpiration of wet bare soil
ET0	False	NUMBER	mm.d-1	daily transpiration of crop canopy
RADIATION	False	NUMBER	kJ.m-2.d-1	daily radiation at surface
SNOWWEQ	True	NUMBER	cm	daily mean snow water equivalent
SNOWDEPTH	True	NUMBER	cm	daily mean snow depth**
TOTALCLOUD	True	NUMBER

<nowiki>*</nowiki> Not available (relevant) in HIS product <nowiki>**</nowiki> Not available in EPS, MON and SEA products

WEATHER_OPE_REGIONCOVER

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDCOVER	False	NUMBER
DAY	False	DATE
DAYOFFSET	False	NUMBER
IDMEMBER	False	NUMBER
TEMPERATURE_MAX	False	NUMBER
TEMPERATURE_MIN	False	NUMBER
TEMPERATURE_AVG	False	NUMBER
TEMPERATURE_DEW	False	NUMBER
VAPOURPRESSURE	False	NUMBER
WINDSPEED	False	NUMBER
PRECIPITATION	False	NUMBER
E0	False	NUMBER
ES0	False	NUMBER
ET0	False	NUMBER
RADIATION	False	NUMBER
SNOWWEQ	True	NUMBER
SNOWDEPTH	True	NUMBER
TOTALCLOUD	True	NUMBER

other datasets

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

CGMS_SYSLOG

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

Structure

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

DATES_75_15

Description: synonym to oracle package
Use: view on DATE_GENERATOR package
Type: Table
Remarks: none

Structure

Attribute	Constraint	Type	Unit
DAY	False	DATE
DAYNO_WK	False	NUMBER
WEEK	False	NUMBER
DAYNO_MON	False	NUMBER
MONTH	False	NUMBER
DAYNO_YR	False	NUMBER
YEAR	False	NUMBER
DAYNO_DEC	False	NUMBER
DECADE	False	NUMBER
DEC_MONTH	False	VARCHAR2
JULIAN	False	NUMBER	-

GRIDS

Description: definition of agroclimatic grid.
Use: target grid for interpolation of weather- and crop indicators
Type: Materialized View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDGRID	False	NUMBER	-	unique identifier
IDORIGINAL_CODE	False	VARCHAR2	-	unique identifier in CGMS12XXX schema's
LATITUDE	False	NUMBER	decimal degree WGS84
LONGITUDE	False	NUMBER	decimal degree WGS84
ALTITUDE	False	NUMBER	meter	average agricultural altitude
ALTITUDE_16	True	NUMBER	meter	average altitude, calculated from 0.50 dd resolution
ALTITUDE_25	True	NUMBER	meter	average altitude, calculated from 0.25 dd resolution
HAS_LAND	False	VARCHAR2	Y/N	boolean to distinguish land from sea grids
DISTANCE_FROM_COAST	True	NUMBER	km	distance of grid to coastline or large water body
CLIMATE_BARRIER	True	NUMBER	-	unique identifier of uniform weather region where grid belongs to
RESOLUTION	False	NUMBER	depending on unit	value of grid resolution
UNIT	False	VARCHAR2	-	unit of grid resolution

definition:

select
    g.idgrid
  , g.idoriginal_code
  , g.latitude
  , g.longitude
  , g.x
  , g.y
  , 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 lower(grid_source) = lower('EUR')
order by idgrid

HRES_YEARS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
YEAR	True	NUMBER

definition:

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

INTERPOLATION_PARAMETERS

Description: list of interpolation parameters
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Comment
IDINTERPOLATION_PARAMETER	False	NUMBER	interpolation parameter identifier
NAME	False	VARCHAR2	parameter name
VALUE	False	VARCHAR2	parameter value

REGIONS

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDREGION	False	VARCHAR2
IDFATHER	True	NUMBER
REGION	False	VARCHAR2
GLOBAL_NAME	False	VARCHAR2
LOCAL_NAME	True	VARCHAR2
REGION_LEVEL	False	NUMBER
CONTINENT	False	VARCHAR2
POPULATION	True	NUMBER
IDREGION_ELEMENT	False	NUMBER
IDORIGINAL_CODE	False	VARCHAR2

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

Description:
Use:
Type: View
Remarks:

Structure

Attribute	Constraint	Type
IDSTATION	False	NUMBER
STATION	False	VARCHAR2
ORGANIZATION	False	VARCHAR2
IDWMO	True	NUMBER
WMO	True	VARCHAR2
LATITUDE	False	NUMBER
LONGITUDE	False	NUMBER
Y_COORDINATE	False	NUMBER
X_COORDINATE	False	NUMBER
ALTITUDE	False	NUMBER
IDCLIMATE_ZONE	False	NUMBER
COUNTRY	False	VARCHAR2
DISTANCE_TO_COAST	False	NUMBER
ANGSTROM_A	False	NUMBER
ANGSTROM_B	False	NUMBER
SUPIT_A	False	NUMBER
SUPIT_B	False	NUMBER
SUPIT_C	False	NUMBER
HARGREAVES_A	False	NUMBER
HARGREAVES_B	False	NUMBER
RELIABLE_STATIONS	False	NUMBER
ACTIVE_STATIONS	False	NUMBER
AVAIL_PRECIPITATION_THRESHOLD	False	NUMBER
AVAIL_SNOWDEPTH_THRESHOLD	False	NUMBER
AVAIL_TEMPERATURE_THRESHOLD	False	NUMBER
AVAIL_HUMIDITY_THRESHOLD	False	NUMBER
AVAIL_REST_THRESHOLD	False	NUMBER

definition:

select
    idstation
  , station
  , organization
  , idwmo
  , wmo
  , latitude
  , longitude
  , y_coordinate
  , x_coordinate
  , altitude
  , idclimate_zone
  , country
  , distance_to_coast
  , angstrom_a
  , angstrom_b
  , supit_a
  , supit_b
  , supit_c
  , hargreaves_a
  , hargreaves_b
  , reliable_station
  , active_station
  , avail_precipitation_threshold
  , avail_snowdepth_threshold
  , avail_temperature_threshold
  , avail_humidity_threshold
  , avail_rest_threshold
from global_stations s
--where country = 'china'
order by idstation

STAT_REGION_AREAS

Description: year specific crop areas for aggregated crops, their source and calculation method.
Use: Used to aggregate simulated crop results to aggregated crops
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
IDCROP	False	NUMBER	-	aggregated crop number
IDREGION	False	VARCHAR2	-	region number
YEAR	False	NUMBER	-	year for which the area is valid
IDSTATISTIC_SOURCE	False	NUMBER	-	source of the area
IDTREATMENT	False	NUMBER	-	method how area is derived
AREA_CALCULATED	False	NUMBER	-	area expressed as fraction of the total area of the region
AREA_ORIGINAL	True	NUMBER	-	column to keep original area_calculated incase area_calculated is manually updated
NOTE	True	VARCHAR2	-	optional column for comments
ELABORATION	False	DATE	-	date when area_calculated was calculated

SYSTABLES

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit	Comment
TABLE_NAME	False	VARCHAR2	-
HIGHEST_ID	False	NUMBER	-

TASKS

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type	Unit
TASK_ID	False	NUMBER	-
MODEL	False	VARCHAR2	-
DAY	False	DATE
STATUS	False	NUMBER
TIMESTAMP	False	DATE
FRACTION	True	NUMBER
MCOMMENT	True	VARCHAR2	-

WOG

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: Table
Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

Structure

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

WOSC

Description:
Use:
Type: Table
Remarks:

Structure

Attribute	Constraint	Type
IDSTATION	False	NUMBER
DAY	False	DATE
E0	True	NUMBER
ES0	True	NUMBER
ET0	True	NUMBER
RADIATION	True	NUMBER

@@ Line 38: / Line 38: @@
 ! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 |-
-| IDCROP_AGGREGATION || False || NUMBER ||  ||
+| IDCROP_AGGREGATION || False || NUMBER || - || identifier for aggregated crop
 |-
-| IDCROP || False || NUMBER ||  ||
+| IDCROP || False || NUMBER || - || identifier to link statistical crop (EUROSTAT)
 |-
-| IDCROP_PARAMETRIZATION || False || NUMBER ||  ||
+| IDCROP_PARAMETRIZATION || False || NUMBER || - || identifier for simulated crop
 |-
 |}