def set_population_dict(self,demographics = []): if not self.search_hits: return [] if not demographics: demographics = Sqlite_Helper.demographic_variables(self) for demographic in demographics: total = 0 # iterate through tract tuples, add total population for tract in self.search_hits.itervalues(): geo_id = tract[0] population = tract[demographic] try: total += population except TypeError as e: try: population = float(population) except ValueError as v: raise v total += population self.population_dict[demographic] = str(total) return self.population_dict
def __init__(self,query, FCC_db,FCC_db_name, db, db_name = "",vars = []):
super(Population_Query,self).__init__(db,db_name)
self.station_vector = self.get_station_vector(query,FCC_db,FCC_db_name)
self.conn,self.cursor = Sqlite_Helper.set_db(self)
self.search_hits = {}
self.population_dict = {}
self.db_name = db_name
self.vars = Sqlite_Helper.demographic_variables(self)
self.area_error = []
self.radius_error = []
self.census_tract_area = []
self.correct_area = []
def __init__(self,db, db_name, coordinates = (0.0,0.0), vars = []):
super(Population_Query,self).__init__(db,db_name)
self.conn,self.cursor = Sqlite_Helper.set_db(self)
assert(isinstance(coordinates,tuple))
self.coordinates = coordinates
self.search_hits = {}
self.population_dict = {}
self.db_name = db_name
self.vars = Sqlite_Helper.demographic_variables(self)
self.area_error = []
self.radius_error = []
self.census_tract_area = []
self.correct_area = []
