Difference between revisions of "Appendix 5: Database objects/CGMS12old"
Wimdewinter (talk | contribs) (comment header typo) |
Wimdewinter (talk | contribs) (comments moved from field name to comments field) |
||
Line 47: | Line 47: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |CROP_NO | + | |CROP_NO || NOT NULL || NUMBER(4) || - || crop number |
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER(10) || - || administrative region id |
|- | |- | ||
− | |YEAR | + | |YEAR || NOT NULL || NUMBER(4) || - || year for which cultivated area is valid |
|- | |- | ||
− | |AREA_CULTIVATED | + | |AREA_CULTIVATED || - || NUMBER || 10^3 ha || cultivated area |
|- | |- | ||
− | |SOURCE* | + | |SOURCE* || NOT NULL || VARCHAR2(40) || - || source from which area was derived |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || day on which area was derived |
|- | |- | ||
− | |PERCENTAGE | + | |PERCENTAGE || - || NUMBER(5,2) || - || percentage of area cultivated; not used; NoData |
|- | |- | ||
− | |AREA_ORIGINAL | + | |AREA_ORIGINAL || - || NUMBER || 10^3 ha || backup to store original cultivated area in this was adapted |
|- | |- | ||
− | |TREATMENT | + | |TREATMENT || - || VARCHAR2(50 byte) || - || calculation method |
|- | |- | ||
− | |NOTE | + | |NOTE || - || VARCHAR2(50 byte) || - || free comments |
|} | |} | ||
<nowiki>*</nowiki> 'SOURCE' can have the following values: | <nowiki>*</nowiki> 'SOURCE' can have the following values: | ||
Line 95: | Line 95: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | RUNID | + | | RUNID ||NOT NULL||NUMBER(8)|| - || identification number of run |
|- | |- | ||
− | | DBUSER | + | | DBUSER ||-||VARCHAR2(20)|| - || username |
|- | |- | ||
− | | RUNDATE | + | | RUNDATE ||-||DATE|| - || run date |
|- | |- | ||
− | | RUNINFO | + | | RUNINFO ||-||VARCHAR2(250)|| - || codes explaining kind of run executed |
|- | |- | ||
− | | CAMPAIGN_START | + | | CAMPAIGN_START )||-||VARCHAR2(50)|| - || start month of campaign (agricultural season |
|- | |- | ||
− | | WEATHER_START | + | | WEATHER_START ||-||DATE|| - || start date of weather calculations |
|- | |- | ||
− | | WEATHER_END | + | | WEATHER_END ||-||DATE|| - || end date of weather calculations |
|- | |- | ||
− | | START_YEAR | + | | START_YEAR ||NOT NULL||NUMBER(4)|| - || year for which simulation is executed |
|- | |- | ||
− | | CAMPAIGN_YEARS | + | | CAMPAIGN_YEARS ||NOT NULL||NUMBER(3)|| - || number of campaign years the model is run for |
|- | |- | ||
− | | RUNSTATUS | + | | RUNSTATUS ||-||VARCHAR2(20)|| - || final status of run |
|- | |- | ||
− | | WEATHER_DATA_SOURCE | + | | WEATHER_DATA_SOURCE ||-||VARCHAR2(20)|| - || source type used for simulation crop yield |
|- | |- | ||
− | | INITIALISATION_WATER_BALANCE | + | | INITIALISATION_WATER_BALANCE ||NOT NULL||NUMBER(1)|| - || code indication type of water balance initialisations |
|- | |- | ||
− | | GROUND_WATER_BALANCE | + | | GROUND_WATER_BALANCE ||NOT NULL||NUMBER(1)|| - || code indication usage of ground water balance |
|} | |} | ||
|} | |} | ||
Line 144: | Line 144: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8) || - || grid number |
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER(10) || - || unique region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER(10) || - || landcover code |
|- | |- | ||
− | |AREA | + | |AREA || NOT NULL || NUMBER(10) || m2 || landcover area within intersection of grid cell en region |
|} | |} | ||
|} | |} | ||
Line 168: | Line 168: | ||
!Attribute !! Contraint* !! Type !! Unit | !Attribute !! Contraint* !! Type !! Unit | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | REG_CODE | + | | REG_CODE ||NOT NULL||NUMBER(10)|| - || region code |
|- | |- | ||
− | | YEAR | + | | YEAR ||NOT NULL||NUMBER(4)|| - || year for which cultivated area is valid |
|- | |- | ||
− | | AREA_CULTIVATED | + | | AREA_CULTIVATED ||-||NUMBER||10^3 ha || cultivated area |
|} | |} | ||
<nowiki>*</nowiki> All attributes Nullable in table versions | <nowiki>*</nowiki> All attributes Nullable in table versions | ||
Line 194: | Line 194: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||-||NUMBER(10,0)|| - || crop number |
|- | |- | ||
− | | CROP_NAME | + | | CROP_NAME ||-||VARCHAR2(40)|| - || name of crop |
|- | |- | ||
− | | CROPGROUP_NO | + | | CROPGROUP_NO ||-||NUMBER(2,0)|| - || group where crop belongs to |
|- | |- | ||
− | | CROP_MODEL | + | | CROP_MODEL of LINGRA (1))||-||NUMBER(1,0)|| - || WOFOST (0 |
|- | |- | ||
− | | START_MONTH | + | | START_MONTH ||-||NUMBER(2,0)|| - || start month of crop season |
|- | |- | ||
| LANDCOVER_ID||-||NUMBER(10,0)|| - || | | LANDCOVER_ID||-||NUMBER(10,0)|| - || | ||
Line 224: | Line 224: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || unique region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landcover code |
|- | |- | ||
− | | AREA | + | | AREA ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region |
|} | |} | ||
|} | |} | ||
Line 247: | Line 247: | ||
!Attribute !! Contraint* !! Type !! Unit | !Attribute !! Contraint* !! Type !! Unit | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8,0) || - || grid number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || calendar day |
|- | |- | ||
|DAY_OFFSET || - || NUMBER || - || | |DAY_OFFSET || - || NUMBER || - || | ||
Line 255: | Line 255: | ||
|MEMBER_NO || - || NUMBER || - || | |MEMBER_NO || - || NUMBER || - || | ||
|- | |- | ||
− | |MAX_TEMPERATURE | + | |MAX_TEMPERATURE || NOT NULL || NUMBER(3,1) || °C || maximum air temperature |
|- | |- | ||
− | |MIN_TEMPERATURE | + | |MIN_TEMPERATURE || NOT NULL || NUMBER(3,1) || °C || minimum air temperature |
|- | |- | ||
− | |MEAN_TEMPERATURE | + | |MEAN_TEMPERATURE || - || NUMBER || °C || mean air temperature |
|- | |- | ||
− | |DEW_TEMPERATURE | + | |DEW_TEMPERATURE || - || NUMBER || °C || mean air temperature |
|- | |- | ||
− | |VAPOUR_PRESSURE | + | |VAPOUR_PRESSURE || NOT NULL || NUMBER(4,2) || hPa || mean daily vapour pressure |
|- | |- | ||
− | |WIND_SPEED | + | |WIND_SPEED || NOT NULL || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || NOT NULL || NUMBER(4,1) || mm.d-1 || daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || NOT NULL || NUMBER|| mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |GLOBAL_RADIATION | + | |GLOBAL_RADIATION || NOT NULL || NUMBER(6) || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | SNOW_WEQ | + | | SNOW_WEQ as snow_weq)|||||| to_number(null |
|} | |} | ||
<nowiki>*</nowiki> All attributes Nullable in table versions | <nowiki>*</nowiki> All attributes Nullable in table versions | ||
Line 325: | Line 325: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8) || - || grid number |
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER(10) || - || unique region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER(10) || - || landcover code |
|- | |- | ||
− | |AREA | + | |AREA || NOT NULL || NUMBER(10) || m2 || landcover area within intersection of grid cell en region |
|} | |} | ||
|} | |} | ||
Line 349: | Line 349: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER || - || region mapping id |
|- | |- | ||
− | | REG_MAP_ID_BT | + | | REG_MAP_ID_BT ||NOT NULL||NUMBER || - || belongs to region mapping id |
|- | |- | ||
− | | REG_DES_ID | + | | REG_DES_ID ||NOT NULL||NUMBER || - || region description id |
|- | |- | ||
− | | REG_LEVEL | + | | REG_LEVEL ||NOT NULL||NUMBER || - || region level |
|- | |- | ||
− | | REG_CODE | + | | REG_CODE ||NOT NULL||VARCHAR2(10 BYTE) || - || region code |
|- | |- | ||
− | | BELONGS_TO | + | | BELONGS_TO ||NOT NULL||VARCHAR2(10 BYTE) || - || belongs to region code |
|- | |- | ||
− | | ROI_CODE | + | | ROI_CODE ||NOT NULL||VARCHAR2(10 BYTE) || - || region of interest code |
|- | |- | ||
| REG_DES_ID_OLD||-||NUMBER || - || | | REG_DES_ID_OLD||-||NUMBER || - || | ||
|- | |- | ||
− | | XMIN_ALT | + | | XMIN_ALT ||-||NUMBER(20,10) || - || Alternative bouding box minimum x coordinate |
|- | |- | ||
− | | XMAX_ALT | + | | XMAX_ALT ||-||NUMBER(20,10) || - || Alternative bouding box maximum x coordinate |
|- | |- | ||
− | | YMIN_ALT | + | | YMIN_ALT ||-||NUMBER(20,10) || - || Alternative bouding box minimum y coordinate |
|- | |- | ||
− | | YMAX_ALT | + | | YMAX_ALT ||-||NUMBER(20,10) || - || Alternative bouding box maximum y coordinate |
|- | |- | ||
− | | SRS_CODE_ALT | + | | SRS_CODE_ALT ||-||VARCHAR2(15 BYTE) || - || Alternative projection code |
|- | |- | ||
− | | STD_GROUP_NO | + | | STD_GROUP_NO ||-||NUMBER || - || attribute to control parallel processing |
|- | |- | ||
− | | EPS_GROUP_NO | + | | EPS_GROUP_NO ||-||NUMBER || - || attribute to control parallel processing |
|} | |} | ||
|} | |} | ||
Line 395: | Line 395: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || agro-environmental region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | DAY_OFFSET | + | | DAY_OFFSET |||||| 0 as day_offset |
|- | |- | ||
− | | MEMBER_NO | + | | MEMBER_NO |||||| 1 as member_no |
|- | |- | ||
− | | MAX_TEMPERATURE | + | | MAX_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE | + | | MIN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature |
|- | |- | ||
− | | MEAN_TEMPERATURE | + | | MEAN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | DEW_TEMPERATURE | + | | DEW_TEMPERATURE as dew_temperature)|||||| to_number(null |
|- | |- | ||
− | | VAPOUR_PRESSURE | + | | VAPOUR_PRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WIND_SPEED | + | | WIND_SPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | GLOBAL_RADIATION | + | | GLOBAL_RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | SNOW_WEQ | + | | SNOW_WEQ as snow_weq)|||||| to_number(null |
|} | |} | ||
|} | |} | ||
Line 449: | Line 449: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||-||NUMBER(10,0) || - || region mapping id |
|- | |- | ||
− | | REG_MAP_ID_BT | + | | REG_MAP_ID_BT ||-||NUMBER(10,0) || - || belongs to region mapping id |
|- | |- | ||
− | | REG_DES_ID | + | | REG_DES_ID ||-||NUMBER(10,0) || - || region description id |
|- | |- | ||
− | | REG_LEVEL | + | | REG_LEVEL ||-||NUMBER(10,0) || - || region level |
|- | |- | ||
− | | REG_CODE | + | | REG_CODE ||-||VARCHAR2(10 BYTE) || - || region code |
|- | |- | ||
− | | ROI_CODE | + | | ROI_CODE ||-||VARCHAR2(10 BYTE) || - || region of interest code |
|- | |- | ||
| PART_GROUP ||-||NUMBER(10,0) || - || | | PART_GROUP ||-||NUMBER(10,0) || - || | ||
Line 493: | Line 493: | ||
| THRESHOLD||-||NUMBER || - || | | THRESHOLD||-||NUMBER || - || | ||
|- | |- | ||
− | | DAY | + | | DAY ||-||DATE || - || calendar day |
|- | |- | ||
| DAY_OFFSET||-||NUMBER || - || | | DAY_OFFSET||-||NUMBER || - || | ||
Line 499: | Line 499: | ||
| MEMBER_NO||-||NUMBER || - || | | MEMBER_NO||-||NUMBER || - || | ||
|- | |- | ||
− | | MAX_TEMPERATURE | + | | MAX_TEMPERATURE ||-||NUMBER ||°C || maximum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE | + | | MIN_TEMPERATURE ||-||NUMBER ||°C || minimum air temperature |
|- | |- | ||
− | | MEAN_TEMPERATURE | + | | MEAN_TEMPERATURE ||-||NUMBER ||°C || mean air temperature |
|- | |- | ||
− | | DEW_TEMPERATURE | + | | DEW_TEMPERATURE ||-||NUMBER ||°C || mean air temperature |
|- | |- | ||
− | | VAPOUR_PRESSURE | + | | VAPOUR_PRESSURE ||-||NUMBER ||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WIND_SPEED | + | | WIND_SPEED ||-||NUMBER ||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER ||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||-||NUMBER ||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||-||NUMBER ||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||-||NUMBER ||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | GLOBAL_RADIATION | + | | GLOBAL_RADIATION ||-||NUMBER ||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER ||cm || daily mean snow depth |
|- | |- | ||
| SNOW_WEQ ||-||NUMBER || | | SNOW_WEQ ||-||NUMBER || | ||
|- | |- | ||
− | | ERROR_CODE | + | | ERROR_CODE ||-||NUMBER || error code |
|} | |} | ||
|} | |} | ||
Line 542: | Line 542: | ||
!Attribute !! Contraint* !! Type !! Unit | !Attribute !! Contraint* !! Type !! Unit | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || agro-environmental region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | DAY_OFFSET | + | | DAY_OFFSET |||||| 0 as day_offset |
|- | |- | ||
− | | MEMBER_NO | + | | MEMBER_NO |||||| 1 as member_no |
|- | |- | ||
− | | MAX_TEMPERATURE | + | | MAX_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE | + | | MIN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature |
|- | |- | ||
− | | MEAN_TEMPERATURE | + | | MEAN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | DEW_TEMPERATURE | + | | DEW_TEMPERATURE as dew_temperature)|||||| to_number(null |
|- | |- | ||
− | | VAPOUR_PRESSURE | + | | VAPOUR_PRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WIND_SPEED | + | | WIND_SPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | GLOBAL_RADIATION | + | | GLOBAL_RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | SNOW_WEQ | + | | SNOW_WEQ as snow_weq)|||||| to_number(null |
|} | |} | ||
|} | |} | ||
Line 595: | Line 595: | ||
!Attribute !! Contraint* !! Type !! Unit | !Attribute !! Contraint* !! Type !! Unit | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | DAY_OFFSET | + | | DAY_OFFSET |||||| 0 as day_offset |
|- | |- | ||
− | | MEMBER_NO | + | | MEMBER_NO |||||| 1 as member_no |
|- | |- | ||
− | | MAX_TEMPERATURE | + | | MAX_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || maximum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE | + | | MIN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || minimum air temperature |
|- | |- | ||
− | | MEAN_TEMPERATURE | + | | MEAN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | DEW_TEMPERATURE | + | | DEW_TEMPERATURE |||||| 0 as dew_temperature |
|- | |- | ||
− | | VAPOUR_PRESSURE | + | | VAPOUR_PRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WIND_SPEED | + | | WIND_SPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | GLOBAL_RADIATION | + | | GLOBAL_RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | SNOW_WEQ | + | | SNOW_WEQ as snow_weq)|||||| to_number(null |
|} | |} | ||
|} | |} | ||
Line 644: | Line 644: | ||
!Attribute !! Contraint* !! Type !! Unit | !Attribute !! Contraint* !! Type !! Unit | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | LANDCOVER_NO | + | | LANDCOVER_NO ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | DAY_OFFSET | + | | DAY_OFFSET |||||| 0 as day_offset |
|- | |- | ||
− | | MEMBER_NO | + | | MEMBER_NO |||||| 1 as member_no |
|- | |- | ||
− | | MAX_TEMPERATURE | + | | MAX_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE | + | | MIN_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature |
|- | |- | ||
− | | DAILY_TEMPERATURE | + | | DAILY_TEMPERATURE ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | DEW_TEMPERATURE | + | | DEW_TEMPERATURE as dew_temperature)|||||| to_number(null |
|- | |- | ||
− | | VAPOUR_PRESSURE | + | | VAPOUR_PRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WIND_SPEED | + | | WIND_SPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | GLOBAL_RADIATION | + | | GLOBAL_RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOW_DEPTH | + | | SNOW_DEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | SNOW_WEQ | + | | SNOW_WEQ as snow_weq)|||||| to_number(null |
|} | |} | ||
|} | |} | ||
Line 698: | Line 698: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO* | + | | CROP_NO* ||-||NUMBER(10,0)|| - || crop number |
|- | |- | ||
− | | CROP_NAME | + | | CROP_NAME ||-||VARCHAR2(40)|| - || name of crop |
|- | |- | ||
− | | CROPGROUP_NO | + | | CROPGROUP_NO ||-||NUMBER(2,0)|| - || group where crop belongs to |
|- | |- | ||
− | | CROP_MODEL | + | | CROP_MODEL of LINGRA (1))||-||NUMBER(1,0)|| - || WOFOST (0 |
|- | |- | ||
− | | START_MONTH | + | | START_MONTH ||-||NUMBER(2,0)|| - || start month of crop season |
|- | |- | ||
− | | LANDCOVER_ID** | + | | LANDCOVER_ID** ||-||NUMBER(10,0)|| - || landcover types |
|- | |- | ||
|} | |} | ||
− | <nowiki>*</nowiki> CROP_NO in | + | <nowiki>*</nowiki> CROP_NO in <br> 1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51 |
<nowiki>**</nowiki> LANDCOVER_ID values: | <nowiki>**</nowiki> LANDCOVER_ID values: | ||
* 101 Arable Land | * 101 Arable Land | ||
Line 735: | Line 735: | ||
!Attribute !! Constraint !! Type !! Unit | !Attribute !! Constraint !! Type !! Unit | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | VARIETY_NO | + | | VARIETY_NO ||NOT NULL||NUMBER(4)|| - || variety number |
|- | |- | ||
− | | YEAR | + | | YEAR ||NOT NULL||NUMBER(4)|| - || calendar year |
|- | |- | ||
− | | START_TYPE* | + | | START_TYPE* ||NOT NULL||VARCHAR2(20 BYTE)|| - || the way crop starts |
|- | |- | ||
− | | START_DATE | + | | START_DATE ||NOT NULL||DATE|| - || start of planting/sowing window |
|- | |- | ||
− | | START_WINDOW | + | | START_WINDOW ||NOT NULL||NUMBER(3)|| number of day's length of planting/sowing window |
|- | |- | ||
− | | END_TYPE** | + | | END_TYPE** ||NOT NULL||VARCHAR2(20 BYTE)|| - || the way a crop ends |
|- | |- | ||
| END_DATE||NOT NULL||DATE|| - || | | END_DATE||NOT NULL||DATE|| - || | ||
|- | |- | ||
− | | MAX_DURATION | + | | MAX_DURATION ||NOT NULL||NUMBER(3)||number of day's maximum duration of crop season |
|} | |} | ||
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br> | <nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br> | ||
Line 773: | Line 773: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |CROPGROUP_NO | + | |CROPGROUP_NO || NOT NULL || NUMBER(2) || - || group where crop belongs to |
|- | |- | ||
− | |CROPGROUP_NAME | + | |CROPGROUP_NAME || NOT NULL || VARCHAR2(40) || - || name of crop group |
|} | |} | ||
|} | |} | ||
Line 822: | Line 822: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | PARAMETER_CODE | + | | PARAMETER_CODE ||NOT NULL||VARCHAR2(20 BYTE)|| - || character code of crop parameter |
|- | |- | ||
− | | PARAMETER_XVALUE | + | | PARAMETER_XVALUE ||NOT NULL||NUMBER(38,6)|| - || crop parameter value |
|- | |- | ||
− | | PARAMETER_YVALUE | + | | PARAMETER_YVALUE ||-||NUMBER(38,6)|| - || crop parameter value - multiple |
|} | |} | ||
|} | |} | ||
Line 846: | Line 846: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
| DAY||NOT NULL||DATE|| - || | | DAY||NOT NULL||DATE|| - || | ||
|- | |- | ||
− | | DECADE | + | | DECADE ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36 |
|- | |- | ||
| YEAR||NOT NULL||NUMBER(4)|| - || | | YEAR||NOT NULL||NUMBER(4)|| - || | ||
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
|} | |} | ||
Line 1,003: | Line 1,003: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER || - || grid number |
|- | |- | ||
− | |LONGITUDE | + | |LONGITUDE || - || DATE || decimal degrees longitude of grid cell centre |
|- | |- | ||
− | |LATITUDE | + | |LATITUDE || - || NUMBER || decimal degrees latitude of grid cell centre |
|- | |- | ||
− | |ALTITUDE* | + | |ALTITUDE* || - || NUMBER || meters altitude of grid cell centre |
|- | |- | ||
− | |HAS_LAND | + | |HAS_LAND ) || - || VARCHAR2(1byte) || - || code indicating grid cell is terrestrial (Y or N |
|- | |- | ||
− | |ALTITUDE_0_16_BASED** | + | |ALTITUDE_0_16_BASED** || - || NUMBER || meters altitude of grid cell centre |
|- | |- | ||
− | |ALTITUDE_0_25_BASED*** | + | |ALTITUDE_0_25_BASED*** || - || NUMBER || meters altitude of grid cell centre |
|- | |- | ||
− | |ALTITUDE_0_50_BASED**** | + | |ALTITUDE_0_50_BASED**** || - || NUMBER || meters altitude of grid cell centre |
|} | |} | ||
<nowiki>*</nowiki> Available in SEA. Derived from N128 gaussian grid<br> | <nowiki>*</nowiki> Available in SEA. Derived from N128 gaussian grid<br> | ||
Line 1,040: | Line 1,040: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8) || - || grid number |
|- | |- | ||
− | |SMU_NO | + | |SMU_NO || NOT NULL || NUMBER(8) || - || soil mapping unit number |
|- | |- | ||
− | |AREA | + | |AREA || NOT NULL || NUMBER(10) || - || area of elementary mapping unit |
|} | |} | ||
|} | |} | ||
Line 1,064: | Line 1,064: | ||
| RUN_ID||NOT NULL||NUMBER|| - || | | RUN_ID||NOT NULL||NUMBER|| - || | ||
|- | |- | ||
− | | MEMBER_NO | + | | MEMBER_NO ||NOT NULL||NUMBER(2)|| - || identifier for ensemble number* |
|- | |- | ||
− | | FORECASTED_YIELD | + | | FORECASTED_YIELD ||-||NUMBER(7,3)||10^3 kg.ha forecasted yield, fresh weight |
|} | |} | ||
<nowiki>*</nowiki> Forecasts that are based on ECMWF EPS, Montly and Seasonal weather data have multiple weather forecasts (ensembles) that result in just as many different yield forecasts. The different yield forecasts are stored under different member numbers. | <nowiki>*</nowiki> Forecasts that are based on ECMWF EPS, Montly and Seasonal weather data have multiple weather forecasts (ensembles) that result in just as many different yield forecasts. The different yield forecasts are stored under different member numbers. | ||
Line 1,085: | Line 1,085: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | LATITUDE | + | | LATITUDE ||NOT NULL||NUMBER(8,5)|| - || latitude of grid cell centre |
|- | |- | ||
− | | LONGITUDE | + | | LONGITUDE ||NOT NULL||NUMBER(8,5)|| - || longitude of grid cell centre |
|- | |- | ||
− | | ALTITUDE | + | | ALTITUDE *||NOT NULL||NUMBER(5)||Meter altitude of grid cell |
|- | |- | ||
| CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - || | | CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - || | ||
|- | |- | ||
− | | DISTANCE_TO_COAST | + | | DISTANCE_TO_COAST ||Km || distance from centre of gravity of land part to coast||NOT NULL||NUMBER(5,1 |
|- | |- | ||
| X_COORDINATE||NOT NULL||NUMBER(*,0)|| - || | | X_COORDINATE||NOT NULL||NUMBER(*,0)|| - || | ||
Line 1,119: | Line 1,119: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(38,0) || - || OPE grid no |
|- | |- | ||
− | |T2M_INT | + | |T2M_INT || NOT NULL || NUMBER || - || interval coefficient av. temp. |
|- | |- | ||
− | |T2M_SLOPE | + | |T2M_SLOPE || NOT NULL || NUMBER || - || slope coefficient av. temp. |
|- | |- | ||
− | |T2M_T1 | + | |T2M_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 av. temp. |
|- | |- | ||
− | |T2M_T2 | + | |T2M_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 av. temp. |
|- | |- | ||
− | |T2M_T3 | + | |T2M_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 av. temp. |
|- | |- | ||
− | |T2M_T4 | + | |T2M_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 av. temp. |
|- | |- | ||
− | |TX_INT | + | |TX_INT || NOT NULL || NUMBER || - || interval coefficient max. temp. |
|- | |- | ||
− | |TX_SLOPE | + | |TX_SLOPE || NOT NULL || NUMBER || - || slope coefficient max. temp. |
|- | |- | ||
− | |TX_T1 | + | |TX_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 max. temp. |
|- | |- | ||
− | |TX_T2 | + | |TX_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 max. temp. |
|- | |- | ||
− | |TX_T3 | + | |TX_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 max. temp. |
|- | |- | ||
− | |TX_T4 | + | |TX_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 max. temp. |
|- | |- | ||
− | |TD_INT | + | |TD_INT || NOT NULL || NUMBER || - || interval coefficient dew. temp. |
|- | |- | ||
− | |TD_SLOPE | + | |TD_SLOPE || NOT NULL || NUMBER || - || slope coefficient dew. temp. |
|- | |- | ||
− | |TD_T1 | + | |TD_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 dew. temp. |
|- | |- | ||
− | |TD_T2 | + | |TD_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 dew. temp. |
|- | |- | ||
− | |TD_T3 | + | |TD_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 dew. temp. |
|- | |- | ||
− | |TD_T4 | + | |TD_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 dew. temp. |
|- | |- | ||
− | |RR_INT | + | |RR_INT || NOT NULL || NUMBER || - || interval coefficient rainfall |
|- | |- | ||
− | |RR_SLOPE | + | |RR_SLOPE * || NOT NULL || NUMBER || - || slope coefficient rainfall |
|- | |- | ||
− | |RR_T1 | + | |RR_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 rainfall |
|- | |- | ||
− | |RR_T2 | + | |RR_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 rainfall |
|- | |- | ||
− | |RR_T3 | + | |RR_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 rainfall |
|- | |- | ||
− | |RR_T4 | + | |RR_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 rainfall |
|- | |- | ||
− | |SSRD_INT | + | |SSRD_INT || NOT NULL || NUMBER || - || interval coefficient radiation |
|- | |- | ||
− | |SSRD_SLOPE | + | |SSRD_SLOPE || NOT NULL || NUMBER || - || slope coefficient radiation |
|- | |- | ||
− | |SSRD_T1 | + | |SSRD_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 radiation |
|- | |- | ||
− | |SSRD_T2 | + | |SSRD_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 radiation |
|- | |- | ||
− | |SSRD_T3 | + | |SSRD_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 radiation |
|- | |- | ||
− | |SSRD_T4 | + | |SSRD_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 radiation |
|- | |- | ||
− | |SN_INT | + | |SN_INT || NOT NULL || NUMBER || - || interval coefficient snow water equivalent |
|- | |- | ||
− | |SN_SLOPE | + | |SN_SLOPE ** || NOT NULL || NUMBER || - || slope coefficient snow water equivalent |
|- | |- | ||
− | |SN_T1 | + | |SN_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 snow water equivalent |
|- | |- | ||
− | |SN_T2 | + | |SN_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 snow water equivalent |
|- | |- | ||
− | |SN_T3 | + | |SN_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 snow water equivalent |
|- | |- | ||
− | |SN_T4 | + | |SN_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 snow water equivalent |
|- | |- | ||
− | |FFM_INT | + | |FFM_INT || NOT NULL || NUMBER || - || interval coefficient windspeed |
|- | |- | ||
− | |FFM_SLOPE | + | |FFM_SLOPE || NOT NULL || NUMBER || - || slope coefficient windspeed |
|- | |- | ||
− | |FFM_T1 | + | |FFM_T1 || NOT NULL || NUMBER || - || seasonal coefficient 1 windspeed |
|- | |- | ||
− | |FFM_T2 | + | |FFM_T2 || NOT NULL || NUMBER || - || seasonal coefficient 2 windspeed |
|- | |- | ||
− | |FFM_T3 | + | |FFM_T3 || NOT NULL || NUMBER || - || seasonal coefficient 3 windspeed |
|- | |- | ||
− | |FFM_T4 | + | |FFM_T4 || NOT NULL || NUMBER || - || seasonal coefficient 4 windspeed |
|} | |} | ||
<nowiki>*</nowiki> No real equations do exist for rainfall therefore simple equation y = x is applied<br> | <nowiki>*</nowiki> No real equations do exist for rainfall therefore simple equation y = x is applied<br> | ||
Line 1,224: | Line 1,224: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | DECADE | + | | DECADE ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36 |
|- | |- | ||
| YEAR||NOT NULL||NUMBER(4)|| - || | | YEAR||NOT NULL||NUMBER(4)|| - || | ||
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
|} | |} | ||
Line 1,283: | Line 1,283: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8) || - || grid number |
|- | |- | ||
− | |STU_NO | + | |STU_NO || NOT NULL || NUMBER(8) || - || soil typological unit number |
|- | |- | ||
− | |CROP_NO | + | |CROP_NO || NOT NULL || NUMBER(2) || - || crop number |
|- | |- | ||
− | |YEAR | + | |YEAR || NOT NULL || NUMBER(4) || - || calendar year |
|- | |- | ||
− | |ZTI* | + | |ZTI* || NOT NULL || NUMBER(4,1) || cm || depth of initial ground water table |
|- | |- | ||
− | |DD* | + | |DD* || NOT NULL || NUMBER(4,1) || cm || depth of drainage |
|- | |- | ||
− | |WAV | + | |WAV || NOT NULL || NUMBER(3,1) || cm || water available in potential rooting depth |
|- | |- | ||
− | |GIVEN_STARTDATE_WATBAL | + | |GIVEN_STARTDATE_WATBAL || NOT NULL || DATE || - || date for which WAV is valid |
|} | |} | ||
* Set to 999 to avoid the the ground water module being used (see [[Soil_map#Initial_available_soil_water|Initial available soil water]]). | * Set to 999 to avoid the the ground water module being used (see [[Soil_map#Initial_available_soil_water|Initial available soil water]]). | ||
Line 1,316: | Line 1,316: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number, equal to CROP_NO in CROP table |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number, equal to GRID_NO in GRID table |
|- | |- | ||
− | | JSOW | + | | JSOW ||NOT NULL||NUMBER(3)||julian day (1-366) day in year |
|} | |} | ||
|} | |} | ||
Line 1,338: | Line 1,338: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || agri-environmental region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landcover code |
|- | |- | ||
− | | AREA | + | | AREA ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region |
|} | |} | ||
|} | |} | ||
Line 1,362: | Line 1,362: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | AREA | + | | AREA ||NOT NULL||NUMBER(10)||m2 || total area of intersection between elementary mapping unit and grid cell |
|} | |} | ||
|} | |} | ||
Line 1,386: | Line 1,386: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | AREA | + | | AREA ||NOT NULL||NUMBER(10)||m2 || crop area of intersection between elementary mapping unit and grid cell |
|} | |} | ||
|} | |} | ||
Line 1,412: | Line 1,412: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || unique region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landcover code |
|- | |- | ||
− | | AREA | + | | AREA ||NOT NULL||NUMBER(10)||m2 || landcover area within intersection of grid cell en region |
|} | |} | ||
|} | |} | ||
Line 1,458: | Line 1,458: | ||
| STATION_NUMBER||NOT NULL||NUMBER(7)|| - || | | STATION_NUMBER||NOT NULL||NUMBER(7)|| - || | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | REG_MAP_BT | + | | REG_MAP_BT administrative region id)||NOT NULL||NUMBER(10)|| - || belongs to (one level up |
|} | |} | ||
|} | |} | ||
Line 1,478: | Line 1,478: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| day number in year (1-366 |
|- | |- | ||
− | | DECADE | + | | DECADE ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36 |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
|} | |} | ||
Line 1,537: | Line 1,537: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DECADE | + | | DECADE ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36 |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 1,722: | Line 1,722: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | NUTS_CODE | + | | NUTS_CODE ||NOT NULL||NUMBER(10)|| - || administrative region code |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | DECADE | + | | DECADE ||NOT NULL||NUMBER(2)|| - || dekad in year (1-36 |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 1,935: | Line 1,935: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | RUN_ID | + | | RUN_ID ||NOT NULL||NUMBER|| - || unique identifier |
|- | |- | ||
− | | EXCLUDED_YEAR | + | | EXCLUDED_YEAR ||NOT NULL||NUMBER(4)|| - || years that are excluded from the regression model |
|} | |} | ||
|} | |} | ||
Line 1,957: | Line 1,957: | ||
| RUN_ID||NOT NULL||NUMBER|| - || | | RUN_ID||NOT NULL||NUMBER|| - || | ||
|- | |- | ||
− | | INDICATOR_NAME | + | | INDICATOR_NAME *||NOT NULL||VARCHAR2(50)|| - || abbreviation of indicator |
|- | |- | ||
− | | MODEL_COEFF | + | | MODEL_COEFF ||NOT NULL||NUMBER|| - || coefficient of included indicator |
|} | |} | ||
<nowiki>*</nowiki> In general one or more of the four level 2 indicators: | <nowiki>*</nowiki> In general one or more of the four level 2 indicators: | ||
Line 1,983: | Line 1,983: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | RUN_ID | + | | RUN_ID ||NOT NULL||NUMBER|| - || unique identifier |
|- | |- | ||
− | | START_YEAR | + | | START_YEAR ||NOT NULL||NUMBER(4)|| - || first year used for time trend |
|- | |- | ||
− | | END_YEAR | + | | END_YEAR ||NOT NULL||NUMBER(4)|| - || last year used for time trend |
|- | |- | ||
− | | NUMBER_OF_YEARS | + | | NUMBER_OF_YEARS ||NOT NULL||NUMBER(2)|| - || number of included years |
|- | |- | ||
− | | TRANSFORM_YEARS | + | | TRANSFORM_YEARS or no ('None'))||NOT NULL||VARCHAR2(12)|| - || transforme years yes ('Logarithmic' |
|- | |- | ||
− | | YEAR_OFFSET | + | | YEAR_OFFSET ||NOT NULL||NUMBER(4)|| - || offset in case of transform years |
|- | |- | ||
− | | ORDER_OF_TIMETREND | + | | ORDER_OF_TIMETREND , linear (1), quadratic (2))||NOT NULL||NUMBER(1)|| - || no trend (0 |
|- | |- | ||
− | | RSQ | + | | RSQ ||NOT NULL||NUMBER|| - || R squared |
|- | |- | ||
− | | RSQ_ADJ | + | | RSQ_ADJ ||NOT NULL||NUMBER|| - || Adjusted R squared |
|- | |- | ||
− | | RES_STD_DEV | + | | RES_STD_DEV ||NOT NULL||NUMBER|| - || Residual Standard deviation |
|- | |- | ||
− | | RMSQ_ERR_PRED | + | | RMSQ_ERR_PRED ||NOT NULL||NUMBER|| - || Root mean squared error for prediction |
|- | |- | ||
| MALLOWS_CP||NOT NULL||NUMBER|| - || | | MALLOWS_CP||NOT NULL||NUMBER|| - || | ||
Line 2,009: | Line 2,009: | ||
| MAX_VAR_INFL_FACT||NOT NULL||NUMBER|| - || | | MAX_VAR_INFL_FACT||NOT NULL||NUMBER|| - || | ||
|- | |- | ||
− | | STD_ERR_PRED_MEAN | + | | STD_ERR_PRED_MEAN ||-||NUMBER|| - || Standard error of prediction |
|- | |- | ||
− | | STD_ERR_PRED_NEW | + | | STD_ERR_PRED_NEW ||-||NUMBER|| - || Standard error of prediction |
|- | |- | ||
| CONST_COEF||-||NUMBER|| - || | | CONST_COEF||-||NUMBER|| - || | ||
Line 2,139: | Line 2,139: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(8)|| - || administrative region code |
|- | |- | ||
| YEAR||NOT NULL||NUMBER(4)|| - || | | YEAR||NOT NULL||NUMBER(4)|| - || | ||
|- | |- | ||
− | | NUTS_CODE | + | | NUTS_CODE ||NOT NULL||NUMBER(10)|| - || administrative region code |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
|} | |} | ||
Line 2,197: | Line 2,197: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |PARAMETER_CODE | + | |PARAMETER_CODE || NOT NULL || VARCHAR2(20) || - || character code of crop parameter |
|- | |- | ||
− | |MULTIPLE | + | |MULTIPLE || NOT NULL || VARCHAR2(1) || - || N = single value, Y = value pairs |
|- | |- | ||
− | |PARAMETER_DESCR | + | |PARAMETER_DESCR || NOT NULL || VARCHAR2(80) || - || description of crop parameter |
|} | |} | ||
|} | |} | ||
Line 2,219: | Line 2,219: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | STATION_NUMBER | + | | STATION_NUMBER ||NOT NULL||NUMBER(7)|| - || station number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | HOUR | + | | HOUR ||NOT NULL||VARCHAR2(5)|| hh:mm || UTC end time of the 6-hourly period |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(6,2)|| mm/6h 6-hourly rainfall sum |
|} | |} | ||
|} | |} | ||
Line 2,249: | Line 2,249: | ||
| HOUR||NOT NULL||VARCHAR2(5)|| - || | | HOUR||NOT NULL||VARCHAR2(5)|| - || | ||
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(2)|| - || flag* |
|} | |} | ||
<nowiki>*</nowiki> Possible values for precipitation (flags):<br> | <nowiki>*</nowiki> Possible values for precipitation (flags):<br> | ||
Line 2,298: | Line 2,298: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER|| - || unique id for region |
|- | |- | ||
− | | REG_MAP_ID_BT | + | | REG_MAP_ID_BT where the administrative region belongs to)||-||NUMBER(10,0) || - || unique id (one level up |
|- | |- | ||
− | | REG_CODE* | + | | REG_CODE* ||NOT NULL||VARCHAR2(10)|| - || unique code for administrative region |
|- | |- | ||
− | | REG_NAME | + | | REG_NAME ||NOT NULL||VARCHAR2(250)|| - || name of administrative region |
|- | |- | ||
− | | REG_LEVEL* | + | | REG_LEVEL* ||NOT NULL||NUMBER|| - || level of administrative region (0-3 |
|- | |- | ||
− | | BELONGS_TO* | + | | BELONGS_TO* where the administrative region belongs to)||NOT NULL||VARCHAR2(10)|| - || region code (one level up |
|- | |- | ||
− | | BELONGS_TO_NAME | + | | BELONGS_TO_NAME where the administrative region belongs to)||NOT NULL||VARCHAR2(250)|| - || region name (one level up |
|- | |- | ||
− | | AREA_HA | + | | AREA_HA ||-||NUMBER||ha area in hectare |
|- | |- | ||
− | | AREA_KM2 | + | | AREA_KM2 ||-||NUMBER||km2 || area in square km |
|} | |} | ||
<nowiki>*</nowiki> According to the 'NUTS' nomenclature (see [[Administrative_regions]]). | <nowiki>*</nowiki> According to the 'NUTS' nomenclature (see [[Administrative_regions]]). | ||
Line 2,333: | Line 2,333: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER || - || region mapping id |
|- | |- | ||
− | | REG_MAP_ID_BT | + | | REG_MAP_ID_BT ||NOT NULL||NUMBER || - || belongs to region mapping id |
|- | |- | ||
− | | REG_DES_ID | + | | REG_DES_ID ||NOT NULL||NUMBER || - || region description id |
|- | |- | ||
− | | REG_LEVEL | + | | REG_LEVEL ||NOT NULL||NUMBER || - || region level |
|- | |- | ||
− | | REG_CODE | + | | REG_CODE ||NOT NULL||VARCHAR2(10 BYTE) || - || region code |
|- | |- | ||
− | | BELONGS_TO | + | | BELONGS_TO ||NOT NULL||VARCHAR2(10 BYTE) || - || belongs to region code |
|- | |- | ||
− | | ROI_CODE | + | | ROI_CODE ||NOT NULL||VARCHAR2(10 BYTE) || - || region of interest code |
|- | |- | ||
| REG_DES_ID_OLD||-||NUMBER || - || | | REG_DES_ID_OLD||-||NUMBER || - || | ||
|- | |- | ||
− | | XMIN_ALT* | + | | XMIN_ALT* ||-||NUMBER(20,10) || - || Alternative bouding box minimum x coordinate |
|- | |- | ||
− | | XMAX_ALT* | + | | XMAX_ALT* ||-||NUMBER(20,10) || - || Alternative bouding box maximum x coordinate |
|- | |- | ||
− | | YMIN_ALT* | + | | YMIN_ALT* ||-||NUMBER(20,10) || - || Alternative bouding box minimum y coordinate |
|- | |- | ||
− | | YMAX_ALT* | + | | YMAX_ALT* ||-||NUMBER(20,10) || - || Alternative bouding box maximum y coordinate |
|- | |- | ||
− | | SRS_CODE_ALT* | + | | SRS_CODE_ALT* ||-||VARCHAR2(15 BYTE) || - || Alternative projection code |
|- | |- | ||
− | | STD_GROUP_NO | + | | STD_GROUP_NO ||-||NUMBER || - || attribute to control parallel processing |
|- | |- | ||
− | | EPS_GROUP_NO | + | | EPS_GROUP_NO ||-||NUMBER || - || attribute to control parallel processing |
|} | |} | ||
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}. | <nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}. | ||
Line 2,387: | Line 2,387: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CLASS | + | | CLASS ||NOT NULL||NUMBER(5)|| - || rooting depth class |
|- | |- | ||
− | | MIN_DEPTH | + | | MIN_DEPTH ||NOT NULL||NUMBER(5)||cm || depth to which crop roots extends |
|} | |} | ||
|} | |} | ||
Line 2,491: | Line 2,491: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | STU_NO | + | | STU_NO ||NOT NULL||NUMBER(8)|| - || soil typological unit number |
|} | |} | ||
|} | |} | ||
Line 2,513: | Line 2,513: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | MEMBER_NO* | + | | MEMBER_NO* ||NOT NULL||NUMBER(2)|| - || member number |
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
<nowiki>*</nowiki> Not in SIMYIELD_HIS_EMU table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_EMU has the attribute although also the OPE model does not have members. | <nowiki>*</nowiki> Not in SIMYIELD_HIS_EMU table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_EMU has the attribute although also the OPE model does not have members. | ||
Line 2,572: | Line 2,572: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE )||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 2,628: | Line 2,628: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 2,684: | Line 2,684: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | MEMBER_NO* | + | | MEMBER_NO* ||NOT NULL||NUMBER(2)|| - || member number |
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(4)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(8,4)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(8,4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(3,2)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(3,2)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||-||NUMBER(8,3)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||-||NUMBER(8,3)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||||||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||||||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
<nowiki>*</nowiki> Not in SIMYIELD_HIS_GRID table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_GRID has the attribute although also the OPE model does not have members. | <nowiki>*</nowiki> Not in SIMYIELD_HIS_GRID table since the HIS model does not have members. Inconsequent, the SIMYIELD_OPE_GRID has the attribute although also the OPE model does not have members. | ||
Line 2,741: | Line 2,741: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(5,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(4)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(8,4)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(8,4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(3,2)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(3,2)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||-||NUMBER(8,3)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||-||NUMBER(8,3)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||||||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||||||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 2,795: | Line 2,795: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 2,977: | Line 2,977: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 3,033: | Line 3,033: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 3,215: | Line 3,215: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region code |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 3,397: | Line 3,397: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || day |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(8)|| - || administrative region code |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,3)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||-||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||-||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||-||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||-||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 3,451: | Line 3,451: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO )||NOT NULL||VARCHAR2(4)|| - || day number in year (1-366 |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region code |
|- | |- | ||
− | | POTENTIAL_YIELD_BIOMASS | + | | POTENTIAL_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | | POTENTIAL_YIELD_STORAGE | + | | POTENTIAL_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | | WATER_LIM_YIELD_BIOMASS | + | | WATER_LIM_YIELD_BIOMASS ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | | WATER_LIM_YIELD_STORAGE | + | | WATER_LIM_YIELD_STORAGE ||NOT NULL||NUMBER(8,3)||kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | | POTENTIAL_LEAF_AREA_INDEX | + | | POTENTIAL_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | | WATER_LIM_LEAF_AREA_INDEX | + | | WATER_LIM_LEAF_AREA_INDEX ||NOT NULL||NUMBER(5,2)||m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | | DEVELOPMENT_STAGE | + | | DEVELOPMENT_STAGE ||NOT NULL||NUMBER(4)|| - || development stag of crop (0-200 |
|- | |- | ||
− | | RELATIVE_SOIL_MOISTURE | + | | RELATIVE_SOIL_MOISTURE )||NOT NULL||NUMBER(8,4)|| - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | | TOTAL_WATER_CONSUMPTION | + | | TOTAL_WATER_CONSUMPTION ||NOT NULL||NUMBER(8,4)||cm || sum of water limited transpiration |
|- | |- | ||
− | | TOTAL_WATER_REQUIREMENT | + | | TOTAL_WATER_REQUIREMENT ||NOT NULL||NUMBER(8,4)||cm || sum of potential transpiration |
|- | |- | ||
− | | FSM | + | | FSM ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in rooted zone |
|- | |- | ||
− | | FSMUR | + | | FSMUR ||NOT NULL||NUMBER(3,2)|| - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | | LEAVES_DIED_BY_COLD | + | | LEAVES_DIED_BY_COLD ||NOT NULL||NUMBER(8,3)|| - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | | RUNOFF | + | | RUNOFF ||NOT NULL||NUMBER(8,3)||cm || run off |
|- | |- | ||
− | | SOIL_EVAPORATION | + | | SOIL_EVAPORATION ||NOT NULL||NUMBER(8,3)||cm || soil evaporation |
|- | |- | ||
− | | LOSS_TO_SUBSOIL | + | | LOSS_TO_SUBSOIL ||NOT NULL||NUMBER(8,3)||cm || amount of water drained to the sub soil and therefore lost for the crop |
|- | |- | ||
| MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | | MIN_POTENTIAL_YIELD_BIOMASS||NOT NULL||NUMBER(8,3)||kg.ha-1 || | ||
Line 3,633: | Line 3,633: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | IFUNRN (infiltration rate depends on storm size. 0=no, 1 = yes | + | | IFUNRN ||-||NUMBER(1)|| - || infiltration rate depends on storm size. 0=no, 1 = yes |
|- | |- | ||
− | | NOTINF | + | | NOTINF ||-||NUMBER(2,1)|| - || non infiltration fration, 0 = infiltration, 1 = no infiltration |
|- | |- | ||
− | | MAX_SURFACE_STORAGE | + | | MAX_SURFACE_STORAGE ||-||NUMBER(5,3)||(cm) maximum surface storage |
|} | |} | ||
|} | |} | ||
Line 3,654: | Line 3,654: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | SMU_NO | + | | SMU_NO ||NOT NULL||NUMBER(8)|| - || soil mapping unit number |
|- | |- | ||
− | | CROPGROUP_NO | + | | CROPGROUP_NO ||NOT NULL||NUMBER(2)|| - || group where crop belongs to |
|- | |- | ||
− | | PERCENTAGE | + | | PERCENTAGE ||NOT NULL||NUMBER(3)|| - || percentage of soil mapping unit suitable for crop group |
|} | |} | ||
|} | |} | ||
Line 3,676: | Line 3,676: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |SMU_NO | + | |SMU_NO || NOT NULL || NUMBER(8) || - || soil mapping unit number |
|- | |- | ||
− | |STU_NO | + | |STU_NO || NOT NULL || NUMBER(8) || - || soil typologic unit number |
|- | |- | ||
− | |PERCENTAGE | + | |PERCENTAGE || NOT NULL || NUMBER(3) || % || share of soil typologic unit in soil mapping unit |
|} | |} | ||
|} | |} | ||
Line 3,698: | Line 3,698: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |SMU_NO | + | |SMU_NO || NOT NULL || NUMBER(8) || - || soil mapping unit number |
|- | |- | ||
− | |COUNTRY_CODE | + | |COUNTRY_CODE * || NOT NULL || VARCHAR2(3) || - || country code |
|} | |} | ||
|} | |} | ||
Line 3,719: | Line 3,719: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |SOIL_GROUP_NO | + | |SOIL_GROUP_NO || NOT NULL || NUMBER(3) || - || soil physical group number |
|- | |- | ||
− | |PARAMETER_CODE | + | |PARAMETER_CODE || NOT NULL || VARCHAR2(30) || - || character code of soil phys. parameter |
|- | |- | ||
− | |PARAMETER_XVALUE | + | |PARAMETER_XVALUE || NOT NULL || NUMBER(38,6) || - || soil phys. parameter value |
|- | |- | ||
− | |PARAMETER_YVALUE | + | |PARAMETER_YVALUE || - || NUMBER(38,6) || - || soil phys. parameter value – multiple |
|} | |} | ||
|} | |} | ||
Line 3,743: | Line 3,743: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |STU_NO | + | |STU_NO || NOT NULL|| NUMBER(8) || - || soil typologic unit number |
|- | |- | ||
− | |SOIL_WRB | + | |SOIL_WRB || NOT NULL|| VARCHAR2(8) || - || World Reference Base soil code |
|- | |- | ||
− | |SOIL_WRB_CL | + | |SOIL_WRB_CL || NOT NULL|| VARCHAR2(1) || - || World Reference Base soil code |
|- | |- | ||
− | |SOIL_FAO90 | + | |SOIL_FAO90 || NOT NULL|| VARCHAR2(8) || - || FAO 1990 soil code |
|- | |- | ||
− | |SOIL_FAO90_CL | + | |SOIL_FAO90_CL || NOT NULL|| VARCHAR2(1) || - || FAO 1990 soil code |
|- | |- | ||
− | |SOIL | + | |SOIL || NOT NULL|| VARCHAR2(8) || - || character code to characterize the soil |
|- | |- | ||
− | |SOIL_FAO85_CL | + | |SOIL_FAO85_CL || NOT NULL|| VARCHAR2(1) || - || FAO 1985 soil code |
|- | |- | ||
− | |SLOPE1 | + | |SLOPE1 || NOT NULL|| VARCHAR2(1) || - || slope |
|- | |- | ||
− | |TEXT1 | + | |TEXT1 || NOT NULL|| VARCHAR2(1) || - || texture of the soil |
|- | |- | ||
− | |PHASE1 | + | |PHASE1 || NOT NULL|| VARCHAR2(2) || - || agricultural limitation |
|- | |- | ||
− | |CALCULATED_ROOTING_DEPTH | + | |CALCULATED_ROOTING_DEPTH || NOT NULL|| NUMBER(5) || - || rooting depth class |
|- | |- | ||
− | |SOIL_GROUP_NO | + | |SOIL_GROUP_NO || NOT NULL|| NUMBER(3) || - || soil physical group number |
|- | |- | ||
− | |DRAINAGE | + | |DRAINAGE || NOT NULL|| VARCHAR2(2) || - || the drainage of the soil |
|- | |- | ||
− | |ALKALINITY | + | |ALKALINITY || NOT NULL|| VARCHAR2(1) || - || alkalinity of the soil |
|- | |- | ||
− | |SALINITY | + | |SALINITY || NOT NULL|| VARCHAR2(1) || - || salinity of the soil |
|} | |} | ||
|} | |} | ||
Line 3,817: | Line 3,817: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | STAT_CROP_NO | + | | STAT_CROP_NO ||NOT NULL||NUMBER(4)|| - || statistic crop number |
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(8)|| - || administrative region code |
|- | |- | ||
− | | YEAR | + | | YEAR ||NOT NULL||NUMBER(4)|| - || calendar year |
|- | |- | ||
− | | AREA_CULTIVATED | + | | AREA_CULTIVATED ||-||NUMBER(10,3)||10^3 ha || acreage cultivated |
|- | |- | ||
− | | OFFICIAL_YIELD | + | | OFFICIAL_YIELD ||-||NUMBER(6,3)||10^3 kg.ha-1 || yield, fresh weight |
|- | |- | ||
| ORIGINAL_OFFICIAL_YIELD||-||NUMBER||10^3 kg.ha-1 || | | ORIGINAL_OFFICIAL_YIELD||-||NUMBER||10^3 kg.ha-1 || | ||
Line 3,855: | Line 3,855: | ||
| WMO_NAME||-||VARCHAR2(32)|| - || | | WMO_NAME||-||VARCHAR2(32)|| - || | ||
|- | |- | ||
− | | LATITUDE | + | | LATITUDE ||NOT NULL||NUMBER(7,5)||dd || latitude |
|- | |- | ||
− | | LONGITUDE | + | | LONGITUDE ||NOT NULL||NUMBER(8,5)||dd || longitude |
|- | |- | ||
− | | Y_COORDINATE | + | | Y_COORDINATE ||NOT NULL||NUMBER(13,5)||m || not used in CGMS |
|- | |- | ||
− | | X_COORDINATE | + | | X_COORDINATE ||NOT NULL||NUMBER(13,5)||m || not used in CGMS |
|- | |- | ||
− | | ALTITUDE | + | | ALTITUDE ||NOT NULL||NUMBER(5)||m || altitude |
|- | |- | ||
| CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - || | | CLIMATE_ZONE||NOT NULL||NUMBER(2)|| - || | ||
|- | |- | ||
− | | COUNTRY_CODE | + | | COUNTRY_CODE ||NOT NULL||VARCHAR2(26)|| - || country code |
|- | |- | ||
− | | DISTANCE_TO_COAST | + | | DISTANCE_TO_COAST ||NOT NULL||NUMBER(4)||km || distance to coast |
|- | |- | ||
| ANGSTROM_A||NOT NULL||NUMBER(18,16)|| - || | | ANGSTROM_A||NOT NULL||NUMBER(18,16)|| - || | ||
Line 3,915: | Line 3,915: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
| DAY||NOT NULL||DATE|| - || | | DAY||NOT NULL||DATE|| - || | ||
|- | |- | ||
− | | PRECIPITATION_STATION | + | | PRECIPITATION_STATION ||NOT NULL||NUMBER(7)|| - || station number used for rainfall |
|- | |- | ||
| SNOW_STATION||-||NUMBER(7)|| - || | | SNOW_STATION||-||NUMBER(7)|| - || | ||
|- | |- | ||
− | | TEMPERATURE_STATION_1 | + | | TEMPERATURE_STATION_1 ||NOT NULL||NUMBER(7)|| - || first station used for interpolation temperature |
|- | |- | ||
− | | TEMPERATURE_STATION_2 | + | | TEMPERATURE_STATION_2 ||-||NUMBER(7)|| - || second station used for interpolation temperature |
|- | |- | ||
− | | TEMPERATURE_STATION_3 | + | | TEMPERATURE_STATION_3 ||-||NUMBER(7)|| - || third station used for interpolation temperature |
|- | |- | ||
− | | TEMPERATURE_STATION_4 | + | | TEMPERATURE_STATION_4 ||-||NUMBER(7)|| - || fourth station used for interpolation temperature |
|- | |- | ||
| HUMIDITY_STATION||-||NUMBER(7)|| - || | | HUMIDITY_STATION||-||NUMBER(7)|| - || | ||
|- | |- | ||
− | | REST_STATION_1 | + | | REST_STATION_1 ||NOT NULL||NUMBER(7)|| - || first station used for interpolation other variables |
|- | |- | ||
− | | REST_STATION_2 | + | | REST_STATION_2 ||-||NUMBER(7)|| - || second station used for interpolation other variables |
|- | |- | ||
− | | REST_STATION_3 | + | | REST_STATION_3 ||-||NUMBER(7)|| - || third station used for interpolation other variables |
|- | |- | ||
− | | REST_STATION_4 | + | | REST_STATION_4 ||-||NUMBER(7)|| - || fourth station used for interpolation other variables |
|- | |- | ||
− | | PRECIPITATION_SCORE | + | | PRECIPITATION_SCORE ||NOT NULL||NUMBER(6,2)||km || similarity score for station used rainfall |
|- | |- | ||
| SNOW_SCORE||-||NUMBER(6,2)|| - || | | SNOW_SCORE||-||NUMBER(6,2)|| - || | ||
|- | |- | ||
− | | TEMPERATURE_SCORE | + | | TEMPERATURE_SCORE ||NOT NULL||NUMBER(6,2)||km || similarity score for first station used interpolation temperature |
|- | |- | ||
| HUMIDITY_SCORE||-||NUMBER(6,2)|| - || | | HUMIDITY_SCORE||-||NUMBER(6,2)|| - || | ||
|- | |- | ||
− | | REST_SCORE | + | | REST_SCORE ||NOT NULL||NUMBER(6,2)||km || similarity score for first station used interpolation other variables |
|} | |} | ||
|} | |} | ||
Line 4,027: | Line 4,027: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |CROPGROUP_NO | + | |CROPGROUP_NO || NOT NULL || NUMBER(2) || - || group where crop belongs to |
|- | |- | ||
− | |STU_NO | + | |STU_NO || NOT NULL || NUMBER(8) || - || soil typologic unit number |
|} | |} | ||
|} | |} | ||
Line 4,047: | Line 4,047: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | WMO_NO | + | | WMO_NO ||-||NUMBER(7)|| - || station number |
|- | |- | ||
− | | ANGSTROM_A | + | | ANGSTROM_A ||-||NUMBER|| - || ångström constant A using sun shine duration |
|- | |- | ||
− | | ANGSTROM_B | + | | ANGSTROM_B ||-||NUMBER|| - || ångström constant B using sun shine duration |
|- | |- | ||
− | | SUPIT_A | + | | SUPIT_A ||-||NUMBER|| - || supit constant A using cloud cover and temperature |
|- | |- | ||
− | | SUPIT_B | + | | SUPIT_B ||-||NUMBER|| - || supit constant B using cloud cover and temperature |
|- | |- | ||
− | | SUPIT_C | + | | SUPIT_C ||-||NUMBER||kJ.m-2.d-1 || supit constant C using cloud cover and temperature |
|- | |- | ||
− | | HARGREAVES_A | + | | HARGREAVES_A ||-||NUMBER|| - || hargreaves constant A using temperature |
|- | |- | ||
− | | HARGREAVES_B | + | | HARGREAVES_B ||-||NUMBER||kJ.m-2.d-1 || hargreaves constant B using temperature |
|} | |} | ||
|} | |} | ||
Line 4,078: | Line 4,078: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | STATION_NAME | + | | STATION_NAME ||NOT NULL||VARCHAR2|| - || dummy name |
|- | |- | ||
− | | LATITUDE | + | | LATITUDE ||NOT NULL||NUMBER||dd || latitude |
|- | |- | ||
− | | LONGITUDE | + | | LONGITUDE ||NOT NULL||NUMBER||dd || longitude |
|- | |- | ||
− | | ALTITUDE | + | | ALTITUDE ||NOT NULL||NUMBER||m || altitude |
|- | |- | ||
− | | ANGSTROM_A | + | | ANGSTROM_A ||-||NUMBER|| - || angstrom constant A using sun shine duration |
|- | |- | ||
− | | ANGSTROM_B | + | | ANGSTROM_B ||-||NUMBER|| - || angstrom constant B using sun shine duration |
|- | |- | ||
− | | SUPIT_A | + | | SUPIT_A ||-||NUMBER|| - || supit constant A using cloud cover and temperature |
|- | |- | ||
− | | SUPIT_B | + | | SUPIT_B ||-||NUMBER|| - || supit constant B using cloud cover and temperature |
|- | |- | ||
− | | SUPIT_C | + | | SUPIT_C ||-||NUMBER||kJ.m-2.d-1 || supit constant C using cloud cover and temperature |
|- | |- | ||
− | | HARGREAVES_A | + | | HARGREAVES_A ||-||NUMBER|| - || hargreaves constant A using temperature |
|- | |- | ||
− | | HARGREAVES_B | + | | HARGREAVES_B ||-||NUMBER||kJ.m-2.d-1 || hargreaves constant A using temperature |
|} | |} | ||
|} | |} | ||
Line 4,116: | Line 4,116: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |CROP_NO | + | |CROP_NO || NOT NULL || NUMBER(38,0) || - || crop number |
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(38,0) || - || grid number |
|- | |- | ||
− | |SMU_NO | + | |SMU_NO || NOT NULL || NUMBER(38,0) || - || soil mapping unit number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || day |
|- | |- | ||
− | |POTENTIAL_YIELD_BIOMASS | + | |POTENTIAL_YIELD_BIOMASS || NOT NULL || NUMBER || kg.ha-1 || potential dry weight biomass |
|- | |- | ||
− | |POTENTIAL_YIELD_STORAGE | + | |POTENTIAL_YIELD_STORAGE || NOT NULL || NUMBER || kg.ha-1 || potential dry weight storage organs |
|- | |- | ||
− | |WATER_LIM_YIELD_BIOMASS | + | |WATER_LIM_YIELD_BIOMASS || NOT NULL || NUMBER || kg.ha-1 || water limited dry weight biomass |
|- | |- | ||
− | |WATER_LIM_YIELD_STORAGE | + | |WATER_LIM_YIELD_STORAGE || NOT NULL || NUMBER || kg.ha-1 || water limited dry weight storage organs |
|- | |- | ||
− | |POTENTIAL_LEAF_AREA_INDEX | + | |POTENTIAL_LEAF_AREA_INDEX || NOT NULL || NUMBER || m2.m2 || potential leaf area divided by surface area |
|- | |- | ||
− | |WATER_LIM_LEAF_AREA_INDEX | + | |WATER_LIM_LEAF_AREA_INDEX || NOT NULL || NUMBER || m2.m2 || water limited leaf area divided by surface area |
|- | |- | ||
− | |DEVELOPMENT_STAGE | + | |DEVELOPMENT_STAGE ) || NOT NULL || NUMBER || - || development stag of crop (0-200 |
|- | |- | ||
− | |RELATIVE_SOIL_MOISTURE | + | |RELATIVE_SOIL_MOISTURE ) || NOT NULL || NUMBER || - || percentage of (field capacity minus wilting point |
|- | |- | ||
− | |TOTAL_WATER_CONSUMPTION | + | |TOTAL_WATER_CONSUMPTION || NOT NULL || NUMBER || cm || sum of water limited transpiration |
|- | |- | ||
− | |TOTAL_WATER_REQUIREMENT | + | |TOTAL_WATER_REQUIREMENT || NOT NULL || NUMBER || cm || sum of potential transpiration |
|- | |- | ||
− | |FSM | + | |FSM || NOT NULL || NUMBER || - || folumetric soil moisture content in rooted zone |
|- | |- | ||
− | |FSMUR | + | |FSMUR || NOT NULL || NUMBER || - || volumetric soil moisture content in not rooted zone |
|- | |- | ||
− | |LEAVES_DIED_BY_COLD | + | |LEAVES_DIED_BY_COLD || - || NUMBER || - || fraction of leaves died by cold wrt total biomass |
|- | |- | ||
− | |RUNOFF | + | |RUNOFF || - || NUMBER || cm || run off |
|- | |- | ||
− | |SOIL_EVAPORATION | + | |SOIL_EVAPORATION || - || NUMBER || cm || soil evaporation |
|- | |- | ||
− | |LOSS_TO_SUBSOIL | + | |LOSS_TO_SUBSOIL || - || NUMBER || cm || amount of water drained to the sub soil and therefore lost for the crop |
|} | |} | ||
|} | |} | ||
Line 4,172: | Line 4,172: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |SNAME | + | |SNAME || NOT NULL || VARCHAR2(30) || - || name of variable |
|- | |- | ||
− | |SVALUE | + | |SVALUE || NOT NULL || VARCHAR2(30) || - || value of variable |
|} | |} | ||
|} | |} | ||
Line 4,245: | Line 4,245: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | CROP_NO | + | | CROP_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | VARIETY_NO | + | | VARIETY_NO ||NOT NULL||NUMBER(4)|| - || crop number |
|- | |- | ||
− | | PARAMETER_CODE | + | | PARAMETER_CODE ||NOT NULL||VARCHAR2(20)|| - || character code of crop parameter |
|- | |- | ||
− | | PARAMETER_XVALUE | + | | PARAMETER_XVALUE ||NOT NULL||NUMBER(38,6)|| - || crop parameter value |
|- | |- | ||
− | | PARAMETER_YVALUE | + | | PARAMETER_YVALUE ||-||NUMBER(38,6)|| - || crop parameter value - multiple |
|} | |} | ||
(in case of single parameters PARAMETER_XVALUE gives the value; in case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE) | (in case of single parameters PARAMETER_XVALUE gives the value; in case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE) | ||
Line 4,303: | Line 4,303: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER || - || grid number |
|- | |- | ||
− | |DAY_NO | + | |DAY_NO || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || NOT NULL || NUMBER(3,1) || °C || average minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall |
|- | |- | ||
− | |RADIATION | + | |RADIATION || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER(6,2) || cm || average daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH | + | |SNOWDEPTH || - || NUMBER(6,2) || cm || average daily mean snow depth |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || NOT NULL || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure |
|- | |- | ||
− | |E0 | + | |E0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_25 | + | |FRAC_DAYS_MAX_TEMP_GE_25 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_30 | + | |FRAC_DAYS_MAX_TEMP_GE_30 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_35 | + | |FRAC_DAYS_MAX_TEMP_GE_35 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | |FRAC_AREA_TEMP_MAX_GE_40 | + | |FRAC_AREA_TEMP_MAX_GE_40 || - || NUMBER(3,2) || - || fraction of area with maximum temperature >= 40°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_0 | + | |FRAC_DAYS_MIN_TEMP_LE_0 || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN8 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN8 || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN10 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN10 || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN18 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN18 || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN20 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN20 || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_1 | + | |FRAC_DAYS_RAINFALL_GE_1 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_3 | + | |FRAC_DAYS_RAINFALL_GE_3 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_5 | + | |FRAC_DAYS_RAINFALL_GE_5 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_10 | + | |FRAC_DAYS_RAINFALL_GE_10 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_15 | + | |FRAC_DAYS_RAINFALL_GE_15 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_30 | + | |FRAC_DAYS_RAINFALL_GE_30 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm |
|- | |- | ||
− | |AVG_TEMP_GE_0 | + | |AVG_TEMP_GE_0 || - || NUMBER(3,1) || °C || average temperature above 0°C |
|- | |- | ||
− | |AVG_TEMP_GE_2 | + | |AVG_TEMP_GE_2 || - || NUMBER(3,1) || °C || average temperature above 2°C |
|- | |- | ||
− | |AVG_TEMP_GE_4 | + | |AVG_TEMP_GE_4 || - || NUMBER(3,1) || °C || average temperature above 4°C |
|- | |- | ||
− | |AVG_TEMP_GE_6 | + | |AVG_TEMP_GE_6 || - || NUMBER(3,1) || °C || average temperature above 6°C |
|- | |- | ||
− | |AVG_TEMP_GE_8 | + | |AVG_TEMP_GE_8 || - || NUMBER(3,1) || °C || average temperature above 8°C |
|- | |- | ||
− | |AVG_TEMP_GE_10 | + | |AVG_TEMP_GE_10 || - || NUMBER(3,1) || °C || average temperature above 10°C |
|} | |} | ||
|} | |} | ||
Line 4,391: | Line 4,391: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER || - || administrative region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER || - || landcover mask / crop mask id |
|- | |- | ||
− | |THRESHOLD | + | |THRESHOLD || NOT NULL || NUMBER || - || used threshold in percentage |
|- | |- | ||
− | |DAY_NO | + | |DAY_NO || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || NOT NULL || NUMBER(3,1) || °C || average minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || NOT NULL || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | |RADIATION | + | |RADIATION || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER(6,2) || cm || average daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH | + | |SNOWDEPTH || - || NUMBER(6,2) || cm || average daily mean snow depth |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_25 | + | |FRAC_DAYS_MAX_TEMP_GE_25 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_30 | + | |FRAC_DAYS_MAX_TEMP_GE_30 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_35 | + | |FRAC_DAYS_MAX_TEMP_GE_35 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_40 | + | |FRAC_DAYS_MAX_TEMP_GE_40 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 40°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_0 | + | |FRAC_DAYS_MIN_TEMP_LE_0 || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN8 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN8 || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN10 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN10 || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN18 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN18 || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN20 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN20 || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_1 | + | |FRAC_DAYS_RAINFALL_GE_1 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_3 | + | |FRAC_DAYS_RAINFALL_GE_3 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_5 | + | |FRAC_DAYS_RAINFALL_GE_5 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_10 | + | |FRAC_DAYS_RAINFALL_GE_10 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_15 | + | |FRAC_DAYS_RAINFALL_GE_15 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_30 | + | |FRAC_DAYS_RAINFALL_GE_30 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm |
|- | |- | ||
− | |AVG_TEMP_GE_0 | + | |AVG_TEMP_GE_0 || - ||NUMBER(3,1) || °C || average temperature above 0°C |
|- | |- | ||
− | |AVG_TEMP_GE_2 | + | |AVG_TEMP_GE_2 || - ||NUMBER(3,1) || °C || average temperature above 2°C |
|- | |- | ||
− | |AVG_TEMP_GE_4 | + | |AVG_TEMP_GE_4 || - ||NUMBER(3,1) || °C || average temperature above 4°C |
|- | |- | ||
− | |AVG_TEMP_GE_6 | + | |AVG_TEMP_GE_6 || - ||NUMBER(3,1) || °C || average temperature above 6°C |
|- | |- | ||
− | |AVG_TEMP_GE_8 | + | |AVG_TEMP_GE_8 || - ||NUMBER(3,1) || °C || average temperature above 8°C |
|- | |- | ||
− | |AVG_TEMP_GE_10 | + | |AVG_TEMP_GE_10 || - ||NUMBER(3,1) || °C || average temperature above 10°C |
|} | |} | ||
|} | |} | ||
Line 4,483: | Line 4,483: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER || - || agri-environmental region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER || - || landcover mask / crop mask id |
|- | |- | ||
− | |THRESHOLD | + | |THRESHOLD || NOT NULL || NUMBER || - || used threshold in percentage |
|- | |- | ||
− | |DAY_NO | + | |DAY_NO || NOT NULL || VARCHAR2(4 BYTE) || - || day of year stored as mmdd |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || NOT NULL || NUMBER(3,1) || °C || average maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || NOT NULL || NUMBER(3,1) || °C || average minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || NOT NULL || NUMBER(3,1) || °C || average average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || NOT NULL || NUMBER(3,1) || °C || average dewpoint air temperature at 2 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || NOT NULL || NUMBER(4,2) || hPa || average mean daily vapour pressure |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || NOT NULL || NUMBER(5,1) || m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || NOT NULL || NUMBER(4,1) || mm.d-1 || average daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || NOT NULL || NUMBER(4,2) || mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | |RADIATION | + | |RADIATION || NOT NULL || NUMBER(6,0) || kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER(6,2) || cm || average daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH | + | |SNOWDEPTH || - || NUMBER(6,2) || cm || average daily mean snow depth |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_25 | + | |FRAC_DAYS_MAX_TEMP_GE_25 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_30 | + | |FRAC_DAYS_MAX_TEMP_GE_30 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_35 | + | |FRAC_DAYS_MAX_TEMP_GE_35 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | |FRAC_DAYS_MAX_TEMP_GE_40 | + | |FRAC_DAYS_MAX_TEMP_GE_40 || - || NUMBER(3,2) || - || fraction of days with maximum temperature >= 40°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_0 | + | |FRAC_DAYS_MIN_TEMP_LE_0 || - || NUMBER(3,2) || - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN8 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN8 || - || NUMBER(3,2) || - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN10 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN10 || - || NUMBER(3,2) || - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN18 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN18 || - || NUMBER(3,2) || - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | |FRAC_DAYS_MIN_TEMP_LE_MIN20 | + | |FRAC_DAYS_MIN_TEMP_LE_MIN20 || - || NUMBER(3,2) || - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_1 | + | |FRAC_DAYS_RAINFALL_GE_1 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_3 | + | |FRAC_DAYS_RAINFALL_GE_3 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_5 | + | |FRAC_DAYS_RAINFALL_GE_5 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_10 | + | |FRAC_DAYS_RAINFALL_GE_10 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_15 | + | |FRAC_DAYS_RAINFALL_GE_15 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | |FRAC_DAYS_RAINFALL_GE_30 | + | |FRAC_DAYS_RAINFALL_GE_30 || - || NUMBER(3,2) || - || fraction of days with rainfall >= 30mm |
|- | |- | ||
− | |AVG_TEMP_GE_0 | + | |AVG_TEMP_GE_0 || - || NUMBER(3,1) || °C || average temperature above 0°C |
|- | |- | ||
− | |AVG_TEMP_GE_2 | + | |AVG_TEMP_GE_2 || - || NUMBER(3,1) || °C || average temperature above 2°C |
|- | |- | ||
− | |AVG_TEMP_GE_4 | + | |AVG_TEMP_GE_4 || - || NUMBER(3,1) || °C || average temperature above 4°C |
|- | |- | ||
− | |AVG_TEMP_GE_6 | + | |AVG_TEMP_GE_6 || - || NUMBER(3,1) || °C || average temperature above 6°C |
|- | |- | ||
− | |AVG_TEMP_GE_8 | + | |AVG_TEMP_GE_8 || - || NUMBER(3,1) || °C || average temperature above 8°C |
|- | |- | ||
− | |AVG_TEMP_GE_10 | + | |AVG_TEMP_GE_10 || - || NUMBER(3,1) || °C || average temperature above 10°C |
|} | |} | ||
|} | |} | ||
Line 4,576: | Line 4,576: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER(10,0) || - || agro-environmental region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER(10,0) || - || landmask / cropmask id |
|- | |- | ||
− | |THRESHOLD | + | |THRESHOLD || NOT NULL || NUMBER(3,0) || - || used threshold in percentage |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || day of forecast |
|- | |- | ||
− | |DAY_OFFSET * | + | |DAY_OFFSET * grid number) || NOT NULL || NUMBER(2,0) || - || day in forecast relative to DAY |
|- | |- | ||
− | |MEMBER_NO * | + | |MEMBER_NO * || NOT NULL || NUMBER(2,0) || - || number of forecast member |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || - || NUMBER(3,1) || °C || maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || - || NUMBER(3,1) || °C || minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || - || NUMBER(3,1) || °C || average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || - || NUMBER(3,1) || °C || dewpoint air temperature at 2 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || - || NUMBER(4,2) || hPa || mean daily vapour pressure |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || - || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || - || NUMBER(4,1) || mm.d-1 || daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |RADIATION | + | |RADIATION || - || NUMBER(6,0) || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER(6,2) || cm || daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH ** | + | |SNOWDEPTH ** || - || NUMBER(6,2) || cm || daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)||°C || average temperature above 10°C |
|} | |} | ||
<nowiki>*</nowiki> Not available (relevant) in HIS products<br> | <nowiki>*</nowiki> Not available (relevant) in HIS products<br> | ||
Line 4,675: | Line 4,675: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER || - || grid number |
|- | |- | ||
− | |DAY | + | |DAY ) || NOT NULL || DATE || - || start day of forecast (= offset day 0 |
|- | |- | ||
− | |DAY_OFFSET * | + | |DAY_OFFSET * grid number) || NOT NULL || NUMBER || - || day in forecast relative to DAY |
|- | |- | ||
− | |MEMBER_NO * | + | |MEMBER_NO * || NOT NULL || NUMBER || - || number of forecast member |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || - || NUMBER || °C || average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || - || NUMBER || °C || maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || - || NUMBER || °C || minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || - || NUMBER || °C || dewpoint air temperature at 2 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || - || NUMBER || mm.d-1 || daily rainfall |
|- | |- | ||
− | |RADIATION | + | |RADIATION || - || NUMBER || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER || cm || daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH ** | + | |SNOWDEPTH ** || - || NUMBER || cm || daily mean snow depth |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || - || NUMBER || m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || - || NUMBER || hPa || mean daily vapour pressure |
|- | |- | ||
− | |E0 | + | |E0 || - || NUMBER || mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || - || NUMBER || mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || - || NUMBER || mm.d-1 || daily transpiration of crop canopy |
|} | |} | ||
<nowiki>*</nowiki> Not available (relevant) in HIS product<br> | <nowiki>*</nowiki> Not available (relevant) in HIS product<br> | ||
Line 4,728: | Line 4,728: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER || - || grid number |
|- | |- | ||
− | |DAY | + | |DAY ) || NOT NULL || DATE || - || start day of forecast (= offset day 0 |
|- | |- | ||
− | |DAY_OFFSET * | + | |DAY_OFFSET * grid number) || NOT NULL || NUMBER || - || day in forecast relative to DAY |
|- | |- | ||
− | |MEMBER_NO * | + | |MEMBER_NO * || NOT NULL || NUMBER || - || number of forecast member |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || - || NUMBER || °C || average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || - || NUMBER || °C || maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || - || NUMBER || °C || minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || - || NUMBER || °C || dewpoint air temperature at 2 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || - || NUMBER || mm.d-1 || daily rainfall |
|- | |- | ||
− | |RADIATION | + | |RADIATION || - || NUMBER || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER || cm || daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH ** | + | |SNOWDEPTH ** || - || NUMBER || cm || daily mean snow depth |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || - || NUMBER || m.s-1 || mean daily wind speed at 10 m height |
|} | |} | ||
<nowiki>*</nowiki> Not available (relevant) in HIS product<br> | <nowiki>*</nowiki> Not available (relevant) in HIS product<br> | ||
Line 4,773: | Line 4,773: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |REG_MAP_ID | + | |REG_MAP_ID || NOT NULL || NUMBER(10,0) || - || administrative region id |
|- | |- | ||
− | |LANDCOVER_ID | + | |LANDCOVER_ID || NOT NULL || NUMBER(10,0) || - || landmask / cropmask id |
|- | |- | ||
− | |THRESHOLD | + | |THRESHOLD || NOT NULL || NUMBER(3,0) || - || used threshold in percentage |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || day of forecast |
|- | |- | ||
− | |DAY_OFFSET * | + | |DAY_OFFSET * grid number) || NOT NULL || NUMBER(2,0) || - || day in forecast relative to DAY |
|- | |- | ||
− | |MEMBER_NO * | + | |MEMBER_NO * || NOT NULL || NUMBER(2,0) || - || number of forecast member |
|- | |- | ||
− | |TEMPERATURE_MAX | + | |TEMPERATURE_MAX || - || NUMBER(3,1) || °C || maximum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_MIN | + | |TEMPERATURE_MIN || - || NUMBER(3,1) || °C || minimum air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_AVG | + | |TEMPERATURE_AVG || - || NUMBER(3,1) || °C || average air temperature at 2 m height |
|- | |- | ||
− | |TEMPERATURE_DEW | + | |TEMPERATURE_DEW || - || NUMBER(3,1) || °C || dewpoint air temperature at 2 m height |
|- | |- | ||
− | |VAPOURPRESSURE | + | |VAPOURPRESSURE || - || NUMBER(4,2) || hPa || mean daily vapour pressure |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || - || NUMBER(5,1) || m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | |PRECIPITATION | + | |PRECIPITATION || - || NUMBER(4,1) || mm.d-1 || daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || - || NUMBER(4,2) || mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |RADIATION | + | |RADIATION || - || NUMBER(6,0) || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | |SNOWWEQ | + | |SNOWWEQ || - || NUMBER(6,2) || cm || daily mean snow water equivalent |
|- | |- | ||
− | |SNOWDEPTH ** | + | |SNOWDEPTH ** || - || NUMBER(6,2) || cm || daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)||°C || average temperature above 10°C |
|} | |} | ||
<nowiki>*</nowiki> Not available (relevant) in HIS products<br> | <nowiki>*</nowiki> Not available (relevant) in HIS products<br> | ||
Line 4,871: | Line 4,871: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || agro-environmental region id |
|- | |- | ||
− | | LANDCOVER_NO | + | | LANDCOVER_NO ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)||°C || average temperature above 10°C |
|} | |} | ||
|} | |} | ||
Line 4,958: | Line 4,958: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || agri-environmental region id |
|- | |- | ||
− | | LANDCOVER_ID | + | | LANDCOVER_ID ||NOT NULL||NUMBER(10)|| - || landcover mask / crop mask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO ||NOT NULL||VARCHAR2(4)|| - || day of year stored as mmdd |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || average maximum air temperature |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || average minimum air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || average mean air temperature |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || average daily rainfall |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||-||NUMBER(7,1)||kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || average mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||-||NUMBER(5,1)||m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | | E0 | + | | E0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || average daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)|| - || average temperature above 10°C |
|- | |- | ||
− | | MIN_TEMPERATURE_MIN | + | | MIN_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || minimum minimum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_MAX | + | | MIN_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || minimum maximum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_AVG | + | | MIN_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || minimum mean air temperature |
|- | |- | ||
− | | MIN_PRECIPITATION | + | | MIN_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || minimum daily rainfall |
|- | |- | ||
− | | MIN_RADIATION | + | | MIN_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || minimum daily radiation at surface |
|- | |- | ||
− | | MIN_VAPOURPRESSURE | + | | MIN_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || minimum mean daily vapour pressure |
|- | |- | ||
− | | MIN_WINDSPEED | + | | MIN_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || minimum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MIN_E0 | + | | MIN_E0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of water surface |
|- | |- | ||
− | | MIN_ES0 | + | | MIN_ES0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of wet bare soil |
|- | |- | ||
− | | MIN_ET0 | + | | MIN_ET0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of crop canopy |
|- | |- | ||
− | | MIN_SNOWDEPTH | + | | MIN_SNOWDEPTH ||-||NUMBER(6,2)||cm || minimum daily mean snow depth |
|- | |- | ||
− | | MAX_TEMPERATURE_MIN | + | | MAX_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_MAX | + | | MAX_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_AVG | + | | MAX_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || maximum mean air temperature |
|- | |- | ||
− | | MAX_PRECIPITATION | + | | MAX_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || maximum daily rainfall |
|- | |- | ||
− | | MAX_RADIATION | + | | MAX_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || maximum daily radiation at surface |
|- | |- | ||
− | | MAX_VAPOURPRESSURE | + | | MAX_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || maximum mean daily vapour pressure |
|- | |- | ||
− | | MAX_WINDSPEED | + | | MAX_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || maximum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MAX_E0 | + | | MAX_E0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of water surface |
|- | |- | ||
− | | MAX_ES0 | + | | MAX_ES0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of wet bare soil |
|- | |- | ||
− | | MAX_ET0 | + | | MAX_ET0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of crop canopy |
|- | |- | ||
− | | MAX_SNOW_DEPTH | + | | MAX_SNOW_DEPTH ||-||NUMBER(6,2)||cm || maximum daily mean snow depth |
|- | |- | ||
− | | STD_TEMPERATURE_MAX | + | | STD_TEMPERATURE_MAX ||-||NUMBER(4,2)||°C || standard deviation of maximum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_MIN | + | | STD_TEMPERATURE_MIN ||-||NUMBER(4,2)||°C || standard deviation of minimum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_AVG | + | | STD_TEMPERATURE_AVG ||-||NUMBER(4,2)||°C || standard deviation of mean air temperature |
|- | |- | ||
− | | STD_PRECIPITATION | + | | STD_PRECIPITATION ||-||NUMBER(5,2)||mm.d-1 || standard deviation of daily rainfall |
|- | |- | ||
− | | STD_RADIATION | + | | STD_RADIATION ||-||NUMBER(8,1)||kJ.m-2.d-1 || standard deviation of daily radiation at surface |
|- | |- | ||
− | | STD_VAPOURPRESSURE | + | | STD_VAPOURPRESSURE ||-||NUMBER(6,3)||hPa || standard deviation of mean daily vapour pressure |
|- | |- | ||
− | | STD_WINDSPEED | + | | STD_WINDSPEED ||-||NUMBER(6,2)||m.s-1 || standard deviation of mean daily wind speed at 10 m height |
|- | |- | ||
− | | STD_E0 | + | | STD_E0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of water surface |
|- | |- | ||
− | | STD_ES0 | + | | STD_ES0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of wet bare soil |
|- | |- | ||
− | | STD_ET0 | + | | STD_ET0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of crop canopy |
|- | |- | ||
− | | STD_SNOWDEPTH | + | | STD_SNOWDEPTH ||-||NUMBER(7,3)||cm || standard deviation of daily mean snow depth |
|- | |- | ||
− | | NUM_TEMPERATURE_MIN | + | | NUM_TEMPERATURE_MIN ||-||NUMBER(6)|| - || count of air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_MAX | + | | NUM_TEMPERATURE_MAX ||-||NUMBER(6)|| - || count of maximum air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_AVG | + | | NUM_TEMPERATURE_AVG ||-||NUMBER(6)|| - || count of mean air temperature |
|- | |- | ||
− | | NUM_PRECIPITATION | + | | NUM_PRECIPITATION ||-||NUMBER(6)|| - || count of daily rainfall |
|- | |- | ||
− | | NUM_RADIATION | + | | NUM_RADIATION ||-||NUMBER(6)|| - || count of daily radiation at surface |
|- | |- | ||
− | | NUM_VAPOURPRESSURE | + | | NUM_VAPOURPRESSURE ||-||NUMBER(6)|| - || count of mean daily vapour pressure |
|- | |- | ||
− | | NUM_WINDSPEED | + | | NUM_WINDSPEED ||-||NUMBER(6)|| - || count of mean daily wind speed at 10 m height |
|- | |- | ||
− | | NUM_E0 | + | | NUM_E0 ||-||NUMBER(6)|| - || count of daily transpiration of water surface |
|- | |- | ||
− | | NUM_ES0 | + | | NUM_ES0 ||-||NUMBER(6)|| - || count of daily transpiration of wet bare soil |
|- | |- | ||
− | | NUM_ET0 | + | | NUM_ET0 ||-||NUMBER(6)|| - || count of daily transpiration of crop canopy |
|- | |- | ||
− | | NUM_SNOWDEPTH | + | | NUM_SNOWDEPTH ||-||NUMBER(6)|| - || count of daily mean snow depth |
|} | |} | ||
|} | |} | ||
Line 5,133: | Line 5,133: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||NOT NULL||NUMBER(3,1)||°C || maximum air temperature |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||NOT NULL||NUMBER(3,1)||°C || minimum air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||NOT NULL||NUMBER(3,1)||°C || average air temperature |
|- | |- | ||
| HUMIDITY_06H||-||NUMBER(6,2)|| - || | | HUMIDITY_06H||-||NUMBER(6,2)|| - || | ||
Line 5,153: | Line 5,153: | ||
| HUMIDITY_18H||-||NUMBER(6,2)|| | | HUMIDITY_18H||-||NUMBER(6,2)|| | ||
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||NOT NULL||NUMBER(4,2)||m.s-1 || mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||NOT NULL||NUMBER(5,1)||hPa || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||NOT NULL||NUMBER(6)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|} | |} | ||
|} | |} | ||
Line 5,184: | Line 5,184: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
| DAY||NOT NULL||DATE|| - || | | DAY||NOT NULL||DATE|| - || | ||
Line 5,213: | Line 5,213: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | GRID_NO | + | | GRID_NO ||NOT NULL||NUMBER(8)|| - || grid number |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO ||NOT NULL||VARCHAR2(4)|| - || day of year stored as mmdd |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || average maximum air temperature |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || average minimum air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || average mean air temperature |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || average daily rainfall |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||-||NUMBER(7,1)||kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || average mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||-||NUMBER(5,1)||m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | | E0 | + | | E0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || average daily mean snow depth |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MAX_GE_25 | + | | FRAC_DAYS_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MAX_GE_30 | + | | FRAC_DAYS_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MAX_GE_35 | + | | FRAC_DAYS_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MAX_GE_40 | + | | FRAC_DAYS_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MIN_LE_0 | + | | FRAC_DAYS_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MIN_LE_MIN8 | + | | FRAC_DAYS_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MIN_LE_MIN10 | + | | FRAC_DAYS_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MIN_LE_MIN18 | + | | FRAC_DAYS_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | | FRAC_DAYS_TEMP_MIN_LE_MIN20 | + | | FRAC_DAYS_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_1 | + | | FRAC_DAYS_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_3 | + | | FRAC_DAYS_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_5 | + | | FRAC_DAYS_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_10 | + | | FRAC_DAYS_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_15 | + | | FRAC_DAYS_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_DAYS_PRECIPITATION_GE_30 | + | | FRAC_DAYS_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 30mm |
|- | |- | ||
| AVG_TEMP_GE_0||-||NUMBER(3,1)|| - || | | AVG_TEMP_GE_0||-||NUMBER(3,1)|| - || | ||
Line 5,281: | Line 5,281: | ||
| AVG_TEMP_GE_10||-||NUMBER(3,1)|| - || | | AVG_TEMP_GE_10||-||NUMBER(3,1)|| - || | ||
|- | |- | ||
− | | MIN_TEMPERATURE_MIN | + | | MIN_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || minimum minimum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_MAX | + | | MIN_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || minimum maximum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_AVG | + | | MIN_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || minimum mean air temperature |
|- | |- | ||
− | | MIN_PRECIPITATION | + | | MIN_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || minimum daily rainfall |
|- | |- | ||
− | | MIN_RADIATION | + | | MIN_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || minimum daily radiation at surface |
|- | |- | ||
− | | MIN_VAPOURPRESSURE | + | | MIN_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || minimum mean daily vapour pressure |
|- | |- | ||
− | | MIN_WINDSPEED | + | | MIN_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || minimum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MIN_E0 | + | | MIN_E0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of water surface |
|- | |- | ||
− | | MIN_ES0 | + | | MIN_ES0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of wet bare soil |
|- | |- | ||
− | | MIN_ET0 | + | | MIN_ET0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of crop canopy |
|- | |- | ||
− | | MIN_SNOWDEPTH | + | | MIN_SNOWDEPTH ||-||NUMBER(6,2)||cm || minimum daily mean snow depth |
|- | |- | ||
− | | MAX_TEMPERATURE_MIN | + | | MAX_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_MAX | + | | MAX_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_AVG | + | | MAX_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || maximum mean air temperature |
|- | |- | ||
− | | MAX_PRECIPITATION | + | | MAX_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || maximum daily rainfall |
|- | |- | ||
− | | MAX_RADIATION | + | | MAX_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || maximum daily radiation at surface |
|- | |- | ||
− | | MAX_VAPOURPRESSURE | + | | MAX_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || maximum mean daily vapour pressure |
|- | |- | ||
− | | MAX_WINDSPEED | + | | MAX_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || maximum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MAX_E0 | + | | MAX_E0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of water surface |
|- | |- | ||
− | | MAX_ES0 | + | | MAX_ES0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of wet bare soil |
|- | |- | ||
− | | MAX_ET0 | + | | MAX_ET0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of crop canopy |
|- | |- | ||
− | | MAX_SNOW_DEPTH | + | | MAX_SNOW_DEPTH ||-||NUMBER(6,2)||cm || maximum daily mean snow depth |
|- | |- | ||
− | | STD_TEMPERATURE_MAX | + | | STD_TEMPERATURE_MAX ||-||NUMBER(4,2)||°C || standard deviation of maximum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_MIN | + | | STD_TEMPERATURE_MIN ||-||NUMBER(4,2)||°C || standard deviation of minimum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_AVG | + | | STD_TEMPERATURE_AVG ||-||NUMBER(4,2)||°C || standard deviation of mean air temperature |
|- | |- | ||
− | | STD_PRECIPITATION | + | | STD_PRECIPITATION ||-||NUMBER(5,2)||mm.d-1 || standard deviation of daily rainfall |
|- | |- | ||
− | | STD_RADIATION | + | | STD_RADIATION ||-||NUMBER(8,1)||kJ.m-2.d-1 || standard deviation of daily radiation at surface |
|- | |- | ||
− | | STD_VAPOURPRESSURE | + | | STD_VAPOURPRESSURE ||-||NUMBER(6,3)||hPa || standard deviation of mean daily vapour pressure |
|- | |- | ||
− | | STD_WINDSPEED | + | | STD_WINDSPEED ||-||NUMBER(6,2)||m.s-1 || standard deviation of mean daily wind speed at 10 m height |
|- | |- | ||
− | | STD_E0 | + | | STD_E0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of water surface |
|- | |- | ||
− | | STD_ES0 | + | | STD_ES0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of wet bare soil |
|- | |- | ||
− | | STD_ET0 | + | | STD_ET0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of crop canopy |
|- | |- | ||
− | | STD_SNOWDEPTH | + | | STD_SNOWDEPTH ||-||NUMBER(7,3)||cm || standard deviation of daily mean snow depth |
|- | |- | ||
− | | NUM_TEMPERATURE_MIN | + | | NUM_TEMPERATURE_MIN ||-||NUMBER(6)|| - || count of air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_MAX | + | | NUM_TEMPERATURE_MAX ||-||NUMBER(6)|| - || count of maximum air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_AVG | + | | NUM_TEMPERATURE_AVG ||-||NUMBER(6)|| - || count of mean air temperature |
|- | |- | ||
− | | NUM_PRECIPITATION | + | | NUM_PRECIPITATION ||-||NUMBER(6)|| - || count of daily rainfall |
|- | |- | ||
− | | NUM_RADIATION | + | | NUM_RADIATION ||-||NUMBER(6)|| - || count of daily radiation at surface |
|- | |- | ||
− | | NUM_VAPOURPRESSURE | + | | NUM_VAPOURPRESSURE ||-||NUMBER(6)|| - || count of mean daily vapour pressure |
|- | |- | ||
− | | NUM_WINDSPEED | + | | NUM_WINDSPEED ||-||NUMBER(6)|| - || count of mean daily wind speed at 10 m height |
|- | |- | ||
− | | NUM_E0 | + | | NUM_E0 ||-||NUMBER(6)|| - || count of daily transpiration of water surface |
|- | |- | ||
− | | NUM_ES0 | + | | NUM_ES0 ||-||NUMBER(6)|| - || count of daily transpiration of wet bare soil |
|- | |- | ||
− | | NUM_ET0 | + | | NUM_ET0 ||-||NUMBER(6)|| - || count of daily transpiration of crop canopy |
|- | |- | ||
− | | NUM_SNOWDEPTH | + | | NUM_SNOWDEPTH ||-||NUMBER(6)|| - || count of daily mean snow depth |
|} | |} | ||
<nowiki>*</nowiki> In script changed to 4,2. Not yet installed. | <nowiki>*</nowiki> In script changed to 4,2. Not yet installed. | ||
Line 5,386: | Line 5,386: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10,0)|| - || administrative region id |
|- | |- | ||
− | | REG_NAME | + | | REG_NAME ||NOT NULL||VARCHAR2(50|| - || administrative region name |
|- | |- | ||
− | | TOTAL_GRIDS | + | | TOTAL_GRIDS ||-||NUMBER(10,0)|| - || total number of grid cells |
|- | |- | ||
− | | TOTAL_GRIDS_CC | + | | TOTAL_GRIDS_CC ||-||NUMBER(10,0)|| - || total number of grid cells with at least 1 crop calendar |
|- | |- | ||
− | | MISSING_GRIDS* | + | | MISSING_GRIDS* ||-||NUMBER(10,1)|| - || total number of missing grid cells |
|- | |- | ||
− | | MISSING_GRIDS_CC | + | | MISSING_GRIDS_CC ||-||NUMBER(10,1)|| - || total number of missing grid cells with at least 1 crop calendar |
|- | |- | ||
− | | MISSING_GRIDS_ORIGINAL | + | | MISSING_GRIDS_ORIGINAL ||-||NUMBER(10,1)|| - || total number of missing grid cells |
|} | |} | ||
<nowiki>*</nowiki> When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL. | <nowiki>*</nowiki> When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL. | ||
Line 5,416: | Line 5,416: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | LANDCOVER_NO | + | | LANDCOVER_NO ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||NOT NULL||NUMBER(3,1)||°C || maximum daily air temperature |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||NOT NULL||NUMBER(3,1)||°C || minimum daily air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||NOT NULL||NUMBER(3,1)||°C || average daily air temperature |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||NOT NULL||NUMBER(4,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||NOT NULL||NUMBER(5,1)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||NOT NULL||NUMBER(4,1)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||NOT NULL||NUMBER(4,2)||mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||NOT NULL||NUMBER(6,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of area with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of area with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of area with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)||°C || average temperature above 10°C |
|} | |} | ||
|} | |} | ||
Line 5,503: | Line 5,503: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | REG_MAP_ID | + | | REG_MAP_ID ||NOT NULL||NUMBER(10)|| - || administrative region id |
|- | |- | ||
− | | LANDCOVER_NO | + | | LANDCOVER_NO ||NOT NULL||NUMBER(10)|| - || landmask / cropmask id |
|- | |- | ||
− | | THRESHOLD | + | | THRESHOLD ||NOT NULL||NUMBER(3)|| - || used threshold in percentage |
|- | |- | ||
− | | DAY_NO | + | | DAY_NO ||NOT NULL||VARCHAR2(4)|| - || day of year stored as mmdd |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || average maximum air temperature |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || average minimum air temperature |
|- | |- | ||
− | | TEMPERATURE_AVG | + | | TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || average mean air temperature |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || average daily rainfall |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||-||NUMBER(7,1)||kJ.m-2.d-1 || average daily radiation at surface |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || average mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||-||NUMBER(5,1)||m.s-1 || average mean daily wind speed at 10 m height |
|- | |- | ||
− | | E0 | + | | E0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||-||NUMBER(4,2)||mm.d-1 || average daily transpiration of crop canopy |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || average daily mean snow depth |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_25 | + | | FRAC_AREA_TEMP_MAX_GE_25 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 25°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_30 | + | | FRAC_AREA_TEMP_MAX_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 30°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_35 | + | | FRAC_AREA_TEMP_MAX_GE_35 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 35°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MAX_GE_40 | + | | FRAC_AREA_TEMP_MAX_GE_40 ||-||NUMBER(3,2)|| - || fraction of days with maximum temperature >= 40°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_0 | + | | FRAC_AREA_TEMP_MIN_LE_0 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= 0°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN8 | + | | FRAC_AREA_TEMP_MIN_LE_MIN8 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -8°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN10 | + | | FRAC_AREA_TEMP_MIN_LE_MIN10 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -10°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN18 | + | | FRAC_AREA_TEMP_MIN_LE_MIN18 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -18°C |
|- | |- | ||
− | | FRAC_AREA_TEMP_MIN_LE_MIN20 | + | | FRAC_AREA_TEMP_MIN_LE_MIN20 ||-||NUMBER(3,2)|| - || fraction of days with minimum <= -20°C |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_1 | + | | FRAC_AREA_PRECIPITATION_GE_1 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 1mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_3 | + | | FRAC_AREA_PRECIPITATION_GE_3 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 3mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_5 | + | | FRAC_AREA_PRECIPITATION_GE_5 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 5mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_10 | + | | FRAC_AREA_PRECIPITATION_GE_10 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 10mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_15 | + | | FRAC_AREA_PRECIPITATION_GE_15 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 15mm |
|- | |- | ||
− | | FRAC_AREA_PRECIPITATION_GE_30 | + | | FRAC_AREA_PRECIPITATION_GE_30 ||-||NUMBER(3,2)|| - || fraction of days with rainfall >= 30mm |
|- | |- | ||
− | | AVG_TEMP_GE_0 | + | | AVG_TEMP_GE_0 ||-||NUMBER(3,1)||°C || average temperature above 0°C |
|- | |- | ||
− | | AVG_TEMP_GE_2 | + | | AVG_TEMP_GE_2 ||-||NUMBER(3,1)||°C || average temperature above 2°C |
|- | |- | ||
− | | AVG_TEMP_GE_4 | + | | AVG_TEMP_GE_4 ||-||NUMBER(3,1)||°C || average temperature above 4°C |
|- | |- | ||
− | | AVG_TEMP_GE_6 | + | | AVG_TEMP_GE_6 ||-||NUMBER(3,1)||°C || average temperature above 6°C |
|- | |- | ||
− | | AVG_TEMP_GE_8 | + | | AVG_TEMP_GE_8 ||-||NUMBER(3,1)||°C || average temperature above 8°C |
|- | |- | ||
− | | AVG_TEMP_GE_10 | + | | AVG_TEMP_GE_10 ||-||NUMBER(3,1)||°C || average temperature above 10°C |
|- | |- | ||
− | | MIN_TEMPERATURE_MIN | + | | MIN_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || minimum minimum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_MAX | + | | MIN_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || minimum maximum air temperature |
|- | |- | ||
− | | MIN_TEMPERATURE_AVG | + | | MIN_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || minimum mean air temperature |
|- | |- | ||
− | | MIN_PRECIPITATION | + | | MIN_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || minimum daily rainfall |
|- | |- | ||
− | | MIN_RADIATION | + | | MIN_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || minimum daily radiation at surface |
|- | |- | ||
− | | MIN_VAPOURPRESSURE | + | | MIN_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || minimum mean daily vapour pressure |
|- | |- | ||
− | | MIN_WINDSPEED | + | | MIN_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || minimum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MIN_E0 | + | | MIN_E0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of water surface |
|- | |- | ||
− | | MIN_ES0 | + | | MIN_ES0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of wet bare soil |
|- | |- | ||
− | | MIN_ET0 | + | | MIN_ET0 ||-||NUMBER(4,2)||mm.d-1 || minimum daily transpiration of crop canopy |
|- | |- | ||
− | | MIN_SNOWDEPTH | + | | MIN_SNOWDEPTH ||-||NUMBER(6,2)||cm || minimum daily mean snow depth |
|- | |- | ||
− | | MAX_TEMPERATURE_MIN | + | | MAX_TEMPERATURE_MIN ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_MAX | + | | MAX_TEMPERATURE_MAX ||-||NUMBER(3,1)||°C || maximum maximum air temperature |
|- | |- | ||
− | | MAX_TEMPERATURE_AVG | + | | MAX_TEMPERATURE_AVG ||-||NUMBER(3,1)||°C || maximum mean air temperature |
|- | |- | ||
− | | MAX_PRECIPITATION | + | | MAX_PRECIPITATION ||-||NUMBER(4,1)||mm.d-1 || maximum daily rainfall |
|- | |- | ||
− | | MAX_RADIATION | + | | MAX_RADIATION ||-||NUMBER(6)||kJ.m-2.d-1 || maximum daily radiation at surface |
|- | |- | ||
− | | MAX_VAPOURPRESSURE | + | | MAX_VAPOURPRESSURE ||-||NUMBER(4,2)||hPa || maximum mean daily vapour pressure |
|- | |- | ||
− | | MAX_WINDSPEED | + | | MAX_WINDSPEED ||-||NUMBER(5,1)||m.s-1 || maximum mean daily wind speed at 10 m height |
|- | |- | ||
− | | MAX_E0 | + | | MAX_E0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of water surface |
|- | |- | ||
− | | MAX_ES0 | + | | MAX_ES0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of wet bare soil |
|- | |- | ||
− | | MAX_ET0 | + | | MAX_ET0 ||-||NUMBER(4,2)||mm.d-1 || maximum daily transpiration of crop canopy |
|- | |- | ||
− | | MAX_SNOW_DEPTH | + | | MAX_SNOW_DEPTH ||-||NUMBER(6,2)||cm || maximum daily mean snow depth |
|- | |- | ||
− | | STD_TEMPERATURE_MAX | + | | STD_TEMPERATURE_MAX ||-||NUMBER(4,2)||°C || standard deviation of maximum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_MIN | + | | STD_TEMPERATURE_MIN ||-||NUMBER(4,2)||°C || standard deviation of minimum air temperature |
|- | |- | ||
− | | STD_TEMPERATURE_AVG | + | | STD_TEMPERATURE_AVG ||-||NUMBER(4,2)||°C || standard deviation of mean air temperature |
|- | |- | ||
− | | STD_PRECIPITATION | + | | STD_PRECIPITATION ||-||NUMBER(5,2)||mm.d-1 || standard deviation of daily rainfall |
|- | |- | ||
− | | STD_RADIATION | + | | STD_RADIATION ||-||NUMBER(8,1)||kJ.m-2.d-1 || standard deviation of daily radiation at surface |
|- | |- | ||
− | | STD_VAPOURPRESSURE | + | | STD_VAPOURPRESSURE ||-||NUMBER(6,3)||hPa || standard deviation of mean daily vapour pressure |
|- | |- | ||
− | | STD_WINDSPEED | + | | STD_WINDSPEED ||-||NUMBER(6,2)||m.s-1 || standard deviation of mean daily wind speed at 10 m height |
|- | |- | ||
− | | STD_E0 | + | | STD_E0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of water surface |
|- | |- | ||
− | | STD_ES0 | + | | STD_ES0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of wet bare soil |
|- | |- | ||
− | | STD_ET0 | + | | STD_ET0 ||-||NUMBER(4,2)||mm.d-1 || standard deviation of daily transpiration of crop canopy |
|- | |- | ||
− | | STD_SNOWDEPTH | + | | STD_SNOWDEPTH ||-||NUMBER(7,3)||cm || standard deviation of daily mean snow depth |
|- | |- | ||
− | | NUM_TEMPERATURE_MIN | + | | NUM_TEMPERATURE_MIN ||-||NUMBER(6)|| - || count of air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_MAX | + | | NUM_TEMPERATURE_MAX ||-||NUMBER(6)|| - || count of maximum air temperature |
|- | |- | ||
− | | NUM_TEMPERATURE_AVG | + | | NUM_TEMPERATURE_AVG ||-||NUMBER(6)|| - || count of mean air temperature |
|- | |- | ||
− | | NUM_PRECIPITATION | + | | NUM_PRECIPITATION ||-||NUMBER(6)|| - || count of daily rainfall |
|- | |- | ||
− | | NUM_RADIATION | + | | NUM_RADIATION ||-||NUMBER(6)|| - || count of daily radiation at surface |
|- | |- | ||
− | | NUM_VAPOURPRESSURE | + | | NUM_VAPOURPRESSURE ||-||NUMBER(6)|| - || count of mean daily vapour pressure |
|- | |- | ||
− | | NUM_WINDSPEED | + | | NUM_WINDSPEED ||-||NUMBER(6)|| - || count of mean daily wind speed at 10 m height |
|- | |- | ||
− | | NUM_E0 | + | | NUM_E0 ||-||NUMBER(6)|| - || count of daily transpiration of water surface |
|- | |- | ||
− | | NUM_ES0 | + | | NUM_ES0 ||-||NUMBER(6)|| - || count of daily transpiration of wet bare soil |
|- | |- | ||
− | | NUM_ET0 | + | | NUM_ET0 ||-||NUMBER(6)|| - || count of daily transpiration of crop canopy |
|- | |- | ||
− | | NUM_SNOWDEPTH | + | | NUM_SNOWDEPTH ||-||NUMBER(6)|| - || count of daily mean snow depth |
|} | |} | ||
|} | |} | ||
Line 5,679: | Line 5,679: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | STATION_NUMBER | + | | STATION_NUMBER ||NOT NULL||NUMBER(7)|| - || station number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
− | | CLOUD_TOTAL_24H | + | | CLOUD_TOTAL_24H ||-||NUMBER(6,2)||oktas || not used in CGMS |
|- | |- | ||
− | | CLOUD_LOW_24H | + | | CLOUD_LOW_24H ||-||NUMBER(6,2)||oktas || not used in CGMS |
|- | |- | ||
− | | CLOUD_MIDDLE_24H | + | | CLOUD_MIDDLE_24H ||-||NUMBER(6,2)||oktas || not used in CGMS |
|- | |- | ||
− | | CLOUD_HIGH_24H | + | | CLOUD_HIGH_24H ||-||NUMBER(6,2)||oktas || not used in CGMS |
|- | |- | ||
− | | SUNSHINE | + | | SUNSHINE (2)||-||NUMBER(6,2)||h daily sunshine duration |
|- | |- | ||
− | | RADIATION | + | | RADIATION (1)||-||NUMBER(11,2)||kJ.m-2.d-1 || daily global radiation at surface |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN (3,4)||-||NUMBER(6,2)||°C || minimum air temperature |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX (3,4)||-||NUMBER(6,2)||°C || maximum air temperature |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||-||NUMBER(6,2)||hPa || daily mean vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||-||NUMBER(6,2)||m.s-1 || not used in CGMS |
|- | |- | ||
− | | WINDSPEED_10M | + | | WINDSPEED_10M ||-||NUMBER(6,2)||m.s-1 || daily mean wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(6,2)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | TEMPERATURE_06H | + | | TEMPERATURE_06H ||-||NUMBER(6,2)||°C || air temperature 6 UTC |
|- | |- | ||
− | | HUMIDITY_06H | + | | HUMIDITY_06H ||-||NUMBER(6,2)|| % || humidity 6 UTC |
|- | |- | ||
− | | TEMPERATURE_09H | + | | TEMPERATURE_09H ||-||NUMBER(6,2)||°C || air temperature 9 UTC |
|- | |- | ||
− | | HUMIDITY_09H | + | | HUMIDITY_09H ||-||NUMBER(6,2)|| % || humidity 9 UTC |
|- | |- | ||
− | | TEMPERATURE_12H | + | | TEMPERATURE_12H ||-||NUMBER(6,2)||°C || air temperature 12 UTC |
|- | |- | ||
− | | HUMIDITY_12H | + | | HUMIDITY_12H ||-||NUMBER(6,2)|| % || humidity 12 UTC |
|- | |- | ||
− | | TEMPERATURE_15H | + | | TEMPERATURE_15H ||-||NUMBER(6,2)||°C || air temperature 15 UTC |
|- | |- | ||
− | | HUMIDITY_15H | + | | HUMIDITY_15H ||-||NUMBER(6,2)|| % || humidity 15 UTC |
|- | |- | ||
− | | TEMPERATURE_18H | + | | TEMPERATURE_18H ||-||NUMBER(6,2)||°C || air temperature 18 UTC |
|- | |- | ||
− | | HUMIDITY_18H | + | | HUMIDITY_18H ||-||NUMBER(6,2)|| % || humidity 18 UTC |
|- | |- | ||
− | | STATE_SOIL | + | | STATE_SOIL ||-||NUMBER(6,2)|| - || not used in CGMS |
|- | |- | ||
− | | VAPOURPRESSURE_DEF | + | | VAPOURPRESSURE_DEF ||-||NUMBER(6,2)||hPa || not used in CGMS |
|- | |- | ||
− | | SLOPE_VP_VS_T | + | | SLOPE_VP_VS_T ||-||NUMBER(6,3)||hPa.°C-1 || not used in CGMS |
|- | |- | ||
− | | CLOUD_TOTAL_DAYTIME | + | | CLOUD_TOTAL_DAYTIME (3)||-||NUMBER(6,2)||oktas || daily mean of total cloud cover |
|- | |- | ||
− | | CLOUD_LOW_DAYTIME | + | | CLOUD_LOW_DAYTIME ||oktas || not used in CGMS||-||NUMBER(6,2 |
|- | |- | ||
− | | CLOUD_SHADOW | + | | CLOUD_SHADOW ||oktas || not used in CGMS||-||NUMBER(6,2 |
|- | |- | ||
− | | VISIBILITY | + | | VISIBILITY ||-||NUMBER(6,1)|| - || not used in CGMS |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|} | |} | ||
1 this variable returns directly radiation<br> | 1 this variable returns directly radiation<br> | ||
Line 5,763: | Line 5,763: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | YEAR | + | | YEAR ||NOT NULL||NUMBER(4,0)|| - || historic year |
|- | |- | ||
− | | STATION_NUMBER | + | | STATION_NUMBER ||NOT NULL||NUMBER(7,0)|| - || station number |
|- | |- | ||
− | | AVAILABILITY_TYPE | + | | AVAILABILITY_TYPE ||NOT NULL||VARCHAR2|| - || class e.g. temperature |
|} | |} | ||
|} | |} | ||
Line 5,785: | Line 5,785: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |STATION_NUMBER | + | |STATION_NUMBER || NOT NULL || NUMBER(7,0) || - || station number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || calendar day |
|- | |- | ||
− | |E0 | + | |E0 || - || NUMBER|| mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || - || NUMBER|| mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || - || NUMBER|| mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |RADIATION | + | |RADIATION || - || NUMBER(9,0) || kJ.m-2.d-1 || daily radiation at surface |
|} | |} | ||
|} | |} | ||
Line 5,917: | Line 5,917: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | | STATION_NUMBER | + | | STATION_NUMBER ||NOT NULL||NUMBER(7)|| - || station number |
|- | |- | ||
− | | DAY | + | | DAY ||NOT NULL||DATE|| - || calendar day |
|- | |- | ||
| CLOUD_TOTAL_24H||-||NUMBER(2)|| - || | | CLOUD_TOTAL_24H||-||NUMBER(2)|| - || | ||
Line 6,006: | Line 6,006: | ||
| STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - || | | STATION_NUMBER||NOT NULL||NUMBER(7,0)|| - || | ||
|- | |- | ||
− | | DAY_NO | + | | DAY_NO ||NOT NULL||VARCHAR2(4|| - || calendar day for leap year |
|- | |- | ||
− | | TEMPERATURE_MAX | + | | TEMPERATURE_MAX ||-||NUMBER(6,2)||°C || maximum air temperature |
|- | |- | ||
− | | TEMPERATURE_MIN | + | | TEMPERATURE_MIN ||-||NUMBER(6,2)||°C || minimum air temperature |
|- | |- | ||
− | | VAPOURPRESSURE | + | | VAPOURPRESSURE ||-||NUMBER(6,2)||hPa || mean daily vapour pressure |
|- | |- | ||
− | | WINDSPEED | + | | WINDSPEED ||-||NUMBER(6,2)||m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | | PRECIPITATION | + | | PRECIPITATION ||-||NUMBER(6,2)||mm.d-1 || daily rainfall |
|- | |- | ||
− | | E0 | + | | E0 ||-||NUMBER(4,2)||mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | | ES0 | + | | ES0 ||-||NUMBER(4,2)||mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | | ET0 | + | | ET0 ||-||NUMBER(4,2)||mm.d-1 || daily transpiration of closed crop canopy |
|- | |- | ||
− | | RADIATION | + | | RADIATION ||-||NUMBER(9,0)||kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | | SNOWDEPTH | + | | SNOWDEPTH ||-||NUMBER(6,2)||cm || daily mean snow depth |
|} | |} | ||
|} | |} | ||
Line 6,190: | Line 6,190: | ||
| WMO_NAME||-||VARCHAR2(32)|| - || | | WMO_NAME||-||VARCHAR2(32)|| - || | ||
|- | |- | ||
− | | LATITUDE | + | | LATITUDE ||NOT NULL||NUMBER(7,5)||dd || latitude |
|- | |- | ||
− | | LONGITUDE | + | | LONGITUDE ||NOT NULL||NUMBER(8,5)||dd || longitude |
|- | |- | ||
| Y_COORDINATE||NOT NULL||NUMBER(13,5)||m || | | Y_COORDINATE||NOT NULL||NUMBER(13,5)||m || | ||
Line 6,198: | Line 6,198: | ||
| X_COORDINATE||NOT NULL||NUMBER(13,5)||m || | | X_COORDINATE||NOT NULL||NUMBER(13,5)||m || | ||
|- | |- | ||
− | | ALTITUDE | + | | ALTITUDE ||NOT NULL||NUMBER(5)||m || altitude |
|- | |- | ||
| CLIMATE_BARRIER_NO||NOT NULL||NUMBER(2)|| - || | | CLIMATE_BARRIER_NO||NOT NULL||NUMBER(2)|| - || | ||
|- | |- | ||
− | | COUNTRY_CODE | + | | COUNTRY_CODE ||NOT NULL||VARCHAR2(26)|| - || country code |
|- | |- | ||
− | | DISTANCE_TO_COAST | + | | DISTANCE_TO_COAST ||NOT NULL||NUMBER(4)||km || distance to coast |
|- | |- | ||
| PERCENT_COMPLETE||-||-|| - || | | PERCENT_COMPLETE||-||-|| - || | ||
Line 6,226: | Line 6,226: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(38,0) || - || grid number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || calendar day |
|- | |- | ||
− | |MAXIMUM_TEMPERATURE | + | |MAXIMUM_TEMPERATURE || NOT NULL || NUMBER || °C || maximum air temperature |
|- | |- | ||
− | |MINIMUM_TEMPERATURE | + | |MINIMUM_TEMPERATURE || NOT NULL || NUMBER || °C || minimum air temperature |
|- | |- | ||
− | |VAPOUR_PRESSURE | + | |VAPOUR_PRESSURE || NOT NULL || NUMBER || hPa || mean daily vapour pressure |
|- | |- | ||
− | |WINDSPEED | + | |WINDSPEED || NOT NULL || NUMBER || m.s-1 || mean daily wind speed at 10 m height |
|- | |- | ||
− | |RAINFALL | + | |RAINFALL || NOT NULL || NUMBER || mm.d-1 || daily rainfall |
|- | |- | ||
− | |E0 | + | |E0 || NOT NULL || NUMBER || mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || NOT NULL || NUMBER || mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || NOT NULL || NUMBER || mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |CALCULATED_RADIATION | + | |CALCULATED_RADIATION || NOT NULL || NUMBER(38) || kJ.m-2.d-1 || daily radiation at surface |
|- | |- | ||
− | |SNOW_DEPTH | + | |SNOW_DEPTH || - || NUMBER || cm || daily mean snow depth |
|} | |} | ||
|} | |} | ||
Line 6,266: | Line 6,266: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |WMO_NO | + | |WMO_NO || NOT NULL || NUMBER(38,0) || - || station number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || DATE || - || calendar day |
|- | |- | ||
− | |E0 | + | |E0 || - || NUMBER|| mm.d-1 || daily transpiration of water surface |
|- | |- | ||
− | |ES0 | + | |ES0 || - || NUMBER|| mm.d-1 || daily transpiration of wet bare soil |
|- | |- | ||
− | |ET0 | + | |ET0 || - || NUMBER|| mm.d-1 || daily transpiration of crop canopy |
|- | |- | ||
− | |CALCULATED_RADIATION | + | |CALCULATED_RADIATION || - || NUMBER(38,0) || kJ.m-2.d-1 || daily radiation at surface |
|} | |} | ||
|} | |} | ||
Line 6,291: | Line 6,291: | ||
| | | | ||
<pre> | <pre> | ||
− | CREATE OR REPLACE VIEW "FORALL"."DAY_DECADE" | + | CREATE OR REPLACE VIEW "FORALL"."DAY_DECADE" AS "DAY", "MONTH", "DECADE" |
select | select | ||
dayno_mon day | dayno_mon day | ||
Line 6,306: | Line 6,306: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |DAY | + | |DAY ) || - || NUMBER || - || day in month (1-31 |
|- | |- | ||
− | |MONTH | + | |MONTH ) || - || NUMBER || - || month in year (1-12 |
|- | |- | ||
− | |DECADE | + | |DECADE || - || NUMBER || - || dekad in year (1-36 |
|} | |} | ||
|} | |} | ||
Line 6,328: | Line 6,328: | ||
!Attribute !! Contraint !! Type !! Unit !! comment | !Attribute !! Contraint !! Type !! Unit !! comment | ||
|- | |- | ||
− | |GRID_NO | + | |GRID_NO || NOT NULL || NUMBER(8,0) || - || grid number |
|- | |- | ||
− | |DAY | + | |DAY || NOT NULL || NUMBER(3,0) || - || day in current year |
|- | |- | ||
− | |RAIN_STATION | + | |RAIN_STATION || NOT NULL || NUMBER(5,0) || - || station number used for rainfall |
|- | |- | ||
− | |TEMP_STATION_1 | + | |TEMP_STATION_1 || NOT NULL || NUMBER(5,0) || - || first station used for interpolation temperature |
|- | |- | ||
− | |TEMP_STATION_2 | + | |TEMP_STATION_2 || - || NUMBER(5,0) || - || second station used for interpolation temperature |
|- | |- | ||
− | |TEMP_STATION_3 | + | |TEMP_STATION_3 || - || NUMBER(5,0) || - || third station used for interpolation temperature |
|- | |- | ||
− | |TEMP_STATION_4 | + | |TEMP_STATION_4 || - || NUMBER(5,0) || - || fourth station used for interpolation temperature |
|- | |- | ||
− | |REST_STATION_1 | + | |REST_STATION_1 || NOT NULL || NUMBER(5,0) || - || first station used for interpolation other variables |
|- | |- | ||
− | |REST_STATION_2 | + | |REST_STATION_2 || - || NUMBER(5,0) || - || second station used for interpolation other variables |
|- | |- | ||
− | |REST_STATION_3 | + | |REST_STATION_3 || - || NUMBER(5,0) || - || third station used for interpolation other variables |
|- | |- | ||
− | |REST_STATION_4 | + | |REST_STATION_4 || - || NUMBER(5,0) || - || fourth station used for interpolation other variables |
|- | |- | ||
− | |RAIN_SCORE | + | |RAIN_SCORE || - || NUMBER(6,2) || km || similarity score for station used rainfall |
|- | |- | ||
− | |TEMP_SCORE | + | |TEMP_SCORE || - || NUMBER(6,2) || km || similarity score for first station used interpolation temperature |
|- | |- | ||
− | |REST_SCORE | + | |REST_SCORE || - || NUMBER(6,2) || km || similarity score for first station used interpolation other variables |
|} | |} | ||
|} | |} | ||
[[Category:Appendixes]] | [[Category:Appendixes]] |
Revision as of 15:25, 7 March 2016
AEZ
- Description: synonym to oracle package
- Use: use to references the tables REGION_DESCRIPTIONS and REGION_MAPPINGS
- Type: synonym on FORALL.REGIONS_ZONES_08
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
AGGREGATION_AREAS
- Description: cultivated areas per region used for spatial aggregation of crop indicators
- Use: used for weighting during aggregating crop indicators towards regional crop indicators
- Type: Permanent table
- Remarks: none
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* 'SOURCE' can have the following values:
|
CGMS_SYSLOG
- Description: logging of run options.
- Use: output table containing information on the run executed
- Type: Permanent table
- Remarks: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_ADMIN
- Description: synonym to oracle package
- Use:
- Type: synonym on mrsman.cmeteo_admin
- Remarks: none
CMETEO_AEZ_GRID_LANDCOVERS
- Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
- Use: input for cmeteo with standardized attribute names
- Type: view on LINK_ AEZ_GRID_LANDCOVER
- Remarks: user defined, derived from GIS
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_AGGREGATION_AREAS
- Description: cultivated areas per region used for spatial aggregation of crop indicators
- Use: input for cmeteo, converting names of columns for use in cmeteo package
- Type: view on tables AGGREGATION_AREAS and REGION
- Remarks: none
Structure | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions ** Not in view, only in table |
CMETEO_CROPS
- Description: description of crops. Crop name, number, associated crop group and general month.
- Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
- Type: synonym on table mrsman.cmeteo_crops
- Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_GRID_LANDCOVER_AREAS
- Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
- Use: input for cmeteo with standardized attribute names
- Type: synonym on view CMETEO_AEZ_GRID_LANDCOVERS
- Remarks: none
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_GRID_WEATHER
- Description: weather indicators per grid
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: synonym on view CMETEO_WEATHER_OBS_GRID
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions |
CMETEO_LANDCOVERS
- List of landcovers or crops to be evaluated in CMETEO
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / CROP_LANDCOVER
Structure | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* All attributes Nullable in table versions |
CMETEO_PROCESS
- Description: synonym to oracle package
- Use:
- Type: synonym on mrsman.cmeteo_process
- Remarks: none
CMETEO_REGION_GRID_LANDCOVERS
- Description: landcover areas for each intersection of grid and administartive region (only level 3).
- Use: input for cmeteo with standardized attribute names
- Type: view on LINK_REGION_GRID_LANDCOVER
- Remarks: user defined, derived from GIS
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REGION_MAPPINGS
- Description: regions and their relations (mappings)
- Use: input for cmeteo
- Type: synonym on table REGION_MAPPINGS
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REGION_WEATHER
- Description: weather indicators per region
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: synonym on view CMETEO_WEATHER_OBS_AEZ
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REGIONS
- Description:
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: synonym on mrsman.cmeteo_regions
- Remark: none
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_REJECTED_WEATHER
- Description: rejected weather
- Use: log table for cmeteo
- Type: synonym on mrsman.cmeteo_rejected_weather
- Remark: none
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_WEATHER_OBS_AEZ
- Description: weather indicators per agri-environmental region
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: view on WEATHER_OBS_AEZ
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_WEATHER_OBS_GRID
- Description: weather indicators per grid
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: view on table WEATHER_OBS_GRID
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CMETEO_WEATHER_OBS_REGION
- Description: weather indicators per region
- Use: input for cmeteo, renaming columns to a standardized naming
- Type: view on WEATHER_OBS_REGION
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP
- Description: description of crops. Crop name, number, associated crop group and general month.
- Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
- Type: view on from forall.crop_landcover (subset of FORALL.CROP_LANDCOVER table).
- Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.
Structure | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* CROP_NO in
|
CROP_CALENDAR
- Description: where and when crops are grown. crop, crop variety and growing season per grid.
- Use: determines which crops are simulated for a grid, and simulation period
- Type: Permanent table
- Remarks: user defined, one of the ‘driving’ tables of the system ||
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category). |
CROP_GROUP
- Description: description of crop groups
- Use: input table for the crop group number and name where crop belongs to
- Type: synonym on permanent table FORALL.CROP_GROUP
- Remarks: none
Structure | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_LANDCOVER
- List of crop and landcovers
- Use: source for various views & synonyms
- Type: synonym & table
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_PARAMETER_VALUE
- Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
- Use: input table for the crop simulation process
- Type: Permanent table
- Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_YIELD
- Description:
- Use: used as interface between the CGMS12EU database and the viewers
- Type: view on table SIMYIELD_EMU
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DATA_FOR_YIELD_FORECAST
- Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).
- Use: table for storing the indicators values that can be used for regression and scenario-analysis (see Yield Forecasting).
- Type: Permanent table.
- Remarks: The table is filled and regularly updated with indicator values from table SIMYIELD_REGION. The table contains the same data as stored in SIMYIELD_REGION, but in a different structure. This way also new indicators can be added without having to change the structure.
Structure | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DATE_GENERATOR
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: synonym on forall.date_generator
- Remarks: none
DATES_75_15
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: synonym on forall.dates_75_15
- Remarks: none
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DAY_DECADEYEAR
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: synonym on FORALL.DAY_DECADEYEAR
- Remarks: none
Structure | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_<MODEL>
- Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
- Use: input for downscaling.
- Type: Permanent table
- Remarks: Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name. The calculation resolution of ECMWF models changes over time and/or forecast depth. In that case different derived elevation models are used stored in separate altitude Attributes with a reference to the ECMWF calculation resolution.
Structure | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Available in SEA. Derived from N128 gaussian grid |
EMU
- Description: the intersection of the soil map and the grid
- Use: input/reference table for the crop simulation process
- Type: Permanent table
- Remarks: user defined, derived from GIS, provides the link to the GIS
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|