Appendix 5: Database objects/CGFS14EU

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



content
1. CMETEO-datasets
2. SIMYIELD-datasets
3. WEATHER-datasets
4. other datasets
5. synonyms




CMETEO-datasets

content
1.1 CMETEO_WEATHER_HIS_AEZ
1.2 CMETEO_WEATHER_HIS_GRID
1.3 CMETEO_WEATHER_HIS_REGION
1.4 CMETEO_WEATHER_OPE_AEZ
1.5 CMETEO_WEATHER_OPE_GRID
1.6 CMETEO_WEATHER_OPE_REGION




CMETEO_WEATHER_HIS_AEZ

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


CMETEO_WEATHER_HIS_GRID

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


CMETEO_WEATHER_HIS_REGION

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


CMETEO_WEATHER_OPE_AEZ

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


CMETEO_WEATHER_OPE_GRID

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


CMETEO_WEATHER_OPE_REGION

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


SIMYIELD-datasets

content
2.1 SIMYIELD_ENSEXT_EMU
2.2 SIMYIELD_ENSEXT_GRID
2.3 SIMYIELD_ENSEXT_REGION
2.4 SIMYIELD_ENSEXT_STU
2.5 SIMYIELD_ENS_EMU
2.6 SIMYIELD_ENS_GRID
2.7 SIMYIELD_ENS_REGION
2.8 SIMYIELD_ENS_STU
2.9 SIMYIELD_SEAS_EMU
2.10 SIMYIELD_SEAS_GRID
2.11 SIMYIELD_SEAS_REGION
2.12 SIMYIELD_SEAS_STU
2.13 SIMYIELD_STU_EPS
2.14 SIMYIELD_STU_MON
2.15 SIMYIELD_STU_SEA




SIMYIELD_ENSEXT_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_ENSEXT_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_ENSEXT_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_ENSEXT_STU

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


SIMYIELD_ENS_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_ENS_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_ENS_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_ENS_STU

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


SIMYIELD_SEAS_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_SEAS_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: Table
  • Remarks: This table contains aggregated simulation results for all PROXY's in STAT_CROP.


SIMYIELD_SEAS_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_SEAS_STU

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


SIMYIELD_STU_EPS

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


SIMYIELD_STU_MON

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


SIMYIELD_STU_SEA

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


WEATHER-datasets

content
3.1 WEATHER_ENSEXT_GRID
3.2 WEATHER_ENS_GRID
3.3 WEATHER_EPS_GRID_FOR_BIOMA
3.4 WEATHER_ERA_GRID
3.5 WEATHER_ERA_GRID_EXPORT
3.6 WEATHER_HIS_AEZ
3.7 WEATHER_HIS_AEZ_LTA
3.8 WEATHER_HIS_GRID
3.9 WEATHER_HIS_GRID_EXPORT
3.10 WEATHER_HIS_GRID_FOR_BIOMA
3.11 WEATHER_HIS_GRID_LTA
3.12 WEATHER_HIS_REGION
3.13 WEATHER_HIS_REGION_LTA
3.14 WEATHER_OPE_AEZ
3.15 WEATHER_OPE_GRID
3.16 WEATHER_OPE_REGION
3.17 WEATHER_SEAS_GRID
3.18 WEATHER_SEA_GRID_FOR_EXPORT




WEATHER_ENSEXT_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_ENS_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_EPS_GRID_FOR_BIOMA

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


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_EXPORT

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


WEATHER_HIS_AEZ

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


WEATHER_HIS_AEZ_LTA

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


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_GRID_EXPORT

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


WEATHER_HIS_GRID_FOR_BIOMA

  • Description:
  • Use:
  • Type: View
  • 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: Table
  • Remarks: Long term average is only available for the HIS model (see forecasted weather).


WEATHER_HIS_REGION

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


WEATHER_HIS_REGION_LTA

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


WEATHER_OPE_AEZ

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


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_REGION

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


WEATHER_SEAS_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_SEA_GRID_FOR_EXPORT

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


other datasets

content
4.1 DATES_75_15
4.2 GRIDS
4.3 GRIDS_FOR_BIOMA
4.4 SYSTABLES
4.5 TASKS




DATES_75_15

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


GRIDS

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


GRIDS_FOR_BIOMA

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


SYSTABLES

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


TASKS

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


synonyms

content
5.1 AEZ
5.2 AGGREGATION_AREAS
5.3 CMETEO_ADMIN
5.4 CMETEO_AEZ_GRID_LANDCOVERS
5.5 CMETEO_AGGREGATION_AREAS
5.6 CMETEO_CROPS
5.7 CMETEO_GRID_LANDCOVER_AREAS
5.8 CMETEO_GRID_WEATHER
5.9 CMETEO_LANDCOVERS
5.10 CMETEO_PROCESS
5.11 CMETEO_REGIONS
5.12 CMETEO_REGION_GRID_LANDCOVERS
5.13 CMETEO_REGION_MAPPINGS
5.14 CMETEO_REGION_WEATHER
5.15 CMETEO_REJECTED_WEATHER
5.16 CROP
5.17 CROP_LANDCOVER
5.18 DATELIST
5.19 DAY_DECADEYEAR
5.20 EMU
5.21 LINK_EMU_REGION_LANDCOVER
5.22 LINK_REGION_GRID_LANDCOVER
5.23 REGION
5.24 REGION_INFO
5.25 REGION_MAPPINGS
5.26 REGLISTS
5.27 SMU_SUITABILITY
5.28 SOIL_ASSOCIATION_COMPOSITION
5.29 STAT_CROP
5.30 SUITABILITY
5.31 TD_THRESHOLD_VALUE
5.32 TD_THRESHOLD_VALUES




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: Synonym ➞ AGGREGATION@AREAS_CGMS12EU
  • Remarks: none

