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

[Paolo Cavallini]

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