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

From Agri4castWiki
Jump to: navigation, search
(STATIONS_PER_GRID)
(Undo revision 6723 by Wimdewinter (talk))
 
(536 intermediate revisions by 6 users not shown)
Line 1: Line 1:
===CALCULATED_WEATHER===
+
__NOTOC__
(daily weather derived from other variables)
+
{{Expert}}
 +
===AEZ===
 +
*Description: synonym to oracle package
 +
*Use: use to references the tables {{Object|REGION_DESCRIPTIONS}} and {{Object|REGION_MAPPINGS}}
 +
*Type: synonym on FORALL.REGIONS_ZONES_08
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID      ||NOT NULL||NUMBER              || ||
 +
|-
 +
| REG_CODE        ||NOT NULL||VARCHAR2(10)        || ||
 +
|-
 +
| REG_NAME        ||NOT NULL||VARCHAR2(250)        || ||
 +
|-
 +
| REG_LEVEL      ||NOT NULL||NUMBER              || ||
 +
|-
 +
| BELONGS_TO      ||NOT NULL||VARCHAR2(10)        || ||
 +
|-
 +
| BELONGS_TO_NAME ||NOT NULL||VARCHAR2(250)        || ||
 +
|-
 +
| AREA_HA        ||-||NUMBER              || ||
 +
|-
 +
| AREA_KM2        ||-||NUMBER              || ||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===AGGREGATION_AREAS===
 +
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 +
*Use: used for weighting during aggregating crop indicators towards regional crop indicators
 +
*Type: Permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|CROP_NO  || NOT NULL || NUMBER(4) || - || crop number
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER(10) || - || administrative region id
 +
|-
 +
|YEAR  || NOT NULL || NUMBER(4) || - || year for which cultivated area is valid
 +
|-
 +
|AREA_CULTIVATED  || - || NUMBER || 10^3 ha || cultivated area
 +
|-
 +
|SOURCE*  || NOT NULL || VARCHAR2(40) || - || source from which area was derived
 +
|-
 +
|DAY  || NOT NULL || DATE || - || day on which area was derived
 +
|-
 +
|PERCENTAGE  || - || NUMBER(5,2) || - || percentage of area cultivated; not used; NoData
 +
 
 +
|-
 +
|AREA_ORIGINAL  || - || NUMBER || 10^3 ha || backup to store original cultivated area in this was adapted
 +
 
 +
|-
 +
|TREATMENT  || - || VARCHAR2(50 byte) || - || calculation method
 +
 
 +
|-
 +
|NOTE  || - || VARCHAR2(50 byte) || - || free comments
 +
|}
 +
<nowiki>*</nowiki> 'SOURCE' can have the following values:
 +
* based on EUROSTAT
 +
** EUROSTAT CROPUSE for crops 1,2,3,4,5,6,7,8,9,10,11,12,76,77
 +
** EUROSTAT LANDUSE for crop 50
 +
 
 +
* based on EMU_PLUS_NUTS_LANDCOVER
 +
** CGMS LANDCOVER for crop 51
 +
** LANDCOVER where EUROSTAT is not available and land cover area > 0
 +
** EMU_PLUS_NUTS where EUROSTAT is not available and land cover area = 0 (set to zero)
 +
|}
 +
<br>
 +
 
 +
===CGMS_SYSLOG===
 +
*Description: logging of run options.
 +
*Use: output table containing information on the run executed
 +
*Type: Permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUNID  ||NOT NULL||NUMBER(8)|| - || identification number of run
 +
|-
 +
| DBUSER  ||-||VARCHAR2(20)|| - || username
 +
|-
 +
| RUNDATE  ||-||DATE|| - || run date
 +
|-
 +
| RUNINFO  ||-||VARCHAR2(250)|| - || codes explaining kind of run executed
 +
|-
 +
| CAMPAIGN_START  )||-||VARCHAR2(50)|| - || start month of campaign (agricultural season
 +
|-
 +
| WEATHER_START  ||-||DATE|| - || start date of weather calculations
 +
|-
 +
| WEATHER_END  ||-||DATE|| - || end date of weather calculations
 +
|-
 +
| START_YEAR  ||NOT NULL||NUMBER(4)|| - || year for which simulation is executed
 +
|-
 +
| CAMPAIGN_YEARS  ||NOT NULL||NUMBER(3)|| - || number of campaign years the model is run for
 +
|-
 +
| RUNSTATUS  ||-||VARCHAR2(20)|| - || final status of run
 +
|-
 +
| WEATHER_DATA_SOURCE  ||-||VARCHAR2(20)|| - || source type used for simulation crop yield
 +
|-
 +
| INITIALISATION_WATER_BALANCE  ||NOT NULL||NUMBER(1)|| - || code indication type of water balance initialisations
 +
|-
 +
| GROUND_WATER_BALANCE  ||NOT NULL||NUMBER(1)|| - || code indication usage of ground water balance
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_ADMIN===
 +
*Description: synonym to oracle package
 +
*Use:
 +
*Type: synonym on mrsman.cmeteo_admin
 +
*Remarks: none
 +
<br>
 +
 
 +
===CMETEO_AEZ_GRID_LANDCOVERS===
 +
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 +
*Use: input for cmeteo with standardized attribute names
 +
*Type: view on {{Object|LINK_ AEZ_GRID_LANDCOVER}}
 +
*Remarks: user defined, derived from GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(8) || - || grid number
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER(10) || - || unique region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER(10) || - || landcover code
 +
|-
 +
|AREA  || NOT NULL || NUMBER(10) || m2 || landcover area within intersection of grid cell en region
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_AGGREGATION_AREAS===
 +
*Description: cultivated areas per region used for spatial aggregation of crop indicators
 +
*Use: input for cmeteo, converting names of columns for use in cmeteo package
 +
*Type: view on tables {{Object|AGGREGATION_AREAS}} and {{Object|REGION}}
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| REG_CODE  ||NOT NULL||NUMBER(10)|| - || region code
 +
|-
 +
| YEAR  ||NOT NULL||NUMBER(4)|| - || year for which cultivated area is valid
 +
|-
 +
| AREA_CULTIVATED  ||-||NUMBER||10^3 ha || cultivated area
 +
|}
 +
<nowiki>*</nowiki> All attributes Nullable in table versions
 +
<nowiki>**</nowiki> Not in view, only in table
 +
|}
 +
<br>
 +
 
 +
===CMETEO_CROPS===
 +
*Description: description of crops. Crop name, number, associated crop group and general month.
 +
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
 +
*Type: synonym on table mrsman.cmeteo_crops
 +
*Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||-||NUMBER(10,0)|| - || crop number
 +
|-
 +
| CROP_NAME  ||-||VARCHAR2(40)|| - || name of crop
 +
|-
 +
| CROPGROUP_NO  ||-||NUMBER(2,0)|| - || group where crop belongs to
 +
|-
 +
| CROP_MODEL  of LINGRA (1))||-||NUMBER(1,0)|| - || WOFOST (0
 +
|-
 +
| START_MONTH  ||-||NUMBER(2,0)|| - || start month of crop season
 +
|-
 +
| LANDCOVER_ID||-||NUMBER(10,0)|| - ||
 +
|-
 +
| STARTMONTH_ASIA||-||NUMBER(2,0)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_GRID_LANDCOVER_AREAS===
 +
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 +
*Use: input for cmeteo with standardized attribute names
 +
*Type: synonym on view {{Object|CMETEO_AEZ_GRID_LANDCOVERS}}
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || unique region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landcover code
 +
|-
 +
| AREA  ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_GRID_WEATHER===
 +
*Description: weather indicators per grid
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: synonym on view {{Object|CMETEO_WEATHER_OBS_GRID}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(8,0) || - || grid number
 +
|-
 +
|DAY  || NOT NULL || DATE || - || calendar day
 +
|-
 +
|DAY_OFFSET || - || NUMBER || - ||
 +
|-
 +
|MEMBER_NO || - || NUMBER || - ||
 +
|-
 +
|MAX_TEMPERATURE  || NOT NULL || NUMBER(3,1) || °C || maximum air temperature
 +
|-
 +
|MIN_TEMPERATURE  || NOT NULL || NUMBER(3,1) || °C || minimum air temperature
 +
|-
 +
|MEAN_TEMPERATURE  || - || NUMBER || °C || mean air temperature
 +
|-
 +
|DEW_TEMPERATURE  || - || NUMBER || °C || mean air temperature
 +
|-
 +
|VAPOUR_PRESSURE  || NOT NULL || NUMBER(4,2) || hPa || mean daily vapour pressure
 +
|-
 +
|WIND_SPEED  || NOT NULL || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
|PRECIPITATION  || NOT NULL || NUMBER(4,1) || mm.d-1 || daily rainfall
 +
|-
 +
|E0  || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of water surface
 +
|-
 +
|ES0  || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
|ET0  || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
|GLOBAL_RADIATION  || NOT NULL || NUMBER(6) || kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ  as snow_weq)|||||| to_number(null
 +
|}
 +
<nowiki>*</nowiki> All attributes Nullable in table versions
 +
|}
 +
<br>
 +
 
 +
===CMETEO_LANDCOVERS===
 +
*List of landcovers or crops to be evaluated in [[CMETEO]]
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / {{Object|CROP_LANDCOVER}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
| CROP_NO ||NOT NULL||NUMBER(8)|| - ||
 +
|-
 +
| CROP_NAME    ||NOT NULL||VARCHAR2(40)|| - ||
 +
|}
 +
<nowiki>*</nowiki> All attributes Nullable in table versions
 +
|}
 +
<br>
 +
 
 +
===CMETEO_PROCESS===
 +
*Description: synonym to oracle package
 +
*Use:
 +
*Type: synonym on mrsman.cmeteo_process
 +
*Remarks: none
 +
<br>
 +
 
 +
===CMETEO_REGION_GRID_LANDCOVERS===
 +
*Description: landcover areas for each intersection of grid and administartive region (only level 3).
 +
*Use: input for cmeteo with standardized attribute names
 +
*Type: view on {{Object|LINK_REGION_GRID_LANDCOVER}}
 +
*Remarks: user defined, derived from GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(8) || - || grid number
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER(10) || - || unique region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER(10) || - || landcover code
 +
|-
 +
|AREA  || NOT NULL || NUMBER(10) || m2 || landcover area within intersection of grid cell en region
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_REGION_MAPPINGS===
 +
*Description: regions and their relations (mappings)
 +
*Use: input for cmeteo
 +
*Type: synonym on table {{Object|REGION_MAPPINGS}}
 +
*Remark: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER                || - || region mapping id
 +
|-
 +
| REG_MAP_ID_BT  ||NOT NULL||NUMBER                || - || belongs to region mapping id
 +
|-
 +
| REG_DES_ID  ||NOT NULL||NUMBER                || - || region description id
 +
|-
 +
| REG_LEVEL  ||NOT NULL||NUMBER                || - || region level
 +
|-
 +
| REG_CODE  ||NOT NULL||VARCHAR2(10 BYTE)    || - || region code
 +
|-
 +
| BELONGS_TO  ||NOT NULL||VARCHAR2(10 BYTE)    || - || belongs to region code
 +
|-
 +
| ROI_CODE  ||NOT NULL||VARCHAR2(10 BYTE)    || - || region of interest code
 +
|-
 +
| REG_DES_ID_OLD||-||NUMBER                || - ||
 +
|-
 +
| XMIN_ALT  ||-||NUMBER(20,10)        || - || Alternative bouding box minimum x coordinate
 +
|-
 +
| XMAX_ALT  ||-||NUMBER(20,10)        || - || Alternative bouding box maximum x coordinate
 +
|-
 +
| YMIN_ALT  ||-||NUMBER(20,10)        || - || Alternative bouding box minimum y coordinate
 +
|-
 +
| YMAX_ALT  ||-||NUMBER(20,10)        || - || Alternative bouding box maximum y coordinate
 +
|-
 +
| SRS_CODE_ALT  ||-||VARCHAR2(15 BYTE)    || - || Alternative projection code
 +
|-
 +
| STD_GROUP_NO  ||-||NUMBER                || - || attribute to control parallel processing
 +
|-
 +
| EPS_GROUP_NO  ||-||NUMBER                || - || attribute to control parallel processing
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_REGION_WEATHER===
 +
*Description: weather indicators per region
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: synonym on view  {{Object|CMETEO_WEATHER_OBS_AEZ}}
 +
*Remark: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || agro-environmental region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id
 +
|-
 +
| THRESHOLD  ||NOT NULL||NUMBER(3)|| - || used threshold in percentage
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| DAY_OFFSET  |||||| 0 as day_offset
 +
|-
 +
| MEMBER_NO  |||||| 1 as member_no
 +
|-
 +
| MAX_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature
 +
|-
 +
| MIN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature
 +
|-
 +
| MEAN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature
 +
|-
 +
