Appendix 5: Database objects/CGMS12old

From Agri4castWiki
Revision as of 14:18, 7 March 2016 by Wimdewinter (talk | contribs) (comment field added)
Jump to: navigation, search


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


CGMS_SYSLOG

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


CMETEO_ADMIN

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


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 on LINK_ AEZ_GRID_LANDCOVER
  • 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 on tables AGGREGATION_AREAS and REGION
  • 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: 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_GRID_LANDCOVER_AREAS

  • Description: landcover areas for each intersection of grid and agri-environmental region (only strata).
  • Use: input for cmeteo with standardized attribute names
  • Type: synonym on view CMETEO_AEZ_GRID_LANDCOVERS
  • Remarks: none


CMETEO_GRID_WEATHER

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


CMETEO_LANDCOVERS

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

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


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 on LINK_REGION_GRID_LANDCOVER
  • Remarks: user defined, derived from GIS


CMETEO_REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: input for cmeteo
  • Type: synonym on table REGION_MAPPINGS
  • Remark: none


CMETEO_REGION_WEATHER

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


CMETEO_REGIONS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: synonym on mrsman.cmeteo_regions
  • Remark: none


CMETEO_REJECTED_WEATHER

  • Description: rejected weather
  • Use: log table for cmeteo
  • Type: synonym on mrsman.cmeteo_rejected_weather
  • Remark: none


CMETEO_WEATHER_OBS_AEZ

  • 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

  • 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

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


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


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: Permanent 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: synonym on permanent table FORALL.CROP_GROUP
  • Remarks: none


CROP_LANDCOVER

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


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


CROP_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_EMU
  • Remarks:


DATA_FOR_YIELD_FORECAST

  • Description: Indicator values per indicator, for each combination of administrative region (nuts_code), year, decade and statistical crop (stat_crop_no).
  • Use: table for storing the indicators values that can be used for regression and scenario-analysis (see Yield Forecasting).
  • Type: Permanent table.
  • Remarks: The table is filled and regularly updated with indicator values from table SIMYIELD_REGION. The table contains the same data as stored in SIMYIELD_REGION, but in a different structure. This way also new indicators can be added without having to change the structure.


DATE_GENERATOR

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


DATES_75_15

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


DAY_DECADEYEAR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: synonym on FORALL.DAY_DECADEYEAR
  • Remarks: none



GRID_<MODEL>

  • Description: latitude, longitude and altitude of A regular ECMWF grid before downscaling.
  • Use: input for downscaling.
  • Type: Permanent table
  • Remarks: Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name. The calculation resolution of ECMWF models changes over time and/or forecast depth. In that case different derived elevation models are used stored in separate altitude Attributes with a reference to the ECMWF calculation resolution.



EMU

  • 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


FOREYIELD_HIS_REGION

  • Description: End of season forecast
  • Use: to store forecast results from the CST operational batch mode.
  • Type: Permanent table
  • Remarks: Not used by the user interface and regular batch mode of the CST that stores the forecast in table FORECASTED_NUTS_YIELD.


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



GRID_SEA_DOWN_ALGORITHMS

  • Description: grid specific downscaling equations per OPE grid cell.
  • Use: Downscaling SEA model data.
  • Type: Permanent table
  • Remarks: A similar table exists for the ERA model data. That table is called CGMS_GRID_METH_C.



GRID_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_GRID
  • 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: Permanent 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: 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'.


LINK_AEZ_GRID_LANDCOVER

  • 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

  • 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

  • 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

  • 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

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


LINK_STATION_REGION

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


LTA_CROP_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_EMU_LTA
  • Remarks:


LTA_GRID_YIELDS

  • Description:
  • Use: interface between the CGMS12EU database and the LTA_YIELD package
  • Type: view on table SIMYIELD_GRID_LTA
  • Remarks:


LTA_NUTS_YIELDS


LTA_YIELD_REGIONS

  • Description: synonym to oracle package
  • Use: table for LTA_YIELD package
  • Type: synonym on mrsman.lta_yield_regions
  • Remarks: none


LTA_YIELD

  • Description: synonym to oracle package
  • Use: link to LTA_YIELD package
  • Type: synonym on mrsman.lta_yield
  • Remarks: none


MODEL_EXCL_YEARS

  • Description: By default the years for which no statistical observations are available. But also outliers could be excluded.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the excluded years need to be known.


MODEL_INCL_INDICATORS

  • Description: Indicators that are included in the regression model.
  • Use: Output of level 3.
  • Type: permanent table.
  • Remarks: To be able to (re)derive the regression models, the included indicators need to be known.


MODEL_REGR_INDICATIFS

  • Description: The table stores the models:
  • Use: Output and input of level 3. In operational mode, this table is used to retrieve the models for calculating the forcasted yield.
  • Type: permanent table.
  • Remarks:


MODEL_SCEN_INDICATIFS

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


