使用距离查询注释在Django 1.11中使用postgis查找最近距离似乎不正确

4

以下是我的模型:

class Coast(TimeStampedModel):
    position = PointField(null=True, srid=4326)
    shape_id = models.IntegerField(null=True)
    state = models.CharField(max_length=4, null=True, blank=True, choices=US_STATES)
    point_type = models.CharField(max_length=25, choices=cc.POINT_TYPES, default=cc.POINT_TYPES.COAST, db_index=True)
    interpolated = models.BooleanField(default=False)

这是我正在运行的代码:

def get_distances(current_address):
    return (models.Coast.objects
        .filter(point_type='COAST', position__distance_lte=(current_address, D(m=10000)))
        .annotate(distance=Distance("position", current_address))
        .order_by("distance"))

current_address = Point(x=26.3960373, y=-80.0755588, srid=4326)
distances = get_distances(current_address)
for dd in distances[0:10]:
    print 'distance:', dd.distance.m, current_address.distance(dd.position)

以下是输出:

distance: 1090.96923342 2.9609226587
distance: 1091.50068042 1.80716304192
distance: 1120.14014531 1.31372843777
distance: 1129.40394238 3.86868793486
distance: 1153.68196704 1.1093495446
distance: 1193.25809435 5.09212206614
distance: 1217.1136617 1.16301011591
distance: 1231.50011729 5.09984181242
distance: 1251.77367236 6.0540028636
distance: 1301.92838504 6.5265317962

我正在尝试找出为什么筛选查询集并按距离排序
.order_by('distance')

返回的顺序与手动计算两点之间的距离不同?
current_address.distance(dd.position)

我正在尝试找到距离当前地址最近的点。


有人能帮忙解决这个问题吗? - acmisiti
1
如果您使用srid = 4326,则可能需要手动计算距离(以米为单位),并通过您的函数以度数计算。 - Grzegorz Grabek
这正是我所怀疑的,但我不确定如何进行转换? - acmisiti
1个回答

0

需要点类的信息。

需要查看Point.distance是否应该是一个函数?


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接