| DEW_TEMPERATURE  as dew_temperature)||||||  to_number(null
 +
|-
 +
| VAPOUR_PRESSURE  ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure
 +
|-
 +
| WIND_SPEED  ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| GLOBAL_RADIATION  ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ  as snow_weq)|||||| to_number(null
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_REGIONS===
 +
*Description:
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: synonym on mrsman.cmeteo_regions
 +
*Remark: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||-||NUMBER(10,0)        || - || region mapping id
 +
|-
 +
| REG_MAP_ID_BT  ||-||NUMBER(10,0)        || - || belongs to region mapping id
 +
|-
 +
| REG_DES_ID  ||-||NUMBER(10,0)        || - || region description id
 +
|-
 +
| REG_LEVEL  ||-||NUMBER(10,0)        || - || region level
 +
|-
 +
| REG_CODE  ||-||VARCHAR2(10 BYTE)    || - || region code
 +
|-
 +
| ROI_CODE  ||-||VARCHAR2(10 BYTE)    || - || region of interest code
 +
|-
 +
| PART_GROUP        ||-||NUMBER(10,0)        || - ||
 +
|-
 +
| SESSION_CD        ||-||VARCHAR2(30 BYTE)    || - ||
 +
|-
 +
| DT_CREATE        ||-||DATE                || - ||
 +
|-
 +
| SESSION_ID        ||-||NUMBER(15,0)        || - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_REJECTED_WEATHER===
 +
*Description: rejected weather
 +
*Use: log table for cmeteo
 +
*Type: synonym on mrsman.cmeteo_rejected_weather
 +
*Remark: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| DT_MUTATION||-||DATE      || - ||
 +
|-
 +
| REG_MAP_ID||-||NUMBER(10,0)|| - ||
 +
|-
 +
| LANDCOVER_ID||-||NUMBER    || - ||
 +
|-
 +
| THRESHOLD||-||NUMBER    || - ||
 +
|-
 +
| DAY  ||-||DATE      || - || calendar day
 +
|-
 +
| DAY_OFFSET||-||NUMBER    || - ||
 +
|-
 +
| MEMBER_NO||-||NUMBER    || - ||
 +
|-
 +
| MAX_TEMPERATURE  ||-||NUMBER    ||°C || maximum air temperature
 +
|-
 +
| MIN_TEMPERATURE  ||-||NUMBER    ||°C || minimum air temperature
 +
|-
 +
| MEAN_TEMPERATURE  ||-||NUMBER    ||°C || mean air temperature
 +
|-
 +
| DEW_TEMPERATURE  ||-||NUMBER    ||°C || mean air temperature
 +
|-
 +
| VAPOUR_PRESSURE  ||-||NUMBER    ||hPa || mean daily vapour pressure
 +
|-
 +
| WIND_SPEED  ||-||NUMBER    ||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||-||NUMBER    ||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||-||NUMBER    ||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||-||NUMBER    ||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||-||NUMBER    ||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| GLOBAL_RADIATION  ||-||NUMBER    ||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER    ||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ ||-||NUMBER    ||
 +
|-
 +
| ERROR_CODE  ||-||NUMBER    || error code
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_WEATHER_OBS_AEZ===
 +
*Description: weather indicators per agri-environmental region
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: view on {{Object|WEATHER_OBS_AEZ}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || agro-environmental region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id
 +
|-
 +
| THRESHOLD  ||NOT NULL||NUMBER(3)|| - || used threshold in percentage
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| DAY_OFFSET  |||||| 0 as day_offset
 +
|-
 +
| MEMBER_NO  |||||| 1 as member_no
 +
|-
 +
| MAX_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature
 +
|-
 +
| MIN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature
 +
|-
 +
| MEAN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature
 +
|-
 +
| DEW_TEMPERATURE  as dew_temperature)||||||  to_number(null
 +
|-
 +
| VAPOUR_PRESSURE  ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure
 +
|-
 +
| WIND_SPEED  ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| GLOBAL_RADIATION  ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ  as snow_weq)|||||| to_number(null
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_WEATHER_OBS_GRID===
 +
*Description: weather indicators per grid
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: view on table {{Object|WEATHER_OBS_GRID}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| DAY_OFFSET  |||||| 0 as day_offset
 +
|-
 +
| MEMBER_NO  |||||| 1 as member_no
 +
|-
 +
| MAX_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || maximum air temperature
 +
|-
 +
| MIN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || minimum air temperature
 +
|-
 +
| MEAN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature
 +
|-
 +
| DEW_TEMPERATURE  ||||||  0 as dew_temperature
 +
|-
 +
| VAPOUR_PRESSURE  ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure
 +
|-
 +
| WIND_SPEED  ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| GLOBAL_RADIATION  ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ  as snow_weq)|||||| to_number(null
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CMETEO_WEATHER_OBS_REGION===
 +
*Description: weather indicators per region
 +
*Use: input for cmeteo, renaming columns to a standardized naming
 +
*Type: view on {{Object|WEATHER_OBS_REGION}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint* !! Type !! Unit
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region id
 +
|-
 +
| LANDCOVER_NO  ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id
 +
|-
 +
| THRESHOLD  ||NOT NULL||NUMBER(3)|| - || used threshold in percentage
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| DAY_OFFSET  |||||| 0 as day_offset
 +
|-
 +
| MEMBER_NO  |||||| 1 as member_no
 +
|-
 +
| MAX_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature
 +
|-
 +
| MIN_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature
 +
|-
 +
| DAILY_TEMPERATURE  ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature
 +
|-
 +
| DEW_TEMPERATURE  as dew_temperature)||||||  to_number(null
 +
|-
 +
| VAPOUR_PRESSURE  ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure
 +
|-
 +
| WIND_SPEED  ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| GLOBAL_RADIATION  ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOW_DEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| SNOW_WEQ  as snow_weq)|||||| to_number(null
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CROP===
 +
*Description: description of crops. Crop name, number, associated crop group and general month.
 +
*Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
 +
*Type: view on from forall.crop_landcover (subset of FORALL.CROP_LANDCOVER table).
 +
*Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO*  ||-||NUMBER(10,0)|| - || crop number
 +
|-
 +
| CROP_NAME  ||-||VARCHAR2(40)|| - || name of crop
 +
|-
 +
| CROPGROUP_NO  ||-||NUMBER(2,0)|| - || group where crop belongs to
 +
|-
 +
| CROP_MODEL  of LINGRA (1))||-||NUMBER(1,0)|| - || WOFOST (0
 +
|-
 +
| START_MONTH  ||-||NUMBER(2,0)|| - || start month of crop season
 +
|-
 +
| LANDCOVER_ID**  ||-||NUMBER(10,0)|| - || landcover types
 +
|-
 +
|}
 +
<nowiki>*</nowiki> CROP_NO in  <br> 1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51
 +
<nowiki>**</nowiki> LANDCOVER_ID values:
 +
* 101 Arable Land
 +
* 102 Non-irrigated arable land
 +
* 103 Agricultural areas
 +
* 104 Pasture
 +
* 105 Temporary forage
 +
* 106 Rice
 +
|}
 +
<br>
 +
 
 +
===CROP_CALENDAR===
 +
*Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
 +
*Use: determines which crops are simulated for a grid, and simulation period
 +
*Type: Permanent table
 +
*Remarks: user defined, one of the ‘driving’ tables of the system ||
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Constraint !! Type !! Unit
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| VARIETY_NO  ||NOT NULL||NUMBER(4)|| - || variety number
 +
|-
 +
| YEAR  ||NOT NULL||NUMBER(4)|| - || calendar year
 +
|-
 +
| START_TYPE*  ||NOT NULL||VARCHAR2(20 BYTE)|| - || the way crop starts
 +
|-
 +
| START_DATE  ||NOT NULL||DATE|| - || start of planting/sowing window
 +
|-
 +
| START_WINDOW  ||NOT NULL||NUMBER(3)|| number of day's length of planting/sowing window
 +
|-
 +
| END_TYPE**  ||NOT NULL||VARCHAR2(20 BYTE)|| - || the way a crop ends
 +
|-
 +
| END_DATE||NOT NULL||DATE|| - ||
 +
|-
 +
| MAX_DURATION  ||NOT NULL||NUMBER(3)||number of day's maximum duration of crop season
 +
|}
 +
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br>
 +
<nowiki>**</nowiki> possible values: HARVEST, MATURITY, EARLIEST (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
 +
|}
 +
<br>
 +
 
 +
===CROP_GROUP===
 +
*Description: description of crop groups
 +
*Use: input table for the crop group number and name where crop belongs to
 +
*Type: synonym on permanent table FORALL.CROP_GROUP
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|CROPGROUP_NO  || NOT NULL || NUMBER(2) || - || group where crop belongs to
 +
|-
 +
|CROPGROUP_NAME  || NOT NULL || VARCHAR2(40) || - || name of crop group
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CROP_LANDCOVER===
 +
*List of crop and landcovers
 +
*Use: source for various views & synonyms
 +
*Type: synonym & table
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|CROP_NO || NOT NULL || NUMBER(8) || - ||
 +
|-
 +
|CROP_NAME || NOT NULL || VARCHAR2(40) || - ||
 +
|-
 +
|CROPGROUP_NO || NOT NULL || NUMBER(2)  || - ||
 +
|-
 +
|CROP_MODEL || NOT NULL || NUMBER(1) || - ||
 +
|-
 +
|START_MONTH || NOT NULL || NUMBER(2) || - ||
 +
|-
 +
|LANDCOVER_ID || - ||  NUMBER(10) || - ||
 +
|-
 +
|STARTMONTH_ASIA || - || NUMBER(2) || - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CROP_PARAMETER_VALUE===
 +
*Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
 +
*Use: input table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| PARAMETER_CODE  ||NOT NULL||VARCHAR2(20 BYTE)|| - || character code of crop parameter
 +
|-
 +
| PARAMETER_XVALUE  ||NOT NULL||NUMBER(38,6)|| - || crop parameter value
 +
|-
 +
| PARAMETER_YVALUE  ||-||NUMBER(38,6)|| - || crop parameter value - multiple
 +
|}
 +
|}
 +
<br>
 +
 
 +
===CROP_YIELD===
 +
*Description:
 +
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 +
*Type: view on table {{Object|SIMYIELD_EMU}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| DAY||NOT NULL||DATE|| - ||
 +
|-
 +
| DECADE  ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36
 +
|-
 +
| YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===DATA_FOR_YIELD_FORECAST===
 +
*Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).
 +
*Use: table for storing the indicators values that can be used for regression and scenario-analysis (see [[Yield_Forecasting|Yield Forecasting]]).
 +
*Type: Permanent table.
 +
*Remarks: The table is filled and regularly updated with indicator values from table {{Object|SIMYIELD_REGION}}. The table contains the same data as stored in {{Object|SIMYIELD_REGION}}, but in a different structure. This way also new indicators can be added without having to change the structure.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| DECADE||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| STAT_CROP_NO||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| INDICATOR_CODE||NOT NULL||VARCHAR2(50 BYTE)|| - ||
 +
|-
 +
| INDICATOR_VALUE||NOT NULL||NUMBER(8,3)||depends on indicator_code
 +
|}
 +
|}
 +
<br>
 +
 
 +
===DATE_GENERATOR===
 +
*Description: synonym to oracle package
 +
*Use: view on [[DATE_GENERATOR]] package
 +
*Type: synonym on forall.date_generator
 +
*Remarks: none
 +
<br>
 +
 
 +
===DATES_75_15===
 +
*Description: synonym to oracle package
 +
*Use: view on [[DATE_GENERATOR]] package
 +
*Type: synonym on forall.dates_75_15
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| DAY||-||DATE||
 +
|-
 +
| DAYNO_WK||-||NUMBER||
 +
|-
 +
| WEEK||-||NUMBER||
 +
|-
 +
| DAYNO_MON||-||NUMBER||
 +
|-
 +
| MONTH||-||NUMBER||
 +
|-
 +
| DAYNO_YR||-||NUMBER||
 +
|-
 +
| YEAR||-||NUMBER||
 +
|-
 +
| DAYNO_DEC||-||NUMBER||
 +
|-
 +
| DECADE||-||NUMBER||
 +
|-
 +
| DEC_MONTH||-||VARCHAR2(10)||
 +
|-
 +
| JULIAN||-||NUMBER||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===DAY_DECADEYEAR===
 +
*Description: synonym to oracle package
 +
*Use: view on [[DATE_GENERATOR]] package
 +
*Type: synonym on FORALL.DAY_DECADEYEAR
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| DAY||-||DATE||
 +
|-
 +
| DECADE||-||NUMBER||
 +
|-
 +
| YEAR||-||NUMBER||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
 
 +
===GRID_<MODEL>===
 +
*Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
 +
*Use: input for downscaling.
 +
*Type: Permanent table
 +
*Remarks: Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name. The calculation resolution of ECMWF models changes over time and/or forecast depth. In that case different derived elevation models are used stored in separate altitude Attributes with a reference to the ECMWF calculation resolution.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER || - || grid number
 +
|-
 +
|LONGITUDE  || - || DATE || decimal degrees longitude of grid cell centre
 +
|-
 +
|LATITUDE  || - || NUMBER || decimal degrees latitude of grid cell centre
 +
|-
 +
|ALTITUDE*  || - || NUMBER || meters altitude of grid cell centre
 +
|-
 +
|HAS_LAND  ) || - || VARCHAR2(1byte) || - || code indicating grid cell is terrestrial (Y or N
 +
|-
 +
|ALTITUDE_0_16_BASED**  || - || NUMBER || meters altitude of grid cell centre
 +
|-
 +
|ALTITUDE_0_25_BASED***  || - || NUMBER || meters altitude of grid cell centre
 +
|-
 +
|ALTITUDE_0_50_BASED****  || - || NUMBER || meters altitude of grid cell centre
 +
|}
 +
<nowiki>*</nowiki> Available in SEA. Derived from N128 gaussian grid<br>
 +
<nowiki>**</nowiki> Available in HIS & OPE. Derived from N640 gaussian grid<br>
 +
<nowiki>***</nowiki> Available in HIS, OPE, EPS, MON. Derived from N320 gaussian grid<br>
 +
<nowiki>****</nowiki> Available in EPS & MON. Derived from N160 gaussian grid<br>
 +
|}
 +
<br>
 +
 
 +
 
 +
===EMU===
 +
*Description: the intersection of the soil map and the grid
 +
*Use: input/reference table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: user defined, derived from GIS, provides the link to the GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(8) || - || grid number
 +
|-
 +
|SMU_NO  || NOT NULL || NUMBER(8) || - || soil mapping unit number
 +
|-
 +
|AREA  || NOT NULL || NUMBER(10) || - || area of elementary mapping unit
 +
|}
 +
|}
 +
<br>
 +
 
 +
===FOREYIELD_HIS_REGION===
 +
*Description: End of season forecast
 +
