Appendix 5: Database objects/CGMS14GLO

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



content
1. GRID-datasets
2. LINK-datasets
3. WEATHER-datasets
4. other datasets
5. synonyms




GRID-datasets

content
1.1 GRID_ENS
1.2 GRID_ENSEXT
1.3 GRID_ENSEXT_DOWN_ALGORITHMS
1.4 GRID_ENS_DOWN_ALGORITHMS
1.5 GRID_ENS_DOWN_ALGORITHMS_RAW
1.6 GRID_ERA
1.7 GRID_ERA_DOWN_ALGORITHMS
1.8 GRID_HIS
1.9 GRID_MAPPING
1.10 GRID_SEAS
1.11 GRID_SEAS_DOWN_ALGORITHMS
1.12 GRID_SEAS_DOWN_ALGORITHMS_RAW
1.13 GRID_SENEGAL




GRID_ENS

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


GRID_ENSEXT

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


GRID_ENSEXT_DOWN_ALGORITHMS

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


GRID_ENS_DOWN_ALGORITHMS

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


GRID_ENS_DOWN_ALGORITHMS_RAW

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


GRID_ERA

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


GRID_ERA_DOWN_ALGORITHMS

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


GRID_HIS

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


GRID_MAPPING

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


GRID_SEAS

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


GRID_SEAS_DOWN_ALGORITHMS

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


GRID_SEAS_DOWN_ALGORITHMS_RAW

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


GRID_SENEGAL

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


LINK-datasets

content
2.1 LINK_GRID_COVER
2.2 LINK_GRID_REGION_COVER
2.3 LINK_REGION_COVER




LINK_GRID_COVER

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


LINK_GRID_REGION_COVER

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


LINK_REGION_COVER

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


WEATHER-datasets

content
3.1 WEATHER_ENSEXT_GRID
3.2 WEATHER_ENSEXT_GRID_RAW
3.3 WEATHER_ENSEXT_REGIONCOVER
3.4 WEATHER_ENS_GRID
3.5 WEATHER_ENS_GRID_RAW
3.6 WEATHER_ENS_REGIONCOVER
3.7 WEATHER_ERA_GRID
3.8 WEATHER_ERA_GRID_LTA
3.9 WEATHER_ERA_GRID_RAW
3.10 WEATHER_ERA_REGIONCOVER
3.11 WEATHER_HIS_GRID
3.12 WEATHER_HIS_REGCOV_THRESHOLDS
3.13 WEATHER_HIS_REGIONCOVER
3.14 WEATHER_HIS_SENEGAL_AGRICAB
3.15 WEATHER_OPE_GRID
3.16 WEATHER_OPE_REGIONCOVER
3.17 WEATHER_SEAS_GRID
3.18 WEATHER_SEAS_GRID_RAW
3.19 WEATHER_SEAS_REGIONCOVER




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

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


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

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

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


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

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


WEATHER_HIS_GRID

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


WEATHER_HIS_REGCOV_THRESHOLDS

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


WEATHER_HIS_REGIONCOVER

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


WEATHER_HIS_SENEGAL_AGRICAB

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


WEATHER_OPE_GRID

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


WEATHER_OPE_REGIONCOVER

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


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

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


other datasets

content
4.1 DATES_75_15
4.2 GLOBAL_REGION_ELEMENTS
4.3 REGIONS
4.4 SYSTABLES




DATES_75_15

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


GLOBAL_REGION_ELEMENTS

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


REGIONS

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


SYSTABLES

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


synonyms

content
5.1 GRID_OPE
5.2 LOG




GRID_OPE

  • Description:
  • Use:
  • Type: Synonym ➞ GRID@HIS_CGMS14GLO
  • Remarks:



LOG

  • Description:
  • Use:
  • Type: Synonym ➞ LOG@_None
  • Remarks: