[postgis-users] Is there a better way for Finding Gaps/Sliver Holes?

[Lars Aksel Opsahl]

>From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Shaozhong SHI <shishaozhong at gmail.com>
>Sent: Monday, May 2, 2022 12:22 PM
>To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
>Subject: [postgis-users] Is there a better way for Finding Gaps/Sliver Holes?
>
>This solution does not appear to be well explained.
>
>Find Topology Error With PostGIS (khairu-aqsara.net)
>
>Has anyone tested it?
>
>Is there a better way for Finding Gaps/Sliver Holes?
>
>Regards,
>
>David

Hi

At https://github.com/larsop/find-overlap-and-gap
we have code that checks for overlaps and gaps on simple feature polygons and creates a spatial tables with the results. We have used this code on tables  with millions  of rows.

And yes we see gaps/overlap as polygons, lines and points .

Lars
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220502/09ecc7e5/attachment.htm>