Example #1
0
    if building_download:
        print 'Querying OverpassAPI for buildings.'
        buildings = osm.query_buildings()
        print 'Uploading OSM buildings to Postgres...'
        db.insert_osm(buildings, 'osm_buildings')

    if address_download:
        print 'Querying OverpassAPI for addresses.'
        addresses = osm.query_address()
        print 'Uploading OSM addresses to Postgres...'
        db.insert_osm(addresses, 'osm_addresses')

    if dedupe:
        print 'Getting rid of overlapping address points...'
        db.dedupe_address()

    if roads_download:
        print 'Querying OverpassAPI for highway=* and railway=*.'
        roads = osm.query_roads()
        print 'Uploading OSM highway=* and railway=* to Postgres...'
        db.insert_osm(roads, 'osm_highway_railway')

    if vacuum:
        print 'Updating DB stats.'
        db.update_stats()

    if index:
        print 'Creating multiple indexes.'
        db.create_index()