<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
font-variant:normal !important;
color:#1F497D;
text-transform:none;
text-shadow:none;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=FR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>Hi, thanks for your answers,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>I didn't interpret well what st_split would do, I thought st_split(line, set of n points) would returns n+1 set of lines segments but in fact it returns 2 n lines, input line being cut n times. So I have to search another way, likely as Nicolas suggested with st_lineLocatePoint and st_lineSubstring, or using st_split one point at a time.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>Olivier<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De :</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] <b>De la part de</b> Alexandre Neto<br><b>Envoyé :</b> vendredi 9 février 2018 13:31<br><b>À :</b> PostGIS Users Discussion<br><b>Objet :</b> Re: [postgis-users] splitting a linestring with points<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Beware that hitting a line with a point can be tricky in terms of accuracy. Unless the point is snapped to one of the line's vertices, if you zoom enough, it will not be on top of the line. That may be the reason why you are not getting the desired results. <o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Olivier Leprêtre <<a href="mailto:o.lepretre@gmail.com">o.lepretre@gmail.com</a>> escreveu no dia sexta, 9/02/2018 às 09:55:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><p class=MsoNormal>Hi Martin<br><br>I hoped but it's doesn't with results from st_collectionExtract(st_Split())<br><br>Olivier<br><br>-----Message d'origine-----<br>De : postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] De la part de Martijn Meijers<br>Envoyé : vendredi 9 février 2018 09:15<br>À : <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>Objet : Re: [postgis-users] splitting a linestring with points<br><br>st_dump would make it possible, no?<br><br>select st_astext((st_dump('MULTILINESTRING((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)<br><br><br><br>On 08-02-18 21:48, Olivier Leprêtre wrote:<br>><br>> Hi,<br>><br>> I want to break a linestring into linestrings by breaking it with a<br>> set of points along this line. This appeared easy at first but<br>> finally, I tried using st_split(line, set of points) but this returns<br>> multilinestrings when I just wants linestrings. I tried several<br>> functions like st_dump, st_geometryN, stcollectionextract and so on<br>> after st_split but did not find how could I get only rows of<br>> linestring splitted by the points acting like blades on the first<br>> linestring.<br>><br>> Thanks for any help,<br>><br>> Olivier<br>><br>><br>> <<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient</a>><br>> Garanti sans virus. <a href="http://www.avast.com" target="_blank">www.avast.com</a><br>> <<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient</a>><br>><br>><br>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><br>><br>><br>> _______________________________________________<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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br><br>_______________________________________________<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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br><br><br>---<br>L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.<br><a href="https://www.avast.com/antivirus" target="_blank">https://www.avast.com/antivirus</a><br><br>_______________________________________________<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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></p></blockquote></div><p class=MsoNormal>-- <o:p></o:p></p><div><div><div><p class=MsoNormal>Alexandre Neto<o:p></o:p></p></div><div><p class=MsoNormal>---------------------<o:p></o:p></p></div><div><p class=MsoNormal>@AlexNetoGeo<o:p></o:p></p></div><div><p class=MsoNormal><a href="http://sigsemgrilhetas.wordpress.com">http://sigsemgrilhetas.wordpress.com</a><o:p></o:p></p></div><p class=MsoNormal><a href="http://gisunchained.wordpress.com">http://gisunchained.wordpress.com</a><o:p></o:p></p></div></div></div></body></html>