Changeset 369 for trunk/umn/alkis_n/alkis_sw_muster.map
- Timestamp:
- 05/23/16 17:29:30 (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/umn/alkis_n/alkis_sw_muster.map
r368 r369 5 5 # Stand: 6 6 # 2016-05-19 generiert, angepasst und optimiert 7 # 2016-05-20 Legende unterdrÃŒcken 8 # 2016-05-23 FlurstÃŒcke: 2stufige Gruppierung raus. 9 # Beschriftung: links-/rechtsbÃŒndig vertauscht. 7 10 8 11 # ToDo: 9 # - Unförmige Legende z.B. im Layer "GebÀude/Grenzen" durch SVG-Symbole und/oder "SIZEUNIT METERS"?10 # - Layer oder Gruppe fÃŒr SchÀtzungsklassen11 12 # - In "GebÀude / Beschriftungen" werden ausser der Haunummer auch nich Buchstaben sichtbar, z.T. ÃŒberlappend 12 13 # Die sollten getrennt schaltbar sein. … … 17 18 # Quelle: C:\Users\[ich]\.qgis2\python\plugins\alkisplugin\svg\ 18 19 # Der Inhalt dieses Ordners ist komplett zum WMS-Server zu exportieren: /opt/gdi/alkisn/svg/ 19 #20 ## MapProxy:21 # Layer fÃŒr FlÀche: LAYERS=fh,fe,fb,fw,fs,fi,fv22 # Layer fÃŒr Strichzeichnung: LAYERS=gh,bh,ge,pe,be,gb,bb,gt,lt,pt,bt,gw,lw,pw,bw,gs,ps,bs,gi,li,pi,bi,gv,lv,pv,bv,fg,gg,lg,pg,bg,gff,lff,pff,lfn,bfn,bl23 20 # 24 21 ## Layername: … … 57 54 # r Rechtliche Festlegungen 58 55 # f FlurstÃŒcke 59 # fn 60 # ff 56 # fn FlurstÃŒcke/Nummern 57 # ff FlurstÃŒcke/FlÀchen 61 58 # p Politische Grenzen 62 59 # l Lagebezeichnungen … … 64 61 ### Layer-Reihenfolge 65 62 ## */ FlÀchen + Grenzen 66 # fh Friedhöfe / FlÀchen 63 # -fh Friedhöfe / FlÀchen 64 # gh Friedhöfe / Grenzen 67 65 # fe Vegetation / FlÀchen 68 66 # fb WohnbauflÀchen / FlÀchen 69 67 # gt Topographie / Grenzen 70 68 # ge Vegetation / Grenzen 71 # -gh Friedhöfe / Grenzen72 69 # -gb WohnbauflÀchen / Grenzen 73 70 # -fw GewÀsser / FlÀchen … … 86 83 # lt Topographie / Linien 87 84 # lw GewÀsser / Linien 88 # lv Verkehr / Linien **85 # lv Verkehr / Linien 89 86 # li Industrie und Gewerbe / Linien 90 87 # lg GebÀude / Linien … … 129 126 METADATA 130 127 wms_title "ALKIS sw" 131 wms_abstract "ALKIS Schwarz/WeiÃ-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 18. Mai 2016"128 wms_abstract "ALKIS Schwarz/WeiÃ-Variante *gkz* - Konverter PostNAS, Version NorGIS-Plugin, Stand vom 20. Mai 2016" 132 129 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 133 130 wms_bbox_extended "true" … … 141 138 wms_fees "none" 142 139 wms_accessconstraints "fÃŒr den Dienstgebrauch" 140 141 # theoretish ausreichend: 142 # wms_enable_request "GetCapabilities GetMap" # Rest je Layer individuell addieren 143 144 # praktisch notwendig: 143 145 wms_enable_request "*" 146 144 147 include "meta_contact.map" # ersetzen durch individuelle Datei je Katasteramt 145 148 END … … 147 150 148 151 LEGEND 149 STATUS O FF # ON152 STATUS ON 150 153 KEYSIZE 32 16 151 154 KEYSPACING 5 5 … … 153 156 TYPE TRUETYPE 154 157 FONT 'arial' 155 SIZE 9158 SIZE 11 156 159 COLOR 1 1 1 157 160 END … … 160 163 ## Layer der Typen FlÀchen + Grenzen 161 164 162 LAYER NAME " fh" # FriedHöfe / FlÀchen165 LAYER NAME "gh" # FriedHöfe / Grenzen 163 166 CLASSITEM "signaturnummer" 164 167 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" … … 173 176 wms_layer_group "/Friedhöfe" 174 177 wms_title "Grenzen" 178 #wms_enable_request "GetLegendGraphic" 175 179 END 176 180 PROCESSING "CLOSE_CONNECTION=DEFER" … … 241 245 wms_layer_group "/GewÀsser" 242 246 wms_title "FlÀchen" 247 wms_enable_request "GetLegendGraphic" 243 248 END 244 249 PROCESSING "CLOSE_CONNECTION=DEFER" … … 322 327 END 323 328 CLASS 324 NAME "Wald"329 #- NAME "Wald" 325 330 EXPRESSION "2517" 326 331 STYLE … … 367 372 END 368 373 369 # LAYER gh ??370 # LAYER gb ??371 # LAYER fw ??372 # LAYER fs ??373 374 374 LAYER NAME "gs" # Sport und Freizeit / Grenzen 375 375 CLASSITEM "signaturnummer" … … 402 402 END 403 403 CLASS 404 NAME "Ãberdachte TribÃŒne"404 #- NAME "Ãberdachte TribÃŒne" 405 405 EXPRESSION "rn1519" 406 406 STYLE … … 414 414 END 415 415 CLASS 416 NAME "Hart-, Rasenplatz, Spielfeld"416 #- NAME "Hart-, Rasenplatz, Spielfeld" 417 417 EXPRESSION "rn1520" 418 418 STYLE … … 436 436 END 437 437 CLASS 438 NAME "Schwimmbecken"438 #- NAME "Schwimmbecken" 439 439 EXPRESSION "rn1526" 440 440 STYLE … … 447 447 END 448 448 CLASS 449 NAME "Rennbahn, Laufbahn, GelÀuf"449 #- NAME "Rennbahn, Laufbahn, GelÀuf" 450 450 EXPRESSION "rn1521" 451 451 STYLE … … 490 490 END 491 491 CLASS 492 NAME "GewÀsser"492 #- NAME "GewÀsser" 493 493 EXPRESSION "2518" 494 494 STYLE … … 512 512 END 513 513 CLASS 514 NAME "Fischtreppe, Sicherheitstor, Sperrwerk"514 #- NAME "Fischtreppe, Sicherheitstor, Sperrwerk" 515 515 EXPRESSION "rn1548" 516 516 STYLE … … 534 534 END 535 535 CLASS 536 NAME "Unterirdisches GewÀsser"536 #- NAME "Unterirdisches GewÀsser" 537 537 EXPRESSION "rn1550" 538 538 STYLE … … 558 558 wms_layer_group "/Industrie und Gewerbe" 559 559 wms_title "FlÀchen" 560 wms_enable_request "GetLegendGraphic" 560 561 END 561 562 PROCESSING "CLOSE_CONNECTION=DEFER" … … 626 627 END 627 628 CLASS 628 NAME "KlÀrbecken"629 #- NAME "KlÀrbecken" 629 630 EXPRESSION "rn1510" 630 631 STYLE … … 658 659 END 659 660 CLASS 660 NAME "VorratsbehÀlter, Speicherbauwerk unterirdisch"661 #- NAME "VorratsbehÀlter, Speicherbauwerk unterirdisch" 661 662 EXPRESSION "rn1321" 662 663 STYLE … … 692 693 END 693 694 CLASS 694 NAME "Mast"695 #- NAME "Mast" 695 696 EXPRESSION "rn1306" 696 697 STYLE … … 717 718 wms_layer_group "/Verkehr" 718 719 wms_title "FlÀchen" 720 wms_enable_request "GetLegendGraphic" 719 721 END 720 722 PROCESSING "CLOSE_CONNECTION=DEFER" … … 772 774 END 773 775 CLASS 774 NAME "Bahnverkehr, Platz"776 #- NAME "Bahnverkehr, Platz" 775 777 EXPRESSION "2515" 776 778 STYLE … … 783 785 END 784 786 CLASS 785 NAME "Weg"787 #- NAME "Weg" 786 788 EXPRESSION "rn1542" 787 789 STYLE … … 828 830 END 829 831 CLASS 830 NAME "BrÃŒcke, Hochbahn/-straÃe"832 #- NAME "BrÃŒcke, Hochbahn/-straÃe" 831 833 EXPRESSION "rn1530" 832 834 STYLE … … 852 854 END 853 855 CLASS 854 NAME "Tunnel, UnterfÃŒhrung"856 #- NAME "Tunnel, UnterfÃŒhrung" 855 857 EXPRESSION "rn1533" 856 858 STYLE … … 876 878 wms_layer_group "/GebÀude" 877 879 wms_title "FlÀchen" 880 wms_enable_request "GetLegendGraphic" 878 881 END 879 882 PROCESSING "CLOSE_CONNECTION=DEFER" … … 965 968 END 966 969 CLASS 967 NAME "GebÀude unter der ErdoberflÀche"970 #- NAME "GebÀude unter der ErdoberflÀche" 968 971 EXPRESSION "2032" 969 972 STYLE … … 989 992 END 990 993 CLASS 991 NAME "Anderes GebÀude"994 #- NAME "Anderes GebÀude" 992 995 EXPRESSION "2031" 993 996 STYLE … … 1001 1004 END 1002 1005 CLASS 1003 NAME "Ãffentliches GebÀude"1006 #- NAME "Ãffentliches GebÀude" 1004 1007 EXPRESSION "2505" 1005 1008 STYLE … … 1034 1037 END 1035 1038 CLASS 1036 NAME "Anderes GebÀude"1039 #- NAME "Anderes GebÀude" 1037 1040 EXPRESSION "rn1501" 1038 1041 STYLE … … 1056 1059 END 1057 1060 CLASS 1058 NAME "aufgestÀndert"1061 #- NAME "aufgestÀndert" 1059 1062 EXPRESSION "2508" 1060 1063 STYLE … … 1068 1071 END 1069 1072 CLASS 1070 NAME "Schornstein im GebÀude"1073 #- NAME "Schornstein im GebÀude" 1071 1074 EXPRESSION "2513" 1072 1075 STYLE … … 1079 1082 END 1080 1083 CLASS 1081 NAME "Turm im GebÀude"1084 #- NAME "Turm im GebÀude" 1082 1085 EXPRESSION "2514" 1083 1086 STYLE … … 1124 1127 wms_layer_group "/Rechtliche Festlegungen" 1125 1128 wms_title "Grenzen" 1129 wms_enable_request "GetFeatureInfo !GetLegendGraphic" 1126 1130 END 1127 1131 PROCESSING "CLOSE_CONNECTION=DEFER" … … 1138 1142 1139 1143 CLASS 1140 NAME "Bau-, Raum-, Bodenordnungsrecht"1144 #- NAME "Bau-, Raum-, Bodenordnungsrecht" 1141 1145 EXPRESSION "rn1704" 1142 1146 STYLE … … 1155 1159 CONNECTIONTYPE POSTGIS 1156 1160 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" 1161 1162 #ATA "geom FROM (SELECT ogc_fid,gml_id,polygon AS geom,sn_randlinie AS signaturnummer FROM po_polygons WHERE signaturnummer = '2028' AND 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" 1163 # Filter signaturnummer = '2028' sinnvoll?: Nein keine Reduzierung de Menge 1164 1157 1165 #EXTENT ... 1158 1166 MAXSCALEDENOM 12000 # 5000 1159 1167 METADATA 1160 1168 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1161 wms_layer_group "/FlurstÃŒcke/FlÀchen" 1169 # wms_layer_group "/FlurstÃŒcke/FlÀchen" 1170 wms_layer_group "/FlurstÃŒcke" 1162 1171 wms_title "Grenzen" 1172 wms_enable_request "GetFeatureInfo" 1173 # Auch wenn 'wms_enable_request "GetLegendGraphic"' weggelassen wird, 1174 # ist in den Capabilities noch eine "LegendURL" enthalten. 1163 1175 END 1164 1176 PROCESSING "CLOSE_CONNECTION=DEFER" … … 1175 1187 UNITS METERS 1176 1188 CLASS 1177 NAME "FlurstÃŒcksgrenze"1189 #- NAME "FlurstÃŒcksgrenze" 1178 1190 EXPRESSION "2028" 1179 1191 STYLE … … 1181 1193 LINEJOIN ROUND 1182 1194 OUTLINECOLOR 0 0 0 1183 SIZE 0.351195 # SIZE 0.35 1184 1196 WIDTH 0.35 1197 # OUTLINEWIDTH 0.35 # NEIN! etwa doppelt so dick wie WIDTH 1185 1198 END 1186 1199 END … … 1208 1221 UNITS METERS 1209 1222 CLASS 1210 NAME "Damm, Wall, Deich, Graben, Knick, Wallkante"1223 #- NAME "Damm, Wall, Deich, Graben, Knick, Wallkante" 1211 1224 EXPRESSION "2620" 1212 1225 STYLE … … 1429 1442 END 1430 1443 CLASS 1431 NAME "Widerlager"1444 #- NAME "Widerlager" 1432 1445 EXPRESSION "2533" 1433 1446 STYLE … … 1553 1566 TYPE LINE 1554 1567 UNITS METERS 1555 CLASS 1556 NAME "Flurgrenze" 1568 # Bemerkung: Die folgenden 3 Classes wurden aus QGIS doppelt generiert 1569 CLASS 1570 #- NAME "Flurgrenze" 1557 1571 EXPRESSION "2012" 1558 STYLE 1572 STYLE # Grundierung 1559 1573 COLOR 255 255 255 1560 1574 # OPACITY 0 1561 1575 WIDTH 1.01 1562 1576 END 1563 STYLE 1577 STYLE # eckige Enden 1564 1578 COLOR 102 102 102 1565 1579 LINECAP SQUARE … … 1568 1582 SIZE 1 1569 1583 END 1570 STYLE 1584 STYLE # 0+ROUND macht Punkte 1571 1585 COLOR 102 102 102 1572 1586 INITIALGAP 7.5 … … 1577 1591 END 1578 1592 CLASS 1579 NAME "Flurgrenze"1580 EXPRESSION "201 2"1593 #- NAME "Gemarkungsgrenze" 1594 EXPRESSION "2014" 1581 1595 STYLE 1582 1596 COLOR 255 255 255 … … 1588 1602 LINECAP SQUARE 1589 1603 LINEJOIN ROUND 1590 PATTERN 5.00 11.00 END1604 PATTERN 5.00 8.00 END 1591 1605 SIZE 1 1592 1606 END … … 1595 1609 INITIALGAP 7.5 1596 1610 LINEJOIN ROUND 1597 PATTERN 0.00 3.00 0.00 3.00 0.0010.00 END1611 PATTERN 0.00 3.00 0.00 10.00 END 1598 1612 SIZE 1 1599 1613 END 1600 1614 END 1601 1615 CLASS 1602 NAME "Gemarkungsgrenze"1603 EXPRESSION "20 14"1616 #- NAME "Gemeindegrenze" 1617 EXPRESSION "2022" 1604 1618 STYLE 1605 1619 COLOR 255 255 255 … … 1611 1625 LINECAP SQUARE 1612 1626 LINEJOIN ROUND 1613 PATTERN 5.00 8.00 END1627 PATTERN 5.00 5.00 END 1614 1628 SIZE 1 1615 1629 END … … 1618 1632 INITIALGAP 7.5 1619 1633 LINEJOIN ROUND 1620 PATTERN 0.00 3.00 0.00 10.00 END1621 SIZE 11622 END1623 END1624 CLASS1625 NAME "Gemarkungsgrenze"1626 EXPRESSION "2014"1627 STYLE1628 COLOR 255 255 2551629 # OPACITY 01630 WIDTH 1.011631 END1632 STYLE1633 COLOR 102 102 1021634 LINECAP SQUARE1635 LINEJOIN ROUND1636 PATTERN 5.00 8.00 END1637 SIZE 11638 END1639 STYLE1640 COLOR 102 102 1021641 INITIALGAP 7.51642 LINEJOIN ROUND1643 PATTERN 0.00 3.00 0.00 10.00 END1644 SIZE 11645 END1646 END1647 CLASS1648 NAME "Gemeindegrenze"1649 EXPRESSION "2022"1650 STYLE1651 COLOR 255 255 2551652 # OPACITY 01653 WIDTH 1.011654 END1655 STYLE1656 COLOR 102 102 1021657 LINECAP SQUARE1658 LINEJOIN ROUND1659 PATTERN 5.00 5.00 END1660 SIZE 11661 END1662 STYLE1663 COLOR 102 102 1021664 INITIALGAP 7.51665 LINEJOIN ROUND1666 1634 PATTERN 0.00 10.00 END 1667 1635 SIZE 1 1668 1636 END 1669 1637 END 1670 CLASS1671 NAME "Gemeindegrenze"1672 EXPRESSION "2022"1673 STYLE1674 COLOR 255 255 2551675 # OPACITY 01676 WIDTH 1.011677 END1678 STYLE1679 COLOR 102 102 1021680 LINECAP SQUARE1681 LINEJOIN ROUND1682 PATTERN 5.00 5.00 END1683 SIZE 11684 END1685 STYLE1686 COLOR 102 102 1021687 INITIALGAP 7.51688 LINEJOIN ROUND1689 PATTERN 0.00 10.00 END1690 SIZE 11691 END1692 END1693 1638 END 1694 1639 … … 1700 1645 #EXTENT ... 1701 1646 MAXSCALEDENOM 5000 1702 METADATA 1703 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1704 wms_layer_group "/FlurstÃŒcke/Nummern" 1705 wms_title "Linien" 1647 REQUIRES "[bfn]" # Zuordnungspfeile nur zusammen mit den FlurstÃŒcksnummern 1648 METADATA 1649 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1650 # wms_layer_group "/FlurstÃŒcke/Nummern" 1651 # wms_title "Linien" 1652 wms_layer_group "/FlurstÃŒcke" 1653 wms_title "Zuordnung" 1706 1654 END 1707 1655 PROCESSING "CLOSE_CONNECTION=DEFER" … … 1712 1660 UNITS METERS 1713 1661 CLASS 1714 NAME "Bruchstriche"1662 #- NAME "Bruchstriche" 1715 1663 EXPRESSION "2001" 1716 1664 STYLE … … 1728 1676 END 1729 1677 CLASS 1730 NAME "Zuordnungspfeil"1678 #- NAME "Zuordnungspfeil" 1731 1679 EXPRESSION "2004" 1732 1680 STYLE … … 1753 1701 METADATA 1754 1702 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1755 wms_layer_group "/FlurstÃŒcke/FlÀchen" 1703 # wms_layer_group "/FlurstÃŒcke/FlÀchen" 1704 wms_layer_group "/FlurstÃŒcke" 1756 1705 wms_title "Linien" 1757 1706 END … … 1763 1712 UNITS METERS 1764 1713 CLASS 1765 NAME "Strittige Grenze"1714 #- NAME "Strittige Grenze" 1766 1715 EXPRESSION "2006" 1767 1716 STYLE … … 1780 1729 END 1781 1730 CLASS 1782 NAME "FlurstÃŒcksgrenze nicht feststellbar"1731 #- NAME "FlurstÃŒcksgrenze nicht feststellbar" 1783 1732 EXPRESSION "2008" 1784 1733 STYLE … … 1809 1758 METADATA 1810 1759 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 1811 wms_layer_group "/FlurstÃŒcke/FlÀchen" 1760 # wms_layer_group "/FlurstÃŒcke/FlÀchen" 1761 wms_layer_group "/FlurstÃŒcke" 1812 1762 wms_title "Punkte" 1813 1763 END … … 1820 1770 UNITS METERS 1821 1771 CLASS 1822 NAME "Abgemarkter Grenzpunkt"1772 #- NAME "Abgemarkter Grenzpunkt" 1823 1773 EXPRESSION "3020" 1824 1774 STYLE … … 1831 1781 END 1832 1782 CLASS 1833 NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt"1783 #- NAME "Grenzpunkt, Abmarkung zeitweilig ausgesetzt" 1834 1784 EXPRESSION "3022" 1835 1785 STYLE … … 1842 1792 END 1843 1793 CLASS 1844 NAME "FlurstÃŒcksÃŒberhaken"1794 #- NAME "FlurstÃŒcksÃŒberhaken" 1845 1795 EXPRESSION "3010" 1846 1796 STYLE … … 1874 1824 UNITS METERS 1875 1825 CLASS 1876 NAME "Springbrunnen, Zierbrunnen"1826 #- NAME "Springbrunnen, Zierbrunnen" 1877 1827 EXPRESSION "3539" 1878 1828 STYLE … … 1896 1846 END 1897 1847 CLASS 1898 NAME "Umformer"1848 #- NAME "Umformer" 1899 1849 EXPRESSION "3521" 1900 1850 STYLE … … 1907 1857 END 1908 1858 CLASS 1909 NAME "Spielcasino"1859 #- NAME "Spielcasino" 1910 1860 EXPRESSION "3308" 1911 1861 STYLE … … 1918 1868 END 1919 1869 CLASS 1920 NAME "Post"1870 #- NAME "Post" 1921 1871 EXPRESSION "3312" 1922 1872 STYLE … … 1929 1879 END 1930 1880 CLASS 1931 NAME "Hallenbad"1881 #- NAME "Hallenbad" 1932 1882 EXPRESSION "3334" 1933 1883 STYLE … … 1940 1890 END 1941 1891 CLASS 1942 NAME "Kapelle"1892 #- NAME "Kapelle" 1943 1893 EXPRESSION "3318" 1944 1894 STYLE … … 1951 1901 END 1952 1902 CLASS 1953 NAME "Kirche"1903 #- NAME "Kirche" 1954 1904 EXPRESSION "3316" 1955 1905 STYLE … … 1962 1912 END 1963 1913 CLASS 1964 NAME "Feuerwehr"1914 #- NAME "Feuerwehr" 1965 1915 EXPRESSION "3326" 1966 1916 STYLE … … 1973 1923 END 1974 1924 CLASS 1975 NAME "Kindergarten"1925 #- NAME "Kindergarten" 1976 1926 EXPRESSION "3323" 1977 1927 STYLE … … 1984 1934 END 1985 1935 CLASS 1986 NAME "Toilette"1936 #- NAME "Toilette" 1987 1937 EXPRESSION "3311" 1988 1938 STYLE … … 1995 1945 END 1996 1946 CLASS 1997 NAME "Kino"1947 #- NAME "Kino" 1998 1948 EXPRESSION "3306" 1999 1949 STYLE … … 2006 1956 END 2007 1957 CLASS 2008 NAME "Tiefgarage"1958 #- NAME "Tiefgarage" 2009 1959 EXPRESSION "3336" 2010 1960 STYLE … … 2017 1967 END 2018 1968 CLASS 2019 NAME "Bank"1969 #- NAME "Bank" 2020 1970 EXPRESSION "3300" 2021 1971 STYLE … … 2028 1978 END 2029 1979 CLASS 2030 NAME "Brunnen / Gasquelle, Mofette / Heilquelle"1980 #- NAME "Brunnen / Gasquelle, Mofette / Heilquelle" 2031 1981 EXPRESSION "3529" 2032 1982 STYLE … … 2039 1989 END 2040 1990 CLASS 2041 NAME "Hotel"1991 #- NAME "Hotel" 2042 1992 EXPRESSION "3302" 2043 1993 STYLE … … 2050 2000 END 2051 2001 CLASS 2052 NAME "GaststÀtte"2002 #- NAME "GaststÀtte" 2053 2003 EXPRESSION "3305" 2054 2004 STYLE … … 2061 2011 END 2062 2012 CLASS 2063 NAME "Meilenstein, historischer Grenzstein"2013 #- NAME "Meilenstein, historischer Grenzstein" 2064 2014 EXPRESSION "3536" 2065 2015 STYLE … … 2072 2022 END 2073 2023 CLASS 2074 NAME "Polizei"2024 #- NAME "Polizei" 2075 2025 EXPRESSION "3324" 2076 2026 STYLE … … 2083 2033 END 2084 2034 CLASS 2085 NAME "Denkmal"2035 #- NAME "Denkmal" 2086 2036 EXPRESSION "3532" 2087 2037 STYLE … … 2115 2065 UNITS METERS 2116 2066 CLASS 2117 NAME "Reitweg"2067 #- NAME "Reitweg" 2118 2068 EXPRESSION "3430" 2119 2069 STYLE … … 2126 2076 END 2127 2077 CLASS 2128 NAME "FuÃweg"2078 #- NAME "FuÃweg" 2129 2079 EXPRESSION "3424" 2130 2080 STYLE … … 2137 2087 END 2138 2088 CLASS 2139 NAME "Haltepunkt"2089 #- NAME "Haltepunkt" 2140 2090 EXPRESSION "3578" 2141 2091 STYLE … … 2148 2098 END 2149 2099 CLASS 2150 NAME "Parkplatz"2100 #- NAME "Parkplatz" 2151 2101 EXPRESSION "3432" 2152 2102 STYLE … … 2159 2109 END 2160 2110 CLASS 2161 NAME "Radweg"2111 #- NAME "Radweg" 2162 2112 EXPRESSION "3426" 2163 2113 STYLE … … 2170 2120 END 2171 2121 CLASS 2172 NAME "Rad- und FuÃweg"2122 #- NAME "Rad- und FuÃweg" 2173 2123 EXPRESSION "3428" 2174 2124 STYLE … … 2202 2152 UNITS METERS 2203 2153 CLASS 2204 NAME "Baumschule"2154 #- NAME "Baumschule" 2205 2155 EXPRESSION "3446" 2206 2156 STYLE … … 2213 2163 END 2214 2164 CLASS 2215 NAME "Sumpf"2165 #- NAME "Sumpf" 2216 2166 EXPRESSION "3478" 2217 2167 STYLE … … 2224 2174 END 2225 2175 CLASS 2226 NAME "Garten"2176 #- NAME "Garten" 2227 2177 EXPRESSION "3421" 2228 2178 STYLE … … 2235 2185 END 2236 2186 CLASS 2237 NAME "Streuobstacker"2187 #- NAME "Streuobstacker" 2238 2188 EXPRESSION "3440" 2239 2189 STYLE … … 2246 2196 END 2247 2197 CLASS 2248 NAME "Quelle"2198 #- NAME "Quelle" 2249 2199 EXPRESSION "3613" 2250 2200 STYLE … … 2257 2207 END 2258 2208 CLASS 2259 NAME "Nadelbaum"2209 #- NAME "Nadelbaum" 2260 2210 EXPRESSION "3597" 2261 2211 STYLE … … 2268 2218 END 2269 2219 CLASS 2270 NAME "Obstbaumplantage"2220 #- NAME "Obstbaumplantage" 2271 2221 EXPRESSION "3452" 2272 2222 STYLE … … 2279 2229 END 2280 2230 CLASS 2281 NAME "Nadelwald"2231 #- NAME "Nadelwald" 2282 2232 EXPRESSION "3460" 2283 2233 STYLE … … 2290 2240 END 2291 2241 CLASS 2292 NAME "Unland"2242 #- NAME "Unland" 2293 2243 EXPRESSION "3480" 2294 2244 STYLE … … 2301 2251 END 2302 2252 CLASS 2303 NAME "Mischwald"2253 #- NAME "Mischwald" 2304 2254 EXPRESSION "3462" 2305 2255 STYLE … … 2312 2262 END 2313 2263 CLASS 2314 NAME "Gras"2264 #- NAME "Gras" 2315 2265 EXPRESSION "3413" 2316 2266 STYLE … … 2323 2273 END 2324 2274 CLASS 2325 NAME "ZierflÀche"2275 #- NAME "ZierflÀche" 2326 2276 EXPRESSION "3605" 2327 2277 STYLE … … 2334 2284 END 2335 2285 CLASS 2336 NAME "Streuobstwiese"2286 #- NAME "Streuobstwiese" 2337 2287 EXPRESSION "3441" 2338 2288 STYLE … … 2345 2295 END 2346 2296 CLASS 2347 NAME "Laubwald"2297 #- NAME "Laubwald" 2348 2298 EXPRESSION "3458" 2349 2299 STYLE … … 2356 2306 END 2357 2307 CLASS 2358 NAME "Laubbaum"2308 #- NAME "Laubbaum" 2359 2309 EXPRESSION "3599" 2360 2310 STYLE … … 2367 2317 END 2368 2318 CLASS 2369 NAME "Heide"2319 #- NAME "Heide" 2370 2320 EXPRESSION "3474" 2371 2321 STYLE … … 2378 2328 END 2379 2329 CLASS 2380 NAME "Mischwald"2330 #- NAME "Mischwald" 2381 2331 EXPRESSION "3470" 2382 2332 STYLE … … 2389 2339 END 2390 2340 CLASS 2391 NAME "Busch, Hecke, Knick"2341 #- NAME "Busch, Hecke, Knick" 2392 2342 EXPRESSION "3601" 2393 2343 STYLE … … 2421 2371 UNITS METERS 2422 2372 CLASS 2423 NAME "Unterirdisches FlieÃgewÀsser"2373 #- NAME "Unterirdisches FlieÃgewÀsser" 2424 2374 EXPRESSION "3619" 2425 2375 STYLE … … 2432 2382 END 2433 2383 CLASS 2434 NAME "FlieÃgewÀsser"2384 #- NAME "FlieÃgewÀsser" 2435 2385 EXPRESSION "3488" 2436 2386 STYLE … … 2443 2393 END 2444 2394 CLASS 2445 NAME "GewÀsser"2395 #- NAME "GewÀsser" 2446 2396 EXPRESSION "3490" 2447 2397 STYLE … … 2454 2404 END 2455 2405 CLASS 2456 NAME "Quelle"2406 #- NAME "Quelle" 2457 2407 EXPRESSION "3613" 2458 2408 STYLE … … 2476 2426 END 2477 2427 CLASS 2478 NAME "FlieÃgewÀsser, nicht stÀndig Wasser fÃŒhrend"2428 #- NAME "FlieÃgewÀsser, nicht stÀndig Wasser fÃŒhrend" 2479 2429 EXPRESSION "3621" 2480 2430 STYLE … … 2508 2458 UNITS METERS 2509 2459 CLASS 2510 NAME "Tankstelle"2460 #- NAME "Tankstelle" 2511 2461 EXPRESSION "3401" 2512 2462 STYLE … … 2519 2469 END 2520 2470 CLASS 2521 NAME "Umformer"2471 #- NAME "Umformer" 2522 2472 EXPRESSION "3521" 2523 2473 STYLE … … 2530 2480 END 2531 2481 CLASS 2532 NAME "Antenne / Funkmast"2482 #- NAME "Antenne / Funkmast" 2533 2483 EXPRESSION "3506" 2534 2484 STYLE … … 2541 2491 END 2542 2492 CLASS 2543 NAME "VorratsbehÀlter"2493 #- NAME "VorratsbehÀlter" 2544 2494 EXPRESSION "3522" 2545 2495 STYLE … … 2552 2502 END 2553 2503 CLASS 2554 NAME "Schornstein, Schlot, Esse"2504 #- NAME "Schornstein, Schlot, Esse" 2555 2505 EXPRESSION "3508" 2556 2506 STYLE … … 2563 2513 END 2564 2514 CLASS 2565 NAME "Mast"2515 #- NAME "Mast" 2566 2516 EXPRESSION "3504" 2567 2517 STYLE … … 2574 2524 END 2575 2525 CLASS 2576 NAME "Windrad"2526 #- NAME "Windrad" 2577 2527 EXPRESSION "3501" 2578 2528 STYLE … … 2585 2535 END 2586 2536 CLASS 2587 NAME "Laufkran, BrÃŒckenlaufkran"2537 #- NAME "Laufkran, BrÃŒckenlaufkran" 2588 2538 EXPRESSION "3514" 2589 2539 STYLE … … 2596 2546 END 2597 2547 CLASS 2598 NAME "Torf"2548 #- NAME "Torf" 2599 2549 EXPRESSION "3407" 2600 2550 STYLE … … 2628 2578 UNITS METERS 2629 2579 CLASS 2630 NAME "Spielplatz, Bolzplatz"2580 #- NAME "Spielplatz, Bolzplatz" 2631 2581 EXPRESSION "3423" 2632 2582 STYLE … … 2639 2589 END 2640 2590 CLASS 2641 NAME "Kleingarten"2591 #- NAME "Kleingarten" 2642 2592 EXPRESSION "3419" 2643 2593 STYLE … … 2650 2600 END 2651 2601 CLASS 2652 NAME "Garten"2602 #- NAME "Garten" 2653 2603 EXPRESSION "3421" 2654 2604 STYLE … … 2661 2611 END 2662 2612 CLASS 2663 NAME "Rasen"2613 #- NAME "Rasen" 2664 2614 EXPRESSION "3413" 2665 2615 STYLE … … 2672 2622 END 2673 2623 CLASS 2674 NAME "Park"2624 #- NAME "Park" 2675 2625 EXPRESSION "3415" 2676 2626 STYLE … … 2683 2633 END 2684 2634 CLASS 2685 NAME "Campingplatz"2635 #- NAME "Campingplatz" 2686 2636 EXPRESSION "3412" 2687 2637 STYLE … … 2715 2665 UNITS METERS 2716 2666 CLASS 2717 NAME "Felsen, Felsblock, Felsnadel"2667 #- NAME "Felsen, Felsblock, Felsnadel" 2718 2668 EXPRESSION "3627" 2719 2669 STYLE … … 2726 2676 END 2727 2677 CLASS 2728 NAME "Busch, Hecke, Knick"2678 #- NAME "Busch, Hecke, Knick" 2729 2679 EXPRESSION "3601" 2730 2680 STYLE … … 2738 2688 ## Diese Class macht Stress ! 2739 2689 # CLASS 2740 # NAME "Busch, Hecke, Knick"2690 # #- NAME "Busch, Hecke, Knick" 2741 2691 # EXPRESSION "3632" 2742 2692 # STYLE … … 2754 2704 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2755 2705 CONNECTIONTYPE POSTGIS 2756 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2706 # links-/rechtsbÃŒndig getauscht: 2707 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='FlurstÃŒcke' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer IN ('ax_flurstueck_nummer','ax_flurstueck_zuordnung','ax_flurstueck_zuordnung_pfeil')) AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2757 2708 #EXTENT ... 2758 2709 LABELITEM "text" … … 2760 2711 METADATA 2761 2712 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2762 wms_layer_group "/FlurstÃŒcke/Nummern" 2763 wms_title "Beschriftungen (Punkte)" 2713 # wms_layer_group "/FlurstÃŒcke/Nummern" 2714 wms_layer_group "/FlurstÃŒcke" 2715 # wms_title "Beschriftungen (Punkte)" 2716 wms_title "Beschriftungen" 2764 2717 END 2765 2718 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2792 2745 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2793 2746 CONNECTIONTYPE POSTGIS 2794 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2747 # links-/rechtsbÃŒndig getauscht: 2748 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GebÀude' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND (layer<>'ax_lagebezeichnungmitpseudonummer') AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2795 2749 #EXTENT ... 2796 2750 LABELITEM "text" … … 2799 2753 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2800 2754 wms_layer_group "/GebÀude" 2801 wms_title "Beschriftungen (Punkte)" 2755 # wms_title "Beschriftungen (Punkte)" 2756 wms_title "Beschriftungen" 2802 2757 END 2803 2758 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2834 2789 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2835 2790 CONNECTIONTYPE POSTGIS 2836 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2791 # links-/rechtsbÃŒndig getauscht: 2792 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Lagebezeichnungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2837 2793 #EXTENT ... 2838 2794 LABELITEM "text" … … 2841 2797 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2842 2798 wms_layer_group "/Lagebezeichnungen" 2843 wms_title "Beschriftungen (Punkte)" 2799 # wms_title "Beschriftungen (Punkte)" 2800 wms_title "Beschriftungen" 2844 2801 END 2845 2802 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2872 2829 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2873 2830 CONNECTIONTYPE POSTGIS 2874 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2831 # links-/rechtsbÃŒndig getauscht: 2832 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Rechtliche Festlegungen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2875 2833 #EXTENT ... 2876 2834 LABELITEM "text" … … 2879 2837 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2880 2838 wms_layer_group "/Rechtliche Festlegungen" 2881 wms_title "Beschriftungen (Punkte)" 2839 # wms_title "Beschriftungen (Punkte)" 2840 wms_title "Beschriftungen" 2882 2841 END 2883 2842 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2910 2869 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2911 2870 CONNECTIONTYPE POSTGIS 2912 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2871 # links-/rechtsbÃŒndig getauscht: 2872 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Verkehr' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2913 2873 #EXTENT ... 2914 2874 LABELITEM "text" … … 2917 2877 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2918 2878 wms_layer_group "/Verkehr" 2919 wms_title "Beschriftungen (Punkte)" 2879 # wms_title "Beschriftungen (Punkte)" 2880 wms_title "Beschriftungen" 2920 2881 END 2921 2882 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2948 2909 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2949 2910 CONNECTIONTYPE POSTGIS 2950 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2911 # Lins-/rechtsbÃŒndig getauscht: 2912 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Friedhöfe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2951 2913 #EXTENT ... 2952 2914 LABELITEM "text" … … 2955 2917 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2956 2918 wms_layer_group "/Friedhöfe" 2957 wms_title "Beschriftungen (Punkte)" 2919 # wms_title "Beschriftungen (Punkte)" 2920 wms_title "Beschriftungen" 2958 2921 END 2959 2922 PROCESSING "CLOSE_CONNECTION=DEFER" … … 2986 2949 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 2987 2950 CONNECTIONTYPE POSTGIS 2988 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2951 # links-/rechtsbÃŒndig getauscht: 2952 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Vegetation' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2989 2953 #EXTENT ... 2990 2954 LABELITEM "text" … … 2993 2957 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 2994 2958 wms_layer_group "/Vegetation" 2995 wms_title "Beschriftungen (Punkte)" 2959 # wms_title "Beschriftungen (Punkte)" 2960 wms_title "Beschriftungen" 2996 2961 END 2997 2962 PROCESSING "CLOSE_CONNECTION=DEFER" … … 3024 2989 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3025 2990 CONNECTIONTYPE POSTGIS 3026 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 2991 # links-/rechtsbÃŒndig getauscht: 2992 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='GewÀsser' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3027 2993 #EXTENT ... 3028 2994 LABELITEM "text" … … 3031 2997 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3032 2998 wms_layer_group "/GewÀsser" 3033 wms_title "Beschriftungen (Punkte)" 2999 # wms_title "Beschriftungen (Punkte)" 3000 wms_title "Beschriftungen" 3034 3001 END 3035 3002 PROCESSING "CLOSE_CONNECTION=DEFER" … … 3062 3029 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3063 3030 CONNECTIONTYPE POSTGIS 3064 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3031 # links-/rechtsbÃŒndig getauscht: 3032 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Industrie und Gewerbe' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3065 3033 #EXTENT ... 3066 3034 LABELITEM "text" … … 3069 3037 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3070 3038 wms_layer_group "/Industrie und Gewerbe" 3071 wms_title "Beschriftungen (Punkte)" 3039 # wms_title "Beschriftungen (Punkte)" 3040 wms_title "Beschriftungen" 3072 3041 END 3073 3042 PROCESSING "CLOSE_CONNECTION=DEFER" … … 3100 3069 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3101 3070 CONNECTIONTYPE POSTGIS 3102 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3071 # links-/rechtsbÃŒndig getauscht: 3072 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Sport und Freizeit' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3103 3073 #EXTENT ... 3104 3074 LABELITEM "text" … … 3107 3077 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3108 3078 wms_layer_group "/Sport und Freizeit" 3109 wms_title "Beschriftungen (Punkte)" 3079 # wms_title "Beschriftungen (Punkte)" 3080 wms_title "Beschriftungen" 3110 3081 END 3111 3082 PROCESSING "CLOSE_CONNECTION=DEFER" … … 3138 3109 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3139 3110 CONNECTIONTYPE POSTGIS 3140 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3111 # links-/rechtsbÃŒndig getauscht: 3112 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='WohnbauflÀchen' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3141 3113 #EXTENT ... 3142 3114 LABELITEM "text" … … 3145 3117 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3146 3118 wms_layer_group "/WohnbauflÀchen" 3147 wms_title "Beschriftungen (Punkte)" 3119 # wms_title "Beschriftungen (Punkte)" 3120 wms_title "Beschriftungen" 3148 3121 END 3149 3122 PROCESSING "CLOSE_CONNECTION=DEFER" … … 3176 3149 CONNECTION "dbname='alkis*gkz*' host=10.0.100.73 port=5432 user='ms6'" 3177 3150 CONNECTIONTYPE POSTGIS 3178 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'L' WHEN 'rechtsbÃŒndig' THEN 'R' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND point IS NOT NULL AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3151 # Hinweis: rechts-/linksbÃŒndig sind vertauscht wenn von QGIS generiert. Und "Not Null" ist doppelt. 3152 DATA "geom FROM (SELECT ogc_fid,gml_id,text,f.umn AS color_umn,lower(art) || coalesce('-'||effekt,'') ||CASE WHEN stil='Kursiv' THEN '-italic' WHEN stil='Fett' THEN '-bold' WHEN stil='Fett, Kursiv' THEN '-bold-italic' ELSE '' END || CASE WHEN coalesce(fontsperrung,0)=0 THEN '' ELSE '-'||(fontsperrung/0.25)::int END AS font_umn,0.25/0.0254*skalierung*grad_pt AS size_umn,CASE coalesce(l.vertikaleausrichtung,s.vertikaleausrichtung) WHEN 'oben' THEN 'L' WHEN 'Basis' THEN 'U' ELSE 'C' END || CASE coalesce(l.horizontaleausrichtung,s.horizontaleausrichtung) WHEN 'linksbÃŒndig' THEN 'R' WHEN 'rechtsbÃŒndig' THEN 'L' ELSE 'C' END AS position_umn,drehwinkel_grad,point AS geom FROM po_labels l JOIN alkis_schriften s ON s.signaturnummer=l.signaturnummer AND s.katalog=2 JOIN alkis_farben f ON s.farbe=f.id WHERE thema='Topographie' AND modell && ARRAY['DLKM','DKKM1000']::varchar[] AND NOT point IS NULL) AS foo USING UNIQUE ogc_fid USING SRID=25832" 3179 3153 #EXTENT ... 3180 3154 LABELITEM "text" … … 3183 3157 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004 EPSG:3034 EPSG:3857" 3184 3158 wms_layer_group "/Topographie" 3185 wms_title "Beschriftungen (Punkte)" 3159 # wms_title "Beschriftungen (Punkte)" 3160 wms_title "Beschriftungen" 3186 3161 END 3187 3162 PROCESSING "CLOSE_CONNECTION=DEFER"
Note: See TracChangeset
for help on using the changeset viewer.