<div dir="ltr">Hi,<div><br></div><div>One very efficient way of splitting lines is to use Linear Referencing functions (<a href="http://postgis.net/docs/reference.html#Linear_Referencing">http://postgis.net/docs/reference.html#Linear_Referencing</a>)</div><div>st_lineLocatePoint and st_lineSubstring will allow you to cut your linestring according to points locations along the line.</div><div><br></div><div>Nicolas</div></div><div class="gmail_extra"><br><div class="gmail_quote">On 9 February 2018 at 09:14, Martijn Meijers <span dir="ltr"><<a href="mailto:b.m.meijers@tudelft.nl" target="_blank">b.m.meijers@tudelft.nl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">st_dump would make it possible, no?<br>
<br>
select st_astext((st_dump('MULTILINES<wbr>TRING((0 0, 10 10), (20 20, 30 30))')).geom);<br>
        st_astext<br>
-------------------------<br>
 LINESTRING(0 0,10 10)<br>
 LINESTRING(20 20,30 30)<br>
(2 rows)<span class=""><br>
<br>
<br>
<br>
On 08-02-18 21:48, Olivier Leprêtre wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
<br>
Hi,<br>
<br>
I want to break a linestring into linestrings by breaking it with a set of points along this line. This appeared easy at first but finally, I tried using st_split(line, set of points) but this returns multilinestrings when I just wants linestrings. I tried several functions like st_dump, st_geometryN, stcollectionextract and so on after st_split but did not find how could I get only rows of linestring splitted by the points acting like blades on the first linestring.<br>
<br>
Thanks for any help,<br>
<br>
Olivier<br>
<br>
<br></span>
<<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" rel="noreferrer" target="_blank">https://www.avast.com/sig-ema<wbr>il?utm_medium=email&utm_source<wbr>=link&utm_campaign=sig-email&<wbr>utm_content=emailclient</a>>       Garanti sans virus. <a href="http://www.avast.com" rel="noreferrer" target="_blank">www.avast.com</a> <<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" rel="noreferrer" target="_blank">https://www.avast.com/sig-ema<wbr>il?utm_medium=email&utm_source<wbr>=link&utm_campaign=sig-email&<wbr>utm_content=emailclient</a>> <br>
<br>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2A<wbr>A1F9FDF2><br>
<br>
<br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br>
</blockquote>
<br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a></blockquote></div><br></div>