Difference between revisions of "Appendix 5: Database objects"

From Agri4castWiki
Jump to: navigation, search
(renamed datasets)
Line 4: Line 4:
 
* [[{{BASEPAGENAME}}/CGMS14xxx|CGMS14xxx database objects]]
 
* [[{{BASEPAGENAME}}/CGMS14xxx|CGMS14xxx database objects]]
 
* [[{{BASEPAGENAME}}/CGMS14SYS|CGMS14SYS database objects]]
 
* [[{{BASEPAGENAME}}/CGMS14SYS|CGMS14SYS database objects]]
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]<br>
+
* [[{{BASEPAGENAME}}/GWSI_E_12|GWSI_E_12 database objects]]
 +
* [[{{BASEPAGENAME}}/CGFS14EU |CGFS14EU database objects]]
 +
 
 +
 
 
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 
* [[{{BASEPAGENAME}}/CGMS12xxx|CGMS12xxx database objects (legacy)]]
 +
 +
 +
  
 
== renamed datasets ==
 
== renamed datasets ==
 
{| class='wikitable'
 
{| class='wikitable'
!old table name
 
 
!new table name
 
!new table name
 +
!old table name (or comment source)
 +
 
|-
 
|-
| CROP_AGGREGATIONS || STAT_CROP
+
| CMETEO_WEATHER_HIS_AEZ || CMETEO_GRID_WEATHER
|-
 
| 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
+
| CMETEO_WEATHER_HIS_GRID || CMETEO_GRID_WEATHER
 
|-
 
|-
| WEATHER_OBS_REGCOV_LTA_THRSHLD || ...
+
| CMETEO_WEATHER_HIS_REGION || CMETEO_GRID_WEATHER
 
|-
 
|-
| WEATHER_OBS_REGCOV_THRESHOLDS || WEATHER_OBS_REGION_THRES
+
| CMETEO_WEATHER_OPE_AEZ || CMETEO_GRID_WEATHER
 
|-
 
|-
| WEATHER_OBS_REGIONCOVER || WEATHER_OBS_REGION
+
| CMETEO_WEATHER_OPE_GRID || CMETEO_GRID_WEATHER
 
|-
 
|-
| WEATHER_OBS_REGIONCOVER_LTA || WEATHER_OBS_REGION_LTA
+
| CMETEO_WEATHER_OPE_REGION || CMETEO_GRID_WEATHER
 
|-
 
|-
| WEATHER_OBS_STATION || WEATHER_OBS_STATION
+
| CROP_CALENDAR || CROP_CALENDARS
 
|-
 
|-
| WEATHER_OBS_STATION_AVAIL || WEATHER_OBS_STATION_AVAIL
+
| SIMYIELD_REGION || SIMYIELD_ENS_REGION
 
|-
 
|-
| WEATHER_OBS_STATION_CALCULATED || WEATHER_OBS_STATION_CALCULATED
+
| STAT_CROP || CROP_AGGREGATIONS
 
|-
 
|-
| WEATHER_OBS_STATION_ERRAIN || WEATHER_OBS_STATION_ERRAIN
+
| WEATHER_<MODEL>_GRID_LTA || WEATHER_ERA_GRID_LTA
 
|-
 
|-
| WEATHER_OBS_STATION_ERRORS || WEATHER_OBS_STATION_ERRORS
+
| WEATHER_ERA_REGION || WEATHER_ERA_REGIONCOVER
 
|-
 
|-
| WEATHER_OBS_STATION_INFO || WEATHER_OBS_STATION_INFO
+
| WEATHER_ERA_REGION_LTA || WEATHER_ERA_REGIONCOVER_LTA
 
|-
 
|-
| WEATHER_OBS_STATION_LTA || WEATHER_OBS_STATION_LTA
+
| WEATHER_HIS_REGION || WEATHER_HIS_REGIONCOVER
 
|-
 
|-
| WEATHER_OBS_STATION_RAW || WEATHER_OBS_STATION_RAW
+
| WEATHER_OBS_REGION || WEATHER_OBS_REGIONCOVER
 
|-
 
|-
| WEATHER_OPE_GRID || ...
+
| WEATHER_OBS_REGION_LTA || WEATHER_OBS_REGIONCOVER_LTA
 
|-
 
|-
| WEATHER_OPE_REGIONCOVER || ...
+
| WEATHER_OBS_REGION_THRES || WEATHER_OBS_REGCOV_THRESHOLDS
 
|}
 
|}

Revision as of 16:25, 7 March 2016







renamed datasets

new table name old table name (or comment source)
CMETEO_WEATHER_HIS_AEZ CMETEO_GRID_WEATHER
CMETEO_WEATHER_HIS_GRID CMETEO_GRID_WEATHER
CMETEO_WEATHER_HIS_REGION CMETEO_GRID_WEATHER
CMETEO_WEATHER_OPE_AEZ CMETEO_GRID_WEATHER
CMETEO_WEATHER_OPE_GRID CMETEO_GRID_WEATHER
CMETEO_WEATHER_OPE_REGION CMETEO_GRID_WEATHER
CROP_CALENDAR CROP_CALENDARS
SIMYIELD_REGION SIMYIELD_ENS_REGION
STAT_CROP CROP_AGGREGATIONS
WEATHER_<MODEL>_GRID_LTA WEATHER_ERA_GRID_LTA
WEATHER_ERA_REGION WEATHER_ERA_REGIONCOVER
WEATHER_ERA_REGION_LTA WEATHER_ERA_REGIONCOVER_LTA
WEATHER_HIS_REGION WEATHER_HIS_REGIONCOVER
WEATHER_OBS_REGION WEATHER_OBS_REGIONCOVER
WEATHER_OBS_REGION_LTA WEATHER_OBS_REGIONCOVER_LTA
WEATHER_OBS_REGION_THRES WEATHER_OBS_REGCOV_THRESHOLDS