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