Appendix 5: Database objects/CGFS14EU

content
1. CMETEO-datasets
2. SIMYIELD-datasets
3. WEATHER-datasets
4. other datasets
5. synonyms

CMETEO-datasets

content
1.1 CMETEO_WEATHER_HIS_AEZ
1.2 CMETEO_WEATHER_HIS_GRID
1.3 CMETEO_WEATHER_HIS_REGION
1.4 CMETEO_WEATHER_OPE_AEZ
1.5 CMETEO_WEATHER_OPE_GRID
1.6 CMETEO_WEATHER_OPE_REGION

CMETEO_WEATHER_HIS_AEZ

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER LANDCOVER_ID False NUMBER THRESHOLD False NUMBER DAY False DATE - calendar day DAY_OFFSET True NUMBER - MEMBER_NO True NUMBER - MAX_TEMPERATURE False NUMBER °C maximum air temperature MIN_TEMPERATURE False NUMBER °C minimum air temperature MEAN_TEMPERATURE False NUMBER °C mean air temperature DEW_TEMPERATURE False NUMBER °C mean air temperature VAPOUR_PRESSURE False NUMBER hPa mean daily vapour pressure WIND_SPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER FRACTIONS True TD_THRESHOLD_VALUES * All attributes Nullable in table versions definition: select wha.reg_map_id , wha.landcover_id , wha.threshold , wha.day , 0 , 1 , wha.temperature_max , wha.temperature_min , wha.temperature_avg , wha.temperature_dew , wha.vapourpressure , wha.windspeed , wha.precipitation , wha.e0 , wha.es0 , wha.et0 , wha.radiation , wha.snowdepth , wha.snowweq , td_threshold_values (td_threshold_value('FRAC_AREA_TEMP_MAX' , 25, wha.frac_area_temp_max_ge_25) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 30, wha.frac_area_temp_max_ge_30) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 35, wha.frac_area_temp_max_ge_35) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 40, wha.frac_area_temp_max_ge_40) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , 0, wha.frac_area_temp_min_le_0) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , -8, wha.frac_area_temp_min_le_min8) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-10, wha.frac_area_temp_min_le_min10) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-18, wha.frac_area_temp_min_le_min18) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-20, wha.frac_area_temp_min_le_min20) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 1, wha.frac_area_precipitation_ge_1) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 3, wha.frac_area_precipitation_ge_3) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 5, wha.frac_area_precipitation_ge_5) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, wha.frac_area_precipitation_ge_10) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, wha.frac_area_precipitation_ge_15) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, wha.frac_area_precipitation_ge_30) ,td_threshold_value('AVG_TEMP' , 0, wha.avg_temp_ge_0) ,td_threshold_value('AVG_TEMP' , 2, wha.avg_temp_ge_2) ,td_threshold_value('AVG_TEMP' , 4, wha.avg_temp_ge_4) ,td_threshold_value('AVG_TEMP' , 6, wha.avg_temp_ge_6) ,td_threshold_value('AVG_TEMP' , 8, wha.avg_temp_ge_8) ,td_threshold_value('AVG_TEMP' , 10, wha.avg_temp_ge_10) ) fractions from weather_his_aez wha

CMETEO_WEATHER_HIS_GRID

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO True NUMBER - grid number DAY True DATE - calendar day DAY_OFFSET True NUMBER - MEMBER_NO True NUMBER - MAX_TEMPERATURE True NUMBER °C maximum air temperature MIN_TEMPERATURE True NUMBER °C minimum air temperature MEAN_TEMPERATURE True NUMBER °C mean air temperature DEW_TEMPERATURE True NUMBER °C mean air temperature VAPOUR_PRESSURE True NUMBER hPa mean daily vapour pressure WIND_SPEED True NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION True NUMBER mm.d-1 daily rainfall E0 True NUMBER mm.d-1 daily transpiration of water surface ES0 True NUMBER mm.d-1 daily transpiration of wet bare soil ET0 True NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION True NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER * All attributes Nullable in table versions definition: select idgrid ,day ,0 as day_offset ,1 as member_no ,temperature_max ,temperature_min ,temperature_avg ,temperature_dew ,vapourpressure ,windspeed ,precipitation ,e0 ,es0 ,et0 ,radiation ,snowdepth ,snowweq from weather_his_grid union all select idgrid ,day ,0 as day_offset ,1 as member_no ,temperature_max ,temperature_min ,temperature_avg ,temperature_dew ,vapourpressure ,windspeed ,precipitation ,e0 ,es0 ,et0 ,radiation ,snowdepth ,snowweq from weather_era_grid

CMETEO_WEATHER_HIS_REGION

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER LANDCOVER_ID False NUMBER THRESHOLD False NUMBER DAY False DATE - calendar day DAY_OFFSET True NUMBER - MEMBER_NO True NUMBER - MAX_TEMPERATURE False NUMBER °C maximum air temperature MIN_TEMPERATURE False NUMBER °C minimum air temperature MEAN_TEMPERATURE False NUMBER °C mean air temperature DEW_TEMPERATURE False NUMBER °C mean air temperature VAPOUR_PRESSURE False NUMBER hPa mean daily vapour pressure WIND_SPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER FRACTIONS True TD_THRESHOLD_VALUES * All attributes Nullable in table versions definition: select whr.reg_map_id , whr.landcover_id , whr.threshold , whr.day , 0 , 1 , whr.temperature_max , whr.temperature_min , whr.temperature_avg , whr.temperature_dew , whr.vapourpressure , whr.windspeed , whr.precipitation , whr.e0 , whr.es0 , whr.et0 , whr.radiation , whr.snowdepth , whr.snowweq , td_threshold_values (td_threshold_value('FRAC_AREA_TEMP_MAX' , 25, whr.frac_area_temp_max_ge_25) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 30, whr.frac_area_temp_max_ge_30) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 35, whr.frac_area_temp_max_ge_35) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 40, whr.frac_area_temp_max_ge_40) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , 0, whr.frac_area_temp_min_le_0) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , -8, whr.frac_area_temp_min_le_min8) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-10, whr.frac_area_temp_min_le_min10) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-18, whr.frac_area_temp_min_le_min18) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-20, whr.frac_area_temp_min_le_min20) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 1, whr.frac_area_precipitation_ge_1) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 3, whr.frac_area_precipitation_ge_3) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 5, whr.frac_area_precipitation_ge_5) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, whr.frac_area_precipitation_ge_10) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, whr.frac_area_precipitation_ge_15) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, whr.frac_area_precipitation_ge_30) ,td_threshold_value('AVG_TEMP' , 0, whr.avg_temp_ge_0) ,td_threshold_value('AVG_TEMP' , 2, whr.avg_temp_ge_2) ,td_threshold_value('AVG_TEMP' , 4, whr.avg_temp_ge_4) ,td_threshold_value('AVG_TEMP' , 6, whr.avg_temp_ge_6) ,td_threshold_value('AVG_TEMP' , 8, whr.avg_temp_ge_8) ,td_threshold_value('AVG_TEMP' , 10, whr.avg_temp_ge_10) ) fractions from weather_his_region whr

