<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=iso-8859-1">
<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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Verdana",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@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 lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Moin Zusammen,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">ich hab mal ne Frage und zwar warum werden bei der Verarbeitung bzw. Erzeugung der politischen Grenzen Vereinfachungen und Puffer verwendet?
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">In #131-135 von \postprocessing.d\1_ableitungsregeln\gebiete.sql [1] finden sich Variablen für Vereinfachungs-Toleranzen der verwendeten ST_Simplify-Funktion [2]
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">\set flur_simplify 0.5 --- #164 [INSERT INTO po_polygons(gml_id,thema,layer,signaturnummer,sn_randlinie,modell,polygon)]…st_multi(st_simplify(st_union(st_buffer(wkb_geometry,:flur_buffer)),
:flur_simplify)) AS polygon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">\set gemarkung_simplify 2.2 --- #196 …st_multi(st_simplify(st_union(st_buffer(polygon, 0.15)), :gemarkung_simplify)) AS polygon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">\set gemeinde_simplify 5.0 --- #227 …st_multi(st_simplify(st_union(st_buffer(polygon,0.20)), :gemeinde_simplify)) AS polygon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">\set kreis_simplify 7.0 --- #258 …st_multi(st_simplify(st_union(st_buffer(polygon,0.30)), :kreis_simplify)) AS polygon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">(Meine Kolleg*innen zoomen immer gerne ganz nah ran und stellen dann fest, dass die Grenzen nicht deckungsgleich mit den Flurstücken sind, und beschweren sich dann immer über
kaputte Daten (durch QGIS)!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Da mir aber auch kein guter Grund für diese Vergröberung einfällt, habe ich das in unserem Importer bereits abgestellt und möchte neben der Eingangsfrage vorschlagen, dass
auch im Quellcode umzustellen, falls es keine guten Gründe dafür gibt.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Eure Meinungen?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">[1]
<a href="https://github.com/norBIT/alkisimport/blob/master/postprocessing.d/1_ableitungsregeln/gebiete.sql">
https://github.com/norBIT/alkisimport/blob/master/postprocessing.d/1_ableitungsregeln/gebiete.sql</a>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">[2]
</span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><a href="https://postgis.net/docs/ST_Simplify.html">https://postgis.net/docs/ST_Simplify.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Beste Grüße<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Thomas Schüttenberg</span><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:DE"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:DE"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:DE">Stadt Minden</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:DE"><br>
</span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:DE">FB 5.3 - Geoservice<br>
Kleiner Domhof 17</span><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;mso-fareast-language:DE">
<br>
<span style="color:gray">32423 Minden</span> <br>
<span style="color:gray">Telefon +49 571 89197<br>
</span><a href="mailto:t.schuettenberg@minden.de"><span style="color:blue">t.schuettenberg@minden.de</span></a></span><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;mso-fareast-language:DE"><br>
<a href="http://www.minden.de/"><span style="font-size:10.0pt;color:blue">www.minden.de</span></a></span><b><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:DE"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE"><img border="0" width="189" height="79" style="width:1.9687in;height:.8229in" id="Grafik_x0020_1" src="cid:image001.png@01DB3507.E8E0C750" alt="Logo_Minden_signatur"></span><span style="mso-fareast-language:DE"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>