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.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" 
Note: See TracChangeset for help on using the changeset viewer.