Difference between revisions of "Appendix 5: Database objects/CGMS12old"

From Agri4castWiki
Jump to: navigation, search
(SUPIT_CONSTANTS)
(SUPIT_REFERENCE_STATIONS)
Line 72: Line 72:
 
(constants per reference station to derive radiation)
 
(constants per reference station to derive radiation)
  
{|class="simple_table"
+
{|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