Last chance : this function is a a sloghtly modified topogeom constructor that won't stop when habving an error. This way you can import everything that works, and then deal with the unworking ...
2014/1/15 Sandro Santilli <[email protected]> > 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; > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
