Appendix 5: Database objects/GWSI E 16

content
1. CROP-datasets
2. GRID-datasets
3. HW30S-datasets
4. SOILS-datasets
5. other datasets

CROP-datasets

content
1.1 CROP_COEFFICIENTS
1.2 CROP_MASKS
1.3 CROP_SEASONS

CROP_COEFFICIENTS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDCROP_COEFFICIENT False NUMBER IDGRID_25KM False NUMBER IDCROP False NUMBER START_OF_SEASON_KC False NUMBER MAX_OF_SEASON_KC False NUMBER START_OF_SENESCENCE_KC False NUMBER END_OF_SEASON_KC False NUMBER CROP_ROOTING_DEPTH False NUMBER

CROP_MASKS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDCROP_MASK False NUMBER IDCROP False NUMBER IDGRID_1KM False NUMBER AREA_FRACTION True NUMBER

CROP_SEASONS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDCROP_SEASON False NUMBER IDCROP False NUMBER IDGRID_1KM False NUMBER IDSEASON False NUMBER

GRID-datasets

content
2.1 GRID_1KM
2.2 GRID_25KM
2.3 GRID_25KMPROCESS

GRID_1KM

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDGRID_1KM False NUMBER LATITUDE False NUMBER LONGITUDE False NUMBER AREA_M2 False NUMBER IDGRID_25KM True NUMBER IDSMU True NUMBER HAS_DATA True VARCHAR2

GRID_25KM

• Description:
• Use:
• Type: View
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDGRID_25KM False NUMBER LATITUDE False NUMBER LONGITUDE False NUMBER HAS_LAND False VARCHAR2 definition: select "IDGRID" as idgrid_25km,"LATITUDE","LONGITUDE","HAS_LAND" from grid_his@cgms14glo_glodas

GRID_25KMPROCESS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDGRID_25KMPROCESS False NUMBER IDGRID_25KM False NUMBER IDPROCESS False NUMBER

HW30S-datasets

content
3.1 HW30S_FULL
3.2 HW30S_MAPUNIT

HW30S_FULL

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment NEWSUID False VARCHAR2 SCID False NUMBER PROP True NUMBER CLAF True VARCHAR2 PRID True VARCHAR2 DRAIN True VARCHAR2 DRAINNUM True NUMBER LAYER False VARCHAR2 TOPDEP True NUMBER BOTDEP True NUMBER CFRAG True NUMBER CFRAG_STD True NUMBER SDTO True NUMBER SDTO_STD True NUMBER STPC True NUMBER STPC_STD True NUMBER CLPC True NUMBER CLPC_STD True NUMBER PSCL True VARCHAR2 BULK True NUMBER BULK_STD True NUMBER TAWC True NUMBER TAWC_STD True NUMBER ORGC True NUMBER ORGC_STD True NUMBER TOTN True NUMBER TOTN_STD True NUMBER CNRT True NUMBER CNRT_STD True NUMBER CECS True NUMBER CECS_STD True NUMBER CECC True NUMBER CECC_STD True NUMBER ECEC True NUMBER ECEC_STD True NUMBER TEB True NUMBER TEB_STD True NUMBER BSAT True NUMBER BSAT_STD True NUMBER ALSA True NUMBER ALSA_STD True NUMBER ESP True NUMBER ESP_STD True NUMBER PHAQ True NUMBER PHAQ_STD True NUMBER TCEQ True NUMBER TCEQ_STD True NUMBER GYPS True NUMBER GYPS_STD True NUMBER ELCO True NUMBER ELCO_STD True NUMBER

HW30S_MAPUNIT

• Description:
• Use:
• Type: Table
• Remarks:

Structure

Attribute Constraint Type Unit Comment NEWSUID False VARCHAR2 NOSOILCOMP True NUMBER DOMFAO_NAME True VARCHAR2 DOMFAO_PROP True NUMBER PROPSYNTHPROF True NUMBER SOILMAPUNIT True VARCHAR2 SOIL1 True VARCHAR2 PROP1 True NUMBER PRID1 True VARCHAR2 SOIL2 True VARCHAR2 PROP2 True NUMBER PRID2 True VARCHAR2 SOIL3 True VARCHAR2 PROP3 True NUMBER PRID3 True VARCHAR2 SOIL4 True VARCHAR2 PROP4 True NUMBER PRID4 True VARCHAR2 SOIL5 True VARCHAR2 PROP5 True NUMBER PRID5 True VARCHAR2 SOIL6 True VARCHAR2 PROP6 True NUMBER PRID6 True VARCHAR2 SOIL7 True VARCHAR2 PROP7 True NUMBER PRID7 True VARCHAR2 SOIL8 True VARCHAR2 PROP8 True NUMBER PRID8 True VARCHAR2 SOIL9 True VARCHAR2 PROP9 True NUMBER PRID9 True VARCHAR2 SOIL10 True VARCHAR2 PROP10 True NUMBER PRID10 True VARCHAR2 WATE True NUMBER

