[423] | 1 | MAP
|
---|
[428] | 2 | # ALKIS: "Bauwerke" aus verschiedenen Tabellen anzeigen.
|
---|
[423] | 3 | # Einige dieser Bauwerke werden in der amtlichen Standard-Karte nicht angezeigt, z.B. DurchlÀsse im GewÀsserbereich.
|
---|
| 4 | # Andere sehen aus wie GebÀude (z.B. Carport aus Sonstige).
|
---|
| 5 | # Mit Maptrimmer eine ausfÃŒhrbare (schlanke) Version diese Mapfiles fÃŒr jedes GKZ (Mandant) erzeugen.
|
---|
| 6 | # Stand
|
---|
| 7 | # 2021-03-01 Entwurf
|
---|
| 8 | # 2021-03-02 POINT-Layer, Stichworte, Korrekturen
|
---|
| 9 | # 2021-03-15 TEMPLATE fÃŒr Auskunft "Bauwerk"
|
---|
[428] | 10 | # 2022-02-24 Neue Bauwerks-Typen 10,11,12.
|
---|
| 11 | # JOIN fÃŒr Feature-Info in allen Layern. EXTENT auch in Layern.
|
---|
| 12 | # FÃŒr die Kartenanzeige (label) wird mit "coalesce()" vorrangig der Name angezeigt, ersatzweise der Bauwerkstyp.
|
---|
| 13 | # FÃŒr die Feature-Info werden beide Werte an das Template geliefert.
|
---|
[423] | 14 |
|
---|
[428] | 15 | # ToDo: keywords vervollstÀndigen
|
---|
| 16 |
|
---|
[423] | 17 | NAME "alkis_bauwerke_*gkz*"
|
---|
| 18 | EXTENT ...
|
---|
| 19 | PROJECTION "init=epsg:25832" END
|
---|
| 20 | STATUS ON
|
---|
| 21 | MAXSIZE 8400
|
---|
| 22 | FONTSET "/opt/gdi/fonts/arial.fnt"
|
---|
| 23 | UNITS METERS
|
---|
| 24 | SYMBOL
|
---|
| 25 | NAME "pkt"
|
---|
| 26 | TYPE ellipse FILLED true
|
---|
| 27 | POINTS 5 5 END
|
---|
| 28 | END
|
---|
| 29 | WEB
|
---|
| 30 | MINSCALEDENOM 50
|
---|
| 31 | MAXSCALEDENOM 20000
|
---|
| 32 | METADATA
|
---|
| 33 | wms_title "ALKIS Bauwerke"
|
---|
| 34 | wms_abstract "Gesonderter Kartendienst fÌr alle Arten von Bauwerken im ALKIS. Diese werden farblich hervorgehoben und mit ihrem Typ beschriftet. Dies Bauwerke werden teilweise auch in der ALKIS-Standardkarte dargestellt, sind dort aber eher unauffÀllig (z.B. BrÌcke) oder können mit GebÀuden verwechselt werden (z.B. Carport)."
|
---|
| 35 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 36 | wms_bbox_extended "true"
|
---|
| 37 | wms_encoding "UTF-8"
|
---|
[428] | 38 | wms_onlineresource "https://mein.ows-server.de/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis_bauwerke_*gkz*.map"
|
---|
[423] | 39 | wms_feature_info_mime_type "text/html"
|
---|
| 40 | wms_keywordlist "GKZ*gkz*,ALKIS,Bauwerk,BrÃŒcke,Durchlass,Carport,Turm"
|
---|
| 41 | wms_fees "none"
|
---|
| 42 | wms_accessconstraints "fÃŒr den Dienstgebrauch"
|
---|
| 43 | wms_enable_request "*"
|
---|
| 44 | include "meta600.map"
|
---|
| 45 | END
|
---|
| 46 | END
|
---|
| 47 | LEGEND
|
---|
| 48 | STATUS ON
|
---|
| 49 | KEYSIZE 32 16
|
---|
| 50 | KEYSPACING 5 5
|
---|
| 51 | TRANSPARENT ON
|
---|
| 52 | LABEL
|
---|
| 53 | TYPE TRUETYPE
|
---|
| 54 | FONT 'arial'
|
---|
| 55 | SIZE 9
|
---|
| 56 | COLOR 1 1 1
|
---|
| 57 | END
|
---|
| 58 | END
|
---|
| 59 |
|
---|
[428] | 60 | # 1: V e r k e h r
|
---|
[423] | 61 | LAYER
|
---|
| 62 | NAME verkehr_f
|
---|
| 63 | GROUP verkehr
|
---|
| 64 | TYPE POLYGON
|
---|
[428] | 65 | EXTENT ...
|
---|
| 66 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 67 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 68 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 69 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 70 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkimverkehrsbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimverkehrsbereich u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS vf using SRID=25832 using unique gml_id"
|
---|
[423] | 71 | METADATA
|
---|
| 72 | wms_group_title "Verkehr"
|
---|
| 73 | wms_group_abstract "Bauwerke im Verkehrsbereich"
|
---|
| 74 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 75 | wms_title "Verk. FlÀchen"
|
---|
| 76 | wms_abstract "Bauwerke im Verkehrsbereich (FlÀchen)"
|
---|
| 77 | wms_keywordlist "BrÃŒcke,BrÃŒckenpfeiler,Tunnel,UnterfÃŒhrung,LandebrÃŒcke,Schleusenkammer,Hochbahn,HochstraÃe,Durchfahrt"
|
---|
| 78 | END
|
---|
| 79 | MINSCALEDENOM 50
|
---|
| 80 | MAXSCALEDENOM 15000
|
---|
| 81 | SYMBOLSCALEDENOM 800
|
---|
[428] | 82 | LABELITEM "label"
|
---|
| 83 | JOIN
|
---|
| 84 | NAME "BW"
|
---|
| 85 | CONNECTIONTYPE postgresql
|
---|
| 86 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 87 | TABLE "(SELECT 1 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkimverkehrsbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimverkehrsbereich u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 88 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 89 | END
|
---|
| 90 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 91 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 92 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 93 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 94 | CLASS
|
---|
| 95 | NAME "Fl. Bauwerk im Verkehrsbereich"
|
---|
| 96 | STYLE
|
---|
| 97 | COLOR 40 0 180 OPACITY 14 # Blau
|
---|
| 98 | END
|
---|
| 99 | STYLE
|
---|
| 100 | OUTLINECOLOR 40 0 180
|
---|
| 101 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 102 | END
|
---|
| 103 | LABEL
|
---|
| 104 | MAXSCALEDENOM 2000
|
---|
| 105 | TYPE TRUETYPE FONT arial COLOR 40 0 180 OUTLINECOLOR 230 230 230
|
---|
| 106 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 107 | END
|
---|
| 108 | END
|
---|
| 109 | END
|
---|
| 110 | LAYER
|
---|
| 111 | NAME verkehr_l
|
---|
| 112 | GROUP verkehr
|
---|
| 113 | TYPE LINE
|
---|
[428] | 114 | EXTENT ...
|
---|
| 115 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 116 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 117 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 118 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 119 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkimverkehrsbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimverkehrsbereich u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='LINESTRING') AS vl using SRID=25832 using unique gml_id"
|
---|
[423] | 120 | METADATA
|
---|
| 121 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 122 | wms_title "Verk. Linien"
|
---|
| 123 | wms_abstract "Bauwerke im Verkehrsbereich (Linien)"
|
---|
| 124 | wms_keywordlist "Widerlager,Steg"
|
---|
| 125 | END
|
---|
| 126 | MINSCALEDENOM 50
|
---|
| 127 | MAXSCALEDENOM 15000
|
---|
| 128 | SYMBOLSCALEDENOM 800
|
---|
[428] | 129 | LABELITEM "label"
|
---|
| 130 |
|
---|
| 131 | JOIN
|
---|
| 132 | NAME "BW"
|
---|
| 133 | CONNECTIONTYPE postgresql
|
---|
| 134 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 135 | TABLE "(SELECT 1 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkimverkehrsbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimverkehrsbereich u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 136 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 137 | END
|
---|
| 138 |
|
---|
[423] | 139 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 140 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 141 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 142 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 143 | CLASS
|
---|
| 144 | NAME "Li. Bauwerk im Verkehrsbereich"
|
---|
| 145 | STYLE
|
---|
| 146 | COLOR 40 0 180
|
---|
| 147 | WIDTH 4 MINWIDTH 2 MAXWIDTH 7 #LI
|
---|
| 148 | END
|
---|
| 149 | LABEL
|
---|
| 150 | MAXSCALEDENOM 2000
|
---|
| 151 | TYPE TRUETYPE FONT arial COLOR 40 0 180 OUTLINECOLOR 230 230 230
|
---|
| 152 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 153 | END
|
---|
| 154 | END
|
---|
| 155 | END
|
---|
| 156 |
|
---|
[428] | 157 | # 2: G e w À s s e r
|
---|
[423] | 158 | LAYER
|
---|
| 159 | NAME gewaess_f
|
---|
| 160 | GROUP gewaess
|
---|
| 161 | TYPE POLYGON
|
---|
[428] | 162 | EXTENT ...
|
---|
| 163 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 164 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 165 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 166 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 167 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS gf using SRID=25832 using unique gml_id"
|
---|
[423] | 168 | METADATA
|
---|
| 169 | wms_group_title "GewÀsser"
|
---|
| 170 | wms_group_abstract "Bauwerke im GewÀsserbereich"
|
---|
| 171 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 172 | wms_title "Gew. FlÀchen"
|
---|
| 173 | wms_abstract "Bauwerke im GewÀsserbereich (FlÀchen)"
|
---|
| 174 | wms_keywordlist "Rohrdurchlass,Wehr,RÌckhaltebecken,Durchlass,Fischtreppe,Schöpfwerk,Sicherheitstor,Hafendamm,Mole"
|
---|
| 175 | END
|
---|
| 176 | MINSCALEDENOM 50
|
---|
| 177 | MAXSCALEDENOM 15000
|
---|
| 178 | SYMBOLSCALEDENOM 800
|
---|
[428] | 179 | LABELITEM "label"
|
---|
| 180 | JOIN
|
---|
| 181 | NAME "BW"
|
---|
| 182 | CONNECTIONTYPE postgresql
|
---|
| 183 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 184 | TABLE "(SELECT 2 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 185 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 186 | END
|
---|
| 187 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 188 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 189 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 190 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 191 | CLASS
|
---|
| 192 | # EXPRESSION "__"
|
---|
| 193 | NAME "Fl. Bauwerk im GewÀsserbereich"
|
---|
| 194 | STYLE
|
---|
| 195 | COLOR 0 160 246 OPACITY 14 # Hellblau
|
---|
| 196 | END
|
---|
| 197 | STYLE
|
---|
| 198 | OUTLINECOLOR 0 160 246
|
---|
| 199 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 200 | END
|
---|
| 201 | LABEL
|
---|
| 202 | MAXSCALEDENOM 3000
|
---|
| 203 | TYPE TRUETYPE FONT arial COLOR 0 160 246 OUTLINECOLOR 230 230 230
|
---|
| 204 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 205 | END
|
---|
| 206 | END
|
---|
| 207 | END
|
---|
| 208 | LAYER
|
---|
| 209 | NAME gewaess_l
|
---|
| 210 | GROUP gewaess
|
---|
| 211 | TYPE LINE
|
---|
[428] | 212 | EXTENT ...
|
---|
| 213 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 214 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 215 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 216 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 217 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='LINESTRING') AS gl using SRID=25832 using unique gml_id"
|
---|
[423] | 218 | METADATA
|
---|
| 219 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 220 | wms_title "Gew. Linien"
|
---|
| 221 | wms_abstract "Bauwerke im GewÀsserbereich (Linien)"
|
---|
| 222 | wms_keywordlist "Wehr,Rohrdurchlass,DÃŒker,Ufermauer,Kaimauer,Siel"
|
---|
| 223 | END
|
---|
| 224 | MINSCALEDENOM 50
|
---|
| 225 | MAXSCALEDENOM 15000
|
---|
| 226 | SYMBOLSCALEDENOM 800
|
---|
[428] | 227 | LABELITEM "label"
|
---|
| 228 | JOIN
|
---|
| 229 | NAME "BW"
|
---|
| 230 | CONNECTIONTYPE postgresql
|
---|
| 231 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 232 | TABLE "(SELECT 2 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 233 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 234 | END
|
---|
[423] | 235 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 236 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 237 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 238 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 239 | CLASS
|
---|
| 240 | NAME "Li. Bauwerk im GewÀsserbereich"
|
---|
| 241 | STYLE
|
---|
| 242 | COLOR 0 160 246
|
---|
| 243 | WIDTH 4 MINWIDTH 2 MAXWIDTH 7 #LI
|
---|
| 244 | END
|
---|
| 245 | LABEL
|
---|
| 246 | MAXSCALEDENOM 3500
|
---|
| 247 | TYPE TRUETYPE FONT arial COLOR 0 160 246 OUTLINECOLOR 230 230 230
|
---|
| 248 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 249 | END
|
---|
| 250 | END
|
---|
| 251 | END
|
---|
| 252 | LAYER
|
---|
| 253 | NAME gewaess_p
|
---|
| 254 | GROUP gewaess
|
---|
| 255 | TYPE POINT
|
---|
[428] | 256 | EXTENT ...
|
---|
| 257 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 258 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 259 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 260 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 261 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS gl using SRID=25832 using unique gml_id"
|
---|
[423] | 262 | METADATA
|
---|
| 263 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 264 | wms_title "Gew. Punkte"
|
---|
| 265 | wms_abstract "Bauwerke im GewÀsserbereich (Punkte)"
|
---|
| 266 | wms_keywordlist "Rohrdurchlass,Durchlass,Pegel"
|
---|
| 267 | END
|
---|
| 268 | MINSCALEDENOM 50
|
---|
| 269 | MAXSCALEDENOM 15000
|
---|
| 270 | SYMBOLSCALEDENOM 800
|
---|
[428] | 271 | LABELITEM "label"
|
---|
| 272 | JOIN
|
---|
| 273 | NAME "BW"
|
---|
| 274 | CONNECTIONTYPE postgresql
|
---|
| 275 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 276 | TABLE "(SELECT 2 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkimgewaesserbereich b LEFT JOIN ax_bauwerksfunktion_bauwerkimgewaesserbereich u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 277 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 278 | END
|
---|
[423] | 279 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 280 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 281 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 282 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 283 | CLASS
|
---|
| 284 | NAME "Pu. Bauwerk im GewÀsserbereich"
|
---|
| 285 | STYLE
|
---|
| 286 | SYMBOL "pkt"
|
---|
| 287 | COLOR 0 160 246
|
---|
| 288 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 289 | END
|
---|
| 290 | LABEL
|
---|
| 291 | MAXSCALEDENOM 4000
|
---|
| 292 | TYPE TRUETYPE FONT arial COLOR 0 160 246 OUTLINECOLOR 230 230 230
|
---|
| 293 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 294 | END
|
---|
| 295 | END
|
---|
| 296 | END
|
---|
| 297 |
|
---|
[428] | 298 | # 3: S o n s t i g e
|
---|
[423] | 299 | LAYER
|
---|
| 300 | NAME sonst_f
|
---|
| 301 | GROUP sonst
|
---|
| 302 | TYPE POLYGON
|
---|
[428] | 303 | EXTENT ...
|
---|
| 304 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 305 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 306 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 307 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 308 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND (GeometryType(b.wkb_geometry)='POLYGON' OR GeometryType(b.wkb_geometry)='MULTIPOLYGON')) AS sf using SRID=25832 using unique gml_id"
|
---|
[423] | 309 | METADATA
|
---|
| 310 | wms_group_title "Sonstiges Bauwerk"
|
---|
| 311 | wms_group_abstract "Sonstiges Bauwerk oder Sonstige Einrichtung"
|
---|
| 312 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 313 | wms_title "Sonst. FlÀchen"
|
---|
| 314 | wms_abstract "Sonstiges Bauwerk oder Sonstige Einrichtung (FlÀchen)"
|
---|
| 315 | wms_keywordlist "Ãberdachung,Carport,Brunnen,Treppe,StÃŒtzmauer,Mauer,Terrasse,Freitreppe,Rampe,GedenkstÀtte,Denkmal,Denkstein,Standbild,Springbrunnen,Zierbrunnen"
|
---|
| 316 | END
|
---|
| 317 | MINSCALEDENOM 50
|
---|
| 318 | MAXSCALEDENOM 15000
|
---|
| 319 | SYMBOLSCALEDENOM 800
|
---|
[428] | 320 | LABELITEM "label"
|
---|
| 321 | JOIN
|
---|
| 322 | NAME "BW"
|
---|
| 323 | CONNECTIONTYPE postgresql
|
---|
| 324 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 325 | TABLE "(SELECT 3 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 326 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 327 | END
|
---|
| 328 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 329 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 330 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 331 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 332 | CLASS
|
---|
| 333 | NAME "Fl. Sonstiges Bauwerk"
|
---|
| 334 | STYLE
|
---|
| 335 | COLOR 160 130 0 OPACITY 14 # Senfgelb
|
---|
| 336 | END
|
---|
| 337 | STYLE
|
---|
| 338 | OUTLINECOLOR 160 130 0
|
---|
| 339 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 340 | END
|
---|
| 341 | LABEL
|
---|
| 342 | MAXSCALEDENOM 1800
|
---|
| 343 | TYPE TRUETYPE FONT arial COLOR 160 130 0 OUTLINECOLOR 230 230 230
|
---|
| 344 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 345 | END
|
---|
| 346 | END
|
---|
| 347 | END
|
---|
| 348 | LAYER
|
---|
| 349 | NAME sonst_l
|
---|
| 350 | GROUP sonst
|
---|
| 351 | TYPE LINE
|
---|
[428] | 352 | EXTENT ...
|
---|
| 353 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 354 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 355 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 356 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 357 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='LINESTRING') AS sl using SRID=25832 using unique gml_id"
|
---|
[423] | 358 | METADATA
|
---|
| 359 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 360 | wms_title "Sonst. Linien"
|
---|
| 361 | wms_abstract "Sonstiges Bauwerk oder Sonstige Einrichtung (Linien)"
|
---|
| 362 | wms_keywordlist "Zaun,StÃŒtzmauer,Mauermitte,Mauerkante,Treppenunterkante,StÃŒtzmauermitte,Spundwand"
|
---|
| 363 | END
|
---|
| 364 | MINSCALEDENOM 50
|
---|
| 365 | MAXSCALEDENOM 15000
|
---|
| 366 | SYMBOLSCALEDENOM 800
|
---|
[428] | 367 | LABELITEM "label"
|
---|
| 368 | JOIN
|
---|
| 369 | NAME "BW"
|
---|
| 370 | CONNECTIONTYPE postgresql
|
---|
| 371 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 372 | TABLE "(SELECT 3 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 373 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 374 | END
|
---|
[423] | 375 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 376 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 377 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 378 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 379 | CLASS
|
---|
| 380 | NAME "Li. Sonstiges Bauwerk"
|
---|
| 381 | STYLE
|
---|
| 382 | COLOR 160 130 0
|
---|
| 383 | WIDTH 4 MINWIDTH 2 MAXWIDTH 7 #LI
|
---|
| 384 | END
|
---|
| 385 | LABEL
|
---|
| 386 | MAXSCALEDENOM 1800
|
---|
| 387 | TYPE TRUETYPE FONT arial COLOR 160 130 0 OUTLINECOLOR 230 230 230
|
---|
| 388 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 389 | END
|
---|
| 390 | END
|
---|
| 391 | END
|
---|
| 392 | LAYER
|
---|
| 393 | NAME sonst_p
|
---|
| 394 | GROUP sonst
|
---|
| 395 | TYPE POINT
|
---|
[428] | 396 | EXTENT ...
|
---|
| 397 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 398 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 399 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 400 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 401 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS gl using SRID=25832 using unique gml_id"
|
---|
[423] | 402 | METADATA
|
---|
| 403 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 404 | wms_title "Sonstige. Punkte"
|
---|
| 405 | wms_abstract "Sonstiges Bauwerk oder Sonstige Einrichtung (Punkte)"
|
---|
| 406 | wms_keywordlist "GedenkstÀtte,Denkmal,Denkstein,Standbild,Brunnen,Meilenstein,historischer Grenzstein,Wegekreuz,Ziehbrunnen"
|
---|
| 407 | END
|
---|
| 408 | MINSCALEDENOM 50
|
---|
| 409 | MAXSCALEDENOM 15000
|
---|
| 410 | SYMBOLSCALEDENOM 800
|
---|
[428] | 411 | LABELITEM "label"
|
---|
| 412 | JOIN
|
---|
| 413 | NAME "BW"
|
---|
| 414 | CONNECTIONTYPE postgresql
|
---|
| 415 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 416 | TABLE "(SELECT 3 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_sonstigesbauwerkodersonstigeeinrichtung b LEFT JOIN ax_bauwerksfunktion_sonstigesbauwerkodersonstigeeinrichtun u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 417 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 418 | END
|
---|
[423] | 419 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 420 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 421 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 422 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 423 | CLASS
|
---|
| 424 | NAME "Pu. Sonstiges Bauwerk"
|
---|
| 425 | STYLE
|
---|
| 426 | SYMBOL "pkt"
|
---|
| 427 | COLOR 160 130 0
|
---|
| 428 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 429 | END
|
---|
| 430 | LABEL
|
---|
| 431 | MAXSCALEDENOM 4000
|
---|
| 432 | TYPE TRUETYPE FONT arial COLOR 160 130 0 OUTLINECOLOR 230 230 230
|
---|
| 433 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 434 | END
|
---|
| 435 | END
|
---|
| 436 | END
|
---|
| 437 |
|
---|
[428] | 438 | # 4: Bauwerk oder Anlage fÃŒr Industrie und Gewerbe
|
---|
[423] | 439 | LAYER
|
---|
| 440 | NAME indu_f
|
---|
| 441 | GROUP indu
|
---|
| 442 | TYPE POLYGON
|
---|
[428] | 443 | EXTENT ...
|
---|
| 444 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 445 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 446 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 447 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 448 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuerindustrieundgewer u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS if using SRID=25832 using unique gml_id"
|
---|
[423] | 449 | METADATA
|
---|
| 450 | wms_group_title "Ind./Gewerbe Bauwerk"
|
---|
| 451 | wms_group_abstract "Bauwerk oder Anlage fÃŒr Industrie und Gewerbe"
|
---|
| 452 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 453 | wms_title "Ind./Gewerbe FlÀchen"
|
---|
| 454 | wms_abstract "Bauwerk oder Anlage fÌr Industrie und Gewerbe (FlÀchen)"
|
---|
| 455 | wms_keywordlist "KlÀrbecken,Umformer,Schornstein,Schlot,Esse,Biogasanlage,Funkmast,Windrad,Mast,Solarzellen,Laufkran, BrÌckenlaufkran,Portalkran,Trockendock,Schachtöffnung,Einsteigeschacht"
|
---|
| 456 | END
|
---|
| 457 | MINSCALEDENOM 50
|
---|
| 458 | MAXSCALEDENOM 15000
|
---|
| 459 | SYMBOLSCALEDENOM 800
|
---|
[428] | 460 | LABELITEM "label"
|
---|
| 461 | JOIN
|
---|
| 462 | NAME "BW"
|
---|
| 463 | CONNECTIONTYPE postgresql
|
---|
| 464 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 465 | TABLE "(SELECT 4 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkoderanlagefuerindustrieundgewerbe b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuerindustrieundgewer u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 466 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 467 | END
|
---|
| 468 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 469 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 470 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 471 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 472 | CLASS
|
---|
| 473 | NAME "Fl. Ind./Gewerbe Bauwerk"
|
---|
| 474 | STYLE
|
---|
| 475 | COLOR 252 162 2 OPACITY 14 # orange
|
---|
| 476 | END
|
---|
| 477 | STYLE
|
---|
| 478 | OUTLINECOLOR 252 162 2
|
---|
| 479 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 480 | END
|
---|
| 481 | LABEL
|
---|
| 482 | MAXSCALEDENOM 3000
|
---|
| 483 | TYPE TRUETYPE FONT arial COLOR 252 162 2 OUTLINECOLOR 230 230 230
|
---|
| 484 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 485 | END
|
---|
| 486 | END
|
---|
| 487 | END
|
---|
| 488 | # LAYER # immer leer?
|
---|
| 489 | # NAME indu_l
|
---|
| 490 | # GROUP indu
|
---|
| 491 | # TYPE LINE
|
---|
[428] | 492 | #...
|
---|
[423] | 493 | # END
|
---|
| 494 | LAYER
|
---|
| 495 | NAME indu_p
|
---|
| 496 | GROUP indu
|
---|
| 497 | TYPE POINT
|
---|
[428] | 498 | EXTENT ...
|
---|
| 499 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 500 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 501 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 502 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 503 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuerindustrieundgewer u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS gl using SRID=25832 using unique gml_id"
|
---|
[423] | 504 | METADATA
|
---|
| 505 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 506 | wms_title "Ind./Gewerbe Punkte"
|
---|
| 507 | wms_abstract "Bauwerk oder Anlage fÃŒr Industrie und Gewerbe (Punkte)"
|
---|
| 508 | wms_keywordlist "Mast,Windrad,Funkmast,Solarzellen,Schornstein,Schlot,Esse,Umformer,Laufkran,BrÌckenlaufkran,Stollenmundloch, Portalkran,Drehkran,Schachtöffnung,Einsteigeschacht"
|
---|
| 509 | END
|
---|
| 510 | MINSCALEDENOM 50
|
---|
| 511 | MAXSCALEDENOM 15000
|
---|
| 512 | SYMBOLSCALEDENOM 800
|
---|
[428] | 513 | LABELITEM "label"
|
---|
| 514 | JOIN
|
---|
| 515 | NAME "BW"
|
---|
| 516 | CONNECTIONTYPE postgresql
|
---|
| 517 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 518 | TABLE "(SELECT 4 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkoderanlagefuerindustrieundgewerbe b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuerindustrieundgewer u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 519 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 520 | END
|
---|
[423] | 521 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 522 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 523 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 524 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 525 | CLASS
|
---|
| 526 | NAME "Pu. Ind./Gewerbe Bauwerk"
|
---|
| 527 | STYLE
|
---|
| 528 | SYMBOL "pkt"
|
---|
| 529 | COLOR 252 162 2
|
---|
| 530 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 531 | END
|
---|
| 532 | LABEL
|
---|
| 533 | MAXSCALEDENOM 4000
|
---|
| 534 | TYPE TRUETYPE FONT arial COLOR 252 162 2 OUTLINECOLOR 230 230 230
|
---|
| 535 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 536 | END
|
---|
| 537 | END
|
---|
| 538 | END
|
---|
| 539 |
|
---|
[428] | 540 | # 5: Bauwerk oder Anlage fÃŒr Sport, Freizeit und Erholung
|
---|
[423] | 541 | LAYER
|
---|
| 542 | NAME sport_f
|
---|
| 543 | GROUP sport
|
---|
| 544 | TYPE POLYGON
|
---|
[428] | 545 | EXTENT ...
|
---|
| 546 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 547 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 548 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 549 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 550 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuersportfreizeitunde u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS sf using SRID=25832 using unique gml_id"
|
---|
[423] | 551 | METADATA
|
---|
| 552 | wms_group_title "Sport/Freiz. Bauwerk"
|
---|
| 553 | wms_group_abstract "Bauwerk oder Anlage fÃŒr Sport, Freizeit und Erholung"
|
---|
| 554 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 555 | wms_title "Sport/Freiz. FlÀchen"
|
---|
| 556 | wms_abstract "Bauwerk oder Anlage fÌr Sport, Freizeit und Erholung (FlÀchen)"
|
---|
| 557 | wms_keywordlist "Spielfeld,Schwimmbecken,Rennbahn,Laufbahn,GelÀuf,ZuschauertribÃŒne nicht ÃŒberdacht,ZuschauertribÃŒne ÃŒberdacht, Rasenplatz,Hartplatz,Stadion,Liegewiese,SchieÃanlage,Wildgehege,Gradierwerk"
|
---|
| 558 | END
|
---|
| 559 | MINSCALEDENOM 50
|
---|
| 560 | MAXSCALEDENOM 15000
|
---|
| 561 | SYMBOLSCALEDENOM 800
|
---|
[428] | 562 | LABELITEM "label"
|
---|
| 563 | JOIN
|
---|
| 564 | NAME "BW"
|
---|
| 565 | CONNECTIONTYPE postgresql
|
---|
| 566 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 567 | TABLE "(SELECT 5 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkoderanlagefuersportfreizeitunderholung b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuersportfreizeitunde u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 568 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 569 | END
|
---|
| 570 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 571 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 572 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 573 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 574 | CLASS
|
---|
| 575 | # EXPRESSION "__"
|
---|
| 576 | NAME "Fl. Sport/Freiz. Bauwerk"
|
---|
| 577 | STYLE
|
---|
| 578 | COLOR 140 0 120 OPACITY 14 # magenta
|
---|
| 579 | END
|
---|
| 580 | STYLE
|
---|
| 581 | OUTLINECOLOR 140 0 120
|
---|
| 582 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 583 | END
|
---|
| 584 | LABEL
|
---|
| 585 | MAXSCALEDENOM 5000
|
---|
| 586 | TYPE TRUETYPE FONT arial COLOR 140 0 120 OUTLINECOLOR 230 230 230
|
---|
| 587 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 588 | END
|
---|
| 589 | END
|
---|
| 590 | END
|
---|
| 591 | # LAYER # immer leer?
|
---|
| 592 | # NAME sport_l
|
---|
| 593 | # GROUP sport
|
---|
| 594 | # TYPE LINE
|
---|
[428] | 595 | #...
|
---|
[423] | 596 | # END
|
---|
| 597 | LAYER
|
---|
| 598 | NAME sport_p
|
---|
| 599 | GROUP sport
|
---|
| 600 | TYPE POINT
|
---|
[428] | 601 | EXTENT ...
|
---|
| 602 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 603 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 604 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 605 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 606 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuersportfreizeitunde u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS gl using SRID=25832 using unique gml_id"
|
---|
[423] | 607 | METADATA
|
---|
| 608 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 609 | wms_title "Sport/Freiz. Punkte"
|
---|
| 610 | wms_abstract "Bauwerk oder Anlage fÃŒr Sport, Freizeit und Erholung (Punkte)"
|
---|
| 611 | wms_keywordlist "Spielfeld"
|
---|
| 612 | END
|
---|
| 613 | MINSCALEDENOM 50
|
---|
| 614 | MAXSCALEDENOM 15000
|
---|
| 615 | SYMBOLSCALEDENOM 800
|
---|
[428] | 616 | LABELITEM "label"
|
---|
| 617 | JOIN
|
---|
| 618 | NAME "BW"
|
---|
| 619 | CONNECTIONTYPE postgresql
|
---|
| 620 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 621 | TABLE "(SELECT 5 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_bauwerkoderanlagefuersportfreizeitunderholung b LEFT JOIN ax_bauwerksfunktion_bauwerkoderanlagefuersportfreizeitunde u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 622 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 623 | END
|
---|
[423] | 624 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 625 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 626 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 627 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 628 | CLASS
|
---|
| 629 | NAME "Pu. Sport/Freiz."
|
---|
| 630 | STYLE
|
---|
| 631 | SYMBOL "pkt"
|
---|
| 632 | COLOR 140 0 120
|
---|
| 633 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 634 | END
|
---|
| 635 | LABEL
|
---|
| 636 | MAXSCALEDENOM 4000
|
---|
| 637 | TYPE TRUETYPE FONT arial COLOR 140 0 120 OUTLINECOLOR 230 230 230
|
---|
| 638 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 639 | END
|
---|
| 640 | END
|
---|
| 641 | END
|
---|
| 642 |
|
---|
[428] | 643 | # 6: L e i t u n g
|
---|
| 644 | # LAYER
|
---|
[423] | 645 | # NAME leitung_f
|
---|
| 646 | # GROUP leitung
|
---|
| 647 | # TYPE POLYGON
|
---|
[428] | 648 | #....
|
---|
[423] | 649 | # END
|
---|
| 650 | LAYER
|
---|
| 651 | NAME leitung_l
|
---|
| 652 | GROUP leitung
|
---|
| 653 | TYPE LINE
|
---|
[428] | 654 | EXTENT ...
|
---|
| 655 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 656 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 657 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 658 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 659 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_leitung b LEFT JOIN ax_bauwerksfunktion_leitung u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='LINESTRING') AS ll using SRID=25832 using unique gml_id"
|
---|
[423] | 660 | METADATA
|
---|
| 661 | wms_group_title "Leitung"
|
---|
| 662 | wms_group_abstract "Leitung (Bauwerke)"
|
---|
| 663 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 664 | wms_title "Leitung Linien"
|
---|
| 665 | wms_abstract "Leitung (Linien)"
|
---|
| 666 | wms_keywordlist "Freileitung"
|
---|
| 667 | END
|
---|
| 668 | MINSCALEDENOM 50
|
---|
| 669 | MAXSCALEDENOM 15000
|
---|
| 670 | SYMBOLSCALEDENOM 800
|
---|
[428] | 671 | LABELITEM "label"
|
---|
| 672 | JOIN
|
---|
| 673 | NAME "BW"
|
---|
| 674 | CONNECTIONTYPE postgresql
|
---|
| 675 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 676 | TABLE "(SELECT 6 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_leitung b LEFT JOIN ax_bauwerksfunktion_leitung u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 677 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 678 | END
|
---|
[423] | 679 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 680 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 681 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 682 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 683 | CLASS
|
---|
| 684 | NAME "Li. Leitung"
|
---|
| 685 | STYLE
|
---|
| 686 | COLOR 220 10 10
|
---|
| 687 | WIDTH 4 MINWIDTH 2 MAXWIDTH 7 #LI
|
---|
| 688 | END
|
---|
| 689 | LABEL
|
---|
| 690 | MAXSCALEDENOM 4000
|
---|
| 691 | TYPE TRUETYPE FONT arial COLOR 220 10 10 OUTLINECOLOR 230 230 230
|
---|
| 692 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 693 | END
|
---|
| 694 | END
|
---|
| 695 | END
|
---|
| 696 |
|
---|
[428] | 697 | # 7: T r a n s p o r t a n l a g e
|
---|
[423] | 698 | # LAYER
|
---|
[428] | 699 | # NAME transport_f
|
---|
[423] | 700 | # GROUP transport
|
---|
| 701 | # TYPE POLYGON
|
---|
[428] | 702 | #...
|
---|
[423] | 703 | # END
|
---|
| 704 | LAYER
|
---|
| 705 | NAME transport_l
|
---|
| 706 | GROUP transport
|
---|
| 707 | TYPE LINE
|
---|
[428] | 708 | EXTENT ...
|
---|
| 709 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 710 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 711 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 712 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 713 | DATA "wkb_geometry from (SELECT b.gml_id, u.beschreibung, b.wkb_geometry FROM ax_transportanlage b LEFT JOIN ax_bauwerksfunktion_transportanlage u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='LINESTRING') AS tl using SRID=25832 using unique gml_id"
|
---|
[423] | 714 | METADATA
|
---|
| 715 | wms_group_title "Transportanlage"
|
---|
| 716 | wms_group_abstract "Transportanlage (Bauwerke)"
|
---|
| 717 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 718 | wms_title "Transportanlage Linien"
|
---|
| 719 | wms_abstract "Transportanlage (Linien)"
|
---|
| 720 | wms_keywordlist "Förderband,BandstraÃe,Rohrleitung,Pipeline"
|
---|
| 721 | END
|
---|
| 722 | MINSCALEDENOM 50
|
---|
| 723 | MAXSCALEDENOM 15000
|
---|
| 724 | SYMBOLSCALEDENOM 800
|
---|
| 725 | LABELITEM "beschreibung"
|
---|
[428] | 726 | JOIN
|
---|
| 727 | NAME "BW"
|
---|
| 728 | CONNECTIONTYPE postgresql
|
---|
| 729 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 730 | TABLE "(SELECT 7 AS bwtyp, b.gml_id, NULL AS name, u.beschreibung FROM ax_transportanlage b LEFT JOIN ax_bauwerksfunktion_transportanlage u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 731 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 732 | END
|
---|
[423] | 733 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 734 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 735 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 736 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 737 | CLASS
|
---|
| 738 | NAME "Li. Transportanlage"
|
---|
| 739 | STYLE
|
---|
| 740 | COLOR 10 180 10
|
---|
| 741 | WIDTH 4 MINWIDTH 2 MAXWIDTH 7 #LI
|
---|
| 742 | END
|
---|
| 743 | LABEL
|
---|
| 744 | MAXSCALEDENOM 3000
|
---|
| 745 | TYPE TRUETYPE FONT arial COLOR 10 180 10 OUTLINECOLOR 230 230 230
|
---|
| 746 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 747 | END
|
---|
| 748 | END
|
---|
| 749 | END
|
---|
| 750 |
|
---|
[428] | 751 | # 8: T u r m
|
---|
[423] | 752 | LAYER
|
---|
| 753 | NAME turm_f
|
---|
| 754 | GROUP turm
|
---|
| 755 | TYPE POLYGON
|
---|
[428] | 756 | EXTENT ...
|
---|
| 757 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 758 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 759 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 760 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 761 | # ax_turm.bauwerksfunktion integer[] ist Array!
|
---|
[428] | 762 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_turm b LEFT JOIN ax_bauwerksfunktion_turm u ON u.wert=ANY(b.bauwerksfunktion) WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS tf using SRID=25832 using unique gml_id"
|
---|
[423] | 763 | METADATA
|
---|
| 764 | wms_group_title "Turm"
|
---|
| 765 | wms_group_abstract "Turm (Bauwerke)"
|
---|
| 766 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 767 | wms_title "Turm FlÀchen"
|
---|
| 768 | wms_abstract "Turm (FlÀchen)"
|
---|
| 769 | wms_keywordlist "Aussichtsturm,Kirchturm,Glockenturm"
|
---|
| 770 | END
|
---|
| 771 | MINSCALEDENOM 50
|
---|
| 772 | MAXSCALEDENOM 15000
|
---|
| 773 | SYMBOLSCALEDENOM 800
|
---|
[428] | 774 | LABELITEM "label"
|
---|
| 775 | JOIN
|
---|
| 776 | NAME "BW"
|
---|
| 777 | CONNECTIONTYPE postgresql
|
---|
| 778 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 779 | TABLE "(SELECT 8 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_turm b LEFT JOIN ax_bauwerksfunktion_turm u ON u.wert=ANY(b.bauwerksfunktion)) as query"
|
---|
| 780 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 781 | END
|
---|
| 782 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 783 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 784 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 785 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 786 | CLASS
|
---|
| 787 | NAME "Fl. Turm"
|
---|
| 788 | STYLE
|
---|
| 789 | COLOR 135 76 1 OPACITY 14
|
---|
| 790 | END
|
---|
| 791 | STYLE
|
---|
| 792 | OUTLINECOLOR 135 76 1
|
---|
| 793 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 794 | END
|
---|
| 795 | LABEL
|
---|
| 796 | MAXSCALEDENOM 2000
|
---|
| 797 | TYPE TRUETYPE FONT arial COLOR 135 76 1 OUTLINECOLOR 230 230 230
|
---|
| 798 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 799 | END
|
---|
| 800 | END
|
---|
| 801 | END
|
---|
[428] | 802 | # LAYER
|
---|
[423] | 803 | # NAME turm_l
|
---|
| 804 | # GROUP turm
|
---|
| 805 | # TYPE LINE
|
---|
[428] | 806 | #....
|
---|
[423] | 807 | # END
|
---|
| 808 |
|
---|
[428] | 809 | # 9: VorratsbehÀlter, Speicherbauwerk
|
---|
[423] | 810 | LAYER
|
---|
| 811 | NAME vorrat_f
|
---|
| 812 | GROUP vorrat
|
---|
| 813 | TYPE POLYGON
|
---|
[428] | 814 | EXTENT ...
|
---|
| 815 | PROJECTION "init=epsg:25832" END
|
---|
[423] | 816 | CONNECTIONTYPE POSTGIS
|
---|
[428] | 817 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
[423] | 818 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
[428] | 819 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk b LEFT JOIN ax_bauwerksfunktion_vorratsbehaelterspeicherbauwerk u ON b.bauwerksfunktion=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS vf using SRID=25832 using unique gml_id"
|
---|
[423] | 820 | METADATA
|
---|
| 821 | wms_group_title "Vorrat/Speicher"
|
---|
| 822 | wms_group_abstract "VorratsbehÀlter, Speicherbauwerk"
|
---|
| 823 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 824 | wms_title "Vorrat/Speicher FlÀchen"
|
---|
| 825 | wms_abstract "VorratsbehÀlter, Speicherbauwerk (FlÀchen)"
|
---|
| 826 | wms_keywordlist "Silo,Tank"
|
---|
| 827 | END
|
---|
| 828 | MINSCALEDENOM 50
|
---|
| 829 | MAXSCALEDENOM 15000
|
---|
| 830 | SYMBOLSCALEDENOM 800
|
---|
[428] | 831 | LABELITEM "label"
|
---|
| 832 | JOIN
|
---|
| 833 | NAME "BW"
|
---|
| 834 | CONNECTIONTYPE postgresql
|
---|
| 835 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 836 | TABLE "(SELECT 9 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_vorratsbehaelterspeicherbauwerk b LEFT JOIN ax_bauwerksfunktion_vorratsbehaelterspeicherbauwerk u ON b.bauwerksfunktion=u.wert) as query"
|
---|
| 837 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 838 | END
|
---|
| 839 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
[423] | 840 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
[428] | 841 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
[423] | 842 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 843 | CLASS
|
---|
| 844 | # EXPRESSION "__"
|
---|
| 845 | NAME "Fl. Vorrat/Speicher"
|
---|
| 846 | STYLE
|
---|
| 847 | COLOR 0 140 40 OPACITY 14
|
---|
| 848 | END
|
---|
| 849 | STYLE
|
---|
| 850 | OUTLINECOLOR 0 140 40
|
---|
| 851 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 852 | END
|
---|
| 853 | LABEL
|
---|
| 854 | MAXSCALEDENOM 2000
|
---|
| 855 | TYPE TRUETYPE FONT arial COLOR 0 140 40 OUTLINECOLOR 230 230 230
|
---|
| 856 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 857 | END
|
---|
| 858 | END
|
---|
| 859 | END
|
---|
[428] | 860 | # LAYER
|
---|
[423] | 861 | # NAME vorrat_l
|
---|
| 862 | # GROUP vorrat
|
---|
| 863 | # TYPE LINE
|
---|
[428] | 864 | #...
|
---|
[423] | 865 | # END
|
---|
| 866 |
|
---|
[428] | 867 | # 10: H i s t o r i s c h e s Bauwerk oder historische Einrichtung
|
---|
| 868 | LAYER
|
---|
| 869 | NAME hist_f
|
---|
| 870 | GROUP hist
|
---|
| 871 | TYPE POLYGON
|
---|
| 872 | EXTENT ...
|
---|
| 873 | PROJECTION "init=epsg:25832" END
|
---|
| 874 | CONNECTIONTYPE POSTGIS
|
---|
| 875 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
| 876 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 877 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_historischesbauwerkoderhistorischeeinrichtung b LEFT JOIN ax_archaeologischertyp_historischesbauwerkoderhistorischee u ON b.archaeologischertyp=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS hf using SRID=25832 using unique gml_id"
|
---|
| 878 | METADATA
|
---|
| 879 | wms_group_title "Historisch"
|
---|
| 880 | wms_group_abstract "Historisches Bauwerk oder historische Einrichtung"
|
---|
| 881 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 882 | wms_title "Historisch FlÀchen"
|
---|
| 883 | wms_abstract "Historisches Bauwerk oder historische Einrichtung (FlÀchen)"
|
---|
| 884 | wms_keywordlist "Historisch"
|
---|
| 885 | END
|
---|
| 886 | MINSCALEDENOM 50
|
---|
| 887 | MAXSCALEDENOM 15000
|
---|
| 888 | SYMBOLSCALEDENOM 800
|
---|
| 889 | LABELITEM "label"
|
---|
| 890 | JOIN
|
---|
| 891 | NAME "BW"
|
---|
| 892 | CONNECTIONTYPE ogr
|
---|
| 893 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 894 | TABLE "(SELECT 10 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_historischesbauwerkoderhistorischeeinrichtung b LEFT JOIN ax_archaeologischertyp_historischesbauwerkoderhistorischee u ON b.archaeologischertyp=u.wert) as query"
|
---|
| 895 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 896 | END
|
---|
| 897 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
| 898 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
| 899 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
| 900 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 901 | CLASS
|
---|
| 902 | NAME "Fl. Historisch"
|
---|
| 903 | STYLE
|
---|
| 904 | COLOR 80 70 40 OPACITY 14
|
---|
| 905 | END
|
---|
| 906 | STYLE
|
---|
| 907 | OUTLINECOLOR 80 70 40
|
---|
| 908 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 909 | END
|
---|
| 910 | LABEL
|
---|
| 911 | MAXSCALEDENOM 2000
|
---|
| 912 | TYPE TRUETYPE FONT arial COLOR 80 70 40 OUTLINECOLOR 230 230 230
|
---|
| 913 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 914 | END
|
---|
| 915 | END
|
---|
| 916 | END
|
---|
| 917 | LAYER
|
---|
| 918 | NAME hist_p
|
---|
| 919 | GROUP hist
|
---|
| 920 | TYPE POINT
|
---|
| 921 | EXTENT ...
|
---|
| 922 | PROJECTION "init=epsg:25832" END
|
---|
| 923 | CONNECTIONTYPE POSTGIS
|
---|
| 924 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
| 925 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 926 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_historischesbauwerkoderhistorischeeinrichtung b LEFT JOIN ax_archaeologischertyp_historischesbauwerkoderhistorischee u ON b.archaeologischertyp=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS hp using SRID=25832 using unique gml_id"
|
---|
| 927 | METADATA
|
---|
| 928 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 929 | wms_title "Historisch Punkt"
|
---|
| 930 | wms_abstract "Historisches Bauwerk oder historische Einrichtung (Punkt)"
|
---|
| 931 | wms_keywordlist "Historisch"
|
---|
| 932 | END
|
---|
| 933 | MINSCALEDENOM 50
|
---|
| 934 | MAXSCALEDENOM 15000
|
---|
| 935 | SYMBOLSCALEDENOM 800
|
---|
| 936 | LABELITEM "label"
|
---|
| 937 | JOIN
|
---|
| 938 | NAME "BW"
|
---|
| 939 | CONNECTIONTYPE postgresql
|
---|
| 940 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 941 | TABLE "(SELECT 10 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_historischesbauwerkoderhistorischeeinrichtung b LEFT JOIN ax_archaeologischertyp_historischesbauwerkoderhistorischee u ON b.archaeologischertyp=u.wert) as query"
|
---|
| 942 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 943 | END
|
---|
| 944 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 945 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
| 946 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
| 947 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 948 | CLASS
|
---|
| 949 | NAME "Pu. Historisch"
|
---|
| 950 | STYLE
|
---|
| 951 | SYMBOL "pkt"
|
---|
| 952 | COLOR 80 70 40
|
---|
| 953 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 954 | END
|
---|
| 955 | LABEL
|
---|
| 956 | MAXSCALEDENOM 4000
|
---|
| 957 | TYPE TRUETYPE FONT arial COLOR 80 70 40 OUTLINECOLOR 230 230 230
|
---|
| 958 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 959 | END
|
---|
| 960 | END
|
---|
| 961 | END
|
---|
| 962 |
|
---|
| 963 | # 11: H e i l q u e l l e , G a s q u e l l e
|
---|
| 964 | LAYER
|
---|
| 965 | NAME heil_p
|
---|
| 966 | GROUP heil
|
---|
| 967 | TYPE POINT
|
---|
| 968 | EXTENT ...
|
---|
| 969 | PROJECTION "init=epsg:25832" END
|
---|
| 970 | CONNECTIONTYPE POSTGIS
|
---|
| 971 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
| 972 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 973 | DATA "wkb_geometry from (SELECT b.gml_id, coalesce(b.name, u.beschreibung) AS label, b.wkb_geometry FROM ax_heilquellegasquelle b LEFT JOIN ax_art_heilquellegasquelle u ON b.art=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS hp using SRID=25832 using unique gml_id"
|
---|
| 974 | METADATA
|
---|
| 975 | wms_group_title "Heil-, Gasquelle"
|
---|
| 976 | wms_group_abstract "Heilquelle, Gasquelle"
|
---|
| 977 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 978 | wms_title "Heil-, Gasquelle Punkt"
|
---|
| 979 | wms_abstract "Heilquelle, Gasquelle (Punkt)"
|
---|
| 980 | wms_keywordlist "Quelle,Heilquelle,Gasquelle"
|
---|
| 981 | END
|
---|
| 982 | MINSCALEDENOM 50
|
---|
| 983 | MAXSCALEDENOM 15000
|
---|
| 984 | SYMBOLSCALEDENOM 800
|
---|
| 985 | LABELITEM "label"
|
---|
| 986 | JOIN
|
---|
| 987 | NAME "BW"
|
---|
| 988 | CONNECTIONTYPE ogr
|
---|
| 989 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 990 | TABLE "(SELECT 11 AS bwtyp, b.gml_id, b.name, u.beschreibung FROM ax_heilquellegasquelle b LEFT JOIN ax_art_heilquellegasquelle u ON b.art=u.wert) as query"
|
---|
| 991 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 992 | END
|
---|
| 993 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 994 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
| 995 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
| 996 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 997 | CLASS
|
---|
| 998 | NAME "Pu. H/G Quelle"
|
---|
| 999 | STYLE
|
---|
| 1000 | SYMBOL "pkt"
|
---|
| 1001 | COLOR 190 170 10
|
---|
| 1002 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 1003 | END
|
---|
| 1004 | LABEL
|
---|
| 1005 | MAXSCALEDENOM 4000
|
---|
| 1006 | TYPE TRUETYPE FONT arial COLOR 190 170 10 OUTLINECOLOR 230 230 230
|
---|
| 1007 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 1008 | END
|
---|
| 1009 | END
|
---|
| 1010 | END
|
---|
| 1011 |
|
---|
| 1012 | # 12: Einrichtung in öffentlichen Bereichen
|
---|
| 1013 | LAYER
|
---|
| 1014 | NAME oeff_f
|
---|
| 1015 | GROUP oeff
|
---|
| 1016 | TYPE POLYGON
|
---|
| 1017 | EXTENT ...
|
---|
| 1018 | PROJECTION "init=epsg:25832" END
|
---|
| 1019 | CONNECTIONTYPE POSTGIS
|
---|
| 1020 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
| 1021 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 1022 | DATA "wkb_geometry from (SELECT b.gml_id, u.beschreibung, b.wkb_geometry FROM ax_einrichtunginoeffentlichenbereichen b LEFT JOIN ax_art_einrichtunginoeffentlichenbereichen u ON b.art=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POLYGON') AS of using SRID=25832 using unique gml_id"
|
---|
| 1023 | METADATA
|
---|
| 1024 | wms_group_title "öffendl. Einrichtung"
|
---|
| 1025 | wms_group_abstract "Einrichtung in öffentlichen Bereichen"
|
---|
| 1026 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 1027 | wms_title "öffendl. Einrichtung FlÀche"
|
---|
| 1028 | wms_abstract "Einrichtung in öffentlichen Bereichen (FlÀchen)"
|
---|
| 1029 | wms_keywordlist "öffendlich,Einrichtung"
|
---|
| 1030 | END
|
---|
| 1031 | MINSCALEDENOM 50
|
---|
| 1032 | MAXSCALEDENOM 15000
|
---|
| 1033 | SYMBOLSCALEDENOM 800
|
---|
| 1034 | LABELITEM "beschreibung"
|
---|
| 1035 | JOIN
|
---|
| 1036 | NAME "BW"
|
---|
| 1037 | CONNECTIONTYPE ogr
|
---|
| 1038 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 1039 | TABLE "(SELECT 12 AS bwtyp, b.gml_id, NULL AS name, u.beschreibung FROM ax_einrichtunginoeffentlichenbereichen b LEFT JOIN ax_art_einrichtunginoeffentlichenbereichen u ON b.art=u.wert) as query"
|
---|
| 1040 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 1041 | END
|
---|
| 1042 | TOLERANCEUNITS pixels TOLERANCE 4
|
---|
| 1043 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
| 1044 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
| 1045 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 1046 | CLASS
|
---|
| 1047 | NAME "Fl. öffentlich"
|
---|
| 1048 | STYLE
|
---|
| 1049 | COLOR 200 10 60 OPACITY 14
|
---|
| 1050 | END
|
---|
| 1051 | STYLE
|
---|
| 1052 | OUTLINECOLOR 200 10 60
|
---|
| 1053 | WIDTH 3 MINWIDTH 2 MAXWIDTH 5 #FL
|
---|
| 1054 | END
|
---|
| 1055 | LABEL
|
---|
| 1056 | MAXSCALEDENOM 2000
|
---|
| 1057 | TYPE TRUETYPE FONT arial COLOR 200 10 60 OUTLINECOLOR 230 230 230
|
---|
| 1058 | POSITION cc SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 1059 | END
|
---|
| 1060 | END
|
---|
| 1061 | END
|
---|
| 1062 | LAYER
|
---|
| 1063 | NAME oeff_p
|
---|
| 1064 | GROUP oeff
|
---|
| 1065 | TYPE POINT
|
---|
| 1066 | EXTENT ...
|
---|
| 1067 | PROJECTION "init=epsg:25832" END
|
---|
| 1068 | CONNECTIONTYPE POSTGIS
|
---|
| 1069 | CONNECTION "host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432"
|
---|
| 1070 | PROCESSING "CLOSE_CONNECTION=DEFER"
|
---|
| 1071 | DATA "wkb_geometry from (SELECT b.gml_id, u.beschreibung, b.wkb_geometry FROM ax_einrichtunginoeffentlichenbereichen b LEFT JOIN ax_art_einrichtunginoeffentlichenbereichen u ON b.art=u.wert WHERE b.endet IS NULL AND GeometryType(b.wkb_geometry)='POINT') AS op using SRID=25832 using unique gml_id"
|
---|
| 1072 | METADATA
|
---|
| 1073 | wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:3034 EPSG:3857"
|
---|
| 1074 | wms_title "öffendl. Einrichtung Punkt"
|
---|
| 1075 | wms_abstract "Einrichtung in öffentlichen Bereichen (Punkt)"
|
---|
| 1076 | wms_keywordlist "öffendlich,Einrichtung"
|
---|
| 1077 | END
|
---|
| 1078 | MINSCALEDENOM 50
|
---|
| 1079 | MAXSCALEDENOM 15000
|
---|
| 1080 | SYMBOLSCALEDENOM 800
|
---|
| 1081 | LABELITEM "beschreibung"
|
---|
| 1082 | JOIN
|
---|
| 1083 | NAME "BW"
|
---|
| 1084 | CONNECTIONTYPE postgresql
|
---|
| 1085 | CONNECTION 'host=[IP-DB-Server] dbname=alkis0*gkz* user=ms7 port=5432'
|
---|
| 1086 | TABLE "(SELECT 12 AS bwtyp, b.gml_id, NULL AS name, u.beschreibung FROM ax_einrichtunginoeffentlichenbereichen b LEFT JOIN ax_art_einrichtunginoeffentlichenbereichen u ON b.art=u.wert) as query"
|
---|
| 1087 | FROM "gml_id" TO "gml_id" TYPE ONE-TO-ONE
|
---|
| 1088 | END
|
---|
| 1089 | TOLERANCEUNITS pixels TOLERANCE 10
|
---|
| 1090 | HEADER "/opt/gdi/alkisn/templates/alkisbauwerkh.html"
|
---|
| 1091 | TEMPLATE "/opt/gdi/alkisn/templates/alkisbauwerkj.html"
|
---|
| 1092 | FOOTER "/opt/gdi/alkisn/templates/footer.html"
|
---|
| 1093 | CLASS
|
---|
| 1094 | NAME "Pu. öffentlich"
|
---|
| 1095 | STYLE
|
---|
| 1096 | SYMBOL "pkt"
|
---|
| 1097 | COLOR 200 10 60
|
---|
| 1098 | SIZE 9 MINSIZE 6 MAXSIZE 15 #PU
|
---|
| 1099 | END
|
---|
| 1100 | LABEL
|
---|
| 1101 | MAXSCALEDENOM 4000
|
---|
| 1102 | TYPE TRUETYPE FONT arial COLOR 200 10 60 OUTLINECOLOR 230 230 230
|
---|
| 1103 | POSITION auto SIZE 10 MINSIZE 8 MAXSIZE 13
|
---|
| 1104 | END
|
---|
| 1105 | END
|
---|
| 1106 | END
|
---|
| 1107 |
|
---|
| 1108 | # 13: Besonderer Bauwerkspunkt
|
---|
| 1109 | # Tab: ax_besondererbauwerkspunkt, rgb 250 40 10
|
---|
[423] | 1110 | END |
---|