Appendix 5: Database objects/CGMS14SYS

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:

Structure
Attribute Constraint Type Unit Comment IDREGION_ELEMENT False NUMBER IDORIGINAL_CODE False VARCHAR2 IDREGION False VARCHAR2 IDREGION_SOURCE False NUMBER NAME True VARCHAR2 REGION_LEVEL False NUMBER IDFATHER True NUMBER STANDARD False VARCHAR2

REGION_SOURCES

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

Structure
Attribute Constraint Type Unit Comment IDREGION_SOURCE False NUMBER REGION_SOURCE False VARCHAR2 DESCRIPTION True VARCHAR2 UNC True VARCHAR2

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)

Structure

Attribute Constraint Type Unit 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

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

Structure

Attribute Constraint Type Unit 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

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:

Structure
Attribute Constraint Type Unit Comment IDCATEGORY False NUMBER category identifier CATEGORY False VARCHAR2 name DESCRIPTOR False VARCHAR2 description

COVERS

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

Structure
Attribute Constraint Type Unit Comment IDCOVER False NUMBER COVER False VARCHAR2 DESCRIPTOR False VARCHAR2

COVER_SOURCES

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

Structure
Attribute Constraint Type Unit Comment IDCOVER_SOURCE False NUMBER COVER_SOURCE False VARCHAR2 DESCRIPTOR True VARCHAR2 UNC True VARCHAR2

CROPS

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

Structure
Attribute Constraint Type Unit Comment IDCROP False NUMBER CROP False VARCHAR2 DESCRIPTOR False VARCHAR2 EUROSTAT False VARCHAR2

CROP_PARAMETERS

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

Structure
Attribute Constraint Type Unit Comment IDCROP_PARAMETER False NUMBER CROP_PARAMETER False VARCHAR2 DESCRIPTOR False VARCHAR2 MULTI False VARCHAR2 IDCATEGORY False NUMBER

GRIDS

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

Structure
Attribute Constraint Type Unit 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

GRIDS_TEMP

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

Structure
Attribute Constraint Type Unit 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

GRID_SOURCES

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

Structure
Attribute Constraint Type Unit Comment IDGRID_SOURCE False NUMBER IDWINDOW False NUMBER GRID_SOURCE False VARCHAR2 RESOLUTION False NUMBER UNIT False VARCHAR2 DESCRIPTION True VARCHAR2 UNC True VARCHAR2

LINK_COVER_WINDOW_SOURCE

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

Structure
Attribute Constraint Type Unit Comment IDWINDOW False NUMBER IDCOVER False NUMBER IDCOVER_SOURCE False NUMBER

MODELS

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

Structure
Attribute Constraint Type Unit Comment IDMODEL False NUMBER MODEL False VARCHAR2 DESCRIPTOR False VARCHAR2

REGIONS

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

Structure
Attribute Constraint Type Unit Comment IDREGION False VARCHAR2 IDWINDOW True NUMBER REGION False VARCHAR2 NAME False VARCHAR2 CONTINENT False VARCHAR2 POPULATION True NUMBER

SOIL_SOURCES

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

Structure
Attribute Constraint Type Unit Comment IDSOIL_SOURCE False NUMBER SOIL_SOURCE False VARCHAR2 DESCRIPTOR False VARCHAR2

STATIONS

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

Structure

Attribute Constraint Type Unit Comment IDSTATION False NUMBER STATION False VARCHAR2 ORGANIZATION False VARCHAR2 IDWMO True NUMBER WMO True VARCHAR2 LATITUDE False NUMBER LONGITUDE False NUMBER Y_COORDINATE False NUMBER X_COORDINATE False NUMBER ALTITUDE False NUMBER IDCLIMATE_ZONE False NUMBER COUNTRY False VARCHAR2 DISTANCE_TO_COAST False NUMBER ANGSTROM_A False NUMBER ANGSTROM_B False NUMBER SUPIT_A False NUMBER SUPIT_B False NUMBER SUPIT_C False NUMBER HARGREAVES_A False NUMBER HARGREAVES_B False NUMBER RELIABLE_STATION False NUMBER ACTIVE_STATION False NUMBER AVAIL_PRECIPITATION_THRESHOLD False NUMBER AVAIL_SNOWDEPTH_THRESHOLD False NUMBER AVAIL_TEMPERATURE_THRESHOLD False NUMBER AVAIL_HUMIDITY_THRESHOLD False NUMBER AVAIL_REST_THRESHOLD False NUMBER

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

Structure
Attribute Constraint Type Unit Comment LATITUDE False NUMBER - LONGITUDE False NUMBER - ALTITUDE False NUMBER - ANGSTROM_A True NUMBER - ANGSTROM_B True NUMBER - SUPIT_A True NUMBER - SUPIT_B True NUMBER - SUPIT_C True NUMBER - HARGREAVES_A True NUMBER - HARGREAVES_B True NUMBER -

STATISTIC_SOURCES

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

Structure
Attribute Constraint Type Unit Comment IDSTATISTIC_SOURCE False NUMBER STATISTIC_SOURCE False VARCHAR2 DESCRIPTOR False VARCHAR2

SUITABILITY_PROPERTIES

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

Structure
Attribute Constraint Type Unit Comment IDSUITABILITY_PROPERTY False NUMBER SUITABILITY_PROPERTY False VARCHAR2 DESCRIPTOR False VARCHAR2

THRESHOLDS

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

Structure
Attribute Constraint Type Unit Comment IDTHRESHOLD False NUMBER IDWINDOW False NUMBER THRESHOLD False VARCHAR2 INDICATOR False VARCHAR2 OPERATOR False VARCHAR2 VALUE_MIN False NUMBER VALUE_MAX False NUMBER

TIME_DIMENSIONS

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

Structure
Attribute Constraint Type Unit Comment DAY False DATE DECADE True NUMBER DECADE_ID True NUMBER MONTH True NUMBER MONTH_ID True NUMBER QUARTER True NUMBER QUARTER_ID True NUMBER YEAR True NUMBER LAST_DAY_DECADE True VARCHAR2

TREATMENTS

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

Structure
Attribute Constraint Type Unit Comment IDTREATMENT False NUMBER TREATMENT False VARCHAR2 DESCRIPTOR False VARCHAR2

WEATHER_STATION

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

Structure

Attribute Constraint Type Unit Comment 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 PERCENT_COMPLETE True NUMBER - 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

WINDOWS

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

Structure
Attribute Constraint Type Unit Comment IDWINDOW False NUMBER WINDOW False VARCHAR2 NAME False VARCHAR2 REFERENCE_SYSTEM False VARCHAR2 DESCRIPTOR True VARCHAR2 MAX_LAT False NUMBER MAX_LON False NUMBER MIN_LAT False NUMBER MIN_LON False NUMBER MAX_X False NUMBER MAX_Y False NUMBER MIN_X False NUMBER MIN_Y False NUMBER ROI True NUMBER