Ignore:
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

File:
1 edited

Legend:

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