先通过ST_Buffer()函数生成缓冲区对象如存储到onegradebuffe字段中,然后再利用ST_Intersects()函数在表中搜索geom字段表示的对象与onegradebuffe字段表示的缓冲区对象相交的多有对象,即是检索出的缓冲区对象,如:
select objectid from poly where ST_Intersects(ST_Transform(geom,3857),ST_Transform((select onegradebuffer from polytest where objectid=20589),3857))=true
@Query(value = "SELECT * FROM gct_park AS gb WHERE ST_Intersects(?1,gb.geom) and gb.city_id in (?2) and deleted = 0", nativeQuery = true) List<GctPark> getScopeLayerAdmin(String geo,List<String> cityIds);