[postgis-users] Union fails on 2389 linestrings.
nicolas.ribot at gmail.com
Tue Jul 27 07:27:24 PDT 2010
> ST_IsValid returns true for all of them. I'll try reducing the
> precision slightly, though I'm later going to do point-in-poly checks
> against some other original input data and the reduced precision will
> increase the chances of inaccurate results.
I'm wondering if using the notice message could be used in conjunction
with linear referencing functions to add the missing point to the
1- identify failing linestrings (or offending coordinates, then
finding the closest linestring to this point)
2- complete these linestrings with new points built from coordinates
3- relaunch the union procedure.
Though I've never done this.
More information about the postgis-users