Appendix 5: Database objects/CGMS12old

From Agri4castWiki
Revision as of 15:59, 14 July 2010 by Raymond (talk | contribs) (SUPIT_REFERENCE_STATIONS)
Jump to: navigation, search

CALCULATED_WEATHER

(daily weather derived from other variables)

Field Contraint Type Unit
WMO_NO (station number) not null number(5,0) -
DAY (calendar day) not null date -
E0 (daily transpiration of water surface) - number mm.d-1
ES0 (daily transpiration of wet bare soil) - number mm.d-1
ET0 (daily transpiration of crop canopy) - number mm.d-1
CALCULATED_RADIATION (daily radiation at surface) - number(9) KJ.m-2.d-1

GRID_WEATHER

(interpolated daily grid weather)

Field Contraint Type Unit
GRID_NO (grid number) not null number(8,0) -
DAY (calendar day) not null date -
MAXIMUM_TEMPERATURE (maximum air temperature) not null number(3,1) 0C
MINIMUM_TEMPERATURE (minimum air temperature) not null number(3,1) 0C
VAPOR_PRESSURE (mean daily vapor pressure) not null number(4,2) hPa
WINDSPEED (mean daily wind speed at 10 m height) not null number(5,1) m.s-1
RAINFALL (daily rainfall) not null number(4,1) mm.d-1
E0 (daily transpiration of water surface) not null number mm.d-1
ES0 (daily transpiration of wet bare soil) not null number mm.d-1
ET0 (daily transpiration of crop canopy) not null number mm.d-1
CALCULATED_RADIATION (daily radiation at surface) not null number(6) KJ.m-2.d-1
SNOW_DEPTH (daily mean snow depth) - number(6,2) cm

SUPIT_CONSTANTS

(constants per station to derive radiation)

Field Contraint Type Unit
WMO_NO (station number) not null number(5,0) -
ANGSTROM_A (ångström constant A using sun shine duration) not null number -
ANGSTROM_B (ångström constant B using sun shine duration) not null number -
SUPIT_A (supit constant A using cloud cover and temperature) not null number -
SUPIT_B (supit constant B using cloud cover and temperature) not null number -
SUPIT_C (supit constant C using cloud cover and temperature) not null number KJ.m-2.d-1
HARGREAVES_A (hargreaves constant A using temperature) not null number -
HARGREAVES_B (hargreaves constant B using temperature) not null number KJ.m-2.d-1

SUPIT_REFERENCE_STATIONS

(constants per reference station to derive radiation)

Field Contraint Type Unit
STATION_NAME (station number) not null varchar2(32 BYTE) -
LATITUDE (latitude) not null number(7,5) dd
LONGITUDE (longitude) not null number(8,5) dd
ALTITUDE (altitude) not null number(5,0) m
ANGSTROM_A (angstrom constant A using sun shine duration) - number -
ANGSTROM_B (angstrom constant B using sun shine duration) - number -
SUPIT_A (supit constant A using cloud cover and temperature) - number -
SUPIT_B (supit constant B using cloud cover and temperature) - number -
SUPIT_C (supit constant C using cloud cover and temperature) - number KJ.m-2.d-1
HARGREAVES_A (hargreaves constant A using temperature) - number -
HARGREAVES_B (hargreaves constant A using temperature) - number KJ.m-2.d-1