CMETEO_WEATHER_OPE_AEZ

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER LANDCOVER_ID False NUMBER THRESHOLD False NUMBER DAY False DATE - calendar day DAY_OFFSET False NUMBER - MEMBER_NO False NUMBER - MAX_TEMPERATURE False NUMBER °C maximum air temperature MIN_TEMPERATURE False NUMBER °C minimum air temperature MEAN_TEMPERATURE False NUMBER °C mean air temperature DEW_TEMPERATURE False NUMBER °C mean air temperature VAPOUR_PRESSURE False NUMBER hPa mean daily vapour pressure WIND_SPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER FRACTIONS True TD_THRESHOLD_VALUES * All attributes Nullable in table versions definition: select woa.reg_map_id , woa.landcover_id , woa.threshold , woa.day , woa.day_offset , woa.member_no , woa.temperature_max , woa.temperature_min , woa.temperature_avg , woa.temperature_dew , woa.vapourpressure , woa.windspeed , woa.precipitation , woa.e0 , woa.es0 , woa.et0 , woa.radiation , woa.snowdepth , woa.snowweq , td_threshold_values (td_threshold_value('FRAC_AREA_TEMP_MAX' , 25, woa.frac_area_temp_max_ge_25) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 30, woa.frac_area_temp_max_ge_30) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 35, woa.frac_area_temp_max_ge_35) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 40, woa.frac_area_temp_max_ge_40) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , 0, woa.frac_area_temp_min_le_0) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , -8, woa.frac_area_temp_min_le_min8) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-10, woa.frac_area_temp_min_le_min10) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-18, woa.frac_area_temp_min_le_min18) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-20, woa.frac_area_temp_min_le_min20) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 1, woa.frac_area_precipitation_ge_1) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 3, woa.frac_area_precipitation_ge_3) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 5, woa.frac_area_precipitation_ge_5) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, woa.frac_area_precipitation_ge_10) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, woa.frac_area_precipitation_ge_15) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, woa.frac_area_precipitation_ge_30) ,td_threshold_value('AVG_TEMP' , 0, woa.avg_temp_ge_0) ,td_threshold_value('AVG_TEMP' , 2, woa.avg_temp_ge_2) ,td_threshold_value('AVG_TEMP' , 4, woa.avg_temp_ge_4) ,td_threshold_value('AVG_TEMP' , 6, woa.avg_temp_ge_6) ,td_threshold_value('AVG_TEMP' , 8, woa.avg_temp_ge_8) ,td_threshold_value('AVG_TEMP' , 10, woa.avg_temp_ge_10) ) fractions from weather_ope_aez woa

CMETEO_WEATHER_OPE_GRID

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER - grid number DAY False DATE - calendar day DAY_OFFSET False NUMBER - MEMBER_NO False NUMBER - MAX_TEMPERATURE False NUMBER °C maximum air temperature MIN_TEMPERATURE False NUMBER °C minimum air temperature MEAN_TEMPERATURE False NUMBER °C mean air temperature DEW_TEMPERATURE False NUMBER °C mean air temperature VAPOUR_PRESSURE False NUMBER hPa mean daily vapour pressure WIND_SPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER * All attributes Nullable in table versions definition: select idgrid ,day ,dayoffset ,idmember ,temperature_max ,temperature_min ,temperature_avg ,temperature_dew ,vapourpressure ,windspeed ,precipitation ,e0 ,es0 ,et0 ,radiation ,snowdepth ,snowweq from weather_ope_grid

CMETEO_WEATHER_OPE_REGION

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER LANDCOVER_ID False NUMBER THRESHOLD False NUMBER DAY False DATE - calendar day DAY_OFFSET False NUMBER - MEMBER_NO False NUMBER - MAX_TEMPERATURE False NUMBER °C maximum air temperature MIN_TEMPERATURE False NUMBER °C minimum air temperature MEAN_TEMPERATURE False NUMBER °C mean air temperature DEW_TEMPERATURE False NUMBER °C mean air temperature VAPOUR_PRESSURE False NUMBER hPa mean daily vapour pressure WIND_SPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy GLOBAL_RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOW_DEPTH True NUMBER cm daily mean snow depth SNOW_WEQ True NUMBER FRACTIONS True TD_THRESHOLD_VALUES * All attributes Nullable in table versions definition: select wor.reg_map_id , wor.landcover_id , wor.threshold , wor.day , wor.day_offset , wor.member_no , wor.temperature_max , wor.temperature_min , wor.temperature_avg , wor.temperature_dew , wor.vapourpressure , wor.windspeed , wor.precipitation , wor.e0 , wor.es0 , wor.et0 , wor.radiation , wor.snowdepth , wor.snowweq , td_threshold_values (td_threshold_value('FRAC_AREA_TEMP_MAX' , 25, wor.frac_area_temp_max_ge_25) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 30, wor.frac_area_temp_max_ge_30) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 35, wor.frac_area_temp_max_ge_35) ,td_threshold_value('FRAC_AREA_TEMP_MAX' , 40, wor.frac_area_temp_max_ge_40) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , 0, wor.frac_area_temp_min_le_0) ,td_threshold_value('FRAC_AREA_TEMP_MIN' , -8, wor.frac_area_temp_min_le_min8) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-10, wor.frac_area_temp_min_le_min10) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-18, wor.frac_area_temp_min_le_min18) ,td_threshold_value('FRAC_AREA_TEMP_MIN' ,-20, wor.frac_area_temp_min_le_min20) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 1, wor.frac_area_precipitation_ge_1) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 3, wor.frac_area_precipitation_ge_3) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 5, wor.frac_area_precipitation_ge_5) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 10, wor.frac_area_precipitation_ge_10) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 15, wor.frac_area_precipitation_ge_15) ,td_threshold_value('FRAC_AREA_PRECIPITATION', 30, wor.frac_area_precipitation_ge_30) ,td_threshold_value('AVG_TEMP' , 0, wor.avg_temp_ge_0) ,td_threshold_value('AVG_TEMP' , 2, wor.avg_temp_ge_2) ,td_threshold_value('AVG_TEMP' , 4, wor.avg_temp_ge_4) ,td_threshold_value('AVG_TEMP' , 6, wor.avg_temp_ge_6) ,td_threshold_value('AVG_TEMP' , 8, wor.avg_temp_ge_8) ,td_threshold_value('AVG_TEMP' , 10, wor.avg_temp_ge_10) ) fractions from weather_ope_region wor

SIMYIELD-datasets

