擅长:python、mysql、java
<p>对于您来说,切换到位置感知数据库(如postgresql(带有postgis扩展)或mysql 5.7)要容易得多。如果您查看与某个点具有给定距离的对象,那么对于这样一个数据库来说,这是一个微不足道的查询,并且是<a href="https://docs.djangoproject.com/en/1.9/ref/contrib/gis/geoquerysets/#dwithin" rel="nofollow">fully supported by django</a></p>
<blockquote>
<p>Dwithin Returns models where the distance to the geometry field from
the lookup geometry are within the given distance from one another.
Note that you can only provide Distance objects if the targeted
geometries are in a projected system. For geographic geometries, you
should use units of the geometry field (e.g. degrees for WGS84) .</p>
<p>Example:</p>
<p><code>Zipcode.objects.filter(poly__dwithin=(geom, D(m=5)))</code></p>
</blockquote>
<p>这样,您的复杂代码就变成了一行代码。地理空间数据库中有许多功能,您会发现这些功能相当有用。你知道吗</p>