Changeset 335
- Timestamp:
- 09/16/14 16:07:01 (10 years ago)
- Location:
- trunk
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/staedtische_FS_aus_ALKIS_rlp.sql
r330 r335 10 10 -- 2013-11-26 Version fÃŒr die ALKIS-Musterdaten RLP Mustermonzel 11 11 -- 2014-08-29 Umstellung auf Datenstruktur PostNAS 0.8 (ohne Tabelle "alkis_beziehungen") 12 -- 2014-09-16 Substring fuer variabal lange gml_id 12 13 13 14 -- Voraussetzung = View "doppelverbindung" aus ALKIS PostNAS-Projekt Datei "sichten.sql" … … 29 30 JOIN ax_buchungsstelle s ON d.bsgml = s.gml_id -- Buchungs-Stelle 30 31 --JOIN ax_buchungsstelle_buchungsart b ON s.buchungsart = b.wert -- EnstschlÃŒsselung Buchungsart 31 JOIN ax_buchungsblatt gb ON gb.gml_id = s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 32 JOIN ax_namensnummer nn ON gb.gml_id = nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 33 JOIN ax_person p ON p.gml_id = nn.benennt -- NamNum >benennt> Person 32 33 -- Bei gml_id character(16): 34 --JOIN ax_buchungsblatt gb ON gb.gml_id = s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 35 --JOIN ax_namensnummer nn ON gb.gml_id = nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 36 --JOIN ax_person p ON p.gml_id = nn.benennt -- NamNum >benennt> Person 37 38 -- Bei gml_id character varying: 39 JOIN ax_buchungsblatt gb ON substring(gb.gml_id,1,16)=s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 40 JOIN ax_namensnummer nn ON substring(gb.gml_id,1,16)=nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 41 JOIN ax_person p ON substring(p.gml_id,1,16) =nn.benennt -- NamNum >benennt> Person 42 34 43 WHERE f.endet IS NULL 35 44 AND s.endet IS NULL … … 59 68 JOIN ax_buchungsstelle s ON d.bsgml = s.gml_id -- Buchungs-Stelle 60 69 JOIN ax_buchungsstelle_buchungsart b ON s.buchungsart = b.wert -- EnstschlÃŒsselung Buchungsart 61 JOIN ax_buchungsblatt gb ON gb.gml_id = s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 62 JOIN ax_namensnummer nn ON gb.gml_id = nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 63 JOIN ax_person p ON p.gml_id = nn.benennt -- NamNum >benennt> Person 70 71 -- Bei gml_id character(16): 72 --JOIN ax_buchungsblatt gb ON gb.gml_id = s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 73 --JOIN ax_namensnummer nn ON gb.gml_id = nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 74 --JOIN ax_person p ON p.gml_id = nn.benennt -- NamNum >benennt> Person 75 76 -- Bei gml_id character varying: 77 JOIN ax_buchungsblatt gb ON substring(gb.gml_id,1,16)=s.istbestandteilvon -- Buchung >istBestandteilVon> Blatt 78 JOIN ax_namensnummer nn ON substring(gb.gml_id,1,16)=nn.istbestandteilvon -- Blatt <istBestandteilVon< NamNum 79 JOIN ax_person p ON substring(p.gml_id,1,16) =nn.benennt -- NamNum >benennt> Person 80 64 81 WHERE f.endet IS NULL 65 82 AND s.endet IS NULL … … 71 88 COMMENT ON VIEW st_flurst IS 'FlurstÃŒcke der Ortsgemeinde Osann-Monzel. FÃŒr WMS: nur ID und Geometrie.'; 72 89 73 --GRANT SELECT ON TABLE st_flurst TO ms6;90 GRANT SELECT ON TABLE st_flurst TO ms6; 74 91 75 92 -
trunk/umn/alkis/alkis_muster.map
r330 r335 1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Entwickler-Version1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant 2 2 # 3 3 # Stand / Historie: 4 # 2012-02-09 F.J. krz Branch 0.7 aus Version 0.65 # 2012-02-17 F.J. krz data dbname=alkis07, Layer-Group pp_gebiete6 # 2012-03-05 F.J. krz PROCESSING "CLOSE_CONNECTION=DEFER"7 # 2012-04-17 F.J. krz Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr.8 # Auch Standard-Position vom Flurstuecksnummern anzeigen9 # 2013-01-23 F.J. krz ax_flurstueck bis 1:25.000 (fÃŒr MapProxy)10 # 2013-03-05 F.J. krz Umstellung auf Mapserver 6.211 # Abgleich mit SVN-Version, z.B. kein "SYMBOL 0" mehr in Pol. Grenz.12 # Gruppe "Recht" verschoben hinter "Flurstueck" und "Gebiete" hinter "Nutzungsarten"13 # Layer FlurstÃŒcksnummer hinter Zuordnungspfeil.14 # Logical Expression: [column] und Wert in '' einschlieÃen (Log-Meldung).15 # Keine Schraffur auf "GebÀude, graphisch".16 # "Laufende Nummer NebengebÀude": kein PrÀsentationsobjekt mehr, Anzeige mittig in Geb.-FlÀche17 # 2013-03-11 F.J. krz Neuer Layer "ax_gebaeude_txt" (Funktion und Name zum GebÀude)18 # 2013-04-18 F.J. krz Thema (Gruppe) "BodenschÀtzung" wurde ÃŒberarbeitet und vor Gruppe "FlurstÃŒcke" verschoben19 # 2013-06-19 F.J. krz Layer "ax_untergeordnetesgewaesser_polygon"/"*_line" nach Geometrietyp filtern nicht nach funktion20 # 2013-10-16 F.J. krz FS-Nr dunkler, besser sichtbar auf SW-Drucker.21 4 # 2013-10-24 F.J. krz PrÀsentation der StraÃennamen aus der Tabelle "pp_strassenname" statt aus dem View "ap_pto_stra". 22 5 # Die Tabelle wird im PostProcessing redundant befÃŒllt um schneller darstellen zu können. … … 24 7 # 2014-08-25 F.J. krz StraÃennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra" 25 8 # 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel 9 # 2014-09-15 F.J. krz: Filter fÃŒr Historische Objekte "WHERE endet IS NULL" in DATA fÃŒr Tabellen ax_* 26 10 27 11 ### … … 39 23 # - Mit Status on/off die gÀngigen Layer vorkonfigurieren? 40 24 41 # - Zuordnungspfeil eFS:25 # - ZuordnungspfeilE FS: 42 26 # Linie im Druck zu dÃŒnn 43 27 # Ist doppelt: in "FlurstÃŒck" ("ag_l_flurstueck") und in "PrÀsentation/Zuordnungspfeile" ("ap_lpo") … … 75 59 FONTSET "fonts/fonts_alkis.fnt" 76 60 UNITS METERS 77 #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" # Nur fuer Test61 #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" 78 62 #DEBUG 3 79 63 WEB 80 64 METADATA 81 wms_title "ALKIS" # TEST-Kennung im Title82 ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile, Version vom August2014"65 wms_title "ALKIS" 66 ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Stand September 2014" 83 67 ows_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 84 68 ows_encoding "UTF-8" … … 446 430 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 447 431 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"432 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 433 METADATA 450 434 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 474 458 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 475 459 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"460 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 461 METADATA 478 462 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 503 487 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 504 488 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"489 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 490 METADATA 507 491 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 529 513 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 530 514 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"515 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 516 METADATA 533 517 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 554 538 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 555 539 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"540 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 541 METADATA 558 542 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 581 565 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 582 566 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"567 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 568 METADATA 585 569 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 610 594 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 611 595 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"596 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 597 METADATA 614 598 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 637 621 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 638 622 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"623 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 624 METADATA 641 625 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 665 649 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 666 650 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"651 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 652 METADATA 669 653 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 694 678 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 695 679 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"680 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 681 METADATA 698 682 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 754 738 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 755 739 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"740 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 741 METADATA 758 742 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 781 765 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 782 766 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"767 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 768 METADATA 785 769 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 816 800 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 817 801 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"802 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 803 METADATA 820 804 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 844 828 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 845 829 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"830 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 831 METADATA 848 832 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 872 856 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 873 857 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"858 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 859 METADATA 876 860 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 900 884 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 901 885 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"886 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 887 METADATA 904 888 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 947 931 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 948 932 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"933 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 934 METADATA 951 935 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 973 957 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 974 958 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"959 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 960 METADATA 977 961 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 999 983 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1000 984 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"985 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 986 METADATA 1003 987 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1026 1010 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1027 1011 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"1012 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 1013 METADATA 1030 1014 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1052 1036 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1053 1037 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"1038 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 1039 METADATA 1056 1040 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1078 1062 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1079 1063 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"1064 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 1065 METADATA 1082 1066 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1104 1088 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1105 1089 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"1090 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 1091 METADATA 1108 1092 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1130 1114 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1131 1115 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"1116 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 1117 METADATA 1134 1118 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1156 1140 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1157 1141 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"1142 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 1143 METADATA 1160 1144 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1182 1166 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1183 1167 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"1168 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 1169 METADATA 1186 1170 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1213 1197 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1214 1198 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"1199 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 1200 METADATA 1217 1201 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1274 1258 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1275 1259 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"1260 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 1261 METADATA 1278 1262 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1462 1446 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1463 1447 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"1448 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 1449 METADATA 1466 1450 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1813 1797 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1814 1798 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"1799 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 1800 METADATA 1817 1801 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2026 2010 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2027 2011 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"2012 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 2013 METADATA 2030 2014 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2087 2071 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2088 2072 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"2073 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 2074 METADATA 2091 2075 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2267 2251 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2268 2252 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"2253 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 2254 METADATA 2271 2255 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2296 2280 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2297 2281 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"2282 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 2283 METADATA 2300 2284 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2326 2310 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2327 2311 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"2312 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 2313 METADATA 2330 2314 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2353 2337 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2354 2338 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"2339 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 2340 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 2357 2341 METADATA … … 2392 2376 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2393 2377 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"2378 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 2379 METADATA 2396 2380 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2420 2404 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2421 2405 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"2406 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 2407 METADATA 2424 2408 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2477 2461 # 1750;"Denkmal, Denkstein, Standbild" 2478 2462 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"2463 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 2464 #ILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" 2481 2465 #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2529 2513 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2530 2514 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"2515 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 2516 #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" # sonst Absturz Mapserver 2533 2517 METADATA … … 2559 2543 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2560 2544 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"2545 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 2546 METADATA 2563 2547 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2597 2581 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2598 2582 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"2583 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 2584 METADATA 2601 2585 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2642 2626 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2643 2627 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"2628 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 2629 METADATA 2646 2630 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2905 2889 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2906 2890 # 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"2891 # 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 2892 # METADATA 2909 2893 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2933 2917 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2934 2918 # 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"2919 # 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 2920 # METADATA 2937 2921 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2962 2946 PROCESSING "CLOSE_CONNECTION=DEFER" 2963 2947 # 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"2948 # 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 2949 # 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"2950 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 2951 METADATA 2968 2952 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3391 3375 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3392 3376 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"3377 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 3378 METADATA 3395 3379 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3433 3417 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3434 3418 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"3419 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 3420 METADATA 3437 3421 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3461 3445 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3462 3446 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"3447 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 3448 METADATA 3465 3449 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3495 3479 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3496 3480 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 3481 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 3482 METADATA 3508 3483 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3691 3666 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3692 3667 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"3668 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 3669 METADATA 3695 3670 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3717 3692 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3718 3693 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"3694 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 3695 METADATA 3721 3696 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3793 3768 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3794 3769 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"3770 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 3771 METADATA 3797 3772 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3822 3797 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3823 3798 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"3799 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 3800 METADATA 3826 3801 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" -
trunk/umn/alkis/alkis_muster_4.map
r330 r335 1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion zur Entwickler-Version1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion 2 2 # Ãnderungen: siehe Bildschirm-Version, letzte: 3 # 2014-08-25 F.J. krz StraÃennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra"4 3 # 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel 5 4 # 2014-09-15 F.J. krz: Filter fÃŒr Historische Objekte "WHERE endet IS NULL" in DATA fÃŒr Tabellen ax_* 6 5 MAP 7 6 NAME "alkis" … … 22 21 wms_enable_request "getmap" 23 22 wms_box_extended "true" 23 #include "meta_contact.map" 24 24 END 25 25 END … … 330 330 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 331 331 PROCESSING "CLOSE_CONNECTION=DEFER" 332 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche ) as foo using unique ogc_fid using SRID=25832"332 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" 333 333 METADATA 334 334 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 356 356 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 357 357 PROCESSING "CLOSE_CONNECTION=DEFER" 358 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche ) as foo using unique ogc_fid using SRID=25832"358 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" 359 359 METADATA 360 360 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 383 383 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 384 384 PROCESSING "CLOSE_CONNECTION=DEFER" 385 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde ) as foo using unique ogc_fid using SRID=25832"385 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" 386 386 METADATA 387 387 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 408 408 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 409 409 PROCESSING "CLOSE_CONNECTION=DEFER" 410 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb ) as foo using unique ogc_fid using SRID=25832"410 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" 411 411 METADATA 412 412 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 432 432 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 433 433 PROCESSING "CLOSE_CONNECTION=DEFER" 434 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch ) as foo using unique ogc_fid using SRID=25832"434 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" 435 435 METADATA 436 436 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 458 458 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 459 459 PROCESSING "CLOSE_CONNECTION=DEFER" 460 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung ) as foo using unique ogc_fid using SRID=25832"460 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" 461 461 METADATA 462 462 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 483 483 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 484 484 PROCESSING "CLOSE_CONNECTION=DEFER" 485 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung ) as foo using unique ogc_fid using SRID=25832"485 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" 486 486 METADATA 487 487 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 508 508 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 509 509 PROCESSING "CLOSE_CONNECTION=DEFER" 510 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche ) as foo using unique ogc_fid using SRID=25832"510 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" 511 511 METADATA 512 512 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 534 534 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 535 535 PROCESSING "CLOSE_CONNECTION=DEFER" 536 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof ) as foo using unique ogc_fid using SRID=25832"536 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" 537 537 METADATA 538 538 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 561 561 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 562 562 PROCESSING "CLOSE_CONNECTION=DEFER" 563 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr ) as foo using unique ogc_fid using SRID=25832"563 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" 564 564 METADATA 565 565 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 619 619 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 620 620 PROCESSING "CLOSE_CONNECTION=DEFER" 621 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg ) as foo using unique ogc_fid using SRID=25832"621 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" 622 622 METADATA 623 623 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 644 644 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 645 645 PROCESSING "CLOSE_CONNECTION=DEFER" 646 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz ) as foo using unique ogc_fid using SRID=25832"646 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" 647 647 METADATA 648 648 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 677 677 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 678 678 PROCESSING "CLOSE_CONNECTION=DEFER" 679 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr ) as foo using unique ogc_fid using SRID=25832"679 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" 680 680 METADATA 681 681 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 703 703 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 704 704 PROCESSING "CLOSE_CONNECTION=DEFER" 705 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr ) as foo using unique ogc_fid using SRID=25832"705 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" 706 706 METADATA 707 707 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 729 729 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 730 730 PROCESSING "CLOSE_CONNECTION=DEFER" 731 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr ) as foo using unique ogc_fid using SRID=25832"731 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" 732 732 METADATA 733 733 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 756 756 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 757 757 PROCESSING "CLOSE_CONNECTION=DEFER" 758 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft ) as foo using unique ogc_fid using SRID=25832"758 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" 759 759 METADATA 760 760 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 798 798 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 799 799 PROCESSING "CLOSE_CONNECTION=DEFER" 800 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald ) as foo using unique ogc_fid using SRID=25832"800 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" 801 801 METADATA 802 802 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 822 822 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 823 823 PROCESSING "CLOSE_CONNECTION=DEFER" 824 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz ) as foo using unique ogc_fid using SRID=25832"824 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" 825 825 METADATA 826 826 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 846 846 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 847 847 PROCESSING "CLOSE_CONNECTION=DEFER" 848 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide ) as foo using unique ogc_fid using SRID=25832"848 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" 849 849 METADATA 850 850 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 870 870 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 871 871 PROCESSING "CLOSE_CONNECTION=DEFER" 872 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor ) as foo using unique ogc_fid using SRID=25832"872 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" 873 873 METADATA 874 874 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 894 894 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 895 895 PROCESSING "CLOSE_CONNECTION=DEFER" 896 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf ) as foo using unique ogc_fid using SRID=25832"896 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" 897 897 METADATA 898 898 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 919 919 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 920 920 PROCESSING "CLOSE_CONNECTION=DEFER" 921 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche ) as foo using unique ogc_fid using SRID=25832"921 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" 922 922 METADATA 923 923 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 944 944 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 945 945 PROCESSING "CLOSE_CONNECTION=DEFER" 946 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal ) as foo using unique ogc_fid using SRID=25832"946 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" 947 947 METADATA 948 948 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 969 969 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 970 970 PROCESSING "CLOSE_CONNECTION=DEFER" 971 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser ) as foo using unique ogc_fid using SRID=25832"971 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" 972 972 METADATA 973 973 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 994 994 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 995 995 PROCESSING "CLOSE_CONNECTION=DEFER" 996 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken ) as foo using unique ogc_fid using SRID=25832"996 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" 997 997 METADATA 998 998 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1019 1019 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1020 1020 PROCESSING "CLOSE_CONNECTION=DEFER" 1021 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser ) as foo using unique ogc_fid using SRID=25832"1021 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" 1022 1022 METADATA 1023 1023 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1046 1046 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1047 1047 PROCESSING "CLOSE_CONNECTION=DEFER" 1048 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"1048 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" 1049 1049 METADATA 1050 1050 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1096 1096 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1097 1097 PROCESSING "CLOSE_CONNECTION=DEFER" 1098 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"1098 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" 1099 1099 METADATA 1100 1100 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1262 1262 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1263 1263 PROCESSING "CLOSE_CONNECTION=DEFER" 1264 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"1264 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" 1265 1265 METADATA 1266 1266 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1607 1607 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1608 1608 PROCESSING "CLOSE_CONNECTION=DEFER" 1609 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"1609 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" 1610 1610 METADATA 1611 1611 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1780 1780 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1781 1781 PROCESSING "CLOSE_CONNECTION=DEFER" 1782 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil ) as foo using unique ogc_fid using SRID=25832"1782 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" 1783 1783 METADATA 1784 1784 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1838 1838 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1839 1839 PROCESSING "CLOSE_CONNECTION=DEFER" 1840 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie ) as foo using unique ogc_fid using SRID=25832"1840 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" 1841 1841 METADATA 1842 1842 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1960 1960 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1961 1961 PROCESSING "CLOSE_CONNECTION=DEFER" 1962 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"1962 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" 1963 1963 METADATA 1964 1964 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1984 1984 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1985 1985 PROCESSING "CLOSE_CONNECTION=DEFER" 1986 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"1986 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" 1987 1987 METADATA 1988 1988 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2009 2009 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2010 2010 PROCESSING "CLOSE_CONNECTION=DEFER" 2011 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich ) as foo using unique ogc_fid using SRID=25832"2011 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" 2012 2012 METADATA 2013 2013 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2034 2034 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2035 2035 PROCESSING "CLOSE_CONNECTION=DEFER" 2036 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe ) as foo using unique ogc_fid using SRID=25832"2036 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" 2037 2037 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 2038 2038 METADATA … … 2070 2070 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2071 2071 PROCESSING "CLOSE_CONNECTION=DEFER" 2072 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung ) as foo using unique ogc_fid using SRID=25832"2072 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" 2073 2073 METADATA 2074 2074 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2095 2095 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2096 2096 PROCESSING "CLOSE_CONNECTION=DEFER" 2097 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk ) as foo using unique ogc_fid using SRID=25832"2097 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" 2098 2098 METADATA 2099 2099 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2120 2120 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2121 2121 PROCESSING "CLOSE_CONNECTION=DEFER" 2122 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"2122 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" 2123 2123 #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" 2124 2124 METADATA … … 2164 2164 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2165 2165 PROCESSING "CLOSE_CONNECTION=DEFER" 2166 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"2166 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" 2167 2167 #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" 2168 2168 METADATA … … 2189 2189 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2190 2190 PROCESSING "CLOSE_CONNECTION=DEFER" 2191 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung ) as foo using unique ogc_fid using SRID=25832"2191 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" 2192 2192 METADATA 2193 2193 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2223 2223 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2224 2224 PROCESSING "CLOSE_CONNECTION=DEFER" 2225 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"2225 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" 2226 2226 METADATA 2227 2227 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2265 2265 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2266 2266 PROCESSING "CLOSE_CONNECTION=DEFER" 2267 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm ) as foo using unique ogc_fid using SRID=25832"2267 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" 2268 2268 METADATA 2269 2269 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2425 2425 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2426 2426 # PROCESSING "CLOSE_CONNECTION=DEFER" 2427 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung ) as foo using unique ogc_fid using SRID=25832"2427 # 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" 2428 2428 # METADATA 2429 2429 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2454 2454 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2455 2455 # PROCESSING "CLOSE_CONNECTION=DEFER" 2456 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck ) as foo using unique ogc_fid using SRID=25832"2456 # 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" 2457 2457 # METADATA 2458 2458 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2480 2480 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2481 2481 PROCESSING "CLOSE_CONNECTION=DEFER" 2482 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck ) as foo using unique ogc_fid using SRID=25832"2482 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" 2483 2483 METADATA 2484 2484 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2506 2506 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2507 2507 PROCESSING "CLOSE_CONNECTION=DEFER" 2508 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze ) as foo using unique ogc_fid using SRID=25832"2508 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2509 2509 METADATA 2510 2510 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2751 2751 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2752 2752 PROCESSING "CLOSE_CONNECTION=DEFER" 2753 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht ) as foo using unique ogc_fid using SRID=25832"2753 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" 2754 2754 METADATA 2755 2755 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2789 2789 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2790 2790 PROCESSING "CLOSE_CONNECTION=DEFER" 2791 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"2791 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" 2792 2792 METADATA 2793 2793 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2814 2814 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2815 2815 PROCESSING "CLOSE_CONNECTION=DEFER" 2816 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"2816 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" 2817 2817 METADATA 2818 2818 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2845 2845 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2846 2846 PROCESSING "CLOSE_CONNECTION=DEFER" 2847 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht ) as foo using unique ogc_fid using SRID=25832"2847 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" 2848 2848 METADATA 2849 2849 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2930 2930 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2931 2931 PROCESSING "CLOSE_CONNECTION=DEFER" 2932 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht ) as foo using unique ogc_fid using SRID=25832"2932 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" 2933 2933 METADATA 2934 2934 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2953 2953 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2954 2954 PROCESSING "CLOSE_CONNECTION=DEFER" 2955 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht ) as foo using unique ogc_fid using SRID=25832"2955 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" 2956 2956 METADATA 2957 2957 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3024 3024 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3025 3025 PROCESSING "CLOSE_CONNECTION=DEFER" 3026 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag ) as foo using unique ogc_fid using SRID=25832"3026 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" 3027 3027 METADATA 3028 3028 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3049 3049 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3050 3050 PROCESSING "CLOSE_CONNECTION=DEFER" 3051 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau ) as foo using unique ogc_fid using SRID=25832"3051 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" 3052 3052 METADATA 3053 3053 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" -
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" -
trunk/umn/alkis/alkis_muster_entw_4.map
r330 r335 1 1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion zur Entwickler-Version 2 2 # Ãnderungen: siehe Bildschirm-Version, letzte: 3 # 2014-08-25 F.J. krz StraÃennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra"4 3 # 2014-08-29 F.J. krz: Umstellung auf Version 0.8 - Datenbankname, Titel 5 4 # 2014-09-15 F.J. krz: Filter fÃŒr Historische Objekte "WHERE endet IS NULL" in DATA fÃŒr Tabellen ax_* 6 5 MAP 7 6 NAME "alkis" … … 331 330 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 332 331 PROCESSING "CLOSE_CONNECTION=DEFER" 333 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche ) as foo using unique ogc_fid using SRID=25832"332 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" 334 333 METADATA 335 334 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 357 356 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 358 357 PROCESSING "CLOSE_CONNECTION=DEFER" 359 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche ) as foo using unique ogc_fid using SRID=25832"358 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" 360 359 METADATA 361 360 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 384 383 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 385 384 PROCESSING "CLOSE_CONNECTION=DEFER" 386 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde ) as foo using unique ogc_fid using SRID=25832"385 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" 387 386 METADATA 388 387 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 409 408 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 410 409 PROCESSING "CLOSE_CONNECTION=DEFER" 411 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb ) as foo using unique ogc_fid using SRID=25832"410 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" 412 411 METADATA 413 412 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 433 432 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 434 433 PROCESSING "CLOSE_CONNECTION=DEFER" 435 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch ) as foo using unique ogc_fid using SRID=25832"434 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" 436 435 METADATA 437 436 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 459 458 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 460 459 PROCESSING "CLOSE_CONNECTION=DEFER" 461 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung ) as foo using unique ogc_fid using SRID=25832"460 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" 462 461 METADATA 463 462 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 484 483 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 485 484 PROCESSING "CLOSE_CONNECTION=DEFER" 486 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung ) as foo using unique ogc_fid using SRID=25832"485 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" 487 486 METADATA 488 487 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 509 508 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 510 509 PROCESSING "CLOSE_CONNECTION=DEFER" 511 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche ) as foo using unique ogc_fid using SRID=25832"510 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" 512 511 METADATA 513 512 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 535 534 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 536 535 PROCESSING "CLOSE_CONNECTION=DEFER" 537 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof ) as foo using unique ogc_fid using SRID=25832"536 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" 538 537 METADATA 539 538 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 562 561 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 563 562 PROCESSING "CLOSE_CONNECTION=DEFER" 564 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr ) as foo using unique ogc_fid using SRID=25832"563 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" 565 564 METADATA 566 565 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 620 619 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 621 620 PROCESSING "CLOSE_CONNECTION=DEFER" 622 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg ) as foo using unique ogc_fid using SRID=25832"621 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" 623 622 METADATA 624 623 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 645 644 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 646 645 PROCESSING "CLOSE_CONNECTION=DEFER" 647 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz ) as foo using unique ogc_fid using SRID=25832"646 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" 648 647 METADATA 649 648 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 678 677 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 679 678 PROCESSING "CLOSE_CONNECTION=DEFER" 680 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr ) as foo using unique ogc_fid using SRID=25832"679 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" 681 680 METADATA 682 681 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 704 703 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 705 704 PROCESSING "CLOSE_CONNECTION=DEFER" 706 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr ) as foo using unique ogc_fid using SRID=25832"705 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" 707 706 METADATA 708 707 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 730 729 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 731 730 PROCESSING "CLOSE_CONNECTION=DEFER" 732 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr ) as foo using unique ogc_fid using SRID=25832"731 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" 733 732 METADATA 734 733 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 757 756 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 758 757 PROCESSING "CLOSE_CONNECTION=DEFER" 759 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft ) as foo using unique ogc_fid using SRID=25832"758 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" 760 759 METADATA 761 760 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 799 798 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 800 799 PROCESSING "CLOSE_CONNECTION=DEFER" 801 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald ) as foo using unique ogc_fid using SRID=25832"800 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" 802 801 METADATA 803 802 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 823 822 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 824 823 PROCESSING "CLOSE_CONNECTION=DEFER" 825 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz ) as foo using unique ogc_fid using SRID=25832"824 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" 826 825 METADATA 827 826 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 847 846 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 848 847 PROCESSING "CLOSE_CONNECTION=DEFER" 849 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide ) as foo using unique ogc_fid using SRID=25832"848 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" 850 849 METADATA 851 850 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 871 870 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 872 871 PROCESSING "CLOSE_CONNECTION=DEFER" 873 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor ) as foo using unique ogc_fid using SRID=25832"872 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" 874 873 METADATA 875 874 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 895 894 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 896 895 PROCESSING "CLOSE_CONNECTION=DEFER" 897 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf ) as foo using unique ogc_fid using SRID=25832"896 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" 898 897 METADATA 899 898 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 920 919 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 921 920 PROCESSING "CLOSE_CONNECTION=DEFER" 922 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche ) as foo using unique ogc_fid using SRID=25832"921 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" 923 922 METADATA 924 923 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 945 944 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 946 945 PROCESSING "CLOSE_CONNECTION=DEFER" 947 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal ) as foo using unique ogc_fid using SRID=25832"946 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" 948 947 METADATA 949 948 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 970 969 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 971 970 PROCESSING "CLOSE_CONNECTION=DEFER" 972 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser ) as foo using unique ogc_fid using SRID=25832"971 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" 973 972 METADATA 974 973 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 995 994 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 996 995 PROCESSING "CLOSE_CONNECTION=DEFER" 997 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken ) as foo using unique ogc_fid using SRID=25832"996 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" 998 997 METADATA 999 998 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1020 1019 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1021 1020 PROCESSING "CLOSE_CONNECTION=DEFER" 1022 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser ) as foo using unique ogc_fid using SRID=25832"1021 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" 1023 1022 METADATA 1024 1023 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1047 1046 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1048 1047 PROCESSING "CLOSE_CONNECTION=DEFER" 1049 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"1048 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" 1050 1049 METADATA 1051 1050 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1097 1096 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1098 1097 PROCESSING "CLOSE_CONNECTION=DEFER" 1099 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"1098 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" 1100 1099 METADATA 1101 1100 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1263 1262 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1264 1263 PROCESSING "CLOSE_CONNECTION=DEFER" 1265 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"1264 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" 1266 1265 METADATA 1267 1266 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1608 1607 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1609 1608 PROCESSING "CLOSE_CONNECTION=DEFER" 1610 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"1609 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" 1611 1610 METADATA 1612 1611 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1781 1780 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1782 1781 PROCESSING "CLOSE_CONNECTION=DEFER" 1783 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil ) as foo using unique ogc_fid using SRID=25832"1782 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" 1784 1783 METADATA 1785 1784 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1839 1838 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1840 1839 PROCESSING "CLOSE_CONNECTION=DEFER" 1841 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie ) as foo using unique ogc_fid using SRID=25832"1840 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" 1842 1841 METADATA 1843 1842 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1961 1960 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1962 1961 PROCESSING "CLOSE_CONNECTION=DEFER" 1963 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"1962 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" 1964 1963 METADATA 1965 1964 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 1985 1984 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 1986 1985 PROCESSING "CLOSE_CONNECTION=DEFER" 1987 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich ) as foo using unique ogc_fid using SRID=25832"1986 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" 1988 1987 METADATA 1989 1988 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2010 2009 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2011 2010 PROCESSING "CLOSE_CONNECTION=DEFER" 2012 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich ) as foo using unique ogc_fid using SRID=25832"2011 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" 2013 2012 METADATA 2014 2013 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2035 2034 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2036 2035 PROCESSING "CLOSE_CONNECTION=DEFER" 2037 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe ) as foo using unique ogc_fid using SRID=25832"2036 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" 2038 2037 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 2039 2038 METADATA … … 2071 2070 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2072 2071 PROCESSING "CLOSE_CONNECTION=DEFER" 2073 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung ) as foo using unique ogc_fid using SRID=25832"2072 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" 2074 2073 METADATA 2075 2074 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2096 2095 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2097 2096 PROCESSING "CLOSE_CONNECTION=DEFER" 2098 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk ) as foo using unique ogc_fid using SRID=25832"2097 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" 2099 2098 METADATA 2100 2099 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2121 2120 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2122 2121 PROCESSING "CLOSE_CONNECTION=DEFER" 2123 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"2122 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" 2124 2123 #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" 2125 2124 METADATA … … 2165 2164 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2166 2165 PROCESSING "CLOSE_CONNECTION=DEFER" 2167 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"2166 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" 2168 2167 #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" 2169 2168 METADATA … … 2190 2189 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2191 2190 PROCESSING "CLOSE_CONNECTION=DEFER" 2192 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung ) as foo using unique ogc_fid using SRID=25832"2191 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" 2193 2192 METADATA 2194 2193 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2224 2223 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2225 2224 PROCESSING "CLOSE_CONNECTION=DEFER" 2226 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"2225 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" 2227 2226 METADATA 2228 2227 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2266 2265 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2267 2266 PROCESSING "CLOSE_CONNECTION=DEFER" 2268 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm ) as foo using unique ogc_fid using SRID=25832"2267 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" 2269 2268 METADATA 2270 2269 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2426 2425 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2427 2426 # PROCESSING "CLOSE_CONNECTION=DEFER" 2428 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung ) as foo using unique ogc_fid using SRID=25832"2427 # 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" 2429 2428 # METADATA 2430 2429 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2455 2454 # CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2456 2455 # PROCESSING "CLOSE_CONNECTION=DEFER" 2457 # DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck ) as foo using unique ogc_fid using SRID=25832"2456 # 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" 2458 2457 # METADATA 2459 2458 # wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2481 2480 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2482 2481 PROCESSING "CLOSE_CONNECTION=DEFER" 2483 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck ) as foo using unique ogc_fid using SRID=25832"2482 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" 2484 2483 METADATA 2485 2484 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2507 2506 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2508 2507 PROCESSING "CLOSE_CONNECTION=DEFER" 2509 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze ) as foo using unique ogc_fid using SRID=25832"2508 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze WHERE endet IS NULL) as foo using unique ogc_fid using SRID=25832" 2510 2509 METADATA 2511 2510 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2752 2751 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2753 2752 PROCESSING "CLOSE_CONNECTION=DEFER" 2754 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht ) as foo using unique ogc_fid using SRID=25832"2753 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" 2755 2754 METADATA 2756 2755 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2790 2789 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2791 2790 PROCESSING "CLOSE_CONNECTION=DEFER" 2792 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"2791 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" 2793 2792 METADATA 2794 2793 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2815 2814 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2816 2815 PROCESSING "CLOSE_CONNECTION=DEFER" 2817 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"2816 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" 2818 2817 METADATA 2819 2818 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2846 2845 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2847 2846 PROCESSING "CLOSE_CONNECTION=DEFER" 2848 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht ) as foo using unique ogc_fid using SRID=25832"2847 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" 2849 2848 METADATA 2850 2849 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2931 2930 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2932 2931 PROCESSING "CLOSE_CONNECTION=DEFER" 2933 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht ) as foo using unique ogc_fid using SRID=25832"2932 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" 2934 2933 METADATA 2935 2934 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 2954 2953 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 2955 2954 PROCESSING "CLOSE_CONNECTION=DEFER" 2956 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht ) as foo using unique ogc_fid using SRID=25832"2955 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" 2957 2956 METADATA 2958 2957 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3025 3024 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3026 3025 PROCESSING "CLOSE_CONNECTION=DEFER" 3027 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag ) as foo using unique ogc_fid using SRID=25832"3026 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" 3028 3027 METADATA 3029 3028 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" … … 3050 3049 CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 3051 3050 PROCESSING "CLOSE_CONNECTION=DEFER" 3052 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau ) as foo using unique ogc_fid using SRID=25832"3051 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" 3053 3052 METADATA 3054 3053 wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004"
Note: See TracChangeset
for help on using the changeset viewer.