Extract city bounding box CSV from Mapzen

extract_cities.py

import json

doc = json.load(open('cities.json'))
for region, region_obj in doc['regions'].items():
    for city_name, city_obj in region_obj['cities'].items():
        bbox = city_obj['bbox']
        parts = city_name.split('_')

        if len(parts) != 2:
            continue

        city, country = parts
        print('\t'.join([
            city_name + '.mbtiles',
            country,
            city,
            bbox['top'],
            bbox['left'],
            bbox['bottom'],
            bbox['right'],
        ]))