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