<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head><body style="zoom: 0%;"><div dir="auto">Have you tried st_linemerge on the collection? <br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get <!-- tmjah_g_1299e --><a href="http://www.bluemail.me/r?b=15860"><!-- tmjah_g_1299s -->BlueMail for Android<!-- tmjah_g_1299e --></a><!-- tmjah_g_1299s --> <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On Jun 26, 2020, at 8:29 AM, Guillaume ARNAUD <<a href="mailto:guillaume.arnaud@ledepartement82.fr" target="_blank">guillaume.arnaud@ledepartement82.fr</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<p>Hello,<br>
<br>
From a series of continuous lines, I must join them to have only
one. With St_collect or st_union, it joins the lines in any
direction and therefore creates multiparts for me. Is there a way
to avoid this?</p>
<p>Thank you.</p>
<div class="moz-signature">-- <br>
<table width="450" height="100" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr valign="bottom">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC"> </td>
<td>
<br>
</td>
</tr>
<tr>
<td>
<a href="http://www.ledepartement.fr" hreflang="fr">
<img src="http://www.ledepartement.fr/fileadmin/integration/lib/images/logo-cd82-footer.png" alt="Logo CD82" width="150" border="0" align="left">
</a> </td>
<td>
<font size="3" face="Eras Medium ITC">
Guillaume ARNAUD
</font><br>
<font size="2" face="Eras Medium ITC">
Technicien SIG
</font><br>
<font medium="" itc="itc" size="»2»" face="»Eras">
Cellule SIGD
</font><br>
<font medium="" itc="itc" size="»2»" face="»Eras">
Direction des systèmes informatiques et de
télécommunication
</font><br>
<font medium="" itc="itc" size="»2»" face="»Eras">
Pôle coordination et ressources
</font><br>
<font size="2" face="Eras Medium ITC">Tél : 05 63 91 82 37
</font><br>
<a class="moz-txt-link-freetext" href="mailto: guillaume.arnaud@ledepartement82.fr"><font size="2">
guillaume.arnaud@ledepartement82.fr
<!--
font--></font></a><font size="2">
</font></td>
</tr>
<tr valign="top">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC">
</td>
</tr>
</tbody>
</table>
</div>
<pre class="blue"><hr><br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre></blockquote></div></body></html>