Difference between revisions of "Appendix 5: Database objects/CGMS12old"
From Agri4castWiki
(→SYSCON) |
(→STATIONS_PER_GRID) |
||
| Line 165: | Line 165: | ||
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || - | |GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || - | ||
|- | |- | ||
| − | |YEAR (year) || NOT NULL || NUMBER(4) || - | + | |YEAR (year) || NOT NULL || NUMBER(4,0) || - |
|- | |- | ||
| − | |RAIN_STATION (station number used for rainfall) || NOT NULL || NUMBER(5) || - | + | |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) || - | + | |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) || - | + | |TEMP_STATION_2 (second station used for interpolation temperature) || - || NUMBER(5,0) || - |
|- | |- | ||
| − | |TEMP_STATION_3 (third station used for interpolation temperature) || - || NUMBER(5) || - | + | |TEMP_STATION_3 (third station used for interpolation temperature) || - || NUMBER(5,0) || - |
|- | |- | ||
| − | |TEMP_STATION_4 (fourth station used for interpolation temperature) || - || NUMBER(5) || - | + | |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) || - | + | |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) || - | + | |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) || - | + | |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) || - | + | |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 | |RAIN_SCORE (similarity score for station used rainfall) || - || NUMBER(6,2) || km | ||
| Line 191: | Line 191: | ||
|REST_SCORE (similarity score for first station used interpolation other variables) || - || NUMBER(6,2) || km | |REST_SCORE (similarity score for first station used interpolation other variables) || - || NUMBER(6,2) || km | ||
|} | |} | ||
| − | |||
===SUPIT_CONSTANTS=== | ===SUPIT_CONSTANTS=== | ||
Revision as of 18:08, 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) | °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) | - |
| 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) | - |
| DAY (calendar day for leap year) | 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 closed crop canopy) | NOT NULL | NUMBER | mm.d-1 |
| CALCULATED_RADIATION (daily radiation at surface) | NOT NULL | NUMBER(9) | 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 | - |
