Changeset 163 for trunk/data/umn/alkis07/alkis07_muster_4.map
- Timestamp:
- 02/17/12 14:57:42 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/umn/alkis07/alkis07_muster_4.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 MAP … … 47 48 END 48 49 50 51 # ** aus Post-Processing: Katasterbezirke 52 53 LAYER 54 NAME "pp_gemeinde" 55 GROUP "pp_gebiete" 56 TYPE POLYGON 57 DUMP true 58 CONNECTIONTYPE POSTGIS 59 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 60 DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 61 METADATA 62 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 63 wms_title "Gemeinde" 64 wms_abstract "GemeindeflÀche (vereinfachte Geometrie)" 65 wms_group_title "Gebiete" 66 wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden" 67 gml_include_items "all" 68 END 69 PROJECTION 70 "init=epsg:25832" 71 END 72 EXTENT 349000 5529000 356000 5533000 73 MINSCALEDENOM 2000 #8000 74 MAXSCALEDENOM 100000 #400000 75 LABELITEM gemeindename 76 CLASS 77 NAME "Gemeinde" 78 STYLE 79 OUTLINECOLOR 10 10 200 80 WIDTH 28 #7 81 PATTERN 32 88 END # 8 22 82 END 83 LABEL 84 TYPE TRUETYPE 85 COLOR 10 10 200 86 FONT "arial" 87 SIZE 80 # 20 88 POSITION cc 89 OFFSET 0 -80 # 0 -20 90 PARTIALS FALSE 91 FORCE FALSE 92 END 93 END 94 END 95 96 LAYER 97 NAME "pp_gemarkung" 98 GROUP "pp_gebiete" 99 TYPE POLYGON 100 #DUMP true 101 CONNECTIONTYPE POSTGIS 102 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 103 DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 104 METADATA 105 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 106 wms_title "Gemarkung" 107 wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)" 108 #gml_include_items "all" 109 END 110 PROJECTION 111 "init=epsg:25832" 112 END 113 EXTENT 349000 5529000 356000 5533000 114 MINSCALEDENOM 1000 #4000 115 MAXSCALEDENOM 10000 #40000 116 LABELITEM gemarkungsname 117 CLASS 118 NAME "Gemarkung" 119 STYLE 120 OUTLINECOLOR 140 80 0 121 WIDTH 20 #5 122 PATTERN 12 48 END #3 12 123 END 124 LABEL 125 TYPE TRUETYPE 126 COLOR 140 80 0 127 FONT "arial" 128 SIZE 64 #16 129 POSITION cc 130 OFFSET 0 40 # 0 10 131 PARTIALS FALSE 132 FORCE FALSE 133 END 134 END 135 END 136 137 LAYER 138 NAME "pp_flur" 139 GROUP "pp_gebiete" 140 TYPE POLYGON 141 #DUMP true 142 CONNECTIONTYPE POSTGIS 143 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 144 DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 145 METADATA 146 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 147 wms_title "Flur" 148 wms_abstract "Flur" 149 #gml_include_items "all" 150 END 151 PROJECTION 152 "init=epsg:25832" 153 END 154 EXTENT 349000 5529000 356000 5533000 155 MINSCALEDENOM 400 #1600 156 MAXSCALEDENOM 5000 #20000 157 LABELITEM flurnummer 158 CLASS 159 NAME "Flur" 160 STYLE 161 OUTLINECOLOR 100 150 10 162 WIDTH 12 #3 163 PATTERN 2 32 END # 1 8 164 END 165 LABEL 166 TYPE TRUETYPE 167 COLOR 100 150 10 168 FONT "arial" 169 SIZE 56 #14 170 POSITION cc 171 PARTIALS FALSE 172 FORCE FALSE 173 END 174 END 175 END 176 49 177 LAYER 50 178 NAME "nutzung_alle" 51 179 TYPE POLYGON 52 DUMP TRUE53 CONNECTIONTYPE POSTGIS 54 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"180 #DUMP TRUE 181 CONNECTIONTYPE POSTGIS 182 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 55 183 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 56 184 METADATA … … 58 186 wms_title "alle Nutzungsarten" 59 187 wms_abstract "Zusammenfassung aller Nutzungsarten-FlÀchen" 60 gml_include_items "all"188 #gml_include_items "all" 61 189 END 62 190 PROJECTION … … 346 474 REQUIRES "![nutzung_alle]" 347 475 CONNECTIONTYPE POSTGIS 348 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"476 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 349 477 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 350 478 METADATA … … 378 506 REQUIRES "![nutzung_alle]" 379 507 CONNECTIONTYPE POSTGIS 380 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"508 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 381 509 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 382 510 METADATA … … 410 538 REQUIRES "![nutzung_alle]" 411 539 CONNECTIONTYPE POSTGIS 412 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"540 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 413 541 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 414 542 METADATA … … 440 568 REQUIRES "![nutzung_alle]" 441 569 CONNECTIONTYPE POSTGIS 442 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"570 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 443 571 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 444 572 METADATA … … 469 597 REQUIRES "![nutzung_alle]" 470 598 CONNECTIONTYPE POSTGIS 471 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"599 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 472 600 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 473 601 METADATA … … 499 627 REQUIRES "![nutzung_alle]" 500 628 CONNECTIONTYPE POSTGIS 501 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"629 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 502 630 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 503 631 METADATA … … 531 659 REQUIRES "![nutzung_alle]" 532 660 CONNECTIONTYPE POSTGIS 533 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"661 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 534 662 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 535 663 METADATA … … 561 689 REQUIRES "![nutzung_alle]" 562 690 CONNECTIONTYPE POSTGIS 563 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"691 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 564 692 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 565 693 METADATA … … 592 720 REQUIRES "![nutzung_alle]" 593 721 CONNECTIONTYPE POSTGIS 594 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"722 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 595 723 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 596 724 METADATA … … 626 754 REQUIRES "![nutzung_alle]" 627 755 CONNECTIONTYPE POSTGIS 628 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"756 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 629 757 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 630 758 METADATA … … 689 817 REQUIRES "![nutzung_alle]" 690 818 CONNECTIONTYPE POSTGIS 691 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"819 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 692 820 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 693 821 METADATA … … 719 847 REQUIRES "![nutzung_alle]" 720 848 CONNECTIONTYPE POSTGIS 721 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"849 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 722 850 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 723 851 METADATA … … 757 885 REQUIRES "![nutzung_alle]" 758 886 CONNECTIONTYPE POSTGIS 759 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"887 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 760 888 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 761 889 METADATA … … 788 916 REQUIRES "![nutzung_alle]" 789 917 CONNECTIONTYPE POSTGIS 790 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"918 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 791 919 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 792 920 METADATA … … 819 947 REQUIRES "![nutzung_alle]" 820 948 CONNECTIONTYPE POSTGIS 821 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"949 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 822 950 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 823 951 METADATA … … 852 980 REQUIRES "![nutzung_alle]" 853 981 CONNECTIONTYPE POSTGIS 854 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"982 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 855 983 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 856 984 METADATA … … 901 1029 TYPE POLYGON 902 1030 CONNECTIONTYPE POSTGIS 903 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1031 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 904 1032 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 905 1033 METADATA … … 929 1057 TYPE POLYGON 930 1058 CONNECTIONTYPE POSTGIS 931 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1059 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 932 1060 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 933 1061 METADATA … … 957 1085 TYPE POLYGON 958 1086 CONNECTIONTYPE POSTGIS 959 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1087 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 960 1088 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 961 1089 METADATA … … 985 1113 TYPE POLYGON 986 1114 CONNECTIONTYPE POSTGIS 987 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1115 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 988 1116 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 989 1117 METADATA … … 1013 1141 TYPE POLYGON 1014 1142 CONNECTIONTYPE POSTGIS 1015 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1143 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1016 1144 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1017 1145 METADATA … … 1044 1172 REQUIRES "![nutzung_alle]" 1045 1173 CONNECTIONTYPE POSTGIS 1046 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1174 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1047 1175 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1048 1176 METADATA … … 1073 1201 REQUIRES "![nutzung_alle]" 1074 1202 CONNECTIONTYPE POSTGIS 1075 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1203 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1076 1204 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1077 1205 METADATA … … 1104 1232 REQUIRES "![nutzung_alle]" 1105 1233 CONNECTIONTYPE POSTGIS 1106 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1234 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1107 1235 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1108 1236 METADATA … … 1133 1261 REQUIRES "![nutzung_alle]" 1134 1262 CONNECTIONTYPE POSTGIS 1135 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1263 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1136 1264 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1137 1265 METADATA … … 1162 1290 REQUIRES "![nutzung_alle]" 1163 1291 CONNECTIONTYPE POSTGIS 1164 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1292 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1165 1293 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1166 1294 METADATA … … 1196 1324 #DUMP TRUE # _4 1197 1325 CONNECTIONTYPE POSTGIS 1198 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1326 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1199 1327 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1200 1328 # Feld funktion, Werte 1010, 1030, 1040 … … 1230 1358 #DUMP TRUE # _4 1231 1359 CONNECTIONTYPE POSTGIS 1232 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1360 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1233 1361 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1234 1362 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1264 1392 #DUMP TRUE # _4 1265 1393 CONNECTIONTYPE POSTGIS 1266 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1394 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1267 1395 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1268 1396 METADATA … … 1309 1437 #DUMP TRUE # _4 1310 1438 CONNECTIONTYPE POSTGIS 1311 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1439 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1312 1440 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1313 1441 METADATA … … 1339 1467 #DUMP TRUE # _4 1340 1468 CONNECTIONTYPE POSTGIS 1341 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1469 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1342 1470 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1343 1471 METADATA … … 1374 1502 TYPE POLYGON 1375 1503 CONNECTIONTYPE POSTGIS 1376 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1504 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1377 1505 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 1378 1506 METADATA … … 1477 1605 #DUMP TRUE # _4 1478 1606 CONNECTIONTYPE POSTGIS 1479 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1607 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1480 1608 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1481 1609 METADATA … … 1506 1634 #DUMP TRUE # _4 1507 1635 CONNECTIONTYPE POSTGIS 1508 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1636 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1509 1637 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 1510 1638 METADATA … … 1539 1667 TYPE POLYGON 1540 1668 CONNECTIONTYPE POSTGIS 1541 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1669 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1542 1670 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" 1543 1671 METADATA … … 1878 2006 TYPE POLYGON 1879 2007 CONNECTIONTYPE POSTGIS 1880 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2008 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1881 2009 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" 1882 2010 METADATA … … 2002 2130 #DUMP TRUE # _4 2003 2131 CONNECTIONTYPE POSTGIS 2004 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2132 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2005 2133 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2006 2134 METADATA … … 2066 2194 #DUMP TRUE # _4 2067 2195 CONNECTIONTYPE POSTGIS 2068 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2196 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2069 2197 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2070 2198 METADATA … … 2101 2229 #DUMP TRUE # _4 2102 2230 CONNECTIONTYPE POSTGIS 2103 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2231 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2104 2232 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2105 2233 METADATA … … 2151 2279 DUMP TRUE 2152 2280 CONNECTIONTYPE POSTGIS 2153 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2281 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2154 2282 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 2155 2283 METADATA … … 2202 2330 DUMP TRUE 2203 2331 CONNECTIONTYPE POSTGIS 2204 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2332 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2205 2333 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2206 2334 … … 2235 2363 #DUMP TRUE # _4 2236 2364 CONNECTIONTYPE POSTGIS 2237 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2365 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2238 2366 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2239 2367 METADATA … … 2267 2395 #DUMP TRUE # _4 2268 2396 CONNECTIONTYPE POSTGIS 2269 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2397 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2270 2398 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2271 2399 METADATA … … 2297 2425 #DUMP TRUE # _4 2298 2426 CONNECTIONTYPE POSTGIS 2299 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2427 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2300 2428 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2301 2429 METADATA … … 2327 2455 #DUMP TRUE # _4 2328 2456 CONNECTIONTYPE POSTGIS 2329 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2457 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2330 2458 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2331 2459 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2368 2496 #DUMP TRUE # _4 2369 2497 CONNECTIONTYPE POSTGIS 2370 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2498 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2371 2499 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2372 2500 METADATA … … 2398 2526 #DUMP TRUE # _4 2399 2527 CONNECTIONTYPE POSTGIS 2400 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2528 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2401 2529 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2402 2530 METADATA … … 2427 2555 TYPE POLYGON 2428 2556 CONNECTIONTYPE POSTGIS 2429 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2557 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2430 2558 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 2431 2559 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2467 2595 #DUMP TRUE # _4 2468 2596 CONNECTIONTYPE POSTGIS 2469 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2597 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2470 2598 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 2471 2599 METADATA … … 2507 2635 #DUMP TRUE # _4 2508 2636 CONNECTIONTYPE POSTGIS 2509 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2637 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2510 2638 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 2511 2639 METADATA … … 2552 2680 #DUMP TRUE # _4 2553 2681 CONNECTIONTYPE POSTGIS 2554 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2682 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2555 2683 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 2556 2684 METADATA … … 2586 2714 TYPE POLYGON 2587 2715 CONNECTIONTYPE POSTGIS 2588 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2716 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2589 2717 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" 2590 2718 METADATA … … 2618 2746 #DUMP TRUE # _4 2619 2747 CONNECTIONTYPE POSTGIS 2620 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2748 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2621 2749 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 2622 2750 METADATA … … 2749 2877 #DUMP TRUE # _4 2750 2878 CONNECTIONTYPE POSTGIS 2751 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2879 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2752 2880 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 2753 2881 METADATA … … 2802 2930 #DUMP TRUE # _4 2803 2931 CONNECTIONTYPE POSTGIS 2804 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2932 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2805 2933 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2806 2934 METADATA … … 2835 2963 STATUS ON 2836 2964 CONNECTIONTYPE POSTGIS 2837 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2965 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2838 2966 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 2839 2967 METADATA … … 2873 3001 #DUMP TRUE # _4 2874 3002 CONNECTIONTYPE POSTGIS 2875 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3003 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2876 3004 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 2877 3005 METADATA … … 2914 3042 #DUMP TRUE # _4 2915 3043 CONNECTIONTYPE POSTGIS 2916 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3044 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2917 3045 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 2918 3046 METADATA … … 2946 3074 #DUMP TRUE # _4 2947 3075 CONNECTIONTYPE POSTGIS 2948 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3076 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2949 3077 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 2950 3078 METADATA … … 2979 3107 #DUMP TRUE # _4 2980 3108 CONNECTIONTYPE POSTGIS 2981 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3109 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2982 3110 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 2983 3111 METADATA … … 3012 3140 #DUMP TRUE # _4 3013 3141 CONNECTIONTYPE POSTGIS 3014 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3142 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3015 3143 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3016 3144 METADATA … … 3042 3170 #DUMP TRUE # _4 3043 3171 CONNECTIONTYPE POSTGIS 3044 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3172 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3045 3173 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3046 3174 METADATA … … 3081 3209 #DUMP TRUE # _4 3082 3210 CONNECTIONTYPE POSTGIS 3083 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3211 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3084 3212 3085 3213 #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" … … 3130 3258 TYPE LINE 3131 3259 CONNECTIONTYPE POSTGIS 3132 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3260 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3133 3261 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3134 3262 METADATA … … 3188 3316 #SYMBOLSCALEDENOM 1000 3189 3317 CONNECTIONTYPE POSTGIS 3190 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3318 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3191 3319 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 3192 3320 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 3268 3396 SYMBOLSCALEDENOM 250 # 1000 3269 3397 CONNECTIONTYPE POSTGIS 3270 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3398 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3271 3399 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 3272 3400 CLASS … … 3304 3432 SYMBOLSCALEDENOM 250 #1000 3305 3433 CONNECTIONTYPE POSTGIS 3306 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3434 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3307 3435 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 3308 3436 CLASS
Note: See TracChangeset
for help on using the changeset viewer.