Index: trunk/umn/alkis_n/alkis_sw_muster.map =================================================================== --- trunk/umn/alkis_n/alkis_sw_muster.map (revision 368) +++ trunk/umn/alkis_n/alkis_sw_muster.map (revision 368) @@ -0,0 +1,3242 @@ +MAP +# ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet fÃŒr mapserver 7.0 +# http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkissw*gkz*.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 + +# Stand: +# 2016-05-19 generiert, angepasst und optimiert + +# ToDo: +# - Unförmige Legende z.B. im Layer "GebÀude/Grenzen" durch SVG-Symbole und/oder "SIZEUNIT METERS"? +# - Layer oder Gruppe fÃŒr SchÀtzungsklassen +# - In "GebÀude / Beschriftungen" werden ausser der Haunummer auch nich Buchstaben sichtbar, z.T. ÃŒberlappend +# Die sollten getrennt schaltbar sein. +# +### Erlaeuterungen: +## SVG: +# Die SVG-Symbole sind aus dem norBIT-ALKIS-Plugin zu entnehmen: +# Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\ +# Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ +# +## MapProxy: +# Layer fÃŒr FlÀche: LAYERS=fh,fe,fb,fw,fs,fi,fv +# Layer fÃŒr Strichzeichnung: LAYERS=gh,bh,ge,pe,be,gb,bb,gt,lt,pt,bt,gw,lw,pw,bw,gs,ps,bs,gi,li,pi,bi,gv,lv,pv,bv,fg,gg,lg,pg,bg,gff,lff,pff,lfn,bfn,bl +# +## Layername: +# Der aus QGIS generierte Layername ("l" + lfd.Nr) ist unterschiedlich je Mandant, +# und wird daher zur Vereinheitlichung ersetzt durch die Buchstaben fÃŒr "Typ" und "Gruppe" aus der unten stehenden Liste. +# +## Layer und Klassen: +# Dies Muster-Mapfile wurde generiert auf der Basis von NBA-Daten fÃŒr einige Staedte in Ost-Westfalen. +# FÃŒr den Einsatz in anderen Kreisen und anderen Regionen ist dies durch lokale Layer und Klassen zu ergÀnzen. +# +## HQ-Print: +# Es wird keine _4-Mapdatei mehr fÃŒr High-Quality-Print mit 288dpi aufbereitet. +# Statt dessen wird fÃŒr den HQ-Print der GetMap-Call ergÀnzt um den Parameter: "&map.resolution=288" +# Beispiel fÃŒr Mapbender 2.7: +# UPDATE gui_element_vars SET var_value = '[{"pattern": ".map&", +# "replacement": {"144": ".map&map.resolution=144&", "288": ".map&map.resolution=288&"}}]' +# WHERE fkey_e_id = 'printPDF' AND var_name ='highqualitymapfiles'; + +## 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 +# fe Vegetation / FlÀchen +# fb WohnbauflÀchen / FlÀchen +# gt Topographie / Grenzen +# ge Vegetation / Grenzen +# -gh Friedhöfe / Grenzen +# -gb WohnbauflÀchen / Grenzen +# -fw GewÀsser / FlÀchen +# -fs Sport und Freizeit / FlÀchen +# gs Sport und Freizeit / Grenzen +# gw GewÀsser / Grenzen +# fi Industrie und Gewerbe / FlÀchen +# gi Industrie und Gewerbe / Grenzen +# fv Verkehr / FlÀchen +# gv Verkehr / Grenzen +# fg GebÀude / FlÀchen +# gg GebÀude / Grenzen +# gr Rechtliche Festlegungen / Grenzen +# gff FlurstÃŒcke / FlÀchen / Grenzen +## */ Linien +# lt Topographie / Linien +# lw GewÀsser / Linien +# lv Verkehr / Linien ** +# li Industrie und Gewerbe / Linien +# lg GebÀude / Linien +# lp Politische Grenzen / Linien +# lfn FlurstÃŒcke / Nummern / Linien +# lff FlurstÃŒcke / FlÀchen / Linien +## */ Punkte +# pff FlurstÃŒcke / FlÀchen / Punkte +# pg GebÀude / Punkte +# pv Verkehr / Punkte +# pe Vegetation / Punkte +# pw GewÀsser / Punkte +# pi Industrie und Gewerbe / Punkte +# ps Sport und Freizeit / Punkte +# pt Topographie / Punkte +## */ Beschriftungen +# bfn FlurstÃŒcke / Nummern / Beschriftungen +# bg GebÀude / Beschriftungen +# -bg2 GebÀude / lfd. Nr. NebengebÀude +# bl Lagebezeichnungen / Beschriftungen +# br Rechtliche Festlegungen / Beschriftungen +# bv Verkehr / Beschriftungen +# bh Friedhöfe / Beschriftungen +# be Vegetation / Beschriftungen +# bw GewÀsser / Beschriftungen +# bi Industrie und Gewerbe / Beschriftungen +# bs Sport und Freizeit / Beschriftungen +# bb WohnbauflÀchen / Beschriftungen +# bt Topographie / Beschriftungen + + NAME "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Ã-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 18. Mai 2016" + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_bbox_extended "true" + wms_encoding "UTF-8" + wms_onlineresource "http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/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 "*" + include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt + END + END + + LEGEND + STATUS OFF # ON + KEYSIZE 32 16 + KEYSPACING 5 5 + LABEL + TYPE TRUETYPE + FONT 'arial' + SIZE 9 + COLOR 1 1 1 + END + END + + ## Layer der Typen FlÀchen + Grenzen + + LAYER NAME "fh" # FriedHöfe / FlÀchen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + #ATA "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" + 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" + # Filter Signaturnummer 37 : 0 + #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" + 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + 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 + #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 + + LAYER NAME "fb" # WohnBauflÀchen / FlÀchen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + # DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + # 150: 1091 SÀtze ohne Filter + # Filter auf die einzig dargestellte Signaturnummer: + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE signaturnummer = '1523' 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" + # 150: Nur 13 SÀtze MIT Filter + #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" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POLYGON + UNITS METERS + CLASS + # NAME "(1523)" + EXPRESSION "1523" # dies in DATA filtern + STYLE + COLOR 255 255 255 + END + END + # Signaturnummern 1548, 1550, 1551, ... + END + + LAYER NAME "gt" # Topographie / Grenzen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + #ATA "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" + 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 + #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 "(rn1551)" + 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Vegetation" + wms_title "Grenzen" + 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 "(rn1560)" + EXPRESSION "rn1560" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn1561)" + EXPRESSION "rn1561" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn1563)" + EXPRESSION "rn1563" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + END + + # LAYER gh ?? + # LAYER gb ?? + # LAYER fw ?? + # LAYER fs ?? + + LAYER NAME "gs" # Sport und Freizeit / Grenzen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Sport und Freizeit" + wms_title "Grenzen" + 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GewÀsser" + wms_title "Grenzen" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE POLYGON + UNITS METERS + CLASS + # NAME "(2520)" + 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 "(rn1523)" + EXPRESSION "rn1523" + 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 "(rn1551)" + EXPRESSION "rn1551" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Unterirdisches GewÀsser" + EXPRESSION "rn1550" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 100000 # 500000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Industrie und Gewerbe" + wms_title "FlÀchen" + 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 "[1305]" + EXPRESSION "1305" + STYLE + COLOR 204 204 204 + END + END + CLASS + # NAME "[1501]" + EXPRESSION "1501" + STYLE + COLOR 204 204 204 + END + END + CLASS + NAME "Mast" + EXPRESSION "1306" + STYLE + COLOR 204 204 204 + END + END + END + + LAYER NAME "gi" # Industrie und Gewerbe / Grenzen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Industrie und Gewerbe" + wms_title "Grenzen" + 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 "(rn2521)" + EXPRESSION "rn2521" + STYLE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + 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 "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 "[rn1305]" + EXPRESSION "rn1305" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + 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 "Mast" + EXPRESSION "rn1306" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "fv" # Verkehr / FlÀchen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + #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 ('1542','1530') AND thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + # Filter "signaturnummer IN ('1542','1530') AND" 1687:149 + #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" + 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 "BrÃŒcke, Hochbahn/-straÃe" + EXPRESSION "1530" + STYLE + COLOR 255 255 255 + END + END + END + + LAYER NAME "gv" # Verkehr / Grenzen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Verkehr" + wms_title "Grenzen" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE POLYGON + UNITS METERS + CLASS + # NAME "(2516)" + EXPRESSION "2516" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 178 178 178 + PATTERN 7.00 1.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Bahnverkehr, Platz" + EXPRESSION "2515" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Weg" + EXPRESSION "rn1542" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + 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 "(rn1536)" + EXPRESSION "rn1536" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 127 127 127 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn1320)" + EXPRESSION "rn1320" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "BrÃŒcke, Hochbahn/-straÃe" + EXPRESSION "rn1530" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 127 127 127 + PATTERN 2.00 1.00 END + SIZE 0.5 + WIDTH 0.5 + END + END + CLASS + # NAME "(rn1531)" + EXPRESSION "rn1531" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 127 127 127 + PATTERN 1.00 0.50 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Tunnel, UnterfÃŒhrung" + EXPRESSION "rn1533" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 127 127 127 + PATTERN 0.50 1.50 END + SIZE 0.5 + WIDTH 0.5 + END + END + END + + LAYER NAME "fg" # GebÀude / FlÀchen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "FlÀchen" + 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 "(2510)" + EXPRESSION "2510" + STYLE + COLOR 204 204 204 + END + END + CLASS + NAME "Aussichtsturm" + EXPRESSION "1501" + STYLE + COLOR 204 204 204 + END + END + CLASS + NAME "Mauer" + EXPRESSION "1305" + STYLE + COLOR 204 204 204 + END + END + CLASS + NAME "Brunnen" + EXPRESSION "1525" + STYLE + COLOR 204 204 204 + END + END + END + + LAYER NAME "gg" # GebÀude / Grenzen + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 3500 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "Grenzen" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE POLYGON + UNITS METERS + CLASS + # NAME "(rn1330)" + EXPRESSION "rn1330" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "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 "(2512)" + EXPRESSION "2512" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "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 "(rn2510)" + EXPRESSION "rn2510" + STYLE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn1317)" + EXPRESSION "rn1317" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 153 153 153 + PATTERN 2.00 1.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Anderes GebÀude" + EXPRESSION "rn1501" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + SIZE 0.35 + WIDTH 0.35 + END + END + CLASS + # NAME "(rn1305)" + 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" + 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 "(2507)" + EXPRESSION "2507" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn1525)" + 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 25000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Rechtliche Festlegungen" + wms_title "Grenzen" + 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 12000 # 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/FlurstÃŒcke/FlÀchen" + wms_title "Grenzen" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + + HEADER "/opt/gdi/alkisn/templates/alkisauskh.html" + TEMPLATE "/opt/gdi/alkisn/templates/alkisausk.html" # gkz aus Mapfile-Name! + FOOTER "/opt/gdi/alkisn/templates/footer.html" + TOLERANCEUNITS pixels TOLERANCE 1 + + TYPE POLYGON + UNITS METERS + CLASS + NAME "FlurstÃŒcksgrenze" + EXPRESSION "2028" + STYLE + LINECAP SQUARE + LINEJOIN ROUND + OUTLINECOLOR 0 0 0 + SIZE 0.35 + WIDTH 0.35 + END + END + END + + ## Layer des Typs Linien + + LAYER NAME "lt" # Topographie / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Topographie" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + NAME "Damm, Wall, Deich, Graben, Knick, Wallkante" + EXPRESSION "2620" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lw" # GewÀsser / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GewÀsser" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + # NAME "(2003)" + EXPRESSION "2003" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2592)" + EXPRESSION "2592" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2593)" + EXPRESSION "2593" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 4.00 2.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2595)" + EXPRESSION "2595" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 1.00 2.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2560)" + EXPRESSION "2560" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lv" # Verkehr / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Verkehr" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + # NAME "(2535)" + EXPRESSION "2535" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.3535 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 2.00 3.20 END + SIZE 0.35 + WIDTH 0.35 + END + END + CLASS + # NAME "(2525)" + EXPRESSION "2525" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2527)" + EXPRESSION "2527" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2530)" + EXPRESSION "2530" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.505 + END + STYLE + COLOR 127 127 127 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.5 + WIDTH 0.5 + END + END + CLASS + # NAME "(2506)" + EXPRESSION "2506" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 153 153 153 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Widerlager" + EXPRESSION "2533" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 127 127 127 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "li" # Industrie und Gewerbe / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Industrie und Gewerbe" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + # NAME "[2524]" + EXPRESSION "2524" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lg" # GebÀude / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 3500 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + # NAME "(2507)" + EXPRESSION "2507" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2303)" + EXPRESSION "2303" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 1.00 1.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lp" # Politische Grenzen / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='Politische Grenzen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 100000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Politische Grenzen" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + NAME "Flurgrenze" + EXPRESSION "2012" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 11.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END + SIZE 1 + END + END + CLASS + NAME "Flurgrenze" + EXPRESSION "2012" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 11.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END + SIZE 1 + END + END + CLASS + NAME "Gemarkungsgrenze" + EXPRESSION "2014" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 8.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 3.00 0.00 10.00 END + SIZE 1 + END + END + CLASS + NAME "Gemarkungsgrenze" + EXPRESSION "2014" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 8.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 3.00 0.00 10.00 END + SIZE 1 + END + END + CLASS + NAME "Gemeindegrenze" + EXPRESSION "2022" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 5.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 10.00 END + SIZE 1 + END + END + CLASS + NAME "Gemeindegrenze" + EXPRESSION "2022" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 1.01 + END + STYLE + COLOR 102 102 102 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 5.00 5.00 END + SIZE 1 + END + STYLE + COLOR 102 102 102 + INITIALGAP 7.5 + LINEJOIN ROUND + PATTERN 0.00 10.00 END + SIZE 1 + END + END + END + + LAYER NAME "lfn" # FlurstÃŒcke / Nummern / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/FlurstÃŒcke/Nummern" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + NAME "Bruchstriche" + EXPRESSION "2001" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + NAME "Zuordnungspfeil" + EXPRESSION "2004" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.1818 + END + STYLE + COLOR 0 0 0 + LINEJOIN ROUND + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lff" # FlurstÃŒcke / FlÀchen / Linien + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,line AS geom,signaturnummer FROM po_lines WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT line IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/FlurstÃŒcke/FlÀchen" + wms_title "Linien" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + TYPE LINE + UNITS METERS + CLASS + NAME "Strittige Grenze" + EXPRESSION "2006" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.3535 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 6.00 1.00 END + SIZE 0.35 + WIDTH 0.35 + END + END + CLASS + NAME "FlurstÃŒcksgrenze nicht feststellbar" + EXPRESSION "2008" + STYLE + COLOR 255 255 255 + # OPACITY 0 + WIDTH 0.3535 + END + STYLE + COLOR 0 0 0 + LINECAP SQUARE + LINEJOIN ROUND + PATTERN 2.00 1.00 END + SIZE 0.35 + WIDTH 0.35 + END + END + END + + ## Layer des Typs Punkte + + LAYER NAME "pff" # FlurstÃŒcke / FlÀchen / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/FlurstÃŒcke/FlÀchen" + wms_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 "FlurstÃŒcksÃŒberhaken" + EXPRESSION "3010" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + OFFSET 0 1 + SIZE 2.2509 + SYMBOL "norGIS_alkis3010_2" + END + END + END + + LAYER NAME "pg" # GebÀude / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 3500 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Springbrunnen, Zierbrunnen" + EXPRESSION "3539" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.056 + SYMBOL "norGIS_alkis3539_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 "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 "Spielcasino" + EXPRESSION "3308" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.1437 + SYMBOL "norGIS_alkis3308_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 "Hallenbad" + EXPRESSION "3334" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 6.2313 + SYMBOL "norGIS_alkis3334_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 "Kirche" + EXPRESSION "3316" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 10.0381 + SYMBOL "norGIS_alkis3316_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 "Kindergarten" + EXPRESSION "3323" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 6.2313 + SYMBOL "norGIS_alkis3323_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 "Kino" + EXPRESSION "3306" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.0077 + SYMBOL "norGIS_alkis3306_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 "Bank" + EXPRESSION "3300" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.189 + SYMBOL "norGIS_alkis3300_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 "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 "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 "Polizei" + EXPRESSION "3324" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.0077 + SYMBOL "norGIS_alkis3324_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 + END + + LAYER NAME "pv" # Verkehr / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Verkehr" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Reitweg" + EXPRESSION "3430" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.3703 + SYMBOL "norGIS_alkis3430_2" + END + END + 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 "Haltepunkt" + EXPRESSION "3578" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 3.1949 + SYMBOL "norGIS_alkis3578_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 "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 + END + + LAYER NAME "pe" # VEgetation / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Vegetation" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Baumschule" + EXPRESSION "3446" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.192 + SYMBOL "norGIS_alkis3446_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 "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 "Quelle" + EXPRESSION "3613" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 1.0197 + SYMBOL "norGIS_alkis3613_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 "Obstbaumplantage" + EXPRESSION "3452" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.192 + SYMBOL "norGIS_alkis3452_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 "Unland" + EXPRESSION "3480" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.0107 + SYMBOL "norGIS_alkis3480_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 "Gras" + EXPRESSION "3413" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 0.4305 + SYMBOL "norGIS_alkis3413_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 "Streuobstwiese" + EXPRESSION "3441" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.192 + SYMBOL "norGIS_alkis3441_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 "Laubbaum" + EXPRESSION "3599" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + OFFSET 0 2 + SIZE 4.567 + SYMBOL "norGIS_alkis3599_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 "Mischwald" + EXPRESSION "3470" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.8718 + SYMBOL "norGIS_alkis3470_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 + END + + LAYER NAME "pw" # GeWÀsser / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 5000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GewÀsser" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Unterirdisches FlieÃgewÀsser" + EXPRESSION "3619" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 1.2236 + SYMBOL "norGIS_alkis3619_2" + END + END + 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 "Quelle" + EXPRESSION "3613" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 1.0197 + SYMBOL "norGIS_alkis3613_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 "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 + END + + LAYER NAME "pi" # Industrie und Gewerbe / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Industrie und Gewerbe" + wms_title "Punkte" + 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 "Umformer" + EXPRESSION "3521" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 3.6935 + SYMBOL "norGIS_alkis3521_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 "VorratsbehÀlter" + EXPRESSION "3522" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 3.1949 + SYMBOL "norGIS_alkis3522_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 "Mast" + EXPRESSION "3504" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 2.1979 + SYMBOL "norGIS_alkis3504_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 "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 "Torf" + EXPRESSION "3407" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 4.5092 + SYMBOL "norGIS_alkis3407_2" + END + END + END + + LAYER NAME "ps" # Sport und Freizeit / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Sport und Freizeit" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Spielplatz, Bolzplatz" + EXPRESSION "3423" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 7.3643 + SYMBOL "norGIS_alkis3423_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 "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 "Campingplatz" + EXPRESSION "3412" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 7.7268 + SYMBOL "norGIS_alkis3412_2" + END + END + END + + LAYER NAME "pt" # Topographie / Punkte + CLASSITEM "signaturnummer" + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,point AS geom,drehwinkel_grad,signaturnummer FROM po_points WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + MAXSCALEDENOM 10000 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/Topographie" + wms_title "Punkte" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS METERS + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + NAME "Felsen, Felsblock, Felsnadel" + EXPRESSION "3627" + STYLE + ANGLE [drehwinkel_grad] + MINSIZE 1 + # OFFSET 0 0 + SIZE 5.3476 + SYMBOL "norGIS_alkis3627_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 + ## Diese Class macht Stress ! + # 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='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=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_title "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 + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bg" # GebÀude / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + LABELITEM "text" + MAXSCALEDENOM 3500 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "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 + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + # LAYER bg2 GebÀude / Laufende Hausnummern / Beschriftungen + # * NebengebÀude-Nummer in Klammer, normalerweise aus + # +++ nur Krs HF + + LAYER NAME "bl" # Lagebezeichnungen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bv" # Verkehr / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bh" # FriedHöfe / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "be" # Vegetation / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bw" # GewÀsser / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bs" # Sport und Freizeit / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bb" # WohnbauflÀchen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='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)" + END + PROCESSING "CLOSE_CONNECTION=DEFER" + PROJECTION "init=epsg:25832" END + SIZEUNITS INCHES + STATUS OFF + SYMBOLSCALEDENOM 1000 + TYPE POINT + UNITS METERS + CLASS + LABEL + ANGLE [drehwinkel_grad] + ANTIALIAS TRUE + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bt" # Topographie / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' 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 "/Topographie" + wms_title "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 + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + # OFFSET 0 0 + OUTLINECOLOR 255 255 255 + POSITION [position_umn] + PRIORITY 10 + # SHADOWSIZE 0 0 + TYPE TRUETYPE + END + END + END + + LAYER + NAME "copyright" + STATUS ON # DEFAULT + TYPE POINT + TRANSFORM lr + METADATA + wms_title "Copyright" + wms_abstract "In der Karte sichtbare Angabe auf die Herkunft der Daten" + WMS_KEYWORDLIST "Katasteramt, Copyright, Quellenangabe" + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + END + FEATURE + POINTS 0 0 END + # individuelle Vertragsnummer einsetzen + TEXT 'Copyright Geobasisdaten Liegenschaftskataster Kreis __' + END + CLASS + LABEL + SIZE small + POSITION ul + COLOR 50 50 50 + FORCE TRUE + STYLE + GEOMTRANSFORM 'labelpoly' + COLOR 250 250 250 + END + END + END + END +END Index: trunk/umn/alkis_n/symbolssw.sym =================================================================== --- trunk/umn/alkis_n/symbolssw.sym (revision 368) +++ trunk/umn/alkis_n/symbolssw.sym (revision 368) @@ -0,0 +1,339 @@ +SYMBOLSET +# Symbole fuer ALKIS-Mapfile Schwarz/Weiss generiert aus aus Norbit-QGIS-Plugin + SYMBOL + NAME "0" + TYPE ELLIPSE + FILLED TRUE + POINTS 1 1 1 1 END + END + SYMBOL + NAME "norGIS_alkis3020_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3020_2.svg" + END + SYMBOL + NAME "norGIS_alkis3022_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3022_2.svg" + END + SYMBOL + NAME "norGIS_alkis3010_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3010_2.svg" + END + SYMBOL + NAME "norGIS_alkis3539_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3539_2.svg" + END + SYMBOL + NAME "norGIS_alkis3527_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3527_2.svg" + END + SYMBOL + NAME "norGIS_alkis3521_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3521_2.svg" + END + SYMBOL + NAME "norGIS_alkis3308_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3308_2.svg" + END + SYMBOL + NAME "norGIS_alkis3312_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3312_2.svg" + END + SYMBOL + NAME "norGIS_alkis3334_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3334_2.svg" + END + SYMBOL + NAME "norGIS_alkis3318_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3318_2.svg" + END + SYMBOL + NAME "norGIS_alkis3316_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3316_2.svg" + END + SYMBOL + NAME "norGIS_alkis3326_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3326_2.svg" + END + SYMBOL + NAME "norGIS_alkis3323_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3323_2.svg" + END + SYMBOL + NAME "norGIS_alkis3311_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3311_2.svg" + END + SYMBOL + NAME "norGIS_alkis3306_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3306_2.svg" + END + SYMBOL + NAME "norGIS_alkis3336_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3336_2.svg" + END + SYMBOL + NAME "norGIS_alkis3300_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3300_2.svg" + END + SYMBOL + NAME "norGIS_alkis3529_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3529_2.svg" + END + SYMBOL + NAME "norGIS_alkis3302_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3302_2.svg" + END + SYMBOL + NAME "norGIS_alkis3305_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3305_2.svg" + END + SYMBOL + NAME "norGIS_alkis3536_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3536_2.svg" + END + SYMBOL + NAME "norGIS_alkis3324_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3324_2.svg" + END + SYMBOL + NAME "norGIS_alkis3532_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3532_2.svg" + END + SYMBOL + NAME "norGIS_alkis3430_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3430_2.svg" + END + SYMBOL + NAME "norGIS_alkis3424_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3424_2.svg" + END + SYMBOL + NAME "norGIS_alkis3578_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3578_2.svg" + END + SYMBOL + NAME "norGIS_alkis3432_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3432_2.svg" + END + SYMBOL + NAME "norGIS_alkis3426_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3426_2.svg" + END + SYMBOL + NAME "norGIS_alkis3428_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3428_2.svg" + END + SYMBOL + NAME "norGIS_alkis3446_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3446_2.svg" + END + SYMBOL + NAME "norGIS_alkis3478_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3478_2.svg" + END + SYMBOL + NAME "norGIS_alkis3421_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3421_2.svg" + END + SYMBOL + NAME "norGIS_alkis3440_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3440_2.svg" + END + SYMBOL + NAME "norGIS_alkis3613_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3613_2.svg" + END + SYMBOL + NAME "norGIS_alkis3597_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3597_2.svg" + END + SYMBOL + NAME "norGIS_alkis3452_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3452_2.svg" + END + SYMBOL + NAME "norGIS_alkis3460_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3460_2.svg" + END + SYMBOL + NAME "norGIS_alkis3480_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3480_2.svg" + END + SYMBOL + NAME "norGIS_alkis3462_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3462_2.svg" + END + SYMBOL + NAME "norGIS_alkis3413_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3413_2.svg" + END + SYMBOL + NAME "norGIS_alkis3605_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3605_2.svg" + END + SYMBOL + NAME "norGIS_alkis3441_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3441_2.svg" + END + SYMBOL + NAME "norGIS_alkis3458_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3458_2.svg" + END + SYMBOL + NAME "norGIS_alkis3599_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3599_2.svg" + END + SYMBOL + NAME "norGIS_alkis3474_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3474_2.svg" + END + SYMBOL + NAME "norGIS_alkis3470_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3470_2.svg" + END + SYMBOL + NAME "norGIS_alkis3601_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3601_2.svg" + END + SYMBOL + NAME "norGIS_alkis3619_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3619_2.svg" + END + SYMBOL + NAME "norGIS_alkis3488_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3488_2.svg" + END + SYMBOL + NAME "norGIS_alkis3490_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3490_2.svg" + END + SYMBOL + NAME "norGIS_alkis3596_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3596_2.svg" + END + SYMBOL + NAME "norGIS_alkis3621_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3621_2.svg" + END + SYMBOL + NAME "norGIS_alkis3401_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3401_2.svg" + END + SYMBOL + NAME "norGIS_alkis3506_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3506_2.svg" + END + SYMBOL + NAME "norGIS_alkis3522_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3522_2.svg" + END + SYMBOL + NAME "norGIS_alkis3508_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3508_2.svg" + END + SYMBOL + NAME "norGIS_alkis3504_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3504_2.svg" + END + SYMBOL + NAME "norGIS_alkis3501_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3501_2.svg" + END + SYMBOL + NAME "norGIS_alkis3514_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3514_2.svg" + END + SYMBOL + NAME "norGIS_alkis3407_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3407_2.svg" + END + SYMBOL + NAME "norGIS_alkis3423_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3423_2.svg" + END + SYMBOL + NAME "norGIS_alkis3419_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3419_2.svg" + END + SYMBOL + NAME "norGIS_alkis3415_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3415_2.svg" + END + SYMBOL + NAME "norGIS_alkis3412_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3412_2.svg" + END + SYMBOL + NAME "norGIS_alkis3627_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3627_2.svg" + END + SYMBOL + NAME "norGIS_alkis3632_2" + TYPE SVG + IMAGE "/opt/gdi/alkisn/svg/alkis3632_2.svg" + END +END Index: trunk/umn/alkis_n/alkis_n_muster.map =================================================================== --- trunk/umn/alkis_n/alkis_n_muster.map (revision 367) +++ trunk/umn/alkis_n/alkis_n_muster.map (revision 368) @@ -1,13 +1,17 @@ MAP # ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet fÃŒr mapserver 7.0 -# http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis150.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 +# http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis*gkz*.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 # Stand: -# 2016-05-03 - Test-Server - +# 2016-05-03 # 2016-05-09 Kommentare +# 2016-05-11 Copyright-Layer, "PATTERN 0 .." und "OPACITY 0" auskommentiert, FS-Nr besser freigestellt +# Template auf Baurecht. +# Die Templates fuer Feature-Info entnehmen den Parameter "gkz" dem Mapfile-Namen vor ".map" +# 2016-05-12 Bei Klassen mit Symbolnummer als Name den Name auskommentiert um die Legende zu entschÀrfen. +# 2016-05-19 Maxscaledenom ÃŒberarbeiten, Abgkeich mit SW-Variante # ToDo: # - Unförmige Legende z.B. im Layer "GebÀude/Grenzen" durch SVG-Symbole und/oder "SIZEUNIT METERS"? -# - Copyright-Layer wegen Vorgaben des Katasteramtes # - Layer oder Gruppe fÃŒr SchÀtzungsklassen # - In "GebÀude / Beschriftungen" werden ausser der Haunummer auch nich Buchstaben sichtbar, z.T. ÃŒberlappend @@ -64,5 +68,5 @@ # l Lagebezeichnungen -### Generierte Layer (Reihenfolge) +### Generierte Layer-Reihenfolge (340) (150) (230) ## */ FlÀchen + Grenzen # fh Friedhöfe / FlÀchen @@ -77,8 +81,8 @@ # gs Sport und Freizeit / Grenzen # gw GewÀsser / Grenzen -# fi Industrie und Gewerbe / FlÀchen ** -# gi Industrie und Gewerbe / Grenzen ** -# fv Verkehr / FlÀchen ** ( teils auch Verkehr vor Industrie) -# gv Verkehr / 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 @@ -88,6 +92,6 @@ # lt Topographie / Linien # lw GewÀsser / Linien -# lv Verkehr / Linien ** -# li Industrie und Gewerbe / Linien ** (teils hinter gebÀude/linien) +# lv Verkehr / Linien +# li Industrie und Gewerbe / Linien # lg GebÀude / Linien # lp Politische Grenzen / Linien @@ -106,5 +110,5 @@ # bfn FlurstÃŒcke / Nummern / Beschriftungen # bg GebÀude / Beschriftungen -# bg2 GebÀude / Laufende Hausnummern / Beschriftungen ** NebengebÀude-Nummer in Klammer +# bg2 GebÀude / lfd. Nr. NebengebÀude # bl Lagebezeichnungen / Beschriftungen # br Rechtliche Festlegungen / Beschriftungen @@ -130,10 +134,12 @@ WEB METADATA - wms_title "ALKIS n" - wms_abstract "ALKIS *gkz* - Konverter PostNAS, NorGIS-Plugin, Version vom Mai 2016" + wms_title "ALKIS" + wms_abstract "ALKIS *gkz* farbige Variante - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 19. Mai 2016" wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_bbox_extended "true" wms_encoding "UTF-8" wms_onlineresource "http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis*gkz*.map" + # Die Position von "GKZ" im Mapfile-Namen muss 3stellig sein, am Ende vor ".map". + # GKZ wird vom Template ÃŒber den [map] ausgelesen um die richtige DB der Auskunft zu finden. wms_feature_info_mime_type "text/html" wms_schema_location ".." @@ -142,12 +148,19 @@ wms_accessconstraints "fÃŒr den Dienstgebrauch" wms_enable_request "*" - # include "meta_contact.map" # individuelle Datei je Katasteramt - END - END + include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt + END + END + + ## Die Legende ist nicht brauchbar. + ## 1. Die Legende von ALKIS ist sowieso sehr umfangreich. Das fÃŒllt mehrere Seiten. + ## 2. Es werden zum Teil mehrere ALKIS-Objekt-Arten in einer Klasse dieses Mapfiles generiert, + ## indem Darstellungsunterschiede aus Datenbank-Felder geholt werden. + ## Das könnte die Legende nicht abbilden. + ## 3. Einige Klassen haben keine Namen sondern Symbolnummern oder Àhnliches. + ## 4. Die Sybole werden so gigantisch gezeichnet, dass sie die Einbindung des WMS im QGIS verhindern. LEGEND - STATUS ON + STATUS OFF # ON KEYSIZE 32 16 KEYSPACING 5 5 - TRANSPARENT ON LABEL TYPE TRUETYPE @@ -160,6 +173,5 @@ ## Layer der Typen FlÀchen + Grenzen - # LAYER fh FriedHöfe / FlÀchen - LAYER + LAYER NAME "fh" # FriedHöfe / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -171,7 +183,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Friedhöfe" - wms_title "FlÀchen" - END - NAME "fh" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -182,5 +193,5 @@ UNITS METERS CLASS - NAME "[1405]" + # NAME "[1405]" EXPRESSION "1405" STYLE @@ -190,6 +201,5 @@ END - # LAYER fe VEgetation / FlÀchen - LAYER + LAYER NAME "fe" # VEgetation / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -201,7 +211,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" - wms_title "FlÀchen" - END - NAME "fe" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -226,5 +235,5 @@ END CLASS - NAME "(1409)" + # NAME "(1409)" EXPRESSION "1409" STYLE @@ -240,5 +249,5 @@ END CLASS - NAME "(1561)" + # NAME "(1561)" EXPRESSION "1561" STYLE @@ -248,6 +257,5 @@ END - # LAYER fb WohnBauflÀchen / FlÀchen - LAYER + LAYER NAME "fb" # WohnBauflÀchen / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -259,7 +267,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/WohnbauflÀchen" - wms_title "FlÀchen" - END - NAME "fb" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -278,6 +285,5 @@ END - # LAYER gt Topographie / Grenzen - LAYER + LAYER NAME "gt" # Topographie / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -289,7 +295,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" - wms_title "Grenzen" - END - NAME "gt" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -299,5 +304,5 @@ UNITS METERS CLASS - NAME "(rn1551)" + # NAME "(rn1551)" EXPRESSION "rn1551" STYLE @@ -311,6 +316,5 @@ END - # LAYER ge VEgetation / Grenzen - LAYER + LAYER NAME "ge" # VEgetation / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -322,7 +326,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" - wms_title "Grenzen" - END - NAME "ge" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -332,5 +335,5 @@ UNITS METERS CLASS - NAME "(rn1560)" + # NAME "(rn1560)" EXPRESSION "rn1560" STYLE @@ -343,5 +346,5 @@ END CLASS - NAME "(rn1561)" + # NAME "(rn1561)" EXPRESSION "rn1561" STYLE @@ -354,5 +357,5 @@ END CLASS - NAME "(rn1563)" + # NAME "(rn1563)" EXPRESSION "rn1563" STYLE @@ -365,5 +368,5 @@ END CLASS - NAME "[2515]" + # NAME "[2515]" EXPRESSION "2515" STYLE @@ -388,6 +391,5 @@ END - # LAYER gh FriedHöfe / Grenzen - LAYER + LAYER NAME "gh" # FriedHöfe / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -399,7 +401,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Friedhöfe" - wms_title "Grenzen" - END - NAME "gh" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -409,5 +410,5 @@ UNITS METERS CLASS - NAME "[2515]" + # NAME "[2515]" EXPRESSION "2515" STYLE @@ -421,6 +422,5 @@ END - # LAYER gb WohnBauflÀchen / Grenzen - LAYER + LAYER NAME "gb" # WohnBauflÀchen / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -432,7 +432,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/WohnbauflÀchen" - wms_title "Grenzen" - END - NAME "gb" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -442,5 +441,5 @@ UNITS METERS CLASS - NAME "[2515]" + # NAME "[2515]" EXPRESSION "2515" STYLE @@ -454,6 +453,5 @@ END - # LAYER fw GewÀsser / FlÀchen - LAYER + LAYER NAME "fw" # GewÀsser / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -465,7 +463,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GewÀsser" - wms_title "FlÀchen" - END - NAME "fw" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -483,5 +480,5 @@ END CLASS - NAME "(1523)" + # NAME "(1523)" EXPRESSION "1523" STYLE @@ -491,6 +488,5 @@ END - # LAYER fs Sport und Freizeit / FlÀchen - LAYER + LAYER NAME "fs" # Sport und Freizeit / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -498,11 +494,10 @@ DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_flaeche AS signaturnummer FROM po_polygons WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT sn_flaeche IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... - MAXSCALEDENOM 500000 + MAXSCALEDENOM 25000 # 500000 METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" - wms_title "FlÀchen" - END - NAME "fs" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -513,5 +508,5 @@ UNITS METERS CLASS - NAME "[1405]" + # NAME "[1405]" EXPRESSION "1405" STYLE @@ -549,6 +544,5 @@ END - # LAYER gs Sport und Freizeit / Grenzen - LAYER + LAYER NAME "gs" # Sport und Freizeit / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -560,7 +554,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" - wms_title "Grenzen" - END - NAME "gs" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -570,5 +563,5 @@ UNITS METERS CLASS - NAME "[2515]" + # NAME "[2515]" EXPRESSION "2515" STYLE @@ -587,7 +580,5 @@ LINEJOIN ROUND OUTLINECOLOR 81 0 0 - PATTERN - 2.00 1.00 - END + PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 @@ -606,5 +597,5 @@ END CLASS - NAME "[1524]" + # NAME "[1524]" EXPRESSION "rn1524" STYLE @@ -640,6 +631,5 @@ END - # LAYER gw GewÀsser / Grenzen - LAYER + LAYER NAME "gw" # GewÀsser / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -651,7 +641,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GewÀsser" - wms_title "Grenzen" - END - NAME "gw" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -661,5 +650,5 @@ UNITS METERS CLASS - NAME "(rn1551)" + # NAME "(rn1551)" EXPRESSION "rn1551" STYLE @@ -672,5 +661,5 @@ END CLASS - NAME "(2520)" + # NAME "(2520)" EXPRESSION "2520" STYLE @@ -678,7 +667,5 @@ LINEJOIN ROUND OUTLINECOLOR 0 204 204 - PATTERN - 4.00 2.00 - END + PATTERN 4.00 2.00 END SIZE 0.18 WIDTH 0.18 @@ -697,5 +684,5 @@ END CLASS - NAME "(rn1523)" + # NAME "(rn1523)" EXPRESSION "rn1523" STYLE @@ -725,15 +712,12 @@ LINEJOIN ROUND OUTLINECOLOR 0 204 204 - PATTERN - 0.35 0.35 - END - SIZE 0.18 - WIDTH 0.18 - END - END - END - - # LAYER fi Industrie und Gewerbe / FlÀchen - LAYER + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "fi" # Industrie und Gewerbe / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -741,11 +725,10 @@ 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 500000 + 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" - END - NAME "fi" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -756,5 +739,5 @@ UNITS METERS CLASS - NAME "[1401]" + # NAME "[1401]" EXPRESSION "1401" STYLE @@ -763,5 +746,5 @@ END CLASS - NAME "[1403]" + # NAME "[1403]" EXPRESSION "1403" STYLE @@ -770,5 +753,5 @@ END CLASS - NAME "[1510]" + # NAME "[1510]" EXPRESSION "1510" STYLE @@ -777,5 +760,5 @@ END CLASS - NAME "[1305]" + # NAME "[1305]" EXPRESSION "1305" STYLE @@ -784,5 +767,5 @@ END CLASS - NAME "[1501]" + # NAME "[1501]" EXPRESSION "1501" STYLE @@ -799,6 +782,5 @@ END - # LAYER gi Industrie und Gewerbe / Grenzen - LAYER + LAYER NAME "gi" # Industrie und Gewerbe / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -810,7 +792,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" - wms_title "Grenzen" - END - NAME "gi" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -820,5 +801,5 @@ UNITS METERS CLASS - NAME "[2515]" + # NAME "[2515]" EXPRESSION "2515" STYLE @@ -842,18 +823,16 @@ END CLASS - NAME "(rn2504)" + # NAME "(rn2504)" EXPRESSION "rn2504" STYLE LINEJOIN ROUND OUTLINECOLOR 0 0 0 - PATTERN - 0.35 0.35 - END - SIZE 0.18 - WIDTH 0.18 - END - END - CLASS - NAME "(rn2521)" + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn2521)" EXPRESSION "rn2521" STYLE @@ -871,13 +850,11 @@ LINEJOIN ROUND OUTLINECOLOR 0 0 0 - PATTERN - 0.35 0.35 - END - SIZE 0.18 - WIDTH 0.18 - END - END - CLASS - NAME "[rn1501]" + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "[rn1501]" EXPRESSION "rn1501" STYLE @@ -890,5 +867,5 @@ END CLASS - NAME "[rn1305]" + # NAME "[rn1305]" EXPRESSION "rn1305" STYLE @@ -913,6 +890,5 @@ END - # LAYER fv Verkehr / FlÀchen - LAYER + LAYER NAME "fv" # Verkehr / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -924,7 +900,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" - wms_title "FlÀchen" - END - NAME "fv" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -964,6 +939,5 @@ END - # LAYER gv Verkehr / Grenzen - LAYER + LAYER NAME "gv" # Verkehr / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -975,7 +949,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" - wms_title "Grenzen" - END - NAME "gv" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -985,5 +958,5 @@ UNITS METERS CLASS - NAME "(2516)" + # NAME "(2516)" EXPRESSION "2516" STYLE @@ -1019,5 +992,5 @@ END CLASS - NAME "(rn1536)" + # NAME "(rn1536)" EXPRESSION "rn1536" STYLE @@ -1030,5 +1003,5 @@ END CLASS - NAME "(rn1330)" + # NAME "(rn1330)" EXPRESSION "rn1330" STYLE @@ -1041,5 +1014,5 @@ END CLASS - NAME "(rn1320)" + # NAME "(rn1320)" EXPRESSION "rn1320" STYLE @@ -1065,5 +1038,5 @@ END CLASS - NAME "(rn1531)" + # NAME "(rn1531)" EXPRESSION "rn1531" STYLE @@ -1090,6 +1063,5 @@ END - # LAYER fg GebÀude / FlÀchen - LAYER + LAYER NAME "fg" # GebÀude / FlÀchen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1101,7 +1073,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GebÀude" - wms_title "FlÀchen" - END - NAME "fg" + wms_title "FlÀchen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1133,5 +1104,5 @@ END CLASS - NAME "(2510)" + # NAME "(2510)" EXPRESSION "2510" STYLE @@ -1162,6 +1133,5 @@ END - # LAYER gg GebÀude / Grenzen - LAYER + LAYER NAME "gg" # GebÀude / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1173,7 +1143,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GebÀude" - wms_title "Grenzen" - END - NAME "gg" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1183,5 +1152,5 @@ UNITS METERS CLASS - NAME "(rn1330)" + # NAME "(rn1330)" EXPRESSION "rn1330" STYLE @@ -1194,5 +1163,5 @@ END CLASS - NAME "(2512)" + # NAME "(2512)" EXPRESSION "2512" STYLE @@ -1200,7 +1169,5 @@ LINEJOIN ROUND OUTLINECOLOR 0 0 0 - PATTERN - 0.35 0.35 - END + PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 @@ -1214,13 +1181,11 @@ LINEJOIN ROUND OUTLINECOLOR 0 0 0 - PATTERN - 0.35 0.35 - END - SIZE 0.18 - WIDTH 0.18 - END - END - CLASS - NAME "(rn2510)" + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(rn2510)" EXPRESSION "rn2510" STYLE @@ -1238,7 +1203,5 @@ LINEJOIN ROUND OUTLINECOLOR 0 0 0 - PATTERN - 2.00 1.00 - END + PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 @@ -1257,5 +1220,5 @@ END CLASS - NAME "(rn1305)" + # NAME "(rn1305)" EXPRESSION "rn1305" STYLE @@ -1268,5 +1231,5 @@ END CLASS - NAME "(rn1317)" + # NAME "(rn1317)" EXPRESSION "rn1317" STYLE @@ -1274,7 +1237,5 @@ LINEJOIN ROUND OUTLINECOLOR 153 153 153 - PATTERN - 2.00 1.00 - END + PATTERN 2.00 1.00 END SIZE 0.18 WIDTH 0.18 @@ -1293,5 +1254,5 @@ END CLASS - NAME "(2507)" + # NAME "(2507)" EXPRESSION "2507" STYLE @@ -1338,5 +1299,5 @@ END CLASS - NAME "(rn1525)" + # NAME "(rn1525)" EXPRESSION "rn1525" STYLE @@ -1350,6 +1311,5 @@ END - # LAYER gr Rechtliche Festlegungen / Grenzen - LAYER + LAYER NAME "gr" # Rechtliche Festlegungen / Grenzen CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1361,7 +1321,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Rechtliche Festlegungen" - wms_title "Grenzen" - END - NAME "gr" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1370,4 +1329,10 @@ 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" @@ -1377,7 +1342,5 @@ LINEJOIN ROUND OUTLINECOLOR 255 127 127 - PATTERN - 4.00 1.00 - END + PATTERN 4.00 1.00 END SIZE 1 END @@ -1386,5 +1349,5 @@ # LAYER gff FlurstÃŒcke / FlÀchen / Grenzen - LAYER + LAYER NAME "gff" CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1392,20 +1355,20 @@ DATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (NOT layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND NOT polygon IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... - MAXSCALEDENOM 5000 + 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_title "Grenzen" - END - NAME "gff" + wms_title "Grenzen" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END SIZEUNITS METERS STATUS OFF - # ToDo: Universelle Version mit GKZ als Parameter? - HEADER "/opt/gdi/alkisn/templates/alkisausk_inlh.html" - TEMPLATE "/opt/gdi/alkisn/templates/alkisausk_inl*gkz*.html" # gkz = mandant + + 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" - TOLERANCE 1 + TOLERANCEUNITS pixels TOLERANCE 1 + TYPE POLYGON UNITS METERS @@ -1425,6 +1388,5 @@ ## Layer des Typs Linien - # LAYER lt Topographie / Linien - LAYER + LAYER NAME "lt" # Topographie / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1436,7 +1398,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" - wms_title "Linien" - END - NAME "lt" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1450,5 +1411,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1463,6 +1424,5 @@ END - # LAYER lw GewÀsser / Linien - LAYER + LAYER NAME "lw" # GewÀsser / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1474,7 +1434,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GewÀsser" - wms_title "Linien" - END - NAME "lw" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1484,9 +1443,9 @@ UNITS METERS CLASS - NAME "(2003)" + # NAME "(2003)" EXPRESSION "2003" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1500,9 +1459,9 @@ END CLASS - NAME "(2592)" + # NAME "(2592)" EXPRESSION "2592" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1516,9 +1475,9 @@ END CLASS - NAME "(2593)" + # NAME "(2593)" EXPRESSION "2593" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1527,17 +1486,15 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 4.00 2.00 - END - SIZE 0.18 - WIDTH 0.18 - END - END - CLASS - NAME "(2595)" + PATTERN 4.00 2.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2595)" EXPRESSION "2595" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1546,17 +1503,15 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 1.00 2.00 - END - SIZE 0.18 - WIDTH 0.18 - END - END - CLASS - NAME "(2560)" + PATTERN 1.00 2.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + CLASS + # NAME "(2560)" EXPRESSION "2560" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1565,15 +1520,12 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 0.35 0.35 - END - SIZE 0.18 - WIDTH 0.18 - END - END - END - - # LAYER lv Verkehr / Linien - LAYER + PATTERN 0.35 0.35 END + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lv" # Verkehr / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1585,7 +1537,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" - wms_title "Linien" - END - NAME "lv" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1595,9 +1546,9 @@ UNITS METERS CLASS - NAME "(2535)" + # NAME "(2535)" EXPRESSION "2535" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.3535 END @@ -1606,7 +1557,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 2.00 3.20 - END + PATTERN 2.00 3.20 END SIZE 0.35 WIDTH 0.35 @@ -1614,9 +1563,9 @@ END CLASS - NAME "(2525)" + # NAME "(2525)" EXPRESSION "2525" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1630,9 +1579,9 @@ END CLASS - NAME "(2527)" + # NAME "(2527)" EXPRESSION "2527" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1646,9 +1595,9 @@ END CLASS - NAME "(2530)" + # NAME "(2530)" EXPRESSION "2530" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.505 END @@ -1662,9 +1611,9 @@ END CLASS - NAME "(2506)" + # NAME "(2506)" EXPRESSION "2506" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1673,7 +1622,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 0.35 0.35 - END + PATTERN 0.35 0.35 END SIZE 0.18 WIDTH 0.18 @@ -1685,5 +1632,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1698,6 +1645,5 @@ END - # LAYER li Industrie und Gewerbe / Linien - LAYER + LAYER NAME "li" # Industrie und Gewerbe / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1709,7 +1655,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" - wms_title "Linien" - END - NAME "li" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1719,9 +1664,9 @@ UNITS METERS CLASS - NAME "[2524]" + # NAME "[2524]" EXPRESSION "2524" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1736,6 +1681,5 @@ END - # LAYER lg GebÀude / Linien - LAYER + LAYER NAME "lg" # GebÀude / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1747,7 +1691,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GebÀude" - wms_title "Linien" - END - NAME "lg" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1757,9 +1700,9 @@ UNITS METERS CLASS - NAME "(2507)" + # NAME "(2507)" EXPRESSION "2507" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1773,9 +1716,9 @@ END CLASS - NAME "(2303)" + # NAME "(2303)" EXPRESSION "2303" STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -1784,15 +1727,12 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 1.00 1.00 - END - SIZE 0.18 - WIDTH 0.18 - END - END - END - - # LAYER lp Politische Grenzen / Linien - LAYER + PATTERN 1.00 1.00 END + SIZE 0.18 + WIDTH 0.18 + END + END + END + + LAYER NAME "lp" # Politische Grenzen / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1804,7 +1744,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Politische Grenzen" - wms_title "Linien" - END - NAME "lp" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -1818,5 +1757,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1825,7 +1764,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 11.00 - END + PATTERN 5.00 11.00 END SIZE 1 END @@ -1834,7 +1771,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 3.00 0.00 3.00 0.00 10.00 - END + PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END SIZE 1 END @@ -1845,5 +1780,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1852,7 +1787,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 11.00 - END + PATTERN 5.00 11.00 END SIZE 1 END @@ -1861,7 +1794,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 3.00 0.00 3.00 0.00 10.00 - END + PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END SIZE 1 END @@ -1872,5 +1803,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1879,7 +1810,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 8.00 - END + PATTERN 5.00 8.00 END SIZE 1 END @@ -1888,7 +1817,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 3.00 0.00 10.00 - END + PATTERN 0.00 3.00 0.00 10.00 END SIZE 1 END @@ -1899,5 +1826,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1906,7 +1833,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 8.00 - END + PATTERN 5.00 8.00 END SIZE 1 END @@ -1915,7 +1840,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 3.00 0.00 10.00 - END + PATTERN 0.00 3.00 0.00 10.00 END SIZE 1 END @@ -1926,5 +1849,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1933,7 +1856,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 5.00 - END + PATTERN 5.00 5.00 END SIZE 1 END @@ -1942,7 +1863,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 10.00 - END + # PATTERN 0.00 10.00 END SIZE 1 END @@ -1953,5 +1872,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 1.01 END @@ -1960,7 +1879,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 5.00 5.00 - END + PATTERN 5.00 5.00 END SIZE 1 END @@ -1969,7 +1886,5 @@ INITIALGAP 7.5 LINEJOIN ROUND - PATTERN - 0.00 10.00 - END + # PATTERN 0.00 10.00 END SIZE 1 END @@ -1977,6 +1892,5 @@ END - # LAYER lfn FlurstÃŒcke / Nummern / Linien - LAYER + LAYER NAME "lfn" # FlurstÃŒcke / Nummern / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -1988,7 +1902,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/FlurstÃŒcke/Nummern" - wms_title "Linien" - END - NAME "lfn" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2002,5 +1915,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -2018,5 +1931,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.1818 END @@ -2030,6 +1943,5 @@ END - # LAYER lff FlurstÃŒcke / FlÀchen / Linien - LAYER + LAYER NAME "lff" # FlurstÃŒcke / FlÀchen / Linien CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2041,7 +1953,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/FlurstÃŒcke/FlÀchen" - wms_title "Linien" - END - NAME "lff" + wms_title "Linien" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2055,5 +1966,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.3535 END @@ -2062,7 +1973,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 6.00 1.00 - END + PATTERN 6.00 1.00 END SIZE 0.35 WIDTH 0.35 @@ -2074,5 +1983,5 @@ STYLE COLOR 255 255 255 - OPACITY 0 + # OPACITY 0 WIDTH 0.3535 END @@ -2081,7 +1990,5 @@ LINECAP SQUARE LINEJOIN ROUND - PATTERN - 2.00 1.00 - END + PATTERN 2.00 1.00 END SIZE 0.35 WIDTH 0.35 @@ -2092,6 +1999,5 @@ ## Layer des Typs Punkte - # LAYER pff FlurstÃŒcke / FlÀchen / Punkte - LAYER + LAYER NAME "pff" # FlurstÃŒcke / FlÀchen / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2103,7 +2009,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/FlurstÃŒcke/FlÀchen" - wms_title "Punkte" - END - NAME "pff" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2146,6 +2051,5 @@ END - # LAYER pg GebÀude / Punkte - LAYER + LAYER NAME "pg" # GebÀude / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2157,7 +2061,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GebÀude" - wms_title "Punkte" - END - NAME "pg" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2178,5 +2081,5 @@ END CLASS - NAME "(3527)" + # NAME "(3527)" EXPRESSION "3527" STYLE @@ -2371,6 +2274,5 @@ END - # LAYER pv Verkehr / Punkte - LAYER + LAYER NAME "pv" # Verkehr / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2382,7 +2284,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Verkehr" - wms_title "Punkte" - END - NAME "pv" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2454,6 +2355,5 @@ END - # LAYER pe Vegetation / Punkte - LAYER + LAYER NAME "pe" # Vegetation / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2465,7 +2365,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Vegetation" - wms_title "Punkte" - END - NAME "pe" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2659,6 +2558,5 @@ END - # LAYER pw GewÀsser / Punkte - LAYER + LAYER NAME "pw" # GewÀsser / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2670,7 +2568,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/GewÀsser" - wms_title "Punkte" - END - NAME "pw" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2724,5 +2621,5 @@ END CLASS - NAME "(3596)" + # NAME "(3596)" EXPRESSION "3596" STYLE @@ -2746,6 +2643,5 @@ END - # LAYER pi Industrie und Gewerbe / Punkte - LAYER + LAYER NAME "pi" # Industrie und Gewerbe / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2757,7 +2653,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Industrie und Gewerbe" - wms_title "Punkte" - END - NAME "pi" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2862,6 +2757,5 @@ END - # LAYER ps Sport und Freizeit / Punkte - LAYER + LAYER NAME "ps" # Sport und Freizeit / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2873,7 +2767,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Sport und Freizeit" - wms_title "Punkte" - END - NAME "ps" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -2945,6 +2838,5 @@ END - # LAYER pt Topographie / Punkte - LAYER + LAYER NAME "pt" # Topographie / Punkte CLASSITEM "signaturnummer" CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" @@ -2956,7 +2848,6 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/Topographie" - wms_title "Punkte" - END - NAME "pt" + wms_title "Punkte" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3003,6 +2894,5 @@ ## Layer des Typs Beschriftungen - # LAYER bfn FlurstÃŒcke / Nummern / Beschriftungen - LAYER + LAYER NAME "bfn" # FlurstÃŒcke / Nummern / Beschriftungen CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" CONNECTIONTYPE POSTGIS @@ -3014,7 +2904,43 @@ wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" wms_layer_group "/FlurstÃŒcke/Nummern" - wms_title "Beschriftungen (Punkte)" - END - NAME "bfn" + wms_title "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 + FONT [font_umn] + SIZE [size_umn] + BUFFER 2 + COLOR [color_umn] + FORCE TRUE + OUTLINECOLOR 255 255 255 + OUTLINEWIDTH 2 # 1 # krz 2016-05-11 + POSITION [position_umn] + PRIORITY 10 + TYPE TRUETYPE + END + END + END + + LAYER NAME "bg" # GebÀude / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + #EXTENT ... + LABELITEM "text" + MAXSCALEDENOM 3500 + METADATA + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + wms_layer_group "/GebÀude" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3041,9 +2967,9 @@ END - # LAYER bg GebÀude / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bg2" # GebÀude / lfd. Nr. NebengebÀude + # NebengebÀude-Nummer in Klammer, normalerweise aus + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3051,8 +2977,7 @@ METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/GebÀude" - wms_title "Beschriftungen (Punkte)" - END - NAME "bg" + wms_layer_group "/GebÀude" # "/GebÀude/Laufende Hausnummern" + wms_title "lfd. Nr. NebengebÀude" # "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3079,21 +3004,17 @@ END - # LAYER bg2 GebÀude / Laufende Hausnummern / Beschriftungen - # * NebengebÀude-Nummer in Klammer, normalerweise aus - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer='ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER # Lagebezeichnungen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" - MAXSCALEDENOM 3500 - METADATA - wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - # wms_layer_group "/GebÀude/Laufende Hausnummern" - # wms_title "Beschriftungen (Punkte)" - wms_layer_group "/GebÀude" - wms_title "lfd. Nr. NebengebÀude" - END - NAME "bg2" + 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)" + END + NAME "bl" PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3120,18 +3041,16 @@ END - # LAYER bl Lagebezeichnungen / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" - MAXSCALEDENOM 5000 - METADATA - wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/Lagebezeichnungen" - wms_title "Beschriftungen (Punkte)" - END - NAME "bl" + 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)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3158,18 +3077,16 @@ END - # LAYER br Rechtliche Festlegungen / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bv" # Verkehr / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" - MAXSCALEDENOM 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)" - END - NAME "br" + 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)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3196,9 +3113,8 @@ END - # LAYER bv Verkehr / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bh" # FriedHöfe / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3206,8 +3122,7 @@ METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/Verkehr" - wms_title "Beschriftungen (Punkte)" - END - NAME "bv" + wms_layer_group "/Friedhöfe" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3234,9 +3149,8 @@ END - # LAYER bh Friedhöfe / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "be" # Vegetation / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3244,8 +3158,7 @@ METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/Friedhöfe" - wms_title "Beschriftungen (Punkte)" - END - NAME "bh" + wms_layer_group "/Vegetation" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3272,9 +3185,8 @@ END - # LAYER be Vegetation / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bw" # GewÀsser / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3282,8 +3194,7 @@ METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/Vegetation" - wms_title "Beschriftungen (Punkte)" - END - NAME "be" + wms_layer_group "/GewÀsser" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3310,18 +3221,16 @@ END - # LAYER bw GewÀsser / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" - MAXSCALEDENOM 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)" - END - NAME "bw" + 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)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3329,5 +3238,5 @@ STATUS OFF SYMBOLSCALEDENOM 1000 - TYPE POINT + TYPE POINT # ANNOTATION UNITS METERS CLASS @@ -3348,9 +3257,8 @@ END - # LAYER bi Industrie und Gewerbe / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bs" # Sport und Freizeit / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3358,8 +3266,7 @@ 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)" - END - NAME "bi" + wms_layer_group "/Sport und Freizeit" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3386,9 +3293,8 @@ END - # LAYER bs Sport und Freizeit / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bb" # WohnBauflÀchen / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3396,8 +3302,7 @@ 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)" - END - NAME "bs" + wms_layer_group "/WohnbauflÀchen" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3424,9 +3329,8 @@ END - # LAYER bb WohnbauflÀchen / Beschriftungen - LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" + LAYER NAME "bt" # Topographie / Beschriftungen + CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" + CONNECTIONTYPE POSTGIS + DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" #EXTENT ... LABELITEM "text" @@ -3434,8 +3338,7 @@ METADATA wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/WohnbauflÀchen" - wms_title "Beschriftungen (Punkte)" - END - NAME "bb" + wms_layer_group "/Topographie" + wms_title "Beschriftungen (Punkte)" + END PROCESSING "CLOSE_CONNECTION=DEFER" PROJECTION "init=epsg:25832" END @@ -3443,5 +3346,5 @@ STATUS OFF SYMBOLSCALEDENOM 1000 - TYPE POINT # ANNOTATION + TYPE POINT UNITS METERS CLASS @@ -3462,38 +3365,30 @@ END - # LAYER bt Topographie / Beschriftungen LAYER - CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" - CONNECTIONTYPE POSTGIS - DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=1 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" - #EXTENT ... - LABELITEM "text" - MAXSCALEDENOM 10000 - METADATA - wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" - wms_layer_group "/Topographie" - wms_title "Beschriftungen (Punkte)" - END - NAME "bt" - PROCESSING "CLOSE_CONNECTION=DEFER" - PROJECTION "init=epsg:25832" END - SIZEUNITS INCHES - STATUS OFF - SYMBOLSCALEDENOM 1000 + NAME "copyright" + STATUS ON # DEFAULT TYPE POINT - UNITS METERS + TRANSFORM lr + METADATA + wms_title "Copyright" + wms_abstract "In der Karte sichtbare Angabe auf die Herkunft der Daten" + WMS_KEYWORDLIST "Katasteramt, Copyright, Quellenangabe" + wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" + END + FEATURE + POINTS 0 0 END + # individuell Kreisname und ggf. Vertragsnummer einsetzen: + TEXT 'Copyright Geobasisdaten Liegenschaftskataster Kreis __' + END CLASS LABEL - ANGLE [drehwinkel_grad] - ANTIALIAS TRUE - FONT [font_umn] - SIZE [size_umn] - BUFFER 2 - COLOR [color_umn] + SIZE small + POSITION ul + COLOR 50 50 50 FORCE TRUE - OUTLINECOLOR 255 255 255 - POSITION [position_umn] - PRIORITY 10 - TYPE TRUETYPE + STYLE + GEOMTRANSFORM 'labelpoly' + COLOR 250 250 250 + END END END Index: trunk/umn/alkis_n/templates/alkisausk.html =================================================================== --- trunk/umn/alkis_n/templates/alkisausk.html (revision 368) +++ trunk/umn/alkis_n/templates/alkisausk.html (revision 368) @@ -0,0 +1,8 @@ + + Index: trunk/umn/alkis_n/templates/alkisrechtbauh.html =================================================================== --- trunk/umn/alkis_n/templates/alkisrechtbauh.html (revision 368) +++ trunk/umn/alkis_n/templates/alkisrechtbauh.html (revision 368) @@ -0,0 +1,10 @@ + + + +
+