* 'SOURCE' can have the following values:

  • based on EUROSTAT
    • EUROSTAT CROPUSE for crops 1,2,3,4,5,6,7,8,9,10,11,12,76,77
    • EUROSTAT LANDUSE for crop 50
  • based on EMU_PLUS_NUTS_LANDCOVER
    • CGMS LANDCOVER for crop 51
    • LANDCOVER where EUROSTAT is not available and land cover area > 0
    • EMU_PLUS_NUTS where EUROSTAT is not available and land cover area = 0 (set to zero)


CMETEO_ADMIN

  • Description: synonym to oracle package
  • Use:
  • Type: Synonym ➞ CMETEO@ADMIN_EURMAN
  • 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: Synonym ➞ CMETEO@AEZ_GRID_LANDCOVERS_CGMS12EU
  • 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: Synonym ➞ CMETEO@AGGREGATION_AREAS_CGMS12EU
  • Remarks: none

* All attributes Nullable in table versions ** Not in view, only in table


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 ➞ CMETEO@CROPS_CGMS12EU
  • 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 ➞ CMETEO@REGION_GRID_LANDCOVERS_CGMS12EU
  • Remarks: none



CMETEO_GRID_WEATHER

  • Description: weather indicators per grid
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: Synonym ➞ CMETEO@WEATHER_OPE_GRID_CGFS14EU
  • Remarks:

* All attributes Nullable in table versions


CMETEO_LANDCOVERS

  • Description: List of landcovers or crops to be evaluated in CMETEO
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: Synonym ➞ CMETEO@LANDCOVERS_CGMS12EU
  • Remarks:

* All attributes Nullable in table versions


CMETEO_PROCESS

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




CMETEO_REGIONS

  • Description:
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: Synonym ➞ CMETEO@REGIONS_EURMAN
  • 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: Synonym ➞ CMETEO@REGION_GRID_LANDCOVERS_CGMS12EU
  • Remarks: user defined, derived from GIS



CMETEO_REGION_MAPPINGS

  • Description: regions and their relations (mappings)
  • Use: input for cmeteo
  • Type: Synonym ➞ CMETEO@REGION_MAPPINGS_EURMAN
  • Remarks:



CMETEO_REGION_WEATHER

  • Description: weather indicators per region
  • Use: input for cmeteo, renaming columns to a standardized naming
  • Type: Synonym ➞ CMETEO@WEATHER_OPE_REGION_CGFS14EU
  • Remarks:



CMETEO_REJECTED_WEATHER

  • Description: rejected weather
  • Use: log table for cmeteo
  • Type: Synonym ➞ CMETEO@REJECTED_WEATHER_EURMAN
  • Remarks:



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: Synonym ➞ CROP@_CGMS12EU
  • 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_NO in
1,2,3,4,6,7,8,10,11,12,13,41,43,46,50,51 ** LANDCOVER_ID values:

  • 101 Arable Land
  • 102 Non-irrigated arable land
  • 103 Agricultural areas
  • 104 Pasture
  • 105 Temporary forage
  • 106 Rice


CROP_LANDCOVER

  • Description: List of crop and landcovers
  • Use: source for various views & synonyms
  • Type: Synonym ➞ CROP@LANDCOVER_CGMS12EU
  • Remarks:



DATELIST

  • Description:
  • Use:
  • Type: Synonym ➞ DATELIST@_EURMAN
  • Remarks:



DAY_DECADEYEAR

  • Description: synonym to oracle package
  • Use: view on DATE_GENERATOR package
  • Type: Synonym ➞ DAY@DECADEYEAR_EURMAN
  • Remarks: none



EMU

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



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: Synonym ➞ LINK@EMU_REGION_LANDCOVER_CGMS12EU
  • Remarks:



LINK_REGION_GRID_LANDCOVER

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



REGION

  • Description: Administrative regions
  • Use: input for monitoring extreme weather events
  • Type: Synonym ➞ REGION@_CGMS12EU
  • Remarks:

* According to the 'NUTS' nomenclature (see Administrative_regions).


REGION_INFO

  • Description:
  • Use:
  • Type: Synonym ➞ REGION@INFO_EURMAN
  • Remarks:



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

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


REGLISTS

  • Description: synonym to oracle package
  • Use: link to REGLISTS
  • Type: Synonym ➞ REGLISTS@_EURMAN
  • Remarks: none




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: Synonym ➞ SMU@SUITABILITY_CGMS12EU
  • 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: Synonym ➞ SOIL@ASSOCIATION_COMPOSITION_CGMS12EU
  • Remarks: derived from the soil map



STAT_CROP

  • Description:
  • Use:
  • Type: Synonym ➞ STAT@CROP_CGMS12EU
  • Remarks:



SUITABILITY

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



TD_THRESHOLD_VALUE

  • Description:
  • Use:
  • Type: Synonym ➞ TD@THRESHOLD_VALUE_EURMAN
  • Remarks:



TD_THRESHOLD_VALUES

  • Description:
  • Use:
  • Type: Synonym ➞ TD@THRESHOLD_VALUES_EURMAN
  • Remarks: