Difference between revisions of "Appendix 5: Database objects/CGMS12old"
From Agri4castWiki
(→SUPIT_CONSTANTS) |
(→SUPIT_REFERENCE_STATIONS) |
||
| Line 72: | Line 72: | ||
(constants per reference station to derive radiation) | (constants per reference station to derive radiation) | ||
| − | {|class=" | + | {|class="wikitable" |
!Field !! Contraint !! Type !! Unit | !Field !! Contraint !! Type !! Unit | ||
|- | |- | ||
| − | |STATION_NAME (station number) || not null || varchar2(32) || - | + | |STATION_NAME (station number) || not null || varchar2(32 BYTE) || - |
|- | |- | ||
|LATITUDE (latitude) || not null || number(7,5) || dd | |LATITUDE (latitude) || not null || number(7,5) || dd | ||
| Line 81: | Line 81: | ||
|LONGITUDE (longitude) || not null || number(8,5) || dd | |LONGITUDE (longitude) || not null || number(8,5) || dd | ||
|- | |- | ||
| − | |ALTITUDE (altitude) || not null || number(5) || m | + | |ALTITUDE (altitude) || not null || number(5,0) || m |
|- | |- | ||
|ANGSTROM_A (angstrom constant A using sun shine duration) || - || number || - | |ANGSTROM_A (angstrom constant A using sun shine duration) || - || number || - | ||
Revision as of 15:59, 14 July 2010
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 |
