Index: /trunk/data/umn/alkis07/alkis07_muster.map
===================================================================
--- /trunk/data/umn/alkis07/alkis07_muster.map	(revision 175)
+++ /trunk/data/umn/alkis07/alkis07_muster.map	(revision 176)
@@ -5,5 +5,7 @@
 # 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6
 # 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete
-# 2012-03-05 A.E. WG   PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html
+# 2012-03-05 F.J. krz  PROCESSING "CLOSE_CONNECTION=DEFER"
+# 2012-04-17 F.J. krz  Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr
+#                      Auch Standard-Position vom Flurstuecksnummern anzeigen
 
 # ToDo:
@@ -76,6 +78,6 @@
 	DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832"
 	METADATA
@@ -120,6 +122,6 @@
 	DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832"
 	METADATA
@@ -162,6 +164,6 @@
 	DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832"
 	METADATA
@@ -254,6 +256,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832"
 	METADATA
@@ -662,6 +664,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -695,6 +697,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -728,6 +730,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -759,6 +761,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -789,6 +791,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -820,6 +822,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -853,6 +855,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -884,6 +886,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -916,6 +918,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -951,6 +953,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1015,6 +1017,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1046,6 +1048,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1085,6 +1087,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1117,6 +1119,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1149,6 +1151,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1183,6 +1185,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1234,6 +1236,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1264,6 +1266,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1294,6 +1296,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1324,6 +1326,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1354,6 +1356,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1386,6 +1388,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1416,6 +1418,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1448,6 +1450,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1478,6 +1480,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1508,6 +1510,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1545,6 +1547,6 @@
 	# REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	# Feld funktion, Werte 1010, 1030, 1040
@@ -1579,6 +1581,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	# Statt EXPRESSION filtern besser gleich als WHERE in SQL
@@ -1615,6 +1617,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1661,6 +1663,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1695,6 +1697,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1732,6 +1734,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 
 	# Tabelle (Standard-Template)
@@ -1968,6 +1970,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1998,6 +2000,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2042,6 +2044,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
 	# Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das?
@@ -2401,6 +2403,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2563,6 +2565,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2632,6 +2634,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2667,6 +2669,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832"
 
@@ -2716,6 +2718,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel, laufendenummer FROM s_nummer_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View
 	# "s_nummer_nebengebaeude" = View
@@ -2768,6 +2770,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 
@@ -2802,6 +2804,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2835,6 +2837,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2868,6 +2870,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2899,6 +2901,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832"
 	FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2941,6 +2943,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2972,6 +2974,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3003,6 +3005,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832"
 	FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -3076,6 +3078,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3117,6 +3119,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3165,6 +3167,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3201,6 +3203,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	# mit Feldern fuer klassisches Template:
 	#  DATA "wkb_geometry from (SELECT ogc_fid, gml_id, flurstueckskennzeichen, amtlicheflaeche, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832"
@@ -3247,6 +3249,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3378,5 +3380,5 @@
 # Ausgestaltung FS (DATA: Views in DB anlegen fuer Beziehungen)
 
-# Flurstuecknummer
+# Flurstuecksnummer
 
 # Musterdaten RLP: zaehler-nenner steht auch in Feld "ap_pto.schriftinhalt"
@@ -3388,13 +3390,12 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
-	DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832"
-	# View: ap_pto >dientZurDarstellungVon> ax_flurstueck
-	# Felder: ogc_fid, wkb_geometry, gemarkungsnummer, flurnummer, zaehler, nenner, fsnum
-	METADATA
-		wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
-		wms_title "FlurstÃŒcknummer"
-		wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
+#	DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View
+	DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing
+	METADATA
+		wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+		wms_title "FlurstÃŒcksnummer"
+		wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer"
 		gml_include_items "all"
 	END
@@ -3443,5 +3444,4 @@
 #	
 #	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
 #	CONNECTION "host=localhost dbname=obk user=alkis"
 #	DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832"
@@ -3510,5 +3510,4 @@
 #	DUMP TRUE
 #	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
 #	CONNECTION "host=localhost dbname=obk user=alkis"
 #	DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832"
@@ -3545,5 +3544,4 @@
 #	DUMP TRUE
 #	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
 #	CONNECTION "host=localhost dbname=obk user=alkis"
 #	DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832"
@@ -3586,6 +3584,6 @@
 	TYPE LINE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 	METADATA
@@ -3617,6 +3615,6 @@
 	STATUS ON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
 	METADATA
