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

From Agri4castWiki
Jump to: navigation, search
Line 6: Line 6:
 
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
 
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
 
|-
 
|-
|DAY (calendar day) || NOT NULL || date || -
+
|DAY (calendar day) || NOT NULL || DATE || -
 
|-
 
|-
 
|E0 (daily transpiration of water surface) || - || NUMBER|| mm.d-1
 
|E0 (daily transpiration of water surface) || - || NUMBER|| mm.d-1
Line 24: Line 24:
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || -
 
|GRID_NO (grid number) || NOT NULL || NUMBER(8,0) || -
 
|-
 
|-
|DAY (calendar day) || NOT NULL || date || -
+
|DAY (calendar day) || NOT NULL || DATE || -
 
|-
 
|-
 
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER(3,1) || °C
 
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER(3,1) || °C
Line 132: Line 132:
 
|WMO_NO (station number) || NOT NULL || NUMBER(5) || -
 
|WMO_NO (station number) || NOT NULL || NUMBER(5) || -
 
|-
 
|-
|DAY (calendar day for leap year) || NOT NULL || date || -
+
|DAY (calendar day for leap year) || NOT NULL || DATE || -
 
|-
 
|-
 
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER((3,1) || °C
 
|MAXIMUM_TEMPERATURE (maximum air temperature) || NOT NULL || NUMBER((3,1) || °C
Line 161: Line 161:
 
!Field !! Contraint !! Type !! Unit
 
!Field !! Contraint !! Type !! Unit
 
|-
 
|-
|WMO_NO (station number) || not null || number(5,0) || -
+
|WMO_NO (station number) || NOT NULL || NUMBER(5,0) || -
 
|-
 
|-
|ANGSTROM_A (ångström constant A using sun shine duration) || not null || number || -
+
|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 || -
+
|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_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_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
+
|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_A (hargreaves constant A using temperature) || NOT NULL || NUMBER || -
 
|-
 
|-
|HARGREAVES_B (hargreaves constant B using temperature) || not  null || number || KJ.m-2.d-1
+
|HARGREAVES_B (hargreaves constant B using temperature) || NOT NULL || NUMBER || KJ.m-2.d-1
 
|}
 
|}
  
Line 184: Line 184:
 
!Field !! Contraint !! Type !! Unit
 
!Field !! Contraint !! Type !! Unit
 
|-
 
|-
|STATION_NAME (station number) || not null || varchar2(32 BYTE) || -
+
|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
 
|-
 
|-
|LONGITUDE (longitude) || not null || number(8,5) || dd
+
|LONGITUDE (longitude) || NOT NULL || NUMBER(8,5) || dd
 
|-
 
|-
|ALTITUDE (altitude) || not  null || number(5,0) || 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 || -
 
|-
 
|-
|ANGSTROM_B (angstrom constant B 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_A (supit constant A using cloud cover and temperature) || -  || NUMBER || -
 
|-
 
|-
|SUPIT_B (supit constant B 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
+
|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_A (hargreaves constant A using temperature) || - || NUMBER || -
 
|-
 
|-
|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
 
|}
 
|}
  

Revision as of 15:55, 15 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) °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


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) -