Appendix 5: Database objects/CGMS14GLO

content
1. GRID-datasets
2. LINK-datasets
3. WEATHER-datasets
4. other datasets
5. synonyms

GRID-datasets

content
1.1 GRID_ENS
1.2 GRID_ENSEXT
1.3 GRID_ENSEXT_DOWN_ALGORITHMS
1.4 GRID_ENS_DOWN_ALGORITHMS
1.5 GRID_ENS_DOWN_ALGORITHMS_RAW
1.6 GRID_ERA
1.7 GRID_ERA_DOWN_ALGORITHMS
1.8 GRID_HIS
1.9 GRID_MAPPING
1.10 GRID_SEAS
1.11 GRID_SEAS_DOWN_ALGORITHMS
1.12 GRID_SEAS_DOWN_ALGORITHMS_RAW
1.13 GRID_SENEGAL

GRID_ENS

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

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

GRID_ENSEXT

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

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

GRID_ENSEXT_DOWN_ALGORITHMS

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

Structure

Attribute Constraint Type Unit Comment IDGRID False NUMBER NCASES False NUMBER T2M_INT False NUMBER T2M_SLOPE False NUMBER T2M_T1 False NUMBER T2M_T2 False NUMBER T2M_T3 False NUMBER T2M_T4 False NUMBER TX_INT False NUMBER TX_SLOPE False NUMBER TX_T1 False NUMBER TX_T2 False NUMBER TX_T3 False NUMBER TX_T4 False NUMBER TN_INT False NUMBER TN_SLOPE False NUMBER TN_T1 False NUMBER TN_T2 False NUMBER TN_T3 False NUMBER TN_T4 False NUMBER TD_INT False NUMBER TD_SLOPE False NUMBER TD_T1 False NUMBER TD_T2 False NUMBER TD_T3 False NUMBER TD_T4 False NUMBER RR_INT False NUMBER RR_SLOPE False NUMBER RR_T1 False NUMBER RR_T2 False NUMBER RR_T3 False NUMBER RR_T4 False NUMBER SSRD_INT False NUMBER SSRD_SLOPE False NUMBER SSRD_T1 False NUMBER SSRD_T2 False NUMBER SSRD_T3 False NUMBER SSRD_T4 False NUMBER SN_INT False NUMBER SN_SLOPE False NUMBER SN_T1 False NUMBER SN_T2 False NUMBER SN_T3 False NUMBER SN_T4 False NUMBER FFM_INT False NUMBER FFM_SLOPE False NUMBER FFM_T1 False NUMBER FFM_T2 False NUMBER FFM_T3 False NUMBER FFM_T4 False NUMBER SH_INT False NUMBER SH_SLOPE False NUMBER SH_T1 False NUMBER SH_T2 False NUMBER SH_T3 False NUMBER SH_T4 False NUMBER TCC_INT False NUMBER TCC_SLOPE False NUMBER TCC_T1 False NUMBER TCC_T2 False NUMBER TCC_T3 False NUMBER TCC_T4 False NUMBER

GRID_ENS_DOWN_ALGORITHMS

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

Structure