@@ -3656,6 +3654,6 @@
 	TYPE POINT
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3683,5 +3681,4 @@
 			SIZE 14 MINSIZE 7 MAXSIZE 24
 			POSITION cc
-		#	OFFSET 0 0
 			COLOR 0 0 0
 			ANGLE [drehwinkel]
@@ -3702,6 +3699,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3735,6 +3732,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3769,6 +3766,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3803,6 +3800,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3834,6 +3831,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3875,6 +3872,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 
 	#DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832"
@@ -3985,6 +3982,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -4048,6 +4045,6 @@
 	#SYMBOLSCALEDENOM 1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832'
 	CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106}
@@ -4129,6 +4126,6 @@
 	SYMBOLSCALEDENOM 1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832'
 	CLASS
@@ -4166,6 +4163,6 @@
 	SYMBOLSCALEDENOM 1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832'
 	CLASS
Index: /trunk/data/umn/alkis07/alkis07_muster_4.map
===================================================================
--- /trunk/data/umn/alkis07/alkis07_muster_4.map	(revision 175)
+++ /trunk/data/umn/alkis07/alkis07_muster_4.map	(revision 176)
@@ -5,5 +5,8 @@
 # 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6
 # 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete
-# 2012-03-05 A.E. WG   PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html
+# 2012-03-05 F.J. krz  PROCESSING "CLOSE_CONNECTION=DEFER"
+# 2012-04-17 F.J. krz  Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr
+#                      Auch Standard-Position vom Flurstuecksnummern anzeigen
+
 MAP
 	NAME "alkis"
@@ -57,6 +60,6 @@
 	DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832"
 	METADATA
@@ -101,6 +104,6 @@
 	#DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832"
 	METADATA
@@ -143,6 +146,6 @@
 	#DUMP true
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832"
 	METADATA
@@ -183,6 +186,6 @@
 	#DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832"
 	METADATA
@@ -478,6 +481,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -511,6 +514,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -544,6 +547,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -575,6 +578,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -605,6 +608,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -636,6 +639,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -669,6 +672,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -700,6 +703,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -732,6 +735,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -767,6 +770,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -831,6 +834,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -862,6 +865,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -901,6 +904,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -933,6 +936,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -965,6 +968,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -999,6 +1002,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1049,6 +1052,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1078,6 +1081,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1107,6 +1110,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1136,6 +1139,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1165,6 +1168,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1197,6 +1200,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1227,6 +1230,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1259,6 +1262,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1289,6 +1292,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1319,6 +1322,6 @@
 	REQUIRES "![nutzung_alle]"
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1354,6 +1357,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	# Feld funktion, Werte 1010, 1030, 1040
@@ -1389,6 +1392,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
 	# Statt EXPRESSION filtern besser gleich als WHERE in SQL
@@ -1424,6 +1427,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1470,6 +1473,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1501,6 +1504,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1537,6 +1540,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1641,6 +1644,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1671,6 +1674,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -1705,6 +1708,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2045,6 +2048,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2170,6 +2173,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2235,6 +2238,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2271,6 +2274,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2322,6 +2325,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,laufendenummer FROM s_nummer_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View
 	METADATA
@@ -2374,6 +2377,6 @@
 	DUMP TRUE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 
@@ -2408,6 +2411,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2441,6 +2444,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2472,6 +2475,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2503,6 +2506,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832"
 	FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2545,6 +2548,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2576,6 +2579,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2606,6 +2609,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832"
 	FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2647,6 +2650,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2688,6 +2691,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2734,6 +2737,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2769,6 +2772,6 @@
 	TYPE POLYGON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2802,6 +2805,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -2927,5 +2930,5 @@
 END
 
-# Flurstuecknummer
+# Flurstuecksnummer
 LAYER
 	NAME "ag_t_flurstueck"
@@ -2934,11 +2937,12 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
-	DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832"
-	METADATA
-		wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
-		wms_title "Flurstuecknummer"
-		wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
+#	DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View
+	DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing
+	METADATA
+		wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+		wms_title "Flurstuecksnummer"
+		wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer"
 		#gml_include_items "all"
 	END
@@ -2988,6 +2992,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 	METADATA
@@ -3022,6 +3026,6 @@
 	STATUS ON
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
 	METADATA
@@ -3061,6 +3065,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3081,5 +3085,5 @@
 		LABEL
 			TYPE TRUETYPE
