Appendix 5: Database objects/CGMS14SYS

From Agri4castWiki
Revision as of 17:02, 28 January 2016 by Wimdewinter (talk | contribs) (generated page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


content
1. REGION-datasets
2. other datasets



REGION-datasets

content
1.1 REGION_ELEMENTS
1.2 REGION_SOURCES



REGION_ELEMENTS

Table.

REGION_SOURCES

Table.

other datasets

content
2.1 CATEGORIES
2.2 COVERS
2.3 CROPS
2.4 GRIDS
2.5 MODELS
2.6 REGIONS
2.7 STATIONS
2.8 THRESHOLDS
2.9 TREATMENTS
2.10 WINDOWS
2.11 COVER_SOURCES
2.12 CROP_PARAMETERS
2.13 GRID_SOURCES
2.14 LINK_COVER_WINDOW_SOURCE
2.15 SOIL_SOURCES
2.16 STATION_REFERENCE_COEFFICIENTS
2.17 STATISTIC_SOURCES
2.18 SUITABILITY_PROPERTIES
2.19 SUPIT_CONSTANTS
2.20 TIME_DIMENSIONS



CATEGORIES

Table.

COVERS

Table.

COVER_SOURCES

Table.

CROPS

Table.

CROP_PARAMETERS

Table.

GRIDS

Table.

GRID_SOURCES

Table.

LINK_COVER_WINDOW_SOURCE

Table.

MODELS

Table.

REGIONS

Table.

SOIL_SOURCES

Table.

STATIONS

Table.

STATION_REFERENCE_COEFFICIENTS

Table.

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe
  • Use: is used by view SUPIT_REFERENCE_STATIONS
  • Type: permanent table
  • Remarks: none

STATISTIC_SOURCES

Table.

SUITABILITY_PROPERTIES

Table.

SUPIT_CONSTANTS

Table.

  • Description: the regression constants per weather station used for the estimation of global radiation for the station
  • Use: support table program SupitConstant; results are copied to table STATION
  • Type: permanent table
  • Remarks: populated by program SupitConstant (recalculate this table when new stations are added to the weather_station table or when table new supit_reference_stations is updated table)

THRESHOLDS

Table.

TIME_DIMENSIONS

Table.

TREATMENTS

Table.

WINDOWS

Table.