source: trunk/umn/alkis_n/alkis_n_muster.map @ 369

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

# Stand:
#  2016-05-03 
#  2016-05-09 Kommentare
#  2016-05-11 Copyright-Layer, "OPACITY 0" auskommentiert, FS-Nr besser freigestellt
#             Template auf Baurecht.
#             Die Templates fuer Feature-Info entnehmen den Parameter "gkz" dem Mapfile-Namen vor ".map"
#  2016-05-12 Bei Klassen mit Symbolnummer als Name den Name auskommentiert um die Legende zu entschÀrfen.
#  2016-05-19 Maxscaledenom ÃŒberarbeiten, Abgkeich mit SW-Variante
#  2016-05-20 Legende unterdrÃŒcken
#  2016-05-23 FlurstÃŒcke: 2stufige Gruppierung raus. 
#             "wms_enable_request" pauschal "*" im Root. 
#             Das macht sonst Probleme bei FeatureInfo wenn nur auf einzelnen Layern.

# ToDo: 
# - Layer oder Gruppe fÌr SchÀtzungsklassen
# - In "GebÀude / Beschriftungen" werden ausser der Haunummer auch noch Buchstaben sichtbar, z.T. Ìberlappend
#   Die sollten getrennt schaltbar sein.
#
### Erlaeuterungen:
## SVG:
# Die SVG-Symbole sind aus dem norBIT-ALKIS-Plugin zu entnehmen:
# Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\
# Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ 
#
## MapProxy:
#  Layer fÌr FlÀche: LAYERS=fh,fe,fb,fw,fs,fi,fv
#  Layer fÃŒr Strichzeichnung: LAYERS=gh,bh,ge,pe,be,gb,bb,gt,lt,pt,bt,gw,lw,pw,bw,gs,ps,bs,gi,li,pi,bi,gv,lv,pv,bv,fg,gg,lg,pg,bg,gff,lff,pff,lfn,bfn,bl
#
## Layername:
# Der aus QGIS generierte Layername ("l" + lfd.Nr) ist unterschiedlich je Mandant, 
# und wird daher zur Vereinheitlichung ersetzt durch die Buchstaben fÃŒr "Typ" und "Gruppe" aus der unten stehenden Liste.
#
## Layer und Klassen:
# Dies Muster-Mapfile wurde generiert auf der Basis von NBA-Daten fÃŒr einige Staedte in Ost-Westfalen.
# FÌr den Einsatz in anderen Kreisen und anderen Regionen ist dies durch lokale Layer und Klassen zu ergÀnzen.
#
## HQ-Print:
# Es wird keine _4-Mapdatei mehr fÃŒr High-Quality-Print mit 288dpi aufbereitet.
# Statt dessen wird fÌr den HQ-Print der GetMap-Call ergÀnzt um den Parameter: "&map.resolution=288"
# Beispiel fÃŒr Mapbender 2.7:
# UPDATE gui_element_vars SET var_value = '[{"pattern": ".map&",
#   "replacement": {"144": ".map&map.resolution=144&", "288": ".map&map.resolution=288&"}}]' 
#   WHERE fkey_e_id = 'printPDF' AND var_name  ='highqualitymapfiles';
#
## Legende
# Class-Name ohne sprechenden Namen (Signaturnummer in Klammer) sind mit einfachem "#" auskommentiert.
# Class-Name, die derzeit keine schöne Legende erzeugen, sind mit "#- ' auskommentiert und lassen
#   sich somit durch Edit/Replace alle wieder aktivieren.

## Typen:
# g Grenzen
# f FlÀchen
# l Linien
# p Punkte
# b Beschriftungen

## Gruppen:
# h     Friedhöfe
# e     Vegetation
# b     WohnbauflÀchen
# t     Topographie
# w     GewÀsser
# s     Sport und Freizeit
# i     Industrie und Gewerbe
# v     Verkehr
# g     GebÀude
# r     Rechtliche Festlegungen
# f     FlurstÃŒcke
# fn    FlurstÃŒcke/Nummern
# ff    FlurstÌcke/FlÀchen
# p     Politische Grenzen
# l     Lagebezeichnungen

