You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
59 lines
2.5 KiB
59 lines
2.5 KiB
from sodapy import Socrata
|
|
from core.models import CalgaryAddress
|
|
from django.shortcuts import render, HttpResponse
|
|
import json
|
|
c = Socrata('data.calgary.ca', None)
|
|
SHORT_NAME_MAPPING = {'ALLEY': 'AL', 'AVENUE': 'AV',
|
|
'BAY': 'BA', 'BOULEVARD': 'BV',
|
|
'CAPE': 'CA', 'CENTRE': 'CE', 'CIRCLE': 'CI', 'CLOSE': 'CL', 'COMMON': 'CM', 'COURT': 'CO', 'CRESCENT': 'CR', 'COVE': 'CV',
|
|
'DRIVE': 'DR',
|
|
'GATE': 'GA', 'GARDENS': 'GD', 'GREEN': 'GR', 'GROVE': 'GV',
|
|
'HEATH': 'HE', 'HIGHWAY': 'HI', 'HILL': 'HL', 'HEIGHTS': 'HT',
|
|
'ISLAND': 'IS', 'LANDING': 'LD', 'LINK': 'LI', 'LANE': 'LN',
|
|
'MEWS': 'ME', 'MANOR': 'MR', 'MOUNT': 'MT',
|
|
'PARK': 'PA', 'PATH': 'PH', 'PLACE': 'PL', 'PARADE': 'PR', 'PASSAGE': 'PS', 'POINT': 'PT', 'PARKWAY': 'PY', 'PLAZA': 'PZ',
|
|
'ROAD': 'RD', 'RISE': 'RI', 'ROW': 'RO',
|
|
'SQUARE': 'SQ', 'STREET': 'ST',
|
|
'TERRACE': 'TC', 'TRAIL': 'TR',
|
|
'VILLAS': 'VI', 'VIEW': 'VW',
|
|
'WALKWAY': 'WK', 'WALK': 'WK', 'WAY': 'WY'}
|
|
|
|
def sanitize_address(addr):
|
|
new_addr = addr.upper()
|
|
for k,v in SHORT_NAME_MAPPING.items():
|
|
new_addr = new_addr.replace(' ' + k, ' ' + v)
|
|
return new_addr
|
|
|
|
# Create your views here.
|
|
def search(request):
|
|
return render(request, 'upload/search.html', {})
|
|
|
|
def search_api(request, address):
|
|
addrs = c.get('uwj2-d2wc',
|
|
where='address like "%{0}%"'.format(sanitize_address(address)),
|
|
limit=5)
|
|
return HttpResponse(json.dumps(addrs))
|
|
|
|
def save_file(file):
|
|
with open('pdfs/test.pdf', 'wb+') as destination:
|
|
for chunk in file.chunks():
|
|
destination.write(chunk)
|
|
|
|
def upload(request, address):
|
|
if request.method == 'POST':
|
|
# addr = c.get('uwj2-d2wc',
|
|
# where='address = "{0}"'.format(address),
|
|
# limit=1)[0]
|
|
# CalgaryAddress.objects.create(
|
|
# address=addr['address'],
|
|
# house_alpha=addr['house_alpha'] if 'house_alpha' in addr else '',
|
|
# street_quad=addr['street_quad'],
|
|
# street_name=addr['street_name'],
|
|
# street_type=addr['street_type']
|
|
# )
|
|
file = request.FILES['file']
|
|
save_file(file)
|
|
return HttpResponse("File saved")
|
|
return render(request, 'upload/upload.html', {
|
|
'address': address
|
|
}) |