Appendix 5: Database objects/CGMS14xxx

From Agri4castWiki
Revision as of 16:41, 28 January 2016 by Wimdewinter (talk | contribs) (SOIL-datasets)
Jump to: navigation, search

CROP-datasets

CROP_AGGREGATIONS

Table.

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:

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_CALENDARS_OLD

Table.

CROP_PARAMETRIZATIONS

Table.

CROP_PARAMETRIZATION_PARAMETER

Table.

CROP_REGIMES

Table.

CROP_SPATIALIZATIONS

Table.

CROP_SUITABILITY_RULES

Table.

CROP_VARIETIES

Table.

CROP_VARIETY_PARAMETERS

Table.

CROP_VARIETY_PARAMETERS_OLD

Table.

CROP_VARIETY_REGIMES

Table.

GLOBAL-datasets

GLOBAL_CATEGORIES

Table.

GLOBAL_COVERS

View.

GLOBAL_COVER_SOURCES

View.

GLOBAL_CROPS

View.

GLOBAL_CROP_PARAMETERS

Table.

GLOBAL_GRIDS

View.

GLOBAL_GRID_SOURCES

View.

GLOBAL_LINK_COVERWINDOW_SOURCE

View.

GLOBAL_MODELS

View.

GLOBAL_REGIONS

View.

GLOBAL_REGION_ELEMENTS

View.

GLOBAL_REGION_SOURCES

View.

GLOBAL_SOIL_SOURCES

View.

GLOBAL_STATISTIC_SOURCES

View.

GLOBAL_SUITABILITY_PROPERTIES

View.

GLOBAL_THRESHOLDS

View.

GLOBAL_TIME_DIMENSIONS

View.

GLOBAL_TREATMENTS

View.

GLOBAL_WINDOWS

View.

LINK-datasets

LINK_CROP_AGGREGATION

View.

LINK_CROP_CALENDARS

View.

LINK_CROP_PARAMETERS

Table.

LINK_CROP_PARAMETERS_CROP

Table.

LINK_CROP_PARAMETERS_MODEL

Table.

LINK_CROP_PARAMETRIZATION

View.

LINK_CROP_SPATIALIZATIONS

View.

LINK_CROP_STU

Table.

LINK_CROP_VARIETY_PARAMETERS

View.

LINK_GRID_COVER

Table.

LINK_GRID_REGION_COVER

Table.

LINK_REGION_COVER

Table.

LINK_SIMULATION_UNIT

View.

LINK_SIMULATION_UNIT_CROP

View.

LINK_SMU_GRID_COVER

Table.

LINK_SMU_GRID_REGION_COVER

Table.

LINK_SMU_STU

Table.

LINK_STU_HORIZONS

Table.

LINK_STU_WEIGHTED_PARAMETERS

View.

LINK_SUITABILITY_RULES

View.

SIM-datasets

SIM_BLAST_HRES_GRID

Table.

SIM_BLAST_HRES_GRID_LTA

Table.

SIM_BLAST_HRES_REGION

Table.

SIM_BLAST_HRES_REGION_LTA

Table.

SIM_WARM_HRES_GRID

Table.

SIM_WARM_HRES_GRID_LTA

Table.

SIM_WARM_HRES_REGION

Table.

SIM_WARM_HRES_REGION_LTA

Table.

SIM_WOFOST_HRES_EMU

Table.

SIM_WOFOST_HRES_EMU_LTA

Table.

SIM_WOFOST_HRES_GRID

Table.

SIM_WOFOST_HRES_GRID_LTA

Table.

SIM_WOFOST_HRES_REGION

Table.

SIM_WOFOST_HRES_REGION_LTA

Table.

SIM_WOFOST_HRES_STU

Table.

SOIL-datasets

content


SOIL_HORIZONS

Table.

SOIL_INITIAL_WATER

Table.

SOIL_SMU

Table.

SOIL_STU

Table.

WEATHER-datasets

WEATHER_ERA_GRID

Table.

WEATHER_ERA_GRID_LTA

Table.

WEATHER_ERA_REGIONCOVER

Table.

WEATHER_ERA_REGIONCOVER_LTA

Table.

WEATHER_HIS_GRID

Table.

WEATHER_HIS_REGIONCOVER

Table.

WEATHER_HRES_GRID

View.

WEATHER_HRES_REGIONCOVER

View.

WEATHER_OBS_GRID

Table.

  • Description: interpolated weather data per grid per day
  • Use: output for level 1, input for level 2
  • Type: Permanent table

WEATHER_OBS_GRID_INFO

Table.

  • Description:
  • Use:
  • Type: Permanent table

WEATHER_OBS_GRID_LTA

Table.

  • Description: long term average interpolated weather data per grid cell per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table

WEATHER_OBS_GRID_LTA_MISS

Table.

  • Description: long term average number of grid cells per country.
  • Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
  • Type: permanent table
  • Remarks: filled with procedure lta_missing_grid_weather.sql

WEATHER_OBS_REGCOV_LTA_THRSHLD

Table.

WEATHER_OBS_REGCOV_THRESHOLDS

Table.

WEATHER_OBS_REGIONCOVER

Table.

  • Description: interpolated weather data per grid per administrative region
  • Use: input for monitoring extreme weather events
  • Type: Permanent table

WEATHER_OBS_REGIONCOVER_LTA

Table.

  • Description: long term average interpolated weather data per administrative region per day
  • Use: Monitoring extreme weather events
  • Type: Permanent table

WEATHER_OBS_STATION

Table.

  • Description: contains the station based daily meteorological data
  • Use: input for level 1
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_AVAIL

Table.

  • Description: available weather stations for interpolation per station and per year.
  • Use: output of the weather data availability calculation, used by the grid weather interpolation
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_CALCULATED

Table.

  • Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
  • Use: output table for additional weather calculation, input for grid weather
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_ERRAIN

Table.

  • Description: contains deleted wrongly rain records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_ERRORS

Table.

  • Description: contains deleted wrongly weather records of the station based daily meteorological data
  • Use: archive reasons
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_INFO

Table.

  • Description: table for storing specific metadata on daily weather data (flags)
  • Use: meta data
  • Type: permanent table
  • Remarks: none

WEATHER_OBS_STATION_LTA

Table.

  • Description: contains the long term average weather data per station per day
  • Use: substitute data in case of missing data during level 1 processing
  • Type: permanent table
  • Remarks: filled by software tool ReferenceWeather

WEATHER_OBS_STATION_RAW

Table.

  • Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: permanent table
  • Remarks: none

WEATHER_OPE_GRID

Table.

WEATHER_OPE_REGIONCOVER

Table.

other datasets

CGMS_SYSLOG

Table.

  • Description: logging of run options.
  • Use: output table containing information on the run executed
  • Type: Permanent table
  • Remarks: none

DATES_75_15

Table.

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.dates_75_15
  • Remarks: none

GRIDS

View.

HRES_YEARS

View.

INTERPOLATION_PARAMETERS

Table.

REGIONS

View.

STATIONS

View.

STAT_REGION_AREAS

Table.

SYSTABLES

Table.

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

TASKS

Table.

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

WOG

Table.

  • Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
  • Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
  • Type: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

WOSC

Table.