[postgis-devel] ST_Intersection(line,line) error

Rémi Cura remi.cura at gmail.com
Tue Dec 3 09:36:22 PST 2013


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

Cheers,
Rémi-C


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?
> Cheers,
> Rémi-C
>
> 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...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20131203/8dbace82/attachment.html>


More information about the postgis-devel mailing list