Changeset 163 for trunk/data

Timestamp:

02/17/12 14:57:42 (12 years ago)

Author:

frank.jaeger

Message:

Vers. 0.7: Flächen von Fluren, Gemarkungen, Gemeinden zusammen fassen und darstellen

Location:

trunk/data

Files:

• konvert/postnas_0.7/konv_batch.sh (modified) (5 diffs)
• konvert/postnas_0.7/ordner_konvertieren.sh (modified) (6 diffs)
• konvert/postnas_0.7/pp_definition.sql (modified) (7 diffs)
• konvert/postnas_0.7/pp_laden.sql (modified) (5 diffs)
• umn/alkis07/alkis07_muster.map (modified) (71 diffs)
• umn/alkis07/alkis07_muster_4.map (modified) (70 diffs)

trunk/data/konvert/postnas_0.7/konv_batch.sh

@@ -5 +5 @@
 ## Batch-Teil, Aufruf mit geprueften Parametern    -
 ## -------------------------------------------------
+##
+## Ordner-Struktur:
+##   /mandant/
+##           /0001/*.xml.zip
+##           /0002/*.xml.zip
+##          usw.
+##           /temp/
+##   Auf der gleichen Ebene wie die Datenordner muss ein Ordner /temp/ existieren.
+##   Dort werden die NAS-Daten temporär ausgepackt.
+##   Relativ zum mitgegebenen Parameter ist das: '../temp/'
+##   Parallel laufende Konvertierungen zum gleichen Mandanten 
+##   würden hier durcheinander geraten. Vermeiden!
+##
 ## Stand: 
 ##   2012-02-10 Umbennung nach 0.7
+##   2012-02-17 Optimierung
 ##
-## Konverter:   /opt/gdal-1.9/bin/ = GDAL 1.9 / PostNAS 0.7
+## Konverter:   /opt/gdal-1.9.1/bin/ = GDAL 1.9-DEV / PostNAS 0.7
 ## Koordinaten: EPSG:25832  UTM, Zone 32
 ##              -a_srs EPSG:25832   - bleibt im UTM-System (korrigierte Werte)
@@ -50 +64 @@
 # DB-Connection
 con="-p 5432 -d ${DBNAME} "
-#
 echo "Datenbank-Name . . = ${DBNAME}"
 echo "Ordner NAS-Daten . = ${ORDNER}"
@@ -76 +89 @@
     then
       # E R S T L A D E N
-      /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
+      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
          PG:"dbname=${DBNAME} host=localhost port=5432" \
          -a_srs EPSG:25832  ${nasdatei}  ${layer}  2>> $errprot
@@ -85 +98 @@
       # A K T U A L I S I E R U N G
       echo "- 1. Nur delete-Layer auswerten" 
-      /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
+      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
          PG:"dbname=${DBNAME} host=localhost port=5432" \
          -a_srs EPSG:25832  ${nasdatei}  delete  2>> $errprot
@@ -96 +109 @@
       #
       echo "- 2. alle Layer auswerten"
-      /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
+      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \
         PG:"dbname=${DBNAME} host=localhost port=5432" \
         -a_srs EPSG:25832  ${nasdatei}  ${layer}  2>> $errprot

trunk/data/konvert/postnas_0.7/ordner_konvertieren.sh

@@ -3 +3 @@
 ## Konvertierung von ALKIS NAS-Format nach PosGIS  -
 ## NAS-Daten in einem Ordner konvertieren          -
-## Dialog-Teil zum Ermitteln der Parameter         -
+## Dialog-Teil zum Abfragen der Parameter          -
 ## -------------------------------------------------
 ## Stand:
 ##  2012-02-10  PostNAS 07, Umbenennung
