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

[Martin Davis]

That blog post does provide useful queries for finding polygon overlaps and
gaps.

Overlaps are found via testing if polygon interiors intersect, using the
DE-9IM relate mask 2********.

Gaps are found by identifying holes in the union of the set of polygons.
One issue with this is that computing the union of large datasets can be
slow.  Lars' solution provides some ideas for dealing with this.



On Mon, May 2, 2022 at 3:22 AM Shaozhong SHI <shishaozhong at gmail.com> wrote:

> This solution does not appear to be well explained.
>
> Find Topology Error With PostGIS (khairu-aqsara.net)
> <https://www.khairu-aqsara.net/blog/find-topology-error-with-postgis>
>
> Has anyone tested it?
>
> Is there a better way for Finding Gaps/Sliver Holes?
>
> Regards,
>
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220502/a9e4269b/attachment.htm>