content
2.1 SIMYIELD_ENSEXT_EMU
2.2 SIMYIELD_ENSEXT_GRID
2.3 SIMYIELD_ENSEXT_REGION
2.4 SIMYIELD_ENSEXT_STU
2.5 SIMYIELD_ENS_EMU
2.6 SIMYIELD_ENS_GRID
2.7 SIMYIELD_ENS_REGION
2.8 SIMYIELD_ENS_STU
2.9 SIMYIELD_SEAS_EMU
2.10 SIMYIELD_SEAS_GRID
2.11 SIMYIELD_SEAS_REGION
2.12 SIMYIELD_SEAS_STU
2.13 SIMYIELD_STU_EPS
2.14 SIMYIELD_STU_MON
2.15 SIMYIELD_STU_SEA

SIMYIELD_ENSEXT_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number SMU_NO False NUMBER - soil mapping unit number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_ENSEXT_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_ENSEXT_REGION

• Description: results of the crop simulation per administrative region. Level 2 output
• Use: output table for the crop simulation process
• Type: Table
• Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER CROP_NO False NUMBER - crop number DAY False DATE - day REG_MAP_ID False NUMBER - administrative region code POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_ENSEXT_STU

• Description:
• Use:
• Type: Table
• Remarks:

Structure

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

SIMYIELD_ENS_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number SMU_NO False NUMBER - soil mapping unit number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_ENS_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_ENS_REGION

• Description: results of the crop simulation per administrative region. Level 2 output
• Use: output table for the crop simulation process
• Type: Table
• Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER CROP_NO False NUMBER - crop number DAY False DATE - day REG_MAP_ID False NUMBER - administrative region code POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_ENS_STU

• Description:
• Use:
• Type: Table
• Remarks:

Structure

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

SIMYIELD_SEAS_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number SMU_NO False NUMBER - soil mapping unit number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_SEAS_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: Table
• Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER - member number* CROP_NO False NUMBER - crop number GRID_NO False NUMBER - grid number DAY False DATE - day POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop * 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.

SIMYIELD_SEAS_REGION

