Appendix 5: Database objects/CGMS12old

From Agri4castWiki
Revision as of 17:13, 15 July 2010 by Hendrik (talk | contribs) (METDATA)
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) °C
MINIMUM_TEMPERATURE (minimum air temperature) NOT NULL NUMBER(3,1) °C
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,0) -
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

REFERENCE_WEATHER

(long term average daily station weather)

Field Contraint Type Unit
WMO_NO (station number) NOT NULL NUMBER(5,0) -
DAY (calendar day for leap year) NOT NULL DATE -
MAXIMUM_TEMPERATURE (maximum air temperature) - NUMBER(3,1) °C
MINIMUM_TEMPERATURE (minimum air temperature) - NUMBER(3,1) °C
VAPOR_PRESSURE (mean daily vapor pressure) - NUMBER(4,2) hPa
WINDSPEED (mean daily wind speed at 10 m height) - NUMBER(5,1) m.s-1
RAINFALL (daily rainfall) - NUMBER(4,1) mm.d-1
E0 (daily transpiration of water surface) - NUMBER(4,2) mm.d-1
ES0 (daily transpiration of wet bare soil) - NUMBER(4,2) mm.d-1
ET0 (daily transpiration of closed crop canopy) - NUMBER(4,2) mm.d-1
CALCULATED_RADIATION (daily radiation at surface) - NUMBER(9,0) KJ.m-2.d-1
SNOW_DEPTH (daily mean snow depth) - NUMBER(6,2) cm

STATIONS_PER_GRID

(stations used for calculation weather per grid cell for historic years)

Field Contraint Type Unit
GRID_NO (grid number) NOT NULL NUMBER(8,0) -
YEAR (year) NOT NULL NUMBER(4,0) -
RAIN_STATION (station number used for rainfall) NOT NULL NUMBER(5,0) -
TEMP_STATION_1 (first station used for interpolation temperature) NOT NULL NUMBER(5,0) -
TEMP_STATION_2 (second station used for interpolation temperature) - NUMBER(5,0) -
TEMP_STATION_3 (third station used for interpolation temperature) - NUMBER(5,0) -
TEMP_STATION_4 (fourth station used for interpolation temperature) - NUMBER(5,0) -
REST_STATION_1 (first station used for interpolation other variables) NOT NULL NUMBER(5,0) -
REST_STATION_2 (second station used for interpolation other variables) - NUMBER(5,0) -
REST_STATION_3 (third station used for interpolation other variables) - NUMBER(5,0) -
REST_STATION_4 (fourth station used for interpolation other variables) - NUMBER(5,0) -
RAIN_SCORE (similarity score for station used rainfall) - NUMBER(6,2) km
TEMP_SCORE (similarity score for first station used interpolation temperature) - NUMBER(6,2) km
REST_SCORE (similarity score for first station used interpolation other variables) - NUMBER(6,2) km

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
SNAME (name of variable) NOT NULL VARCHAR2(30) -
SVALUE (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,0) -
WMO_NO (station number) NOT NULL NUMBER(5,0) -
AVAILABILITY_TYPE (group of variable(s)) NOT NULL VARCHAR2(30) -

WEATHER_STATION

(description of weather stations)

Field Contraint Type Unit
WMO_NO (station number) NOT NULL NUMBER(5,0) -
WMO_NAME (station name) NOT NULL VARCHAR2(32) -
LATITUDE (latitude) NOT NULL NUMBER(7,5) dd
LONGITUDE (longitude) NOT NULL NUMBER(8,5 dd
Y_COORDINATE (not used in CGMS) NOT NULL NUMBER(13,5) m
X_COORDINATE (not used in CGMS) NOT NULL NUMBER(13,5) m
ALTITUDE (altitude) NOT NULL NUMBER(5,0) m
CLIMATE_BARRIER_NO (climate barrier) NOT NULL NUMBER(2,0) -
COUNTRY_CODE (country code) NOT NULL VARCHAR2(26) -
DISTANCE_TO_COAST (distance to coast) NOT NULL NUMBER(4,0) km
PERCENT_COMPLETE (threshold for yearly available observations) - NUMBER(3,0)  %
RELIABLE_STATION (sufficient archive for several elements) NOT NULL NUMBER -