Changeset 368 for trunk/umn/alkis_n
- Timestamp:
- 05/19/16 15:43:31 (8 years ago)
- Location:
- trunk/umn/alkis_n
- Files:
-
- 8 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/umn/alkis_n/alkis_n_muster.map
r367 r368 1 1 MAP 2 2 # ALKIS generiert aus norBIT-QGIS-Plugin, dann manuell nach-bearbeitet fÃŒr mapserver 7.0 3 # http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis 150.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.13 # http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis*gkz*.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1 4 4 5 5 # Stand: 6 # 2016-05-03 - Test-Server -6 # 2016-05-03 7 7 # 2016-05-09 Kommentare 8 # 2016-05-11 Copyright-Layer, "PATTERN 0 .." und "OPACITY 0" auskommentiert, FS-Nr besser freigestellt 9 # Template auf Baurecht. 10 # Die Templates fuer Feature-Info entnehmen den Parameter "gkz" dem Mapfile-Namen vor ".map" 11 # 2016-05-12 Bei Klassen mit Symbolnummer als Name den Name auskommentiert um die Legende zu entschÀrfen. 12 # 2016-05-19 Maxscaledenom ÃŒberarbeiten, Abgkeich mit SW-Variante 8 13 9 14 # ToDo: 10 15 # - Unförmige Legende z.B. im Layer "GebÀude/Grenzen" durch SVG-Symbole und/oder "SIZEUNIT METERS"? 11 # - Copyright-Layer wegen Vorgaben des Katasteramtes12 16 # - Layer oder Gruppe fÃŒr SchÀtzungsklassen 13 17 # - In "GebÀude / Beschriftungen" werden ausser der Haunummer auch nich Buchstaben sichtbar, z.T. ÃŒberlappend … … 64 68 # l Lagebezeichnungen 65 69 66 ### Generierte Layer (Reihenfolge)70 ### Generierte Layer-Reihenfolge (340) (150) (230) 67 71 ## */ FlÀchen + Grenzen 68 72 # fh Friedhöfe / FlÀchen … … 77 81 # gs Sport und Freizeit / Grenzen 78 82 # gw GewÀsser / Grenzen 79 # fi Industrie und Gewerbe / FlÀchen **80 # gi Industrie und Gewerbe / Grenzen **81 # fv Verkehr / FlÀchen ** ( teils auch Verkehr vor Industrie)82 # gv Verkehr / Grenzen **83 # fi Industrie und Gewerbe / FlÀchen 84 # gi Industrie und Gewerbe / Grenzen 85 # fv Verkehr / FlÀchen 86 # gv Verkehr / Grenzen 83 87 # fg GebÀude / FlÀchen 84 88 # gg GebÀude / Grenzen … … 88 92 # lt Topographie / Linien 89 93 # lw GewÀsser / Linien 90 # lv Verkehr / Linien **91 # li Industrie und Gewerbe / Linien ** (teils hinter gebÀude/linien)94 # lv Verkehr / Linien 95 # li Industrie und Gewerbe / Linien 92 96 # lg GebÀude / Linien 93 97 # lp Politische Grenzen / Linien … … 106 110 # bfn FlurstÃŒcke / Nummern / Beschriftungen 107 111 # bg GebÀude / Beschriftungen 108 # bg2 GebÀude / Laufende Hausnummern / Beschriftungen ** NebengebÀude-Nummer in Klammer112 # bg2 GebÀude / lfd. Nr. NebengebÀude 109 113 # bl Lagebezeichnungen / Beschriftungen 110 114 # br Rechtliche Festlegungen / Beschriftungen … … 130 134 WEB 131 135 METADATA 132 wms_title "ALKIS n"133 wms_abstract "ALKIS *gkz* - Konverter PostNAS, NorGIS-Plugin, Version vomMai 2016"136 wms_title "ALKIS" 137 wms_abstract "ALKIS *gkz* farbige Variante - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 19. Mai 2016" 134 138 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 135 139 wms_bbox_extended "true" 136 140 wms_encoding "UTF-8" 137 141 wms_onlineresource "http://10.0.100.79/cgi-bin/mapserv7?map=/opt/gdi/alkisn/alkis*gkz*.map" 142 # Die Position von "GKZ" im Mapfile-Namen muss 3stellig sein, am Ende vor ".map". 143 # GKZ wird vom Template ÃŒber den [map] ausgelesen um die richtige DB der Auskunft zu finden. 138 144 wms_feature_info_mime_type "text/html" 139 145 wms_schema_location ".." … … 142 148 wms_accessconstraints "fÃŒr den Dienstgebrauch" 143 149 wms_enable_request "*" 144 # include "meta_contact.map" # individuelle Datei je Katasteramt 145 END 146 END 150 include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt 151 END 152 END 153 154 ## Die Legende ist nicht brauchbar. 155 ## 1. Die Legende von ALKIS ist sowieso sehr umfangreich. Das fÃŒllt mehrere Seiten. 156 ## 2. Es werden zum Teil mehrere ALKIS-Objekt-Arten in einer Klasse dieses Mapfiles generiert, 157 ## indem Darstellungsunterschiede aus Datenbank-Felder geholt werden. 158 ## Das könnte die Legende nicht abbilden. 159 ## 3. Einige Klassen haben keine Namen sondern Symbolnummern oder Àhnliches. 160 ## 4. Die Sybole werden so gigantisch gezeichnet, dass sie die Einbindung des WMS im QGIS verhindern. 147 161 LEGEND 148 STATUS O N162 STATUS OFF # ON 149 163 KEYSIZE 32 16 150 164 KEYSPACING 5 5 151 TRANSPARENT ON152 165 LABEL 153 166 TYPE TRUETYPE … … 160 173 ## Layer der Typen FlÀchen + Grenzen 161 174 162 # LAYER fh FriedHöfe / FlÀchen 163 LAYER 175 LAYER NAME "fh" # FriedHöfe / FlÀchen 164 176 CLASSITEM "signaturnummer" 165 177 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 171 183 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 172 184 wms_layer_group "/Friedhöfe" 173 wms_title "FlÀchen" 174 END 175 NAME "fh" 185 wms_title "FlÀchen" 186 END 176 187 PROCESSING "CLOSE_CONNECTION=DEFER" 177 188 PROJECTION "init=epsg:25832" END … … 182 193 UNITS METERS 183 194 CLASS 184 NAME "[1405]"195 # NAME "[1405]" 185 196 EXPRESSION "1405" 186 197 STYLE … … 190 201 END 191 202 192 # LAYER fe VEgetation / FlÀchen 193 LAYER 203 LAYER NAME "fe" # VEgetation / FlÀchen 194 204 CLASSITEM "signaturnummer" 195 205 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 201 211 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 202 212 wms_layer_group "/Vegetation" 203 wms_title "FlÀchen" 204 END 205 NAME "fe" 213 wms_title "FlÀchen" 214 END 206 215 PROCESSING "CLOSE_CONNECTION=DEFER" 207 216 PROJECTION "init=epsg:25832" END … … 226 235 END 227 236 CLASS 228 NAME "(1409)"237 # NAME "(1409)" 229 238 EXPRESSION "1409" 230 239 STYLE … … 240 249 END 241 250 CLASS 242 NAME "(1561)"251 # NAME "(1561)" 243 252 EXPRESSION "1561" 244 253 STYLE … … 248 257 END 249 258 250 # LAYER fb WohnBauflÀchen / FlÀchen 251 LAYER 259 LAYER NAME "fb" # WohnBauflÀchen / FlÀchen 252 260 CLASSITEM "signaturnummer" 253 261 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 259 267 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 260 268 wms_layer_group "/WohnbauflÀchen" 261 wms_title "FlÀchen" 262 END 263 NAME "fb" 269 wms_title "FlÀchen" 270 END 264 271 PROCESSING "CLOSE_CONNECTION=DEFER" 265 272 PROJECTION "init=epsg:25832" END … … 278 285 END 279 286 280 # LAYER gt Topographie / Grenzen 281 LAYER 287 LAYER NAME "gt" # Topographie / Grenzen 282 288 CLASSITEM "signaturnummer" 283 289 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 289 295 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 290 296 wms_layer_group "/Topographie" 291 wms_title "Grenzen" 292 END 293 NAME "gt" 297 wms_title "Grenzen" 298 END 294 299 PROCESSING "CLOSE_CONNECTION=DEFER" 295 300 PROJECTION "init=epsg:25832" END … … 299 304 UNITS METERS 300 305 CLASS 301 NAME "(rn1551)"306 # NAME "(rn1551)" 302 307 EXPRESSION "rn1551" 303 308 STYLE … … 311 316 END 312 317 313 # LAYER ge VEgetation / Grenzen 314 LAYER 318 LAYER NAME "ge" # VEgetation / Grenzen 315 319 CLASSITEM "signaturnummer" 316 320 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 322 326 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 323 327 wms_layer_group "/Vegetation" 324 wms_title "Grenzen" 325 END 326 NAME "ge" 328 wms_title "Grenzen" 329 END 327 330 PROCESSING "CLOSE_CONNECTION=DEFER" 328 331 PROJECTION "init=epsg:25832" END … … 332 335 UNITS METERS 333 336 CLASS 334 NAME "(rn1560)"337 # NAME "(rn1560)" 335 338 EXPRESSION "rn1560" 336 339 STYLE … … 343 346 END 344 347 CLASS 345 NAME "(rn1561)"348 # NAME "(rn1561)" 346 349 EXPRESSION "rn1561" 347 350 STYLE … … 354 357 END 355 358 CLASS 356 NAME "(rn1563)"359 # NAME "(rn1563)" 357 360 EXPRESSION "rn1563" 358 361 STYLE … … 365 368 END 366 369 CLASS 367 NAME "[2515]"370 # NAME "[2515]" 368 371 EXPRESSION "2515" 369 372 STYLE … … 388 391 END 389 392 390 # LAYER gh FriedHöfe / Grenzen 391 LAYER 393 LAYER NAME "gh" # FriedHöfe / Grenzen 392 394 CLASSITEM "signaturnummer" 393 395 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 399 401 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 400 402 wms_layer_group "/Friedhöfe" 401 wms_title "Grenzen" 402 END 403 NAME "gh" 403 wms_title "Grenzen" 404 END 404 405 PROCESSING "CLOSE_CONNECTION=DEFER" 405 406 PROJECTION "init=epsg:25832" END … … 409 410 UNITS METERS 410 411 CLASS 411 NAME "[2515]"412 # NAME "[2515]" 412 413 EXPRESSION "2515" 413 414 STYLE … … 421 422 END 422 423 423 # LAYER gb WohnBauflÀchen / Grenzen 424 LAYER 424 LAYER NAME "gb" # WohnBauflÀchen / Grenzen 425 425 CLASSITEM "signaturnummer" 426 426 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 432 432 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 433 433 wms_layer_group "/WohnbauflÀchen" 434 wms_title "Grenzen" 435 END 436 NAME "gb" 434 wms_title "Grenzen" 435 END 437 436 PROCESSING "CLOSE_CONNECTION=DEFER" 438 437 PROJECTION "init=epsg:25832" END … … 442 441 UNITS METERS 443 442 CLASS 444 NAME "[2515]"443 # NAME "[2515]" 445 444 EXPRESSION "2515" 446 445 STYLE … … 454 453 END 455 454 456 # LAYER fw GewÀsser / FlÀchen 457 LAYER 455 LAYER NAME "fw" # GewÀsser / FlÀchen 458 456 CLASSITEM "signaturnummer" 459 457 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 465 463 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 466 464 wms_layer_group "/GewÀsser" 467 wms_title "FlÀchen" 468 END 469 NAME "fw" 465 wms_title "FlÀchen" 466 END 470 467 PROCESSING "CLOSE_CONNECTION=DEFER" 471 468 PROJECTION "init=epsg:25832" END … … 483 480 END 484 481 CLASS 485 NAME "(1523)"482 # NAME "(1523)" 486 483 EXPRESSION "1523" 487 484 STYLE … … 491 488 END 492 489 493 # LAYER fs Sport und Freizeit / FlÀchen 494 LAYER 490 LAYER NAME "fs" # Sport und Freizeit / FlÀchen 495 491 CLASSITEM "signaturnummer" 496 492 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 498 494 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" 499 495 #EXTENT ... 500 MAXSCALEDENOM 500000496 MAXSCALEDENOM 25000 # 500000 501 497 METADATA 502 498 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 503 499 wms_layer_group "/Sport und Freizeit" 504 wms_title "FlÀchen" 505 END 506 NAME "fs" 500 wms_title "FlÀchen" 501 END 507 502 PROCESSING "CLOSE_CONNECTION=DEFER" 508 503 PROJECTION "init=epsg:25832" END … … 513 508 UNITS METERS 514 509 CLASS 515 NAME "[1405]"510 # NAME "[1405]" 516 511 EXPRESSION "1405" 517 512 STYLE … … 549 544 END 550 545 551 # LAYER gs Sport und Freizeit / Grenzen 552 LAYER 546 LAYER NAME "gs" # Sport und Freizeit / Grenzen 553 547 CLASSITEM "signaturnummer" 554 548 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 560 554 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 561 555 wms_layer_group "/Sport und Freizeit" 562 wms_title "Grenzen" 563 END 564 NAME "gs" 556 wms_title "Grenzen" 557 END 565 558 PROCESSING "CLOSE_CONNECTION=DEFER" 566 559 PROJECTION "init=epsg:25832" END … … 570 563 UNITS METERS 571 564 CLASS 572 NAME "[2515]"565 # NAME "[2515]" 573 566 EXPRESSION "2515" 574 567 STYLE … … 587 580 LINEJOIN ROUND 588 581 OUTLINECOLOR 81 0 0 589 PATTERN 590 2.00 1.00 591 END 582 PATTERN 2.00 1.00 END 592 583 SIZE 0.18 593 584 WIDTH 0.18 … … 606 597 END 607 598 CLASS 608 NAME "[1524]"599 # NAME "[1524]" 609 600 EXPRESSION "rn1524" 610 601 STYLE … … 640 631 END 641 632 642 # LAYER gw GewÀsser / Grenzen 643 LAYER 633 LAYER NAME "gw" # GewÀsser / Grenzen 644 634 CLASSITEM "signaturnummer" 645 635 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 651 641 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 652 642 wms_layer_group "/GewÀsser" 653 wms_title "Grenzen" 654 END 655 NAME "gw" 643 wms_title "Grenzen" 644 END 656 645 PROCESSING "CLOSE_CONNECTION=DEFER" 657 646 PROJECTION "init=epsg:25832" END … … 661 650 UNITS METERS 662 651 CLASS 663 NAME "(rn1551)"652 # NAME "(rn1551)" 664 653 EXPRESSION "rn1551" 665 654 STYLE … … 672 661 END 673 662 CLASS 674 NAME "(2520)"663 # NAME "(2520)" 675 664 EXPRESSION "2520" 676 665 STYLE … … 678 667 LINEJOIN ROUND 679 668 OUTLINECOLOR 0 204 204 680 PATTERN 681 4.00 2.00 682 END 669 PATTERN 4.00 2.00 END 683 670 SIZE 0.18 684 671 WIDTH 0.18 … … 697 684 END 698 685 CLASS 699 NAME "(rn1523)"686 # NAME "(rn1523)" 700 687 EXPRESSION "rn1523" 701 688 STYLE … … 725 712 LINEJOIN ROUND 726 713 OUTLINECOLOR 0 204 204 727 PATTERN 728 0.35 0.35 729 END 730 SIZE 0.18 731 WIDTH 0.18 732 END 733 END 734 END 735 736 # LAYER fi Industrie und Gewerbe / FlÀchen 737 LAYER 714 PATTERN 0.35 0.35 END 715 SIZE 0.18 716 WIDTH 0.18 717 END 718 END 719 END 720 721 LAYER NAME "fi" # Industrie und Gewerbe / FlÀchen 738 722 CLASSITEM "signaturnummer" 739 723 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 741 725 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" 742 726 #EXTENT ... 743 MAXSCALEDENOM 500000727 MAXSCALEDENOM 100000 # 500000 744 728 METADATA 745 729 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 746 730 wms_layer_group "/Industrie und Gewerbe" 747 wms_title "FlÀchen" 748 END 749 NAME "fi" 731 wms_title "FlÀchen" 732 END 750 733 PROCESSING "CLOSE_CONNECTION=DEFER" 751 734 PROJECTION "init=epsg:25832" END … … 756 739 UNITS METERS 757 740 CLASS 758 NAME "[1401]"741 # NAME "[1401]" 759 742 EXPRESSION "1401" 760 743 STYLE … … 763 746 END 764 747 CLASS 765 NAME "[1403]"748 # NAME "[1403]" 766 749 EXPRESSION "1403" 767 750 STYLE … … 770 753 END 771 754 CLASS 772 NAME "[1510]"755 # NAME "[1510]" 773 756 EXPRESSION "1510" 774 757 STYLE … … 777 760 END 778 761 CLASS 779 NAME "[1305]"762 # NAME "[1305]" 780 763 EXPRESSION "1305" 781 764 STYLE … … 784 767 END 785 768 CLASS 786 NAME "[1501]"769 # NAME "[1501]" 787 770 EXPRESSION "1501" 788 771 STYLE … … 799 782 END 800 783 801 # LAYER gi Industrie und Gewerbe / Grenzen 802 LAYER 784 LAYER NAME "gi" # Industrie und Gewerbe / Grenzen 803 785 CLASSITEM "signaturnummer" 804 786 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 810 792 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 811 793 wms_layer_group "/Industrie und Gewerbe" 812 wms_title "Grenzen" 813 END 814 NAME "gi" 794 wms_title "Grenzen" 795 END 815 796 PROCESSING "CLOSE_CONNECTION=DEFER" 816 797 PROJECTION "init=epsg:25832" END … … 820 801 UNITS METERS 821 802 CLASS 822 NAME "[2515]"803 # NAME "[2515]" 823 804 EXPRESSION "2515" 824 805 STYLE … … 842 823 END 843 824 CLASS 844 NAME "(rn2504)"825 # NAME "(rn2504)" 845 826 EXPRESSION "rn2504" 846 827 STYLE 847 828 LINEJOIN ROUND 848 829 OUTLINECOLOR 0 0 0 849 PATTERN 850 0.35 0.35 851 END 852 SIZE 0.18 853 WIDTH 0.18 854 END 855 END 856 CLASS 857 NAME "(rn2521)" 830 PATTERN 0.35 0.35 END 831 SIZE 0.18 832 WIDTH 0.18 833 END 834 END 835 CLASS 836 # NAME "(rn2521)" 858 837 EXPRESSION "rn2521" 859 838 STYLE … … 871 850 LINEJOIN ROUND 872 851 OUTLINECOLOR 0 0 0 873 PATTERN 874 0.35 0.35 875 END 876 SIZE 0.18 877 WIDTH 0.18 878 END 879 END 880 CLASS 881 NAME "[rn1501]" 852 PATTERN 0.35 0.35 END 853 SIZE 0.18 854 WIDTH 0.18 855 END 856 END 857 CLASS 858 # NAME "[rn1501]" 882 859 EXPRESSION "rn1501" 883 860 STYLE … … 890 867 END 891 868 CLASS 892 NAME "[rn1305]"869 # NAME "[rn1305]" 893 870 EXPRESSION "rn1305" 894 871 STYLE … … 913 890 END 914 891 915 # LAYER fv Verkehr / FlÀchen 916 LAYER 892 LAYER NAME "fv" # Verkehr / FlÀchen 917 893 CLASSITEM "signaturnummer" 918 894 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 924 900 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 925 901 wms_layer_group "/Verkehr" 926 wms_title "FlÀchen" 927 END 928 NAME "fv" 902 wms_title "FlÀchen" 903 END 929 904 PROCESSING "CLOSE_CONNECTION=DEFER" 930 905 PROJECTION "init=epsg:25832" END … … 964 939 END 965 940 966 # LAYER gv Verkehr / Grenzen 967 LAYER 941 LAYER NAME "gv" # Verkehr / Grenzen 968 942 CLASSITEM "signaturnummer" 969 943 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 975 949 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 976 950 wms_layer_group "/Verkehr" 977 wms_title "Grenzen" 978 END 979 NAME "gv" 951 wms_title "Grenzen" 952 END 980 953 PROCESSING "CLOSE_CONNECTION=DEFER" 981 954 PROJECTION "init=epsg:25832" END … … 985 958 UNITS METERS 986 959 CLASS 987 NAME "(2516)"960 # NAME "(2516)" 988 961 EXPRESSION "2516" 989 962 STYLE … … 1019 992 END 1020 993 CLASS 1021 NAME "(rn1536)"994 # NAME "(rn1536)" 1022 995 EXPRESSION "rn1536" 1023 996 STYLE … … 1030 1003 END 1031 1004 CLASS 1032 NAME "(rn1330)"1005 # NAME "(rn1330)" 1033 1006 EXPRESSION "rn1330" 1034 1007 STYLE … … 1041 1014 END 1042 1015 CLASS 1043 NAME "(rn1320)"1016 # NAME "(rn1320)" 1044 1017 EXPRESSION "rn1320" 1045 1018 STYLE … … 1065 1038 END 1066 1039 CLASS 1067 NAME "(rn1531)"1040 # NAME "(rn1531)" 1068 1041 EXPRESSION "rn1531" 1069 1042 STYLE … … 1090 1063 END 1091 1064 1092 # LAYER fg GebÀude / FlÀchen 1093 LAYER 1065 LAYER NAME "fg" # GebÀude / FlÀchen 1094 1066 CLASSITEM "signaturnummer" 1095 1067 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1101 1073 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1102 1074 wms_layer_group "/GebÀude" 1103 wms_title "FlÀchen" 1104 END 1105 NAME "fg" 1075 wms_title "FlÀchen" 1076 END 1106 1077 PROCESSING "CLOSE_CONNECTION=DEFER" 1107 1078 PROJECTION "init=epsg:25832" END … … 1133 1104 END 1134 1105 CLASS 1135 NAME "(2510)"1106 # NAME "(2510)" 1136 1107 EXPRESSION "2510" 1137 1108 STYLE … … 1162 1133 END 1163 1134 1164 # LAYER gg GebÀude / Grenzen 1165 LAYER 1135 LAYER NAME "gg" # GebÀude / Grenzen 1166 1136 CLASSITEM "signaturnummer" 1167 1137 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1173 1143 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1174 1144 wms_layer_group "/GebÀude" 1175 wms_title "Grenzen" 1176 END 1177 NAME "gg" 1145 wms_title "Grenzen" 1146 END 1178 1147 PROCESSING "CLOSE_CONNECTION=DEFER" 1179 1148 PROJECTION "init=epsg:25832" END … … 1183 1152 UNITS METERS 1184 1153 CLASS 1185 NAME "(rn1330)"1154 # NAME "(rn1330)" 1186 1155 EXPRESSION "rn1330" 1187 1156 STYLE … … 1194 1163 END 1195 1164 CLASS 1196 NAME "(2512)"1165 # NAME "(2512)" 1197 1166 EXPRESSION "2512" 1198 1167 STYLE … … 1200 1169 LINEJOIN ROUND 1201 1170 OUTLINECOLOR 0 0 0 1202 PATTERN 1203 0.35 0.35 1204 END 1171 PATTERN 0.35 0.35 END 1205 1172 SIZE 0.18 1206 1173 WIDTH 0.18 … … 1214 1181 LINEJOIN ROUND 1215 1182 OUTLINECOLOR 0 0 0 1216 PATTERN 1217 0.35 0.35 1218 END 1219 SIZE 0.18 1220 WIDTH 0.18 1221 END 1222 END 1223 CLASS 1224 NAME "(rn2510)" 1183 PATTERN 0.35 0.35 END 1184 SIZE 0.18 1185 WIDTH 0.18 1186 END 1187 END 1188 CLASS 1189 # NAME "(rn2510)" 1225 1190 EXPRESSION "rn2510" 1226 1191 STYLE … … 1238 1203 LINEJOIN ROUND 1239 1204 OUTLINECOLOR 0 0 0 1240 PATTERN 1241 2.00 1.00 1242 END 1205 PATTERN 2.00 1.00 END 1243 1206 SIZE 0.18 1244 1207 WIDTH 0.18 … … 1257 1220 END 1258 1221 CLASS 1259 NAME "(rn1305)"1222 # NAME "(rn1305)" 1260 1223 EXPRESSION "rn1305" 1261 1224 STYLE … … 1268 1231 END 1269 1232 CLASS 1270 NAME "(rn1317)"1233 # NAME "(rn1317)" 1271 1234 EXPRESSION "rn1317" 1272 1235 STYLE … … 1274 1237 LINEJOIN ROUND 1275 1238 OUTLINECOLOR 153 153 153 1276 PATTERN 1277 2.00 1.00 1278 END 1239 PATTERN 2.00 1.00 END 1279 1240 SIZE 0.18 1280 1241 WIDTH 0.18 … … 1293 1254 END 1294 1255 CLASS 1295 NAME "(2507)"1256 # NAME "(2507)" 1296 1257 EXPRESSION "2507" 1297 1258 STYLE … … 1338 1299 END 1339 1300 CLASS 1340 NAME "(rn1525)"1301 # NAME "(rn1525)" 1341 1302 EXPRESSION "rn1525" 1342 1303 STYLE … … 1350 1311 END 1351 1312 1352 # LAYER gr Rechtliche Festlegungen / Grenzen 1353 LAYER 1313 LAYER NAME "gr" # Rechtliche Festlegungen / Grenzen 1354 1314 CLASSITEM "signaturnummer" 1355 1315 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1361 1321 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1362 1322 wms_layer_group "/Rechtliche Festlegungen" 1363 wms_title "Grenzen" 1364 END 1365 NAME "gr" 1323 wms_title "Grenzen" 1324 END 1366 1325 PROCESSING "CLOSE_CONNECTION=DEFER" 1367 1326 PROJECTION "init=epsg:25832" END … … 1370 1329 TYPE POLYGON 1371 1330 UNITS METERS 1331 1332 TOLERANCEUNITS pixels TOLERANCE 1 1333 HEADER "/opt/gdi/alkisn/templates/alkisrechtbauh.html" 1334 TEMPLATE "/opt/gdi/alkisn/templates/alkisrechtbau.html" 1335 FOOTER "/opt/gdi/alkisn/templates/footer.html" 1336 1372 1337 CLASS 1373 1338 NAME "Bau-, Raum-, Bodenordnungsrecht" … … 1377 1342 LINEJOIN ROUND 1378 1343 OUTLINECOLOR 255 127 127 1379 PATTERN 1380 4.00 1.00 1381 END 1344 PATTERN 4.00 1.00 END 1382 1345 SIZE 1 1383 1346 END … … 1386 1349 1387 1350 # LAYER gff FlurstÃŒcke / FlÀchen / Grenzen 1388 LAYER 1351 LAYER NAME "gff" 1389 1352 CLASSITEM "signaturnummer" 1390 1353 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1392 1355 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" 1393 1356 #EXTENT ... 1394 MAXSCALEDENOM 50001357 MAXSCALEDENOM 12000 # 5000 1395 1358 METADATA 1396 1359 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1397 1360 wms_layer_group "/FlurstÃŒcke/FlÀchen" 1398 wms_title "Grenzen" 1399 END 1400 NAME "gff" 1361 wms_title "Grenzen" 1362 END 1401 1363 PROCESSING "CLOSE_CONNECTION=DEFER" 1402 1364 PROJECTION "init=epsg:25832" END 1403 1365 SIZEUNITS METERS 1404 1366 STATUS OFF 1405 # ToDo: Universelle Version mit GKZ als Parameter? 1406 HEADER "/opt/gdi/alkisn/templates/alkisausk _inlh.html"1407 TEMPLATE "/opt/gdi/alkisn/templates/alkisausk _inl*gkz*.html" # gkz = mandant1367 1368 HEADER "/opt/gdi/alkisn/templates/alkisauskh.html" 1369 TEMPLATE "/opt/gdi/alkisn/templates/alkisausk.html" # gkz aus Mapfile-Name! 1408 1370 FOOTER "/opt/gdi/alkisn/templates/footer.html" 1409 TOLERANCE 1 1371 TOLERANCEUNITS pixels TOLERANCE 1 1372 1410 1373 TYPE POLYGON 1411 1374 UNITS METERS … … 1425 1388 ## Layer des Typs Linien 1426 1389 1427 # LAYER lt Topographie / Linien 1428 LAYER 1390 LAYER NAME "lt" # Topographie / Linien 1429 1391 CLASSITEM "signaturnummer" 1430 1392 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1436 1398 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1437 1399 wms_layer_group "/Topographie" 1438 wms_title "Linien" 1439 END 1440 NAME "lt" 1400 wms_title "Linien" 1401 END 1441 1402 PROCESSING "CLOSE_CONNECTION=DEFER" 1442 1403 PROJECTION "init=epsg:25832" END … … 1450 1411 STYLE 1451 1412 COLOR 255 255 255 1452 OPACITY 01413 # OPACITY 0 1453 1414 WIDTH 0.1818 1454 1415 END … … 1463 1424 END 1464 1425 1465 # LAYER lw GewÀsser / Linien 1466 LAYER 1426 LAYER NAME "lw" # GewÀsser / Linien 1467 1427 CLASSITEM "signaturnummer" 1468 1428 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1474 1434 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1475 1435 wms_layer_group "/GewÀsser" 1476 wms_title "Linien" 1477 END 1478 NAME "lw" 1436 wms_title "Linien" 1437 END 1479 1438 PROCESSING "CLOSE_CONNECTION=DEFER" 1480 1439 PROJECTION "init=epsg:25832" END … … 1484 1443 UNITS METERS 1485 1444 CLASS 1486 NAME "(2003)"1445 # NAME "(2003)" 1487 1446 EXPRESSION "2003" 1488 1447 STYLE 1489 1448 COLOR 255 255 255 1490 OPACITY 01449 # OPACITY 0 1491 1450 WIDTH 0.1818 1492 1451 END … … 1500 1459 END 1501 1460 CLASS 1502 NAME "(2592)"1461 # NAME "(2592)" 1503 1462 EXPRESSION "2592" 1504 1463 STYLE 1505 1464 COLOR 255 255 255 1506 OPACITY 01465 # OPACITY 0 1507 1466 WIDTH 0.1818 1508 1467 END … … 1516 1475 END 1517 1476 CLASS 1518 NAME "(2593)"1477 # NAME "(2593)" 1519 1478 EXPRESSION "2593" 1520 1479 STYLE 1521 1480 COLOR 255 255 255 1522 OPACITY 01481 # OPACITY 0 1523 1482 WIDTH 0.1818 1524 1483 END … … 1527 1486 LINECAP SQUARE 1528 1487 LINEJOIN ROUND 1529 PATTERN 1530 4.00 2.00 1531 END 1532 SIZE 0.18 1533 WIDTH 0.18 1534 END 1535 END 1536 CLASS 1537 NAME "(2595)" 1488 PATTERN 4.00 2.00 END 1489 SIZE 0.18 1490 WIDTH 0.18 1491 END 1492 END 1493 CLASS 1494 # NAME "(2595)" 1538 1495 EXPRESSION "2595" 1539 1496 STYLE 1540 1497 COLOR 255 255 255 1541 OPACITY 01498 # OPACITY 0 1542 1499 WIDTH 0.1818 1543 1500 END … … 1546 1503 LINECAP SQUARE 1547 1504 LINEJOIN ROUND 1548 PATTERN 1549 1.00 2.00 1550 END 1551 SIZE 0.18 1552 WIDTH 0.18 1553 END 1554 END 1555 CLASS 1556 NAME "(2560)" 1505 PATTERN 1.00 2.00 END 1506 SIZE 0.18 1507 WIDTH 0.18 1508 END 1509 END 1510 CLASS 1511 # NAME "(2560)" 1557 1512 EXPRESSION "2560" 1558 1513 STYLE 1559 1514 COLOR 255 255 255 1560 OPACITY 01515 # OPACITY 0 1561 1516 WIDTH 0.1818 1562 1517 END … … 1565 1520 LINECAP SQUARE 1566 1521 LINEJOIN ROUND 1567 PATTERN 1568 0.35 0.35 1569 END 1570 SIZE 0.18 1571 WIDTH 0.18 1572 END 1573 END 1574 END 1575 1576 # LAYER lv Verkehr / Linien 1577 LAYER 1522 PATTERN 0.35 0.35 END 1523 SIZE 0.18 1524 WIDTH 0.18 1525 END 1526 END 1527 END 1528 1529 LAYER NAME "lv" # Verkehr / Linien 1578 1530 CLASSITEM "signaturnummer" 1579 1531 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1585 1537 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1586 1538 wms_layer_group "/Verkehr" 1587 wms_title "Linien" 1588 END 1589 NAME "lv" 1539 wms_title "Linien" 1540 END 1590 1541 PROCESSING "CLOSE_CONNECTION=DEFER" 1591 1542 PROJECTION "init=epsg:25832" END … … 1595 1546 UNITS METERS 1596 1547 CLASS 1597 NAME "(2535)"1548 # NAME "(2535)" 1598 1549 EXPRESSION "2535" 1599 1550 STYLE 1600 1551 COLOR 255 255 255 1601 OPACITY 01552 # OPACITY 0 1602 1553 WIDTH 0.3535 1603 1554 END … … 1606 1557 LINECAP SQUARE 1607 1558 LINEJOIN ROUND 1608 PATTERN 1609 2.00 3.20 1610 END 1559 PATTERN 2.00 3.20 END 1611 1560 SIZE 0.35 1612 1561 WIDTH 0.35 … … 1614 1563 END 1615 1564 CLASS 1616 NAME "(2525)"1565 # NAME "(2525)" 1617 1566 EXPRESSION "2525" 1618 1567 STYLE 1619 1568 COLOR 255 255 255 1620 OPACITY 01569 # OPACITY 0 1621 1570 WIDTH 0.1818 1622 1571 END … … 1630 1579 END 1631 1580 CLASS 1632 NAME "(2527)"1581 # NAME "(2527)" 1633 1582 EXPRESSION "2527" 1634 1583 STYLE 1635 1584 COLOR 255 255 255 1636 OPACITY 01585 # OPACITY 0 1637 1586 WIDTH 0.1818 1638 1587 END … … 1646 1595 END 1647 1596 CLASS 1648 NAME "(2530)"1597 # NAME "(2530)" 1649 1598 EXPRESSION "2530" 1650 1599 STYLE 1651 1600 COLOR 255 255 255 1652 OPACITY 01601 # OPACITY 0 1653 1602 WIDTH 0.505 1654 1603 END … … 1662 1611 END 1663 1612 CLASS 1664 NAME "(2506)"1613 # NAME "(2506)" 1665 1614 EXPRESSION "2506" 1666 1615 STYLE 1667 1616 COLOR 255 255 255 1668 OPACITY 01617 # OPACITY 0 1669 1618 WIDTH 0.1818 1670 1619 END … … 1673 1622 LINECAP SQUARE 1674 1623 LINEJOIN ROUND 1675 PATTERN 1676 0.35 0.35 1677 END 1624 PATTERN 0.35 0.35 END 1678 1625 SIZE 0.18 1679 1626 WIDTH 0.18 … … 1685 1632 STYLE 1686 1633 COLOR 255 255 255 1687 OPACITY 01634 # OPACITY 0 1688 1635 WIDTH 0.1818 1689 1636 END … … 1698 1645 END 1699 1646 1700 # LAYER li Industrie und Gewerbe / Linien 1701 LAYER 1647 LAYER NAME "li" # Industrie und Gewerbe / Linien 1702 1648 CLASSITEM "signaturnummer" 1703 1649 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1709 1655 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1710 1656 wms_layer_group "/Industrie und Gewerbe" 1711 wms_title "Linien" 1712 END 1713 NAME "li" 1657 wms_title "Linien" 1658 END 1714 1659 PROCESSING "CLOSE_CONNECTION=DEFER" 1715 1660 PROJECTION "init=epsg:25832" END … … 1719 1664 UNITS METERS 1720 1665 CLASS 1721 NAME "[2524]"1666 # NAME "[2524]" 1722 1667 EXPRESSION "2524" 1723 1668 STYLE 1724 1669 COLOR 255 255 255 1725 OPACITY 01670 # OPACITY 0 1726 1671 WIDTH 0.1818 1727 1672 END … … 1736 1681 END 1737 1682 1738 # LAYER lg GebÀude / Linien 1739 LAYER 1683 LAYER NAME "lg" # GebÀude / Linien 1740 1684 CLASSITEM "signaturnummer" 1741 1685 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1747 1691 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1748 1692 wms_layer_group "/GebÀude" 1749 wms_title "Linien" 1750 END 1751 NAME "lg" 1693 wms_title "Linien" 1694 END 1752 1695 PROCESSING "CLOSE_CONNECTION=DEFER" 1753 1696 PROJECTION "init=epsg:25832" END … … 1757 1700 UNITS METERS 1758 1701 CLASS 1759 NAME "(2507)"1702 # NAME "(2507)" 1760 1703 EXPRESSION "2507" 1761 1704 STYLE 1762 1705 COLOR 255 255 255 1763 OPACITY 01706 # OPACITY 0 1764 1707 WIDTH 0.1818 1765 1708 END … … 1773 1716 END 1774 1717 CLASS 1775 NAME "(2303)"1718 # NAME "(2303)" 1776 1719 EXPRESSION "2303" 1777 1720 STYLE 1778 1721 COLOR 255 255 255 1779 OPACITY 01722 # OPACITY 0 1780 1723 WIDTH 0.1818 1781 1724 END … … 1784 1727 LINECAP SQUARE 1785 1728 LINEJOIN ROUND 1786 PATTERN 1787 1.00 1.00 1788 END 1789 SIZE 0.18 1790 WIDTH 0.18 1791 END 1792 END 1793 END 1794 1795 # LAYER lp Politische Grenzen / Linien 1796 LAYER 1729 PATTERN 1.00 1.00 END 1730 SIZE 0.18 1731 WIDTH 0.18 1732 END 1733 END 1734 END 1735 1736 LAYER NAME "lp" # Politische Grenzen / Linien 1797 1737 CLASSITEM "signaturnummer" 1798 1738 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1804 1744 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1805 1745 wms_layer_group "/Politische Grenzen" 1806 wms_title "Linien" 1807 END 1808 NAME "lp" 1746 wms_title "Linien" 1747 END 1809 1748 PROCESSING "CLOSE_CONNECTION=DEFER" 1810 1749 PROJECTION "init=epsg:25832" END … … 1818 1757 STYLE 1819 1758 COLOR 255 255 255 1820 OPACITY 01759 # OPACITY 0 1821 1760 WIDTH 1.01 1822 1761 END … … 1825 1764 LINECAP SQUARE 1826 1765 LINEJOIN ROUND 1827 PATTERN 1828 5.00 11.00 1829 END 1766 PATTERN 5.00 11.00 END 1830 1767 SIZE 1 1831 1768 END … … 1834 1771 INITIALGAP 7.5 1835 1772 LINEJOIN ROUND 1836 PATTERN 1837 0.00 3.00 0.00 3.00 0.00 10.00 1838 END 1773 PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END 1839 1774 SIZE 1 1840 1775 END … … 1845 1780 STYLE 1846 1781 COLOR 255 255 255 1847 OPACITY 01782 # OPACITY 0 1848 1783 WIDTH 1.01 1849 1784 END … … 1852 1787 LINECAP SQUARE 1853 1788 LINEJOIN ROUND 1854 PATTERN 1855 5.00 11.00 1856 END 1789 PATTERN 5.00 11.00 END 1857 1790 SIZE 1 1858 1791 END … … 1861 1794 INITIALGAP 7.5 1862 1795 LINEJOIN ROUND 1863 PATTERN 1864 0.00 3.00 0.00 3.00 0.00 10.00 1865 END 1796 PATTERN 0.00 3.00 0.00 3.00 0.00 10.00 END 1866 1797 SIZE 1 1867 1798 END … … 1872 1803 STYLE 1873 1804 COLOR 255 255 255 1874 OPACITY 01805 # OPACITY 0 1875 1806 WIDTH 1.01 1876 1807 END … … 1879 1810 LINECAP SQUARE 1880 1811 LINEJOIN ROUND 1881 PATTERN 1882 5.00 8.00 1883 END 1812 PATTERN 5.00 8.00 END 1884 1813 SIZE 1 1885 1814 END … … 1888 1817 INITIALGAP 7.5 1889 1818 LINEJOIN ROUND 1890 PATTERN 1891 0.00 3.00 0.00 10.00 1892 END 1819 PATTERN 0.00 3.00 0.00 10.00 END 1893 1820 SIZE 1 1894 1821 END … … 1899 1826 STYLE 1900 1827 COLOR 255 255 255 1901 OPACITY 01828 # OPACITY 0 1902 1829 WIDTH 1.01 1903 1830 END … … 1906 1833 LINECAP SQUARE 1907 1834 LINEJOIN ROUND 1908 PATTERN 1909 5.00 8.00 1910 END 1835 PATTERN 5.00 8.00 END 1911 1836 SIZE 1 1912 1837 END … … 1915 1840 INITIALGAP 7.5 1916 1841 LINEJOIN ROUND 1917 PATTERN 1918 0.00 3.00 0.00 10.00 1919 END 1842 PATTERN 0.00 3.00 0.00 10.00 END 1920 1843 SIZE 1 1921 1844 END … … 1926 1849 STYLE 1927 1850 COLOR 255 255 255 1928 OPACITY 01851 # OPACITY 0 1929 1852 WIDTH 1.01 1930 1853 END … … 1933 1856 LINECAP SQUARE 1934 1857 LINEJOIN ROUND 1935 PATTERN 1936 5.00 5.00 1937 END 1858 PATTERN 5.00 5.00 END 1938 1859 SIZE 1 1939 1860 END … … 1942 1863 INITIALGAP 7.5 1943 1864 LINEJOIN ROUND 1944 PATTERN 1945 0.00 10.00 1946 END 1865 # PATTERN 0.00 10.00 END 1947 1866 SIZE 1 1948 1867 END … … 1953 1872 STYLE 1954 1873 COLOR 255 255 255 1955 OPACITY 01874 # OPACITY 0 1956 1875 WIDTH 1.01 1957 1876 END … … 1960 1879 LINECAP SQUARE 1961 1880 LINEJOIN ROUND 1962 PATTERN 1963 5.00 5.00 1964 END 1881 PATTERN 5.00 5.00 END 1965 1882 SIZE 1 1966 1883 END … … 1969 1886 INITIALGAP 7.5 1970 1887 LINEJOIN ROUND 1971 PATTERN 1972 0.00 10.00 1973 END 1888 # PATTERN 0.00 10.00 END 1974 1889 SIZE 1 1975 1890 END … … 1977 1892 END 1978 1893 1979 # LAYER lfn FlurstÃŒcke / Nummern / Linien 1980 LAYER 1894 LAYER NAME "lfn" # FlurstÃŒcke / Nummern / Linien 1981 1895 CLASSITEM "signaturnummer" 1982 1896 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 1988 1902 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1989 1903 wms_layer_group "/FlurstÃŒcke/Nummern" 1990 wms_title "Linien" 1991 END 1992 NAME "lfn" 1904 wms_title "Linien" 1905 END 1993 1906 PROCESSING "CLOSE_CONNECTION=DEFER" 1994 1907 PROJECTION "init=epsg:25832" END … … 2002 1915 STYLE 2003 1916 COLOR 255 255 255 2004 OPACITY 01917 # OPACITY 0 2005 1918 WIDTH 0.1818 2006 1919 END … … 2018 1931 STYLE 2019 1932 COLOR 255 255 255 2020 OPACITY 01933 # OPACITY 0 2021 1934 WIDTH 0.1818 2022 1935 END … … 2030 1943 END 2031 1944 2032 # LAYER lff FlurstÃŒcke / FlÀchen / Linien 2033 LAYER 1945 LAYER NAME "lff" # FlurstÃŒcke / FlÀchen / Linien 2034 1946 CLASSITEM "signaturnummer" 2035 1947 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2041 1953 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2042 1954 wms_layer_group "/FlurstÃŒcke/FlÀchen" 2043 wms_title "Linien" 2044 END 2045 NAME "lff" 1955 wms_title "Linien" 1956 END 2046 1957 PROCESSING "CLOSE_CONNECTION=DEFER" 2047 1958 PROJECTION "init=epsg:25832" END … … 2055 1966 STYLE 2056 1967 COLOR 255 255 255 2057 OPACITY 01968 # OPACITY 0 2058 1969 WIDTH 0.3535 2059 1970 END … … 2062 1973 LINECAP SQUARE 2063 1974 LINEJOIN ROUND 2064 PATTERN 2065 6.00 1.00 2066 END 1975 PATTERN 6.00 1.00 END 2067 1976 SIZE 0.35 2068 1977 WIDTH 0.35 … … 2074 1983 STYLE 2075 1984 COLOR 255 255 255 2076 OPACITY 01985 # OPACITY 0 2077 1986 WIDTH 0.3535 2078 1987 END … … 2081 1990 LINECAP SQUARE 2082 1991 LINEJOIN ROUND 2083 PATTERN 2084 2.00 1.00 2085 END 1992 PATTERN 2.00 1.00 END 2086 1993 SIZE 0.35 2087 1994 WIDTH 0.35 … … 2092 1999 ## Layer des Typs Punkte 2093 2000 2094 # LAYER pff FlurstÃŒcke / FlÀchen / Punkte 2095 LAYER 2001 LAYER NAME "pff" # FlurstÃŒcke / FlÀchen / Punkte 2096 2002 CLASSITEM "signaturnummer" 2097 2003 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2103 2009 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2104 2010 wms_layer_group "/FlurstÃŒcke/FlÀchen" 2105 wms_title "Punkte" 2106 END 2107 NAME "pff" 2011 wms_title "Punkte" 2012 END 2108 2013 PROCESSING "CLOSE_CONNECTION=DEFER" 2109 2014 PROJECTION "init=epsg:25832" END … … 2146 2051 END 2147 2052 2148 # LAYER pg GebÀude / Punkte 2149 LAYER 2053 LAYER NAME "pg" # GebÀude / Punkte 2150 2054 CLASSITEM "signaturnummer" 2151 2055 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2157 2061 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2158 2062 wms_layer_group "/GebÀude" 2159 wms_title "Punkte" 2160 END 2161 NAME "pg" 2063 wms_title "Punkte" 2064 END 2162 2065 PROCESSING "CLOSE_CONNECTION=DEFER" 2163 2066 PROJECTION "init=epsg:25832" END … … 2178 2081 END 2179 2082 CLASS 2180 NAME "(3527)"2083 # NAME "(3527)" 2181 2084 EXPRESSION "3527" 2182 2085 STYLE … … 2371 2274 END 2372 2275 2373 # LAYER pv Verkehr / Punkte 2374 LAYER 2276 LAYER NAME "pv" # Verkehr / Punkte 2375 2277 CLASSITEM "signaturnummer" 2376 2278 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2382 2284 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2383 2285 wms_layer_group "/Verkehr" 2384 wms_title "Punkte" 2385 END 2386 NAME "pv" 2286 wms_title "Punkte" 2287 END 2387 2288 PROCESSING "CLOSE_CONNECTION=DEFER" 2388 2289 PROJECTION "init=epsg:25832" END … … 2454 2355 END 2455 2356 2456 # LAYER pe Vegetation / Punkte 2457 LAYER 2357 LAYER NAME "pe" # Vegetation / Punkte 2458 2358 CLASSITEM "signaturnummer" 2459 2359 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2465 2365 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2466 2366 wms_layer_group "/Vegetation" 2467 wms_title "Punkte" 2468 END 2469 NAME "pe" 2367 wms_title "Punkte" 2368 END 2470 2369 PROCESSING "CLOSE_CONNECTION=DEFER" 2471 2370 PROJECTION "init=epsg:25832" END … … 2659 2558 END 2660 2559 2661 # LAYER pw GewÀsser / Punkte 2662 LAYER 2560 LAYER NAME "pw" # GewÀsser / Punkte 2663 2561 CLASSITEM "signaturnummer" 2664 2562 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2670 2568 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2671 2569 wms_layer_group "/GewÀsser" 2672 wms_title "Punkte" 2673 END 2674 NAME "pw" 2570 wms_title "Punkte" 2571 END 2675 2572 PROCESSING "CLOSE_CONNECTION=DEFER" 2676 2573 PROJECTION "init=epsg:25832" END … … 2724 2621 END 2725 2622 CLASS 2726 NAME "(3596)"2623 # NAME "(3596)" 2727 2624 EXPRESSION "3596" 2728 2625 STYLE … … 2746 2643 END 2747 2644 2748 # LAYER pi Industrie und Gewerbe / Punkte 2749 LAYER 2645 LAYER NAME "pi" # Industrie und Gewerbe / Punkte 2750 2646 CLASSITEM "signaturnummer" 2751 2647 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2757 2653 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2758 2654 wms_layer_group "/Industrie und Gewerbe" 2759 wms_title "Punkte" 2760 END 2761 NAME "pi" 2655 wms_title "Punkte" 2656 END 2762 2657 PROCESSING "CLOSE_CONNECTION=DEFER" 2763 2658 PROJECTION "init=epsg:25832" END … … 2862 2757 END 2863 2758 2864 # LAYER ps Sport und Freizeit / Punkte 2865 LAYER 2759 LAYER NAME "ps" # Sport und Freizeit / Punkte 2866 2760 CLASSITEM "signaturnummer" 2867 2761 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2873 2767 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2874 2768 wms_layer_group "/Sport und Freizeit" 2875 wms_title "Punkte" 2876 END 2877 NAME "ps" 2769 wms_title "Punkte" 2770 END 2878 2771 PROCESSING "CLOSE_CONNECTION=DEFER" 2879 2772 PROJECTION "init=epsg:25832" END … … 2945 2838 END 2946 2839 2947 # LAYER pt Topographie / Punkte 2948 LAYER 2840 LAYER NAME "pt" # Topographie / Punkte 2949 2841 CLASSITEM "signaturnummer" 2950 2842 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 2956 2848 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2957 2849 wms_layer_group "/Topographie" 2958 wms_title "Punkte" 2959 END 2960 NAME "pt" 2850 wms_title "Punkte" 2851 END 2961 2852 PROCESSING "CLOSE_CONNECTION=DEFER" 2962 2853 PROJECTION "init=epsg:25832" END … … 3003 2894 ## Layer des Typs Beschriftungen 3004 2895 3005 # LAYER bfn FlurstÃŒcke / Nummern / Beschriftungen 3006 LAYER 2896 LAYER NAME "bfn" # FlurstÃŒcke / Nummern / Beschriftungen 3007 2897 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3008 2898 CONNECTIONTYPE POSTGIS … … 3014 2904 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3015 2905 wms_layer_group "/FlurstÃŒcke/Nummern" 3016 wms_title "Beschriftungen (Punkte)" 3017 END 3018 NAME "bfn" 2906 wms_title "Beschriftungen (Punkte)" 2907 END 2908 PROCESSING "CLOSE_CONNECTION=DEFER" 2909 PROJECTION "init=epsg:25832" END 2910 SIZEUNITS INCHES 2911 STATUS OFF 2912 SYMBOLSCALEDENOM 1000 2913 TYPE POINT 2914 UNITS METERS 2915 CLASS 2916 LABEL 2917 ANGLE [drehwinkel_grad] 2918 ANTIALIAS TRUE 2919 FONT [font_umn] 2920 SIZE [size_umn] 2921 BUFFER 2 2922 COLOR [color_umn] 2923 FORCE TRUE 2924 OUTLINECOLOR 255 255 255 2925 OUTLINEWIDTH 2 # 1 # krz 2016-05-11 2926 POSITION [position_umn] 2927 PRIORITY 10 2928 TYPE TRUETYPE 2929 END 2930 END 2931 END 2932 2933 LAYER NAME "bg" # GebÀude / Beschriftungen 2934 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2935 CONNECTIONTYPE POSTGIS 2936 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" 2937 #EXTENT ... 2938 LABELITEM "text" 2939 MAXSCALEDENOM 3500 2940 METADATA 2941 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2942 wms_layer_group "/GebÀude" 2943 wms_title "Beschriftungen (Punkte)" 2944 END 3019 2945 PROCESSING "CLOSE_CONNECTION=DEFER" 3020 2946 PROJECTION "init=epsg:25832" END … … 3041 2967 END 3042 2968 3043 # LAYER bg GebÀude / Beschriftungen3044 LAYER3045 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3046 CONNECTIONTYPE POSTGIS 3047 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"2969 LAYER NAME "bg2" # GebÀude / lfd. Nr. NebengebÀude 2970 # NebengebÀude-Nummer in Klammer, normalerweise aus 2971 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2972 CONNECTIONTYPE POSTGIS 2973 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" 3048 2974 #EXTENT ... 3049 2975 LABELITEM "text" … … 3051 2977 METADATA 3052 2978 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3053 wms_layer_group "/GebÀude" 3054 wms_title "Beschriftungen (Punkte)" 3055 END 3056 NAME "bg" 2979 wms_layer_group "/GebÀude" # "/GebÀude/Laufende Hausnummern" 2980 wms_title "lfd. Nr. NebengebÀude" # "Beschriftungen (Punkte)" 2981 END 3057 2982 PROCESSING "CLOSE_CONNECTION=DEFER" 3058 2983 PROJECTION "init=epsg:25832" END … … 3079 3004 END 3080 3005 3081 # LAYER bg2 GebÀude / Laufende Hausnummern / Beschriftungen 3082 # * NebengebÀude-Nummer in Klammer, normalerweise aus 3083 LAYER 3084 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3085 CONNECTIONTYPE POSTGIS 3086 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" 3006 LAYER # Lagebezeichnungen / Beschriftungen 3007 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3008 CONNECTIONTYPE POSTGIS 3009 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" 3087 3010 #EXTENT ... 3088 3011 LABELITEM "text" 3089 MAXSCALEDENOM 3500 3090 METADATA 3091 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3092 # wms_layer_group "/GebÀude/Laufende Hausnummern" 3093 # wms_title "Beschriftungen (Punkte)" 3094 wms_layer_group "/GebÀude" 3095 wms_title "lfd. Nr. NebengebÀude" 3096 END 3097 NAME "bg2" 3012 MAXSCALEDENOM 5000 3013 METADATA 3014 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3015 wms_layer_group "/Lagebezeichnungen" 3016 wms_title "Beschriftungen (Punkte)" 3017 END 3018 NAME "bl" 3098 3019 PROCESSING "CLOSE_CONNECTION=DEFER" 3099 3020 PROJECTION "init=epsg:25832" END … … 3120 3041 END 3121 3042 3122 # LAYER bl Lagebezeichnungen / Beschriftungen 3123 LAYER 3124 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3125 CONNECTIONTYPE POSTGIS 3126 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" 3043 LAYER NAME "br" # Rechtliche Festlegungen / Beschriftungen 3044 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3045 CONNECTIONTYPE POSTGIS 3046 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" 3127 3047 #EXTENT ... 3128 3048 LABELITEM "text" 3129 MAXSCALEDENOM 5000 3130 METADATA 3131 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3132 wms_layer_group "/Lagebezeichnungen" 3133 wms_title "Beschriftungen (Punkte)" 3134 END 3135 NAME "bl" 3049 MAXSCALEDENOM 25000 3050 METADATA 3051 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3052 wms_layer_group "/Rechtliche Festlegungen" 3053 wms_title "Beschriftungen (Punkte)" 3054 END 3136 3055 PROCESSING "CLOSE_CONNECTION=DEFER" 3137 3056 PROJECTION "init=epsg:25832" END … … 3158 3077 END 3159 3078 3160 # LAYER br Rechtliche Festlegungen / Beschriftungen 3161 LAYER 3162 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3163 CONNECTIONTYPE POSTGIS 3164 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" 3079 LAYER NAME "bv" # Verkehr / Beschriftungen 3080 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3081 CONNECTIONTYPE POSTGIS 3082 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" 3165 3083 #EXTENT ... 3166 3084 LABELITEM "text" 3167 MAXSCALEDENOM 25000 3168 METADATA 3169 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3170 wms_layer_group "/Rechtliche Festlegungen" 3171 wms_title "Beschriftungen (Punkte)" 3172 END 3173 NAME "br" 3085 MAXSCALEDENOM 5000 3086 METADATA 3087 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3088 wms_layer_group "/Verkehr" 3089 wms_title "Beschriftungen (Punkte)" 3090 END 3174 3091 PROCESSING "CLOSE_CONNECTION=DEFER" 3175 3092 PROJECTION "init=epsg:25832" END … … 3196 3113 END 3197 3114 3198 # LAYER bv Verkehr / Beschriftungen 3199 LAYER 3200 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3201 CONNECTIONTYPE POSTGIS 3202 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" 3115 LAYER NAME "bh" # FriedHöfe / Beschriftungen 3116 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3117 CONNECTIONTYPE POSTGIS 3118 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" 3203 3119 #EXTENT ... 3204 3120 LABELITEM "text" … … 3206 3122 METADATA 3207 3123 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3208 wms_layer_group "/Verkehr" 3209 wms_title "Beschriftungen (Punkte)" 3210 END 3211 NAME "bv" 3124 wms_layer_group "/Friedhöfe" 3125 wms_title "Beschriftungen (Punkte)" 3126 END 3212 3127 PROCESSING "CLOSE_CONNECTION=DEFER" 3213 3128 PROJECTION "init=epsg:25832" END … … 3234 3149 END 3235 3150 3236 # LAYER bh Friedhöfe / Beschriftungen 3237 LAYER 3238 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3239 CONNECTIONTYPE POSTGIS 3240 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" 3151 LAYER NAME "be" # Vegetation / Beschriftungen 3152 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3153 CONNECTIONTYPE POSTGIS 3154 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" 3241 3155 #EXTENT ... 3242 3156 LABELITEM "text" … … 3244 3158 METADATA 3245 3159 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3246 wms_layer_group "/Friedhöfe" 3247 wms_title "Beschriftungen (Punkte)" 3248 END 3249 NAME "bh" 3160 wms_layer_group "/Vegetation" 3161 wms_title "Beschriftungen (Punkte)" 3162 END 3250 3163 PROCESSING "CLOSE_CONNECTION=DEFER" 3251 3164 PROJECTION "init=epsg:25832" END … … 3272 3185 END 3273 3186 3274 # LAYER be Vegetation / Beschriftungen 3275 LAYER 3276 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3277 CONNECTIONTYPE POSTGIS 3278 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" 3187 LAYER NAME "bw" # GewÀsser / Beschriftungen 3188 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3189 CONNECTIONTYPE POSTGIS 3190 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" 3279 3191 #EXTENT ... 3280 3192 LABELITEM "text" … … 3282 3194 METADATA 3283 3195 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3284 wms_layer_group "/Vegetation" 3285 wms_title "Beschriftungen (Punkte)" 3286 END 3287 NAME "be" 3196 wms_layer_group "/GewÀsser" 3197 wms_title "Beschriftungen (Punkte)" 3198 END 3288 3199 PROCESSING "CLOSE_CONNECTION=DEFER" 3289 3200 PROJECTION "init=epsg:25832" END … … 3310 3221 END 3311 3222 3312 # LAYER bw GewÀsser / Beschriftungen 3313 LAYER 3314 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3315 CONNECTIONTYPE POSTGIS 3316 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" 3223 LAYER NAME "bi" # Industrie und Gewerbe / Beschriftungen 3224 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3225 CONNECTIONTYPE POSTGIS 3226 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" 3317 3227 #EXTENT ... 3318 3228 LABELITEM "text" 3319 MAXSCALEDENOM 5000 3320 METADATA 3321 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3322 wms_layer_group "/GewÀsser" 3323 wms_title "Beschriftungen (Punkte)" 3324 END 3325 NAME "bw" 3229 MAXSCALEDENOM 10000 3230 METADATA 3231 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3232 wms_layer_group "/Industrie und Gewerbe" 3233 wms_title "Beschriftungen (Punkte)" 3234 END 3326 3235 PROCESSING "CLOSE_CONNECTION=DEFER" 3327 3236 PROJECTION "init=epsg:25832" END … … 3329 3238 STATUS OFF 3330 3239 SYMBOLSCALEDENOM 1000 3331 TYPE POINT 3240 TYPE POINT # ANNOTATION 3332 3241 UNITS METERS 3333 3242 CLASS … … 3348 3257 END 3349 3258 3350 # LAYER bi Industrie und Gewerbe / Beschriftungen 3351 LAYER 3352 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3353 CONNECTIONTYPE POSTGIS 3354 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" 3259 LAYER NAME "bs" # Sport und Freizeit / Beschriftungen 3260 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3261 CONNECTIONTYPE POSTGIS 3262 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" 3355 3263 #EXTENT ... 3356 3264 LABELITEM "text" … … 3358 3266 METADATA 3359 3267 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3360 wms_layer_group "/Industrie und Gewerbe" 3361 wms_title "Beschriftungen (Punkte)" 3362 END 3363 NAME "bi" 3268 wms_layer_group "/Sport und Freizeit" 3269 wms_title "Beschriftungen (Punkte)" 3270 END 3364 3271 PROCESSING "CLOSE_CONNECTION=DEFER" 3365 3272 PROJECTION "init=epsg:25832" END … … 3386 3293 END 3387 3294 3388 # LAYER bs Sport und Freizeit / Beschriftungen 3389 LAYER 3390 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3391 CONNECTIONTYPE POSTGIS 3392 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" 3295 LAYER NAME "bb" # WohnBauflÀchen / Beschriftungen 3296 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3297 CONNECTIONTYPE POSTGIS 3298 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" 3393 3299 #EXTENT ... 3394 3300 LABELITEM "text" … … 3396 3302 METADATA 3397 3303 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3398 wms_layer_group "/Sport und Freizeit" 3399 wms_title "Beschriftungen (Punkte)" 3400 END 3401 NAME "bs" 3304 wms_layer_group "/WohnbauflÀchen" 3305 wms_title "Beschriftungen (Punkte)" 3306 END 3402 3307 PROCESSING "CLOSE_CONNECTION=DEFER" 3403 3308 PROJECTION "init=epsg:25832" END … … 3424 3329 END 3425 3330 3426 # LAYER bb WohnbauflÀchen / Beschriftungen 3427 LAYER 3428 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3429 CONNECTIONTYPE POSTGIS 3430 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" 3331 LAYER NAME "bt" # Topographie / Beschriftungen 3332 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3333 CONNECTIONTYPE POSTGIS 3334 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" 3431 3335 #EXTENT ... 3432 3336 LABELITEM "text" … … 3434 3338 METADATA 3435 3339 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3436 wms_layer_group "/WohnbauflÀchen" 3437 wms_title "Beschriftungen (Punkte)" 3438 END 3439 NAME "bb" 3340 wms_layer_group "/Topographie" 3341 wms_title "Beschriftungen (Punkte)" 3342 END 3440 3343 PROCESSING "CLOSE_CONNECTION=DEFER" 3441 3344 PROJECTION "init=epsg:25832" END … … 3443 3346 STATUS OFF 3444 3347 SYMBOLSCALEDENOM 1000 3445 TYPE POINT # ANNOTATION3348 TYPE POINT 3446 3349 UNITS METERS 3447 3350 CLASS … … 3462 3365 END 3463 3366 3464 # LAYER bt Topographie / Beschriftungen3465 3367 LAYER 3466 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3467 CONNECTIONTYPE POSTGIS 3468 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" 3469 #EXTENT ... 3470 LABELITEM "text" 3471 MAXSCALEDENOM 10000 3472 METADATA 3473 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3474 wms_layer_group "/Topographie" 3475 wms_title "Beschriftungen (Punkte)" 3476 END 3477 NAME "bt" 3478 PROCESSING "CLOSE_CONNECTION=DEFER" 3479 PROJECTION "init=epsg:25832" END 3480 SIZEUNITS INCHES 3481 STATUS OFF 3482 SYMBOLSCALEDENOM 1000 3368 NAME "copyright" 3369 STATUS ON # DEFAULT 3483 3370 TYPE POINT 3484 UNITS METERS 3371 TRANSFORM lr 3372 METADATA 3373 wms_title "Copyright" 3374 wms_abstract "In der Karte sichtbare Angabe auf die Herkunft der Daten" 3375 WMS_KEYWORDLIST "Katasteramt, Copyright, Quellenangabe" 3376 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3377 END 3378 FEATURE 3379 POINTS 0 0 END 3380 # individuell Kreisname und ggf. Vertragsnummer einsetzen: 3381 TEXT 'Copyright Geobasisdaten Liegenschaftskataster Kreis __' 3382 END 3485 3383 CLASS 3486 3384 LABEL 3487 ANGLE [drehwinkel_grad] 3488 ANTIALIAS TRUE 3489 FONT [font_umn] 3490 SIZE [size_umn] 3491 BUFFER 2 3492 COLOR [color_umn] 3385 SIZE small 3386 POSITION ul 3387 COLOR 50 50 50 3493 3388 FORCE TRUE 3494 OUTLINECOLOR 255 255 2553495 POSITION [position_umn]3496 PRIORITY 103497 TYPE TRUETYPE3389 STYLE 3390 GEOMTRANSFORM 'labelpoly' 3391 COLOR 250 250 250 3392 END 3498 3393 END 3499 3394 END
Note: See TracChangeset
for help on using the changeset viewer.