MODEL_SCEN_SIM_YEARS

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


MODEL_SETTINGS

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


MONTHDAYTODECADE

  • Description: synonym to oracle package
  • Use: Conversion of day and month to a decade (dutch: 10-daagse periode)
  • Type: synonym on forall.monthday2decade
  • Remarks:
Both month and day must be numeric: month {1..12}, day {1..31}.
No check is performed on valid COMBINATIONS of month and day
If one or both parameters seem invalid then a null-value will be returned


NUTS_YIELD

  • Description:
  • Use: used as interface between the CGMS12EU database and the viewers
  • Type: view on table SIMYIELD_REGION
  • 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: permanent table
  • Remarks: do not change this table


RAIN_OBS_STATION

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


RAIN_OBS_STATION_INFO

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


RAIN_OBS_STATION_RAW

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


REGION

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

  • 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


REGLISTS

  • Description: synonym to oracle package
  • Use: link to REGLISTS
  • Type: synonym on forall.reglists
  • Remarks: none


ROOTING_DEPTH

  • 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


RUN

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


SIMULATION_LOG

  • Description: contains information about simulation
  • Use: reference table
  • Type: permanent 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: 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.


SIMYIELD_<MODEL>_EMU

  • Description: results of the crop simulation per emu. Level 2 output based on forecast 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_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: Permanent table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


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


SIMYIELD_<MODEL>_GRID

  • Description: results of the crop simulation per grid. Level 2 output, based on forecast 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

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


SIMYIELD_HIS_EMU_LTA

  • Description: Long term average results of the crop simulation per emu. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_GRID_LTA

  • Description: Long term average results of the crop simulation per grid. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_HIS_REGION_LTA

  • Description: Long term average results of the crop simulation per administrative region. Level 2 output based on forecast weather.
  • Use: Output table for the crop simulation process.
  • Type: Permanent table
  • Remark: -


SIMYIELD_REGION

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


SITE

  • 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

  • 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


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


SOIL_MAPPING_UNIT

  • 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

* not filled/used

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


STAT_CROP

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


STAT_REGION

  • Description: official observed cultivated area and yield
  • Use: to derive regression models in Yield Forecasting module
  • Type: Permanent table
  • Remarks: none


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


STU_LAYER

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


SUITABILITY

  • 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


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: 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

  • 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 on table station_reference_coefficients
  • Remarks: not normally changed by the user but supplied by the JRC


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

SYSTABLES

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


TASKS

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

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



WEATHER_HIS_GRID_LTA

  • Description: long term average forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_REGION_LTA

  • Description: long term average forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_AEZ_LTA

  • Description: long term average forecasted weather per day and agri-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).



WEATHER_<MODEL>_AEZ

  • Description: forecasted weather per day and agro-environmental region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent 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) to get the table name. ERA, MON and SEA are not available for agro-environmental regions



WEATHER_<MODEL>_GRID

  • Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
  • Use: input for crop simulation.
  • Type: Permanent 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_<MODEL>_GRID_RAW

  • Description: forecasted weather per day and grid point in WGS84 geographic coordinate system.
  • Use: input for downscalling procedure (output to WEATHER_<MODEL>_GRID).
  • Type: Permanent 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_<MODEL>_REGION

  • Description: forecasted weather per day and administrative region.
  • Use: Monitoring extreme weather events.
  • Type: Permanent 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) to get the table name. MON and SEA are not available for administrative regions



WEATHER_OBS_AEZ

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


WEATHER_OBS_AEZ_LTA

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


WEATHER_OBS_GRID

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


WEATHER_OBS_GRID_INFO

  • Description:
  • Use:
  • Type: Permanent table


WEATHER_OBS_GRID_LTA

  • 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

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

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


WEATHER_OBS_REGION_LTA

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


WEATHER_OBS_STATION

  • Description: contains the station based daily meteorological data
  • Use: input for level 1
  • Type: permanent 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: permanent 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: permanent table
  • Remarks: none


WEATHER_OBS_STATION_ERRAIN

  • 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

  • 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

  • Description: table for storing specific metadata on daily weather data (flags)
  • Use: meta data
  • Type: permanent 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: permanent 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: permanent table
  • Remarks: none


WEATHER_STATION

  • Description:
  • Use: interface between the CGMS12EU database and the SupitConstants software
  • Type: view on table STATION
  • 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: Permanent table
  • Remarks: The table is created by cgms.exe each time the crop indicators are calculated.


WOGC

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


DAY_DECADE

  • Description: link between and decade, for mapping purposes
  • Use: sytem table used in level 2
  • Type: synonym on view FORALL.DAY_DECADE (based on DATE_GENERATOR)


STATIONS_PER_GRID_CURRENTYEAR

  • Description: the stations used for the grid weather interpolation of the current year.
  • Use: output table for the level 1 grid weather calculation
  • Type: permanent table
  • Remarks: will contain the information produced by current run for every day