Difference between revisions of "Appendix 5: Database objects/GWSI E 12"
From Agri4castWiki
Wimdewinter (talk | contribs) (generated page) |
Wimdewinter (talk | contribs) |
||
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 === | ||
− | + | * 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: | + | * 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 === | ||
− | + | * 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: | + | * 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 === | ||
− | + | * 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: | + | * 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 === | ||
− | + | * Description: | |
− | *Description: | + | * Use: |
− | *Use: | + | * Type: ''Table'' |
− | *Type: | + | * Remarks: |
− | *Remarks: | ||
{|class="collapsing_table collapsible collapsed" | {|class="collapsing_table collapsible collapsed" | ||
!Structure | !Structure | ||
Line 1,573: | Line 1,636: | ||
<!-- start --> | <!-- start --> | ||
=== TASKS === | === TASKS === | ||
− | + | * Description: | |
− | *Description: | + | * Use: |
− | *Use: | + | * Type: ''Table'' |
− | *Type: | + | * 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 ➞ DATELIST@_WSIMAN'' | + | * Description: |
− | + | * Use: | |
+ | * Type: ''Synonym ➞ DATELIST@_WSIMAN'' | ||
+ | * Remarks: | ||
<!-- end --> | <!-- end --> | ||
Line 1,624: | Line 1,688: | ||
<!-- start --> | <!-- start --> | ||
=== REGION_INFO === | === REGION_INFO === | ||
− | ''Synonym ➞ REGION@INFO_WSIMAN'' | + | * Description: |
− | + | * Use: | |
+ | * Type: ''Synonym ➞ REGION@INFO_WSIMAN'' | ||
+ | * Remarks: | ||
<!-- end --> | <!-- end --> | ||
Line 1,633: | Line 1,699: | ||
<!-- start --> | <!-- start --> | ||
=== REGION_MAPPINGS === | === REGION_MAPPINGS === | ||
− | + | * 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 ➞ REGION@MAPPINGS_WSIMAN'' |
− | *Type: | + | * 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 === | ||
− | + | * Description: synonym to oracle package | |
− | *Description: synonym to oracle package | + | * Use: link to [[REGLISTS]] |
− | *Use: link to [[REGLISTS]] | + | * Type: ''Synonym ➞ REGLISTS@_WSIMAN'' |
− | *Type: | + | * 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:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ACTUAL_CALENDARS_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see Spatial/temporal variation category). |
CROP_COEFFICIENTS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CROP_TEMP_COEFFICIENTS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID-datasets
GRID_CLIMATE_SEASONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_CLIMATE_SEASONS_CROP_MASK
- Description:
- Use:
- Type: View
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
select gs.grid_id ,gs.crop_id ,gs.nr_of_seasons as season_cnt ,case when gs.start1 > 0 then 1 else 0 end as season_1 ,case when gs.start2 > 0 then 1 else 0 end as season_2 ,case when gs.start3 > 0 then 1 else 0 end as season_3 from grid_cropmasks gc ,grid_climate_seasons gs where (gc.wheat = 1 and gs.crop_id = 1 and gs.grid_id = gc.grid_id) or (gc.maize = 1 and gs.crop_id = 2 and gs.grid_id = gc.grid_id) or (gc.barley = 1 and gs.crop_id = 3 and gs.grid_id = gc.grid_id) or (gc.rice = 1 and gs.crop_id = 5 and gs.grid_id = gc.grid_id) or (gc.potato = 1 and gs.crop_id = 7 and gs.grid_id = gc.grid_id) or (gc.beans = 1 and gs.crop_id = 8 and gs.grid_id = gc.grid_id) or (gc.soybean = 1 and gs.crop_id = 9 and gs.grid_id = gc.grid_id) or (gc.sorghum = 1 and gs.crop_id = 30 and gs.grid_id = gc.grid_id) or (gc.groundnut = 1 and gs.crop_id = 31 and gs.grid_id = gc.grid_id) or (gc.millet = 1 and gs.crop_id = 32 and gs.grid_id = gc.grid_id) or (gc.pulses = 1 and gs.crop_id = 33 and gs.grid_id = gc.grid_id) |
GRID_CROPMASKS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_CUMETA_DUR1
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_CUMETA_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_CUMETA_LTA_ADJ
- Description:
- Use:
- Type: View
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT GRID_ID , CROP_ID , DEKAD_IN_YEAR , DURATION , -- (case when isvalidstart = 100 then cumeta else 0 end) cumeta , cumeta , ISVALIDSTART FROM GRID_CUMETA_LTA |
GRID_CUMETA_TIMESERIES
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_FULL
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_FULLXUNITS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_FULLXUNITS_JOINOPT
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_INI_SEASONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_REGION_LANDCOVERS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_THRESHOLDS_1
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_THRESHOLDS_2
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_THRESHOLDS_3
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_WEATHER_MODEL_10
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
GRID_WEATHER_MODEL_10_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
REGION_WEATHER_MODEL_10_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SOIL-datasets
content |
---|
5.1 SOIL_MAP_UNITS |
5.2 SOIL_TYPES |
SOIL_MAP_UNITS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
SOIL_TYPES
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
UNITS_CALC_OUTPUT
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
UNITS_CALC_OUTPUT_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
UNITS_CALC_STATUS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
UNITS_CALC_STATUS_LTA
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
Structure | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
DAY_DECADEYEAR
- Description: synonym to oracle package
- Use: view on DATE_GENERATOR package
- Type: Table
- Remarks: none
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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
Structure | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
* Not a simple average (see 'Similarity score' in paragraph Qualification of weather stations). |
MAX_FAO
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
REGIONS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SYSTABLES
- Description:
- Use:
- Type: Table
- Remarks:
Structure | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
TASKS
- Description:
- Use:
- Type: Table
- Remarks:
Structure | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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