SELECT
lon,lat,id,name,
ST_Distance
(
point ( lon, lat ),
point ( 106.6890580000000, 26.60426400000000 )
)*111195 AS jl
FROM
rl_pollution_source_vocabulary
HAVING jl<=1000
mysql根据经纬度查询距离在1000米范围内的数据
于 2022-03-21 11:57:55 首次发布