+##  2012-02-17  Parameter "DBUSER" raus
 ## 
 function get_db_config(){
-
+        #
         # Name der zu ladenden ALKIS-Datenbank
+        #
         until [ -n "$DBNAME" ]
         do
@@ -17 +19 @@
                 read DBNAME
         done
-
-        echo ""
-        echo "Datenbank-User?"
-        read DBUSER
-
-#       echo ""
-#       echo "Datenbank-Passwort?"
-#       stty -echo
-#               read DBPASS
-#       stty echo
-
-        ## Ordner (Eingabedaten)
+        #
+        # Ordner (Eingabedaten)
+        #
         echo ""
         echo "Ordner mit gezippten NAS-Daten (*.xml.zip)? (Absoluter Pfad)"
@@ -43 +36 @@
                 LSRESULT=$?
         done
-
+        #
         # Erstladen oder NBA-Aktualisierung
+        #
         echo " "
         echo "Art der Konvertierung"
@@ -54 +48 @@
                 read UPD
         done
+        #
         # Bestaetigung holen
+        #
         echo " "
         echo "Abschließende Bestätigung:"
@@ -74 +70 @@
 echo "** Konvertierung ALKIS **" > /data/konvert/postnas_0.7/log/postnas_err.prot
 echo "** Beginn Batch **"
-##                                                1        2        3        4        5
-         /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $DBUSER  $UPD
+##                                       1        2        3
+/data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $UPD
 result=$?
 if [ $result = 0 ]
@@ -85 +81 @@
 echo " "
 echo " Kommando fuer Wiederholung:"
-echo " /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $DBUSER  $UPD "
+echo " /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $UPD "
 echo " "
 ###

trunk/data/konvert/postnas_0.7/pp_definition.sql

@@ -2 +2 @@
 -- ALKIS PostNAS 0.7
 
--- Post Processing Teil 1: Anlegen der Tabellen
+-- Post Processing (pp_) Teil 1: Anlegen der Tabellen und Views
 
 -- Stand 
 
 --  2012-02-13 PostNAS 07, Umbenennung
+--  2012-02-17 Optimierung
 
 -- ============================
@@ -42 +43 @@
 
   CREATE TABLE pp_gemeinde (
-    land                integer,
+    gid                 serial,
+    land                integer NOT NULL,
     regierungsbezirk    integer,
     kreis               integer,
-    gemeinde            integer,
+    gemeinde            integer NOT NULL,
     gemeindename        character varying(80),
-    gkz                 character varying(03),  -- wird (noch) nicht benutzt
+ -- gkz                 character varying(03),  -- wird (noch) nicht benutzt
     anz_gemarkg         integer,                -- Anzahl Gemarkungen
     CONSTRAINT pp_gemeinde_pk PRIMARY KEY (land, gemeinde)
   );
 
-
--- GesamtflÀche
+-- ALTER TABLE pp_gemeinde ADD COLUMN gid serial;
+CREATE UNIQUE INDEX pp_gemeinde_gid_ix ON pp_gemeinde (gid);
+
+-- Gesamtflaeche
 SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2);
-
--- Index
 CREATE INDEX pp_gemeinde_gidx ON pp_gemeinde USING gist(the_geom);
 
--- vereinfachte GesamtflÀche
+-- vereinfachte Gesamtflaeche
 SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2);
-
 CREATE INDEX pp_gemeinde_sgidx ON pp_gemeinde USING gist(simple_geom);
 
@@ -68 +69 @@
 COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer';
 COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant';
+COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÀzise Geometrie aus Summe aller Gemarkungen';
+COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.';
 
 
@@ -80 +83 @@
 -- muss diese Information als (redundante) Tabelle nach dem Laden zwischengespeichert werden. 
 
