Appendix 5: Database objects/CGMS12old

From Agri4castWiki
Revision as of 14:17, 15 July 2010 by Hendrik (talk | contribs)
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

METDATA

(daily station weather)

Field Contraint Type Unit
STATION_NUMBER (station number) NOT NULL NUMBER(5) -
DAY (calendar day) NOT NULL DATE -
CLOUD_24_TOTAL (not used in CGMS) - NUMBER(6,2) oktas
CLOUD_24_LOW (not used in CGMS) - NUMBER(6,2) oktas
CLOUD_24_MIDDLE (not used in CGMS) - NUMBER(6,2) oktas
CLOUD_24_HIGH (not used in CGMS) - NUMBER(6,2) oktas
SUNSHINE (daily sunshine duration) (2) - NUMBER(6,2) h
RAD_MEA (daily global radiation at surface) (1) - NUMBER(11,2) KJ.m-2.d-1
TEMP_MIN (minimum air temperature) (3,4) - NUMBER(6,2) °C
TEMP_MAX (maximum air temperature) (3,4) - NUMBER(6,2) °C
VAP_PRES (daily mean vapor pressure) - NUMBER(6,2) hPa
WIND_MEA (not used in CGMS) - NUMBER(6,2) m.s-1
WIND_10 (daily mean wind speed at 10 m height) - NUMBER(6,2) m.s-1
RAIN (daily rainfall) - NUMBER(6,2) mm.d-1
TEMP_06 (not used in CGMS) - NUMBER(6,2) °C
HUM_06 (not used in CGMS) - NUMBER(6,2)  %
TEMP_09 (not used in CGMS) - NUMBER(6,2) °C
HUM_09 (not used in CGMS) - NUMBER(6,2)  %
TEMP_12 (not used in CGMS) - NUMBER(6,2) °C
HUM_12 (not used in CGMS) - NUMBER(6,2)  %
TEMP_15 (not used in CGMS) - NUMBER(6,2) °C
HUM_15 (not used in CGMS) - NUMBER(6,2)  %
TEMP_18 (not used in CGMS) - NUMBER(6,2) °C
HUM_18 (not used in CGMS) - NUMBER(6,2)  %
STATE_SOIL (not used in CGMS) - NUMBER(6,2) -
VAP_PRES_DEF (not used in CGMS) - NUMBER(6,2) hPa
SLOPE_VP_VS_T (not used in CGMS) - NUMBER(6,3) hPa.°C-1
CLOUD_DAYTIME_TOTAL (daily mean of total cloud cover) (3) - NUMBER(6,2) oktas
CLOUD_DAYTIME_LOW (not used in CGMS) - NUMBER(6,2) oktas
CLOUD_SHADOW (not used in CGMS) - NUMBER(6,2) oktas
VISIBILITY (not used in CGMS) - NUMBER(6,1) -
SNOW_DEPTH (daily mean snow depth) - NUMBER(6,2) cm

1 this variable returns directly radiation

2 this variable can be used to derive radiation via the angstrom formula

3 these variables can be used to derive radiation via the Supit formula

4 these variables can be used to derive radiation via the Hargreaves formula


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

SYSCON

(description of system variables)

Field Contraint Type Unit
NAME (name of variable) NOT NULL VARCHAR2(30) -
VALUE (value of variable) NOT NULL VARCHAR2(30) -


WEATHER_DATA_AVAILABILITY

(availability of stations for interpolation)

Field Contraint Type Unit
YEAR (year) NOT NULL NUMBER(4) -
WMO_NO (station number) NOT NULL NUMBER(5,0) -
AVAILABILITY_TYPE (group of variable(s)) NOT NULL VARCHAR2(30) -