def city_data():
    city_obj = db.get_cities()
    for c in city_obj:
        try:
            c_data = b.getCityData(c.city, c.state_id, c.best_places_url)
        except:
            print "ERROR could not get data for {}".format(c.city)
            continue
        for d in c_data:
            db.set_cities(
                            state_id = d['state_id'],
                            city = d['city'],
                            population = d['population'], 
                            unemployment = d['unemployment'],
                            avg_commute = d['avg_commute'],
                            median_age = d['median_age'],
                            household_size = d['household_size'],
                            median_home_price = d['median_home_price'],
                            msa = d['msa'],
                            zipcodes = d['zipcodes']

                        )
        print "imported {}".format(c.city)
    return
Example #2
0
#!/usr/bin/env python

import bestplaces

states = bestplaces.getStates('ny')

cities = bestplaces.getCityData('las_vegas', 'nv')

temp = bestplaces.getStates()

metros = bestplaces.getMetroData('anderson', 'in')