django model postgis的一些操作

by giser · 2019-04-03

django.contrib.gis下

model声明中的差异

# Overrides Manager to return Geographic QuerySets

objects = GeoManager()

loc = models.PointField(srid=4326, db_index=True)

坐标声明

Point(123.456, 34,567)

比较空间距离

point = fromstr(‘POINT(%s %s)’ % (123.456, 34,567), srid=4326)

filter(loc__distance_lte=(point, 1000)).distance(point, field_name=’loc’).order_by(“distance”) # 例:小于等于1000米及排序

转载自：https://blog.csdn.net/yxteagle/article/details/49100913