# WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* für Mandant - Druckversion zur Entwickler-Version
# Änderungen: siehe Bildschirm-Version, letzte:
# 2014-08-25 F.J. krz  Straßennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra"
# 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel

MAP
	NAME "alkis"
	STATUS ON
	EXTENT 349000 5529000 356000 5533000
	PROJECTION "init=epsg:25832" END
	MAXSIZE 8400 # Druck
	SYMBOLSET "symbols/symbols_alkis.sym"
	FONTSET "fonts/fonts_alkis.fnt"	
	UNITS METERS
	WEB
		METADATA
			wms_title "ALKIS_"
			wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
			wms_encoding "UTF-8"
			wms_onlineresource "http://ows.krz.de/cgi-bin/mapserv6?map=/opt/gdi/alkis08/alkis08*gkz*a_4.map"
			ows_schema_location ".."
			wms_enable_request "getmap"
			wms_box_extended "true"
			#include "meta_contact.map"
		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
	NAME "nutzung_alle"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "alle Nutzungsarten"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 10000
	CLASSITEM nutz_id
	# ** Siedlung **
	CLASS
		EXPRESSION '1'
		NAME "Wohnbaufläche"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '2'
		NAME "Industrie- und Gewerbefläche"
		STYLE
			COLOR 237 237 237
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '3'
		NAME "Halde"
		STYLE
			COLOR 237 237 237
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '4'
		NAME "Bergbaubetrieb"
		STYLE
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '5'
		NAME "Tagebau Grube Steinbruch"
		STYLE
			COLOR 227 227 227
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '6'
		NAME "Fläche gemischter Nutzung"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '7'
		NAME "Fläche besonderer funktionaler Prägung"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '8'
		NAME "Sport-, Freizeit- und Erholungsfläche"
		STYLE
			COLOR 224 255 217
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '9'
		NAME "Friedhof"
		STYLE
			COLOR 201 228 201
			OUTLINECOLOR 153 153 153
		END
	END
	# ** Verkehr **  nutzung.class = ax_Strassenverkehr.function
	CLASS
		NAME "Fußgängerzone"
		EXPRESSION ('[nutz_id]' = '10' and '[class]' = '5130')
		STYLE
			COLOR 217 255 217
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Verkehrsbegleitfläche Straße"
		EXPRESSION ('[nutz_id]' = '10' and '[class]' = '2312')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Straßenentwässerungsanlage"
		EXPRESSION ('[nutz_id]' = '10' and '[class]' = '2313')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Gebäude- und Freifläche zu Verkehrsanlagen, Straße"
		EXPRESSION ('[nutz_id]' = '10' and '[class]' = '2311')
		STYLE
			COLOR 200 200 200
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '10'
		NAME "Straßenverkehr"
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '11'
		NAME "Weg"
		STYLE
			COLOR 250 250 250
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Fußgängerzone (Platz)"
		EXPRESSION ('[nutz_id]' = '12' and '[class]' = '5130')
		STYLE
			COLOR 217 247 217
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '12'
		NAME "Platz"
		STYLE
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '13'
		NAME "Bahnverkehr"
		STYLE
			COLOR 250 250 250
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '14'
		NAME "Flugverkehr"
		STYLE
			COLOR 221 236 197
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '15'
		NAME "Schiffsverkehr" 
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
	# ** Vegetation **
	#  AX_Landwirtschaft=16, class=vegetationsmerkmal
	CLASS
		NAME "Ackerland, Streuobstacker, Hopfen und Spargel"
		EXPRESSION ('[nutz_id]' = '16' and '[class]' < '1020')
		STYLE
			COLOR 255 247 191
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Grünland, Streuobstwiese, Gartenland, Baumschule, Weingarten, Obstplantage, Obstbaumplantage und Obststrauchplantage"
		EXPRESSION ('[nutz_id]' = '16' and '1019' < '[class]' AND '[class]' < '1199')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Brachland"
		EXPRESSION ('[nutz_id]' = '16 and '1199' < '[class]')
		STYLE
			COLOR 242 235 232
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '17'
		NAME "Wald"
		STYLE
			COLOR 251 255 251
			OUTLINECOLOR 0 255 0
		END
	END
	CLASS
		EXPRESSION '18'
		NAME "Gehölz"
		STYLE
			COLOR 187 222 201
			OUTLINECOLOR  153 153 153
		END
	END
	CLASS
		EXPRESSION '19'
		NAME "Heide"
		STYLE
			COLOR 230 215 207
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '20'
		NAME "Moor"
		STYLE
			COLOR 242 235 232
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '21'
		NAME "Sumpf"
		STYLE
			COLOR 230 215 207
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '22'
		NAME "Unland, vegetationslose Fläche"
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
	#CLASS
	#	EXPRESSION 23
	#	NAME "Vegetationsmerkmal" ????
	#	STYLE
	#		OUTLINECOLOR 0 255 0
	#	END
	#END
	# ** Gewässer **
	CLASS
		EXPRESSION '24'
		NAME "Fließgewässer"
		STYLE
			COLOR 190 233 250
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		EXPRESSION '25'
		NAME "Hafenbecken"
		STYLE
			COLOR 230 255 255
			OUTLINECOLOR 0 204 204
		END
	END
	CLASS
		EXPRESSION '26'
		NAME "stehendes Gewässer"
		STYLE
			COLOR 190 233 250
			OUTLINECOLOR 153 153 153
		END
	END
	# '27' = Meer
END
## ** Siedlung **
LAYER
	NAME "ax_wohnbauflaeche"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Wohnbaufläche"
		wms_group_title "Nutzung " # nur im ersten Layer der Gruppe
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Wohnbaufläche"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_industrieundgewerbeflaeche"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Industrie- und Gewerbefläche"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'funktion'
	CLASS
		NAME "Industrie- und Gewerbefläche"
		#EXPRESSION ('999' < '[funktion]')
		STYLE
			COLOR 237 237 237
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_halde"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Halde"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Halde"
		STYLE
			COLOR 237 237 237
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER 
	NAME "ax_bergbaubetrieb"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bergbaubetrieb"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Bergbaubetrieb"
		STYLE
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_tagebaugrubesteinbruch"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Tagebau, Grube, Steinbruch"
		#wms_abstract "Tagebau, Grube, Steinbruch"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Tagebau Grube Steinbruch"
		STYLE
			COLOR 227 227 227
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_flaechegemischternutzung"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Fläche gemischter Nutzung"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Fläche gemischter Nutzung"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_flaechebesondererfunktionalerpraegung"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Fläche besonderer funktionaler Prägung"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Fläche besonderer funktionaler Prägung"
		STYLE
			COLOR 255 235 245
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_sportfreizeitunderholungsflaeche"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Sport-, Freizeit- und Erholungsfläche"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'funktion'
	CLASS
		NAME "Sport-, Freizeit- und Erholungsfläche"
		STYLE
			COLOR 224 255 217
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_friedhof"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Friedhof"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 3750 #15000
	#CLASSITEM 'funktion'
	CLASS
		NAME "Friedhof"
		STYLE
			COLOR 201 228 201
			OUTLINECOLOR 153 153 153
		END
	END
END
## ** Verkehr **
LAYER
	NAME "ax_strassenverkehr"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Straßenverkehr"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'funktion'
	CLASS
		NAME "Fußgängerzone"
		EXPRESSION ('[funktion]' = '5130')
		STYLE
			COLOR 217 255 217
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Verkehrsbegleitfläche Straße"
		EXPRESSION ('[funktion]' < '2312')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Straßenentwässerungsanlage"
		EXPRESSION ('[funktion]' < '2313')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Gebäude- und Freifläche zu Verkehrsanlagen, Straße" #nicht im SK
		EXPRESSION ('[funktion]' = '2311')
		STYLE
			COLOR 200 200 200
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Straßenverkehr" #nicht im SK
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_weg"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Weg"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Weg" #sn2515
		STYLE
			COLOR 250 250 250
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_platz"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Platz"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'funktion'
	CLASS
		NAME "Fußgängerzone (Platz)"
		EXPRESSION ('[funktion]' = '5130')
		STYLE
			COLOR 217 247 217
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Platz"
		STYLE
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_bahnverkehr"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bahnverkehr"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	#CLASSITEM 'funktion'
	CLASS
		NAME "Bahnverkehr"
		STYLE
			COLOR 250 250 250
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_flugverkehr"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Flugverkehr"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	#CLASSITEM 'funktion'
	CLASS
		NAME "Flugverkehr"
		STYLE
			COLOR 221 236 197
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_schiffsverkehr"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Schiffsverkehr"
		#wms_abstract "'Schiffsverkehr' umfasst die baulich geprägte Fläche und die mit ihr in Zusammenhang stehende Freifläche, die ausschließlich oder vorwiegend dem Schiffsverkehr dient."
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Schiffsverkehr" # sn1544
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
END
## ** Vegetation **
LAYER
	NAME "ax_landwirtschaft"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Landwirtschaft"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'vegetationsmerkmal'
	CLASS
		NAME "Ackerland, Streuobstacker, Hopfen und Spargel"
		EXPRESSION ('[vegetationsmerkmal]' < '1020')
		STYLE
			COLOR 255 247 191
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Grünland, Streuobstwiese, Gartenland, Baumschule, Weingarten, Obstplantage, Obstbaumplantage und Obststrauchplantage"
		EXPRESSION ('1019' < '[vegetationsmerkmal]' AND '[vegetationsmerkmal]' < '1199')
		STYLE
			COLOR 235 255 212
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Brachland"
		EXPRESSION ('1199' < '[vegetationsmerkmal]')
		STYLE
			COLOR 242 235 232
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_wald"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Wald"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Wald"
		STYLE
			COLOR 251 255 251
			OUTLINECOLOR 0 255 0
		END
	END
END
LAYER
	NAME "ax_gehoelz"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Gehölz"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Gehoelz" #sn1414_sn2517
		STYLE
			COLOR 187 222 201
			OUTLINECOLOR  153 153 153
		END
	END
END
LAYER
	NAME "ax_heide"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Heide"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Heide"
		STYLE
			COLOR 230 215 207
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_moor"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Moor"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Moor"
		STYLE
			COLOR 242 235 232
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_sumpf"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Sumpf"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Sumpf"
		STYLE
			COLOR 230 215 207
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_unlandvegetationsloseflaeche"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Unland"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Unland, vegetationslose Fläche"
		STYLE
			COLOR 255 255 255
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_vegetationsmerkmal"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Vegetationsmerkmal"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Vegetationsmerkmal"
		STYLE
			OUTLINECOLOR 0 255 0
		END
	END
END
## ** Gewässer **
LAYER
	NAME "ax_fliessgewaesser"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Fließgewässer"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Fließgewässer"
		STYLE
			COLOR 190 233 250
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_hafenbecken"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Hafenbecken"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	CLASS
		NAME "Hafenbecken"
		STYLE
			COLOR 230 255 255
			OUTLINECOLOR 0 204 204
		END
	END
END
LAYER
	NAME "ax_stehendesgewaesser"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	REQUIRES "![nutzung_alle]"
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "stehendes Gewässer"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "stehendes Gewässer" #sn2515
		STYLE
			COLOR 190 233 250
			OUTLINECOLOR 153 153 153
		END
	END
END
# AX_Meer fehlt
# Besondere Angaben zum Gewässer
LAYER
	NAME "ax_untergeordnetesgewaesser_polygon"
	#GROUP "ax_untergeordnetesgewaesser"
	GROUP "ax_nutzungen"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon') as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Untergeordnetes Gewässer (Flächen)"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	CLASSITEM funktion
	CLASS
		NAME "Graben"
		EXPRESSION ('[funktion]' >= '1010' AND '[funktion]' <= '1013')
		STYLE
			COLOR 227 255 255
			OUTLINECOLOR 0 204 204
		END
	END
	CLASS # ToDo: Klassen differenzieren? nach Farbe?
		NAME "Fleet"
		EXPRESSION '1020'
		STYLE
			COLOR 227 255 255
			OUTLINECOLOR 0 204 204
		END
	END
	CLASS
		NAME "Bach"
		EXPRESSION '1030'
		STYLE
			COLOR 227 255 255
			OUTLINECOLOR 0 204 204
		END
	END
	CLASS
		NAME "Teich"
		EXPRESSION '1040'
		STYLE
			COLOR 227 255 255
			OUTLINECOLOR 0 204 204
		END
	END
END
LAYER
	NAME "ax_untergeordnetesgewaesser_line"
	GROUP "ax_nutzungen"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_LineString') as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Untergeordnetes Gewässer (Line)"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	CLASSITEM funktion
	CLASS
		NAME "Graben"
		EXPRESSION ('[funktion]' >= '1010' AND '[funktion]' <= '1013')
		STYLE
			COLOR 0 204 204
		END
	END
	CLASS # ToDo: Klassen differenzieren? nach Farbe?
		NAME "Fleet"
		EXPRESSION '1020'
		STYLE
			COLOR 0 204 204
		END
	END
	CLASS
		NAME "Bach"
		EXPRESSION '1030'
		STYLE
			COLOR 0 204 204
		END
	END
	#CLASS
	#	NAME "Teich"
	#	EXPRESSION '1040'
	#	STYLE
	#		COLOR 0 204 204
	#	END
	#END
END

# ** aus Post-Processing: Katasterbezirke
LAYER
	NAME "pp_flur"
	GROUP "pp_gebiete"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832"
	METADATA
		wms_title "Flur"
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_group_title "Gebiete"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 400 #1600
	MAXSCALEDENOM 5000 #20000
	LABELITEM flurnummer
	CLASS
		NAME "Flur"
		TEXT "Flur [flurnummer]"
		STYLE
			OUTLINECOLOR 100 150 10
			WIDTH 12 #3
		END
		LABEL
			TYPE TRUETYPE
			COLOR 100 150 10
			FONT "arial"
			SIZE 56 #14
			POSITION cc
			PARTIALS FALSE FORCE FALSE
			STYLE
				GEOMTRANSFORM 'labelpoly'
				COLOR 250 250 250
			END
		END
	END
END
LAYER
	NAME "pp_gemarkung"
	GROUP "pp_gebiete"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Gemarkung"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 1000 #4000
	MAXSCALEDENOM 10000 #40000
	LABELITEM gemarkungsname
	CLASS
		NAME "Gemarkung"
		STYLE
			OUTLINECOLOR 140 80 0
			WIDTH 20 #5
		END
		LABEL
			TYPE TRUETYPE
			COLOR 140 80 0
			FONT "arial"
			SIZE 64 #16
			POSITION cc
			OFFSET 0 40 # 0 10
			PARTIALS FALSE FORCE FALSE
			STYLE
				GEOMTRANSFORM 'labelpoly'
				COLOR 250 250 250
			END
		END
	END
END
LAYER
	NAME "pp_gemeinde"
	GROUP "pp_gebiete"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Gemeinde"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 2000 #8000
	MAXSCALEDENOM 100000 #400000
	LABELITEM gemeindename
	CLASS
		NAME "Gemeinde"
		STYLE
			OUTLINECOLOR 10 10 200
			WIDTH 28 #7
		END
		LABEL
			TYPE TRUETYPE
			COLOR 10 10 200
			FONT "arial"
			SIZE 80 # 20
			POSITION cc
			OFFSET 0 -80 # 0 -20
			PARTIALS FALSE
			FORCE FALSE
			STYLE
				GEOMTRANSFORM 'labelpoly'
				COLOR 250 250 250
			END
		END
	END
END

# ALKIS Gebäude
LAYER
	NAME "ax_gebaeude_fl"
	GROUP "gebaeude"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Gebäude (Fläche)"
		wms_group_title "Gebäude"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1250 #5000
	SYMBOLSCALEDENOM 250 #1000
	CLASSITEM 'gebaeudefunktion'
	# Classes ohne Flächenfüllung
	CLASS
		NAME "Gebäude, unterirdisch"
		EXPRESSION ('[lagezurerdoberflaeche]' = '1200')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 #1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 4 8 END # 1 2
			LINECAP butt
		END
	END
	CLASS
		NAME "Hochhaus, verfallen"
		EXPRESSION ('[hochhaus]' = "true" AND '[zustand]' > '2199')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 12 # 2 2 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude, verfallen"
		EXPRESSION ('[zustand]' > '2199')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	# Classes mit Flächenfüllung
	CLASS
		NAME "Wohngebäude, Hochhaus graphisch"
		EXPRESSION ('[hochhaus]' = "true" AND '[ax_datenerhebung]' = '4300' AND '[gebaeudefunktion]' < '2000')
		STYLE
			COLOR 153 153 153
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Wohngebäude, Hochhaus aufgeständert" # sn2030_sn1301
		EXPRESSION ('[hochhaus]' = "true" AND '[gebaeudefunktion]' < '2000' AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 153 153 153
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Hochhaus" # "Wohngebäude, Hochhaus"
		EXPRESSION ('[gebaeudefunktion]' < '2000' AND '[hochhaus]' = "true")
		STYLE
			COLOR 153 153 153
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Wohngebäude graphisch"
		EXPRESSION ('[gebaeudefunktion]' < '2000' AND '[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 153 153 153
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 #1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Wohngebäude aufgeständert"
		EXPRESSION ('[gebaeudefunktion]' < '2000' AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 153 153 153
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Wohngebäude"
		EXPRESSION /^1/ #('[gebaeudefunktion]' < '2000')
		STYLE
			COLOR 153 153 153
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 #1 1 3
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe, Hochhaus, graphisch"
		EXPRESSION ('[gebaeudefunktion]' > '1999' AND '[gebaeudefunktion]' < '3000' AND '[hochhaus]' = "true" AND '[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 220 220 220
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50 #[schrawink]
	#		SIZE 20 # 5 
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe, Hochhaus, aufgeständert"
		EXPRESSION ('[gebaeudefunktion]' > '1999' AND '[gebaeudefunktion]' < '3000' AND '[hochhaus]' = "true" AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 220 220 220
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe, Hochhaus"
		EXPRESSION ('[gebaeudefunktion]' > '1999' AND '[gebaeudefunktion]' < '3000' AND '[hochhaus]' = "true")
		STYLE
			COLOR 220 220 220
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe, graphisch"
		EXPRESSION ('[gebaeudefunktion]' > '1999' AND '[gebaeudefunktion]' < '3000' AND '[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 220 220 220
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50 #[schrawink]
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe, aufgeständert"
		EXPRESSION ('[gebaeudefunktion]' > '1999' AND '[gebaeudefunktion]' < '3000' AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 220 220 220
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 #1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für Wirtschaft oder Gewerbe"
		EXPRESSION /^2/
		STYLE
			COLOR 220 220 220
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke, Hochhaus, graphisch"
		EXPRESSION ('[gebaeudefunktion]' > '2999' AND '[gebaeudefunktion]' < '4000' AND '[hochhaus]' = "true" AND '[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 255 128 128
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50 #[schrawink]
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke, Hochhaus, aufgeständert"
		EXPRESSION ('[gebaeudefunktion]' > 2999 AND '[gebaeudefunktion]' < 4000 AND '[hochhaus]' = "true" AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 255 128 128
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke, Hochhaus"
		EXPRESSION ('[gebaeudefunktion]' > '2999' AND '[gebaeudefunktion]' < '4000' AND '[hochhaus]' = "true")
		STYLE
			COLOR 255 128 128
		END
		STYLE
			SYMBOL 'quadrate'
			SIZE 8 MINSIZE 8 MAXSIZE 16 # 2 2 4
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke, graphisch"
		EXPRESSION ('[gebaeudefunktion]' > '2999' AND '[gebaeudefunktion]' < '4000' AND '[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 255 128 128
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50 #[schrawink]
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke, aufgeständert"
		EXPRESSION ('[gebaeudefunktion]' > '2999' AND '[gebaeudefunktion]' < '4000' AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 255 128 128
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude für öffentliche Zwecke"
		EXPRESSION /^3/
		STYLE
			COLOR 255 128 128
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
		END
	END
	CLASS
		NAME "Nach Quellenlage nicht zu spezifizieren"
		EXPRESSION /9998/ #('[gebaeudefunktion]' = 9998)
		STYLE
			COLOR 190 190 190 # 204 204 204
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
		END
	END
#	CLASS
#		#NAME "Rest"
#		EXPRESSION /./
#		STYLE
#			#COLOR 255 128 128
#			OUTLINECOLOR 255 0 0
#			WIDTH 8 MINWIDTH 8 MAXWIDTH 12 #2 2 3
#		END
#	END
END
LAYER
	NAME "ax_gebaeude_umr"
	GROUP "gebaeude"
	REQUIRES "![ax_gebaeude_fl]" # ent oder weder
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Gebäude (Umring)"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1500
	CLASSITEM 'gebaeudefunktion' #'zustand'
	CLASS
		NAME "Gebäude, unterirdisch" # z.B. Tiefgarage
		EXPRESSION ('[lagezurerdoberflaeche]' = '1200')
		STYLE # Dummy-Füllung. Legende zeigt Fläche, Fläche bleibt aber transparent
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			PATTERN 4 8 END # 1 2
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude, verfallen"
		EXPRESSION ('[zustand]' > '2199')
		STYLE # Dummy-Füllung
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Hochhaus aufgeständert"
		EXPRESSION ('[hochhaus]' = "true" AND '[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 8 MINWIDTH 8 MAXWIDTH 16 # 2 2 4
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
		END
	END
	CLASS
		NAME "Hochhaus" 
		EXPRESSION ('[hochhaus]' = "true")
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			SYMBOL 'quadrate'
			SIZE 8 MINSIZE 8 MAXSIZE 16 # 2 2 4
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Gebäude graphisch"
		EXPRESSION ('[ax_datenerhebung]' = '4300')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
	#	STYLE
	#		SYMBOL 'hatch'
	#		ANGLE 50
	#		SIZE 20 # 5
	#		WIDTH 8 MINWIDTH 8 MAXWIDTH 8 # 2 2 2
	#		COLOR 128 64 0
	#	END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 24 16 8 16 END # 6 4 2 4 
		END
	END
	CLASS
		NAME "Gebäude aufgeständert"
		EXPRESSION ('[lagezurerdoberflaeche]' = '1400')
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
			OUTLINECOLOR 0 0 0
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		NAME "Gebäude"
		STYLE
			COLOR 255 255 255
			SYMBOL 'filler'
			SIZE 60 # 15
		END
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 12 # 1 1 3
		END
	END
END
LAYER
	NAME "ax_gebaeude_txt" # Gebäude - Texte
	GROUP "gebaeude"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM gebaeude_txt) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Funktion und Name)"
	END
	MINSCALEDENOM 50
	MAXSCALEDENOM 2000
	SYMBOLSCALEDENOM 1000
	LABELITEM 'funktion'
	CLASSITEM 'name'
	CLASS
		NAME "Name und Funktion"
		EXPRESSION /./
		LABEL
			TYPE TRUETYPE FONT 'arialnarrow'
			SIZE 24 MINSIZE 20 MAXSIZE 36 # 9 7 12
			POSITION cc OFFSET 0 40 # 0 12
			COLOR 0 0 0 OUTLINECOLOR 254 254 254
			ANTIALIAS true PARTIALS false FORCE false
			WRAP " " MAXLENGTH 10
		END
		LABEL # 2. Label
			TEXT '[name]'
			TYPE TRUETYPE FONT 'arialbold'
			SIZE 34 MINSIZE 22 MAXSIZE 40 # 9 6 10
			POSITION cc OFFSET 0 -36 # 0 -10
			COLOR 180 0 0 OUTLINECOLOR 254 254 254
			ANTIALIAS true PARTIALS false FORCE true
		END
	END
	CLASS
		NAME "Funktion" # nur ..
		LABEL
			TYPE TRUETYPE FONT 'arialnarrow'
			SIZE 24 MINSIZE 20 MAXSIZE 36 # 9 7 12
			POSITION auto #cc
			COLOR 0 0 0 OUTLINECOLOR 254 254 254
			ANTIALIAS true PARTIALS false FORCE false
			WRAP " " MAXLENGTH 10
		END
	END
END
LAYER
	NAME "ax_bauteil"
	GROUP "gebaeude"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauteil"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1000 #4000
	CLASSITEM 'bauart'
	# ToDo: "lagezurerdoberflaeche" auswerten, Werte: null, 1200.
	CLASS
		NAME "Bauteil"
		EXPRESSION ('[bauart]' = '1100' OR '[bauart]' = '1200' OR '[bauart]' = '1400' OR '[bauart]' = '2000' OR '[bauart]' = '2100' OR '[bauart]' = '2300' OR '[bauart]' = '2350' OR '[bauart]' = '2400' OR '[bauart]' = '2500' OR '[bauart]' = '2510' OR '[bauart]' = '2520' OR '[bauart]' = '2610' OR '[bauart]' = '2620' OR '[bauart]' = '9999')
		STYLE
			OUTLINECOLOR 0 0 0
		END
	END
	CLASS
		NAME "Bauteil-Schornstein"
		EXPRESSION ('[bauart]' = '2710')
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 8 #2
		END
	END
	CLASS
		NAME "Bauteil-Turm"
		EXPRESSION ('[bauart]' = '2720')
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 12 #3
		END
	END
	CLASS
		NAME "Bauteil-Hochhausgebäudeteil"
		EXPRESSION ('[bauart]' = '1300')
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 16 #4
		END
	END
	CLASS
		NAME "Beschaffenheit"
		EXPRESSION /./
		STYLE
			OUTLINECOLOR 200 0 0
			WIDTH 4 #1
		END
	END
END
LAYER
	NAME "ax_besonderegebaeudelinie"
	GROUP "gebaeude"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Besondere Gebäudelinie"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1000 #4000
	CLASS
		NAME "Besondere Gebäudelinie"
		STYLE
			COLOR 0 0 0
		END
		STYLE
			COLOR 254 254 254
			PATTERN 12 24 END # 3 6 
		END
	END
END
LAYER # Hausnummer
	NAME "ag_t_gebaeude"
	GROUP "gebaeude"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Hausnummer"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	LABELITEM "hausnummer"
	LABELMINSCALEDENOM 0
	LABELMAXSCALEDENOM 500 #2000
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		NAME "Hausnummer"
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			TYPE TRUETYPE FONT 'arialnarrow'
			SIZE 28 MINSIZE 16 MAXSIZE 40 # (8 5 12) *4 = (32 20 48) also nicht proportional zur Bildscheirm-Version
			POSITION uc
			OFFSET 0 -12 # 0 -3
			ANGLE [drehwinkel] 
			COLOR 0 0 0
			ANTIALIAS true PARTIALS false FORCE true
			BUFFER 1
			OUTLINECOLOR 254 254 254
		END
	END
END

LAYER # Lagebezeichnung mit Pseudonummer, Anzeige der lfd-Nr.
	NAME "ag_t_nebengeb"
	GROUP "gebaeude"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM lfdnr_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "lfd. Nr Nebengebäude"
	END
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 325 # 1500
	SYMBOLSCALEDENOM 1000
	CLASS
		NAME "Hausnummer"
		TEXT '([laufendenummer])' # Die Klammern auch mit darstellen!
		LABEL 
			TYPE TRUETYPE FONT 'arialnarrow'
			SIZE 28 MINSIZE 20 MAXSIZE 40 # 7 5 10
			POSITION cc
			COLOR 50 50 50
			ANTIALIAS true PARTIALS false FORCE true
			OUTLINECOLOR 254 254 254			
		END
	END
END
# Zuordnungspfeile Gebäude
# siehe auch Layer "ap_lpo"
LAYER
	NAME "ag_l_gebaeude"
	GROUP "gebaeude"
	REQUIRES "[ag_t_nebengeb]" # nur beides
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zuordnungspfeile Gebäude"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 325 # 1500
	CLASS
		NAME "Zuordnungspfeile"
		STYLE
			COLOR 0 0 0
		END
	END
END
# ALKIS Bauwerke
LAYER
	NAME "ax_bauwerkimverkehrsbereich_fuellung"
	GROUP "bauwerk"
	#GROUP "ax_bauwerkimverkehrsbereich"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauwerk im Verkehrsbereich (Füllung)"
		wms_group_title "Bauwerke"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Brücke"
		STYLE
			COLOR 255 255 255
		END
	END
END
LAYER
	NAME "ax_bauwerkimverkehrsbereich_umrandung"
	GROUP "bauwerk" # "ax_bauwerkimverkehrsbereich"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauwerk im Verkehrsbereich (Umrandung)"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Brücke"
		STYLE
			OUTLINECOLOR 128 128 128
			PATTERN 22.7 11.4 END # 5.67 2.85
			WIDTH 8# 2
		END
	END
END
LAYER
	NAME "ax_bauwerkimgewaesserbereich"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauwerk im Gewässerbereich"
		#wms_abstract "Bauwerk im Gewässerbereich"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	#CLASSITEM 'bauwerksfunktion'
	CLASS
		NAME "Bauwerk im Gewässerbereich"
		STYLE
			OUTLINECOLOR 82 0 0
		END
	END
END
LAYER
	NAME "ax_bauwerkoderanlagefuerindustrieundgewerbe"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832"
	FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauwerk oder Anlage für Industrie und Gewerbe"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'bauwerksfunktion'
	CLASS
		NAME "Klärbecken"
		EXPRESSION ('[bauwerksfunktion]' = '1210')
		STYLE
			COLOR 242 235 232
			OUTLINECOLOR 0 204 204
		END
	END
	CLASS
		NAME "Bauwerk oder Anlage für Industrie und Gewerbe"
		EXPRESSION ('[bauwerksfunktion]' = '1215' OR '[bauwerksfunktion]' = '1220' OR '[bauwerksfunktion]' = '1250' OR '[bauwerksfunktion]' = '1260')
		STYLE
			COLOR 220 220 220 # 204 204 204
			OUTLINECOLOR 0 0 0
		END
	END
	# else?
END
LAYER
	NAME "ax_bauwerkoderanlagefuersportfreizeitunderholung"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bauwerk oder Anlage für Sport, Freizeit und Erholung"
	END	
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	#CLASSITEM 'bauwerksfunktion'
	CLASS
		NAME "Bauwerk oder Anlage für Sport, Freizeit und Erholung" # sn1520
		STYLE
			COLOR 217 255 217
			OUTLINECOLOR 82 0 0
		END
	END
END
LAYER
	NAME "ax_vorratsbehaelterspeicherbauwerk"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Vorratsbehälter, Speicherbauwerk"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	#CLASSITEM 'bauwerksfunktion'
	CLASS
		NAME "Vorratsbehälter, Speicherbauwerk"
		STYLE
			COLOR 220 220 220 # 204 204 204
			OUTLINECOLOR 0 0 0
		END
	END
END
LAYER
	NAME "ax_sonstigesbauwerkodersonstigeeinrichtung"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon') as foo using unique ogc_fid using SRID=25832"
	#FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Sonstiges Bauwerk/Einrichtung"
	END
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
#	CLASSITEM 'bauwerksfunktion'
	#CLASS
	#	NAME "Überdachung"
	#	EXPRESSION "1610"
	#	STYLE
	#		COLOR 220 220 220
	#	END
	#END
	#CLASS
	#	NAME "Brunnen (Trinkwasserversorgung)"
	#	EXPRESSION "1781"
	#	STYLE
	#		COLOR 227 255 255
	#		OUTLINECOLOR 0 204 204
	#	END
	#END
	CLASS
		NAME "Bauwerksfläche"
		STYLE
			COLOR 229 229 229
			OPACITY 50
		END
		STYLE
			OUTLINECOLOR 0 0 0
			OUTLINEWIDTH 3
			PATTERN 20 8 END # 5 2
		END
	END
END
LAYER
	NAME "ax_sonstigesbauwerkodersonstigeeinrichtung_l"
	GROUP "bauwerk"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_LineString') as foo using unique ogc_fid using SRID=25832"
	#FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Sonstiges Bauwerk/Einrichtung (Linien)"
	END
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'bauwerksfunktion'
	CLASS 
		NAME "Bauwerkslinie"
		STYLE
			COLOR 0 0 0
			WIDTH 3 #1
			PATTERN 20 8 END # 5 2
		END
	END
END
LAYER
	NAME "ax_leitung"
	GROUP "bauwerk"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Leitung"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Freileitung"
		EXPRESSION ('[bauwerksfunktion]' = '1110')
		STYLE
			COLOR 0 0 0
			SIZE 2.04 #0.51
		END
	END
	CLASS
		NAME "Erdkabel" # sn2523
		EXPRESSION ('[bauwerksfunktion]' = '1111')
		STYLE
			SYMBOL 'point'
			COLOR 0 0 0
			PATTERN 4 4 END # 1 1
		END
	END
END
LAYER
	NAME "ax_transportanlage"
	GROUP "bauwerk"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Transportanlage"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'lagezurerdoberflaeche'
#	CLASS
#		NAME "Transportanlage"
#		STYLE
#			SYMBOL 'point'
#			COLOR 0 0 0
#		END
#	END
	CLASS
		NAME "Pipeline unter der Erdoberfläche oder Wasseroberfläche" # sn2523
		EXPRESSION ('[lagezurerdoberflaeche]' = '1200' OR '[lagezurerdoberflaeche]' = '1700')
		SYMBOL 0 #SYMBOL 'sn2523'
		STYLE
			COLOR 0 0 0
			PATTERN 4 4 END # 1 1
		END
	END
	CLASS
		NAME "Pipeline"
		EXPRESSION ('[lagezurerdoberflaeche]' = '1400')
		STYLE
			SYMBOL 0
			COLOR 0 0 0
		END
	END
END
LAYER
	NAME "ax_turm"
	GROUP "bauwerk"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Turm"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Turm"
		STYLE
			COLOR 204 204 204
			OUTLINECOLOR 0 0 0
		END
	END
END

# B o d e n s c h ä t z u n g
## Einfache Version: Den Label mittig in der Fläche anzeigen
#LAYER
#	NAME "bodensch_klass"

LAYER
	NAME "bodensch_po"
	GROUP "bodenschaetzung"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from s_bodensch_po using unique ogc_fid using SRID=25832"
	METADATA
		wms_group_title "Bodenschätzung"
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Klassenfläche"
	END
	PROJECTION "init=epsg:25832" END
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		NAME "Klassenflächengrenze"
		STYLE
			OUTLINECOLOR 144 197 140
			WIDTH 14 MINWIDTH 10 MAXWIDTH 20 # 3.5  2.5  5
		END
	END
END

LAYER
	NAME "bodensch_tx"
	GROUP "bodenschaetzung"
	REQUIRES "[bodensch_po]" # Grenzen aufzeigen?
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from s_bodensch_tx using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Schätzungsergebnis"
	END
	PROJECTION "init=epsg:25832" END
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASSITEM kult # Kulturart, SELECT DISTINCT kult FROM s_bodensch_wms; A, AGR, Gr, GrA
	LABELITEM derlabel
	CLASS
		NAME "Acker"
		EXPRESSION  ('[kult]' = 'A' OR '[kult]' = 'AGr')
		LABEL
			TYPE TRUETYPE FONT "times" # Serifenschrift
			COLOR 211 147 135 # rosa
			OUTLINECOLOR 254 254 254 OUTLINEWIDTH 8 #2
			SIZE 44 MINSIZE 34 MAXSIZE 56 # 13 10 16
			POSITION uc  # hor/ver = zentrisch/basis
			PARTIALS FALSE FORCE TRUE
			WRAP ' ' MAXLENGTH 3
		END
	END
	CLASS
		NAME "Grünland"
		EXPRESSION ('[kult]' = 'Gr' OR '[kult]' = 'GrA')
		LABEL
			TYPE TRUETYPE FONT "times"
			COLOR 144 197 140 # Grün
			OUTLINECOLOR 254 254 254 OUTLINEWIDTH 8 #2
			SIZE 44 MINSIZE 34 MAXSIZE 56 # 13 10 16
			POSITION uc  # hor/ver = zentrisch/basis
			PARTIALS FALSE FORCE TRUE
			WRAP ' ' MAXLENGTH 3
		END
	END
END

# Zuordnungspfeile Bodenschätzung
LAYER
	NAME "ag_l_bodsch"
	GROUP "bodenschaetzung"
	#REQUIRES "[ag_t_flurstueck]" # zur Nummer
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM s_zuordungspfeil_bodensch) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zuordnungspfeile" # Linie
	END
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		#NAME "Zuordnungspfeil"
		STYLE
			COLOR 144 197 140
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
		END
	END
END
LAYER
	NAME "ag_l_bodsch_sp"
	GROUP "bodenschaetzung"
	REQUIRES "[ag_l_bodsch]" # nur beides
	TYPE Annotation
	STATUS ON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_bodensch) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zuordnungspfeil Spitze"
	END
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		#NAME "Zuordnungspfeilspitze"
		TEXT 'E'
		LABEL
			TYPE TRUETYPE
			FONT "alkis_textsymbols"
			SIZE 12 MINSIZE 8 MAXSIZE 24 # 3 2 6
			POSITION cc
			ANGLE [winkel]
			COLOR 144 197 140
			ANTIALIAS TRUE PARTIALS FALSE FORCE TRUE
		END
	END
END

#LAYER
#	NAME "ax_grablochderbodenschaetzung"
#	GROUP "bodenschaetzung"
#	TYPE POINT
#	CONNECTIONTYPE POSTGIS
#	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
#	PROCESSING "CLOSE_CONNECTION=DEFER"
#	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832"
#	METADATA
#		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
#		wms_title "Grabloch der Bodenschätzung"
#		#wms_abstract "Grabloch der Bodenschätzung"
#		wms_group_title "Bodenschätzung"
#		wms_group_abstract "Bodenschätzung" 
#	END
#	#PROJECTION "init=epsg:25832" END
#	#EXTENT 349000 5529000 356000 5533000
#	MINSCALEDENOM 0
#	MAXSCALEDENOM 1250 #5000
#	CLASS
#		NAME "Grabloch der Bodenschätzung"
#		STYLE
#			SYMBOL "sn3703"
#			COLOR 255 128 128
#			SIZE 4 #1
#		END
#	END
#END

#LAYER
#	NAME "ax_musterlandesmusterundvergleichsstueck"
#	GROUP "bodenschaetzung"
#	TYPE POLYGON
#	CONNECTIONTYPE POSTGIS
#	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
#	PROCESSING "CLOSE_CONNECTION=DEFER"
#	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832"
#	METADATA
#		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
#		wms_title "Muster Landesmuster und Vergleichsstück"
#		#wms_abstract "Muster-, Landesmuster- und Vergleichsstück der Bodenschätzung"
#	END
#	#PROJECTION "init=epsg:25832" END
#	#EXTENT 349000 5529000 356000 5533000
#	MINSCALEDENOM 12 #0
#	MAXSCALEDENOM 1250 #5000
#	CLASS
#		NAME "Muster Landesmuster und Vergleichsstück"
#		STYLE
#			OUTLINECOLOR 255 128 128
#		END
#	END
#END

# ALKIS  F l u r s t ü c k
LAYER
	NAME "ax_flurstueck"
	GROUP "flurstueck"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Flurstück"
		wms_group_title "Flurstück"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 6250 #25000
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		NAME "Flurstück"
		STYLE
			OUTLINECOLOR 0 0 0
			WIDTH 6 MINWIDTH 4 MAXWIDTH 10 # 1.5 1 2.5
		END
	END
END
LAYER
	NAME "ax_besondereflurstuecksgrenze"
	GROUP "flurstueck"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Besondere Flurstücksgrenze"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	SYMBOLSCALEDENOM 250 #1000
	CLASSITEM "artderflurstuecksgrenze"
	CLASS
		EXPRESSION /1000/ # reg. Expression, weil Teil eines ARRAY
		NAME "Strittige Grenze"
		STYLE
			COLOR 254 254 254 # heller Hintergrund, weiss, nicht transparent, bedeckt die Flurstücksgrenze
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 80 40 END # 20 10
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2001/
		NAME "Nicht festgestellte Grenze"
		STYLE
			COLOR 254 254 254
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 68 11.4 END # 17 2.85
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2002/
		NAME "Verwaltungsstreitverfahren (Grenze)"
		STYLE
			COLOR 254 254 254
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 68 11.4 END # 17 2.85
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2003/
		NAME "Mittellinie in Gewässern"
		STYLE
			COLOR 254 254 254
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2004/
		NAME "Flurstücksgrenze nicht feststellbar"
		STYLE
			COLOR 254 254 254 
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 32 16 END # 8 4
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2010/
		NAME "Topographische Grenzeinrichtung"
		STYLE
			COLOR 254 254 254
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 17 2.85 END
			LINECAP butt
		END
	END
	CLASS
		EXPRESSION /2100/
		NAME "Topographische Gewässerbegrenzung"
		STYLE
			COLOR 254 254 254
			WIDTH 9.6 MINWIDTH 6 MAXWIDTH 14 # 2.4 / 1.5 / 3.5
		END
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8 # 1 1 2
			PATTERN 68 11.4 END # 17 2.85
		END
	END
END

# Zuordnungspfeile Flurstück
LAYER
	NAME "ag_l_flurstueck"
	GROUP "flurstueck"
	REQUIRES "[ag_t_flurstueck]" # zur Nummer
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zuordnungspfeil Linie"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		#NAME "Zuordnungspfeile"
		STYLE
			COLOR 0 0 0
			WIDTH 4 MINWIDTH 4 MAXWIDTH 8
		END
	END
END
LAYER
	NAME "sk2004_zuordnungspfeil_spitze"
	GROUP "flurstueck"
	REQUIRES "[ag_l_flurstueck]" # nur beides
	TYPE Annotation
	STATUS ON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zuordnungspfeil Spitze"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 875 #3500
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		#NAME "Zuordnungspfeilspitze"
		TEXT 'E'
		LABEL
			TYPE TRUETYPE
			FONT "alkis_textsymbols"
			SIZE 12 MINSIZE 8 MAXSIZE 24 # 3 2 6
			POSITION cc
			ANGLE [winkel]
			COLOR 0 0 0
			ANTIALIAS TRUE PARTIALS FALSE FORCE TRUE
		END
	END
END

# Flurstuecksnummer
LAYER
	NAME "ag_t_flurstueck"
	GROUP "flurstueck"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Flurstuecksnummer"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1000 #4000
	LABELITEM "fsnum"
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		NAME "Flurstuecknummer"
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			TYPE TRUETYPE FONT 'arialnarrowkursiv'
			SIZE 28 MINSIZE 20 MAXSIZE 48 # kleiner als 4x Bildschirm. Im Druck "dezentere" Darstellung
			POSITION cc
			OFFSET 0 -14 # -3.5433
			COLOR 100 0 0 # 200 0 0
			OUTLINECOLOR 254 254 254
			OUTLINEWIDTH 6 # 2
			FORCE True
		END
	END
END
# Zugehoerigkeitshaken Flurstueck
LAYER
	NAME "ag_p_flurstueck"
	GROUP "flurstueck"
	TYPE ANNOTATION
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Zugehörigkeitshaken Flurstueck"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1000 #4000
	SYMBOLSCALEDENOM 250 #1000
	CLASS
		TEXT 'B'
		LABEL
			TYPE TRUETYPE FONT "alkis_textsymbols"
			SIZE 56 MINSIZE 28 MAXSIZE 96 # 14 7 24
			POSITION cc OFFSET 0 -12
			COLOR 0 0 0
			ANGLE [drehwinkel]
			ANTIALIAS TRUE PARTIALS FALSE FORCE True
		END
	END
END
# ALKIS Recht (Klassifizierungen, ges. Festlegungen)
LAYER
	NAME "ax_klassifizierungnachstrassenrecht"
	GROUP "recht"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Klassifizierung nach Strassenrecht"
		wms_group_title "Recht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'artderfestlegung'
	CLASS
		NAME "Bundesautobahn, Bundesstrasse"
		EXPRESSION ('[artderfestlegung]' = '1110' OR '[artderfestlegung]' = '1120')
		STYLE
			COLOR 255 230 128
			OUTLINECOLOR 153 153 153
		END
	END
	CLASS
		NAME "Landes- oder Staatsstrasse"
		EXPRESSION ('[artderfestlegung]' = '1130')
		STYLE
			COLOR 255 255 178
			OUTLINECOLOR 153 153 153
		END
	END
	# sn7858 Gemeindeverbindungsstraße erhält Schriftsatz
END
# ax_klassifizierungnachwasserrecht
# Tabelle leer
LAYER
	NAME "ax_naturumweltoderbodenschutzrecht"
	GROUP "recht"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Natur, Umwelt oder Bodenschutzrecht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Natur, Umwelt oder Bodenschutzrecht"
		STYLE
			OUTLINECOLOR 128 255 128
			WIDTH 12 # 3
			PATTERN 45 11.4 END # 11.34 2.85
		END
	END
END
LAYER
	NAME "ax_anderefestlegungnachwasserrecht"
	GROUP "recht"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Andere Festlegung nach Wasserrecht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 2500 #10000
#	CLASSITEM 'artderfestlegung'
	CLASS #sn1705
		NAME "Andere Festlegung nach Wasserrecht" 
		STYLE
			OUTLINECOLOR 178 255 255
			WIDTH 12 #3
			PATTERN 45 11.4 END # 11.34 2.85
		END
	END
#	CLASS
#		NAME "Festgesetztes Überschwemmungsgebiet"
#		EXPRESSION ('[artderfestlegung]' = '1441')
#			COLOR 178 255 255
#	END
END
LAYER
	NAME "ax_bauraumoderbodenordnungsrecht_umrandung"
	GROUP "recht"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bau-, Raum- oder Bodenordnungsrecht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 2500 #10000
	SYMBOLSCALEDENOM 250 # 1000
	CLASSITEM "artderfestlegung"
	CLASS
		EXPRESSION "2610"
		NAME "Baulast"
		TEXT "Baulast"
		STYLE
			OUTLINECOLOR 255 128 128
			WIDTH 12 MINWIDTH 8 MAXWIDTH 20 # 3 2 5
			PATTERN 44 12 END # 11 3
		END
		LABEL
			TYPE TRUETYPE FONT "arial"
			COLOR 255 128 128
			OUTLINECOLOR 255 255 255
			SIZE 56 # 14
			MINSIZE 32 # 8
			MAXSIZE 64 # 16
			POSITION cc
			PARTIALS FALSE FORCE FALSE
		END
	END
	CLASS
		EXPRESSION ('[artderfestlegung]' ge '2100' and '[artderfestlegung]' le '2199') # Rest der Gruppe
		NAME "Flurbereinigung"
		STYLE
			COLOR 100 100 100
			SYMBOL "sn3631"
			SIZE 60 MINSIZE 40 MAXSIZE 100 #15 10 25
		END
		STYLE
			OUTLINECOLOR 255 128 128
			WIDTH 12 MINWIDTH 8 MAXWIDTH 20 # 3 2 5
			PATTERN 48 12 END # 12 3
		END
	END
	CLASS
		EXPRESSION ('[artderfestlegung]' = '1750' OR '[artderfestlegung]' = '1770')
		NAME "Umlegung"
		TEXT "Umlegung"
		STYLE
			OUTLINECOLOR 255 128 128
			WIDTH 12 MINWIDTH 8 MAXWIDTH 20 # 3 2 5
			PATTERN 44 12 END # 11 3
		END
		STYLE
			COLOR 100 100 100
			SYMBOL "sn3631"
			SIZE 60 MINSIZE 40 MAXSIZE 80 #15 10 20
		END
		LABEL
			TYPE TRUETYPE
			COLOR 255 0 255
			FONT "arial"
			SIZE 40 MINSIZE 32 MAXSIZE 56 # 10 8 14
			POSITION cc
			PARTIALS FALSE FORCE FALSE
		END
	END
	CLASS
		EXPRESSION /./
		NAME "Bau-, Raum oder Bodenordnungsrecht"
		STYLE # sn1704
			OUTLINECOLOR 255 128 128
			WIDTH 12 MINWIDTH 8 MAXWIDTH 15 # 3 2 5
			PATTERN 44 12 END # 11 3
		END
	END
END
LAYER
	NAME "ax_denkmalschutzrecht"
	GROUP "recht"
	TYPE POLYGON
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Denkmalschutzrecht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASS
		NAME "Denkmalschutzrecht"
		STYLE
			OUTLINECOLOR 153 153 153
		END
	END
END
LAYER
	NAME "ax_sonstigesrecht"
	GROUP "recht"
	TYPE LINE
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Sonstiges Recht"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 2500 #10000
	CLASSITEM 'artderfestlegung'
	CLASS
		NAME "Freileitung"
		EXPRESSION ('[artderfestlegung]' = '4720')
		STYLE
			PATTERN 45.3 11.4 END # 11.34 2.85
			OUTLINECOLOR 255 128 128
		END
	END
END

# ALKIS Punktort (Vermessungspunkte)
LAYER
	NAME "ax_punktortta"
	GROUP "punktort"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM grenzpunkt) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Grenzpunkt"
		wms_group_title "Vermessungspunkte"
	END
	MINSCALEDENOM 50
	MAXSCALEDENOM 2000
	SYMBOLSCALEDENOM 1000
	# Die folgenden Grenzpunkt-Symbole sind nicht genau 4mal so groß wie in der Bildschirm-Map.
	# Druck und Bildschirm getrennt optimieren! Auf Bildschirm vergrößern zur besseren Erkennbarkeit.
	CLASS
		NAME "vermarkt"
		EXPRESSION ('[abmarkung_marke]' < '9000') # 1000 bis 3845 = Abmarkung 
		STYLE # Kringel
			SYMBOL 'point'
			COLOR 255 255 255
			SIZE 11 MINSIZE 7 MAXSIZE 20 # Füllung 4 2 7 
			OUTLINECOLOR 0 0 0
			WIDTH 2 MINWIDTH 2 MAXWIDTH 5 # Rand 1 1 2
		END
	END
	CLASS # 9500=Ohne Marke, 9600=Abmarkung zeitweilig ausgesetzt, 9998=Nach Quellenlage nicht zu spezifizieren
		NAME "unvermarkt"
		STYLE
			SYMBOL 'point'
			SIZE 10 MINSIZE 6 MAXSIZE 18 # Freistellung 4 2 6
			COLOR 255 255 255
		END
		STYLE
			SYMBOL 'point'
			SIZE 4 MINSIZE 2 MAXSIZE 8 # Pünktchen 1.25 1 3
			COLOR 0 0 0
		END
	END
END
LAYER
	NAME "ax_punktortag"
	GROUP "punktort"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Bes. Gebäudepunkt"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 500 #2000
	CLASS
		NAME "Gebäudepunkt"
		STYLE
			SYMBOL "point"
			SIZE 16 MINSIZE 12 MAXSIZE 32 # 4 3 8
			COLOR 0 0 0
		END
	END
END
LAYER
	NAME "ax_punktortau"
	GROUP "punktort"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Punktort AU"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 500 #2000
	CLASS
		NAME "PunktortAU"
		STYLE
			SYMBOL "point"
			SIZE 20 # 5
			COLOR 0 0 0
		END
	END
END
# ALKIS  AAA-Präsentationsobjekte
LAYER
	NAME "ap_pto_stra"
	GROUP "praesentation"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "the_geom from (SELECT * FROM pp_strassenname_p) as foo using unique gid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Straßen ."
		wms_group_title "Präsentation"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1000 #4000
	LABELITEM "schriftinhalt"

	# Strasse
	CLASS
		EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'linksbündig' AND '[ver]' eq 'Basis')
		#NAME 'Straße'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION ur # linksbündig/Basis
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
		#NAME 'Straße'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION cc # zentrisch/Mitte
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Strasse') 
		NAME 'Straße'
		STYLE
			SYMBOL "point" SIZE 1 MINSIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION uc # zentrisch/Basis
			COLOR 0 0 0
			FORCE true
		END
	END

	# Weg
	CLASS
		EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'linksbündig' AND '[ver]' eq 'Basis')
		#NAME 'Weg'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
			TYPE TRUETYPE FONT "arial"
			ANGLE [winkel] 
			POSITION ur # linksbündig/Basis
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
		#NAME 'Weg'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
			TYPE TRUETYPE FONT "arial"
			ANGLE [winkel] POSITION cc # zentrisch/Mitte
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Weg')
		NAME 'Weg'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
			TYPE TRUETYPE FONT "arial"
			ANGLE [winkel] POSITION uc # zentrisch/Basis
			COLOR 0 0 0
			FORCE true
		END
	END

	# Platz 
	CLASS
		#EXPRESSION 'Platz'
		EXPRESSION ('[art]' eq 'Platz' AND '[ver]' eq 'Mitte')
		#NAME 'Platz'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 28 MAXSIZE 88 # 10 7 22
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION cc # zentrisch/Mitte
			COLOR 0 0 90
			FORCE true
		END
	END
	CLASS
		#EXPRESSION 'Platz'
		EXPRESSION ('[art]' eq 'Platz')
		NAME 'Platz'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 28 MAXSIZE 88 # 10 7 22
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION uc # zentrisch/Basis
			COLOR 0 0 90
			FORCE true
		END
	END

	# Klassifikation
	CLASS
		#EXPRESSION 'BezKlassifizierungStrasse'
		EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse' AND '[hor]' eq 'linksbündig')
		#NAME 'Klassifizierung'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 44 MINSIZE 32 MAXSIZE 88 # 11 8 22
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION ur # linksbündig/Basis
			COLOR 0 90 0
			FORCE true
		END
	END
	CLASS
		#EXPRESSION 'BezKlassifizierungStrasse'
		EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse')
		NAME 'Klassifizierung'
		STYLE
			SYMBOL "point" SIZE 1 MINSIZE 1
		END
		LABEL
			SIZE 44 MINSIZE 32 MAXSIZE 88 # 11 8 22
			TYPE TRUETYPE FONT "arialbold"
			ANGLE [winkel] POSITION uc # zentrisch/Basis
			COLOR 0 90 0
			FORCE true
		END
	END
END
LAYER
	NAME "ap_lto_stra"
	GROUP "praesentation"
	TYPE LINE
	REQUIRES "[ap_pto_stra]" # P- und L gemeinsam
	STATUS DEFAULT # automatisch mit
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "the_geom from (SELECT * FROM pp_strassenname_l) as foo using unique gid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Straßen _"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 #50
	MAXSCALEDENOM 1000 #4000
	LABELITEM "schriftinhalt"

	# Strasse
	CLASS
		EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'linksbündig' AND '[ver]' eq 'Basis')
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			POSITION ur # linksbündig/Basis
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			POSITION cc # zentrisch/Mitte
			COLOR 0 0 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'Strasse') 
		NAME 'Straße'
		STYLE
			SYMBOL "point" SIZE 1 MINSIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 24 MAXSIZE 80 # 10 6 20
			TYPE TRUETYPE FONT "arialbold"
			POSITION uc # zentrisch/Basis
			COLOR 0 0 0
			FORCE true
		END
	END

	# Weg
	CLASS
		EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'linksbündig' AND '[ver]' eq 'Basis')
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
			TYPE TRUETYPE FONT "arial"
			POSITION ur # linksbündig/Basis
			COLOR 0 0 0
			FORCE true
		END
	END
	#CLASS
	#	EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
	#	STYLE
	#		SYMBOL "point" SIZE 1
	#	END
	#	LABEL
	#		SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
	#		TYPE TRUETYPE FONT "arial"
	#		POSITION cc # zentrisch/Mitte
	#		COLOR 0 0 0
	#		FORCE true
	#	END
	#END
	CLASS
		EXPRESSION ('[art]' eq 'Weg')
		NAME 'Weg'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 32 MINSIZE 20 MAXSIZE 64 # 8 5 16
			TYPE TRUETYPE FONT "arial"
			POSITION uc # zentrisch/Basis
			COLOR 0 0 0
			FORCE true
		END
	END

	# Platz 
#	CLASS
#		EXPRESSION ('[art]' eq 'Platz' AND '[ver]' eq 'Mitte')
#		STYLE
#			SYMBOL "point" SIZE 1
#		END
#		LABEL
#			SIZE 40 MINSIZE 28 MAXSIZE 88 # 10 7 22
#			TYPE TRUETYPE FONT "arialbold"
#			POSITION cc # zentrisch/Mitte
#			COLOR 0 0 90
#			FORCE true
#		END
#	END
#	CLASS
#		EXPRESSION ('[art]' eq 'Platz')
#		NAME 'Platz'
#		STYLE
#			SYMBOL "point" SIZE 1
#		END
#		LABEL
#			SIZE 40 MINSIZE 28 MAXSIZE 88 # 10 7 22
#			TYPE TRUETYPE FONT "arialbold"
#			POSITION uc # zentrisch/Basis
#			COLOR 0 0 90
#			FORCE true
#		END
#	END

	# Klassifikation
	CLASS
		EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse' AND '[hor]' eq 'linksbündig')
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 44 MINSIZE 32 MAXSIZE 88 # 11 8 22
			TYPE TRUETYPE FONT "arialbold"
			POSITION ur # linksbündig/Basis
			COLOR 0 90 0
			FORCE true
		END
	END
	CLASS
		EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse')
		NAME 'Klassifizierung'
		STYLE
			SYMBOL "point" SIZE 1 MINSIZE 1
		END
		LABEL
			SIZE 44 MINSIZE 32 MAXSIZE 88 # 11 8 22
			TYPE TRUETYPE FONT "arialbold"
			POSITION uc # zentrisch/Basis
			COLOR 0 90 0
			FORCE true
		END
	END
END

LAYER
	NAME "ap_pto" # Rest
	GROUP "praesentation"
	TYPE POINT
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA "wkb_geometry from (SELECT * FROM ap_pto_rest) as foo using unique ogc_fid using SRID=25832"
	METADATA
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
		wms_title "Beschriftung"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 0
	MAXSCALEDENOM 1250 #5000
	LABELITEM "schriftinhalt"
	CLASSITEM "art"
	CLASS
		NAME "Gewanne"
		EXPRESSION 'Gewanne'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL # waagerecht
			SIZE 44 MINSIZE 36 MAXSIZE 72 # 11 9 18
			TYPE TRUETYPE FONT "arial"
			POSITION cc
			COLOR 0 0 0
		END
	END
	CLASS
		NAME "freier Text"
		EXPRESSION 'FreierText'
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 10 MINSIZE 8 MAXSIZE 16
			TYPE TRUETYPE FONT "arial"
			ANGLE [winkel]
			POSITION cc
			COLOR 0 0 0
			WRAP "/n" MAXLENGTH 15
		END
	END
	CLASS
		NAME "sonst. Beschriftung" # Rest
		EXPRESSION /./
		STYLE
			SYMBOL "point" SIZE 1
		END
		LABEL
			SIZE 40 MINSIZE 32 MAXSIZE 64 # 10 8 16
			TYPE TRUETYPE FONT "arial"
			ANGLE [winkel]
			POSITION cc
			COLOR 0 0 0
			WRAP "/n" MAXLENGTH 15
		END
	END
END

# ap_ppo fehlt noch

## Gruppe  G r e n z e n
LAYER
	NAME 'pol_Grenze'
	GROUP 'grenzen'
	TYPE LINE
	STATUS ON
	METADATA
		wms_group_title "Grenzen"
		wms_title "Politische Grenze"
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 62 # 250
	MAXSCALEDENOM 3000 #12000
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832'
	CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B. {3000,7106}
	CLASS
		NAME 'Bundeslandgrenze'
		EXPRESSION /7102/
		STYLE
			COLOR 255 255 255
			WIDTH 28 MINWIDTH 28 MAXWIDTH 28 # 7 7 7
		END
		STYLE
			COLOR 242 128 255
			WIDTH 28 MINWIDTH 28 MAXWIDTH 28 # 7 7 7
			PATTERN 10 60 20 60 108 48 108 60 END #5 15 5 15 27 12 27 15
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter	
		END
	END
	CLASS
		NAME 'Regierungsbezirksgrenze'
		EXPRESSION /7103/
		STYLE
			COLOR 255 255 255
			WIDTH 5 MINWIDTH 5 MAXWIDTH 5
		END
		STYLE
			COLOR 242 128 255
			WIDTH 5 MINWIDTH 5 MAXWIDTH 5 # 5 5 5
			PATTERN 16 60 16 60 100 40 100 52 END #4 15 4 15 25 10 25 13
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter	
		END
	END
	CLASS
		NAME 'Kreisgrenze'
		EXPRESSION /7104/
		STYLE
			COLOR 255 255 255
			WIDTH 20 MINWIDTH 20 MAXWIDTH 20 # 5 5 5
		END
		STYLE
			COLOR 242 128 255 
			WIDTH 20 MINWIDTH 20 MAXWIDTH 20 # 5 5 5
			PATTERN 93 50 20 60 20 50 END # 23.33 12.5 5 15 5 12.5
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter	
		END
	END
	CLASS
		NAME 'Gemeindegrenze'
		EXPRESSION /7106/
		STYLE
			COLOR 255 255 255
			WIDTH 16 MINWIDTH 16 MAXWIDTH 16 #4 4 4
		END
		STYLE
			COLOR 242 128 255
			WIDTH 16 MINWIDTH 16 MAXWIDTH 16 # 4 4 4
			PATTERN 67 33 13.3 33 END # 16.67 8.33 3.33 8.33
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter	
		END
	END
END
LAYER
	NAME 'gemarkungsrenze'
	GROUP 'grenzen'
	TYPE LINE
	STATUS ON
	METADATA
		wms_title "Gemarkungsrenze"
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 50 # 200
	MAXSCALEDENOM 2500 # 10000
	SYMBOLSCALEDENOM 250 # 1000
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832'
	CLASS
		NAME 'Gemarkungsgrenze'
		STYLE
			COLOR 254 254 254 # heller Untergrund (Flurstücksgrenze übermalen)
			WIDTH 16 MINWIDTH 12 MAXWIDTH 24 # 4 3 6
		END
		STYLE
			COLOR 242 128 255
			WIDTH 16 MINWIDTH 12 MAXWIDTH 24 # 4 3 6
			PATTERN 67 33 13.3 33 END # 16.67 8.33 3.33 8.33
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter
		END
	END
END
LAYER
	NAME 'flurgrenze'
	GROUP 'grenzen'
	TYPE LINE
	METADATA
		wms_title "Flurgrenze"
		wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
	END
	#PROJECTION "init=epsg:25832" END
	#EXTENT 349000 5529000 356000 5533000
	MINSCALEDENOM 12 # 50
	MAXSCALEDENOM 1250 #5000
	SYMBOLSCALEDENOM 250 #1000
	CONNECTIONTYPE POSTGIS
	CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
	PROCESSING "CLOSE_CONNECTION=DEFER"
	DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832'
	CLASS
		NAME 'Flurgrenze'
		#STYLE
		#	COLOR 254 254 254
		#	WIDTH 12 MINWIDTH 8 MAXWIDTH 16 # 3 2 4
		#END
		STYLE
			COLOR 242 128 255
			WIDTH 12 MINWIDTH 8 MAXWIDTH 16 # 3 2 4
			PATTERN 67 33 13 40 13 40 13 33 END #16.67 8.33 3.33 10 3.33 10 3.33 8.33
			LINECAP butt
			LINEJOINMAXSIZE 80 #20
			LINEJOIN miter
		END
	END
END

LAYER
	NAME "copyright"
	STATUS ON # DEFAULT
	TYPE annotation
	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"
	END
	FEATURE
		POINTS 0 0 END
		# hier die individuelle Vertragsnummer einsetzen
		TEXT 'Copyright Geobasisdaten Liegenschaftskataster Kreis __'
	END
	CLASS
		LABEL
			SIZE small # x4 ?
			POSITION ul
			COLOR 50 50 50
			FORCE TRUE
			STYLE # bbox ms 6.0
				GEOMTRANSFORM 'labelpoly'
				COLOR 250 250 250
			END
		END
	END
END
END