*Use: to store forecast results from the [[Software_Tools#CGMS_statistical_tool|CST]] operational batch mode.
 +
*Type: Permanent table
 +
*Remarks: Not used by the user interface and regular batch mode of the [[Software_Tools#CGMS_statistical_tool|CST]] that stores the forecast in table {{Object|FORECASTED_NUTS_YIELD}}.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| MEMBER_NO  ||NOT NULL||NUMBER(2)|| - || identifier for ensemble number*
 +
|-
 +
| FORECASTED_YIELD  ||-||NUMBER(7,3)||10^3 kg.ha forecasted yield, fresh weight
 +
|}
 +
<nowiki>*</nowiki> Forecasts that are based on ECMWF EPS, Montly and Seasonal weather data have multiple weather forecasts (ensembles) that result in just as many different yield forecasts. The different yield forecasts are stored under different member numbers.
 +
|}
 +
<br>
 +
 
 +
===GRID===
 +
*Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
 +
*Use: input/reference table for both level 1 and level 2
 +
*Type: permanent table
 +
*Remarks: user defined, derived from GIS, provides the link to the GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| LATITUDE  ||NOT NULL||NUMBER(8,5)|| - || latitude of grid cell centre
 +
|-
 +
| LONGITUDE  ||NOT NULL||NUMBER(8,5)|| - || longitude of grid cell centre
 +
|-
 +
| ALTITUDE  *||NOT NULL||NUMBER(5)||Meter altitude of grid cell
 +
|-
 +
| CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| DISTANCE_TO_COAST  ||Km || distance from centre of gravity of land part to coast||NOT NULL||NUMBER(5,1
 +
|-
 +
| X_COORDINATE||NOT NULL||NUMBER(*,0)|| - ||
 +
|-
 +
| Y_COORDINATE||NOT NULL||NUMBER(*,0)|| - ||
 +
|}
 +
<nowiki>*</nowiki> Not a simple average (see 'Similarity score' in paragraph [[Interpolation of observed weather#Qualification of weather stations|Qualification of weather stations]]).
 +
|}
 +
<br>
 +
 
 +
 
 +
===GRID_SEA_DOWN_ALGORITHMS===
 +
*Description: grid specific downscaling equations per OPE grid cell.
 +
*Use: Downscaling SEA model data.
 +
*Type: Permanent table
 +
*Remarks: A similar table exists for the ERA model data. That table is called CGMS_GRID_METH_C.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(38,0) || - || OPE grid no
 +
|-
 +
|T2M_INT  || NOT NULL || NUMBER || - || interval coefficient av. temp.
 +
|-
 +
|T2M_SLOPE  || NOT NULL || NUMBER || - || slope coefficient av. temp.
 +
|-
 +
|T2M_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 av. temp.
 +
|-
 +
|T2M_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 av. temp.
 +
|-
 +
|T2M_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 av. temp.
 +
|-
 +
|T2M_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 av. temp.
 +
|-
 +
|TX_INT  || NOT NULL || NUMBER || - || interval coefficient max. temp.
 +
|-
 +
|TX_SLOPE  || NOT NULL || NUMBER || - || slope coefficient max. temp.
 +
|-
 +
|TX_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 max. temp.
 +
|-
 +
|TX_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 max. temp.
 +
|-
 +
|TX_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 max. temp.
 +
|-
 +
|TX_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 max. temp.
 +
|-
 +
|TD_INT  || NOT NULL || NUMBER || - || interval coefficient dew. temp.
 +
|-
 +
|TD_SLOPE  || NOT NULL || NUMBER || - || slope coefficient dew. temp.
 +
|-
 +
|TD_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 dew. temp.
 +
|-
 +
|TD_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 dew. temp.
 +
|-
 +
|TD_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 dew. temp.
 +
|-
 +
|TD_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 dew. temp.
 +
|-
 +
|RR_INT  || NOT NULL || NUMBER || - || interval coefficient rainfall
 +
|-
 +
|RR_SLOPE  * || NOT NULL || NUMBER || - || slope coefficient rainfall
 +
|-
 +
|RR_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 rainfall
 +
|-
 +
|RR_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 rainfall
 +
|-
 +
|RR_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 rainfall
 +
|-
 +
|RR_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 rainfall
 +
|-
 +
|SSRD_INT  || NOT NULL || NUMBER || - || interval coefficient radiation
 +
|-
 +
|SSRD_SLOPE  || NOT NULL || NUMBER || - || slope coefficient radiation
 +
|-
 +
|SSRD_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 radiation
 +
|-
 +
|SSRD_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 radiation
 +
|-
 +
|SSRD_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 radiation
 +
|-
 +
|SSRD_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 radiation
 +
|-
 +
|SN_INT  || NOT NULL || NUMBER || - || interval coefficient snow water equivalent
 +
|-
 +
|SN_SLOPE  ** || NOT NULL || NUMBER || - || slope coefficient snow water equivalent
 +
|-
 +
|SN_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 snow water equivalent
 +
|-
 +
|SN_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 snow water equivalent
 +
|-
 +
|SN_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 snow water equivalent
 +
|-
 +
|SN_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 snow water equivalent
 +
|-
 +
|FFM_INT  || NOT NULL || NUMBER || - || interval coefficient windspeed
 +
|-
 +
|FFM_SLOPE  || NOT NULL || NUMBER || - || slope coefficient windspeed
 +
|-
 +
|FFM_T1  || NOT NULL || NUMBER || - || seasonal coefficient 1 windspeed
 +
|-
 +
|FFM_T2  || NOT NULL || NUMBER || - || seasonal coefficient 2 windspeed
 +
|-
 +
|FFM_T3  || NOT NULL || NUMBER || - || seasonal coefficient 3 windspeed
 +
|-
 +
|FFM_T4  || NOT NULL || NUMBER || - || seasonal coefficient 4 windspeed
 +
|}
 +
<nowiki>*</nowiki> No real equations do exist for rainfall therefore simple equation y = x is applied<br>
 +
<nowiki>**</nowiki> No real equations do exist for snow water equivalent therefore simple equation y = x is applied<br>
 +
|}
 +
<br>
 +
 
 +
 
 +
===GRID_YIELD===
 +
*Description:
 +
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 +
*Type: view on table {{Object|SIMYIELD_GRID}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || day
 +
|-
 +
| DECADE  ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36
 +
|-
 +
| YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===INITIAL_SOIL_WATER===
 +
*Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
 +
*Use: input for level 2
 +
*Type: Permanent table
 +
*Remarks: user defined
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(8) || - || grid number
 +
|-
 +
|STU_NO  || NOT NULL || NUMBER(8) || - || soil typological unit number
 +
|-
 +
|CROP_NO  || NOT NULL || NUMBER(2) || - || crop number
 +
|-
 +
|YEAR  || NOT NULL || NUMBER(4) || - || calendar year
 +
|-
 +
|ZTI*  || NOT NULL || NUMBER(4,1) || cm || depth of initial ground water table
 +
|-
 +
|DD*  || NOT NULL || NUMBER(4,1) || cm || depth of drainage
 +
|-
 +
|WAV  || NOT NULL || NUMBER(3,1) || cm || water available in potential rooting depth
 +
|-
 +
|GIVEN_STARTDATE_WATBAL  || NOT NULL || DATE || - || date for which WAV is valid
 +
|}
 +
* Set to 999 to avoid the the ground water module being used (see [[Soil_map#Initial_available_soil_water|Initial available soil water]]).
 +
|}
 +
<br>
 +
 
 +
===JSOW===
 +
*Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
 +
*Use:  Input table for calculating one of the [[Crop Simulation]] indicators.
 +
*Type: Permanent table, provided by JRC.
 +
*Remark: Even if the table {{Object|CROP_CALENDAR}} specifies fixed sowing per crop per year, the JSOW table is used to calculate 'rainfall around sowing'.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number, equal to CROP_NO in CROP table
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number, equal to GRID_NO in GRID table
 +
|-
 +
| JSOW  ||NOT NULL||NUMBER(3)||julian day (1-366) day in year
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_AEZ_GRID_LANDCOVER===
 +
*Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
 +
*Use: input for cmeteo
 +
*Type: Permanent table
 +
*Remarks: user defined, derived from GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || agri-environmental region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landcover code
 +
|-
 +
| AREA  ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_EMU_REGION===
 +
*Description: intersection of grid, administrative regions and soil mapping units, and their area.
 +
*Use: input/reference table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region id
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| AREA  ||NOT NULL||NUMBER(10)||m2 || total area of intersection between elementary mapping unit and grid cell
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_EMU_REGION_LANDCOVER===
 +
*Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
 +
*Use: input/reference table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region id
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| AREA  ||NOT NULL||NUMBER(10)||m2 || crop area of intersection between elementary mapping unit and grid cell
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_REGION_GRID_LANDCOVER===
 +
*Description: landcover areas for each intersection of grid and NUTS region (only level 3).
 +
*Use: input for cmeteo
 +
*Type: Permanent table
 +
*Remarks: user defined, derived from GIS
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || unique region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landcover code
 +
|-
 +
| AREA  ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_STATION_GRID===
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 +
|-
 +
| GRID_NO||NOT NULL||NUMBER(8)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LINK_STATION_REGION===
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region id
 +
|-
 +
| REG_MAP_BT  administrative region id)||NOT NULL||NUMBER(10)|| - || belongs to (one level up
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LTA_CROP_YIELDS===
 +
*Description:
 +
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 +
*Type: view on table {{Object|SIMYIELD_EMU_LTA}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| day number in year (1-366
 +
|-
 +
| DECADE  ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LTA_GRID_YIELDS===
 +
*Description:
 +
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 +
*Type: view on table {{Object|SIMYIELD_GRID_LTA}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DECADE  ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LTA_NUTS_YIELDS===
 +
*Description:
 +
*Use: interface between the CGMS12EU database and the [[LTA_YIELD]] package
 +
*Type: view on table {{Object|SIMYIELD_REGION_LTA}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| NUTS_CODE  ||NOT NULL||NUMBER(10)|| - || administrative region code
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| DECADE  ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LTA_YIELD_REGIONS===
 +
*Description: synonym to oracle package
 +
*Use: table for [[LTA_YIELD]] package
 +
*Type: synonym on mrsman.lta_yield_regions
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| SESSION_ID ||-||VARCHAR2(30 BYTE) ||
 +
|-
 +
| REGION_CODE||-||VARCHAR2(10 BYTE) ||
 +
|-
 +
|}
 +
|}
 +
<br>
 +
 
 +
===LTA_YIELD===
 +
*Description: synonym to oracle package
 +
*Use: link to [[LTA_YIELD]] package
 +
*Type: synonym on mrsman.lta_yield
 +
*Remarks: none
 +
<br>
 +
 
 +
===MODEL_EXCL_YEARS===
 +
*Description: By default the years for which no statistical observations are available. But also outliers could be excluded.
 +
*Use: Output of level 3.
 +
*Type: permanent table.
 +
*Remarks: To be able to (re)derive the regression models, the excluded years need to be known.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID  ||NOT NULL||NUMBER|| - || unique identifier
 +
|-
 +
| EXCLUDED_YEAR  ||NOT NULL||NUMBER(4)|| - || years that are excluded from the regression model
 +
|}
 +
|}
 +
<br>
 +
 
 +
===MODEL_INCL_INDICATORS===
 +
*Description: Indicators that are included in the regression model.
 +
*Use: Output of level 3.
 +
*Type: permanent table.
 +
*Remarks: To be able to (re)derive the regression models, the included indicators need to be known.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| INDICATOR_NAME  *||NOT NULL||VARCHAR2(50)|| - || abbreviation of indicator
 +
|-
 +
| MODEL_COEFF  ||NOT NULL||NUMBER|| - || coefficient of included indicator
 +
|}
 +
<nowiki>*</nowiki> In general one or more of the four level 2 indicators:
 +
* PYB (POTENTIAL_YIELD_BIOMASS)
 +
* PYS (POTENTIAL_YIELD_STORAGE)
 +
* WYB (WATER_LIM_YIELD_BIOMASS)
 +
* WYS (WATER_LIM_YIELD_STORAGE)
 +
* any other abbriviation when other indicators are part of the regression models
 +
|}
 +
<br>
 +
 
 +
===MODEL_REGR_INDICATIFS===
 +
*Description: The table stores the models:
 +
*Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
 +
*Type: permanent table.
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID  ||NOT NULL||NUMBER|| - || unique identifier
 +
|-
 +
| START_YEAR  ||NOT NULL||NUMBER(4)|| - || first year used for time trend
 +
|-
 +
| END_YEAR  ||NOT NULL||NUMBER(4)|| - || last year used for time trend
 +
|-
 +
| NUMBER_OF_YEARS  ||NOT NULL||NUMBER(2)|| - || number of included years
 +
|-
 +
| TRANSFORM_YEARS  or no ('None'))||NOT NULL||VARCHAR2(12)|| - || transforme years yes ('Logarithmic'
 +
|-
 +
| YEAR_OFFSET  ||NOT NULL||NUMBER(4)|| - || offset in case of transform years
 +
|-
 +
| ORDER_OF_TIMETREND  , linear (1), quadratic (2))||NOT NULL||NUMBER(1)|| - || no trend (0
 +
|-
 +
| RSQ  ||NOT NULL||NUMBER|| - || R squared
 +
|-
 +
| RSQ_ADJ  ||NOT NULL||NUMBER|| - || Adjusted R squared
 +
|-
 +
| RES_STD_DEV  ||NOT NULL||NUMBER|| - || Residual Standard deviation
 +
|-
 +
| RMSQ_ERR_PRED  ||NOT NULL||NUMBER|| - || Root mean squared error for prediction
 +
|-
 +
| MALLOWS_CP||NOT NULL||NUMBER|| - ||
 +
|-
 +
| MAX_VAR_INFL_FACT||NOT NULL||NUMBER|| - ||
 +
|-
 +
| STD_ERR_PRED_MEAN  ||-||NUMBER|| - || Standard error of prediction
 +
|-
 +
| STD_ERR_PRED_NEW  ||-||NUMBER|| - || Standard error of prediction
 +
|-
 +
| CONST_COEF||-||NUMBER|| - ||
 +
|-
 +
| TIMETREND_LIN||-||NUMBER|| - ||
 +
|-
 +
| TIMETREND_QUAD||-||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===MODEL_SCEN_INDICATIFS===
 +
*Description:
 +
*Use:
 +
*Type: permanent table.
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| START_YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| END_YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUMBER_OF_YEARS||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| TRANSFORM_YEARS||NOT NULL||VARCHAR2(12)|| - ||
 +
|-
 +
| YEAR_OFFSET||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| ORDER_OF_TIMETREND||NOT NULL||NUMBER(1)|| - ||
 +
|-
 +
| RSQ||NOT NULL||NUMBER|| - ||
 +
|-
 +
| RES_STD_DEV||NOT NULL||NUMBER|| - ||
 +
|-
 +
| PCOMP_COUNT||NOT NULL||NUMBER|| - ||
 +
|-
 +
| PERC_EXPL_VARIANCE||NOT NULL||NUMBER|| - ||
 +
|-
 +
| CUTOFFD||NOT NULL||NUMBER|| - ||
 +
|-
 +
| SCEN_MODEL_TYPE||NOT NULL||VARCHAR2(20)|| - ||
 +
|-
 +
| CONST_COEFF||NOT NULL||NUMBER|| - ||
 +
|-
 +
| TIMETREND_LIN||-||NUMBER|| - ||
 +
|-
 +
| TIMETREND_QUAD||-||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===MODEL_SCEN_SIM_YEARS===
 +
*Description:
 +
*Use:
 +
*Type: permanent table.
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| SIMILAR_YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| EUCLID_DISTANCE||NOT NULL||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===MODEL_SETTINGS===
 +
*Description:
 +
*Use:
 +
*Type: permanent table.
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| RUN_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| DESCRIPTION||-||VARCHAR2(255)|| - ||
 +
|-
 +
| STRVALUE||-||VARCHAR2(255)|| - ||
 +
|-
 +
| NUMVALUE||-||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===MONTHDAYTODECADE===
 +
*Description: synonym to oracle package
 +
*Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
 +
*Type: synonym on forall.monthday2decade
 +
*Remarks:
 +
Both month and day must be numeric: month {1..12}, day {1..31}.
 +
No check is performed on valid COMBINATIONS of month and day
 +
If one or both parameters seem invalid then a null-value will be returned
 +
<br>
 +
 
 +
===NUTS_YIELD===
 +
*Description:
 +
*Use: used as interface between the CGMS12EU database and the [[Software_Tools#Marsop3_viewer|viewers]]
 +
*Type: view on table {{Object|SIMYIELD_REGION}}
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || day
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(8)|| - || administrative region code
 +
|-
 +
| YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUTS_CODE  ||NOT NULL||NUMBER(10)|| - || administrative region code
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
|}
 +
|}
 +
 
 +
===PARAMETER_DESCRIPTION===
 +
*Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
 +
*Use: used during system initialisation to correctly interpret the parameter tables
 +
*Type: permanent table
 +
*Remarks: do not change this table
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|PARAMETER_CODE  || NOT NULL || VARCHAR2(20) || - || character code of crop parameter
 +
|-
 +
|MULTIPLE  || NOT NULL || VARCHAR2(1) || - || N = single value, Y = value pairs
 +
|-
 +
|PARAMETER_DESCR  || NOT NULL || VARCHAR2(80) || - || description of crop parameter
 +
|}
 +
|}
 +
<br>
 +
 
 +
===RAIN_OBS_STATION===
 +
*Description: contains the station based 6-hourly rainfall data
 +
*Use: input level 1
 +
*Type: permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER  ||NOT NULL||NUMBER(7)|| - || station number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| HOUR  ||NOT NULL||VARCHAR2(5)|| hh:mm || UTC end time of the 6-hourly period
 +
|-
 +
| PRECIPITATION  ||-||NUMBER(6,2)|| mm/6h 6-hourly rainfall sum
 +
|}
 +
|}
 +
<br>
 +
 
 +
===RAIN_OBS_STATION_INFO===
 +
*Description: table for storing specific metadata for 6-hourly rainfall data (flags)
 +
*Use: meta data
 +
*Type: permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 +
|-
 +
| DAY||NOT NULL||DATE|| - ||
 +
|-
 +
| HOUR||NOT NULL||VARCHAR2(5)|| - ||
 +
|-
 +
| PRECIPITATION  ||-||NUMBER(2)|| - || flag*
 +
|}
 +
<nowiki>*</nowiki> Possible values for precipitation (flags):<br>
 +
1 Changed by meteoroloog <br>
 +
2 Automaticaly corrected <br>
 +
3 Observation <br>
 +
4 Lineair interpolation from observations <br>
 +
5 Interpolated via MOS from observations <br>
 +
6 MOS analyses <br>
 +
 
 +
|}
 +
<br>
 +
 
 +
===RAIN_OBS_STATION_RAW===
 +
*Description: temporary storage before inserting data into RAIN_OBS_STATION(_INFO)
 +
*Use: input level 1
 +
*Type: permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - ||
 +
|-
 +
| DAY||NOT NULL||VARCHAR2(16)|| - ||
 +
|-
 +
| PRECIPITATION||-||NUMBER(6,2)|| - ||
 +
|-
 +
| PRECIPITATION_INFO||-||NUMBER(2)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===REGION===
 +
*Description: Administrative regions
 +
*Use: input for monitoring extreme weather events
 +
*Type: Synonym on view FORALL.REGIONS_EUR12EU which references the FORALL tables {{Object|REGION_DESCRIPTIONS}} and {{Object|REGION_MAPPINGS}}
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER|| - || unique id for region
 +
|-
 +
| REG_MAP_ID_BT  where the administrative region belongs to)||-||NUMBER(10,0)        || - || unique id (one level up
 +
|-
 +
| REG_CODE*  ||NOT NULL||VARCHAR2(10)|| - || unique code for administrative region
 +
|-
 +
| REG_NAME  ||NOT NULL||VARCHAR2(250)|| - || name of administrative region
 +
|-
 +
| REG_LEVEL*  ||NOT NULL||NUMBER|| - || level of administrative region (0-3
 +
|-
 +
| BELONGS_TO*  where the administrative region belongs to)||NOT NULL||VARCHAR2(10)|| - || region code (one level up
 +
|-
 +
| BELONGS_TO_NAME  where the administrative region belongs to)||NOT NULL||VARCHAR2(250)|| - || region name (one level up
 +
|-
 +
| AREA_HA  ||-||NUMBER||ha area in hectare
 +
|-
 +
| AREA_KM2  ||-||NUMBER||km2 || area in square km
 +
|}
 +
<nowiki>*</nowiki> According to the 'NUTS' nomenclature (see [[Administrative_regions]]).
 +
|}
 +
<br>
 +
 
 +
===REGION_MAPPINGS===
 +
*Description: regions and their relations (mappings)
 +
