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 ·
884 阅读 ·
0 评论