Appendix 5: Database objects/CGMS12xxx

From Agri4castWiki
Revision as of 22:05, 28 January 2016 by Wimdewinter (talk | contribs) (generated page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


note: this page was generated as a round trip of Appendix_5:_CGMS_tables and therefore shoul be identical except for the lay-out.


content
1. CMETEO-datasets
2. COMPLETE-datasets
3. CROP-datasets
4. LINK-datasets
5. RAIN-datasets
6. SIMULATION-datasets
7. SIMYIELD-datasets
8. SOIL-datasets
9. SUPIT-datasets
10. WEATHER-datasets
11. other datasets
12. synonyms




CMETEO-datasets

content
1.1 CMETEO_AEZ_GRID_LANDCOVERS
1.2 CMETEO_AGGREGATION_AREAS
1.3 CMETEO_CROPS
1.4 CMETEO_LANDCOVERS
1.5 CMETEO_REGION_GRID_LANDCOVERS
1.6 CMETEO_WEATHER_OBS_AEZ
1.7 CMETEO_WEATHER_OBS_GRID
1.8 CMETEO_WEATHER_OBS_REGION




CMETEO_AEZ_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: View
  • Remarks: user defined, derived from GIS


CMETEO_AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: input for cmeteo, converting names of columns for use in cmeteo package
  • Type: View
  • Remarks: none


CMETEO_CROPS

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: View
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CMETEO_LANDCOVERS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


CMETEO_REGION_GRID_LANDCOVERS

  • Description: landcover areas for each intersection of grid and administartive region (only level 3).
  • Use: input for cmeteo with standardized attribute names
  • Type: View
  • Remarks: user defined, derived from GIS


CMETEO_WEATHER_OBS_AEZ

  • Description: weather indicators per agri-environmental region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


CMETEO_WEATHER_OBS_GRID

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


CMETEO_WEATHER_OBS_REGION

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: View
  • Remarks:


COMPLETE-datasets

content
2.1 COMPLETE_LIST_OF_SIM_UNITS
2.2 COMPLETE_LIST_OF_SIM_UNITS_X




COMPLETE_LIST_OF_SIM_UNITS

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


COMPLETE_LIST_OF_SIM_UNITS_X

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


CROP-datasets

content
3.1 CROP_CALENDAR
3.2 CROP_GROUP
3.3 CROP_LANDCOVER
3.4 CROP_PARAMETER_VALUE




CROP_CALENDAR

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

  • Description: description of crop groups
  • Use: input table for the crop group number and name where crop belongs to
  • Type: Table
  • Remarks: none


CROP_LANDCOVER

  • Description:
  • Use: source for various views & synonyms
  • Type: Table
  • Remarks:


CROP_PARAMETER_VALUE

  • Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: Table
  • Remarks: In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


LINK-datasets

content
4.1 LINK_AEZ_GRID_LANDCOVER
4.2 LINK_EMU_REGION
4.3 LINK_EMU_REGION_LANDCOVER
4.4 LINK_REGION_GRID_LANDCOVER
4.5 LINK_STATION_GRID




LINK_AEZ_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo
  • Type: Table
  • Remarks: user defined, derived from GIS


LINK_EMU_REGION

  • Description: intersection of grid, administrative regions and soil mapping units, and their area.
  • Use: input/reference table for the crop simulation process
  • Type: Table
  • Remarks:


LINK_EMU_REGION_LANDCOVER

  • Description: intersection of grid, administrative regions and soil mapping units, and the cropping area per crop or landcover type.
  • Use: input/reference table for the crop simulation process
  • Type: Table
  • Remarks:


LINK_REGION_GRID_LANDCOVER

  • Description: landcover areas for each intersection of grid and NUTS region (only level 3).
  • Use: input for cmeteo
  • Type: Table
  • Remarks: user defined, derived from GIS


LINK_STATION_GRID

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


RAIN-datasets

content
5.1 RAIN_OBS_STATION
5.2 RAIN_OBS_STATION_INFO
5.3 RAIN_OBS_STATION_RAW




RAIN_OBS_STATION

  • Description: contains the station based 6-hourly rainfall data
  • Use: input level 1
  • Type: Table
  • Remarks: none


RAIN_OBS_STATION_INFO

  • Description: table for storing specific metadata for 6-hourly rainfall data (flags)
  • Use: meta data
  • Type: Table
  • Remarks: none


RAIN_OBS_STATION_RAW

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


SIMULATION-datasets

content
6.1 SIMULATION_LOG
6.2 SIMULATION_UNIT
6.3 SIMULATION_UNIT_ALL




SIMULATION_LOG

  • Description: contains information about simulation
  • Use: reference table
  • Type: Table
  • Remarks: none


SIMULATION_UNIT

  • Description: contains the unique combinations of grid number and soil typologic unit for each crop to be simulated.
  • Use: lookup table used during crop simulation
  • Type: View
  • Remarks: the content of this table is based on the intersection of soil map and climatic grid, excluding intersections (STU's) that are unsuitable for crop growth.


SIMULATION_UNIT_ALL

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


SIMYIELD-datasets

content
7.1 SIMYIELD_BLAST_GRID
7.2 SIMYIELD_BLAST_GRID_LOG
7.3 SIMYIELD_BLAST_GRID_LTA
7.4 SIMYIELD_BLAST_REGION
7.5 SIMYIELD_BLAST_REGION_LOG
7.6 SIMYIELD_BLAST_REGION_LTA
7.7 SIMYIELD_EMU
7.8 SIMYIELD_EMU_LOG
7.9 SIMYIELD_EMU_LTA
7.10 SIMYIELD_GRID
7.11 SIMYIELD_GRID_LOG
7.12 SIMYIELD_GRID_LTA
7.13 SIMYIELD_REGION
7.14 SIMYIELD_REGION_LOG
7.15 SIMYIELD_REGION_LTA
7.16 SIMYIELD_STU
7.17 SIMYIELD_WARM_GRID
7.18 SIMYIELD_WARM_GRID_LOG
7.19 SIMYIELD_WARM_GRID_LTA
7.20 SIMYIELD_WARM_REGION
7.21 SIMYIELD_WARM_REGION_LOG
7.22 SIMYIELD_WARM_REGION_LTA




SIMYIELD_BLAST_GRID

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


SIMYIELD_BLAST_GRID_LOG

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


SIMYIELD_BLAST_GRID_LTA

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


SIMYIELD_BLAST_REGION

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


SIMYIELD_BLAST_REGION_LOG

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


SIMYIELD_BLAST_REGION_LTA

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


SIMYIELD_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on weather observations
  • Use: output table for the crop simulation process
  • Type: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_EMU_LOG

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


SIMYIELD_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Table
  • Remarks:


SIMYIELD_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based observed weather.
  • Use: output table for the crop simulation process
  • Type: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_GRID_LOG

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


SIMYIELD_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Table
  • Remarks:


SIMYIELD_REGION

  • Description: results of the crop simulation per administrative region. Level 2 output
  • Use: output table for the crop simulation process
  • Type: Table
  • Remarks: This table contains aggregated simulation results for all CROP_NO's in STAT_CROP.


SIMYIELD_REGION_LOG

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


SIMYIELD_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on weather observations.
  • Use: Output table for the crop simulation process.
  • Type: Table
  • Remarks:


SIMYIELD_STU

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


SIMYIELD_WARM_GRID

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


SIMYIELD_WARM_GRID_LOG

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


SIMYIELD_WARM_GRID_LTA

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


SIMYIELD_WARM_REGION

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


SIMYIELD_WARM_REGION_LOG

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


SIMYIELD_WARM_REGION_LTA

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


SOIL-datasets

content
8.1 SOIL_ASSOCIATION_COMPOSITION
8.2 SOIL_DATA_FOR_BIOMA
8.3 SOIL_MAPPING_UNIT
8.4 SOIL_PHYSICAL_GROUP
8.5 SOIL_TYPOLOGIC_UNIT




SOIL_ASSOCIATION_COMPOSITION

  • Description: described the percentage area for each STU in each SMU. It is assumed that it therefore also describes the percentage area for each STU in each EMU.
  • Use: used to calculate the weighing factor to be applied to the SIMULATION_UNIT results
  • Type: Table
  • Remarks: derived from the soil map


SOIL_DATA_FOR_BIOMA

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


SOIL_MAPPING_UNIT

  • Description: listing of unique soil mapping units and related countries
  • Use: used by the crop growth model
  • Type: Table
  • Remarks: user defined, derived from the soil map


SOIL_PHYSICAL_GROUP

  • Description: contains the physical parameters describing the soil groups used by the crop growth model. Mainly describes the soil water model.
  • Use: used by the crop growth model
  • Type: Table
  • Remarks: user defined, derived from the soil map


SOIL_TYPOLOGIC_UNIT

  • Description: the rooting depth ( rd ) and soil physical group ( spg ) combination associated with every stu
  • Use: used by the crop growth model
  • Type: Table
  • Remarks: user defined, derived from the soil map


SUPIT-datasets

content
9.1 SUPIT_CONSTANTS
9.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:
  • Use:
  • Type: View
  • Remarks:


WEATHER-datasets

content
10.1 WEATHER_OBS_AEZ
10.2 WEATHER_OBS_AEZ_LTA
10.3 WEATHER_OBS_AEZ_LTA_THRES
10.4 WEATHER_OBS_AEZ_THRES
10.5 WEATHER_OBS_GRID
10.6 WEATHER_OBS_GRID_INFO
10.7 WEATHER_OBS_GRID_LTA
10.8 WEATHER_OBS_GRID_LTA_MISS
10.9 WEATHER_OBS_HIS_OPE_GRID
10.10 WEATHER_OBS_REGION
10.11 WEATHER_OBS_REGION_LTA
10.12 WEATHER_OBS_REGION_LTA_THRES
10.13 WEATHER_OBS_REGION_THRES
10.14 WEATHER_OBS_STATION
10.15 WEATHER_OBS_STATION_AVAIL
10.16 WEATHER_OBS_STATION_CALCULATED
10.17 WEATHER_OBS_STATION_ERRAIN
10.18 WEATHER_OBS_STATION_ERRORS
10.19 WEATHER_OBS_STATION_INFO
10.20 WEATHER_OBS_STATION_LTA
10.21 WEATHER_OBS_STATION_RAW
10.22 WEATHER_STATION




WEATHER_OBS_AEZ

  • Description: interpolated weather data per grid per agro-environmental egion
  • Use: input for monitoring extreme weather events
  • Type: Table
  • Remarks:


WEATHER_OBS_AEZ_LTA

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


WEATHER_OBS_AEZ_LTA_THRES

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


WEATHER_OBS_AEZ_THRES

  • Description:
  • Use:
  • Type: Table
  • 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_HIS_OPE_GRID

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


WEATHER_OBS_REGION

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


WEATHER_OBS_REGION_LTA

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


WEATHER_OBS_REGION_LTA_THRES

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


WEATHER_OBS_REGION_THRES

  • Description:
  • Use:
  • 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_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_STATION

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


other datasets

content
11.1 AEZ
11.2 AGGREGATION_AREAS
11.3 ALL_SIMULATION_UNITS
11.4 CGMS_SYSLOG
11.5 CROP
11.6 CROPSUSE
11.7 CW
11.8 DATES_75_15
11.9 EMU
11.10 GRID
11.11 GRID_ALL
11.12 INITIAL_SOIL_WATER
11.13 JSOW
11.14 ORDER_EAST_EUROPE
11.15 PARAMETER_DESCRIPTION
11.16 REGION
11.17 REGION_GRIDS_EMU
11.18 ROOTING_DEPTH
11.19 SITE
11.20 SMU_SUITABILITY
11.21 STATION
11.22 STATIONS_PER_GRID
11.23 STATION_REFERENCE_COEFFICIENTS
11.24 STAT_CROP
11.25 STU_LAYER
11.26 SUITABILITY
11.27 SYE
11.28 SYSCON
11.29 SYSTABLES
11.30 TASKS
11.31 VARIETY_PARAMETER_VALUE
11.32 VIEWER_REQUESTS
11.33 WOG
11.34 WOGINFO
11.35 WOSC




AEZ


AGGREGATION_AREAS

  • Description: cultivated areas per region used for spatial aggregation of crop indicators
  • Use: used for weighting during aggregating crop indicators towards regional crop indicators
  • Type: Table
  • Remarks: none


ALL_SIMULATION_UNITS

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


CGMS_SYSLOG

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


CROP

  • Description: description of crops. Crop name, number, associated crop group and general month.
  • Use: reference table, establishes association between crop and crop _ group , used during system initialisation and the crop growth simulation
  • Type: Table
  • Remarks: user defined. START_MONTH is not to be mistaken by grid and crop/variety specific START_MONTH in CROP_CALENDAR table. START_MONTH in CROP table indicates that the model will be run for the crop from this month onwards. Development can only start after passing START_MONTHDAY of START_MONTH and in accordance with START_TYPE of CROP_CALENDAR table.


CROPSUSE

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


CW

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


DATES_75_15

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


EMU

  • Description: the intersection of the soil map and the grid
  • Use: input/reference table for the crop simulation process
  • Type: Table
  • Remarks: user defined, derived from GIS, provides the link to the GIS


GRID

  • Description: The grid is used for two purposes. Firstly it is used to describe the area for which the meteorological data is assumed to be homogeneous. Secondly, a so-called ‘crop-calendar’ is associated with each grid square that defines certain crop specific parameters, and defines if a crop has to be simulated for this grid. The parameters describe the growing season for a crop in a grid square, and make it possible to take geographic differences in the growing season into account.
  • Use: input/reference table for both level 1 and level 2
  • Type: View
  • Remarks: user defined, derived from GIS, provides the link to the GIS


GRID_ALL

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


INITIAL_SOIL_WATER

  • Description: contains the initial soil moisture content per grid, stu_no, crop_no and calendar year
  • Use: input for level 2
  • Type: Table
  • Remarks: user defined


JSOW

  • Description: Long term average sowing data per crop for calculating 'rainfall around sowing'.
  • Use: Input table for calculating one of the Crop Simulation indicators.
  • Type: Table
  • Remarks:


ORDER_EAST_EUROPE

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


PARAMETER_DESCRIPTION

  • Description: describes the use and the type of parameter in crop_parameter_value and variety_parameter_value tables
  • Use: used during system initialisation to correctly interpret the parameter tables
  • Type: Table
  • Remarks: do not change this table


REGION

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Table
  • Remarks:


REGION_GRIDS_EMU

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


ROOTING_DEPTH

  • Description: the rooting depth classes and associated rooting depth limits
  • Use: reference table used in crop simulation
  • Type: Table
  • Remarks: part of the soil model, can be changed or extended if necessary


SITE

  • Description: Contains some soil model parameters on a system wide basis
  • Use: input table for the crop simulation process
  • Type: Table
  • Remarks: supplied by the user, but rarely changed


SMU_SUITABILITY

  • Description: a derived table containing the sum of the suitable area for a SMU for a particular crop _ group
  • Use: used during the aggregation from the simulation unit results to the emu results (to derive the simulation_unit table)
  • Type: Table
  • Remarks: this table needs to be recalculated whenever the simulation_unit table changes


STATION

  • Description: the weather stations and weather station characteristics to be used by the system
  • Use: used by all of the level 1 steps (additional weather, availability, grid weather)
  • Type: Table
  • Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated


STATIONS_PER_GRID

  • Description: the stations used for the grid weather interpolation of the historic year.
  • Use: output table for the level 1 grid weather calculation
  • Type: Table
  • Remarks: contains both information produced by historical interpolation and current year interpolation.


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


STAT_CROP

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


STU_LAYER

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


SUITABILITY

  • Description: the suitable STUs for each crop _ group
  • Use: used to derive the simulation_unit table
  • Type: Table
  • Remarks: user defined, derived from the soil map


SYE

  • Description: table for storing temporary results during Crop_Simulation. When the calculation is finshed, all records are inserted into SIMYIELD_EMU overwriting old results.
  • Use: temporary output table for the calculation of crop indicators.
  • Type: Table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


SYSCON

  • Description: contains system parameters
  • Use: upon system initialisation
  • Type: Table
  • Remarks: user defined


SYSTABLES

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


TASKS

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


VARIETY_PARAMETER_VALUE

  • Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: Table
  • Remarks: user defined. To express the deviation of a variety from the main crop parameters (stored in CROP_PARAMETER_VALUE table). In case of single parameters PARAMETER_XVALUE gives the value. In case of multiple parameters PARAMETER_YVALUE gives the value for a certain development stage or temperature described by PARAMETER_XVALUE.


VIEWER_REQUESTS

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


WOGINFO

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


WOSC

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


synonyms

content
12.1 CMETEO_ADMIN
12.2 REGION_MAPPINGS




CMETEO_ADMIN

  • Description: synonym to oracle package
  • Use:
  • Type: Synonym ➞ CMETEO@ADMIN_MRSMAN
  • Remarks: none




REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: Synonym ➞ REGION@MAPPINGS_EURMAN
  • Remarks: none

* When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table REGION_DESCRIPTIONS.