*Use: used by many object to find relation between regions of different levels.
 +
*Type: synonyms on forall.region_mappings_eur
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER                || - || region mapping id
 +
|-
 +
| REG_MAP_ID_BT  ||NOT NULL||NUMBER                || - || belongs to region mapping id
 +
|-
 +
| REG_DES_ID  ||NOT NULL||NUMBER                || - || region description id
 +
|-
 +
| REG_LEVEL  ||NOT NULL||NUMBER                || - || region level
 +
|-
 +
| REG_CODE  ||NOT NULL||VARCHAR2(10 BYTE)    || - || region code
 +
|-
 +
| BELONGS_TO  ||NOT NULL||VARCHAR2(10 BYTE)    || - || belongs to region code
 +
|-
 +
| ROI_CODE  ||NOT NULL||VARCHAR2(10 BYTE)    || - || region of interest code
 +
|-
 +
| REG_DES_ID_OLD||-||NUMBER                || - ||
 +
|-
 +
| XMIN_ALT*  ||-||NUMBER(20,10)        || - || Alternative bouding box minimum x coordinate
 +
|-
 +
| XMAX_ALT*  ||-||NUMBER(20,10)        || - || Alternative bouding box maximum x coordinate
 +
|-
 +
| YMIN_ALT*  ||-||NUMBER(20,10)        || - || Alternative bouding box minimum y coordinate
 +
|-
 +
| YMAX_ALT*  ||-||NUMBER(20,10)        || - || Alternative bouding box maximum y coordinate
 +
|-
 +
| SRS_CODE_ALT*  ||-||VARCHAR2(15 BYTE)    || - || Alternative projection code
 +
|-
 +
| STD_GROUP_NO  ||-||NUMBER                || - || attribute to control parallel processing
 +
|-
 +
| EPS_GROUP_NO  ||-||NUMBER                || - || attribute to control parallel processing
 +
|}
 +
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}.
 +
|}
 +
<br>
 +
 
 +
===REGLISTS===
 +
*Description: synonym to oracle package
 +
*Use: link to [[REGLISTS]]
 +
*Type: synonym on forall.reglists
 +
*Remarks: none
 +
<br>
 +
 
 +
===ROOTING_DEPTH===
 +
*Description: the rooting depth classes and associated rooting depth limits
 +
*Use: reference table used in crop simulation
 +
*Type: permanent table
 +
*Remarks: part of the soil model, can be changed or extended if necessary
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
+
| CLASS  ||NOT NULL||NUMBER(5)|| - || rooting depth class
 
|-
 
|-
|DAY (calendar day) || NOT NULL || DATE || -
+
| MIN_DEPTH  ||NOT NULL||NUMBER(5)||cm || depth to which crop roots extends
 +
|}
 +
|}
 +
<br>
 +
 
 +
===RUN===
 +
*Description:
 +
*Use:
 +
*Type: permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|E0 (daily transpiration of water surface) || - || NUMBER|| mm.d-1
+
| RUN_ID||NOT NULL||NUMBER|| - ||
 
|-
 
|-
|ES0 (daily transpiration of wet bare soil) || - || NUMBER|| mm.d-1
+
| REG_MAP_ID||NOT NULL||NUMBER(10)|| - ||
 
|-
 
|-
|ET0 (daily transpiration of crop canopy) || - || NUMBER|| mm.d-1
+
| STAT_CROP_NO||NOT NULL||NUMBER(4)|| - ||
 
|-
 
|-
|CALCULATED_RADIATION (daily radiation at surface) || - || NUMBER(9) || KJ.m-2.d-1
+
| DECADE||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| ANALYSIS||NOT NULL||VARCHAR2(1)|| - ||
 +
|-
 +
| TARGET_YEAR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| TIMESTAMP||NOT NULL||NUMBER|| - ||
 
|}
 
|}
 +
|}
 +
<br>
  
 +
===SIMULATION_LOG===
 +
*Description: contains information about simulation
 +
*Use: reference table
 +
*Type: permanent table
 +
*Remarks: none
  
===GRID_WEATHER===
+
{|class="collapsing_table collapsible collapsed"
(interpolated daily grid weather)
+
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || -
+
| YEAR||NOT NULL||NUMBER(4)|| - ||
 
|-
 
|-
|DAY (calendar day) || NOT NULL || DATE || -
+
| GRID_NO||NOT NULL||NUMBER(8)|| - ||
 
|-
 
|-
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER(3,1) || °C
+
| CROP_NO||NOT NULL||NUMBER(4)|| - ||
 
|-
 
|-
|MINIMUM_TEMPERATURE (minimum air temperature) || NOT NULL || NUMBER(3,1) || °C
+
| VARIETY_NO||NOT NULL||NUMBER(2)|| - ||
 
|-
 
|-
|VAPOR_PRESSURE (mean daily vapor pressure) || NOT NULL || NUMBER(4,2) || hPa
+
| SOWING_DATE||-||DATE|| - ||
 
|-
 
|-
|WINDSPEED (mean daily wind speed at 10 m height) || NOT NULL || NUMBER(5,1) || m.s-1
+
| EMERGENCE_DATE||-||DATE|| - ||
 
|-
 
|-
|RAINFALL (daily rainfall) || NOT NULL || NUMBER(4,1) || mm.d-1
+
| ANTHESIS_DATE||-||DATE|| - ||
 
|-
 
|-
|E0 (daily transpiration of water surface) || NOT NULL || NUMBER|| mm.d-1
+
| END_DATE||-||DATE|| - ||
 
|-
 
|-
|ES0 (daily transpiration of wet bare soil) || NOT NULL || NUMBER|| mm.d-1
+
| STATUS||-||VARCHAR2(250)|| - ||
 +
|}
 +
 
 +
Possible status messeges:
 +
* BND: Number of leaf classes exceeds 365
 +
* DEC: Exceeded end decade, but not yet lifemax
 +
* DVS: DVS >= DVSEND (development stage)
 +
* EBE: End date before emergence
 +
* EME: Invalid emergence date (either from sowing, or fixed emergence (CC))
 +
* IED: Invalid end date
 +
* LAI: No living leaves (anymore)
 +
* LAY: No soil layers found
 +
* MAX: Exceeded lifemax (as read from database)
 +
* MFI: Maximum Flow Iteration exceeded
 +
* MSL: Number of soil layers exceeds maximum number
 +
* NEQ: Number of simulated rows for potential and water limited not equal
 +
* NGW: No grid weather for this grid
 +
* NSU: No simulation units for this grid
 +
* RDM: Does not coincide with a layer boundary
 +
* SOW: Invalid sowing date (either from variable sowing, or fixed sowing (CC))
 +
* WLG: Crop failure due to waterlogging
 +
* ???: Unknown
 +
|}
 +
<br>
 +
 
 +
===SIMULATION_UNIT===
 +
*Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
 +
*Use: lookup table used during crop simulation
 +
*Type: permanent table
 +
*Remarks: the content of this table is based on the intersection of soil map and climatic grid, excluding intersections (STU's) that are unsuitable for crop growth.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|ET0 (daily transpiration of crop canopy) || NOT NULL || NUMBER|| mm.d-1
+
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 
|-
 
|-
|CALCULATED_RADIATION (daily radiation at surface) || NOT NULL || NUMBER(6) || KJ.m-2.d-1
+
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 
|-
 
|-
|SNOW_DEPTH (daily mean snow depth) || - || NUMBER(6,2) || cm
+
| STU_NO  ||NOT NULL||NUMBER(8)|| - || soil typological unit number
 +
|}
 
|}
 
|}
 +
<br>
  
 +
===SIMYIELD_<MODEL>_EMU===
 +
*Description: results of the crop simulation per emu. Level 2 output based on forecast weather
 +
*Use: output table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
  
===METDATA===
+
{|class="collapsing_table collapsible collapsed"
(daily station weather)
+
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| MEMBER_NO*  ||NOT NULL||NUMBER(2)|| - || member number
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || day
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 
|-
 
|-
|STATION_NUMBER (station number) || NOT NULL || NUMBER(5) || -
+
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 
|-
 
|-
|DAY (calendar day) || NOT NULL || DATE || -
+
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 
|-
 
|-
|CLOUD_24_TOTAL (not used in CGMS) || - || NUMBER(6,2) || oktas
+
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 
|-
 
|-
|CLOUD_24_LOW (not used in CGMS) || - ||NUMBER(6,2) || oktas
+
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 
|-
 
|-
|CLOUD_24_MIDDLE (not used in CGMS) ||- || NUMBER(6,2) || oktas
+
| DEVELOPMENT_STAGE  )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 
|-
 
|-
|CLOUD_24_HIGH (not used in CGMS) || || NUMBER(6,2) || oktas
+
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 
|-
 
|-
|SUNSHINE (daily sunshine duration) (2)|| - || NUMBER(6,2) || h
+
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 
|-
 
|-
|RAD_MEA (daily global radiation at surface) (1) || - || NUMBER(11,2) || KJ.m-2.d-1
+
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 
|-
 
|-
|TEMP_MIN (minimum air temperature) (3,4) || - || NUMBER(6,2) || °C
+
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 
|-
 
|-
|TEMP_MAX (maximum air temperature) (3,4) || - || NUMBER(6,2) || °C
+
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 
|-
 
|-
|VAP_PRES (daily mean vapor pressure) || - || NUMBER(6,2) || hPa
+
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
<nowiki>*</nowiki> Not in SIMYIELD_HIS_EMU table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_EMU has the attribute although also the OPE model does not have members.
 +
|}
 +
<br>
 +
 
 +
===SIMYIELD_EMU===
 +
*Description: results of the crop simulation per emu. Level 2 output based on weather observations
 +
*Use: output table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
|WIND_MEA (not used in CGMS) || - || NUMBER(6,2) || m.s-1
+
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|WIND_10 (daily mean wind speed at 10 m height) || || NUMBER(6,2) || m.s-1
+
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 
|-
 
|-
|RAIN (daily rainfall) || || NUMBER(6,2) || mm.d-1
+
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 
|-
 
|-
|TEMP_06 (not used in CGMS) || - || NUMBER(6,2) || °C
+
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 
|-
 
|-
|HUM_06 (not used in CGMS) || - || NUMBER(6,2) || %
+
| DAY  ||NOT NULL||DATE|| - || day
 
|-
 
|-
|TEMP_09 (not used in CGMS) || - || NUMBER(6,2) || °C
+
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 
|-
 
|-
|HUM_09 (not used in CGMS) || - || NUMBER(6,2) || %
+
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 
|-
 
|-
|TEMP_12 (not used in CGMS) || - || NUMBER(6,2) || °C
+
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 
|-
 
|-
|HUM_12 (not used in CGMS) || - || NUMBER(6,2) || %
+
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 
|-
 
|-
|TEMP_15 (not used in CGMS) || - || NUMBER(6,2) || °C
+
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 
|-
 
|-
|HUM_15 (not used in CGMS) || - || NUMBER(6,2) || %
+
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 
|-
 
|-
|TEMP_18 (not used in CGMS) || - || NUMBER(6,2) || °C
+
| DEVELOPMENT_STAGE  )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 
|-
 
|-
|HUM_18 (not used in CGMS) || - || NUMBER(6,2) || %
+
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 
|-
 
|-
|STATE_SOIL (not used in CGMS) || - || NUMBER(6,2) || -
+
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 
|-
 
|-
|VAP_PRES_DEF (not used in CGMS) || - || NUMBER(6,2) || hPa
+
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 
|-
 
|-
|SLOPE_VP_VS_T (not used in CGMS) || - || NUMBER(6,3) || hPa.°C-1
+
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 
|-
 
|-
|CLOUD_DAYTIME_TOTAL (daily mean of total cloud cover) (3) || - || NUMBER(6,2) || oktas
+
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 
|-
 
|-
|CLOUD_DAYTIME_LOW (not used in CGMS) || - || NUMBER(6,2) || oktas
+
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 
|-
 
|-
|CLOUD_SHADOW (not used in CGMS) || - || NUMBER(6,2) || oktas
+
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 
|-
 
|-
|VISIBILITY (not used in CGMS) || - || NUMBER(6,1) || -
+
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 
|-
 
|-
|SNOW_DEPTH (daily mean snow depth) || - || NUMBER(6,2) || cm
+
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 
|}
 
|}
1 this variable returns directly radiation
+
|}
 +
<br>
  
2 this variable can be used to derive radiation via the angstrom formula
+
===SIMYIELD_EMU_LTA===
 +
*Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
  
3 these variables can be used to derive radiation via the Supit formula
+
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
|}
 +
<br>
 +
 
 +
===SIMYIELD_<MODEL>_GRID===
 +
*Description: results of the crop simulation per grid. Level 2 output, based on forecast weather.
 +
*Use: output table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
  
4 these variables can be used to derive radiation via the Hargreaves formula
+
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| MEMBER_NO*  ||NOT NULL||NUMBER(2)|| - || member number
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || day
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(4)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(8,4)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(8,4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(3,2)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(3,2)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||-||NUMBER(8,3)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||-||NUMBER(8,3)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||||||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||||||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
<nowiki>*</nowiki> Not in SIMYIELD_HIS_GRID table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_GRID has the attribute although also the OPE model does not have members.
 +
|}
 +
<br>
  
 +
===SIMYIELD_GRID===
 +
*Description: results of the crop simulation per grid. Level 2 output, based observed weather.
 +
*Use: output table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: This table contains aggregated simulation results for all PROXY's in {{Object|STAT_CROP}}.
  
===REFERENCE_WEATHER===
+
{|class="collapsing_table collapsible collapsed"
(long term average daily station weather)
+
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|WMO_NO (station number) || NOT NULL || NUMBER(5) || -
+
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 
|-
 
|-
|DAY (calendar day for leap year) || NOT NULL || DATE || -
+
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 
|-
 
|-
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER(3,1) || °C
+
| DAY  ||NOT NULL||DATE|| - || day
 
|-
 
|-
|MINIMUM_TEMPERATURE (minimum air temperature) || NOT NULL || NUMBER(3,1) || °C
+
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 
|-
 
|-
|VAPOR_PRESSURE (mean daily vapor pressure) || NOT NULL || NUMBER(4,2) || hPa
+
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 
|-
 
|-
|WINDSPEED (mean daily wind speed at 10 m height) || NOT NULL || NUMBER(5,1) || m.s-1
+
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight biomass
 
|-
 
|-
|RAINFALL (daily rainfall) || NOT NULL || NUMBER(4,1) || mm.d-1
+
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight storage organs
 
|-
 
|-
|E0 (daily transpiration of water surface) || NOT NULL || NUMBER || mm.d-1
+
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(4)||m2.m2 || potential leaf area divided by surface area
 
|-
 
|-
|ES0 (daily transpiration of wet bare soil) || NOT NULL || NUMBER || mm.d-1
+
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(8,4)||m2.m2 || water limited leaf area divided by surface area
 
|-
 
|-
|ET0 (daily transpiration of closed crop canopy) || NOT NULL || NUMBER || mm.d-1
+
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(8,4)|| - || development stag of crop (0-200
 
|-
 
|-
|CALCULATED_RADIATION (daily radiation at surface) || NOT NULL || NUMBER(9) || KJ.m-2.d-1
+
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 
|-
 
|-
|SNOW_DEPTH (daily mean snow depth) || - || NUMBER(6,2) || cm
+
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(3,2)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(3,2)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||-||NUMBER(8,3)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||-||NUMBER(8,3)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||||||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||||||cm || amount of water drained to the sub soil and therefore lost for the crop
 
|}
 
|}
 +
|}
 +
<br>
  
 +
===SIMYIELD_GRID_LTA===
 +
*Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===SIMYIELD_HIS_EMU_LTA===
 +
*Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
|}
 +
<br>
 +
 +
===SIMYIELD_HIS_GRID_LTA===
 +
*Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===SIMYIELD_HIS_REGION_LTA===
 +
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region code
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===SIMYIELD_REGION===
 +
*Description: results of the crop simulation per administrative region. Level 2 output
 +
*Use: output table for the crop simulation process
 +
*Type: Permanent table
 +