SOILS-datasets

content
4.1 SOILS_SMU
4.2 SOILS_SMU_TEMP
4.3 SOILS_STU
4.4 SOILS_STU_TEMP

SOILS_SMU

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDSMU False NUMBER

SOILS_SMU_TEMP

• Description:
• Use:
• Type: View
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDSMU True NUMBER definition: SELECT TO_NUMBER(SUBSTR(newsuid,4)) as IDSMU from HW30S_MAPUNIT

SOILS_STU

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDSOILS_STU False NUMBER IDSMU False NUMBER IDSTU False NUMBER PERCENTAGE False NUMBER SOIL_ROOTING_DEPTH False NUMBER AVAILABLE_WATER_CAPACITY False NUMBER

SOILS_STU_TEMP

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment IDSMU True NUMBER IDSTU False NUMBER PERCENTAGE True NUMBER SOIL_ROOTING_DEPTH True NUMBER AVAILABLE_WATER_CAPACITY True NUMBER definition: select to_number(substr(newsuid,4)) idsmu , scid idstu , prop percentage , max(botdep) soil_rooting_depth , avg(tawcc*(botdep-topdep))/sum(botdep-topdep) available_water_capacity from (select newsuid newsuid -- soil map unit id , scid scid -- soil type id , prop prop -- proportion of soil type in map unit , topdep topdep -- top depth of layer , botdep botdep -- bottom depth of layer , (1-(cfrag/100))*tawc tawcc -- tawc corrected for coarse fragments > 2mm from hw30s_full where botdep <= 100 -- skip layers deeper than 1 meter and tawc >= 0 -- skip records with -1, -2, -3, -4, -5, -7, -9 and to_number(substr(newsuid,4)) not in (0,6997,6998) -- skip records with suid 0, 6997, 6998 -- and newsuid = 'WD30003473' ) group by to_number(substr(newsuid,4)), scid, prop order by to_number(substr(newsuid,4)), scid, prop

other datasets

content
5.1 AREA
5.2 CROPS
5.3 PROCESS
5.4 SEASONS
5.5 SYSPARAMETERS
5.6 SYSTABLES
5.7 UNITS_CALC_INPUT
5.8 WEATHER_HRES_GRID_10

AREA

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDAREA False NUMBER AREA False NUMBER X False NUMBER Y False NUMBER X_NEW True NUMBER Y_NEW True NUMBER

CROPS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDCROP False NUMBER CROP False VARCHAR2 DESCRIPTOR False VARCHAR2

PROCESS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDPROCESS False NUMBER STATUS False NUMBER

SEASONS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDSEASON False NUMBER SEASON_NO False NUMBER START_OF_SEASON False NUMBER MAX_OF_SEASON False NUMBER START_OF_SENESCENCE False NUMBER END_OF_SEASON False NUMBER

SYSPARAMETERS

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment MNAME False VARCHAR2 MVALUE False VARCHAR2

SYSTABLES

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment TABLE_NAME True VARCHAR2 - HIGHEST_ID True NUMBER -

UNITS_CALC_INPUT

• Description:
• Use:
• Type: Table
• Remarks:

Structure
Attribute Constraint Type Unit Comment IDUNIT_CALC_INPUT False NUMBER IDGRID_25KM False NUMBER IDSMU False NUMBER IDSEASON False NUMBER IDCROP False NUMBER

WEATHER_HRES_GRID_10

• Description:
• Use:
• Type: View
• Remarks:

Structure

Attribute Constraint Type Unit Comment WEATHER_HRES_GRID_10_ID False NUMBER IDGRID_25KM False NUMBER YEAR False NUMBER DEKAD_IN_YEAR False NUMBER TEMPERATURE_AVG False NUMBER TEMPERATURE_MAX False NUMBER TEMPERATURE_MIN False NUMBER PRECIPITATION False NUMBER ET0 False NUMBER definition: select w.weather_hres_grid_10_id , w.idgrid IDGRID_25KM , w.year , w.dekad_in_year , w.temperature_avg , w.temperature_max , w.temperature_min , w.precipitation , w.et0 from weather_hres_grid_10@cgms14glo_glodas w