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

From Agri4castWiki
Jump to: navigation, search
(LINK_CROP_PARAMETERS_CROP)
(LINK_CROP_PARAMETERS_MODEL)
Line 1,619: Line 1,619:
  
 
=== LINK_CROP_PARAMETERS_MODEL ===
 
=== LINK_CROP_PARAMETERS_MODEL ===
* Description: snapshot table for snapshot CGMS14CHN.LINK_CROP_PARAMETERS_MODEL
+
* Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.  
* Use:  
+
* Use: default crop parameter values in case no variety specific crop parameters are available.
 
* Type: ''Materialized View''
 
* Type: ''Materialized View''
* Remarks:  
+
* Remarks: Contains the same records as {{Object|CROP_PARAMETRIZATION_PARAMETER}}, with extra descriptive fields and only of the parameter category 'CROP'
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,630: Line 1,630:
 
! 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_PARAMETRIZATION || False || NUMBER || ||  
+
| IDCROP_PARAMETRIZATION || False || NUMBER || - || crop number
 
|-
 
|-
| CROP_PARAMETRIZATION || False || VARCHAR2 || ||  
+
| CROP_PARAMETRIZATION || False || VARCHAR2 || - || crop name
 
|-
 
|-
| IDMODEL || False || NUMBER || ||  
+
| IDMODEL || False || NUMBER || - || crop model number
 
|-
 
|-
| MODEL || False || VARCHAR2 || ||  
+
| MODEL || False || VARCHAR2 || - || crop model name
 
|-
 
|-
| IDCOVER || False || NUMBER || ||  
+
| IDCOVER || False || NUMBER || - || crop mask number
 
|-
 
|-
| COVER || False || VARCHAR2 || ||  
+
| COVER || False || VARCHAR2 || - || crop mask name
 
|-
 
|-
| IDCROP_PARAMETER || False || NUMBER || ||  
+
| IDCROP_PARAMETER || False || NUMBER || - || parameter number
 
|-
 
|-
| CROP_PARAMETER || False || VARCHAR2 || ||  
+
| CROP_PARAMETER || False || VARCHAR2 || - || parameter name
 
|-
 
|-
| DESCRIPTOR || False || VARCHAR2 || ||  
+
| DESCRIPTOR || False || VARCHAR2 || - || parameter description and unit
 
|-
 
|-
| XVALUE || False || NUMBER || ||  
+
| XVALUE || False || NUMBER || depending on parameter || parameter x value
 
|-
 
|-
| YVALUE || True || NUMBER || ||  
+
| YVALUE || True || NUMBER || depending on parameter || parameter y value (in case of AFGEN function)
 
|-
 
|-
 
|}
 
|}
 
 
 
'''definition:'''
 
'''definition:'''
 
  select
 
  select
Line 1,674: Line 1,672:
 
   , crop_parametrizations cp
 
   , crop_parametrizations cp
 
   , global_crop_parameters cps
 
   , global_crop_parameters cps
  where cpp.idcrop_parametrization = cp.idcrop_parametrization
+
  where cpp.idcrop_parametrization       = cp.idcrop_parametrization
  and  cpp.idcrop_parameter       = cps.idcrop_parameter
+
  and  cpp.idcrop_parameter             = cps.idcrop_parameter
  and  cp.idcover                 = c.idcover
+
  and  cp.idcover                       = c.idcover  
  and  cp.idmodel                 = m.idmodel
+
  and  cp.idmodel                       = m.idmodel
  and  cp.active_parametrization  = 'Y'
+
  and  lower(cp.active_parametrization) = lower('Y')
  and  cps.category              = 'MODEL'
+
  and  lower(cps.category)               = lower('MODEL')
   
+
  order by cpp.idcrop_parametrization, cps.crop_parameter
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
Line 1,687: Line 1,685:
  
 
<!-- start -->
 
<!-- start -->
 +
 
=== LINK_CROP_PARAMETRIZATION ===
 
=== LINK_CROP_PARAMETRIZATION ===
 
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
 
* Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.

Revision as of 15:57, 12 April 2018




content
1. CROP-datasets
2. GLOBAL-datasets
3. LINK-datasets
4. SIM-datasets
5. SOIL-datasets
6. WEATHER-datasets
7. other datasets




CROP-datasets

content
1.1 CROP_AGGREGATIONS
1.2 CROP_CALENDARS
1.3 CROP_PARAMETRIZATIONS
1.4 CROP_PARAMETRIZATION_PARAMETER
1.5 CROP_REGIMES
1.6 CROP_SPATIALIZATIONS
1.7 CROP_SUITABILITY_RULES
1.8 CROP_VARIETIES
1.9 CROP_VARIETY_PARAMETERS
1.10 CROP_VARIETY_REGIMES




