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.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • 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.