---CREATE TABLE gemeinde_gemarkung (  -- PostNAS 0.6
-  CREATE TABLE pp_gemarkung (        -- PostNAS 0.7
-    land                integer,
+--CREATE TABLE gemeinde_gemarkung (             -- alt: PostNAS 0.6
+  CREATE TABLE pp_gemarkung (                   -- PostNAS 0.7
+    gid                 serial,
+    land                integer NOT NULL,
     regierungsbezirk    integer,
     kreis               integer,
-    gemeinde            integer,        -- fast ein Foreign-Key Constraint
+    gemeinde            integer NOT NULL,       -- fast ein Foreign-Key Constraint
     gemarkung           integer NOT NULL,
     gemarkungsname      character varying(80),
-    anz_flur            integer,        -- Anzahl Fluren
+    anz_flur            integer,                -- Anzahl Fluren
     CONSTRAINT pp_gemarkung_pk PRIMARY KEY (land, gemarkung)
   );
 
+-- ALTER TABLE pp_gemarkung ADD COLUMN gid serial;
+CREATE UNIQUE INDEX pp_gemarkung_gid_ix ON pp_gemarkung (gid);
 
 -- GesamtflÀche
 SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2);
-
--- Index
 CREATE INDEX pp_gemarkung_gidx ON pp_gemarkung USING gist(the_geom);
-
 
 -- vereinfachte GesamtflÀche
 SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2);
-
 CREATE INDEX pp_gemarkung_sgidx ON pp_gemarkung USING gist(simple_geom);
 
 
-COMMENT ON TABLE  pp_gemarkung                IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde';
-COMMENT ON COLUMN pp_gemarkung.gemeinde       IS 'Gemeindenummer';
-COMMENT ON COLUMN pp_gemarkung.gemarkung      IS 'Gemarkungsnummer';
+COMMENT ON TABLE  pp_gemarkung               IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde';
+COMMENT ON COLUMN pp_gemarkung.gemeinde      IS 'Gemeindenummer';
+COMMENT ON COLUMN pp_gemarkung.gemarkung     IS 'Gemarkungsnummer';
+COMMENT ON COLUMN pp_gemarkung.the_geom      IS 'prÀzise Geometrie aus Summe aller Fluren';
+COMMENT ON COLUMN pp_gemarkung.simple_geom   IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.';
 
 
@@ -115 +119 @@
 
   CREATE TABLE pp_flur (
-    land                integer,
+    gid                 serial,
+    land                integer NOT NULL,
     regierungsbezirk    integer,
     kreis               integer,
     gemarkung           integer NOT NULL,
     flurnummer          integer NOT NULL,
-    anz_fs              integer,        -- Anzahl FlurstÃŒcke
+    anz_fs              integer,                -- Anzahl FlurstÃŒcke
     CONSTRAINT pp_flur_pk PRIMARY KEY (land, gemarkung, flurnummer)
   );
 
+-- ALTER TABLE pp_flur ADD COLUMN gid serial;
+CREATE UNIQUE INDEX pp_flur_gid_ix ON pp_flur (gid);
+
 -- GesamtflÀche
 SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2);
-
--- Index
 CREATE INDEX pp_flur_gidx ON pp_flur USING gist(the_geom);
 
 COMMENT ON TABLE  pp_flur                IS 'Post-Processing: Flur';
 COMMENT ON COLUMN pp_flur.gemarkung      IS 'Gemarkungsnummer';
+COMMENT ON COLUMN pp_flur.the_geom       IS 'Geometrie aus Summe aller FlurstÃŒcke';
 
 
@@ -150 +157 @@
 
   CREATE TABLE gemeinde_person (
-    land                        integer,
+    land                integer,
     regierungsbezirk    integer,
-    kreis                       integer,
+    kreis               integer,
     gemeinde            integer,
-    person              character varying(16), 
+    person              character varying(16),
     buchtyp             integer,
     CONSTRAINT gemeinde_person_pk PRIMARY KEY (gemeinde, person)
@@ -288 +295 @@
 
 
+-- Views zur Analyse der vereinfachten Geometrie
+-- Finden des richtigen Genauigkeits-Wertes fÃŒr die Vereinfachung der Geometrie
+
+-- z.B. Gemeinden:  10 Meter
+--      Gemarkungen: 4 Meter
+
+CREATE VIEW pp_gemeinde_analyse AS
+  SELECT land, gemeinde, gemeindename,
+         st_npoints(the_geom)    AS umring_alle_punkte,
+         st_npoints(simple_geom) AS umring_einfache_punkte
+  FROM pp_gemeinde;
+
+
+CREATE VIEW pp_gemarkung_analyse AS
+  SELECT land, gemeinde, gemarkung, gemarkungsname,
+         st_npoints(the_geom)    AS umring_alle_punkte,
+         st_npoints(simple_geom) AS umring_einfache_punkte
+  FROM pp_gemarkung;
+
+
 -- ENDE --

trunk/data/konvert/postnas_0.7/pp_laden.sql

@@ -2 +2 @@
 -- ALKIS PostNAS 0.7
 
--- Post Processing Teil 2: Laden der Tabellen
+-- Post Processing (pp_) Teil 2: Laden der Tabellen
 
 -- Stand 
 
 --  2012-02-13 PostNAS 07, Umbenennung
+--  2012-02-17 Optimierung
 
 
@@ -81 +82 @@
 
 
--- ===============================================================
--- Geometrien der Flurstücke zu größeren Einheiten zusammen fassen
--- ===============================================================
+-- ==============================================================================
+-- Geometrien der Flurstücke schrittweise zu groesseren Einheiten zusammen fassen
+-- ==============================================================================
+
+-- Dies macht nur Sinn, wenn der Inhalt der Datenbenk einen ganzen Katasterbezirk enthält.
+-- Wenn ein Gebiet durch geometrische Filter im NBA ausgegeben wurde, dann gibt es Randstreifen, 
+-- die zu Pseudo-Fluren zusammen gefasst werden. Fachlich falsch!
 
 INSERT INTO pp_flur (land, regierungsbezirk, kreis, gemarkung, flurnummer, anz_fs, the_geom )
@@ -104 +109 @@
    );
 
