PostGres查询附近300m的数据并计算距离
SELECT
ST_Distance (
ST_SetSRID ( ST_MakePoint ( 121.265221, 31.195005 ), 4326 ) :: geography,
ST_SetSRID ( ST_MakePoint ( a.lon::float8, a.lat::float8 ), 4326 ) :: geography
), a.*
FROM
(
SELECT
*
FROM
map_report_industrial_park
WHERE
ST_Distan
原创
2021-06-16 16:22:46 ·
774 阅读 ·
0 评论