[postgis-users] Getting TopologyExections when trying to node linestrings to create an overlay

Paolo Cavallini cavallini at faunalia.it
Sun Feb 8 23:31:52 PST 2015

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":

More information about the postgis-users mailing list