--- Fluren zählen
+-- Fluren zaehlen
 UPDATE pp_gemarkung a
   SET anz_flur = 
@@ -112 +117 @@
    ); -- Gemarkungsnummer ist je BundesLand eindeutig
 
--- Geometrie vereinfachen
-UPDATE pp_gemarkung SET simple_geom = simplify(the_geom, 4.0);
-
-COMMENT ON COLUMN pp_gemarkung.simple_geom     IS 'Vereinfachte Geometrie mit 4 Meter-Genauigkeit. Für Anzeige von Übersichten in kleinen Maßstäben.';
+-- Geometrie vereinfachen (Wirkung siehe pp_gemarkung_analyse)
+UPDATE pp_gemarkung SET simple_geom = simplify(the_geom, 8.0);
 
 
@@ -137 +140 @@
    );
 
--- Geometrie vereinfachen
-
-UPDATE pp_gemeinde SET simple_geom = simplify(the_geom, 10.0);
-
-COMMENT ON COLUMN pp_gemeinde.simple_geom     IS 'Vereinfachte Geometrie mit 10 Meter-Genauigkeit. Für Anzeige von Übersichten in kleinen Maßstäben.';
-
+-- Geometrie vereinfachen (Wirkung siehe pp_gemeinde_analyse)
+UPDATE pp_gemeinde SET simple_geom = simplify(the_geom, 20.0);
 
 

trunk/data/umn/alkis07/alkis07_muster.map

@@ -4 +4 @@
 
 # 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6
+# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete
 
 # ToDo:
@@ -61 +62 @@
         END
 
-# ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetaion)
+
+# ** aus Post-Processing: Katasterbezirke
+
+# Die Layer dieser Gruppe nur anzeigen lassen, wenn der Inhalt der Datenbenk einen ganzen Katasterbezirk enthÀlt.
+# Wenn ein Gebiet durch geometrische Filter im NBA ausgegeben wurde, dann gibt es Randstreifen, 
+# die zu Pseudo-Fluren zusammen gefasst werden. Fachlich falsch!
+
+LAYER
+        NAME "pp_gemeinde"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Gemeinde"
+                wms_abstract "GemeindeflÀche (vereinfachte Geometrie)"
+                wms_group_title "Gebiete"
+                wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden"
+                gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM   8000
+        MAXSCALEDENOM 400000
+        LABELITEM gemeindename
+        CLASS
+                NAME "Gemeinde"
+                STYLE
+                        OUTLINECOLOR 10 10 200
+                        WIDTH 7
+                        PATTERN 8 22 END
+                END
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 10 10 200
+                        FONT "arial"
+                        SIZE 20
+                        POSITION cc
+                        OFFSET 0 -20
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
+LAYER
+        NAME "pp_gemarkung"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Gemarkung"
+                wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)"
+                gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM  4000
+        MAXSCALEDENOM 40000
+        LABELITEM gemarkungsname
+        CLASS
+                NAME "Gemarkung"
+                STYLE
+                        OUTLINECOLOR 140 80 0
+                        WIDTH 5
+                        PATTERN 3 12 END
+                END
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 140 80 0
+                        FONT "arial"
+                        SIZE 16
+                        POSITION cc
+                        OFFSET 0 10
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
+LAYER
+        NAME "pp_flur"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Flur"
+                wms_abstract "Flur"
+                gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM  1600
+        MAXSCALEDENOM 20000
+        CLASS
+                NAME "Flur"
+                TEXT "Flur [flurnummer]" 
+                STYLE
+                        OUTLINECOLOR 100 150 10
+                        WIDTH 3
+                        PATTERN 1 8 END
+                END
+
+                #STYLE # fuer TEST Flaechendeckung?
+                #       COLOR 100 150 10
+                #       SYMBOL "sn3631"
+                #       SIZE 10
+                #END
+
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 100 150 10
+                        FONT "arial"
+                        SIZE 14
+                        POSITION cc
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
+
+# ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetation)
 # alle Layer von GROUP "ax_nutzungen"
 
