我正在参考下面列出的问题中的答案,因为我正在尝试运行一个查询,在我的Django应用程序中获取最接近给定点的对象。我的Django版本是1.9.2。
在我的视图中,我传递一个Zipcode并使用GeoPy获取位置和纬度/经度。
from django.contrib.gis.geos import *
from django.contrib.gis.measure import D
from geopy.geocoders import Nominatim
geolocator = Nominatim()
zipcode = self.request.query_params.get('zipcode', None)
distance_m = 20000
if zipcode is not None:
location = geolocator.geocode(zipcode, timeout=None)
origin = Point((location.latitude, location.longitude))
queryset = Chapter.objects.filter(location__distance_lte=(origin, D(m=distance_m))).distance(origin).order_by('distance')[:1][0]
return queryset
Chapter模型有一个名为location的字段,它是一个点字段。
from django.contrib.gis.db import models
class Chapter(models.Model):
name = models.CharField(max_length=500)
school = models.ForeignKey(School)
verification = models.CharField(max_length=50)
address1 = models.TextField()
address2 = models.TextField(null=True, blank=True)
city = models.TextField()
state = models.TextField()
zipcode = models.CharField(max_length=5)
location = models.PointField(srid=4326, null=True, blank=True)
is_school = models.BooleanField(default=False)
is_association = models.BooleanField(default=False)
authorized = models.NullBooleanField(default=False)
stripe_account_active = models.NullBooleanField(default=False)
def __unicode__(self):
return self.name
def get_nickname(self):
return self.school.nickname
执行时出现以下错误:
AttributeError: 'QuerySet' object has no attribute 'distance'
编辑--
当我尝试使用上述问题中的替代方法获取距离时,我得到了不同的错误,这使我认为我的模型存在问题。
point = Chapter.objects.get(name='Chapter of the Year').location
distance_m = 20000
for chapter in Chapter.objects.distance(point):
print(chapter.name, chapter.distance)
错误:
'Manager' object has no attribute 'distance'
Distance
? - Brett Jacksonfrom django.contrib.gis.db.models.functions import Distance
- jmq