[postgis-users] postgis topology

[Sandro Santilli]

On Tue, Jan 14, 2014 at 04:10:45PM +0100, Ludovic Granjon wrote:

> UPDATE ec SET topogeom2 = toTopoGeom(geom, 'ec_topo', 1, 1.0);
...
> ERREUR: Spatial exception - geometry intersects edge 262
...
> Have  you a solution for that ?

Do the update in chunks. That way you'll import what can be and isolate
the offending record (if still offending) and then fight with that one
individually.

These kind of error sometime happen when the tolerance you specify
is bigger than the smallest distance between any two vertices in
your input dataset. An ST_SnapToGrid with given tolerance might also
give you better results, but the chunked loading is always the best
way to do topology building.

--strk;