<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Another option, you could try is using the<b> Advanced Digitising
Toolbar</b> under <b>View, Toolbars<br>
</b>Select the lines you want to merge/Join and click <b>Merge
Selected Features</b>.<br>
This should also allow you to edit the DB directly from QGIS.<br>
I have not tried it, so your issue with Multi-Lines instead of
single linestrings may still apply.<br>
You could still use the above example on the locally saved version
of the table though and upload and overwrite the changed dataset.<br>
Sorry I cant be of more help.<br>
Reagrds,<br>
<br>
Richard.<br>
<div class="moz-cite-prefix">On 19/04/2017 14:07,
<a class="moz-txt-link-abbreviated" href="mailto:Fuenfer-Koenigstein.Benjamin@swm.de">Fuenfer-Koenigstein.Benjamin@swm.de</a> wrote:<br>
</div>
<blockquote
cite="mid:EB40934938ED3C4C81B5998181C6D34C1C6AD603@SVEXMB04.intra.swm.de"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 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";
color:black;}
h1
{mso-style-priority:9;
mso-style-link:"Überschrift 1 Zchn";
margin-top:24.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:14.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;}
h2
{mso-style-priority:9;
mso-style-link:"Überschrift 2 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:13.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;}
h3
{mso-style-priority:9;
mso-style-link:"Überschrift 3 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;}
h4
{mso-style-priority:9;
mso-style-link:"Überschrift 4 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;
font-style:italic;}
h5
{mso-style-priority:9;
mso-style-link:"Überschrift 5 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:normal;}
h6
{mso-style-priority:9;
mso-style-link:"Überschrift 6 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:normal;
font-style:italic;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{mso-style-priority:9;
mso-style-link:"Überschrift 7 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-style:italic;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
{mso-style-priority:9;
mso-style-link:"Überschrift 8 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{mso-style-priority:9;
mso-style-link:"Überschrift 9 Zchn";
margin-top:10.0pt;
margin-right:0cm;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-style:italic;}
p.MsoTitle, li.MsoTitle, div.MsoTitle
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
margin-top:0cm;
margin-right:0cm;
margin-bottom:15.0pt;
margin-left:0cm;
mso-add-space:auto;
border:none;
padding:0cm;
font-size:26.0pt;
font-family:"Times New Roman","serif";
color:black;
letter-spacing:.25pt;}
p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, div.MsoTitleCxSpFirst
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin:0cm;
margin-bottom:.0001pt;
mso-add-space:auto;
border:none;
padding:0cm;
font-size:26.0pt;
font-family:"Times New Roman","serif";
color:black;
letter-spacing:.25pt;}
p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin:0cm;
margin-bottom:.0001pt;
mso-add-space:auto;
border:none;
padding:0cm;
font-size:26.0pt;
font-family:"Times New Roman","serif";
color:black;
letter-spacing:.25pt;}
p.MsoTitleCxSpLast, li.MsoTitleCxSpLast, div.MsoTitleCxSpLast
{mso-style-priority:10;
mso-style-link:"Titel Zchn";
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:15.0pt;
margin-left:0cm;
mso-add-space:auto;
border:none;
padding:0cm;
font-size:26.0pt;
font-family:"Times New Roman","serif";
color:black;
letter-spacing:.25pt;}
p.MsoSubtitle, li.MsoSubtitle, div.MsoSubtitle
{mso-style-priority:11;
mso-style-link:"Untertitel Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
letter-spacing:.75pt;
font-style:italic;}
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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing
{mso-style-priority:1;
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Times New Roman","serif";
color:windowtext;}
p.MsoIntenseQuote, li.MsoIntenseQuote, div.MsoIntenseQuote
{mso-style-priority:30;
mso-style-link:"Intensives Zitat Zchn";
margin-top:10.0pt;
margin-right:46.8pt;
margin-bottom:14.0pt;
margin-left:46.8pt;
border:none;
padding:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;
font-style:italic;}
span.MsoIntenseEmphasis
{mso-style-priority:21;
color:black;
font-weight:bold;
font-style:italic;}
span.berschrift1Zchn
{mso-style-name:"Überschrift 1 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 1";
font-family:"Arial","sans-serif";
color:black;
font-weight:bold;}
span.berschrift2Zchn
{mso-style-name:"Überschrift 2 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 2";
font-family:"Arial","sans-serif";
color:black;
font-weight:bold;}
span.TitelZchn
{mso-style-name:"Titel Zchn";
mso-style-priority:10;
mso-style-link:Titel;
font-family:"Arial","sans-serif";
color:black;
letter-spacing:.25pt;}
span.UntertitelZchn
{mso-style-name:"Untertitel Zchn";
mso-style-priority:11;
mso-style-link:Untertitel;
font-family:"Arial","sans-serif";
color:black;
letter-spacing:.75pt;
font-style:italic;}
span.IntensivesZitatZchn
{mso-style-name:"Intensives Zitat Zchn";
mso-style-priority:30;
mso-style-link:"Intensives Zitat";
color:black;
font-weight:bold;
font-style:italic;}
span.berschrift3Zchn
{mso-style-name:"Überschrift 3 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 3";
font-family:"Arial","sans-serif";
color:black;
font-weight:bold;}
span.berschrift4Zchn
{mso-style-name:"Überschrift 4 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 4";
font-family:"Arial","sans-serif";
color:black;
font-weight:bold;
font-style:italic;}
span.berschrift5Zchn
{mso-style-name:"Überschrift 5 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 5";
font-family:"Arial","sans-serif";
color:black;}
span.berschrift6Zchn
{mso-style-name:"Überschrift 6 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 6";
font-family:"Arial","sans-serif";
color:black;
font-style:italic;}
span.berschrift7Zchn
{mso-style-name:"Überschrift 7 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 7";
font-family:"Arial","sans-serif";
color:black;
font-style:italic;}
span.berschrift8Zchn
{mso-style-name:"Überschrift 8 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 8";
font-family:"Arial","sans-serif";
color:black;}
span.berschrift9Zchn
{mso-style-name:"Überschrift 9 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 9";
font-family:"Arial","sans-serif";
color:black;
font-style:italic;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
span.E-MailFormatvorlage37
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:#003285;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 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]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Hi
Richard,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"
lang="EN-US">thanks for your suggestion! I think Dissolve
won’t work for me as it’s applied to the whole layer (hope I
understood this right). I’m looking for a way to easily
merge certain linestrings when I, for example, want to
create one geometry by first creating a spline and then a
straight line feature. I will try out your workaround with
local files. But as the db-source is very large (>
500.000 rows) I’m happy for any other suggestion to solve it
directly in QGIS with db-source.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"
lang="EN-US">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"
lang="EN-US">Benjamin</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#003285"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"><o:p> </o:p></span></p>
<div>
<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";color:windowtext">Von:</span></b><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">
Richard McDonnell [<a class="moz-txt-link-freetext" href="mailto:richard.mcdonnell@opw.ie">mailto:richard.mcdonnell@opw.ie</a>]
<br>
<b>Gesendet:</b> Mittwoch, 19. April 2017 10:10<br>
<b>An:</b> David J. Bakeman;
Fuenfer-Koenigstein.Benjamin G-PRA;
<a class="moz-txt-link-abbreviated" href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Qgis-user] Join multiple
Linestrings to single Linestring<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Benjamin,<br>
You could try Dissolve, under Geoprocessing Tools,
alternatively you could try saving the dataset locally as a
shapefile, edit using either of the methods you outlined
below, In relation to saving the edits back to the table as
linestring, use the DB Manager tool, select the table you wish
to update, tick the options you want, making sure both
<b>Replace destination Table (if exists) </b>and<b> Create
single-part geometries instead of multi-part</b> This has
worked for me in the past, admittedly for polygons, but it
should also work for linestrings.<br>
<br>
Hope this helps,<br>
<br>
Richard.<o:p></o:p></p>
<div>
<p class="MsoNormal">On 18/04/2017 17:24, David J. Bakeman
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>On 04/18/2017 02:17 AM, <a moz-do-not-send="true" href="mailto:Fuenfer-Koenigstein.Benjamin@swm.de">Fuenfer-Koenigstein.Benjamin@swm.de</a> wrote:<o:p></o:p></pre>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>Hi there,<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>I want to merge multiple linestrings with same start/endpoint to a single linestring (all lines within one layer). As I use a PostGIS source with geometry type linestring, it is important that the new geometry is still linestring and not multilinestring type. "Merge selected features" tool and "JOIN" in QAD-Plugin both create multilinestrings. Has anyone an idea how to directly merge into linestring or how to change geometry type after merging? Thanks for your suggestions!<o:p></o:p></pre>
</blockquote>
<pre>I'm not sure I completely understand what you want but you could run<o:p></o:p></pre>
<pre>multipart to singleparts from the Vector/Geometry Tools menu on the<o:p></o:p></pre>
<pre>multilinestring layer to generate a layer with just linestrings.<o:p></o:p></pre>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre><o:p> </o:p></pre>
<pre>Best regards<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Benjamin<o:p></o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a moz-do-not-send="true" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a moz-do-not-send="true" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a moz-do-not-send="true" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a moz-do-not-send="true" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><span style="font-size:7.5pt">GIS Specialist PgD GIS
AssocSCSI</span></b><br>
<b><span style="font-size:10.0pt">OPW FRM Data Management</span></b><br>
<b><span style="font-size:10.0pt">52 Stephens Green, Dublin
2.</span></b><br>
<span style="font-size:7.5pt">TEL: 01 6476543</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><a moz-do-not-send="true"
href="http://www.opw.ie/"><span style="border:solid
windowtext 1.0pt;padding:0cm;text-decoration:none"><img
id="_x0000_i1025"
src="cid:part8.07040608.08060307@opw.ie" alt="Das Bild
wurde vom Absender entfernt." border="0" height="225"
width="405"></span></a><o:p></o:p></p>
</div>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<p></p>
<a href="http://www.opw.ie/"><img src="http://www.opw.ie/en/media/opw-logo-december-2016.gif" width="405" height="225" /></a>
</body>
</html>