Attribute Constraint Type Unit Comment IDGRID False NUMBER NCASES False NUMBER T2M_INT False NUMBER T2M_SLOPE False NUMBER T2M_T1 False NUMBER T2M_T2 False NUMBER T2M_T3 False NUMBER T2M_T4 False NUMBER TX_INT False NUMBER TX_SLOPE False NUMBER TX_T1 False NUMBER TX_T2 False NUMBER TX_T3 False NUMBER TX_T4 False NUMBER TN_INT False NUMBER TN_SLOPE False NUMBER TN_T1 False NUMBER TN_T2 False NUMBER TN_T3 False NUMBER TN_T4 False NUMBER TD_INT False NUMBER TD_SLOPE False NUMBER TD_T1 False NUMBER TD_T2 False NUMBER TD_T3 False NUMBER TD_T4 False NUMBER RR_INT False NUMBER RR_SLOPE False NUMBER RR_T1 False NUMBER RR_T2 False NUMBER RR_T3 False NUMBER RR_T4 False NUMBER SSRD_INT False NUMBER SSRD_SLOPE False NUMBER SSRD_T1 False NUMBER SSRD_T2 False NUMBER SSRD_T3 False NUMBER SSRD_T4 False NUMBER SN_INT False NUMBER SN_SLOPE False NUMBER SN_T1 False NUMBER SN_T2 False NUMBER SN_T3 False NUMBER SN_T4 False NUMBER FFM_INT False NUMBER FFM_SLOPE False NUMBER FFM_T1 False NUMBER FFM_T2 False NUMBER FFM_T3 False NUMBER FFM_T4 False NUMBER SH_INT False NUMBER SH_SLOPE False NUMBER SH_T1 False NUMBER SH_T2 False NUMBER SH_T3 False NUMBER SH_T4 False NUMBER TCC_INT False NUMBER TCC_SLOPE False NUMBER TCC_T1 False NUMBER TCC_T2 False NUMBER TCC_T3 False NUMBER TCC_T4 False NUMBER

GRID_ENS_DOWN_ALGORITHMS_RAW

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

Structure

Attribute Constraint Type Unit Comment LON False NUMBER LAT False NUMBER NCASES True NUMBER T2M_INT True NUMBER T2M_SLOPE True NUMBER T2M_T1 True NUMBER T2M_T2 True NUMBER T2M_T3 True NUMBER T2M_T4 True NUMBER TX_INT True NUMBER TX_SLOPE True NUMBER TX_T1 True NUMBER TX_T2 True NUMBER TX_T3 True NUMBER TX_T4 True NUMBER TN_INT True NUMBER TN_SLOPE True NUMBER TN_T1 True NUMBER TN_T2 True NUMBER TN_T3 True NUMBER TN_T4 True NUMBER TD_INT True NUMBER TD_SLOPE True NUMBER TD_T1 True NUMBER TD_T2 True NUMBER TD_T3 True NUMBER TD_T4 True NUMBER RR_INT True NUMBER RR_SLOPE True NUMBER RR_T1 True NUMBER RR_T2 True NUMBER RR_T3 True NUMBER RR_T4 True NUMBER SSRD_INT True NUMBER SSRD_SLOPE True NUMBER SSRD_T1 True NUMBER SSRD_T2 True NUMBER SSRD_T3 True NUMBER SSRD_T4 True NUMBER SN_INT True NUMBER SN_SLOPE True NUMBER SN_T1 True NUMBER SN_T2 True NUMBER SN_T3 True NUMBER SN_T4 True NUMBER FFM_INT True NUMBER FFM_SLOPE True NUMBER FFM_T1 True NUMBER FFM_T2 True NUMBER FFM_T3 True NUMBER FFM_T4 True NUMBER

GRID_ERA

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

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

GRID_ERA_DOWN_ALGORITHMS

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

Structure

Attribute Constraint Type Unit Comment IDGRID False NUMBER NCASES False NUMBER T2M_INT False NUMBER T2M_SLOPE False NUMBER T2M_T1 False NUMBER T2M_T2 False NUMBER T2M_T3 False NUMBER T2M_T4 False NUMBER TX_INT False NUMBER TX_SLOPE False NUMBER TX_T1 False NUMBER TX_T2 False NUMBER TX_T3 False NUMBER TX_T4 False NUMBER TN_INT False NUMBER TN_SLOPE False NUMBER TN_T1 False NUMBER TN_T2 False NUMBER TN_T3 False NUMBER TN_T4 False NUMBER TD_INT False NUMBER TD_SLOPE False NUMBER TD_T1 False NUMBER TD_T2 False NUMBER TD_T3 False NUMBER TD_T4 False NUMBER RR_INT False NUMBER RR_SLOPE False NUMBER RR_T1 False NUMBER RR_T2 False NUMBER RR_T3 False NUMBER RR_T4 False NUMBER SSRD_INT False NUMBER SSRD_SLOPE False NUMBER SSRD_T1 False NUMBER SSRD_T2 False NUMBER SSRD_T3 False NUMBER SSRD_T4 False NUMBER SN_INT False NUMBER SN_SLOPE False NUMBER SN_T1 False NUMBER SN_T2 False NUMBER SN_T3 False NUMBER SN_T4 False NUMBER FFM_INT False NUMBER FFM_SLOPE False NUMBER FFM_T1 False NUMBER FFM_T2 False NUMBER FFM_T3 False NUMBER FFM_T4 False NUMBER SH_INT False NUMBER SH_SLOPE False NUMBER SH_T1 False NUMBER SH_T2 False NUMBER SH_T3 False NUMBER SH_T4 False NUMBER TCC_INT False NUMBER TCC_SLOPE False NUMBER TCC_T1 False NUMBER TCC_T2 False NUMBER TCC_T3 False NUMBER TCC_T4 False NUMBER

