SELECT DISTINCT ON(站名) *
FROM(
SELECT a.站名,a.小区名称,x.基站名称 ,x.基站标识,a.geom::geography<->x.geom::geography as Distance
FROM “铜陵3G工参” a
CROSS JOIN LATERAL (
SELECT b.基站名称,b.基站标识,b.geom
FROM “铜陵4G工参” b
ORDER BY (a.geom<->b.geom) asc
LIMIT 1
) as x
) as tmp
postgis 对基站最近距离关联关系检索
最新推荐文章于 2024-05-13 09:52:13 发布