Snippet to clean up and push KMZ->JSON data to a CouchDB instance. Routes are converted to LineStrings.

GeoJSON2Couch.py

import ijson
from couchdbkit import (Document, Server, StringProperty, DictProperty)


class Route(Document):
    id = StringProperty()
    geometry = DictProperty()
    properties = DictProperty()


def main():
    unnamed_count = 0
    server = Server('https://xxxxxxxxx:xxxxxxxxx@redrobot.iriscouch.com')
    db = server.get_or_create_db('iom-walking-routes')
    
    Route.set_db(db)
    
    with open('routes.json') as file:
        for feature_list in ijson.items(file, 'features'):
            for route in feature_list:
                name = route['properties'].get('Name')
                if name in (None, 'NULL'):
                    name = 'Unnamed Route %d' % (unnamed_count,)
                    unnamed_count += 1
                geometry = {
                    'type': 'LineString',
                    'coordinates': [[float(y) for y in x if y != 0.0] for x in route['geometry']['coordinates'][0]]
                }
                route = Route(id=name, geometry=geometry, properties=route['properties'])
                route.save()


if __name__ == '__main__':
    main()