• Description: results of the crop simulation per administrative region. Level 2 output
• Use: output table for the crop simulation process
• Type: Table
• Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER CROP_NO False NUMBER - crop number DAY False DATE - day REG_MAP_ID False NUMBER - administrative region code POTENTIAL_YIELD_BIOMASS False NUMBER kg.ha-1 potential dry weight biomass POTENTIAL_YIELD_STORAGE False NUMBER kg.ha-1 potential dry weight storage organs WATER_LIM_YIELD_BIOMASS False NUMBER kg.ha-1 water limited dry weight biomass WATER_LIM_YIELD_STORAGE False NUMBER kg.ha-1 water limited dry weight storage organs POTENTIAL_LEAF_AREA_INDEX False NUMBER m2.m2 potential leaf area divided by surface area WATER_LIM_LEAF_AREA_INDEX False NUMBER m2.m2 water limited leaf area divided by surface area DEVELOPMENT_STAGE False NUMBER - development stag of crop (0-200 RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER cm sum of water limited transpiration TOTAL_WATER_REQUIREMENT False NUMBER cm sum of potential transpiration FSM False NUMBER - folumetric soil moisture content in rooted zone FSMUR False NUMBER - volumetric soil moisture content in not rooted zone LEAVES_DIED_BY_COLD True NUMBER - fraction of leaves died by cold wrt total biomass RUNOFF True NUMBER cm run off SOIL_EVAPORATION True NUMBER cm soil evaporation LOSS_TO_SUBSOIL True NUMBER cm amount of water drained to the sub soil and therefore lost for the crop

SIMYIELD_SEAS_STU

• Description:
• Use:
• Type: Table
• Remarks:

Structure

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

SIMYIELD_STU_EPS

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER DAY False DATE DOY False NUMBER YEAR False NUMBER GRID_NO False NUMBER STU_NO False NUMBER CROP_NO False NUMBER POTENTIAL_LEAF_AREA_INDEX False NUMBER POTENTIAL_YIELD_BIOMASS False NUMBER POTENTIAL_YIELD_STORAGE False NUMBER WATER_LIM_LEAF_AREA_INDEX False NUMBER WATER_LIM_YIELD_BIOMASS False NUMBER WATER_LIM_YIELD_STORAGE False NUMBER DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER TOTAL_WATER_REQUIREMENT False NUMBER FSM False NUMBER FSMUR False NUMBER RUNOFF True NUMBER SOIL_EVAPORATION True NUMBER LOSS_TO_SUBSOIL True NUMBER ID_SERIES True NUMBER definition: select IDMEMBER as member_no ,DAY ,DOY ,YEAR ,IDGRID as grid_no ,IDSTU as stu_no ,IDCROP as crop_no ,POTENTIAL_LEAF_AREA_INDEX ,POTENTIAL_YIELD_BIOMASS ,POTENTIAL_YIELD_STORAGE ,WATER_LIM_LEAF_AREA_INDEX ,WATER_LIM_YIELD_BIOMASS ,WATER_LIM_YIELD_STORAGE ,DEVELOPMENT_STAGE ,RELATIVE_SOIL_MOISTURE ,TOTAL_WATER_CONSUMPTION ,TOTAL_WATER_REQUIREMENT ,FSM ,FSMUR ,RUNOFF ,SOIL_EVAPORATION ,LOSS_TO_SUBSOIL ,IDSERIES as id_series from simyield_ens_stu

SIMYIELD_STU_MON

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER DAY False DATE DOY False NUMBER YEAR False NUMBER GRID_NO False NUMBER STU_NO False NUMBER CROP_NO False NUMBER POTENTIAL_LEAF_AREA_INDEX False NUMBER POTENTIAL_YIELD_BIOMASS False NUMBER POTENTIAL_YIELD_STORAGE False NUMBER WATER_LIM_LEAF_AREA_INDEX False NUMBER WATER_LIM_YIELD_BIOMASS False NUMBER WATER_LIM_YIELD_STORAGE False NUMBER DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER TOTAL_WATER_REQUIREMENT False NUMBER FSM False NUMBER FSMUR False NUMBER RUNOFF True NUMBER SOIL_EVAPORATION True NUMBER LOSS_TO_SUBSOIL True NUMBER ID_SERIES True NUMBER definition: select IDMEMBER as member_no ,DAY ,DOY ,YEAR ,IDGRID as grid_no ,IDSTU as stu_no ,IDCROP as crop_no ,POTENTIAL_LEAF_AREA_INDEX ,POTENTIAL_YIELD_BIOMASS ,POTENTIAL_YIELD_STORAGE ,WATER_LIM_LEAF_AREA_INDEX ,WATER_LIM_YIELD_BIOMASS ,WATER_LIM_YIELD_STORAGE ,DEVELOPMENT_STAGE ,RELATIVE_SOIL_MOISTURE ,TOTAL_WATER_CONSUMPTION ,TOTAL_WATER_REQUIREMENT ,FSM ,FSMUR ,RUNOFF ,SOIL_EVAPORATION ,LOSS_TO_SUBSOIL ,IDSERIES as id_series from simyield_ensext_stu

SIMYIELD_STU_SEA

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment MEMBER_NO False NUMBER DAY False DATE DOY False NUMBER YEAR False NUMBER GRID_NO False NUMBER STU_NO False NUMBER CROP_NO False NUMBER POTENTIAL_LEAF_AREA_INDEX False NUMBER POTENTIAL_YIELD_BIOMASS False NUMBER POTENTIAL_YIELD_STORAGE False NUMBER WATER_LIM_LEAF_AREA_INDEX False NUMBER WATER_LIM_YIELD_BIOMASS False NUMBER WATER_LIM_YIELD_STORAGE False NUMBER DEVELOPMENT_STAGE False NUMBER RELATIVE_SOIL_MOISTURE False NUMBER TOTAL_WATER_CONSUMPTION False NUMBER TOTAL_WATER_REQUIREMENT False NUMBER FSM False NUMBER FSMUR False NUMBER RUNOFF True NUMBER SOIL_EVAPORATION True NUMBER LOSS_TO_SUBSOIL True NUMBER ID_SERIES True NUMBER definition: select IDMEMBER as member_no ,DAY ,DOY ,YEAR ,IDGRID as grid_no ,IDSTU as stu_no ,IDCROP as crop_no ,POTENTIAL_LEAF_AREA_INDEX ,POTENTIAL_YIELD_BIOMASS ,POTENTIAL_YIELD_STORAGE ,WATER_LIM_LEAF_AREA_INDEX ,WATER_LIM_YIELD_BIOMASS ,WATER_LIM_YIELD_STORAGE ,DEVELOPMENT_STAGE ,RELATIVE_SOIL_MOISTURE ,TOTAL_WATER_CONSUMPTION ,TOTAL_WATER_REQUIREMENT ,FSM ,FSMUR ,RUNOFF ,SOIL_EVAPORATION ,LOSS_TO_SUBSOIL ,IDSERIES as id_series from simyield_seas_stu

WEATHER-datasets

content
3.1 WEATHER_ENSEXT_GRID
3.2 WEATHER_ENS_GRID
3.3 WEATHER_EPS_GRID_FOR_BIOMA
3.4 WEATHER_ERA_GRID
3.5 WEATHER_ERA_GRID_EXPORT
3.6 WEATHER_HIS_AEZ
3.7 WEATHER_HIS_AEZ_LTA
3.8 WEATHER_HIS_GRID
3.9 WEATHER_HIS_GRID_EXPORT
3.10 WEATHER_HIS_GRID_FOR_BIOMA
3.11 WEATHER_HIS_GRID_LTA
3.12 WEATHER_HIS_REGION
3.13 WEATHER_HIS_REGION_LTA
3.14 WEATHER_OPE_AEZ
3.15 WEATHER_OPE_GRID
3.16 WEATHER_OPE_REGION
3.17 WEATHER_SEAS_GRID
3.18 WEATHER_SEA_GRID_FOR_EXPORT

WEATHER_ENSEXT_GRID

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

Structure

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

WEATHER_ENS_GRID

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

Structure

Attribute Constraint Type Unit Comment IDGRID False NUMBER DAY False DATE DAYOFFSET False NUMBER IDMEMBER False NUMBER TEMPERATURE_MAX False NUMBER °C maximum air temperature at 2 m height TEMPERATURE_MIN False NUMBER °C minimum air temperature at 2 m height TEMPERATURE_AVG False NUMBER °C average air temperature at 2 m height TEMPERATURE_DEW False NUMBER °C dewpoint air temperature at 2 m height VAPOURPRESSURE False NUMBER hPa mean daily vapour pressure WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOWWEQ True NUMBER cm daily mean snow water equivalent SNOWDEPTH True NUMBER cm daily mean snow depth** TOTALCLOUD True NUMBER SYS_STS29D$RZ#ATMM___ICOPXSFQ5 True NUMBER * Not available (relevant) in HIS product ** Not available in EPS, MON and SEA products

WEATHER_EPS_GRID_FOR_BIOMA

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER MEMBER_NO False NUMBER DAY_OFFSET False NUMBER DAY False DATE RADIATION False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER PRECIPITATION False NUMBER SNOWWEQ True NUMBER VAPOURPRESSURE False NUMBER WINDSPEED False NUMBER definition: select idgrid as grid_no , idmember as member_no , dayoffset as day_offset , day , radiation , e0 , es0 , et0 , temperature_max , temperature_min , precipitation , snowweq , vapourpressure , windspeed from weather_ens_grid

WEATHER_ERA_GRID

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

Structure

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

WEATHER_ERA_GRID_EXPORT

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER DAY False DATE TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER TEMPERATURE_AVG False NUMBER TEMPERATURE_DEW False NUMBER VAPOURPRESSURE False NUMBER WINDSPEED False NUMBER PRECIPITATION False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER RADIATION False NUMBER SNOWWEQ True NUMBER SNOWDEPTH True NUMBER definition: select IDGRID ,DAY ,TEMPERATURE_MAX ,TEMPERATURE_MIN ,TEMPERATURE_AVG ,TEMPERATURE_DEW ,VAPOURPRESSURE ,WINDSPEED ,PRECIPITATION ,E0 ,ES0 ,ET0 ,RADIATION ,SNOWWEQ ,SNOWDEPTH from WEATHER_ERA_GRID

WEATHER_HIS_AEZ

• Description: forecasted weather per day and agro-environmental region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. ERA, MON and SEA are not available for agro-environmental regions

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - agro-environmental region id LANDCOVER_ID False NUMBER - landmask / cropmask id THRESHOLD False NUMBER - used threshold in percentage DAY False DATE - day of forecast TEMPERATURE_MAX False NUMBER °C maximum air temperature at 2 m height TEMPERATURE_MIN False NUMBER °C minimum air temperature at 2 m height TEMPERATURE_AVG False NUMBER °C average air temperature at 2 m height TEMPERATURE_DEW False NUMBER °C dewpoint air temperature at 2 m height VAPOURPRESSURE False NUMBER hPa mean daily vapour pressure WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOWWEQ True NUMBER cm daily mean snow water equivalent SNOWDEPTH True NUMBER cm daily mean snow depth** FRAC_AREA_TEMP_MAX_GE_25 True NUMBER - fraction of area with maximum temperature >= 25°C FRAC_AREA_TEMP_MAX_GE_30 True NUMBER - fraction of area with maximum temperature >= 30°C FRAC_AREA_TEMP_MAX_GE_35 True NUMBER - fraction of area with maximum temperature >= 35°C FRAC_AREA_TEMP_MAX_GE_40 True NUMBER - fraction of area with maximum temperature >= 40°C FRAC_AREA_TEMP_MIN_LE_0 True NUMBER - fraction of area with minimum <= 0°C FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER - fraction of area with minimum <= -8°C FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER - fraction of area with minimum <= -10°C FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER - fraction of area with minimum <= -18°C FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER - fraction of area with minimum <= -20°C FRAC_AREA_PRECIPITATION_GE_1 True NUMBER - fraction of area with rainfall >= 1mm FRAC_AREA_PRECIPITATION_GE_3 True NUMBER - fraction of area with rainfall >= 3mm FRAC_AREA_PRECIPITATION_GE_5 True NUMBER - fraction of area with rainfall >= 5mm FRAC_AREA_PRECIPITATION_GE_10 True NUMBER - fraction of area with rainfall >= 10mm FRAC_AREA_PRECIPITATION_GE_15 True NUMBER - fraction of area with rainfall >= 15mm FRAC_AREA_PRECIPITATION_GE_30 True NUMBER - fraction of area with rainfall >= 30mm AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C * Not available (relevant) in HIS products ** Not available in EPS, MON and SEA products

WEATHER_HIS_AEZ_LTA

• Description: long term average forecasted weather per day and agri-environmental region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: Long term average is only available for the HIS model (see forecasted weather).

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - agri-environmental region id LANDCOVER_ID False NUMBER - landcover mask / crop mask id THRESHOLD False NUMBER - used threshold in percentage DAY_NO False VARCHAR2 - day of year stored as mmdd TEMPERATURE_MAX True NUMBER °C average maximum air temperature at 2 m height TEMPERATURE_MIN True NUMBER °C average minimum air temperature at 2 m height TEMPERATURE_AVG True NUMBER °C average average air temperature at 2 m height TEMPERATURE_DEW True NUMBER °C average dewpoint air temperature at 2 m height VAPOURPRESSURE True NUMBER hPa average mean daily vapour pressure WINDSPEED True NUMBER m.s-1 average mean daily wind speed at 10 m height PRECIPITATION True NUMBER mm.d-1 average daily rainfall E0 True NUMBER mm.d-1 average daily transpiration of water surface ES0 True NUMBER mm.d-1 average daily transpiration of wet bare soil ET0 True NUMBER mm.d-1 average daily transpiration of crop canopy RADIATION True NUMBER kJ.m-2.d-1 average daily radiation at surface SNOWWEQ True NUMBER cm average daily mean snow water equivalent SNOWDEPTH True NUMBER cm average daily mean snow depth FRAC_AREA_TEMP_MAX_GE_25 True NUMBER FRAC_AREA_TEMP_MAX_GE_30 True NUMBER FRAC_AREA_TEMP_MAX_GE_35 True NUMBER FRAC_AREA_TEMP_MAX_GE_40 True NUMBER FRAC_AREA_TEMP_MIN_LE_0 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER FRAC_AREA_PRECIPITATION_GE_1 True NUMBER FRAC_AREA_PRECIPITATION_GE_3 True NUMBER FRAC_AREA_PRECIPITATION_GE_5 True NUMBER FRAC_AREA_PRECIPITATION_GE_10 True NUMBER FRAC_AREA_PRECIPITATION_GE_15 True NUMBER FRAC_AREA_PRECIPITATION_GE_30 True NUMBER AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C

WEATHER_HIS_GRID

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

Structure

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

WEATHER_HIS_GRID_EXPORT

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER DAY False DATE TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER TEMPERATURE_AVG False NUMBER TEMPERATURE_DEW False NUMBER VAPOURPRESSURE False NUMBER WINDSPEED False NUMBER PRECIPITATION False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER RADIATION False NUMBER SNOWWEQ True NUMBER SNOWDEPTH True NUMBER definition: select IDGRID ,DAY ,TEMPERATURE_MAX ,TEMPERATURE_MIN ,TEMPERATURE_AVG ,TEMPERATURE_DEW ,VAPOURPRESSURE ,WINDSPEED ,PRECIPITATION ,E0 ,ES0 ,ET0 ,RADIATION ,SNOWWEQ ,SNOWDEPTH from WEATHER_HIS_GRID

WEATHER_HIS_GRID_FOR_BIOMA

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER DAY False DATE RADIATION False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER PRECIPITATION False NUMBER SNOWWEQ True NUMBER VAPOURPRESSURE False NUMBER WINDSPEED False NUMBER definition: select idgrid as grid_no , day , radiation , e0 , es0 , et0 , temperature_max , temperature_min , precipitation , snowweq , vapourpressure , windspeed from weather_his_grid

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: Table
• Remarks: Long term average is only available for the HIS model (see forecasted weather).

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER - grid number DAY_NO False VARCHAR2 - day of year stored as mmdd TEMPERATURE_MAX True NUMBER °C average maximum air temperature at 2 m height TEMPERATURE_MIN True NUMBER °C average minimum air temperature at 2 m height TEMPERATURE_AVG True NUMBER °C average average air temperature at 2 m height TEMPERATURE_DEW True NUMBER °C average dewpoint air temperature at 2 m height VAPOURPRESSURE True NUMBER hPa average mean daily vapour pressure WINDSPEED True NUMBER m.s-1 average mean daily wind speed at 10 m height PRECIPITATION True NUMBER mm.d-1 average daily rainfall E0 True NUMBER mm.d-1 average daily transpiration of water surface ES0 True NUMBER mm.d-1 average daily transpiration of wet bare soil ET0 True NUMBER mm.d-1 average daily transpiration of crop canopy RADIATION True NUMBER kJ.m-2.d-1 average daily radiation at surface SNOWWEQ True NUMBER cm average daily mean snow water equivalent SNOWDEPTH True NUMBER cm average daily mean snow depth FRAC_DAYS_TEMP_MAX_GE_25 True NUMBER FRAC_DAYS_TEMP_MAX_GE_30 True NUMBER FRAC_DAYS_TEMP_MAX_GE_35 True NUMBER FRAC_DAYS_TEMP_MAX_GE_40 True NUMBER FRAC_DAYS_TEMP_MIN_LE_0 True NUMBER FRAC_DAYS_TEMP_MIN_LE_MIN8 True NUMBER FRAC_DAYS_TEMP_MIN_LE_MIN10 True NUMBER FRAC_DAYS_TEMP_MIN_LE_MIN18 True NUMBER FRAC_DAYS_TEMP_MIN_LE_MIN20 True NUMBER FRAC_DAYS_PRECIPITATION_GE_1 True NUMBER FRAC_DAYS_PRECIPITATION_GE_3 True NUMBER FRAC_DAYS_PRECIPITATION_GE_5 True NUMBER FRAC_DAYS_PRECIPITATION_GE_10 True NUMBER FRAC_DAYS_PRECIPITATION_GE_15 True NUMBER FRAC_DAYS_PRECIPITATION_GE_30 True NUMBER AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C

WEATHER_HIS_REGION

• Description: forecasted weather per day and administrative region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. MON and SEA are not available for administrative regions

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - administrative region id LANDCOVER_ID False NUMBER - landmask / cropmask id THRESHOLD False NUMBER - used threshold in percentage DAY False DATE - day of forecast TEMPERATURE_MAX False NUMBER °C maximum air temperature at 2 m height TEMPERATURE_MIN False NUMBER °C minimum air temperature at 2 m height TEMPERATURE_AVG False NUMBER °C average air temperature at 2 m height TEMPERATURE_DEW False NUMBER °C dewpoint air temperature at 2 m height VAPOURPRESSURE False NUMBER hPa mean daily vapour pressure WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOWWEQ True NUMBER cm daily mean snow water equivalent SNOWDEPTH True NUMBER cm daily mean snow depth** FRAC_AREA_TEMP_MAX_GE_25 True NUMBER - fraction of area with maximum temperature >= 25°C FRAC_AREA_TEMP_MAX_GE_30 True NUMBER - fraction of area with maximum temperature >= 30°C FRAC_AREA_TEMP_MAX_GE_35 True NUMBER - fraction of area with maximum temperature >= 35°C FRAC_AREA_TEMP_MAX_GE_40 True NUMBER - fraction of area with maximum temperature >= 40°C FRAC_AREA_TEMP_MIN_LE_0 True NUMBER - fraction of area with minimum <= 0°C FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER - fraction of area with minimum <= -8°C FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER - fraction of area with minimum <= -10°C FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER - fraction of area with minimum <= -18°C FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER - fraction of area with minimum <= -20°C FRAC_AREA_PRECIPITATION_GE_1 True NUMBER - fraction of area with rainfall >= 1mm FRAC_AREA_PRECIPITATION_GE_3 True NUMBER - fraction of area with rainfall >= 3mm FRAC_AREA_PRECIPITATION_GE_5 True NUMBER - fraction of area with rainfall >= 5mm FRAC_AREA_PRECIPITATION_GE_10 True NUMBER - fraction of area with rainfall >= 10mm FRAC_AREA_PRECIPITATION_GE_15 True NUMBER - fraction of area with rainfall >= 15mm FRAC_AREA_PRECIPITATION_GE_30 True NUMBER - fraction of area with rainfall >= 30mm AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C * Not available (relevant) in HIS products ** Not available in EPS, MON and SEA products

WEATHER_HIS_REGION_LTA

• Description: long term average forecasted weather per day and administrative region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: Long term average is only available for the HIS model (see forecasted weather).

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - administrative region id LANDCOVER_ID False NUMBER - landcover mask / crop mask id THRESHOLD False NUMBER - used threshold in percentage DAY_NO False VARCHAR2 - day of year stored as mmdd TEMPERATURE_MAX True NUMBER °C average maximum air temperature at 2 m height TEMPERATURE_MIN True NUMBER °C average minimum air temperature at 2 m height TEMPERATURE_AVG True NUMBER °C average average air temperature at 2 m height TEMPERATURE_DEW True NUMBER °C average dewpoint air temperature at 2 m height VAPOURPRESSURE True NUMBER hPa average mean daily vapour pressure WINDSPEED True NUMBER m.s-1 average mean daily wind speed at 10 m height PRECIPITATION True NUMBER mm.d-1 average daily rainfall E0 True NUMBER mm.d-1 average daily transpiration of water surface ES0 True NUMBER mm.d-1 average daily transpiration of wet bare soil ET0 True NUMBER mm.d-1 average daily transpiration of crop canopy RADIATION True NUMBER kJ.m-2.d-1 average daily radiation at surface SNOWWEQ True NUMBER cm average daily mean snow water equivalent SNOWDEPTH True NUMBER cm average daily mean snow depth FRAC_AREA_TEMP_MAX_GE_25 True NUMBER FRAC_AREA_TEMP_MAX_GE_30 True NUMBER FRAC_AREA_TEMP_MAX_GE_35 True NUMBER FRAC_AREA_TEMP_MAX_GE_40 True NUMBER FRAC_AREA_TEMP_MIN_LE_0 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER FRAC_AREA_PRECIPITATION_GE_1 True NUMBER FRAC_AREA_PRECIPITATION_GE_3 True NUMBER FRAC_AREA_PRECIPITATION_GE_5 True NUMBER FRAC_AREA_PRECIPITATION_GE_10 True NUMBER FRAC_AREA_PRECIPITATION_GE_15 True NUMBER FRAC_AREA_PRECIPITATION_GE_30 True NUMBER AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C

WEATHER_OPE_AEZ

• Description: forecasted weather per day and agro-environmental region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. ERA, MON and SEA are not available for agro-environmental regions

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - agro-environmental region id LANDCOVER_ID False NUMBER - landmask / cropmask id THRESHOLD False NUMBER - used threshold in percentage DAY False DATE - day of forecast DAY_OFFSET False NUMBER MEMBER_NO False NUMBER - number of forecast member* TEMPERATURE_MAX False NUMBER °C maximum air temperature at 2 m height TEMPERATURE_MIN False NUMBER °C minimum air temperature at 2 m height TEMPERATURE_AVG False NUMBER °C average air temperature at 2 m height TEMPERATURE_DEW False NUMBER °C dewpoint air temperature at 2 m height VAPOURPRESSURE False NUMBER hPa mean daily vapour pressure WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOWWEQ True NUMBER cm daily mean snow water equivalent SNOWDEPTH True NUMBER cm daily mean snow depth** FRAC_AREA_TEMP_MAX_GE_25 True NUMBER - fraction of area with maximum temperature >= 25°C FRAC_AREA_TEMP_MAX_GE_30 True NUMBER - fraction of area with maximum temperature >= 30°C FRAC_AREA_TEMP_MAX_GE_35 True NUMBER - fraction of area with maximum temperature >= 35°C FRAC_AREA_TEMP_MAX_GE_40 True NUMBER - fraction of area with maximum temperature >= 40°C FRAC_AREA_TEMP_MIN_LE_0 True NUMBER - fraction of area with minimum <= 0°C FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER - fraction of area with minimum <= -8°C FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER - fraction of area with minimum <= -10°C FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER - fraction of area with minimum <= -18°C FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER - fraction of area with minimum <= -20°C FRAC_AREA_PRECIPITATION_GE_1 True NUMBER - fraction of area with rainfall >= 1mm FRAC_AREA_PRECIPITATION_GE_3 True NUMBER - fraction of area with rainfall >= 3mm FRAC_AREA_PRECIPITATION_GE_5 True NUMBER - fraction of area with rainfall >= 5mm FRAC_AREA_PRECIPITATION_GE_10 True NUMBER - fraction of area with rainfall >= 10mm FRAC_AREA_PRECIPITATION_GE_15 True NUMBER - fraction of area with rainfall >= 15mm FRAC_AREA_PRECIPITATION_GE_30 True NUMBER - fraction of area with rainfall >= 30mm AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C * Not available (relevant) in HIS products ** Not available in EPS, MON and SEA products

WEATHER_OPE_GRID

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

Structure

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

WEATHER_OPE_REGION

• Description: forecasted weather per day and administrative region.
• Use: Monitoring extreme weather events.
• Type: Table
• Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS) to get the table name. MON and SEA are not available for administrative regions

