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

From Agri4castWiki
Jump to: navigation, search
(generated page)
 
Line 1: Line 1:
 
 
 
{{expert}}
 
{{expert}}
 
__NOTOC__
 
__NOTOC__
 
{{TocTable|content=
 
{{TocTable|content=
 
{{TocRow|#REGION-datasets|1. REGION-datasets}}
 
{{TocRow|#REGION-datasets|1. REGION-datasets}}
{{TocRow|#other datasets|2. other datasets}}
+
{{TocRow|#SUPIT-datasets|2. SUPIT-datasets}}
 +
{{TocRow|#other datasets|3. other datasets}}
 
}}
 
}}
  
Line 33: Line 32:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_ELEMENT || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| NAME || || VARCHAR2(255) ||  ||  
+
| NAME || True || VARCHAR2 ||  ||  
 
|-
 
|-
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  ||  
+
| REGION_LEVEL || False || NUMBER ||  ||  
 
|-
 
|-
| IDFATHER || || NUMBER(22, 12) ||  ||  
+
| IDFATHER || True || NUMBER ||  ||  
 
|-
 
|-
| STANDARD || NOT NULL || VARCHAR2(20) ||  ||  
+
| STANDARD || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 69: Line 68:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDREGION_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
  
 +
|}
 +
<!-- end -->
 +
 +
 +
 +
== SUPIT-datasets ==
 +
{{TocTable|content=
 +
{{TocRow|#SUPIT_CONSTANTS|2.1 SUPIT_CONSTANTS}}
 +
{{TocRow|#SUPIT_REFERENCE_STATIONS|2.2 SUPIT_REFERENCE_STATIONS}}
 +
}}
 +
 +
 +
 +
 +
<!-- start -->
 +
=== 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)
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| WMO_NO || False || NUMBER || - || station number
 +
|-
 +
| ANGSTROM_A || True || NUMBER || ånström || constant A using sun shine duration
 +
|-
 +
| ANGSTROM_B || True || NUMBER || ånström || constant B using sun shine duration
 +
|-
 +
| SUPIT_A || True || NUMBER || - || supit constant A using cloud cover and temperature
 +
|-
 +
| SUPIT_B || True || NUMBER || - || supit constant B using cloud cover and temperature
 +
|-
 +
| SUPIT_C || True || NUMBER || kJ.m-2.d-1 || supit constant C using cloud cover and temperature
 +
|-
 +
| HARGREAVES_A || True || NUMBER || - || hargreaves constant A using temperature
 +
|-
 +
| HARGREAVES_B || True || NUMBER || kJ.m-2.d-1 || hargreaves constant B using temperature
 +
|-
 +
|}
 +
 +
|}
 +
<!-- end -->
 +
 +
 +
 +
<!-- start -->
 +
=== 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
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| STATION_NAME || True || CHAR || - || dummy name
 +
|-
 +
| LATITUDE || False || NUMBER || dd || latitude
 +
|-
 +
| LONGITUDE || False || NUMBER || dd || longitude
 +
|-
 +
| ALTITUDE || False || NUMBER || m || altitude
 +
|-
 +
| ANGSTROM_A || True || NUMBER || - || angstrom constant A using sun shine duration
 +
|-
 +
| ANGSTROM_B || True || NUMBER || - || angstrom constant B using sun shine duration
 +
|-
 +
| SUPIT_A || True || NUMBER || - || supit constant A using cloud cover and temperature
 +
|-
 +
| SUPIT_B || True || NUMBER || - || supit constant B using cloud cover and temperature
 +
|-
 +
| SUPIT_C || True || NUMBER || kJ.m-2.d-1 || supit constant C using cloud cover and temperature
 +
|-
 +
| HARGREAVES_A || True || NUMBER || - || hargreaves constant A using temperature
 +
|-
 +
| HARGREAVES_B || True || NUMBER || kJ.m-2.d-1 || hargreaves constant A using temperature
 +
|-
 +
|}
 +
 +
 +
'''definition:'''
 +
select
 +
    'dummy_name'  as station_name
 +
    , latitude
 +
    , longitude
 +
    , altitude
 +
    , angstrom_a
 +
    , angstrom_b
 +
    , supit_a
 +
    , supit_b
 +
    , supit_c
 +
    , hargreaves_a
 +
    , hargreaves_b
 +
from station_reference_coefficients
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 86: Line 187:
 
== other datasets ==
 
== other datasets ==
 
{{TocTable|content=
 
{{TocTable|content=
{{TocRow|#CATEGORIES|2.1 CATEGORIES}}
+
{{TocRow|#CATEGORIES|3.1 CATEGORIES}}
{{TocRow|#COVERS|2.2 COVERS}}
+
{{TocRow|#COVERS|3.2 COVERS}}
{{TocRow|#COVER_SOURCES|2.3 COVER_SOURCES}}
+
{{TocRow|#COVER_SOURCES|3.3 COVER_SOURCES}}
{{TocRow|#CROPS|2.4 CROPS}}
+
{{TocRow|#CROPS|3.4 CROPS}}
{{TocRow|#CROP_PARAMETERS|2.5 CROP_PARAMETERS}}
+
{{TocRow|#CROP_PARAMETERS|3.5 CROP_PARAMETERS}}
{{TocRow|#GRIDS|2.6 GRIDS}}
+
{{TocRow|#GRIDS|3.6 GRIDS}}
{{TocRow|#GRID_SOURCES|2.7 GRID_SOURCES}}
+
{{TocRow|#GRIDS_TEMP|3.7 GRIDS_TEMP}}
{{TocRow|#LINK_COVER_WINDOW_SOURCE|2.8 LINK_COVER_WINDOW_SOURCE}}
+
{{TocRow|#GRID_SOURCES|3.8 GRID_SOURCES}}
{{TocRow|#MODELS|2.9 MODELS}}
+
{{TocRow|#LINK_COVER_WINDOW_SOURCE|3.9 LINK_COVER_WINDOW_SOURCE}}
{{TocRow|#REGIONS|2.10 REGIONS}}
+
{{TocRow|#MODELS|3.10 MODELS}}
{{TocRow|#SOIL_SOURCES|2.11 SOIL_SOURCES}}
+
{{TocRow|#REGIONS|3.11 REGIONS}}
{{TocRow|#STATIONS|2.12 STATIONS}}
+
{{TocRow|#SOIL_SOURCES|3.12 SOIL_SOURCES}}
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|2.13 STATION_REFERENCE_COEFFICIENTS}}
+
{{TocRow|#STATIONS|3.13 STATIONS}}
{{TocRow|#STATISTIC_SOURCES|2.14 STATISTIC_SOURCES}}
+
{{TocRow|#STATION_REFERENCE_COEFFICIENTS|3.14 STATION_REFERENCE_COEFFICIENTS}}
{{TocRow|#SUITABILITY_PROPERTIES|2.15 SUITABILITY_PROPERTIES}}
+
{{TocRow|#STATISTIC_SOURCES|3.15 STATISTIC_SOURCES}}
{{TocRow|#SUPIT_CONSTANTS|2.16 SUPIT_CONSTANTS}}
+
{{TocRow|#SUITABILITY_PROPERTIES|3.16 SUITABILITY_PROPERTIES}}
{{TocRow|#THRESHOLDS|2.17 THRESHOLDS}}
+
{{TocRow|#THRESHOLDS|3.17 THRESHOLDS}}
{{TocRow|#TIME_DIMENSIONS|2.18 TIME_DIMENSIONS}}
+
{{TocRow|#TIME_DIMENSIONS|3.18 TIME_DIMENSIONS}}
{{TocRow|#TREATMENTS|2.19 TREATMENTS}}
+
{{TocRow|#TREATMENTS|3.19 TREATMENTS}}
{{TocRow|#WINDOWS|2.20 WINDOWS}}
+
{{TocRow|#WEATHER_STATION|3.20 WEATHER_STATION}}
 +
{{TocRow|#WINDOWS|3.21 WINDOWS}}
 
}}
 
}}
  
Line 124: Line 226:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  || category identifier
 
|-
 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  ||  
+
| CATEGORY || False || VARCHAR2 ||  || name
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  || description
 
|-
 
|-
 
|}
 
|}
Line 150: Line 252:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 176: Line 278:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| COVER_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 204: Line 306:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP || False || NUMBER ||  ||  
 
|-
 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  ||  
+
| CROP || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  ||  
+
| EUROSTAT || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 232: Line 334:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCROP_PARAMETER || False || NUMBER ||  ||  
 
|-
 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  ||  
+
| CROP_PARAMETER || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
| MULTI || NOT NULL || VARCHAR2(1) ||  ||  
+
| MULTI || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCATEGORY || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 262: Line 364:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID || False || NUMBER ||  ||  
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_16 || || NUMBER(22) ||  ||  
+
| ALTITUDE_16 || True || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE_25 || || NUMBER(22) ||  ||  
+
| ALTITUDE_25 || True || NUMBER ||  ||  
 
|-
 
|-
| X || NOT NULL || NUMBER(22) ||  ||  
+
| X || False || NUMBER ||  ||  
 
|-
 
|-
| Y || NOT NULL || NUMBER(22) ||  ||  
+
| Y || False || NUMBER ||  ||  
 
|-
 
|-
| DISTANCE_FROM_COAST || || NUMBER(22) ||  ||  
+
| DISTANCE_FROM_COAST || True || NUMBER ||  ||  
 
|-
 
|-
| CLIMATE_BARRIER || || NUMBER(22) ||  ||  
+
| CLIMATE_BARRIER || True || NUMBER ||  ||  
 
|-
 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  ||  
+
| HAS_LAND || False || VARCHAR2 ||  ||
 +
|-
 +
|}
 +
 
 +
|}
 +
<!-- end -->
 +
 
 +
 
 +
 
 +
<!-- start -->
 +
=== GRIDS_TEMP ===
 +
* Description:
 +
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 +
{|class="collapsing_table collapsible collapsed"
 +
!Structure
 +
|-
 +
|
 +
{|class="wikitable"
 +
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 +
|-
 +
| IDGRID || False || NUMBER ||  ||
 +
|-
 +
| IDGRID_SOURCE || False || NUMBER ||  ||
 +
|-
 +
| IDORIGINAL_CODE || False || VARCHAR2 ||  ||
 +
|-
 +
| LONGITUDE || False || NUMBER ||  ||
 +
|-
 +
| LATITUDE || False || NUMBER ||  ||
 +
|-
 +
| ALTITUDE || False || NUMBER ||  ||
 +
|-
 +
| ALTITUDE_16 || True || NUMBER ||  ||
 +
|-
 +
| ALTITUDE_25 || True || NUMBER ||  ||
 +
|-
 +
| X || False || NUMBER ||  ||
 +
|-
 +
| Y || False || NUMBER ||  ||
 +
|-
 +
| DISTANCE_FROM_COAST || True || NUMBER ||  ||
 +
|-
 +
| CLIMATE_BARRIER || True || NUMBER ||  ||
 +
|-
 +
| HAS_LAND || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 308: Line 456:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDGRID_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  ||  
+
| GRID_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  ||  
+
| RESOLUTION || False || NUMBER ||  ||  
 
|-
 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  ||  
+
| UNIT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTION || || VARCHAR2(255) ||  ||  
+
| DESCRIPTION || True || VARCHAR2 ||  ||  
 
|-
 
|-
| UNC || || VARCHAR2(255) ||  ||  
+
| UNC || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 342: Line 490:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER || False || NUMBER ||  ||  
 
|-
 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCOVER_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 368: Line 516:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDMODEL || False || NUMBER ||  ||  
 
|-
 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  ||  
+
| MODEL || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 394: Line 542:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| IDREGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDWINDOW || || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || True || NUMBER ||  ||  
 
|-
 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  ||  
+
| REGION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  ||  
+
| CONTINENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| POPULATION || || NUMBER(22) ||  ||  
+
| POPULATION || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 426: Line 574:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSOIL_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| SOIL_SOURCE || NOT NULL || VARCHAR2(30) ||  ||  
+
| SOIL_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 452: Line 600:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATION || False || NUMBER ||  ||  
 
|-
 
|-
| STATION || NOT NULL || VARCHAR2(32) ||  ||  
+
| STATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| ORGANIZATION || NOT NULL || VARCHAR2(32) ||  ||  
+
| ORGANIZATION || False || VARCHAR2 ||  ||  
 
|-
 
|-
| IDWMO || || NUMBER(22, 12) ||  ||  
+
| IDWMO || True || NUMBER ||  ||  
 
|-
 
|-
| WMO || || VARCHAR2(32) ||  ||  
+
| WMO || True || VARCHAR2 ||  ||  
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22, 7) ||  ||  
+
| LATITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22, 8) ||  ||  
+
| LONGITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| Y_COORDINATE || NOT NULL || NUMBER(22, 13) ||  ||  
+
| Y_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| X_COORDINATE || NOT NULL || NUMBER(22, 13) ||  ||  
+
| X_COORDINATE || False || NUMBER ||  ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22, 5) ||  ||  
+
| ALTITUDE || False || NUMBER ||  ||  
 
|-
 
|-
| IDCLIMATE_ZONE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDCLIMATE_ZONE || False || NUMBER ||  ||  
 
|-
 
|-
| COUNTRY || NOT NULL || VARCHAR2(26) ||  ||  
+
| COUNTRY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DISTANCE_TO_COAST || NOT NULL || NUMBER(22, 4) ||  ||  
+
| DISTANCE_TO_COAST || False || NUMBER ||  ||  
 
|-
 
|-
| ANGSTROM_A || NOT NULL || NUMBER(22, 18) ||  ||  
+
| ANGSTROM_A || False || NUMBER ||  ||  
 
|-
 
|-
| ANGSTROM_B || NOT NULL || NUMBER(22, 18) ||  ||  
+
| ANGSTROM_B || False || NUMBER ||  ||  
 
|-
 
|-
| SUPIT_A || NOT NULL || NUMBER(22, 18) ||  ||  
+
| SUPIT_A || False || NUMBER ||  ||  
 
|-
 
|-
| SUPIT_B || NOT NULL || NUMBER(22, 18) ||  ||  
+
| SUPIT_B || False || NUMBER ||  ||  
 
|-
 
|-
| SUPIT_C || NOT NULL || NUMBER(22, 18) ||  ||  
+
| SUPIT_C || False || NUMBER ||  ||  
 
|-
 
|-
| HARGREAVES_A || NOT NULL || NUMBER(22, 18) ||  ||  
+
| HARGREAVES_A || False || NUMBER ||  ||  
 
|-
 
|-
| HARGREAVES_B || NOT NULL || NUMBER(22, 18) ||  ||  
+
| HARGREAVES_B || False || NUMBER ||  ||  
 
|-
 
|-
| RELIABLE_STATIONS || NOT NULL || NUMBER(22, 1) ||  ||  
+
| RELIABLE_STATION || False || NUMBER ||  ||  
 
|-
 
|-
| ACTIVE_STATIONS || NOT NULL || NUMBER(22, 1) ||  ||  
+
| ACTIVE_STATION || False || NUMBER ||  ||  
 
|-
 
|-
| AVAIL_PRECIPITATION_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVAIL_PRECIPITATION_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| AVAIL_SNOWDEPTH_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVAIL_SNOWDEPTH_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| AVAIL_TEMPERATURE_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVAIL_TEMPERATURE_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| AVAIL_HUMIDITY_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVAIL_HUMIDITY_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
| AVAIL_REST_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  ||  
+
| AVAIL_REST_THRESHOLD || False || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 526: Line 674:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| LATITUDE || NOT NULL || NUMBER(22) || - ||  
+
| LATITUDE || False || NUMBER || - ||  
 
|-
 
|-
| LONGITUDE || NOT NULL || NUMBER(22) || - ||  
+
| LONGITUDE || False || NUMBER || - ||  
 
|-
 
|-
| ALTITUDE || NOT NULL || NUMBER(22) || - ||  
+
| ALTITUDE || False || NUMBER || - ||  
 
|-
 
|-
| ANGSTROM_A || || NUMBER(22) || - ||  
+
| ANGSTROM_A || True || NUMBER || - ||  
 
|-
 
|-
| ANGSTROM_B || || NUMBER(22) || - ||  
+
| ANGSTROM_B || True || NUMBER || - ||  
 
|-
 
|-
| SUPIT_A || || NUMBER(22) || - ||  
+
| SUPIT_A || True || NUMBER || - ||  
 
|-
 
|-
| SUPIT_B || || NUMBER(22) || - ||  
+
| SUPIT_B || True || NUMBER || - ||  
 
|-
 
|-
| SUPIT_C || || NUMBER(22) || - ||  
+
| SUPIT_C || True || NUMBER || - ||  
 
|-
 
|-
| HARGREAVES_A || || NUMBER(22) || - ||  
+
| HARGREAVES_A || True || NUMBER || - ||  
 
|-
 
|-
| HARGREAVES_B || || NUMBER(22) || - ||  
+
| HARGREAVES_B || True || NUMBER || - ||  
 
|-
 
|-
 
|}
 
|}
Line 566: Line 714:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSTATISTIC_SOURCE || False || NUMBER ||  ||  
 
|-
 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  ||  
+
| STATISTIC_SOURCE || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 592: Line 740:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDSUITABILITY_PROPERTY || False || NUMBER ||  ||  
 
|-
 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  ||  
+
| SUITABILITY_PROPERTY || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 606: Line 754:
  
 
<!-- start -->
 
<!-- start -->
=== SUPIT_CONSTANTS ===
+
=== THRESHOLDS ===
* Description: the regression constants per weather station used for the estimation of global radiation for the station
+
* Description:  
* Use: support table program SupitConstant; results are copied to table STATION
+
* Use:  
 
* Type: ''Table''
 
* 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)
+
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 618: Line 766:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| WMO_NO || NOT NULL || NUMBER(22, 7) || - || station number
+
| IDTHRESHOLD || False || NUMBER ||  ||  
|-
 
| ANGSTROM_A ||  || NUMBER(22) || - || ångström constant A using sun shine duration
 
 
|-
 
|-
| ANGSTROM_B || || NUMBER(22) || - || ångström constant B using sun shine duration
+
| IDWINDOW || False || NUMBER || ||  
 
|-
 
|-
| SUPIT_A || || NUMBER(22) || - || supit constant A using cloud cover and temperature
+
| THRESHOLD || False || VARCHAR2 || ||  
 
|-
 
|-
| SUPIT_B || || NUMBER(22) || - || supit constant B using cloud cover and temperature
+
| INDICATOR || False || VARCHAR2 || ||  
 
|-
 
|-
| SUPIT_C || || NUMBER(22) || KJ.m-2.d-1 || supit constant C using cloud cover and temperature
+
| OPERATOR || False || VARCHAR2 || ||  
 
|-
 
|-
| HARGREAVES_A || || NUMBER(22) || - || hargreaves constant A using temperature
+
| VALUE_MIN || False || NUMBER || ||  
 
|-
 
|-
| HARGREAVES_B || || NUMBER(22) || KJ.m-2.d-1 || hargreaves constant B using temperature
+
| VALUE_MAX || False || NUMBER || ||  
 
|-
 
|-
 
|}
 
|}
Line 642: Line 788:
  
 
<!-- start -->
 
<!-- start -->
=== THRESHOLDS ===
+
=== TIME_DIMENSIONS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 654: Line 800:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  ||  
+
| DAY || False || DATE ||  ||
 +
|-
 +
| DECADE || True || NUMBER ||  ||
 +
|-
 +
| DECADE_ID || True || NUMBER ||  ||  
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| MONTH || True || NUMBER ||  ||  
 
|-
 
|-
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  ||  
+
| MONTH_ID || True || NUMBER ||  ||  
 
|-
 
|-
| INDICATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| QUARTER || True || NUMBER ||  ||  
 
|-
 
|-
| OPERATOR || NOT NULL || VARCHAR2(30) ||  ||  
+
| QUARTER_ID || True || NUMBER ||  ||  
 
|-
 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  ||  
+
| YEAR || True || NUMBER ||  ||  
 
|-
 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  ||  
+
| LAST_DAY_DECADE || True || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 676: Line 826:
  
 
<!-- start -->
 
<!-- start -->
=== TIME_DIMENSIONS ===
+
=== TREATMENTS ===
 
* Description:  
 
* Description:  
 
* Use:  
 
* Use:  
Line 688: Line 838:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| DAY || NOT NULL || DATE ||  ||
+
| IDTREATMENT || False || NUMBER ||  ||  
|-
 
| DECADE ||  || NUMBER(22) ||  ||
 
|-
 
| DECADE_ID ||  || NUMBER(22) ||  ||
 
|-
 
| MONTH ||  || NUMBER(22) ||  ||
 
|-
 
| MONTH_ID ||  || NUMBER(22) ||  ||
 
|-
 
| QUARTER ||  || NUMBER(22) ||  ||
 
|-
 
| QUARTER_ID ||  || NUMBER(22) ||  ||  
 
 
|-
 
|-
| YEAR || || NUMBER(22) ||  ||  
+
| TREATMENT || False || VARCHAR2 ||  ||  
 
|-
 
|-
| LAST_DAY_DECADE || || VARCHAR2(1) ||  ||  
+
| DESCRIPTOR || False || VARCHAR2 ||  ||  
 
|-
 
|-
 
|}
 
|}
Line 714: Line 852:
  
 
<!-- start -->
 
<!-- start -->
=== TREATMENTS ===
+
=== WEATHER_STATION ===
 
* Description:  
 
* Description:  
* Use:  
+
* Use: interface between the CGMS12EU database and the [[SupitConstants]] software
* Type: ''Table''
+
* Type: ''View''
 
* Remarks:  
 
* Remarks:  
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
Line 726: Line 864:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) || ||  
+
| WMO_NO || False || NUMBER || - ||  
 +
|-
 +
| WMO_NAME || False || VARCHAR2 || - ||
 +
|-
 +
| LATITUDE || False || NUMBER || dd || latitude
 +
|-
 +
| LONGITUDE || False || NUMBER || dd || longitude
 +
|-
 +
| Y_COORDINATE || False || NUMBER || m ||
 +
|-
 +
| X_COORDINATE || False || NUMBER || m ||
 +
|-
 +
| ALTITUDE || False || NUMBER || m || altitude
 +
|-
 +
| CLIMATE_BARRIER_NO || False || NUMBER || - ||
 +
|-
 +
| COUNTRY_CODE || False || VARCHAR2 || - || country code
 +
|-
 +
| DISTANCE_TO_COAST || False || NUMBER || km || distance to coast
 
|-
 
|-
| TREATMENT || NOT NULL || VARCHAR2(60) || ||  
+
| PERCENT_COMPLETE || True || NUMBER || - ||  
 
|-
 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) || ||  
+
| RELIABLE_STATION || False || NUMBER || - ||  
 
|-
 
|-
 
|}
 
|}
  
 +
 +
'''definition:'''
 +
select
 +
      idstation
 +
    , station
 +
    , latitude
 +
    , longitude
 +
    , y_coordinate
 +
    , x_coordinate
 +
    , altitude
 +
    , idclimate_zone
 +
    , country
 +
    , distance_to_coast
 +
    , 80 as percent_complete
 +
    , reliable_station
 +
from stations
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 752: Line 924:
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
 
|-
 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  ||  
+
| IDWINDOW || False || NUMBER ||  ||  
 
|-
 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  ||  
+
| WINDOW || False || VARCHAR2 ||  ||  
 
|-
 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  ||  
+
| NAME || False || VARCHAR2 ||  ||  
 
|-
 
|-
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  ||  
+
| REFERENCE_SYSTEM || False || VARCHAR2 ||  ||  
 
|-
 
|-
| DESCRIPTOR || || VARCHAR2(255) ||  ||  
+
| DESCRIPTOR || True || VARCHAR2 ||  ||  
 
|-
 
|-
| MAX_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_LON || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_LON || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LAT || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_LAT || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_LON || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_LON || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_X || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_X || False || NUMBER ||  ||  
 
|-
 
|-
| MAX_Y || NOT NULL || NUMBER(22) ||  ||  
+
| MAX_Y || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_X || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_X || False || NUMBER ||  ||  
 
|-
 
|-
| MIN_Y || NOT NULL || NUMBER(22) ||  ||  
+
| MIN_Y || False || NUMBER ||  ||  
 
|-
 
|-
| ROI || || NUMBER(22, 3) ||  ||  
+
| ROI || True || NUMBER ||  ||  
 
|-
 
|-
 
|}
 
|}

Latest revision as of 17:26, 7 March 2016




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: