使用 SQL 查询查找最近的纬度/经度

2021-11-20 00:00:00 coordinates sql geospatial mysql

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

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.

相关文章