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

From Agri4castWiki
Jump to: navigation, search
(generated page)
 
(generated page)
Line 1: Line 1:
  
 +
 +
{{expert}}
 
__NOTOC__
 
__NOTOC__
 
{{TocTable|content=
 
{{TocTable|content=
Line 5: Line 7:
 
{{TocRow|#other datasets|2. other datasets}}
 
{{TocRow|#other datasets|2. other datasets}}
 
}}
 
}}
 +
 +
  
  
Line 12: Line 16:
 
{{TocRow|#REGION_SOURCES|1.2 REGION_SOURCES}}
 
{{TocRow|#REGION_SOURCES|1.2 REGION_SOURCES}}
 
}}
 
}}
 +
 +
  
  
Line 45: Line 51:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 69: Line 77:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== other datasets ==
 
== other datasets ==
Line 74: Line 84:
 
{{TocRow|#CATEGORIES|2.1 CATEGORIES}}
 
{{TocRow|#CATEGORIES|2.1 CATEGORIES}}
 
{{TocRow|#COVERS|2.2 COVERS}}
 
{{TocRow|#COVERS|2.2 COVERS}}
{{TocRow|#CROPS|2.3 CROPS}}
+
{{TocRow|#COVER_SOURCES|2.3 COVER_SOURCES}}
{{TocRow|#GRIDS|2.4 GRIDS}}
+
{{TocRow|#CROPS|2.4 CROPS}}
{{TocRow|#MODELS|2.5 MODELS}}
+
{{TocRow|#CROP_PARAMETERS|2.5 CROP_PARAMETERS}}
{{TocRow|#REGIONS|2.6 REGIONS}}
+
{{TocRow|#GRIDS|2.6 GRIDS}}
{{TocRow|#STATIONS|2.7 STATIONS}}
+
{{TocRow|#GRID_SOURCES|2.7 GRID_SOURCES}}
{{TocRow|#THRESHOLDS|2.8 THRESHOLDS}}
+
{{TocRow|#LINK_COVER_WINDOW_SOURCE|2.8 LINK_COVER_WINDOW_SOURCE}}
{{TocRow|#TREATMENTS|2.9 TREATMENTS}}
+
{{TocRow|#MODELS|2.9 MODELS}}
{{TocRow|#WINDOWS|2.10 WINDOWS}}
+
{{TocRow|#REGIONS|2.10 REGIONS}}
{{TocRow|#COVER_SOURCES|2.11 COVER_SOURCES}}
+
{{TocRow|#SOIL_SOURCES|2.11 SOIL_SOURCES}}
{{TocRow|#CROP_PARAMETERS|2.12 CROP_PARAMETERS}}
+
{{TocRow|#STATIONS|2.12 STATIONS}}
{{TocRow|#GRID_SOURCES|2.13 GRID_SOURCES}}
+
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|2.13 STATION_REFERENCE_COEFFICIENTS}}
{{TocRow|#LINK_COVER_WINDOW_SOURCE|2.14 LINK_COVER_WINDOW_SOURCE}}
+
{{TocRow|#STATISTIC_SOURCES|2.14 STATISTIC_SOURCES}}
{{TocRow|#SOIL_SOURCES|2.15 SOIL_SOURCES}}
+
{{TocRow|#SUITABILITY_PROPERTIES|2.15 SUITABILITY_PROPERTIES}}
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|2.16 STATION_REFERENCE_COEFFICIENTS}}
+
{{TocRow|#SUPIT_CONSTANTS|2.16 SUPIT_CONSTANTS}}
{{TocRow|#STATISTIC_SOURCES|2.17 STATISTIC_SOURCES}}
+
{{TocRow|#THRESHOLDS|2.17 THRESHOLDS}}
{{TocRow|#SUITABILITY_PROPERTIES|2.18 SUITABILITY_PROPERTIES}}
+
{{TocRow|#TIME_DIMENSIONS|2.18 TIME_DIMENSIONS}}
{{TocRow|#SUPIT_CONSTANTS|2.19 SUPIT_CONSTANTS}}
+
{{TocRow|#TREATMENTS|2.19 TREATMENTS}}
{{TocRow|#TIME_DIMENSIONS|2.20 TIME_DIMENSIONS}}
+
{{TocRow|#WINDOWS|2.20 WINDOWS}}
 
}}
 
}}
 +
 +
  
  
Line 116: Line 128:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 138: Line 152:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 162: Line 178:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 186: Line 204:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 212: Line 232:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 254: Line 276:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 284: Line 308:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 306: Line 332:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 328: Line 356:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 356: Line 386:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 378: Line 410:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 448: Line 482:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 487: Line 523:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 509: Line 547:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 531: Line 571:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 566: Line 608:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 596: Line 640:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 630: Line 676:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 652: Line 700:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->

Revision as of 21:27, 28 January 2016





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

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.