使用 SQL 查询查找最近的纬度/经度 [英] Find nearest latitude/longitude with an SQL query

问题描述

我有纬度和经度，我想从数据库中提取记录，该记录具有距离最近的纬度和经度，如果该距离超过指定的距离，则不要检索它.

I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets longer than specified one, then don't retrieve it.

表结构:

id
latitude
longitude
place name
city
country
state
zip
sealevel

推荐答案

SELECT latitude, longitude, SQRT(
    POW(69.1 * (latitude - [startlat]), 2) +
    POW(69.1 * ([startlng] - longitude) * COS(latitude / 57.3), 2)) AS distance
FROM TableName HAVING distance < 25 ORDER BY distance;

其中 [starlat] 和 [startlng] 是开始测量距离的位置.

where [starlat] and [startlng] is the position where to start measuring the distance.

这篇关于使用 SQL 查询查找最近的纬度/经度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！