ACTUAL-datasets
ACTUAL_CALENDARS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
ACTUAL_CALENDAR_ID |
NOT NULL |
NUMBER(22) |
|
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
SEASON_NO |
NOT NULL |
NUMBER(22) |
|
|
SUB_SEASON |
|
VARCHAR2(1) |
|
|
START_YEAR |
NOT NULL |
NUMBER(22) |
|
|
START_DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
END_YEAR |
NOT NULL |
NUMBER(22) |
|
|
END_DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
EARLINESS |
NOT NULL |
NUMBER(22) |
|
|
FORCED |
|
VARCHAR2(1) |
|
|
YEAR_OF_ENTRY |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR_OF_ENTRY |
NOT NULL |
NUMBER(22) |
|
|
|
ACTUAL_CALENDARS_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
ACTUAL_CALENDAR_LTA_ID |
NOT NULL |
NUMBER(22) |
|
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
SEASON_NO |
NOT NULL |
NUMBER(22) |
|
|
START_DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
END_DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
EARLINESS |
|
NUMBER(22) |
|
|
FORCED |
NOT NULL |
NUMBER(22) |
|
|
AGG_COUNT |
|
NUMBER(22) |
|
|
|
CROP-datasets
CROP_CALENDARS
- 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: Table
- Remarks: user defined, one of the ‘driving’ tables of the system
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
CROP_CALENDAR_ID |
NOT NULL |
NUMBER(22) |
|
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
HAS_CLIMATE_SEASON_1 |
NOT NULL |
NUMBER(22, 1) |
|
|
HAS_CLIMATE_SEASON_2 |
NOT NULL |
NUMBER(22, 1) |
|
|
HAS_CLIMATE_SEASON_3 |
NOT NULL |
NUMBER(22, 1) |
|
|
MAX_FAO_DURATION |
|
NUMBER(22, 2) |
|
|
HAS_CROP_SEASON_1 |
NOT NULL |
NUMBER(22, 1) |
|
|
HAS_CROP_SEASON_2 |
NOT NULL |
NUMBER(22, 1) |
|
|
HAS_CROP_SEASON_3 |
NOT NULL |
NUMBER(22, 1) |
|
|
MIN_CROP_DURATION |
|
NUMBER(22, 2) |
|
|
NR_OF_SEASONS |
|
NUMBER(22) |
|
|
START1 |
|
NUMBER(22) |
|
|
DUR1 |
|
NUMBER(22) |
|
|
SUBSEASON1 |
|
VARCHAR2(1) |
|
|
START2 |
|
NUMBER(22) |
|
|
DUR2 |
|
NUMBER(22) |
|
|
SUBSEASON2 |
|
VARCHAR2(1) |
|
|
START3 |
|
NUMBER(22) |
|
|
DUR3 |
|
NUMBER(22) |
|
|
SUBSEASON3 |
|
VARCHAR2(1) |
|
|
START4 |
|
NUMBER(22) |
|
|
DUR4 |
|
NUMBER(22) |
|
|
SUBSEASON4 |
|
VARCHAR2(1) |
|
|
* possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category).
** possible values: HARVEST, MATURITY, EARLIEST (see Spatial/temporal variation category).
|
CROP_COEFFICIENTS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
CROP_COEFFICIENT_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
PROGRESS_INDEX |
NOT NULL |
NUMBER(22) |
|
|
CROP_COEFFICIENT_VALUE |
NOT NULL |
NUMBER(22) |
|
|
|
CROP_TEMP_COEFFICIENTS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
TEMPERATURE_MEAN |
NOT NULL |
NUMBER(22) |
|
|
REDUCTION |
NOT NULL |
NUMBER(22) |
|
|
|
GRID-datasets
GRID_CLIMATE_SEASONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
NR_OF_SEASONS |
|
NUMBER(22, 1) |
|
|
START1 |
|
NUMBER(22, 2) |
|
|
START2 |
|
NUMBER(22, 2) |
|
|
START3 |
|
NUMBER(22, 2) |
|
|
DUR1 |
|
NUMBER(22, 2) |
|
|
DUR2 |
|
NUMBER(22, 2) |
|
|
DUR3 |
|
NUMBER(22, 2) |
|
|
START1_THLD1 |
|
NUMBER(22, 5) |
|
|
START1_THLD2 |
|
NUMBER(22, 5) |
|
|
START1_THLD3 |
|
NUMBER(22, 5) |
|
|
START1_THLD4 |
|
NUMBER(22, 5) |
|
|
START1_THLD5 |
|
NUMBER(22, 5) |
|
|
START1_THLD6 |
|
NUMBER(22, 5) |
|
|
START1_THLD7 |
|
NUMBER(22, 5) |
|
|
START2_THLD1 |
|
NUMBER(22, 5) |
|
|
START2_THLD2 |
|
NUMBER(22, 5) |
|
|
START2_THLD3 |
|
NUMBER(22, 5) |
|
|
START2_THLD4 |
|
NUMBER(22, 5) |
|
|
START2_THLD5 |
|
NUMBER(22, 5) |
|
|
START2_THLD6 |
|
NUMBER(22, 5) |
|
|
START2_THLD7 |
|
NUMBER(22, 5) |
|
|
START3_THLD1 |
|
NUMBER(22, 5) |
|
|
START3_THLD2 |
|
NUMBER(22, 5) |
|
|
START3_THLD3 |
|
NUMBER(22, 5) |
|
|
START3_THLD4 |
|
NUMBER(22, 5) |
|
|
START3_THLD5 |
|
NUMBER(22, 5) |
|
|
START3_THLD6 |
|
NUMBER(22, 5) |
|
|
START3_THLD7 |
|
NUMBER(22, 5) |
|
|
LOGGING_CHANGES |
|
VARCHAR2(500) |
|
|
|
GRID_CLIMATE_SEASONS_CROP_MASK
- Description:
- Use:
- Type: View
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
SEASON_CNT |
|
NUMBER(22, 1) |
|
|
SEASON_1 |
|
NUMBER(22) |
|
|
SEASON_2 |
|
NUMBER(22) |
|
|
SEASON_3 |
|
NUMBER(22) |
|
|
definition:
select gs.grid_id
,gs.crop_id
,gs.nr_of_seasons as season_cnt
,case when gs.start1 > 0 then 1 else 0 end as season_1
,case when gs.start2 > 0 then 1 else 0 end as season_2
,case when gs.start3 > 0 then 1 else 0 end as season_3
from grid_cropmasks gc
,grid_climate_seasons gs
where (gc.wheat = 1 and gs.crop_id = 1 and gs.grid_id = gc.grid_id)
or (gc.maize = 1 and gs.crop_id = 2 and gs.grid_id = gc.grid_id)
or (gc.barley = 1 and gs.crop_id = 3 and gs.grid_id = gc.grid_id)
or (gc.rice = 1 and gs.crop_id = 5 and gs.grid_id = gc.grid_id)
or (gc.potato = 1 and gs.crop_id = 7 and gs.grid_id = gc.grid_id)
or (gc.beans = 1 and gs.crop_id = 8 and gs.grid_id = gc.grid_id)
or (gc.soybean = 1 and gs.crop_id = 9 and gs.grid_id = gc.grid_id)
or (gc.sorghum = 1 and gs.crop_id = 30 and gs.grid_id = gc.grid_id)
or (gc.groundnut = 1 and gs.crop_id = 31 and gs.grid_id = gc.grid_id)
or (gc.millet = 1 and gs.crop_id = 32 and gs.grid_id = gc.grid_id)
or (gc.pulses = 1 and gs.crop_id = 33 and gs.grid_id = gc.grid_id)
|
GRID_CROPMASKS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
MAIZE |
NOT NULL |
NUMBER(22, 1) |
|
|
WHEAT |
NOT NULL |
NUMBER(22, 1) |
|
|
BARLEY |
|
NUMBER(22, 1) |
|
|
RICE |
NOT NULL |
NUMBER(22, 1) |
|
|
SORGHUM |
NOT NULL |
NUMBER(22, 1) |
|
|
SOYBEAN |
NOT NULL |
NUMBER(22, 1) |
|
|
MILLET |
NOT NULL |
NUMBER(22, 1) |
|
|
BEANS |
NOT NULL |
NUMBER(22, 1) |
|
|
POTATO |
NOT NULL |
NUMBER(22, 1) |
|
|
PULSES |
NOT NULL |
NUMBER(22, 1) |
|
|
GROUNDNUT |
NOT NULL |
NUMBER(22, 1) |
|
|
|
GRID_CUMETA_DUR1
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
CUMETA |
NOT NULL |
NUMBER(22) |
|
|
|
GRID_CUMETA_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
|
NUMBER(22) |
|
|
CROP_ID |
|
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
|
NUMBER(22) |
|
|
DURATION |
|
NUMBER(22) |
|
|
CUMETA |
|
NUMBER(22) |
|
|
ISVALIDSTART |
|
NUMBER(22) |
|
|
|
GRID_CUMETA_LTA_ADJ
- Description:
- Use:
- Type: View
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
|
NUMBER(22) |
|
|
CROP_ID |
|
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
|
NUMBER(22) |
|
|
DURATION |
|
NUMBER(22) |
|
|
CUMETA |
|
NUMBER(22) |
|
|
ISVALIDSTART |
|
NUMBER(22) |
|
|
definition:
SELECT GRID_ID ,
CROP_ID ,
DEKAD_IN_YEAR ,
DURATION ,
-- (case when isvalidstart = 100 then cumeta else 0 end) cumeta ,
cumeta ,
ISVALIDSTART
FROM GRID_CUMETA_LTA
|
GRID_CUMETA_TIMESERIES
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
DURATION |
NOT NULL |
NUMBER(22) |
|
|
CUMETA |
|
NUMBER(22) |
|
|
ISVALIDSTART |
|
VARCHAR2(1) |
|
|
|
GRID_FULL
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_FULL_ID |
NOT NULL |
NUMBER(22) |
|
|
XCENTRE |
NOT NULL |
NUMBER(22) |
|
|
YCENTRE |
NOT NULL |
NUMBER(22) |
|
|
AREA_KM2 |
NOT NULL |
NUMBER(22) |
|
|
AREA_M2 |
NOT NULL |
NUMBER(22) |
|
|
SNUM |
NOT NULL |
NUMBER(22) |
|
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
REG_MAP_ID |
NOT NULL |
NUMBER(22) |
|
|
|
GRID_FULLXUNITS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_FULLXUNIT_ID |
NOT NULL |
NUMBER(22) |
|
|
GRID_FULL_ID |
NOT NULL |
NUMBER(22) |
|
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
|
GRID_FULLXUNITS_JOINOPT
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
UNIT_CALC_INPUT_ID |
|
NUMBER(22) |
|
|
XCENTRE |
|
NUMBER(22) |
|
|
YCENTRE |
|
NUMBER(22) |
|
|
|
GRID_INI_SEASONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
NR |
|
NUMBER(22, 2) |
|
|
MAX1 |
|
NUMBER(22, 2) |
|
|
MAX2 |
|
NUMBER(22, 2) |
|
|
MAX3 |
|
NUMBER(22, 2) |
|
|
MAX4 |
|
NUMBER(22, 2) |
|
|
|
GRID_REGION_LANDCOVERS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
REG_MAP_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
LANDCOVER_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
AREA |
NOT NULL |
NUMBER(22, 10) |
|
|
|
GRID_THRESHOLDS_1
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
DEKAD |
|
NUMBER(22, 2) |
|
|
THR_1 |
|
NUMBER(22) |
|
|
THR_2 |
|
NUMBER(22) |
|
|
THR_3 |
|
NUMBER(22) |
|
|
THR_4 |
|
NUMBER(22) |
|
|
THR_5 |
|
NUMBER(22) |
|
|
THR_6 |
|
NUMBER(22) |
|
|
THR_7 |
|
NUMBER(22) |
|
|
|
GRID_THRESHOLDS_2
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
DEKAD |
|
NUMBER(22, 2) |
|
|
THR_1 |
|
NUMBER(22) |
|
|
THR_2 |
|
NUMBER(22) |
|
|
THR_3 |
|
NUMBER(22) |
|
|
THR_4 |
|
NUMBER(22) |
|
|
THR_5 |
|
NUMBER(22) |
|
|
THR_6 |
|
NUMBER(22) |
|
|
THR_7 |
|
NUMBER(22) |
|
|
|
GRID_THRESHOLDS_3
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 7) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
DEKAD |
|
NUMBER(22, 2) |
|
|
THR_1 |
|
NUMBER(22) |
|
|
THR_2 |
|
NUMBER(22) |
|
|
THR_3 |
|
NUMBER(22) |
|
|
THR_4 |
|
NUMBER(22) |
|
|
THR_5 |
|
NUMBER(22) |
|
|
THR_6 |
|
NUMBER(22) |
|
|
THR_7 |
|
NUMBER(22) |
|
|
|
GRID_WEATHER_MODEL_10
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_WEATHER_MODEL_10_ID |
NOT NULL |
NUMBER(22) |
|
|
GRID_ID |
|
NUMBER(22) |
|
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
|
NUMBER(22) |
|
|
TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
PRECIPITATION |
|
NUMBER(22) |
|
|
ET0 |
|
NUMBER(22) |
|
|
GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
SNOW_DEPTH |
|
NUMBER(22) |
|
|
|
GRID_WEATHER_MODEL_10_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_WEATHER_MODEL_10_LTA_ID |
NOT NULL |
NUMBER(22) |
|
|
GRID_ID |
|
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
|
NUMBER(22) |
|
|
MEAN_TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
MEAN_TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
MEAN_TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
MEAN_PRECIPITATION |
|
NUMBER(22) |
|
|
MEAN_ET0 |
|
NUMBER(22) |
|
|
MEAN_GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
MEAN_SNOW_DEPTH |
|
NUMBER(22) |
|
|
P25_TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
P25_TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
P25_TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
P25_PRECIPITATION |
|
NUMBER(22) |
|
|
P25_ET0 |
|
NUMBER(22) |
|
|
P25_GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
P25_SNOW_DEPTH |
|
NUMBER(22) |
|
|
P50_TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
P50_TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
P50_TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
P50_PRECIPITATION |
|
NUMBER(22) |
|
|
P50_ET0 |
|
NUMBER(22) |
|
|
P50_GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
P50_SNOW_DEPTH |
|
NUMBER(22) |
|
|
P75_TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
P75_TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
P75_TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
P75_PRECIPITATION |
|
NUMBER(22) |
|
|
P75_ET0 |
|
NUMBER(22) |
|
|
P75_GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
P75_SNOW_DEPTH |
|
NUMBER(22) |
|
|
SDV_TEMPERATURE_MEAN |
|
NUMBER(22) |
|
|
SDV_TEMPERATURE_MAXIMUM |
|
NUMBER(22) |
|
|
SDV_TEMPERATURE_MINIMUM |
|
NUMBER(22) |
|
|
SDV_PRECIPITATION |
|
NUMBER(22) |
|
|
SDV_ET0 |
|
NUMBER(22) |
|
|
SDV_GLOBAL_RADIATION |
|
NUMBER(22) |
|
|
SDV_SNOW_DEPTH |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_0 |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_2 |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_4 |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_6 |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_8 |
|
NUMBER(22) |
|
|
AVG_TEMP_GE_10 |
|
NUMBER(22) |
|
|
|
REGION-datasets
REGION_WEATHER_MODEL_10
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
REG_MAP_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
LANDCOVER_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
THRESHOLD |
NOT NULL |
NUMBER(22, 3) |
|
|
YEAR |
NOT NULL |
NUMBER(22, 4) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22, 2) |
|
|
TEMPERATURE_MEAN |
NOT NULL |
NUMBER(22, 3) |
|
|
TEMPERATURE_MAXIMUM |
NOT NULL |
NUMBER(22, 3) |
|
|
TEMPERATURE_MINIMUM |
NOT NULL |
NUMBER(22, 3) |
|
|
PRECIPITATION |
NOT NULL |
NUMBER(22, 5) |
|
|
ET0 |
NOT NULL |
NUMBER(22, 5) |
|
|
GLOBAL_RADIATION |
NOT NULL |
NUMBER(22, 7) |
|
|
SNOW_DEPTH |
NOT NULL |
NUMBER(22, 6) |
|
|
|
REGION_WEATHER_MODEL_10_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
REG_MAP_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
LANDCOVER_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
THRESHOLD |
NOT NULL |
NUMBER(22, 3) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22, 2) |
|
|
MEAN_TEMPERATURE_MEAN |
|
NUMBER(22, 3) |
|
|
MEAN_TEMPERATURE_MAXIMUM |
|
NUMBER(22, 3) |
|
|
MEAN_TEMPERATURE_MINIMUM |
|
NUMBER(22, 3) |
|
|
MEAN_PRECIPITATION |
|
NUMBER(22, 5) |
|
|
MEAN_ET0 |
|
NUMBER(22, 5) |
|
|
MEAN_GLOBAL_RADIATION |
|
NUMBER(22, 7) |
|
|
MEAN_SNOW_DEPTH |
|
NUMBER(22, 6) |
|
|
P25_TEMPERATURE_MEAN |
|
NUMBER(22, 3) |
|
|
P25_TEMPERATURE_MAXIMUM |
|
NUMBER(22, 3) |
|
|
P25_TEMPERATURE_MINIMUM |
|
NUMBER(22, 3) |
|
|
P25_PRECIPITATION |
|
NUMBER(22, 5) |
|
|
P25_ET0 |
|
NUMBER(22, 5) |
|
|
P25_GLOBAL_RADIATION |
|
NUMBER(22, 7) |
|
|
P25_SNOW_DEPTH |
|
NUMBER(22, 6) |
|
|
P50_TEMPERATURE_MEAN |
|
NUMBER(22, 3) |
|
|
P50_TEMPERATURE_MAXIMUM |
|
NUMBER(22, 3) |
|
|
P50_TEMPERATURE_MINIMUM |
|
NUMBER(22, 3) |
|
|
P50_PRECIPITATION |
|
NUMBER(22, 5) |
|
|
P50_ET0 |
|
NUMBER(22, 5) |
|
|
P50_GLOBAL_RADIATION |
|
NUMBER(22, 7) |
|
|
P50_SNOW_DEPTH |
|
NUMBER(22, 6) |
|
|
P75_TEMPERATURE_MEAN |
|
NUMBER(22, 3) |
|
|
P75_TEMPERATURE_MAXIMUM |
|
NUMBER(22, 3) |
|
|
P75_TEMPERATURE_MINIMUM |
|
NUMBER(22, 3) |
|
|
P75_PRECIPITATION |
|
NUMBER(22, 5) |
|
|
P75_ET0 |
|
NUMBER(22, 5) |
|
|
P75_GLOBAL_RADIATION |
|
NUMBER(22, 7) |
|
|
P75_SNOW_DEPTH |
|
NUMBER(22, 6) |
|
|
SDV_TEMPERATURE_MEAN |
|
NUMBER(22, 3) |
|
|
SDV_TEMPERATURE_MAXIMUM |
|
NUMBER(22, 3) |
|
|
SDV_TEMPERATURE_MINIMUM |
|
NUMBER(22, 3) |
|
|
SDV_PRECIPITATION |
|
NUMBER(22, 5) |
|
|
SDV_ET0 |
|
NUMBER(22, 5) |
|
|
SDV_GLOBAL_RADIATION |
|
NUMBER(22, 7) |
|
|
SDV_SNOW_DEPTH |
|
NUMBER(22, 6) |
|
|
AVG_TEMP_GE_0 |
|
NUMBER(22, 3) |
|
|
AVG_TEMP_GE_2 |
|
NUMBER(22, 3) |
|
|
AVG_TEMP_GE_4 |
|
NUMBER(22, 3) |
|
|
AVG_TEMP_GE_6 |
|
NUMBER(22, 3) |
|
|
AVG_TEMP_GE_8 |
|
NUMBER(22, 3) |
|
|
AVG_TEMP_GE_10 |
|
NUMBER(22, 3) |
|
|
|
SOIL-datasets
SOIL_MAP_UNITS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
SNUM |
NOT NULL |
NUMBER(22, 8) |
|
|
|
SOIL_TYPES
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
SOIL_TYPE_ID |
NOT NULL |
NUMBER(22) |
|
|
SNUM |
NOT NULL |
NUMBER(22) |
|
|
WATER_HOLDING_CAPACITY |
NOT NULL |
NUMBER(22) |
|
|
MAXIMUM_ROOTING_DEPTH_MM |
NOT NULL |
NUMBER(22) |
|
|
PERCENTAGE_AREA |
NOT NULL |
NUMBER(22) |
|
|
SOIL_TYPE |
NOT NULL |
VARCHAR2(31) |
|
|
|
UNITS-datasets
UNITS_CALC_INPUT
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
SNUM |
NOT NULL |
NUMBER(22) |
|
|
|
UNITS_CALC_OUTPUT
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
ACTUAL_CALENDAR_ID |
NOT NULL |
NUMBER(22) |
|
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
WSI_P25 |
NOT NULL |
NUMBER(22) |
|
|
WSI_P50 |
NOT NULL |
NUMBER(22) |
|
|
WSI_P75 |
NOT NULL |
NUMBER(22) |
|
|
WSI_SUFF |
NOT NULL |
NUMBER(22) |
|
|
PROGRESS_INDEX |
|
NUMBER(22) |
|
|
CR |
NOT NULL |
NUMBER(22) |
|
|
CR_CUM |
NOT NULL |
NUMBER(22) |
|
|
ETA |
NOT NULL |
NUMBER(22) |
|
|
ETA_CUM |
NOT NULL |
NUMBER(22) |
|
|
WD |
NOT NULL |
NUMBER(22) |
|
|
WD_CUM |
NOT NULL |
NUMBER(22) |
|
|
WS |
NOT NULL |
NUMBER(22) |
|
|
WS_CUM |
NOT NULL |
NUMBER(22) |
|
|
WA |
|
NUMBER(22) |
|
|
|
UNITS_CALC_OUTPUT_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
ACTUAL_CALENDAR_LTA_ID |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
WSI_P25 |
NOT NULL |
NUMBER(22) |
|
|
WSI_P50 |
NOT NULL |
NUMBER(22) |
|
|
WSI_P75 |
NOT NULL |
NUMBER(22) |
|
|
WSI_SUFF |
NOT NULL |
NUMBER(22) |
|
|
PROGRESS_INDEX |
|
NUMBER(22) |
|
|
CR |
NOT NULL |
NUMBER(22) |
|
|
CR_CUM |
NOT NULL |
NUMBER(22) |
|
|
ETA |
NOT NULL |
NUMBER(22) |
|
|
ETA_CUM |
NOT NULL |
NUMBER(22) |
|
|
WD |
NOT NULL |
NUMBER(22) |
|
|
WD_CUM |
NOT NULL |
NUMBER(22) |
|
|
WS |
NOT NULL |
NUMBER(22) |
|
|
WS_CUM |
NOT NULL |
NUMBER(22) |
|
|
AGG_COUNT |
|
NUMBER(22) |
|
|
WA |
|
NUMBER(22) |
|
|
|
UNITS_CALC_STATUS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
SEASON_NO |
NOT NULL |
NUMBER(22) |
|
|
SUB_SEASON |
|
VARCHAR2(1) |
|
|
PLANTING_STATUS |
NOT NULL |
NUMBER(22) |
|
|
STATUS_AGE |
|
NUMBER(22) |
|
|
YEAR_OF_ENTRY |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR_OF_ENTRY |
NOT NULL |
NUMBER(22) |
|
|
|
UNITS_CALC_STATUS_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
UNIT_CALC_INPUT_ID |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
SEASON_NO |
NOT NULL |
NUMBER(22) |
|
|
PLANTING_STATUS |
NOT NULL |
NUMBER(22) |
|
|
STATUS_AGE |
|
NUMBER(22) |
|
|
AGG_COUNT |
|
NUMBER(22) |
|
|
|
other datasets
CROPS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
NAME_UK |
NOT NULL |
VARCHAR2(255) |
|
|
MAXIMUM_ROOTING_DEPTH_MM |
NOT NULL |
NUMBER(22) |
|
|
YIELD_REDUCTION_FACTOR |
NOT NULL |
NUMBER(22) |
|
|
CROP_PHYS_TYPE |
NOT NULL |
VARCHAR2(2) |
|
|
|
DAY_DECADEYEAR
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: Table
- Remarks: none
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
DAY |
NOT NULL |
DATE |
|
|
DECADE |
NOT NULL |
NUMBER(22, 2) |
|
|
YEAR |
NOT NULL |
NUMBER(22, 4) |
- |
|
|
GRID
- Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
- Use: input/reference table for both level 1 and level 2
- Type: Table
- Remarks: user defined, derived from GIS, provides the link to the GIS
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22) |
|
|
XCENTRE |
|
NUMBER(22) |
|
|
YCENTRE |
|
NUMBER(22) |
|
|
HAS_LAND |
|
VARCHAR2(1) |
|
|
SELECTED |
|
VARCHAR2(1) |
|
|
* Not a simple average (see 'Similarity score' in paragraph Qualification of weather stations).
|
MAX_FAO
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
GRID_ID |
NOT NULL |
NUMBER(22, 10) |
|
|
MAX_FAO |
|
NUMBER(22, 4) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22, 2) |
|
|
|
REGIONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
REG_ID |
NOT NULL |
NUMBER(22) |
|
|
REG_CODE |
NOT NULL |
VARCHAR2(10) |
|
|
REG_NAME |
NOT NULL |
VARCHAR2(250) |
|
|
REG_LEVEL |
NOT NULL |
NUMBER(22) |
|
|
AREA_M2 |
NOT NULL |
NUMBER(22) |
|
|
REG_MAP_ID |
NOT NULL |
NUMBER(22) |
|
|
REG_MAP_ID_BT |
NOT NULL |
NUMBER(22) |
|
|
|
SYSTABLES
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
TABLE_NAME |
NOT NULL |
VARCHAR2(31) |
- |
|
HIGHEST_ID |
|
NUMBER(22) |
- |
|
|
TASKS
- Description:
- Use:
- Type: Table
- Remarks:
Structure
|
Attribute |
Constraint |
Type |
Unit |
Comment
|
TASK_ID |
NOT NULL |
NUMBER(22) |
- |
|
YEAR |
NOT NULL |
NUMBER(22) |
|
|
DEKAD_IN_YEAR |
NOT NULL |
NUMBER(22) |
|
|
CROP_ID |
NOT NULL |
NUMBER(22) |
|
|
STATUS_INDICATORS |
NOT NULL |
NUMBER(22) |
|
|
|
synonyms
DATELIST
- Description:
- Use:
- Type: Synonym ➞ DATELIST@_WSIMAN
- Remarks:
REGION_INFO
- Description:
- Use:
- Type: Synonym ➞ REGION@INFO_WSIMAN
- Remarks:
REGION_MAPPINGS
- Description: regions and their relations (mappings)
- Use: used by many object to find relation between regions of different levels.
- Type: Synonym ➞ REGION@MAPPINGS_WSIMAN
- Remarks: none
* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.
REGLISTS
- Description: synonym to oracle package
- Use: link to REGLISTS
- Type: Synonym ➞ REGLISTS@_WSIMAN
- Remarks: none