<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 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;
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;
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;
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;
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;
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;
font-family:"Arial","sans-serif";
color:#003285;}
span.E-MailFormatvorlage38
{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]-->
</head>
<body bgcolor="white" lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Hi Richard,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">thanks again for your reply! I’m really amazed about the active community around QGIS, never experienced that with any other GIS-Software!
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">‘Merge Selected Features’ is exactly the tool that I initially wanted to use and then realized that it creates multiline-features which causes problems
with my linestring db table. Meanwhile I will use QAD plugin that creates linestring or I will work with a local copy as you suggested.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">So for me it works quite OK with this workaround, but maybe it would be helpful to have an option to choose between creating multilinestring or linestring
when using the ‘Merge’ tool. What do others think? Useful and important enough to open an issue?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Benni</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#003285"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" 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 [mailto:richard.mcdonnell@opw.ie]
<br>
<b>Gesendet:</b> Mittwoch, 19. April 2017 16:02<br>
<b>An:</b> Fuenfer-Koenigstein.Benjamin G-PRA; qgis-user@lists.osgeo.org<br>
<b>Betreff:</b> Re: AW: [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">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.<o:p></o:p></p>
<div>
<p class="MsoNormal">On 19/04/2017 14:07, <a href="mailto:Fuenfer-Koenigstein.Benjamin@swm.de">
Fuenfer-Koenigstein.Benjamin@swm.de</a> wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Hi Richard,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">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.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Regards</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285">Benjamin</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#003285"> </span><o:p></o:p></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 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 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</span><o:p></o:p></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 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 href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a 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 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 href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a 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 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 href="http://www.opw.ie/"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none"><img border="0" width="405" height="225" id="_x0000_i1025" src="cid:image001.jpg@01D2B9AE.E1F65130" alt="Das Bild
wurde vom Absender entfernt."></span></a><o:p></o:p></p>
</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 href="http://www.opw.ie/"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none"><img border="0" width="405" height="225" id="_x0000_i1026" src="cid:image002.jpg@01D2B9AE.E1F65130" alt="Das Bild wurde vom Absender entfernt."></span></a><o:p></o:p></p>
</div>
</body>
</html>