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/alkissw*gkz*.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 

# Stand:
#  2016-05-19 generiert, angepasst und optimiert
#  2016-05-20 Legende unterdrücken
#  2016-05-23 Flurstücke: 2stufige Gruppierung raus. 
#             Beschriftung: links-/rechtsbündig vertauscht.

# ToDo: 
# - 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/ 
#
## 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

### Layer-Reihenfolge
##			*/ Flächen + Grenzen
# -fh Friedhöfe / Flächen
# gh Friedhöfe / Grenzen
# fe Vegetation / Flächen
# fb Wohnbauflächen / Flächen
# gt Topographie / Grenzen
# ge Vegetation / 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
# 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
# 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 / lfd. Nr. Nebengebäude
# 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 "alkissw"
	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 "symbolssw.sym" # ausgelagert, ursprünglich hier inline generiert
	FONTSET "/opt/gdi/alkisn/fonts/fonts.txt"
	UNITS METERS
	WEB
		METADATA
			wms_title "ALKIS sw"
			wms_abstract "ALKIS Schwarz/Weiß-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 20. 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/alkissw*gkz*.map"
			# Die Position von "GKZ" im Mapfile-Namen muss 3stellig sein, am Ende vor ".map".
			# GKZ wird vom Template über den [map] ausgelesen um die richtige DB der Auskunft zu finden.
			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"

			# theoretish ausreichend:
		#	wms_enable_request "GetCapabilities GetMap" # Rest je Layer individuell addieren

			# praktisch notwendig:
			wms_enable_request "*"

			include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt
		END
	END

	LEGEND
		STATUS ON
		KEYSIZE 32 16
		KEYSPACING 5 5
		LABEL
			TYPE TRUETYPE
			FONT 'arial'
			SIZE 11
			COLOR 1 1 1
		END
	END

	## Layer der Typen Flächen + Grenzen

	LAYER NAME "gh" # FriedHöfe / Grenzen
		CLASSITEM "signaturnummer"
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		#ATA "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"
		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
		# Filter Signaturnummer 37 : 0
		#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"
			#wms_enable_request "GetLegendGraphic"
		END
		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 NAME "fe" # VEgetation / Flächen
		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"
		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='Wohnbauflächen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
		# Filter Signaturnummer 2200 : 0
		#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
		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 NAME "fb"	# WohnBauflächen / Flächen
		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"
		# 150: 1091 Sätze ohne Filter
		# Filter auf die einzig dargestellte Signaturnummer:
		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer = '1523' AND thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
		# 150: Nur 13 Sätze MIT Filter
		#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"
			wms_enable_request "GetLegendGraphic"
		END
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS INCHES
		STATUS OFF
		SYMBOLSCALEDENOM 1000
		TYPE POLYGON
		UNITS METERS
		CLASS
		#	NAME "(1523)"
			EXPRESSION "1523" # dies in DATA filtern
			STYLE
				COLOR 255 255 255
			END
		END
		# Signaturnummern 1548, 1550, 1551, ...
	END

	LAYER NAME "gt"	# Topographie / Grenzen
		CLASSITEM "signaturnummer"
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		#ATA "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"
		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = 'rn1551' AND thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
		# Filter "signaturnummer = 'rn1551' AND"  6:0
		#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
		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 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "ge"	# VEgetation / Grenzen
		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
		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 "Wald"
			EXPRESSION "2517"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "(rn1560)"
			EXPRESSION "rn1560"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "(rn1561)"
			EXPRESSION "rn1561"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "(rn1563)"
			EXPRESSION "rn1563"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "gs" # Sport und Freizeit / Grenzen
		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
		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 153 153 153
				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 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "[1524]"
			EXPRESSION "rn1524"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#- 	NAME "Schwimmbecken"
			EXPRESSION "rn1526"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#- 	NAME "Rennbahn, Laufbahn, Geläuf"
			EXPRESSION "rn1521"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "gw"	# Gewässer / Grenzen
		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
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS METERS
		STATUS OFF
		TYPE POLYGON
		UNITS METERS
		CLASS
		#	NAME "(2520)"
			EXPRESSION "2520"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				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 153 153 153
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "(rn1523)"
			EXPRESSION "rn1523"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				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 "(rn1551)"
			EXPRESSION "rn1551"
			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 153 153 153
				PATTERN 0.35 0.35 END
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "fi" # Industrie und Gewerbe / Flächen
		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 100000 # 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"
			wms_enable_request "GetLegendGraphic"
		END
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS INCHES
		STATUS OFF
		SYMBOLSCALEDENOM 1000
		TYPE POLYGON
		UNITS METERS
		CLASS
		#	NAME "[1403]"
			EXPRESSION "1403"
			STYLE
				COLOR 237 237 237
			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 NAME "gi" # Industrie und Gewerbe / Grenzen
		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
		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 153 153 153
				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 "(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 "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 "[rn1305]"
			EXPRESSION "rn1305"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 0 0 0
				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 "Mast"
			EXPRESSION "rn1306"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 0 0 0
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "fv" # Verkehr / Flächen
		CLASSITEM "signaturnummer"
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		#ATA "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"
		DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer IN ('1542','1530') AND thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
		# Filter "signaturnummer IN ('1542','1530') AND" 1687:149
		#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"
			wms_enable_request "GetLegendGraphic"
		END
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS INCHES
		STATUS OFF
		SYMBOLSCALEDENOM 1000
		TYPE POLYGON
		UNITS METERS
		CLASS
			NAME "Weg"
			EXPRESSION "1542"
			STYLE
				COLOR 255 255 255
			END
		END
		CLASS
			NAME "Brücke, Hochbahn/-straße"
			EXPRESSION "1530"
			STYLE
				COLOR 255 255 255
			END
		END
	END

	LAYER NAME "gv" # Verkehr / Grenzen
		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
		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 153 153 153
				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 "(rn1536)"
			EXPRESSION "rn1536"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 127 127 127
				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 NAME "fg" # Gebäude / Flächen
		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"
			wms_enable_request "GetLegendGraphic"
		END
		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 102 102 102
			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 204 204 204
			END
		END
	END

	LAYER NAME "gg" # Gebäude / Grenzen
		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
		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 "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 "(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 "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 "(rn2510)"
			EXPRESSION "rn2510"
			STYLE
				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 "(rn1305)"
			EXPRESSION "rn1305"
			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 "(2507)"
			EXPRESSION "2507"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 0 0 0
				SIZE 0.18
				WIDTH 0.18
			END
		END
		CLASS
		#	NAME "(rn1525)"
			EXPRESSION "rn1525"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 0 0 0
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "gr" # Rechtliche Festlegungen / Grenzen
		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"
			wms_enable_request "GetFeatureInfo !GetLegendGraphic"
		END
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS METERS
		STATUS OFF
		TYPE POLYGON
		UNITS METERS

		TOLERANCEUNITS pixels TOLERANCE 1
		HEADER   "/opt/gdi/alkisn/templates/alkisrechtbauh.html"
		TEMPLATE "/opt/gdi/alkisn/templates/alkisrechtbau.html"
		FOOTER   "/opt/gdi/alkisn/templates/footer.html"

		CLASS
		#- 	NAME "Bau-, Raum-, Bodenordnungsrecht"
			EXPRESSION "rn1704"
			STYLE
				LINECAP SQUARE
				LINEJOIN ROUND
				OUTLINECOLOR 153 153 153
				PATTERN 4.00 1.00 END
				SIZE 1
			END
		END
	END

	LAYER NAME "gff" # Flurstücke / Flächen / Grenzen
		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"

		#ATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2028' AND 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"
		# Filter signaturnummer = '2028' sinnvoll?: Nein keine Reduzierung de Menge

		#EXTENT ...
		MAXSCALEDENOM 12000 # 5000
		METADATA
			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
		#	wms_layer_group	"/Flurstücke/Flächen"
			wms_layer_group	"/Flurstücke"
			wms_title "Grenzen"
			wms_enable_request "GetFeatureInfo"
			# Auch wenn 'wms_enable_request "GetLegendGraphic"' weggelassen wird,
			# ist in den Capabilities noch eine "LegendURL" enthalten.
		END
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS METERS
		STATUS OFF

		HEADER   "/opt/gdi/alkisn/templates/alkisauskh.html" 
		TEMPLATE "/opt/gdi/alkisn/templates/alkisausk.html" # gkz aus Mapfile-Name!
		FOOTER   "/opt/gdi/alkisn/templates/footer.html"
		TOLERANCEUNITS pixels 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
			#	OUTLINEWIDTH 0.35 # NEIN! etwa doppelt so dick wie WIDTH
			END
		END
	END

	## Layer des Typs Linien

	LAYER NAME "lt" # Topographie / Linien
		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
		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 153 153 153
				LINECAP SQUARE
				LINEJOIN ROUND
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "lw" # Gewässer / Linien
		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
		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 153 153 153
				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 153 153 153
				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 153 153 153
				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 153 153 153
				LINECAP SQUARE
				LINEJOIN ROUND
				PATTERN 0.35 0.35 END
				SIZE 0.18
				WIDTH 0.18
			END
		END
	END

	LAYER NAME "lv" # Verkehr / Linien 
		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
		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 153 153 153
				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 NAME "li" # Industrie und Gewerbe / Linien
		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
		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 NAME "lg" # Gebäude / Linien
		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
		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 NAME "lp" # Politische Grenzen / Linien
		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
		PROCESSING "CLOSE_CONNECTION=DEFER"
		PROJECTION "init=epsg:25832" END
		SIZEUNITS METERS
		STATUS OFF
		TYPE LINE
		UNITS METERS
		# Bemerkung: Die folgenden 3 Classes wurden aus QGIS doppelt generiert
		CLASS
		#- 	NAME "Flurgrenze"
			EXPRESSION "2012"
			STYLE # Grundierung
				COLOR 255 255 255
			#	OPACITY 0
				WIDTH 1.01
			END
			STYLE # eckige Enden
				COLOR 102 102 102
				LINECAP SQUARE
				LINEJOIN ROUND
				PATTERN 5.00 11.00 END
				SIZE 1
			END
			STYLE # 0+ROUND macht Punkte
				COLOR 102 102 102
				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 102 102 102
				LINECAP SQUARE
				LINEJOIN ROUND
				PATTERN 5.00 8.00 END
				SIZE 1
			END
			STYLE
				COLOR 102 102 102
				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 102 102 102
				LINECAP SQUARE
				LINEJOIN ROUND
				PATTERN 5.00 5.00 END
				SIZE 1
			END
			STYLE
				COLOR 102 102 102
				INITIALGAP 7.5
				LINEJOIN ROUND
				PATTERN 0.00 10.00 END
				SIZE 1
			END
		END
	END

	LAYER NAME "lfn" # Flurstücke / Nummern / Linien
		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
		REQUIRES "[bfn]" # Zuordnungspfeile nur zusammen mit den Flurstücksnummern
		METADATA
			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
		#	wms_layer_group	"/Flurstücke/Nummern"
		#	wms_title "Linien"
			wms_layer_group	"/Flurstücke"
			wms_title "Zuordnung"
		END
		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 NAME "lff" # Flurstücke / Flächen / Linien
		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_layer_group	"/Flurstücke"
			wms_title "Linien"
		END
		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 NAME "pff" # Flurstücke / Flächen / Punkte
		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_layer_group	"/Flurstücke"
			wms_title "Punkte"
		END
		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
			#	OFFSET 0 0
				SIZE 1.6995
				SYMBOL "norGIS_alkis3020_2"
			END
		END
		CLASS
		#- 	NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"
			EXPRESSION "3022"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.6995
				SYMBOL "norGIS_alkis3022_2"
			END
		END
		CLASS
		#- 	NAME "Flurstücksüberhaken"
			EXPRESSION "3010"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 1
				SIZE 2.2509
				SYMBOL "norGIS_alkis3010_2"
			END
		END
	END

	LAYER NAME "pg" # Gebäude / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 4.056
				SYMBOL "norGIS_alkis3539_2"
			END
		END
		CLASS
		#	NAME "(3527)"
			EXPRESSION "3527"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0 0 0
				SIZE 3.8294
				SYMBOL "norGIS_alkis3527_2"
			END
		END
		CLASS
		#- 	NAME "Umformer"
			EXPRESSION "3521"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0 0 0
				SIZE 3.6935
				SYMBOL "norGIS_alkis3521_2"
			END
		END
		CLASS
		#- 	NAME "Spielcasino"
			EXPRESSION "3308"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.1437
				SYMBOL "norGIS_alkis3308_2"
			END
		END
		CLASS
		#- 	NAME "Post"
			EXPRESSION "3312"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3312_2"
			END
		END
		CLASS
		#- 	NAME "Hallenbad"
			EXPRESSION "3334"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 6.2313
				SYMBOL "norGIS_alkis3334_2"
			END
		END
		CLASS
		#- 	NAME "Kapelle"
			EXPRESSION "3318"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.0137
				SYMBOL "norGIS_alkis3318_2"
			END
		END
		CLASS
		#- 	NAME "Kirche"
			EXPRESSION "3316"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 10.0381
				SYMBOL "norGIS_alkis3316_2"
			END
		END
		CLASS
		#- 	NAME "Feuerwehr"
			EXPRESSION "3326"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3326_2"
			END
		END
		CLASS
		#- 	NAME "Kindergarten"
			EXPRESSION "3323"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 6.2313
				SYMBOL "norGIS_alkis3323_2"
			END
		END
		CLASS
		#- 	NAME "Toilette"
			EXPRESSION "3311"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3311_2"
			END
		END
		CLASS
		#- 	NAME "Kino"
			EXPRESSION "3306"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3306_2"
			END
		END
		CLASS
		#- 	NAME "Tiefgarage"
			EXPRESSION "3336"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 6.5712
				SYMBOL "norGIS_alkis3336_2"
			END
		END
		CLASS
		#- 	NAME "Bank"
			EXPRESSION "3300"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.189
				SYMBOL "norGIS_alkis3300_2"
			END
		END
		CLASS
		#- 	NAME "Brunnen / Gasquelle, Mofette / Heilquelle"
			EXPRESSION "3529"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 2.6965
				SYMBOL "norGIS_alkis3529_2"
			END
		END
		CLASS
		#- 	NAME "Hotel"
			EXPRESSION "3302"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3302_2"
			END
		END
		CLASS
		#- 	NAME "Gaststätte"
			EXPRESSION "3305"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3305_2"
			END
		END
		CLASS
		#- 	NAME "Meilenstein, historischer Grenzstein"
			EXPRESSION "3536"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 1
				SIZE 2.8688
				SYMBOL "norGIS_alkis3536_2"
			END
		END
		CLASS
		#- 	NAME "Polizei"
			EXPRESSION "3324"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.0077
				SYMBOL "norGIS_alkis3324_2"
			END
		END
		CLASS
		#- 	NAME "Denkmal"
			EXPRESSION "3532"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 2
				SIZE 4.866
				SYMBOL "norGIS_alkis3532_2"
			END
		END
	END

	LAYER NAME "pv" # Verkehr / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 5.3703
				SYMBOL "norGIS_alkis3430_2"
			END
		END
		CLASS
		#- 	NAME "Fußweg"
			EXPRESSION "3424"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.3703
				SYMBOL "norGIS_alkis3424_2"
			END
		END
		CLASS
		#- 	NAME "Haltepunkt"
			EXPRESSION "3578"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.1949
				SYMBOL "norGIS_alkis3578_2"
			END
		END
		CLASS
		#- 	NAME "Parkplatz"
			EXPRESSION "3432"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.4836
				SYMBOL "norGIS_alkis3432_2"
			END
		END
		CLASS
		#- 	NAME "Radweg"
			EXPRESSION "3426"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.3703
				SYMBOL "norGIS_alkis3426_2"
			END
		END
		CLASS
		#- 	NAME "Rad- und Fußweg"
			EXPRESSION "3428"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.3703
				SYMBOL "norGIS_alkis3428_2"
			END
		END
	END

	LAYER NAME "pe" # VEgetation / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 4.192
				SYMBOL "norGIS_alkis3446_2"
			END
		END
		CLASS
		#- 	NAME "Sumpf"
			EXPRESSION "3478"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.065
				SYMBOL "norGIS_alkis3478_2"
			END
		END
		CLASS
		#- 	NAME "Garten"
			EXPRESSION "3421"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.8127
				SYMBOL "norGIS_alkis3421_2"
			END
		END
		CLASS
		#- 	NAME "Streuobstacker"
			EXPRESSION "3440"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.192
				SYMBOL "norGIS_alkis3440_2"
			END
		END
		CLASS
		#- 	NAME "Quelle"
			EXPRESSION "3613"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.0197
				SYMBOL "norGIS_alkis3613_2"
			END
		END
		CLASS
		#- 	NAME "Nadelbaum"
			EXPRESSION "3597"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 2
				SIZE 4.8638
				SYMBOL "norGIS_alkis3597_2"
			END
		END
		CLASS
		#- 	NAME "Obstbaumplantage"
			EXPRESSION "3452"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.192
				SYMBOL "norGIS_alkis3452_2"
			END
		END
		CLASS
		#- 	NAME "Nadelwald"
			EXPRESSION "3460"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.8491
				SYMBOL "norGIS_alkis3460_2"
			END
		END
		CLASS
		#- 	NAME "Unland"
			EXPRESSION "3480"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.0107
				SYMBOL "norGIS_alkis3480_2"
			END
		END
		CLASS
		#- 	NAME "Mischwald"
			EXPRESSION "3462"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.3703
				SYMBOL "norGIS_alkis3462_2"
			END
		END
		CLASS
		#- 	NAME "Gras"
			EXPRESSION "3413"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 0.4305
				SYMBOL "norGIS_alkis3413_2"
			END
		END
		CLASS
		#- 	NAME "Zierfläche"
			EXPRESSION "3605"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 2.4245
				SYMBOL "norGIS_alkis3605_2"
			END
		END
		CLASS
		#- 	NAME "Streuobstwiese"
			EXPRESSION "3441"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.192
				SYMBOL "norGIS_alkis3441_2"
			END
		END
		CLASS
		#- 	NAME "Laubwald"
			EXPRESSION "3458"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.3763
				SYMBOL "norGIS_alkis3458_2"
			END
		END
		CLASS
		#- 	NAME "Laubbaum"
			EXPRESSION "3599"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 2
				SIZE 4.567
				SYMBOL "norGIS_alkis3599_2"
			END
		END
		CLASS
		#- 	NAME "Heide"
			EXPRESSION "3474"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.9261
				SYMBOL "norGIS_alkis3474_2"
			END
		END
		CLASS
		#- 	NAME "Mischwald"
			EXPRESSION "3470"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.8718
				SYMBOL "norGIS_alkis3470_2"
			END
		END
		CLASS
		#- 	NAME "Busch, Hecke, Knick"
			EXPRESSION "3601"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.4275
				SYMBOL "norGIS_alkis3601_2"
			END
		END
	END

	LAYER NAME "pw"	# GeWässer / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 1.2236
				SYMBOL "norGIS_alkis3619_2"
			END
		END
		CLASS
		#- 	NAME "Fließgewässer"
			EXPRESSION "3488"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.2236
				SYMBOL "norGIS_alkis3488_2"
			END
		END
		CLASS
		#- 	NAME "Gewässer"
			EXPRESSION "3490"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.3369
				SYMBOL "norGIS_alkis3490_2"
			END
		END
		CLASS
		#- 	NAME "Quelle"
			EXPRESSION "3613"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.0197
				SYMBOL "norGIS_alkis3613_2"
			END
		END
		CLASS
		#	NAME "(3596)"
			EXPRESSION "3596"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 1
				SIZE 3.6936
				SYMBOL "norGIS_alkis3596_2"
			END
		END
		CLASS
		#- 	NAME "Fließgewässer, nicht ständig Wasser führend"
			EXPRESSION "3621"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.2236
				SYMBOL "norGIS_alkis3621_2"
			END
		END
	END

	LAYER NAME "pi" # Industrie und Gewerbe / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 5.2343
				SYMBOL "norGIS_alkis3401_2"
			END
		END
		CLASS
		#- 	NAME "Umformer"
			EXPRESSION "3521"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.6935
				SYMBOL "norGIS_alkis3521_2"
			END
		END
		CLASS
		#- 	NAME "Antenne / Funkmast"
			EXPRESSION "3506"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 2
				SIZE 5.2585
				SYMBOL "norGIS_alkis3506_2"
			END
		END
		CLASS
		#- 	NAME "Vorratsbehälter"
			EXPRESSION "3522"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.1949
				SYMBOL "norGIS_alkis3522_2"
			END
		END
		CLASS
		#- 	NAME "Schornstein, Schlot, Esse"
			EXPRESSION "3508"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 3.3763
				SYMBOL "norGIS_alkis3508_2"
			END
		END
		CLASS
		#- 	NAME "Mast"
			EXPRESSION "3504"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 2.1979
				SYMBOL "norGIS_alkis3504_2"
			END
		END
		CLASS
		#- 	NAME "Windrad"
			EXPRESSION "3501"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 3
				SIZE 6.8565
				SYMBOL "norGIS_alkis3501_2"
			END
		END
		CLASS
		#- 	NAME "Laufkran, Brückenlaufkran"
			EXPRESSION "3514"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
				OFFSET 0 2
				SIZE 5.235
				SYMBOL "norGIS_alkis3514_2"
			END
		END
		CLASS
		#- 	NAME "Torf"
			EXPRESSION "3407"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 4.5092
				SYMBOL "norGIS_alkis3407_2"
			END
		END
	END

	LAYER NAME "ps" # Sport und Freizeit / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 7.3643
				SYMBOL "norGIS_alkis3423_2"
			END
		END
		CLASS
		#- 	NAME "Kleingarten"
			EXPRESSION "3419"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 6.4126
				SYMBOL "norGIS_alkis3419_2"
			END
		END
		CLASS
		#- 	NAME "Garten"
			EXPRESSION "3421"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.8127
				SYMBOL "norGIS_alkis3421_2"
			END
		END
		CLASS
		#- 	NAME "Rasen"
			EXPRESSION "3413"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 0.4305
				SYMBOL "norGIS_alkis3413_2"
			END
		END
		CLASS
		#- 	NAME "Park"
			EXPRESSION "3415"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 5.6648
				SYMBOL "norGIS_alkis3415_2"
			END
		END
		CLASS
		#- 	NAME "Campingplatz"
			EXPRESSION "3412"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 7.7268
				SYMBOL "norGIS_alkis3412_2"
			END
		END
	END

	LAYER NAME "pt"	# Topographie / Punkte
		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
		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
			#	OFFSET 0 0
				SIZE 5.3476
				SYMBOL "norGIS_alkis3627_2"
			END
		END
		CLASS
		#- 	NAME "Busch, Hecke, Knick"
			EXPRESSION "3601"
			STYLE
				ANGLE [drehwinkel_grad]
				MINSIZE 1
			#	OFFSET 0 0
				SIZE 1.4275
				SYMBOL "norGIS_alkis3601_2"
			END
		END
	## Diese Class macht Stress !
	#	CLASS
	#	#- 	NAME "Busch, Hecke, Knick"
	#		EXPRESSION "3632"
	#		STYLE
	#			ANGLE [drehwinkel_grad]
	#			MINSIZE 1
	#			SIZE 2
	#			SYMBOL "norGIS_alkis3632_2"
	#		END
	##	END
	END

	## Layer des Typs  Beschriftungen

	LAYER NAME "bfn" # Flurstücke / Nummern / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 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 point IS NOT NULL 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_layer_group	"/Flurstücke"
		#	wms_title "Beschriftungen (Punkte)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bg" # Gebäude / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 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"
		#	wms_title "Beschriftungen (Punkte)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	# LAYER bg2 Gebäude / Laufende Hausnummern / Beschriftungen
	# * Nebengebäude-Nummer in Klammer, normalerweise aus
	# +++ nur Krs HF

	LAYER NAME "bl" # Lagebezeichnungen / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bv" # Verkehr / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bh" # FriedHöfe / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# Lins-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "be"	# Vegetation / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bw" # Gewässer / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bs" # Sport und Freizeit / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bb" # Wohnbauflächen / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# links-/rechtsbündig getauscht:
		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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Wohnbauflächen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER NAME "bt" # Topographie / Beschriftungen
		CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
		CONNECTIONTYPE POSTGIS
		# Hinweis: rechts-/linksbündig sind vertauscht wenn von QGIS generiert. Und "Not Null" ist doppelt.
		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=2 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)"
			wms_title "Beschriftungen"
		END
		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
			#	OFFSET 0 0
				OUTLINECOLOR 255 255 255
				POSITION [position_umn]
				PRIORITY 10
			#	SHADOWSIZE 0 0
				TYPE TRUETYPE
			END
		END
	END

	LAYER
		NAME "copyright"
		STATUS ON # DEFAULT
		TYPE POINT
		TRANSFORM lr
		METADATA
			wms_title "Copyright"
			wms_abstract "In der Karte sichtbare Angabe auf die Herkunft der Daten"
			WMS_KEYWORDLIST "Katasteramt, Copyright, Quellenangabe"
			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
		END
		FEATURE
			POINTS 0 0 END
			# individuelle Vertragsnummer einsetzen
			TEXT 'Copyright Geobasisdaten Liegenschaftskataster Kreis __'
		END
		CLASS
			LABEL
				SIZE small
				POSITION ul
				COLOR 50 50 50
				FORCE TRUE
				STYLE
					GEOMTRANSFORM 'labelpoly'
					COLOR 250 250 250
				END
			END
		END
	END
END