Structure

Attribute Constraint Type Unit Comment REG_MAP_ID False NUMBER - administrative region id LANDCOVER_ID False NUMBER - landmask / cropmask id THRESHOLD False NUMBER - used threshold in percentage DAY False DATE - day of forecast DAY_OFFSET False NUMBER MEMBER_NO False NUMBER - number of forecast member* TEMPERATURE_MAX False NUMBER °C maximum air temperature at 2 m height TEMPERATURE_MIN False NUMBER °C minimum air temperature at 2 m height TEMPERATURE_AVG False NUMBER °C average air temperature at 2 m height TEMPERATURE_DEW False NUMBER °C dewpoint air temperature at 2 m height VAPOURPRESSURE False NUMBER hPa mean daily vapour pressure WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall E0 False NUMBER mm.d-1 daily transpiration of water surface ES0 False NUMBER mm.d-1 daily transpiration of wet bare soil ET0 False NUMBER mm.d-1 daily transpiration of crop canopy RADIATION False NUMBER kJ.m-2.d-1 daily radiation at surface SNOWWEQ True NUMBER cm daily mean snow water equivalent SNOWDEPTH True NUMBER cm daily mean snow depth** FRAC_AREA_TEMP_MAX_GE_25 True NUMBER - fraction of area with maximum temperature >= 25°C FRAC_AREA_TEMP_MAX_GE_30 True NUMBER - fraction of area with maximum temperature >= 30°C FRAC_AREA_TEMP_MAX_GE_35 True NUMBER - fraction of area with maximum temperature >= 35°C FRAC_AREA_TEMP_MAX_GE_40 True NUMBER - fraction of area with maximum temperature >= 40°C FRAC_AREA_TEMP_MIN_LE_0 True NUMBER - fraction of area with minimum <= 0°C FRAC_AREA_TEMP_MIN_LE_MIN8 True NUMBER - fraction of area with minimum <= -8°C FRAC_AREA_TEMP_MIN_LE_MIN10 True NUMBER - fraction of area with minimum <= -10°C FRAC_AREA_TEMP_MIN_LE_MIN18 True NUMBER - fraction of area with minimum <= -18°C FRAC_AREA_TEMP_MIN_LE_MIN20 True NUMBER - fraction of area with minimum <= -20°C FRAC_AREA_PRECIPITATION_GE_1 True NUMBER - fraction of area with rainfall >= 1mm FRAC_AREA_PRECIPITATION_GE_3 True NUMBER - fraction of area with rainfall >= 3mm FRAC_AREA_PRECIPITATION_GE_5 True NUMBER - fraction of area with rainfall >= 5mm FRAC_AREA_PRECIPITATION_GE_10 True NUMBER - fraction of area with rainfall >= 10mm FRAC_AREA_PRECIPITATION_GE_15 True NUMBER - fraction of area with rainfall >= 15mm FRAC_AREA_PRECIPITATION_GE_30 True NUMBER - fraction of area with rainfall >= 30mm AVG_TEMP_GE_0 True NUMBER °C average temperature above 0°C AVG_TEMP_GE_2 True NUMBER °C average temperature above 2°C AVG_TEMP_GE_4 True NUMBER °C average temperature above 4°C AVG_TEMP_GE_6 True NUMBER °C average temperature above 6°C AVG_TEMP_GE_8 True NUMBER °C average temperature above 8°C AVG_TEMP_GE_10 True NUMBER °C average temperature above 10°C * Not available (relevant) in HIS products ** Not available in EPS, MON and SEA products

