def neighborhooddata_view(request, state, name, region_id=None):
if region_id:
zillow = requests.get("http://www.zillow.com/webservice/GetDemographics.htm?"
+ "zws-id=" + apis('zillowkey')
+ "&state=" + state
+ "&city=" + name
+ "®ionid=" + region_id)
else:
zillow = requests.get("http://www.zillow.com/webservice/" +
"GetDemographics.htm?" +
"zws-id=" + apis('zillowkey') +
"&state=" + state +
"&city=" + name)
return JsonResponse(xmltodict.parse(zillow.text))
def get(self, request, state, name):
payload = {"zws-id": apis("zillowkey"), "state": state, "city": name}
housing_data = requests.get("http://www.zillow.com/"
+ "webservice/GetDemographics.htm",
params=payload)
housing_data = xmltodict.parse(housing_data.text, xml_attribs=True)
return JsonResponse(housing_data)
def industry_view(request, state, name):
name = get_object_or_404(Name, name=name, state=state)
bls = Bls.objects.all()
seriesids = name.city.ind_id.split(',')
headers = {'Content-type': 'application/json'}
data = json.dumps({"seriesid": seriesids,
"startyear": "2015", "endyear": "2015",
"registrationKey": apis("blskey"),
})
ind_data = requests.post('http://api.bls.gov/publicAPI/v2/timeseries/data/',
data=data, headers=headers)
ndata = json.loads(ind_data.text)
datadict = {}
if len(ndata["Results"]["series"]) == 0:
return HttpResponse("no data")
else:
for line in ndata["Results"]["series"]:
for name in bls:
if name.code == line["seriesID"][10:-2] and \
len(line["data"]) > 0:
datadict[name.industry] = line["data"][0]["value"]
for val in datadict:
if val != "Total Nonfarm" and val != "Total Private" and \
val != "Government":
datadict[val] = round(100 * float(datadict[val]) / \
float(datadict["Total Nonfarm"]), ndigits=1)
datadict['Gov'] = str(round(float(datadict["Total Nonfarm"]) - \
float(datadict["Total Private"]), ndigits=1))
return JsonResponse(datadict)
def school_districts_view(request, state, name):
city = name.replace('-', '_')
city = city.replace(' ', '-')
districts = requests.get(
"http://api.greatschools.org/districts/" +
state + '/' +
city + '/' +
"?key=" + apis("greatschools"))
return JsonResponse(xmltodict.parse(districts.text))
def cell_view(request, state, name):
coords = [request.GET.get("lon"), request.GET.get("lat")]
signal = requests.get("http://api.opensignal.com/v2/networkstats.json?lat=" \
+ str(coords[1]) + "&lng=" + str(coords[0]) \
+ "&distance=" + "10" \
+ "&json_format=" + "2" \
+ "&apikey=" + apis('opensignal'))
signal = json.loads(signal.text)
return JsonResponse(signal)
def nearby_schools_view(request, state):
lat = request.GET.get('lat')
lon = request.GET.get('lon')
data = requests.get("http://api.greatschools.org/schools/nearby?key=" +
apis('greatschools') + "&state=" + state +
"&lat=" + lat + "&lon=" + lon)
returndata = xmltodict.parse(data.text)
returndata['lat'] = lat
returndata['lon'] = lon
return JsonResponse(returndata) # xmltodict.parse(data.text))
def salary_view(request, state, name, job):
name = get_object_or_404(Name, name=name, state=state)
occupations = Occupation.objects.all()
jobtitle = job.title()
locids = name.city.ocp_id.split(',')
seriesids = []
for series in locids:
for line in occupations:
if jobtitle == line.job:
for item in range(11, 16):
seriesids.append(series + line.code + str(item))
headers = {'Content-type': 'application/json'}
data = json.dumps({"seriesid": seriesids,
"startyear": "2014", "endyear": "2014",
"registrationKey": apis("blskey"),
})
ocp_data = requests.post('http://api.bls.gov/publicAPI/v2/timeseries/data/',
data=data, headers=headers)
ndata = json.loads(ocp_data.text)
datadict = {}
typecodes = {"11": "10th", "12": "25th", "13": "50th", "14": "75th",
"15": "90th"}
if not ndata["Results"] or not ndata["Results"]["series"] or ndata["message"]:
return JsonResponse({"no data": "no data"})
else:
for line in ndata["Results"]["series"]:
for job in occupations:
if job.code == line['seriesID'][17:-2] and len(line["data"]) > 0:
datadict[job.job
+ typecodes[str(line['seriesID'][-2:])]] = \
line["data"][0]["value"]
for value in datadict:
if datadict[value] == "-":
response = JsonResponse({"no data": "no data"})
return response
else:
return JsonResponse(datadict)
def industry_size_view(request, state, name):
name = get_object_or_404(Name, name=name, state=state)
occupations = Occupation.objects.all()
locid = name.city.ocp_id.split(',')[0][4:11]
seriesids = [("OEUM" + locid + "000000" + ocup + "01") for ocup in main_ind]
seriesids += [("OEUM" + locid + "000000" + "000000" + "01")]
headers = {'Content-type': 'application/json'}
data = json.dumps({"seriesid": seriesids,
"startyear": "2014", "endyear": "2014",
"registrationKey": apis("blskey"),
})
ocp_data = requests.post('http://api.bls.gov/publicAPI/v2/timeseries/data/',
data=data, headers=headers)
ndata = json.loads(ocp_data.text)
datadict = {}
if not ndata["Results"] or not ndata["Results"]["series"]:
datadict["no data"] = "no data"
response = JsonResponse(datadict)
return response
else:
for line in ndata["Results"]["series"]:
for job in occupations:
if job.code == line['seriesID'][17:-2] and len(line["data"]) > 0:
datadict[job.job] = line["data"][0]["value"]
allind = datadict["All"]
for ind in datadict:
datadict[ind] = round(100 * float(datadict[ind]) / float(allind), 2)
datadict.pop("All", None)
return JsonResponse(datadict)
def school_view(request, state, gsid):
data = requests.get("http://api.greatschools.org/schools/" + state \
+ "/" + gsid
+ "?key=" + apis('greatschools'))
return JsonResponse(xmltodict.parse(data.text))