Il 09/02/2015 02:31, John Abraham ha scritto: > Well I could say that using PostGIS ST_Intersects with "messy data" > always seems to give me TopologyExceptions. I've had luck with various > combinations of ST_SnapToGrid and ST_Buffer(0), but with messy data > there always seems to be some weird case that requires manually edits.
Hi John, have you tried ST_MakeValid? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html *New course* "QGIS for naturalists": http://www.faunalia.eu/en/nat_course.html _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users