WEATHER_SEAS_GRID

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

Structure

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

WEATHER_SEA_GRID_FOR_EXPORT

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER DAY False DATE DAY_OFFSET False NUMBER MEMBER_NO False NUMBER TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER TEMPERATURE_AVG False NUMBER TEMPERATURE_DEW False NUMBER VAPOURPRESSURE False NUMBER WINDSPEED False NUMBER PRECIPITATION False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER RADIATION False NUMBER SNOWWEQ True NUMBER definition: select IDGRID as grid_no ,DAY ,dayoffset as day_offset ,idmember as member_no ,TEMPERATURE_MAX ,TEMPERATURE_MIN ,TEMPERATURE_AVG ,TEMPERATURE_DEW ,VAPOURPRESSURE ,WINDSPEED ,PRECIPITATION ,E0 ,ES0 ,ET0 ,RADIATION ,SNOWWEQ from WEATHER_seas_GRID

other datasets

content
4.1 DATES_75_15
4.2 GRIDS
4.3 GRIDS_FOR_BIOMA
4.4 SYSTABLES
4.5 TASKS

DATES_75_15

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

Structure
Attribute Constraint Type Unit Comment DAY False DATE DAYNO_WK False NUMBER WEEK False NUMBER DAYNO_MON False NUMBER MONTH False NUMBER DAYNO_YR False NUMBER YEAR False NUMBER DAYNO_DEC False NUMBER DECADE False NUMBER DEC_MONTH False VARCHAR2 JULIAN False NUMBER SYS_STS9Y7#F4BCLHQNV3KK1F0LNA$ True NUMBER

