[postgis-users] Finding all polygons crossing a large polygons boundary

[Mats Taraldsvik]

Hi,

I have a large polygon P in a query against a table A where I'm only
interested in A's polygons that touch/crosses the boundary of P.

I have tried https://postgis.net/docs/ST_DumpSegments.html but it does
generate a lot of geometries when the polygon has 100s or 1000s of points.

Are there more efficient approaches to this?

Regards,
Mats Taraldsvik
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231205/f4065470/attachment.htm>