GRID_HIS

• 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_25 False NUMBER ALTITUDE_16 False NUMBER

GRID_MAPPING

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

Structure
Attribute Constraint Type Unit Comment IDGRID_A False NUMBER LONGITUDE_A False NUMBER LATITUDE_A False NUMBER IDGRID_J False NUMBER LONGITUDE_J False NUMBER LATITUDE_J False NUMBER

GRID_SEAS

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

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

GRID_SEAS_DOWN_ALGORITHMS

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

Structure

Attribute Constraint Type Unit Comment IDGRID False NUMBER NCASES False NUMBER T2M_INT False NUMBER T2M_SLOPE False NUMBER T2M_T1 False NUMBER T2M_T2 False NUMBER T2M_T3 False NUMBER T2M_T4 False NUMBER TX_INT False NUMBER TX_SLOPE False NUMBER TX_T1 False NUMBER TX_T2 False NUMBER TX_T3 False NUMBER TX_T4 False NUMBER TN_INT False NUMBER TN_SLOPE False NUMBER TN_T1 False NUMBER TN_T2 False NUMBER TN_T3 False NUMBER TN_T4 False NUMBER TD_INT False NUMBER TD_SLOPE False NUMBER TD_T1 False NUMBER TD_T2 False NUMBER TD_T3 False NUMBER TD_T4 False NUMBER RR_INT False NUMBER RR_SLOPE False NUMBER RR_T1 False NUMBER RR_T2 False NUMBER RR_T3 False NUMBER RR_T4 False NUMBER SSRD_INT False NUMBER SSRD_SLOPE False NUMBER SSRD_T1 False NUMBER SSRD_T2 False NUMBER SSRD_T3 False NUMBER SSRD_T4 False NUMBER SN_INT False NUMBER SN_SLOPE False NUMBER SN_T1 False NUMBER SN_T2 False NUMBER SN_T3 False NUMBER SN_T4 False NUMBER FFM_INT False NUMBER FFM_SLOPE False NUMBER FFM_T1 False NUMBER FFM_T2 False NUMBER FFM_T3 False NUMBER FFM_T4 False NUMBER SH_INT False NUMBER SH_SLOPE False NUMBER SH_T1 False NUMBER SH_T2 False NUMBER SH_T3 False NUMBER SH_T4 False NUMBER TCC_INT False NUMBER TCC_SLOPE False NUMBER TCC_T1 False NUMBER TCC_T2 False NUMBER TCC_T3 False NUMBER TCC_T4 False NUMBER

GRID_SEAS_DOWN_ALGORITHMS_RAW

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

Structure

