[postgis-users] postgis topology

[Rémi Cura]

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 <strk at keybit.net>

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140115/08c354f2/attachment.html>