GRIDS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDGRID False NUMBER LATITUDE False NUMBER LONGITUDE False NUMBER HAS_LAND False VARCHAR2 ALTITUDE False NUMBER

GRIDS_FOR_BIOMA

• Description:
• Use:
• Type: View
• Remarks:

Structure
Attribute Constraint Type Unit Comment ALTITUDE False NUMBER GRID_NO False NUMBER LATITUDE False NUMBER LONGITUDE False NUMBER definition: select altitude as altitude , idgrid as grid_no , latitude as latitude , longitude as longitude from grids

SYSTABLES

• Description:
• Use:
• Type: Table
• Remarks:

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

TASKS

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment TASK_ID False NUMBER - MODEL False VARCHAR2 - DAY False DATE date STATUS* False NUMBER - status of the tasks. Values 0-6, 9 TIMESTAMP False DATE date-time FRACTION True NUMBER - fraction of weather (of type 'MODEL') available MCOMMENT True VARCHAR2 - comment (updated by daemon or update manually by operator) * Status: 0: weather not yet available 1: weather available, ready to start BIOMA 2: finished BIOMA at STU resolution 3: finished loading results at STU resolution 4: finished aggregation results to EMU resolution 5: finished aggregation results to GRID resolution 6: finished aggregation results to REGION resolution 9: used for manually canceling or postponing a BIOMA run. definition: select TASK_ID ,MODEL ,DAY ,STATUS ,TIMESTAMP ,FRACTION ,MCOMMENT from eurman.tasks where model in ('OBS+OPE','OPE','ENS','ENSEXT','SEAS') and day >= to_date('01-01-2016','dd-mm-yyyy') order by task_id

synonyms