Attribute Constraint Type Unit Comment LON False NUMBER LAT False NUMBER NCASES True NUMBER T2M_INT True NUMBER T2M_SLOPE True NUMBER T2M_T1 True NUMBER T2M_T2 True NUMBER T2M_T3 True NUMBER T2M_T4 True NUMBER TX_INT True NUMBER TX_SLOPE True NUMBER TX_T1 True NUMBER TX_T2 True NUMBER TX_T3 True NUMBER TX_T4 True NUMBER TN_INT True NUMBER TN_SLOPE True NUMBER TN_T1 True NUMBER TN_T2 True NUMBER TN_T3 True NUMBER TN_T4 True NUMBER TD_INT True NUMBER TD_SLOPE True NUMBER TD_T1 True NUMBER TD_T2 True NUMBER TD_T3 True NUMBER TD_T4 True NUMBER RR_INT True NUMBER RR_SLOPE True NUMBER RR_T1 True NUMBER RR_T2 True NUMBER RR_T3 True NUMBER RR_T4 True NUMBER SSRD_INT True NUMBER SSRD_SLOPE True NUMBER SSRD_T1 True NUMBER SSRD_T2 True NUMBER SSRD_T3 True NUMBER SSRD_T4 True NUMBER SN_INT True NUMBER SN_SLOPE True NUMBER SN_T1 True NUMBER SN_T2 True NUMBER SN_T3 True NUMBER SN_T4 True NUMBER FFM_INT True NUMBER FFM_SLOPE True NUMBER FFM_T1 True NUMBER FFM_T2 True NUMBER FFM_T3 True NUMBER FFM_T4 True NUMBER

GRID_SENEGAL

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

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

LINK-datasets

content
2.1 LINK_GRID_COVER
2.2 LINK_GRID_REGION_COVER
2.3 LINK_REGION_COVER

LINK_GRID_COVER

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

Structure
Attribute Constraint Type Unit Comment IDGRID False NUMBER IDCOVER False NUMBER AREA False NUMBER

LINK_GRID_REGION_COVER

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

Structure
Attribute Constraint Type Unit Comment IDREGION False VARCHAR2 IDCOVER False NUMBER IDGRID False NUMBER AREA False NUMBER

LINK_REGION_COVER

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

Structure
Attribute Constraint Type Unit Comment IDREGION False VARCHAR2 IDCOVER False NUMBER AREA False NUMBER

WEATHER-datasets

content
3.1 WEATHER_ENSEXT_GRID
3.2 WEATHER_ENSEXT_GRID_RAW
3.3 WEATHER_ENSEXT_REGIONCOVER
3.4 WEATHER_ENS_GRID
3.5 WEATHER_ENS_GRID_RAW
3.6 WEATHER_ENS_REGIONCOVER
3.7 WEATHER_ERA_GRID
3.8 WEATHER_ERA_GRID_LTA
3.9 WEATHER_ERA_GRID_RAW
3.10 WEATHER_ERA_REGIONCOVER
3.11 WEATHER_HIS_GRID
3.12 WEATHER_HIS_REGCOV_THRESHOLDS
3.13 WEATHER_HIS_REGIONCOVER
3.14 WEATHER_HIS_SENEGAL_AGRICAB
3.15 WEATHER_OPE_GRID
3.16 WEATHER_OPE_REGIONCOVER
3.17 WEATHER_SEAS_GRID
3.18 WEATHER_SEAS_GRID_RAW
3.19 WEATHER_SEAS_REGIONCOVER

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_ENSEXT_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: 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 WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall 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_ENSEXT_REGIONCOVER

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

Structure

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

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 * Not available (relevant) in HIS product ** Not available in EPS, MON and SEA products

WEATHER_ENS_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: 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 WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall 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_STSMIF9I4XIKOJEFH#9W#GQ293 True NUMBER SYS_STS_TSXE_3AO_QZTSW8WZF35L4 True NUMBER * Not available (relevant) in HIS product ** Not available in EPS, MON and SEA products

WEATHER_ENS_REGIONCOVER

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

Structure

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

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_LTA

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

Structure

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

WEATHER_ERA_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: 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 WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall 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_REGIONCOVER

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

Structure

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

WEATHER_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_REGCOV_THRESHOLDS

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

Structure
Attribute Constraint Type Unit Comment IDREGION False VARCHAR2 IDCOVER False NUMBER IDTHRESHOLD False NUMBER DAY False DATE VALUE False NUMBER

WEATHER_HIS_REGIONCOVER

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

Structure

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

WEATHER_HIS_SENEGAL_AGRICAB

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

Structure