@@ -110 +250 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832"
         METADATA
@@ -258 +398 @@
                 NAME "Platz"
                 STYLE
-                #       COLOR -1 -1 -1 #?
                         OUTLINECOLOR 153 153 153
                 END
@@ -518 +657 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -550 +689 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -582 +721 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -612 +751 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -641 +780 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -671 +810 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -703 +842 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -733 +872 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -764 +903 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -798 +937 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -861 +1000 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -891 +1030 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -929 +1068 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -960 +1099 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -991 +1130 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1024 +1163 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1074 +1213 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1103 +1242 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1132 +1271 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1161 +1300 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1190 +1329 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1221 +1360 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1250 +1389 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1281 +1420 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1310 +1449 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1339 +1478 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1375 +1514 @@
         # REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
         # Feld funktion, Werte 1010, 1030, 1040
@@ -1408 +1547 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
         # Statt EXPRESSION filtern besser gleich als WHERE in SQL
@@ -1443 +1582 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1488 +1627 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1521 +1660 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1557 +1696 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
 
         # Tabelle (Standard-Template)
@@ -1792 +1931 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1821 +1960 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1864 +2003 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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"
         # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das?
@@ -2222 +2361 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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"
         METADATA
@@ -2383 +2522 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2451 +2590 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2485 +2624 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832"
 
@@ -2533 +2672 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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
         # "s_nummer_nebengebaeude" = View
@@ -2584 +2723 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 
@@ -2617 +2756 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2649 +2788 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2681 +2820 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2711 +2850 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832"
         FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2752 +2891 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2782 +2921 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2812 +2951 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832"
         FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2884 +3023 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2924 +3063 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2971 +3110 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3006 +3145 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         # mit Feldern fuer klassisches Template:
         #  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"
@@ -3051 +3190 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3191 +3330 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832"
         # View: ap_pto >dientZurDarstellungVon> ax_flurstueck
@@ -3385 +3524 @@
         TYPE LINE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert
         METADATA
@@ -3415 +3554 @@
         STATUS ON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
         METADATA
@@ -3453 +3592 @@
         TYPE POINT
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3498 +3637 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3530 +3669 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3563 +3702 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3596 +3735 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3626 +3765 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3666 +3805 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
 
         #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"
@@ -3775 +3914 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3837 +3976 @@
         #SYMBOLSCALEDENOM 1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832'
         CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106}
@@ -3917 +4056 @@
         SYMBOLSCALEDENOM 1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832'
         CLASS
@@ -3953 +4092 @@
         SYMBOLSCALEDENOM 1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832'
         CLASS

trunk/data/umn/alkis07/alkis07_muster_4.map

@@ -4 +4 @@
 
 # 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6
+# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete
 
 MAP
@@ -47 +48 @@
         END
 