### Generierte Layer-Reihenfolge (340) (150) (230)
##                      */ FlÀchen + Grenzen
# fh Friedhöfe / FlÀchen
# fe Vegetation / FlÀchen
# fb WohnbauflÀchen / FlÀchen
# gt Topographie / Grenzen
# ge Vegetation / Grenzen
# gh Friedhöfe / Grenzen
# gb WohnbauflÀchen / Grenzen
# fw GewÀsser / FlÀchen
# fs Sport und Freizeit / FlÀchen
# gs Sport und Freizeit / Grenzen
# gw GewÀsser / Grenzen
# fi Industrie und Gewerbe / FlÀchen
# gi Industrie und Gewerbe / Grenzen
# fv Verkehr / FlÀchen
# 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 "alkis"
        STATUS ON
        #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log"
        EXTENT ..
        PROJECTION "init=epsg:25832" END
        MAXSIZE 8400 # reicht fuer 288 dpi auf DIN-A2
        DEFRESOLUTION 72
        SYMBOLSET "symbols.sym" # ausgelagert, ursprÃŒnglich hier inline generiert
        FONTSET "/opt/gdi/alkisn/fonts/fonts.txt"
        UNITS METERS
        WEB
                METADATA
                        wms_title "ALKIS"
                        wms_abstract "ALKIS *gkz* farbige Variante - 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/alkis*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"

                        # theoretisch: fÃŒr ALLE Layer die Aufrufe "GetMap" und "GetCapabilities" zulassen.
                        # dann bei einzelnen Layern zusÀtzlich auch "GetLegendGraphic" oder "GetFeatureInfo" erlauben.
                #       wms_enable_request "GetMap GetCapabilities" 

                        # praktisch: Bei Feature-Info auf Layer "gff" (Grenzen FlurstÃŒcke) antwortet der WMS
                        # dass der Layer nicht erlaubt ist. Also alles pauschal erlauben.
                        wms_enable_request "*"

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

        ## Die Legende ist nicht brauchbar.
        ## 1. Die Legende von ALKIS ist sowieso sehr umfangreich. Das fÃŒllt mehrere Seiten.
        ## 2. Es werden zum Teil mehrere ALKIS-Objekt-Arten in einer Klasse dieses Mapfiles generiert, 
        ##    indem Darstellungsunterschiede aus Datenbank-Felder geholt werden.
        ##    Das könnte die Legende nicht abbilden.
        ## 3. Einige Klassen haben keine Namen sondern Symbolnummern oder Àhnliches.
        ## 4. Die Sybole werden so gigantisch gezeichnet, dass sie die Einbindung des WMS im QGIS verhindern.
        LEGEND
                STATUS ON
                KEYSIZE 32 16
                TRANSPARENT ON
                KEYSPACING 5 5
                LABEL
                        TYPE TRUETYPE
                        FONT 'arial'
                        SIZE 11
                        COLOR 1 1 1
                END
        END

        ## Layer der Typen FlÀchen + Grenzen

        LAYER NAME "fh" # FriedHöfe / 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='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 25000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Friedhöfe"
                        wms_title "FlÀchen"
                        #wms_enable_request "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[1405]"
                        EXPRESSION "1405"
                        STYLE
                                COLOR 224 255 216
                        END
                END
        END

        LAYER 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_flaeche AS signaturnummer FROM po_polygons WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 25000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Vegetation"
                        wms_title "FlÀchen"
                        #wms_enable_request "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                        NAME "Brachland, Heide, Moor, Sumpf, Torf"
                        EXPRESSION "1404"
                        STYLE
                                COLOR 242 234 232
                        END
                END
                CLASS
                        NAME "Garten"
                        EXPRESSION "1406"
                        STYLE
                                COLOR 234 255 211
                        END
                END
                CLASS
                #       NAME "(1409)"
                        EXPRESSION "1409"
                        STYLE
                                COLOR 255 247 191
                        END
                END
                CLASS
                        NAME "Wald"
                        EXPRESSION "1414"
                        STYLE
                                COLOR 216 255 216
                        END
                END
                CLASS
                #       NAME "(1561)"
                        EXPRESSION "1561"
                        STYLE
                                COLOR 234 255 211
                        END
                END
        END

        LAYER 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='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 500000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/WohnbauflÀchen"
                        wms_title "FlÀchen"
                        #wms_enable_request "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                        NAME "WohnbauflÀche"
                        EXPRESSION "1401"
                        STYLE
                                COLOR 255 234 244
                        END
                END
        END

        LAYER NAME "gt" # Topographie / 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='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                        wms_title "Grenzen"
                        #wms_enable_request "GetMap GetCapabilities"
                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 81 0 0
                                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"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "(rn1560)"
                        EXPRESSION "rn1560"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 255 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1561)"
                        EXPRESSION "rn1561"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 255 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1563)"
                        EXPRESSION "rn1563"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "[2515]"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Wald"
                        EXPRESSION "2517"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 255 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER NAME "gh" # FriedHöfe / 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='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Friedhöfe"
                        wms_title "Grenzen"
                        #wms_enable_request "GetCapabilities GetMap"
                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 "gb" # WohnBauflÀ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='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/WohnbauflÀchen"
                        wms_title "Grenzen"
                        #wms_enable_request "GetCapabilities GetMap"
                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 "fw" # GewÀsser / 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"
                #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 "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #-      NAME "GewÀsser"
                        EXPRESSION "1410"
                        STYLE
                                COLOR 226 255 255
                        END
                END
                CLASS
                #       NAME "(1523)"
                        EXPRESSION "1523"
                        STYLE
                                COLOR 226 255 255
                        END
                END
        END

        LAYER NAME "fs" # Sport und Freizeit / 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='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 25000 # 500000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Sport und Freizeit"
                        wms_title "FlÀchen"
                        #wms_enable_request "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[1405]"
                        EXPRESSION "1405"
                        STYLE
                                COLOR 224 255 216
                        END
                END
                CLASS
                        NAME "Überdachte TribÃŒne"
                        EXPRESSION "1519"
                        STYLE
                                COLOR 255 127 127
                        END
                END
                CLASS
                        NAME "Hart-, Rasenplatz, Spielfeld"
                        EXPRESSION "1520"
                        STYLE
                                COLOR 216 255 216
                        END
                END
                CLASS
                        NAME "Schwimmbecken"
                        EXPRESSION "1526"
                        STYLE
                                COLOR 226 255 255
                        END
                END
                CLASS
                        NAME "Rennbahn, Laufbahn, GelÀuf"
                        EXPRESSION "1521"
                        STYLE
                                COLOR 255 234 244
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetMap GetCapabilities"
                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 81 0 0
                                PATTERN 2.00 1.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Hart-, Rasenplatz, Spielfeld"
                        EXPRESSION "rn1520"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 81 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "[1524]"
                        EXPRESSION "rn1524"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 81 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Schwimmbecken"
                        EXPRESSION "rn1526"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Rennbahn, Laufbahn, GelÀuf"
                        EXPRESSION "rn1521"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 81 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetMap GetCapabilities"
                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 81 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2520)"
                        EXPRESSION "2520"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                PATTERN 4.00 2.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "GewÀsser"
                        EXPRESSION "2518"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1523)"
                        EXPRESSION "rn1523"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Fischtreppe, Sicherheitstor, Sperrwerk"
                        EXPRESSION "rn1548"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Unterirdisches GewÀsser"
                        EXPRESSION "rn1550"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER 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 "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[1401]"
                        EXPRESSION "1401"
                        STYLE
                                COLOR 255 234 244
                        END
                END
                CLASS
                #       NAME "[1403]"
                        EXPRESSION "1403"
                        STYLE
                                COLOR 237 237 237
                        END
                END
                CLASS
                #       NAME "[1510]"
                        EXPRESSION "1510"
                        STYLE
                                COLOR 242 234 232
                        END
                END
                CLASS
                #       NAME "[1305]"
                        EXPRESSION "1305"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                #       NAME "[1501]"
                        EXPRESSION "1501"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Mast"
                        EXPRESSION "1306"
                        STYLE
                                COLOR 204 204 204
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn2504)"
                        EXPRESSION "rn2504"
                        STYLE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn2521)"
                        EXPRESSION "rn2521"
                        STYLE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "VorratsbehÀlter, Speicherbauwerk unterirdisch"
                        EXPRESSION "rn1321"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "[rn1501]"
                        EXPRESSION "rn1501"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.35
                                WIDTH 0.35
                        END
                END
                CLASS
                #       NAME "[rn1305]"
                        EXPRESSION "rn1305"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Mast"
                        EXPRESSION "rn1306"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER NAME "fv" # Verkehr / 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='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                MAXSCALEDENOM 25000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                        wms_title "FlÀchen"
                        #wms_enable_request "GetMap GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                        NAME "BegleitflÀche"
                        EXPRESSION "1406"
                        STYLE
                                COLOR 234 255 211
                        END
                END
                CLASS
                        NAME "FußgÀngerzone"
                        EXPRESSION "1414"
                        STYLE
                                COLOR 216 255 216
                        END
                END
                CLASS
                        NAME "Weg"
                        EXPRESSION "1542"
                        STYLE
                                COLOR 247 247 239
                        END
                END
                CLASS
                        NAME "BrÃŒcke, Hochbahn/-straße"
                        EXPRESSION "1530"
                        STYLE
                                COLOR 255 255 255
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 81 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1536)"
                        EXPRESSION "rn1536"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1330)"
                        EXPRESSION "rn1330"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1320)"
                        EXPRESSION "rn1320"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "BrÃŒcke, Hochbahn/-straße"
                        EXPRESSION "rn1530"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                PATTERN 2.00 1.00 END
                                SIZE 0.5
                                WIDTH 0.5
                        END
                END
                CLASS
                #       NAME "(rn1531)"
                        EXPRESSION "rn1531"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                PATTERN 1.00 0.50 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Tunnel, UnterfÃŒhrung"
                        EXPRESSION "rn1533"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                PATTERN 0.50 1.50 END
                                SIZE 0.5
                                WIDTH 0.5
                        END
                END
        END

        LAYER 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 "GetMap 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 255 127 127
                        END
                END
                CLASS
                        NAME "Anderes GebÀude"
                        EXPRESSION "1304"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "WohngebÀude"
                        EXPRESSION "1301"
                        STYLE
                                COLOR 153 153 153
                        END
                END
                CLASS
                #       NAME "(2510)"
                        EXPRESSION "2510"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Aussichtsturm"
                        EXPRESSION "1501"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Mauer"
                        EXPRESSION "1305"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Brunnen"
                        EXPRESSION "1525"
                        STYLE
                                COLOR 226 255 255
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 "(2512)"
                        EXPRESSION "2512"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "GebÀude unter der ErdoberflÀche"
                        EXPRESSION "2032"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn2510)"
                        EXPRESSION "rn2510"
                        STYLE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Anderes GebÀude"
                        EXPRESSION "2031"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 2.00 1.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Öffentliches GebÀude"
                        EXPRESSION "2505"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1305)"
                        EXPRESSION "rn1305"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(rn1317)"
                        EXPRESSION "rn1317"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 2.00 1.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Anderes GebÀude"
                        EXPRESSION "rn1501"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.35
                                WIDTH 0.35
                        END
                END
                CLASS
                #       NAME "(2507)"
                        EXPRESSION "2507"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "aufgestÀndert"
                        EXPRESSION "2508"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 2.00 1.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Schornstein im GebÀude"
                        EXPRESSION "2513"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.25
                                WIDTH 0.25
                        END
                END
                CLASS
                #-      NAME "Turm im GebÀude"
                        EXPRESSION "2514"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.35
                                WIDTH 0.35
                        END
                END
                CLASS
                #       NAME "(rn1525)"
                        EXPRESSION "rn1525"
                        STYLE
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 204 204
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER 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 "GetMap GetFeatureInfo"
                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 255 127 127
                                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"
                #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 GetLegendGraphic"
                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
                        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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 81 0 0
                                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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 0 204 204
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2593)"
                        EXPRESSION "2593"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 204 204
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 4.00 2.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2595)"
                        EXPRESSION "2595"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 204 204
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 1.00 2.00 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2560)"
                        EXPRESSION "2560"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 204 204
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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 81 0 0
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 2.00 3.20 END
                                SIZE 0.35
                                WIDTH 0.35
                        END
                END
                CLASS
                #       NAME "(2525)"
                        EXPRESSION "2525"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2527)"
                        EXPRESSION "2527"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "(2530)"
                        EXPRESSION "2530"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.505
                        END
                        STYLE
                                COLOR 127 127 127
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                SIZE 0.5
                                WIDTH 0.5
                        END
                END
                CLASS
                #       NAME "(2506)"
                        EXPRESSION "2506"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 0.35 0.35 END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Widerlager"
                        EXPRESSION "2533"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 127 127 127
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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"
                        #wms_enable_request "GetCapabilities GetMap"
                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"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                # alle CLASS doppelt generiert!
                CLASS
                #-      NAME "Flurgrenze"
                        EXPRESSION "2012"
                        STYLE # Grundierung
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 1.01
                        END
                        STYLE # eckige Enden
                                COLOR 242 127 255
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 5.00 11.00 END
                                SIZE 1
                        END
                        STYLE # 0+ROUND macht Punkte
                                COLOR 242 127 255
                                INITIALGAP 7.5
                                LINEJOIN ROUND
                                PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END
                                SIZE 1
                        END
                END
                CLASS
                #-      NAME "Gemarkungsgrenze"
                        EXPRESSION "2014"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 1.01
                        END
                        STYLE
                                COLOR 242 127 255
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 5.00 8.00 END
                                SIZE 1
                        END
                        STYLE
                                COLOR 242 127 255
                                INITIALGAP 7.5
                                LINEJOIN ROUND
                                PATTERN 0.00 3.00 0.00 10.00 END
                                SIZE 1
                        END
                END
                CLASS
                #-      NAME "Gemeindegrenze"
                        EXPRESSION "2022"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 1.01
                        END
                        STYLE
                                COLOR 242 127 255
                                LINECAP SQUARE
                                LINEJOIN ROUND
                                PATTERN 5.00 5.00 END
                                SIZE 1
                        END
                        STYLE
                                COLOR 242 127 255
                                INITIALGAP 7.5
                                LINEJOIN ROUND
                                PATTERN 0.00 10.00 END
                                SIZE 1
                        END
                END
        END

        LAYER 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
                # Tipp: Im Client verstecken
                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_enable_request "GetCapabilities GetMap"
                        # Dieser doppelt gruppierte Layer erzeugt im Mapbender 2.7 / Mapserver 7.0.1 immer noch 
                        # einen Legenden-Eintrag "kaputte Grafik" obwohl doppelt deaktiviert.
                        # Lösung: Doppelte Gruppe auflösen. Mit REQUIRES koppeln.
                        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"
                        #wms_enable_request "GetCapabilities GetMap"
                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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3020_1"
                        END
                END
                CLASS
                #-      NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"
                        EXPRESSION "3022"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3022_1"
                        END
                END
                CLASS
                #-      NAME "FlurstÃŒcksÃŒberhaken"
                        EXPRESSION "3010"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 1
                                SIZE 2.2509
                                SYMBOL "norGIS_alkis3010_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 4.056
                                SYMBOL "norGIS_alkis3539_1"
                        END
                END
                CLASS
                #       NAME "(3527)"
                        EXPRESSION "3527"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.8294
                                SYMBOL "norGIS_alkis3527_1"
                        END
                END
                CLASS
                #-      NAME "Umformer"
                        EXPRESSION "3521"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.6935
                                SYMBOL "norGIS_alkis3521_1"
                        END
                END
                CLASS
                #-      NAME "Spielcasino"
                        EXPRESSION "3308"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.1437
                                SYMBOL "norGIS_alkis3308_1"
                        END
                END
                CLASS
                #-      NAME "Denkmal"
                        EXPRESSION "3532"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 2
                                SIZE 4.866
                                SYMBOL "norGIS_alkis3532_1"
                        END
                END
                CLASS
                #-      NAME "Polizei"
                        EXPRESSION "3324"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3324_1"
                        END
                END
                CLASS
                #-      NAME "Post"
                        EXPRESSION "3312"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3312_1"
                        END
                END
                CLASS
                #-      NAME "Hallenbad"
                        EXPRESSION "3334"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3334_1"
                        END
                END
                CLASS
                #-      NAME "Kapelle"
                        EXPRESSION "3318"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.0137
                                SYMBOL "norGIS_alkis3318_1"
                        END
                END
                CLASS
                #-      NAME "Feuerwehr"
                        EXPRESSION "3326"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3326_1"
                        END
                END
                CLASS
                #-      NAME "Kirche"
                        EXPRESSION "3316"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 10.0381
                                SYMBOL "norGIS_alkis3316_1"
                        END
                END
                CLASS
                #-      NAME "Kindergarten"
                        EXPRESSION "3323"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3323_1"
                        END
                END
                CLASS
                #-      NAME "Toilette"
                        EXPRESSION "3311"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3311_1"
                        END
                END
                CLASS
                #-      NAME "Kino"
                        EXPRESSION "3306"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3306_1"
                        END
                END
                CLASS
                #-      NAME "Tiefgarage"
                        EXPRESSION "3336"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3336_1"
                        END
                END
                CLASS
                #-      NAME "Bank"
                        EXPRESSION "3300"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.189
                                SYMBOL "norGIS_alkis3300_1"
                        END
                END
                CLASS
                #-      NAME "Brunnen / Gasquelle, Mofette / Heilquelle"
                        EXPRESSION "3529"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 2.6965
                                SYMBOL "norGIS_alkis3529_1"
                        END
                END
                CLASS
                #-      NAME "Hotel"
                        EXPRESSION "3302"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3302_1"
                        END
                END
                CLASS
                #-      NAME "GaststÀtte"
                        EXPRESSION "3305"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3305_1"
                        END
                END
                CLASS
                #-      NAME "Meilenstein, historischer Grenzstein"
                        EXPRESSION "3536"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 1
                                SIZE 2.8688
                                SYMBOL "norGIS_alkis3536_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3430_1"
                        END
                END
                CLASS
                #-      NAME "Fußweg"
                        EXPRESSION "3424"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3424_1"
                        END
                END
                CLASS
                #-      NAME "Haltepunkt"
                        EXPRESSION "3578"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3578_1"
                        END
                END
                CLASS
                #-      NAME "Parkplatz"
                        EXPRESSION "3432"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.4836
                                SYMBOL "norGIS_alkis3432_1"
                        END
                END
                CLASS
                #-      NAME "Radweg"
                        EXPRESSION "3426"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3426_1"
                        END
                END
                CLASS
                #-      NAME "Rad- und Fußweg"
                        EXPRESSION "3428"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3428_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3446_1"
                        END
                END
                CLASS
                #-      NAME "Sumpf"
                        EXPRESSION "3478"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.065
                                SYMBOL "norGIS_alkis3478_1"
                        END
                END
                CLASS
                #-      NAME "Garten"
                        EXPRESSION "3421"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.8127
                                SYMBOL "norGIS_alkis3421_1"
                        END
                END
                CLASS
                #-      NAME "Streuobstacker"
                        EXPRESSION "3440"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3440_1"
                        END
                END
                CLASS
                #-      NAME "Quelle"
                        EXPRESSION "3613"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.0197
                                SYMBOL "norGIS_alkis3613_1"
                        END
                END
                CLASS
                #-      NAME "Nadelbaum"
                        EXPRESSION "3597"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 2
                                SIZE 4.8638
                                SYMBOL "norGIS_alkis3597_1"
                        END
                END
                CLASS
                #-      NAME "Obstbaumplantage"
                        EXPRESSION "3452"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3452_1"
                        END
                END
                CLASS
                #-      NAME "Nadelwald"
                        EXPRESSION "3460"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.8491
                                SYMBOL "norGIS_alkis3460_1"
                        END
                END
                CLASS
                #-      NAME "Unland"
                        EXPRESSION "3480"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.0107
                                SYMBOL "norGIS_alkis3480_1"
                        END
                END
                CLASS
                #-      NAME "Mischwald"
                        EXPRESSION "3462"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3462_1"
                        END
                END
                CLASS
                #-      NAME "Gras"
                        EXPRESSION "3413"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 0.4305
                                SYMBOL "norGIS_alkis3413_1"
                        END
                END
                CLASS
                #-      NAME "ZierflÀche"
                        EXPRESSION "3605"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 2.4245
                                SYMBOL "norGIS_alkis3605_1"
                        END
                END
                CLASS
                #-      NAME "Streuobstwiese"
                        EXPRESSION "3441"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3441_1"
                        END
                END
                CLASS
                #-      NAME "Laubwald"
                        EXPRESSION "3458"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.3763
                                SYMBOL "norGIS_alkis3458_1"
                        END
                END
                CLASS
                #-      NAME "Laubbaum"
                        EXPRESSION "3599"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 2
                                SIZE 4.567
                                SYMBOL "norGIS_alkis3599_1"
                        END
                END
                CLASS
                #-      NAME "Heide"
                        EXPRESSION "3474"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.9261
                                SYMBOL "norGIS_alkis3474_1"
                        END
                END
                CLASS
                #-      NAME "Mischwald"
                        EXPRESSION "3470"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.8718
                                SYMBOL "norGIS_alkis3470_1"
                        END
                END
                CLASS
                #-      NAME "Busch, Hecke, Knick"
                        EXPRESSION "3601"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.4275
                                SYMBOL "norGIS_alkis3601_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3619_1"
                        END
                END
                CLASS
                #-      NAME "FließgewÀsser"
                        EXPRESSION "3488"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3488_1" # Pfeil
                # FEHLER: Bei Drehung wird oben/unten abgeschnitten.
                # Siehe: https://github.com/mapserver/mapserver/pull/5264
                # http://freegis.org/pipermail/mapserver-de/2016-April/004793.html
                        END
                END
                CLASS
                #-      NAME "GewÀsser"
                        EXPRESSION "3490"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.3369
                                SYMBOL "norGIS_alkis3490_1"
                        END
                END
                CLASS
                #-      NAME "Quelle"
                        EXPRESSION "3613"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.0197
                                SYMBOL "norGIS_alkis3613_1"
                        END
                END
                CLASS
                #       NAME "(3596)"
                        EXPRESSION "3596"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 1
                                SIZE 3.6936
                                SYMBOL "norGIS_alkis3596_1"
                        END
                END
                CLASS
                #-      NAME "FließgewÀsser, nicht stÀndig Wasser fÃŒhrend"
                        EXPRESSION "3621"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3621_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 5.2343
                                SYMBOL "norGIS_alkis3401_1"
                        END
                END
                CLASS
                #-      NAME "Umformer"
                        EXPRESSION "3521"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.6935
                                SYMBOL "norGIS_alkis3521_1"
                        END
                END
                CLASS
                #-      NAME "Antenne / Funkmast"
                        EXPRESSION "3506"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 2
                                SIZE 5.2585
                                SYMBOL "norGIS_alkis3506_1"
                        END
                END
                CLASS
                #-      NAME "VorratsbehÀlter"
                        EXPRESSION "3522"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3522_1"
                        END
                END
                CLASS
                #-      NAME "Schornstein, Schlot, Esse"
                        EXPRESSION "3508"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.3763
                                SYMBOL "norGIS_alkis3508_1"
                        END
                END
                CLASS
                #-      NAME "Mast"
                        EXPRESSION "3504"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 2.1979
                                SYMBOL "norGIS_alkis3504_1"
                        END
                END
                CLASS
                #-      NAME "Windrad"
                        EXPRESSION "3501"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 3
                                SIZE 6.8565
                                SYMBOL "norGIS_alkis3501_1"
                        END
                END
                CLASS
                #-      NAME "Laufkran, BrÃŒckenlaufkran"
                        EXPRESSION "3514"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                OFFSET 0 2
                                SIZE 5.235
                                SYMBOL "norGIS_alkis3514_1"
                        END
                END
                CLASS
                #-      NAME "Torf"
                        EXPRESSION "3407"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.5092
                                SYMBOL "norGIS_alkis3407_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3423_1"
                        END
                END
                CLASS
                #-      NAME "Kleingarten"
                        EXPRESSION "3419"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.4126
                                SYMBOL "norGIS_alkis3419_1"
                        END
                END
                CLASS
                #-      NAME "Garten"
                        EXPRESSION "3421"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.8127
                                SYMBOL "norGIS_alkis3421_1"
                        END
                END
                CLASS
                #-      NAME "Rasen"
                        EXPRESSION "3413"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 0.4305
                                SYMBOL "norGIS_alkis3413_1"
                        END
                END
                CLASS
                #-      NAME "Park"
                        EXPRESSION "3415"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.6648
                                SYMBOL "norGIS_alkis3415_1"
                        END
                END
                CLASS
                #-      NAME "Campingplatz"
                        EXPRESSION "3412"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 7.7268
                                SYMBOL "norGIS_alkis3412_1"
                        END
                END
        END

        LAYER 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"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                SIZE 5.3476
                                SYMBOL "norGIS_alkis3627_1"
                        END
                END
                CLASS
                #-      NAME "Busch, Hecke, Knick"
                        EXPRESSION "3601"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.4275
                                SYMBOL "norGIS_alkis3601_1"
                        END
                END

                # "Internal Server Error" wenn diese Class aktiv ist.
                #  Tritt nur auf bei kleinen MaßstÀben (> 1000) und an manchen Stellen.
        ##      CLASS 
        #       #-      NAME "Busch, Hecke, Knick"
        #               EXPRESSION "3632"
        #               STYLE
        #                       ANGLE [drehwinkel_grad]
        #                       MINSIZE 1
        #                       SIZE 2.0
        #                       SYMBOL "norGIS_alkis3632_1"
        #               END
        ##      END
        END

        ## Layer des Typs  Beschriftungen

        LAYER NAME "bfn" # FlurstÃŒcke / Nummern / Beschriftungen
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil'))  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                #       wms_layer_group "/FlurstÃŒcke/Nummern"
                        wms_layer_group "/FlurstÃŒcke"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                OUTLINEWIDTH 2 # krz
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÌndig' THEN 'R' WHEN 'rechtsbÌndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer')  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 3500
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                TYPE TRUETYPE
                        END
                END
        END

        LAYER NAME "bg2" # GebÀude / lfd. Nr. NebengebÀude
                # NebengebÀude-Nummer in Klammer, normalerweise aus
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÌndig' THEN 'L' WHEN 'rechtsbÌndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 3500
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/GebÀude" # "/GebÀude/Laufende Hausnummern"
                        wms_title "lfd. Nr. NebengebÀude" # "Beschriftungen (Punkte)"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                TYPE TRUETYPE
                        END
                END
        END

        LAYER NAME "bl" # Lagebezeichnungen / Beschriftungen
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Lagebezeichnungen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 25000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Rechtliche Festlegungen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÌndig' THEN 'R' WHEN 'rechtsbÌndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Friedhöfe"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Vegetation"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÌndig' THEN 'R' WHEN 'rechtsbÌndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Industrie und Gewerbe"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT # ANNOTATION
                UNITS METERS
                CLASS
                        LABEL
                                ANGLE [drehwinkel_grad]
                                ANTIALIAS TRUE
                                FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2
                                COLOR [color_umn]
                                FORCE TRUE
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                TYPE TRUETYPE
                        END
                END
        END

        LAYER NAME "bs" # Sport und Freizeit / Beschriftungen
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Sport und Freizeit"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT # ANNOTATION
                UNITS METERS
                CLASS
                        LABEL
                                ANGLE [drehwinkel_grad]
                                ANTIALIAS TRUE
                                FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2
                                COLOR [color_umn]
                                FORCE TRUE
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                TYPE TRUETYPE
                        END
                END
        END

        LAYER NAME "bb" # WohnBauflÀchen / Beschriftungen
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung)  WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÌndig' THEN 'R' WHEN 'rechtsbÌndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[]  AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/WohnbauflÀchen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT # ANNOTATION
                UNITS METERS
                CLASS
                        LABEL
                                ANGLE [drehwinkel_grad]
                                ANTIALIAS TRUE
                                FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2
                                COLOR [color_umn]
                                FORCE TRUE
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                TYPE TRUETYPE
                        END
                END
        END

        LAYER NAME "bt" # Topographie / Beschriftungen
                CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                #EXTENT  ...
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen"
                        #wms_enable_request "GetCapabilities GetMap"
                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
                                OUTLINECOLOR 255 255 255
                                POSITION [position_umn]
                                PRIORITY 10
                                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"
                        #wms_enable_request "GetCapabilities GetMap"
                END
                FEATURE
                        POINTS 0 0 END
                        # individuell Kreisname und ggf. 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