Difference between revisions of "Appendix 5: Database objects"

From Agri4castWiki
Jump to: navigation, search
(renamed datasets)
(GWSI objects)
 
(6 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
{{Expert}}
 
{{Expert}}
  
 +
==Regional objects==
 +
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 
* [[{{BASEPAGENAME}}/CGMS14xxx|CGMS14xxx database objects]]
 
* [[{{BASEPAGENAME}}/CGMS14xxx|CGMS14xxx database objects]]
 +
* [[{{BASEPAGENAME}}/CGFS14EU |CGFS14EU  database objects]]
 +
* [[{{BASEPAGENAME}}/CGMS14GLO|CGMS14GLO database objects]]
 +
 +
==GWSI objects==
 +
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects (legacy)]]
 +
* [[{{BASEPAGENAME}}/GWSI_E_16|GWSI_E_16 database objects]]
 +
 +
==Shared objects==
 
* [[{{BASEPAGENAME}}/CGMS14SYS|CGMS14SYS database objects]]
 
* [[{{BASEPAGENAME}}/CGMS14SYS|CGMS14SYS database objects]]
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]<br>
 
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 
 
== renamed datasets ==
 
{| class='wikitable'
 
!old table name
 
!new table name
 
|-
 
| CROP_AGGREGATIONS || STAT_CROP
 
|-
 
| CROP_CALENDARS || CROP_CALENDAR
 
|-
 
| CROP_CALENDARS_OLD || ...
 
|-
 
| CROP_PARAMETRIZATIONS || ...
 
|-
 
| CROP_PARAMETRIZATION_PARAMETER || ...
 
|-
 
| CROP_REGIMES || ...
 
|-
 
| CROP_SPATIALIZATIONS || ...
 
|-
 
| CROP_SUITABILITY_RULES || ...
 
|-
 
| CROP_VARIETIES || ...
 
|-
 
| CROP_VARIETY_PARAMETERS || ...
 
|-
 
| CROP_VARIETY_PARAMETERS_OLD || ...
 
|-
 
| CROP_VARIETY_REGIMES || ...
 
|-
 
| DATES_75_15 || DATES_75_15
 
|-
 
| GLOBAL_CATEGORIES || ...
 
|-
 
| GLOBAL_COVERS || ...
 
|-
 
| GLOBAL_COVER_SOURCES || ...
 
|-
 
| GLOBAL_CROPS || ...
 
|-
 
| GLOBAL_CROP_PARAMETERS || ...
 
|-
 
| GLOBAL_GRIDS || ...
 
|-
 
| GLOBAL_GRID_SOURCES || ...
 
|-
 
| GLOBAL_LINK_COVERWINDOW_SOURCE || ...
 
|-
 
| GLOBAL_MODELS || ...
 
|-
 
| GLOBAL_REGIONS || ...
 
|-
 
| GLOBAL_REGION_ELEMENTS || ...
 
|-
 
| GLOBAL_REGION_SOURCES || ...
 
|-
 
| GLOBAL_SOIL_SOURCES || ...
 
|-
 
| GLOBAL_STATISTIC_SOURCES || ...
 
|-
 
| GLOBAL_SUITABILITY_PROPERTIES || ...
 
|-
 
| GLOBAL_THRESHOLDS || ...
 
|-
 
| GLOBAL_TIME_DIMENSIONS || ...
 
|-
 
| GLOBAL_TREATMENTS || ...
 
|-
 
| GLOBAL_WINDOWS || ...
 
|-
 
| GRIDS || ...
 
|-
 
| HRES_YEARS || ...
 
|-
 
| INTERPOLATION_PARAMETERS || ...
 
|-
 
| LINK_CROP_AGGREGATION || ...
 
|-
 
| LINK_CROP_CALENDARS || ...
 
|-
 
| LINK_CROP_PARAMETERS || ...
 
|-
 
| LINK_CROP_PARAMETERS_CROP || ...
 
|-
 
| LINK_CROP_PARAMETERS_MODEL || ...
 
|-
 
| LINK_CROP_PARAMETRIZATION || ...
 
|-
 
| LINK_CROP_SPATIALIZATIONS || ...
 
|-
 
| LINK_CROP_STU || ...
 
|-
 
| LINK_CROP_VARIETY_PARAMETERS || ...
 
|-
 
| LINK_GRID_COVER || ...
 
|-
 
| LINK_GRID_REGION_COVER || ...
 
|-
 
| LINK_REGION_COVER || ...
 
|-
 
| LINK_SIMULATION_UNIT || ...
 
|-
 
| LINK_SIMULATION_UNIT_CROP || ...
 
|-
 
| LINK_SMU_GRID_COVER || ...
 
|-
 
| LINK_SMU_GRID_REGION_COVER || ...
 
|-
 
| LINK_SMU_STU || ...
 
|-
 
| LINK_STU_HORIZONS || ...
 
|-
 
| LINK_STU_WEIGHTED_PARAMETERS || ...
 
|-
 
| LINK_SUITABILITY_RULES || ...
 
|-
 
| REGIONS || ...
 
|-
 
| SIM_BLAST_HRES_GRID || ...
 
|-
 
| SIM_BLAST_HRES_GRID_LTA || ...
 
|-
 
| SIM_BLAST_HRES_REGION || ...
 
|-
 
| SIM_BLAST_HRES_REGION_LTA || ...
 
|-
 
| SIM_WARM_HRES_GRID || ...
 
|-
 
| SIM_WARM_HRES_GRID_LTA || ...
 
|-
 
| SIM_WARM_HRES_REGION || ...
 
|-
 
| SIM_WARM_HRES_REGION_LTA || ...
 
|-
 
| SIM_WOFOST_HRES_EMU || ...
 
|-
 
| SIM_WOFOST_HRES_EMU_LTA || ...
 
|-
 
| SIM_WOFOST_HRES_GRID || ...
 
|-
 
| SIM_WOFOST_HRES_GRID_LTA || ...
 
|-
 
| SIM_WOFOST_HRES_REGION || ...
 
|-
 
| SIM_WOFOST_HRES_REGION_LTA || ...
 
|-
 
| SIM_WOFOST_HRES_STU || ...
 
|-
 
| SOIL_HORIZONS || ...
 
|-
 
| SOIL_INITIAL_WATER || ...
 
|-
 
| SOIL_SMU || ...
 
|-
 
| SOIL_STU || ...
 
|-
 
| STATIONS || ...
 
|-
 
| STAT_REGION_AREAS || ...
 
|-
 
| SYSTABLES || SYSTABLES
 
|-
 
| TASKS || TASKS
 
|-
 
| WEATHER_ERA_GRID || WEATHER_ERA_GRID
 
|-
 
| WEATHER_ERA_GRID_LTA || WEATHER_<MODEL>_GRID_LTA
 
|-
 
| WEATHER_ERA_REGIONCOVER || WEATHER_ERA_REGION
 
|-
 
| WEATHER_ERA_REGIONCOVER_LTA || WEATHER_ERA_REGION_LTA
 
|-
 
| WEATHER_HIS_GRID || WEATHER_HIS_GRID
 
|-
 
| WEATHER_HIS_REGIONCOVER || WEATHER_HIS_REGION
 
|-
 
| WEATHER_HRES_GRID || ...
 
|-
 
| WEATHER_HRES_REGIONCOVER || ...
 
|-
 
| WEATHER_OBS_GRID || WEATHER_OBS_GRID
 
|-
 
| WEATHER_OBS_GRID_INFO || WEATHER_OBS_GRID_INFO
 
|-
 
| WEATHER_OBS_GRID_LTA || WEATHER_OBS_GRID_LTA
 
|-
 
| WEATHER_OBS_GRID_LTA_MISS || WEATHER_OBS_GRID_LTA_MISS
 
|-
 
| WEATHER_OBS_REGCOV_LTA_THRSHLD || ...
 
|-
 
| WEATHER_OBS_REGCOV_THRESHOLDS || WEATHER_OBS_REGION_THRES
 
|-
 
| WEATHER_OBS_REGIONCOVER || WEATHER_OBS_REGION
 
|-
 
| WEATHER_OBS_REGIONCOVER_LTA || WEATHER_OBS_REGION_LTA
 
|-
 
| WEATHER_OBS_STATION || WEATHER_OBS_STATION
 
|-
 
| WEATHER_OBS_STATION_AVAIL || WEATHER_OBS_STATION_AVAIL
 
|-
 
| WEATHER_OBS_STATION_CALCULATED || WEATHER_OBS_STATION_CALCULATED
 
|-
 
| WEATHER_OBS_STATION_ERRAIN || WEATHER_OBS_STATION_ERRAIN
 
|-
 
| WEATHER_OBS_STATION_ERRORS || WEATHER_OBS_STATION_ERRORS
 
|-
 
| WEATHER_OBS_STATION_INFO || WEATHER_OBS_STATION_INFO
 
|-
 
| WEATHER_OBS_STATION_LTA || WEATHER_OBS_STATION_LTA
 
|-
 
| WEATHER_OBS_STATION_RAW || WEATHER_OBS_STATION_RAW
 
|-
 
| WEATHER_OPE_GRID || ...
 
|-
 
| WEATHER_OPE_REGIONCOVER || ...
 
|}
 

Latest revision as of 14:17, 20 May 2016