-			FONT "alk_textsymbols"
+			FONT "alkis_textsymbols"
 			SIZE 28.4 #7.1
 			POSITION cc
@@ -3103,6 +3107,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3136,6 +3140,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3170,6 +3174,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3204,6 +3208,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3235,6 +3239,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3275,6 +3279,6 @@
 	#DUMP TRUE # _4
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	
 	#DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832"
@@ -3325,6 +3329,6 @@
 	TYPE LINE
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832"
 	METADATA
@@ -3384,6 +3388,6 @@
 	#SYMBOLSCALEDENOM 1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832'
 	CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106}
@@ -3465,6 +3469,6 @@
 	SYMBOLSCALEDENOM 250 # 1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832'
 	CLASS
@@ -3502,6 +3506,6 @@
 	SYMBOLSCALEDENOM 250 #1000
 	CONNECTIONTYPE POSTGIS
-	PROCESSING "CLOSE_CONNECTION=DEFER"
-	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+	PROCESSING "CLOSE_CONNECTION=DEFER"
 	DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832'
 	CLASS
Index: /trunk/data/konvert/postnas_0.7/pp_definition.sql
===================================================================
--- /trunk/data/konvert/postnas_0.7/pp_definition.sql	(revision 175)
+++ /trunk/data/konvert/postnas_0.7/pp_definition.sql	(revision 176)
@@ -8,4 +8,7 @@
 --  2012-02-13 PostNAS 07, Umbenennung
 --  2012-02-17 Optimierung
+--  2012-02-28 gkz aus View nehmen
+--  2012-04-17 Flurstuecksnummern auf Standardposition
+
 
 -- ============================
@@ -66,9 +69,9 @@
 
 
-COMMENT ON TABLE  pp_gemeinde                IS 'Post-Processing: Gemeinde';
-COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer';
-COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant';
-COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÃ€zise Geometrie aus Summe aller Gemarkungen';
-COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÃ€ben.';
+  COMMENT ON TABLE  pp_gemeinde                IS 'Post-Processing: Gemeinde';
+  COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer';
+--COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant';
+  COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÃ€zise Geometrie aus Summe aller Gemarkungen';
+  COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÃ€ben.';
 
 
@@ -152,5 +155,5 @@
 
 
--- pp_  ?
+-- Prefix "pp_" verwenden  ?
 
 --DROP TABLE gemeinde_person;
