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()