Difference between revisions of "Appendix 5: Database objects/CGMS14SYS"

From Agri4castWiki
Jump to: navigation, search
(generated page)
(generated page)
Line 22: Line 22:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_ELEMENTS ===
 
=== REGION_ELEMENTS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 56: Line 58:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_SOURCES ===
 
=== REGION_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 109: Line 113:
 
<!-- start -->
 
<!-- start -->
 
=== CATEGORIES ===
 
=== CATEGORIES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 133: Line 139:
 
<!-- start -->
 
<!-- start -->
 
=== COVERS ===
 
=== COVERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 157: Line 165:
 
<!-- start -->
 
<!-- start -->
 
=== COVER_SOURCES ===
 
=== COVER_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 183: Line 193:
 
<!-- start -->
 
<!-- start -->
 
=== CROPS ===
 
=== CROPS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 209: Line 221:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_PARAMETERS ===
 
=== CROP_PARAMETERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 237: Line 251:
 
<!-- start -->
 
<!-- start -->
 
=== GRIDS ===
 
=== GRIDS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 281: Line 297:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_SOURCES ===
 
=== GRID_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 313: Line 331:
 
<!-- start -->
 
<!-- start -->
 
=== LINK_COVER_WINDOW_SOURCE ===
 
=== LINK_COVER_WINDOW_SOURCE ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 337: Line 357:
 
<!-- start -->
 
<!-- start -->
 
=== MODELS ===
 
=== MODELS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 361: Line 383:
 
<!-- start -->
 
<!-- start -->
 
=== REGIONS ===
 
=== REGIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 391: Line 415:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_SOURCES ===
 
=== SOIL_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 415: Line 441:
 
<!-- start -->
 
<!-- start -->
 
=== STATIONS ===
 
=== STATIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 487: Line 515:
 
<!-- start -->
 
<!-- start -->
 
=== STATION_REFERENCE_COEFFICIENTS ===
 
=== STATION_REFERENCE_COEFFICIENTS ===
''Table''.
+
* Description: contains calculated regression constants for selected weather stations covering a large part of Europe
*Description: contains calculated regression constants for selected weather stations covering a large part of Europe
+
* Use: is used by view SUPIT_REFERENCE_STATIONS
*Use: is used by view SUPIT_REFERENCE_STATIONS
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 528: Line 555:
 
<!-- start -->
 
<!-- start -->
 
=== STATISTIC_SOURCES ===
 
=== STATISTIC_SOURCES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 552: Line 581:
 
<!-- start -->
 
<!-- start -->
 
=== SUITABILITY_PROPERTIES ===
 
=== SUITABILITY_PROPERTIES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 576: Line 607:
 
<!-- start -->
 
<!-- start -->
 
=== SUPIT_CONSTANTS ===
 
=== SUPIT_CONSTANTS ===
''Table''.
+
* Description: the regression constants per weather station used for the estimation of global radiation for the station
*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
*Use: support table program SupitConstant; results are copied to table STATION
+
* Type: ''Table''
*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)
*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)
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 613: Line 643:
 
<!-- start -->
 
<!-- start -->
 
=== THRESHOLDS ===
 
=== THRESHOLDS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 645: Line 677:
 
<!-- start -->
 
<!-- start -->
 
=== TIME_DIMENSIONS ===
 
=== TIME_DIMENSIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 681: Line 715:
 
<!-- start -->
 
<!-- start -->
 
=== TREATMENTS ===
 
=== TREATMENTS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 705: Line 741:
 
<!-- start -->
 
<!-- start -->
 
=== WINDOWS ===
 
=== WINDOWS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure

Revision as of 22:02, 28 January 2016





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: