Appendix 5: Database objects/CGMS12xxx

From Agri4castWiki
Revision as of 18:09, 28 January 2016 by Wimdewinter (talk | contribs) (note added)
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

View.

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

CMETEO_AGGREGATION_AREAS

View.

  • 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 on tables AGGREGATION_AREAS and REGION
  • Remarks: none

CMETEO_CROPS

View.

  • 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: synonym on table mrsman.cmeteo_crops
  • 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

View.

  • List of landcovers or crops to be evaluated in CMETEO
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on FORALL.CMETEO_LAND_COVERS_EU / CROP_LANDCOVER

CMETEO_REGION_GRID_LANDCOVERS

View.

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

CMETEO_WEATHER_OBS_AEZ

View.

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

CMETEO_WEATHER_OBS_GRID

View.

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on table WEATHER_OBS_GRID

CMETEO_WEATHER_OBS_REGION

View.

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: view on WEATHER_OBS_REGION

COMPLETE-datasets

content
2.1 COMPLETE_LIST_OF_SIM_UNITS
2.2 COMPLETE_LIST_OF_SIM_UNITS_X



COMPLETE_LIST_OF_SIM_UNITS

Table.

COMPLETE_LIST_OF_SIM_UNITS_X

View.

CROP-datasets

content
3.1 CROP_CALENDAR
3.2 CROP_GROUP
3.3 CROP_LANDCOVER
3.4 CROP_PARAMETER_VALUE



CROP_CALENDAR

Table.

  • 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: Permanent table
  • Remarks: user defined, one of the ‘driving’ tables of the system

CROP_GROUP

Table.

  • Description: description of crop groups
  • Use: input table for the crop group number and name where crop belongs to
  • Type: synonym on permanent table FORALL.CROP_GROUP
  • Remarks: none

CROP_LANDCOVER

Table.

  • List of crop and landcovers
  • Use: source for various views & synonyms
  • Type: synonym & table

CROP_PARAMETER_VALUE

Table.

  • Description: values of crop parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: Permanent 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

Table.

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

LINK_EMU_REGION

Table.

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

LINK_EMU_REGION_LANDCOVER

Table.

  • 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: Permanent table
  • Remarks:

LINK_REGION_GRID_LANDCOVER

Table.

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

LINK_STATION_GRID

Table.

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

Table.

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

RAIN_OBS_STATION_INFO

Table.

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

RAIN_OBS_STATION_RAW

Table.

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

SIMULATION-datasets

content
6.1 SIMULATION_LOG
6.2 SIMULATION_UNIT
6.3 SIMULATION_UNIT_ALL



SIMULATION_LOG

Table.

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

SIMULATION_UNIT

View.

  • 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: permanent table
  • 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

Table.

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

Table.

SIMYIELD_BLAST_GRID_LOG

Table.

SIMYIELD_BLAST_GRID_LTA

Table.

SIMYIELD_BLAST_REGION

Table.

SIMYIELD_BLAST_REGION_LOG

Table.

SIMYIELD_BLAST_REGION_LTA

Table.

SIMYIELD_EMU

Table.

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

SIMYIELD_EMU_LOG

Table.

SIMYIELD_EMU_LTA

Table.

  • 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: Permanent table
  • Remark: -

SIMYIELD_GRID

Table.

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

SIMYIELD_GRID_LOG

Table.

SIMYIELD_GRID_LTA

Table.

  • 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: Permanent table
  • Remark: -

SIMYIELD_REGION

Table.

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

SIMYIELD_REGION_LOG

Table.

SIMYIELD_REGION_LTA

Table.

  • 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: Permanent table
  • Remark: -

SIMYIELD_STU

Table.

SIMYIELD_WARM_GRID

Table.

SIMYIELD_WARM_GRID_LOG

Table.

SIMYIELD_WARM_GRID_LTA

Table.

SIMYIELD_WARM_REGION

Table.

SIMYIELD_WARM_REGION_LOG

Table.

SIMYIELD_WARM_REGION_LTA

Table.

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

Table.

  • 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: permanent table
  • Remarks: derived from the soil map

SOIL_DATA_FOR_BIOMA

View.

SOIL_MAPPING_UNIT

Table.

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

SOIL_PHYSICAL_GROUP

Table.

  • 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: permanent table
  • Remarks: user defined, derived from the soil map

SOIL_TYPOLOGIC_UNIT

Table.

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

SUPIT-datasets

content
9.1 SUPIT_CONSTANTS
9.2 SUPIT_REFERENCE_STATIONS



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)

SUPIT_REFERENCE_STATIONS

View.

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

