[postgis-devel] ST_Intersection(line,line) error
remi.cura at gmail.com
Tue Dec 3 10:37:50 PST 2013
indeed way easier,
2013/12/3 Paul Ramsey <pramsey at cleverelephant.ca>
> Another workaround is to slightly buffer one of the lines
> On December 3, 2013 at 9:36:25 AM, Rémi Cura (remi.cura at gmail.com<//remi.cura at gmail.com>)
> 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
> 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
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-devel