Appendix 5: Database objects/CGMS14SYS

From Agri4castWiki
Jump to: navigation, search



content
1. REGION-datasets
2. SUPIT-datasets
3. 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:


SUPIT-datasets

content
2.1 SUPIT_CONSTANTS
2.2 SUPIT_REFERENCE_STATIONS




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)


SUPIT_REFERENCE_STATIONS

  • Description: contains calculated regression constants for selected weather stations covering a large part of Europe.
  • Use: used by SupitConstants to derive the regression constants for all weather stations (and listed in the weather_station table).
  • Type: View
  • Remarks: not normally changed by the user but supplied by the JRC


other datasets

content
3.1 CATEGORIES
3.2 COVERS
3.3 COVER_SOURCES
3.4 CROPS
3.5 CROP_PARAMETERS
3.6 GRIDS
3.7 GRIDS_TEMP
3.8 GRID_SOURCES
3.9 LINK_COVER_WINDOW_SOURCE
3.10 MODELS
3.11 REGIONS
3.12 SOIL_SOURCES
3.13 STATIONS
3.14 STATION_REFERENCE_COEFFICIENTS
3.15 STATISTIC_SOURCES
3.16 SUITABILITY_PROPERTIES
3.17 THRESHOLDS
3.18 TIME_DIMENSIONS
3.19 TREATMENTS
3.20 WEATHER_STATION
3.21 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:


GRIDS_TEMP

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


THRESHOLDS

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


TIME_DIMENSIONS

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


TREATMENTS

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


WEATHER_STATION

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: View
  • Remarks:


WINDOWS

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