source: trunk/umn/alkis_n/alkis_sw_muster.map @ 424

MAP
# ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet fÃŒr mapserver 7.4
# http://10.0.100.54/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkissw*gkz*.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 

# Stand:
#  2016-05-19 generiert, angepasst und optimiert
#  2016-05-20 Legende unterdrÃŒcken
#  2016-05-23 FlurstÃŒcke: 2stufige Gruppierung raus. "wms_enable_request" pauschal "*" im Root. 
#             Beschriftung: links-/rechtsbÃŒndig vertauscht.
#  2017-11-24 Abgleich mit neuer Generierung aus QGIS-Plugin
#  2017-11-27 Übernahme Test nach Produktion
#  2019-01-22 Layer "pt": "drehwinkel_grad" bei "signaturnummer"=3632 in Tabelle "po_points" der alkis-DB darf NICHT "0" sein  -> ggf. Wert minimal aendern
#  2019-03-05 EPSG:54004 entfernt
#  2019-03-08 GKZ in Keywords
#  2019-04    wms_abstract angepasst (Stand und Link zur Symbolliste)
#             Layer pg2, bll, bwl eingefÃŒgt
#             Symbole und Classes ergÀnzt
#             Alle OFFSETs auskommentiert (können dann gelöscht werden), weil Positionierung jetzt Ìber Anchorpoint lÀuft
#             Layer-Reihenfolge geÀndert (Layer werden Gruppenweise aufgefÌhrt) und umbenannt analog alkisn
#  2019-05  -> fÌr die Verwendung mÌssen zusÀtzlich zum Maptrimmer die Extents fÌr die einzelnen Layer eingefÌgt werden
#           -> zur Zeit Verwendung der IP-Adresse 10.0.100.54, nachdem der alte OWS-Server abgeschaltet ist, Àndern in ows.krz.de
#  2019-08-13 User ms6 -> ms7
#  2020-01-28 F.J.: Name in CLASS auskommentiert in mehreren Layern. Darstellung in Legende ist sonst fehlerhaft.
#  2020-06-10 F.J.: wms_enable_request '* !GetMetadata', Extent in alle Layer (vom Maptrimmer nicht unterstÃŒtzt!)
#
### Erlaeuterungen:
## SVG:
# Die SVG-Symbole sind aus dem norBIT-ALKIS-Plugin zu entnehmen:
# Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\
# Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ 
#
## Layername:
# Der aus QGIS generierte Layername ("l" + lfd.Nr) ist unterschiedlich je Mandant, 
# und wird daher zur Vereinheitlichung ersetzt durch die Buchstaben fÃŒr "Typ" und "Gruppe" aus der unten stehenden Liste.
#
## Layer und Klassen:
# Dies Muster-Mapfile wurde generiert auf der Basis von NBA-Daten fÃŒr einige Staedte in Ost-Westfalen.
# FÌr den Einsatz in anderen Kreisen und anderen Regionen ist dies ggf. durch lokale Layer und Klassen zu ergÀnzen.
#
## HQ-Print:
# Es wird keine _4-Mapdatei mehr fÃŒr High-Quality-Print mit 288dpi aufbereitet.
# Statt dessen wird fÌr den HQ-Print der GetMap-Call ergÀnzt um den Parameter: "&map.resolution=288"
# Beispiel fÃŒr Mapbender 2.7:
# UPDATE gui_element_vars SET var_value = '[{"pattern": ".map&",
#   "replacement": {"144": ".map&map.resolution=144&", "288": ".map&map.resolution=288&"}}]' 
#   WHERE fkey_e_id = 'printPDF' AND var_name  ='highqualitymapfiles';

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

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

### Layer-Reihenfolge   ( "-": FlÀche tritt im Gegensatz zur farbigen ALKIS-Darstellung nicht auf)
### Die Gruppierung hat setzt im Mapbender die Layer-Reihenfolge außer Kraft -> DarstellungsprioritÀt hÀngt von Gruppenreihenfolge ab.
##  Layer-Reihenfolge an alkis farbig angepasst, auch wenn hier das Problem möglicher Überdeckung geringer ist
## */ alle FlÀchen (ohne GebÀude) in einer Gruppe "/FlÀchennutzung (FlÀchen)"
# -fh Friedhöfe / FlÀchen
# -fb WohnbauflÀchen / FlÀchen
# -fe Vegetation / FlÀchen
# fw GewÀsser / FlÀchen
# -fs Sport und Freizeit / FlÀchen
# fi Industrie und Gewerbe / FlÀchen
# fv Verkehr / FlÀchen

## */ Gruppe Topographie
# gt Topographie / Grenzen
# lt Topographie / Linien
# pt Topographie / Punkte
# bt Topographie / Beschriftungen

## */ Gruppe Friedhöfe
# gh Friedhöfe / Grenzen
# bh Friedhöfe / Beschriftungen

## */ Gruppe WohnBauflÀchen
# gb WohnbauflÀchen / Grenzen
# bb WohnbauflÀchen / Beschriftungen

## */ Gruppe Vegetation
# ge Vegetation / Grenzen
# pe Vegetation / Punkte
# be Vegetation / Beschriftungen

## */ Gruppe Sport und Freizeit
# gs Sport und Freizeit / Grenzen
# ps Sport und Freizeit / Punkte
# bs Sport und Freizeit / Beschriftungen

## */ Gruppe GewÀsser
# gw GewÀsser / Grenzen
# lw GewÀsser / Linien
# pw GewÀsser / Punkte
# bw GewÀsser / Beschriftungen (Punkte)
# bwl GewÀsser / Beschriftungen (Linien)

## */ Gruppe Industrie und Gewerbe
# gi Industrie und Gewerbe / Grenzen
# li Industrie und Gewerbe / Linien
# pi Industrie und Gewerbe / Punkte
# bi Industrie und Gewerbe / Beschriftungen

## */ Gruppe Verkehr
# gv Verkehr / Grenzen
# lv Verkehr / Linien
# pv Verkehr / Punkte
# bv Verkehr / Beschriftungen

## */ Gruppe GebÀude
# fg GebÀude / FlÀchen
# gg GebÀude / Grenzen
# lg GebÀude / Linien
# pg GebÀude / GebÀude /Punkte
# pg2 GebÀude / Funktion / Punkte
# bgh GebÀude / Hausnummern
# bgn GebÀude / lfd. Nr. NebengebÀude
# bgd GebÀude / Dachform
# bgf GebÀude / Funktion
# bgg GebÀude / Geschosse
# bgz GebÀude / Zustand

## */ Gruppe Rechtliche Festlegung
# gr Rechtliche Festlegungen / Grenzen
# br Rechtliche Festlegungen / Beschriftungen

## */ Gruppe Politische Grenzen
# lp Politische Grenzen / Linien

## */ Gruppe Lagebezeichnungen
# bl Lagebezeichnungen / Beschriftungen (Punkte)
# bll Lagebezeichnung / Beschriftung (Linien)

## */ Gruppe FlurstÃŒcke
# gff FlurstÌcke / FlÀchen / Grenzen
# lfn FlurstÃŒcke / Nummern / Linien
# lff FlurstÌcke / FlÀchen / Linien
# pff FlurstÌcke / FlÀchen / Punkte
# bfn FlurstÃŒcke / Nummern / Beschriftungen


        NAME "alkissw"
        STATUS ON
        #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log"
        EXTENT ...
        PROJECTION "init=epsg:25832" END
        MAXSIZE 8400 # reicht fuer 288 dpi auf DIN-A2
        DEFRESOLUTION 72
        SYMBOLSET "symbolssw.sym" # ausgelagert, ursprÃŒnglich hier inline generiert
        FONTSET "/opt/gdi/alkisn/fonts/fonts.txt"
        UNITS METERS
        WEB
                METADATA
                        wms_title "ALKIS sw"
                        wms_abstract "ALKIS Schwarz/Weiß- bzw. Graustufen-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom Januar 2019. Die Legende wÀre zu umfangreich. Sie wird hier nur fÃŒr eine kleine Anzahl Objekte ausgegeben. Eine vollstÀndige Beschreibung der Zeichenvorschrift fÃŒr ALKIS findet man z.B. in http://sg.geodatenzentrum.de/web_public/adv/sk/v1.1/alkis/docAlkisSW/SymbologyCatalog.html ."
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_bbox_extended "true"
                        wms_encoding "UTF-8"
                        wms_onlineresource "http://ows.krz.de/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkissw*gkz*.map"
                        # Die Position von "GKZ" im Mapfile-Namen muss 3stellig sein, am Ende vor ".map".
                        # GKZ wird vom Template ÃŒber den [map] ausgelesen um die richtige DB der Auskunft zu finden.
                        wms_feature_info_mime_type "text/html"
                        wms_schema_location ".."
                        wms_keywordlist "GKZ*gkz*,ALKIS,FlurstÃŒck,NAS"
                        wms_fees "none"
                        wms_accessconstraints "fÃŒr den Dienstgebrauch"
                        wms_enable_request '* !GetMetadata'
                        include "meta600.map" # Kontakt krz
                END
        END

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

