Appendix 5: Database objects/GWSI E 12

From Agri4castWiki
Jump to: navigation, search





content
1. ACTUAL-datasets
2. CROP-datasets
3. GRID-datasets
4. REGION-datasets
5. SOIL-datasets
6. UNITS-datasets
7. other datasets
8. synonyms




ACTUAL-datasets

content
1.1 ACTUAL_CALENDARS
1.2 ACTUAL_CALENDARS_LTA




ACTUAL_CALENDARS

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


ACTUAL_CALENDARS_LTA

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


CROP-datasets

content
2.1 CROP_CALENDARS
2.2 CROP_COEFFICIENTS
2.3 CROP_TEMP_COEFFICIENTS




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

content
3.1 GRID_CLIMATE_SEASONS
3.2 GRID_CLIMATE_SEASONS_CROP_MASK
3.3 GRID_CROPMASKS
3.4 GRID_CUMETA_DUR1
3.5 GRID_CUMETA_LTA
3.6 GRID_CUMETA_LTA_ADJ
3.7 GRID_CUMETA_TIMESERIES
3.8 GRID_FULL
3.9 GRID_FULLXUNITS
3.10 GRID_FULLXUNITS_JOINOPT
3.11 GRID_INI_SEASONS
3.12 GRID_REGION_LANDCOVERS
3.13 GRID_THRESHOLDS_1
3.14 GRID_THRESHOLDS_2
3.15 GRID_THRESHOLDS_3
3.16 GRID_WEATHER_MODEL_10
3.17 GRID_WEATHER_MODEL_10_LTA




GRID_CLIMATE_SEASONS

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


GRID_CLIMATE_SEASONS_CROP_MASK

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


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:


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

content
4.1 REGION_WEATHER_MODEL_10
4.2 REGION_WEATHER_MODEL_10_LTA




REGION_WEATHER_MODEL_10

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


REGION_WEATHER_MODEL_10_LTA

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


SOIL-datasets

content
5.1 SOIL_MAP_UNITS
5.2 SOIL_TYPES




SOIL_MAP_UNITS

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


SOIL_TYPES

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


UNITS-datasets

content
6.1 UNITS_CALC_INPUT
6.2 UNITS_CALC_OUTPUT
6.3 UNITS_CALC_OUTPUT_LTA
6.4 UNITS_CALC_STATUS
6.5 UNITS_CALC_STATUS_LTA




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

content
7.1 CROPS
7.2 DAY_DECADEYEAR
7.3 GRID
7.4 MAX_FAO
7.5 REGIONS
7.6 SYSTABLES
7.7 TASKS




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

content
8.1 DATELIST
8.2 REGION_INFO
8.3 REGION_MAPPINGS
8.4 REGLISTS




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