smooth out last few rough edges with GEO-PEAS

Finishing with the GEO-PEAS service there are a few small details that need to be refined.

~~Landcover

The entries in the controlled vocabulary are not matching with the data used in the service.~~

Ecoregion

The service still returns the OBJECT_ID instead of the ECO_ID. The controlled vocabulary uses the ECO_ID.

NOx emissions

The pages have a query for year 1990. The earliest available year in the service is 2000. rename mean_nox_emissions_10km_year1990 --> mean_nox_emissions_10km_year2000

Mismatches between database field name and url

srtm -> topography_srtm
nightlight -> stable_nightlights

added .todo enhancement labels

marked this issue as related to #45 (closed)

Landcover

We used to have (from http://www.eomf.ou.edu/static/IGBP.pdf)

 -1: Undefined, -1 (undefined)
  0: Water, 0 (Water)
  1: EGNeedleleaf, 1  (Evergreen Needleleaf forests)
  2: EGBroadleaf, 2  (Evergreen Broadleaf forests)
  3: DCNeedleleaf, 3  (Deciduous Needleleaf forests)
  4: DCBroadleaf, 4  (Deciduous Broadleaf forests)
  5: MixedForests, 5  (Mixed forests)
  6: ClosedShrublands, 6  (Closed shrublands)
  7: OpenShrublands, 7  (Open shrublands)
  8: WoodySavannas, 8  (Woody savannas)
  9: Savannas, 9  (Savannas)
 10: Grasslands, 10  (Grasslands)
 11: Wetlands, 11  (Permanent wetlands)
 12: Croplands, 12  (Croplands)
 13: Urban, 13  (Urban and built-up)
 14: Mosaic, 14  (Cropland/Natural vegetation mosaic)
 15: Snow, 15  (Snow and ice)
 16: Barren, 16  (Barren or sparsely vegetated)
255: Fill, 255 (Fill Value/Unclassified)

This has now to be adapted to serve the following codes (from http://maps.elie.ucl.ac.be/CCI/viewer/download/ESACCI-LC-Ph2-PUGv2_2.0.pdf):

 -1: Undefined, -1 (undefined))
  0: NoData, 0 (No Data)
 10: CroplandRainfed, 10 (Cropland, rainfed)
 11: CroplandRainfedHerbaceousCover, 11 (Cropland, rainfed, herbaceous cover)
 12: CroplandRainfedTreeOrShrubCover, 12 (Cropland, rainfed, tree or shrub cover)
 20: CroplandIrrigated, 20 (Cropland, irrigated or post-flooding)
 30: MosaicCropland, 30 (Mosaic cropland (>50%) / natural vegetation (tree, shrub, herbaceous cover) (<50%))
 40: MosaicNaturalVegetation, 40 (Mosaic natural vegetation (tree, shrub, herbaceous cover) (>50%) / cropland (<50%))
 50: TreeBroadleavedEvergreenClosedToOpen, 50 (Tree cover, broadleaved, evergreen, closed to open (>15%))
 60: TreeBroadleavedDeciduousClosedToOpen, 60 (Tree cover, broadleaved, deciduous, closed to open (>15%))
 61: TreeBroadleavedDeciduousClosed, 61 (Tree cover, broadleaved, deciduous, closed (>40%))
 62: TreeBroadleavedDeciduousOpen, 62 (Tree cover, broadleaved, deciduous, open (15-40%))
 70: TreeNeedleleavedEvergreenClosedToOpen, 70 (Tree cover, needleleaved, evergreen, closed to open (>15%))
 71: TreeNeedleleavedEvergreenClosed, 71 (Tree cover, needleleaved, evergreen, closed (>40%))
 72: TreeNeedleleavedEvergreenOpen, 72 (Tree cover, needleleaved, evergreen, open (15-40%))
 80: TreeNeedleleavedDeciduousClosedToOpen, 80 (Tree cover, needleleaved, deciduous, closed to open (>15%))
 81: TreeNedleleavedDeciduousClosed, 81 (Tree cover, needleleaved, deciduous, closed (>40%))
 82: TreeNeedleleavedDeciduousOpen, 82 (Tree cover, needleleaved, deciduous, open (15-40%))
 90: TreeMixed, 90 (Tree cover, mixed leaf type (broadleaved and needleleaved))
100: MosaicTreeAndShrub, 100 (Mosaic tree and shrub (>50%) / herbaceous cover (<50%))
110: MosaicHerbaceous, 110 (Mosaic herbaceous cover (>50%) / tree and shrub (<50%))
120: Shrubland, 120 (Shrubland)
121: ShrublandEvergreen, 121 (Evergreen shrubland)
122: ShrublandDeciduous, 122 (Deciduous shrubland)
130: Grassland, 130 (Grassland)
140: LichensAndMosses, 140 (Lichens and mosses)
150: SparseVegetation, 150 (Sparse vegetation (tree, shrub, herbaceous cover) (<15%))
151: SparseTree, 151 (Sparse tree (<15%))
152: SparseShrub, 152 (Sparse shrub (<15%))
153: SparseHerbaceous, 153 (Sparse herbaceous cover (<15%))
160: TreeCoverFloodedFreshOrBrakishWater, 160 (Tree cover, flooded, fresh or brakish water)
170: TreeCoverFloodedSalineWater, 170 (Tree cover, flooded, saline water)
180: ShrubOrHerbaceousCoverFlooded, 180 (Shrub or herbaceous cover, flooded, fresh/saline/brakish water)
190: Urban, 190 (Urban areas)
200: BareAreas, 200 (Bare areas)
201: BareAreasConsolidated, 201 (Consolidated bare areas)
202: BareAreasUnconsolidated, 202 (Unconsolidated bare areas)
210: Water, 210 (Water bodies)
220: SnowAndIce, 220 (Permanent snow and ice)

mentioned in commit 0d4ae000

mentioned in commit e9073781

changed the description

changed the description

mentioned in commit d59906f7

The above commit works with the following additional database changes:

UPDATE stationmeta_global_services SET variable_name='mean_nox_emissions_10km_year2000', service_url='{base_url}/nox_emissions/?agg=mean&radius=25000&year=2000&lat={lat}&lon={lon}' WHERE variable_name='mean_nox_emissions_10km_year1990';
ALTER TABLE stationmeta_global RENAME COLUMN mean_nox_emissions_10km_year1990 TO mean_nox_emissions_10km_year2000;

Do not forget about the pytest database!

mentioned in merge request !130 (merged)

mentioned in commit 0bc4ea98

mentioned in merge request !131 (merged)

mentioned in commit b47fc505

mentioned in commit b40e0017

To rename
srtm -> topography_srtm
nightlight -> stable_nightlights
do the following changes to all (operational, dev, pytest) databases (besides code/pages/documentation adaptation):

ALTER TABLE stationmeta_global
    RENAME COLUMN mean_nightlight_1km_year2013 TO mean_stable_nightlights_1km_year2013;
ALTER TABLE stationmeta_global
    RENAME COLUMN mean_nightlight_5km_year2013 TO mean_stable_nightlights_5km_year2013;
ALTER TABLE stationmeta_global
    RENAME COLUMN max_nightlight_25km_year2013 TO max_stable_nightlights_25km_year2013;
ALTER TABLE stationmeta_global
    RENAME COLUMN max_nightlight_25km_year1992 TO max_stable_nightlights_25km_year1992;
ALTER TABLE stationmeta_global
    RENAME COLUMN mean_srtm_alt_90m_year1994 TO mean_topography_srtm_alt_90m_year1994;
ALTER TABLE stationmeta_global
    RENAME COLUMN mean_srtm_alt_1km_year1994 TO mean_topography_srtm_alt_1km_year1994;
ALTER TABLE stationmeta_global
    RENAME COLUMN max_srtm_relative_alt_5km_year1994 TO max_topography_srtm_relative_alt_5km_year1994;
ALTER TABLE stationmeta_global
    RENAME COLUMN min_srtm_relative_alt_5km_year1994 TO min_topography_srtm_relative_alt_5km_year1994;
ALTER TABLE stationmeta_global
    RENAME COLUMN stddev_srtm_relative_alt_5km_year1994 TO stddev_topography_srtm_relative_alt_5km_year1994;

UPDATE stationmeta_global_services SET variable_name='mean_topography_srtm_alt_90m_year1994'
                                 WHERE variable_name='mean_srtm_alt_90m_year1994';
UPDATE stationmeta_global_services SET variable_name='mean_topography_srtm_alt_1km_year1994'
                                 WHERE variable_name='mean_srtm_alt_1km_year1994';
UPDATE stationmeta_global_services SET variable_name='max_topography_srtm_relative_alt_5km_year1994'
                                 WHERE variable_name='max_srtm_relative_alt_5km_year1994';
UPDATE stationmeta_global_services SET variable_name='min_topography_srtm_relative_alt_5km_year1994'
                                 WHERE variable_name='min_srtm_relative_alt_5km_year1994';
UPDATE stationmeta_global_services SET variable_name='stddev_topography_srtm_relative_alt_5km_year1994'
                                 WHERE variable_name='stddev_srtm_relative_alt_5km_year1994';
UPDATE stationmeta_global_services SET variable_name='mean_stable_nightlights_1km_year2013'
                                 WHERE variable_name='mean_nightlight_1km_year2013';
UPDATE stationmeta_global_services SET variable_name='mean_stable_nightlights_5km_year2013'
                                 WHERE variable_name='mean_nightlight_5km_year2013';
UPDATE stationmeta_global_services SET variable_name='max_stable_nightlights_25km_year2013'
                                 WHERE variable_name='max_nightlight_25km_year2013';
UPDATE stationmeta_global_services SET variable_name='max_stable_nightlights_25km_year1992'
                                 WHERE variable_name='max_nightlight_25km_year1992';

mentioned in commit 3a28822c