select a.“Lon” as “Mrlon”,a.“Lat” as “Mrlat”,a.“总采样点数” as “CellMRCount”,a.“栅格平均电平” as “AvgeRSRQ”,a.“Ci” as “Ci”,a.geom as geom, c.“Lon”,c.“Lat”, c.“小区名称”, c.“Ang” from “mrhuawei安庆” as a LEFT JOIN “lte小区工参geom” as c ON c.“Ci”=a.“Ci” where ST_Within(a.“geom”,ST_Buffer(ST_GeomFromText(‘Point(117.0497904172115 30.51027617867294)’,4326)::geography, 4000, ‘quad_segs=2’)::geometry)
postgis 如何用米制单位 buffer
于 2022-05-30 14:23:19 首次发布