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

From Agri4castWiki
Jump to: navigation, search
(generated page)
 
Line 1: Line 1:
 +
  
 
{{expert}}
 
{{expert}}
Line 27: Line 28:
 
<!-- start -->
 
<!-- start -->
 
=== ACTUAL_CALENDARS ===
 
=== ACTUAL_CALENDARS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 71: Line 74:
 
<!-- start -->
 
<!-- start -->
 
=== ACTUAL_CALENDARS_LTA ===
 
=== ACTUAL_CALENDARS_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 117: Line 122:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_CALENDARS ===
 
=== CROP_CALENDARS ===
''Table''.
+
* Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
*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
*Use: determines which crops are simulated for a grid, and simulation period
+
* Type: ''Table''
*Type: Permanent table
+
* Remarks: user defined, one of the ‘driving’ tables of the system
*Remarks: user defined, one of the ‘driving’ tables of the system
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 187: Line 191:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_COEFFICIENTS ===
 
=== CROP_COEFFICIENTS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 213: Line 219:
 
<!-- start -->
 
<!-- start -->
 
=== CROP_TEMP_COEFFICIENTS ===
 
=== CROP_TEMP_COEFFICIENTS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 261: Line 269:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CLIMATE_SEASONS ===
 
=== GRID_CLIMATE_SEASONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 341: Line 351:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CLIMATE_SEASONS_CROP_MASK ===
 
=== GRID_CLIMATE_SEASONS_CROP_MASK ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 392: Line 404:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CROPMASKS ===
 
=== GRID_CROPMASKS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 434: Line 448:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CUMETA_DUR1 ===
 
=== GRID_CUMETA_DUR1 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 462: Line 478:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CUMETA_LTA ===
 
=== GRID_CUMETA_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 492: Line 510:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CUMETA_LTA_ADJ ===
 
=== GRID_CUMETA_LTA_ADJ ===
''View''.
+
* Description:
 
+
* Use:
 +
* Type: ''View''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 532: Line 552:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_CUMETA_TIMESERIES ===
 
=== GRID_CUMETA_TIMESERIES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 564: Line 586:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_FULL ===
 
=== GRID_FULL ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 598: Line 622:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_FULLXUNITS ===
 
=== GRID_FULLXUNITS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 622: Line 648:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_FULLXUNITS_JOINOPT ===
 
=== GRID_FULLXUNITS_JOINOPT ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 646: Line 674:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_INI_SEASONS ===
 
=== GRID_INI_SEASONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 678: Line 708:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_REGION_LANDCOVERS ===
 
=== GRID_REGION_LANDCOVERS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 704: Line 736:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_THRESHOLDS_1 ===
 
=== GRID_THRESHOLDS_1 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 742: Line 776:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_THRESHOLDS_2 ===
 
=== GRID_THRESHOLDS_2 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 780: Line 816:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_THRESHOLDS_3 ===
 
=== GRID_THRESHOLDS_3 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 818: Line 856:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_WEATHER_MODEL_10 ===
 
=== GRID_WEATHER_MODEL_10 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 858: Line 898:
 
<!-- start -->
 
<!-- start -->
 
=== GRID_WEATHER_MODEL_10_LTA ===
 
=== GRID_WEATHER_MODEL_10_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 973: Line 1,015:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_WEATHER_MODEL_10 ===
 
=== REGION_WEATHER_MODEL_10 ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,015: Line 1,059:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_WEATHER_MODEL_10_LTA ===
 
=== REGION_WEATHER_MODEL_10_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,132: Line 1,178:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_MAP_UNITS ===
 
=== SOIL_MAP_UNITS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,152: Line 1,200:
 
<!-- start -->
 
<!-- start -->
 
=== SOIL_TYPES ===
 
=== SOIL_TYPES ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,194: Line 1,244:
 
<!-- start -->
 
<!-- start -->
 
=== UNITS_CALC_INPUT ===
 
=== UNITS_CALC_INPUT ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,218: Line 1,270:
 
<!-- start -->
 
<!-- start -->
 
=== UNITS_CALC_OUTPUT ===
 
=== UNITS_CALC_OUTPUT ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,270: Line 1,324:
 
<!-- start -->
 
<!-- start -->
 
=== UNITS_CALC_OUTPUT_LTA ===
 
=== UNITS_CALC_OUTPUT_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,322: Line 1,378:
 
<!-- start -->
 
<!-- start -->
 
=== UNITS_CALC_STATUS ===
 
=== UNITS_CALC_STATUS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,360: Line 1,418:
 
<!-- start -->
 
<!-- start -->
 
=== UNITS_CALC_STATUS_LTA ===
 
=== UNITS_CALC_STATUS_LTA ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,406: Line 1,466:
 
<!-- start -->
 
<!-- start -->
 
=== CROPS ===
 
=== CROPS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,434: Line 1,496:
 
<!-- start -->
 
<!-- start -->
 
=== DAY_DECADEYEAR ===
 
=== DAY_DECADEYEAR ===
''Table''.
+
* Description: synonym to oracle package
*Description: synonym to oracle package
+
* Use: view on [[DATE_GENERATOR]] package
*Use: view on [[DATE_GENERATOR]] package
+
* Type: ''Table''
*Type: synonym on FORALL.DAY_DECADEYEAR
+
* Remarks: none
*Remarks: none
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,461: Line 1,522:
 
<!-- start -->
 
<!-- start -->
 
=== GRID ===
 
=== 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.
*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
*Use: input/reference table for both level 1 and level 2
+
* Type: ''Table''
*Type: permanent table
+
* Remarks: user defined, derived from GIS, provides the link to the GIS
*Remarks: user defined, derived from GIS, provides the link to the GIS
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,492: Line 1,552:
 