Table.

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

WEATHER_OBS_AEZ_LTA

Table.

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

WEATHER_OBS_AEZ_LTA_THRES

Table.

WEATHER_OBS_AEZ_THRES

Table.

WEATHER_OBS_GRID

Table.

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

WEATHER_OBS_GRID_INFO

Table.

  • Description:
  • Use:
  • Type: Permanent table

WEATHER_OBS_GRID_LTA

Table.

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

WEATHER_OBS_GRID_LTA_MISS

Table.

  • 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: permanent table
  • Remarks: filled with procedure lta_missing_grid_weather.sql

WEATHER_OBS_HIS_OPE_GRID

View.

WEATHER_OBS_REGION

Table.

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

WEATHER_OBS_REGION_LTA

Table.

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

WEATHER_OBS_REGION_LTA_THRES

Table.

WEATHER_OBS_REGION_THRES

Table.

WEATHER_OBS_STATION

Table.

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

WEATHER_OBS_STATION_AVAIL

Table.

  • 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: permanent table
  • Remarks: none

WEATHER_OBS_STATION_CALCULATED

Table.

  • 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: permanent table
  • Remarks: none

WEATHER_OBS_STATION_ERRAIN

Table.

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

WEATHER_OBS_STATION_ERRORS

Table.

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

WEATHER_OBS_STATION_INFO

Table.

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

WEATHER_OBS_STATION_LTA

Table.

  • 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: permanent table
  • Remarks: filled by software tool ReferenceWeather

WEATHER_OBS_STATION_RAW

Table.

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

WEATHER_STATION

View.

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: view on table STATION
  • Remarks:

other datasets

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



AEZ

Table.

AGGREGATION_AREAS

Table.

  • 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: Permanent table
  • Remarks: none

ALL_SIMULATION_UNITS

View.

CGMS_SYSLOG

Table.

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

CROP

Table.

  • 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 on from forall.crop_landcover (subset of FORALL.CROP_LANDCOVER 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

Table.

CW

Table.

DATES_75_15

Table.

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on forall.dates_75_15
  • Remarks: none

EMU

Table.

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

GRID

View.

  • 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: permanent table
  • Remarks: user defined, derived from GIS, provides the link to the GIS

GRID_ALL

Table.

INITIAL_SOIL_WATER

Table.

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

JSOW

Table.

  • 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: Permanent table, provided by JRC.
  • Remark: Even if the table CROP_CALENDAR specifies fixed sowing per crop per year, the JSOW table is used to calculate 'rainfall around sowing'.

ORDER_EAST_EUROPE

Table.

PARAMETER_DESCRIPTION

Table.

  • 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: permanent table
  • Remarks: do not change this table

REGION

Table.

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Synonym on view FORALL.REGIONS_EUR12EU which references the FORALL tables REGION_DESCRIPTIONS and REGION_MAPPINGS

REGION_GRIDS_EMU

View.

ROOTING_DEPTH

Table.

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

SITE

Table.

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

SMU_SUITABILITY

Table.

  • 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: permanent table
  • Remarks: this table needs to be recalculated whenever the simulation_unit table changes

STATION

Table.

  • 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: permanent table
  • Remarks: when changing this table, Reference_Weather and Supit_Constants may have to be updated

STATIONS_PER_GRID

Table.

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

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

STAT_CROP

Table.

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:

STU_LAYER

Table.

  • Description:
  • Use:
  • Type: Permanent table
  • Remarks:

SUITABILITY

Table.

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

SYE

Table.

  • 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: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

SYSCON

Table.

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

SYSTABLES

Table.

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:

TASKS

View.

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:

VARIETY_PARAMETER_VALUE

Table.

  • Description: values of variety parameters. Crop characteristics as understood by WOFOST and LINGRA
  • Use: input table for the crop simulation process
  • Type: permanent 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

Table.

  • Description:
  • Use:
  • Type: permanent table
  • Remarks:

WOG

Table.

  • 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: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.

WOGINFO

Table.

WOSC

Table.

synonyms

content
12.1 CMETEO_ADMIN
12.2 REGION_MAPPINGS



CMETEO_ADMIN

Synonym ➞ CMETEO@ADMIN_MRSMAN.

  • Description: synonym to oracle package
  • Use:
  • Type: synonym on mrsman.cmeteo_admin
  • Remarks: none



REGION_MAPPINGS

Synonym ➞ REGION@MAPPINGS_EURMAN.

  • Description: regions and their relations (mappings)
  • Use: used by many object to find relation between regions of different levels.
  • Type: synonyms on forall.region_mappings_eur
  • Remarks: none

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