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 <[email protected]> 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
