Changeset 176 for trunk/data
- Timestamp:
- 04/17/12 18:35:28 (12 years ago)
- Location:
- trunk/data
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/konvert/postnas_0.7/pp_definition.sql
r163 r176 8 8 -- 2012-02-13 PostNAS 07, Umbenennung 9 9 -- 2012-02-17 Optimierung 10 -- 2012-02-28 gkz aus View nehmen 11 -- 2012-04-17 Flurstuecksnummern auf Standardposition 12 10 13 11 14 -- ============================ … … 66 69 67 70 68 COMMENT ON TABLE pp_gemeinde IS 'Post-Processing: Gemeinde';69 COMMENT ON COLUMN pp_gemeinde.gemeinde IS 'Gemeindenummer';70 COMMENT ON COLUMN pp_gemeinde.gkz IS 'Gemeindekennziffer fÃŒr Mandant';71 COMMENT ON COLUMN pp_gemeinde.the_geom IS 'prÀzise Geometrie aus Summe aller Gemarkungen';72 COMMENT ON COLUMN pp_gemeinde.simple_geom IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÀben.';71 COMMENT ON TABLE pp_gemeinde IS 'Post-Processing: Gemeinde'; 72 COMMENT ON COLUMN pp_gemeinde.gemeinde IS 'Gemeindenummer'; 73 --COMMENT ON COLUMN pp_gemeinde.gkz IS 'Gemeindekennziffer fÃŒr Mandant'; 74 COMMENT ON COLUMN pp_gemeinde.the_geom IS 'prÀzise Geometrie aus Summe aller Gemarkungen'; 75 COMMENT ON COLUMN pp_gemeinde.simple_geom IS 'vereinfachte Geometrie fÃŒr die Suche und die Anzeige von Ãbersichten in kleinen MaÃstÀben.'; 73 76 74 77 … … 152 155 153 156 154 -- pp_?157 -- Prefix "pp_" verwenden ? 155 158 156 159 --DROP TABLE gemeinde_person; … … 175 178 176 179 180 -- Flurstuecksnummern-Position 181 -- =========================== 182 183 -- ersetzt den View "s_flurstueck_nr" fÃŒr WMS-Layer "ag_t_flurstueck" 184 185 --DROP TABLE pp_flurstueck_nr; 186 187 CREATE TABLE pp_flurstueck_nr ( 188 gid serial, 189 fsgml character(16), 190 fsnum character varying(10), -- zzzzz/nnnn 191 CONSTRAINT pp_flurstueck_nr_pk PRIMARY KEY (gid), 192 CONSTRAINT pp_flurstueck_nr_gml FOREIGN KEY (fsgml) 193 REFERENCES ax_flurstueck (gml_id) MATCH SIMPLE 194 ON UPDATE CASCADE ON DELETE CASCADE 195 ); 196 197 SELECT AddGeometryColumn('pp_flurstueck_nr','the_geom','25832','POINT',2); 198 199 -- Geometrischer Index 200 CREATE INDEX pp_flurstueck_nr_gidx ON pp_flurstueck_nr USING gist(the_geom); 201 202 -- Foreig-Key Index 203 CREATE INDEX fki_pp_flurstueck_nr_gml ON pp_flurstueck_nr(fsgml); 204 205 COMMENT ON TABLE pp_flurstueck_nr IS 'Post-Processing: Position der FlurstÃŒcksnummer in der Karte'; 206 COMMENT ON COLUMN pp_flurstueck_nr.fsgml IS 'gml_id des zugehörigen FlurstÃŒcks-Objektes'; 207 COMMENT ON COLUMN pp_flurstueck_nr.fsnum IS 'Label, Darzustellende FS-Nummer als Bruch'; 208 COMMENT ON COLUMN pp_flurstueck_nr.the_geom IS 'Position der FlurstÃŒcksnummer in der Karte'; 209 210 177 211 -- ===== 178 212 -- VIEWs … … 185 219 CREATE VIEW gemeinde_gemarkung 186 220 AS 187 SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname , g.gkz221 SELECT g.land, g.regierungsbezirk, g.kreis, g.gemeinde, k.gemarkung, g.gemeindename, k.gemarkungsname 188 222 FROM pp_gemarkung k 189 223 JOIN pp_gemeinde g 190 224 ON k.land = g.land 191 AND k.gemeinde = g.gemeinde 192 ; 225 AND k.gemeinde = g.gemeinde; 193 226 194 227 -- VIEWs fuer die Zuordnung vom EigentÃŒmern zu Gemeinden … … 228 261 AND bnb.beziehungsart = 'istBestandteilVon' 229 262 AND bbg.beziehungsart = 'istBestandteilVon' 230 AND bsf.beziehungsart = 'istGebucht' 231 ; 263 AND bsf.beziehungsart = 'istGebucht'; 232 264 233 265 COMMENT ON VIEW gemeinde_person_typ1 IS 'Personen die EigentÃŒmer vom FlurstÃŒcken in einer Gemeinde sind. Typ1 = nomale Buchungen mit direkter Beziehung.'; … … 289 321 AND p.gemeinde = g.gemeinde 290 322 GROUP BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, g.gemeindename, p.buchtyp 291 ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp 292 ; 323 ORDER BY p.land, p.regierungsbezirk, p.kreis, p.gemeinde, p.buchtyp; 293 324 294 325 COMMENT ON VIEW gemeinde_person_statistik IS 'ZÀhlen der Personen je Gemeinde und Buchungstyp'; -
trunk/data/konvert/postnas_0.7/pp_laden.sql
r163 r176 8 8 -- 2012-02-13 PostNAS 07, Umbenennung 9 9 -- 2012-02-17 Optimierung 10 -- 2012-04-17 Flurstuecksnummern auf Standardposition 10 11 11 12 … … 22 23 23 24 -- Die per PostProcessing gefüllten Tabellen bekommen den Profix "pp_". 25 26 -- Die Ausführung dieses Scriptes auf einer Datenbank für eine 80T-Einwohner-Stadt dauert ca.: 500 Sek. ! 27 28 29 30 -- =========================== 31 -- Flurstuecksnummern-Position 32 -- =========================== 33 34 -- ersetzt den View "s_flurstueck_nr" für WMS-Layer "ag_t_flurstueck" 35 36 DELETE FROM pp_flurstueck_nr; 37 38 INSERT INTO pp_flurstueck_nr 39 ( fsgml, fsnum, the_geom ) 40 SELECT f.gml_id, 41 f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum, 42 p.wkb_geometry -- manuelle Position des Textes 43 FROM ap_pto p 44 JOIN alkis_beziehungen v ON p.gml_id = v.beziehung_von 45 JOIN ax_flurstueck f ON v.beziehung_zu = f.gml_id 46 WHERE v.beziehungsart = 'dientZurDarstellungVon' 47 --AND p."art" = 'ZAE_NEN' 48 UNION 49 SELECT f.gml_id, 50 f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum, 51 ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry -- Flaechenmitte als Position des Textes 52 FROM ax_flurstueck f 53 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f.gml_id 54 WHERE v.beziehungsart is NULL 55 ; 56 -- Ausführung: mittlere Stadt: ca. 4 - 18 Sec. 24 57 25 58 -
trunk/data/konvert/postnas_0.7/sichten.sql
r162 r176 6 6 7 7 -- 2012-02-25 PostNAS 07, Umbenennung 8 -- 2012-04-17 flstnr_ohne_position 9 8 10 9 11 -- ----------------------------------------- … … 12 14 13 15 14 -- Layer "ag_t_flurstueck"15 -- ----------------------- 16 -- WMS-Layer "ag_t_flurstueck" 17 -- --------------------------- 16 18 17 19 -- Die Geometrie befindet sich in "ap_pto", der Label in "ax_flurstueck" … … 20 22 21 23 -- Bruchnummerierung erzeugen 24 -- ALT 2012-04-17: Diese Version zeigt nur die manuell gesetzten Positionen 22 25 CREATE OR REPLACE VIEW s_flurstueck_nr 23 26 AS 24 SELECT ap_pto.ogc_fid, 25 ap_pto.wkb_geometry, -- Position des Textes 26 -- ax_flurstueck.flurstueckskennzeichen, -- am Stueck, aufgefuellt, unpraktisch 27 -- ax_flurstueck.gemarkungsnummer, -- integer 28 -- ax_flurstueck.flurnummer, -- integer 29 -- ax_flurstueck.zaehler, -- integer 30 -- ax_flurstueck.nenner, -- integer oder NULL 31 ax_flurstueck.zaehler::text || COALESCE ('/' || ax_flurstueck.nenner::text, '') AS fsnum 32 FROM ap_pto 33 JOIN alkis_beziehungen 34 ON ap_pto.gml_id = alkis_beziehungen.beziehung_von 35 JOIN ax_flurstueck 36 ON alkis_beziehungen.beziehung_zu = ax_flurstueck.gml_id 37 WHERE alkis_beziehungen.beziehungsart = 'dientZurDarstellungVon' 27 SELECT f.ogc_fid, 28 p.wkb_geometry, -- Position des Textes 29 f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 30 FROM ap_pto p 31 JOIN alkis_beziehungen v ON p.gml_id = v.beziehung_von 32 JOIN ax_flurstueck f ON v.beziehung_zu = f.gml_id 33 WHERE v.beziehungsart = 'dientZurDarstellungVon' 34 --AND p."art" = 'ZAE_NEN' 38 35 ; 39 36 40 37 COMMENT ON VIEW s_flurstueck_nr IS 'fuer Kartendarstellung: Bruchnummerierung FlurstÃŒck'; 38 39 -- NEU 2012-04-17 40 -- Wenn keine manuelle Position gesetzt ist, wird die Flaechenmitte verwendet 41 42 -- ACHTUNG: Dieser View kann nicht direkt im Mapserver-WMS verwendet werden. 43 -- Die Anzeige ist zu langsam. Filterung ÃŒber BBOX kann nicht funktionieren, da zunÀchst ALLE Standardpositionen 44 -- berechnet werden mÃŒssen, bevor darÃŒber gefiltert werden kann. 45 46 -- FAZIT: In einer Hilfstabelle mit geometrischem Index zwischenspeichern. 47 -- Siehe PostProcessing Tabelle "pp_flurstueck_nr" 48 49 CREATE OR REPLACE VIEW s_flurstueck_nr2 50 AS 51 SELECT f.ogc_fid, 52 p.wkb_geometry, -- manuelle Position des Textes 53 f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 54 FROM ap_pto p 55 JOIN alkis_beziehungen v ON p.gml_id = v.beziehung_von 56 JOIN ax_flurstueck f ON v.beziehung_zu = f.gml_id 57 WHERE v.beziehungsart = 'dientZurDarstellungVon' 58 --AND p."art" = 'ZAE_NEN' 59 UNION 60 SELECT f.ogc_fid, 61 ST_PointOnSurface(f.wkb_geometry) AS wkb_geometry, -- Flaechenmitte als Position des Textes 62 f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS fsnum 63 FROM ax_flurstueck f 64 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f.gml_id 65 WHERE v.beziehungsart is NULL 66 ; 67 68 COMMENT ON VIEW s_flurstueck_nr2 IS 'Bruchnummerierung FlurstÃŒck, auch Standard-Position. Nicht direkt fuer WMS verwenden'; 41 69 42 70 … … 313 341 -- Sichten fuer Fehlersuche und Daten-Analyse 314 342 -- ------------------------------------------ 343 344 345 -- FlurstÃŒcke mit Anzeige der FlurstÃŒcksnummer an der "Standardposition" 346 347 -- Nach der Konvertierung aus ALK hat zunÀchst jedes FlurstÃŒck eine explizit gesetzte Position der FlurstÃŒcksnummer. 348 349 -- Nach einer manuellen Teilung bekommen die neuen FlurstÃŒcke im ALKIS nur dann eine Position, 350 -- wenn die Positioin manuell bestimmt (verschoben) wurde. 351 -- Wenn die FlurstÃŒcksnummer an ihrer "Standardposition" angezeigt werden soll, 352 -- dann wird diese in den Daten (DHK, NAS) nicht gesetzt. 353 -- Der Konverter PostNAS konvertiert aber nur die Daten, die er bekommt, er setzt nicht die Standard-Position 354 -- fÃŒr die FlurstÃŒcke, die ohne eine manuelle Position kommen. 355 356 -- Diese FÀlle identifizieren 357 CREATE OR REPLACE VIEW flstnr_ohne_position 358 AS 359 SELECT f.gml_id, 360 f.gemarkungsnummer || '-' || f.flurnummer || '-' || f.zaehler::text || COALESCE ('/' || f.nenner::text, '') AS such -- Suchstring fÃŒr ALKIS-Navigation nach FS-Kennzeichen 361 FROM ax_flurstueck f 362 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f.gml_id 363 --LEFT JOIN ap_pto p ON p.gml_id = v.beziehung_von 364 WHERE v.beziehungsart is NULL 365 --ORDER BY f.gemarkungsnummer, f.flurnummer, f.zaehler 366 ; 367 368 COMMENT ON VIEW flstnr_ohne_position IS 'FlurstÃŒcke ohne manuell gesetzte Position fÃŒr die PrÀsentation der FS-Nr'; 369 315 370 316 371 -- Zeigt die Texte an, die nicht in einem der Mapfile-Views verarbeitet werden -
trunk/data/umn/alkis07/alkis07_muster.map
r171 r176 5 5 # 2012-02-09 F.J. krz Branch 0.7 aus Version 0.6 6 6 # 2012-02-17 F.J. krz data dbname=alkis07, Layer-Group pp_gebiete 7 # 2012-03-05 A.E. WG PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html 7 # 2012-03-05 F.J. krz PROCESSING "CLOSE_CONNECTION=DEFER" 8 # 2012-04-17 F.J. krz Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr 9 # Auch Standard-Position vom Flurstuecksnummern anzeigen 8 10 9 11 # ToDo: … … 76 78 DUMP true 77 79 CONNECTIONTYPE POSTGIS 78 PROCESSING "CLOSE_CONNECTION=DEFER"79 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"80 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 81 PROCESSING "CLOSE_CONNECTION=DEFER" 80 82 DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 81 83 METADATA … … 120 122 DUMP true 121 123 CONNECTIONTYPE POSTGIS 122 PROCESSING "CLOSE_CONNECTION=DEFER"123 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"124 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 125 PROCESSING "CLOSE_CONNECTION=DEFER" 124 126 DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 125 127 METADATA … … 162 164 DUMP true 163 165 CONNECTIONTYPE POSTGIS 164 PROCESSING "CLOSE_CONNECTION=DEFER"165 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"166 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 167 PROCESSING "CLOSE_CONNECTION=DEFER" 166 168 DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 167 169 METADATA … … 254 256 DUMP TRUE 255 257 CONNECTIONTYPE POSTGIS 256 PROCESSING "CLOSE_CONNECTION=DEFER"257 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"258 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 259 PROCESSING "CLOSE_CONNECTION=DEFER" 258 260 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 259 261 METADATA … … 662 664 REQUIRES "![nutzung_alle]" 663 665 CONNECTIONTYPE POSTGIS 664 PROCESSING "CLOSE_CONNECTION=DEFER"665 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"666 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 667 PROCESSING "CLOSE_CONNECTION=DEFER" 666 668 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 667 669 METADATA … … 695 697 REQUIRES "![nutzung_alle]" 696 698 CONNECTIONTYPE POSTGIS 697 PROCESSING "CLOSE_CONNECTION=DEFER"698 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"699 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 700 PROCESSING "CLOSE_CONNECTION=DEFER" 699 701 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 700 702 METADATA … … 728 730 REQUIRES "![nutzung_alle]" 729 731 CONNECTIONTYPE POSTGIS 730 PROCESSING "CLOSE_CONNECTION=DEFER"731 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"732 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 733 PROCESSING "CLOSE_CONNECTION=DEFER" 732 734 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 733 735 METADATA … … 759 761 REQUIRES "![nutzung_alle]" 760 762 CONNECTIONTYPE POSTGIS 761 PROCESSING "CLOSE_CONNECTION=DEFER"762 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"763 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 764 PROCESSING "CLOSE_CONNECTION=DEFER" 763 765 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 764 766 METADATA … … 789 791 REQUIRES "![nutzung_alle]" 790 792 CONNECTIONTYPE POSTGIS 791 PROCESSING "CLOSE_CONNECTION=DEFER"792 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"793 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 794 PROCESSING "CLOSE_CONNECTION=DEFER" 793 795 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 794 796 METADATA … … 820 822 REQUIRES "![nutzung_alle]" 821 823 CONNECTIONTYPE POSTGIS 822 PROCESSING "CLOSE_CONNECTION=DEFER"823 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"824 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 825 PROCESSING "CLOSE_CONNECTION=DEFER" 824 826 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 825 827 METADATA … … 853 855 REQUIRES "![nutzung_alle]" 854 856 CONNECTIONTYPE POSTGIS 855 PROCESSING "CLOSE_CONNECTION=DEFER"856 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"857 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 858 PROCESSING "CLOSE_CONNECTION=DEFER" 857 859 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 858 860 METADATA … … 884 886 REQUIRES "![nutzung_alle]" 885 887 CONNECTIONTYPE POSTGIS 886 PROCESSING "CLOSE_CONNECTION=DEFER"887 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"888 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 889 PROCESSING "CLOSE_CONNECTION=DEFER" 888 890 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 889 891 METADATA … … 916 918 REQUIRES "![nutzung_alle]" 917 919 CONNECTIONTYPE POSTGIS 918 PROCESSING "CLOSE_CONNECTION=DEFER"919 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"920 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 921 PROCESSING "CLOSE_CONNECTION=DEFER" 920 922 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 921 923 METADATA … … 951 953 REQUIRES "![nutzung_alle]" 952 954 CONNECTIONTYPE POSTGIS 953 PROCESSING "CLOSE_CONNECTION=DEFER"954 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"955 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 956 PROCESSING "CLOSE_CONNECTION=DEFER" 955 957 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 956 958 METADATA … … 1015 1017 REQUIRES "![nutzung_alle]" 1016 1018 CONNECTIONTYPE POSTGIS 1017 PROCESSING "CLOSE_CONNECTION=DEFER"1018 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1019 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1020 PROCESSING "CLOSE_CONNECTION=DEFER" 1019 1021 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 1020 1022 METADATA … … 1046 1048 REQUIRES "![nutzung_alle]" 1047 1049 CONNECTIONTYPE POSTGIS 1048 PROCESSING "CLOSE_CONNECTION=DEFER"1049 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1050 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1051 PROCESSING "CLOSE_CONNECTION=DEFER" 1050 1052 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 1051 1053 METADATA … … 1085 1087 REQUIRES "![nutzung_alle]" 1086 1088 CONNECTIONTYPE POSTGIS 1087 PROCESSING "CLOSE_CONNECTION=DEFER"1088 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1089 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1090 PROCESSING "CLOSE_CONNECTION=DEFER" 1089 1091 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 1090 1092 METADATA … … 1117 1119 REQUIRES "![nutzung_alle]" 1118 1120 CONNECTIONTYPE POSTGIS 1119 PROCESSING "CLOSE_CONNECTION=DEFER"1120 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1121 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1122 PROCESSING "CLOSE_CONNECTION=DEFER" 1121 1123 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 1122 1124 METADATA … … 1149 1151 REQUIRES "![nutzung_alle]" 1150 1152 CONNECTIONTYPE POSTGIS 1151 PROCESSING "CLOSE_CONNECTION=DEFER"1152 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1153 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1154 PROCESSING "CLOSE_CONNECTION=DEFER" 1153 1155 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 1154 1156 METADATA … … 1183 1185 REQUIRES "![nutzung_alle]" 1184 1186 CONNECTIONTYPE POSTGIS 1185 PROCESSING "CLOSE_CONNECTION=DEFER"1186 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1187 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1188 PROCESSING "CLOSE_CONNECTION=DEFER" 1187 1189 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 1188 1190 METADATA … … 1234 1236 REQUIRES "![nutzung_alle]" 1235 1237 CONNECTIONTYPE POSTGIS 1236 PROCESSING "CLOSE_CONNECTION=DEFER"1237 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1238 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1239 PROCESSING "CLOSE_CONNECTION=DEFER" 1238 1240 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 1239 1241 METADATA … … 1264 1266 REQUIRES "![nutzung_alle]" 1265 1267 CONNECTIONTYPE POSTGIS 1266 PROCESSING "CLOSE_CONNECTION=DEFER"1267 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1268 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1269 PROCESSING "CLOSE_CONNECTION=DEFER" 1268 1270 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 1269 1271 METADATA … … 1294 1296 REQUIRES "![nutzung_alle]" 1295 1297 CONNECTIONTYPE POSTGIS 1296 PROCESSING "CLOSE_CONNECTION=DEFER"1297 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1298 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1299 PROCESSING "CLOSE_CONNECTION=DEFER" 1298 1300 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 1299 1301 METADATA … … 1324 1326 REQUIRES "![nutzung_alle]" 1325 1327 CONNECTIONTYPE POSTGIS 1326 PROCESSING "CLOSE_CONNECTION=DEFER"1327 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1328 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1329 PROCESSING "CLOSE_CONNECTION=DEFER" 1328 1330 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 1329 1331 METADATA … … 1354 1356 REQUIRES "![nutzung_alle]" 1355 1357 CONNECTIONTYPE POSTGIS 1356 PROCESSING "CLOSE_CONNECTION=DEFER"1357 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1358 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1359 PROCESSING "CLOSE_CONNECTION=DEFER" 1358 1360 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1359 1361 METADATA … … 1386 1388 REQUIRES "![nutzung_alle]" 1387 1389 CONNECTIONTYPE POSTGIS 1388 PROCESSING "CLOSE_CONNECTION=DEFER"1389 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1390 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1391 PROCESSING "CLOSE_CONNECTION=DEFER" 1390 1392 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1391 1393 METADATA … … 1416 1418 REQUIRES "![nutzung_alle]" 1417 1419 CONNECTIONTYPE POSTGIS 1418 PROCESSING "CLOSE_CONNECTION=DEFER"1419 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1420 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1421 PROCESSING "CLOSE_CONNECTION=DEFER" 1420 1422 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1421 1423 METADATA … … 1448 1450 REQUIRES "![nutzung_alle]" 1449 1451 CONNECTIONTYPE POSTGIS 1450 PROCESSING "CLOSE_CONNECTION=DEFER"1451 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1452 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1453 PROCESSING "CLOSE_CONNECTION=DEFER" 1452 1454 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1453 1455 METADATA … … 1478 1480 REQUIRES "![nutzung_alle]" 1479 1481 CONNECTIONTYPE POSTGIS 1480 PROCESSING "CLOSE_CONNECTION=DEFER"1481 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1482 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1483 PROCESSING "CLOSE_CONNECTION=DEFER" 1482 1484 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1483 1485 METADATA … … 1508 1510 REQUIRES "![nutzung_alle]" 1509 1511 CONNECTIONTYPE POSTGIS 1510 PROCESSING "CLOSE_CONNECTION=DEFER"1511 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1512 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1513 PROCESSING "CLOSE_CONNECTION=DEFER" 1512 1514 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1513 1515 METADATA … … 1545 1547 # REQUIRES "![nutzung_alle]" 1546 1548 CONNECTIONTYPE POSTGIS 1547 PROCESSING "CLOSE_CONNECTION=DEFER"1548 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1549 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1550 PROCESSING "CLOSE_CONNECTION=DEFER" 1549 1551 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1550 1552 # Feld funktion, Werte 1010, 1030, 1040 … … 1579 1581 DUMP TRUE 1580 1582 CONNECTIONTYPE POSTGIS 1581 PROCESSING "CLOSE_CONNECTION=DEFER"1582 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1583 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1584 PROCESSING "CLOSE_CONNECTION=DEFER" 1583 1585 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1584 1586 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1615 1617 DUMP TRUE 1616 1618 CONNECTIONTYPE POSTGIS 1617 PROCESSING "CLOSE_CONNECTION=DEFER"1618 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1619 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1620 PROCESSING "CLOSE_CONNECTION=DEFER" 1619 1621 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1620 1622 METADATA … … 1661 1663 DUMP TRUE 1662 1664 CONNECTIONTYPE POSTGIS 1663 PROCESSING "CLOSE_CONNECTION=DEFER"1664 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1665 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1666 PROCESSING "CLOSE_CONNECTION=DEFER" 1665 1667 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1666 1668 METADATA … … 1695 1697 DUMP TRUE 1696 1698 CONNECTIONTYPE POSTGIS 1697 PROCESSING "CLOSE_CONNECTION=DEFER"1698 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1699 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1700 PROCESSING "CLOSE_CONNECTION=DEFER" 1699 1701 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1700 1702 METADATA … … 1732 1734 DUMP TRUE 1733 1735 CONNECTIONTYPE POSTGIS 1734 PROCESSING "CLOSE_CONNECTION=DEFER"1735 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1736 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1737 PROCESSING "CLOSE_CONNECTION=DEFER" 1736 1738 1737 1739 # Tabelle (Standard-Template) … … 1968 1970 DUMP TRUE 1969 1971 CONNECTIONTYPE POSTGIS 1970 PROCESSING "CLOSE_CONNECTION=DEFER"1971 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1972 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1973 PROCESSING "CLOSE_CONNECTION=DEFER" 1972 1974 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1973 1975 METADATA … … 1998 2000 DUMP TRUE 1999 2001 CONNECTIONTYPE POSTGIS 2000 PROCESSING "CLOSE_CONNECTION=DEFER"2001 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2002 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2003 PROCESSING "CLOSE_CONNECTION=DEFER" 2002 2004 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 2003 2005 METADATA … … 2042 2044 TYPE POLYGON 2043 2045 CONNECTIONTYPE POSTGIS 2044 PROCESSING "CLOSE_CONNECTION=DEFER"2045 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2046 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2047 PROCESSING "CLOSE_CONNECTION=DEFER" 2046 2048 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" 2047 2049 # Feld "ax_datenerhebung" fehlt im krz-Schema - was ist das? … … 2401 2403 DUMP TRUE 2402 2404 CONNECTIONTYPE POSTGIS 2403 PROCESSING "CLOSE_CONNECTION=DEFER"2404 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2405 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2406 PROCESSING "CLOSE_CONNECTION=DEFER" 2405 2407 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" 2406 2408 METADATA … … 2563 2565 DUMP TRUE 2564 2566 CONNECTIONTYPE POSTGIS 2565 PROCESSING "CLOSE_CONNECTION=DEFER"2566 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2567 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2568 PROCESSING "CLOSE_CONNECTION=DEFER" 2567 2569 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2568 2570 METADATA … … 2632 2634 DUMP TRUE 2633 2635 CONNECTIONTYPE POSTGIS 2634 PROCESSING "CLOSE_CONNECTION=DEFER"2635 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2636 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2637 PROCESSING "CLOSE_CONNECTION=DEFER" 2636 2638 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2637 2639 METADATA … … 2667 2669 DUMP TRUE 2668 2670 CONNECTIONTYPE POSTGIS 2669 PROCESSING "CLOSE_CONNECTION=DEFER"2670 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2671 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2672 PROCESSING "CLOSE_CONNECTION=DEFER" 2671 2673 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2672 2674 … … 2716 2718 DUMP TRUE 2717 2719 CONNECTIONTYPE POSTGIS 2718 PROCESSING "CLOSE_CONNECTION=DEFER"2719 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2720 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2721 PROCESSING "CLOSE_CONNECTION=DEFER" 2720 2722 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 2721 2723 # "s_nummer_nebengebaeude" = View … … 2768 2770 DUMP TRUE 2769 2771 CONNECTIONTYPE POSTGIS 2770 PROCESSING "CLOSE_CONNECTION=DEFER"2771 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2772 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2773 PROCESSING "CLOSE_CONNECTION=DEFER" 2772 2774 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2773 2775 … … 2802 2804 DUMP TRUE 2803 2805 CONNECTIONTYPE POSTGIS 2804 PROCESSING "CLOSE_CONNECTION=DEFER"2805 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2806 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2807 PROCESSING "CLOSE_CONNECTION=DEFER" 2806 2808 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2807 2809 METADATA … … 2835 2837 DUMP TRUE 2836 2838 CONNECTIONTYPE POSTGIS 2837 PROCESSING "CLOSE_CONNECTION=DEFER"2838 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2839 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2840 PROCESSING "CLOSE_CONNECTION=DEFER" 2839 2841 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2840 2842 METADATA … … 2868 2870 DUMP TRUE 2869 2871 CONNECTIONTYPE POSTGIS 2870 PROCESSING "CLOSE_CONNECTION=DEFER"2871 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2872 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2873 PROCESSING "CLOSE_CONNECTION=DEFER" 2872 2874 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2873 2875 METADATA … … 2899 2901 DUMP TRUE 2900 2902 CONNECTIONTYPE POSTGIS 2901 PROCESSING "CLOSE_CONNECTION=DEFER"2902 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2903 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2904 PROCESSING "CLOSE_CONNECTION=DEFER" 2903 2905 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2904 2906 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2941 2943 DUMP TRUE 2942 2944 CONNECTIONTYPE POSTGIS 2943 PROCESSING "CLOSE_CONNECTION=DEFER"2944 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2945 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2946 PROCESSING "CLOSE_CONNECTION=DEFER" 2945 2947 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2946 2948 METADATA … … 2972 2974 DUMP TRUE 2973 2975 CONNECTIONTYPE POSTGIS 2974 PROCESSING "CLOSE_CONNECTION=DEFER"2975 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2976 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2977 PROCESSING "CLOSE_CONNECTION=DEFER" 2976 2978 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2977 2979 METADATA … … 3003 3005 DUMP TRUE 3004 3006 CONNECTIONTYPE POSTGIS 3005 PROCESSING "CLOSE_CONNECTION=DEFER"3006 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3007 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3008 PROCESSING "CLOSE_CONNECTION=DEFER" 3007 3009 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 3008 3010 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 3076 3078 DUMP TRUE 3077 3079 CONNECTIONTYPE POSTGIS 3078 PROCESSING "CLOSE_CONNECTION=DEFER"3079 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3080 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3081 PROCESSING "CLOSE_CONNECTION=DEFER" 3080 3082 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 3081 3083 METADATA … … 3117 3119 DUMP TRUE 3118 3120 CONNECTIONTYPE POSTGIS 3119 PROCESSING "CLOSE_CONNECTION=DEFER"3120 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3121 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3122 PROCESSING "CLOSE_CONNECTION=DEFER" 3121 3123 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 3122 3124 METADATA … … 3165 3167 DUMP TRUE 3166 3168 CONNECTIONTYPE POSTGIS 3167 PROCESSING "CLOSE_CONNECTION=DEFER"3168 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3169 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3170 PROCESSING "CLOSE_CONNECTION=DEFER" 3169 3171 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 3170 3172 METADATA … … 3201 3203 DUMP TRUE 3202 3204 CONNECTIONTYPE POSTGIS 3203 PROCESSING "CLOSE_CONNECTION=DEFER"3204 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3205 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3206 PROCESSING "CLOSE_CONNECTION=DEFER" 3205 3207 # mit Feldern fuer klassisches Template: 3206 3208 # 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" … … 3247 3249 DUMP TRUE 3248 3250 CONNECTIONTYPE POSTGIS 3249 PROCESSING "CLOSE_CONNECTION=DEFER"3250 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3251 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3252 PROCESSING "CLOSE_CONNECTION=DEFER" 3251 3253 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 3252 3254 METADATA … … 3378 3380 # Ausgestaltung FS (DATA: Views in DB anlegen fuer Beziehungen) 3379 3381 3380 # Flurstueck nummer3382 # Flurstuecksnummer 3381 3383 3382 3384 # Musterdaten RLP: zaehler-nenner steht auch in Feld "ap_pto.schriftinhalt" … … 3388 3390 DUMP TRUE 3389 3391 CONNECTIONTYPE POSTGIS 3390 PROCESSING "CLOSE_CONNECTION=DEFER" 3391 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3392 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 3393 # View: ap_pto >dientZurDarstellungVon> ax_flurstueck 3394 # Felder: ogc_fid, wkb_geometry, gemarkungsnummer, flurnummer, zaehler, nenner, fsnum 3395 METADATA 3396 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 3397 wms_title "FlurstÃŒcknummer" 3398 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer" 3392 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3393 PROCESSING "CLOSE_CONNECTION=DEFER" 3394 # DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View 3395 DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing 3396 METADATA 3397 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 3398 wms_title "FlurstÃŒcksnummer" 3399 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer" 3399 3400 gml_include_items "all" 3400 3401 END … … 3443 3444 # 3444 3445 # CONNECTIONTYPE POSTGIS 3445 PROCESSING "CLOSE_CONNECTION=DEFER"3446 3446 # CONNECTION "host=localhost dbname=obk user=alkis" 3447 3447 # DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" … … 3510 3510 # DUMP TRUE 3511 3511 # CONNECTIONTYPE POSTGIS 3512 PROCESSING "CLOSE_CONNECTION=DEFER"3513 3512 # CONNECTION "host=localhost dbname=obk user=alkis" 3514 3513 # DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" … … 3545 3544 # DUMP TRUE 3546 3545 # CONNECTIONTYPE POSTGIS 3547 PROCESSING "CLOSE_CONNECTION=DEFER"3548 3546 # CONNECTION "host=localhost dbname=obk user=alkis" 3549 3547 # DATA "wkb_geometry from (SELECT * FROM alkis.obk_sk4111_flurstuecksnummer) as foo using unique ogc_fid using SRID=25832" … … 3586 3584 TYPE LINE 3587 3585 CONNECTIONTYPE POSTGIS 3588 PROCESSING "CLOSE_CONNECTION=DEFER"3589 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3586 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3587 PROCESSING "CLOSE_CONNECTION=DEFER" 3590 3588 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 3591 3589 METADATA … … 3617 3615 STATUS ON 3618 3616 CONNECTIONTYPE POSTGIS 3619 PROCESSING "CLOSE_CONNECTION=DEFER"3620 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3617 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3618 PROCESSING "CLOSE_CONNECTION=DEFER" 3621 3619 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 3622 3620 METADATA … … 3656 3654 TYPE POINT 3657 3655 CONNECTIONTYPE POSTGIS 3658 PROCESSING "CLOSE_CONNECTION=DEFER"3659 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3656 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3657 PROCESSING "CLOSE_CONNECTION=DEFER" 3660 3658 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry, drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 3661 3659 METADATA … … 3683 3681 SIZE 14 MINSIZE 7 MAXSIZE 24 3684 3682 POSITION cc 3685 # OFFSET 0 03686 3683 COLOR 0 0 0 3687 3684 ANGLE [drehwinkel] … … 3702 3699 DUMP TRUE 3703 3700 CONNECTIONTYPE POSTGIS 3704 PROCESSING "CLOSE_CONNECTION=DEFER"3705 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3701 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3702 PROCESSING "CLOSE_CONNECTION=DEFER" 3706 3703 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 3707 3704 METADATA … … 3735 3732 DUMP TRUE 3736 3733 CONNECTIONTYPE POSTGIS 3737 PROCESSING "CLOSE_CONNECTION=DEFER"3738 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3734 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3735 PROCESSING "CLOSE_CONNECTION=DEFER" 3739 3736 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 3740 3737 METADATA … … 3769 3766 DUMP TRUE 3770 3767 CONNECTIONTYPE POSTGIS 3771 PROCESSING "CLOSE_CONNECTION=DEFER"3772 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3768 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3769 PROCESSING "CLOSE_CONNECTION=DEFER" 3773 3770 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 3774 3771 METADATA … … 3803 3800 DUMP TRUE 3804 3801 CONNECTIONTYPE POSTGIS 3805 PROCESSING "CLOSE_CONNECTION=DEFER"3806 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3802 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3803 PROCESSING "CLOSE_CONNECTION=DEFER" 3807 3804 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3808 3805 METADATA … … 3834 3831 DUMP TRUE 3835 3832 CONNECTIONTYPE POSTGIS 3836 PROCESSING "CLOSE_CONNECTION=DEFER"3837 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3833 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3834 PROCESSING "CLOSE_CONNECTION=DEFER" 3838 3835 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3839 3836 METADATA … … 3875 3872 DUMP TRUE 3876 3873 CONNECTIONTYPE POSTGIS 3877 PROCESSING "CLOSE_CONNECTION=DEFER"3878 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3874 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3875 PROCESSING "CLOSE_CONNECTION=DEFER" 3879 3876 3880 3877 #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" … … 3985 3982 DUMP TRUE 3986 3983 CONNECTIONTYPE POSTGIS 3987 PROCESSING "CLOSE_CONNECTION=DEFER"3988 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3984 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3985 PROCESSING "CLOSE_CONNECTION=DEFER" 3989 3986 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3990 3987 METADATA … … 4048 4045 #SYMBOLSCALEDENOM 1000 4049 4046 CONNECTIONTYPE POSTGIS 4050 PROCESSING "CLOSE_CONNECTION=DEFER"4051 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"4047 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 4048 PROCESSING "CLOSE_CONNECTION=DEFER" 4052 4049 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 4053 4050 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 4129 4126 SYMBOLSCALEDENOM 1000 4130 4127 CONNECTIONTYPE POSTGIS 4131 PROCESSING "CLOSE_CONNECTION=DEFER"4132 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"4128 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 4129 PROCESSING "CLOSE_CONNECTION=DEFER" 4133 4130 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 4134 4131 CLASS … … 4166 4163 SYMBOLSCALEDENOM 1000 4167 4164 CONNECTIONTYPE POSTGIS 4168 PROCESSING "CLOSE_CONNECTION=DEFER"4169 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"4165 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 4166 PROCESSING "CLOSE_CONNECTION=DEFER" 4170 4167 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 4171 4168 CLASS -
trunk/data/umn/alkis07/alkis07_muster_4.map
r171 r176 5 5 # 2012-02-09 F.J. krz Branch 0.7 aus Version 0.6 6 6 # 2012-02-17 F.J. krz data dbname=alkis07, Layer-Group pp_gebiete 7 # 2012-03-05 A.E. WG PROCESSING "CLOSE_CONNECTION=DEFER" eingefÃŒgt siehe auch http://mapserver.org/mapfile/layer.html 7 # 2012-03-05 F.J. krz PROCESSING "CLOSE_CONNECTION=DEFER" 8 # 2012-04-17 F.J. krz Tabelle pp_flurstueck_nr ersetzt View s_flurstueck_nr 9 # Auch Standard-Position vom Flurstuecksnummern anzeigen 10 8 11 MAP 9 12 NAME "alkis" … … 57 60 DUMP true 58 61 CONNECTIONTYPE POSTGIS 59 PROCESSING "CLOSE_CONNECTION=DEFER"60 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"62 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 63 PROCESSING "CLOSE_CONNECTION=DEFER" 61 64 DATA "simple_geom from (SELECT gid, gemeindename, simple_geom FROM pp_gemeinde) as foo using unique gid using SRID=25832" 62 65 METADATA … … 101 104 #DUMP true 102 105 CONNECTIONTYPE POSTGIS 103 PROCESSING "CLOSE_CONNECTION=DEFER"104 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"106 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 107 PROCESSING "CLOSE_CONNECTION=DEFER" 105 108 DATA "simple_geom from (SELECT gid, gemarkungsname, simple_geom FROM pp_gemarkung) as foo using unique gid using SRID=25832" 106 109 METADATA … … 143 146 #DUMP true 144 147 CONNECTIONTYPE POSTGIS 145 PROCESSING "CLOSE_CONNECTION=DEFER"146 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"148 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 149 PROCESSING "CLOSE_CONNECTION=DEFER" 147 150 DATA "the_geom from (SELECT gid, gemarkung, flurnummer, the_geom FROM pp_flur) as foo using unique gid using SRID=25832" 148 151 METADATA … … 183 186 #DUMP TRUE 184 187 CONNECTIONTYPE POSTGIS 185 PROCESSING "CLOSE_CONNECTION=DEFER"186 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"188 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 189 PROCESSING "CLOSE_CONNECTION=DEFER" 187 190 DATA "wkb_geometry from (SELECT gml_id, nutz_id, class, wkb_geometry FROM nutzung) as foo using unique gml_id using SRID=25832" 188 191 METADATA … … 478 481 REQUIRES "![nutzung_alle]" 479 482 CONNECTIONTYPE POSTGIS 480 PROCESSING "CLOSE_CONNECTION=DEFER"481 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"483 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 484 PROCESSING "CLOSE_CONNECTION=DEFER" 482 485 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wohnbauflaeche) as foo using unique ogc_fid using SRID=25832" 483 486 METADATA … … 511 514 REQUIRES "![nutzung_alle]" 512 515 CONNECTIONTYPE POSTGIS 513 PROCESSING "CLOSE_CONNECTION=DEFER"514 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"516 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 517 PROCESSING "CLOSE_CONNECTION=DEFER" 515 518 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_industrieundgewerbeflaeche) as foo using unique ogc_fid using SRID=25832" 516 519 METADATA … … 544 547 REQUIRES "![nutzung_alle]" 545 548 CONNECTIONTYPE POSTGIS 546 PROCESSING "CLOSE_CONNECTION=DEFER"547 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"549 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 550 PROCESSING "CLOSE_CONNECTION=DEFER" 548 551 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_halde) as foo using unique ogc_fid using SRID=25832" 549 552 METADATA … … 575 578 REQUIRES "![nutzung_alle]" 576 579 CONNECTIONTYPE POSTGIS 577 PROCESSING "CLOSE_CONNECTION=DEFER"578 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"580 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 581 PROCESSING "CLOSE_CONNECTION=DEFER" 579 582 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_bergbaubetrieb) as foo using unique ogc_fid using SRID=25832" 580 583 METADATA … … 605 608 REQUIRES "![nutzung_alle]" 606 609 CONNECTIONTYPE POSTGIS 607 PROCESSING "CLOSE_CONNECTION=DEFER"608 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"610 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 611 PROCESSING "CLOSE_CONNECTION=DEFER" 609 612 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_tagebaugrubesteinbruch) as foo using unique ogc_fid using SRID=25832" 610 613 METADATA … … 636 639 REQUIRES "![nutzung_alle]" 637 640 CONNECTIONTYPE POSTGIS 638 PROCESSING "CLOSE_CONNECTION=DEFER"639 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"641 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 642 PROCESSING "CLOSE_CONNECTION=DEFER" 640 643 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechegemischternutzung) as foo using unique ogc_fid using SRID=25832" 641 644 METADATA … … 669 672 REQUIRES "![nutzung_alle]" 670 673 CONNECTIONTYPE POSTGIS 671 PROCESSING "CLOSE_CONNECTION=DEFER"672 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"674 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 675 PROCESSING "CLOSE_CONNECTION=DEFER" 673 676 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flaechebesondererfunktionalerpraegung) as foo using unique ogc_fid using SRID=25832" 674 677 METADATA … … 700 703 REQUIRES "![nutzung_alle]" 701 704 CONNECTIONTYPE POSTGIS 702 PROCESSING "CLOSE_CONNECTION=DEFER"703 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"705 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 706 PROCESSING "CLOSE_CONNECTION=DEFER" 704 707 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_sportfreizeitunderholungsflaeche) as foo using unique ogc_fid using SRID=25832" 705 708 METADATA … … 732 735 REQUIRES "![nutzung_alle]" 733 736 CONNECTIONTYPE POSTGIS 734 PROCESSING "CLOSE_CONNECTION=DEFER"735 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"737 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 738 PROCESSING "CLOSE_CONNECTION=DEFER" 736 739 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_friedhof) as foo using unique ogc_fid using SRID=25832" 737 740 METADATA … … 767 770 REQUIRES "![nutzung_alle]" 768 771 CONNECTIONTYPE POSTGIS 769 PROCESSING "CLOSE_CONNECTION=DEFER"770 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"772 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 773 PROCESSING "CLOSE_CONNECTION=DEFER" 771 774 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_strassenverkehr) as foo using unique ogc_fid using SRID=25832" 772 775 METADATA … … 831 834 REQUIRES "![nutzung_alle]" 832 835 CONNECTIONTYPE POSTGIS 833 PROCESSING "CLOSE_CONNECTION=DEFER"834 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"836 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 837 PROCESSING "CLOSE_CONNECTION=DEFER" 835 838 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_weg) as foo using unique ogc_fid using SRID=25832" 836 839 METADATA … … 862 865 REQUIRES "![nutzung_alle]" 863 866 CONNECTIONTYPE POSTGIS 864 PROCESSING "CLOSE_CONNECTION=DEFER"865 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"867 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 868 PROCESSING "CLOSE_CONNECTION=DEFER" 866 869 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_platz) as foo using unique ogc_fid using SRID=25832" 867 870 METADATA … … 901 904 REQUIRES "![nutzung_alle]" 902 905 CONNECTIONTYPE POSTGIS 903 PROCESSING "CLOSE_CONNECTION=DEFER"904 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"906 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 907 PROCESSING "CLOSE_CONNECTION=DEFER" 905 908 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_bahnverkehr) as foo using unique ogc_fid using SRID=25832" 906 909 METADATA … … 933 936 REQUIRES "![nutzung_alle]" 934 937 CONNECTIONTYPE POSTGIS 935 PROCESSING "CLOSE_CONNECTION=DEFER"936 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"938 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 939 PROCESSING "CLOSE_CONNECTION=DEFER" 937 940 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_flugverkehr) as foo using unique ogc_fid using SRID=25832" 938 941 METADATA … … 965 968 REQUIRES "![nutzung_alle]" 966 969 CONNECTIONTYPE POSTGIS 967 PROCESSING "CLOSE_CONNECTION=DEFER"968 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"970 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 971 PROCESSING "CLOSE_CONNECTION=DEFER" 969 972 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_schiffsverkehr) as foo using unique ogc_fid using SRID=25832" 970 973 METADATA … … 999 1002 REQUIRES "![nutzung_alle]" 1000 1003 CONNECTIONTYPE POSTGIS 1001 PROCESSING "CLOSE_CONNECTION=DEFER"1002 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1004 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1005 PROCESSING "CLOSE_CONNECTION=DEFER" 1003 1006 DATA "wkb_geometry from (SELECT ogc_fid, vegetationsmerkmal, wkb_geometry FROM ax_landwirtschaft) as foo using unique ogc_fid using SRID=25832" 1004 1007 METADATA … … 1049 1052 TYPE POLYGON 1050 1053 CONNECTIONTYPE POSTGIS 1051 PROCESSING "CLOSE_CONNECTION=DEFER"1052 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1054 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1055 PROCESSING "CLOSE_CONNECTION=DEFER" 1053 1056 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_wald) as foo using unique ogc_fid using SRID=25832" 1054 1057 METADATA … … 1078 1081 TYPE POLYGON 1079 1082 CONNECTIONTYPE POSTGIS 1080 PROCESSING "CLOSE_CONNECTION=DEFER"1081 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1083 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1084 PROCESSING "CLOSE_CONNECTION=DEFER" 1082 1085 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_gehoelz) as foo using unique ogc_fid using SRID=25832" 1083 1086 METADATA … … 1107 1110 TYPE POLYGON 1108 1111 CONNECTIONTYPE POSTGIS 1109 PROCESSING "CLOSE_CONNECTION=DEFER"1110 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1112 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1113 PROCESSING "CLOSE_CONNECTION=DEFER" 1111 1114 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_heide) as foo using unique ogc_fid using SRID=25832" 1112 1115 METADATA … … 1136 1139 TYPE POLYGON 1137 1140 CONNECTIONTYPE POSTGIS 1138 PROCESSING "CLOSE_CONNECTION=DEFER"1139 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1141 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1142 PROCESSING "CLOSE_CONNECTION=DEFER" 1140 1143 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_moor) as foo using unique ogc_fid using SRID=25832" 1141 1144 METADATA … … 1165 1168 TYPE POLYGON 1166 1169 CONNECTIONTYPE POSTGIS 1167 PROCESSING "CLOSE_CONNECTION=DEFER"1168 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1170 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1171 PROCESSING "CLOSE_CONNECTION=DEFER" 1169 1172 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_sumpf) as foo using unique ogc_fid using SRID=25832" 1170 1173 METADATA … … 1197 1200 REQUIRES "![nutzung_alle]" 1198 1201 CONNECTIONTYPE POSTGIS 1199 PROCESSING "CLOSE_CONNECTION=DEFER"1200 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1202 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1203 PROCESSING "CLOSE_CONNECTION=DEFER" 1201 1204 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_unlandvegetationsloseflaeche) as foo using unique ogc_fid using SRID=25832" 1202 1205 METADATA … … 1227 1230 REQUIRES "![nutzung_alle]" 1228 1231 CONNECTIONTYPE POSTGIS 1229 PROCESSING "CLOSE_CONNECTION=DEFER"1230 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1232 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1233 PROCESSING "CLOSE_CONNECTION=DEFER" 1231 1234 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_vegetationsmerkmal) as foo using unique ogc_fid using SRID=25832" 1232 1235 METADATA … … 1259 1262 REQUIRES "![nutzung_alle]" 1260 1263 CONNECTIONTYPE POSTGIS 1261 PROCESSING "CLOSE_CONNECTION=DEFER"1262 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1264 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1265 PROCESSING "CLOSE_CONNECTION=DEFER" 1263 1266 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_fliessgewaesser) as foo using unique ogc_fid using SRID=25832" 1264 1267 METADATA … … 1289 1292 REQUIRES "![nutzung_alle]" 1290 1293 CONNECTIONTYPE POSTGIS 1291 PROCESSING "CLOSE_CONNECTION=DEFER"1292 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1294 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1295 PROCESSING "CLOSE_CONNECTION=DEFER" 1293 1296 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_hafenbecken) as foo using unique ogc_fid using SRID=25832" 1294 1297 METADATA … … 1319 1322 REQUIRES "![nutzung_alle]" 1320 1323 CONNECTIONTYPE POSTGIS 1321 PROCESSING "CLOSE_CONNECTION=DEFER"1322 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1324 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1325 PROCESSING "CLOSE_CONNECTION=DEFER" 1323 1326 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_stehendesgewaesser) as foo using unique ogc_fid using SRID=25832" 1324 1327 METADATA … … 1354 1357 #DUMP TRUE # _4 1355 1358 CONNECTIONTYPE POSTGIS 1356 PROCESSING "CLOSE_CONNECTION=DEFER"1357 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1359 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1360 PROCESSING "CLOSE_CONNECTION=DEFER" 1358 1361 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1359 1362 # Feld funktion, Werte 1010, 1030, 1040 … … 1389 1392 #DUMP TRUE # _4 1390 1393 CONNECTIONTYPE POSTGIS 1391 PROCESSING "CLOSE_CONNECTION=DEFER"1392 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1394 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1395 PROCESSING "CLOSE_CONNECTION=DEFER" 1393 1396 DATA "wkb_geometry from (SELECT ogc_fid, funktion, wkb_geometry FROM ax_untergeordnetesgewaesser) as foo using unique ogc_fid using SRID=25832" 1394 1397 # Statt EXPRESSION filtern besser gleich als WHERE in SQL … … 1424 1427 #DUMP TRUE # _4 1425 1428 CONNECTIONTYPE POSTGIS 1426 PROCESSING "CLOSE_CONNECTION=DEFER"1427 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1429 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1430 PROCESSING "CLOSE_CONNECTION=DEFER" 1428 1431 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_klassifizierungnachstrassenrecht) as foo using unique ogc_fid using SRID=25832" 1429 1432 METADATA … … 1470 1473 #DUMP TRUE # _4 1471 1474 CONNECTIONTYPE POSTGIS 1472 PROCESSING "CLOSE_CONNECTION=DEFER"1473 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1475 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1476 PROCESSING "CLOSE_CONNECTION=DEFER" 1474 1477 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_naturumweltoderbodenschutzrecht) as foo using unique ogc_fid using SRID=25832" 1475 1478 METADATA … … 1501 1504 #DUMP TRUE # _4 1502 1505 CONNECTIONTYPE POSTGIS 1503 PROCESSING "CLOSE_CONNECTION=DEFER"1504 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1506 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1507 PROCESSING "CLOSE_CONNECTION=DEFER" 1505 1508 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_anderefestlegungnachwasserrecht) as foo using unique ogc_fid using SRID=25832" 1506 1509 METADATA … … 1537 1540 TYPE POLYGON 1538 1541 CONNECTIONTYPE POSTGIS 1539 PROCESSING "CLOSE_CONNECTION=DEFER"1540 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1542 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1543 PROCESSING "CLOSE_CONNECTION=DEFER" 1541 1544 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, artderfestlegung, wkb_geometry FROM ax_bauraumoderbodenordnungsrecht) as foo using unique ogc_fid using SRID=25832" 1542 1545 METADATA … … 1641 1644 #DUMP TRUE # _4 1642 1645 CONNECTIONTYPE POSTGIS 1643 PROCESSING "CLOSE_CONNECTION=DEFER"1644 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1646 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1647 PROCESSING "CLOSE_CONNECTION=DEFER" 1645 1648 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_denkmalschutzrecht) as foo using unique ogc_fid using SRID=25832" 1646 1649 METADATA … … 1671 1674 #DUMP TRUE # _4 1672 1675 CONNECTIONTYPE POSTGIS 1673 PROCESSING "CLOSE_CONNECTION=DEFER"1674 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1676 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1677 PROCESSING "CLOSE_CONNECTION=DEFER" 1675 1678 DATA "wkb_geometry from (SELECT ogc_fid, artderfestlegung, wkb_geometry FROM ax_sonstigesrecht) as foo using unique ogc_fid using SRID=25832" 1676 1679 METADATA … … 1705 1708 TYPE POLYGON 1706 1709 CONNECTIONTYPE POSTGIS 1707 PROCESSING "CLOSE_CONNECTION=DEFER"1708 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"1710 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 1711 PROCESSING "CLOSE_CONNECTION=DEFER" 1709 1712 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" 1710 1713 METADATA … … 2045 2048 TYPE POLYGON 2046 2049 CONNECTIONTYPE POSTGIS 2047 PROCESSING "CLOSE_CONNECTION=DEFER"2048 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2050 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2051 PROCESSING "CLOSE_CONNECTION=DEFER" 2049 2052 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" 2050 2053 METADATA … … 2170 2173 #DUMP TRUE # _4 2171 2174 CONNECTIONTYPE POSTGIS 2172 PROCESSING "CLOSE_CONNECTION=DEFER"2173 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2175 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2176 PROCESSING "CLOSE_CONNECTION=DEFER" 2174 2177 DATA "wkb_geometry from (SELECT ogc_fid, bauart, lagezurerdoberflaeche, wkb_geometry FROM ax_bauteil) as foo using unique ogc_fid using SRID=25832" 2175 2178 METADATA … … 2235 2238 #DUMP TRUE # _4 2236 2239 CONNECTIONTYPE POSTGIS 2237 PROCESSING "CLOSE_CONNECTION=DEFER"2238 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2240 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2241 PROCESSING "CLOSE_CONNECTION=DEFER" 2239 2242 DATA "wkb_geometry from (SELECT ogc_fid, beschaffenheit, wkb_geometry FROM ax_besonderegebaeudelinie) as foo using unique ogc_fid using SRID=25832" 2240 2243 METADATA … … 2271 2274 #DUMP TRUE # _4 2272 2275 CONNECTIONTYPE POSTGIS 2273 PROCESSING "CLOSE_CONNECTION=DEFER"2274 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2276 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2277 PROCESSING "CLOSE_CONNECTION=DEFER" 2275 2278 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel,hausnummer FROM s_hausnummer_gebaeude) as foo using unique ogc_fid using SRID=25832" 2276 2279 METADATA … … 2322 2325 DUMP TRUE 2323 2326 CONNECTIONTYPE POSTGIS 2324 PROCESSING "CLOSE_CONNECTION=DEFER"2325 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2327 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2328 PROCESSING "CLOSE_CONNECTION=DEFER" 2326 2329 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 2327 2330 METADATA … … 2374 2377 DUMP TRUE 2375 2378 CONNECTIONTYPE POSTGIS 2376 PROCESSING "CLOSE_CONNECTION=DEFER"2377 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2379 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2380 PROCESSING "CLOSE_CONNECTION=DEFER" 2378 2381 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_gebaeude) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2379 2382 … … 2408 2411 #DUMP TRUE # _4 2409 2412 CONNECTIONTYPE POSTGIS 2410 PROCESSING "CLOSE_CONNECTION=DEFER"2411 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2413 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2414 PROCESSING "CLOSE_CONNECTION=DEFER" 2412 2415 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2413 2416 METADATA … … 2441 2444 #DUMP TRUE # _4 2442 2445 CONNECTIONTYPE POSTGIS 2443 PROCESSING "CLOSE_CONNECTION=DEFER"2444 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2446 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2447 PROCESSING "CLOSE_CONNECTION=DEFER" 2445 2448 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimverkehrsbereich) as foo using unique ogc_fid using SRID=25832" 2446 2449 METADATA … … 2472 2475 #DUMP TRUE # _4 2473 2476 CONNECTIONTYPE POSTGIS 2474 PROCESSING "CLOSE_CONNECTION=DEFER"2475 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2477 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2478 PROCESSING "CLOSE_CONNECTION=DEFER" 2476 2479 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkimgewaesserbereich) as foo using unique ogc_fid using SRID=25832" 2477 2480 METADATA … … 2503 2506 #DUMP TRUE # _4 2504 2507 CONNECTIONTYPE POSTGIS 2505 PROCESSING "CLOSE_CONNECTION=DEFER"2506 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2508 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2509 PROCESSING "CLOSE_CONNECTION=DEFER" 2507 2510 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid using SRID=25832" 2508 2511 FILTER "st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2545 2548 #DUMP TRUE # _4 2546 2549 CONNECTIONTYPE POSTGIS 2547 PROCESSING "CLOSE_CONNECTION=DEFER"2548 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2550 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2551 PROCESSING "CLOSE_CONNECTION=DEFER" 2549 2552 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_bauwerkoderanlagefuersportfreizeitunderholung) as foo using unique ogc_fid using SRID=25832" 2550 2553 METADATA … … 2576 2579 #DUMP TRUE # _4 2577 2580 CONNECTIONTYPE POSTGIS 2578 PROCESSING "CLOSE_CONNECTION=DEFER"2579 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2581 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2582 PROCESSING "CLOSE_CONNECTION=DEFER" 2580 2583 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_vorratsbehaelterspeicherbauwerk) as foo using unique ogc_fid using SRID=25832" 2581 2584 METADATA … … 2606 2609 TYPE POLYGON 2607 2610 CONNECTIONTYPE POSTGIS 2608 PROCESSING "CLOSE_CONNECTION=DEFER"2609 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2611 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2612 PROCESSING "CLOSE_CONNECTION=DEFER" 2610 2613 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_sonstigesbauwerkodersonstigeeinrichtung) as foo using unique ogc_fid using SRID=25832" 2611 2614 FILTER "bauwerksfunktion in (1610,1781) AND st_geometrytype(wkb_geometry) = 'ST_Polygon'" # sonst Absturz Mapserver … … 2647 2650 #DUMP TRUE # _4 2648 2651 CONNECTIONTYPE POSTGIS 2649 PROCESSING "CLOSE_CONNECTION=DEFER"2650 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2652 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2653 PROCESSING "CLOSE_CONNECTION=DEFER" 2651 2654 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, spannungsebene, wkb_geometry FROM ax_leitung) as foo using unique ogc_fid using SRID=25832" 2652 2655 METADATA … … 2688 2691 #DUMP TRUE # _4 2689 2692 CONNECTIONTYPE POSTGIS 2690 PROCESSING "CLOSE_CONNECTION=DEFER"2691 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2693 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2694 PROCESSING "CLOSE_CONNECTION=DEFER" 2692 2695 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, lagezurerdoberflaeche, wkb_geometry FROM ax_transportanlage) as foo using unique ogc_fid using SRID=25832" 2693 2696 METADATA … … 2734 2737 #DUMP TRUE # _4 2735 2738 CONNECTIONTYPE POSTGIS 2736 PROCESSING "CLOSE_CONNECTION=DEFER"2737 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2739 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2740 PROCESSING "CLOSE_CONNECTION=DEFER" 2738 2741 DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM ax_turm) as foo using unique ogc_fid using SRID=25832" 2739 2742 METADATA … … 2769 2772 TYPE POLYGON 2770 2773 CONNECTIONTYPE POSTGIS 2771 PROCESSING "CLOSE_CONNECTION=DEFER"2772 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2774 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2775 PROCESSING "CLOSE_CONNECTION=DEFER" 2773 2776 DATA "wkb_geometry from (SELECT ogc_fid, gml_id, wkb_geometry FROM ax_flurstueck) as foo using unique ogc_fid using SRID=25832" 2774 2777 METADATA … … 2802 2805 #DUMP TRUE # _4 2803 2806 CONNECTIONTYPE POSTGIS 2804 PROCESSING "CLOSE_CONNECTION=DEFER"2805 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2807 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2808 PROCESSING "CLOSE_CONNECTION=DEFER" 2806 2809 DATA "wkb_geometry from (SELECT ogc_fid, artderflurstuecksgrenze, wkb_geometry FROM ax_besondereflurstuecksgrenze) as foo using unique ogc_fid using SRID=25832" 2807 2810 METADATA … … 2927 2930 END 2928 2931 2929 # Flurstueck nummer2932 # Flurstuecksnummer 2930 2933 LAYER 2931 2934 NAME "ag_t_flurstueck" … … 2934 2937 #DUMP TRUE # _4 2935 2938 CONNECTIONTYPE POSTGIS 2936 PROCESSING "CLOSE_CONNECTION=DEFER" 2937 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2938 DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" 2939 METADATA 2940 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 2941 wms_title "Flurstuecknummer" 2942 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcknummer" 2939 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2940 PROCESSING "CLOSE_CONNECTION=DEFER" 2941 # DATA "wkb_geometry from (SELECT * FROM s_flurstueck_nr) as foo using unique ogc_fid using SRID=25832" # View 2942 DATA "the_geom from (SELECT * FROM pp_flurstueck_nr) as foo using unique gid using SRID=25832" # Tabelle aus PostProcessing 2943 METADATA 2944 wms_srs "epsg:31467 epsg:4326 epsg:25832 epsg:54004" 2945 wms_title "Flurstuecksnummer" 2946 wms_abstract "ALKIS FlurstÃŒck FlurstÃŒcksnummer" 2943 2947 #gml_include_items "all" 2944 2948 END … … 2988 2992 #DUMP TRUE # _4 2989 2993 CONNECTIONTYPE POSTGIS 2990 PROCESSING "CLOSE_CONNECTION=DEFER"2991 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"2994 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 2995 PROCESSING "CLOSE_CONNECTION=DEFER" 2992 2996 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry FROM s_zuordungspfeil_flurstueck) as foo using unique ogc_fid using SRID=25832" # View gespeichert 2993 2997 METADATA … … 3022 3026 STATUS ON 3023 3027 CONNECTIONTYPE POSTGIS 3024 PROCESSING "CLOSE_CONNECTION=DEFER"3025 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3028 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3029 PROCESSING "CLOSE_CONNECTION=DEFER" 3026 3030 DATA "wkb_geometry from (SELECT * FROM s_zuordungspfeilspitze_flurstueck) as foo using unique ogc_fid using SRID=25832" # View berechnet Winkel 3027 3031 METADATA … … 3061 3065 #DUMP TRUE # _4 3062 3066 CONNECTIONTYPE POSTGIS 3063 PROCESSING "CLOSE_CONNECTION=DEFER"3064 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3067 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3068 PROCESSING "CLOSE_CONNECTION=DEFER" 3065 3069 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,drehwinkel FROM s_zugehoerigkeitshaken_flurstueck) as foo using unique ogc_fid using SRID=25832" 3066 3070 METADATA … … 3081 3085 LABEL 3082 3086 TYPE TRUETYPE 3083 FONT "alk _textsymbols"3087 FONT "alkis_textsymbols" 3084 3088 SIZE 28.4 #7.1 3085 3089 POSITION cc … … 3103 3107 #DUMP TRUE # _4 3104 3108 CONNECTIONTYPE POSTGIS 3105 PROCESSING "CLOSE_CONNECTION=DEFER"3106 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3109 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3110 PROCESSING "CLOSE_CONNECTION=DEFER" 3107 3111 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_grablochderbodenschaetzung) as foo using unique ogc_fid using SRID=25832" 3108 3112 METADATA … … 3136 3140 #DUMP TRUE # _4 3137 3141 CONNECTIONTYPE POSTGIS 3138 PROCESSING "CLOSE_CONNECTION=DEFER"3139 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3142 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3143 PROCESSING "CLOSE_CONNECTION=DEFER" 3140 3144 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_musterlandesmusterundvergleichsstueck) as foo using unique ogc_fid using SRID=25832" 3141 3145 METADATA … … 3170 3174 #DUMP TRUE # _4 3171 3175 CONNECTIONTYPE POSTGIS 3172 PROCESSING "CLOSE_CONNECTION=DEFER"3173 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3176 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3177 PROCESSING "CLOSE_CONNECTION=DEFER" 3174 3178 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortta) as foo using unique ogc_fid using SRID=25832" 3175 3179 METADATA … … 3204 3208 #DUMP TRUE # _4 3205 3209 CONNECTIONTYPE POSTGIS 3206 PROCESSING "CLOSE_CONNECTION=DEFER"3207 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3210 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3211 PROCESSING "CLOSE_CONNECTION=DEFER" 3208 3212 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortag) as foo using unique ogc_fid using SRID=25832" 3209 3213 METADATA … … 3235 3239 #DUMP TRUE # _4 3236 3240 CONNECTIONTYPE POSTGIS 3237 PROCESSING "CLOSE_CONNECTION=DEFER"3238 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3241 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3242 PROCESSING "CLOSE_CONNECTION=DEFER" 3239 3243 DATA "wkb_geometry from (SELECT ogc_fid, wkb_geometry FROM ax_punktortau) as foo using unique ogc_fid using SRID=25832" 3240 3244 METADATA … … 3275 3279 #DUMP TRUE # _4 3276 3280 CONNECTIONTYPE POSTGIS 3277 PROCESSING "CLOSE_CONNECTION=DEFER"3278 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3281 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3282 PROCESSING "CLOSE_CONNECTION=DEFER" 3279 3283 3280 3284 #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" … … 3325 3329 TYPE LINE 3326 3330 CONNECTIONTYPE POSTGIS 3327 PROCESSING "CLOSE_CONNECTION=DEFER"3328 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3331 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3332 PROCESSING "CLOSE_CONNECTION=DEFER" 3329 3333 DATA "wkb_geometry from (SELECT ogc_fid,wkb_geometry,art FROM ap_lpo) as foo using unique ogc_fid using SRID=25832" 3330 3334 METADATA … … 3384 3388 #SYMBOLSCALEDENOM 1000 3385 3389 CONNECTIONTYPE POSTGIS 3386 PROCESSING "CLOSE_CONNECTION=DEFER"3387 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3390 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3391 PROCESSING "CLOSE_CONNECTION=DEFER" 3388 3392 DATA 'wkb_geometry from (SELECT * FROM sk201x_politische_grenze) as foo using unique ogc_fid using SRID=25832' 3389 3393 CLASSITEM 'art' # Art der besonderen Grundstuecksgrenze IST EIN ARRAY! z.B. {3000,7106} … … 3465 3469 SYMBOLSCALEDENOM 250 # 1000 3466 3470 CONNECTIONTYPE POSTGIS 3467 PROCESSING "CLOSE_CONNECTION=DEFER"3468 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3471 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3472 PROCESSING "CLOSE_CONNECTION=DEFER" 3469 3473 DATA 'wkb_geometry from (SELECT * FROM sk2014_gemarkungsgrenze) as foo using unique ogc_fid using SRID=25832' 3470 3474 CLASS … … 3502 3506 SYMBOLSCALEDENOM 250 #1000 3503 3507 CONNECTIONTYPE POSTGIS 3504 PROCESSING "CLOSE_CONNECTION=DEFER"3505 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432"3508 CONNECTION "host=localhost dbname=alkis07*gkz* user=ms6 port=5432" 3509 PROCESSING "CLOSE_CONNECTION=DEFER" 3506 3510 DATA 'wkb_geometry from (SELECT * FROM sk2012_flurgrenze) as foo using unique ogc_fid using SRID=25832' 3507 3511 CLASS
Note: See TracChangeset
for help on using the changeset viewer.