Appendix 5: Database objects/CGMS14SYS

From Agri4castWiki
Revision as of 22:02, 28 January 2016 by Wimdewinter (talk | contribs) (generated page)
Jump to: navigation, search





content
1. REGION-datasets
2. other datasets




REGION-datasets

content
1.1 REGION_ELEMENTS
1.2 REGION_SOURCES




REGION_ELEMENTS

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


REGION_SOURCES

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


other datasets

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




CATEGORIES

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


COVERS

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


COVER_SOURCES

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


CROPS

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


CROP_PARAMETERS

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


GRIDS

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


GRID_SOURCES

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


LINK_COVER_WINDOW_SOURCE

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


MODELS

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


REGIONS

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


SOIL_SOURCES

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


STATIONS

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


STATION_REFERENCE_COEFFICIENTS

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


STATISTIC_SOURCES

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


SUITABILITY_PROPERTIES

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


SUPIT_CONSTANTS

  • 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: 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

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


TIME_DIMENSIONS

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


TREATMENTS

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


WINDOWS

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