Changeset 163 for trunk


Ignore:
Timestamp:
02/17/12 14:57:42 (8 years ago)
Author:
frank.jaeger
Message:

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

Location:
trunk/data
Files:
6 edited

Legend:

Unmodified
Added
Removed
  • trunk/data/konvert/postnas_0.7/konv_batch.sh

    r162 r163  
    55## Batch-Teil, Aufruf mit geprueften Parametern    - 
    66## ------------------------------------------------- 
     7## 
     8## Ordner-Struktur: 
     9##   /mandant/ 
     10##           /0001/*.xml.zip 
     11##           /0002/*.xml.zip 
     12##          usw. 
     13##           /temp/ 
     14##   Auf der gleichen Ebene wie die Datenordner muss ein Ordner /temp/ existieren. 
     15##   Dort werden die NAS-Daten temporär ausgepackt. 
     16##   Relativ zum mitgegebenen Parameter ist das: '../temp/' 
     17##   Parallel laufende Konvertierungen zum gleichen Mandanten  
     18##   würden hier durcheinander geraten. Vermeiden! 
     19## 
    720## Stand:  
    821##   2012-02-10 Umbennung nach 0.7 
     22##   2012-02-17 Optimierung 
    923## 
    10 ## Konverter:   /opt/gdal-1.9/bin/ = GDAL 1.9 / PostNAS 0.7 
     24## Konverter:   /opt/gdal-1.9.1/bin/ = GDAL 1.9-DEV / PostNAS 0.7 
    1125## Koordinaten: EPSG:25832  UTM, Zone 32 
    1226##              -a_srs EPSG:25832   - bleibt im UTM-System (korrigierte Werte) 
     
    5064# DB-Connection 
    5165con="-p 5432 -d ${DBNAME} " 
    52 # 
    5366echo "Datenbank-Name . . = ${DBNAME}" 
    5467echo "Ordner NAS-Daten . = ${ORDNER}" 
     
    7689    then 
    7790      # E R S T L A D E N 
    78       /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
     91      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
    7992         PG:"dbname=${DBNAME} host=localhost port=5432" \ 
    8093         -a_srs EPSG:25832  ${nasdatei}  ${layer}  2>> $errprot 
     
    8598      # A K T U A L I S I E R U N G 
    8699      echo "- 1. Nur delete-Layer auswerten"  
    87       /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
     100      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
    88101         PG:"dbname=${DBNAME} host=localhost port=5432" \ 
    89102         -a_srs EPSG:25832  ${nasdatei}  delete  2>> $errprot 
     
    96109      # 
    97110      echo "- 2. alle Layer auswerten" 
    98       /opt/gdal-1.9/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
     111      /opt/gdal-1.9.1/bin/ogr2ogr -f "PostgreSQL" -append  ${update}  -skipfailures \ 
    99112        PG:"dbname=${DBNAME} host=localhost port=5432" \ 
    100113        -a_srs EPSG:25832  ${nasdatei}  ${layer}  2>> $errprot 
  • trunk/data/konvert/postnas_0.7/ordner_konvertieren.sh

    r162 r163  
    33## Konvertierung von ALKIS NAS-Format nach PosGIS  - 
    44## NAS-Daten in einem Ordner konvertieren          - 
    5 ## Dialog-Teil zum Ermitteln der Parameter         - 
     5## Dialog-Teil zum Abfragen der Parameter          - 
    66## ------------------------------------------------- 
    77## Stand: 
    88##  2012-02-10  PostNAS 07, Umbenennung 
     9##  2012-02-17  Parameter "DBUSER" raus 
    910##  
    1011function get_db_config(){ 
    11  
     12        # 
    1213        # Name der zu ladenden ALKIS-Datenbank 
     14        # 
    1315        until [ -n "$DBNAME" ] 
    1416        do 
     
    1719                read DBNAME 
    1820        done 
    19  
    20         echo "" 
    21         echo "Datenbank-User?" 
    22         read DBUSER 
    23  
    24 #       echo "" 
    25 #       echo "Datenbank-Passwort?" 
    26 #       stty -echo 
    27 #               read DBPASS 
    28 #       stty echo 
    29  
    30         ## Ordner (Eingabedaten) 
     21        # 
     22        # Ordner (Eingabedaten) 
     23        # 
    3124        echo "" 
    3225        echo "Ordner mit gezippten NAS-Daten (*.xml.zip)? (Absoluter Pfad)" 
     
    4336                LSRESULT=$? 
    4437        done 
    45  
     38        # 
    4639        # Erstladen oder NBA-Aktualisierung 
     40        # 
    4741        echo " " 
    4842        echo "Art der Konvertierung" 
     
    5448                read UPD 
    5549        done 
     50        # 
    5651        # Bestaetigung holen 
     52        # 
    5753        echo " " 
    5854        echo "Abschließende Bestätigung:" 
     
    7470echo "** Konvertierung ALKIS **" > /data/konvert/postnas_0.7/log/postnas_err.prot 
    7571echo "** Beginn Batch **" 
    76 ##                                                1        2        3        4        5 
    77          /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $DBUSER  $UPD 
     72##                                       1        2        3 
     73/data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $UPD 
    7874result=$? 
    7975if [ $result = 0 ] 
     
    8581echo " " 
    8682echo " Kommando fuer Wiederholung:" 
    87 echo " /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $DBUSER  $UPD " 
     83echo " /data/konvert/postnas_0.7/konv_batch.sh  $ORDNER  $DBNAME  $UPD " 
    8884echo " " 
    8985### 
  • trunk/data/konvert/postnas_0.7/pp_definition.sql

    r162 r163  
    22-- ALKIS PostNAS 0.7 
    33 
    4 -- Post Processing Teil 1: Anlegen der Tabellen 
     4-- Post Processing (pp_) Teil 1: Anlegen der Tabellen und Views 
    55 
    66-- Stand  
    77 
    88--  2012-02-13 PostNAS 07, Umbenennung 
     9--  2012-02-17 Optimierung 
    910 
    1011-- ============================ 
     
    4243 
    4344  CREATE TABLE pp_gemeinde ( 
    44     land                integer, 
     45    gid                 serial, 
     46    land                integer NOT NULL, 
    4547    regierungsbezirk    integer, 
    4648    kreis               integer, 
    47     gemeinde            integer, 
     49    gemeinde            integer NOT NULL, 
    4850    gemeindename        character varying(80), 
    49    gkz                 character varying(03),  -- wird (noch) nicht benutzt 
     51 -- gkz                 character varying(03),  -- wird (noch) nicht benutzt 
    5052    anz_gemarkg         integer,                -- Anzahl Gemarkungen 
    5153    CONSTRAINT pp_gemeinde_pk PRIMARY KEY (land, gemeinde) 
    5254  ); 
    5355 
    54  
    55 -- GesamtflÀche 
     56-- ALTER TABLE pp_gemeinde ADD COLUMN gid serial; 
     57CREATE UNIQUE INDEX pp_gemeinde_gid_ix ON pp_gemeinde (gid); 
     58 
     59-- Gesamtflaeche 
    5660SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 
    57  
    58 -- Index 
    5961CREATE INDEX pp_gemeinde_gidx ON pp_gemeinde USING gist(the_geom); 
    6062 
    61 -- vereinfachte GesamtflÀche 
     63-- vereinfachte Gesamtflaeche 
    6264SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2); 
    63  
    6465CREATE INDEX pp_gemeinde_sgidx ON pp_gemeinde USING gist(simple_geom); 
    6566 
     
    6869COMMENT ON COLUMN pp_gemeinde.gemeinde       IS 'Gemeindenummer'; 
    6970COMMENT ON COLUMN pp_gemeinde.gkz            IS 'Gemeindekennziffer fÃŒr Mandant'; 
     71COMMENT ON COLUMN pp_gemeinde.the_geom       IS 'prÀzise Geometrie aus Summe aller Gemarkungen'; 
     72COMMENT ON COLUMN pp_gemeinde.simple_geom    IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.'; 
    7073 
    7174 
     
    8083-- muss diese Information als (redundante) Tabelle nach dem Laden zwischengespeichert werden.  
    8184 
    82 --CREATE TABLE gemeinde_gemarkung (  -- PostNAS 0.6 
    83   CREATE TABLE pp_gemarkung (        -- PostNAS 0.7 
    84     land                integer, 
     85--CREATE TABLE gemeinde_gemarkung (             -- alt: PostNAS 0.6 
     86  CREATE TABLE pp_gemarkung (                   -- PostNAS 0.7 
     87    gid                 serial, 
     88    land                integer NOT NULL, 
    8589    regierungsbezirk    integer, 
    8690    kreis               integer, 
    87     gemeinde            integer,        -- fast ein Foreign-Key Constraint 
     91    gemeinde            integer NOT NULL,       -- fast ein Foreign-Key Constraint 
    8892    gemarkung           integer NOT NULL, 
    8993    gemarkungsname      character varying(80), 
    90     anz_flur            integer,        -- Anzahl Fluren 
     94    anz_flur            integer,                -- Anzahl Fluren 
    9195    CONSTRAINT pp_gemarkung_pk PRIMARY KEY (land, gemarkung) 
    9296  ); 
    9397 
     98-- ALTER TABLE pp_gemarkung ADD COLUMN gid serial; 
     99CREATE UNIQUE INDEX pp_gemarkung_gid_ix ON pp_gemarkung (gid); 
    94100 
    95101-- GesamtflÀche 
    96102SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2); 
    97  
    98 -- Index 
    99103CREATE INDEX pp_gemarkung_gidx ON pp_gemarkung USING gist(the_geom); 
    100  
    101104 
    102105-- vereinfachte GesamtflÀche 
    103106SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2); 
    104  
    105107CREATE INDEX pp_gemarkung_sgidx ON pp_gemarkung USING gist(simple_geom); 
    106108 
    107109 
    108 COMMENT ON TABLE  pp_gemarkung                IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde'; 
    109 COMMENT ON COLUMN pp_gemarkung.gemeinde       IS 'Gemeindenummer'; 
    110 COMMENT ON COLUMN pp_gemarkung.gemarkung      IS 'Gemarkungsnummer'; 
     110COMMENT ON TABLE  pp_gemarkung               IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde'; 
     111COMMENT ON COLUMN pp_gemarkung.gemeinde      IS 'Gemeindenummer'; 
     112COMMENT ON COLUMN pp_gemarkung.gemarkung     IS 'Gemarkungsnummer'; 
     113COMMENT ON COLUMN pp_gemarkung.the_geom      IS 'prÀzise Geometrie aus Summe aller Fluren'; 
     114COMMENT ON COLUMN pp_gemarkung.simple_geom   IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Übersichten in kleinen MaßstÀben.'; 
    111115 
    112116 
     
    115119 
    116120  CREATE TABLE pp_flur ( 
    117     land                integer, 
     121    gid                 serial, 
     122    land                integer NOT NULL, 
    118123    regierungsbezirk    integer, 
    119124    kreis               integer, 
    120125    gemarkung           integer NOT NULL, 
    121126    flurnummer          integer NOT NULL, 
    122     anz_fs              integer,        -- Anzahl FlurstÃŒcke 
     127    anz_fs              integer,                -- Anzahl FlurstÃŒcke 
    123128    CONSTRAINT pp_flur_pk PRIMARY KEY (land, gemarkung, flurnummer) 
    124129  ); 
    125130 
     131-- ALTER TABLE pp_flur ADD COLUMN gid serial; 
     132CREATE UNIQUE INDEX pp_flur_gid_ix ON pp_flur (gid); 
     133 
    126134-- GesamtflÀche 
    127135SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2); 
    128  
    129 -- Index 
    130136CREATE INDEX pp_flur_gidx ON pp_flur USING gist(the_geom); 
    131137 
    132138COMMENT ON TABLE  pp_flur                IS 'Post-Processing: Flur'; 
    133139COMMENT ON COLUMN pp_flur.gemarkung      IS 'Gemarkungsnummer'; 
     140COMMENT ON COLUMN pp_flur.the_geom       IS 'Geometrie aus Summe aller FlurstÃŒcke'; 
    134141 
    135142 
     
    150157 
    151158  CREATE TABLE gemeinde_person ( 
    152     land                        integer, 
     159    land                integer, 
    153160    regierungsbezirk    integer, 
    154     kreis                       integer, 
     161    kreis               integer, 
    155162    gemeinde            integer, 
    156     person              character varying(16),  
     163    person              character varying(16), 
    157164    buchtyp             integer, 
    158165    CONSTRAINT gemeinde_person_pk PRIMARY KEY (gemeinde, person) 
     
    288295 
    289296 
     297-- Views zur Analyse der vereinfachten Geometrie 
     298-- Finden des richtigen Genauigkeits-Wertes fÃŒr die Vereinfachung der Geometrie 
     299 
     300-- z.B. Gemeinden:  10 Meter 
     301--      Gemarkungen: 4 Meter 
     302 
     303CREATE VIEW pp_gemeinde_analyse AS 
     304  SELECT land, gemeinde, gemeindename, 
     305         st_npoints(the_geom)    AS umring_alle_punkte, 
     306         st_npoints(simple_geom) AS umring_einfache_punkte 
     307  FROM pp_gemeinde; 
     308 
     309 
     310CREATE VIEW pp_gemarkung_analyse AS 
     311  SELECT land, gemeinde, gemarkung, gemarkungsname, 
     312         st_npoints(the_geom)    AS umring_alle_punkte, 
     313         st_npoints(simple_geom) AS umring_einfache_punkte 
     314  FROM pp_gemarkung; 
     315 
     316 
    290317-- ENDE -- 
  • trunk/data/konvert/postnas_0.7/pp_laden.sql

    r162 r163  
    22-- ALKIS PostNAS 0.7 
    33 
    4 -- Post Processing Teil 2: Laden der Tabellen 
     4-- Post Processing (pp_) Teil 2: Laden der Tabellen 
    55 
    66-- Stand  
    77 
    88--  2012-02-13 PostNAS 07, Umbenennung 
     9--  2012-02-17 Optimierung 
    910 
    1011 
     
    8182 
    8283 
    83 -- =============================================================== 
    84 -- Geometrien der Flurstücke zu größeren Einheiten zusammen fassen 
    85 -- =============================================================== 
     84-- ============================================================================== 
     85-- Geometrien der Flurstücke schrittweise zu groesseren Einheiten zusammen fassen 
     86-- ============================================================================== 
     87 
     88-- Dies macht nur Sinn, wenn der Inhalt der Datenbenk einen ganzen Katasterbezirk enthält. 
     89-- Wenn ein Gebiet durch geometrische Filter im NBA ausgegeben wurde, dann gibt es Randstreifen,  
     90-- die zu Pseudo-Fluren zusammen gefasst werden. Fachlich falsch! 
    8691 
    8792INSERT INTO pp_flur (land, regierungsbezirk, kreis, gemarkung, flurnummer, anz_fs, the_geom ) 
     
    104109   ); 
    105110 
    106 -- Fluren zählen 
     111-- Fluren zaehlen 
    107112UPDATE pp_gemarkung a 
    108113  SET anz_flur =  
     
    112117   ); -- Gemarkungsnummer ist je BundesLand eindeutig 
    113118 
    114 -- Geometrie vereinfachen 
    115 UPDATE pp_gemarkung SET simple_geom = simplify(the_geom, 4.0); 
    116  
    117 COMMENT ON COLUMN pp_gemarkung.simple_geom     IS 'Vereinfachte Geometrie mit 4 Meter-Genauigkeit. Für Anzeige von Übersichten in kleinen Maßstäben.'; 
     119-- Geometrie vereinfachen (Wirkung siehe pp_gemarkung_analyse) 
     120UPDATE pp_gemarkung SET simple_geom = simplify(the_geom, 8.0); 
    118121 
    119122 
     
    137140   ); 
    138141 
    139 -- Geometrie vereinfachen 
    140  
    141 UPDATE pp_gemeinde SET simple_geom = simplify(the_geom, 10.0); 
    142  
    143 COMMENT ON COLUMN pp_gemeinde.simple_geom     IS 'Vereinfachte Geometrie mit 10 Meter-Genauigkeit. Für Anzeige von Übersichten in kleinen Maßstäben.'; 
    144  
     142-- Geometrie vereinfachen (Wirkung siehe pp_gemeinde_analyse) 
     143UPDATE pp_gemeinde SET simple_geom = simplify(the_geom, 20.0); 
    145144 
    146145 
  • trunk/data/umn/alkis07/alkis07_muster.map

    r160 r163  
    44 
    55# 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6 
     6# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete 
    67 
    78# ToDo: 
     
    6162        END 
    6263 
    63 # ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetaion) 
     64 
     65# ** aus Post-Processing: Katasterbezirke 
     66 
     67# Die Layer dieser Gruppe nur anzeigen lassen, wenn der Inhalt der Datenbenk einen ganzen Katasterbezirk enthÀlt. 
     68# Wenn ein Gebiet durch geometrische Filter im NBA ausgegeben wurde, dann gibt es Randstreifen,  
     69# die zu Pseudo-Fluren zusammen gefasst werden. Fachlich falsch! 
     70 
     71LAYER 
     72        NAME "pp_gemeinde" 
     73        GROUP "pp_gebiete" 
     74        TYPE POLYGON 
     75        DUMP true 
     76        CONNECTIONTYPE POSTGIS 
     77        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     78        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 
     79        METADATA 
     80                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     81                wms_title "Gemeinde" 
     82                wms_abstract "GemeindeflÀche (vereinfachte Geometrie)" 
     83                wms_group_title "Gebiete" 
     84                wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden" 
     85                gml_include_items "all" 
     86        END 
     87        PROJECTION 
     88                "init=epsg:25832" 
     89        END 
     90        EXTENT 349000 5529000 356000 5533000 
     91        MINSCALEDENOM   8000 
     92        MAXSCALEDENOM 400000 
     93        LABELITEM gemeindename 
     94        CLASS 
     95                NAME "Gemeinde" 
     96                STYLE 
     97                        OUTLINECOLOR 10 10 200 
     98                        WIDTH 7 
     99                        PATTERN 8 22 END 
     100                END 
     101                LABEL 
     102                        TYPE TRUETYPE 
     103                        COLOR 10 10 200 
     104                        FONT "arial" 
     105                        SIZE 20 
     106                        POSITION cc 
     107                        OFFSET 0 -20 
     108                        PARTIALS FALSE 
     109                        FORCE FALSE 
     110                END 
     111        END 
     112END 
     113 
     114LAYER 
     115        NAME "pp_gemarkung" 
     116        GROUP "pp_gebiete" 
     117        TYPE POLYGON 
     118        DUMP true 
     119        CONNECTIONTYPE POSTGIS 
     120        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     121        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 
     122        METADATA 
     123                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     124                wms_title "Gemarkung" 
     125                wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)" 
     126                gml_include_items "all" 
     127        END 
     128        PROJECTION 
     129                "init=epsg:25832" 
     130        END 
     131        EXTENT 349000 5529000 356000 5533000 
     132        MINSCALEDENOM  4000 
     133        MAXSCALEDENOM 40000 
     134        LABELITEM gemarkungsname 
     135        CLASS 
     136                NAME "Gemarkung" 
     137                STYLE 
     138                        OUTLINECOLOR 140 80 0 
     139                        WIDTH 5 
     140                        PATTERN 3 12 END 
     141                END 
     142                LABEL 
     143                        TYPE TRUETYPE 
     144                        COLOR 140 80 0 
     145                        FONT "arial" 
     146                        SIZE 16 
     147                        POSITION cc 
     148                        OFFSET 0 10 
     149                        PARTIALS FALSE 
     150                        FORCE FALSE 
     151                END 
     152        END 
     153END 
     154 
     155LAYER 
     156        NAME "pp_flur" 
     157        GROUP "pp_gebiete" 
     158        TYPE POLYGON 
     159        DUMP true 
     160        CONNECTIONTYPE POSTGIS 
     161        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     162        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 
     163        METADATA 
     164                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     165                wms_title "Flur" 
     166                wms_abstract "Flur" 
     167                gml_include_items "all" 
     168        END 
     169        PROJECTION 
     170                "init=epsg:25832" 
     171        END 
     172        EXTENT 349000 5529000 356000 5533000 
     173        MINSCALEDENOM  1600 
     174        MAXSCALEDENOM 20000 
     175        CLASS 
     176                NAME "Flur" 
     177                TEXT "Flur [flurnummer]"  
     178                STYLE 
     179                        OUTLINECOLOR 100 150 10 
     180                        WIDTH 3 
     181                        PATTERN 1 8 END 
     182                END 
     183 
     184                #STYLE # fuer TEST Flaechendeckung? 
     185                #       COLOR 100 150 10 
     186                #       SYMBOL "sn3631" 
     187                #       SIZE 10 
     188                #END 
     189 
     190                LABEL 
     191                        TYPE TRUETYPE 
     192                        COLOR 100 150 10 
     193                        FONT "arial" 
     194                        SIZE 14 
     195                        POSITION cc 
     196                        PARTIALS FALSE 
     197                        FORCE FALSE 
     198                END 
     199        END 
     200END 
     201 
     202 
     203# ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetation) 
    64204# alle Layer von GROUP "ax_nutzungen" 
    65205 
     
    110250        DUMP TRUE 
    111251        CONNECTIONTYPE POSTGIS 
    112         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     252        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    113253        DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 
    114254        METADATA 
     
    258398                NAME "Platz" 
    259399                STYLE 
    260                 #       COLOR -1 -1 -1 #? 
    261400                        OUTLINECOLOR 153 153 153 
    262401                END 
     
    518657        REQUIRES "![nutzung_alle]" 
    519658        CONNECTIONTYPE POSTGIS 
    520         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     659        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    521660        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 
    522661        METADATA 
     
    550689        REQUIRES "![nutzung_alle]" 
    551690        CONNECTIONTYPE POSTGIS 
    552         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     691        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    553692        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 
    554693        METADATA 
     
    582721        REQUIRES "![nutzung_alle]" 
    583722        CONNECTIONTYPE POSTGIS 
    584         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     723        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    585724        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 
    586725        METADATA 
     
    612751        REQUIRES "![nutzung_alle]" 
    613752        CONNECTIONTYPE POSTGIS 
    614         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     753        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    615754        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 
    616755        METADATA 
     
    641780        REQUIRES "![nutzung_alle]" 
    642781        CONNECTIONTYPE POSTGIS 
    643         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     782        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    644783        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 
    645784        METADATA 
     
    671810        REQUIRES "![nutzung_alle]" 
    672811        CONNECTIONTYPE POSTGIS 
    673         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     812        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    674813        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 
    675814        METADATA 
     
    703842        REQUIRES "![nutzung_alle]" 
    704843        CONNECTIONTYPE POSTGIS 
    705         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     844        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    706845        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 
    707846        METADATA 
     
    733872        REQUIRES "![nutzung_alle]" 
    734873        CONNECTIONTYPE POSTGIS 
    735         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     874        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    736875        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 
    737876        METADATA 
     
    764903        REQUIRES "![nutzung_alle]" 
    765904        CONNECTIONTYPE POSTGIS 
    766         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     905        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    767906        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 
    768907        METADATA 
     
    798937        REQUIRES "![nutzung_alle]" 
    799938        CONNECTIONTYPE POSTGIS 
    800         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     939        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    801940        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 
    802941        METADATA 
     
    8611000        REQUIRES "![nutzung_alle]" 
    8621001        CONNECTIONTYPE POSTGIS 
    863         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1002        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    8641003        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 
    8651004        METADATA 
     
    8911030        REQUIRES "![nutzung_alle]" 
    8921031        CONNECTIONTYPE POSTGIS 
    893         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1032        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    8941033        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 
    8951034        METADATA 
     
    9291068        REQUIRES "![nutzung_alle]" 
    9301069        CONNECTIONTYPE POSTGIS 
    931         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1070        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9321071        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 
    9331072        METADATA 
     
    9601099        REQUIRES "![nutzung_alle]" 
    9611100        CONNECTIONTYPE POSTGIS 
    962         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1101        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9631102        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 
    9641103        METADATA 
     
    9911130        REQUIRES "![nutzung_alle]" 
    9921131        CONNECTIONTYPE POSTGIS 
    993         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1132        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9941133        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 
    9951134        METADATA 
     
    10241163        REQUIRES "![nutzung_alle]" 
    10251164        CONNECTIONTYPE POSTGIS 
    1026         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1165        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    10271166        DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 
    10281167        METADATA 
     
    10741213        REQUIRES "![nutzung_alle]" 
    10751214        CONNECTIONTYPE POSTGIS 
    1076         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1215        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    10771216        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 
    10781217        METADATA 
     
    11031242        REQUIRES "![nutzung_alle]" 
    11041243        CONNECTIONTYPE POSTGIS 
    1105         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1244        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11061245        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 
    11071246        METADATA 
     
    11321271        REQUIRES "![nutzung_alle]" 
    11331272        CONNECTIONTYPE POSTGIS 
    1134         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1273        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11351274        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 
    11361275        METADATA 
     
    11611300        REQUIRES "![nutzung_alle]" 
    11621301        CONNECTIONTYPE POSTGIS 
    1163         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1302        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11641303        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 
    11651304        METADATA 
     
    11901329        REQUIRES "![nutzung_alle]" 
    11911330        CONNECTIONTYPE POSTGIS 
    1192         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1331        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11931332        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 
    11941333        METADATA 
     
    12211360        REQUIRES "![nutzung_alle]" 
    12221361        CONNECTIONTYPE POSTGIS 
    1223         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1362        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    12241363        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 
    12251364        METADATA 
     
    12501389        REQUIRES "![nutzung_alle]" 
    12511390        CONNECTIONTYPE POSTGIS 
    1252         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1391        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    12531392        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 
    12541393        METADATA 
     
    12811420        REQUIRES "![nutzung_alle]" 
    12821421        CONNECTIONTYPE POSTGIS 
    1283         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1422        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    12841423        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 
    12851424        METADATA 
     
    13101449        REQUIRES "![nutzung_alle]" 
    13111450        CONNECTIONTYPE POSTGIS 
    1312         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1451        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13131452        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 
    13141453        METADATA 
     
    13391478        REQUIRES "![nutzung_alle]" 
    13401479        CONNECTIONTYPE POSTGIS 
    1341         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1480        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13421481        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    13431482        METADATA 
     
    13751514        # REQUIRES "![nutzung_alle]" 
    13761515        CONNECTIONTYPE POSTGIS 
    1377         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1516        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13781517        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    13791518        # Feld funktion, Werte 1010, 1030, 1040 
     
    14081547        DUMP TRUE 
    14091548        CONNECTIONTYPE POSTGIS 
    1410         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1549        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    14111550        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    14121551        # Statt EXPRESSION filtern besser gleich als WHERE in SQL 
     
    14431582        DUMP TRUE 
    14441583        CONNECTIONTYPE POSTGIS 
    1445         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1584        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    14461585        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 
    14471586        METADATA 
     
    14881627        DUMP TRUE 
    14891628        CONNECTIONTYPE POSTGIS 
    1490         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1629        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    14911630        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    14921631        METADATA 
     
    15211660        DUMP TRUE 
    15221661        CONNECTIONTYPE POSTGIS 
    1523         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1662        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    15241663        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 
    15251664        METADATA 
     
    15571696        DUMP TRUE 
    15581697        CONNECTIONTYPE POSTGIS 
    1559         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1698        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    15601699 
    15611700        # Tabelle (Standard-Template) 
     
    17921931        DUMP TRUE 
    17931932        CONNECTIONTYPE POSTGIS 
    1794         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1933        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    17951934        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    17961935        METADATA 
     
    18211960        DUMP TRUE 
    18221961        CONNECTIONTYPE POSTGIS 
    1823         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1962        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    18241963        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 
    18251964        METADATA 
     
    18642003        TYPE POLYGON 
    18652004        CONNECTIONTYPE POSTGIS 
    1866         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2005        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    18672006        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" 
    18682007        # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das? 
     
    22222361        DUMP TRUE 
    22232362        CONNECTIONTYPE POSTGIS 
    2224         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2363        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    22252364        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" 
    22262365        METADATA 
     
    23832522        DUMP TRUE 
    23842523        CONNECTIONTYPE POSTGIS 
    2385         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2524        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    23862525        DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 
    23872526        METADATA 
     
    24512590        DUMP TRUE 
    24522591        CONNECTIONTYPE POSTGIS 
    2453         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2592        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    24542593        DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 
    24552594        METADATA 
     
    24852624        DUMP TRUE 
    24862625        CONNECTIONTYPE POSTGIS 
    2487         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2626        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    24882627        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 
    24892628 
     
    25332672        DUMP TRUE 
    25342673        CONNECTIONTYPE POSTGIS 
    2535         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2674        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    25362675        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 
    25372676        # "s_nummer_nebengebaeude" = View 
     
    25842723        DUMP TRUE 
    25852724        CONNECTIONTYPE POSTGIS 
    2586         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2725        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    25872726        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    25882727 
     
    26172756        DUMP TRUE 
    26182757        CONNECTIONTYPE POSTGIS 
    2619         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2758        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    26202759        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    26212760        METADATA 
     
    26492788        DUMP TRUE 
    26502789        CONNECTIONTYPE POSTGIS 
    2651         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2790        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    26522791        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    26532792        METADATA 
     
    26812820        DUMP TRUE 
    26822821        CONNECTIONTYPE POSTGIS 
    2683         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2822        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    26842823        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 
    26852824        METADATA 
     
    27112850        DUMP TRUE 
    27122851        CONNECTIONTYPE POSTGIS 
    2713         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2852        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    27142853        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 
    27152854        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    27522891        DUMP TRUE 
    27532892        CONNECTIONTYPE POSTGIS 
    2754         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2893        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    27552894        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 
    27562895        METADATA 
     
    27822921        DUMP TRUE 
    27832922        CONNECTIONTYPE POSTGIS 
    2784         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2923        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    27852924        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 
    27862925        METADATA 
     
    28122951        DUMP TRUE 
    28132952        CONNECTIONTYPE POSTGIS 
    2814         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2953        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    28152954        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 
    28162955        FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    28843023        DUMP TRUE 
    28853024        CONNECTIONTYPE POSTGIS 
    2886         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3025        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    28873026        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 
    28883027        METADATA 
     
    29243063        DUMP TRUE 
    29253064        CONNECTIONTYPE POSTGIS 
    2926         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3065        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    29273066        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 
    29283067        METADATA 
     
    29713110        DUMP TRUE 
    29723111        CONNECTIONTYPE POSTGIS 
    2973         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3112        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    29743113        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 
    29753114        METADATA 
     
    30063145        DUMP TRUE 
    30073146        CONNECTIONTYPE POSTGIS 
    3008         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3147        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    30093148        # mit Feldern fuer klassisches Template: 
    30103149        #  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" 
     
    30513190        DUMP TRUE 
    30523191        CONNECTIONTYPE POSTGIS 
    3053         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3192        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    30543193        DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 
    30553194        METADATA 
     
    31913330        DUMP TRUE 
    31923331        CONNECTIONTYPE POSTGIS 
    3193         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3332        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    31943333        DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 
    31953334        # View: ap_pto >dientZurDarstellungVon> ax_flurstueck 
     
    33853524        TYPE LINE 
    33863525        CONNECTIONTYPE POSTGIS 
    3387         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3526        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    33883527        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    33893528        METADATA 
     
    34153554        STATUS ON 
    34163555        CONNECTIONTYPE POSTGIS 
    3417         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3556        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    34183557        DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 
    34193558        METADATA 
     
    34533592        TYPE POINT 
    34543593        CONNECTIONTYPE POSTGIS 
    3455         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3594        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    34563595        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    34573596        METADATA 
     
    34983637        DUMP TRUE 
    34993638        CONNECTIONTYPE POSTGIS 
    3500         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3639        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    35013640        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 
    35023641        METADATA 
     
    35303669        DUMP TRUE 
    35313670        CONNECTIONTYPE POSTGIS 
    3532         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3671        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    35333672        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 
    35343673        METADATA 
     
    35633702        DUMP TRUE 
    35643703        CONNECTIONTYPE POSTGIS 
    3565         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3704        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    35663705        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 
    35673706        METADATA 
     
    35963735        DUMP TRUE 
    35973736        CONNECTIONTYPE POSTGIS 
    3598         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3737        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    35993738        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 
    36003739        METADATA 
     
    36263765        DUMP TRUE 
    36273766        CONNECTIONTYPE POSTGIS 
    3628         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3767        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    36293768        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 
    36303769        METADATA 
     
    36663805        DUMP TRUE 
    36673806        CONNECTIONTYPE POSTGIS 
    3668         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3807        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    36693808 
    36703809        #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" 
     
    37753914        DUMP TRUE 
    37763915        CONNECTIONTYPE POSTGIS 
    3777         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3916        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    37783917        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 
    37793918        METADATA 
     
    38373976        #SYMBOLSCALEDENOM 1000 
    38383977        CONNECTIONTYPE POSTGIS 
    3839         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3978        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    38403979        DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 
    38413980        CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106} 
     
    39174056        SYMBOLSCALEDENOM 1000 
    39184057        CONNECTIONTYPE POSTGIS 
    3919         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     4058        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    39204059        DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 
    39214060        CLASS 
     
    39534092        SYMBOLSCALEDENOM 1000 
    39544093        CONNECTIONTYPE POSTGIS 
    3955         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     4094        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    39564095        DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 
    39574096        CLASS 
  • trunk/data/umn/alkis07/alkis07_muster_4.map

    r160 r163  
    44 
    55# 2012-02-09 F.J. krz  Branch 0.7 aus Version 0.6 
     6# 2012-02-17 F.J. krz  data dbname=alkis07, Layer-Group pp_gebiete 
    67 
    78MAP 
     
    4748        END 
    4849 
     50 
     51# ** aus Post-Processing: Katasterbezirke 
     52 
     53LAYER 
     54        NAME "pp_gemeinde" 
     55        GROUP "pp_gebiete" 
     56        TYPE POLYGON 
     57        DUMP true 
     58        CONNECTIONTYPE POSTGIS 
     59        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     60        DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 
     61        METADATA 
     62                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     63                wms_title "Gemeinde" 
     64                wms_abstract "GemeindeflÀche (vereinfachte Geometrie)" 
     65                wms_group_title "Gebiete" 
     66                wms_group_abstract "Zusammenfassung der FlurstÃŒcke mit gleichen SchlÃŒssel: Fluren, Gemarkungen und Gemeinden" 
     67                gml_include_items "all" 
     68        END 
     69        PROJECTION 
     70                "init=epsg:25832" 
     71        END 
     72        EXTENT 349000 5529000 356000 5533000 
     73        MINSCALEDENOM 2000 #8000 
     74        MAXSCALEDENOM 100000 #400000 
     75        LABELITEM gemeindename 
     76        CLASS 
     77                NAME "Gemeinde" 
     78                STYLE 
     79                        OUTLINECOLOR 10 10 200 
     80                        WIDTH 28 #7 
     81                        PATTERN 32 88 END # 8 22 
     82                END 
     83                LABEL 
     84                        TYPE TRUETYPE 
     85                        COLOR 10 10 200 
     86                        FONT "arial" 
     87                        SIZE 80 # 20 
     88                        POSITION cc 
     89                        OFFSET 0 -80 # 0 -20 
     90                        PARTIALS FALSE 
     91                        FORCE FALSE 
     92                END 
     93        END 
     94END 
     95 
     96LAYER 
     97        NAME "pp_gemarkung" 
     98        GROUP "pp_gebiete" 
     99        TYPE POLYGON 
     100        #DUMP true 
     101        CONNECTIONTYPE POSTGIS 
     102        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     103        DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 
     104        METADATA 
     105                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     106                wms_title "Gemarkung" 
     107                wms_abstract "GemarkungsflÀche (vereinfachte Geometrie)" 
     108                #gml_include_items "all" 
     109        END 
     110        PROJECTION 
     111                "init=epsg:25832" 
     112        END 
     113        EXTENT 349000 5529000 356000 5533000 
     114        MINSCALEDENOM 1000 #4000 
     115        MAXSCALEDENOM 10000 #40000 
     116        LABELITEM gemarkungsname 
     117        CLASS 
     118                NAME "Gemarkung" 
     119                STYLE 
     120                        OUTLINECOLOR 140 80 0 
     121                        WIDTH 20 #5 
     122                        PATTERN 12 48 END #3 12 
     123                END 
     124                LABEL 
     125                        TYPE TRUETYPE 
     126                        COLOR 140 80 0 
     127                        FONT "arial" 
     128                        SIZE 64 #16 
     129                        POSITION cc 
     130                        OFFSET 0 40 # 0 10 
     131                        PARTIALS FALSE 
     132                        FORCE FALSE 
     133                END 
     134        END 
     135END 
     136 
     137LAYER 
     138        NAME "pp_flur" 
     139        GROUP "pp_gebiete" 
     140        TYPE POLYGON 
     141        #DUMP true 
     142        CONNECTIONTYPE POSTGIS 
     143        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
     144        DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 
     145        METADATA 
     146                wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 
     147                wms_title "Flur" 
     148                wms_abstract "Flur" 
     149                #gml_include_items "all" 
     150        END 
     151        PROJECTION 
     152                "init=epsg:25832" 
     153        END 
     154        EXTENT 349000 5529000 356000 5533000 
     155        MINSCALEDENOM 400 #1600 
     156        MAXSCALEDENOM 5000 #20000 
     157        LABELITEM flurnummer 
     158        CLASS 
     159                NAME "Flur" 
     160                STYLE 
     161                        OUTLINECOLOR 100 150 10 
     162                        WIDTH 12 #3 
     163                        PATTERN 2 32 END # 1 8 
     164                END 
     165                LABEL 
     166                        TYPE TRUETYPE 
     167                        COLOR 100 150 10 
     168                        FONT "arial" 
     169                        SIZE 56 #14 
     170                        POSITION cc 
     171                        PARTIALS FALSE 
     172                        FORCE FALSE 
     173                END 
     174        END 
     175END 
     176 
    49177LAYER 
    50178        NAME "nutzung_alle" 
    51179        TYPE POLYGON 
    52         DUMP TRUE 
    53         CONNECTIONTYPE POSTGIS 
    54         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     180        #DUMP TRUE 
     181        CONNECTIONTYPE POSTGIS 
     182        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    55183        DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 
    56184        METADATA 
     
    58186                wms_title "alle Nutzungsarten" 
    59187                wms_abstract "Zusammenfassung aller Nutzungsarten-FlÀchen" 
    60                 gml_include_items "all" 
     188                #gml_include_items "all" 
    61189        END 
    62190        PROJECTION 
     
    346474        REQUIRES "![nutzung_alle]" 
    347475        CONNECTIONTYPE POSTGIS 
    348         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     476        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    349477        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 
    350478        METADATA 
     
    378506        REQUIRES "![nutzung_alle]" 
    379507        CONNECTIONTYPE POSTGIS 
    380         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     508        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    381509        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 
    382510        METADATA 
     
    410538        REQUIRES "![nutzung_alle]" 
    411539        CONNECTIONTYPE POSTGIS 
    412         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     540        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    413541        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 
    414542        METADATA 
     
    440568        REQUIRES "![nutzung_alle]" 
    441569        CONNECTIONTYPE POSTGIS 
    442         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     570        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    443571        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 
    444572        METADATA 
     
    469597        REQUIRES "![nutzung_alle]" 
    470598        CONNECTIONTYPE POSTGIS 
    471         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     599        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    472600        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 
    473601        METADATA 
     
    499627        REQUIRES "![nutzung_alle]" 
    500628        CONNECTIONTYPE POSTGIS 
    501         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     629        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    502630        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 
    503631        METADATA 
     
    531659        REQUIRES "![nutzung_alle]" 
    532660        CONNECTIONTYPE POSTGIS 
    533         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     661        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    534662        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 
    535663        METADATA 
     
    561689        REQUIRES "![nutzung_alle]" 
    562690        CONNECTIONTYPE POSTGIS 
    563         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     691        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    564692        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 
    565693        METADATA 
     
    592720        REQUIRES "![nutzung_alle]" 
    593721        CONNECTIONTYPE POSTGIS 
    594         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     722        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    595723        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 
    596724        METADATA 
     
    626754        REQUIRES "![nutzung_alle]" 
    627755        CONNECTIONTYPE POSTGIS 
    628         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     756        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    629757        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 
    630758        METADATA 
     
    689817        REQUIRES "![nutzung_alle]" 
    690818        CONNECTIONTYPE POSTGIS 
    691         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     819        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    692820        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 
    693821        METADATA 
     
    719847        REQUIRES "![nutzung_alle]" 
    720848        CONNECTIONTYPE POSTGIS 
    721         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     849        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    722850        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 
    723851        METADATA 
     
    757885        REQUIRES "![nutzung_alle]" 
    758886        CONNECTIONTYPE POSTGIS 
    759         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     887        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    760888        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 
    761889        METADATA 
     
    788916        REQUIRES "![nutzung_alle]" 
    789917        CONNECTIONTYPE POSTGIS 
    790         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     918        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    791919        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 
    792920        METADATA 
     
    819947        REQUIRES "![nutzung_alle]" 
    820948        CONNECTIONTYPE POSTGIS 
    821         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     949        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    822950        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 
    823951        METADATA 
     
    852980        REQUIRES "![nutzung_alle]" 
    853981        CONNECTIONTYPE POSTGIS 
    854         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     982        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    855983        DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 
    856984        METADATA 
     
    9011029        TYPE POLYGON 
    9021030        CONNECTIONTYPE POSTGIS 
    903         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1031        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9041032        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 
    9051033        METADATA 
     
    9291057        TYPE POLYGON 
    9301058        CONNECTIONTYPE POSTGIS 
    931         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1059        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9321060        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 
    9331061        METADATA 
     
    9571085        TYPE POLYGON 
    9581086        CONNECTIONTYPE POSTGIS 
    959         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1087        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9601088        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 
    9611089        METADATA 
     
    9851113        TYPE POLYGON 
    9861114        CONNECTIONTYPE POSTGIS 
    987         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1115        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    9881116        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 
    9891117        METADATA 
     
    10131141        TYPE POLYGON 
    10141142        CONNECTIONTYPE POSTGIS 
    1015         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1143        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    10161144        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 
    10171145        METADATA 
     
    10441172        REQUIRES "![nutzung_alle]" 
    10451173        CONNECTIONTYPE POSTGIS 
    1046         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1174        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    10471175        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 
    10481176        METADATA 
     
    10731201        REQUIRES "![nutzung_alle]" 
    10741202        CONNECTIONTYPE POSTGIS 
    1075         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1203        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    10761204        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 
    10771205        METADATA 
     
    11041232        REQUIRES "![nutzung_alle]" 
    11051233        CONNECTIONTYPE POSTGIS 
    1106         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1234        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11071235        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 
    11081236        METADATA 
     
    11331261        REQUIRES "![nutzung_alle]" 
    11341262        CONNECTIONTYPE POSTGIS 
    1135         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1263        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11361264        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 
    11371265        METADATA 
     
    11621290        REQUIRES "![nutzung_alle]" 
    11631291        CONNECTIONTYPE POSTGIS 
    1164         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1292        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11651293        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    11661294        METADATA 
     
    11961324        #DUMP TRUE # _4 
    11971325        CONNECTIONTYPE POSTGIS 
    1198         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1326        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    11991327        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    12001328        # Feld funktion, Werte 1010, 1030, 1040 
     
    12301358        #DUMP TRUE # _4 
    12311359        CONNECTIONTYPE POSTGIS 
    1232         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1360        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    12331361        DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 
    12341362        # Statt EXPRESSION filtern besser gleich als WHERE in SQL 
     
    12641392        #DUMP TRUE # _4 
    12651393        CONNECTIONTYPE POSTGIS 
    1266         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1394        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    12671395        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 
    12681396        METADATA 
     
    13091437        #DUMP TRUE # _4 
    13101438        CONNECTIONTYPE POSTGIS 
    1311         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1439        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13121440        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    13131441        METADATA 
     
    13391467        #DUMP TRUE # _4 
    13401468        CONNECTIONTYPE POSTGIS 
    1341         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1469        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13421470        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry  FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 
    13431471        METADATA 
     
    13741502        TYPE POLYGON 
    13751503        CONNECTIONTYPE POSTGIS 
    1376         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1504        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    13771505        DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 
    13781506        METADATA 
     
    14771605        #DUMP TRUE # _4 
    14781606        CONNECTIONTYPE POSTGIS 
    1479         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1607        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    14801608        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 
    14811609        METADATA 
     
    15061634        #DUMP TRUE # _4 
    15071635        CONNECTIONTYPE POSTGIS 
    1508         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1636        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    15091637        DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 
    15101638        METADATA 
     
    15391667        TYPE POLYGON 
    15401668        CONNECTIONTYPE POSTGIS 
    1541         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     1669        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    15421670        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" 
    15431671        METADATA 
     
    18782006        TYPE POLYGON 
    18792007        CONNECTIONTYPE POSTGIS 
    1880         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2008        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    18812009        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" 
    18822010        METADATA 
     
    20022130        #DUMP TRUE # _4 
    20032131        CONNECTIONTYPE POSTGIS 
    2004         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2132        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    20052133        DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 
    20062134        METADATA 
     
    20662194        #DUMP TRUE # _4 
    20672195        CONNECTIONTYPE POSTGIS 
    2068         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2196        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    20692197        DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 
    20702198        METADATA 
     
    21012229        #DUMP TRUE # _4 
    21022230        CONNECTIONTYPE POSTGIS 
    2103         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2231        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    21042232        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 
    21052233        METADATA 
     
    21512279        DUMP TRUE 
    21522280        CONNECTIONTYPE POSTGIS 
    2153         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2281        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    21542282        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 
    21552283        METADATA 
     
    22022330        DUMP TRUE 
    22032331        CONNECTIONTYPE POSTGIS 
    2204         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2332        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    22052333        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    22062334 
     
    22352363        #DUMP TRUE # _4 
    22362364        CONNECTIONTYPE POSTGIS 
    2237         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2365        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    22382366        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    22392367        METADATA 
     
    22672395        #DUMP TRUE # _4 
    22682396        CONNECTIONTYPE POSTGIS 
    2269         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2397        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    22702398        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 
    22712399        METADATA 
     
    22972425        #DUMP TRUE # _4 
    22982426        CONNECTIONTYPE POSTGIS 
    2299         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2427        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    23002428        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 
    23012429        METADATA 
     
    23272455        #DUMP TRUE # _4 
    23282456        CONNECTIONTYPE POSTGIS 
    2329         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2457        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    23302458        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 
    23312459        FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    23682496        #DUMP TRUE # _4 
    23692497        CONNECTIONTYPE POSTGIS 
    2370         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2498        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    23712499        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 
    23722500        METADATA 
     
    23982526        #DUMP TRUE # _4 
    23992527        CONNECTIONTYPE POSTGIS 
    2400         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2528        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    24012529        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 
    24022530        METADATA 
     
    24272555        TYPE POLYGON 
    24282556        CONNECTIONTYPE POSTGIS 
    2429         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2557        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    24302558        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 
    24312559        FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver 
     
    24672595        #DUMP TRUE # _4 
    24682596        CONNECTIONTYPE POSTGIS 
    2469         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2597        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    24702598        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 
    24712599        METADATA 
     
    25072635        #DUMP TRUE # _4 
    25082636        CONNECTIONTYPE POSTGIS 
    2509         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2637        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    25102638        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry  FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 
    25112639        METADATA 
     
    25522680        #DUMP TRUE # _4 
    25532681        CONNECTIONTYPE POSTGIS 
    2554         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2682        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    25552683        DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 
    25562684        METADATA 
     
    25862714        TYPE POLYGON 
    25872715        CONNECTIONTYPE POSTGIS 
    2588         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2716        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    25892717        DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    25902718        METADATA 
     
    26182746        #DUMP TRUE # _4 
    26192747        CONNECTIONTYPE POSTGIS 
    2620         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2748        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    26212749        DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 
    26222750        METADATA 
     
    27492877        #DUMP TRUE # _4 
    27502878        CONNECTIONTYPE POSTGIS 
    2751         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2879        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    27522880        DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 
    27532881        METADATA 
     
    28022930        #DUMP TRUE # _4 
    28032931        CONNECTIONTYPE POSTGIS 
    2804         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2932        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    28052933        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 
    28062934        METADATA 
     
    28352963        STATUS ON 
    28362964        CONNECTIONTYPE POSTGIS 
    2837         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     2965        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    28382966        DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 
    28392967        METADATA 
     
    28733001        #DUMP TRUE # _4 
    28743002        CONNECTIONTYPE POSTGIS 
    2875         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3003        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    28763004        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 
    28773005        METADATA 
     
    29143042        #DUMP TRUE # _4 
    29153043        CONNECTIONTYPE POSTGIS 
    2916         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3044        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    29173045        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 
    29183046        METADATA 
     
    29463074        #DUMP TRUE # _4 
    29473075        CONNECTIONTYPE POSTGIS 
    2948         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3076        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    29493077        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 
    29503078        METADATA 
     
    29793107        #DUMP TRUE # _4 
    29803108        CONNECTIONTYPE POSTGIS 
    2981         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3109        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    29823110        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 
    29833111        METADATA 
     
    30123140        #DUMP TRUE # _4 
    30133141        CONNECTIONTYPE POSTGIS 
    3014         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3142        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    30153143        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 
    30163144        METADATA 
     
    30423170        #DUMP TRUE # _4 
    30433171        CONNECTIONTYPE POSTGIS 
    3044         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3172        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    30453173        DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 
    30463174        METADATA 
     
    30813209        #DUMP TRUE # _4 
    30823210        CONNECTIONTYPE POSTGIS 
    3083         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3211        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    30843212         
    30853213        #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" 
     
    31303258        TYPE LINE 
    31313259        CONNECTIONTYPE POSTGIS 
    3132         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3260        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    31333261        DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 
    31343262        METADATA 
     
    31883316        #SYMBOLSCALEDENOM 1000 
    31893317        CONNECTIONTYPE POSTGIS 
    3190         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3318        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    31913319        DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 
    31923320        CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze  IST EIN ARRAY! z.B.  {3000,7106} 
     
    32683396        SYMBOLSCALEDENOM 250 # 1000 
    32693397        CONNECTIONTYPE POSTGIS 
    3270         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3398        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    32713399        DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 
    32723400        CLASS 
     
    33043432        SYMBOLSCALEDENOM 250 #1000 
    33053433        CONNECTIONTYPE POSTGIS 
    3306         CONNECTION "host=localhost dbname=alkis06*gkz* user=ms5 port=5432" 
     3434        CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 
    33073435        DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 
    33083436        CLASS 
Note: See TracChangeset for help on using the changeset viewer.