<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Another workaround is to slightly buffer one of the lines</div> <div id="bloop_sign_1386092502239602176"><div><br></div><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br><span>http://postgis.net</span><div><span>http://cleverelephant.ca</span></div><div><br></div></div> <br><p style="color:#A0A0A8;">On December 3, 2013 at 9:36:25 AM, Rémi Cura (<a href="mailto://remi.cura@gmail.com">remi.cura@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div>
<title></title>
<div dir="ltr">
<div>Correction :<br>
it gives the right extremities, but so the segments between are
lost.<br>
<br>
A work around is to use ST_Split(line,point) instead,<br>
while snapping point to line (closestPoint)<br>
but this is painfull<br>
<br></div>
Cheers,<br>
Rémi-C<br></div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/12/3 Rémi Cura <span dir="ltr"><<a href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>Hey list,<br>
<br></div>
ST_Intersection(line,line) seems to be faulty in the above
case:<br>
It should return a line , but strangely enough it returns
multipoints with the correct points of the line it should
return.<br>
<br></div>
<div>I guess I should be happy to have an answer at
all.<br></div>
Any thought?<br></div>
Cheers,<br>
Rémi-C<br>
<div>
<div><br>
SELECT row_number() over() as id,
ST_AsText(ST_Intersection(l1,l2)), ST_Intersection(l1,l2) AS
the_intersection, l1,l2<br>
FROM
ST_GeomFromtext(' LINESTRING(1602.31065385555
21488.8919364873,1601.3 21494.4,1598.5 21510.2)') AS l1,<br>
ST_GeomFromText('LINESTRING(1605.3 21472.6,1601.3
21494.4,1601.21138045673 21494.9000674227)') AS l2<br>
<br>
<br></div>
</div>
</div>
</blockquote>
</div>
<br></div>
_______________________________________________
<br>postgis-devel mailing list
<br>postgis-devel@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</div></div></span></blockquote></body></html>