CROP_AGGREGATIONS

  • Description: Link between simulated and aggregated crops.
  • Use: To aggregate simulation results at EMU resolution (IDCROP_PARAMETRIZATION) to regional resolution (IDCROP_AGGREGATION). A single simulated crop (IDCROP_PARAMETERIZATION) can be aggregated to different aggregated crops (IDCROP_AGGREGATION) using different aggregation areas.
  • Type: Table
  • Remarks:



CROP_CALENDARS

  • Description: where and when crops are grown. crop, crop variety and growing season per grid.
  • Use: determines which crops are simulated for a grid, and simulation period
  • Type: Table
  • Remarks: user defined, one of the ‘driving’ tables of the system


CROP_PARAMETRIZATIONS

  • Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
  • Use:
  • Type: Table
  • Remarks:



CROP_PARAMETRIZATION_PARAMETER

  • Description: crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Table
  • Remarks:


CROP_REGIMES

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


CROP_SPATIALIZATIONS

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


CROP_SUITABILITY_RULES

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


CROP_VARIETIES

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


CROP_VARIETY_PARAMETERS

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


CROP_VARIETY_REGIMES

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


GLOBAL-datasets

content
2.1 GLOBAL_CATEGORIES
2.2 GLOBAL_COVERS
2.3 GLOBAL_COVER_SOURCES
2.4 GLOBAL_CROPS
2.5 GLOBAL_CROP_PARAMETERS
2.6 GLOBAL_GRIDS
2.7 GLOBAL_GRID_SOURCES
2.8 GLOBAL_LINK_COVERWINDOW_SOURCE
2.9 GLOBAL_MODELS
2.10 GLOBAL_REGIONS
2.11 GLOBAL_REGION_ELEMENTS
2.12 GLOBAL_REGION_SOURCES
2.13 GLOBAL_SOIL_SOURCES
2.14 GLOBAL_STATIONS
2.15 GLOBAL_STATISTIC_SOURCES
2.16 GLOBAL_SUITABILITY_PROPERTIES
2.17 GLOBAL_THRESHOLDS
2.18 GLOBAL_TIME_DIMENSIONS
2.19 GLOBAL_TREATMENTS
2.20 GLOBAL_WINDOWS




GLOBAL_CATEGORIES

  • Description: snapshot table for snapshot CGMS14CHN.GLOBAL_CATEGORIES
  • Use:
  • Type: Materialized View
  • Remarks:


GLOBAL_COVERS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_COVER_SOURCES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_CROPS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_CROP_PARAMETERS

  • Description: snapshot table for snapshot GLOBAL_CROP_PARAMETERS. List of all crop parameters, description, unit, type (single value or AFGEN function) and category (crop- or model parameters).
  • Use:
  • Type: Materialized View
  • Remarks: source objects exist in a different tennent, available via dblink.



GLOBAL_GRIDS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_GRID_SOURCES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_LINK_COVERWINDOW_SOURCE

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_MODELS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_REGIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_REGION_ELEMENTS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_REGION_SOURCES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_SOIL_SOURCES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_STATIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_STATISTIC_SOURCES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_SUITABILITY_PROPERTIES

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_THRESHOLDS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_TIME_DIMENSIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_TREATMENTS

  • Description:
  • Use:
  • Type: View
  • Remarks:


GLOBAL_WINDOWS

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK-datasets

content
3.1 LINK_CROP_AGGREGATION
3.2 LINK_CROP_CALENDARS
3.3 LINK_CROP_PARAMETERS
3.4 LINK_CROP_PARAMETERS_CROP
3.5 LINK_CROP_PARAMETERS_MODEL
3.6 LINK_CROP_PARAMETRIZATION
3.7 LINK_CROP_SPATIALIZATIONS
3.8 LINK_CROP_STU
3.9 LINK_CROP_VARIETY_PARAMETERS
3.10 LINK_GRID_COVER
3.11 LINK_GRID_REGION_COVER
3.12 LINK_REGION_COVER
3.13 LINK_SIMULATION_UNIT
3.14 LINK_SIMULATION_UNIT_CROP
3.15 LINK_SMU_GRID_COVER
3.16 LINK_SMU_GRID_REGION_COVER
3.17 LINK_SMU_STU
3.18 LINK_STU_HORIZONS
3.19 LINK_STU_WEIGHTED_PARAMETERS
3.20 LINK_SUITABILITY_RULES




LINK_CROP_AGGREGATION

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_CROP_CALENDARS

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_CROP_PARAMETERS

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains the same records as CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields


LINK_CROP_PARAMETERS_CROP

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains the same records as CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'CROP'



