根据经纬度查询所在的地块详情
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
你接受吗
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