PostGIS Combining ST_Touches and ST_Buffer

[المشرف العام]

Im looking for a PostGIS/Postgres query thats a bit tricky. To find all polygons within a radius and all neighboring polygons to the polygon where I have my coordinates

SELECT * FROM polygons_wgs84 where ST_Intersects(geom, ST_Transform(ST_Buffer(ST_Transform(ST_SetSRID(ST_MakePoint(9.116447, 60.548203), 4326), 3857), 1000), 4326))

And the polygons that ST_Touches the polygon Im "in" or something

cheers Henrik



أكثر...