+
+# ** aus Post-Processing: Katasterbezirke
+
+LAYER
+        NAME "pp_gemeinde"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Gemeinde"
+                wms_abstract "GemeindeflÀche (vereinfachte Geometrie)"
+                wms_group_title "Gebiete"
+                wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden"
+                gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM 2000 #8000
+        MAXSCALEDENOM 100000 #400000
+        LABELITEM gemeindename
+        CLASS
+                NAME "Gemeinde"
+                STYLE
+                        OUTLINECOLOR 10 10 200
+                        WIDTH 28 #7
+                        PATTERN 32 88 END # 8 22
+                END
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 10 10 200
+                        FONT "arial"
+                        SIZE 80 # 20
+                        POSITION cc
+                        OFFSET 0 -80 # 0 -20
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
+LAYER
+        NAME "pp_gemarkung"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        #DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Gemarkung"
+                wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)"
+                #gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM 1000 #4000
+        MAXSCALEDENOM 10000 #40000
+        LABELITEM gemarkungsname
+        CLASS
+                NAME "Gemarkung"
+                STYLE
+                        OUTLINECOLOR 140 80 0
+                        WIDTH 20 #5
+                        PATTERN 12 48 END #3 12
+                END
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 140 80 0
+                        FONT "arial"
+                        SIZE 64 #16
+                        POSITION cc
+                        OFFSET 0 40 # 0 10
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
+LAYER
+        NAME "pp_flur"
+        GROUP "pp_gebiete"
+        TYPE POLYGON
+        #DUMP true
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
+        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832"
+        METADATA
+                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004"
+                wms_title "Flur"
+                wms_abstract "Flur"
+                #gml_include_items "all"
+        END
+        PROJECTION
+                "init=epsg:25832"
+        END
+        EXTENT 349000 5529000 356000 5533000
+        MINSCALEDENOM 400 #1600
+        MAXSCALEDENOM 5000 #20000
+        LABELITEM flurnummer
+        CLASS
+                NAME "Flur"
+                STYLE
+                        OUTLINECOLOR 100 150 10
+                        WIDTH 12 #3
+                        PATTERN 2 32 END # 1 8
+                END
+                LABEL
+                        TYPE TRUETYPE
+                        COLOR 100 150 10
+                        FONT "arial"
+                        SIZE 56 #14
+                        POSITION cc
+                        PARTIALS FALSE
+                        FORCE FALSE
+                END
+        END
+END
+
 LAYER
         NAME "nutzung_alle"
         TYPE POLYGON
-        DUMP TRUE
-        CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        #DUMP TRUE
+        CONNECTIONTYPE POSTGIS
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832"
         METADATA
@@ -58 +186 @@
                 wms_title "alle Nutzungsarten"
                 wms_abstract "Zusammenfassung aller Nutzungsarten-FlÀchen"
-                gml_include_items "all"
+                #gml_include_items "all"
         END
         PROJECTION
@@ -346 +474 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -378 +506 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -410 +538 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -440 +568 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -469 +597 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -499 +627 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -531 +659 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -561 +689 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -592 +720 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -626 +754 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -689 +817 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -719 +847 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -757 +885 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -788 +916 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -819 +947 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -852 +980 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -901 +1029 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -929 +1057 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -957 +1085 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -985 +1113 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1013 +1141 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1044 +1172 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1073 +1201 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1104 +1232 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1133 +1261 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1162 +1290 @@
         REQUIRES "![nutzung_alle]"
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1196 +1324 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
         # Feld funktion, Werte 1010, 1030, 1040
@@ -1230 +1358 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832"
         # Statt EXPRESSION filtern besser gleich als WHERE in SQL
@@ -1264 +1392 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1309 +1437 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1339 +1467 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1374 +1502 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1477 +1605 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1506 +1634 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -1539 +1667 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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"
         METADATA
@@ -1878 +2006 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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"
         METADATA
@@ -2002 +2130 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2066 +2194 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2101 +2229 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2151 +2279 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         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
         METADATA
@@ -2202 +2330 @@
         DUMP TRUE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert
 
@@ -2235 +2363 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2267 +2395 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2297 +2425 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2327 +2455 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832"
         FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2368 +2496 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2398 +2526 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2427 +2555 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832"
         FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver
@@ -2467 +2595 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2507 +2635 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2552 +2680 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2586 +2714 @@
         TYPE POLYGON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2618 +2746 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2749 +2877 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2802 +2930 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert
         METADATA
@@ -2835 +2963 @@
         STATUS ON
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel
         METADATA
@@ -2873 +3001 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2914 +3042 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2946 +3074 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -2979 +3107 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3012 +3140 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3042 +3170 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3081 +3209 @@
         #DUMP TRUE # _4
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         
         #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"
@@ -3130 +3258 @@
         TYPE LINE
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832"
         METADATA
@@ -3188 +3316 @@
         #SYMBOLSCALEDENOM 1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832'
         CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106}
@@ -3268 +3396 @@
         SYMBOLSCALEDENOM 250 # 1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832'
         CLASS
@@ -3304 +3432 @@
         SYMBOLSCALEDENOM 250 #1000
         CONNECTIONTYPE POSTGIS
-        CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432"
+        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"
         DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832'
         CLASS