Topology cleaning with PostGIS
An early tester of the new PostGIS Topology submitted an interesting dataset which kept me busy for a couple of weeks fixing a bunch of bugs related to numerical stability/robustness.
Finally, the ST_CreateTopoGeo function succeeded and imported the dataset as a proper topological schema. Here’s what it looks like:
Edges of the built topology At a first glance it doesn’t seem to be particularly problematic. Here’s the composition summary:
=# select topologysummary('small_sample_topo');
topologysummary
--------------------------------------------------------
Topology small_sample_topo (2042), SRID 0, precision 0
83 nodes, 156 edges, 74 faces, 0 topogeoms in 0 layers But the devil hides at high zoom levels.