LINK_CROP_PARAMETERS_MODEL

  • Description: snapshot table for snapshot LINK_CROP_PARAMETERS. Crop specific values of the parameters, copied from the region- and non-region specific physiological information of the crop knowledge database.
  • Use: default crop parameter values in case no variety specific crop parameters are available.
  • Type: Materialized View
  • Remarks: Contains the same records as CROP_PARAMETRIZATION_PARAMETER, with extra descriptive fields and only of the parameter category 'CROP'



LINK_CROP_PARAMETRIZATION

  • Description: list of the crop parametrizations and additional general attributes such as the crop name, crop model, landcover to which the crop is linked and operability of the crop.
  • Use:
  • Type: View
  • Remarks: contains the same records as CROP_PARAMETRIZATIONS, with additional descriptive fields.



LINK_CROP_SPATIALIZATIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_CROP_STU

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


LINK_CROP_VARIETY_PARAMETERS

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_GRID_COVER

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


LINK_GRID_REGION_COVER

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


LINK_REGION_COVER

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


LINK_SIMULATION_UNIT

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_SIMULATION_UNIT_CROP

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_SMU_GRID_COVER

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


LINK_SMU_GRID_REGION_COVER

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


LINK_SMU_STU

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


LINK_STU_HORIZONS

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


LINK_STU_WEIGHTED_PARAMETERS

  • Description:
  • Use:
  • Type: View
  • Remarks:


LINK_SUITABILITY_RULES

  • Description:
  • Use:
  • Type: View
  • Remarks:


SIM-datasets

content
4.1 SIM_BLAST_HRES_GRID
4.2 SIM_BLAST_HRES_GRID_LTA
4.3 SIM_BLAST_HRES_REGION
4.4 SIM_BLAST_HRES_REGION_LTA
4.5 SIM_WARM_HRES_GRID
4.6 SIM_WARM_HRES_GRID_LTA
4.7 SIM_WARM_HRES_REGION
4.8 SIM_WARM_HRES_REGION_LTA
4.9 SIM_WOFOST_HRES_EMU
4.10 SIM_WOFOST_HRES_EMU_LTA
4.11 SIM_WOFOST_HRES_GRID
4.12 SIM_WOFOST_HRES_GRID_LTA
4.13 SIM_WOFOST_HRES_REGION
4.14 SIM_WOFOST_HRES_REGION_LTA
4.15 SIM_WOFOST_HRES_STU




SIM_BLAST_HRES_GRID

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


SIM_BLAST_HRES_GRID_LTA

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


SIM_BLAST_HRES_REGION

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


SIM_BLAST_HRES_REGION_LTA

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


SIM_WARM_HRES_GRID

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


SIM_WARM_HRES_GRID_LTA

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


SIM_WARM_HRES_REGION

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


SIM_WARM_HRES_REGION_LTA

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


SIM_WOFOST_HRES_EMU

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


SIM_WOFOST_HRES_EMU_LTA

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


SIM_WOFOST_HRES_GRID

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


SIM_WOFOST_HRES_GRID_LTA

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


SIM_WOFOST_HRES_REGION

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


SIM_WOFOST_HRES_REGION_LTA

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


SIM_WOFOST_HRES_STU

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


SOIL-datasets

content
5.1 SOIL_HORIZONS
5.2 SOIL_INITIAL_WATER
5.3 SOIL_SMU
5.4 SOIL_STU




SOIL_HORIZONS

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


SOIL_INITIAL_WATER

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


SOIL_SMU

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


SOIL_STU

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


WEATHER-datasets

content
6.1 WEATHER_ERA_GRID
6.2 WEATHER_ERA_GRID_LTA
6.3 WEATHER_ERA_REGIONCOVER
6.4 WEATHER_ERA_REGIONCOVER_LTA
6.5 WEATHER_HIS_GRID
6.6 WEATHER_HIS_REGIONCOVER
6.7 WEATHER_HRES_GRID
6.8 WEATHER_HRES_REGIONCOVER
6.9 WEATHER_OBS_GRID
6.10 WEATHER_OBS_GRID_INFO
6.11 WEATHER_OBS_GRID_LTA
6.12 WEATHER_OBS_GRID_LTA_MISS
6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD
6.14 WEATHER_OBS_REGCOV_THRESHOLDS
6.15 WEATHER_OBS_REGIONCOVER
6.16 WEATHER_OBS_REGIONCOVER_LTA
6.17 WEATHER_OBS_STATION
6.18 WEATHER_OBS_STATION_AVAIL
6.19 WEATHER_OBS_STATION_CALCULATED
6.20 WEATHER_OBS_STATION_ERRAIN
6.21 WEATHER_OBS_STATION_ERRORS
6.22 WEATHER_OBS_STATION_INFO
6.23 WEATHER_OBS_STATION_INFO_ERR
6.24 WEATHER_OBS_STATION_LTA
6.25 WEATHER_OBS_STATION_RAW
6.26 WEATHER_OBS_STATION_TEMP
6.27 WEATHER_OPE_GRID
6.28 WEATHER_OPE_REGIONCOVER