@@ -175,4 +178,35 @@
 
 
+-- Flurstuecksnummern-Position
+-- ===========================
+
+-- ersetzt den View "s_flurstueck_nr" fÃŒr WMS-Layer "ag_t_flurstueck"
+
+--DROP TABLE pp_flurstueck_nr;
+
+  CREATE TABLE pp_flurstueck_nr (
+    gid		serial,
+    fsgml	character(16),
+    fsnum	character varying(10),  -- zzzzz/nnnn
+    CONSTRAINT pp_flurstueck_nr_pk  PRIMARY KEY (gid),
+    CONSTRAINT pp_flurstueck_nr_gml FOREIGN KEY (fsgml)
+      REFERENCES ax_flurstueck (gml_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE
+  );
+
+SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom','25832','POINT',2);
+
+-- Geometrischer Index
+CREATE INDEX pp_flurstueck_nr_gidx ON pp_flurstueck_nr USING gist(the_geom);
+
+-- Foreig-Key Index
+CREATE INDEX fki_pp_flurstueck_nr_gml ON pp_flurstueck_nr(fsgml);
+
+COMMENT ON TABLE  pp_flurstueck_nr           IS 'Post-Processing: Position der FlurstÃŒcksnummer in der Karte';
+COMMENT ON COLUMN pp_flurstueck_nr.fsgml     IS 'gml_id des zugehÃ¶rigen FlurstÃŒcks-Objektes';
+COMMENT ON COLUMN pp_flurstueck_nr.fsnum     IS 'Label, Darzustellende FS-Nummer als Bruch';
+COMMENT ON COLUMN pp_flurstueck_nr.the_geom  IS 'Position der FlurstÃŒcksnummer in der Karte';
+
+
 -- =====
 -- VIEWs 
@@ -185,10 +219,9 @@
 CREATE VIEW gemeinde_gemarkung
 AS
-  SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname, g.gkz
+  SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname
   FROM pp_gemarkung k
   JOIN pp_gemeinde  g 
     ON k.land = g.land 
-   AND k.gemeinde = g.gemeinde
-;
+   AND k.gemeinde = g.gemeinde;
 
 -- VIEWs  fuer die Zuordnung vom EigentÃŒmern zu Gemeinden
@@ -228,6 +261,5 @@
     AND bnb.beziehungsart = 'istBestandteilVon'
     AND bbg.beziehungsart = 'istBestandteilVon'
-    AND bsf.beziehungsart = 'istGebucht'
-;
+    AND bsf.beziehungsart = 'istGebucht';
 
 COMMENT ON VIEW gemeinde_person_typ1 IS 'Personen die EigentÃŒmer vom FlurstÃŒcken in einer Gemeinde sind. Typ1 = nomale Buchungen mit direkter Beziehung.';
@@ -289,6 +321,5 @@
     AND  p.gemeinde = g.gemeinde
   GROUP BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, g.gemeindename, p.buchtyp
-  ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp
-;
+  ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp;
 
 COMMENT ON VIEW gemeinde_person_statistik IS 'ZÃ€hlen der Personen je Gemeinde und Buchungstyp';
Index: /trunk/data/konvert/postnas_0.7/sichten.sql
===================================================================
--- /trunk/data/konvert/postnas_0.7/sichten.sql	(revision 175)
+++ /trunk/data/konvert/postnas_0.7/sichten.sql	(revision 176)
@@ -6,4 +6,6 @@
 
 --  2012-02-25 PostNAS 07, Umbenennung
+--  2012-04-17 flstnr_ohne_position
+
 
 --  -----------------------------------------
@@ -12,6 +14,6 @@
 
 
--- Layer "ag_t_flurstueck"
--- -----------------------
+-- WMS-Layer "ag_t_flurstueck"
+-- ---------------------------
 
 -- Die Geometrie befindet sich in "ap_pto", der Label in "ax_flurstueck"
@@ -20,23 +22,49 @@
 
 -- Bruchnummerierung erzeugen
+-- ALT 2012-04-17: Diese Version zeigt nur die manuell gesetzten Positionen
 CREATE OR REPLACE VIEW s_flurstueck_nr
 AS 
- SELECT ap_pto.ogc_fid, 
-        ap_pto.wkb_geometry,   -- Position des Textes
-    --  ax_flurstueck.flurstueckskennzeichen,   -- am Stueck, aufgefuellt, unpraktisch
-    --  ax_flurstueck.gemarkungsnummer,  -- integer
-    --  ax_flurstueck.flurnummer,        -- integer
-    --  ax_flurstueck.zaehler,           -- integer
-    --  ax_flurstueck.nenner,            -- integer oder NULL
-        ax_flurstueck.zaehler::text || COALESCE ('/' || ax_flurstueck.nenner::text, '') AS fsnum
-   FROM ap_pto
-   JOIN alkis_beziehungen 
-     ON ap_pto.gml_id = alkis_beziehungen.beziehung_von
-   JOIN ax_flurstueck 
-     ON alkis_beziehungen.beziehung_zu = ax_flurstueck.gml_id
-  WHERE alkis_beziehungen.beziehungsart = 'dientZurDarstellungVon'
+ SELECT f.ogc_fid, 
+        p.wkb_geometry,  -- Position des Textes
+        f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum
+   FROM ap_pto             p
+   JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von
+   JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id
+  WHERE v.beziehungsart = 'dientZurDarstellungVon' 
+  --AND p."art" = 'ZAE_NEN'
   ;
 
 COMMENT ON VIEW s_flurstueck_nr IS 'fuer Kartendarstellung: Bruchnummerierung FlurstÃŒck';
+
+-- NEU 2012-04-17
+-- Wenn keine manuelle Position gesetzt ist, wird die Flaechenmitte verwendet
+
+-- ACHTUNG: Dieser View kann nicht direkt im Mapserver-WMS verwendet werden.
+-- Die Anzeige ist zu langsam. Filterung ÃŒber BBOX kann nicht funktionieren, da zunÃ€chst ALLE Standardpositionen 
+-- berechnet werden mÃŒssen, bevor darÃŒber gefiltert werden kann.
+
+-- FAZIT: In einer Hilfstabelle mit geometrischem Index zwischenspeichern.
+--        Siehe PostProcessing Tabelle "pp_flurstueck_nr"
+
+CREATE OR REPLACE VIEW s_flurstueck_nr2
+AS 
+  SELECT f.ogc_fid, 
+         p.wkb_geometry,  -- manuelle Position des Textes
+         f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum
+    FROM ap_pto             p
+    JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von
+    JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id
+   WHERE v.beziehungsart = 'dientZurDarstellungVon' 
+   --AND p."art" = 'ZAE_NEN'
+ UNION 
+  SELECT f.ogc_fid,
+         ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry,  -- Flaechenmitte als Position des Textes
+         f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum
+    FROM      ax_flurstueck     f 
+    LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id
+   WHERE v.beziehungsart is NULL
+  ;
+
+COMMENT ON VIEW s_flurstueck_nr2 IS 'Bruchnummerierung FlurstÃŒck, auch Standard-Position. Nicht direkt fuer WMS verwenden';
 
 
@@ -313,4 +341,31 @@
 --  Sichten fuer Fehlersuche und Daten-Analyse
 --  ------------------------------------------
+
+
+-- FlurstÃŒcke mit Anzeige der FlurstÃŒcksnummer an der "Standardposition"
+
+-- Nach der Konvertierung aus ALK hat zunÃ€chst jedes FlurstÃŒck eine explizit gesetzte Position der FlurstÃŒcksnummer.
+
+-- Nach einer manuellen Teilung bekommen die neuen FlurstÃŒcke im ALKIS nur dann eine Position,
+-- wenn die Positioin manuell bestimmt (verschoben) wurde.
+-- Wenn die FlurstÃŒcksnummer an ihrer "Standardposition" angezeigt werden soll, 
+-- dann wird diese in den Daten (DHK, NAS) nicht gesetzt.
+-- Der Konverter PostNAS konvertiert aber nur die Daten, die er bekommt, er setzt nicht die Standard-Position 
+-- fÃŒr die FlurstÃŒcke, die ohne eine manuelle Position kommen.
+
+-- Diese FÃ€lle identifizieren
+CREATE OR REPLACE VIEW flstnr_ohne_position
+AS 
+ SELECT f.gml_id, 
+        f.gemarkungsnummer || '-' || f.flurnummer || '-' || f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS such -- Suchstring fÃŒr ALKIS-Navigation nach FS-Kennzeichen
+ FROM        ax_flurstueck     f 
+   LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id
+ --LEFT JOIN ap_pto            p  ON p.gml_id       = v.beziehung_von
+  WHERE v.beziehungsart is NULL
+--ORDER BY f.gemarkungsnummer, f.flurnummer, f.zaehler
+  ;
+
+COMMENT ON VIEW flstnr_ohne_position IS 'FlurstÃŒcke ohne manuell gesetzte Position fÃŒr die PrÃ€sentation der FS-Nr';
+
 
 -- Zeigt die Texte an, die nicht in einem der Mapfile-Views verarbeitet werden
Index: /trunk/data/konvert/postnas_0.7/pp_laden.sql
===================================================================
--- /trunk/data/konvert/postnas_0.7/pp_laden.sql	(revision 175)
+++ /trunk/data/konvert/postnas_0.7/pp_laden.sql	(revision 176)
@@ -8,4 +8,5 @@
 --  2012-02-13 PostNAS 07, Umbenennung
 --  2012-02-17 Optimierung
+--  2012-04-17 Flurstuecksnummern auf Standardposition
 
 
@@ -22,4 +23,36 @@
 
 -- Die per PostProcessing gefüllten Tabellen bekommen den Profix "pp_". 
+
+-- Die Ausführung dieses Scriptes auf einer Datenbank für eine 80T-Einwohner-Stadt dauert ca.: 500 Sek. !
+
+
+
+-- ===========================
+-- Flurstuecksnummern-Position
+-- ===========================
+
+-- ersetzt den View "s_flurstueck_nr" für WMS-Layer "ag_t_flurstueck"
+
+  DELETE FROM pp_flurstueck_nr;
+
+  INSERT INTO pp_flurstueck_nr
+          ( fsgml, fsnum, the_geom )
+    SELECT f.gml_id,
+           f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum,
+           p.wkb_geometry  -- manuelle Position des Textes
+      FROM ap_pto             p
+      JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von
+      JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id
+     WHERE v.beziehungsart = 'dientZurDarstellungVon' 
+     --AND p."art" = 'ZAE_NEN'
+   UNION 
+    SELECT f.gml_id,
+           f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum,
+           ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry  -- Flaechenmitte als Position des Textes
+      FROM      ax_flurstueck     f 
+      LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id
+     WHERE v.beziehungsart is NULL
+  ;
+-- Ausführung: mittlere Stadt: ca. 4 - 18 Sec.
 
 
