Changeset 335 for trunk/umn


Ignore:
Timestamp:
09/16/14 16:07:01 (10 years ago)
Author:
frank.jaeger
Message:

WMS: Filter Historisch ("endet IS NULL" in Data), View für den WMS "Flurstücke kommunal" für variable gml-IDs angepasst.

Location:
trunk/umn/alkis
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • trunk/umn/alkis/alkis_muster.map

    r330 r335  
    1 # WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Entwickler-Version 
     1# WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant 
    22# 
    33# Stand / Historie: 
    4 # 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6 
    5 # 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete 
    6 # 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 anzeigen 
    9 # 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.2 
    11 #                      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Àche  
    17 # 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" verschoben 
    19 # 2013-06-19 F.J. krz  Layer "ax_untergeordnetesgewaesser_polygon"/"*_line" nach Geometrietyp filtern nicht nach funktion 
    20 # 2013-10-16 F.J. krz  FS-Nr dunkler, besser sichtbar auf SW-Drucker. 
    214# 2013-10-24 F.J. krz  PrÀsentation der Straßennamen aus der Tabelle "pp_strassenname" statt aus dem View "ap_pto_stra". 
    225#                      Die Tabelle wird im PostProcessing redundant befÃŒllt um schneller darstellen zu können. 
    … …  
    247# 2014-08-25 F.J. krz  Straßennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra" 
    258# 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_* 
    2610 
    2711### 
    … …  
    3923# - Mit Status on/off die gÀngigen Layer vorkonfigurieren? 
    4024 
    41 # - Zuordnungspfeile FS: 
     25# - ZuordnungspfeilE FS: 
    4226#   Linie im Druck zu dÃŒnn 
    4327#   Ist doppelt: in "FlurstÃŒck" ("ag_l_flurstueck") und in "PrÀsentation/Zuordnungspfeile" ("ap_lpo") 
    … …  
    7559        FONTSET "fonts/fonts_alkis.fnt" 
    7660        UNITS METERS 
    77         #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" # Nur fuer Test 
     61        #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" 
    7862        #DEBUG 3 
    7963        WEB 
    8064                METADATA 
    81                         wms_title "ALKIS" # TEST-Kennung im Title 
    82                         ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile, Version vom August 2014" 
     65                        wms_title "ALKIS" 
     66                        ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Stand September 2014" 
    8367                        ows_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    8468                        ows_encoding "UTF-8" 
    … …  
    446430        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    447431        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" 
    449433        METADATA 
    450434                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    474458        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    475459        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" 
    477461        METADATA 
    478462                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    503487        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    504488        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" 
    506490        METADATA 
    507491                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    529513        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    530514        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" 
    532516        METADATA 
    533517                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    554538        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    555539        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" 
    557541        METADATA 
    558542                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    581565        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    582566        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" 
    584568        METADATA 
    585569                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    610594        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    611595        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" 
    613597        METADATA 
    614598                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    637621        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    638622        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" 
    640624        METADATA 
    641625                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    665649        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    666650        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" 
    668652        METADATA 
    669653                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    694678        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    695679        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" 
    697681        METADATA 
    698682                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    754738        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    755739        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" 
    757741        METADATA 
    758742                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    781765        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    782766        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" 
    784768        METADATA 
    785769                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    816800        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    817801        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" 
    819803        METADATA 
    820804                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    844828        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    845829        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" 
    847831        METADATA 
    848832                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    872856        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    873857        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" 
    875859        METADATA 
    876860                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    900884        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    901885        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" 
    903887        METADATA 
    904888                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    947931        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    948932        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" 
    950934        METADATA 
    951935                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    973957        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    974958        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" 
    976960        METADATA 
    977961                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    999983        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    1000984        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" 
    1002986        METADATA 
    1003987                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10261010        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10271011        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" 
    10291013        METADATA 
    10301014                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10521036        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10531037        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" 
    10551039        METADATA 
    10561040                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10781062        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10791063        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" 
    10811065        METADATA 
    10821066                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11041088        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11051089        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" 
    11071091        METADATA 
    11081092                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11301114        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11311115        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" 
    11331117        METADATA 
    11341118                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11561140        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11571141        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" 
    11591143        METADATA 
    11601144                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11821166        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11831167        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" 
    11851169        METADATA 
    11861170                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12131197        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12141198        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" 
    12161200        METADATA 
    12171201                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12741258        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12751259        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" 
    12771261        METADATA 
    12781262                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    14621446        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    14631447        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" 
    14651449        METADATA 
    14661450                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    18131797        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    18141798        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" 
    18161800        METADATA 
    18171801                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20262010        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20272011        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" 
    20292013        METADATA 
    20302014                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20872071        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20882072        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" 
    20902074        METADATA 
    20912075                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22672251        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22682252        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" 
    22702254        METADATA 
    22712255                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22962280        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22972281        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" 
    22992283        METADATA 
    23002284                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    23262310        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23272311        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" 
    23292313        METADATA 
    23302314                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    23532337        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23542338        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" 
    23562340        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    23572341        METADATA 
    … …  
    23922376        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23932377        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" 
    23952379        METADATA 
    23962380                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24202404        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24212405        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" 
    24232407        METADATA 
    24242408                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24772461# 1750;"Denkmal, Denkstein, Standbild" 
    24782462 
    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" 
    24802464        #ILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" 
    24812465        #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    … …  
    25292513        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25302514        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" 
    25322516        #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" # sonst Absturz Mapserver 
    25332517        METADATA 
    … …  
    25592543        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25602544        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" 
    25622546        METADATA 
    25632547                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    25972581        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25982582        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" 
    26002584        METADATA 
    26012585                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    26422626        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    26432627        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" 
    26452629        METADATA 
    26462630                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29052889#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29062890#       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" 
    29082892#       METADATA 
    29092893#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29332917#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29342918#       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" 
    29362920#       METADATA 
    29372921#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29622946        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29632947        # 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" 
    29652949        # 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" 
    29672951        METADATA 
    29682952                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    33913375        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    33923376        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" 
    33943378        METADATA 
    33953379                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34333417        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34343418        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" 
    34363420        METADATA 
    34373421                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34613445        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34623446        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" 
    34643448        METADATA 
    34653449                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34953479        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34963480        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" 
    35073482        METADATA 
    35083483                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    36913666        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    36923667        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" 
    36943669        METADATA 
    36953670                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    37173692        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    37183693        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" 
    37203695        METADATA 
    37213696                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    37933768        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    37943769        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" 
    37963771        METADATA 
    37973772                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    38223797        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    38233798        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" 
    38253800        METADATA 
    38263801                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-Version 
     1# WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion 
    22# Ä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" 
    43# 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_* 
    65MAP 
    76        NAME "alkis" 
    … …  
    2221                        wms_enable_request "getmap" 
    2322                        wms_box_extended "true" 
     23                        #include "meta_contact.map" 
    2424                END 
    2525        END 
    … …  
    330330        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    331331        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" 
    333333        METADATA 
    334334                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    356356        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    357357        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" 
    359359        METADATA 
    360360                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    383383        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    384384        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" 
    386386        METADATA 
    387387                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    408408        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    409409        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" 
    411411        METADATA 
    412412                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    432432        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    433433        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" 
    435435        METADATA 
    436436                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    458458        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    459459        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" 
    461461        METADATA 
    462462                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    483483        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    484484        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" 
    486486        METADATA 
    487487                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    508508        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    509509        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" 
    511511        METADATA 
    512512                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    534534        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    535535        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" 
    537537        METADATA 
    538538                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    561561        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    562562        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" 
    564564        METADATA 
    565565                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    619619        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    620620        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" 
    622622        METADATA 
    623623                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    644644        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    645645        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" 
    647647        METADATA 
    648648                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    677677        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    678678        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" 
    680680        METADATA 
    681681                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    703703        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    704704        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" 
    706706        METADATA 
    707707                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    729729        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    730730        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" 
    732732        METADATA 
    733733                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    756756        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    757757        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" 
    759759        METADATA 
    760760                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    798798        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    799799        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" 
    801801        METADATA 
    802802                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    822822        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    823823        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" 
    825825        METADATA 
    826826                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    846846        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    847847        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" 
    849849        METADATA 
    850850                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    870870        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    871871        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" 
    873873        METADATA 
    874874                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    894894        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    895895        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" 
    897897        METADATA 
    898898                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    919919        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    920920        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" 
    922922        METADATA 
    923923                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    944944        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    945945        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" 
    947947        METADATA 
    948948                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    969969        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    970970        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" 
    972972        METADATA 
    973973                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    994994        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    995995        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" 
    997997        METADATA 
    998998                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10191019        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10201020        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" 
    10221022        METADATA 
    10231023                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10461046        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10471047        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" 
    10491049        METADATA 
    10501050                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10961096        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10971097        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" 
    10991099        METADATA 
    11001100                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12621262        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12631263        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" 
    12651265        METADATA 
    12661266                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    16071607        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    16081608        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" 
    16101610        METADATA 
    16111611                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    17801780        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    17811781        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" 
    17831783        METADATA 
    17841784                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    18381838        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    18391839        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" 
    18411841        METADATA 
    18421842                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    19601960        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    19611961        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" 
    19631963        METADATA 
    19641964                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    19841984        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    19851985        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" 
    19871987        METADATA 
    19881988                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20092009        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20102010        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" 
    20122012        METADATA 
    20132013                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20342034        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20352035        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" 
    20372037        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    20382038        METADATA 
    … …  
    20702070        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20712071        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" 
    20732073        METADATA 
    20742074                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20952095        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20962096        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" 
    20982098        METADATA 
    20992099                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    21202120        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21212121        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" 
    21232123        #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" 
    21242124        METADATA 
    … …  
    21642164        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21652165        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" 
    21672167        #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" 
    21682168        METADATA 
    … …  
    21892189        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21902190        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" 
    21922192        METADATA 
    21932193                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22232223        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22242224        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" 
    22262226        METADATA 
    22272227                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22652265        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22662266        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" 
    22682268        METADATA 
    22692269                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24252425#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24262426#       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" 
    24282428#       METADATA 
    24292429#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24542454#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24552455#       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" 
    24572457#       METADATA 
    24582458#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24802480        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24812481        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" 
    24832483        METADATA 
    24842484                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    25062506        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25072507        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" 
    25092509        METADATA 
    25102510                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    27512751        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    27522752        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" 
    27542754        METADATA 
    27552755                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    27892789        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    27902790        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" 
    27922792        METADATA 
    27932793                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    28142814        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    28152815        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" 
    28172817        METADATA 
    28182818                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    28452845        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    28462846        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" 
    28482848        METADATA 
    28492849                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29302930        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29312931        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" 
    29332933        METADATA 
    29342934                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29532953        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29542954        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" 
    29562956        METADATA 
    29572957                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    30243024        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    30253025        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" 
    30273027        METADATA 
    30283028                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    30493049        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    30503050        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" 
    30523052        METADATA 
    30533053                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 

  • trunk/umn/alkis/alkis_muster_entw.map

    r330 r335  
    2424# 2014-08-25 F.J. krz  Straßennamen als P- und L-Variante, hinter "ap_pto_stra" neuer Layer "ap_lto_stra" 
    2525# 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_* 
    2627 
    2728### 
    … …  
    7576        FONTSET "fonts/fonts_alkis.fnt" 
    7677        UNITS METERS 
    77         #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" # Nur fuer Test 
     78        #CONFIG "MS_ERRORFILE" "/opt/gdi/log/umn.log" 
    7879        #DEBUG 3 
    7980        WEB 
    8081                METADATA 
    8182                        wms_title "ALKIS_" # TEST-Kennung im Title 
    82                         ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile Entwicklungs-Version vom August 2014" 
     83                        ows_abstract "ALKIS - Konverter PostNAS Version 0.8, Mapfile Entwicklungs-Version vom September 2014" 
    8384                        ows_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    8485                        ows_encoding "UTF-8" 
    … …  
    446447        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    447448        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" 
    449450        METADATA 
    450451                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    474475        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    475476        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" 
    477478        METADATA 
    478479                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    503504        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    504505        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" 
    506507        METADATA 
    507508                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    529530        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    530531        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" 
    532533        METADATA 
    533534                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    554555        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    555556        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" 
    557558        METADATA 
    558559                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    581582        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    582583        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" 
    584585        METADATA 
    585586                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    610611        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    611612        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" 
    613614        METADATA 
    614615                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    637638        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    638639        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" 
    640641        METADATA 
    641642                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    665666        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    666667        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" 
    668669        METADATA 
    669670                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    694695        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    695696        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" 
    697698        METADATA 
    698699                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    754755        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    755756        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" 
    757758        METADATA 
    758759                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    781782        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    782783        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" 
    784785        METADATA 
    785786                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    816817        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    817818        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" 
    819820        METADATA 
    820821                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    844845        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    845846        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" 
    847848        METADATA 
    848849                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    872873        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    873874        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" 
    875876        METADATA 
    876877                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    900901        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    901902        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" 
    903904        METADATA 
    904905                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    947948        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    948949        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" 
    950951        METADATA 
    951952                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    973974        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    974975        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" 
    976977        METADATA 
    977978                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    9991000        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10001001        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" 
    10021003        METADATA 
    10031004                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10261027        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10271028        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" 
    10291030        METADATA 
    10301031                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10521053        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10531054        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" 
    10551056        METADATA 
    10561057                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10781079        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10791080        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" 
    10811082        METADATA 
    10821083                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11041105        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11051106        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" 
    11071108        METADATA 
    11081109                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11301131        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11311132        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" 
    11331134        METADATA 
    11341135                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11561157        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11571158        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" 
    11591160        METADATA 
    11601161                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    11821183        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    11831184        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" 
    11851186        METADATA 
    11861187                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12131214        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12141215        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" 
    12161217        METADATA 
    12171218                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12741275        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12751276        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" 
    12771278        METADATA 
    12781279                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    14621463        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    14631464        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" 
    14651466        METADATA 
    14661467                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    18131814        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    18141815        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" 
    18161817        METADATA 
    18171818                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20262027        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20272028        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" 
    20292030        METADATA 
    20302031                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20872088        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20882089        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" 
    20902091        METADATA 
    20912092                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22672268        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22682269        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" 
    22702271        METADATA 
    22712272                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22962297        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22972298        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" 
    22992300        METADATA 
    23002301                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    23262327        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23272328        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" 
    23292330        METADATA 
    23302331                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    23532354        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23542355        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" 
    23562357        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    23572358        METADATA 
    … …  
    23922393        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    23932394        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" 
    23952396        METADATA 
    23962397                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24202421        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24212422        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" 
    24232424        METADATA 
    24242425                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24772478# 1750;"Denkmal, Denkstein, Standbild" 
    24782479 
    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" 
    24802481        #ILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" 
    24812482        #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    … …  
    25292530        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25302531        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" 
    25322533        #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" # sonst Absturz Mapserver 
    25332534        METADATA 
    … …  
    25592560        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25602561        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" 
    25622563        METADATA 
    25632564                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    25972598        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25982599        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" 
    26002601        METADATA 
    26012602                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    26422643        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    26432644        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" 
    26452646        METADATA 
    26462647                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29052906#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29062907#       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" 
    29082909#       METADATA 
    29092910#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29332934#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29342935#       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" 
    29362937#       METADATA 
    29372938#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29622963        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29632964        # 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" 
    29652966        # 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" 
    29672968        METADATA 
    29682969                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    33913392        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    33923393        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" 
    33943395        METADATA 
    33953396                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34333434        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34343435        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" 
    34363437        METADATA 
    34373438                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34613462        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34623463        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" 
    34643465        METADATA 
    34653466                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    34953496        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    34963497        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" 
    35073499        METADATA 
    35083500                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    36913683        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    36923684        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" 
    36943686        METADATA 
    36953687                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    37173709        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    37183710        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" 
    37203712        METADATA 
    37213713                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    37933785        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    37943786        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" 
    37963788        METADATA 
    37973789                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    38223814        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    38233815        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" 
    38253817        METADATA 
    38263818                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 

  • trunk/umn/alkis/alkis_muster_entw_4.map

    r330 r335  
    11# WMS: ALKIS PostNAS Muster mit Platzhalter *gkz* fÃŒr Mandant - Druckversion zur Entwickler-Version 
    22# Ä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" 
    43# 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_* 
    65MAP 
    76        NAME "alkis" 
    … …  
    331330        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    332331        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" 
    334333        METADATA 
    335334                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    357356        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    358357        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" 
    360359        METADATA 
    361360                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    384383        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    385384        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" 
    387386        METADATA 
    388387                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    409408        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    410409        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" 
    412411        METADATA 
    413412                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    433432        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    434433        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" 
    436435        METADATA 
    437436                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    459458        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    460459        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" 
    462461        METADATA 
    463462                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    484483        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    485484        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" 
    487486        METADATA 
    488487                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    509508        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    510509        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" 
    512511        METADATA 
    513512                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    535534        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    536535        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" 
    538537        METADATA 
    539538                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    562561        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    563562        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" 
    565564        METADATA 
    566565                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    620619        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    621620        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" 
    623622        METADATA 
    624623                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    645644        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    646645        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" 
    648647        METADATA 
    649648                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    678677        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    679678        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" 
    681680        METADATA 
    682681                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    704703        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    705704        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" 
    707706        METADATA 
    708707                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    730729        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    731730        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" 
    733732        METADATA 
    734733                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    757756        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    758757        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" 
    760759        METADATA 
    761760                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    799798        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    800799        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" 
    802801        METADATA 
    803802                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    823822        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    824823        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" 
    826825        METADATA 
    827826                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    847846        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    848847        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" 
    850849        METADATA 
    851850                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    871870        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    872871        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" 
    874873        METADATA 
    875874                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    895894        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    896895        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" 
    898897        METADATA 
    899898                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    920919        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    921920        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" 
    923922        METADATA 
    924923                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    945944        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    946945        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" 
    948947        METADATA 
    949948                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    970969        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    971970        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" 
    973972        METADATA 
    974973                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    995994        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    996995        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" 
    998997        METADATA 
    999998                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10201019        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10211020        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" 
    10231022        METADATA 
    10241023                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10471046        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10481047        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" 
    10501049        METADATA 
    10511050                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    10971096        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    10981097        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" 
    11001099        METADATA 
    11011100                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    12631262        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    12641263        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" 
    12661265        METADATA 
    12671266                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    16081607        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    16091608        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" 
    16111610        METADATA 
    16121611                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    17811780        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    17821781        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" 
    17841783        METADATA 
    17851784                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    18391838        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    18401839        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" 
    18421841        METADATA 
    18431842                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    19611960        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    19621961        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" 
    19641963        METADATA 
    19651964                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    19851984        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    19861985        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" 
    19881987        METADATA 
    19891988                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20102009        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20112010        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" 
    20132012        METADATA 
    20142013                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20352034        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20362035        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" 
    20382037        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
    20392038        METADATA 
    … …  
    20712070        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20722071        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" 
    20742073        METADATA 
    20752074                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    20962095        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    20972096        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" 
    20992098        METADATA 
    21002099                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    21212120        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21222121        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" 
    21242123        #FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" 
    21252124        METADATA 
    … …  
    21652164        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21662165        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" 
    21682167        #FILTER "st_geometrytype(wkb_geometry) = 'ST_LineString'" 
    21692168        METADATA 
    … …  
    21902189        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    21912190        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" 
    21932192        METADATA 
    21942193                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22242223        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22252224        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" 
    22272226        METADATA 
    22282227                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    22662265        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    22672266        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" 
    22692268        METADATA 
    22702269                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24262425#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24272426#       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" 
    24292428#       METADATA 
    24302429#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24552454#       CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24562455#       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" 
    24582457#       METADATA 
    24592458#               wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    24812480        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    24822481        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" 
    24842483        METADATA 
    24852484                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    25072506        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    25082507        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" 
    25102509        METADATA 
    25112510                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    27522751        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    27532752        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" 
    27552754        METADATA 
    27562755                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    27902789        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    27912790        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" 
    27932792        METADATA 
    27942793                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    28152814        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    28162815        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" 
    28182817        METADATA 
    28192818                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    28462845        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    28472846        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" 
    28492848        METADATA 
    28502849                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29312930        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29322931        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" 
    29342933        METADATA 
    29352934                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    29542953        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    29552954        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" 
    29572956        METADATA 
    29582957                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    30253024        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    30263025        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" 
    30283027        METADATA 
    30293028                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
    … …  
    30503049        CONNECTION "host=10.0.100.73 dbname=alkis08*gkz* user=ms6 port=5432" 
    30513050        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" 
    30533052        METADATA 
    30543053                wms_srs "EPSG:25832 EPSG:31467 EPSG:4326 EPSG:54004" 
Note: See TracChangeset for help on using the changeset viewer.