##      ##      Gruppe mit den FlÀchen (ohne GebÀude)

        LAYER NAME "fw" # GewÀsser / FlÀchen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer IN ('1308','1523','1572','2510') AND thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 

                EXTENT ..
                MAXSCALEDENOM 500000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/FlÀchennutzung (FlÀchen)"
                        wms_title "GewÀsser (FlÀchen)"
                        wms_enable_request "GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME '{"Hafendamm, Mole","Wellenbrecher, Buhne"}'
                        EXPRESSION "1308"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                #       NAME '{Bach,Fleet,Graben,Priel,Teich,"Untergeordnetes GewÀsser"}'
                        EXPRESSION "1523"
                        STYLE
                                COLOR 255 255 255 # weiß!
                        END
                END
                CLASS
                #       NAME '{"Bach, nicht stÀndig Wasser fÌhrend","Fleet, nicht stÀndig Wasser fÌhrend","Graben, nicht stÀndig Wasser fÌhrend","Teich, nicht stÀndig Wasser fÌhrend","Untergeordnetes GewÀsser, nicht stÀndig Wasser fÌhrend"}'
                        EXPRESSION "1572"
                        STYLE
                                COLOR 255 255 255
                        END
                END
                CLASS
                #       NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"StÃŒtzmauer links",StÃŒtzmauermitte,"StÃŒtzmauer rechts","Ufermauer, Kaimauer"}'
                        EXPRESSION "2510"
                        STYLE
                                COLOR 204 204 204
                        END
                END
        END #*
        
        LAYER NAME "fi" # Industrie und Gewerbe / FlÀchen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/FlÀchennutzung (FlÀchen)"
                        wms_title "Industrie und Gewerbe (FlÀchen)"
                        wms_enable_request "GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[1403]"
                        EXPRESSION "1403"
                        STYLE
                                COLOR 237 237 237
                        END
                END
                CLASS
                #-      NAME "VorratsbehÀlter, aufgestÀndert"
                        EXPRESSION "1304"
                        STYLE
                          COLOR 204 204 204
                        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 "fv" # Verkehr / FlÀchen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                #ATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer IN ('1530','1532','1540','1542','1544') AND 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:3034 EPSG:3857"
                        wms_layer_group "/FlÀchennutzung (FlÀchen)"
                        wms_title "Verkehr (FlÀchen)"
                        wms_enable_request "GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                        NAME "Weg"
                        EXPRESSION "1542"
                        STYLE
                                COLOR 255 255 255
                        END
                END
                CLASS
                        NAME "Anleger"
                        EXPRESSION "1544"
                        STYLE
                                COLOR 255 255 255
                        END
                END
                CLASS
                        NAME "Fahrbahn"
                        EXPRESSION "1540"
                        STYLE
                                COLOR 255 255 255
                        END
                END
                CLASS
                #       NAME "{BrÃŒckenjoch}"
                        NAME "BrÃŒckenjoch"
                        EXPRESSION "1532"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "BrÃŒcke, Hochbahn/-straße"
                        EXPRESSION "1530"
                        STYLE
                                COLOR 255 255 255
                        END
                END
        END #*
        
        
##      ## Gruppe Topographie

        LAYER NAME "gt" # Topographie / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
        #       DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = 'rn1551' AND thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 
                # Filter "signaturnummer = 'rn1551' AND"  6:0
                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:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                        wms_title "Grenzen (Topogr.)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME '{"Damm, Wall, Deich","Felsen, Felsblock, Felsnadel",RÃŒckhaltebecken,"Sonstiges GewÀssermerkmal",Staudamm,"Staudamm, außer Betrieb"}'
                        EXPRESSION "rn1551"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "lt" # Topographie / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                        wms_title "Linien (Topogr.)"
                        wms_abstract "Darstellung von Böschungen bestehend aus Böschungs-Oberkante, -Unterkante, Trennschraffen und vom Konverter generierten Schraffen."
                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
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Böschung, Kliff","GelÀndekante, Böschungsoberkante","GelÀndekante, Böschungsunterkante","GelÀndekante, Allgemeine GelÀndekante (z.B. Trennschraffe)"}'
                        EXPRESSION "2531"
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"GelÀndekante, Böschungsoberkante, unsicher","GelÀndekante, Böschungsunterkante, unsicher","GelÀndekante, Sonstige Begrenzungskante (z.B. Trennschraffe), unsicher"}'
                        EXPRESSION "8223"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 2.00 1.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*
        
        LAYER NAME "pt" # Topographie / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                        wms_title "Punkte (Topogr.)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "Busch, Hecke, Knick"
                        EXPRESSION "3601"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.4275
                                SYMBOL "norGIS_alkis3601_2"
                        END
                END
                CLASS
                #-      NAME "Felsen, Felsblock, Felsnadel"
                        EXPRESSION "3627"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3476
                                SYMBOL "norGIS_alkis3627_2"
                        END
                END
                CLASS
                #-      NAME "Höhleneingang"
                        EXPRESSION "3625"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.9654
                                SYMBOL "norGIS_alkis3625_2"
                        END
                END
                CLASS
                #-      NAME "Besonderer topographischer Punkt"
                        EXPRESSION "3629"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1.0197
                                SYMBOL "norGIS_alkis3629_2"
                        END
                END
                
                # "Internal Server Error" wenn diese Class aktiv ist.
                #  Tritt nur auf bei kleinen MaßstÀben (> 1000) und an manchen Stellen.
                #  Jan2019:
                #  Tritt auf, wenn in DB in der Tabelle "po_points" fuer "signaturnummer"=3632 ein "drehwinkel_grad"=0 eingetragen ist.
                #  Workaround: in der DB in der Tabelle "po_points" die entsprechenden Eintraege suchen (signaturnummer ='3632' AND drehwinkel_grad =0) ...
                #  ... und "drehwinkel_grad" auf einen sehr kleinen Wert, wie z.B. 0.000000001, setzen.
                CLASS
                #-      NAME "Busch, Hecke, Knick"
                        EXPRESSION "3632"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 2
                                SYMBOL "norGIS_alkis3632_2"
                        END
                END
                CLASS
                #-      NAME "Felsen, Felsblock, Felsnadel"
                        EXPRESSION "3634"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.3309
                                SYMBOL "norGIS_alkis3634_2"
                        END
                END
        END #*
        
        LAYER NAME "bt" # Topographie / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Topographie"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Topogr.)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*


##      ## Gruppe Friedhöfe

        LAYER NAME "gh" # FriedHöfe / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
        #       DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                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:3034 EPSG:3857"
                        wms_layer_group "/Friedhöfe"
                        wms_title "Grenzen (Friedhöfe)"
                        #wms_enable_request "GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[2515]"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*
        
        LAYER NAME "bh" # FriedHöfe / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Friedhöfe"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Friedhöfe)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
##      ## Gruppe WohnBauflÀchen

        LAYER NAME "gb" # WohnbauflÀchen / Grenzen    
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
        #       DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                # Filter Signaturnummer 2200 : 0
                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:3034 EPSG:3857"
                        wms_layer_group "/WohnbauflÀchen"
                        wms_title "Grenzen (Wohnbaufl.)"
                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 "bb" # WohnbauflÀchen / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/WohnbauflÀchen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Wohnbaufl.)"
                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]
                                TYPE TRUETYPE ANTIALIAS TRUE
                                FONT [font_umn] SIZE [size_umn]
                                BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                                FORCE TRUE
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END

        
## ##   Gruppe Vegetation

        LAYER NAME "ge" # VEgetation / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Vegetation"
                        wms_title "Grenzen (Vegetation)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[2515]"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Wald"
                        EXPRESSION "2517"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Baumbestand, Laub- und Nadelholz","Baumbestand, Laubholz","Baumbestand, Nadelholz",GebÌsch,"Gehölz (Vegetationsmerkmal)",Gras,Korbweide,Reet,"Röhricht, Schilf",ZierflÀche}'
                        EXPRESSION "rn1560"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "{Rain,Schneise}"
                        EXPRESSION "rn1561"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Vegetationsmerkmal, Zustand nass"}'
                        EXPRESSION "rn1563"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*
        
        LAYER NAME "pe" # VEgetation / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Vegetation"
                        wms_title "Punkte (Vegetation)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "Gras"
                        EXPRESSION "3413"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 0.4305
                                SYMBOL "norGIS_alkis3413_2"
                        END
                END
                CLASS
                #-      NAME "Garten"
                        EXPRESSION "3421"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.8127
                                SYMBOL "norGIS_alkis3421_2"
                        END
                END
                CLASS
                #-      NAME "Streuobstacker"
                        EXPRESSION "3440"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3440_2"
                        END
                END
                CLASS
                #-      NAME "Streuobstwiese"
                        EXPRESSION "3441"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3441_2"
                        END
                END
                CLASS
                #-      NAME "Spargel"
                        EXPRESSION "3444"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.34
                                SYMBOL "norGIS_alkis3444_2"
                        END
                END
                CLASS
                #-      NAME "Baumschule"
                        EXPRESSION "3446"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3446_2"
                        END
                END
                CLASS
                #-      NAME "Obstplantage"
                        EXPRESSION "3450"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3450_2"
                        END
                END
                CLASS
                        NAME "DÃŒne, Sand"
                        EXPRESSION "3484"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.0137
                                SYMBOL "norGIS_alkis3484_2"
                        END
                END
                CLASS
                #-      NAME "Obstbaumplantage"
                        EXPRESSION "3452"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.192
                                SYMBOL "norGIS_alkis3452_2"
                        END
                END
                CLASS
                #-      NAME "Obststrauchplantage"
                        EXPRESSION "3454"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.8807
                                SYMBOL "norGIS_alkis3454_2"
                        END
                END
                CLASS
                #-      NAME "Laubwald"
                        EXPRESSION "3458"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.3763
                                SYMBOL "norGIS_alkis3458_2"
                        END
                END
                CLASS
                #-      NAME "Nadelwald"
                        EXPRESSION "3460"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.8491
                                SYMBOL "norGIS_alkis3460_2"
                        END
                END
                CLASS
                #-      NAME "Mischwald"
                        EXPRESSION "3462"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3462_2"
                        END
                END
                CLASS
                #-      NAME "Mischwald"
                        EXPRESSION "3470"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.8718
                                SYMBOL "norGIS_alkis3470_2"
                        END
                END
                CLASS
                #-      NAME "Heide"
                        EXPRESSION "3474"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.9261
                                SYMBOL "norGIS_alkis3474_2"
                        END
                END
                CLASS
                #-      NAME "Moor"
                        EXPRESSION "3476"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.6088
                                SYMBOL "norGIS_alkis3476_2"
                        END
                END
                CLASS
                #-      NAME "Sumpf"
                        EXPRESSION "3478"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.065
                                SYMBOL "norGIS_alkis3478_2"
                        END
                END
                CLASS
                #-      NAME "Unland"
                        EXPRESSION "3480"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.0107
                                SYMBOL "norGIS_alkis3480_2"
                        END
                END
                CLASS
                #-      NAME "Fels"
                        EXPRESSION "3481"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.7614
                                SYMBOL "norGIS_alkis3481_2"
                        END
                END
                CLASS
                #-      NAME "Nadelbaum"
                        EXPRESSION "3597"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 4.8638
                                SYMBOL "norGIS_alkis3597_2"
                        END
                END
                CLASS
                #-      NAME "Laubbaum"
                        EXPRESSION "3599"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 4.567
                                SYMBOL "norGIS_alkis3599_2"
                        END
                END
                CLASS
                #-      NAME "Busch, Hecke, Knick"
                        EXPRESSION "3601"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.4275
                                SYMBOL "norGIS_alkis3601_2"
                        END
                END
                CLASS
                #-      NAME "Steine, Schotter / Wellenbrecher, Buhne"
                        EXPRESSION "3482"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.2856
                                SYMBOL "norGIS_alkis3482_2"
                        END
                END
                CLASS
                #-      NAME "Röhricht, Schilf"
                        EXPRESSION "3603"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.7388
                                SYMBOL "norGIS_alkis3603_2"
                        END
                END
                CLASS
                #-      NAME "ZierflÀche"
                        EXPRESSION "3605"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.4245
                                SYMBOL "norGIS_alkis3605_2"
                        END
                END
                CLASS
                #-      NAME "Quelle"
                        EXPRESSION "3613"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.0197
                                SYMBOL "norGIS_alkis3613_2"
                        END
                END
        END #*
        
        LAYER NAME "be" # Vegetation / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Vegetation"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Vegetation)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*

        
## ##   Gruppe Sport und Freizeit

        LAYER NAME "gs" # Sport und Freizeit / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Sport und Freizeit"
                        wms_title "Grenzen (Sport u. Freizeit)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[2515]"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Überdachte TribÃŒne"
                        EXPRESSION "rn1519"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 2.00 1.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Hart-, Rasenplatz, Spielfeld"
                        EXPRESSION "rn1520"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Stadion"
                        EXPRESSION "rn1522"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.5 WIDTH 0.5
                        END
                END
                CLASS
                #       NAME "[1524]"
                        EXPRESSION "rn1524"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Schwimmbecken"
                        EXPRESSION "rn1526"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Rennbahn, Laufbahn, GelÀuf"
                        EXPRESSION "rn1521"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "ps" # Sport und Freizeit / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Sport und Freizeit"
                        wms_title "Punkte (Sport u. Freizeit)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "Skating"
                        EXPRESSION "3409"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3409_2"
                        END
                END
                CLASS
                #-      NAME "Zoo"
                        EXPRESSION "3410"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3410_2"
                        END
                END
                CLASS
                #-      NAME "Safaripark, Wildpark"
                        EXPRESSION "3411"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3411_2"
                        END
                END
                CLASS
                #-      NAME "Campingplatz"
                        EXPRESSION "3412"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.7268
                                SYMBOL "norGIS_alkis3412_2"
                        END
                END
                CLASS
                #-      NAME "Rasen"
                        EXPRESSION "3413"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 0.4305
                                SYMBOL "norGIS_alkis3413_2"
                        END
                END
                CLASS
                #-      NAME "Park"
                        EXPRESSION "3415"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.6648
                                SYMBOL "norGIS_alkis3415_2"
                        END
                END
                CLASS
                #-      NAME "Botanischer Garten"
                        EXPRESSION "3417"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3417_2"
                        END
                END
                CLASS
                #-      NAME "Kleingarten"
                        EXPRESSION "3419"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.4126
                                SYMBOL "norGIS_alkis3419_2"
                        END
                END
                CLASS
                #-      NAME "Garten"
                        EXPRESSION "3421"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.8127
                                SYMBOL "norGIS_alkis3421_2"
                        END
                END
                CLASS
                #-      NAME "Spielplatz, Bolzplatz"
                        EXPRESSION "3423"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3423_2"
                        END
                END
                CLASS
                #-      NAME "Schießanlage"
                        EXPRESSION "3524"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.3673
                                SYMBOL "norGIS_alkis3524_2"
                        END
                END
                CLASS
                #-      NAME "Gradierwerk"
                        EXPRESSION "3525"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.0727
                                SYMBOL "norGIS_alkis3525_2"
                        END
                END
        END #*
        
        LAYER NAME "bs" # Sport und Freizeit / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Sport und Freizeit"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Sport u. Freizeit)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ##   Gruppe GewÀsser

        LAYER NAME "gw" # GewÀsser / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                        wms_title "Grenzen (GewÀsser)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME '{"Stehendes GewÀsser, nicht stÀndig Wasser fÌhrend"}'
                        EXPRESSION "2520"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 4.00 2.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "GewÀsser"
                        EXPRESSION "2518"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Hafendamm, Mole","Wellenbrecher, Buhne"}'
                        EXPRESSION "rn1308"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Damm, Wall, Deich","Felsen, Felsblock, Felsnadel",RÃŒckhaltebecken,"Sonstiges GewÀssermerkmal",Staudamm,"Staudamm, außer Betrieb"}'
                        EXPRESSION "rn1551"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "{Quelle,Stromschnelle,Wasserfall}"
                        EXPRESSION "rn1562"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "Fischtreppe, Sicherheitstor, Sperrwerk"
                        EXPRESSION "rn1548"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{Bach,Fleet,Graben,Priel,Teich,"Untergeordnetes GewÀsser"}'
                        EXPRESSION "rn1523"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"StÃŒtzmauer links",StÃŒtzmauermitte,"StÃŒtzmauer rechts","Ufermauer, Kaimauer"}'
                        EXPRESSION "rn2510"
                        STYLE
                                LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Unterirdisches GewÀsser"
                        EXPRESSION "rn1550"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 0.35 0.35 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bach, nicht stÀndig Wasser fÌhrend","Fleet, nicht stÀndig Wasser fÌhrend","Graben, nicht stÀndig Wasser fÌhrend","Teich, nicht stÀndig Wasser fÌhrend","Untergeordnetes GewÀsser, nicht stÀndig Wasser fÌhrend"}'
                        EXPRESSION "rn1572"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN
                                 4.00 2.00
                                END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bach, trocken, versiegt","Fleet, trocken, versiegt","Graben, trocken, versiegt","Teich, trocken, versiegt","Untergeordnetes GewÀsser, trocken, versiegt"}'
                        EXPRESSION "rn1573"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN
                                 1.00 2.00
                                END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "lw" # GewÀsser / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                        wms_title "Linien (GewÀsser)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                CLASS
                #       NAME '{Lahnung,Schöpfwerk,"Sonstiges Bauwerk im GewÀsserbereich",Sperrwerk,Wehr}'
                        EXPRESSION "2003"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{Bach,Fleet,Graben,"Grabenkante links","Grabenkante rechts",Grabenmitte,Linienverkehr,"Untergeordnetes GewÀsser"}'
                        EXPRESSION "2592"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bach, nicht stÀndig Wasser fÌhrend","Fleet, nicht stÀndig Wasser fÌhrend","Graben, nicht stÀndig Wasser fÌhrend","Grabenkante links, nicht stÀndig Wasser fÌhrend","Grabenkante rechts, nicht stÀndig Wasser fÌhrend","Grabenmitte, nicht stÀndig Wasser fÌhrend","Untergeordnetes GewÀsser, nicht stÀndig Wasser fÌhrend"}'
                        EXPRESSION "2593"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 4.00 2.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bach, verdolt","Bach, verrohrt, unterirdisch, bedeckt",Durchlass,"Fleet, verdolt","Fleet, verrohrt, unterirdisch, bedeckt","Graben, verdolt","Graben, verrohrt, unterirdisch, bedeckt",Rohrdurchlass,Siel,"Untergeordnetes GewÀsser, verdolt","Untergeordnetes GewÀsser, verrohrt, unterirdisch, bedeckt"}'
                        EXPRESSION "2560"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE END
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                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 "{DÃŒker}"
                        EXPRESSION "2561"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 1.01
                        END
                        STYLE
                                COLOR 153 153 153
                                INITIALGAP 3.6 LINEJOIN ROUND
                                PATTERN 0.00 3.60 END
                                SIZE 1
                        END
                END
                CLASS
                #       NAME "(2595)"
                #       NAME '{"Bach, trocken, versiegt","Fleet, trocken, versiegt","Graben, trocken, versiegt","Grabenkante links, trocken versiegt","Grabenkante rechts, trocken versiegt","Grabenmitte, trocken versiegt","Untergeordnetes GewÀsser, trocken, versiegt"}'
                        EXPRESSION "2595"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 1.00 2.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "pw" # GeWÀsser / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                        wms_title "Punkte (GewÀsser)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "FließgewÀsser"
                        EXPRESSION "3488"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3488_2"
                        END
                END
                CLASS
                #-      NAME "GewÀsser"
                        EXPRESSION "3490"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.3369
                                SYMBOL "norGIS_alkis3490_2"
                        END
                END
                CLASS
                #-      NAME "Brunnen / Gasquelle, Mofette / Heilquelle"
                        EXPRESSION "3529"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.6965
                                SYMBOL "norGIS_alkis3529_2"
                        END
                END
                CLASS
                #       NAME "(3592)"
                        EXPRESSION "3592"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2009
                                SYMBOL "norGIS_alkis3592_2"
                        END
                END
                CLASS
                #       NAME "(3595)"
                        EXPRESSION "3595"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2009
                                SYMBOL "norGIS_alkis3595_2"
                        END
                END
                CLASS
                #       NAME "(3596)"
                        EXPRESSION "3596"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 1
                                SIZE 3.6936
                                SYMBOL "norGIS_alkis3596_2"
                        END
                END
                CLASS
                #-      NAME "Quelle"
                        EXPRESSION "3613"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.0197
                                SYMBOL "norGIS_alkis3613_2"
                        END
                END
                CLASS
                #-      NAME "Unterirdisches FließgewÀsser"
                        EXPRESSION "3619"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3619_2"
                        END
                END
                CLASS
                #-      NAME "FließgewÀsser, nicht stÀndig Wasser fÃŒhrend"
                        EXPRESSION "3621"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2236
                                SYMBOL "norGIS_alkis3621_2"
                        END
                END
                CLASS
                #       NAME "[3653]"
                        EXPRESSION "3653"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.2009
                                SYMBOL "norGIS_alkis3653_2"
                        END
                END
        END #*

        LAYER NAME "bw" # GewÀsser / Beschriftungen (Punkte)
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen Punkte (GewÀsser)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        LAYER NAME "bwl" # GewÀsser / Beschriftungen (Linien)
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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,st_offsetcurve(line,0.125*skalierung*grad_pt,'') AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND line IS NOT 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:3034 EPSG:3857"
                        wms_layer_group "/GewÀsser"
                        wms_title "Beschriftungen Linien (GewÀsser)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE LINE
                UNITS METERS
                CLASS
                        LABEL
                                ANGLE FOLLOW
                                ANTIALIAS TRUE FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION CC PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ## Gruppe Industrie und Gewerbe

        LAYER NAME "gi" # Industrie und Gewerbe / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Industrie und Gewerbe"
                        wms_title "Grenzen (Industrie u. Gewerbe)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME "[2515]"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "KlÀrbecken"
                        EXPRESSION "rn1510"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Förderband, Bandstraße",Tor}'
                        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 "[2031]"
                        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 "(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 "Mast"
                        EXPRESSION "rn1306"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "li" # Industrie und Gewerbe / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Industrie und Gewerbe"
                        wms_title "Linien (Industrie u. Gewerbe)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                CLASS
                #       NAME '{"BahnÌbergang, Schranke","HÀngende Lampe",Höckerlinie,"Rohrleitung, Pipeline",Zaun}'
                        EXPRESSION "2002"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{Erdkabel,"Rohrleitung, Pipeline, unter der ErdoberflÀche","Rohrleitung, Pipeline, unter der WasseroberflÀche"}'
                        EXPRESSION "2523"
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN
                                 0.35 0.35
                                END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "[2524]"
                        EXPRESSION "2524"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*
        
        LAYER NAME "pi" # Industrie und Gewerbe / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Industrie und Gewerbe"
                        wms_title "Punkte (Industrie u. Gewerbe)"
                        wms_enable_request "!GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "Tankstelle"
                        EXPRESSION "3401"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.2343
                                SYMBOL "norGIS_alkis3401_2"
                        END
                END
                CLASS
                #       NAME "(3402)"
                        EXPRESSION "3402"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.1603
                                SYMBOL "norGIS_alkis3402_2"
                        END
                END
                CLASS
                #-      NAME "Kraftwerk"
                        EXPRESSION "3403"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3403_2"
                        END
                END
                CLASS
                #-      NAME "Umspannstation"
                        EXPRESSION "3404"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 7.3643
                                SYMBOL "norGIS_alkis3404_2"
                        END
                END
                CLASS
                #-      NAME "Torf"
                        EXPRESSION "3407"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.5092
                                SYMBOL "norGIS_alkis3407_2"
                        END
                END
                CLASS
                #-      NAME "Windrad"
                        EXPRESSION "3501"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 3
                                SIZE 6.8565
                                SYMBOL "norGIS_alkis3501_2"
                        END
                END
                CLASS
                #-      NAME "Solarzellen"
                        EXPRESSION "3502"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.3733
                                SYMBOL "norGIS_alkis3502_2"
                        END
                END
                CLASS
                #       NAME "(3503)"
                        EXPRESSION "3503"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.8008
                                SYMBOL "norGIS_alkis3503_2"
                        END
                END
                CLASS
                #-      NAME "Mast"
                        EXPRESSION "3504"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.1979
                                SYMBOL "norGIS_alkis3504_2"
                        END
                END
                CLASS
                #-      NAME "Antenne / Funkmast"
                        EXPRESSION "3506"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 5.2585
                                SYMBOL "norGIS_alkis3506_2"
                        END
                END
                CLASS
                #-      NAME "Schornstein, Schlot, Esse"
                        EXPRESSION "3508"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.3763
                                SYMBOL "norGIS_alkis3508_2"
                        END
                END
                CLASS
                #-      NAME "Stollenmundloch"
                        EXPRESSION "3509"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.2856
                                SYMBOL "norGIS_alkis3509_2"
                        END
                END
                CLASS
                #-      NAME "Schachtöffnung"
                        EXPRESSION "3510"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.6058
                                SYMBOL "norGIS_alkis3510_2"
                        END
                END
                CLASS
                #-      NAME "Kran"
                        EXPRESSION "3511"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.142
                                SYMBOL "norGIS_alkis3511_2"
                        END
                END
                CLASS
                #-      NAME "Drehkran"
                        EXPRESSION "3512"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 1
                                SIZE 5.1886
                                SYMBOL "norGIS_alkis3512_2"
                        END
                END
                CLASS
                #-      NAME "Portalkran"
                        EXPRESSION "3513"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.189
                                SYMBOL "norGIS_alkis3513_2"
                        END
                END
                CLASS
                #-      NAME "Laufkran, BrÃŒckenlaufkran"
                        EXPRESSION "3514"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 5.235
                                SYMBOL "norGIS_alkis3514_2"
                        END
                END
                CLASS
                #-      NAME "Oberflurhydrant"
                        EXPRESSION "3517"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.1987
                                SYMBOL "norGIS_alkis3517_2"
                        END
                END
                CLASS
                #-      NAME "Einsteigeschacht"
                        EXPRESSION "3520"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3520_2"
                        END
                END
                CLASS
                #-      NAME "Umformer"
                        EXPRESSION "3521"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.6935
                                SYMBOL "norGIS_alkis3521_2"
                        END
                END
                CLASS
                #-      NAME "VorratsbehÀlter"
                        EXPRESSION "3522"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3522_2"
                        END
                END
                CLASS
                #-      NAME "Pumpe"
                        EXPRESSION "3523"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.6348
                                SYMBOL "norGIS_alkis3523_2"
                        END
                END
        END #*
        
        LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 10000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Industrie und Gewerbe"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Industrie u. Gewerbe)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ##   Gruppe Verkehr

        LAYER NAME "gv" # Verkehr / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                        wms_title "Grenzen (Verkehr)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                # Sortierung der CLASS nach numerischen Teil in EXPRESSION um Redundanzen zu finden
                CLASS
                #       NAME "{Furt}"
                        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 "(rn1330)"
                #       NAME '{AquÀdukt,"Befestigung (Wall, Graben)","Denkmal, Denkstein, Standbild",FernsprechhÀuschen,Grab,"GrabhÃŒgel (HÃŒgelgrab)","Großsteingrab (Dolmen), HÃŒnenbett",MÃŒllbox,"Sonstige Einrichtung in öffentlichen Bereichen","Sonstiges Bauwerk oder sonstige Einrichtung, Sonstiges","Sonstiges historisches Bauwerk oder sonstige historische Einrichtung","Wachturm (römisch), Warte",Wasserleitung}'
                        EXPRESSION "rn1330"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                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 "{BrÃŒckenpfeiler}"
                        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 "{BrÃŒckenjoch}"
                        EXPRESSION "rn1532"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                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
                CLASS
                #-      NAME "Schleusenkammer"
                        EXPRESSION "rn1535"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                SIZE 0.5 WIDTH 0.5
                        END
                END
                CLASS
                #       NAME "(rn1536)"
                #   NAME '{"Sonstiges Bauwerk im Verkehrsbereich"}'
                        EXPRESSION "rn1536"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Fahrbahn"
                        EXPRESSION "rn1540"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 127 127 127
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bahnhof, Bahn im Freizeitpark","Bahnhof, Bergbahn, Seilbahn","Bahnhof, Eisenbahn","Bahnhof, GÃŒterverkehr","Bahnhof, Magnetschwebebahn","Bahnhof, Museumsbahn","Bahnhof, S-Bahn","Bahnhof, sonstige Bahnkategorie","Bahnhof, Stadtbahn","Bahnhof, Standseilbahn","Bahnhof, Straßenbahn","Bahnhof, U-Bahn","Bahnhof, Zahnradbahn",Drehscheibe,"Haltestelle, Haltepunkt, Bahn im Freizeitpark","Haltestelle, Haltepunkt, Bergbahn, Seilbahn","Haltestelle, Haltepunkt, Eisenbahn","Haltestelle, Haltepunkt, GÃŒterverkehr","Haltestelle, Haltepunkt, Magnetschwebebahn","Haltestelle, Haltepunkt, Museumsbahn","Haltestelle, Haltepunkt, S-Bahn","Haltestelle, Haltepunkt, sonstige Bahnkategorie","Haltestelle, Haltepunkt, Stadtbahn","Haltestelle, Haltepunkt, Standseilbahn","Haltestelle, Haltepunkt, Straßenbahn","Haltestelle, Haltepunkt, U-Bahn","Haltestelle, Haltepunkt, Zahnradbahn"}'
                        EXPRESSION "rn1541"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Weg"
                        EXPRESSION "rn1542"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Anleger"
                        EXPRESSION "rn1544"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{Fischtreppe,Sicherheitstor,Sperrwerk,"Sonstiges Bauwerk im GewÀsserbereich","Sonstige Straßenverkehrsanlage",Wehr}'
                        EXPRESSION "rn1548"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Landeplatz, -bahn, Vorfeld, Rollbahn"
                        EXPRESSION "rn1808"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Durchfahrt, Bauwerk"
                        EXPRESSION "2305"
                        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 "Bahnverkehr, Platz"
                        EXPRESSION "2515"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bahnverkehr, im Bau","Flughafen, im Bau","Flugverkehr, im Bau","Hubschrauberflugplatz, im Bau","Internationaler Flughafen, im Bau","Landeplatz, Sonderlandeplatz im Bau","Regionalflughafen, im Bau","Schiffsverkehr, im Bau","SegelfluggelÀnde, im Bau","Straßenverkehr, im Bau","Verkehrslandeplatz, im Bau"}'
                        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
        END #*

        LAYER NAME "lv" # Verkehr / Linien 
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                        wms_title "Linien (Verkehr)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                CLASS
                #       NAME '{"Fußweg (Weg, Pfad, Steig)","Karren- und Ziehweg","Rad- und Fußweg (Weg, Pfad, Steig)","Radweg (Weg, Pfad, Steig)","Reitweg (Weg, Pfad, Steig)",Skaterstrecke,"Weg, Pfad, Steig"}'
                        EXPRESSION "2535"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.3535
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 2.00 3.20 END
                                SIZE 0.35 WIDTH 0.35
                        END
                END
                CLASS
                #       NAME '{AutofÀhrverkehr,"AutofÀhrverkehr, EisenbahnfÀhrverkehr",EisenbahnfÀhrverkehr,PersonenfÀhrverkehr,"Schifffahrtslinie, FÀhrverkehr"}'
                        EXPRESSION "2609"
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 2.00 1.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "{Fahrbahnbegrenzungslinie}"
                        EXPRESSION "2527"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 153 153 153
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Bahn im Freizeitpark, Gleis","Bergbahn, Seilbahn, Gleis","Eisenbahn, Gleis","GÃŒterverkehr, Gleis","Magnetschwebebahn, Gleis","Museumsbahn, Gleis","S-Bahn, Gleis","Sonstige Bahnkategorie, Gleis","Stadtbahn, Gleis","Standseilbahn, Gleis","Straßenbahn, Gleis","U-Bahn, Gleis","Zahnradbahn, Gleis"}'
                        EXPRESSION "2525"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE END
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "{Steg}"
                        EXPRESSION "2530"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.505
                        END
                        STYLE
                                COLOR 127 127 127
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.5 WIDTH 0.5
                        END
                END
                CLASS
                #       NAME '{"Fahrbahnbegrenzungslinie, ÃŒberdeckt"}'
                        EXPRESSION "2506"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                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 '{"Ausgabekopf - Trennlinie","Kabinenbahn, Umlaufseilbahn","Luftseilbahn, Großkabinenbahn",Materialseilbahn,Schwebebahn,Sessellift,"Skilift, Schlepplift"}'
                        EXPRESSION "2001"
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END
                        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 "Widerlager"
                        EXPRESSION "2533"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 127 127 127
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

                LAYER NAME "pv" # Verkehr / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                        wms_title "Punkte (Verkehr)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                # Sortierung nach Nummer in Expression
                CLASS
                #-      NAME "Fußweg"
                        EXPRESSION "3424"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3424_2"
                        END
                END
                CLASS
                #-      NAME "Radweg"
                        EXPRESSION "3426"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3426_2"
                        END
                END
                CLASS
                #-      NAME "Rad- und Fußweg"
                        EXPRESSION "3428"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3428_2"
                        END
                END
                CLASS
                #-      NAME "Reitweg"
                        EXPRESSION "3430"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.3703
                                SYMBOL "norGIS_alkis3430_2"
                        END
                END
                CLASS
                #-      NAME "Parkplatz"
                        EXPRESSION "3432"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.4836
                                SYMBOL "norGIS_alkis3432_2"
                        END
                END
                CLASS
                #-      NAME "Rastplatz"
                        EXPRESSION "3434"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.4836
                                SYMBOL "norGIS_alkis3434_2"
                        END
                END
                CLASS
                #-      NAME "SegelfluggelÀnde"
                        EXPRESSION "3439"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 12.5306
                                SYMBOL "norGIS_alkis3439_2"
                        END
                END
                CLASS
                #-      NAME "Haltestelle"
                        EXPRESSION "3554"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.5062
                                SYMBOL "norGIS_alkis3554_2"
                        END
                END
                CLASS
                #-      NAME "Kilometerstein"
                        EXPRESSION "3556"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1043
                                SYMBOL "norGIS_alkis3556_2"
                        END
                END
                CLASS
                #       NAME "(3574)"
                        EXPRESSION "3574"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.8687
                                SYMBOL "norGIS_alkis3574_2"
                        END
                END
                CLASS
                #-      NAME "Haltepunkt"
                        EXPRESSION "3578"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3578_2"
                        END
                END
                CLASS
                #       NAME "(3587)"
                        EXPRESSION "3587"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.7751
                                SYMBOL "norGIS_alkis3587_2"
                        END
                END
                CLASS
                #-      NAME "Hubschrauberlandeplatz"
                        EXPRESSION "3588"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.3672
                                SYMBOL "norGIS_alkis3588_2"
                        END
                END
                CLASS
                #       NAME "(3643)"
                        EXPRESSION "3643"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 1
                                SYMBOL "norGIS_alkis3643_2"
                        END
                END
        END #*
        
        LAYER NAME "bv" # Verkehr / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Verkehr"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Verkehr)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ##   Gruppe GebÀude

        LAYER NAME "fg" # GebÀude / FlÀchen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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"
                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 NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "FlÀchen (GebÀude)"
                        wms_enable_request "GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POLYGON
                UNITS METERS
                CLASS
                        NAME "WohngebÀude"
                        EXPRESSION "1301"
                        STYLE
                                COLOR 153 153 153
                        END
                END
                CLASS
                        NAME "Anderes GebÀude"
                        EXPRESSION "1304"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Mauer"
                        EXPRESSION "1305"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "GebÀude fÌr öffentliche Zwecke"
                        EXPRESSION "1309"
                        STYLE
                                COLOR 102 102 102
                        END
                END
                CLASS
                #       NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"StÃŒtzmauer links",StÃŒtzmauermitte,"StÃŒtzmauer rechts","Ufermauer, Kaimauer"}'
                #   NAME "Mauer"
                        EXPRESSION "2510"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Aussichtsturm"
                        EXPRESSION "1501"
                        STYLE
                                COLOR 204 204 204
                        END
                END
                CLASS
                        NAME "Brunnen"
                        EXPRESSION "1525"
                        STYLE
                                COLOR 204 204 204
                        END
                END
        END #*

        LAYER NAME "gg" # GebÀude / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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"
                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 NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Grenzen (GebÀude)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS
                CLASS
                #       NAME '{AquÀdukt,"Befestigung (Wall, Graben)","Denkmal, Denkstein, Standbild",FernsprechhÀuschen,Grab,"GrabhÃŒgel (HÃŒgelgrab)","Großsteingrab (Dolmen), HÃŒnenbett",MÃŒllbox,"Sonstige Einrichtung in öffentlichen Bereichen","Sonstiges Bauwerk oder sonstige Einrichtung, Sonstiges","Sonstiges historisches Bauwerk oder sonstige historische Einrichtung","Wachturm (römisch), Warte",Wasserleitung}'
                        EXPRESSION "rn1330"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME '{"Keller, unter der ErdoberflÀche","Tiefgarage, unter der ErdoberflÀche (Bauteil)"}'
                        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"
                        EXPRESSION "2030"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 2.00 1.00 END
                                SIZE 0.5 WIDTH 0.5
                        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 '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"StÃŒtzmauer links",StÃŒtzmauermitte,"StÃŒtzmauer rechts","Ufermauer, Kaimauer"}'
                        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 "Hochhaus"
                        EXPRESSION "2623"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.5 WIDTH 0.5
                        END
                END
                CLASS
                #       NAME NAME '{"Befestigung (Burgruine)","Burg (Fliehburg, Ringwall)",Lager,Schanze}'
                        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 '{Antenne,BrÃŒckenlaufkran,Drehkran,Einsteigeschacht,Freitreppe,Funkmast,"Historische Mauer",Hochofen,Kran,Laufkran,Mauer,Portalkran,Radioteleskop,Rampe,Rolltreppe,Schachtöffnung,Schöpfwerk,Solarzellen,"Sonstige historische Mauer","Sonstiges Bauwerk oder sonstige Anlage fÃŒr Industrie und Gewerbe",Stadtmauer,Staumauer,"Staumauer, außer Betrieb",StÃŒtzmauer,Terrasse,Treppe,Trockendock,"VorratsbehÀlter, Speicherbauwerk",Wasserrad,Windrad}'
                        EXPRESSION "rn1305"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "aufgestÀndert"
                        EXPRESSION "2508"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN 2.00 1.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "Schornstein im GebÀude"
                #-      NAME "Unterirdisch"
                        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 '{Arkade,"Auskragende Geschosse","Auskragende/zurÃŒckspringende Geschosse","Durchfahrt an ÃŒberbauter Verkehrsstraße","Durchfahrt im GebÀude","GebÀudeteil - abweichende Geschosshöhe","Geringergeschossiger GebÀudeteil","Höhergeschossiger GebÀudeteil (nicht Hochhaus)",Keller,Loggia,"Sonstiger GebÀudeteil","Tiefgarage (Bauteil)",Treppenunterkante,"ZurÃŒckspringende Geschosse"}'
                        EXPRESSION "2507"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Hochhausbauteil"
                        EXPRESSION "2509"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.5 WIDTH 0.5
                        END
                END
                CLASS
                #       NAME '{"Aussichtsturm, verfallen, zerstört","Bohrturm, verfallen, zerstört","Feuerwachturm, verfallen, zerstört","Förderturm, verfallen, zerstört","Kirchturm, Glockenturm, verfallen, zestört","Kontrollturm, verfallen, zerstört","KÃŒhlturm, verfallen, zerstört","Leuchtturm, verfallen, zerstört","Schloß-, Burgturm, verfallen, zerstört","Sende-, Funkturm, Fernmeldeturm, verfallen, zerstört","Sonstiger Turm, verfallen, zerstört","Stadt-, Torturm, verfallen, zerstört","Turm, nach Quellenlage nicht zu spezifizieren, verfallen, zerstört","Wasserturm, verfallen, zerstört"}'
                        EXPRESSION "rn1502"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                PATTERN
                                 2.00 1.00
                                END
                                SIZE 0.35 WIDTH 0.35
                        END
                END
                CLASS
                #       NAME '{Brunnen,"Springbrunnen, Zierbrunnen"}'
                        EXPRESSION "rn1525"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                                SIZE 0.18 WIDTH 0.18
                        END
                END
        END #*

        LAYER NAME "lg" # GebÀude / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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"
                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 NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Linien (GebÀude)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                CLASS
                #-      NAME "Kanal, Im Bau"
                        EXPRESSION "2519"
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 178 178 178
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN 7.00 1.00 END
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Zaun"
                        EXPRESSION "2002"
                        STYLE END
                        STYLE END
                        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 '{Arkade,"Auskragende Geschosse","Auskragende/zurÃŒckspringende Geschosse","Durchfahrt an ÃŒberbauter Verkehrsstraße","Durchfahrt im GebÀude","GebÀudeteil - abweichende Geschosshöhe","Geringergeschossiger GebÀudeteil","Höhergeschossiger GebÀudeteil (nicht Hochhaus)",Keller,Loggia,"Sonstiger GebÀudeteil","Tiefgarage (Bauteil)",Treppenunterkante,"ZurÃŒckspringende Geschosse"}'
                        EXPRESSION "2507"
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                SIZE 0.18 WIDTH 0.18
                        END
                END
                CLASS
                #       NAME "{Firstlinie}"
                        EXPRESSION "2303"
                        STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                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
                CLASS
                #-      NAME "Offene GebÀudelinie"
                        EXPRESSION "2305"
                        STYLE END
                        STYLE END
                        STYLE
                                COLOR 255 255 255
                                OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 0 0 0
                                LINECAP SQUARE LINEJOIN ROUND
                                PATTERN
                                 2.00 1.00
                                END
                                SIZE 0.18
                                WIDTH 0.18
                        END
                END
        END #*

                LAYER NAME "pg" # GebÀude / Punkte   2019-04: eingefÌgt -> entspricht QGIS ALKIS/GebÀude/Funktion/Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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 IN ('ax_gebaeude_funktion','ax_bauteil_funktion','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        #wms_title "Punkte"
                        wms_title "Punkte Funktion (GebÀude)"     #25.05.2019 Titel geÀndert um Àhnlich ALKIS/QGIS zu sein
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                # CLASS sortiert nach Nummer in Expression
                CLASS
                #-      NAME "Bank"
                        EXPRESSION "3300"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.189
                                SYMBOL "norGIS_alkis3300_2"
                        END
                END
                CLASS
                #-      NAME "Hotel"
                        EXPRESSION "3302"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3302_2"
                        END
                END
                CLASS
                #-      NAME "Jugendherberge"
                        EXPRESSION "3303"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.0047
                                SYMBOL "norGIS_alkis3303_2"
                        END
                END
                CLASS
                #-      NAME "GaststÀtte"
                        EXPRESSION "3305"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3305_2"
                        END
                END
                CLASS
                #-      NAME "Kino"
                        EXPRESSION "3306"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3306_2"
                        END
                END
                CLASS
                #-      NAME "Spielcasino"
                        EXPRESSION "3308"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.1437
                                SYMBOL "norGIS_alkis3308_2"
                        END
                END
                CLASS   # eingefÃŒgt 2019-04
                #-      NAME "Parkhaus"
                        EXPRESSION "3309"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3309_2"
                        END
                END
                CLASS
                #-      NAME "Toilette"
                        EXPRESSION "3311"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3311_2"
                        END
                END
                CLASS
                #-      NAME "Post"
                        EXPRESSION "3312"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3312_2"
                        END
                END
                CLASS  # eingefÃŒgt 2019-04
                #-      NAME "Theater"
                        EXPRESSION "3314"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 6.0274
                                SYMBOL "norGIS_alkis3314_2"
                        END
                END
                CLASS  # eingefÃŒgt 2019-04
                #-      NAME "Bibliothek"
                        EXPRESSION "3315"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3315_2"
                        END
                END
                CLASS
                #-      NAME "Kirche"
                        EXPRESSION "3316"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 10.0381
                                SYMBOL "norGIS_alkis3316_2"
                        END
                END
                CLASS  # eingefÃŒgt 2019-04
                #-      NAME "Synagoge"
                        EXPRESSION "3317"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.5122
                                SYMBOL "norGIS_alkis3317_2"
                        END
                END
                CLASS
                #-      NAME "Kapelle"
                        EXPRESSION "3318"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.0137
                                SYMBOL "norGIS_alkis3318_2"
                        END
                END
                CLASS  # eingefÃŒgt 2019-04
                #-      NAME "Moschee"
                        EXPRESSION "3319"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.189
                                SYMBOL "norGIS_alkis3319_2"
                        END
                END
                CLASS  # eingefÃŒgt 2019-04
                #-      NAME "Krankenhaus"
                        EXPRESSION "3321"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3321_2"
                        END
                END
                CLASS
                #-      NAME "Kindergarten"
                        EXPRESSION "3323"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3323_2"
                        END
                END
                CLASS
                #-      NAME "Polizei"
                        EXPRESSION "3324"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3324_2"
                        END
                END
                CLASS
                #-      NAME "Feuerwehr"
                        EXPRESSION "3326"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3326_2"
                        END
                END
                CLASS   # eingefÃŒgt 2019-04
                #-      NAME "GebÀude zum Busbahnhof"
                        EXPRESSION "3332"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.5062
                                SYMBOL "norGIS_alkis3332_2"
                        END
                END
                CLASS
                #-      NAME "Hallenbad"
                        EXPRESSION "3334"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.2313
                                SYMBOL "norGIS_alkis3334_2"
                        END
                END
                CLASS
                #-      NAME "Tiefgarage"
                        EXPRESSION "3336"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 6.5712
                                SYMBOL "norGIS_alkis3336_2"
                        END
                END
                CLASS   # eingefÃŒgt 2019-04
                #-      NAME "Apotheke"
                        EXPRESSION "3338"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3338_2"
                        END
                END
                CLASS   # eingefÃŒgt 2019-04
                #       NAME "(3340)"
                        EXPRESSION "3340"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 5.0077
                                SYMBOL "norGIS_alkis3340_2"
                        END
                END
                CLASS
                #-      NAME "Umformer"
                        EXPRESSION "3521"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0 0 0
                                SIZE 3.6935
                                SYMBOL "norGIS_alkis3521_2"
                        END
                END
        END #*
        
        LAYER NAME "pg2" # GebÀude / Punkte     2019-04: umbenannt von pg in pg2 analog zu alkisn -> entspricht QGIS ALKIS/GebÀude/GebÀude/Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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"
                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 NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        #wms_title "Punkte"
                        wms_title "Punkte (GebÀude)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                # CLASS sortiert nach Nummer in Expression
                CLASS
                #-      NAME "Großsteingrab (Dolmen), HÃŒnenbett"
                        EXPRESSION "3526"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1043
                                SYMBOL "norGIS_alkis3526_2"
                        END
                END
                CLASS
                #       NAME "(3527)"
                        EXPRESSION "3527"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0 0 0
                                SIZE 3.8294
                                SYMBOL "norGIS_alkis3527_2"
                        END
                END
                CLASS
                #       NAME "(3528)"
                        EXPRESSION "3528"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 3.1043
                                SYMBOL "norGIS_alkis3528_2"
                        END
                END
                CLASS
                #-      NAME "Brunnen / Gasquelle, Mofette / Heilquelle"
                        EXPRESSION "3529"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 2.6965
                                SYMBOL "norGIS_alkis3529_2"
                        END
                END
                CLASS
                #-      NAME "Denkmal"
                        EXPRESSION "3532"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 4.866
                                SYMBOL "norGIS_alkis3532_2"
                        END
                END
                CLASS
                #       NAME "(3533)"
                        EXPRESSION "3533"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.2
                                SYMBOL "norGIS_alkis3533_2"
                        END
                END
                CLASS
                #-      NAME "Bildstock"
                        EXPRESSION "3534"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 4.2202
                                SYMBOL "norGIS_alkis3534_2"
                        END
                END
                CLASS
                #-      NAME "Gipfel-/Wegekreuz"
                        EXPRESSION "3535"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 4.0149
                                SYMBOL "norGIS_alkis3535_2"
                        END
                END
                CLASS
                #-      NAME "Meilenstein, historischer Grenzstein"
                        EXPRESSION "3536"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 1
                                SIZE 2.8688
                                SYMBOL "norGIS_alkis3536_2"
                        END
                END
                CLASS
                #-      NAME "Brunnen (Trinkwasserversorgung)"
                        EXPRESSION "3537"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                                SIZE 3.1949
                                SYMBOL "norGIS_alkis3537_2"
                        END
                END
                CLASS
                #-      NAME "Springbrunnen, Zierbrunnen"
                        EXPRESSION "3539"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 4.056
                                SYMBOL "norGIS_alkis3539_2"
                        END
                END
                CLASS
                #-      NAME "Ziehbrunnen"
                        EXPRESSION "3540"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 2
                                SIZE 6.2498
                                SYMBOL "norGIS_alkis3540_2"
                        END
                END
        END #*  
        
        #       LAYER NAME "bg"  # GebÀude / Beschriftungen
        LAYER NAME "bgh" # GebÀude / Hausnummer (HauptgebÀude)
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                # Daten der neuen Layer hier raus: Dachform usw.
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 3500
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                #       wms_title "Beschriftungen (Punkte)"
                #       wms_title "Beschriftungen"
                        wms_title "Hausnummern (GebÀude)"
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2 FORCE TRUE
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*

        # LAYER bg2 GebÀude / Laufende Hausnummern / Beschriftungen
        LAYER NAME "bgn" # GebÀude / NebengebÀude lfd. Nr. # NebengebÀude-Nummer in Klammer, normalerweise aus
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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 \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude" # "/GebÀude/Laufende Hausnummern"
                        wms_title "NebengebÀude lfd. Nr. (GebÀude)" # "Beschriftungen (Punkte)"
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn]  BUFFER 2
                                FORCE TRUE
                #               OFFSET 0 0
                                OUTLINECOLOR 255 255 255 COLOR [color_umn]
                                POSITION [position_umn] PRIORITY 10
                #               SHADOWSIZE 0 0
                        END
                END
        END #*

        LAYER NAME "bgd" # GebÀude / Dachform
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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 \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_dachform','ax_bauteil_dachform')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Dachform (GebÀude)"
                END
                MINSCALEDENOM 0
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                FORCE TRUE
                                OUTLINECOLOR 255 255 255 COLOR [color_umn]
                                POSITION [position_umn] PRIORITY 10
                        END
                END
        END #*

        LAYER NAME "bgf" # GebÀude / Funktion
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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 \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_funktion','ax_bauteil_funktion','ax_turm_funktion')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Funktion (GebÀude)"
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                                FORCE TRUE
                                POSITION [position_umn] PRIORITY 10
                        END
                END
        END #*

        LAYER NAME "bgg" # GebÀude / Geschosse
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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 \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_geschosse','ax_bauteil_geschosse')) 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Geschosse (GebÀude)"
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                                FORCE TRUE
                                POSITION [position_umn] PRIORITY 10
                        END
                END
        END #*

        LAYER NAME "bgz" # GebÀude / Zustand
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                # Mai 2019: "... WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R'  ..." Kein Beispiel gefunden an dem ÃŒberprÃŒft werden kann, ob das so richtig ist oder 'R' und 'L' vertauscht werden mÃŒssten.
                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 \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_gebaeude_zustand') 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:3034 EPSG:3857"
                        wms_layer_group "/GebÀude"
                        wms_title "Zustand (GebÀude)"
                END
                MINSCALEDENOM 0
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                                FORCE TRUE
                                POSITION [position_umn] PRIORITY 10
                        END
                END
        END #*
        
        
