<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hola Emilio,</p>
<p>you can try do generate a new virtual Layer with a union of the
geometry grouped by the geometry itself and use this one for
labeling. The following statement will define your new virtual
layer:</p>
<p><b><i>select mylayer.labelfield, st_union(</i></b><b><i>mylayer</i></b><b><i>.geometry)
from </i></b><b><i>mylayer</i></b><b><i> group by </i></b><b><i>mylayer</i></b><b><i>.geometry</i></b><br>
</p>
<p>The result will be a new layer with no double geometries.</p>
<p>Hope this helps</p>
<p>Best regards</p>
<p>Stefan<br>
</p>
<pre class="moz-signature" cols="72">Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
-----------------------------------
Aufwind durch Wissen!
Qualifizierte Open-Source-Schulungen
bei der <a class="moz-txt-link-abbreviated" href="http://www.foss-academy.com">www.foss-academy.com</a>
-----------------------------------
WhereGroup GmbH & Co. KG
Schwimmbadstr. 2
79100 Freiburg
Germany
Fon: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11
<a class="moz-txt-link-abbreviated" href="mailto:stefan.giese@wheregroup.com">stefan.giese@wheregroup.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.wheregroup.com">www.wheregroup.com</a>
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
-------------------------------</pre>
<div class="moz-cite-prefix">Am 25.06.2018 um 10:32 schrieb Emilio
Abad Vidal:<br>
</div>
<blockquote type="cite"
cite="mid:58780999.528408.1529915570311.JavaMail.root@mail.cesga.es">
<pre wrap="">Hello everyone,
I have a problem and I can not find the solution. I would appreciate any help.
I have a layer of lines that represent stretches of electrical conductors. These sections have a point of origin and an end point. One of its attributes is the length of each of the sections.
Some of these sections have the same point of origin and the same ending point, so when I label these lines by their length, this repeated data appears for each of the lines and the data is repeated.
I need that when labeling the layer, only the label of one of the lines appears, that is, that the distance between each of the points is represented. I have tried to do it by means of a labeling based on rules, and some function of aggregation by geometry, so that only one label is shown for each space between points.
I do not get it, so I would appreciate any help to solve this problem.
Thank you very much in advance and greetings
</pre>
</blockquote>
<br>
</body>
</html>