Appendix 5: Database objects/GWSI E 12

From Agri4castWiki
Revision as of 18:03, 28 January 2016 by Wimdewinter (talk | contribs) (generated page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Table.

ACTUAL_CALENDARS_LTA

Table.

CROP-datasets

content
2.1 CROP_CALENDARS
2.2 CROP_COEFFICIENTS
2.3 CROP_TEMP_COEFFICIENTS



CROP_CALENDARS

Table.

  • 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

CROP_COEFFICIENTS

Table.

CROP_TEMP_COEFFICIENTS

Table.

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

Table.

GRID_CLIMATE_SEASONS_CROP_MASK

View.

GRID_CROPMASKS

Table.

GRID_CUMETA_DUR1

Table.

GRID_CUMETA_LTA

Table.

GRID_CUMETA_LTA_ADJ

View.

GRID_CUMETA_TIMESERIES

Table.

GRID_FULL

Table.

GRID_FULLXUNITS

Table.

GRID_FULLXUNITS_JOINOPT

Table.

GRID_INI_SEASONS

Table.

GRID_REGION_LANDCOVERS

Table.

GRID_THRESHOLDS_1

Table.

GRID_THRESHOLDS_2

Table.

GRID_THRESHOLDS_3

Table.

GRID_WEATHER_MODEL_10

Table.

GRID_WEATHER_MODEL_10_LTA

Table.

REGION-datasets

content
4.1 REGION_WEATHER_MODEL_10
4.2 REGION_WEATHER_MODEL_10_LTA



REGION_WEATHER_MODEL_10

Table.

REGION_WEATHER_MODEL_10_LTA

Table.

SOIL-datasets

content
5.1 SOIL_MAP_UNITS
5.2 SOIL_TYPES



SOIL_MAP_UNITS

Table.

SOIL_TYPES

Table.

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

Table.

UNITS_CALC_OUTPUT

Table.

UNITS_CALC_OUTPUT_LTA

Table.

UNITS_CALC_STATUS

Table.

UNITS_CALC_STATUS_LTA

Table.

other datasets

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



CROPS

Table.

DAY_DECADEYEAR

Table.

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on FORALL.DAY_DECADEYEAR
  • Remarks: none

GRID

Table.

  • 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: permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS

MAX_FAO

Table.

REGIONS

Table.

SYSTABLES

Table.

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:

TASKS

Table.

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:

synonyms

content
8.1 DATELIST
8.2 REGION_INFO
8.3 REGION_MAPPINGS
8.4 REGLISTS



DATELIST

Synonym ➞ DATELIST@_WSIMAN.


REGION_INFO

Synonym ➞ REGION@INFO_WSIMAN.


REGION_MAPPINGS

Synonym ➞ REGION@MAPPINGS_WSIMAN.

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: synonyms on forall.region_mappings_eur
  • Remarks: none

* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.

REGLISTS

Synonym ➞ REGLISTS@_WSIMAN.

  • Description: synonym to oracle package
  • Use: link to REGLISTS
  • Type: synonym on forall.reglists
  • Remarks: none