content
5.1 AEZ
5.2 AGGREGATION_AREAS
5.3 CMETEO_ADMIN
5.4 CMETEO_AEZ_GRID_LANDCOVERS
5.5 CMETEO_AGGREGATION_AREAS
5.6 CMETEO_CROPS
5.7 CMETEO_GRID_LANDCOVER_AREAS
5.8 CMETEO_GRID_WEATHER
5.9 CMETEO_LANDCOVERS
5.10 CMETEO_PROCESS
5.11 CMETEO_REGIONS
5.12 CMETEO_REGION_GRID_LANDCOVERS
5.13 CMETEO_REGION_MAPPINGS
5.14 CMETEO_REGION_WEATHER
5.15 CMETEO_REJECTED_WEATHER
5.16 CROP
5.17 CROP_LANDCOVER
5.18 DATELIST
5.19 DAY_DECADEYEAR
5.20 EMU
5.21 LINK_EMU_REGION_LANDCOVER
5.22 LINK_REGION_GRID_LANDCOVER
5.23 REGION
5.24 REGION_INFO
5.25 REGION_MAPPINGS
5.26 REGLISTS
5.27 SMU_SUITABILITY
5.28 SOIL_ASSOCIATION_COMPOSITION
5.29 STAT_CROP
5.30 SUITABILITY
5.31 TD_THRESHOLD_VALUE
5.32 TD_THRESHOLD_VALUES

AEZ

• Description: synonym to oracle package
• Use: use to references the tables REGION_DESCRIPTIONS and REGION_MAPPINGS
• Type: Synonym ➞ AEZ@_CGMS12EU
• Remarks:

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: Synonym ➞ AGGREGATION@AREAS_CGMS12EU
• Remarks: none

* '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)

CMETEO_ADMIN

• Description: synonym to oracle package
• Use:
• Type: Synonym ➞ CMETEO@ADMIN_EURMAN
• Remarks: none

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: Synonym ➞ CMETEO@AEZ_GRID_LANDCOVERS_CGMS12EU
• Remarks: user defined, derived from GIS

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: Synonym ➞ CMETEO@AGGREGATION_AREAS_CGMS12EU
• Remarks: none

* All attributes Nullable in table versions ** Not in view, only in table

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 ➞ CMETEO@CROPS_CGMS12EU
• 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.

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 ➞ CMETEO@REGION_GRID_LANDCOVERS_CGMS12EU
• Remarks: none

CMETEO_GRID_WEATHER

• Description: weather indicators per grid
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: Synonym ➞ CMETEO@WEATHER_OPE_GRID_CGFS14EU
• Remarks:

* All attributes Nullable in table versions

CMETEO_LANDCOVERS

• Description: List of landcovers or crops to be evaluated in CMETEO

• Use: input for cmeteo, renaming columns to a standardized naming
• Type: Synonym ➞ CMETEO@LANDCOVERS_CGMS12EU
• Remarks:

* All attributes Nullable in table versions

CMETEO_PROCESS

• Description: synonym to oracle package
• Use:
• Type: Synonym ➞ CMETEO@PROCESS_EURMAN
• Remarks: none

CMETEO_REGIONS

• Description:
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: Synonym ➞ CMETEO@REGIONS_EURMAN
• Remarks:

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: Synonym ➞ CMETEO@REGION_GRID_LANDCOVERS_CGMS12EU
• Remarks: user defined, derived from GIS

CMETEO_REGION_MAPPINGS

• Description: regions and their relations (mappings)
• Use: input for cmeteo
• Type: Synonym ➞ CMETEO@REGION_MAPPINGS_EURMAN
• Remarks:

CMETEO_REGION_WEATHER

• Description: weather indicators per region
• Use: input for cmeteo, renaming columns to a standardized naming
• Type: Synonym ➞ CMETEO@WEATHER_OPE_REGION_CGFS14EU
• Remarks:

CMETEO_REJECTED_WEATHER

• Description: rejected weather
• Use: log table for cmeteo
• Type: Synonym ➞ CMETEO@REJECTED_WEATHER_EURMAN
• Remarks:

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: Synonym ➞ CROP@_CGMS12EU
• 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.

* CROP_NO in
1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51 ** LANDCOVER_ID values:

• 101 Arable Land
• 102 Non-irrigated arable land
• 103 Agricultural areas
• 104 Pasture
• 105 Temporary forage
• 106 Rice

CROP_LANDCOVER

• Description: List of crop and landcovers

• Use: source for various views & synonyms
• Type: Synonym ➞ CROP@LANDCOVER_CGMS12EU
• Remarks:

DATELIST

• Description:
• Use:
• Type: Synonym ➞ DATELIST@_EURMAN
• Remarks:

DAY_DECADEYEAR

• Description: synonym to oracle package
• Use: view on DATE_GENERATOR package
• Type: Synonym ➞ DAY@DECADEYEAR_EURMAN
• Remarks: none

EMU

• Description: the intersection of the soil map and the grid
• Use: input/reference table for the crop simulation process
• Type: Synonym ➞ EMU@_CGMS12EU
• Remarks: user defined, derived from GIS, provides the link to the GIS

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: Synonym ➞ LINK@EMU_REGION_LANDCOVER_CGMS12EU
• Remarks:

LINK_REGION_GRID_LANDCOVER

• Description: landcover areas for each intersection of grid and NUTS region (only level 3).
• Use: input for cmeteo
• Type: Synonym ➞ LINK@REGION_GRID_LANDCOVER_CGMS12EU
• Remarks: user defined, derived from GIS

REGION

• Description: Administrative regions
• Use: input for monitoring extreme weather events
• Type: Synonym ➞ REGION@_CGMS12EU
• Remarks:

* According to the 'NUTS' nomenclature (see Administrative_regions).

REGION_INFO

• Description:
• Use:
• Type: Synonym ➞ REGION@INFO_EURMAN
• Remarks:

REGION_MAPPINGS

• Description: regions and their relations (mappings)
• Use: used by many object to find relation between regions of different levels.
• Type: Synonym ➞ REGION@MAPPINGS_CGMS12EU
• Remarks: none

* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.

REGLISTS

• Description: synonym to oracle package
• Use: link to REGLISTS
• Type: Synonym ➞ REGLISTS@_EURMAN
• Remarks: none

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: Synonym ➞ SMU@SUITABILITY_CGMS12EU
• Remarks: this table needs to be recalculated whenever the simulation_unit table changes

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: Synonym ➞ SOIL@ASSOCIATION_COMPOSITION_CGMS12EU
• Remarks: derived from the soil map

STAT_CROP

• Description:
• Use:
• Type: Synonym ➞ STAT@CROP_CGMS12EU
• Remarks:

SUITABILITY

• Description: the suitable STUs for each crop _ group
• Use: used to derive the simulation_unit table
• Type: Synonym ➞ SUITABILITY@_CGMS12EU
• Remarks: user defined, derived from the soil map

TD_THRESHOLD_VALUE

• Description:
• Use:
• Type: Synonym ➞ TD@THRESHOLD_VALUE_EURMAN
• Remarks:

TD_THRESHOLD_VALUES

• Description:
• Use:
• Type: Synonym ➞ TD@THRESHOLD_VALUES_EURMAN
• Remarks: