Difference between revisions of "Appendix 5: Database objects/GWSI E 12"

ACTUAL-datasets

ACTUAL_CALENDARS

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

ACTUAL_CALENDARS_LTA

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

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

CROP_COEFFICIENTS

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

CROP_TEMP_COEFFICIENTS

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

GRID-datasets

GRID_CLIMATE_SEASONS

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

GRID_CLIMATE_SEASONS_CROP_MASK

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

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:

GRID_CUMETA_DUR1

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

GRID_CUMETA_LTA

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

GRID_CUMETA_LTA_ADJ

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

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:

GRID_FULL

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

GRID_FULLXUNITS

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

GRID_FULLXUNITS_JOINOPT

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

GRID_INI_SEASONS

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

GRID_REGION_LANDCOVERS

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

GRID_THRESHOLDS_1

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

GRID_THRESHOLDS_2

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

GRID_THRESHOLDS_3

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

GRID_WEATHER_MODEL_10

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

GRID_WEATHER_MODEL_10_LTA

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

REGION-datasets

REGION_WEATHER_MODEL_10

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

REGION_WEATHER_MODEL_10_LTA

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

SOIL-datasets

SOIL_MAP_UNITS

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

SOIL_TYPES

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

UNITS-datasets

UNITS_CALC_INPUT

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

UNITS_CALC_OUTPUT

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

UNITS_CALC_OUTPUT_LTA

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

UNITS_CALC_STATUS

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

UNITS_CALC_STATUS_LTA

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

other datasets

CROPS

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

DAY_DECADEYEAR

• Description: synonym to oracle package
• Use: view on DATE_GENERATOR package
• Type: Table
• Remarks: none

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

MAX_FAO

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

REGIONS

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

SYSTABLES

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

TASKS

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

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