def handle_get(http_server, database_manager, ip, account, api_key):
query_params = http_server.get_query_parameters()
if "zip" not in query_params:
raise ApiParamNoZipCodeProvidedError
raw_zip_code_string = query_params["zip"]
zip_code_string = raw_zip_code_string
if "-" in raw_zip_code_string:
dash_position = raw_zip_code_string.find("-")
zip_code_string = raw_zip_code_string[0:dash_position]
match = re.match(r'^\d+$', zip_code_string)
if match is None:
raise ApiParamInvalidZipCodeError
zip_code_int = int(zip_code_string)
zip_code = ZipCode.fetch_by_zip_int(
database_manager,
zip_code_int,
is_decommisioned=False
)
if zip_code is None:
raise ApiParamInvalidZipCodeError
state = UsState.fetch_by_id(database_manager, zip_code.state_id)
city_name = zip_code.city
if zip_code.city is not None:
city_name = zip_code.city.title()
county_percentages = zip_code.get_county_percentages()
county_fips = []
if len(county_percentages) > 0:
county_fips = [c.get_state_county_fips() for c in county_percentages]
county_fips = list(set(county_fips))
subscription_plan = SubscriptionPlan.fetch_by_id(
database_manager,
account.subscription_plan_id
)
for header in eligible_headers:
eligible_headers[header] = get_is_eligible(
subscription_plan,
header
)
zip_totals = {}
if len(county_fips) > 0:
education_county_conditions = [{
"column": "county_code",
"equivalence": "IN",
"value": county_fips
}]
county_totals = database_manager.fetch_by(
EducationCounty(database_manager),
education_county_conditions
)
else:
raise ApiParamInvalidZipCodeError
for header, is_eligible in eligible_headers.items():
if is_eligible is True:
zip_totals[header] = 0
for county_total in county_totals:
for county_percentage in county_percentages:
if county_percentage.get_state_county_fips() == \
county_total.county_code:
total = getattr(
county_total,
header
)
if total is None:
total = 0
zip_totals[header] = (
round(
total * county_percentage.zip_population_percent
)
)
break
years = ["1980", "1990", "2000", "2009"]
raw_output_data = OrderedDict({})
totals = {}
for year in years:
output_year = {}
for header, value in zip_totals.items():
if "num_adults" not in header:
if year in header:
ending = year
end = len(ending) + 1
if "_2005_" in header:
ending = "2005_{}".format(year)
end = len(ending) + 1
output_year[header[:-end]] = 100 * value / zip_totals[
"num_adults_{}".format(ending)
]
if len(output_year) > 0:
raw_output_data[year] = output_year
if year not in totals:
if year in raw_output_data:
ending = year
if year == "2009":
ending = "2005_2009"
totals[year] = zip_totals["num_adults_{}".format(ending)]
# get percentages
output_data = OrderedDict({})
notes = []
for year in raw_output_data:
output_data[year] = {"breakdown":{}}
for key, value in raw_output_data[year].items():
output_data[year]["breakdown"][key] = value
if get_is_eligible(subscription_plan, "totals") is True:
output_data[year]['total_adults'] = totals[year]
else:
notes.append("Upgrade to a paid plan for totals")
if len(output_data) == 1:
notes.append("Upgrade plan for historical data")
notes = list(set(notes))
state_name = ""
state_code = ""
if state.code is not None:
state_code = state.code
if state.name is not None:
state_name = state.name
output = OrderedDict({
"education_ranges": output_data,
"city": {
"name": city_name,
"api_endpoint": '/v1/education/city?city={}&state={}'.format(
requote_uri(city_name),
state_code.upper()
),
},
"state": {
"name": state_name,
"code": state_code.upper(),
"api_endpoint": '/v1/education/state?code={}'.format(state_code.upper()),
},
"country": {
"name": "United States of America",
"code": "US",
"api_endpoint": '/v1/education/country?code=US',
}
})
http_server.print_headers()
http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key):
query_params = http_server.get_query_parameters()
if "zip" not in query_params:
raise ApiParamNoZipCodeProvidedError
raw_zip_code_string = query_params["zip"]
zip_code_string = raw_zip_code_string
if "-" in raw_zip_code_string:
dash_position = raw_zip_code_string.find("-")
zip_code_string = raw_zip_code_string[0:dash_position]
match = re.match(r'^\d+$', zip_code_string)
if match is None:
raise ApiParamInvalidZipCodeError
zip_code_int = int(zip_code_string)
zip_code = ZipCode.fetch_by_zip_int(database_manager,
zip_code_int,
is_decommisioned=False)
if zip_code is None:
raise ApiParamInvalidZipCodeError
state = UsState.fetch_by_id(database_manager, zip_code.state_id)
city_name = zip_code.city
if zip_code.city is not None:
city_name = zip_code.city.title()
county_percentages = zip_code.get_county_percentages()
county_fips = []
if len(county_percentages) > 0:
county_fips = [c.get_state_county_fips() for c in county_percentages]
county_fips = list(set(county_fips))
subscription_plan = SubscriptionPlan.fetch_by_id(
database_manager, account.subscription_plan_id)
for header in eligible_headers:
eligible_headers[header] = get_is_eligible(subscription_plan, header)
zip_totals = {}
if len(county_fips) > 0:
population_county_conditions = [{
"column": "county_code",
"equivalence": "IN",
"value": county_fips
}]
county_totals = database_manager.fetch_by(
PopulationCounty(database_manager), population_county_conditions)
else:
raise ApiParamInvalidZipCodeError
for header, is_eligible in eligible_headers.items():
if is_eligible is True:
zip_totals[header] = 0
for county_total in county_totals:
for county_percentage in county_percentages:
if county_percentage.get_state_county_fips() == \
county_total.county_code:
total = getattr(county_total, header)
if total is None:
total = 0
zip_totals[header] += (round(
total * county_percentage.zip_population_percent))
break
years = [str(x) for x in range(1930, 2011)]
raw_output_data = OrderedDict({})
totals = {}
for year in years:
output_year = {}
for header, value in zip_totals.items():
if year in header:
output_year[header[:-len(year) - 1]] = value
if len(output_year) > 0:
raw_output_data[year] = output_year
# get percentages
output_data = OrderedDict({})
notes = []
for year in raw_output_data:
output_data[year] = None
for key, value in raw_output_data[year].items():
output_data[year] = value
if len(output_data) == 1:
notes.append("Upgrade plan for historical data")
notes = list(set(notes))
state_name = ""
state_code = ""
if state.code is not None:
state_code = state.code
if state.name is not None:
state_name = state.name
output = OrderedDict({
"population_estimates": output_data,
"units": "people",
"location": {
"city": {
"name":
city_name,
"api_endpoint":
'/v1/population/city?city={}&state={}'.format(
requote_uri(city_name), state_code.upper()),
},
"state": {
"name":
state_name,
"code":
state_code.upper(),
"api_endpoint":
'/v1/population/state?code={}'.format(state_code.upper()),
},
"country": {
"name": "United States of America",
"code": "US",
"api_endpoint": '/v1/population/country?code=US',
}
},
"notes": notes
})
http_server.print_headers()
http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key):
query_params = http_server.get_query_parameters()
if "zip" not in query_params:
raise ApiParamNoZipCodeeProvidedError
http_server.print_headers()
raw_zip_code_string = query_params["zip"]
zip_code_string = raw_zip_code_string
if "-" in raw_zip_code_string:
dash_position = raw_zip_code_string.find("-")
zip_code_string = raw_zip_code_string[0:dash_position]
match = re.match(r'^\d+$', zip_code_string)
if match is None:
raise ApiParamInvalidZipCodeError
zip_code_int = int(zip_code_string)
zip_code = ZipCode.fetch_by_zip_int(database_manager,
zip_code_int,
is_decommisioned=False)
if zip_code is None:
raise ApiParamInvalidZipCodeError
state = UsState.fetch_by_code(database_manager, zip_code.state_code)
is_po_box = zip_code.zip_code_type == "PO BOX"
city_name = zip_code.city
if zip_code.city is not None:
city_name = zip_code.city.capitalize()
mean_income = zip_code.get_mean_income()
mean_national_income = zip_code.get_mean_national_income()
mean_state_income = state.get_mean_income()
mean_city_income = zip_code.get_mean_city_income()
estimated_national_population = zip_code.get_estimated_national_population(
)
estimated_state_population = state.get_estimated_population()
estimated_city_population = zip_code.get_estimated_city_population()
area_km2 = zip_code.area_m2 / 1000000
city_area_km2 = zip_code.get_city_area_km2()
state_area_km2 = state.area_km2
national_area_km2 = 9147420
output = {
"zip": zip_code_string,
"geolocation": {
"latitude": zip_code.latitude,
"longitude": zip_code.longitude,
},
"is_po_box": is_po_box,
"estimated_population": zip_code.estimated_population,
"mean_income": mean_income,
"utc_offset": zip_code.utc_offset,
"area_km2": area_km2,
"city": {
"name": city_name,
"mean_income": mean_city_income,
"estimated_population": estimated_city_population,
"area_km2": city_area_km2,
},
"state": {
"name": state.name.capitalize(),
"code": state.code.upper(),
"mean_income": mean_state_income,
"estimated_population": estimated_state_population,
"area_km2": state_area_km2,
},
"country": {
"name": "United States of America",
"code": "US",
"mean_income": mean_national_income,
"estimated_population": estimated_national_population,
"area_km2": national_area_km2,
}
}
http_server.print_json(output)