Changeset 335 for trunk/umn/alkis/alkis_muster_entw.map
- Timestamp:
- 09/16/14 16:07:01 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/umn/alkis/alkis_muster_entw.map
r330 r335 24 24 # 2014-08-25 F.J. krz StraÃennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra" 25 25 # 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel 26 # 2014-09-15 F.J. krz: Filter fÃŒr Historische Objekte "WHERE endet IS NULL" in DATA fÃŒr Tabellen ax_* 26 27 27 28 ### … … 75 76 FONTSET "fonts/fonts_alkis.fnt" 76 77 UNITS METERS 77 #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" # Nur fuer Test78 #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" 78 79 #DEBUG 3 79 80 WEB 80 81 METADATA 81 82 wms_title "ALKIS_" # TEST-Kennung im Title 82 ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile Entwicklungs-Version vom August2014"83 ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile Entwicklungs-Version vom September 2014" 83 84 ows_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 84 85 ows_encoding "UTF-8" … … 446 447 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 447 448 PROCESSING "CLOSE_CONNECTION=DEFER" 448 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche ) as foo using unique ogc_fid using SRID=25832"449 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 449 450 METADATA 450 451 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 474 475 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 475 476 PROCESSING "CLOSE_CONNECTION=DEFER" 476 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche ) as foo using unique ogc_fid using SRID=25832"477 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 477 478 METADATA 478 479 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 503 504 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 504 505 PROCESSING "CLOSE_CONNECTION=DEFER" 505 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832"506 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 506 507 METADATA 507 508 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 529 530 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 530 531 PROCESSING "CLOSE_CONNECTION=DEFER" 531 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb ) as foo using unique ogc_fid using SRID=25832"532 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 532 533 METADATA 533 534 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 554 555 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 555 556 PROCESSING "CLOSE_CONNECTION=DEFER" 556 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch ) as foo using unique ogc_fid using SRID=25832"557 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 557 558 METADATA 558 559 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 581 582 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 582 583 PROCESSING "CLOSE_CONNECTION=DEFER" 583 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung ) as foo using unique ogc_fid using SRID=25832"584 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 584 585 METADATA 585 586 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 610 611 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 611 612 PROCESSING "CLOSE_CONNECTION=DEFER" 612 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung ) as foo using unique ogc_fid using SRID=25832"613 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 613 614 METADATA 614 615 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 637 638 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 638 639 PROCESSING "CLOSE_CONNECTION=DEFER" 639 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche ) as foo using unique ogc_fid using SRID=25832"640 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 640 641 METADATA 641 642 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 665 666 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 666 667 PROCESSING "CLOSE_CONNECTION=DEFER" 667 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof ) as foo using unique ogc_fid using SRID=25832"668 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 668 669 METADATA 669 670 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 694 695 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 695 696 PROCESSING "CLOSE_CONNECTION=DEFER" 696 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr ) as foo using unique ogc_fid using SRID=25832"697 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 697 698 METADATA 698 699 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 754 755 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 755 756 PROCESSING "CLOSE_CONNECTION=DEFER" 756 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg ) as foo using unique ogc_fid using SRID=25832"757 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 757 758 METADATA 758 759 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 781 782 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 782 783 PROCESSING "CLOSE_CONNECTION=DEFER" 783 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz ) as foo using unique ogc_fid using SRID=25832"784 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 784 785 METADATA 785 786 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 816 817 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 817 818 PROCESSING "CLOSE_CONNECTION=DEFER" 818 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr ) as foo using unique ogc_fid using SRID=25832"819 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 819 820 METADATA 820 821 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 844 845 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 845 846 PROCESSING "CLOSE_CONNECTION=DEFER" 846 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr ) as foo using unique ogc_fid using SRID=25832"847 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 847 848 METADATA 848 849 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 872 873 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 873 874 PROCESSING "CLOSE_CONNECTION=DEFER" 874 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr ) as foo using unique ogc_fid using SRID=25832"875 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 875 876 METADATA 876 877 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 900 901 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 901 902 PROCESSING "CLOSE_CONNECTION=DEFER" 902 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft ) as foo using unique ogc_fid using SRID=25832"903 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 903 904 METADATA 904 905 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 947 948 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 948 949 PROCESSING "CLOSE_CONNECTION=DEFER" 949 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald ) as foo using unique ogc_fid using SRID=25832"950 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 950 951 METADATA 951 952 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 973 974 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 974 975 PROCESSING "CLOSE_CONNECTION=DEFER" 975 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz ) as foo using unique ogc_fid using SRID=25832"976 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 976 977 METADATA 977 978 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 999 1000 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1000 1001 PROCESSING "CLOSE_CONNECTION=DEFER" 1001 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide ) as foo using unique ogc_fid using SRID=25832"1002 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1002 1003 METADATA 1003 1004 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1026 1027 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1027 1028 PROCESSING "CLOSE_CONNECTION=DEFER" 1028 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor ) as foo using unique ogc_fid using SRID=25832"1029 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1029 1030 METADATA 1030 1031 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1052 1053 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1053 1054 PROCESSING "CLOSE_CONNECTION=DEFER" 1054 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf ) as foo using unique ogc_fid using SRID=25832"1055 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1055 1056 METADATA 1056 1057 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1078 1079 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1079 1080 PROCESSING "CLOSE_CONNECTION=DEFER" 1080 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche ) as foo using unique ogc_fid using SRID=25832"1081 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1081 1082 METADATA 1082 1083 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1104 1105 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1105 1106 PROCESSING "CLOSE_CONNECTION=DEFER" 1106 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal ) as foo using unique ogc_fid using SRID=25832"1107 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1107 1108 METADATA 1108 1109 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1130 1131 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1131 1132 PROCESSING "CLOSE_CONNECTION=DEFER" 1132 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser ) as foo using unique ogc_fid using SRID=25832"1133 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1133 1134 METADATA 1134 1135 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1156 1157 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1157 1158 PROCESSING "CLOSE_CONNECTION=DEFER" 1158 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken ) as foo using unique ogc_fid using SRID=25832"1159 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1159 1160 METADATA 1160 1161 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1182 1183 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1183 1184 PROCESSING "CLOSE_CONNECTION=DEFER" 1184 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser ) as foo using unique ogc_fid using SRID=25832"1185 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1185 1186 METADATA 1186 1187 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1213 1214 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1214 1215 PROCESSING "CLOSE_CONNECTION=DEFER" 1215 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon' ) as foo using unique ogc_fid using SRID=25832"1216 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon' AND endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1216 1217 METADATA 1217 1218 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1274 1275 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1275 1276 PROCESSING "CLOSE_CONNECTION=DEFER" 1276 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_LineString' ) as foo using unique ogc_fid using SRID=25832"1277 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser WHERE st_geometrytype(wkb_geometry) = 'ST_LineString' AND endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1277 1278 METADATA 1278 1279 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1462 1463 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1463 1464 PROCESSING "CLOSE_CONNECTION=DEFER" 1464 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"1465 DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1465 1466 METADATA 1466 1467 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1813 1814 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1814 1815 PROCESSING "CLOSE_CONNECTION=DEFER" 1815 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"1816 DATA "wkb_geometry from (SELECT ogc_fid, gebaeudefunktion, lagezurerdoberflaeche, hochhaus, zustand, ax_datenerhebung, wkb_geometry FROM ax_gebaeude WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 1816 1817 METADATA 1817 1818 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2026 2027 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2027 2028 PROCESSING "CLOSE_CONNECTION=DEFER" 2028 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil ) as foo using unique ogc_fid using SRID=25832"2029 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2029 2030 METADATA 2030 2031 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2087 2088 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2088 2089 PROCESSING "CLOSE_CONNECTION=DEFER" 2089 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie ) as foo using unique ogc_fid using SRID=25832"2090 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2090 2091 METADATA 2091 2092 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2267 2268 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2268 2269 PROCESSING "CLOSE_CONNECTION=DEFER" 2269 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"2270 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2270 2271 METADATA 2271 2272 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2296 2297 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2297 2298 PROCESSING "CLOSE_CONNECTION=DEFER" 2298 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"2299 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2299 2300 METADATA 2300 2301 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2326 2327 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2327 2328 PROCESSING "CLOSE_CONNECTION=DEFER" 2328 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich ) as foo using unique ogc_fid using SRID=25832"2329 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2329 2330 METADATA 2330 2331 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2353 2354 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2354 2355 PROCESSING "CLOSE_CONNECTION=DEFER" 2355 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe ) as foo using unique ogc_fid using SRID=25832"2356 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2356 2357 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 2357 2358 METADATA … … 2392 2393 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2393 2394 PROCESSING "CLOSE_CONNECTION=DEFER" 2394 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung ) as foo using unique ogc_fid using SRID=25832"2395 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2395 2396 METADATA 2396 2397 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2420 2421 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2421 2422 PROCESSING "CLOSE_CONNECTION=DEFER" 2422 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk ) as foo using unique ogc_fid using SRID=25832"2423 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2423 2424 METADATA 2424 2425 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2477 2478 # 1750;"Denkmal, Denkstein, Standbild" 2478 2479 2479 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon' ) as foo using unique ogc_fid using SRID=25832"2480 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_Polygon' AND endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2480 2481 #ILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" 2481 2482 #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2529 2530 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2530 2531 PROCESSING "CLOSE_CONNECTION=DEFER" 2531 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_LineString' ) as foo using unique ogc_fid using SRID=25832"2532 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung WHERE st_geometrytype(wkb_geometry) = 'ST_LineString' AND endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2532 2533 #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" # sonst Absturz Mapserver 2533 2534 METADATA … … 2559 2560 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2560 2561 PROCESSING "CLOSE_CONNECTION=DEFER" 2561 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung ) as foo using unique ogc_fid using SRID=25832"2562 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2562 2563 METADATA 2563 2564 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2597 2598 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2598 2599 PROCESSING "CLOSE_CONNECTION=DEFER" 2599 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"2600 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2600 2601 METADATA 2601 2602 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2642 2643 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2643 2644 PROCESSING "CLOSE_CONNECTION=DEFER" 2644 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm ) as foo using unique ogc_fid using SRID=25832"2645 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2645 2646 METADATA 2646 2647 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2905 2906 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2906 2907 # PROCESSING "CLOSE_CONNECTION=DEFER" 2907 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung ) as foo using unique ogc_fid using SRID=25832"2908 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2908 2909 # METADATA 2909 2910 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2933 2934 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2934 2935 # PROCESSING "CLOSE_CONNECTION=DEFER" 2935 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck ) as foo using unique ogc_fid using SRID=25832"2936 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2936 2937 # METADATA 2937 2938 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2962 2963 PROCESSING "CLOSE_CONNECTION=DEFER" 2963 2964 # mit Feldern fuer klassisches Template: 2964 # 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"2965 # DATA "wkb_geometry from (SELECT ogc_fid, gml_id, flurstueckskennzeichen, amtlicheflaeche, wkb_geometry FROM ax_flurstueck WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2965 2966 # reduzierte Felder: nur 'gml_id' fuer Inlay, und geometry fuer Karte 2966 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck ) as foo using unique ogc_fid using SRID=25832"2967 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2967 2968 METADATA 2968 2969 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3391 3392 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3392 3393 PROCESSING "CLOSE_CONNECTION=DEFER" 3393 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht ) as foo using unique ogc_fid using SRID=25832"3394 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3394 3395 METADATA 3395 3396 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3433 3434 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3434 3435 PROCESSING "CLOSE_CONNECTION=DEFER" 3435 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht ) as foo using unique ogc_fid using SRID=25832"3436 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3436 3437 METADATA 3437 3438 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3461 3462 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3462 3463 PROCESSING "CLOSE_CONNECTION=DEFER" 3463 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"3464 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3464 3465 METADATA 3465 3466 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3495 3496 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3496 3497 PROCESSING "CLOSE_CONNECTION=DEFER" 3497 3498 # Tabelle (Standard-Template) 3499 #DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, name, bezeichnung, stelle, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 3500 3501 # Tabelle (Template mit Inlay, gkz als Parameter fuer DB-Zugriff uebergeben) 3502 #DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry, *gkz* as gkz FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 3503 3504 # Tabelle (Template mit Inlay, gkz im Namen des Templat) 3505 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 3506 3498 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3507 3499 METADATA 3508 3500 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3691 3683 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3692 3684 PROCESSING "CLOSE_CONNECTION=DEFER" 3693 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht ) as foo using unique ogc_fid using SRID=25832"3685 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3694 3686 METADATA 3695 3687 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3717 3709 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3718 3710 PROCESSING "CLOSE_CONNECTION=DEFER" 3719 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht ) as foo using unique ogc_fid using SRID=25832"3711 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3720 3712 METADATA 3721 3713 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3793 3785 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3794 3786 PROCESSING "CLOSE_CONNECTION=DEFER" 3795 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag ) as foo using unique ogc_fid using SRID=25832"3787 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3796 3788 METADATA 3797 3789 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3822 3814 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3823 3815 PROCESSING "CLOSE_CONNECTION=DEFER" 3824 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau ) as foo using unique ogc_fid using SRID=25832"3816 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 3825 3817 METADATA 3826 3818 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
Note: See TracChangeset
for help on using the changeset viewer.