Difference between revisions of "Appendix 5: Database objects/GWSI E 12"

From Agri4castWiki
Jump to: navigation, search
(generated page)
 
(generated page)
Line 1: Line 1:
 +
 +
{{expert}}
 
__NOTOC__
 
__NOTOC__
 
{{TocTable|content=
 
{{TocTable|content=
Line 10: Line 12:
 
{{TocRow|#synonyms|8. synonyms}}
 
{{TocRow|#synonyms|8. synonyms}}
 
}}
 
}}
 +
 +
  
  
Line 17: Line 21:
 
{{TocRow|#ACTUAL_CALENDARS_LTA|1.2 ACTUAL_CALENDARS_LTA}}
 
{{TocRow|#ACTUAL_CALENDARS_LTA|1.2 ACTUAL_CALENDARS_LTA}}
 
}}
 
}}
 +
 +
  
  
Line 60: Line 66:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 94: Line 102:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== CROP-datasets ==
 
== CROP-datasets ==
Line 101: Line 111:
 
{{TocRow|#CROP_TEMP_COEFFICIENTS|2.3 CROP_TEMP_COEFFICIENTS}}
 
{{TocRow|#CROP_TEMP_COEFFICIENTS|2.3 CROP_TEMP_COEFFICIENTS}}
 
}}
 
}}
 +
 +
  
  
Line 170: Line 182:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 194: Line 208:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 216: Line 232:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== GRID-datasets ==
 
== GRID-datasets ==
Line 237: Line 255:
 
{{TocRow|#GRID_WEATHER_MODEL_10_LTA|3.17 GRID_WEATHER_MODEL_10_LTA}}
 
{{TocRow|#GRID_WEATHER_MODEL_10_LTA|3.17 GRID_WEATHER_MODEL_10_LTA}}
 
}}
 
}}
 +
 +
  
  
Line 316: Line 336:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 365: Line 387:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 405: Line 429:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 431: Line 457:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 459: Line 487:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 497: Line 527:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 527: Line 559:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 559: Line 593:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 581: Line 617:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 603: Line 641:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 633: Line 673:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 657: Line 699:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 693: Line 737:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 729: Line 775:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 765: Line 813:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 803: Line 853:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 907: Line 959:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== REGION-datasets ==
 
== REGION-datasets ==
Line 913: Line 967:
 
{{TocRow|#REGION_WEATHER_MODEL_10_LTA|4.2 REGION_WEATHER_MODEL_10_LTA}}
 
{{TocRow|#REGION_WEATHER_MODEL_10_LTA|4.2 REGION_WEATHER_MODEL_10_LTA}}
 
}}
 
}}
 +
 +
  
  
Line 954: Line 1,010:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,060: Line 1,118:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== SOIL-datasets ==
 
== SOIL-datasets ==
Line 1,066: Line 1,126:
 
{{TocRow|#SOIL_TYPES|5.2 SOIL_TYPES}}
 
{{TocRow|#SOIL_TYPES|5.2 SOIL_TYPES}}
 
}}
 
}}
 +
 +
  
  
Line 1,085: Line 1,147:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,113: Line 1,177:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== UNITS-datasets ==
 
== UNITS-datasets ==
Line 1,122: Line 1,188:
 
{{TocRow|#UNITS_CALC_STATUS_LTA|6.5 UNITS_CALC_STATUS_LTA}}
 
{{TocRow|#UNITS_CALC_STATUS_LTA|6.5 UNITS_CALC_STATUS_LTA}}
 
}}
 
}}
 +
 +
  
  
Line 1,145: Line 1,213:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,195: Line 1,265:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,245: Line 1,317:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,281: Line 1,355:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,311: Line 1,387:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== other datasets ==
 
== other datasets ==
 
{{TocTable|content=
 
{{TocTable|content=
 
{{TocRow|#CROPS|7.1 CROPS}}
 
{{TocRow|#CROPS|7.1 CROPS}}
{{TocRow|#GRID|7.2 GRID}}
+
{{TocRow|#DAY_DECADEYEAR|7.2 DAY_DECADEYEAR}}
{{TocRow|#REGIONS|7.3 REGIONS}}
+
{{TocRow|#GRID|7.3 GRID}}
{{TocRow|#SYSTABLES|7.4 SYSTABLES}}
+
{{TocRow|#MAX_FAO|7.4 MAX_FAO}}
{{TocRow|#TASKS|7.5 TASKS}}
+
{{TocRow|#REGIONS|7.5 REGIONS}}
{{TocRow|#DAY_DECADEYEAR|7.6 DAY_DECADEYEAR}}
+
{{TocRow|#SYSTABLES|7.6 SYSTABLES}}
{{TocRow|#MAX_FAO|7.7 MAX_FAO}}
+
{{TocRow|#TASKS|7.7 TASKS}}
 
}}
 
}}
 +
 +
  
  
Line 1,349: Line 1,429:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,374: Line 1,456:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,403: Line 1,487:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,425: Line 1,511:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,455: Line 1,543:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,478: Line 1,568:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
<!-- start -->
 
<!-- start -->
Line 1,507: Line 1,599:
 
|}
 
|}
 
<!-- end -->
 
<!-- end -->
 +
 +
  
 
== synonyms ==
 
== synonyms ==
Line 1,517: Line 1,611:
  
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== DATELIST ===
 
=== DATELIST ===
Line 1,524: Line 1,620:
 
<!-- end -->
 
<!-- end -->
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== REGION_INFO ===
 
=== REGION_INFO ===
Line 1,531: Line 1,629:
 
<!-- end -->
 
<!-- end -->
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== REGION_MAPPINGS ===
 
=== REGION_MAPPINGS ===
Line 1,541: Line 1,641:
 
<!-- end -->
 
<!-- end -->
  
 +
 +
   
 
<!-- start -->
 
<!-- start -->
 
=== REGLISTS ===
 
=== REGLISTS ===

Revision as of 21:29, 28 January 2016




content
1. ACTUAL-datasets
2. CROP-datasets
3. GRID-datasets
4. REGION-datasets
5. SOIL-datasets
6. UNITS-datasets
7. other datasets
8. synonyms




ACTUAL-datasets

content
1.1 ACTUAL_CALENDARS
1.2 ACTUAL_CALENDARS_LTA




ACTUAL_CALENDARS

Table.


ACTUAL_CALENDARS_LTA

Table.


CROP-datasets

content
2.1 CROP_CALENDARS
2.2 CROP_COEFFICIENTS
2.3 CROP_TEMP_COEFFICIENTS




CROP_CALENDARS

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_COEFFICIENTS

Table.


CROP_TEMP_COEFFICIENTS

Table.


GRID-datasets

content
3.1 GRID_CLIMATE_SEASONS
3.2 GRID_CLIMATE_SEASONS_CROP_MASK
3.3 GRID_CROPMASKS
3.4 GRID_CUMETA_DUR1
3.5 GRID_CUMETA_LTA
3.6 GRID_CUMETA_LTA_ADJ
3.7 GRID_CUMETA_TIMESERIES
3.8 GRID_FULL
3.9 GRID_FULLXUNITS
3.10 GRID_FULLXUNITS_JOINOPT
3.11 GRID_INI_SEASONS
3.12 GRID_REGION_LANDCOVERS
3.13 GRID_THRESHOLDS_1
3.14 GRID_THRESHOLDS_2
3.15 GRID_THRESHOLDS_3
3.16 GRID_WEATHER_MODEL_10
3.17 GRID_WEATHER_MODEL_10_LTA




GRID_CLIMATE_SEASONS

Table.


GRID_CLIMATE_SEASONS_CROP_MASK

View.


GRID_CROPMASKS

Table.


GRID_CUMETA_DUR1

Table.


GRID_CUMETA_LTA

Table.


GRID_CUMETA_LTA_ADJ

View.


GRID_CUMETA_TIMESERIES

Table.


GRID_FULL

Table.


GRID_FULLXUNITS

Table.


GRID_FULLXUNITS_JOINOPT

Table.


GRID_INI_SEASONS

Table.


GRID_REGION_LANDCOVERS

Table.


GRID_THRESHOLDS_1

Table.


GRID_THRESHOLDS_2

Table.


GRID_THRESHOLDS_3

Table.


GRID_WEATHER_MODEL_10

Table.


GRID_WEATHER_MODEL_10_LTA

Table.


REGION-datasets

content
4.1 REGION_WEATHER_MODEL_10
4.2 REGION_WEATHER_MODEL_10_LTA




REGION_WEATHER_MODEL_10

Table.


REGION_WEATHER_MODEL_10_LTA

Table.


SOIL-datasets

content
5.1 SOIL_MAP_UNITS
5.2 SOIL_TYPES




SOIL_MAP_UNITS

Table.


SOIL_TYPES

Table.


UNITS-datasets

content
6.1 UNITS_CALC_INPUT
6.2 UNITS_CALC_OUTPUT
6.3 UNITS_CALC_OUTPUT_LTA
6.4 UNITS_CALC_STATUS
6.5 UNITS_CALC_STATUS_LTA




UNITS_CALC_INPUT

Table.


UNITS_CALC_OUTPUT

Table.


UNITS_CALC_OUTPUT_LTA

Table.


UNITS_CALC_STATUS

Table.


UNITS_CALC_STATUS_LTA

Table.


other datasets

content
7.1 CROPS
7.2 DAY_DECADEYEAR
7.3 GRID
7.4 MAX_FAO
7.5 REGIONS
7.6 SYSTABLES
7.7 TASKS




CROPS

Table.


DAY_DECADEYEAR

Table.

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


GRID

Table.

  • 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


MAX_FAO

Table.


REGIONS

Table.


SYSTABLES

Table.

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


TASKS

Table.

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


synonyms

content
8.1 DATELIST
8.2 REGION_INFO
8.3 REGION_MAPPINGS
8.4 REGLISTS




DATELIST

Synonym ➞ DATELIST@_WSIMAN.



REGION_INFO

Synonym ➞ REGION@INFO_WSIMAN.



REGION_MAPPINGS

Synonym ➞ REGION@MAPPINGS_WSIMAN.

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


REGLISTS

Synonym ➞ REGLISTS@_WSIMAN.

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