*Remarks: This table contains aggregated simulation results for all CROP_NO's in {{Object|STAT_CROP}}.
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || day
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(8)|| - || administrative region code
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||-||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||-||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
|}
 +
<br>
 +
 +
===SIMYIELD_REGION_LTA===
 +
*Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
 +
*Use:  Output table for the crop simulation process.
 +
*Type: Permanent table
 +
*Remark: -
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| DAY_NO  )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || administrative region code
 +
|-
 +
| POTENTIAL_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass
 +
|-
 +
| POTENTIAL_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs
 +
|-
 +
| WATER_LIM_YIELD_BIOMASS  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass
 +
|-
 +
| WATER_LIM_YIELD_STORAGE  ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
| POTENTIAL_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area
 +
|-
 +
| WATER_LIM_LEAF_AREA_INDEX  ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
| DEVELOPMENT_STAGE  ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200
 +
|-
 +
| RELATIVE_SOIL_MOISTURE  )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point
 +
|-
 +
| TOTAL_WATER_CONSUMPTION  ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration
 +
|-
 +
| TOTAL_WATER_REQUIREMENT  ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration
 +
|-
 +
| FSM  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone
 +
|-
 +
| FSMUR  ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone
 +
|-
 +
| LEAVES_DIED_BY_COLD  ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
| RUNOFF  ||NOT NULL||NUMBER(8,3)||cm || run off
 +
|-
 +
| SOIL_EVAPORATION  ||NOT NULL||NUMBER(8,3)||cm || soil evaporation
 +
|-
 +
| LOSS_TO_SUBSOIL  ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|-
 +
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MIN_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MIN_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MIN_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MIN_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MIN_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MIN_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MIN_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MIN_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| MAX_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| MAX_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| MAX_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| MAX_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| MAX_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| MAX_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| MAX_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| MAX_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(8,3)||kg.ha-1 ||
 +
|-
 +
| STD_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(5,2)||m2.m2 ||
 +
|-
 +
| STD_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STD_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(8,4)|| - ||
 +
|-
 +
| STD_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(8,4)||cm ||
 +
|-
 +
| STD_FSM||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_FSMUR||NOT NULL||NUMBER(3,2)|| - ||
 +
|-
 +
| STD_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(8,3)|| - ||
 +
|-
 +
| STD_RUNOFF||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_SOIL_EVAPORATION||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| STD_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(8,3)||cm ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_BIOMASS||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_YIELD_STORAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_POTENTIAL_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_WATER_LIM_LEAF_AREA_INDEX||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_DEVELOPMENT_STAGE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RELATIVE_SOIL_MOISTURE||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_CONSUMPTION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_TOTAL_WATER_REQUIREMENT||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSM||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_FSMUR||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LEAVES_DIED_BY_COLD||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_RUNOFF||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_SOIL_EVAPORATION||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| NUM_LOSS_TO_SUBSOIL||NOT NULL||NUMBER(4)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===SITE===
 +
*Description: Contains some soil model parameters on a system wide basis
 +
*Use: input table for the crop simulation process
 +
*Type: permanent table
 +
*Remarks: supplied by the user, but rarely changed
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| IFUNRN  ||-||NUMBER(1)|| - || infiltration rate depends on storm size. 0=no, 1 = yes
 +
|-
 +
| NOTINF  ||-||NUMBER(2,1)|| - || non infiltration fration, 0 = infiltration, 1 = no infiltration
 +
|-
 +
| MAX_SURFACE_STORAGE  ||-||NUMBER(5,3)||(cm) maximum surface storage
 +
|}
 +
|}
 +
 +
===SMU_SUITABILITY===
 +
*Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
 +
*Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
 +
*Type: permanent table
 +
*Remarks: this table needs to be recalculated whenever the simulation_unit table changes
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| SMU_NO  ||NOT NULL||NUMBER(8)|| - || soil mapping unit number
 +
|-
 +
| CROPGROUP_NO  ||NOT NULL||NUMBER(2)|| - || group where crop belongs to
 +
|-
 +
| PERCENTAGE  ||NOT NULL||NUMBER(3)|| - || percentage of soil mapping unit suitable for crop group
 +
|}
 +
|}
 +
<br>
 +
 +
===SOIL_ASSOCIATION_COMPOSITION===
 +
*Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
 +
*Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
 +
*Type: permanent table
 +
*Remarks: derived from the soil map
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|SMU_NO  || NOT NULL || NUMBER(8) || - || soil mapping unit number
 +
|-
 +
|STU_NO  || NOT NULL || NUMBER(8) || - || soil typologic unit number
 +
|-
 +
|PERCENTAGE  || NOT NULL || NUMBER(3) || % || share of soil typologic unit in soil mapping unit
 +
|}
 +
|}
 +
<br>
 +
 +
===SOIL_MAPPING_UNIT===
 +
*Description: listing of unique soil mapping units and related countries
 +
*Use: used by the crop growth model
 +
*Type: permanent table
 +
*Remarks: user defined, derived from the soil map
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|SMU_NO  || NOT NULL || NUMBER(8) || - || soil mapping unit number
 +
|-
 +
|COUNTRY_CODE  * || NOT NULL || VARCHAR2(3) || - || country code
 +
|}
 +
|}
 +
<nowiki>*</nowiki> not filled/used
 +
<br>
 +
 +
===SOIL_PHYSICAL_GROUP===
 +
*Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
 +
*Use: used by the crop growth model
 +
*Type: permanent table
 +
*Remarks: user defined, derived from the soil map
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|SOIL_GROUP_NO  || NOT NULL || NUMBER(3) || - || soil physical group number
 +
|-
 +
|PARAMETER_CODE  || NOT NULL || VARCHAR2(30) || - || character code of soil phys. parameter
 +
|-
 +
|PARAMETER_XVALUE  || NOT NULL || NUMBER(38,6) || - || soil phys. parameter value
 +
|-
 +
|PARAMETER_YVALUE  || - || NUMBER(38,6) || - || soil phys. parameter value – multiple
 +
|}
 +
|}
 +
<br>
 +
 +
===SOIL_TYPOLOGIC_UNIT===
 +
*Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
 +
*Use: used by the crop growth model
 +
*Type: permanent table
 +
*Remarks: user defined, derived from the soil map
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|STU_NO  || NOT NULL|| NUMBER(8) || - || soil typologic unit number
 +
|-
 +
|SOIL_WRB  || NOT NULL|| VARCHAR2(8) || - || World Reference Base soil code
 +
|-
 +
|SOIL_WRB_CL  || NOT NULL|| VARCHAR2(1) || - || World Reference Base soil code
 +
|-
 +
|SOIL_FAO90  || NOT NULL|| VARCHAR2(8) || - || FAO 1990 soil code
 +
|-
 +
|SOIL_FAO90_CL  || NOT NULL|| VARCHAR2(1) || - || FAO 1990 soil code
 +
|-
 +
|SOIL  || NOT NULL|| VARCHAR2(8) || - || character code to characterize the soil
 +
|-
 +
|SOIL_FAO85_CL  || NOT NULL|| VARCHAR2(1) || - || FAO 1985 soil code
 +
|-
 +
|SLOPE1  || NOT NULL|| VARCHAR2(1) || - || slope
 +
|-
 +
|TEXT1  || NOT NULL|| VARCHAR2(1) || - || texture of the soil
 +
|-
 +
|PHASE1  || NOT NULL|| VARCHAR2(2) || - || agricultural limitation
 +
|-
 +
|CALCULATED_ROOTING_DEPTH    || NOT NULL|| NUMBER(5) || - || rooting depth class
 +
|-
 +
|SOIL_GROUP_NO  || NOT NULL|| NUMBER(3) || - || soil physical group number
 +
|-
 +
|DRAINAGE  || NOT NULL|| VARCHAR2(2) || - || the drainage of the soil
 +
|-
 +
|ALKALINITY  || NOT NULL|| VARCHAR2(1) || - || alkalinity of the soil
 +
|-
 +
|SALINITY  || NOT NULL|| VARCHAR2(1) || - || salinity of the soil
 +
|}
 +
|}
 +
<br>
 +
 +
===STAT_CROP===
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
*Remarks:
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STAT_CROP_NO||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| STAT_CROP_NAME||NOT NULL||VARCHAR2(40)|| - ||
 +
|-
 +
| CROP_NO||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| CROP_NAME||NOT NULL||VARCHAR2(40)|| - ||
 +
|-
 +
| PROXY||NOT NULL||NUMBER(4)|| - ||
 +
|-
 +
| PROXY_NAME||NOT NULL||VARCHAR2(40)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===STAT_REGION===
 +
*Description: official observed cultivated area and yield
 +
*Use: to derive regression models in [[Yield Forecasting]] module
 +
*Type: Permanent table
 +
*Remarks: none
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STAT_CROP_NO  ||NOT NULL||NUMBER(4)|| - || statistic crop number
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(8)|| - || administrative region code
 +
|-
 +
| YEAR  ||NOT NULL||NUMBER(4)|| - || calendar year
 +
|-
 +
| AREA_CULTIVATED  ||-||NUMBER(10,3)||10^3 ha || acreage cultivated
 +
|-
 +
| OFFICIAL_YIELD  ||-||NUMBER(6,3)||10^3 kg.ha-1 || yield, fresh weight
 +
|-
 +
| ORIGINAL_OFFICIAL_YIELD||-||NUMBER||10^3 kg.ha-1 ||
 +
|}
 +
|}
 +
<br>
 +
 +
===STATION===
 +
*Description: the weather stations and weather station characteristics to be used by the system ||
 +
*Use: used by all of the level 1 steps (additional weather, availability, grid weather)
 +
*Type: permanent table
 +
*Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - ||
 +
|-
 +
| STATION_NAME||NOT NULL||VARCHAR2(32)|| - ||
 +
|-
 +
| ORGANIZATION||NOT NULL||VARCHAR2(32)|| - ||
 +
|-
 +
| WMO_NO||-||NUMBER(5)|| - ||
 +
|-
 +
| WMO_NAME||-||VARCHAR2(32)|| - ||
 +
|-
 +
| LATITUDE  ||NOT NULL||NUMBER(7,5)||dd || latitude
 +
|-
 +
| LONGITUDE  ||NOT NULL||NUMBER(8,5)||dd || longitude
 +
|-
 +
| Y_COORDINATE  ||NOT NULL||NUMBER(13,5)||m || not used in CGMS
 +
|-
 +
| X_COORDINATE  ||NOT NULL||NUMBER(13,5)||m || not used in CGMS
 +
|-
 +
| ALTITUDE  ||NOT NULL||NUMBER(5)||m || altitude
 +
|-
 +
| CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| COUNTRY_CODE  ||NOT NULL||VARCHAR2(26)|| - || country code
 +
|-
 +
| DISTANCE_TO_COAST  ||NOT NULL||NUMBER(4)||km || distance to coast
 +
|-
 +
| ANGSTROM_A||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| ANGSTROM_B||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| SUPIT_A||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| SUPIT_B||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| SUPIT_C||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| HARGREAVES_A||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| HARGREAVES_B||NOT NULL||NUMBER(18,16)|| - ||
 +
|-
 +
| RELIABLE_STATION||NOT NULL||NUMBER(1)|| - ||
 +
|-
 +
| ACTIVE_STATION||NOT NULL||NUMBER(1)|| - ||
 +
|-
 +
| AVAIL_PRECIPITATION_THRESHOLD||NOT NULL||NUMBER(4,1)|| - ||
 +
|-
 +
| AVAIL_SNOWDEPTH_THRESHOLD||NOT NULL||NUMBER(4,1)|| - ||
 +
|-
 +
| AVAIL_TEMPERATURE_THRESHOLD||NOT NULL||NUMBER(4,1)|| - ||
 +
|-
 +
| AVAIL_HUMIDITY_THRESHOLD||NOT NULL||NUMBER(4,1)|| - ||
 +
|-
 +
| AVAIL_REST_THRESHOLD||NOT NULL||NUMBER(4,1)|| - ||
 +
|}
 +
|}
 +
<br>
  
 
===STATIONS_PER_GRID===
 
===STATIONS_PER_GRID===
(stations used for calculation weather per grid cell for historic years)
+
*Description: the stations used for the grid weather interpolation of the historic year.
 +
*Use: output table for the level 1 grid weather calculation
 +
*Type: permanent table
 +
*Remarks: contains both information produced by historical interpolation and current year interpolation.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY||NOT NULL||DATE|| - ||
 +
|-
 +
| PRECIPITATION_STATION  ||NOT NULL||NUMBER(7)|| - || station number used for rainfall
 +
|-
 +
| SNOW_STATION||-||NUMBER(7)|| - ||
 +
|-
 +
| TEMPERATURE_STATION_1  ||NOT NULL||NUMBER(7)|| - || first station used for interpolation temperature
 +
|-
 +
| TEMPERATURE_STATION_2  ||-||NUMBER(7)|| - || second station used for interpolation temperature
 +
|-
 +
| TEMPERATURE_STATION_3  ||-||NUMBER(7)|| - || third station used for interpolation temperature
 +
|-
 +
| TEMPERATURE_STATION_4  ||-||NUMBER(7)|| - || fourth station used for interpolation temperature
 +
|-
 +
| HUMIDITY_STATION||-||NUMBER(7)|| - ||
 +
|-
 +
| REST_STATION_1  ||NOT NULL||NUMBER(7)|| - || first station used for interpolation other variables
 +
|-
 +
| REST_STATION_2  ||-||NUMBER(7)|| - || second station used for interpolation other variables
 +
|-
 +
| REST_STATION_3  ||-||NUMBER(7)|| - || third station used for interpolation other variables
 +
|-
 +
| REST_STATION_4  ||-||NUMBER(7)|| - || fourth station used for interpolation other variables
 +
|-
 +
| PRECIPITATION_SCORE  ||NOT NULL||NUMBER(6,2)||km || similarity score for station used rainfall
 +
|-
 +
| SNOW_SCORE||-||NUMBER(6,2)|| - ||
 +
|-
 +
| TEMPERATURE_SCORE  ||NOT NULL||NUMBER(6,2)||km || similarity score for first station used interpolation temperature
 +
|-
 +
| HUMIDITY_SCORE||-||NUMBER(6,2)|| - ||
 +
|-
 +
| REST_SCORE  ||NOT NULL||NUMBER(6,2)||km || similarity score for first station used interpolation other variables
 +
|}
 +
|}
 +
<br>
 +
 
 +
===STATION_REFERENCE_COEFFICIENTS===
 +
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe
 +
*Use: is used by view SUPIT_REFERENCE_STATIONS
 +
*Type: permanent table
 +
*Remarks: none
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || -
+
| LATITUDE||NOT NULL||NUMBER|| - ||
 
|-
 
|-
|YEAR (year) || NOT NULL || NUMBER(4,0) || -
+
| LONGITUDE||NOT NULL||NUMBER|| - ||
 
|-
 
|-
|RAIN_STATION (station number used for rainfall) || NOT NULL || NUMBER(5,0) || -
+
| ALTITUDE||NOT NULL||NUMBER|| - ||
 
|-
 
|-
|TEMP_STATION_1 (first station used for interpolation temperature) || NOT NULL || NUMBER(5,0) || -
+
| ANGSTROM_A||-||NUMBER|| - ||
 
|-
 
|-
|TEMP_STATION_2 (second station used for interpolation temperature) || - || NUMBER(5,0) || -
+
| ANGSTROM_B||-||NUMBER|| - ||
 
|-
 
|-
|TEMP_STATION_3 (third station used for interpolation temperature) || - || NUMBER(5,0) || -
+
| SUPIT_A||-||NUMBER|| - ||
 
|-
 
|-
|TEMP_STATION_4 (fourth station used for interpolation temperature) || - || NUMBER(5,0) || -
+
| SUPIT_B||-||NUMBER|| - ||
 
|-
 
|-
|REST_STATION_1 (first station used for interpolation other variables) || NOT NULL || NUMBER(5,0) || -
+
| SUPIT_C||-||NUMBER|| - ||
 
|-
 
|-
|REST_STATION_2 (second station used for interpolation other variables) || - || NUMBER(5,0) || -
+
| HARGREAVES_A||-||NUMBER|| - ||
 
|-
 
|-
|REST_STATION_3 (third station used for interpolation other variables) || - || NUMBER(5,0) || -
+
| HARGREAVES_B||-||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===STU_LAYER===
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 
|-
 
|-
|REST_STATION_4 (fourth station used for interpolation other variables) || - || NUMBER(5,0) || -
+
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|RAIN_SCORE (similarity score for station used rainfall) || - || NUMBER(6,2) || km
+
| STU_NO||NOT NULL||NUMBER(8)|| - ||
 
|-
 
|-
|TEMP_SCORE (similarity score for first station used interpolation temperature) || - || NUMBER(6,2) || km
+
| LAYER_NO||NOT NULL||NUMBER(2)|| - ||
 
|-
 
|-
|REST_SCORE (similarity score for first station used interpolation other variables) || - || NUMBER(6,2) || km
+
| THICKNESS||NOT NULL||NUMBER(3)|| - ||
 +
|-
 +
| SOIL_GROUP_NO||NOT NULL||NUMBER(3)|| - ||
 
|}
 
|}
 +
|}
 +
<br>
 +
 +
===SUITABILITY===
 +
*Description: the suitable STUs for each crop _ group
 +
*Use: used to derive the simulation_unit table
 +
*Type: Permanent table
 +
*Remarks: user defined, derived from the soil map
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|CROPGROUP_NO  || NOT NULL || NUMBER(2) || - || group where crop belongs to
 +
|-
 +
|STU_NO  || NOT NULL || NUMBER(8) || - || soil typologic unit number
 +
|}
 +
|}
 +
<br>
  
 
===SUPIT_CONSTANTS===
 
===SUPIT_CONSTANTS===
(constants per station to derive radiation)
+
*Description: the regression constants per weather station used for the estimation of global radiation for the station
 +
*Use: support table program SupitConstant; results are copied to table STATION
 +
*Type: permanent table
 +
*Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
+
| WMO_NO ||-||NUMBER(7)|| - || station number
 
|-
 
|-
|ANGSTROM_A (ångström constant A using sun shine duration) || NOT NULL || NUMBER || -
+
| ANGSTROM_A ||-||NUMBER|| - || ångström constant A using sun shine duration
 
|-
 
|-
|ANGSTROM_B (ångström constant B using sun shine duration) || NOT NULL || NUMBER || -
+
| ANGSTROM_B ||-||NUMBER|| - || ångström constant B using sun shine duration
 
|-
 
|-
|SUPIT_A (supit constant A using cloud cover and temperature) || NOT NULL || NUMBER || -
+
| SUPIT_A ||-||NUMBER|| - || supit constant A using cloud cover and temperature
 
|-
 
|-
|SUPIT_B (supit constant B using cloud cover and temperature) || NOT NULL || NUMBER || -
+
| SUPIT_B ||-||NUMBER|| - || supit constant B using cloud cover and temperature
 
|-
 
|-
|SUPIT_C (supit constant C using cloud cover and temperature) || NOT NULL || NUMBER || KJ.m-2.d-1
+
| SUPIT_C ||-||NUMBER||kJ.m-2.d-1 || supit constant C using cloud cover and temperature
 
|-
 
|-
|HARGREAVES_A (hargreaves constant A using temperature) || NOT NULL || NUMBER || -
+
| HARGREAVES_A ||-||NUMBER|| - || hargreaves constant A using temperature
 
|-
 
|-
|HARGREAVES_B (hargreaves constant B using temperature) || NOT NULL || NUMBER || KJ.m-2.d-1
+
| HARGREAVES_B ||-||NUMBER||kJ.m-2.d-1 || hargreaves constant B using temperature
 +
|}
 
|}
 
|}
 
  
 
===SUPIT_REFERENCE_STATIONS ===
 
===SUPIT_REFERENCE_STATIONS ===
(constants per reference station to derive radiation)
+
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
 +
*Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
 +
*Type: view on table station_reference_coefficients
 +
*Remarks: not normally changed by the user but supplied by the JRC
  
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 
|-
 
|-
|STATION_NAME (station number) || NOT NULL || VARCHAR2(32 BYTE) || -
+
| STATION_NAME ||NOT NULL||VARCHAR2|| - || dummy name
 
|-
 
|-
|LATITUDE (latitude) || NOT NULL || NUMBER(7,5) || dd
+
| LATITUDE ||NOT NULL||NUMBER||dd || latitude
 
|-
 
|-
|LONGITUDE (longitude) || NOT NULL || NUMBER(8,5) || dd
+
| LONGITUDE ||NOT NULL||NUMBER||dd || longitude
 
|-
 
|-
|ALTITUDE (altitude) || NOT NULL || NUMBER(5,0) || m
+
| ALTITUDE ||NOT NULL||NUMBER||m || altitude
 
|-
 
|-
|ANGSTROM_A (angstrom constant A using sun shine duration) || - || NUMBER || -
+
| ANGSTROM_A ||-||NUMBER|| - || angstrom constant A using sun shine duration
 
|-
 
|-
|ANGSTROM_B (angstrom constant B using sun shine duration) || - || NUMBER || -
+
| ANGSTROM_B ||-||NUMBER|| - || angstrom constant B using sun shine duration
 
|-
 
|-
|SUPIT_A (supit constant A using cloud cover and temperature) || - || NUMBER || -
+
| SUPIT_A ||-||NUMBER|| - || supit constant A using cloud cover and temperature
 
|-
 
|-
|SUPIT_B (supit constant B using cloud cover and temperature) || - ||NUMBER || -
+
| SUPIT_B ||-||NUMBER|| - || supit constant B using cloud cover and temperature
 
|-
 
|-
|SUPIT_C (supit constant C using cloud cover and temperature) || - || NUMBER || KJ.m-2.d-1
+
| SUPIT_C ||-||NUMBER||kJ.m-2.d-1 || supit constant C using cloud cover and temperature
 
|-
 
|-
|HARGREAVES_A (hargreaves constant A using temperature) || - || NUMBER || -
+
| HARGREAVES_A ||-||NUMBER|| - || hargreaves constant A using temperature
 
|-
 
|-
|HARGREAVES_B (hargreaves constant A using temperature) || - || NUMBER || KJ.m-2.d-1
+
| HARGREAVES_B ||-||NUMBER||kJ.m-2.d-1 || hargreaves constant A using temperature
 +
|}
 
|}
 
|}
 +
<br>
  
 +
===SYE===
 +
*Description: table for storing temporary results during [[Crop_Simulation]]. When the calculation is finshed, all records are inserted into {{Object|SIMYIELD_EMU}} overwriting old results.
 +
*Use: temporary output table for the calculation of crop indicators.
 +
*Type: Permanent table
 +
*Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|CROP_NO  || NOT NULL || NUMBER(38,0) || - || crop number
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER(38,0) || - || grid number
 +
|-
 +
|SMU_NO  || NOT NULL || NUMBER(38,0) || - || soil mapping unit number
 +
|-
 +
|DAY  || NOT NULL || DATE || - || day
 +
|-
 +
|POTENTIAL_YIELD_BIOMASS  || NOT NULL || NUMBER || kg.ha-1 || potential dry weight biomass
 +
|-
 +
|POTENTIAL_YIELD_STORAGE  || NOT NULL || NUMBER || kg.ha-1 || potential dry weight storage organs
 +
|-
 +
|WATER_LIM_YIELD_BIOMASS  || NOT NULL || NUMBER || kg.ha-1 || water limited dry weight biomass
 +
|-
 +
|WATER_LIM_YIELD_STORAGE  || NOT NULL || NUMBER || kg.ha-1 || water limited dry weight storage organs
 +
|-
 +
|POTENTIAL_LEAF_AREA_INDEX  || NOT NULL || NUMBER || m2.m2 || potential leaf area divided by surface area
 +
|-
 +
|WATER_LIM_LEAF_AREA_INDEX  || NOT NULL || NUMBER || m2.m2 || water limited leaf area divided by surface area
 +
|-
 +
|DEVELOPMENT_STAGE  ) || NOT NULL || NUMBER || - || development stag of crop (0-200
 +
|-
 +
|RELATIVE_SOIL_MOISTURE  ) || NOT NULL || NUMBER || - || percentage of (field capacity minus wilting point
 +
|-
 +
|TOTAL_WATER_CONSUMPTION  || NOT NULL || NUMBER || cm || sum of water limited transpiration
 +
|-
 +
|TOTAL_WATER_REQUIREMENT  || NOT NULL || NUMBER || cm || sum of potential transpiration
 +
|-
 +
|FSM  || NOT NULL || NUMBER || - || folumetric soil moisture content in rooted zone
 +
|-
 +
|FSMUR  || NOT NULL || NUMBER || - || volumetric soil moisture content in not rooted zone
 +
|-
 +
|LEAVES_DIED_BY_COLD  || - || NUMBER || - || fraction of leaves died by cold wrt total biomass
 +
|-
 +
|RUNOFF  || - || NUMBER || cm || run off
 +
|-
 +
|SOIL_EVAPORATION  || - || NUMBER || cm || soil evaporation
 +
|-
 +
|LOSS_TO_SUBSOIL  || - || NUMBER || cm || amount of water drained to the sub soil and therefore lost for the crop
 +
|}
 +
|}
 +
<br>
  
 
===SYSCON===
 
===SYSCON===
(description of system variables)
+
*Description: contains system parameters
 +
*Use: upon system initialisation
 +
*Type: permanent table
 +
*Remarks: user defined
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|SNAME  || NOT NULL || VARCHAR2(30) || - || name of variable
 +
|-
 +
|SVALUE  || NOT NULL || VARCHAR2(30) || - || value of variable
 +
|}
 +
|}
 +
 
 +
===SYSTABLES===
 +
*Description:
 +
*Use:
 +
*Type: permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| TABLE_NAME||NOT NULL||VARCHAR2(31)|| - ||
 +
|-
 +
| HIGHEST_ID||NOT NULL||NUMBER(38,0)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===TASKS===
 +
*Description:
 +
*Use:
 +
*Type: permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| TASK_ID||NOT NULL||NUMBER(8)|| - ||
 +
|-
 +
| MODEL||NOT NULL||VARCHAR2(3|| - ||
 +
|-
 +
| MEMBER_NO||NOT NULL||NUMBER(2)|| - ||
 +
|-
 +
| MDATE||NOT NULL||DATE|| - ||
 +
|-
 +
| STATUS_CGMS||NOT NULL||NUMBER(1)|| - ||
 +
|-
 +
| MTIMESTAMP_CGMS||NOT NULL||DATE|| - ||
 +
|-
 +
| STATUS_CST||-||NUMBER(1)|| - ||
 +
|-
 +
| MTIMESTAMP_CST||-||DATE|| - ||
 +
|-
 +
| MCOMMENT||-||VARCHAR2(255|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
===VARIETY_PARAMETER_VALUE===
 +
*Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
 +
*Use: input table for the crop simulation process
 +
*Type: permanent table
 +
*Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in {{Object|CROP_PARAMETER_VALUE}} table). In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| CROP_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| VARIETY_NO  ||NOT NULL||NUMBER(4)|| - || crop number
 +
|-
 +
| PARAMETER_CODE  ||NOT NULL||VARCHAR2(20)|| - || character code of crop parameter
 +
|-
 +
| PARAMETER_XVALUE  ||NOT NULL||NUMBER(38,6)|| - || crop parameter value
 +
|-
 +
| PARAMETER_YVALUE  ||-||NUMBER(38,6)|| - || crop parameter value - multiple
 +
|}
 +
(in case of single parameters PARAMETER_XVALUE gives the value; in case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE)
 +
|}
 +
<br>
 +
 
 +
===VIEWER_REQUESTS===
 +
*Description:
 +
*Use:
 +
*Type: permanent table
 +
*Remarks:
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REQUEST_ID||NOT NULL||NUMBER|| - ||
 +
|-
 +
| URL||NOT NULL||VARCHAR2(4000)|| - ||
 +
|-
 +
| CREATION_TIMESTAMP||NOT NULL||DATE|| - ||
 +
|-
 +
| REQUEST_STATUS||NOT NULL||NUMBER|| - ||
 +
|-
 +
| FILE_PATH||-||VARCHAR2(4000)|| - ||
 +
|-
 +
| ACCESS_TIMESTAMP||NOT NULL||DATE|| - ||
 +
|-
 +
| HIT_COUNT||NOT NULL||NUMBER|| - ||
 +
|}
 +
|}
 +
<br>
 +
 
 +
 
 +
===WEATHER_HIS_GRID_LTA===
 +
*Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
 +
*Use: Monitoring extreme weather events.
 +
*Type: Permanent table
 +
*Remarks: Long term average is only available for the HIS model (see [[Weather_Monitoring#Forecasted weather|forecasted weather]]).
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER || - || grid number
 +
|-
 +
|DAY_NO  || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd
 +
|-
 +
|TEMPERATURE_AVG  || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MAX  || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || NOT NULL  || NUMBER(3,1) || °C || average minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height
 +
|-
 +
|PRECIPITATION  || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall
 +
|-
 +
|RADIATION  || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER(6,2) || cm || average daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH  || - || NUMBER(6,2) || cm || average daily mean snow depth
 +
|-
 +
|WINDSPEED  || NOT NULL  || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height
 +
|-
 +
|VAPOURPRESSURE  || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure
 +
|-
 +
|E0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface
 +
|-
 +
|ES0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil
 
|-
 
|-
|SNAME (name of variable) || NOT NULL || VARCHAR2(30) || -
+
|ET0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy
 
|-
 
|-
|SVALUE (value of variable) || NOT NULL || VARCHAR2(30) || -
+
|FRAC_DAYS_MAX_TEMP_GE_25  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_30  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_35  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C
 +
|-
 +
|FRAC_AREA_TEMP_MAX_GE_40  || - || NUMBER(3,2) || - || fraction of area with maximum temperature >= 40°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_0  || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN8  || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN10  || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN18  || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN20  || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_1  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_3  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_5  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_10  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_15  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_30  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm
 +
|-
 +
|AVG_TEMP_GE_0  || - || NUMBER(3,1) || °C || average temperature above 0°C
 +
|-
 +
|AVG_TEMP_GE_2  || - || NUMBER(3,1) || °C || average temperature above 2°C
 +
|-
 +
|AVG_TEMP_GE_4  || - || NUMBER(3,1) || °C || average temperature above 4°C
 +
|-
 +
|AVG_TEMP_GE_6  || - || NUMBER(3,1) || °C || average temperature above 6°C
 +
|-
 +
|AVG_TEMP_GE_8  || - || NUMBER(3,1) || °C || average temperature above 8°C
 +
|-
 +
|AVG_TEMP_GE_10  || - || NUMBER(3,1) || °C || average temperature above 10°C
 
|}
 
|}
 +
|}
 +
<br>
  
===WEATHER_DATA_AVAILABILITY===
+
===WEATHER_HIS_REGION_LTA===
(availability of stations for interpolation)
+
*Description: long term average forecasted weather per day and administrative region.
 +
*Use: Monitoring extreme weather events.
 +
*Type: Permanent table
 +
