根据经纬度查询所在的地块详情

select st_asgeojson(geom) geom,

st_asgeojson(st_centriod(geom)) "centerJson"

from xxxtable

where geom is not null and st_intersects(geom,ST_geomFromText('point(${lng} ${lat})',4326)) limit 1

posted on 2024-08-05 16:43  黑子菜园  阅读(32)  评论(0)    收藏  举报

导航