<!-- start -->
 
<!-- start -->
 
=== MAX_FAO ===
 
=== MAX_FAO ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,516: Line 1,578:
 
<!-- start -->
 
<!-- start -->
 
=== REGIONS ===
 
=== REGIONS ===
''Table''.
+
* Description:
 
+
* Use:
 +
* Type: ''Table''
 +
* Remarks:
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,548: Line 1,612:
 
<!-- start -->
 
<!-- start -->
 
=== SYSTABLES ===
 
=== SYSTABLES ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,573: Line 1,636:
 
<!-- start -->
 
<!-- start -->
 
=== TASKS ===
 
=== TASKS ===
''Table''.
+
* Description:  
*Description:  
+
* Use:  
*Use:  
+
* Type: ''Table''
*Type: permanent table
+
* Remarks:  
*Remarks:
 
 
{|class="collapsing_table collapsible collapsed"
 
{|class="collapsing_table collapsible collapsed"
 
!Structure
 
!Structure
Line 1,615: Line 1,677:
 
<!-- start -->
 
<!-- start -->
 
=== DATELIST ===
 
=== DATELIST ===
''Synonym &#x279e; DATELIST@_WSIMAN''.
+
* Description:
 
+
* Use:
 +
* Type: ''Synonym &#x279e; DATELIST@_WSIMAN''
 +
* Remarks:
  
 
<!-- end -->
 
<!-- end -->
Line 1,624: Line 1,688:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_INFO ===
 
=== REGION_INFO ===
''Synonym &#x279e; REGION@INFO_WSIMAN''.
+
* Description:
 
+
* Use:
 +
* Type: ''Synonym &#x279e; REGION@INFO_WSIMAN''
 +
* Remarks:
  
 
<!-- end -->
 
<!-- end -->
Line 1,633: Line 1,699:
 
<!-- start -->
 
<!-- start -->
 
=== REGION_MAPPINGS ===
 
=== REGION_MAPPINGS ===
''Synonym &#x279e; REGION@MAPPINGS_WSIMAN''.
+
* Description: regions and their relations (mappings)
*Description: regions and their relations (mappings)
+
* Use: used by many object to find relation between regions of different levels.
*Use: used by many object to find relation between regions of different levels.
+
* Type: ''Synonym &#x279e; REGION@MAPPINGS_WSIMAN''
*Type: synonyms on forall.region_mappings_eur
+
* Remarks: none
*Remarks: none
 
 
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}.
 
<nowiki>*</nowiki> When defined the values overwrite XMIN, XMAX, YMIN, YMAX and SRS_CODE in table {{Object|REGION_DESCRIPTIONS}}.
 
<!-- end -->
 
<!-- end -->
Line 1,645: Line 1,710:
 
<!-- start -->
 
<!-- start -->
 
=== REGLISTS ===
 
=== REGLISTS ===
''Synonym &#x279e; REGLISTS@_WSIMAN''.
+
* Description: synonym to oracle package
*Description: synonym to oracle package
+
* Use: link to [[REGLISTS]]
*Use: link to [[REGLISTS]]
+
* Type: ''Synonym &#x279e; REGLISTS@_WSIMAN''
*Type: synonym on forall.reglists
+
* Remarks: none
*Remarks: none
 
 
<br>
 
<br>
  
 
<!-- end -->
 
<!-- end -->

Latest revision as of 22:00, 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

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


ACTUAL_CALENDARS_LTA

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


CROP-datasets

content
2.1 CROP_CALENDARS
2.2 CROP_COEFFICIENTS
2.3 CROP_TEMP_COEFFICIENTS




CROP_CALENDARS

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


CROP_COEFFICIENTS

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


CROP_TEMP_COEFFICIENTS

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


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

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


GRID_CLIMATE_SEASONS_CROP_MASK

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


GRID_CROPMASKS

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


GRID_CUMETA_DUR1

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


GRID_CUMETA_LTA

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


GRID_CUMETA_LTA_ADJ

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


GRID_CUMETA_TIMESERIES

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


GRID_FULL

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


GRID_FULLXUNITS

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


GRID_FULLXUNITS_JOINOPT

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


GRID_INI_SEASONS

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


GRID_REGION_LANDCOVERS

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


GRID_THRESHOLDS_1

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


GRID_THRESHOLDS_2

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


GRID_THRESHOLDS_3

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


GRID_WEATHER_MODEL_10

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


GRID_WEATHER_MODEL_10_LTA

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


REGION-datasets

content
4.1 REGION_WEATHER_MODEL_10
4.2 REGION_WEATHER_MODEL_10_LTA




REGION_WEATHER_MODEL_10

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


REGION_WEATHER_MODEL_10_LTA

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


SOIL-datasets

content
5.1 SOIL_MAP_UNITS
5.2 SOIL_TYPES




SOIL_MAP_UNITS

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


SOIL_TYPES

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


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

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


UNITS_CALC_OUTPUT

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


UNITS_CALC_OUTPUT_LTA

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


UNITS_CALC_STATUS

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


UNITS_CALC_STATUS_LTA

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


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

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


DAY_DECADEYEAR

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


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


MAX_FAO

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


REGIONS

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


SYSTABLES

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


TASKS

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


synonyms

content
8.1 DATELIST
8.2 REGION_INFO
8.3 REGION_MAPPINGS
8.4 REGLISTS




DATELIST

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



REGION_INFO

  • Description:
  • Use:
  • Type: Synonym ➞ REGION@INFO_WSIMAN
  • 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_WSIMAN
  • 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@_WSIMAN
  • Remarks: none