WEATHER_ERA_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


WEATHER_ERA_GRID_LTA

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


WEATHER_ERA_REGIONCOVER

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


WEATHER_ERA_REGIONCOVER_LTA

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


WEATHER_HIS_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


WEATHER_HIS_REGIONCOVER

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


WEATHER_HRES_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: View
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


WEATHER_HRES_REGIONCOVER

  • Description:
  • Use:
  • Type: View
  • Remarks:


WEATHER_OBS_GRID

  • Description: interpolated weather data per grid per day
  • Use: output for level 1, input for level 2
  • Type: Table
  • Remarks:


WEATHER_OBS_GRID_INFO

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


WEATHER_OBS_GRID_LTA

  • Description: long term average interpolated weather data per grid cell per day
  • Use: Monitoring extreme weather events
  • Type: Table
  • Remarks:


WEATHER_OBS_GRID_LTA_MISS

  • Description: long term average number of grid cells per country.
  • Use: input for check on WEATHER_OBS_GRID table (see section Check on missing grid weather).
  • Type: Table
  • Remarks: filled with procedure lta_missing_grid_weather.sql


WEATHER_OBS_REGCOV_LTA_THRSHLD

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


WEATHER_OBS_REGCOV_THRESHOLDS

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


WEATHER_OBS_REGIONCOVER

  • Description: interpolated weather data per grid per administrative region
  • Use: input for monitoring extreme weather events
  • Type: Table
  • Remarks:


WEATHER_OBS_REGIONCOVER_LTA

  • Description: long term average interpolated weather data per administrative region per day
  • Use: Monitoring extreme weather events
  • Type: Table
  • Remarks:


WEATHER_OBS_STATION

  • Description: contains the station based daily meteorological data
  • Use: input for level 1
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_AVAIL

  • Description: available weather stations for interpolation per station and per year.
  • Use: output of the weather data availability calculation, used by the grid weather interpolation
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_CALCULATED

  • Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
  • Use: output table for additional weather calculation, input for grid weather
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_ERRAIN

  • Description: contains deleted wrongly rain records of the station based daily meteorological data
  • Use: archive reasons
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_ERRORS

  • Description: contains deleted wrongly weather records of the station based daily meteorological data
  • Use: archive reasons
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_INFO

  • Description: table for storing specific metadata on daily weather data (flags)
  • Use: meta data
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_INFO_ERR

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


WEATHER_OBS_STATION_LTA

  • Description: contains the long term average weather data per station per day
  • Use: substitute data in case of missing data during level 1 processing
  • Type: Table
  • Remarks: filled by software tool ReferenceWeather


WEATHER_OBS_STATION_RAW

  • Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
  • Use: input level 1
  • Type: Table
  • Remarks: none


WEATHER_OBS_STATION_TEMP

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


WEATHER_OPE_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Table
  • Remarks: The products from ECMWF (see Forecasted weather) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.


WEATHER_OPE_REGIONCOVER

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


other datasets

content
7.1 CGMS_SYSLOG
7.2 DATES_75_15
7.3 GRIDS
7.4 HRES_YEARS
7.5 INTERPOLATION_PARAMETERS
7.6 REGIONS
7.7 STATIONS
7.8 STAT_REGION_AREAS
7.9 SYSTABLES
7.10 TASKS
7.11 WOG
7.12 WOSC




CGMS_SYSLOG

  • Description: logging of run options.
  • Use: output table containing information on the run executed
  • Type: Table
  • Remarks: none


DATES_75_15

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: Table
  • Remarks: none


GRIDS

  • Description:
  • Use:
  • Type: View
  • Remarks:


HRES_YEARS

  • Description:
  • Use:
  • Type: View
  • Remarks:


INTERPOLATION_PARAMETERS

  • Description: list of interpolation parameters
  • Use:
  • Type: Table
  • Remarks:


REGIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


STATIONS

  • Description:
  • Use:
  • Type: View
  • Remarks:


STAT_REGION_AREAS

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


SYSTABLES

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


TASKS

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


WOG

  • Description: table for storing temporary results during interpolation of grid weather as part of the Weather Monitoring module. When the calculation is finshed, all records are inserted into WEATHER_OBS_GRID.
  • Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
  • Type: Table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


WOSC

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