<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 15 (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:"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:Aptos;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Aptos",sans-serif;}
span.EmailStyle23
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:531966725;
mso-list-template-ids:850015258;}
@list l0:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1
{mso-list-id:788087702;
mso-list-template-ids:736679450;}
@list l1:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l2
{mso-list-id:831339888;
mso-list-template-ids:1268517136;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3
{mso-list-id:857356583;
mso-list-template-ids:-1369131312;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:1351174908;
mso-list-template-ids:-92761156;}
@list l4:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l4:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l5
{mso-list-id:1928153108;
mso-list-template-ids:-1153901088;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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="LB-LU" link="#0563C1" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US">Hallo zusammen,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US">vielen Dank für eure Hinweise und Fragen.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US">In QGIS – wie auch in Lizmap – wird die PostgreSQL-PostGIS Datenbanktabelle (welche die Geometrien Punkt & Polygon enthält) in Form von
<b>zwei</b> separaten Layern dargestellt, da (wahrscheinlich) weder QGIS noch Lizmap dies mit einem Layer können. Beide Layer greifen jedoch auf dieselbe Tabelle mit zwei Geometrien in der Datenbank zurück.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US">Ein Vorteil für uns ist z.B. dass ein Lizmap-Nutzer nur einen Punkt erstellen muss und ein Datenbank-Trigger die Polygongeometrie z.B. der Katasterparzelle / des Grundstückes auf der der
Punkt liegt aus einem Grundstückslayer herausliest und in die Datenbank-Tabelle ablegt. Das erspart dem Nutzen das „Nachzeichnen“ des Grundstückes, er muss nur den Punkt zeichnen und die Polygongeometrie des Grundstückes wird automatisiert in die Tabelle abgelegt.
Vielleicht kann diese Aufgabe jedoch auch auf einem anderen Wege gelöst werden?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal">Liebe Grüße,<o:p></o:p></p>
<p class="MsoNormal">Tobias<span style="mso-fareast-language:EN-US"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:6.0pt"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual">Mat frëndleche Gréiss +++ Meilleures salutations +++ Mit freundlichen Grüssen
+++ Kind Regards<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="549">
<tbody>
<tr style="height:27.5pt">
<td width="180" style="width:134.65pt;padding:0cm 11.25pt 15.0pt 0cm;height:27.5pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:12.0pt;line-height:105%;mso-fareast-language:EN-US"><img width="149" height="59" style="width:1.552in;height:.6145in" id="Image_x0020_1" src="cid:image001.png@01DB2486.F96C17F0" alt="sias"></span><span style="mso-ligatures:standardcontextual;mso-fareast-language:EN-US"><o:p></o:p></span></p>
</td>
<td width="180" valign="top" style="width:134.65pt;padding:0cm 0cm 15.0pt 22.5pt;height:27.5pt">
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><span lang="FR-LU" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">Tobias Mosthaf</span><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">
<br>
</span><b><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#EE7D00;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">Natura 2000<br>
</span></b><b><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">T
</span></b><span lang="FR-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">+ 352 34 94 10 – 34<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><b><span lang="DE-LU" style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US">E
</span></b><span style="font-size:12.0pt;line-height:105%;mso-ligatures:standardcontextual;mso-fareast-language:EN-US"><a href="mailto:t.mosthaf@sias.lu"><span lang="DE-LU" style="color:#946B43;text-decoration:none">t.mosthaf@sias.lu</span></a> </span><span style="mso-ligatures:standardcontextual;mso-fareast-language:EN-US"><o:p></o:p></span></p>
</td>
<td width="190" style="width:142.45pt;padding:0cm 0cm 0cm 0cm;height:27.5pt">
<p class="MsoNormal" align="center" style="margin-left:-7.65pt;text-align:center;text-indent:-.55pt;line-height:105%">
<span style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US"> </span><span style="font-size:12.0pt;line-height:105%;mso-fareast-language:EN-US"><img border="0" width="144" height="69" style="width:1.5in;height:.7187in" id="_x0000_i1028" src="cid:image002.png@01DB2486.F96C17F0" alt="Une image contenant texte, capture d’écran, dessin humoristique, Graphique
Description générée automatiquement"></span><span lang="FR-LU" style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual;mso-fareast-language:EN-US"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual">SIAS - Syndicat intercommunal à vocation multiple<br>
</span></b><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43;mso-ligatures:standardcontextual">5, rue Neihaischen - L-2633 Senningerberg<br>
<b><u><a href="http://www.sias.lu/"><span style="color:#946B43">www.sias.lu</span></a><o:p></o:p></u></b></span></p>
<p class="MsoNormal"><u><span style="font-size:12.0pt;color:#946B43;mso-ligatures:standardcontextual"><a href="http://www.natura2000.lu/"><b><span style="font-family:"Calibri",sans-serif;color:#946B43">www.natura2000.lu</span></b></a></span></u><u><span style="color:#946B43;mso-ligatures:standardcontextual"><o:p></o:p></span></u></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://www.facebook.com/www.sias.lu/"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" width="9" height="19" style="width:.0937in;height:.1979in" id="Image_x0020_3" src="cid:image003.png@01DB2486.F96C17F0"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-ligatures:standardcontextual"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" width="19" height="19" style="width:.1979in;height:.1979in" id="Image_x0020_4" src="cid:image004.png@01DB2486.F96C17F0"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-ligatures:standardcontextual"> </span><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;text-decoration:none"><img border="0" width="28" height="19" style="width:.2916in;height:.1979in" id="Image_x0020_5" src="cid:image005.png@01DB2486.F96C17F0"></span></a><span lang="EN-US" style="font-size:12.0pt;mso-ligatures:standardcontextual"> <br>
</span><span style="font-size:11.5pt;font-family:Webdings;color:#C8D400;mso-ligatures:standardcontextual">P</span><span style="font-size:12.0pt;color:#C8D400;mso-ligatures:standardcontextual"> Be environmentally friendly: please do not print this email unless
it is entirely necessary. </span><span lang="EN-US" style="font-size:12.0pt;mso-ligatures:standardcontextual"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FR" style="font-family:"Calibri",sans-serif">De :</span></b><span lang="FR" style="font-family:"Calibri",sans-serif"> Peter Berger <peter.berger@bluewin.ch>
<br>
<b>Envoyé :</b> 22. Oktober2024 13:05<br>
<b>À :</b> guenter@lizmap.de<br>
<b>Cc :</b> Tobias Mosthaf <T.Mosthaf@sias.lu>; lizmap-de@lists.osgeo.org<br>
<b>Objet :</b> Re: [Lizmap-de] Lizmap - Fehlermeldung Edit Layer mit zwei Geometrien<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Soweit ich das sehe kann man in QGIS nur Vektorlayer für entweder Punkte, Polygone oder Linien erstellen. <span style="font-size:12.0pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Irre ich mich?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Liebe Grüsse<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Peter<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt">Am 22.10.2024 um 08:00 schrieb Günter Wagner via Lizmap-de <<a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a>>:<o:p></o:p></p>
</blockquote>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Hallo Tobias,</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">ich habe im Moment leider nicht die Zeit um mir Dein Problem näher anzuschauen.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Aber warum eine Tabelle für zwei Geometriearten? Hätte nicht gedacht, dass das überhaupt im QGIS geht.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Das Problem mit Punkten und Polygonen hatte ich allerdings auch mal.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Ich habe dann mit einem kleinen Puffer um den Punkt ein Polygon erzeugt. Ist das vielleicht auch bei Dir ein Lösungsansatz?</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Viele Grüße</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif">Günter</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Calibri",sans-serif"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-family:"Calibri",sans-serif;mso-fareast-language:DE">Von:</span></b><span style="font-family:"Calibri",sans-serif;mso-fareast-language:DE"> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Tobias Mosthaf via Lizmap-de<br>
<b>Gesendet:</b> Montag, 21. Oktober 2024 17:43<br>
<b>An:</b> <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> [Lizmap-de] Lizmap - Fehlermeldung Edit Layer mit zwei Geometrien</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Hallo in die Runde,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">wir haben in einer PostgreSQL / PostGIS - Datenbank eine Tabelle erstellt, die als Attribute / Spalten eine Punkt-
<b><u>und</u></b> eine Polygon-Geometrie besitzt.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Beim Erstellen eines Eintrages über Lizmap in der Datenbank treten keine Fehler auf. Wenn ich jedoch z.B. die Punkt-Geometrie
<b>editieren</b> möchte (<b>und</b> der dazugehörige Eintrag in der Datenbank auch eine Polygon-Geometrie besitzt), kommt die folgende Fehlermeldung (s. Screenshot im Anhang):
<i>unzulässige Anfrage(ERROR: parse error - invalid geometry HINT: "01" <-- parse error at position 2 within geometry(SELECT GeometryType(ST_GeomFromText('0106000020787F0000010000000103000000010000000600000000E87F1898A212414C3BC9F509F754411C10BDE8AAA31241011B946E07F754414265313685A31241F6B1B4D319F7544142045515AAA21241DCB24D0B1AF7544142045515AAA21241DCB24D0B1AF7544100E87F1898A212414C3BC9F509F75441',
32632)) as geomtype))</i><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Der Fehler tritt <b>nicht</b> auf, wenn ich gleichzeitig neben der Punkt-Geometrie auch ein anderes Attribut des Eintrages verändere (z.B. den Wert für das Attribut „Test Dropdown“ im Testbeispiel hier:
<a href="https://test.siasportail.lu/">https://test.siasportail.lu/</a>, einloggen mit dem User „test“ und Passwort „test123456789“). Der Fehler tritt auch
<b>nicht</b> auf, wenn nur die Punkt-Geometrie zum Eintrag vorhanden ist und keine Polygon-Geometrie.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Um dies zu testen, kann man im Testbeispiel unter <a href="https://test.siasportail.lu/">
https://test.siasportail.lu/</a> (User „test“ und Passwort „test123456789“) wie folgt vorgehen:<o:p></o:p></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l4 level1 lfo3">Editieren eines Punktes, der
<b>keine</b> Polygon-Geometrie enthält (alle Punkte, die <b>nicht</b> die Labels <b>
3</b> oder <b>1</b> besitzen): Diese lassen sich ohne Fehlermeldung editieren.<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l4 level1 lfo3">Editieren eines Punktes, der eine Polygon-Geometrie enthält (Punkte, die die Labels
<b>3</b> oder <b>1</b> besitzen): Es erscheint die obige Fehlermeldung.<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l4 level1 lfo3">Editieren eines Punktes der eine Polygon-Geometrie enthält (Punkte, die die Labels
<b>3</b> oder <b>1</b> besitzen) und <b>gleichzeitiges</b> Ändern des Attributes „Test Dropdown“: Ein Editieren ist möglich.<o:p></o:p></li></ol>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Wir gehen davon aus, dass der Fehler an Lizmap liegt, da das beschriebene Editieren im QGIS-Projekt ohne Fehlermeldungen möglich ist.
<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Die folgenden Versionen haben wir für das Aufsetzten des Test-Projektes verwendet:
<o:p></o:p></p>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">Lizmap Web Client : 3.7.10<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">Lizmap plugin : 4.3.24<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">QGIS Desktop : 3.34.4<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">QGIS Server : 3.34.11<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">QGIS Server plugin atlasprint : 3.4.1<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">QGIS Server plugin lizmap_server : 2.10.0<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l0 level1 lfo6">PHP Version: 8.3<o:p></o:p></li></ol>
<ol style="margin-top:0cm" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo9">PostgreSQL / PostGIS : 16 / 3.4.2<o:p></o:p></li></ol>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Hatte jemand schon einmal ein ähnliches Problem und kann uns bei diesem Problem weiterhelfen?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Vielleicht ist dieser Fehler auch einen Bug-Report über Github Wert?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Herzlichen Dank im Voraus und liebe Grüße aus Luxemburg,<o:p></o:p></p>
<p class="MsoNormal">Tobias<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:6.0pt"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43">Mat frëndleche Gréiss +++ Meilleures salutations +++ Mit freundlichen Grüssen +++ Kind Regards</span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="549" style="width:411.75pt">
<tbody>
<tr style="height:27.5pt">
<td width="180" style="width:134.65pt;padding:0cm 11.25pt 15.0pt 0cm;height:27.5pt">
<div>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:12.0pt;line-height:105%"><image001.png><o:p></o:p></span></p>
</div>
</td>
<td width="180" valign="top" style="width:134.65pt;padding:0cm 0cm 15.0pt 22.5pt;height:27.5pt">
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><span style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">Tobias Mosthaf</span><span style="font-size:12.0pt;line-height:105%">
<br>
</span><b><span style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#EE7D00">Natura 2000<br>
</span></b><b><span style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">T
</span></b><span style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">+ 352 34 94 10 – 34</span><o:p></o:p></p>
<p class="MsoNormal" style="margin-left:-15.4pt;line-height:105%"><b><span style="font-size:12.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43">E
</span></b><span style="font-size:12.0pt;line-height:105%"><a href="mailto:t.mosthaf@sias.lu"><span style="color:#946B43;text-decoration:none">t.mosthaf@sias.lu</span></a> </span><o:p></o:p></p>
</td>
<td width="190" style="width:142.45pt;padding:0cm 0cm 0cm 0cm;height:27.5pt">
<p class="MsoNormal" align="center" style="margin-left:-7.65pt;text-align:center;text-indent:-.55pt;line-height:105%">
<span style="font-size:15.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#946B43"> </span><span style="font-size:12.0pt;line-height:105%"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:12.0pt;line-height:105%"><image004.png><o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43">SIAS - Syndicat intercommunal à vocation multiple<br>
</span></b><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#946B43">5, rue Neihaischen - L-2633 Senningerberg<br>
<b><u><a href="http://www.sias.lu/"><span style="color:#946B43">www.sias.lu</span></a></u></b></span><o:p></o:p></p>
<p class="MsoNormal"><u><span style="font-size:12.0pt;color:#946B43"><a href="http://www.natura2000.lu/"><b><span style="font-family:"Calibri",sans-serif;color:#946B43">www.natura2000.lu</span></b></a></span></u><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a href="https://www.facebook.com/www.sias.lu/"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;text-decoration:none"><o:p></o:p></span></a></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1"><a href="https://www.facebook.com/www.sias.lu/"><span style="text-decoration:none"><image009.png></span><span style="font-size:11.0pt;font-family:"Aptos",sans-serif;color:windowtext;text-decoration:none"><o:p></o:p></span></a></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt"> <a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:11.0pt;text-decoration:none"><o:p></o:p></span></a></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1"><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="text-decoration:none"><image010.png></span><span style="font-size:11.0pt;font-family:"Aptos",sans-serif;color:windowtext;text-decoration:none"><o:p></o:p></span></a></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt"> <a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="font-size:11.0pt;text-decoration:none"><o:p></o:p></span></a></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Calibri",sans-serif;color:#0563C1"><a href="https://www.youtube.com/channel/UClGQbc7ugXYy7jw7j547g7w"><span style="text-decoration:none"><image011.png></span><span style="font-size:11.0pt;font-family:"Aptos",sans-serif;color:windowtext;text-decoration:none"><o:p></o:p></span></a></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt"> <br>
</span><span style="font-size:11.5pt;font-family:Webdings;color:#C8D400">P</span><span style="font-size:12.0pt;color:#C8D400"> Be environmentally friendly: please do not print this email unless it is entirely necessary.
</span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt">-- <br>
Lizmap-de mailing list<br>
<a href="mailto:Lizmap-de@lists.osgeo.org">Lizmap-de@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap-de">https://lists.osgeo.org/mailman/listinfo/lizmap-de</a><o:p></o:p></span></p>
</div>
</blockquote>
</div>
</body>
</html>