Changeset 163 for trunk/data/umn/alkis07/alkis07_muster.map
- Timestamp:
- 02/17/12 14:57:42 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/umn/alkis07/alkis07_muster.map
r160 r163 4 4 5 5 # 2012-02-09 F.J. krz Branch 0.7 aus Version 0.6 6 # 2012-02-17 F.J. krz data dbname=alkis07, Layer-Group pp_gebiete 6 7 7 8 # ToDo: … … 61 62 END 62 63 63 # ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetaion) 64 65 # ** aus Post-Processing: Katasterbezirke 66 67 # Die Layer dieser Gruppe nur anzeigen lassen, wenn der Inhalt der Datenbenk einen ganzen Katasterbezirk enthÀlt. 68 # Wenn ein Gebiet durch geometrische Filter im NBA ausgegeben wurde, dann gibt es Randstreifen, 69 # die zu Pseudo-Fluren zusammen gefasst werden. Fachlich falsch! 70 71 LAYER 72 NAME "pp_gemeinde" 73 GROUP "pp_gebiete" 74 TYPE POLYGON 75 DUMP true 76 CONNECTIONTYPE POSTGIS 77 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 78 DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 79 METADATA 80 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 81 wms_title "Gemeinde" 82 wms_abstract "GemeindeflÀche (vereinfachte Geometrie)" 83 wms_group_title "Gebiete" 84 wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden" 85 gml_include_items "all" 86 END 87 PROJECTION 88 "init=epsg:25832" 89 END 90 EXTENT 349000 5529000 356000 5533000 91 MINSCALEDENOM 8000 92 MAXSCALEDENOM 400000 93 LABELITEM gemeindename 94 CLASS 95 NAME "Gemeinde" 96 STYLE 97 OUTLINECOLOR 10 10 200 98 WIDTH 7 99 PATTERN 8 22 END 100 END 101 LABEL 102 TYPE TRUETYPE 103 COLOR 10 10 200 104 FONT "arial" 105 SIZE 20 106 POSITION cc 107 OFFSET 0 -20 108 PARTIALS FALSE 109 FORCE FALSE 110 END 111 END 112 END 113 114 LAYER 115 NAME "pp_gemarkung" 116 GROUP "pp_gebiete" 117 TYPE POLYGON 118 DUMP true 119 CONNECTIONTYPE POSTGIS 120 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 121 DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 122 METADATA 123 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 124 wms_title "Gemarkung" 125 wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)" 126 gml_include_items "all" 127 END 128 PROJECTION 129 "init=epsg:25832" 130 END 131 EXTENT 349000 5529000 356000 5533000 132 MINSCALEDENOM 4000 133 MAXSCALEDENOM 40000 134 LABELITEM gemarkungsname 135 CLASS 136 NAME "Gemarkung" 137 STYLE 138 OUTLINECOLOR 140 80 0 139 WIDTH 5 140 PATTERN 3 12 END 141 END 142 LABEL 143 TYPE TRUETYPE 144 COLOR 140 80 0 145 FONT "arial" 146 SIZE 16 147 POSITION cc 148 OFFSET 0 10 149 PARTIALS FALSE 150 FORCE FALSE 151 END 152 END 153 END 154 155 LAYER 156 NAME "pp_flur" 157 GROUP "pp_gebiete" 158 TYPE POLYGON 159 DUMP true 160 CONNECTIONTYPE POSTGIS 161 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 162 DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 163 METADATA 164 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 165 wms_title "Flur" 166 wms_abstract "Flur" 167 gml_include_items "all" 168 END 169 PROJECTION 170 "init=epsg:25832" 171 END 172 EXTENT 349000 5529000 356000 5533000 173 MINSCALEDENOM 1600 174 MAXSCALEDENOM 20000 175 CLASS 176 NAME "Flur" 177 TEXT "Flur [flurnummer]" 178 STYLE 179 OUTLINECOLOR 100 150 10 180 WIDTH 3 181 PATTERN 1 8 END 182 END 183 184 #STYLE # fuer TEST Flaechendeckung? 185 # COLOR 100 150 10 186 # SYMBOL "sn3631" 187 # SIZE 10 188 #END 189 190 LABEL 191 TYPE TRUETYPE 192 COLOR 100 150 10 193 FONT "arial" 194 SIZE 14 195 POSITION cc 196 PARTIALS FALSE 197 FORCE FALSE 198 END 199 END 200 END 201 202 203 # ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetation) 64 204 # alle Layer von GROUP "ax_nutzungen" 65 205 … … 110 250 DUMP TRUE 111 251 CONNECTIONTYPE POSTGIS 112 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"252 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 113 253 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 114 254 METADATA … … 258 398 NAME "Platz" 259 399 STYLE 260 # COLOR -1 -1 -1 #?261 400 OUTLINECOLOR 153 153 153 262 401 END … … 518 657 REQUIRES "![nutzung_alle]" 519 658 CONNECTIONTYPE POSTGIS 520 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"659 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 521 660 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 522 661 METADATA … … 550 689 REQUIRES "![nutzung_alle]" 551 690 CONNECTIONTYPE POSTGIS 552 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"691 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 553 692 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 554 693 METADATA … … 582 721 REQUIRES "![nutzung_alle]" 583 722 CONNECTIONTYPE POSTGIS 584 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"723 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 585 724 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 586 725 METADATA … … 612 751 REQUIRES "![nutzung_alle]" 613 752 CONNECTIONTYPE POSTGIS 614 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"753 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 615 754 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 616 755 METADATA … … 641 780 REQUIRES "![nutzung_alle]" 642 781 CONNECTIONTYPE POSTGIS 643 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"782 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 644 783 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 645 784 METADATA … … 671 810 REQUIRES "![nutzung_alle]" 672 811 CONNECTIONTYPE POSTGIS 673 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"812 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 674 813 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 675 814 METADATA … … 703 842 REQUIRES "![nutzung_alle]" 704 843 CONNECTIONTYPE POSTGIS 705 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"844 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 706 845 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 707 846 METADATA … … 733 872 REQUIRES "![nutzung_alle]" 734 873 CONNECTIONTYPE POSTGIS 735 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"874 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 736 875 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 737 876 METADATA … … 764 903 REQUIRES "![nutzung_alle]" 765 904 CONNECTIONTYPE POSTGIS 766 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"905 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 767 906 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 768 907 METADATA … … 798 937 REQUIRES "![nutzung_alle]" 799 938 CONNECTIONTYPE POSTGIS 800 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"939 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 801 940 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 802 941 METADATA … … 861 1000 REQUIRES "![nutzung_alle]" 862 1001 CONNECTIONTYPE POSTGIS 863 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1002 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 864 1003 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 865 1004 METADATA … … 891 1030 REQUIRES "![nutzung_alle]" 892 1031 CONNECTIONTYPE POSTGIS 893 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1032 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 894 1033 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 895 1034 METADATA … … 929 1068 REQUIRES "![nutzung_alle]" 930 1069 CONNECTIONTYPE POSTGIS 931 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1070 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 932 1071 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 933 1072 METADATA … … 960 1099 REQUIRES "![nutzung_alle]" 961 1100 CONNECTIONTYPE POSTGIS 962 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1101 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 963 1102 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 964 1103 METADATA … … 991 1130 REQUIRES "![nutzung_alle]" 992 1131 CONNECTIONTYPE POSTGIS 993 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1132 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 994 1133 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 995 1134 METADATA … … 1024 1163 REQUIRES "![nutzung_alle]" 1025 1164 CONNECTIONTYPE POSTGIS 1026 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1165 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1027 1166 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 1028 1167 METADATA … … 1074 1213 REQUIRES "![nutzung_alle]" 1075 1214 CONNECTIONTYPE POSTGIS 1076 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1215 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1077 1216 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 1078 1217 METADATA … … 1103 1242 REQUIRES "![nutzung_alle]" 1104 1243 CONNECTIONTYPE POSTGIS 1105 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1244 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1106 1245 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 1107 1246 METADATA … … 1132 1271 REQUIRES "![nutzung_alle]" 1133 1272 CONNECTIONTYPE POSTGIS 1134 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1273 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1135 1274 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 1136 1275 METADATA … … 1161 1300 REQUIRES "![nutzung_alle]" 1162 1301 CONNECTIONTYPE POSTGIS 1163 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1302 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1164 1303 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 1165 1304 METADATA … … 1190 1329 REQUIRES "![nutzung_alle]" 1191 1330 CONNECTIONTYPE POSTGIS 1192 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1331 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1193 1332 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1194 1333 METADATA … … 1221 1360 REQUIRES "![nutzung_alle]" 1222 1361 CONNECTIONTYPE POSTGIS 1223 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1362 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1224 1363 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1225 1364 METADATA … … 1250 1389 REQUIRES "![nutzung_alle]" 1251 1390 CONNECTIONTYPE POSTGIS 1252 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1391 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1253 1392 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1254 1393 METADATA … … 1281 1420 REQUIRES "![nutzung_alle]" 1282 1421 CONNECTIONTYPE POSTGIS 1283 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1422 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1284 1423 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1285 1424 METADATA … … 1310 1449 REQUIRES "![nutzung_alle]" 1311 1450 CONNECTIONTYPE POSTGIS 1312 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1451 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1313 1452 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1314 1453 METADATA … … 1339 1478 REQUIRES "![nutzung_alle]" 1340 1479 CONNECTIONTYPE POSTGIS 1341 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1480 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1342 1481 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1343 1482 METADATA … … 1375 1514 # REQUIRES "![nutzung_alle]" 1376 1515 CONNECTIONTYPE POSTGIS 1377 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1516 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1378 1517 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1379 1518 # Feld funktion, Werte 1010, 1030, 1040 … … 1408 1547 DUMP TRUE 1409 1548 CONNECTIONTYPE POSTGIS 1410 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1549 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1411 1550 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1412 1551 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1443 1582 DUMP TRUE 1444 1583 CONNECTIONTYPE POSTGIS 1445 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1584 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1446 1585 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1447 1586 METADATA … … 1488 1627 DUMP TRUE 1489 1628 CONNECTIONTYPE POSTGIS 1490 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1629 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1491 1630 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1492 1631 METADATA … … 1521 1660 DUMP TRUE 1522 1661 CONNECTIONTYPE POSTGIS 1523 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1662 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1524 1663 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1525 1664 METADATA … … 1557 1696 DUMP TRUE 1558 1697 CONNECTIONTYPE POSTGIS 1559 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1698 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1560 1699 1561 1700 # Tabelle (Standard-Template) … … 1792 1931 DUMP TRUE 1793 1932 CONNECTIONTYPE POSTGIS 1794 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1933 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1795 1934 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1796 1935 METADATA … … 1821 1960 DUMP TRUE 1822 1961 CONNECTIONTYPE POSTGIS 1823 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1962 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1824 1963 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 1825 1964 METADATA … … 1864 2003 TYPE POLYGON 1865 2004 CONNECTIONTYPE POSTGIS 1866 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2005 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1867 2006 DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832" 1868 2007 # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das? … … 2222 2361 DUMP TRUE 2223 2362 CONNECTIONTYPE POSTGIS 2224 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2363 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2225 2364 DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude) as foo using unique ogc_fid using SRID=25832" 2226 2365 METADATA … … 2383 2522 DUMP TRUE 2384 2523 CONNECTIONTYPE POSTGIS 2385 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2524 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2386 2525 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2387 2526 METADATA … … 2451 2590 DUMP TRUE 2452 2591 CONNECTIONTYPE POSTGIS 2453 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2592 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2454 2593 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2455 2594 METADATA … … 2485 2624 DUMP TRUE 2486 2625 CONNECTIONTYPE POSTGIS 2487 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2626 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2488 2627 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2489 2628 … … 2533 2672 DUMP TRUE 2534 2673 CONNECTIONTYPE POSTGIS 2535 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2674 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2536 2675 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel, laufendenummer FROM s_nummer_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View 2537 2676 # "s_nummer_nebengebaeude" = View … … 2584 2723 DUMP TRUE 2585 2724 CONNECTIONTYPE POSTGIS 2586 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2725 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2587 2726 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2588 2727 … … 2617 2756 DUMP TRUE 2618 2757 CONNECTIONTYPE POSTGIS 2619 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2758 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2620 2759 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2621 2760 METADATA … … 2649 2788 DUMP TRUE 2650 2789 CONNECTIONTYPE POSTGIS 2651 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2790 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2652 2791 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2653 2792 METADATA … … 2681 2820 DUMP TRUE 2682 2821 CONNECTIONTYPE POSTGIS 2683 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2822 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2684 2823 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2685 2824 METADATA … … 2711 2850 DUMP TRUE 2712 2851 CONNECTIONTYPE POSTGIS 2713 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2852 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2714 2853 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2715 2854 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2752 2891 DUMP TRUE 2753 2892 CONNECTIONTYPE POSTGIS 2754 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2893 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2755 2894 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2756 2895 METADATA … … 2782 2921 DUMP TRUE 2783 2922 CONNECTIONTYPE POSTGIS 2784 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2923 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2785 2924 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2786 2925 METADATA … … 2812 2951 DUMP TRUE 2813 2952 CONNECTIONTYPE POSTGIS 2814 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2953 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2815 2954 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 2816 2955 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2884 3023 DUMP TRUE 2885 3024 CONNECTIONTYPE POSTGIS 2886 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3025 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2887 3026 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 2888 3027 METADATA … … 2924 3063 DUMP TRUE 2925 3064 CONNECTIONTYPE POSTGIS 2926 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3065 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2927 3066 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 2928 3067 METADATA … … 2971 3110 DUMP TRUE 2972 3111 CONNECTIONTYPE POSTGIS 2973 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3112 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2974 3113 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 2975 3114 METADATA … … 3006 3145 DUMP TRUE 3007 3146 CONNECTIONTYPE POSTGIS 3008 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3147 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3009 3148 # mit Feldern fuer klassisches Template: 3010 3149 # DATA "wkb_geometry from (SELECT ogc_fid, gml_id, flurstueckskennzeichen, amtlicheflaeche, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" … … 3051 3190 DUMP TRUE 3052 3191 CONNECTIONTYPE POSTGIS 3053 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3192 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3054 3193 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 3055 3194 METADATA … … 3191 3330 DUMP TRUE 3192 3331 CONNECTIONTYPE POSTGIS 3193 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3332 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3194 3333 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 3195 3334 # View: ap_pto >dientZurDarstellungVon> ax_flurstueck … … 3385 3524 TYPE LINE 3386 3525 CONNECTIONTYPE POSTGIS 3387 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3526 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3388 3527 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 3389 3528 METADATA … … 3415 3554 STATUS ON 3416 3555 CONNECTIONTYPE POSTGIS 3417 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3556 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3418 3557 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 3419 3558 METADATA … … 3453 3592 TYPE POINT 3454 3593 CONNECTIONTYPE POSTGIS 3455 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3594 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3456 3595 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 3457 3596 METADATA … … 3498 3637 DUMP TRUE 3499 3638 CONNECTIONTYPE POSTGIS 3500 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3639 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3501 3640 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 3502 3641 METADATA … … 3530 3669 DUMP TRUE 3531 3670 CONNECTIONTYPE POSTGIS 3532 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3671 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3533 3672 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 3534 3673 METADATA … … 3563 3702 DUMP TRUE 3564 3703 CONNECTIONTYPE POSTGIS 3565 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3704 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3566 3705 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 3567 3706 METADATA … … 3596 3735 DUMP TRUE 3597 3736 CONNECTIONTYPE POSTGIS 3598 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3737 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3599 3738 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3600 3739 METADATA … … 3626 3765 DUMP TRUE 3627 3766 CONNECTIONTYPE POSTGIS 3628 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3767 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3629 3768 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3630 3769 METADATA … … 3666 3805 DUMP TRUE 3667 3806 CONNECTIONTYPE POSTGIS 3668 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3807 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3669 3808 3670 3809 #DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832" … … 3775 3914 DUMP TRUE 3776 3915 CONNECTIONTYPE POSTGIS 3777 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3916 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3778 3917 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3779 3918 METADATA … … 3837 3976 #SYMBOLSCALEDENOM 1000 3838 3977 CONNECTIONTYPE POSTGIS 3839 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3978 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3840 3979 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 3841 3980 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 3917 4056 SYMBOLSCALEDENOM 1000 3918 4057 CONNECTIONTYPE POSTGIS 3919 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"4058 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3920 4059 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 3921 4060 CLASS … … 3953 4092 SYMBOLSCALEDENOM 1000 3954 4093 CONNECTIONTYPE POSTGIS 3955 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"4094 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3956 4095 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 3957 4096 CLASS
Note: See TracChangeset
for help on using the changeset viewer.