Index: /trunk/umn/alkis_n/fonts/fonts.txt
===================================================================
--- /trunk/umn/alkis_n/fonts/fonts.txt	(revision 367)
+++ /trunk/umn/alkis_n/fonts/fonts.txt	(revision 367)
@@ -0,0 +1,5 @@
+arial				arial.ttf
+arial-bold			arialbd.ttf
+arial-bold-italic	arialbi.ttf
+arial-italic		ariali.ttf
+arial-bold-0		arialbd.ttf
Index: /trunk/umn/alkis_n/alkis_n_muster.map
===================================================================
--- /trunk/umn/alkis_n/alkis_n_muster.map	(revision 367)
+++ /trunk/umn/alkis_n/alkis_n_muster.map	(revision 367)
@@ -0,0 +1,3501 @@
+MAP
+# ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet fÃŒr mapserver 7.0
+# http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis150.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 
+
+# Stand:
+#  2016-05-03 - Test-Server -
+#  2016-05-09 Kommentare
+
+# ToDo: 
+# - UnfÃ¶rmige Legende z.B. im Layer "GebÃ€ude/Grenzen" durch SVG-Symbole und/oder "SIZEUNIT METERS"?
+# - Copyright-Layer wegen Vorgaben des Katasteramtes
+# - Layer oder Gruppe fÃŒr SchÃ€tzungsklassen
+# - In "GebÃ€ude / Beschriftungen" werden ausser der Haunummer auch nich Buchstaben sichtbar, z.T. ÃŒberlappend
+#   Die sollten getrennt schaltbar sein.
+#
+### Erlaeuterungen:
+## SVG:
+# Die SVG-Symbole sind aus dem norBIT-ALKIS-Plugin zu entnehmen:
+# Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\
+# Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ 
+#
+## MapProxy:
+#  Layer fÃŒr FlÃ€che: LAYERS=fh,fe,fb,fw,fs,fi,fv
+#  Layer fÃŒr Strichzeichnung: LAYERS=gh,bh,ge,pe,be,gb,bb,gt,lt,pt,bt,gw,lw,pw,bw,gs,ps,bs,gi,li,pi,bi,gv,lv,pv,bv,fg,gg,lg,pg,bg,gff,lff,pff,lfn,bfn,bl
+#
+## Layername:
+# Der aus QGIS generierte Layername ("l" + lfd.Nr) ist unterschiedlich je Mandant, 
+# und wird daher zur Vereinheitlichung ersetzt durch die Buchstaben fÃŒr "Typ" und "Gruppe" aus der unten stehenden Liste.
+#
+## Layer und Klassen:
+# Dies Muster-Mapfile wurde generiert auf der Basis von NBA-Daten fÃŒr einige Staedte in Ost-Westfalen.
+# FÃŒr den Einsatz in anderen Kreisen und anderen Regionen ist dies durch lokale Layer und Klassen zu ergÃ€nzen.
+#
+## HQ-Print:
+# Es wird keine _4-Mapdatei mehr fÃŒr High-Quality-Print mit 288dpi aufbereitet.
+# Statt dessen wird fÃŒr den HQ-Print der GetMap-Call ergÃ€nzt um den Parameter: "&map.resolution=288"
+# Beispiel fÃŒr Mapbender 2.7:
+# UPDATE gui_element_vars SET var_value = '[{"pattern": ".map&",
+#   "replacement": {"144": ".map&map.resolution=144&", "288": ".map&map.resolution=288&"}}]' 
+#   WHERE fkey_e_id = 'printPDF' AND var_name  ='highqualitymapfiles';
+
+## Typen:
+# g Grenzen
+# f FlÃ€chen
+# l Linien
+# p Punkte
+# b Beschriftungen
+
+## Gruppen:
+# h	FriedhÃ¶fe
+# e	Vegetation
+# b	WohnbauflÃ€chen
+# t	Topographie
+# w	GewÃ€sser
+# s	Sport und Freizeit
+# i	Industrie und Gewerbe
+# v	Verkehr
+# g	GebÃ€ude
+# r	Rechtliche Festlegungen
+# f	FlurstÃŒcke
+# fn	FlurstÃŒcke/Nummern
+# ff	FlurstÃŒcke/FlÃ€chen
+# p	Politische Grenzen
+# l	Lagebezeichnungen
+
+### Generierte Layer (Reihenfolge)
+##			*/ FlÃ€chen + Grenzen
+# fh FriedhÃ¶fe / FlÃ€chen
+# fe Vegetation / FlÃ€chen
+# fb WohnbauflÃ€chen / FlÃ€chen
+# gt Topographie / Grenzen
+# ge Vegetation / Grenzen
+# gh FriedhÃ¶fe / Grenzen
+# gb WohnbauflÃ€chen / Grenzen
+# fw GewÃ€sser / FlÃ€chen
+# fs Sport und Freizeit / FlÃ€chen
+# gs Sport und Freizeit / Grenzen
+# gw GewÃ€sser / Grenzen
+# fi Industrie und Gewerbe / FlÃ€chen  **
+# gi Industrie und Gewerbe / Grenzen  **
+# fv Verkehr / FlÃ€chen **  ( teils auch Verkehr vor Industrie)
+# gv Verkehr / Grenzen **
+# fg GebÃ€ude / FlÃ€chen
+# gg GebÃ€ude / Grenzen
+# gr Rechtliche Festlegungen / Grenzen
+# gff FlurstÃŒcke / FlÃ€chen / Grenzen
+##			*/ Linien
+# lt Topographie / Linien
+# lw GewÃ€sser / Linien
+# lv Verkehr / Linien **
+# li Industrie und Gewerbe / Linien   ** (teils  hinter gebÃ€ude/linien)
+# lg GebÃ€ude / Linien
+# lp Politische Grenzen / Linien
+# lfn FlurstÃŒcke / Nummern / Linien
+# lff FlurstÃŒcke / FlÃ€chen / Linien
+##			*/ Punkte
+# pff FlurstÃŒcke / FlÃ€chen / Punkte
+# pg GebÃ€ude / Punkte
+# pv Verkehr / Punkte
+# pe Vegetation / Punkte
+# pw GewÃ€sser / Punkte
+# pi Industrie und Gewerbe / Punkte
+# ps Sport und Freizeit / Punkte
+# pt Topographie / Punkte
+##			*/ Beschriftungen
+# bfn FlurstÃŒcke / Nummern / Beschriftungen
+# bg GebÃ€ude / Beschriftungen
+# bg2 GebÃ€ude / Laufende Hausnummern / Beschriftungen  ** NebengebÃ€ude-Nummer in Klammer
+# bl Lagebezeichnungen / Beschriftungen
+# br Rechtliche Festlegungen / Beschriftungen
+# bv Verkehr / Beschriftungen
+# bh FriedhÃ¶fe / Beschriftungen
+# be Vegetation / Beschriftungen
+# bw GewÃ€sser / Beschriftungen
+# bi Industrie und Gewerbe / Beschriftungen
+# bs Sport und Freizeit / Beschriftungen
+# bb WohnbauflÃ€chen / Beschriftungen
+# bt Topographie / Beschriftungen
+
+	NAME "alkis"
+	STATUS ON
+   	#CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log"
+	EXTENT ..
+	PROJECTION "init=epsg:25832" END
+	MAXSIZE 8400 # reicht fuer 288 dpi auf DIN-A2
+	DEFRESOLUTION 72
+	SYMBOLSET "symbols.sym" # ausgelagert, ursprÃŒnglich hier inline generiert
+	FONTSET "/opt/gdi/alkisn/fonts/fonts.txt"
+	UNITS METERS
+	WEB
+		METADATA
+			wms_title "ALKIS n"
+			wms_abstract "ALKIS *gkz* - Konverter PostNAS, NorGIS-Plugin, Version vom Mai 2016"
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_bbox_extended "true"
+			wms_encoding "UTF-8"
+			wms_onlineresource "http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis*gkz*.map"
+			wms_feature_info_mime_type "text/html"
+			wms_schema_location ".."
+			wms_keywordlist "ALKIS,FlurstÃŒck,NAS"
+			wms_fees "none"
+			wms_accessconstraints "fÃŒr den Dienstgebrauch"
+			wms_enable_request "*"
+		#	include "meta_contact.map" # individuelle Datei je Katasteramt
+		END
+	END
+	LEGEND
+		STATUS ON
+		KEYSIZE 32 16
+		KEYSPACING 5 5
+		TRANSPARENT ON
+		LABEL
+			TYPE TRUETYPE
+			FONT 'arial'
+			SIZE 9
+			COLOR 1 1 1
+		END
+	END
+
+	## Layer der Typen FlÃ€chen + Grenzen
+
+	# LAYER fh FriedHÃ¶fe / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='FriedhÃ¶fe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 25000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FriedhÃ¶fe"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fh"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[1405]"
+			EXPRESSION "1405"
+			STYLE
+				COLOR 224 255 216
+			END
+		END
+	END
+
+	# LAYER fe VEgetation / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 25000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Vegetation"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fe"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "Brachland, Heide, Moor, Sumpf, Torf"
+			EXPRESSION "1404"
+			STYLE
+				COLOR 242 234 232
+			END
+		END
+		CLASS
+			NAME "Garten"
+			EXPRESSION "1406"
+			STYLE
+				COLOR 234 255 211
+			END
+		END
+		CLASS
+			NAME "(1409)"
+			EXPRESSION "1409"
+			STYLE
+				COLOR 255 247 191
+			END
+		END
+		CLASS
+			NAME "Wald"
+			EXPRESSION "1414"
+			STYLE
+				COLOR 216 255 216
+			END
+		END
+		CLASS
+			NAME "(1561)"
+			EXPRESSION "1561"
+			STYLE
+				COLOR 234 255 211
+			END
+		END
+	END
+
+	# LAYER fb WohnBauflÃ€chen / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='WohnbauflÃ€chen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 500000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/WohnbauflÃ€chen"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fb"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "WohnbauflÃ€che"
+			EXPRESSION "1401"
+			STYLE
+				COLOR 255 234 244
+			END
+		END
+	END
+
+	# LAYER gt Topographie / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Topographie"
+			wms_title	"Grenzen"
+		END
+		NAME "gt"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "(rn1551)"
+			EXPRESSION "rn1551"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER ge VEgetation / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Vegetation"
+			wms_title	"Grenzen"
+		END
+		NAME "ge"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "(rn1560)"
+			EXPRESSION "rn1560"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 255 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1561)"
+			EXPRESSION "rn1561"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 255 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1563)"
+			EXPRESSION "rn1563"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "[2515]"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Wald"
+			EXPRESSION "2517"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 255 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER gh FriedHÃ¶fe / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='FriedhÃ¶fe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FriedhÃ¶fe"
+			wms_title	"Grenzen"
+		END
+		NAME "gh"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[2515]"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER gb WohnBauflÃ€chen / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='WohnbauflÃ€chen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/WohnbauflÃ€chen"
+			wms_title	"Grenzen"
+		END
+		NAME "gb"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[2515]"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER fw GewÃ€sser / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='GewÃ€sser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 500000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GewÃ€sser"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fw"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "GewÃ€sser"
+			EXPRESSION "1410"
+			STYLE
+				COLOR 226 255 255
+			END
+		END
+		CLASS
+			NAME "(1523)"
+			EXPRESSION "1523"
+			STYLE
+				COLOR 226 255 255
+			END
+		END
+	END
+
+	# LAYER fs Sport und Freizeit / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 500000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Sport und Freizeit"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fs"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[1405]"
+			EXPRESSION "1405"
+			STYLE
+				COLOR 224 255 216
+			END
+		END
+		CLASS
+			NAME "Ãberdachte TribÃŒne"
+			EXPRESSION "1519"
+			STYLE
+				COLOR 255 127 127
+			END
+		END
+		CLASS
+			NAME "Hart-, Rasenplatz, Spielfeld"
+			EXPRESSION "1520"
+			STYLE
+				COLOR 216 255 216
+			END
+		END
+		CLASS
+			NAME "Schwimmbecken"
+			EXPRESSION "1526"
+			STYLE
+				COLOR 226 255 255
+			END
+		END
+		CLASS
+			NAME "Rennbahn, Laufbahn, GelÃ€uf"
+			EXPRESSION "1521"
+			STYLE
+				COLOR 255 234 244
+			END
+		END
+	END
+
+	# LAYER gs Sport und Freizeit / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Sport und Freizeit"
+			wms_title	"Grenzen"
+		END
+		NAME "gs"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[2515]"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Ãberdachte TribÃŒne"
+			EXPRESSION "rn1519"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				PATTERN
+				 2.00 1.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Hart-, Rasenplatz, Spielfeld"
+			EXPRESSION "rn1520"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "[1524]"
+			EXPRESSION "rn1524"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Schwimmbecken"
+			EXPRESSION "rn1526"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Rennbahn, Laufbahn, GelÃ€uf"
+			EXPRESSION "rn1521"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER gw GewÃ€sser / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='GewÃ€sser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GewÃ€sser"
+			wms_title	"Grenzen"
+		END
+		NAME "gw"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "(rn1551)"
+			EXPRESSION "rn1551"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2520)"
+			EXPRESSION "2520"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				PATTERN
+				 4.00 2.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "GewÃ€sser"
+			EXPRESSION "2518"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1523)"
+			EXPRESSION "rn1523"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Fischtreppe, Sicherheitstor, Sperrwerk"
+			EXPRESSION "rn1548"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Unterirdisches GewÃ€sser"
+			EXPRESSION "rn1550"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER fi Industrie und Gewerbe / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 500000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Industrie und Gewerbe"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fi"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[1401]"
+			EXPRESSION "1401"
+			STYLE
+				COLOR 255 234 244
+			END
+		END
+		CLASS
+			NAME "[1403]"
+			EXPRESSION "1403"
+			STYLE
+				COLOR 237 237 237
+			END
+		END
+		CLASS
+			NAME "[1510]"
+			EXPRESSION "1510"
+			STYLE
+				COLOR 242 234 232
+			END
+		END
+		CLASS
+			NAME "[1305]"
+			EXPRESSION "1305"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "[1501]"
+			EXPRESSION "1501"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "Mast"
+			EXPRESSION "1306"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+	END
+
+	# LAYER gi Industrie und Gewerbe / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Industrie und Gewerbe"
+			wms_title	"Grenzen"
+		END
+		NAME "gi"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "[2515]"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "KlÃ€rbecken"
+			EXPRESSION "rn1510"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn2504)"
+			EXPRESSION "rn2504"
+			STYLE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn2521)"
+			EXPRESSION "rn2521"
+			STYLE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "VorratsbehÃ€lter, Speicherbauwerk unterirdisch"
+			EXPRESSION "rn1321"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "[rn1501]"
+			EXPRESSION "rn1501"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+		CLASS
+			NAME "[rn1305]"
+			EXPRESSION "rn1305"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Mast"
+			EXPRESSION "rn1306"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER fv Verkehr / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 25000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Verkehr"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fv"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "BegleitflÃ€che"
+			EXPRESSION "1406"
+			STYLE
+				COLOR 234 255 211
+			END
+		END
+		CLASS
+			NAME "FuÃgÃ€ngerzone"
+			EXPRESSION "1414"
+			STYLE
+				COLOR 216 255 216
+			END
+		END
+		CLASS
+			NAME "Weg"
+			EXPRESSION "1542"
+			STYLE
+				COLOR 247 247 239
+			END
+		END
+		CLASS
+			NAME "BrÃŒcke, Hochbahn/-straÃe"
+			EXPRESSION "1530"
+			STYLE
+				COLOR 255 255 255
+			END
+		END
+	END
+
+	# LAYER gv Verkehr / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Verkehr"
+			wms_title	"Grenzen"
+		END
+		NAME "gv"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "(2516)"
+			EXPRESSION "2516"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 178 178 178
+				PATTERN 7.00 1.00 END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Bahnverkehr, Platz"
+			EXPRESSION "2515"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Weg"
+			EXPRESSION "rn1542"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 81 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1536)"
+			EXPRESSION "rn1536"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 127 127 127
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1330)"
+			EXPRESSION "rn1330"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1320)"
+			EXPRESSION "rn1320"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				PATTERN 0.35 0.35 END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "BrÃŒcke, Hochbahn/-straÃe"
+			EXPRESSION "rn1530"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 127 127 127
+				PATTERN 2.00 1.00 END
+				SIZE 0.5
+				WIDTH 0.5
+			END
+		END
+		CLASS
+			NAME "(rn1531)"
+			EXPRESSION "rn1531"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 127 127 127
+				PATTERN 1.00 0.50 END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Tunnel, UnterfÃŒhrung"
+			EXPRESSION "rn1533"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 127 127 127
+				PATTERN 0.50 1.50 END
+				SIZE 0.5
+				WIDTH 0.5
+			END
+		END
+	END
+
+	# LAYER fg GebÃ€ude / FlÃ€chen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"FlÃ€chen"
+		END
+		NAME "fg"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "GebÃ€ude fÃŒr Ã¶ffentliche Zwecke"
+			EXPRESSION "1309"
+			STYLE
+				COLOR 255 127 127
+			END
+		END
+		CLASS
+			NAME "Anderes GebÃ€ude"
+			EXPRESSION "1304"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "WohngebÃ€ude"
+			EXPRESSION "1301"
+			STYLE
+				COLOR 153 153 153
+			END
+		END
+		CLASS
+			NAME "(2510)"
+			EXPRESSION "2510"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "Aussichtsturm"
+			EXPRESSION "1501"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "Mauer"
+			EXPRESSION "1305"
+			STYLE
+				COLOR 204 204 204
+			END
+		END
+		CLASS
+			NAME "Brunnen"
+			EXPRESSION "1525"
+			STYLE
+				COLOR 226 255 255
+			END
+		END
+	END
+
+	# LAYER gg GebÃ€ude / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 3500
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"Grenzen"
+		END
+		NAME "gg"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "(rn1330)"
+			EXPRESSION "rn1330"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2512)"
+			EXPRESSION "2512"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "GebÃ€ude unter der ErdoberflÃ€che"
+			EXPRESSION "2032"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn2510)"
+			EXPRESSION "rn2510"
+			STYLE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Anderes GebÃ€ude"
+			EXPRESSION "2031"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN
+				 2.00 1.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Ãffentliches GebÃ€ude"
+			EXPRESSION "2505"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1305)"
+			EXPRESSION "rn1305"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(rn1317)"
+			EXPRESSION "rn1317"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 153 153 153
+				PATTERN
+				 2.00 1.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Anderes GebÃ€ude"
+			EXPRESSION "rn1501"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+		CLASS
+			NAME "(2507)"
+			EXPRESSION "2507"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "aufgestÃ€ndert"
+			EXPRESSION "2508"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				PATTERN 2.00 1.00 END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Schornstein im GebÃ€ude"
+			EXPRESSION "2513"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.25
+				WIDTH 0.25
+			END
+		END
+		CLASS
+			NAME "Turm im GebÃ€ude"
+			EXPRESSION "2514"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+		CLASS
+			NAME "(rn1525)"
+			EXPRESSION "rn1525"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 204 204
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER gr Rechtliche Festlegungen / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 25000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Rechtliche Festlegungen"
+			wms_title	"Grenzen"
+		END
+		NAME "gr"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "Bau-, Raum-, Bodenordnungsrecht"
+			EXPRESSION "rn1704"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 255 127 127
+				PATTERN
+				 4.00 1.00
+				END
+				SIZE 1
+			END
+		END
+	END
+
+	# LAYER  gff FlurstÃŒcke / FlÃ€chen / Grenzen
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FlurstÃŒcke/FlÃ€chen"
+			wms_title	"Grenzen"
+		END
+		NAME "gff"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		# ToDo: Universelle Version mit GKZ als Parameter?
+		HEADER   "/opt/gdi/alkisn/templates/alkisausk_inlh.html" 
+		TEMPLATE "/opt/gdi/alkisn/templates/alkisausk_inl*gkz*.html" # gkz = mandant
+		FOOTER   "/opt/gdi/alkisn/templates/footer.html"
+		TOLERANCE 1
+		TYPE POLYGON
+		UNITS METERS
+		CLASS
+			NAME "FlurstÃŒcksgrenze"
+			EXPRESSION "2028"
+			STYLE
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				OUTLINECOLOR 0 0 0
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+	END
+
+	## Layer des Typs Linien
+
+	# LAYER lt Topographie / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Topographie"
+			wms_title	"Linien"
+		END
+		NAME "lt"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "Damm, Wall, Deich, Graben, Knick, Wallkante"
+			EXPRESSION "2620"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 81 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER lw GewÃ€sser / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='GewÃ€sser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GewÃ€sser"
+			wms_title	"Linien"
+		END
+		NAME "lw"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "(2003)"
+			EXPRESSION "2003"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2592)"
+			EXPRESSION "2592"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 204 204
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2593)"
+			EXPRESSION "2593"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 204 204
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 4.00 2.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2595)"
+			EXPRESSION "2595"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 204 204
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 1.00 2.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2560)"
+			EXPRESSION "2560"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 204 204
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER lv Verkehr / Linien 
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Verkehr"
+			wms_title	"Linien"
+		END
+		NAME "lv"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "(2535)"
+			EXPRESSION "2535"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.3535
+			END
+			STYLE
+				COLOR 81 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 2.00 3.20
+				END
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+		CLASS
+			NAME "(2525)"
+			EXPRESSION "2525"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2527)"
+			EXPRESSION "2527"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 153 153 153
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2530)"
+			EXPRESSION "2530"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.505
+			END
+			STYLE
+				COLOR 127 127 127
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.5
+				WIDTH 0.5
+			END
+		END
+		CLASS
+			NAME "(2506)"
+			EXPRESSION "2506"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 153 153 153
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 0.35 0.35
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Widerlager"
+			EXPRESSION "2533"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 127 127 127
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER li Industrie und Gewerbe / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Industrie und Gewerbe"
+			wms_title	"Linien"
+		END
+		NAME "li"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "[2524]"
+			EXPRESSION "2524"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER lg GebÃ€ude / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 3500
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"Linien"
+		END
+		NAME "lg"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "(2507)"
+			EXPRESSION "2507"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "(2303)"
+			EXPRESSION "2303"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 1.00 1.00
+				END
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER lp Politische Grenzen / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Politische Grenzen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 100000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Politische Grenzen"
+			wms_title	"Linien"
+		END
+		NAME "lp"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "Flurgrenze"
+			EXPRESSION "2012"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 11.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 3.00 0.00 3.00 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+		CLASS
+			NAME "Flurgrenze"
+			EXPRESSION "2012"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 11.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 3.00 0.00 3.00 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+		CLASS
+			NAME "Gemarkungsgrenze"
+			EXPRESSION "2014"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 8.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 3.00 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+		CLASS
+			NAME "Gemarkungsgrenze"
+			EXPRESSION "2014"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 8.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 3.00 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+		CLASS
+			NAME "Gemeindegrenze"
+			EXPRESSION "2022"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 5.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+		CLASS
+			NAME "Gemeindegrenze"
+			EXPRESSION "2022"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 1.01
+			END
+			STYLE
+				COLOR 242 127 255
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 5.00 5.00
+				END
+				SIZE 1
+			END
+			STYLE
+				COLOR 242 127 255
+				INITIALGAP 7.5
+				LINEJOIN ROUND
+				PATTERN
+				 0.00 10.00
+				END
+				SIZE 1
+			END
+		END
+	END
+
+	# LAYER lfn FlurstÃŒcke / Nummern / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FlurstÃŒcke/Nummern"
+			wms_title	"Linien"
+		END
+		NAME "lfn"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "Bruchstriche"
+			EXPRESSION "2001"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+		CLASS
+			NAME "Zuordnungspfeil"
+			EXPRESSION "2004"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.1818
+			END
+			STYLE
+				COLOR 0 0 0
+				LINEJOIN ROUND
+				SIZE 0.18
+				WIDTH 0.18
+			END
+		END
+	END
+
+	# LAYER lff FlurstÃŒcke / FlÃ€chen / Linien
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FlurstÃŒcke/FlÃ€chen"
+			wms_title	"Linien"
+		END
+		NAME "lff"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		TYPE LINE
+		UNITS METERS
+		CLASS
+			NAME "Strittige Grenze"
+			EXPRESSION "2006"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.3535
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 6.00 1.00
+				END
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+		CLASS
+			NAME "FlurstÃŒcksgrenze nicht feststellbar"
+			EXPRESSION "2008"
+			STYLE
+				COLOR 255 255 255
+				OPACITY 0
+				WIDTH 0.3535
+			END
+			STYLE
+				COLOR 0 0 0
+				LINECAP SQUARE
+				LINEJOIN ROUND
+				PATTERN
+				 2.00 1.00
+				END
+				SIZE 0.35
+				WIDTH 0.35
+			END
+		END
+	END
+
+	## Layer des Typs Punkte
+
+	# LAYER pff FlurstÃŒcke / FlÃ€chen / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FlurstÃŒcke/FlÃ€chen"
+			wms_title	"Punkte"
+		END
+		NAME "pff"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Abgemarkter Grenzpunkt"
+			EXPRESSION "3020"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.6995
+				SYMBOL "norGIS_alkis3020_1"
+			END
+		END
+		CLASS
+			NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"
+			EXPRESSION "3022"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.6995
+				SYMBOL "norGIS_alkis3022_1"
+			END
+		END
+		CLASS
+			NAME "FlurstÃŒcksÃŒberhaken"
+			EXPRESSION "3010"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 1
+				SIZE 2.2509
+				SYMBOL "norGIS_alkis3010_1"
+			END
+		END
+	END
+
+	# LAYER pg GebÃ€ude / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 3500
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"Punkte"
+		END
+		NAME "pg"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Springbrunnen, Zierbrunnen"
+			EXPRESSION "3539"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.056
+				SYMBOL "norGIS_alkis3539_1"
+			END
+		END
+		CLASS
+			NAME "(3527)"
+			EXPRESSION "3527"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.8294
+				SYMBOL "norGIS_alkis3527_1"
+			END
+		END
+		CLASS
+			NAME "Umformer"
+			EXPRESSION "3521"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.6935
+				SYMBOL "norGIS_alkis3521_1"
+			END
+		END
+		CLASS
+			NAME "Spielcasino"
+			EXPRESSION "3308"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.1437
+				SYMBOL "norGIS_alkis3308_1"
+			END
+		END
+		CLASS
+			NAME "Denkmal"
+			EXPRESSION "3532"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 2
+				SIZE 4.866
+				SYMBOL "norGIS_alkis3532_1"
+			END
+		END
+		CLASS
+			NAME "Polizei"
+			EXPRESSION "3324"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3324_1"
+			END
+		END
+		CLASS
+			NAME "Post"
+			EXPRESSION "3312"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3312_1"
+			END
+		END
+		CLASS
+			NAME "Hallenbad"
+			EXPRESSION "3334"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 6.2313
+				SYMBOL "norGIS_alkis3334_1"
+			END
+		END
+		CLASS
+			NAME "Kapelle"
+			EXPRESSION "3318"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.0137
+				SYMBOL "norGIS_alkis3318_1"
+			END
+		END
+		CLASS
+			NAME "Feuerwehr"
+			EXPRESSION "3326"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3326_1"
+			END
+		END
+		CLASS
+			NAME "Kirche"
+			EXPRESSION "3316"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 10.0381
+				SYMBOL "norGIS_alkis3316_1"
+			END
+		END
+		CLASS
+			NAME "Kindergarten"
+			EXPRESSION "3323"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 6.2313
+				SYMBOL "norGIS_alkis3323_1"
+			END
+		END
+		CLASS
+			NAME "Toilette"
+			EXPRESSION "3311"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3311_1"
+			END
+		END
+		CLASS
+			NAME "Kino"
+			EXPRESSION "3306"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3306_1"
+			END
+		END
+		CLASS
+			NAME "Tiefgarage"
+			EXPRESSION "3336"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 6.2313
+				SYMBOL "norGIS_alkis3336_1"
+			END
+		END
+		CLASS
+			NAME "Bank"
+			EXPRESSION "3300"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.189
+				SYMBOL "norGIS_alkis3300_1"
+			END
+		END
+		CLASS
+			NAME "Brunnen / Gasquelle, Mofette / Heilquelle"
+			EXPRESSION "3529"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 2.6965
+				SYMBOL "norGIS_alkis3529_1"
+			END
+		END
+		CLASS
+			NAME "Hotel"
+			EXPRESSION "3302"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3302_1"
+			END
+		END
+		CLASS
+			NAME "GaststÃ€tte"
+			EXPRESSION "3305"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3305_1"
+			END
+		END
+		CLASS
+			NAME "Meilenstein, historischer Grenzstein"
+			EXPRESSION "3536"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 1
+				SIZE 2.8688
+				SYMBOL "norGIS_alkis3536_1"
+			END
+		END
+	END
+
+	# LAYER pv Verkehr / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Verkehr"
+			wms_title	"Punkte"
+		END
+		NAME "pv"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Reitweg"
+			EXPRESSION "3430"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3430_1"
+			END
+		END
+		CLASS
+			NAME "FuÃweg"
+			EXPRESSION "3424"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3424_1"
+			END
+		END
+		CLASS
+			NAME "Haltepunkt"
+			EXPRESSION "3578"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.1949
+				SYMBOL "norGIS_alkis3578_1"
+			END
+		END
+		CLASS
+			NAME "Parkplatz"
+			EXPRESSION "3432"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.4836
+				SYMBOL "norGIS_alkis3432_1"
+			END
+		END
+		CLASS
+			NAME "Radweg"
+			EXPRESSION "3426"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3426_1"
+			END
+		END
+		CLASS
+			NAME "Rad- und FuÃweg"
+			EXPRESSION "3428"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.0077
+				SYMBOL "norGIS_alkis3428_1"
+			END
+		END
+	END
+
+	# LAYER pe Vegetation / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Vegetation"
+			wms_title	"Punkte"
+		END
+		NAME "pe"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Baumschule"
+			EXPRESSION "3446"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.192
+				SYMBOL "norGIS_alkis3446_1"
+			END
+		END
+		CLASS
+			NAME "Sumpf"
+			EXPRESSION "3478"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.065
+				SYMBOL "norGIS_alkis3478_1"
+			END
+		END
+		CLASS
+			NAME "Garten"
+			EXPRESSION "3421"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.8127
+				SYMBOL "norGIS_alkis3421_1"
+			END
+		END
+		CLASS
+			NAME "Streuobstacker"
+			EXPRESSION "3440"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.192
+				SYMBOL "norGIS_alkis3440_1"
+			END
+		END
+		CLASS
+			NAME "Quelle"
+			EXPRESSION "3613"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.0197
+				SYMBOL "norGIS_alkis3613_1"
+			END
+		END
+		CLASS
+			NAME "Nadelbaum"
+			EXPRESSION "3597"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 2
+				SIZE 4.8638
+				SYMBOL "norGIS_alkis3597_1"
+			END
+		END
+		CLASS
+			NAME "Obstbaumplantage"
+			EXPRESSION "3452"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.192
+				SYMBOL "norGIS_alkis3452_1"
+			END
+		END
+		CLASS
+			NAME "Nadelwald"
+			EXPRESSION "3460"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.8491
+				SYMBOL "norGIS_alkis3460_1"
+			END
+		END
+		CLASS
+			NAME "Unland"
+			EXPRESSION "3480"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.0107
+				SYMBOL "norGIS_alkis3480_1"
+			END
+		END
+		CLASS
+			NAME "Mischwald"
+			EXPRESSION "3462"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.3703
+				SYMBOL "norGIS_alkis3462_1"
+			END
+		END
+		CLASS
+			NAME "Gras"
+			EXPRESSION "3413"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 0.4305
+				SYMBOL "norGIS_alkis3413_1"
+			END
+		END
+		CLASS
+			NAME "ZierflÃ€che"
+			EXPRESSION "3605"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 2.4245
+				SYMBOL "norGIS_alkis3605_1"
+			END
+		END
+		CLASS
+			NAME "Streuobstwiese"
+			EXPRESSION "3441"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.192
+				SYMBOL "norGIS_alkis3441_1"
+			END
+		END
+		CLASS
+			NAME "Laubwald"
+			EXPRESSION "3458"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.3763
+				SYMBOL "norGIS_alkis3458_1"
+			END
+		END
+		CLASS
+			NAME "Laubbaum"
+			EXPRESSION "3599"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 2
+				SIZE 4.567
+				SYMBOL "norGIS_alkis3599_1"
+			END
+		END
+		CLASS
+			NAME "Heide"
+			EXPRESSION "3474"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.9261
+				SYMBOL "norGIS_alkis3474_1"
+			END
+		END
+		CLASS
+			NAME "Mischwald"
+			EXPRESSION "3470"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.8718
+				SYMBOL "norGIS_alkis3470_1"
+			END
+		END
+		CLASS
+			NAME "Busch, Hecke, Knick"
+			EXPRESSION "3601"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.4275
+				SYMBOL "norGIS_alkis3601_1"
+			END
+		END
+	END
+
+	# LAYER pw GewÃ€sser / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='GewÃ€sser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GewÃ€sser"
+			wms_title	"Punkte"
+		END
+		NAME "pw"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Unterirdisches FlieÃgewÃ€sser"
+			EXPRESSION "3619"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.2236
+				SYMBOL "norGIS_alkis3619_1"
+			END
+		END
+		CLASS
+			NAME "FlieÃgewÃ€sser"
+			EXPRESSION "3488"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.2236
+				SYMBOL "norGIS_alkis3488_1" # Pfeil
+		# FEHLER: Bei Drehung wird oben/unten abgeschnitten.
+		# Siehe: https://github.com/mapserver/mapserver/pull/5264
+		# http://freegis.org/pipermail/mapserver-de/2016-April/004793.html
+			END
+		END
+		CLASS
+			NAME "GewÃ€sser"
+			EXPRESSION "3490"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.3369
+				SYMBOL "norGIS_alkis3490_1"
+			END
+		END
+		CLASS
+			NAME "Quelle"
+			EXPRESSION "3613"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.0197
+				SYMBOL "norGIS_alkis3613_1"
+			END
+		END
+		CLASS
+			NAME "(3596)"
+			EXPRESSION "3596"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 1
+				SIZE 3.6936
+				SYMBOL "norGIS_alkis3596_1"
+			END
+		END
+		CLASS
+			NAME "FlieÃgewÃ€sser, nicht stÃ€ndig Wasser fÃŒhrend"
+			EXPRESSION "3621"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.2236
+				SYMBOL "norGIS_alkis3621_1"
+			END
+		END
+	END
+
+	# LAYER pi Industrie und Gewerbe / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Industrie und Gewerbe"
+			wms_title	"Punkte"
+		END
+		NAME "pi"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Tankstelle"
+			EXPRESSION "3401"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.2343
+				SYMBOL "norGIS_alkis3401_1"
+			END
+		END
+		CLASS
+			NAME "Umformer"
+			EXPRESSION "3521"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.6935
+				SYMBOL "norGIS_alkis3521_1"
+			END
+		END
+		CLASS
+			NAME "Antenne / Funkmast"
+			EXPRESSION "3506"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 2
+				SIZE 5.2585
+				SYMBOL "norGIS_alkis3506_1"
+			END
+		END
+		CLASS
+			NAME "VorratsbehÃ€lter"
+			EXPRESSION "3522"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.1949
+				SYMBOL "norGIS_alkis3522_1"
+			END
+		END
+		CLASS
+			NAME "Schornstein, Schlot, Esse"
+			EXPRESSION "3508"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 3.3763
+				SYMBOL "norGIS_alkis3508_1"
+			END
+		END
+		CLASS
+			NAME "Mast"
+			EXPRESSION "3504"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 2.1979
+				SYMBOL "norGIS_alkis3504_1"
+			END
+		END
+		CLASS
+			NAME "Windrad"
+			EXPRESSION "3501"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 3
+				SIZE 6.8565
+				SYMBOL "norGIS_alkis3501_1"
+			END
+		END
+		CLASS
+			NAME "Laufkran, BrÃŒckenlaufkran"
+			EXPRESSION "3514"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				OFFSET 0 2
+				SIZE 5.235
+				SYMBOL "norGIS_alkis3514_1"
+			END
+		END
+		CLASS
+			NAME "Torf"
+			EXPRESSION "3407"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 4.5092
+				SYMBOL "norGIS_alkis3407_1"
+			END
+		END
+	END
+
+	# LAYER ps Sport und Freizeit / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Sport und Freizeit"
+			wms_title	"Punkte"
+		END
+		NAME "ps"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Spielplatz, Bolzplatz"
+			EXPRESSION "3423"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 7.3643
+				SYMBOL "norGIS_alkis3423_1"
+			END
+		END
+		CLASS
+			NAME "Kleingarten"
+			EXPRESSION "3419"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 6.4126
+				SYMBOL "norGIS_alkis3419_1"
+			END
+		END
+		CLASS
+			NAME "Garten"
+			EXPRESSION "3421"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.8127
+				SYMBOL "norGIS_alkis3421_1"
+			END
+		END
+		CLASS
+			NAME "Rasen"
+			EXPRESSION "3413"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 0.4305
+				SYMBOL "norGIS_alkis3413_1"
+			END
+		END
+		CLASS
+			NAME "Park"
+			EXPRESSION "3415"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.6648
+				SYMBOL "norGIS_alkis3415_1"
+			END
+		END
+		CLASS
+			NAME "Campingplatz"
+			EXPRESSION "3412"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 7.7268
+				SYMBOL "norGIS_alkis3412_1"
+			END
+		END
+	END
+
+	# LAYER pt Topographie / Punkte
+	LAYER
+		CLASSITEM "signaturnummer"
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Topographie"
+			wms_title	"Punkte"
+		END
+		NAME "pt"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS METERS
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			NAME "Felsen, Felsblock, Felsnadel"
+			EXPRESSION "3627"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 5.3476
+				SYMBOL "norGIS_alkis3627_1"
+			END
+		END
+		CLASS
+			NAME "Busch, Hecke, Knick"
+			EXPRESSION "3601"
+			STYLE
+				ANGLE [drehwinkel_grad]
+				MINSIZE 1
+				SIZE 1.4275
+				SYMBOL "norGIS_alkis3601_1"
+			END
+		END
+
+		# "Internal Server Error" wenn diese Class aktiv ist.
+		#  Tritt nur auf bei kleinen MaÃstÃ€ben (> 1000) und an manchen Stellen.
+	##	CLASS 
+	#		NAME "Busch, Hecke, Knick"
+	#		EXPRESSION "3632"
+	#		STYLE
+	#			ANGLE [drehwinkel_grad]
+	#			MINSIZE 1
+	#			SIZE 2.0
+	#			SYMBOL "norGIS_alkis3632_1"
+	#		END
+	##	END
+	END
+
+	## Layer des Typs  Beschriftungen
+
+	# LAYER bfn FlurstÃŒcke / Nummern / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil'))  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FlurstÃŒcke/Nummern"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bfn"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bg GebÃ€ude / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer')  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 3500
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bg"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bg2 GebÃ€ude / Laufende Hausnummern / Beschriftungen
+	# * NebengebÃ€ude-Nummer in Klammer, normalerweise aus
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÃ€ude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 3500
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+		#	wms_layer_group	"/GebÃ€ude/Laufende Hausnummern"
+		#	wms_title	"Beschriftungen (Punkte)"
+			wms_layer_group	"/GebÃ€ude"
+			wms_title	"lfd. Nr. NebengebÃ€ude"
+		END
+		NAME "bg2"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bl Lagebezeichnungen / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Lagebezeichnungen"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bl"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER br Rechtliche Festlegungen / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 25000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Rechtliche Festlegungen"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "br"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bv Verkehr / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Verkehr"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bv"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bh FriedhÃ¶fe / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FriedhÃ¶fe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/FriedhÃ¶fe"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bh"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER be Vegetation / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Vegetation"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "be"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bw GewÃ€sser / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÃ€sser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 5000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/GewÃ€sser"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bw"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bi Industrie und Gewerbe / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Industrie und Gewerbe"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bi"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT # ANNOTATION
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bs Sport und Freizeit / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Sport und Freizeit"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bs"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT # ANNOTATION
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bb WohnbauflÃ€chen / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÃ€chen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/WohnbauflÃ€chen"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bb"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT # ANNOTATION
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+
+	# LAYER bt Topographie / Beschriftungen
+	LAYER
+		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
+		CONNECTIONTYPE POSTGIS
+		DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
+		#EXTENT  ...
+		LABELITEM "text"
+		MAXSCALEDENOM 10000
+		METADATA
+			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
+			wms_layer_group	"/Topographie"
+			wms_title	"Beschriftungen (Punkte)"
+		END
+		NAME "bt"
+		PROCESSING "CLOSE_CONNECTION=DEFER"
+		PROJECTION "init=epsg:25832" END
+		SIZEUNITS INCHES
+		STATUS OFF
+		SYMBOLSCALEDENOM 1000
+		TYPE POINT
+		UNITS METERS
+		CLASS
+			LABEL
+				ANGLE [drehwinkel_grad]
+				ANTIALIAS TRUE
+				FONT [font_umn]
+				SIZE [size_umn]
+				BUFFER 2
+				COLOR [color_umn]
+				FORCE TRUE
+				OUTLINECOLOR 255 255 255
+				POSITION [position_umn]
+				PRIORITY 10
+				TYPE TRUETYPE
+			END
+		END
+	END
+END
Index: /trunk/umn/alkis_n/symbols.sym
===================================================================
--- /trunk/umn/alkis_n/symbols.sym	(revision 367)
+++ /trunk/umn/alkis_n/symbols.sym	(revision 367)
@@ -0,0 +1,342 @@
+SYMBOLSET
+# Symbole fuer ALKIS-Mapfile generiert aus aus Norbit-QGIS-Plugin
+	SYMBOL
+		NAME "0"
+		TYPE ELLIPSE
+		FILLED TRUE
+		POINTS
+		  1 1
+		  1 1
+		END
+	END
+	SYMBOL
+		NAME "norGIS_alkis3020_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3020_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3022_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3022_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3010_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3010_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3539_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3539_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3527_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3527_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3521_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3521_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3308_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3308_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3532_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3532_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3324_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3324_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3312_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3312_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3334_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3334_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3318_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3318_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3326_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3326_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3316_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3316_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3323_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3323_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3311_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3311_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3306_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3306_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3336_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3336_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3300_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3300_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3529_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3529_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3302_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3302_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3305_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3305_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3536_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3536_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3430_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3430_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3424_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3424_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3578_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3578_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3432_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3432_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3426_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3426_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3428_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3428_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3446_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3446_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3478_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3478_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3421_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3421_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3440_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3440_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3613_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3613_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3597_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3597_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3452_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3452_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3460_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3460_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3480_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3480_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3462_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3462_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3413_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3413_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3605_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3605_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3441_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3441_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3458_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3458_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3599_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3599_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3474_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3474_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3470_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3470_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3601_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3601_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3619_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3619_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3488_1" # Pfeil
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3488_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3490_1" # Welle
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3490_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3596_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3596_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3621_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3621_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3401_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3401_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3506_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3506_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3522_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3522_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3508_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3508_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3504_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3504_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3501_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3501_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3514_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3514_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3407_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3407_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3423_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3423_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3419_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3419_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3415_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3415_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3412_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3412_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3627_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3627_1.svg"
+	END
+	SYMBOL
+		NAME "norGIS_alkis3632_1"
+		TYPE SVG
+		IMAGE "/opt/gdi/alkisn/svg/alkis3632_1.svg"
+	END
+END
Index: /trunk/import/norgis_alkis_pp/x_classic2norgis.sql
===================================================================
--- /trunk/import/norgis_alkis_pp/x_classic2norgis.sql	(revision 367)
+++ /trunk/import/norgis_alkis_pp/x_classic2norgis.sql	(revision 367)
@@ -0,0 +1,393 @@
+
+-- ===================================================================================
+--  ALKIS-PostGIS   Mapbender-Navigation und Buchauskunft fÃŒr NorGIS-ALKIS-Importer
+-- ===================================================================================
+
+--Stand 2016-02-23
+
+-- Aufgabe:
+--
+-- Die ALKIS-Navigation fÃŒr Mapbender 2.7.4 arbeitet bisher mit der Datenbank-Struktur
+-- aus dem "Klassischen" Import mit Aufruf des Konvertres ogr2ogr aus einen Shellscript.
+--
+-- Dabei wird ein PostProcessing (Nach-Konverter-Verarbeitung) durchgefÃŒhrt,
+-- das Tabellen und Views bereit stellt, fÃŒr einen schnellen Zugriff in 
+--  Mapfile, Auskunft und Navigation. 
+--
+-- Dies Script soll eine Datenbank, die mit dem NorGIS-ALKIS-Importer geladen wurde
+-- fÃŒr die Verwendung mit ALKIS-Navigation vorbereiten. 
+-- Es ist jedoch eine speziell angepasste Version der NAV-PHP-Scripte notwendig. 
+
+-- Alternative: 
+--  Die bisher auch in der NAV verwendeten Tabellen "pp_flur", "pp_gemarkung", "pp_gemeinde"
+--  werden auch fÃŒr eine "Ãbersichtskarte" benÃ¶tigt (Gruppe "Gebiete" im Classic-Mapfile). 
+--  Um diese zu bekommen mÃŒsste dieser Teil des klassischen Post-Processing auch in der 
+--  NorGIS-Version ausgefÃŒhrt wÃŒrde.
+--  Siehe Script: "pp_gebiete.sql" (FÃŒllen) und Teile von "pp_definition.sql" (DB-Struktur).
+
+
+-- Die Beziehungen werden immer noch mit geladen, sind aber inzwischen ÃŒberflÃŒssig,
+-- weil jetzt Relationen zwischen den Tabellen definiert sind. 
+  TRUNCATE alkis_beziehungen;
+
+
+-- Bausteine fÃŒr andere Views:
+-- ---------------------------
+
+-- Ein View, der die Verbindung von FlurstÃŒck zur Buchung fÃŒr zwei verschiedene FÃ€lle herstellt.
+-- Einmal die "normalen" (direkten) Buchungen.
+-- Zweitens ÃŒber die Rechte von Buchungsstellen an anderen Buchungsstellen.
+-- Dies kann als "MittelstÃŒck" in den anderen Views eingefÃŒgt werden.
+
+-- Einfach/Direkt:
+--   FlurstÃŒck   >istGebucht>                         (Buchungs-Stelle)
+--
+-- Mit "Recht an":
+--   FlurstÃŒck   >istGebucht>  Buchungs-Stelle  <an<  (Buchungs-Stelle)
+--                               (dienend)              (herrschend) 
+
+--           DROP VIEW public.doppelverbindung;
+CREATE OR REPLACE VIEW public.doppelverbindung
+AS
+  -- FS >istGebucht> Buchungstelle
+  SELECT f1.gml_id              AS fsgml,    -- gml_id FlurstÃŒck
+         b1.gml_id              AS bsgml,    -- gml_id Buchungs
+         0                      AS ba_dien
+    FROM ax_flurstueck f1
+    JOIN ax_buchungsstelle b1   ON f1.istgebucht = b1.gml_id
+ UNION
+  -- FS >istGebucht> Buchungstelle  <an<  Buchungstelle
+  SELECT f2.gml_id              AS fsgml,    -- gml_id FlurstÃŒck
+         b2.gml_id              AS bsgml,    -- gml_id Buchung - (herrschendes GB)
+         dien.buchungsart       AS ba_dien   -- Ein Feld aus der Zwischen-Buchung zur Fall-Unterscheidung
+    FROM ax_flurstueck f2
+    JOIN ax_buchungsstelle dien ON f2.istgebucht = dien.gml_id
+    JOIN ax_buchungsstelle b2   ON dien.gml_id = ANY (b2.an)  -- auch "zu" ?
+   WHERE dien.endet IS NULL;   -- FÃŒr das zusÃ€tzliche Verbindungselement die Historie HIER ausschlieÃen, 
+                               -- FÃŒr andere Tabellen muss dies in dem View erfolgen, der dies verwendet.
+
+COMMENT ON VIEW public.doppelverbindung 
+ IS 'ALKIS-Beziehung von FlurstÃŒck zu Buchung. UNION-Zusammenfassung des einfachen Falls mit direkter Buchung und des Falles mit Recht einer Buchungsstelle an einer anderen Buchungsstelle.
+Dies ist ausschlieÃlich gedacht zur Verwendung in anderen Views um diese einfacher zu machen.';
+
+
+-- Ein View, der die Verbindung von FlurstÃŒck zur StraÃentabelle fÃŒr zwei verschiedene FÃ€lle herstellt.
+-- Einmal ÃŒber die Lagebezeichnung MIT Hausnummer und einmal OHNE.
+-- Dies kann als "MittelstÃŒck" in den anderen Views eingefÃŒgt werden.
+
+--           DROP VIEW public.flst_an_strasse;
+CREATE OR REPLACE VIEW public.flst_an_strasse
+AS
+  -- FlurstÃŒck >weistAuf> ax_lagebezeichnungMIThausnummer <JOIN> ax_lagebezeichnungkatalogeintrag
+  SELECT fm.gml_id AS fsgml,
+         sm.gml_id AS stgml,                 -- Filter: gml_id der StraÃe
+         'm' AS fall                         -- SÃ€tze unterschieden: Mit HsNr
+    FROM ax_flurstueck fm                    -- FlurstÃŒck Mit
+    JOIN ax_lagebezeichnungmithausnummer lm  -- Lage MIT
+      ON lm.gml_id = ANY (fm.weistauf)
+    JOIN ax_lagebezeichnungkatalogeintrag sm
+      ON lm.land=sm.land AND lm.regierungsbezirk=sm.regierungsbezirk AND lm.kreis=sm.kreis AND lm.gemeinde=sm.gemeinde AND lm.lage=sm.lage 
+   WHERE lm.endet IS NULL AND fm.endet IS NULL -- nichts Historisches
+ UNION
+  -- FlurstÃŒck >zeigtAuf> ax_lagebezeichnungOHNEhausnummer <JOIN> ax_lagebezeichnungkatalogeintrag
+  SELECT fo.gml_id AS fsgml,
+         so.gml_id AS stgml,                 -- Filter: gml_id der StraÃe
+         'o' AS fall                         -- SÃ€tze unterschieden: Ohne HsNr
+    FROM ax_flurstueck fo                    -- FlurstÃŒck OHNE
+    JOIN ax_lagebezeichnungohnehausnummer lo -- Lage OHNE
+      ON lo.gml_id = ANY (fo.zeigtauf)
+    JOIN ax_lagebezeichnungkatalogeintrag so -- StraÃe OHNE
+      ON lo.land=so.land AND lo.regierungsbezirk=so.regierungsbezirk AND lo.kreis=so.kreis AND lo.gemeinde=so.gemeinde AND lo.lage=so.lage
+   WHERE lo.endet IS NULL AND fo.endet IS NULL; -- nichts Historisches
+
+COMMENT ON VIEW public.flst_an_strasse 
+ IS 'ALKIS-Beziehung von FlurstÃŒck zu StraÃentabelle. UNION-Zusammenfassung der FÃ€lle MIT und OHNE Hausnummer.';
+
+-- Muss man noch dafÃŒr sorgen, dass FlurstÃŒck nicht doppelt vorkommt? z.B. mit DISTINCT
+-- Oder mÃŒssen ggf. mehrfache FS im Programm ÃŒbersprungen werden?
+
+-- Test-Ausgabe:
+--   SELECT * FROM flst_an_strasse WHERE stgml='DENW18AL000004Fl' LIMIT 40;
+
+
+-- Generelle Export-Struktur "FlurstÃŒck - Buchung - Grundbuch - Person"
+-- --------------------------------------------------------------------
+-- Verwendet den gespeicherten View "doppelverbindung".
+-- Wird benÃ¶tigt im Auskunft-Modul "alkisexport.php":
+-- Je nach aufrufendem Modul wird der Filter (WHERE) an anderer Stelle gesetzt (gml_id von FS, GB oder Pers.)
+-- FÃŒr Filter nach "StraÃe" siehe die nachfolgende Sonderversion "exp_csv_str".
+
+-- Problem / Konflikt:
+-- Es kann nur eine lineare Struktur aus Spalten und Zeilen exportiert werden. 
+-- Wenn nicht nur die Daten des Ausgangs-Objektes exportiert werden, sondern auch verbundene Tabellen in 
+-- einer 1:N-Struktur, dann verdoppeln sich Zeileninhalte und es werden redundante Daten erzeugt. 
+-- Diese Redundanzen mÃŒssen vom dem Programm gefiltert werden, das die Daten ÃŒber eine Schnittstelle einliest.
+
+-- Anwendungs-Beispiel: Abrechnung von AnliegerbeitrÃ€gen.
+
+DROP VIEW IF EXISTS exp_csv;
+
+CREATE OR REPLACE VIEW exp_csv
+AS
+ SELECT
+  -- F l u r s t ÃŒ c k
+    f.gml_id                             AS fsgml,       -- mÃ¶glicher Filter FlurstÃŒcks-GML-ID
+    f.flurstueckskennzeichen             AS fs_kennz,
+    f.gemarkungsnummer,                                  -- Teile des FS-Kennz. noch mal einzeln
+    f.flurnummer, f.zaehler, f.nenner, 
+    f.amtlicheflaeche                    AS fs_flae,
+    g.bezeichnung                        AS gemarkung,
+
+  -- G r u n d b u c h
+    gb.gml_id                            AS gbgml,       -- mÃ¶glicher Filter Grundbuch-GML-ID
+    gb.bezirk                            AS gb_bezirk,
+    gb.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt,
+    z.bezeichnung                        AS beznam,      -- GB-Bezirks-Name
+
+  -- B u c h u n g s s t e l l e  (GrundstÃŒck)
+    s.laufendenummer                     AS bu_lfd,      -- BVNR
+  --s.zaehler, s.nenner,                                 -- Anteil des GB am FS, einzelne Felder
+    '=' || s.zaehler || '/' || s.nenner  AS bu_ant,      -- als Excel-Formel (nur bei Wohnungsgrundbuch JOIN ÃŒber 'Recht an')
+    s.buchungsart,                                       -- verschlÃŒsselt
+  --b.bezeichner                         AS bu_art,      -- Buchungsart entschlÃŒsselt
+    wb.v                                 AS bu_art,      -- Buchungsart entschlÃŒsselt
+
+  -- N a m e n s N u m m e r  (Normalfall mit Person)
+    nn.laufendenummernachdin1421         AS nam_lfd, 
+    '=' || nn.zaehler|| '/' || nn.nenner AS nam_ant,         -- als Excel-Formel
+
+  -- R e c h t s g e m e i n s c h a f t  (Sonderfall von Namensnummer, ohne Person, ohne Nummer)
+  -- Aus Subquery rg
+    rg.artderrechtsgemeinschaft          AS nam_adr,
+    rg.v                                 AS nam_adrv,        -- Art der Rechtsgem. - Value zum Key
+    rg.beschriebderrechtsgemeinschaft    AS nam_bes,
+
+  -- P e r s o n
+    p.gml_id                             AS psgml,           -- mÃ¶glicher Filter Personen-GML-ID
+    p.anrede,                                                -- Anrede key
+    wp.v                                 AS anrv,            -- Anrede Value zum Key
+    p.vorname,
+    p.namensbestandteil,
+    p.nachnameoderfirma,                                     -- Familienname
+    p.geburtsdatum,
+    --p.geburtsname, p.akademischergrad 
+ 
+  -- A d r e s s e  der Person
+    a.postleitzahlpostzustellung         AS plz,
+    a.ort_post                           AS ort,             -- Anschreifenzeile 1: PLZ+Ort
+    a.strasse,  a.hausnummer,                                -- Anschriftenzeile 2: StraÃe+HsNr
+    a.bestimmungsland                    AS land
+
+  FROM ax_flurstueck    f               -- FlurstÃŒck
+  JOIN doppelverbindung d               -- beide FÃ€lle ÃŒber Union-View: direkt und ÃŒber Recht von Buchung an Buchung
+    ON d.fsgml = f.gml_id
+  JOIN ax_gemarkung g                   -- entschlÃŒsseln
+    ON f.land=g.land AND f.gemarkungsnummer=g.gemarkungsnummer 
+  JOIN ax_buchungsstelle s              -- Buchungs-Stelle
+    ON d.bsgml = s.gml_id
+  JOIN ax_buchungsblatt  gb             -- Buchung >istBestandteilVon> Grundbuchblatt
+    ON gb.gml_id = s.istbestandteilvon
+  JOIN ax_buchungsblattbezirk z 
+    ON gb.land=z.land AND gb.bezirk=z.bezirk 
+  JOIN ax_namensnummer nn               -- Blatt <istBestandteilVon< NamNum
+    ON gb.gml_id = nn.istbestandteilvon
+  JOIN ax_person p                      -- NamNum >benennt> Person 
+    ON p.gml_id = nn.benennt
+  LEFT JOIN ax_anschrift a 
+    ON a.gml_id = ANY (p.hat)
+  -- E n t s c h l ÃŒ s s e l n:
+  LEFT JOIN alkis_wertearten wp         -- EntschlÃŒsseln "Person - Anrede"
+    ON cast(p.anrede AS character varying)=wp.k AND wp.element='ax_person' AND wp.bezeichnung='anrede' 
+  LEFT JOIN alkis_wertearten wb         -- EntschlÃŒsseln "Buchungsart"
+    ON cast(s.buchungsart AS character varying)=wb.k AND wp.element='ax_buchungsstelle' AND wp.bezeichnung='buchungsart' 
+
+  -- 2mal "LEFT JOIN" verdoppelt die Zeile in der Ausgabe. Darum als Subquery in Spalten packen:
+  -- Noch mal "GB -> NamNum", aber dieses Mal fÃŒr "Rechtsgemeinschaft".
+  -- Kommt max. 1 mal je GB vor und hat keine Relation auf Person.
+  LEFT JOIN
+   ( SELECT gr.gml_id, r.artderrechtsgemeinschaft, r.beschriebderrechtsgemeinschaft, wr.v
+       FROM ax_namensnummer r 
+       JOIN ax_buchungsblatt gr
+         ON r.istbestandteilvon = gr.gml_id -- Blatt <istBestandteilVon< NamNum (Rechtsgemeinschaft) 
+      LEFT JOIN alkis_wertearten wr
+        ON cast(r.artderrechtsgemeinschaft AS character varying)=wr.k AND wr.element='ax_namensnummer' AND wr.bezeichnung='artderrechtsgemeinschaft' 
+      WHERE NOT r.artderrechtsgemeinschaft IS NULL ) AS rg -- Rechtsgemeinschaft
+   ON rg.gml_id = gb.gml_id  -- zum GB
+
+  WHERE f.endet IS NULL AND s.endet IS NULL and gb.endet IS NULL and nn.endet IS NULL AND p.endet IS NULL
+
+  ORDER BY f.flurstueckskennzeichen, 
+           gb.bezirk, gb.buchungsblattnummermitbuchstabenerweiterung, s.laufendenummer,
+           nn.laufendenummernachdin1421;
+
+COMMENT ON VIEW exp_csv 
+ IS 'View fÃŒr einen CSV-Export aus der Buchauskunft mit alkisexport.php. Generelle Struktur. FÃŒr eine bestimmte gml_id noch den Filter setzen.';
+
+
+-- Variante des View "exp_csv":
+-- Hier wird zusÃ€tzlich der Baustein "flst_an_strasse" verwendet.
+-- Der Filter "WHERE stgml= " auf die "gml_id" von "ax_lagebezeichnungkatalogeintrag" sollte gesetzt werden
+-- um alle FlurstÃŒcke zu bekommen, die an einer StraÃe liegen.
+
+
+DROP VIEW IF EXISTS exp_csv_str;
+
+CREATE OR REPLACE VIEW exp_csv_str
+AS
+ SELECT
+    l.stgml,                                             -- Filter: gml_id aus "ax_lagebezeichnungkatalogeintrag"
+                                                         -- UNTERSCHIED zu exp_csv)
+  -- F l u r s t ÃŒ c k
+    f.gml_id                             AS fsgml,       -- Gruppenwechsel fÃŒr "function lage_zum_fs" in alkisexport.php
+    f.flurstueckskennzeichen             AS fs_kennz,
+    f.gemarkungsnummer,                                  -- Teile des FS-Kennz. noch mal einzeln
+    f.flurnummer, f.zaehler, f.nenner, 
+    f.amtlicheflaeche                    AS fs_flae,
+    g.bezeichnung                        AS gemarkung,
+
+  -- G r u n d b u c h
+  --gb.gml_id                            AS gbgml,       -- mÃ¶glicher Filter Grundbuch-GML-ID
+    gb.bezirk                            AS gb_bezirk,
+    gb.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt,
+    z.bezeichnung                        AS beznam,      -- GB-Bezirks-Name
+
+  -- B u c h u n g s s t e l l e  (GrundstÃŒck)
+    s.laufendenummer                     AS bu_lfd,      -- BVNR
+  --s.zaehler, s.nenner,                                 -- Anteil des GB am FS, einzelne Felder
+    '=' || s.zaehler || '/' || s.nenner  AS bu_ant,      -- als Excel-Formel (nur bei Wohnungsgrundbuch JOIN ÃŒber 'Recht an')
+    s.buchungsart,                                       -- verschlÃŒsselt
+    wb.v                                 AS bu_art,      -- Buchungsart entschlÃŒsselt
+
+  -- N a m e n s N u m m e r (Normalfall mit Person)
+    nn.laufendenummernachdin1421         AS nam_lfd, 
+    '=' || nn.zaehler|| '/' || nn.nenner AS nam_ant,         -- als Excel-Formel
+
+  -- R e c h t s g e m e i n s c h a f t  (Sonderfall von Namensnummer, ohne Person, ohne Nummer)
+  -- Aus Subquery rg
+    rg.artderrechtsgemeinschaft          AS nam_adr,
+    rg.v                                 AS nam_adrv,        -- Art der Rechtsgem. - Value zum Key
+    rg.beschriebderrechtsgemeinschaft    AS nam_bes,
+
+  -- P e r s o n
+  --p.gml_id                             AS psgml,           -- mÃ¶glicher Filter Personen-GML-ID
+    p.anrede,                                                -- Anrede key
+    wp.v                                 AS anrv,            -- Anrede Value zum Key
+    p.vorname,
+    p.namensbestandteil,
+    p.nachnameoderfirma,                                     -- Familienname
+    p.geburtsdatum,
+    --p.geburtsname, p.akademischergrad 
+ 
+  -- A d r e s s e  der Person
+    a.postleitzahlpostzustellung         AS plz,
+    a.ort_post                           AS ort,             -- Anschreifenzeile 1: PLZ+Ort
+    a.strasse,  a.hausnummer,                                -- Anschriftenzeile 2: StraÃe+HsNr
+    a.bestimmungsland                    AS land
+
+  FROM ax_flurstueck    f               -- FlurstÃŒck
+  JOIN flst_an_strasse  l               -- Lage (hier zusÃ€tzlicher JOIN gegenÃŒber Version "exp_csv") 
+	ON l.fsgml = f.gml_id 
+  JOIN doppelverbindung d               -- beide FÃ€lle ÃŒber Union-View: direkt und ÃŒber Recht von Buchung an Buchung
+    ON d.fsgml = f.gml_id 
+  JOIN ax_gemarkung g                   -- entschlÃŒsseln
+    ON f.land=g.land AND f.gemarkungsnummer=g.gemarkungsnummer 
+  JOIN ax_buchungsstelle s              -- Buchungs-Stelle
+    ON d.bsgml = s.gml_id 
+  JOIN ax_buchungsblatt  gb             -- Buchung >istBestandteilVon> Grundbuchblatt
+    ON gb.gml_id = s.istbestandteilvon
+  JOIN ax_buchungsblattbezirk z 
+    ON gb.land=z.land AND gb.bezirk=z.bezirk 
+  JOIN ax_namensnummer nn               -- Blatt <istBestandteilVon< NamNum
+    ON gb.gml_id = nn.istbestandteilvon
+  JOIN ax_person p                      -- NamNum >benennt> Person 
+    ON p.gml_id = nn.benennt
+  LEFT JOIN ax_anschrift a 
+    ON a.gml_id = ANY (p.hat)
+  -- E n t s c h l ÃŒ s s e l n:
+  LEFT JOIN alkis_wertearten wp         -- EntschlÃŒsseln "Person - Anrede"
+    ON cast(p.anrede AS character varying)=wp.k AND wp.element='ax_person' AND wp.bezeichnung='anrede' 
+  LEFT JOIN alkis_wertearten wb         -- EntschlÃŒsseln "Buchungsart"
+    ON cast(s.buchungsart AS character varying)=wb.k AND wp.element='ax_buchungsstelle' AND wp.bezeichnung='buchungsart' 
+
+  -- 2mal "LEFT JOIN" verdoppelt die Zeile in der Ausgabe. Darum als Subquery in Spalten packen:
+  -- Noch mal "GB -> NamNum", aber dieses Mal fÃŒr "Rechtsgemeinschaft".
+  -- Kommt max. 1 mal je GB vor und hat keine Relation auf Person.
+  LEFT JOIN
+   ( SELECT gr.gml_id, r.artderrechtsgemeinschaft, r.beschriebderrechtsgemeinschaft, wr.v
+       FROM ax_namensnummer r 
+       JOIN ax_buchungsblatt gr
+         ON r.istbestandteilvon = gr.gml_id -- Blatt <istBestandteilVon< NamNum (Rechtsgemeinschaft) 
+      LEFT JOIN alkis_wertearten wr
+        ON cast(r.artderrechtsgemeinschaft AS character varying)=wr.k AND wr.element='ax_namensnummer' AND wr.bezeichnung='artderrechtsgemeinschaft' 
+      WHERE NOT r.artderrechtsgemeinschaft IS NULL ) AS rg  -- Rechtsgemeinschaft
+   ON rg.gml_id = gb.gml_id  -- zum GB
+
+  WHERE f.endet IS NULL AND s.endet IS NULL and gb.endet IS NULL and nn.endet IS NULL AND p.endet IS NULL
+
+  ORDER BY f.flurstueckskennzeichen, 
+           gb.bezirk, gb.buchungsblattnummermitbuchstabenerweiterung, s.laufendenummer,
+           nn.laufendenummernachdin1421;
+
+COMMENT ON VIEW exp_csv_str 
+ IS 'View fÃŒr einen CSV-Export aus der Buchauskunft mit alkisexport.php. Liefert nur FlurstÃŒcke, die eine Lagebezeichnung MIT/OHNE Hausnummer haben. Dazu noch den Filter auf GML-ID der StraÃentabelle setzen.';
+
+
+-- B e r e c h t i g u n g e n
+-- ============================
+-- Analog "grant.sql"
+-- Die ALKIS-Navigation fÃŒr Mapbender 2.7 und die Buchauskunft verwendet den DB-User "mb27"
+
+-- Tabellen der ALKIS-Struktur
+-- -----------------------------------------------------------------------
+
+  GRANT SELECT ON TABLE public.ap_pto TO mb27;
+
+  GRANT SELECT ON TABLE public.ax_anschrift TO mb27;
+  GRANT SELECT ON TABLE public.ax_bauraumoderbodenordnungsrecht TO mb27;
+  GRANT SELECT ON TABLE public.ax_besondereflurstuecksgrenze TO mb27;
+  GRANT SELECT ON TABLE public.ax_buchungsblatt TO mb27;
+  GRANT SELECT ON TABLE public.ax_buchungsblattbezirk TO mb27;
+  GRANT SELECT ON TABLE public.ax_buchungsstelle TO mb27;
+  GRANT SELECT ON TABLE public.ax_bundesland TO mb27;
+  GRANT SELECT ON TABLE public.ax_dienststelle TO mb27;
+  GRANT SELECT ON TABLE public.ax_flurstueck TO mb27;
+  GRANT SELECT ON TABLE public.ax_gebaeude TO mb27;
+  GRANT SELECT ON TABLE public.ax_gemarkung TO mb27;
+  GRANT SELECT ON TABLE public.ax_gemarkungsteilflur TO mb27;
+  GRANT SELECT ON TABLE public.ax_gemeinde TO mb27;
+  GRANT SELECT ON TABLE public.ax_historischesflurstueck TO mb27;
+  GRANT SELECT ON TABLE public.ax_historischesflurstueckohneraumbezug TO mb27;
+  GRANT SELECT ON TABLE public.ax_kreisregion TO mb27;
+  GRANT SELECT ON TABLE public.ax_lagebezeichnungkatalogeintrag TO mb27;
+  GRANT SELECT ON TABLE public.ax_lagebezeichnungmithausnummer TO mb27;
+  GRANT SELECT ON TABLE public.ax_lagebezeichnungmitpseudonummer TO mb27;
+  GRANT SELECT ON TABLE public.ax_lagebezeichnungohnehausnummer TO mb27;
+  GRANT SELECT ON TABLE public.ax_namensnummer TO mb27;
+  GRANT SELECT ON TABLE public.ax_person TO mb27;
+  GRANT SELECT ON TABLE public.ax_regierungsbezirk TO mb27;
+
+-- Tabellen der norGIS-Metadaten (Ersatz fÃŒr SchlÃŒssel-Tabellen )
+-- -----------------------------------------------------------------------
+  GRANT SELECT ON TABLE public.alkis_elemente TO mb27;
+  GRANT SELECT ON TABLE public.alkis_wertearten TO mb27;
+
+-- Tabellen des norGIS-PostProcessing  (Ersatz Classic-Post-Processing)
+-- -----------------------------------------------------------------------
+  -- Dies muss nach einer Datenbank-Aktualisierung neu berechtigt werden
+  GRANT SELECT ON TABLE public.gem_shl TO mb27;
+  GRANT SELECT ON TABLE public.gema_shl TO mb27;
+  GRANT SELECT ON TABLE public.nutz_21 TO mb27;
+  GRANT SELECT ON TABLE public.nutz_shl TO mb27;
+
+-- Berechtigung fuer Views
+-- -----------------------------------------------------------------------
+
+  -- Bausteine fÃŒr andere Views
+  GRANT SELECT ON TABLE public.doppelverbindung TO mb27;
+  GRANT SELECT ON TABLE public.flst_an_strasse TO mb27;
+
+  -- alkis_export als CSV
+  GRANT SELECT ON TABLE public.exp_csv TO mb27;
+  GRANT SELECT ON TABLE public.exp_csv_str TO mb27;
+
+-- Ende --
