def makeMap(request): listings = Building.objects.order_by('?')[:1000] keywords = Keywords.objects.order_by('keyword') allcategories = Categories.objects.order_by('category').values('category') zipcodes = Zipcode.objects.order_by('code') if request.method == 'GET': try: lat = request.GET['lat'] lng = request.GET['lng'] lists = Listing.objects.all().values() minlat = min([l['latitude'] for l in lists]) minlng = min([l['longitude'] for l in lists]) key1 = int(float(lat)*1000000-minlat*1000000) key2 = int(float(lng)*1000000-minlng*1000000) search = zcurve.interleave2(key1,key2) storage = FileStorage.FileStorage('listings2.fs') db = DB(storage) conn = db.open() dbroot = conn.root() userdb = dbroot['listingdb'] listings = [] for i in range(search-100000,search+10000): try: listings.append(userdb[int(i)]) except: pass db.close() return render_to_response('map2.html', locals()) except: pass return render_to_response('map.html', locals())
def testPickle(request): listing = database.Listing() listing.name = Building.objects.all()[0].name listing.number = Building.objects.all()[0].number listing.street = Building.objects.all()[0].street listing.city = Building.objects.all()[0].city listing.state = Building.objects.all()[0].state listing.location = zcurve.interleave2(int(Building.objects.all()[0].location.x*10000000),int(Building.objects.all()[0].location.y*10000000)) listing.zipcode = Building.objects.all()[0].zipcode #for key, value in : # listing.key = value #listing.location = zcurve.interleave2(listing.location.x, listing.location.y) pickle.dump( listing, open( "save.p", "wb" ), -1 ) return HttpResponse(sys.maxint)
def testzcurve(request): zcurvevals = [[{str(i)+','+str(j):zcurve.interleave2(i,j)} for i in range(0,11)] for j in range(0,11)] return HttpResponse(zcurvevals)