Difference between revisions of "Appendix 5: Database objects/CGMS12old"
From Agri4castWiki
| Line 174: | Line 174: | ||
|- | |- | ||
|HARGREAVES_B (hargreaves constant A using temperature) || - || number || KJ.m-2.d-1 | |HARGREAVES_B (hargreaves constant A using temperature) || - || number || KJ.m-2.d-1 | ||
| + | |} | ||
| + | |||
| + | ===SYSCON=== | ||
| + | (description of system variables) | ||
| + | {|class="wikitable" | ||
| + | !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) | ||
| + | {|class="wikitable" | ||
| + | !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) || - | ||
|} | |} | ||
Revision as of 14:17, 15 July 2010
Contents
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) | - |
