Changeset 176 for trunk


Ignore:
Timestamp:
04/17/12 18:35:28 (8 years ago)
Author:
frank.jaeger
Message:

Flurstücksnummern an Standard-Position aus Fläche generieren

Location:
trunk/data
Files:
5 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/konvert/postnas_0.7/pp_definition.sql

    r163 r176  
    88--  2012-02-13 PostNAS 07, Umbenennung 
    99--  2012-02-17 Optimierung 
     10--  2012-02-28 gkz aus View nehmen 
     11--  2012-04-17 Flurstuecksnummern auf Standardposition 
     12 
    1013 
    1114-- ============================ 
     
    6669 
    6770 
    68 COMMENT ON TABLE  pp_gemeinde                IS 'Post-Processing: Gemeinde'; 
    69 COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer'; 
    70 COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant'; 
    71 COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÀzise Geometrie aus Summe aller Gemarkungen'; 
    72 COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.'; 
     71  COMMENT ON TABLE  pp_gemeinde                IS 'Post-Processing: Gemeinde'; 
     72  COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer'; 
     73--COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant'; 
     74  COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÀzise Geometrie aus Summe aller Gemarkungen'; 
     75  COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.'; 
    7376 
    7477 
     
    152155 
    153156 
    154 -- pp_  ? 
     157-- Prefix "pp_" verwenden  ? 
    155158 
    156159--DROP TABLE gemeinde_person; 
     
    175178 
    176179 
     180-- Flurstuecksnummern-Position 
     181-- =========================== 
     182 
     183-- ersetzt den View "s_flurstueck_nr" fÃŒr WMS-Layer "ag_t_flurstueck" 
     184 
     185--DROP TABLE pp_flurstueck_nr; 
     186 
     187  CREATE TABLE pp_flurstueck_nr ( 
     188    gid         serial, 
     189    fsgml       character(16), 
     190    fsnum       character varying(10),  -- zzzzz/nnnn 
     191    CONSTRAINT pp_flurstueck_nr_pk  PRIMARY KEY (gid), 
     192    CONSTRAINT pp_flurstueck_nr_gml FOREIGN KEY (fsgml) 
     193      REFERENCES ax_flurstueck (gml_id) MATCH SIMPLE 
     194      ON UPDATE CASCADE ON DELETE CASCADE 
     195  ); 
     196 
     197SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom','25832','POINT',2); 
     198 
     199-- Geometrischer Index 
     200CREATE INDEX pp_flurstueck_nr_gidx ON pp_flurstueck_nr USING gist(the_geom); 
     201 
     202-- Foreig-Key Index 
     203CREATE INDEX fki_pp_flurstueck_nr_gml ON pp_flurstueck_nr(fsgml); 
     204 
     205COMMENT ON TABLE  pp_flurstueck_nr           IS 'Post-Processing: Position der FlurstÃŒcksnummer in der Karte'; 
     206COMMENT ON COLUMN pp_flurstueck_nr.fsgml     IS 'gml_id des zugehörigen FlurstÃŒcks-Objektes'; 
     207COMMENT ON COLUMN pp_flurstueck_nr.fsnum     IS 'Label, Darzustellende FS-Nummer als Bruch'; 
     208COMMENT ON COLUMN pp_flurstueck_nr.the_geom  IS 'Position der FlurstÃŒcksnummer in der Karte'; 
     209 
     210 
    177211-- ===== 
    178212-- VIEWs  
     
    185219CREATE VIEW gemeinde_gemarkung 
    186220AS 
    187   SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname, g.gkz 
     221  SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname 
    188222  FROM pp_gemarkung k 
    189223  JOIN pp_gemeinde  g  
    190224    ON k.land = g.land  
    191    AND k.gemeinde = g.gemeinde 
    192 ; 
     225   AND k.gemeinde = g.gemeinde; 
    193226 
    194227-- VIEWs  fuer die Zuordnung vom EigentÃŒmern zu Gemeinden 
     
    228261    AND bnb.beziehungsart = 'istBestandteilVon' 
    229262    AND bbg.beziehungsart = 'istBestandteilVon' 
    230     AND bsf.beziehungsart = 'istGebucht' 
    231 ; 
     263    AND bsf.beziehungsart = 'istGebucht'; 
    232264 
    233265COMMENT ON VIEW gemeinde_person_typ1 IS 'Personen die EigentÃŒmer vom FlurstÃŒcken in einer Gemeinde sind. Typ1 = nomale Buchungen mit direkter Beziehung.'; 
     
    289321    AND  p.gemeinde = g.gemeinde 
    290322  GROUP BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, g.gemeindename, p.buchtyp 
    291   ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp 
    292 ; 
     323  ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp; 
    293324 
    294325COMMENT ON VIEW gemeinde_person_statistik IS 'ZÀhlen der Personen je Gemeinde und Buchungstyp'; 
  • trunk/data/konvert/postnas_0.7/pp_laden.sql

    r163 r176  
    88--  2012-02-13 PostNAS 07, Umbenennung 
    99--  2012-02-17 Optimierung 
     10--  2012-04-17 Flurstuecksnummern auf Standardposition 
    1011 
    1112 
     
    2223 
    2324-- Die per PostProcessing gefüllten Tabellen bekommen den Profix "pp_".  
     25 
     26-- Die Ausführung dieses Scriptes auf einer Datenbank für eine 80T-Einwohner-Stadt dauert ca.: 500 Sek. ! 
     27 
     28 
     29 
     30-- =========================== 
     31-- Flurstuecksnummern-Position 
     32-- =========================== 
     33 
     34-- ersetzt den View "s_flurstueck_nr" für WMS-Layer "ag_t_flurstueck" 
     35 
     36  DELETE FROM pp_flurstueck_nr; 
     37 
     38  INSERT INTO pp_flurstueck_nr 
     39          ( fsgml, fsnum, the_geom ) 
     40    SELECT f.gml_id, 
     41           f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum, 
     42           p.wkb_geometry  -- manuelle Position des Textes 
     43      FROM ap_pto             p 
     44      JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von 
     45      JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id 
     46     WHERE v.beziehungsart = 'dientZurDarstellungVon'  
     47     --AND p."art" = 'ZAE_NEN' 
     48   UNION  
     49    SELECT f.gml_id, 
     50           f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum, 
     51           ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry  -- Flaechenmitte als Position des Textes 
     52      FROM      ax_flurstueck     f  
     53      LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id 
     54     WHERE v.beziehungsart is NULL 
     55  ; 
     56-- Ausführung: mittlere Stadt: ca. 4 - 18 Sec. 
    2457 
    2558 
  • trunk/data/konvert/postnas_0.7/sichten.sql

    r162 r176  
    66 
    77--  2012-02-25 PostNAS 07, Umbenennung 
     8--  2012-04-17 flstnr_ohne_position 
     9 
    810 
    911--  ----------------------------------------- 
     
    1214 
    1315 
    14 -- Layer "ag_t_flurstueck" 
    15 -- ----------------------- 
     16-- WMS-Layer "ag_t_flurstueck" 
     17-- --------------------------- 
    1618 
    1719-- Die Geometrie befindet sich in "ap_pto", der Label in "ax_flurstueck" 
     
    2022 
    2123-- Bruchnummerierung erzeugen 
     24-- ALT 2012-04-17: Diese Version zeigt nur die manuell gesetzten Positionen 
    2225CREATE OR REPLACE VIEW s_flurstueck_nr 
    2326AS  
    24  SELECT ap_pto.ogc_fid,  
    25         ap_pto.wkb_geometry,   -- Position des Textes 
    26     --  ax_flurstueck.flurstueckskennzeichen,   -- am Stueck, aufgefuellt, unpraktisch 
    27     --  ax_flurstueck.gemarkungsnummer,  -- integer 
    28     --  ax_flurstueck.flurnummer,        -- integer 
    29     --  ax_flurstueck.zaehler,           -- integer 
    30     --  ax_flurstueck.nenner,            -- integer oder NULL 
    31         ax_flurstueck.zaehler::text || COALESCE ('/' || ax_flurstueck.nenner::text, '') AS fsnum 
    32    FROM ap_pto 
    33    JOIN alkis_beziehungen  
    34      ON ap_pto.gml_id = alkis_beziehungen.beziehung_von 
    35    JOIN ax_flurstueck  
    36      ON alkis_beziehungen.beziehung_zu = ax_flurstueck.gml_id 
    37   WHERE alkis_beziehungen.beziehungsart = 'dientZurDarstellungVon' 
     27 SELECT f.ogc_fid,  
     28        p.wkb_geometry,  -- Position des Textes 
     29        f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 
     30   FROM ap_pto             p 
     31   JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von 
     32   JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id 
     33  WHERE v.beziehungsart = 'dientZurDarstellungVon'  
     34  --AND p."art" = 'ZAE_NEN' 
    3835  ; 
    3936 
    4037COMMENT ON VIEW s_flurstueck_nr IS 'fuer Kartendarstellung: Bruchnummerierung FlurstÃŒck'; 
     38 
     39-- NEU 2012-04-17 
     40-- Wenn keine manuelle Position gesetzt ist, wird die Flaechenmitte verwendet 
     41 
     42-- ACHTUNG: Dieser View kann nicht direkt im Mapserver-WMS verwendet werden. 
     43-- Die Anzeige ist zu langsam. Filterung ÃŒber BBOX kann nicht funktionieren, da zunÀchst ALLE Standardpositionen  
     44-- berechnet werden mÃŒssen, bevor darÃŒber gefiltert werden kann. 
     45 
     46-- FAZIT: In einer Hilfstabelle mit geometrischem Index zwischenspeichern. 
     47--        Siehe PostProcessing Tabelle "pp_flurstueck_nr" 
     48 
     49CREATE OR REPLACE VIEW s_flurstueck_nr2 
     50AS  
     51  SELECT f.ogc_fid,  
     52         p.wkb_geometry,  -- manuelle Position des Textes 
     53         f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 
     54    FROM ap_pto             p 
     55    JOIN alkis_beziehungen  v  ON p.gml_id       = v.beziehung_von 
     56    JOIN ax_flurstueck      f  ON v.beziehung_zu = f.gml_id 
     57   WHERE v.beziehungsart = 'dientZurDarstellungVon'  
     58   --AND p."art" = 'ZAE_NEN' 
     59 UNION  
     60  SELECT f.ogc_fid, 
     61         ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry,  -- Flaechenmitte als Position des Textes 
     62         f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 
     63    FROM      ax_flurstueck     f  
     64    LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id 
     65   WHERE v.beziehungsart is NULL 
     66  ; 
     67 
     68COMMENT ON VIEW s_flurstueck_nr2 IS 'Bruchnummerierung FlurstÃŒck, auch Standard-Position. Nicht direkt fuer WMS verwenden'; 
    4169 
    4270 
     
    313341--  Sichten fuer Fehlersuche und Daten-Analyse 
    314342--  ------------------------------------------ 
     343 
     344 
     345-- FlurstÃŒcke mit Anzeige der FlurstÃŒcksnummer an der "Standardposition" 
     346 
     347-- Nach der Konvertierung aus ALK hat zunÀchst jedes FlurstÃŒck eine explizit gesetzte Position der FlurstÃŒcksnummer. 
     348 
     349-- Nach einer manuellen Teilung bekommen die neuen FlurstÃŒcke im ALKIS nur dann eine Position, 
     350-- wenn die Positioin manuell bestimmt (verschoben) wurde. 
     351-- Wenn die FlurstÃŒcksnummer an ihrer "Standardposition" angezeigt werden soll,  
     352-- dann wird diese in den Daten (DHK, NAS) nicht gesetzt. 
     353-- Der Konverter PostNAS konvertiert aber nur die Daten, die er bekommt, er setzt nicht die Standard-Position  
     354-- fÃŒr die FlurstÃŒcke, die ohne eine manuelle Position kommen. 
     355 
     356-- Diese FÀlle identifizieren 
     357CREATE OR REPLACE VIEW flstnr_ohne_position 
     358AS  
     359 SELECT f.gml_id,  
     360        f.gemarkungsnummer || '-' || f.flurnummer || '-' || f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS such -- Suchstring fÃŒr ALKIS-Navigation nach FS-Kennzeichen 
     361 FROM        ax_flurstueck     f  
     362   LEFT JOIN alkis_beziehungen v  ON v.beziehung_zu = f.gml_id 
     363 --LEFT JOIN ap_pto            p  ON p.gml_id       = v.beziehung_von 
     364  WHERE v.beziehungsart is NULL 
     365--ORDER BY f.gemarkungsnummer, f.flurnummer, f.zaehler 
     366  ; 
     367 
     368COMMENT ON VIEW flstnr_ohne_position IS 'FlurstÃŒcke ohne manuell gesetzte Position fÃŒr die PrÀsentation der FS-Nr'; 
     369 
    315370 
    316371-- Zeigt die Texte an, die nicht in einem der Mapfile-Views verarbeitet werden 
  • trunk/data/umn/alkis07/alkis07_muster.map

    r171 r176  
    55# 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6 
    66# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete 
    7 # 2012-03-05 A.E. WG   PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html 
     7# 2012-03-05 F.J. krz  PROCESSING "CLOSE_CONNECTION=DEFER" 
     8# 2012-04-17 F.J. krz  Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr 
     9#                      Auch Standard-Position vom Flurstuecksnummern anzeigen 
    810 
    911# ToDo: 
     
    7678        DUMP true 
    7779        CONNECTIONTYPE POSTGIS 
    78         PROCESSING "CLOSE_CONNECTION=DEFER" 
    79         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     80        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     81        PROCESSING "CLOSE_CONNECTION=DEFER" 
    8082        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 
    8183        METADATA 
     
    120122        DUMP true 
    121123        CONNECTIONTYPE POSTGIS 
    122         PROCESSING "CLOSE_CONNECTION=DEFER" 
    123         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     124        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     125        PROCESSING "CLOSE_CONNECTION=DEFER" 
    124126        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 
    125127        METADATA 
     
    162164        DUMP true 
    163165        CONNECTIONTYPE POSTGIS 
    164         PROCESSING "CLOSE_CONNECTION=DEFER" 
    165         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     166        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     167        PROCESSING "CLOSE_CONNECTION=DEFER" 
    166168        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 
    167169        METADATA 
     
    254256        DUMP TRUE 
    255257        CONNECTIONTYPE POSTGIS 
    256         PROCESSING "CLOSE_CONNECTION=DEFER" 
    257         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     258        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     259        PROCESSING "CLOSE_CONNECTION=DEFER" 
    258260        DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 
    259261        METADATA 
     
    662664        REQUIRES "![nutzung_alle]" 
    663665        CONNECTIONTYPE POSTGIS 
    664         PROCESSING "CLOSE_CONNECTION=DEFER" 
    665         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     666        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     667        PROCESSING "CLOSE_CONNECTION=DEFER" 
    666668        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 
    667669        METADATA 
     
    695697        REQUIRES "![nutzung_alle]" 
    696698        CONNECTIONTYPE POSTGIS 
    697         PROCESSING "CLOSE_CONNECTION=DEFER" 
    698         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     699        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     700        PROCESSING "CLOSE_CONNECTION=DEFER" 
    699701        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 
    700702        METADATA 
     
    728730        REQUIRES "![nutzung_alle]" 
    729731        CONNECTIONTYPE POSTGIS 
    730         PROCESSING "CLOSE_CONNECTION=DEFER" 
    731         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     732        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     733        PROCESSING "CLOSE_CONNECTION=DEFER" 
    732734        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 
    733735        METADATA 
     
    759761        REQUIRES "![nutzung_alle]" 
    760762        CONNECTIONTYPE POSTGIS 
    761         PROCESSING "CLOSE_CONNECTION=DEFER" 
    762         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     763        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     764        PROCESSING "CLOSE_CONNECTION=DEFER" 
    763765        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 
    764766        METADATA 
     
    789791        REQUIRES "![nutzung_alle]" 
    790792        CONNECTIONTYPE POSTGIS 
    791         PROCESSING "CLOSE_CONNECTION=DEFER" 
    792         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     793        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     794        PROCESSING "CLOSE_CONNECTION=DEFER" 
    793795        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 
    794796        METADATA 
     
    820822        REQUIRES "![nutzung_alle]" 
    821823        CONNECTIONTYPE POSTGIS 
    822         PROCESSING "CLOSE_CONNECTION=DEFER" 
    823         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     824        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     825        PROCESSING "CLOSE_CONNECTION=DEFER" 
    824826        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 
    825827        METADATA 
     
    853855        REQUIRES "![nutzung_alle]" 
    854856        CONNECTIONTYPE POSTGIS 
    855         PROCESSING "CLOSE_CONNECTION=DEFER" 
    856         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     857        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     858        PROCESSING "CLOSE_CONNECTION=DEFER" 
    857859        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 
    858860        METADATA 
     
    884886        REQUIRES "![nutzung_alle]" 
    885887        CONNECTIONTYPE POSTGIS 
    886         PROCESSING "CLOSE_CONNECTION=DEFER" 
    887         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     888        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     889        PROCESSING "CLOSE_CONNECTION=DEFER" 
    888890        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 
    889891        METADATA 
     
    916918        REQUIRES "![nutzung_alle]" 
    917919        CONNECTIONTYPE POSTGIS 
    918         PROCESSING "CLOSE_CONNECTION=DEFER" 
    919         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     920        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     921        PROCESSING "CLOSE_CONNECTION=DEFER" 
    920922        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 
    921923        METADATA 
     
    951953        REQUIRES "![nutzung_alle]" 
    952954        CONNECTIONTYPE POSTGIS 
    953         PROCESSING "CLOSE_CONNECTION=DEFER" 
    954         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     955        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     956        PROCESSING "CLOSE_CONNECTION=DEFER" 
    955957        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 
    956958        METADATA 
     
    10151017        REQUIRES "![nutzung_alle]" 
    10161018        CONNECTIONTYPE POSTGIS 
    1017         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1018         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1019        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1020        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10191021        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 
    10201022        METADATA 
     
    10461048        REQUIRES "![nutzung_alle]" 
    10471049        CONNECTIONTYPE POSTGIS 
    1048         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1049         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1050        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1051        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10501052        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 
    10511053        METADATA 
     
    10851087        REQUIRES "![nutzung_alle]" 
    10861088        CONNECTIONTYPE POSTGIS 
    1087         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1088         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1089        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1090        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10891091        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 
    10901092        METADATA 
     
    11171119        REQUIRES "![nutzung_alle]" 
    11181120        CONNECTIONTYPE POSTGIS 
    1119         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1120         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1121        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1122        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11211123        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 
    11221124        METADATA 
     
    11491151        REQUIRES "![nutzung_alle]" 
    11501152        CONNECTIONTYPE POSTGIS 
    1151         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1152         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1153        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1154        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11531155        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 
    11541156        METADATA 
     
    11831185        REQUIRES "![nutzung_alle]" 
    11841186        CONNECTIONTYPE POSTGIS 
    1185         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1186         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1187        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1188        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11871189        DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 
    11881190        METADATA 
     
    12341236        REQUIRES "![nutzung_alle]" 
    12351237        CONNECTIONTYPE POSTGIS 
    1236         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1237         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1238        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1239        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12381240        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 
    12391241        METADATA 
     
    12641266        REQUIRES "![nutzung_alle]" 
    12651267        CONNECTIONTYPE POSTGIS 
    1266         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1267         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1268        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1269        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12681270        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 
    12691271        METADATA 
     
    12941296        REQUIRES "![nutzung_alle]" 
    12951297        CONNECTIONTYPE POSTGIS 
    1296         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1297         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1298        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1299        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12981300        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 
    12991301        METADATA 
     
    13241326        REQUIRES "![nutzung_alle]" 
    13251327        CONNECTIONTYPE POSTGIS 
    1326         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1327         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1328        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1329        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13281330        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 
    13291331        METADATA 
     
    13541356        REQUIRES "![nutzung_alle]" 
    13551357        CONNECTIONTYPE POSTGIS 
    1356         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1357         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1358        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1359        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13581360        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 
    13591361        METADATA 
     
    13861388        REQUIRES "![nutzung_alle]" 
    13871389        CONNECTIONTYPE POSTGIS 
    1388         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1389         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1390        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1391        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13901392        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 
    13911393        METADATA 
     
    14161418        REQUIRES "![nutzung_alle]" 
    14171419        CONNECTIONTYPE POSTGIS 
    1418         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1419         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1420        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1421        PROCESSING "CLOSE_CONNECTION=DEFER" 
    14201422        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 
    14211423        METADATA 
     
    14481450        REQUIRES "![nutzung_alle]" 
    14491451        CONNECTIONTYPE POSTGIS 
    1450         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1451         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1452        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1453        PROCESSING "CLOSE_CONNECTION=DEFER" 
    14521454        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 
    14531455        METADATA 
     
    14781480        REQUIRES "![nutzung_alle]" 
    14791481        CONNECTIONTYPE POSTGIS 
    1480         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1481         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1482        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1483        PROCESSING "CLOSE_CONNECTION=DEFER" 
    14821484        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 
    14831485        METADATA 
     
    15081510        REQUIRES "![nutzung_alle]" 
    15091511        CONNECTIONTYPE POSTGIS 
    1510         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1511         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1512        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1513        PROCESSING "CLOSE_CONNECTION=DEFER" 
    15121514        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    15131515        METADATA 
     
    15451547        # REQUIRES "![nutzung_alle]" 
    15461548        CONNECTIONTYPE POSTGIS 
    1547         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1548         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1549        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1550        PROCESSING "CLOSE_CONNECTION=DEFER" 
    15491551        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    15501552        # Feld funktion, Werte 1010, 1030, 1040 
     
    15791581        DUMP TRUE 
    15801582        CONNECTIONTYPE POSTGIS 
    1581         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1582         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1583        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1584        PROCESSING "CLOSE_CONNECTION=DEFER" 
    15831585        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    15841586        # Statt EXPRESSION filtern besser gleich als WHERE in SQL 
     
    16151617        DUMP TRUE 
    16161618        CONNECTIONTYPE POSTGIS 
    1617         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1618         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1619        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1620        PROCESSING "CLOSE_CONNECTION=DEFER" 
    16191621        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 
    16201622        METADATA 
     
    16611663        DUMP TRUE 
    16621664        CONNECTIONTYPE POSTGIS 
    1663         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1664         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1665        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1666        PROCESSING "CLOSE_CONNECTION=DEFER" 
    16651667        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    16661668        METADATA 
     
    16951697        DUMP TRUE 
    16961698        CONNECTIONTYPE POSTGIS 
    1697         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1698         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1699        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1700        PROCESSING "CLOSE_CONNECTION=DEFER" 
    16991701        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 
    17001702        METADATA 
     
    17321734        DUMP TRUE 
    17331735        CONNECTIONTYPE POSTGIS 
    1734         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1735         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1736        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1737        PROCESSING "CLOSE_CONNECTION=DEFER" 
    17361738 
    17371739        # Tabelle (Standard-Template) 
     
    19681970        DUMP TRUE 
    19691971        CONNECTIONTYPE POSTGIS 
    1970         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1971         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1972        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1973        PROCESSING "CLOSE_CONNECTION=DEFER" 
    19721974        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    19731975        METADATA 
     
    19982000        DUMP TRUE 
    19992001        CONNECTIONTYPE POSTGIS 
    2000         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2001         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2002        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2003        PROCESSING "CLOSE_CONNECTION=DEFER" 
    20022004        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 
    20032005        METADATA 
     
    20422044        TYPE POLYGON 
    20432045        CONNECTIONTYPE POSTGIS 
    2044         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2045         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2046        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2047        PROCESSING "CLOSE_CONNECTION=DEFER" 
    20462048        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" 
    20472049        # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das? 
     
    24012403        DUMP TRUE 
    24022404        CONNECTIONTYPE POSTGIS 
    2403         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2404         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2405        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2406        PROCESSING "CLOSE_CONNECTION=DEFER" 
    24052407        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" 
    24062408        METADATA 
     
    25632565        DUMP TRUE 
    25642566        CONNECTIONTYPE POSTGIS 
    2565         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2566         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2567        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2568        PROCESSING "CLOSE_CONNECTION=DEFER" 
    25672569        DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 
    25682570        METADATA 
     
    26322634        DUMP TRUE 
    26332635        CONNECTIONTYPE POSTGIS 
    2634         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2635         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2636        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2637        PROCESSING "CLOSE_CONNECTION=DEFER" 
    26362638        DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 
    26372639        METADATA 
     
    26672669        DUMP TRUE 
    26682670        CONNECTIONTYPE POSTGIS 
    2669         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2670         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2671        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2672        PROCESSING "CLOSE_CONNECTION=DEFER" 
    26712673        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 
    26722674 
     
    27162718        DUMP TRUE 
    27172719        CONNECTIONTYPE POSTGIS 
    2718         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2719         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2720        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2721        PROCESSING "CLOSE_CONNECTION=DEFER" 
    27202722        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel, laufendenummer FROM s_nummer_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View 
    27212723        # "s_nummer_nebengebaeude" = View 
     
    27682770        DUMP TRUE 
    27692771        CONNECTIONTYPE POSTGIS 
    2770         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2771         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2772        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2773        PROCESSING "CLOSE_CONNECTION=DEFER" 
    27722774        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    27732775 
     
    28022804        DUMP TRUE 
    28032805        CONNECTIONTYPE POSTGIS 
    2804         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2805         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2806        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2807        PROCESSING "CLOSE_CONNECTION=DEFER" 
    28062808        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    28072809        METADATA 
     
    28352837        DUMP TRUE 
    28362838        CONNECTIONTYPE POSTGIS 
    2837         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2838         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2839        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2840        PROCESSING "CLOSE_CONNECTION=DEFER" 
    28392841        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    28402842        METADATA 
     
    28682870        DUMP TRUE 
    28692871        CONNECTIONTYPE POSTGIS 
    2870         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2871         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2872        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2873        PROCESSING "CLOSE_CONNECTION=DEFER" 
    28722874        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 
    28732875        METADATA 
     
    28992901        DUMP TRUE 
    29002902        CONNECTIONTYPE POSTGIS 
    2901         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2902         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2903        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2904        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29032905        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 
    29042906        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    29412943        DUMP TRUE 
    29422944        CONNECTIONTYPE POSTGIS 
    2943         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2944         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2945        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2946        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29452947        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 
    29462948        METADATA 
     
    29722974        DUMP TRUE 
    29732975        CONNECTIONTYPE POSTGIS 
    2974         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2975         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2976        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2977        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29762978        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 
    29772979        METADATA 
     
    30033005        DUMP TRUE 
    30043006        CONNECTIONTYPE POSTGIS 
    3005         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3006         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3007        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3008        PROCESSING "CLOSE_CONNECTION=DEFER" 
    30073009        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 
    30083010        FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    30763078        DUMP TRUE 
    30773079        CONNECTIONTYPE POSTGIS 
    3078         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3079         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3080        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3081        PROCESSING "CLOSE_CONNECTION=DEFER" 
    30803082        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 
    30813083        METADATA 
     
    31173119        DUMP TRUE 
    31183120        CONNECTIONTYPE POSTGIS 
    3119         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3120         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3121        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3122        PROCESSING "CLOSE_CONNECTION=DEFER" 
    31213123        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 
    31223124        METADATA 
     
    31653167        DUMP TRUE 
    31663168        CONNECTIONTYPE POSTGIS 
    3167         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3168         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3169        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3170        PROCESSING "CLOSE_CONNECTION=DEFER" 
    31693171        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 
    31703172        METADATA 
     
    32013203        DUMP TRUE 
    32023204        CONNECTIONTYPE POSTGIS 
    3203         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3204         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3205        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3206        PROCESSING "CLOSE_CONNECTION=DEFER" 
    32053207        # mit Feldern fuer klassisches Template: 
    32063208        #  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" 
     
    32473249        DUMP TRUE 
    32483250        CONNECTIONTYPE POSTGIS 
    3249         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3250         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3251        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3252        PROCESSING "CLOSE_CONNECTION=DEFER" 
    32513253        DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 
    32523254        METADATA 
     
    33783380# Ausgestaltung FS (DATA: Views in DB anlegen fuer Beziehungen) 
    33793381 
    3380 # Flurstuecknummer 
     3382# Flurstuecksnummer 
    33813383 
    33823384# Musterdaten RLP: zaehler-nenner steht auch in Feld "ap_pto.schriftinhalt" 
     
    33883390        DUMP TRUE 
    33893391        CONNECTIONTYPE POSTGIS 
    3390         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3391         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    3392         DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 
    3393         # View: ap_pto >dientZurDarstellungVon> ax_flurstueck 
    3394         # Felder: ogc_fid, wkb_geometry, gemarkungsnummer, flurnummer, zaehler, nenner, fsnum 
    3395         METADATA 
    3396                 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
    3397                 wms_title "FlurstÃŒcknummer" 
    3398                 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer" 
     3392        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3393        PROCESSING "CLOSE_CONNECTION=DEFER" 
     3394#       DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View 
     3395        DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing 
     3396        METADATA 
     3397                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     3398                wms_title "FlurstÃŒcksnummer" 
     3399                wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer" 
    33993400                gml_include_items "all" 
    34003401        END 
     
    34433444#        
    34443445#       CONNECTIONTYPE POSTGIS 
    3445         PROCESSING "CLOSE_CONNECTION=DEFER" 
    34463446#       CONNECTION "host=localhost dbname=obk user=alkis" 
    34473447#       DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" 
     
    35103510#       DUMP TRUE 
    35113511#       CONNECTIONTYPE POSTGIS 
    3512         PROCESSING "CLOSE_CONNECTION=DEFER" 
    35133512#       CONNECTION "host=localhost dbname=obk user=alkis" 
    35143513#       DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" 
     
    35453544#       DUMP TRUE 
    35463545#       CONNECTIONTYPE POSTGIS 
    3547         PROCESSING "CLOSE_CONNECTION=DEFER" 
    35483546#       CONNECTION "host=localhost dbname=obk user=alkis" 
    35493547#       DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" 
     
    35863584        TYPE LINE 
    35873585        CONNECTIONTYPE POSTGIS 
    3588         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3589         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3586        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3587        PROCESSING "CLOSE_CONNECTION=DEFER" 
    35903588        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    35913589        METADATA 
     
    36173615        STATUS ON 
    36183616        CONNECTIONTYPE POSTGIS 
    3619         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3620         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3617        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3618        PROCESSING "CLOSE_CONNECTION=DEFER" 
    36213619        DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 
    36223620        METADATA 
     
    36563654        TYPE POINT 
    36573655        CONNECTIONTYPE POSTGIS 
    3658         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3659         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3656        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3657        PROCESSING "CLOSE_CONNECTION=DEFER" 
    36603658        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    36613659        METADATA 
     
    36833681                        SIZE 14 MINSIZE 7 MAXSIZE 24 
    36843682                        POSITION cc 
    3685                 #       OFFSET 0 0 
    36863683                        COLOR 0 0 0 
    36873684                        ANGLE [drehwinkel] 
     
    37023699        DUMP TRUE 
    37033700        CONNECTIONTYPE POSTGIS 
    3704         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3705         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3701        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3702        PROCESSING "CLOSE_CONNECTION=DEFER" 
    37063703        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 
    37073704        METADATA 
     
    37353732        DUMP TRUE 
    37363733        CONNECTIONTYPE POSTGIS 
    3737         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3738         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3734        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3735        PROCESSING "CLOSE_CONNECTION=DEFER" 
    37393736        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 
    37403737        METADATA 
     
    37693766        DUMP TRUE 
    37703767        CONNECTIONTYPE POSTGIS 
    3771         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3772         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3768        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3769        PROCESSING "CLOSE_CONNECTION=DEFER" 
    37733770        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 
    37743771        METADATA 
     
    38033800        DUMP TRUE 
    38043801        CONNECTIONTYPE POSTGIS 
    3805         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3806         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3802        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3803        PROCESSING "CLOSE_CONNECTION=DEFER" 
    38073804        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 
    38083805        METADATA 
     
    38343831        DUMP TRUE 
    38353832        CONNECTIONTYPE POSTGIS 
    3836         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3837         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3833        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3834        PROCESSING "CLOSE_CONNECTION=DEFER" 
    38383835        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 
    38393836        METADATA 
     
    38753872        DUMP TRUE 
    38763873        CONNECTIONTYPE POSTGIS 
    3877         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3878         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3874        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3875        PROCESSING "CLOSE_CONNECTION=DEFER" 
    38793876 
    38803877        #DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832" 
     
    39853982        DUMP TRUE 
    39863983        CONNECTIONTYPE POSTGIS 
    3987         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3988         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3984        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3985        PROCESSING "CLOSE_CONNECTION=DEFER" 
    39893986        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 
    39903987        METADATA 
     
    40484045        #SYMBOLSCALEDENOM 1000 
    40494046        CONNECTIONTYPE POSTGIS 
    4050         PROCESSING "CLOSE_CONNECTION=DEFER" 
    4051         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4047        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4048        PROCESSING "CLOSE_CONNECTION=DEFER" 
    40524049        DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 
    40534050        CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106} 
     
    41294126        SYMBOLSCALEDENOM 1000 
    41304127        CONNECTIONTYPE POSTGIS 
    4131         PROCESSING "CLOSE_CONNECTION=DEFER" 
    4132         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4128        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4129        PROCESSING "CLOSE_CONNECTION=DEFER" 
    41334130        DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 
    41344131        CLASS 
     
    41664163        SYMBOLSCALEDENOM 1000 
    41674164        CONNECTIONTYPE POSTGIS 
    4168         PROCESSING "CLOSE_CONNECTION=DEFER" 
    4169         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4165        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     4166        PROCESSING "CLOSE_CONNECTION=DEFER" 
    41704167        DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 
    41714168        CLASS 
  • trunk/data/umn/alkis07/alkis07_muster_4.map

    r171 r176  
    55# 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6 
    66# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete 
    7 # 2012-03-05 A.E. WG   PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html 
     7# 2012-03-05 F.J. krz  PROCESSING "CLOSE_CONNECTION=DEFER" 
     8# 2012-04-17 F.J. krz  Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr 
     9#                      Auch Standard-Position vom Flurstuecksnummern anzeigen 
     10 
    811MAP 
    912        NAME "alkis" 
     
    5760        DUMP true 
    5861        CONNECTIONTYPE POSTGIS 
    59         PROCESSING "CLOSE_CONNECTION=DEFER" 
    60         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     62        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     63        PROCESSING "CLOSE_CONNECTION=DEFER" 
    6164        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 
    6265        METADATA 
     
    101104        #DUMP true 
    102105        CONNECTIONTYPE POSTGIS 
    103         PROCESSING "CLOSE_CONNECTION=DEFER" 
    104         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     106        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     107        PROCESSING "CLOSE_CONNECTION=DEFER" 
    105108        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 
    106109        METADATA 
     
    143146        #DUMP true 
    144147        CONNECTIONTYPE POSTGIS 
    145         PROCESSING "CLOSE_CONNECTION=DEFER" 
    146         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     148        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     149        PROCESSING "CLOSE_CONNECTION=DEFER" 
    147150        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 
    148151        METADATA 
     
    183186        #DUMP TRUE 
    184187        CONNECTIONTYPE POSTGIS 
    185         PROCESSING "CLOSE_CONNECTION=DEFER" 
    186         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     188        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     189        PROCESSING "CLOSE_CONNECTION=DEFER" 
    187190        DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 
    188191        METADATA 
     
    478481        REQUIRES "![nutzung_alle]" 
    479482        CONNECTIONTYPE POSTGIS 
    480         PROCESSING "CLOSE_CONNECTION=DEFER" 
    481         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     483        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     484        PROCESSING "CLOSE_CONNECTION=DEFER" 
    482485        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 
    483486        METADATA 
     
    511514        REQUIRES "![nutzung_alle]" 
    512515        CONNECTIONTYPE POSTGIS 
    513         PROCESSING "CLOSE_CONNECTION=DEFER" 
    514         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     516        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     517        PROCESSING "CLOSE_CONNECTION=DEFER" 
    515518        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 
    516519        METADATA 
     
    544547        REQUIRES "![nutzung_alle]" 
    545548        CONNECTIONTYPE POSTGIS 
    546         PROCESSING "CLOSE_CONNECTION=DEFER" 
    547         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     549        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     550        PROCESSING "CLOSE_CONNECTION=DEFER" 
    548551        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 
    549552        METADATA 
     
    575578        REQUIRES "![nutzung_alle]" 
    576579        CONNECTIONTYPE POSTGIS 
    577         PROCESSING "CLOSE_CONNECTION=DEFER" 
    578         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     580        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     581        PROCESSING "CLOSE_CONNECTION=DEFER" 
    579582        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 
    580583        METADATA 
     
    605608        REQUIRES "![nutzung_alle]" 
    606609        CONNECTIONTYPE POSTGIS 
    607         PROCESSING "CLOSE_CONNECTION=DEFER" 
    608         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     610        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     611        PROCESSING "CLOSE_CONNECTION=DEFER" 
    609612        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 
    610613        METADATA 
     
    636639        REQUIRES "![nutzung_alle]" 
    637640        CONNECTIONTYPE POSTGIS 
    638         PROCESSING "CLOSE_CONNECTION=DEFER" 
    639         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     641        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     642        PROCESSING "CLOSE_CONNECTION=DEFER" 
    640643        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 
    641644        METADATA 
     
    669672        REQUIRES "![nutzung_alle]" 
    670673        CONNECTIONTYPE POSTGIS 
    671         PROCESSING "CLOSE_CONNECTION=DEFER" 
    672         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     674        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     675        PROCESSING "CLOSE_CONNECTION=DEFER" 
    673676        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 
    674677        METADATA 
     
    700703        REQUIRES "![nutzung_alle]" 
    701704        CONNECTIONTYPE POSTGIS 
    702         PROCESSING "CLOSE_CONNECTION=DEFER" 
    703         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     705        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     706        PROCESSING "CLOSE_CONNECTION=DEFER" 
    704707        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 
    705708        METADATA 
     
    732735        REQUIRES "![nutzung_alle]" 
    733736        CONNECTIONTYPE POSTGIS 
    734         PROCESSING "CLOSE_CONNECTION=DEFER" 
    735         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     737        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     738        PROCESSING "CLOSE_CONNECTION=DEFER" 
    736739        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 
    737740        METADATA 
     
    767770        REQUIRES "![nutzung_alle]" 
    768771        CONNECTIONTYPE POSTGIS 
    769         PROCESSING "CLOSE_CONNECTION=DEFER" 
    770         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     772        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     773        PROCESSING "CLOSE_CONNECTION=DEFER" 
    771774        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 
    772775        METADATA 
     
    831834        REQUIRES "![nutzung_alle]" 
    832835        CONNECTIONTYPE POSTGIS 
    833         PROCESSING "CLOSE_CONNECTION=DEFER" 
    834         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     836        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     837        PROCESSING "CLOSE_CONNECTION=DEFER" 
    835838        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 
    836839        METADATA 
     
    862865        REQUIRES "![nutzung_alle]" 
    863866        CONNECTIONTYPE POSTGIS 
    864         PROCESSING "CLOSE_CONNECTION=DEFER" 
    865         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     867        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     868        PROCESSING "CLOSE_CONNECTION=DEFER" 
    866869        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 
    867870        METADATA 
     
    901904        REQUIRES "![nutzung_alle]" 
    902905        CONNECTIONTYPE POSTGIS 
    903         PROCESSING "CLOSE_CONNECTION=DEFER" 
    904         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     906        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     907        PROCESSING "CLOSE_CONNECTION=DEFER" 
    905908        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 
    906909        METADATA 
     
    933936        REQUIRES "![nutzung_alle]" 
    934937        CONNECTIONTYPE POSTGIS 
    935         PROCESSING "CLOSE_CONNECTION=DEFER" 
    936         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     938        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     939        PROCESSING "CLOSE_CONNECTION=DEFER" 
    937940        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 
    938941        METADATA 
     
    965968        REQUIRES "![nutzung_alle]" 
    966969        CONNECTIONTYPE POSTGIS 
    967         PROCESSING "CLOSE_CONNECTION=DEFER" 
    968         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     970        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     971        PROCESSING "CLOSE_CONNECTION=DEFER" 
    969972        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 
    970973        METADATA 
     
    9991002        REQUIRES "![nutzung_alle]" 
    10001003        CONNECTIONTYPE POSTGIS 
    1001         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1002         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1004        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1005        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10031006        DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 
    10041007        METADATA 
     
    10491052        TYPE POLYGON 
    10501053        CONNECTIONTYPE POSTGIS 
    1051         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1052         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1054        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1055        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10531056        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 
    10541057        METADATA 
     
    10781081        TYPE POLYGON 
    10791082        CONNECTIONTYPE POSTGIS 
    1080         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1081         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1083        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1084        PROCESSING "CLOSE_CONNECTION=DEFER" 
    10821085        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 
    10831086        METADATA 
     
    11071110        TYPE POLYGON 
    11081111        CONNECTIONTYPE POSTGIS 
    1109         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1110         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1112        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1113        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11111114        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 
    11121115        METADATA 
     
    11361139        TYPE POLYGON 
    11371140        CONNECTIONTYPE POSTGIS 
    1138         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1139         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1141        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1142        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11401143        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 
    11411144        METADATA 
     
    11651168        TYPE POLYGON 
    11661169        CONNECTIONTYPE POSTGIS 
    1167         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1168         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1170        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1171        PROCESSING "CLOSE_CONNECTION=DEFER" 
    11691172        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 
    11701173        METADATA 
     
    11971200        REQUIRES "![nutzung_alle]" 
    11981201        CONNECTIONTYPE POSTGIS 
    1199         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1200         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1202        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1203        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12011204        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 
    12021205        METADATA 
     
    12271230        REQUIRES "![nutzung_alle]" 
    12281231        CONNECTIONTYPE POSTGIS 
    1229         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1230         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1232        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1233        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12311234        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 
    12321235        METADATA 
     
    12591262        REQUIRES "![nutzung_alle]" 
    12601263        CONNECTIONTYPE POSTGIS 
    1261         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1262         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1264        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1265        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12631266        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 
    12641267        METADATA 
     
    12891292        REQUIRES "![nutzung_alle]" 
    12901293        CONNECTIONTYPE POSTGIS 
    1291         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1292         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1294        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1295        PROCESSING "CLOSE_CONNECTION=DEFER" 
    12931296        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 
    12941297        METADATA 
     
    13191322        REQUIRES "![nutzung_alle]" 
    13201323        CONNECTIONTYPE POSTGIS 
    1321         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1322         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1324        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1325        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13231326        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    13241327        METADATA 
     
    13541357        #DUMP TRUE # _4 
    13551358        CONNECTIONTYPE POSTGIS 
    1356         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1357         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1359        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1360        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13581361        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    13591362        # Feld funktion, Werte 1010, 1030, 1040 
     
    13891392        #DUMP TRUE # _4 
    13901393        CONNECTIONTYPE POSTGIS 
    1391         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1392         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1394        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1395        PROCESSING "CLOSE_CONNECTION=DEFER" 
    13931396        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    13941397        # Statt EXPRESSION filtern besser gleich als WHERE in SQL 
     
    14241427        #DUMP TRUE # _4 
    14251428        CONNECTIONTYPE POSTGIS 
    1426         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1427         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1429        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1430        PROCESSING "CLOSE_CONNECTION=DEFER" 
    14281431        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 
    14291432        METADATA 
     
    14701473        #DUMP TRUE # _4 
    14711474        CONNECTIONTYPE POSTGIS 
    1472         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1473         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1475        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1476        PROCESSING "CLOSE_CONNECTION=DEFER" 
    14741477        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    14751478        METADATA 
     
    15011504        #DUMP TRUE # _4 
    15021505        CONNECTIONTYPE POSTGIS 
    1503         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1504         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1506        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1507        PROCESSING "CLOSE_CONNECTION=DEFER" 
    15051508        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 
    15061509        METADATA 
     
    15371540        TYPE POLYGON 
    15381541        CONNECTIONTYPE POSTGIS 
    1539         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1540         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1542        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1543        PROCESSING "CLOSE_CONNECTION=DEFER" 
    15411544        DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 
    15421545        METADATA 
     
    16411644        #DUMP TRUE # _4 
    16421645        CONNECTIONTYPE POSTGIS 
    1643         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1644         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1646        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1647        PROCESSING "CLOSE_CONNECTION=DEFER" 
    16451648        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    16461649        METADATA 
     
    16711674        #DUMP TRUE # _4 
    16721675        CONNECTIONTYPE POSTGIS 
    1673         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1674         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1676        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1677        PROCESSING "CLOSE_CONNECTION=DEFER" 
    16751678        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 
    16761679        METADATA 
     
    17051708        TYPE POLYGON 
    17061709        CONNECTIONTYPE POSTGIS 
    1707         PROCESSING "CLOSE_CONNECTION=DEFER" 
    1708         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1710        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     1711        PROCESSING "CLOSE_CONNECTION=DEFER" 
    17091712        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" 
    17101713        METADATA 
     
    20452048        TYPE POLYGON 
    20462049        CONNECTIONTYPE POSTGIS 
    2047         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2048         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2050        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2051        PROCESSING "CLOSE_CONNECTION=DEFER" 
    20492052        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" 
    20502053        METADATA 
     
    21702173        #DUMP TRUE # _4 
    21712174        CONNECTIONTYPE POSTGIS 
    2172         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2173         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2175        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2176        PROCESSING "CLOSE_CONNECTION=DEFER" 
    21742177        DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 
    21752178        METADATA 
     
    22352238        #DUMP TRUE # _4 
    22362239        CONNECTIONTYPE POSTGIS 
    2237         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2238         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2240        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2241        PROCESSING "CLOSE_CONNECTION=DEFER" 
    22392242        DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 
    22402243        METADATA 
     
    22712274        #DUMP TRUE # _4 
    22722275        CONNECTIONTYPE POSTGIS 
    2273         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2274         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2276        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2277        PROCESSING "CLOSE_CONNECTION=DEFER" 
    22752278        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 
    22762279        METADATA 
     
    23222325        DUMP TRUE 
    23232326        CONNECTIONTYPE POSTGIS 
    2324         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2325         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2327        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2328        PROCESSING "CLOSE_CONNECTION=DEFER" 
    23262329        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,laufendenummer FROM s_nummer_nebengebaeude) as foo using unique ogc_fid using SRID=25832" # View 
    23272330        METADATA 
     
    23742377        DUMP TRUE 
    23752378        CONNECTIONTYPE POSTGIS 
    2376         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2377         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2379        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2380        PROCESSING "CLOSE_CONNECTION=DEFER" 
    23782381        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    23792382 
     
    24082411        #DUMP TRUE # _4 
    24092412        CONNECTIONTYPE POSTGIS 
    2410         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2411         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2413        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2414        PROCESSING "CLOSE_CONNECTION=DEFER" 
    24122415        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    24132416        METADATA 
     
    24412444        #DUMP TRUE # _4 
    24422445        CONNECTIONTYPE POSTGIS 
    2443         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2444         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2446        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2447        PROCESSING "CLOSE_CONNECTION=DEFER" 
    24452448        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    24462449        METADATA 
     
    24722475        #DUMP TRUE # _4 
    24732476        CONNECTIONTYPE POSTGIS 
    2474         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2475         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2477        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2478        PROCESSING "CLOSE_CONNECTION=DEFER" 
    24762479        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 
    24772480        METADATA 
     
    25032506        #DUMP TRUE # _4 
    25042507        CONNECTIONTYPE POSTGIS 
    2505         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2506         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2508        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2509        PROCESSING "CLOSE_CONNECTION=DEFER" 
    25072510        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 
    25082511        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    25452548        #DUMP TRUE # _4 
    25462549        CONNECTIONTYPE POSTGIS 
    2547         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2548         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2550        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2551        PROCESSING "CLOSE_CONNECTION=DEFER" 
    25492552        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 
    25502553        METADATA 
     
    25762579        #DUMP TRUE # _4 
    25772580        CONNECTIONTYPE POSTGIS 
    2578         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2579         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2581        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2582        PROCESSING "CLOSE_CONNECTION=DEFER" 
    25802583        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 
    25812584        METADATA 
     
    26062609        TYPE POLYGON 
    26072610        CONNECTIONTYPE POSTGIS 
    2608         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2609         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2611        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2612        PROCESSING "CLOSE_CONNECTION=DEFER" 
    26102613        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 
    26112614        FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    26472650        #DUMP TRUE # _4 
    26482651        CONNECTIONTYPE POSTGIS 
    2649         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2650         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2652        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2653        PROCESSING "CLOSE_CONNECTION=DEFER" 
    26512654        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 
    26522655        METADATA 
     
    26882691        #DUMP TRUE # _4 
    26892692        CONNECTIONTYPE POSTGIS 
    2690         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2691         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2693        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2694        PROCESSING "CLOSE_CONNECTION=DEFER" 
    26922695        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 
    26932696        METADATA 
     
    27342737        #DUMP TRUE # _4 
    27352738        CONNECTIONTYPE POSTGIS 
    2736         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2737         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2739        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2740        PROCESSING "CLOSE_CONNECTION=DEFER" 
    27382741        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 
    27392742        METADATA 
     
    27692772        TYPE POLYGON 
    27702773        CONNECTIONTYPE POSTGIS 
    2771         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2772         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2774        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2775        PROCESSING "CLOSE_CONNECTION=DEFER" 
    27732776        DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    27742777        METADATA 
     
    28022805        #DUMP TRUE # _4 
    28032806        CONNECTIONTYPE POSTGIS 
    2804         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2805         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2807        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2808        PROCESSING "CLOSE_CONNECTION=DEFER" 
    28062809        DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 
    28072810        METADATA 
     
    29272930END 
    29282931 
    2929 # Flurstuecknummer 
     2932# Flurstuecksnummer 
    29302933LAYER 
    29312934        NAME "ag_t_flurstueck" 
     
    29342937        #DUMP TRUE # _4 
    29352938        CONNECTIONTYPE POSTGIS 
    2936         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2937         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    2938         DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 
    2939         METADATA 
    2940                 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
    2941                 wms_title "Flurstuecknummer" 
    2942                 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer" 
     2939        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2940        PROCESSING "CLOSE_CONNECTION=DEFER" 
     2941#       DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View 
     2942        DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing 
     2943        METADATA 
     2944                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     2945                wms_title "Flurstuecksnummer" 
     2946                wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer" 
    29432947                #gml_include_items "all" 
    29442948        END 
     
    29882992        #DUMP TRUE # _4 
    29892993        CONNECTIONTYPE POSTGIS 
    2990         PROCESSING "CLOSE_CONNECTION=DEFER" 
    2991         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2994        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     2995        PROCESSING "CLOSE_CONNECTION=DEFER" 
    29922996        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    29932997        METADATA 
     
    30223026        STATUS ON 
    30233027        CONNECTIONTYPE POSTGIS 
    3024         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3025         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3028        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3029        PROCESSING "CLOSE_CONNECTION=DEFER" 
    30263030        DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 
    30273031        METADATA 
     
    30613065        #DUMP TRUE # _4 
    30623066        CONNECTIONTYPE POSTGIS 
    3063         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3064         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3067        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3068        PROCESSING "CLOSE_CONNECTION=DEFER" 
    30653069        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    30663070        METADATA 
     
    30813085                LABEL 
    30823086                        TYPE TRUETYPE 
    3083                         FONT "alk_textsymbols" 
     3087                        FONT "alkis_textsymbols" 
    30843088                        SIZE 28.4 #7.1 
    30853089                        POSITION cc 
     
    31033107        #DUMP TRUE # _4 
    31043108        CONNECTIONTYPE POSTGIS 
    3105         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3106         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3109        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3110        PROCESSING "CLOSE_CONNECTION=DEFER" 
    31073111        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 
    31083112        METADATA 
     
    31363140        #DUMP TRUE # _4 
    31373141        CONNECTIONTYPE POSTGIS 
    3138         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3139         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3142        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3143        PROCESSING "CLOSE_CONNECTION=DEFER" 
    31403144        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 
    31413145        METADATA 
     
    31703174        #DUMP TRUE # _4 
    31713175        CONNECTIONTYPE POSTGIS 
    3172         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3173         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3176        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3177        PROCESSING "CLOSE_CONNECTION=DEFER" 
    31743178        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 
    31753179        METADATA 
     
    32043208        #DUMP TRUE # _4 
    32053209        CONNECTIONTYPE POSTGIS 
    3206         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3207         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3210        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3211        PROCESSING "CLOSE_CONNECTION=DEFER" 
    32083212        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 
    32093213        METADATA 
     
    32353239        #DUMP TRUE # _4 
    32363240        CONNECTIONTYPE POSTGIS 
    3237         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3238         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3241        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3242        PROCESSING "CLOSE_CONNECTION=DEFER" 
    32393243        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 
    32403244        METADATA 
     
    32753279        #DUMP TRUE # _4 
    32763280        CONNECTIONTYPE POSTGIS 
    3277         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3278         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3281        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3282        PROCESSING "CLOSE_CONNECTION=DEFER" 
    32793283         
    32803284        #DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832" 
     
    33253329        TYPE LINE 
    33263330        CONNECTIONTYPE POSTGIS 
    3327         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3328         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3331        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3332        PROCESSING "CLOSE_CONNECTION=DEFER" 
    33293333        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 
    33303334        METADATA 
     
    33843388        #SYMBOLSCALEDENOM 1000 
    33853389        CONNECTIONTYPE POSTGIS 
    3386         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3387         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3390        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3391        PROCESSING "CLOSE_CONNECTION=DEFER" 
    33883392        DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 
    33893393        CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106} 
     
    34653469        SYMBOLSCALEDENOM 250 # 1000 
    34663470        CONNECTIONTYPE POSTGIS 
    3467         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3468         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3471        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3472        PROCESSING "CLOSE_CONNECTION=DEFER" 
    34693473        DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 
    34703474        CLASS 
     
    35023506        SYMBOLSCALEDENOM 250 #1000 
    35033507        CONNECTIONTYPE POSTGIS 
    3504         PROCESSING "CLOSE_CONNECTION=DEFER" 
    3505         CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3508        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     3509        PROCESSING "CLOSE_CONNECTION=DEFER" 
    35063510        DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 
    35073511        CLASS 
Note: See TracChangeset for help on using the changeset viewer.