[postgis-devel] ST_Intersection(line,line) error
remi.cura at gmail.com
Tue Dec 3 09:36:22 PST 2013
it gives the right extremities, but so the segments between are lost.
A work around is to use ST_Split(line,point) instead,
while snapping point to line (closestPoint)
but this is painfull
2013/12/3 Rémi Cura <remi.cura at gmail.com>
> Hey list,
> ST_Intersection(line,line) seems to be faulty in the above case:
> It should return a line , but strangely enough it returns multipoints with
> the correct points of the line it should return.
> I guess I should be happy to have an answer at all.
> Any thought?
> SELECT row_number() over() as id, ST_AsText(ST_Intersection(l1,l2)),
> ST_Intersection(l1,l2) AS the_intersection, l1,l2
> FROM ST_GeomFromtext(' LINESTRING(1602.31065385555
> 21488.8919364873,1601.3 21494.4,1598.5 21510.2)') AS l1,
> ST_GeomFromText('LINESTRING(1605.3 21472.6,1601.3
> 21494.4,1601.21138045673 21494.9000674227)') AS l2
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-devel