MAP # ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet für mapserver 7 # Stand: # 2016-05-19 generiert, angepasst und optimiert # 2016-05-20 Legende unterdrücken # 2016-05-23 Flurstücke: 2stufige Gruppierung raus. "wms_enable_request" pauschal "*" im Root. # Beschriftung: links-/rechtsbündig vertauscht. # 2017-11-24 Abgleich mit neuer Generierung aus QGIS-Plugin, mapserver 7.0.7 ### Erlaeuterungen: # ## Dies ist ein reichlich kommentriertes Muster-Mapfile. Für den produktiven Einsatz sollten Kommentare, Leerzeilen usw. mit einem Programm wie "MapTrimmer" entfernt werden. # ## SVG: # Die SVG-Symbole sind aus dem norBIT-ALKIS-Plugin zu entnehmen: # Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\ # Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ # ## Layername: # Der aus QGIS generierte Layername ("l" + lfd.Nr) ist unterschiedlich je Mandant, # und wird daher zur Vereinheitlichung ersetzt durch die Buchstaben für "Typ" und "Gruppe" aus der unten stehenden Liste. # ## Layer und Klassen: # Dies Muster-Mapfile wurde generiert auf der Basis von NBA-Daten für einige Staedte in Ost-Westfalen. # Für den Einsatz in anderen Kreisen und anderen Regionen ist dies durch lokale Layer und Klassen zu ergänzen. # ## HQ-Print: # Es wird keine _4-Mapdatei mehr für High-Quality-Print mit 288dpi aufbereitet. # Statt dessen wird für den HQ-Print der GetMap-Call ergänzt um den Parameter: "&map.resolution=288" # Beispiel für Mapbender 2.7: # UPDATE gui_element_vars SET var_value = '[{"pattern": ".map&", # "replacement": {"144": ".map&map.resolution=144&", "288": ".map&map.resolution=288&"}}]' # WHERE fkey_e_id = 'printPDF' AND var_name ='highqualitymapfiles'; ## Typen: # g Grenzen # f Flächen # l Linien # p Punkte # b Beschriftungen ## Gruppen: # h Friedhöfe # e Vegetation # b Wohnbauflächen # t Topographie # w Gewässer # s Sport und Freizeit # i Industrie und Gewerbe # v Verkehr # g Gebäude # r Rechtliche Festlegungen # f Flurstücke # fn Flurstücke/Nummern # ff Flurstücke/Flächen # p Politische Grenzen # l Lagebezeichnungen ### Layer-Reihenfolge ## */ Flächen + Grenzen # -fh Friedhöfe / Flächen # gh Friedhöfe / Grenzen # fe Vegetation / Flächen # -fb Wohnbauflächen / Flächen # gt Topographie / Grenzen # ge Vegetation / Grenzen # -gb Wohnbauflächen / Grenzen # -fw Gewässer / Flächen # -fs Sport und Freizeit / Flächen # gs Sport und Freizeit / Grenzen # gw Gewässer / Grenzen # fi Industrie und Gewerbe / Flächen # gi Industrie und Gewerbe / Grenzen # fv Verkehr / Flächen # gv Verkehr / Grenzen # fg Gebäude / Flächen # gg Gebäude / Grenzen # gr Rechtliche Festlegungen / Grenzen # gff Flurstücke / Flächen / Grenzen ## */ Linien # lt Topographie / Linien # lw Gewässer / Linien # lv Verkehr / Linien # li Industrie und Gewerbe / Linien # lg Gebäude / Linien # lp Politische Grenzen / Linien # lfn Flurstücke / Nummern / Linien # lff Flurstücke / Flächen / Linien ## */ Punkte # pff Flurstücke / Flächen / Punkte # pg Gebäude / Punkte # pv Verkehr / Punkte # pe Vegetation / Punkte # pw Gewässer / Punkte # pi Industrie und Gewerbe / Punkte # ps Sport und Freizeit / Punkte # pt Topographie / Punkte ## */ Beschriftungen # bfn Flurstücke / Nummern / Beschriftungen # bg -> bgh Gebäude / Hausnummern # bg2 -> bgn Gebäude / lfd. Nr. Nebengebäude # (NEU) bgd Gebäude / Dachform # (NEU) bgf Gebäude / Funktion # (NEU) bgg Gebäude / Geschosse # (NEU) bgz Gebäude / Zustand # bl Lagebezeichnungen / Beschriftungen # br Rechtliche Festlegungen / Beschriftungen # bv Verkehr / Beschriftungen # bh Friedhöfe / Beschriftungen # be Vegetation / Beschriftungen # bw Gewässer / Beschriftungen # bi Industrie und Gewerbe / Beschriftungen # bs Sport und Freizeit / Beschriftungen # bb Wohnbauflächen / Beschriftungen # bt Topographie / Beschriftungen NAME "alkissw" STATUS ON #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" EXTENT .. PROJECTION "init=epsg:25832" END MAXSIZE 8400 # reicht fuer 288 dpi auf DIN-A2 DEFRESOLUTION 72 SYMBOLSET "symbolssw.sym" # ausgelagert, ursprünglich hier inline generiert FONTSET "/opt/gdi/alkisn/fonts/fonts.txt" UNITS METERS WEB METADATA wms_title "ALKIS sw" wms_abstract "ALKIS Schwarz/Weiß- bzw. Graustufen-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom November 2017. Die Legende wäre zu umfangreich. Sie wird hier nur für eine kleine Anzahl Objekte ausgegeben. Eine vollständige Beschreibung der Zeichenvorschrift für ALKIS findet man z.B. in http://sg.geodatenzentrum.de/web_public/adv/sk/alkis/docAlkisSW/SymbologyCatalog.html ." wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_bbox_extended "true" wms_encoding "UTF-8" wms_onlineresource "http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkissw*gkz*.map" # Die Position von "GKZ" im Mapfile-Namen muss 3stellig sein, am Ende vor ".map". # GKZ wird vom Template über den [map] ausgelesen um die richtige DB der Auskunft zu finden. wms_feature_info_mime_type "text/html" wms_schema_location ".." wms_keywordlist "ALKIS,Flurstück,NAS" wms_fees "none" wms_accessconstraints "für den Dienstgebrauch" wms_enable_request "*" # Bis der Fehler geklärt ist # wms_enable_request "GetCapabilities GetMap" # Rest je Layer individuell addieren include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt END END LEGEND STATUS ON KEYSIZE 32 16 KEYSPACING 5 5 LABEL TYPE TRUETYPE FONT 'arial' SIZE 11 COLOR 1 1 1 END END ## ---------------------------------------------- ## Layer der Typen Flächen + Grenzen ## ---------------------------------------------- LAYER NAME "gh" # FriedHöfe / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Friedhöfe" wms_title "Grenzen" #wms_enable_request "GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME "[2515]" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "fe" # VEgetation / Flächen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2515' AND thema='Wohnbauflächen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # Filter Signaturnummer 2200 : 0 DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Wohnbauflächen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Wohnbauflächen" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME "[2515]" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END END #* # -fb Wohnbauflächen / Flächen (verschoben und umbenannt Nov. 2017) LAYER NAME "gt" # Topographie / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = 'rn1551' AND thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # Filter "signaturnummer = 'rn1551' AND" 6:0 DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME '{"Damm, Wall, Deich","Felsen, Felsblock, Felsnadel",Rückhaltebecken,"Sonstiges Gewässermerkmal",Staudamm,"Staudamm, außer Betrieb"}' EXPRESSION "rn1551" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "ge" # VEgetation / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME "[2515]" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Wald" EXPRESSION "2517" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Baumbestand, Laub- und Nadelholz","Baumbestand, Laubholz","Baumbestand, Nadelholz",Gebüsch,"Gehölz (Vegetationsmerkmal)",Gras,Korbweide,Reet,"Röhricht, Schilf",Zierfläche}' EXPRESSION "rn1560" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Rain,Schneise}" EXPRESSION "rn1561" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Vegetationsmerkmal, Zustand nass"}' EXPRESSION "rn1563" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "fw" # Gewässer / Flächen ## FEHLER: "fb = "WohnBauflächen / Flächen # Layer umbenannt und verschoben CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # Nur verwendete Sätze auslesen: DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer IN ('1308','1523','2510') AND thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # SELECT count(ogc_fid) AS ungefiltert FROM po_polygons WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL # SELECT count(ogc_fid) AS gefiltert FROM po_polygons WHERE signaturnummer IN ('1308','1523','2510') AND thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL # 300: 10824 : 1435 Sätze --> Filtern! # Was fehlt? # SELECT sn_flaeche AS signaturnummer, count(ogc_fid) AS anzahl FROM po_polygons WHERE signaturnummer NOT IN ('1308','1523','2510') AND thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL GROUP BY sn_flaeche # "1548"; 16 # "1562"; 5 # "1550"; 436 # "1410"; 8810 # "1551"; 122 #EXTENT ... MAXSCALEDENOM 500000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gewässer" wms_title "Flächen" wms_enable_request "GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POLYGON UNITS METERS CLASS # NAME '{"Hafendamm, Mole","Wellenbrecher, Buhne"}' EXPRESSION "1308" STYLE COLOR 204 204 204 END END CLASS # NAME '{Bach,Fleet,Graben,Priel,Teich,"Untergeordnetes Gewässer"}' EXPRESSION "1523" STYLE COLOR 255 255 255 # weiß! END END CLASS # NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"Stützmauer links",Stützmauermitte,"Stützmauer rechts","Ufermauer, Kaimauer"}' EXPRESSION "2510" STYLE COLOR 204 204 204 END END END #* LAYER NAME "gs" # Sport und Freizeit / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME "[2515]" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Überdachte Tribüne" EXPRESSION "rn1519" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Hart-, Rasenplatz, Spielfeld" EXPRESSION "rn1520" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "[1524]" EXPRESSION "rn1524" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Schwimmbecken" EXPRESSION "rn1526" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Rennbahn, Laufbahn, Geläuf" EXPRESSION "rn1521" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "gw" # Gewässer / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gewässer" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME '{"Stehendes Gewässer, nicht ständig Wasser führend"}' EXPRESSION "2520" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 4.00 2.00 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Gewässer" EXPRESSION "2518" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Hafendamm, Mole","Wellenbrecher, Buhne"}' EXPRESSION "rn1308" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Damm, Wall, Deich","Felsen, Felsblock, Felsnadel",Rückhaltebecken,"Sonstiges Gewässermerkmal",Staudamm,"Staudamm, außer Betrieb"}' EXPRESSION "rn1551" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Quelle,Stromschnelle,Wasserfall}" EXPRESSION "rn1562" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "Fischtreppe, Sicherheitstor, Sperrwerk" EXPRESSION "rn1548" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{Bach,Fleet,Graben,Priel,Teich,"Untergeordnetes Gewässer"}' EXPRESSION "rn1523" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"Stützmauer links",Stützmauermitte,"Stützmauer rechts","Ufermauer, Kaimauer"}' EXPRESSION "rn2510" STYLE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Unterirdisches Gewässer" EXPRESSION "rn1550" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "fi" # Industrie und Gewerbe / Flächen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 100000 # 500000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" wms_title "Flächen" wms_enable_request "GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POLYGON UNITS METERS CLASS # NAME "[1403]" EXPRESSION "1403" STYLE COLOR 237 237 237 END END CLASS #- NAME "Vorratsbehälter, aufgeständert" EXPRESSION "1304" STYLE COLOR 204 204 204 END END CLASS # NAME "[1305]" EXPRESSION "1305" STYLE COLOR 204 204 204 END END CLASS # NAME "[1501]" EXPRESSION "1501" STYLE COLOR 204 204 204 END END CLASS #- NAME "Mast" EXPRESSION "1306" STYLE COLOR 204 204 204 END END END #* LAYER NAME "gi" # Industrie und Gewerbe / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME "[2515]" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Klärbecken" EXPRESSION "rn1510" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Förderband, Bandstraße",Tor}' EXPRESSION "rn2521" STYLE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Vorratsbehälter, Speicherbauwerk unterirdisch" EXPRESSION "rn1321" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "[rn1501]" EXPRESSION "rn1501" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.35 WIDTH 0.35 END END CLASS # NAME "[rn1305]" EXPRESSION "rn1305" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "[2031]" EXPRESSION "2031" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "(rn2504)" EXPRESSION "rn2504" STYLE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Mast" EXPRESSION "rn1306" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "fv" # Verkehr / Flächen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS #ATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer IN ('1530','1532','1540','1542','1544') AND thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 25000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" wms_title "Flächen" wms_enable_request "GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POLYGON UNITS METERS CLASS NAME "Weg" EXPRESSION "1542" STYLE COLOR 255 255 255 END END CLASS NAME "Anleger" EXPRESSION "1544" STYLE COLOR 255 255 255 END END CLASS NAME "Fahrbahn" EXPRESSION "1540" STYLE COLOR 255 255 255 END END CLASS # NAME "{Brückenjoch}" NAME "Brückenjoch" EXPRESSION "1532" STYLE COLOR 204 204 204 END END CLASS NAME "Brücke, Hochbahn/-straße" EXPRESSION "1530" STYLE COLOR 255 255 255 END END END #* LAYER NAME "gv" # Verkehr / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS # Sortierung der CLASS nach numerischen Teil in EXPRESSION um Redundanzen zu finden CLASS # NAME "{Furt}" EXPRESSION "rn1320" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "(rn1330)" EXPRESSION "rn1330" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Brücke, Hochbahn/-straße" EXPRESSION "rn1530" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 PATTERN 2.00 1.00 END SIZE 0.5 WIDTH 0.5 END END CLASS # NAME "{Brückenpfeiler}" EXPRESSION "rn1531" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 PATTERN 1.00 0.50 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Brückenjoch}" EXPRESSION "rn1532" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "Tunnel, Unterführung" EXPRESSION "rn1533" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 PATTERN 0.50 1.50 END SIZE 0.5 WIDTH 0.5 END END CLASS #- NAME "Schleusenkammer" EXPRESSION "rn1535" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 SIZE 0.5 WIDTH 0.5 END END CLASS # NAME "(rn1536)" EXPRESSION "rn1536" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Fahrbahn" EXPRESSION "rn1540" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 127 127 127 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Bahnhof, Bahn im Freizeitpark","Bahnhof, Bergbahn, Seilbahn","Bahnhof, Eisenbahn","Bahnhof, Güterverkehr","Bahnhof, Magnetschwebebahn","Bahnhof, Museumsbahn","Bahnhof, S-Bahn","Bahnhof, sonstige Bahnkategorie","Bahnhof, Stadtbahn","Bahnhof, Standseilbahn","Bahnhof, Straßenbahn","Bahnhof, U-Bahn","Bahnhof, Zahnradbahn",Drehscheibe,"Haltestelle, Haltepunkt, Bahn im Freizeitpark","Haltestelle, Haltepunkt, Bergbahn, Seilbahn","Haltestelle, Haltepunkt, Eisenbahn","Haltestelle, Haltepunkt, Güterverkehr","Haltestelle, Haltepunkt, Magnetschwebebahn","Haltestelle, Haltepunkt, Museumsbahn","Haltestelle, Haltepunkt, S-Bahn","Haltestelle, Haltepunkt, sonstige Bahnkategorie","Haltestelle, Haltepunkt, Stadtbahn","Haltestelle, Haltepunkt, Standseilbahn","Haltestelle, Haltepunkt, Straßenbahn","Haltestelle, Haltepunkt, U-Bahn","Haltestelle, Haltepunkt, Zahnradbahn"}' EXPRESSION "rn1541" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Weg" EXPRESSION "rn1542" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Anleger" EXPRESSION "rn1544" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Landeplatz, -bahn, Vorfeld, Rollbahn" EXPRESSION "rn1808" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Durchfahrt, Bauwerk" EXPRESSION "2305" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Bahnverkehr, Platz" EXPRESSION "2515" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Bahnverkehr, im Bau","Flughafen, im Bau","Flugverkehr, im Bau","Hubschrauberflugplatz, im Bau","Internationaler Flughafen, im Bau","Landeplatz, Sonderlandeplatz im Bau","Regionalflughafen, im Bau","Schiffsverkehr, im Bau","Segelfluggelände, im Bau","Straßenverkehr, im Bau","Verkehrslandeplatz, im Bau"}' EXPRESSION "2516" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 178 178 178 PATTERN 7.00 1.00 END SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "fg" # Gebäude / Flächen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Flächen" wms_enable_request "GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POLYGON UNITS METERS CLASS NAME "Gebäude für öffentliche Zwecke" EXPRESSION "1309" STYLE COLOR 102 102 102 END END CLASS NAME "Anderes Gebäude" EXPRESSION "1304" STYLE COLOR 204 204 204 END END CLASS NAME "Wohngebäude" EXPRESSION "1301" STYLE COLOR 153 153 153 END END CLASS # NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"Stützmauer links",Stützmauermitte,"Stützmauer rechts","Ufermauer, Kaimauer"}' EXPRESSION "2510" STYLE COLOR 204 204 204 END END CLASS NAME "Aussichtsturm" EXPRESSION "1501" STYLE COLOR 204 204 204 END END CLASS NAME "Mauer" EXPRESSION "1305" STYLE COLOR 204 204 204 END END CLASS NAME "Brunnen" EXPRESSION "1525" STYLE COLOR 204 204 204 END END END #* LAYER NAME "gg" # Gebäude / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Grenzen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS CLASS # NAME '{Aquädukt,"Befestigung (Wall, Graben)","Denkmal, Denkstein, Standbild",Fernsprechhäuschen,Grab,"Grabhügel (Hügelgrab)","Großsteingrab (Dolmen), Hünenbett",Müllbox,"Sonstige Einrichtung in öffentlichen Bereichen","Sonstiges Bauwerk oder sonstige Einrichtung, Sonstiges","Sonstiges historisches Bauwerk oder sonstige historische Einrichtung","Wachturm (römisch), Warte",Wasserleitung}' EXPRESSION "rn1330" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Keller, unter der Erdoberfläche","Tiefgarage, unter der Erdoberfläche (Bauteil)"}' EXPRESSION "2512" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Gebäude unter der Erdoberfläche" EXPRESSION "2032" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Historische Mauer","Mauerkante links,","Mauerkante rechts,","Mauermitte,","Sonstige historische Mauer",Stadtmauer,"Stützmauer links",Stützmauermitte,"Stützmauer rechts","Ufermauer, Kaimauer"}' EXPRESSION "rn2510" STYLE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Anderes Gebäude" EXPRESSION "2031" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Öffentliches Gebäude" EXPRESSION "2505" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Hochhaus" EXPRESSION "2623" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.5 WIDTH 0.5 END END CLASS # NAME NAME '{"Befestigung (Burgruine)","Burg (Fliehburg, Ringwall)",Lager,Schanze}' EXPRESSION "rn1317" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Anderes Gebäude" EXPRESSION "rn1501" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.35 WIDTH 0.35 END END CLASS # NAME '{Antenne,Brückenlaufkran,Drehkran,Einsteigeschacht,Freitreppe,Funkmast,"Historische Mauer",Hochofen,Kran,Laufkran,Mauer,Portalkran,Radioteleskop,Rampe,Rolltreppe,Schachtöffnung,Schöpfwerk,Solarzellen,"Sonstige historische Mauer","Sonstiges Bauwerk oder sonstige Anlage für Industrie und Gewerbe",Stadtmauer,Staumauer,"Staumauer, außer Betrieb",Stützmauer,Terrasse,Treppe,Trockendock,"Vorratsbehälter, Speicherbauwerk",Wasserrad,Windrad}' EXPRESSION "rn1305" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "aufgeständert" EXPRESSION "2508" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "Schornstein im Gebäude" #- NAME "Unterirdisch" EXPRESSION "2513" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.25 WIDTH 0.25 END END CLASS #- NAME "Turm im Gebäude" EXPRESSION "2514" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.35 WIDTH 0.35 END END CLASS # NAME '{Arkade,"Auskragende Geschosse","Auskragende/zurückspringende Geschosse","Durchfahrt an überbauter Verkehrsstraße","Durchfahrt im Gebäude","Gebäudeteil - abweichende Geschosshöhe","Geringergeschossiger Gebäudeteil","Höhergeschossiger Gebäudeteil (nicht Hochhaus)",Keller,Loggia,"Sonstiger Gebäudeteil","Tiefgarage (Bauteil)",Treppenunterkante,"Zurückspringende Geschosse"}' EXPRESSION "2507" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{Brunnen,"Springbrunnen, Zierbrunnen"}' EXPRESSION "rn1525" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "gr" # Rechtliche Festlegungen / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 25000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Rechtliche Festlegungen" wms_title "Grenzen" wms_enable_request "GetFeatureInfo !GetLegendGraphic" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE POLYGON UNITS METERS TOLERANCEUNITS pixels TOLERANCE 1 HEADER "/opt/gdi/alkisn/templates/alkisrechtbauh.html" TEMPLATE "/opt/gdi/alkisn/templates/alkisrechtbau.html" FOOTER "/opt/gdi/alkisn/templates/footer.html" CLASS #- NAME "Bau-, Raum-, Bodenordnungsrecht" EXPRESSION "rn1704" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 153 153 153 PATTERN 4.00 1.00 END SIZE 1 END END END #* LAYER NAME "gff" # Flurstücke / Flächen / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # Filter signaturnummer = '2028' sinnvoll?: Nein keine Reduzierung der Menge #EXTENT ... MAXSCALEDENOM 12000 # 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" # wms_layer_group "/Flurstücke/Flächen" wms_layer_group "/Flurstücke" wms_title "Grenzen" wms_enable_request "GetFeatureInfo" # wms_enable_request "GetFeatureInfo GetLegendGraphic" # wms_enable_request "GetFeatureInfo !GetLegendGraphic" # Auch wenn 'wms_enable_request "GetLegendGraphic"' weggelassen wird, ist in den Capabilities noch eine "LegendURL" enthalten. END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF HEADER "/opt/gdi/alkisn/templates/alkisauskh.html" TEMPLATE "/opt/gdi/alkisn/templates/alkisausk.html" # gkz aus Mapfile-Name! FOOTER "/opt/gdi/alkisn/templates/footer.html" TOLERANCEUNITS pixels TOLERANCE 1 TYPE POLYGON UNITS METERS CLASS #- NAME "Flurstücksgrenze" EXPRESSION "2028" STYLE LINECAP SQUARE LINEJOIN ROUND OUTLINECOLOR 0 0 0 # SIZE 0.35 WIDTH 0.35 # OUTLINEWIDTH 0.35 # etwa doppelt so dick wie WIDTH ?! END END END #* ## ---------------------------------------------- ## Layer des Typs "Linien" ## ---------------------------------------------- LAYER NAME "lt" # Topographie / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" wms_title "Linien" wms_abstract "Darstellung von Böschungen bestehend aus Böschungs-Oberkante, -Unterkante, Trennschraffen und vom Konverter generierten Schraffen." END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS #- NAME "Damm, Wall, Deich, Graben, Knick, Wallkante" EXPRESSION "2620" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Böschung, Kliff","Geländekante, Böschungsoberkante","Geländekante, Böschungsunterkante","Geländekante, Allgemeine Geländekante (z.B. Trennschraffe)"}' EXPRESSION "2531" STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Geländekante, Böschungsoberkante, unsicher","Geländekante, Böschungsunterkante, unsicher","Geländekante, Sonstige Begrenzungskante (z.B. Trennschraffe), unsicher"}' EXPRESSION "8223" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "lw" # Gewässer / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gewässer" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS # NAME '{Lahnung,Schöpfwerk,"Sonstiges Bauwerk im Gewässerbereich",Sperrwerk,Wehr}' EXPRESSION "2003" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{Bach,Fleet,Graben,"Grabenkante links","Grabenkante rechts",Grabenmitte,Linienverkehr,"Untergeordnetes Gewässer"}' EXPRESSION "2592" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Bach, nicht ständig Wasser führend","Fleet, nicht ständig Wasser führend","Graben, nicht ständig Wasser führend","Grabenkante links, nicht ständig Wasser führend","Grabenkante rechts, nicht ständig Wasser führend","Grabenmitte, nicht ständig Wasser führend","Untergeordnetes Gewässer, nicht ständig Wasser führend"}' EXPRESSION "2593" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 4.00 2.00 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Bach, verdolt","Bach, verrohrt, unterirdisch, bedeckt",Durchlass,"Fleet, verdolt","Fleet, verrohrt, unterirdisch, bedeckt","Graben, verdolt","Graben, verrohrt, unterirdisch, bedeckt",Rohrdurchlass,Siel,"Untergeordnetes Gewässer, verdolt","Untergeordnetes Gewässer, verrohrt, unterirdisch, bedeckt"}' EXPRESSION "2560" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Düker}" EXPRESSION "2561" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 1.01 END STYLE COLOR 153 153 153 INITIALGAP 3.6 LINEJOIN ROUND PATTERN 0.00 3.60 END SIZE 1 END END CLASS # NAME "(2595)" EXPRESSION "2595" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 1.00 2.00 END SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "lv" # Verkehr / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS # NAME '{"Fußweg (Weg, Pfad, Steig)","Karren- und Ziehweg","Rad- und Fußweg (Weg, Pfad, Steig)","Radweg (Weg, Pfad, Steig)","Reitweg (Weg, Pfad, Steig)",Skaterstrecke,"Weg, Pfad, Steig"}' EXPRESSION "2535" STYLE COLOR 255 255 255 WIDTH 0.3535 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 2.00 3.20 END SIZE 0.35 WIDTH 0.35 END END CLASS # NAME '{Autofährverkehr,"Autofährverkehr, Eisenbahnfährverkehr",Eisenbahnfährverkehr,Personenfährverkehr,"Schifffahrtslinie, Fährverkehr"}' EXPRESSION "2609" STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Fahrbahnbegrenzungslinie}" EXPRESSION "2527" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{"Bahn im Freizeitpark, Gleis","Bergbahn, Seilbahn, Gleis","Eisenbahn, Gleis","Güterverkehr, Gleis","Magnetschwebebahn, Gleis","Museumsbahn, Gleis","S-Bahn, Gleis","Sonstige Bahnkategorie, Gleis","Stadtbahn, Gleis","Standseilbahn, Gleis","Straßenbahn, Gleis","U-Bahn, Gleis","Zahnradbahn, Gleis"}' EXPRESSION "2525" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Steg}" EXPRESSION "2530" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.505 END STYLE COLOR 127 127 127 LINECAP SQUARE LINEJOIN ROUND SIZE 0.5 WIDTH 0.5 END END CLASS # NAME '{"Fahrbahnbegrenzungslinie, überdeckt"}' EXPRESSION "2506" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 153 153 153 LINECAP SQUARE LINEJOIN ROUND PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Widerlager" EXPRESSION "2533" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 127 127 127 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "li" # Industrie und Gewerbe / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS # NAME '{"Bahnübergang, Schranke","Hängende Lampe",Höckerlinie,"Rohrleitung, Pipeline",Zaun}' EXPRESSION "2002" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{Erdkabel,"Rohrleitung, Pipeline, unter der Erdoberfläche","Rohrleitung, Pipeline, unter der Wasseroberfläche"}' EXPRESSION "2523" STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "[2524]" EXPRESSION "2524" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "lg" # Gebäude / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS #- NAME "Kanal, Im Bau" EXPRESSION "2519" STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 178 178 178 LINECAP SQUARE LINEJOIN ROUND PATTERN 7.00 1.00 END SIZE 0.18 WIDTH 0.18 END END CLASS # NAME '{Arkade,"Auskragende Geschosse","Auskragende/zurückspringende Geschosse","Durchfahrt an überbauter Verkehrsstraße","Durchfahrt im Gebäude","Gebäudeteil - abweichende Geschosshöhe","Geringergeschossiger Gebäudeteil","Höhergeschossiger Gebäudeteil (nicht Hochhaus)",Keller,Loggia,"Sonstiger Gebäudeteil","Tiefgarage (Bauteil)",Treppenunterkante,"Zurückspringende Geschosse"}' EXPRESSION "2507" STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND SIZE 0.18 WIDTH 0.18 END END CLASS # NAME "{Firstlinie}" EXPRESSION "2303" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND PATTERN 1.00 1.00 END SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "lp" # Politische Grenzen / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Politische Grenzen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 100000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Politische Grenzen" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS # Bemerkung: Die folgenden 3 Classes wurden aus QGIS doppelt generiert, mit unterschiedlicher Anzahl blinder STYLE-END-Paare, Nur jeweils 1 Class übernommen. CLASS NAME "Flurgrenze" # Strich - 3 Punkte EXPRESSION "2012" STYLE # Grundierung COLOR 255 255 255 WIDTH 1.01 END ## Lösung mit 2 überlappenden Styles # STYLE # eckige Enden # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 5.00 11.00 END # Summe 16 # # SIZE 1 # WIDTH 1 # END # STYLE # Länge 0 + ROUND macht Punkte # # COLOR 102 102 102 # COLOR 202 102 102 # INITIALGAP 7.5 # LINECAP round LINEJOIN round # # PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END # Summe 16 - theoretisch korrekt, läuft aber auseinander # PATTERN 0.00 2.80 0.00 2.80 0.00 10.00 END # sieht in großen Maßstäben besser aus # # SIZE 1 # WIDTH 1 ## END ## Alternative in EINEM Style. Striche und Punkte beide rund. Aber wenigstens Synchron. STYLE COLOR 102 102 102 LINECAP round LINEJOIN round PATTERN 5.00 2.5 0.00 3.00 0.00 3.00 0.00 2.5 END WIDTH 1 END END CLASS NAME "Gemarkungsgrenze" # Strich - Punkt - Punkt EXPRESSION "2014" # Hier wurden 9 blinde STYLE-END-Paare generiert. -> 3 reichen STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 1.01 END ## 2 Styles # STYLE # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 5.00 8.00 END # Summe 13 # # SIZE 1 # WIDTH 1 # END # STYLE # COLOR 102 102 102 # INITIALGAP 7.5 # LINECAP round LINEJOIN round # PATTERN 0.00 3.00 0.00 10.00 END # Summe 13 - theoretisch korrekte Lösung # # PATTERN 0.00 2.80 0.00 9.90 END # praktisch funktionierende Lösung für mapserver 7.0.7 # # SIZE 1 # WIDTH 1 ## END ## 1 Style STYLE COLOR 102 102 102 LINECAP round LINEJOIN round PATTERN 5.00 2.5 0.00 3.00 0.00 2.5 END WIDTH 1 END END CLASS NAME "Gemeindegrenze" # Strich - Punkt EXPRESSION "2022" # Hier wurden 45 blinde STYLE-END-Paare generiert. -> 6 reichen STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END STYLE # weisser Grund COLOR 255 255 255 WIDTH 1.01 END ## 2 Styles aus QGIS-Generierung # STYLE # Strichelierung # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 5.00 5.00 END # Summe 10 # # SIZE 1 # WIDTH 1 # END # STYLE # Punkte in den Lücken der Strichelung # COLOR 102 102 102 # INITIALGAP 7.5 # LINECAP round LINEJOIN round # # PATTERN 0.00 10.00 END # Summe 10 - sollte also synchron sein zum vorhergehenden Style, verschiebt sich aber mit jedem Strich # PATTERN 0.00 9.90 END # theoretisch falsch, funktioniert aber im Mapserver 7.0.7. Rundungs-Problem? # # SIZE 1 # WIDTH 1 ## END ## 1 Style STYLE COLOR 102 102 102 LINECAP round LINEJOIN round PATTERN 5.00 2.5 0.00 2.5 END # Summe 10 WIDTH 1 END END CLASS NAME "Landkreisgrenze" EXPRESSION "2010" # hier wurden 189 blinde STYLE-END-Paare generiert. Muss das? -> 9 reichen STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 1.515 END ## 2 Styles # STYLE # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 7.00 12.00 END # Summe 19 # SIZE 1.5 WIDTH 1.5 # END # STYLE # COLOR 102 102 102 # INITIALGAP 10.75 # LINECAP round LINEJOIN round # PATTERN 0.00 4.50 0.00 14.50 END # Summe 19 # SIZE 1.5 WIDTH 1.5 ## END ## 1 Style STYLE COLOR 102 102 102 LINECAP round LINEJOIN round PATTERN 7.00 3.75 0.00 4.50 0.00 3.75 END # Summe 19 WIDTH 1.5 END END CLASS NAME "Regierungsbezirksgrenze" EXPRESSION "2020" # hier wurden 765!! blinde STYLE-END-Paare generiert. Ist das wirklich sinnvoll und notwendig für eine korrekte Darstellung?? -> 12 reichen STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END # STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 1.515 END ## 2 Styles # STYLE # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 7.00 3.00 7.00 12.00 END # Summe 29 # SIZE 1.5 WIDTH 1.5 # END # STYLE # COLOR 102 102 102 # INITIALGAP 20.75 # LINECAP round LINEJOIN round # PATTERN 0.00 4.50 0.00 24.50 END # Summe 29 # SIZE 1.5 WIDTH 1.5 ## END ## 1 Style STYLE COLOR 102 102 102 LINECAP round LINEJOIN round # 10 17 20.75 25.25 29.0 PATTERN 7.00 3.00 7.00 3.75 0.00 4.50 0.00 3.75 END # Summe 29 WIDTH 1.5 END END CLASS NAME "Landesgrenze" EXPRESSION "2018" # Hier wurden 3069!! blinde STYLE-END-Paare generiert. Ist das für eine korrekte Darstellung wirklich notwendig? -> 15 reichen STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 WIDTH 2.02 END ## 2 Styles # STYLE # COLOR 102 102 102 # LINECAP butt LINEJOIN round # PATTERN 8.00 3.50 8.00 9.00 END # Summe 28.5 # # SIZE 2 # WIDTH 2 # END # STYLE # COLOR 102 102 102 # INITIALGAP 24 # LINECAP round LINEJOIN round # PATTERN 0.00 28.50 END # Summe 28.5 # # SIZE 2 # WIDTH 2 ## END ## 1 Style STYLE COLOR 102 102 102 LINECAP round LINEJOIN round # 11.5 19.5 24 28.5 PATTERN 8.00 3.50 8.00 4.5 0.0 4.5 END # Summe 28.5 WIDTH 2 END END END LAYER NAME "lfn" # Flurstücke / Nummern / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 REQUIRES "[bfn]" # Zuordnungspfeile nur zusammen mit den Flurstücksnummern METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" # wms_layer_group "/Flurstücke/Nummern" # wms_title "Linien" wms_layer_group "/Flurstücke" wms_title "Zuordnung" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS #- NAME "Bruchstriche" EXPRESSION "2001" STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND # SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Zuordnungspfeil, abweichender Rechtszustand" EXPRESSION "2005" STYLE END STYLE END STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.1818 END STYLE COLOR 204 204 204 LINEJOIN ROUND # SIZE 0.18 WIDTH 0.18 END END CLASS #- NAME "Zuordnungspfeil" EXPRESSION "2004" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.1818 END STYLE COLOR 0 0 0 LINEJOIN ROUND # SIZE 0.18 WIDTH 0.18 END END END #* LAYER NAME "lff" # Flurstücke / Flächen / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" # wms_layer_group "/Flurstücke/Flächen" wms_layer_group "/Flurstücke" wms_title "Linien" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF TYPE LINE UNITS METERS CLASS #- NAME "Flurstücksgrenze, abw. Rechtszustand" EXPRESSION "2029" STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.3535 END STYLE COLOR 204 204 204 LINECAP SQUARE LINEJOIN ROUND # SIZE 0.35 WIDTH 0.35 END END CLASS #- NAME "Strittige Grenze" EXPRESSION "2006" STYLE END STYLE END STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.3535 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND PATTERN 6.00 1.00 END # SIZE 0.35 WIDTH 0.35 END END CLASS #- NAME "Flurstücksgrenze nicht feststellbar" EXPRESSION "2008" STYLE END STYLE END STYLE END STYLE END STYLE END STYLE END # Darstellungspriorität anheben STYLE COLOR 255 255 255 # OPACITY 0 WIDTH 0.3535 END STYLE COLOR 0 0 0 LINECAP SQUARE LINEJOIN ROUND PATTERN 2.00 1.00 END # SIZE 0.35 WIDTH 0.35 END END END #* ## ---------------------------------------------- ## Layer des Typs "Punkte" ## ---------------------------------------------- LAYER NAME "pff" # Flurstücke / Flächen / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" # wms_layer_group "/Flurstücke/Flächen" wms_layer_group "/Flurstücke" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Abgemarkter Grenzpunkt" EXPRESSION "3020" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.6995 SYMBOL "norGIS_alkis3020_2" END END CLASS #- NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt" EXPRESSION "3022" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.6995 SYMBOL "norGIS_alkis3022_2" END END CLASS #- NAME "Grenzpunkt ohne spezifizierte Abmarkung" EXPRESSION "3024" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.5182 SYMBOL "norGIS_alkis3024_2" END END CLASS #- NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt" EXPRESSION "3022" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.6995 SYMBOL "norGIS_alkis3022_2" END END CLASS # NAME "(3011)" EXPRESSION "3011" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 1 SIZE 2.2509 SYMBOL "norGIS_alkis3011_2" END END CLASS #- NAME "Flurstücksüberhaken" EXPRESSION "3010" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 1 SIZE 2.2509 SYMBOL "norGIS_alkis3010_2" END END CLASS #- NAME "Abgemarkter Grenzpunkt, abw. Rechtszustand" EXPRESSION "3021" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.6995 SYMBOL "norGIS_alkis3021_2" END END END #* LAYER NAME "pg" # Gebäude / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS # CLASS sortiert nach Nummer in Expression CLASS #- NAME "Bank" EXPRESSION "3300" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.189 SYMBOL "norGIS_alkis3300_2" END END CLASS #- NAME "Hotel" EXPRESSION "3302" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3302_2" END END CLASS #- NAME "Gaststätte" EXPRESSION "3305" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3305_2" END END CLASS #- NAME "Kino" EXPRESSION "3306" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3306_2" END END CLASS #- NAME "Spielcasino" EXPRESSION "3308" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.1437 SYMBOL "norGIS_alkis3308_2" END END CLASS #- NAME "Toilette" EXPRESSION "3311" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3311_2" END END CLASS #- NAME "Post" EXPRESSION "3312" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3312_2" END END CLASS #- NAME "Kirche" EXPRESSION "3316" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 10.0381 SYMBOL "norGIS_alkis3316_2" END END CLASS #- NAME "Kapelle" EXPRESSION "3318" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.0137 SYMBOL "norGIS_alkis3318_2" END END CLASS #- NAME "Polizei" EXPRESSION "3324" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3324_2" END END CLASS #- NAME "Kindergarten" EXPRESSION "3323" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.2313 SYMBOL "norGIS_alkis3323_2" END END CLASS #- NAME "Feuerwehr" EXPRESSION "3326" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.0077 SYMBOL "norGIS_alkis3326_2" END END CLASS #- NAME "Hallenbad" EXPRESSION "3334" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.2313 SYMBOL "norGIS_alkis3334_2" END END CLASS #- NAME "Tiefgarage" EXPRESSION "3336" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.5712 SYMBOL "norGIS_alkis3336_2" END END CLASS #- NAME "Umformer" EXPRESSION "3521" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 0 0 SIZE 3.6935 SYMBOL "norGIS_alkis3521_2" END END CLASS #- NAME "Großsteingrab (Dolmen), Hünenbett" EXPRESSION "3526" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1043 SYMBOL "norGIS_alkis3526_2" END END CLASS # NAME "(3527)" EXPRESSION "3527" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 0 0 SIZE 3.8294 SYMBOL "norGIS_alkis3527_2" END END CLASS # NAME "(3528)" EXPRESSION "3528" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1043 SYMBOL "norGIS_alkis3528_2" END END CLASS #- NAME "Brunnen / Gasquelle, Mofette / Heilquelle" EXPRESSION "3529" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 2.6965 SYMBOL "norGIS_alkis3529_2" END END CLASS #- NAME "Denkmal" EXPRESSION "3532" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 4.866 SYMBOL "norGIS_alkis3532_2" END END CLASS #- NAME "Gipfel-/Wegekreuz" EXPRESSION "3535" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 4.0149 SYMBOL "norGIS_alkis3535_2" END END CLASS #- NAME "Meilenstein, historischer Grenzstein" EXPRESSION "3536" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 1 SIZE 2.8688 SYMBOL "norGIS_alkis3536_2" END END CLASS #- NAME "Springbrunnen, Zierbrunnen" EXPRESSION "3539" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.056 SYMBOL "norGIS_alkis3539_2" END END CLASS #- NAME "Ziehbrunnen" EXPRESSION "3540" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 6.2498 SYMBOL "norGIS_alkis3540_2" END END END #* LAYER NAME "pv" # Verkehr / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS # Sortierung nach Nummer in Expression CLASS #- NAME "Fußweg" EXPRESSION "3424" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3703 SYMBOL "norGIS_alkis3424_2" END END CLASS #- NAME "Radweg" EXPRESSION "3426" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3703 SYMBOL "norGIS_alkis3426_2" END END CLASS #- NAME "Rad- und Fußweg" EXPRESSION "3428" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3703 SYMBOL "norGIS_alkis3428_2" END END CLASS #- NAME "Reitweg" EXPRESSION "3430" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3703 SYMBOL "norGIS_alkis3430_2" END END CLASS #- NAME "Parkplatz" EXPRESSION "3432" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.4836 SYMBOL "norGIS_alkis3432_2" END END CLASS #- NAME "Rastplatz" EXPRESSION "3434" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.4836 SYMBOL "norGIS_alkis3434_2" END END CLASS #- NAME "Segelfluggelände" EXPRESSION "3439" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 12.5306 SYMBOL "norGIS_alkis3439_2" END END CLASS #- NAME "Kilometerstein" EXPRESSION "3556" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1043 SYMBOL "norGIS_alkis3556_2" END END CLASS # NAME "(3574)" EXPRESSION "3574" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.8687 SYMBOL "norGIS_alkis3574_2" END END CLASS #- NAME "Haltepunkt" EXPRESSION "3578" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1949 SYMBOL "norGIS_alkis3578_2" END END CLASS # NAME "(3587)" EXPRESSION "3587" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.7751 SYMBOL "norGIS_alkis3587_2" END END CLASS #- NAME "Hubschrauberlandeplatz" EXPRESSION "3588" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.3672 SYMBOL "norGIS_alkis3588_2" END END END #* LAYER NAME "pe" # VEgetation / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Gras" EXPRESSION "3413" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 0.4305 SYMBOL "norGIS_alkis3413_2" END END CLASS #- NAME "Garten" EXPRESSION "3421" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.8127 SYMBOL "norGIS_alkis3421_2" END END CLASS #- NAME "Streuobstacker" EXPRESSION "3440" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.192 SYMBOL "norGIS_alkis3440_2" END END CLASS #- NAME "Streuobstwiese" EXPRESSION "3441" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.192 SYMBOL "norGIS_alkis3441_2" END END CLASS #- NAME "Spargel" EXPRESSION "3444" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 2.34 SYMBOL "norGIS_alkis3444_2" END END CLASS #- NAME "Baumschule" EXPRESSION "3446" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.192 SYMBOL "norGIS_alkis3446_2" END END CLASS #- NAME "Obstplantage" EXPRESSION "3450" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.192 SYMBOL "norGIS_alkis3450_2" END END CLASS #- NAME "Obstbaumplantage" EXPRESSION "3452" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.192 SYMBOL "norGIS_alkis3452_2" END END CLASS #- NAME "Obststrauchplantage" EXPRESSION "3454" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.8807 SYMBOL "norGIS_alkis3454_2" END END CLASS #- NAME "Laubwald" EXPRESSION "3458" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.3763 SYMBOL "norGIS_alkis3458_2" END END CLASS #- NAME "Nadelwald" EXPRESSION "3460" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.8491 SYMBOL "norGIS_alkis3460_2" END END CLASS #- NAME "Mischwald" EXPRESSION "3462" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3703 SYMBOL "norGIS_alkis3462_2" END END CLASS #- NAME "Mischwald" EXPRESSION "3470" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.8718 SYMBOL "norGIS_alkis3470_2" END END CLASS #- NAME "Heide" EXPRESSION "3474" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.9261 SYMBOL "norGIS_alkis3474_2" END END CLASS #- NAME "Moor" EXPRESSION "3476" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.6088 SYMBOL "norGIS_alkis3476_2" END END CLASS #- NAME "Sumpf" EXPRESSION "3478" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.065 SYMBOL "norGIS_alkis3478_2" END END CLASS #- NAME "Unland" EXPRESSION "3480" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.0107 SYMBOL "norGIS_alkis3480_2" END END CLASS #- NAME "Nadelbaum" EXPRESSION "3597" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 4.8638 SYMBOL "norGIS_alkis3597_2" END END CLASS #- NAME "Laubbaum" EXPRESSION "3599" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 4.567 SYMBOL "norGIS_alkis3599_2" END END CLASS #- NAME "Busch, Hecke, Knick" EXPRESSION "3601" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.4275 SYMBOL "norGIS_alkis3601_2" END END CLASS #- NAME "Röhricht, Schilf" EXPRESSION "3603" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.7388 SYMBOL "norGIS_alkis3603_2" END END CLASS #- NAME "Zierfläche" EXPRESSION "3605" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 2.4245 SYMBOL "norGIS_alkis3605_2" END END CLASS #- NAME "Quelle" EXPRESSION "3613" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.0197 SYMBOL "norGIS_alkis3613_2" END END END #* LAYER NAME "pw" # GeWässer / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gewässer" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Fließgewässer" EXPRESSION "3488" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2236 SYMBOL "norGIS_alkis3488_2" END END CLASS #- NAME "Gewässer" EXPRESSION "3490" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.3369 SYMBOL "norGIS_alkis3490_2" END END CLASS #- NAME "Brunnen / Gasquelle, Mofette / Heilquelle" EXPRESSION "3529" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 2.6965 SYMBOL "norGIS_alkis3529_2" END END CLASS # NAME "(3592)" EXPRESSION "3592" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2009 SYMBOL "norGIS_alkis3592_2" END END CLASS # NAME "(3595)" EXPRESSION "3595" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2009 SYMBOL "norGIS_alkis3595_2" END END CLASS # NAME "(3596)" EXPRESSION "3596" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 1 SIZE 3.6936 SYMBOL "norGIS_alkis3596_2" END END CLASS #- NAME "Quelle" EXPRESSION "3613" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.0197 SYMBOL "norGIS_alkis3613_2" END END CLASS #- NAME "Unterirdisches Fließgewässer" EXPRESSION "3619" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2236 SYMBOL "norGIS_alkis3619_2" END END CLASS #- NAME "Fließgewässer, nicht ständig Wasser führend" EXPRESSION "3621" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2236 SYMBOL "norGIS_alkis3621_2" END END CLASS # NAME "[3653]" EXPRESSION "3653" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.2009 SYMBOL "norGIS_alkis3653_2" END END END #* LAYER NAME "pi" # Industrie und Gewerbe / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Tankstelle" EXPRESSION "3401" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.2343 SYMBOL "norGIS_alkis3401_2" END END CLASS # NAME "(3402)" EXPRESSION "3402" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.1603 SYMBOL "norGIS_alkis3402_2" END END CLASS #- NAME "Umspannstation" EXPRESSION "3404" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.3643 SYMBOL "norGIS_alkis3404_2" END END CLASS #- NAME "Torf" EXPRESSION "3407" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.5092 SYMBOL "norGIS_alkis3407_2" END END CLASS #- NAME "Windrad" EXPRESSION "3501" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 3 SIZE 6.8565 SYMBOL "norGIS_alkis3501_2" END END CLASS #- NAME "Solarzellen" EXPRESSION "3502" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 4.3733 SYMBOL "norGIS_alkis3502_2" END END CLASS #- NAME "Mast" EXPRESSION "3504" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 2.1979 SYMBOL "norGIS_alkis3504_2" END END CLASS #- NAME "Antenne / Funkmast" EXPRESSION "3506" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 5.2585 SYMBOL "norGIS_alkis3506_2" END END CLASS #- NAME "Schornstein, Schlot, Esse" EXPRESSION "3508" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.3763 SYMBOL "norGIS_alkis3508_2" END END CLASS #- NAME "Stollenmundloch" EXPRESSION "3509" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.2856 SYMBOL "norGIS_alkis3509_2" END END CLASS NAME "Schachtöffnung" EXPRESSION "3510" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 0 SIZE 2.6058 SYMBOL "norGIS_alkis3510_2" END END CLASS #- NAME "Drehkran" EXPRESSION "3512" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 1 SIZE 5.1886 SYMBOL "norGIS_alkis3512_2" END END CLASS # NAME "Portalkran" EXPRESSION "3513" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.189 SYMBOL "norGIS_alkis3513_2" END END CLASS #- NAME "Laufkran, Brückenlaufkran" EXPRESSION "3514" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 OFFSET 0 2 SIZE 5.235 SYMBOL "norGIS_alkis3514_2" END END CLASS # NAME "Einsteigeschacht" EXPRESSION "3520" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1949 SYMBOL "norGIS_alkis3520_2" END END CLASS #- NAME "Umformer" EXPRESSION "3521" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.6935 SYMBOL "norGIS_alkis3521_2" END END CLASS #- NAME "Vorratsbehälter" EXPRESSION "3522" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.1949 SYMBOL "norGIS_alkis3522_2" END END END #* LAYER NAME "ps" # Sport und Freizeit / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Skating" EXPRESSION "3409" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.3643 SYMBOL "norGIS_alkis3409_2" END END CLASS #- NAME "Safaripark, Wildpark" EXPRESSION "3411" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.3643 SYMBOL "norGIS_alkis3411_2" END END CLASS #- NAME "Campingplatz" EXPRESSION "3412" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.7268 SYMBOL "norGIS_alkis3412_2" END END CLASS #- NAME "Rasen" EXPRESSION "3413" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 0.4305 SYMBOL "norGIS_alkis3413_2" END END CLASS #- NAME "Park" EXPRESSION "3415" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.6648 SYMBOL "norGIS_alkis3415_2" END END CLASS #- NAME "Botanischer Garten" EXPRESSION "3417" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.3643 SYMBOL "norGIS_alkis3417_2" END END CLASS #- NAME "Kleingarten" EXPRESSION "3419" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.4126 SYMBOL "norGIS_alkis3419_2" END END CLASS #- NAME "Garten" EXPRESSION "3421" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.8127 SYMBOL "norGIS_alkis3421_2" END END CLASS #- NAME "Spielplatz, Bolzplatz" EXPRESSION "3423" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 7.3643 SYMBOL "norGIS_alkis3423_2" END END CLASS #- NAME "Schießanlage" EXPRESSION "3524" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.3673 SYMBOL "norGIS_alkis3524_2" END END CLASS #- NAME "Gradierwerk" EXPRESSION "3525" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 6.0727 SYMBOL "norGIS_alkis3525_2" END END END #* LAYER NAME "pt" # Topographie / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" wms_title "Punkte" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS #- NAME "Busch, Hecke, Knick" EXPRESSION "3601" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 1.4275 SYMBOL "norGIS_alkis3601_2" END END CLASS #- NAME "Felsen, Felsblock, Felsnadel" EXPRESSION "3627" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 5.3476 SYMBOL "norGIS_alkis3627_2" END END CLASS #- NAME "Höhleneingang" EXPRESSION "3625" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 # OFFSET 0 0 SIZE 3.9654 SYMBOL "norGIS_alkis3625_2" END END CLASS # NAME "Busch, Hecke, Knick" EXPRESSION "3632" STYLE ANGLE [drehwinkel_grad] MINSIZE 1 SIZE 2 SYMBOL "norGIS_alkis3632_2" END END END #* ## ---------------------------------------------- ## Layer des Typs "Beschriftungen" ## ---------------------------------------------- LAYER NAME "bfn" # Flurstücke / Nummern / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Flurstücke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" # wms_layer_group "/Flurstücke/Nummern" wms_layer_group "/Flurstücke" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 FORCE TRUE COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* # LAYER NAME "bg" # Gebäude / Beschriftungen LAYER NAME "bgh" # Gebäude / Hausnummer (Hauptgebäude) CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS # DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer NOT IN ('ax_lagebezeichnungmitpseudonummer','ax_gebaeude_dachform','ax_gebaeude_funktion','ax_gebaeude_geschosse','ax_gebaeude_zustand','ax_bauteil_dachform','ax_bauteil_funktion','ax_bauteil_geschosse','ax_turm_funktion')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" # Daten der neuen Layer hier raus: Dachform usw. #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" # wms_title "Beschriftungen (Punkte)" # wms_title "Beschriftungen" wms_title "Hausnummern" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 FORCE TRUE COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* # LAYER bg2 Gebäude / Laufende Hausnummern / Beschriftungen LAYER NAME "bgn" # Gebäude / Nebengebäude lfd. Nr. # Nebengebäude-Nummer in Klammer, normalerweise aus CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') || CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" # "/Gebäude/Laufende Hausnummern" wms_title "Nebengebäude lfd. Nr." # "Beschriftungen (Punkte)" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 FORCE TRUE # OFFSET 0 0 OUTLINECOLOR 255 255 255 COLOR [color_umn] POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bgd" # Gebäude / Dachform # Neu 2017-11 CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_dachform','ax_bauteil_dachform')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Dachform" END MINSCALEDENOM 0 PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 FORCE TRUE OUTLINECOLOR 255 255 255 COLOR [color_umn] POSITION [position_umn] PRIORITY 10 END END END #* LAYER NAME "bgf" # Gebäude / Funktion # Neu 2017-11 CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_funktion','ax_bauteil_funktion','ax_turm_funktion')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Funktion" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 FORCE TRUE POSITION [position_umn] PRIORITY 10 END END END #* LAYER NAME "bgg" # Gebäude / Geschosse # Neu 2017-10 CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_gebaeude_geschosse','ax_bauteil_geschosse')) AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Geschosse" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 FORCE TRUE POSITION [position_umn] PRIORITY 10 END END END #* LAYER NAME "bgz" # Gebäude / Zustand # Neu 2017-11 CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'L' WHEN 'rechtsbündig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM \"public\".po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gebäude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_gebaeude_zustand') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 3500 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gebäude" wms_title "Zustand" END MINSCALEDENOM 0 PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 FORCE TRUE POSITION [position_umn] PRIORITY 10 END END END #* LAYER NAME "bl" # Lagebezeichnungen / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Lagebezeichnungen" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 25000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Rechtliche Festlegungen" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 PRIORITY 10 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] # SHADOWSIZE 0 0 END END END #* LAYER NAME "bv" # Verkehr / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bh" # FriedHöfe / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Friedhöfe" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "be" # Vegetation / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bw" # Gewässer / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Gewässer' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 5000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Gewässer" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bs" # Sport und Freizeit / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* LAYER NAME "bb" # Wohnbauflächen / Beschriftungen # 2017-11: wurde nicht neu generiert (aus 300). Grund: Kommt nur selten vor (z.B. in 150). CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Wohnbauflächen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Wohnbauflächen" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] TYPE TRUETYPE ANTIALIAS TRUE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 FORCE TRUE # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END LAYER NAME "bt" # Topographie / Beschriftungen CONNECTION "dbname='alkis0*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbündig' THEN 'R' WHEN 'rechtsbündig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" MAXSCALEDENOM 10000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" # wms_title "Beschriftungen (Punkte)" wms_title "Beschriftungen" END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS INCHES STATUS OFF SYMBOLSCALEDENOM 1000 TYPE POINT UNITS METERS CLASS LABEL ANGLE [drehwinkel_grad] ANTIALIAS TRUE FORCE TRUE TYPE TRUETYPE FONT [font_umn] SIZE [size_umn] BUFFER 2 COLOR [color_umn] OUTLINECOLOR 255 255 255 # OFFSET 0 0 POSITION [position_umn] PRIORITY 10 # SHADOWSIZE 0 0 END END END #* END