https://kvwmap.de/wiki/index.php?action=history&feed=atom&title=%C3%96ffentliche_Liegenschaften_einf%C3%A4rben Öffentliche Liegenschaften einfärben - Versionsgeschichte 2026-04-29T02:05:25Z Versionsgeschichte dieser Seite in kvwmap MediaWiki 1.23.1 https://kvwmap.de/wiki/index.php?title=%C3%96ffentliche_Liegenschaften_einf%C3%A4rben&diff=3080&oldid=prev A.tower am 19. Juni 2007 um 14:24 Uhr 2007-06-19T14:24:35Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 19. Juni 2007, 14:24 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno">Zeile 5:</td> <td colspan="2" class="diff-lineno">Zeile 5:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im pfad-Feld des Layers sieht vom Prinzip folgender maßen aus:&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im pfad-Feld des Layers sieht vom Prinzip folgender maßen aus:&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>select o.objnr as id,x.the_geom,o.flurstkennz,e.namensnr,e.anteilsverhaeltnis, b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND (e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&#160; </ins>select o.objnr as id,x.the_geom,o.flurstkennz,e.namensnr,e.anteilsverhaeltnis,<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>(e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im data-Feld:&lt;br&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im data-Feld:&lt;br&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>the_geom from (select o.objnr as id,x.the_geom,o.flurstkennz, b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND (e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)) as foo using unique id using srid=2398</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">&#160; </ins>the_geom from (select o.objnr as id,x.the_geom,o.flurstkennz,<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>(e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)) as foo using<ins class="diffchange diffchange-inline">&lt;br&gt; </ins>unique id using srid=2398</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Für jeden auszuwertenden Eigentümer ist also ein eigenständiger Layer zu bilden. Entscheidend für die Einfärbung ist die Spalte name1 der Tabelle alb_g_namen. Im Landkreis Müritz ist es nicht notwendig auch noch das Feld name2 mit auszuwerten. Das kann in anderen Landkreisen aber eventuell notwendig sein. Das sollte also mi Hilfe von PGAdmin III geprüft werden.</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Entscheidend ist der Teil des SQL-Statements hinter LIKE. Folgende Varianten werden im Landkreis Müritz verwendet:</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Suche nach städtischem Eigentum: '''LIKE '%Stadt %''''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Suche nach Eigentum der Gemeinden: '''LIKE '%Gemeinde %''''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Suche nach Eigentum des Landkreises: '''LIKE '%Landkreis %' OR LIKE '%Rat des Kreises %''''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Suche nach Eigentum des Landes: '''LIKE '%Land Mecklen%''''</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Suche nach Eigentum des Bundes: '''LIKE '%Bundesrepublik%''''</ins></div></td></tr> </table> A.tower https://kvwmap.de/wiki/index.php?title=%C3%96ffentliche_Liegenschaften_einf%C3%A4rben&diff=3079&oldid=prev A.tower am 19. Juni 2007 um 13:53 Uhr 2007-06-19T13:53:27Z <p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 19. Juni 2007, 13:53 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno">Zeile 3:</td> <td colspan="2" class="diff-lineno">Zeile 3:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Unser Ziel war es eine neue Gruppe anzubieten deren Layer jeweils Flurstücke eines bestimmten Eigentümers einfärben. Von Interesse für die Benutzer im Landkreis und in den angeschlossenen Amtsverwaltungen sind jeweils die Flurstücke, welche Im Eigentum der Städte, der Gemeinden, des Landkreises, des Landes und des Bundes sind. &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>Unser Ziel war es eine neue Gruppe anzubieten deren Layer jeweils Flurstücke eines bestimmten Eigentümers einfärben. Von Interesse für die Benutzer im Landkreis und in den angeschlossenen Amtsverwaltungen sind jeweils die Flurstücke, welche Im Eigentum der Städte, der Gemeinden, des Landkreises, des Landes und des Bundes sind. &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im pfad-Feld des Layers sieht vom Prinzip folgender maßen aus:</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Der Eintrag im pfad-Feld des Layers sieht vom Prinzip folgender maßen aus:<ins class="diffchange diffchange-inline">&lt;br&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">select o.objnr as id,x.the_geom,o.flurstkennz,e.namensnr,e.anteilsverhaeltnis, b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND (e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Der Eintrag im data-Feld:&lt;br&gt;</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">the_geom from (select o.objnr as id,x.the_geom,o.flurstkennz, b.flurstkennz,b.blatt,b.bezirk,e.lfd_nr_name,e.bezirk,e.blatt,n.lfd_nr_name,n.name1 FROM alb_g_namen as n,alb_g_eigentuemer as e,alb_g_buchungen as b, alknflst as o,alkobj_e_fla as x WHERE (n.name1 LIKE '%Stadt %') AND (n.lfd_nr_name=e.lfd_nr_name) AND (e.bezirk=b.bezirk) AND (e.blatt=b.blatt) AND (o.flurstkennz=b.flurstkennz) AND (o.objnr=x.objnr)) as foo using unique id using srid=2398</ins></div></td></tr> </table> A.tower https://kvwmap.de/wiki/index.php?title=%C3%96ffentliche_Liegenschaften_einf%C3%A4rben&diff=3078&oldid=prev A.tower am 19. Juni 2007 um 13:48 Uhr 2007-06-19T13:48:29Z <p></p> <p><b>Neue Seite</b></p><div>--[[Benutzer:A.tower|Andreas Thurm]] 15:48, 19. Jun 2007 (CEST)<br /> <br /> Unser Ziel war es eine neue Gruppe anzubieten deren Layer jeweils Flurstücke eines bestimmten Eigentümers einfärben. Von Interesse für die Benutzer im Landkreis und in den angeschlossenen Amtsverwaltungen sind jeweils die Flurstücke, welche Im Eigentum der Städte, der Gemeinden, des Landkreises, des Landes und des Bundes sind. <br /> <br /> Der Eintrag im pfad-Feld des Layers sieht vom Prinzip folgender maßen aus:</div> A.tower