*Remarks: Long term average is only available for the HIS model (see [[Weather_Monitoring#Forecasted weather|forecasted weather]]).
 +
 
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 
{|class="wikitable"
 
{|class="wikitable"
!Field !! Contraint !! Type !! Unit
+
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER || - || administrative region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER || - || landcover mask / crop mask id
 +
|-
 +
|THRESHOLD  || NOT NULL || NUMBER || - || used threshold in percentage
 +
|-
 +
|DAY_NO  || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd
 +
|-
 +
|TEMPERATURE_MAX  || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || NOT NULL  || NUMBER(3,1) || °C || average minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_AVG  || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height
 +
|-
 +
|VAPOURPRESSURE  || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure
 +
|-
 +
|WINDSPEED  || NOT NULL  || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height
 +
|-
 +
|PRECIPITATION  || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall
 +
|-
 +
|E0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface
 +
|-
 +
|ES0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil
 +
|-
 +
|ET0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy
 +
|-
 +
|RADIATION  || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER(6,2) || cm || average daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH  || - || NUMBER(6,2) || cm || average daily mean snow depth
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_25  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_30  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_35  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C
 
|-
 
|-
|YEAR (year) || NOT NULL || NUMBER(4,0) || -
+
|FRAC_DAYS_MAX_TEMP_GE_40  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 40°C
 
|-
 
|-
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
+
|FRAC_DAYS_MIN_TEMP_LE_0  || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C
 
|-
 
|-
|AVAILABILITY_TYPE (group of variable(s)) || NOT NULL || VARCHAR2(30) || -
+
|FRAC_DAYS_MIN_TEMP_LE_MIN8  || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN10  || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN18  || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN20  || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_1  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_3  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_5  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_10  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_15  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_30  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm
 +
|-
 +
|AVG_TEMP_GE_0  || - ||NUMBER(3,1) || °C || average temperature above 0°C
 +
|-
 +
|AVG_TEMP_GE_2  || - ||NUMBER(3,1) || °C || average temperature above 2°C
 +
|-
 +
|AVG_TEMP_GE_4  || - ||NUMBER(3,1) || °C || average temperature above 4°C
 +
|-
 +
|AVG_TEMP_GE_6  || - ||NUMBER(3,1) || °C || average temperature above 6°C
 +
|-
 +
|AVG_TEMP_GE_8  || - ||NUMBER(3,1) || °C || average temperature above 8°C
 +
|-
 +
|AVG_TEMP_GE_10  || - ||NUMBER(3,1) || °C || average temperature above 10°C
 
|}
 
|}
 +
|}
 +
<br>
 +
 +
===WEATHER_HIS_AEZ_LTA===
 +
*Description: long term average forecasted weather per day and agri-environmental region.
 +
*Use: Monitoring extreme weather events.
 +
*Type: Permanent table
 +
*Remarks: Long term average is only available for the HIS model (see [[Weather_Monitoring#Forecasted weather|forecasted weather]]).
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER || - || agri-environmental region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER || - || landcover mask / crop mask id
 +
|-
 +
|THRESHOLD  || NOT NULL || NUMBER || - || used threshold in percentage
 +
|-
 +
|DAY_NO  || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd
 +
|-
 +
|TEMPERATURE_MAX  || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || NOT NULL  || NUMBER(3,1) || °C || average minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_AVG  || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height
 +
|-
 +
|VAPOURPRESSURE  || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure
 +
|-
 +
|WINDSPEED  || NOT NULL  || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height
 +
|-
 +
|PRECIPITATION  || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall
 +
|-
 +
|E0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface
 +
|-
 +
|ES0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil
 +
|-
 +
|ET0  || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy
 +
|-
 +
|RADIATION  || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER(6,2) || cm || average daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH  || - || NUMBER(6,2) || cm || average daily mean snow depth
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_25  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_30  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_35  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C
 +
|-
 +
|FRAC_DAYS_MAX_TEMP_GE_40  || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 40°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_0  || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN8  || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN10  || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN18  || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C
 +
|-
 +
|FRAC_DAYS_MIN_TEMP_LE_MIN20  || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_1  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_3  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_5  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_10  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_15  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm
 +
|-
 +
|FRAC_DAYS_RAINFALL_GE_30  || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm
 +
|-
 +
|AVG_TEMP_GE_0  || - || NUMBER(3,1) || °C || average temperature above 0°C
 +
|-
 +
|AVG_TEMP_GE_2  || - || NUMBER(3,1) || °C || average temperature above 2°C
 +
|-
 +
|AVG_TEMP_GE_4  || - || NUMBER(3,1) || °C || average temperature above 4°C
 +
|-
 +
|AVG_TEMP_GE_6  || - || NUMBER(3,1) || °C || average temperature above 6°C
 +
|-
 +
|AVG_TEMP_GE_8  || - || NUMBER(3,1) || °C || average temperature above 8°C
 +
|-
 +
|AVG_TEMP_GE_10  || - || NUMBER(3,1) || °C || average temperature above 10°C
 +
|}
 +
|}
 +
<br>
 +
 +
 +
===WEATHER_<MODEL>_AEZ===
 +
*Description: forecasted weather per day and agro-environmental region.
 +
*Use: Monitoring extreme weather events.
 +
*Type: Permanent table
 +
*Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. ERA, MON and SEA are not available for agro-environmental regions
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER(10,0) || - || agro-environmental region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER(10,0) || - || landmask / cropmask id
 +
|-
 +
|THRESHOLD  || NOT NULL || NUMBER(3,0) || - || used threshold in percentage
 +
|-
 +
|DAY  || NOT NULL || DATE || - || day of forecast
 +
|-
 +
|DAY_OFFSET *  grid number) || NOT NULL || NUMBER(2,0) || - || day in forecast relative to DAY
 +
|-
 +
|MEMBER_NO *  || NOT NULL || NUMBER(2,0) || - || number of forecast member
 +
|-
 +
|TEMPERATURE_MAX  || - || NUMBER(3,1) || °C || maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || - || NUMBER(3,1) || °C || minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_AVG  || - || NUMBER(3,1) || °C || average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || - || NUMBER(3,1) || °C || dewpoint air temperature at 2 m height
 +
|-
 +
|VAPOURPRESSURE  || - || NUMBER(4,2) || hPa || mean daily vapour pressure
 +
|-
 +
|WINDSPEED  || - || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
|PRECIPITATION  || - || NUMBER(4,1) || mm.d-1 || daily rainfall
 +
|-
 +
|E0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of water surface
 +
|-
 +
|ES0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
|ET0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
|RADIATION  || - || NUMBER(6,0) || kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER(6,2) || cm || daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH **  || - || NUMBER(6,2) || cm || daily mean snow depth
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_25  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_35  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_40  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_0  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN8  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN10  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN18  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN20  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_1  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_3  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_5  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_10  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_15  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm
 +
|-
 +
| AVG_TEMP_GE_0  ||-||NUMBER(3,1)||°C || average temperature above 0°C
 +
|-
 +
| AVG_TEMP_GE_2  ||-||NUMBER(3,1)||°C || average temperature above 2°C
 +
|-
 +
| AVG_TEMP_GE_4  ||-||NUMBER(3,1)||°C || average temperature above 4°C
 +
|-
 +
| AVG_TEMP_GE_6  ||-||NUMBER(3,1)||°C || average temperature above 6°C
 +
|-
 +
| AVG_TEMP_GE_8  ||-||NUMBER(3,1)||°C || average temperature above 8°C
 +
|-
 +
| AVG_TEMP_GE_10  ||-||NUMBER(3,1)||°C || average temperature above 10°C
 +
|}
 +
<nowiki>*</nowiki> Not available (relevant) in HIS products<br>
 +
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
 +
|}
 +
<br>
 +
 +
 +
===WEATHER_<MODEL>_GRID===
 +
*Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
 +
*Use: input for crop simulation.
 +
*Type: Permanent table
 +
*Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|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.
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER || - || grid number
 +
|-
 +
|DAY ) || NOT NULL || DATE || - || start day of forecast (= offset day 0
 +
|-
 +
|DAY_OFFSET *  grid number) || NOT NULL || NUMBER || - || day in forecast relative to DAY
 +
|-
 +
|MEMBER_NO *  || NOT NULL || NUMBER || - || number of forecast member
 +
|-
 +
|TEMPERATURE_AVG  || - || NUMBER || °C || average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MAX  || - || NUMBER || °C || maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || - || NUMBER || °C || minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || - || NUMBER || °C || dewpoint air temperature at 2 m height
 +
|-
 +
|PRECIPITATION  || - || NUMBER || mm.d-1 || daily rainfall
 +
|-
 +
|RADIATION  || - || NUMBER || kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER || cm || daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH **  || - || NUMBER || cm || daily mean snow depth
 +
|-
 +
|WINDSPEED  || - || NUMBER || m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
|VAPOURPRESSURE  || - || NUMBER || hPa || mean daily vapour pressure
 +
|-
 +
|E0  || - || NUMBER || mm.d-1 || daily transpiration of water surface
 +
|-
 +
|ES0  || - || NUMBER || mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
|ET0  || - || NUMBER || mm.d-1 || daily transpiration of crop canopy
 +
|}
 +
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
 +
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
 +
|}
 +
<br>
 +
 +
 +
===WEATHER_<MODEL>_GRID_RAW===
 +
*Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
 +
*Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
 +
*Type: Permanent table
 +
*Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|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.
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|GRID_NO  || NOT NULL || NUMBER || - || grid number
 +
|-
 +
|DAY  ) || NOT NULL || DATE || - || start day of forecast (= offset day 0
 +
|-
 +
|DAY_OFFSET *  grid number) || NOT NULL || NUMBER || - || day in forecast relative to DAY
 +
|-
 +
|MEMBER_NO *  || NOT NULL || NUMBER || - || number of forecast member
 +
|-
 +
|TEMPERATURE_AVG  || - || NUMBER || °C || average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MAX  || - || NUMBER || °C || maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || - || NUMBER || °C || minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || - || NUMBER || °C || dewpoint air temperature at 2 m height
 +
|-
 +
|PRECIPITATION  || - || NUMBER || mm.d-1 || daily rainfall
 +
|-
 +
|RADIATION  || - || NUMBER || kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER || cm || daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH **  || - || NUMBER || cm || daily mean snow depth
 +
|-
 +
|WINDSPEED  || - || NUMBER || m.s-1 || mean daily wind speed at 10 m height
 +
|}
 +
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
 +
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
 +
|}
 +
<br>
 +
 +
 +
===WEATHER_<MODEL>_REGION===
 +
*Description: forecasted weather per day and administrative region.
 +
*Use: Monitoring extreme weather events.
 +
*Type: Permanent table
 +
*Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. MON and SEA are not available for administrative regions
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
|REG_MAP_ID  || NOT NULL || NUMBER(10,0) || - || administrative region id
 +
|-
 +
|LANDCOVER_ID  || NOT NULL || NUMBER(10,0) || - || landmask / cropmask id
 +
|-
 +
|THRESHOLD  || NOT NULL || NUMBER(3,0) || - || used threshold in percentage
 +
|-
 +
|DAY  || NOT NULL || DATE || - || day of forecast
 +
|-
 +
|DAY_OFFSET *  grid number) || NOT NULL || NUMBER(2,0) || - || day in forecast relative to DAY
 +
|-
 +
|MEMBER_NO *  || NOT NULL || NUMBER(2,0) || - || number of forecast member
 +
|-
 +
|TEMPERATURE_MAX  || - || NUMBER(3,1) || °C || maximum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_MIN  || - || NUMBER(3,1) || °C || minimum air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_AVG  || - || NUMBER(3,1) || °C || average air temperature at 2 m height
 +
|-
 +
|TEMPERATURE_DEW  || - || NUMBER(3,1) || °C || dewpoint air temperature at 2 m height
 +
|-
 +
|VAPOURPRESSURE  || - || NUMBER(4,2) || hPa || mean daily vapour pressure
 +
|-
 +
|WINDSPEED  || - || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
|PRECIPITATION  || - || NUMBER(4,1) || mm.d-1 || daily rainfall
 +
|-
 +
|E0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of water surface
 +
|-
 +
|ES0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
|ET0  || - || NUMBER(4,2) || mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
|RADIATION  || - || NUMBER(6,0) || kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
|SNOWWEQ  || - || NUMBER(6,2) || cm || daily mean snow water equivalent
 +
|-
 +
|SNOWDEPTH **  || - || NUMBER(6,2) || cm || daily mean snow depth
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_25  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_35  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_40  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_0  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN8  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN10  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN18  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN20  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_1  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_3  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_5  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_10  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_15  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm
 +
|-
 +
| AVG_TEMP_GE_0  ||-||NUMBER(3,1)||°C || average temperature above 0°C
 +
|-
 +
| AVG_TEMP_GE_2  ||-||NUMBER(3,1)||°C || average temperature above 2°C
 +
|-
 +
| AVG_TEMP_GE_4  ||-||NUMBER(3,1)||°C || average temperature above 4°C
 +
|-
 +
| AVG_TEMP_GE_6  ||-||NUMBER(3,1)||°C || average temperature above 6°C
 +
|-
 +
| AVG_TEMP_GE_8  ||-||NUMBER(3,1)||°C || average temperature above 8°C
 +
|-
 +
| AVG_TEMP_GE_10  ||-||NUMBER(3,1)||°C || average temperature above 10°C
 +
|}
 +
<nowiki>*</nowiki> Not available (relevant) in HIS products<br>
 +
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
 +
|}
 +
<br>
 +
 +
 +
===WEATHER_OBS_AEZ===
 +
*Description: interpolated weather data per grid per agro-environmental egion
 +
*Use: input for monitoring extreme weather events
 +
*Type: Permanent table
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || agro-environmental region id
 +
|-
 +
| LANDCOVER_NO  ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id
 +
|-
 +
| THRESHOLD  ||NOT NULL||NUMBER(3)|| - || used threshold in percentage
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| TEMPERATURE_MAX  ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature
 +
|-
 +
| TEMPERATURE_MIN  ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature
 +
|-
 +
| TEMPERATURE_AVG  ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature
 +
|-
 +
| VAPOURPRESSURE  ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure
 +
|-
 +
| WINDSPEED  ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| RADIATION  ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOWDEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_25  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_35  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_40  ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_0  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN8  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN10  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN18  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN20  ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_1  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_3  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_5  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_10  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_15  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_30  ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm
 +
|-
 +
| AVG_TEMP_GE_0  ||-||NUMBER(3,1)||°C || average temperature above 0°C
 +
|-
 +
| AVG_TEMP_GE_2  ||-||NUMBER(3,1)||°C || average temperature above 2°C
 +
|-
 +
| AVG_TEMP_GE_4  ||-||NUMBER(3,1)||°C || average temperature above 4°C
 +
|-
 +
| AVG_TEMP_GE_6  ||-||NUMBER(3,1)||°C || average temperature above 6°C
 +
|-
 +
| AVG_TEMP_GE_8  ||-||NUMBER(3,1)||°C || average temperature above 8°C
 +
|-
 +
| AVG_TEMP_GE_10  ||-||NUMBER(3,1)||°C || average temperature above 10°C
 +
|}
 +
|}
 +
<br>
 +
 +
===WEATHER_OBS_AEZ_LTA===
 +
*Description: long term average interpolated weather data per agri-environmental region per day
 +
*Use: Monitoring extreme weather events
 +
*Type: Permanent table
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| REG_MAP_ID  ||NOT NULL||NUMBER(10)|| - || agri-environmental region id
 +
|-
 +
| LANDCOVER_ID  ||NOT NULL||NUMBER(10)|| - || landcover mask / crop mask id
 +
|-
 +
| THRESHOLD  ||NOT NULL||NUMBER(3)|| - || used threshold in percentage
 +
|-
 +
| DAY_NO  ||NOT NULL||VARCHAR2(4)|| - || day of year stored as mmdd
 +
|-
 +
| TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || average maximum air temperature
 +
|-
 +
| TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || average minimum air temperature
 +
|-
 +
| TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || average mean air temperature
 +
|-
 +
| PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || average daily rainfall
 +
|-
 +
| RADIATION  ||-||NUMBER(7,1)||kJ.m-2.d-1 || average daily radiation at surface
 +
|-
 +
| VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || average mean daily vapour pressure
 +
|-
 +
| WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || average mean daily wind speed at 10 m height
 +
|-
 +
| E0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of water surface
 +
|-
 +
| ES0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of crop canopy
 +
|-
 +
| SNOWDEPTH  ||-||NUMBER(6,2)||cm || average daily mean snow depth
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_25  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 25°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_30  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 30°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_35  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 35°C
 +
|-
 +
| FRAC_AREA_TEMP_MAX_GE_40  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 40°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_0  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= 0°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN8  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -8°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN10  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -10°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN18  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -18°C
 +
|-
 +
| FRAC_AREA_TEMP_MIN_LE_MIN20  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -20°C
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_1  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 1mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_3  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 3mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_5  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 5mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_10  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 10mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_15  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 15mm
 +
|-
 +
| FRAC_AREA_PRECIPITATION_GE_30  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 30mm
 +
|-
 +
| AVG_TEMP_GE_0  ||-||NUMBER(3,1)||°C || average temperature above 0°C
 +
|-
 +