Attribute Constraint Type Unit Comment GRID_NO False NUMBER DAY True VARCHAR2 MAXIMUM_TEMPERATURE False NUMBER MINIMUM_TEMPERATURE False NUMBER VAPOUR_PRESSURE False NUMBER WINDSPEED False NUMBER RAINFALL False NUMBER E0 False NUMBER ES0 False NUMBER ET0 False NUMBER CALCULATED_RADIATION False NUMBER SNOW_DEPTH True NUMBER definition: select s.idgrid AS grid_no , TO_CHAR(w.day,'dd/mm/yyyy') AS DAY , w.temperature_max AS maximum_temperature , w.temperature_min AS minimum_temperature , w.vapourpressure AS vapour_pressure , w.windspeed AS windspeed , w.precipitation AS rainfall , w.e0 AS e0 , w.es0 AS es0 , w.et0 AS et0 , w.radiation AS calculated_radiation , w.snowdepth AS snow_depth FROM weather_his_grid w , grid_his g , grid_senegal s , dates_75_15 d -- JOIN CLAUSE WHERE w.idgrid = g.idgrid and g.latitude = s.latitude and g.longitude = s.longitude and w.day = d.day -- FILTER CLAUSE and d.year = 2015 and d.decade = 29 -- and s.idgrid = 362095

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 SYS_STS29D$RZ#ATMM___ICOPXSFQ5 True NUMBER SYS_STS_P8YLVRDMY2IUA_G#K3S7TE True NUMBER * Not available (relevant) in HIS product ** Not available in EPS, MON and SEA products

WEATHER_OPE_REGIONCOVER

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

Structure

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

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_SEAS_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: 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 WINDSPEED False NUMBER m.s-1 mean daily wind speed at 10 m height PRECIPITATION False NUMBER mm.d-1 daily rainfall 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_SEAS_REGIONCOVER

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

Structure

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

other datasets

content
4.1 DATES_75_15
4.2 GLOBAL_REGION_ELEMENTS
4.3 REGIONS
4.4 SYSTABLES

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

GLOBAL_REGION_ELEMENTS

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

Structure

Attribute Constraint Type Unit Comment IDREGION_ELEMENT False NUMBER IDORIGINAL_CODE False VARCHAR2 IDREGION False VARCHAR2 CONTINENT False VARCHAR2 REGION False VARCHAR2 GLOBAL_NAME False VARCHAR2 LOCAL_NAME True VARCHAR2 REGION_LEVEL False NUMBER POPULATION True NUMBER STANDARD False VARCHAR2 IDFATHER True NUMBER IDREGION_SOURCE False NUMBER REGION_SOURCE False VARCHAR2 definition: select re.idregion_element , re.idoriginal_code , re.idregion , r.continent , r.region , r.name global_name , re.name local_name , re.region_level , r.population , re.standard , re.idfather , re.idregion_source , rs.region_source from region_elements@CGMS14SYS_ASSISTDAS re , regions@CGMS14SYS_ASSISTDAS r , region_sources@CGMS14SYS_ASSISTDAS rs where re.idregion = r.idregion and re.idregion_source = rs.idregion_source

REGIONS

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

Structure

Attribute Constraint Type Unit Comment IDREGION False VARCHAR2 IDFATHER True NUMBER REGION False VARCHAR2 GLOBAL_NAME False VARCHAR2 LOCAL_NAME True VARCHAR2 REGION_LEVEL False NUMBER CONTINENT False VARCHAR2 POPULATION True NUMBER IDREGION_ELEMENT False NUMBER IDORIGINAL_CODE False VARCHAR2 definition: select lrc.idregion , idfather , region , global_name , local_name , region_level , continent , population , idregion_element , idoriginal_code from global_region_elements re , link_region_cover lrc where region_source = 'GAUL' and lrc.idregion = re.idregion and lrc.idcover = 1000

SYSTABLES

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

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

synonyms

content
5.1 GRID_OPE
5.2 LOG

GRID_OPE

• Description:
• Use:
• Type: Synonym ➞ GRID@HIS_CGMS14GLO
• Remarks:

LOG

• Description:
• Use:
• Type: Synonym ➞ LOG@_None
• Remarks: