source: trunk/umn/alkis/alkis_muster_entw_4.map @ 349

# WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion zur Entwickler-Version
# Änderungen: siehe Bildschirm-Version, letzte:
# 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel
# 2014-09-15 F.J. krz: Filter fÃŒr Historische Objekte "WHERE endet IS NULL" in DATA fÃŒr Tabellen ax_*
# 2014-10-28 F.J. krz: "ANGLE follow" bei ap_lto_stra, Textgrößen verkleinert in PrÀsentation
# 2014-10-28 F.J. krz: Versuch "OPACITY 80" auf "nutzung_alle"
# 2014-10-29 F.J. krz: Straßennamen auf Liniengeometrie besser positionieren
# 2014-12-16 F.J. krz: 3 Layer in Gebiete auf Views umgestellt

MAP
        NAME "alkis"
        STATUS ON
        EXTENT 349000 5529000 356000 5533000
        PROJECTION "init=epsg:25832" END
        MAXSIZE 8400 # _4-Druck
        SYMBOLSET "symbols/symbols_alkis.sym"
        FONTSET "fonts/fonts_alkis.fnt" 
        UNITS METERS
        WEB
                METADATA
                        wms_title "ALKIS_"
                        wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
                        wms_encoding "UTF-8"
                        wms_onlineresource "http://ows.krz.de/cgi-bin/mapserv6?map=/opt/gdi/alkis08/alkis08*gkz*a_4.map"
                        ows_schema_location ".."
                        wms_enable_request "getmap"
                        wms_box_extended "true"
                        #include "meta_contact.map"
                END
        END
        LEGEND
                STATUS ON
                KEYSIZE 32 16
                KEYSPACING 5 5
                TRANSPARENT ON
                LABEL
                        TYPE TRUETYPE
                        FONT 'arial'
                        SIZE 9
                        COLOR 1 1 1
                END
        END

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

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

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

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

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

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

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

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

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

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

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

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

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

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

# ALKIS  AAA-PrÀsentationsobjekte

LAYER
        NAME "ap_pto_stra"
        GROUP "praesentation"
        TYPE POINT
        CONNECTIONTYPE POSTGIS
        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
        PROCESSING "CLOSE_CONNECTION=DEFER"
        DATA "the_geom from (SELECT * FROM pp_strassenname_p) as foo using unique gid using SRID=25832"
        METADATA
                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
                wms_title "Straßen ."
                wms_group_title "PrÀsentation"
        END
        #PROJECTION "init=epsg:25832" END
        #EXTENT 349000 5529000 356000 5533000
        MAXSCALEDENOM 625 #2500
        SYMBOLSCALEDENOM 250 #1000
        LABELITEM "schriftinhalt"

        # Strasse
        CLASS
                EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'linksbÃŒndig' AND '[ver]' eq 'Basis')
                #NAME 'Straße'
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION ur # linksbÃŒndig/Basis
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
                #NAME 'Straße'
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION cc # zentrisch/Mitte
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Strasse') 
                NAME 'Straße'
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION uc # zentrisch/Basis
                        COLOR 0 0 0
                        FORCE true
                END
        END

        # Weg
        CLASS
                EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'linksbÃŒndig' AND '[ver]' eq 'Basis')
                #NAME 'Weg'
                LABEL
                        SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
                        TYPE TRUETYPE FONT "arial"
                        ANGLE [winkel] 
                        POSITION ur # linksbÃŒndig/Basis
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
                #NAME 'Weg'
                LABEL
                        SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
                        TYPE TRUETYPE FONT "arial"
                        ANGLE [winkel] POSITION cc # zentrisch/Mitte
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Weg')
                NAME 'Weg'
                LABEL
                        SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
                        TYPE TRUETYPE FONT "arial"
                        ANGLE [winkel] POSITION uc # zentrisch/Basis
                        COLOR 0 0 0
                        FORCE true
                END
        END

        # Platz 
        CLASS
                #EXPRESSION 'Platz'
                EXPRESSION ('[art]' eq 'Platz' AND '[ver]' eq 'Mitte')
                #NAME 'Platz'
                LABEL
                        SIZE 36 MINSIZE 28 MAXSIZE 80 # 9 7 20
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION cc # zentrisch/Mitte
                        COLOR 0 0 90
                        FORCE true
                END
        END
        CLASS
                #EXPRESSION 'Platz'
                EXPRESSION ('[art]' eq 'Platz')
                NAME 'Platz'
                LABEL
                        SIZE 36 MINSIZE 28 MAXSIZE 80 # 9 7 20
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION uc # zentrisch/Basis
                        COLOR 0 0 90
                        FORCE true
                END
        END

        # Klassifikation
        CLASS
                #EXPRESSION 'BezKlassifizierungStrasse'
                EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse' AND '[hor]' eq 'linksbÃŒndig')
                #NAME 'Klassifizierung'
                LABEL
                        SIZE 40 MINSIZE 32 MAXSIZE 80 # 10 8 20
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION ur # linksbÃŒndig/Basis
                        COLOR 0 90 0
                        FORCE true
                END
        END
        CLASS
                #EXPRESSION 'BezKlassifizierungStrasse'
                EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse')
                NAME 'Klassifizierung'
                STYLE
                        SYMBOL "point" SIZE 1 MINSIZE 1
                END
                LABEL
                        SIZE 40 MINSIZE 32 MAXSIZE 80 # 10 8 20
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE [winkel] POSITION uc # zentrisch/Basis
                        COLOR 0 90 0
                        FORCE true
                END
        END
END

LAYER
        NAME "ap_lto_stra"
        GROUP "praesentation"
        TYPE LINE
        REQUIRES "[ap_pto_stra]" # P- und L gemeinsam
        STATUS DEFAULT # automatisch mit
        CONNECTIONTYPE POSTGIS
        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432"
        PROCESSING "CLOSE_CONNECTION=DEFER"
        DATA "the_geom from (SELECT * FROM pp_strassenname_l) as foo using unique gid using SRID=25832"
        METADATA
                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
                wms_title "Straßen _"
        END
        #PROJECTION "init=epsg:25832" END
        #EXTENT 349000 5529000 356000 5533000
        MAXSCALEDENOM 625 #2500
        SYMBOLSCALEDENOM 250 #1000
        LABELITEM "schriftinhalt"

        # Strasse
        CLASS
                EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'linksbÃŒndig' AND '[ver]' eq 'Basis')
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        ANGLE follow
                        OFFSET 9 99 # 3 99
                        POSITION uc
                        TEXT '[schriftinhalt]      ' 
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Strasse' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        #POSITION cc # zentrisch/Mitte
                        ANGLE follow
                        COLOR 0 0 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'Strasse') 
                NAME 'Straße'
                LABEL
                        SIZE 32 MINSIZE 24 MAXSIZE 64 # 8 6 16
                        TYPE TRUETYPE FONT "arialbold"
                        POSITION uc
                        ANGLE follow
                        COLOR 0 0 0
                        FORCE true
                END
        END

        # Weg
        CLASS
                EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'linksbÃŒndig' AND '[ver]' eq 'Basis')
                LABEL
                        SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
                        TYPE TRUETYPE FONT "arial"
                        ANGLE follow
                        POSITION uc
                        OFFSET 9 99 # 3 99
                        TEXT '[schriftinhalt]    '
                        COLOR 0 0 0
                        FORCE true
                END
        END
        #CLASS
        #       EXPRESSION ('[art]' eq 'Weg' AND '[hor]' eq 'zentrisch' AND '[ver]' eq 'Mitte')
        #       LABEL
        #               SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
        #               TYPE TRUETYPE FONT "arial"
        #               POSITION cc # zentrisch/Mitte
        #               ANGLE follow
        #               COLOR 0 0 0
        #               FORCE true
        #       END
        #END
        CLASS
                EXPRESSION ('[art]' eq 'Weg')
                NAME 'Weg'
                LABEL
                        SIZE 28 MINSIZE 20 MAXSIZE 56 # 7 5 14
                        TYPE TRUETYPE FONT "arial"
                        POSITION uc # zentrisch/Basis
                        ANGLE follow
                        COLOR 0 0 0
                        FORCE true
                END
        END

        # Platz 
#       CLASS
#               EXPRESSION ('[art]' eq 'Platz' AND '[ver]' eq 'Mitte')
#               LABEL
#                       SIZE 36 MINSIZE 28 MAXSIZE 80 # 9 7 20
#                       TYPE TRUETYPE FONT "arialbold"
#                       POSITION cc # zentrisch/Mitte
#                       ANGLE follow
#                       COLOR 0 0 90
#                       FORCE true
#               END
#       END
#       CLASS
#               EXPRESSION ('[art]' eq 'Platz')
#               NAME 'Platz'
#               LABEL
#                       SIZE 36 MINSIZE 28 MAXSIZE 80 # 9 7 20
#                       TYPE TRUETYPE FONT "arialbold"
#                       POSITION uc # zentrisch/Basis
#                       ANGLE follow
#                       COLOR 0 0 90
#                       FORCE true
#               END
#       END

        # Klassifikation
        CLASS
                EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse' AND '[hor]' eq 'linksbÃŒndig')
                LABEL
                        SIZE 40 MINSIZE 32 MAXSIZE 80 # 10 8 20
                        TYPE TRUETYPE FONT "arialbold"
                        POSITION ur # linksbÃŒndig/Basis
                        ANGLE follow
                        COLOR 0 90 0
                        FORCE true
                END
        END
        CLASS
                EXPRESSION ('[art]' eq 'BezKlassifizierungStrasse')
                NAME 'Klassifizierung'
                LABEL
                        SIZE 40 MINSIZE 32 MAXSIZE 80 # 10 8 20
                        TYPE TRUETYPE FONT "arialbold"
                        POSITION uc # zentrisch/Basis
                        ANGLE follow
                        COLOR 0 90 0
                        FORCE true
                END
        END
END

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

# ap_ppo fehlt noch

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

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