| AVG_TEMP_GE_2  ||-||NUMBER(3,1)||°C || average temperature above 2°C
 +
|-
 +
| AVG_TEMP_GE_4  ||-||NUMBER(3,1)||°C || average temperature above 4°C
 +
|-
 +
| AVG_TEMP_GE_6  ||-||NUMBER(3,1)||°C || average temperature above 6°C
 +
|-
 +
| AVG_TEMP_GE_8  ||-||NUMBER(3,1)||°C || average temperature above 8°C
 +
|-
 +
| AVG_TEMP_GE_10  ||-||NUMBER(3,1)|| - || average temperature above 10°C
 +
|-
 +
| MIN_TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || minimum minimum air temperature
 +
|-
 +
| MIN_TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || minimum maximum air temperature
 +
|-
 +
| MIN_TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || minimum mean air temperature
 +
|-
 +
| MIN_PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || minimum daily rainfall
 +
|-
 +
| MIN_RADIATION  ||-||NUMBER(6)||kJ.m-2.d-1 || minimum daily radiation at surface
 +
|-
 +
| MIN_VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || minimum mean daily vapour pressure
 +
|-
 +
| MIN_WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || minimum mean daily wind speed at 10 m height
 +
|-
 +
| MIN_E0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of water surface
 +
|-
 +
| MIN_ES0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of wet bare soil
 +
|-
 +
| MIN_ET0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of crop canopy
 +
|-
 +
| MIN_SNOWDEPTH  ||-||NUMBER(6,2)||cm || minimum daily mean snow depth
 +
|-
 +
| MAX_TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || maximum maximum air temperature
 +
|-
 +
| MAX_TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || maximum maximum air temperature
 +
|-
 +
| MAX_TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || maximum mean air temperature
 +
|-
 +
| MAX_PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || maximum daily rainfall
 +
|-
 +
| MAX_RADIATION  ||-||NUMBER(6)||kJ.m-2.d-1 || maximum daily radiation at surface
 +
|-
 +
| MAX_VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || maximum mean daily vapour pressure
 +
|-
 +
| MAX_WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || maximum mean daily wind speed at 10 m height
 +
|-
 +
| MAX_E0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of water surface
 +
|-
 +
| MAX_ES0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of wet bare soil
 +
|-
 +
| MAX_ET0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of crop canopy
 +
|-
 +
| MAX_SNOW_DEPTH  ||-||NUMBER(6,2)||cm || maximum daily mean snow depth
 +
|-
 +
| STD_TEMPERATURE_MAX  ||-||NUMBER(4,2)||°C || standard deviation of maximum air temperature
 +
|-
 +
| STD_TEMPERATURE_MIN  ||-||NUMBER(4,2)||°C || standard deviation of minimum air temperature
 +
|-
 +
| STD_TEMPERATURE_AVG  ||-||NUMBER(4,2)||°C || standard deviation of mean air temperature
 +
|-
 +
| STD_PRECIPITATION  ||-||NUMBER(5,2)||mm.d-1 || standard deviation of daily rainfall
 +
|-
 +
| STD_RADIATION  ||-||NUMBER(8,1)||kJ.m-2.d-1 || standard deviation of daily radiation at surface
 +
|-
 +
| STD_VAPOURPRESSURE  ||-||NUMBER(6,3)||hPa || standard deviation of mean daily vapour pressure
 +
|-
 +
| STD_WINDSPEED  ||-||NUMBER(6,2)||m.s-1 || standard deviation of mean daily wind speed at 10 m height
 +
|-
 +
| STD_E0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of water surface
 +
|-
 +
| STD_ES0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of wet bare soil
 +
|-
 +
| STD_ET0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of crop canopy
 +
|-
 +
| STD_SNOWDEPTH  ||-||NUMBER(7,3)||cm || standard deviation of daily mean snow depth
 +
|-
 +
| NUM_TEMPERATURE_MIN  ||-||NUMBER(6)|| - || count of air temperature
 +
|-
 +
| NUM_TEMPERATURE_MAX  ||-||NUMBER(6)|| - || count of maximum air temperature
 +
|-
 +
| NUM_TEMPERATURE_AVG  ||-||NUMBER(6)|| - || count of mean air temperature
 +
|-
 +
| NUM_PRECIPITATION  ||-||NUMBER(6)|| - || count of daily rainfall
 +
|-
 +
| NUM_RADIATION  ||-||NUMBER(6)|| - || count of daily radiation at surface
 +
|-
 +
| NUM_VAPOURPRESSURE  ||-||NUMBER(6)|| - || count of mean daily vapour pressure
 +
|-
 +
| NUM_WINDSPEED  ||-||NUMBER(6)|| - || count of mean daily wind speed at 10 m height
 +
|-
 +
| NUM_E0  ||-||NUMBER(6)|| - || count of daily transpiration of water surface
 +
|-
 +
| NUM_ES0  ||-||NUMBER(6)|| - || count of daily transpiration of wet bare soil
 +
|-
 +
| NUM_ET0  ||-||NUMBER(6)|| - || count of daily transpiration of crop canopy
 +
|-
 +
| NUM_SNOWDEPTH  ||-||NUMBER(6)|| - || count of daily mean snow depth
 +
|}
 +
|}
 +
<br>
 +
 +
===WEATHER_OBS_GRID===
 +
*Description: interpolated weather data per grid per day
 +
*Use: output for level 1, input for level 2
 +
*Type: Permanent table
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY  ||NOT NULL||DATE|| - || calendar day
 +
|-
 +
| TEMPERATURE_MAX  ||NOT NULL||NUMBER(3,1)||°C || maximum air temperature
 +
|-
 +
| TEMPERATURE_MIN  ||NOT NULL||NUMBER(3,1)||°C || minimum air temperature
 +
|-
 +
| TEMPERATURE_AVG  ||NOT NULL||NUMBER(3,1)||°C || average air temperature
 +
|-
 +
| HUMIDITY_06H||-||NUMBER(6,2)|| - ||
 +
|-
 +
| HUMIDITY_09H||-||NUMBER(6,2)|| - ||
 +
|-
 +
| HUMIDITY_12H||-||NUMBER(6,2)|| - ||
 +
|-
 +
| HUMIDITY_15H||-||NUMBER(6,2)|| - ||
 +
|-
 +
| HUMIDITY_18H||-||NUMBER(6,2)||
 +
|-
 +
| VAPOURPRESSURE  ||NOT NULL||NUMBER(4,2)||m.s-1 || mean daily vapour pressure
 +
|-
 +
| WINDSPEED  ||NOT NULL||NUMBER(5,1)||hPa || mean daily wind speed at 10 m height
 +
|-
 +
| PRECIPITATION  ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall
 +
|-
 +
| E0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface
 +
|-
 +
| ES0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy
 +
|-
 +
| RADIATION  ||NOT NULL||NUMBER(6)||kJ.m-2.d-1 || daily radiation at surface
 +
|-
 +
| SNOWDEPTH  ||-||NUMBER(6,2)||cm || daily mean snow depth
 +
|}
 +
|}
 +
<br>
 +
 +
===WEATHER_OBS_GRID_INFO===
 +
*Description:
 +
*Use:
 +
*Type: Permanent table
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY||NOT NULL||DATE|| - ||
 +
|-
 +
| PRECIPITATION||NOT NULL||VARCHAR2(10)|| - ||
 +
|-
 +
| SNOWDEPTH||NOT NULL||VARCHAR2(10)|| - ||
 +
|-
 +
| TEMPERATURE_GROUP||NOT NULL||VARCHAR2(10)|| - ||
 +
|-
 +
| HUMIDITY_GROUP||NOT NULL||VARCHAR2(10)|| - ||
 +
|-
 +
| REST_GROUP||NOT NULL||VARCHAR2(10)|| - ||
 +
|}
 +
|}
 +
<br>
 +
 +
===WEATHER_OBS_GRID_LTA===
 +
*Description: long term average interpolated weather data per grid cell per day
 +
*Use: Monitoring extreme weather events
 +
*Type: Permanent table
 +
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
!Attribute !! Contraint !! Type !! Unit !! comment
 +
|-
 +
| GRID_NO  ||NOT NULL||NUMBER(8)|| - || grid number
 +
|-
 +
| DAY_NO  ||NOT NULL||VARCHAR2(4)|| - || day of year stored as mmdd
 +
|-
 +
| TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || average maximum air temperature
 +
|-
 +
| TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || average minimum air temperature
 +
|-
 +
| TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || average mean air temperature
 +
|-
 +
| PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || average daily rainfall
 +
|-
 +
| RADIATION  ||-||NUMBER(7,1)||kJ.m-2.d-1 || average daily radiation at surface
 +
|-
 +
| VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || average mean daily vapour pressure
 +
|-
 +
| WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || average mean daily wind speed at 10 m height
 +
|-
 +
| E0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of water surface
 +
|-
 +
| ES0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of wet bare soil
 +
|-
 +
| ET0  ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of crop canopy
 +
|-
 +
| SNOWDEPTH  ||-||NUMBER(6,2)||cm || average daily mean snow depth
 +
|-
 +
| FRAC_DAYS_TEMP_MAX_GE_25  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 25°C
 +
|-
 +
| FRAC_DAYS_TEMP_MAX_GE_30  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 30°C
 +
|-
 +
| FRAC_DAYS_TEMP_MAX_GE_35  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 35°C
 +
|-
 +
| FRAC_DAYS_TEMP_MAX_GE_40  ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 40°C
 +
|-
 +
| FRAC_DAYS_TEMP_MIN_LE_0  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= 0°C
 +
|-
 +
| FRAC_DAYS_TEMP_MIN_LE_MIN8  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -8°C
 +
|-
 +
| FRAC_DAYS_TEMP_MIN_LE_MIN10  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -10°C
 +
|-
 +
| FRAC_DAYS_TEMP_MIN_LE_MIN18  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -18°C
 +
|-
 +
| FRAC_DAYS_TEMP_MIN_LE_MIN20  ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -20°C
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_1  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 1mm
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_3  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 3mm
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_5  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 5mm
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_10  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 10mm
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_15  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 15mm
 +
|-
 +
| FRAC_DAYS_PRECIPITATION_GE_30  ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 30mm
 +
|-
 +
| AVG_TEMP_GE_0||-||NUMBER(3,1)|| - ||
 +
|-
 +
| AVG_TEMP_GE_2||-||NUMBER(3,1)|| - ||
 +
|-
 +
| AVG_TEMP_GE_4||-||NUMBER(3,1)|| - ||
 +
|-
 +
| AVG_TEMP_GE_6||-||NUMBER(3,1)|| - ||
 +
|-
 +
| AVG_TEMP_GE_8||-||NUMBER(3,1)|| - ||
 +
|-
 +
| AVG_TEMP_GE_10||-||NUMBER(3,1)|| - ||
 +
|-
 +
| MIN_TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || minimum minimum air temperature
 +
|-
 +
| MIN_TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || minimum maximum air temperature
 +
|-
 +
| MIN_TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || minimum mean air temperature
 +
|-
 +
| MIN_PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || minimum daily rainfall
 +
|-
 +
| MIN_RADIATION  ||-||NUMBER(6)||kJ.m-2.d-1 || minimum daily radiation at surface
 +
|-
 +
| MIN_VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || minimum mean daily vapour pressure
 +
|-
 +
| MIN_WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || minimum mean daily wind speed at 10 m height
 +
|-
 +
| MIN_E0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of water surface
 +
|-
 +
| MIN_ES0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of wet bare soil
 +
|-
 +
| MIN_ET0  ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of crop canopy
 +
|-
 +
| MIN_SNOWDEPTH  ||-||NUMBER(6,2)||cm || minimum daily mean snow depth
 +
|-
 +
| MAX_TEMPERATURE_MIN  ||-||NUMBER(3,1)||°C || maximum maximum air temperature
 +
|-
 +
| MAX_TEMPERATURE_MAX  ||-||NUMBER(3,1)||°C || maximum maximum air temperature
 +
|-
 +
| MAX_TEMPERATURE_AVG  ||-||NUMBER(3,1)||°C || maximum mean air temperature
 +
|-
 +
| MAX_PRECIPITATION  ||-||NUMBER(4,1)||mm.d-1 || maximum daily rainfall
 +
|-
 +
| MAX_RADIATION  ||-||NUMBER(6)||kJ.m-2.d-1 || maximum daily radiation at surface
 +
|-
 +
| MAX_VAPOURPRESSURE  ||-||NUMBER(4,2)||hPa || maximum mean daily vapour pressure
 +
|-
 +
| MAX_WINDSPEED  ||-||NUMBER(5,1)||m.s-1 || maximum mean daily wind speed at 10 m height
 +
|-
 +
| MAX_E0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of water surface
 +
|-
 +
| MAX_ES0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of wet bare soil
 +
|-
 +
| MAX_ET0  ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of crop canopy
 +
|-
 +
| MAX_SNOW_DEPTH  ||-||NUMBER(6,2)||cm || maximum daily mean snow depth
 +
|-
 +
| STD_TEMPERATURE_MAX  ||-||NUMBER(4,2)||°C || standard deviation of maximum air temperature
 +
|-
 +
| STD_TEMPERATURE_MIN  ||-||NUMBER(4,2)||°C || standard deviation of minimum air temperature
 +
|-
 +
| STD_TEMPERATURE_AVG  ||-||NUMBER(4,2)||°C || standard deviation of mean air temperature
 +
|-
 +
| STD_PRECIPITATION  ||-||NUMBER(5,2)||mm.d-1 || standard deviation of daily rainfall
 +
|-
 +
| STD_RADIATION  ||-||NUMBER(8,1)||kJ.m-2.d-1 || standard deviation of daily radiation at surface
 +
|-
 +
| STD_VAPOURPRESSURE  ||-||NUMBER(6,3)||hPa || standard deviation of mean daily vapour pressure
 +
|-
 +
| STD_WINDSPEED  ||-||NUMBER(6,2)||m.s-1 || standard deviation of mean daily wind speed at 10 m height
 +
|-
 +
| STD_E0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of water surface
 +
|-
 +
| STD_ES0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of wet bare soil
 +
|-
 +
| STD_ET0  ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of crop canopy
 +
|-
 +
| STD_SNOWDEPTH  ||-||NUMBER(7,3)||cm || standard deviation of daily mean snow depth
 +
|-
 +
| NUM_TEMPERATURE_MIN  ||-||NUMBER(6)|| - || count of air temperature
 +
|-
 +
| NUM_TEMPERATURE_MAX  ||-||NUMBER(6)|| - || count of maximum air temperature
 +
|-
 +
| NUM_TEMPERATURE_AVG  ||-||NUMBER(6)|| - || count of mean air temperature
 +
|-
 +
| NUM_PRECIPITATION  ||-||NUMBER(6)|| - || count of daily rainfall
 +
|-
 +
| NUM_RADIATION  ||-||NUMBER(6)|| - || count of daily radiation at surface
 +
|-
 +
| NUM_VAPOURPRESSURE  ||-||NUMBER(6)|| - || count of mean daily vapour pressure
 +
|-
 +
| NUM_WINDSPEED  ||-||NUMBER(6)|| - || count of mean daily wind speed at 10 m height
 +
|-
 +
| NUM_E0  ||-||NUMBER(6)|| - || count of daily transpiration of water surface
 +
|-
 +
| NUM_ES0  ||-||NUMBER(6)|| - || count of daily transpiration of wet bare soil
 +
|-
 +
| NUM_ET0  ||-||NUMBER(6)|| - || count of daily transpiration of crop canopy
 +
|-
 +
| NUM_SNOWDEPTH  ||-||NUMBER(6)|| - || count of daily mean snow depth
 +
|}
 +
<nowiki>*</nowiki> In script changed to 4,2. Not yet installed.
 +
|}
 +
<br>
 +
 +
===WEATHER_OBS_GRID_LTA_MISS===
 +
*Description: long term average number of grid cells per country.
 +
*Use: input for check on {{Object|WEATHER_OBS_GRID}} table (see section [[Interpolation of observed weather#Check_on_missing_grid_weather|Check on missing grid weather]]).
 +
*Type: permanent table
 +
*Remarks: filled with procedure lta_missing_grid_weather.sql
 +