Fixes for Mastercard data at UK

[juanignaciosl]

Parent names

• [x] 0-7 (postal areas, datashare_pa_geo), curl -o /tmp/uk.5.mvt "http://localhost.local:8889/api/v1/data-observatory/census/5/16/10.mvt?api_key=wadus&measurement=demographics.mrli&measurement=mastercard.mrli&month=2018-02&month=2017-02&month=2016-02&month=2015-02&month=2014-02&month=2013-02&month=2012-02": probably, level name mismatch.
• [x] 8-11 (postal districts), http://localhost.local:8889/api/v1/data-observatory/census/9/256/168.mvt?api_key=wadus&measurement=demographics.mrli&measurement=mastercard.mrli&month=2018-02&month=2017-02&month=2016-02&month=2015-02&month=2014-02&month=2013-02&month=2012-02: missing names at names tables.
• [x] 12-13 (postal sectors), http://localhost.local:8889/api/v1/data-observatory/census/12/2047/1361.mvt?api_key=wadus&measurement=demographics.mrli&measurement=mastercard.mrli&month=2018-02&month=2017-02&month=2016-02&month=2015-02&month=2014-02&month=2013-02&month=2012-02: xyz has underscores, names don't.

Demographics

• [x] Missing for for Z 12, 13.

Identifiers for Mastercard data at UK from 2018/07

From CartoDB/Geographica-Product-Coordination/issues/52

• [x] Since July, UK identifiers are using spaces instead of underscores:

gis=# select distinct month, region_id from "uk.mastercard".mc_postcode_sector where month in ('06/01/2018', '07/01/2018');

...
 06/01/2018 | ZE1_0
 06/01/2018 | ZE2_9
 06/01/2018 | ZE3_9
 07/01/2018 | AB10 1
 07/01/2018 | AB10 6
 07/01/2018 | AB10 7
...

In the past we tried adding underscores, but it broke other datasets, so we're moving to spaces.

Fixes needed for mc_postcode_unit and mc_postcode_sector.

Parent names (again)

• [x] As ids changed in the previous steps, they must be regenerated again.

Extra ball: Tilesets API now also returns the level for top level features (for example, at state level. level was undefined).