Valencia neighborhoods

ESP_VAL_adm5.json

ESP_VAL_adm6.csv

fix_csv.py

# -*- coding: UTF-8 -*-
import os, json, csv, time
import ast
from termcolor import colored


# python3 -c "from fix_csv import *; fix_csv('ESP_VAL_adm6.csv')"

def fix_csv(filename):
    try:

        data = { "type": "FeatureCollection", "features": [] }

        with open(os.path.join(os.path.dirname(os.path.abspath(__file__)), filename)) as csvfile:
            spamreader = csv.reader(csvfile, delimiter=',')
            for row in spamreader:

                doc = {
                    "type": "Feature",
                    "properties": {
                        "nombre": row[2],
                        "coddistrit": row[1]
                    },
                    "geometry": {
                        "type": "Polygon",
                        "coordinates": [[]]
                    }
                }
                for coor in row[0][10:-2].split(','):
                    if coor == '': continue
                    cct = [0,0]
                    ccs = coor.split(' ')
                    cct[0] = float(ccs[0])
                    cct[1] = float(ccs[1])
                    doc['geometry']['coordinates'][0].append(cct)

                data['features'].append(doc)
        
        f = open(os.path.join(os.path.dirname(os.path.abspath(__file__)),'fixed_'+filename[:-3]+'json'),'w')
        f.write(json.dumps(data))
        f.close()


    except Exception as e:
        print(time.strftime("%Y-%m-%d %H:%M:%S"),colored('Error general:','red'), e)

fixed_ESP_VAL_adm6.json

adm6 original from from https://data.lab.fiware.org/dataset/valencia-sectorpublico-barrios (It only can be downloaded as csv)