- Timestamp:
- 02/17/12 14:57:42 (12 years ago)
- Location:
- trunk/data
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/konvert/postnas_0.7/konv_batch.sh
r162 r163 5 5 ## Batch-Teil, Aufruf mit geprueften Parametern - 6 6 ## ------------------------------------------------- 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 ## 7 20 ## Stand: 8 21 ## 2012-02-10 Umbennung nach 0.7 22 ## 2012-02-17 Optimierung 9 23 ## 10 ## Konverter: /opt/gdal-1.9 /bin/ = GDAL 1.9/ PostNAS 0.724 ## Konverter: /opt/gdal-1.9.1/bin/ = GDAL 1.9-DEV / PostNAS 0.7 11 25 ## Koordinaten: EPSG:25832 UTM, Zone 32 12 26 ## -a_srs EPSG:25832 - bleibt im UTM-System (korrigierte Werte) … … 50 64 # DB-Connection 51 65 con="-p 5432 -d ${DBNAME} " 52 #53 66 echo "Datenbank-Name . . = ${DBNAME}" 54 67 echo "Ordner NAS-Daten . = ${ORDNER}" … … 76 89 then 77 90 # 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 \ 79 92 PG:"dbname=${DBNAME} host=localhost port=5432" \ 80 93 -a_srs EPSG:25832 ${nasdatei} ${layer} 2>> $errprot … … 85 98 # A K T U A L I S I E R U N G 86 99 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 \ 88 101 PG:"dbname=${DBNAME} host=localhost port=5432" \ 89 102 -a_srs EPSG:25832 ${nasdatei} delete 2>> $errprot … … 96 109 # 97 110 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 \ 99 112 PG:"dbname=${DBNAME} host=localhost port=5432" \ 100 113 -a_srs EPSG:25832 ${nasdatei} ${layer} 2>> $errprot -
trunk/data/konvert/postnas_0.7/ordner_konvertieren.sh
r162 r163 3 3 ## Konvertierung von ALKIS NAS-Format nach PosGIS - 4 4 ## NAS-Daten in einem Ordner konvertieren - 5 ## Dialog-Teil zum Ermitteln der Parameter-5 ## Dialog-Teil zum Abfragen der Parameter - 6 6 ## ------------------------------------------------- 7 7 ## Stand: 8 8 ## 2012-02-10 PostNAS 07, Umbenennung 9 ## 2012-02-17 Parameter "DBUSER" raus 9 10 ## 10 11 function get_db_config(){ 11 12 # 12 13 # Name der zu ladenden ALKIS-Datenbank 14 # 13 15 until [ -n "$DBNAME" ] 14 16 do … … 17 19 read DBNAME 18 20 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 # 31 24 echo "" 32 25 echo "Ordner mit gezippten NAS-Daten (*.xml.zip)? (Absoluter Pfad)" … … 43 36 LSRESULT=$? 44 37 done 45 38 # 46 39 # Erstladen oder NBA-Aktualisierung 40 # 47 41 echo " " 48 42 echo "Art der Konvertierung" … … 54 48 read UPD 55 49 done 50 # 56 51 # Bestaetigung holen 52 # 57 53 echo " " 58 54 echo "Abschließende Bestätigung:" … … 74 70 echo "** Konvertierung ALKIS **" > /data/konvert/postnas_0.7/log/postnas_err.prot 75 71 echo "** Beginn Batch **" 76 ## 1 2 3 4 577 /data/konvert/postnas_0.7/konv_batch.sh $ORDNER $DBNAME $DBUSER$UPD72 ## 1 2 3 73 /data/konvert/postnas_0.7/konv_batch.sh $ORDNER $DBNAME $UPD 78 74 result=$? 79 75 if [ $result = 0 ] … … 85 81 echo " " 86 82 echo " Kommando fuer Wiederholung:" 87 echo " /data/konvert/postnas_0.7/konv_batch.sh $ORDNER $DBNAME $ DBUSER $UPD "83 echo " /data/konvert/postnas_0.7/konv_batch.sh $ORDNER $DBNAME $UPD " 88 84 echo " " 89 85 ### -
trunk/data/konvert/postnas_0.7/pp_definition.sql
r162 r163 2 2 -- ALKIS PostNAS 0.7 3 3 4 -- Post Processing Teil 1: Anlegen der Tabellen4 -- Post Processing (pp_) Teil 1: Anlegen der Tabellen und Views 5 5 6 6 -- Stand 7 7 8 8 -- 2012-02-13 PostNAS 07, Umbenennung 9 -- 2012-02-17 Optimierung 9 10 10 11 -- ============================ … … 42 43 43 44 CREATE TABLE pp_gemeinde ( 44 land integer, 45 gid serial, 46 land integer NOT NULL, 45 47 regierungsbezirk integer, 46 48 kreis integer, 47 gemeinde integer ,49 gemeinde integer NOT NULL, 48 50 gemeindename character varying(80), 49 51 -- gkz character varying(03), -- wird (noch) nicht benutzt 50 52 anz_gemarkg integer, -- Anzahl Gemarkungen 51 53 CONSTRAINT pp_gemeinde_pk PRIMARY KEY (land, gemeinde) 52 54 ); 53 55 54 55 -- GesamtflÀche 56 -- ALTER TABLE pp_gemeinde ADD COLUMN gid serial; 57 CREATE UNIQUE INDEX pp_gemeinde_gid_ix ON pp_gemeinde (gid); 58 59 -- Gesamtflaeche 56 60 SELECT AddGeometryColumn('pp_gemeinde','the_geom','25832','MULTIPOLYGON',2); 57 58 -- Index59 61 CREATE INDEX pp_gemeinde_gidx ON pp_gemeinde USING gist(the_geom); 60 62 61 -- vereinfachte Gesamtfl Àche63 -- vereinfachte Gesamtflaeche 62 64 SELECT AddGeometryColumn('pp_gemeinde','simple_geom','25832','MULTIPOLYGON',2); 63 64 65 CREATE INDEX pp_gemeinde_sgidx ON pp_gemeinde USING gist(simple_geom); 65 66 … … 68 69 COMMENT ON COLUMN pp_gemeinde.gemeinde IS 'Gemeindenummer'; 69 70 COMMENT ON COLUMN pp_gemeinde.gkz IS 'Gemeindekennziffer fÃŒr Mandant'; 71 COMMENT ON COLUMN pp_gemeinde.the_geom IS 'prÀzise Geometrie aus Summe aller Gemarkungen'; 72 COMMENT ON COLUMN pp_gemeinde.simple_geom IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÀben.'; 70 73 71 74 … … 80 83 -- muss diese Information als (redundante) Tabelle nach dem Laden zwischengespeichert werden. 81 84 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, 85 89 regierungsbezirk integer, 86 90 kreis integer, 87 gemeinde integer , -- fast ein Foreign-Key Constraint91 gemeinde integer NOT NULL, -- fast ein Foreign-Key Constraint 88 92 gemarkung integer NOT NULL, 89 93 gemarkungsname character varying(80), 90 anz_flur integer, -- Anzahl Fluren94 anz_flur integer, -- Anzahl Fluren 91 95 CONSTRAINT pp_gemarkung_pk PRIMARY KEY (land, gemarkung) 92 96 ); 93 97 98 -- ALTER TABLE pp_gemarkung ADD COLUMN gid serial; 99 CREATE UNIQUE INDEX pp_gemarkung_gid_ix ON pp_gemarkung (gid); 94 100 95 101 -- GesamtflÀche 96 102 SELECT AddGeometryColumn('pp_gemarkung','the_geom','25832','MULTIPOLYGON',2); 97 98 -- Index99 103 CREATE INDEX pp_gemarkung_gidx ON pp_gemarkung USING gist(the_geom); 100 101 104 102 105 -- vereinfachte GesamtflÀche 103 106 SELECT AddGeometryColumn('pp_gemarkung','simple_geom','25832','MULTIPOLYGON',2); 104 105 107 CREATE INDEX pp_gemarkung_sgidx ON pp_gemarkung USING gist(simple_geom); 106 108 107 109 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'; 110 COMMENT ON TABLE pp_gemarkung IS 'Post-Processing: Gemarkung. u.a. liegt in welcher Gemeinde'; 111 COMMENT ON COLUMN pp_gemarkung.gemeinde IS 'Gemeindenummer'; 112 COMMENT ON COLUMN pp_gemarkung.gemarkung IS 'Gemarkungsnummer'; 113 COMMENT ON COLUMN pp_gemarkung.the_geom IS 'prÀzise Geometrie aus Summe aller Fluren'; 114 COMMENT ON COLUMN pp_gemarkung.simple_geom IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÀben.'; 111 115 112 116 … … 115 119 116 120 CREATE TABLE pp_flur ( 117 land integer, 121 gid serial, 122 land integer NOT NULL, 118 123 regierungsbezirk integer, 119 124 kreis integer, 120 125 gemarkung integer NOT NULL, 121 126 flurnummer integer NOT NULL, 122 anz_fs integer, -- Anzahl FlurstÃŒcke127 anz_fs integer, -- Anzahl FlurstÃŒcke 123 128 CONSTRAINT pp_flur_pk PRIMARY KEY (land, gemarkung, flurnummer) 124 129 ); 125 130 131 -- ALTER TABLE pp_flur ADD COLUMN gid serial; 132 CREATE UNIQUE INDEX pp_flur_gid_ix ON pp_flur (gid); 133 126 134 -- GesamtflÀche 127 135 SELECT AddGeometryColumn('pp_flur','the_geom','25832','MULTIPOLYGON',2); 128 129 -- Index130 136 CREATE INDEX pp_flur_gidx ON pp_flur USING gist(the_geom); 131 137 132 138 COMMENT ON TABLE pp_flur IS 'Post-Processing: Flur'; 133 139 COMMENT ON COLUMN pp_flur.gemarkung IS 'Gemarkungsnummer'; 140 COMMENT ON COLUMN pp_flur.the_geom IS 'Geometrie aus Summe aller FlurstÃŒcke'; 134 141 135 142 … … 150 157 151 158 CREATE TABLE gemeinde_person ( 152 land 159 land integer, 153 160 regierungsbezirk integer, 154 kreis 161 kreis integer, 155 162 gemeinde integer, 156 person character varying(16), 163 person character varying(16), 157 164 buchtyp integer, 158 165 CONSTRAINT gemeinde_person_pk PRIMARY KEY (gemeinde, person) … … 288 295 289 296 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 303 CREATE 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 310 CREATE 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 290 317 -- ENDE -- -
trunk/data/konvert/postnas_0.7/pp_laden.sql
r162 r163 2 2 -- ALKIS PostNAS 0.7 3 3 4 -- Post Processing Teil 2: Laden der Tabellen4 -- Post Processing (pp_) Teil 2: Laden der Tabellen 5 5 6 6 -- Stand 7 7 8 8 -- 2012-02-13 PostNAS 07, Umbenennung 9 -- 2012-02-17 Optimierung 9 10 10 11 … … 81 82 82 83 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! 86 91 87 92 INSERT INTO pp_flur (land, regierungsbezirk, kreis, gemarkung, flurnummer, anz_fs, the_geom ) … … 104 109 ); 105 110 106 -- Fluren z ählen111 -- Fluren zaehlen 107 112 UPDATE pp_gemarkung a 108 113 SET anz_flur = … … 112 117 ); -- Gemarkungsnummer ist je BundesLand eindeutig 113 118 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) 120 UPDATE pp_gemarkung SET simple_geom = simplify(the_geom, 8.0); 118 121 119 122 … … 137 140 ); 138 141 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) 143 UPDATE pp_gemeinde SET simple_geom = simplify(the_geom, 20.0); 145 144 146 145 -
trunk/data/umn/alkis07/alkis07_muster.map
r160 r163 4 4 5 5 # 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 6 7 7 8 # ToDo: … … 61 62 END 62 63 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 71 LAYER 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 112 END 113 114 LAYER 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 153 END 154 155 LAYER 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 200 END 201 202 203 # ALKIS tatsaechliche Nutzung (Siedlung, Verkehr, GewÀsser, Vegetation) 64 204 # alle Layer von GROUP "ax_nutzungen" 65 205 … … 110 250 DUMP TRUE 111 251 CONNECTIONTYPE POSTGIS 112 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"252 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 113 253 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 114 254 METADATA … … 258 398 NAME "Platz" 259 399 STYLE 260 # COLOR -1 -1 -1 #?261 400 OUTLINECOLOR 153 153 153 262 401 END … … 518 657 REQUIRES "![nutzung_alle]" 519 658 CONNECTIONTYPE POSTGIS 520 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"659 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 521 660 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 522 661 METADATA … … 550 689 REQUIRES "![nutzung_alle]" 551 690 CONNECTIONTYPE POSTGIS 552 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"691 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 553 692 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 554 693 METADATA … … 582 721 REQUIRES "![nutzung_alle]" 583 722 CONNECTIONTYPE POSTGIS 584 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"723 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 585 724 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 586 725 METADATA … … 612 751 REQUIRES "![nutzung_alle]" 613 752 CONNECTIONTYPE POSTGIS 614 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"753 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 615 754 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 616 755 METADATA … … 641 780 REQUIRES "![nutzung_alle]" 642 781 CONNECTIONTYPE POSTGIS 643 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"782 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 644 783 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 645 784 METADATA … … 671 810 REQUIRES "![nutzung_alle]" 672 811 CONNECTIONTYPE POSTGIS 673 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"812 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 674 813 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 675 814 METADATA … … 703 842 REQUIRES "![nutzung_alle]" 704 843 CONNECTIONTYPE POSTGIS 705 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"844 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 706 845 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 707 846 METADATA … … 733 872 REQUIRES "![nutzung_alle]" 734 873 CONNECTIONTYPE POSTGIS 735 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"874 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 736 875 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 737 876 METADATA … … 764 903 REQUIRES "![nutzung_alle]" 765 904 CONNECTIONTYPE POSTGIS 766 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"905 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 767 906 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 768 907 METADATA … … 798 937 REQUIRES "![nutzung_alle]" 799 938 CONNECTIONTYPE POSTGIS 800 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"939 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 801 940 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 802 941 METADATA … … 861 1000 REQUIRES "![nutzung_alle]" 862 1001 CONNECTIONTYPE POSTGIS 863 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1002 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 864 1003 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 865 1004 METADATA … … 891 1030 REQUIRES "![nutzung_alle]" 892 1031 CONNECTIONTYPE POSTGIS 893 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1032 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 894 1033 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 895 1034 METADATA … … 929 1068 REQUIRES "![nutzung_alle]" 930 1069 CONNECTIONTYPE POSTGIS 931 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1070 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 932 1071 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 933 1072 METADATA … … 960 1099 REQUIRES "![nutzung_alle]" 961 1100 CONNECTIONTYPE POSTGIS 962 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1101 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 963 1102 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 964 1103 METADATA … … 991 1130 REQUIRES "![nutzung_alle]" 992 1131 CONNECTIONTYPE POSTGIS 993 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1132 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 994 1133 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 995 1134 METADATA … … 1024 1163 REQUIRES "![nutzung_alle]" 1025 1164 CONNECTIONTYPE POSTGIS 1026 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1165 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1027 1166 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 1028 1167 METADATA … … 1074 1213 REQUIRES "![nutzung_alle]" 1075 1214 CONNECTIONTYPE POSTGIS 1076 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1215 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1077 1216 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 1078 1217 METADATA … … 1103 1242 REQUIRES "![nutzung_alle]" 1104 1243 CONNECTIONTYPE POSTGIS 1105 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1244 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1106 1245 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 1107 1246 METADATA … … 1132 1271 REQUIRES "![nutzung_alle]" 1133 1272 CONNECTIONTYPE POSTGIS 1134 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1273 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1135 1274 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 1136 1275 METADATA … … 1161 1300 REQUIRES "![nutzung_alle]" 1162 1301 CONNECTIONTYPE POSTGIS 1163 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1302 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1164 1303 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 1165 1304 METADATA … … 1190 1329 REQUIRES "![nutzung_alle]" 1191 1330 CONNECTIONTYPE POSTGIS 1192 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1331 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1193 1332 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1194 1333 METADATA … … 1221 1360 REQUIRES "![nutzung_alle]" 1222 1361 CONNECTIONTYPE POSTGIS 1223 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1362 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1224 1363 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1225 1364 METADATA … … 1250 1389 REQUIRES "![nutzung_alle]" 1251 1390 CONNECTIONTYPE POSTGIS 1252 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1391 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1253 1392 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1254 1393 METADATA … … 1281 1420 REQUIRES "![nutzung_alle]" 1282 1421 CONNECTIONTYPE POSTGIS 1283 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1422 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1284 1423 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1285 1424 METADATA … … 1310 1449 REQUIRES "![nutzung_alle]" 1311 1450 CONNECTIONTYPE POSTGIS 1312 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1451 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1313 1452 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1314 1453 METADATA … … 1339 1478 REQUIRES "![nutzung_alle]" 1340 1479 CONNECTIONTYPE POSTGIS 1341 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1480 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1342 1481 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1343 1482 METADATA … … 1375 1514 # REQUIRES "![nutzung_alle]" 1376 1515 CONNECTIONTYPE POSTGIS 1377 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1516 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1378 1517 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1379 1518 # Feld funktion, Werte 1010, 1030, 1040 … … 1408 1547 DUMP TRUE 1409 1548 CONNECTIONTYPE POSTGIS 1410 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1549 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1411 1550 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1412 1551 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1443 1582 DUMP TRUE 1444 1583 CONNECTIONTYPE POSTGIS 1445 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1584 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1446 1585 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1447 1586 METADATA … … 1488 1627 DUMP TRUE 1489 1628 CONNECTIONTYPE POSTGIS 1490 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1629 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1491 1630 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1492 1631 METADATA … … 1521 1660 DUMP TRUE 1522 1661 CONNECTIONTYPE POSTGIS 1523 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1662 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1524 1663 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1525 1664 METADATA … … 1557 1696 DUMP TRUE 1558 1697 CONNECTIONTYPE POSTGIS 1559 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1698 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1560 1699 1561 1700 # Tabelle (Standard-Template) … … 1792 1931 DUMP TRUE 1793 1932 CONNECTIONTYPE POSTGIS 1794 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1933 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1795 1934 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1796 1935 METADATA … … 1821 1960 DUMP TRUE 1822 1961 CONNECTIONTYPE POSTGIS 1823 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1962 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1824 1963 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 1825 1964 METADATA … … 1864 2003 TYPE POLYGON 1865 2004 CONNECTIONTYPE POSTGIS 1866 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2005 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1867 2006 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" 1868 2007 # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das? … … 2222 2361 DUMP TRUE 2223 2362 CONNECTIONTYPE POSTGIS 2224 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2363 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2225 2364 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" 2226 2365 METADATA … … 2383 2522 DUMP TRUE 2384 2523 CONNECTIONTYPE POSTGIS 2385 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2524 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2386 2525 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2387 2526 METADATA … … 2451 2590 DUMP TRUE 2452 2591 CONNECTIONTYPE POSTGIS 2453 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2592 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2454 2593 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2455 2594 METADATA … … 2485 2624 DUMP TRUE 2486 2625 CONNECTIONTYPE POSTGIS 2487 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2626 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2488 2627 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2489 2628 … … 2533 2672 DUMP TRUE 2534 2673 CONNECTIONTYPE POSTGIS 2535 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2674 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2536 2675 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 2537 2676 # "s_nummer_nebengebaeude" = View … … 2584 2723 DUMP TRUE 2585 2724 CONNECTIONTYPE POSTGIS 2586 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2725 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2587 2726 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2588 2727 … … 2617 2756 DUMP TRUE 2618 2757 CONNECTIONTYPE POSTGIS 2619 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2758 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2620 2759 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2621 2760 METADATA … … 2649 2788 DUMP TRUE 2650 2789 CONNECTIONTYPE POSTGIS 2651 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2790 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2652 2791 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2653 2792 METADATA … … 2681 2820 DUMP TRUE 2682 2821 CONNECTIONTYPE POSTGIS 2683 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2822 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2684 2823 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2685 2824 METADATA … … 2711 2850 DUMP TRUE 2712 2851 CONNECTIONTYPE POSTGIS 2713 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2852 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2714 2853 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2715 2854 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2752 2891 DUMP TRUE 2753 2892 CONNECTIONTYPE POSTGIS 2754 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2893 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2755 2894 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2756 2895 METADATA … … 2782 2921 DUMP TRUE 2783 2922 CONNECTIONTYPE POSTGIS 2784 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2923 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2785 2924 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2786 2925 METADATA … … 2812 2951 DUMP TRUE 2813 2952 CONNECTIONTYPE POSTGIS 2814 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2953 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2815 2954 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 2816 2955 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2884 3023 DUMP TRUE 2885 3024 CONNECTIONTYPE POSTGIS 2886 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3025 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2887 3026 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 2888 3027 METADATA … … 2924 3063 DUMP TRUE 2925 3064 CONNECTIONTYPE POSTGIS 2926 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3065 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2927 3066 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 2928 3067 METADATA … … 2971 3110 DUMP TRUE 2972 3111 CONNECTIONTYPE POSTGIS 2973 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3112 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2974 3113 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 2975 3114 METADATA … … 3006 3145 DUMP TRUE 3007 3146 CONNECTIONTYPE POSTGIS 3008 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3147 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3009 3148 # mit Feldern fuer klassisches Template: 3010 3149 # DATA "wkb_geometry from (SELECT ogc_fid, gml_id, flurstueckskennzeichen, amtlicheflaeche, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" … … 3051 3190 DUMP TRUE 3052 3191 CONNECTIONTYPE POSTGIS 3053 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3192 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3054 3193 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 3055 3194 METADATA … … 3191 3330 DUMP TRUE 3192 3331 CONNECTIONTYPE POSTGIS 3193 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3332 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3194 3333 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 3195 3334 # View: ap_pto >dientZurDarstellungVon> ax_flurstueck … … 3385 3524 TYPE LINE 3386 3525 CONNECTIONTYPE POSTGIS 3387 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3526 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3388 3527 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 3389 3528 METADATA … … 3415 3554 STATUS ON 3416 3555 CONNECTIONTYPE POSTGIS 3417 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3556 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3418 3557 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 3419 3558 METADATA … … 3453 3592 TYPE POINT 3454 3593 CONNECTIONTYPE POSTGIS 3455 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3594 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3456 3595 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 3457 3596 METADATA … … 3498 3637 DUMP TRUE 3499 3638 CONNECTIONTYPE POSTGIS 3500 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3639 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3501 3640 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 3502 3641 METADATA … … 3530 3669 DUMP TRUE 3531 3670 CONNECTIONTYPE POSTGIS 3532 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3671 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3533 3672 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 3534 3673 METADATA … … 3563 3702 DUMP TRUE 3564 3703 CONNECTIONTYPE POSTGIS 3565 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3704 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3566 3705 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 3567 3706 METADATA … … 3596 3735 DUMP TRUE 3597 3736 CONNECTIONTYPE POSTGIS 3598 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3737 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3599 3738 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3600 3739 METADATA … … 3626 3765 DUMP TRUE 3627 3766 CONNECTIONTYPE POSTGIS 3628 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3767 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3629 3768 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3630 3769 METADATA … … 3666 3805 DUMP TRUE 3667 3806 CONNECTIONTYPE POSTGIS 3668 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3807 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3669 3808 3670 3809 #DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832" … … 3775 3914 DUMP TRUE 3776 3915 CONNECTIONTYPE POSTGIS 3777 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3916 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3778 3917 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3779 3918 METADATA … … 3837 3976 #SYMBOLSCALEDENOM 1000 3838 3977 CONNECTIONTYPE POSTGIS 3839 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3978 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3840 3979 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 3841 3980 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 3917 4056 SYMBOLSCALEDENOM 1000 3918 4057 CONNECTIONTYPE POSTGIS 3919 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"4058 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3920 4059 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 3921 4060 CLASS … … 3953 4092 SYMBOLSCALEDENOM 1000 3954 4093 CONNECTIONTYPE POSTGIS 3955 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"4094 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3956 4095 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 3957 4096 CLASS -
trunk/data/umn/alkis07/alkis07_muster_4.map
r160 r163 4 4 5 5 # 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 6 7 7 8 MAP … … 47 48 END 48 49 50 51 # ** aus Post-Processing: Katasterbezirke 52 53 LAYER 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 94 END 95 96 LAYER 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 135 END 136 137 LAYER 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 175 END 176 49 177 LAYER 50 178 NAME "nutzung_alle" 51 179 TYPE POLYGON 52 DUMP TRUE53 CONNECTIONTYPE POSTGIS 54 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"180 #DUMP TRUE 181 CONNECTIONTYPE POSTGIS 182 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 55 183 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 56 184 METADATA … … 58 186 wms_title "alle Nutzungsarten" 59 187 wms_abstract "Zusammenfassung aller Nutzungsarten-FlÀchen" 60 gml_include_items "all"188 #gml_include_items "all" 61 189 END 62 190 PROJECTION … … 346 474 REQUIRES "![nutzung_alle]" 347 475 CONNECTIONTYPE POSTGIS 348 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"476 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 349 477 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 350 478 METADATA … … 378 506 REQUIRES "![nutzung_alle]" 379 507 CONNECTIONTYPE POSTGIS 380 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"508 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 381 509 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 382 510 METADATA … … 410 538 REQUIRES "![nutzung_alle]" 411 539 CONNECTIONTYPE POSTGIS 412 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"540 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 413 541 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 414 542 METADATA … … 440 568 REQUIRES "![nutzung_alle]" 441 569 CONNECTIONTYPE POSTGIS 442 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"570 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 443 571 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 444 572 METADATA … … 469 597 REQUIRES "![nutzung_alle]" 470 598 CONNECTIONTYPE POSTGIS 471 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"599 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 472 600 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 473 601 METADATA … … 499 627 REQUIRES "![nutzung_alle]" 500 628 CONNECTIONTYPE POSTGIS 501 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"629 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 502 630 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 503 631 METADATA … … 531 659 REQUIRES "![nutzung_alle]" 532 660 CONNECTIONTYPE POSTGIS 533 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"661 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 534 662 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 535 663 METADATA … … 561 689 REQUIRES "![nutzung_alle]" 562 690 CONNECTIONTYPE POSTGIS 563 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"691 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 564 692 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 565 693 METADATA … … 592 720 REQUIRES "![nutzung_alle]" 593 721 CONNECTIONTYPE POSTGIS 594 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"722 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 595 723 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 596 724 METADATA … … 626 754 REQUIRES "![nutzung_alle]" 627 755 CONNECTIONTYPE POSTGIS 628 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"756 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 629 757 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 630 758 METADATA … … 689 817 REQUIRES "![nutzung_alle]" 690 818 CONNECTIONTYPE POSTGIS 691 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"819 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 692 820 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 693 821 METADATA … … 719 847 REQUIRES "![nutzung_alle]" 720 848 CONNECTIONTYPE POSTGIS 721 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"849 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 722 850 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 723 851 METADATA … … 757 885 REQUIRES "![nutzung_alle]" 758 886 CONNECTIONTYPE POSTGIS 759 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"887 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 760 888 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 761 889 METADATA … … 788 916 REQUIRES "![nutzung_alle]" 789 917 CONNECTIONTYPE POSTGIS 790 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"918 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 791 919 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 792 920 METADATA … … 819 947 REQUIRES "![nutzung_alle]" 820 948 CONNECTIONTYPE POSTGIS 821 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"949 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 822 950 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 823 951 METADATA … … 852 980 REQUIRES "![nutzung_alle]" 853 981 CONNECTIONTYPE POSTGIS 854 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"982 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 855 983 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 856 984 METADATA … … 901 1029 TYPE POLYGON 902 1030 CONNECTIONTYPE POSTGIS 903 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1031 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 904 1032 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 905 1033 METADATA … … 929 1057 TYPE POLYGON 930 1058 CONNECTIONTYPE POSTGIS 931 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1059 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 932 1060 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 933 1061 METADATA … … 957 1085 TYPE POLYGON 958 1086 CONNECTIONTYPE POSTGIS 959 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1087 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 960 1088 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 961 1089 METADATA … … 985 1113 TYPE POLYGON 986 1114 CONNECTIONTYPE POSTGIS 987 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1115 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 988 1116 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 989 1117 METADATA … … 1013 1141 TYPE POLYGON 1014 1142 CONNECTIONTYPE POSTGIS 1015 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1143 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1016 1144 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1017 1145 METADATA … … 1044 1172 REQUIRES "![nutzung_alle]" 1045 1173 CONNECTIONTYPE POSTGIS 1046 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1174 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1047 1175 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1048 1176 METADATA … … 1073 1201 REQUIRES "![nutzung_alle]" 1074 1202 CONNECTIONTYPE POSTGIS 1075 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1203 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1076 1204 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1077 1205 METADATA … … 1104 1232 REQUIRES "![nutzung_alle]" 1105 1233 CONNECTIONTYPE POSTGIS 1106 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1234 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1107 1235 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1108 1236 METADATA … … 1133 1261 REQUIRES "![nutzung_alle]" 1134 1262 CONNECTIONTYPE POSTGIS 1135 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1263 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1136 1264 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1137 1265 METADATA … … 1162 1290 REQUIRES "![nutzung_alle]" 1163 1291 CONNECTIONTYPE POSTGIS 1164 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1292 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1165 1293 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1166 1294 METADATA … … 1196 1324 #DUMP TRUE # _4 1197 1325 CONNECTIONTYPE POSTGIS 1198 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1326 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1199 1327 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1200 1328 # Feld funktion, Werte 1010, 1030, 1040 … … 1230 1358 #DUMP TRUE # _4 1231 1359 CONNECTIONTYPE POSTGIS 1232 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1360 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1233 1361 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1234 1362 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1264 1392 #DUMP TRUE # _4 1265 1393 CONNECTIONTYPE POSTGIS 1266 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1394 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1267 1395 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1268 1396 METADATA … … 1309 1437 #DUMP TRUE # _4 1310 1438 CONNECTIONTYPE POSTGIS 1311 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1439 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1312 1440 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1313 1441 METADATA … … 1339 1467 #DUMP TRUE # _4 1340 1468 CONNECTIONTYPE POSTGIS 1341 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1469 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1342 1470 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1343 1471 METADATA … … 1374 1502 TYPE POLYGON 1375 1503 CONNECTIONTYPE POSTGIS 1376 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1504 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1377 1505 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 1378 1506 METADATA … … 1477 1605 #DUMP TRUE # _4 1478 1606 CONNECTIONTYPE POSTGIS 1479 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1607 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1480 1608 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1481 1609 METADATA … … 1506 1634 #DUMP TRUE # _4 1507 1635 CONNECTIONTYPE POSTGIS 1508 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1636 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1509 1637 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 1510 1638 METADATA … … 1539 1667 TYPE POLYGON 1540 1668 CONNECTIONTYPE POSTGIS 1541 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"1669 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1542 1670 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" 1543 1671 METADATA … … 1878 2006 TYPE POLYGON 1879 2007 CONNECTIONTYPE POSTGIS 1880 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2008 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1881 2009 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" 1882 2010 METADATA … … 2002 2130 #DUMP TRUE # _4 2003 2131 CONNECTIONTYPE POSTGIS 2004 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2132 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2005 2133 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2006 2134 METADATA … … 2066 2194 #DUMP TRUE # _4 2067 2195 CONNECTIONTYPE POSTGIS 2068 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2196 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2069 2197 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2070 2198 METADATA … … 2101 2229 #DUMP TRUE # _4 2102 2230 CONNECTIONTYPE POSTGIS 2103 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2231 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2104 2232 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2105 2233 METADATA … … 2151 2279 DUMP TRUE 2152 2280 CONNECTIONTYPE POSTGIS 2153 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2281 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2154 2282 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 2155 2283 METADATA … … 2202 2330 DUMP TRUE 2203 2331 CONNECTIONTYPE POSTGIS 2204 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2332 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2205 2333 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2206 2334 … … 2235 2363 #DUMP TRUE # _4 2236 2364 CONNECTIONTYPE POSTGIS 2237 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2365 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2238 2366 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2239 2367 METADATA … … 2267 2395 #DUMP TRUE # _4 2268 2396 CONNECTIONTYPE POSTGIS 2269 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2397 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2270 2398 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2271 2399 METADATA … … 2297 2425 #DUMP TRUE # _4 2298 2426 CONNECTIONTYPE POSTGIS 2299 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2427 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2300 2428 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2301 2429 METADATA … … 2327 2455 #DUMP TRUE # _4 2328 2456 CONNECTIONTYPE POSTGIS 2329 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2457 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2330 2458 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2331 2459 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2368 2496 #DUMP TRUE # _4 2369 2497 CONNECTIONTYPE POSTGIS 2370 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2498 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2371 2499 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2372 2500 METADATA … … 2398 2526 #DUMP TRUE # _4 2399 2527 CONNECTIONTYPE POSTGIS 2400 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2528 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2401 2529 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2402 2530 METADATA … … 2427 2555 TYPE POLYGON 2428 2556 CONNECTIONTYPE POSTGIS 2429 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2557 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2430 2558 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 2431 2559 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2467 2595 #DUMP TRUE # _4 2468 2596 CONNECTIONTYPE POSTGIS 2469 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2597 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2470 2598 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 2471 2599 METADATA … … 2507 2635 #DUMP TRUE # _4 2508 2636 CONNECTIONTYPE POSTGIS 2509 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2637 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2510 2638 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 2511 2639 METADATA … … 2552 2680 #DUMP TRUE # _4 2553 2681 CONNECTIONTYPE POSTGIS 2554 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2682 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2555 2683 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 2556 2684 METADATA … … 2586 2714 TYPE POLYGON 2587 2715 CONNECTIONTYPE POSTGIS 2588 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2716 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2589 2717 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" 2590 2718 METADATA … … 2618 2746 #DUMP TRUE # _4 2619 2747 CONNECTIONTYPE POSTGIS 2620 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2748 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2621 2749 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 2622 2750 METADATA … … 2749 2877 #DUMP TRUE # _4 2750 2878 CONNECTIONTYPE POSTGIS 2751 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2879 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2752 2880 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 2753 2881 METADATA … … 2802 2930 #DUMP TRUE # _4 2803 2931 CONNECTIONTYPE POSTGIS 2804 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2932 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2805 2933 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2806 2934 METADATA … … 2835 2963 STATUS ON 2836 2964 CONNECTIONTYPE POSTGIS 2837 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"2965 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2838 2966 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 2839 2967 METADATA … … 2873 3001 #DUMP TRUE # _4 2874 3002 CONNECTIONTYPE POSTGIS 2875 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3003 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2876 3004 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 2877 3005 METADATA … … 2914 3042 #DUMP TRUE # _4 2915 3043 CONNECTIONTYPE POSTGIS 2916 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3044 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2917 3045 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 2918 3046 METADATA … … 2946 3074 #DUMP TRUE # _4 2947 3075 CONNECTIONTYPE POSTGIS 2948 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3076 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2949 3077 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 2950 3078 METADATA … … 2979 3107 #DUMP TRUE # _4 2980 3108 CONNECTIONTYPE POSTGIS 2981 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3109 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2982 3110 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 2983 3111 METADATA … … 3012 3140 #DUMP TRUE # _4 3013 3141 CONNECTIONTYPE POSTGIS 3014 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3142 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3015 3143 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3016 3144 METADATA … … 3042 3170 #DUMP TRUE # _4 3043 3171 CONNECTIONTYPE POSTGIS 3044 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3172 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3045 3173 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3046 3174 METADATA … … 3081 3209 #DUMP TRUE # _4 3082 3210 CONNECTIONTYPE POSTGIS 3083 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3211 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3084 3212 3085 3213 #DATA "wkb_geometry from (SELECT ogc_fid, schriftinhalt, art, drehwinkel * 57.296 AS winkel, wkb_geometry FROM ap_pto WHERE not schriftinhalt is null) as foo using unique ogc_fid using SRID=25832" … … 3130 3258 TYPE LINE 3131 3259 CONNECTIONTYPE POSTGIS 3132 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3260 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3133 3261 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3134 3262 METADATA … … 3188 3316 #SYMBOLSCALEDENOM 1000 3189 3317 CONNECTIONTYPE POSTGIS 3190 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3318 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3191 3319 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 3192 3320 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 3268 3396 SYMBOLSCALEDENOM 250 # 1000 3269 3397 CONNECTIONTYPE POSTGIS 3270 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3398 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3271 3399 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 3272 3400 CLASS … … 3304 3432 SYMBOLSCALEDENOM 250 #1000 3305 3433 CONNECTIONTYPE POSTGIS 3306 CONNECTION "host=localhost dbname=alkis0 6*gkz* user=ms5port=5432"3434 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3307 3435 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 3308 3436 CLASS
Note: See TracChangeset
for help on using the changeset viewer.