## ## Gruppe Rechtliche Festlegung

        LAYER NAME "gr" # Rechtliche Festlegungen / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Rechtliche Festlegungen"
                        wms_title "Grenzen (Rechtl. Festlegungen)"
                        wms_enable_request "GetFeatureInfo !GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE POLYGON
                UNITS METERS

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

                CLASS
                #-      NAME "Bau-, Raum-, Bodenordnungsrecht"
                        EXPRESSION "rn1704"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 153 153 153
                                PATTERN 4.00 1.00 END
                                SIZE 1
                        END
                END
        END #*
        
        LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 25000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Rechtliche Festlegungen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (Rechtl. Festlegungen)"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2 PRIORITY 10
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn]
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ## Gruppe Politische Grenzen

        LAYER NAME "lp" # Politische Grenzen / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                        wms_layer_group "/Politische Grenzen"
                        wms_title "Linien (Polit. Grenzen)"
                        wms_enable_request "!GetLegendGraphic"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                # Bemerkung: Die folgenden 3 Classes wurden aus QGIS doppelt generiert, mit unterschiedlicher Anzahl blinder STYLE-END-Paare, Nur jeweils 1 Class ÃŒbernommen.

                CLASS
                #-      NAME "Flurgrenze" # Strich - 3 Punkte
                        EXPRESSION "2012"
                        STYLE # Grundierung
                                COLOR 255 255 255
                                WIDTH 1.01
                        END

                ##      Lösung mit 2 Ìberlappenden Styles
                #       STYLE # eckige Enden
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 5.00 11.00 END # Summe 16
                #       #       SIZE 1
                #               WIDTH 1
                #       END
                #       STYLE # LÀnge 0 + ROUND macht Punkte
                #       #       COLOR 102 102 102
                #               COLOR 202 102 102
                #               INITIALGAP 7.5
                #               LINECAP round LINEJOIN round
                #       #       PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END # Summe 16 - theoretisch korrekt, lÀuft aber auseinander
                #               PATTERN 0.00 2.80 0.00 2.80 0.00 10.00 END # sieht in großen MaßstÀben besser aus
                #       #       SIZE 1
                #               WIDTH 1
                ##      END

                ## Alternative in EINEM Style. Striche und Punkte beide rund. Aber wenigstens Synchron.
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                PATTERN 5.00 2.5 0.00 3.00 0.00 3.00 0.00 2.5 END
                                WIDTH 1
                        END
                END

                CLASS
                #-      NAME "Gemarkungsgrenze" # Strich - Punkt - Punkt
                        EXPRESSION "2014"
                        # Hier wurden 9 blinde STYLE-END-Paare generiert. -> 3 reichen
                        STYLE END STYLE END STYLE END 
                #       STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END

                        STYLE
                                COLOR 255 255 255
                                WIDTH 1.01
                        END

                ##      2 Styles
                #       STYLE
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 5.00 8.00 END # Summe 13
                #       #       SIZE 1
                #               WIDTH 1
                #       END
                #       STYLE
                #               COLOR 102 102 102
                #               INITIALGAP 7.5
                #               LINECAP round LINEJOIN round
                #               PATTERN 0.00 3.00 0.00 10.00 END # Summe 13 - theoretisch korrekte Lösung
                #       #       PATTERN 0.00 2.80 0.00  9.90 END # praktisch funktionierende Lösung fÌr mapserver 7.0.7
                #       #       SIZE 1
                #               WIDTH 1
                ##      END

                ##      1 Style
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                PATTERN 5.00 2.5 0.00 3.00 0.00 2.5 END
                                WIDTH 1
                        END
                END

                CLASS
                        NAME "Gemeindegrenze" # Strich - Punkt
                        EXPRESSION "2022"
                        # Hier wurden 45 blinde STYLE-END-Paare generiert. -> 6 reichen
                        STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END 
                #       STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END

                        STYLE # weisser Grund
                                COLOR 255 255 255
                                WIDTH 1.01
                        END

                ##      2 Styles aus QGIS-Generierung
                #       STYLE # Strichelierung
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 5.00 5.00 END # Summe 10
                #       #       SIZE 1
                #               WIDTH 1
                #       END
                #       STYLE # Punkte in den LÃŒcken der Strichelung
                #               COLOR 102 102 102
                #               INITIALGAP 7.5
                #               LINECAP round LINEJOIN round
                #       #       PATTERN 0.00 10.00 END # Summe 10 - sollte also synchron sein zum vorhergehenden Style, verschiebt sich aber mit jedem Strich
                #               PATTERN 0.00  9.90 END # theoretisch falsch, funktioniert aber im Mapserver 7.0.7. Rundungs-Problem?
                #       #       SIZE 1
                #               WIDTH 1
                ##      END                                     

                ##      1 Style
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                PATTERN 5.00 2.5 0.00 2.5 END # Summe 10
                                WIDTH 1
                        END
                END

                CLASS
                #-      NAME "Landkreisgrenze"
                        EXPRESSION "2010"
                        # hier wurden 189 blinde STYLE-END-Paare generiert. Muss das? -> 9 reichen
                        STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END 
                #       STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 1.515
                        END

                ##      2 Styles
                #       STYLE
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 7.00 12.00 END # Summe 19
                #               SIZE 1.5 WIDTH 1.5
                #       END
                #       STYLE
                #               COLOR 102 102 102
                #               INITIALGAP 10.75
                #               LINECAP round LINEJOIN round
                #               PATTERN 0.00 4.50 0.00 14.50 END # Summe 19
                #               SIZE 1.5 WIDTH 1.5
                ##      END

                ##      1 Style
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                PATTERN 7.00 3.75 0.00 4.50 0.00 3.75 END # Summe 19
                                WIDTH 1.5
                        END
                END

                CLASS
                #-      NAME "Regierungsbezirksgrenze"
                        EXPRESSION "2020"
                        # hier wurden 765!! blinde STYLE-END-Paare generiert. Ist das wirklich sinnvoll und notwendig fÃŒr eine korrekte Darstellung?? -> 12 reichen
                        STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END     STYLE END STYLE END 
                #       STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                #       STYLE END STYLE END STYLE END STYLE END STYLE END
                        STYLE
                                COLOR 255 255 255
                                WIDTH 1.515
                        END

                ##      2 Styles
                #       STYLE
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 7.00 3.00 7.00 12.00 END # Summe 29
                #               SIZE 1.5 WIDTH 1.5
                #       END
                #       STYLE
                #               COLOR 102 102 102
                #               INITIALGAP 20.75
                #               LINECAP round LINEJOIN round
                #               PATTERN 0.00 4.50 0.00 24.50 END # Summe 29
                #               SIZE 1.5 WIDTH 1.5
                ##      END

                ##      1 Style
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                #            10   17   20.75     25.25     29.0
                                PATTERN 7.00 3.00 7.00 3.75 0.00 4.50 0.00 3.75 END # Summe 29
                                WIDTH 1.5
                        END
                END

                CLASS
                #-      NAME "Landesgrenze"
                        EXPRESSION "2018"

                        # Hier wurden 3069!! blinde STYLE-END-Paare generiert. Ist das fÃŒr eine korrekte Darstellung wirklich notwendig? -> 15 reichen
                        STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END

                        STYLE
                                COLOR 255 255 255
                                WIDTH 2.02
                        END

                ##      2 Styles
                #       STYLE
                #               COLOR 102 102 102
                #               LINECAP butt LINEJOIN round
                #               PATTERN 8.00 3.50 8.00 9.00 END # Summe 28.5
                #       #       SIZE 2
                #               WIDTH 2
                #       END
                #       STYLE
                #               COLOR 102 102 102
                #               INITIALGAP 24
                #               LINECAP round LINEJOIN round
                #               PATTERN 0.00 28.50 END # Summe 28.5
                #       #       SIZE 2
                #               WIDTH 2
                ##      END

                ##      1 Style
                        STYLE
                                COLOR 102 102 102
                                LINECAP round LINEJOIN round
                                #            11.5 19.5 24      28.5
                                PATTERN 8.00 3.50 8.00 4.5 0.0 4.5 END # Summe 28.5
                                WIDTH 2
                        END
                END
        END
        
        
## ## Gruppe Lagebezeichnungen

        LAYER NAME "bl" # Lagebezeichnungen / Beschriftungen (Punkte)
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                        wms_layer_group "/Lagebezeichnungen"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen Punkte (Lagebez.)"
                        wms_enable_request "!GetLegendGraphic"
                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 FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*

        LAYER NAME "bll" # Lagebezeichnungen / Beschriftungen (Linien)
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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,st_offsetcurve(line,0.125*skalierung*grad_pt,'') AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND line IS NOT 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:3034 EPSG:3857"
                        wms_layer_group "/Lagebezeichnungen"
                        wms_title "Beschriftungen Linien (Lagebez.)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS INCHES
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE LINE
                UNITS METERS
                CLASS
                        LABEL
                                ANGLE FOLLOW
                                ANTIALIAS TRUE FORCE TRUE
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn] BUFFER 2
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION CC PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
        
        
## ## */ Gruppe FlurstÃŒcke

        LAYER NAME "gff" # FlurstÌcke / FlÀchen / Grenzen
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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"
                # Filter signaturnummer = '2028' sinnvoll?: Nein keine Reduzierung der Menge

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

                HEADER   "/opt/gdi/alkisn/templates/alkisauskh.html" 
                TEMPLATE "/opt/gdi/alkisn/templates/alkisausk.html" # gkz aus Mapfile-Name!
                FOOTER   "/opt/gdi/alkisn/templates/footer.html"
                TOLERANCEUNITS pixels TOLERANCE 1

                TYPE POLYGON
                UNITS METERS
                CLASS
                #-      NAME "FlurstÃŒcksgrenze"
                        EXPRESSION "2028"
                        STYLE
                                LINECAP SQUARE LINEJOIN ROUND
                                OUTLINECOLOR 0 0 0
                        #       SIZE 0.35
                                WIDTH 0.35
                        #       OUTLINEWIDTH 0.35 # etwa doppelt so dick wie WIDTH ?!
                        END
                END
        END #*

        LAYER NAME "lfn" # FlurstÃŒcke / Nummern / Linien
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                CONNECTIONTYPE POSTGIS
                DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                MAXSCALEDENOM 5000
                REQUIRES "[bfn]" # Zuordnungspfeile nur zusammen mit den FlurstÃŒcksnummern
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                #       wms_layer_group "/FlurstÃŒcke/Nummern"
                #       wms_title "Linien"
                        wms_layer_group "/FlurstÃŒcke"
                        wms_title "Zuordnung (FlurstÃŒcke)"
                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, abweichender Rechtszustand"
                        EXPRESSION "2005"
                        STYLE END STYLE END
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.1818
                        END
                        STYLE
                                COLOR 204 204 204
                                LINEJOIN ROUND
                        #       SIZE 0.18
                                WIDTH 0.18
                        END
                END
                CLASS
                #-      NAME "Zuordnungspfeil"
                        EXPRESSION "2004"
                        STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END
                        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='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                #       wms_layer_group "/FlurstÌcke/FlÀchen"
                        wms_layer_group "/FlurstÃŒcke"
                        wms_title "Linien (FlurstÃŒcke)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                TYPE LINE
                UNITS METERS
                CLASS
                #-      NAME "FlurstÃŒcksgrenze, abw. Rechtszustand"
                        EXPRESSION "2029"
                        STYLE
                                COLOR 255 255 255
                        #       OPACITY 0
                                WIDTH 0.3535
                        END
                        STYLE
                                COLOR 204 204 204
                                LINECAP SQUARE LINEJOIN ROUND
                        #       SIZE 0.35
                                WIDTH 0.35
                        END
                END
                CLASS
                #-      NAME "Strittige Grenze"
                        EXPRESSION "2006"
                        STYLE END STYLE END
                        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 END STYLE END STYLE END STYLE END STYLE END STYLE END # DarstellungsprioritÀt anheben
                        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 NAME "pff" # FlurstÌcke / FlÀchen / Punkte
                CLASSITEM "signaturnummer"
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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:3034 EPSG:3857"
                #       wms_layer_group "/FlurstÌcke/FlÀchen"
                        wms_layer_group "/FlurstÃŒcke"
                        wms_title "Punkte (FlurstÃŒcke)"
                END
                PROCESSING "CLOSE_CONNECTION=DEFER"
                PROJECTION "init=epsg:25832" END
                SIZEUNITS METERS
                STATUS OFF
                SYMBOLSCALEDENOM 1000
                TYPE POINT
                UNITS METERS
                CLASS
                #-      NAME "Abgemarkter Grenzpunkt"
                        EXPRESSION "3020"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3020_2"
                        END
                END
                CLASS
                #-      NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"
                        EXPRESSION "3022"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3022_2"
                        END
                END
                CLASS
                #-      NAME "Grenzpunkt ohne spezifizierte Abmarkung"
                        EXPRESSION "3024"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.5182
                                SYMBOL "norGIS_alkis3024_2"
                        END
                END
                CLASS
                #-      NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"
                        EXPRESSION "3022"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3022_2"
                        END
                END
                CLASS
                #       NAME "(3011)"
                        EXPRESSION "3011"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 1
                                SIZE 2.2509
                                SYMBOL "norGIS_alkis3011_2"
                        END
                END
                CLASS
                #-      NAME "FlurstÃŒcksÃŒberhaken"
                        EXPRESSION "3010"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 1
                                SIZE 2.2509
                                SYMBOL "norGIS_alkis3010_2"
                        END
                END
                CLASS
                #-      NAME "Abgemarkter Grenzpunkt, abw. Rechtszustand"
                        EXPRESSION "3021"
                        STYLE
                                ANGLE [drehwinkel_grad]
                                MINSIZE 1
                        #       OFFSET 0 0
                                SIZE 1.6995
                                SYMBOL "norGIS_alkis3021_2"
                        END
                END
        END #*

        LAYER NAME "bfn" # FlurstÃŒcke / Nummern / Beschriftungen
                CONNECTION "dbname='alkis0*gkz*' host=10.0.100.75 port=5432 user='ms7'"
                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=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832"
                EXTENT ..
                LABELITEM "text"
                MAXSCALEDENOM 5000
                METADATA
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
                #       wms_layer_group "/FlurstÃŒcke/Nummern"
                        wms_layer_group "/FlurstÃŒcke"
                #       wms_title "Beschriftungen (Punkte)"
                        wms_title "Beschriftungen (FlurstÃŒcke)"
                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
                                TYPE TRUETYPE FONT [font_umn]
                                SIZE [size_umn]
                                BUFFER 2 FORCE TRUE
                                COLOR [color_umn] OUTLINECOLOR 255 255 255
                        #       OFFSET 0 0
                                POSITION [position_umn] PRIORITY 10
                        #       SHADOWSIZE 0 0
                        END
                END
        END #*
END