Changeset 252 for trunk/import
- Timestamp:
- 02/01/13 17:06:43 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/sichten_ORACLE.sql
r251 r252 5 5 CREATE OR REPLACE VIEW S_FLURSTUECK_NR 6 6 AS 7 SELECT f. ogr_fid,8 p. ora_geometry,9 f.zaehler ::text || COALESCE ('/' || f.nenner::text, '') AS fsnum7 SELECT f.OGR_FID, 8 p.ORA_GEOMETRY, 9 f.zaehler || COALESCE ('/' || f.nenner, '') AS FSNUM 10 10 FROM ap_pto p 11 JOIN alkis_beziehungen v ON p. gml_id= v.beziehung_von12 JOIN ax_flurstueck f ON v.beziehung_zu = f. gml_id11 JOIN alkis_beziehungen v ON p.GL_ID = v.beziehung_von 12 JOIN ax_flurstueck f ON v.beziehung_zu = f.GL_ID 13 13 WHERE v.beziehungsart = 'dientZurDarstellungVon' 14 14 AND p.endet IS NULL … … 18 18 CREATE OR REPLACE VIEW S_FLURSTUECK_NR2 19 19 AS 20 SELECT f. ogr_fid,21 p. ora_geometry,22 f.zaehler ::text || COALESCE ('/' || f.nenner::text, '') AS fsnum20 SELECT f.OGR_FID, 21 p.ORA_GEOMETRY, 22 f.zaehler || COALESCE ('/' || f.nenner, '') AS FSNUM 23 23 FROM ap_pto p 24 JOIN alkis_beziehungen v ON p. gml_id= v.beziehung_von25 JOIN ax_flurstueck f ON v.beziehung_zu = f. gml_id24 JOIN alkis_beziehungen v ON p.GL_ID = v.beziehung_von 25 JOIN ax_flurstueck f ON v.beziehung_zu = f.GL_ID 26 26 WHERE v.beziehungsart = 'dientZurDarstellungVon' 27 27 AND p.endet IS NULL 28 28 AND f.endet IS NULL 29 29 UNION 30 SELECT f. ogr_fid,31 ST_PointOnSurface(f. ora_geometry) AS wkb_geometry,32 f.zaehler ::text || COALESCE ('/' || f.nenner::text, '') AS fsnum30 SELECT f.OGR_FID, 31 ST_PointOnSurface(f.ORA_GEOMETRY) AS wkb_geometry, 32 f.zaehler || COALESCE ('/' || f.nenner, '') AS FSNUM 33 33 FROM ax_flurstueck f 34 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f. gml_id34 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f.GL_ID 35 35 WHERE v.beziehungsart is NULL 36 36 AND f.endet IS NULL … … 39 39 CREATE OR REPLACE VIEW S_HAUSNUMMER_GEBAEUDE 40 40 AS 41 SELECT p. ogr_fid,42 p. ora_geometry,43 p. drehwinkel * 57.296 AS drehwinkel,41 SELECT p.OGR_FID, 42 p.ORA_GEOMETRY, 43 p.DREHWINKEL * 57.296 AS DREHWINKEL, 44 44 l.hausnummer 45 45 FROM ap_pto p 46 46 JOIN alkis_beziehungen v 47 ON p. gml_id= v.beziehung_von47 ON p.GL_ID = v.beziehung_von 48 48 JOIN AX_LAGEBEZEICHNUNGMITHAUSNUMME l 49 ON v.beziehung_zu = l. gml_id49 ON v.beziehung_zu = l.GL_ID 50 50 WHERE v.beziehungsart = 'dientZurDarstellungVon' 51 51 AND p.endet IS NULL … … 54 54 CREATE OR REPLACE VIEW S_NUMMER_NEBENGEBAEUDE 55 55 AS 56 SELECT p. ogr_fid,57 p. ora_geometry,58 p. drehwinkel * 57.296 AS drehwinkel,56 SELECT p.OGR_FID, 57 p.ORA_GEOMETRY, 58 p.DREHWINKEL * 57.296 AS DREHWINKEL, 59 59 l.laufendenummer 60 60 FROM ap_pto p 61 61 JOIN alkis_beziehungen v 62 ON p. gml_id= v.beziehung_von62 ON p.GL_ID = v.beziehung_von 63 63 JOIN AX_LAGEBEZEICHNUNGMITPSEUDONUM l 64 ON v.beziehung_zu = l. gml_id64 ON v.beziehung_zu = l.GL_ID 65 65 WHERE v.beziehungsart = 'dientZurDarstellungVon' 66 66 AND p.endet IS NULL … … 70 70 CREATE OR REPLACE VIEW S_ZUGEHOERIGKEITSHAKEN_FLURSTU 71 71 AS 72 SELECT p. ogr_fid,73 p. ora_geometry,74 p. drehwinkel * 57.296 AS drehwinkel,72 SELECT p.OGR_FID, 73 p.ORA_GEOMETRY, 74 p.DREHWINKEL * 57.296 AS DREHWINKEL, 75 75 f.flurstueckskennzeichen 76 76 FROM ap_ppo p 77 77 JOIN alkis_beziehungen v 78 ON p. gml_id= v.beziehung_von78 ON p.GL_ID = v.beziehung_von 79 79 JOIN ax_flurstueck f 80 ON v.beziehung_zu = f. gml_id80 ON v.beziehung_zu = f.GL_ID 81 81 WHERE p.art = 'Haken' 82 82 AND v.beziehungsart = 'dientZurDarstellungVon' … … 86 86 CREATE OR REPLACE VIEW S_ZUORDUNGSPFEIL_FLURSTUECK 87 87 AS 88 SELECT l. ogr_fid,89 l. ora_geometry88 SELECT l.OGR_FID, 89 l.ORA_GEOMETRY 90 90 FROM ap_lpo l 91 91 JOIN alkis_beziehungen v 92 ON l. gml_id= v.beziehung_von92 ON l.GL_ID = v.beziehung_von 93 93 JOIN ax_flurstueck f 94 ON v.beziehung_zu = f. gml_id94 ON v.beziehung_zu = f.GL_ID 95 95 WHERE l.art = 'Pfeil' 96 96 AND v.beziehungsart = 'dientZurDarstellungVon' … … 101 101 CREATE OR REPLACE VIEW S_ZUORDUNGSPFEILSPITZE_FLURSTU 102 102 AS 103 SELECT l. ogr_fid,104 (((st_azimuth(st_pointn(l. ora_geometry, 1),105 st_pointn(l. ora_geometry, 2)) * (- (180)::double precision)) / pi()) + (90)::double precision) AS winkel,106 st_startpoint(l. ora_geometry) AS wkb_geometry103 SELECT l.OGR_FID, 104 (((st_azimuth(st_pointn(l.ORA_GEOMETRY, 1), 105 st_pointn(l.ORA_GEOMETRY, 2)) * (- (180)::double precision)) / pi()) + (90)::double precision) AS WINKEL, 106 st_startpoint(l.ORA_GEOMETRY) AS wkb_geometry 107 107 FROM ap_lpo l 108 108 JOIN alkis_beziehungen v 109 ON l. gml_id= v.beziehung_von109 ON l.GL_ID = v.beziehung_von 110 110 JOIN ax_flurstueck f 111 ON v.beziehung_zu = f. gml_id111 ON v.beziehung_zu = f.GL_ID 112 112 WHERE l.art = 'Pfeil' 113 113 AND v.beziehungsart = 'dientZurDarstellungVon' … … 118 118 CREATE OR REPLACE VIEW S_BESCHRIFTUNG 119 119 AS 120 SELECT p. ogr_fid,120 SELECT p.OGR_FID, 121 121 p.schriftinhalt, 122 122 p.art, 123 p. drehwinkel * 57.296 AS winkel,124 p. ora_geometry123 p.DREHWINKEL * 57.296 AS WINKEL, 124 p.ORA_GEOMETRY 125 125 FROM ap_pto p 126 126 WHERE not p.schriftinhalt IS NULL … … 130 130 CREATE OR REPLACE VIEW S_ZUORDUNGSPFEIL_GEBAEUDE 131 131 AS 132 SELECT l. ogr_fid,133 l. ora_geometry132 SELECT l.OGR_FID, 133 l.ORA_GEOMETRY 134 134 FROM ap_lpo l 135 135 JOIN alkis_beziehungen v 136 ON l. gml_id= v.beziehung_von136 ON l.GL_ID = v.beziehung_von 137 137 JOIN ax_gebaeude g 138 ON v.beziehung_zu = g. gml_id138 ON v.beziehung_zu = g.GL_ID 139 139 WHERE l.art = 'Pfeil' 140 140 AND v.beziehungsart = 'dientZurDarstellungVon' … … 144 144 CREATE OR REPLACE VIEW SK2004_ZUORDNUNGSPFEIL 145 145 AS 146 SELECT ap. ogr_fid, ap.ora_geometry146 SELECT ap.OGR_FID, ap.ORA_GEOMETRY 147 147 FROM ap_lpo ap 148 148 WHERE ((ap.signaturnummer = '2004') 149 AND ('DKKM1000' ::text ~~ ANY ((ap.advstandardmodell)::text[])));149 AND ('DKKM1000' ~~ ANY ((ap.advstandardmodell)[]))); 150 150 COMMENT ON VIEW SK2004_ZUORDNUNGSPFEIL IS 'fuer Kartendarstellung: Zuordnungspfeil FlurstÃŒcksnummer"'; 151 151 CREATE OR REPLACE VIEW SK2004_ZUORDNUNGSPFEIL_SPITZE 152 152 AS 153 SELECT ap. ogr_fid, (((st_azimuth(st_pointn(ap.ora_geometry, 1),154 st_pointn(ap. ora_geometry, 2)) * (- (180)::double precision)) / pi()) + (90)::double precision) AS winkel,155 st_startpoint(ap. ora_geometry) AS wkb_geometry153 SELECT ap.OGR_FID, (((st_azimuth(st_pointn(ap.ORA_GEOMETRY, 1), 154 st_pointn(ap.ORA_GEOMETRY, 2)) * (- (180)::double precision)) / pi()) + (90)::double precision) AS WINKEL, 155 st_startpoint(ap.ORA_GEOMETRY) AS wkb_geometry 156 156 FROM ap_lpo ap 157 157 WHERE ((ap.signaturnummer = '2004') 158 AND ('DKKM1000' ::text ~~ ANY ((ap.advstandardmodell)::text[])));158 AND ('DKKM1000' ~~ ANY ((ap.advstandardmodell)[]))); 159 159 CREATE OR REPLACE VIEW SK2012_FLURGRENZE 160 160 AS 161 SELECT fg. ogr_fid, fg.ora_geometry161 SELECT fg.OGR_FID, fg.ORA_GEOMETRY 162 162 FROM ax_besondereflurstuecksgrenze fg 163 163 WHERE (3000 = ANY (fg.artderflurstuecksgrenze)) 164 AND fg.advstandardmodell ~~ 'DLKM' ::text;164 AND fg.advstandardmodell ~~ 'DLKM'; 165 165 COMMENT ON VIEW SK2012_FLURGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "Flurgrenze"'; 166 166 CREATE OR REPLACE VIEW SK2014_GEMARKUNGSGRENZE 167 167 AS 168 SELECT gemag. ogr_fid, gemag.ora_geometry168 SELECT gemag.OGR_FID, gemag.ORA_GEOMETRY 169 169 FROM ax_besondereflurstuecksgrenze gemag 170 170 WHERE (7003 = ANY (gemag.artderflurstuecksgrenze)) 171 AND gemag.advstandardmodell ~~ 'DLKM' ::text;171 AND gemag.advstandardmodell ~~ 'DLKM'; 172 172 COMMENT ON VIEW SK2014_GEMARKUNGSGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "Gemarkungsgrenze"'; 173 173 CREATE OR REPLACE VIEW SK2018_BUNDESLANDGRENZE 174 174 AS 175 SELECT blg. ogr_fid, blg.ora_geometry175 SELECT blg.OGR_FID, blg.ORA_GEOMETRY 176 176 FROM ax_besondereflurstuecksgrenze blg 177 177 WHERE (7102 = ANY (blg.artderflurstuecksgrenze)) 178 AND blg.advstandardmodell ~~ 'DLKM' ::text;179 COMMENT ON VIEW SK2018_BUNDESLANDGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "Bundes landgrenze"';178 AND blg.advstandardmodell ~~ 'DLKM'; 179 COMMENT ON VIEW SK2018_BUNDESLANDGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "BundesLANDgrenze"'; 180 180 CREATE OR REPLACE VIEW SK2020_REGIERUNGSBEZIRKSGRENZE 181 181 AS 182 SELECT rbg. ogr_fid, rbg.ora_geometry182 SELECT rbg.OGR_FID, rbg.ORA_GEOMETRY 183 183 FROM ax_besondereflurstuecksgrenze rbg 184 184 WHERE (7103 = ANY (rbg.artderflurstuecksgrenze)) 185 AND rbg.advstandardmodell ~~ 'DLKM' ::text;185 AND rbg.advstandardmodell ~~ 'DLKM'; 186 186 COMMENT ON VIEW SK2020_REGIERUNGSBEZIRKSGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "Regierungsbezirksgrenze"'; 187 187 CREATE OR REPLACE VIEW SK2022_GEMEINDEGRENZE 188 188 AS 189 SELECT gemg. ogr_fid, gemg.ora_geometry189 SELECT gemg.OGR_FID, gemg.ORA_GEOMETRY 190 190 FROM ax_besondereflurstuecksgrenze gemg 191 191 WHERE (7106 = ANY (gemg.artderflurstuecksgrenze)) 192 AND gemg.advstandardmodell ~~ 'DLKM' ::text;192 AND gemg.advstandardmodell ~~ 'DLKM'; 193 193 COMMENT ON VIEW SK2022_GEMEINDEGRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze "Gemeindegrenze"'; 194 194 CREATE OR REPLACE VIEW SK201X_POLITISCHE_GRENZE 195 195 AS 196 SELECT ogr_fid, artderflurstuecksgrenze as art, ora_geometry196 SELECT OGR_FID, artderflurstuecksgrenze as art, ORA_GEOMETRY 197 197 FROM ax_besondereflurstuecksgrenze 198 198 WHERE (7102 = ANY (artderflurstuecksgrenze) … … 202 202 OR 7106 = ANY (artderflurstuecksgrenze) 203 203 ) 204 AND advstandardmodell ~~ 'DLKM' ::text;205 COMMENT ON VIEW SK201X_POLITISCHE_GRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze Politische Grenzen (Bund, L and, Kreis, Gemeinde)';204 AND advstandardmodell ~~ 'DLKM'; 205 COMMENT ON VIEW SK201X_POLITISCHE_GRENZE IS 'fuer Kartendarstellung: besondere FlurstÃŒcksgrenze Politische Grenzen (Bund, LAND, Kreis, Gemeinde)'; 206 206 CREATE OR REPLACE VIEW FLSTNR_OHNE_POSITION 207 207 AS 208 SELECT f. gml_id,209 f.gemarkungsnummer || '-' || f.flurnummer || '-' || f.zaehler ::text || COALESCE ('/' || f.nenner::text, '') AS such208 SELECT f.GL_ID, 209 f.gemarkungsnummer || '-' || f.flurnummer || '-' || f.zaehler || COALESCE ('/' || f.nenner, '') AS SUCH 210 210 FROM ax_flurstueck f 211 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f. gml_id211 LEFT JOIN alkis_beziehungen v ON v.beziehung_zu = f.GL_ID 212 212 WHERE v.beziehungsart is NULL 213 213 AND f.endet IS NULL … … 216 216 CREATE OR REPLACE VIEW S_ALLGEMEINE_TEXTE 217 217 AS 218 SELECT p. ogr_fid,219 p. art,220 p. drehwinkel * 57.296 AS drehwinkel,221 p. schriftinhalt218 SELECT p.OGR_FID, 219 p.ART, 220 p.DREHWINKEL * 57.296 AS DREHWINKEL, 221 p.SCHRIFTINHALT 222 222 FROM ap_pto p 223 223 WHERE NOT p.art = 'ZAE_NEN' … … 233 233 CREATE OR REPLACE VIEW TEXTE_MIT_UMBRUCH 234 234 AS 235 SELECT ogr_fid, schriftinhalt, art235 SELECT OGR_FID, schriftinhalt, art 236 236 FROM ap_pto 237 237 WHERE not schriftinhalt is null … … 242 242 FROM s_allgemeine_texte; 243 243 CREATE OR REPLACE VIEW FLURSTUECKS_MINMAX AS 244 SELECT min(st_xmin( ora_geometry)) AS r_min,245 min(st_ymin( ora_geometry)) AS h_min,246 max(st_xmax( ora_geometry)) AS r_max,247 max(st_ymax( ora_geometry)) AS h_max244 SELECT min(st_xmin(ORA_GEOMETRY)) AS r_min, 245 min(st_ymin(ORA_GEOMETRY)) AS h_min, 246 max(st_xmax(ORA_GEOMETRY)) AS r_max, 247 max(st_ymax(ORA_GEOMETRY)) AS h_max 248 248 FROM ax_flurstueck f 249 249 WHERE f.endet IS NULL; … … 251 251 CREATE OR REPLACE VIEW BAURECHT 252 252 AS 253 SELECT r. ogr_fid,254 r. ora_geometry,255 r. gml_id,253 SELECT r.OGR_FID, 254 r.ORA_GEOMETRY, 255 r.GL_ID, 256 256 r.artderfestlegung as adfkey, 257 257 r."name", … … 264 264 ON r.artderfestlegung = a.wert 265 265 LEFT JOIN ax_dienststelle d 266 ON r. land = d.land266 ON r.LAND = d.LAND 267 267 AND r.stelle = d.stelle 268 268 WHERE r.endet IS NULL … … 271 271 CREATE OR REPLACE VIEW GEMARKUNG_IN_GEMEINDE 272 272 AS 273 SELECT DISTINCT land, regierungsbezirk, kreis, gemeinde, gemarkungsnummer273 SELECT DISTINCT LAND, regierungsbezirk, kreis, gemeinde, gemarkungsnummer 274 274 FROM ax_flurstueck 275 275 WHERE endet IS NULL 276 ORDER BY land, regierungsbezirk, kreis, gemeinde, gemarkungsnummer276 ORDER BY LAND, regierungsbezirk, kreis, gemeinde, gemarkungsnummer 277 277 ; 278 278 COMMENT ON VIEW GEMARKUNG_IN_GEMEINDE IS 'Welche Gemarkung liegt in welcher Gemeinde? Durch Verweise aus FlurstÃŒck.'; 279 279 CREATE OR REPLACE VIEW ARTEN_VON_FLURSTUECKSGEOMETRIE 280 280 AS 281 SELECT count( gml_id) as anzahl,282 st_geometrytype( ora_geometry)281 SELECT count(GL_ID) as anzahl, 282 st_geometrytype(ORA_GEOMETRY) 283 283 FROM ax_flurstueck 284 284 WHERE endet IS NULL 285 GROUP BY st_geometrytype( ora_geometry);285 GROUP BY st_geometrytype(ORA_GEOMETRY); 286 286 CREATE OR REPLACE VIEW ADRESSEN_HAUSNUMMERN 287 287 AS … … 289 289 s.bezeichnung AS strassenname, 290 290 g.bezeichnung AS gemeindename, 291 l. land,291 l.LAND, 292 292 l.regierungsbezirk, 293 293 l.kreis, … … 317 317 FROM ax_flurstueck f 318 318 JOIN alkis_beziehungen v 319 ON f. gml_id=v.beziehung_von319 ON f.GL_ID=v.beziehung_von 320 320 JOIN AX_LAGEBEZEICHNUNGMITHAUSNUMME l 321 ON l. gml_id=v.beziehung_zu321 ON l.GL_ID=v.beziehung_zu 322 322 JOIN ax_gemeinde g 323 323 ON l.kreis=g.kreis … … 343 343 f.nenner AS fs_nenner, 344 344 f.amtlicheflaeche AS flaeche, 345 f. ora_geometryAS geom,345 f.ORA_GEOMETRY AS geom, 346 346 b.bezeichnung AS bezirkname, 347 347 g.BUCHUNGSBLATTNUMMERMITBUCHSTAB AS gb_blatt, … … 352 352 p.nachnameoderfirma AS nachname 353 353 FROM ax_person p 354 JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p. gml_id355 JOIN ax_namensnummer n ON bpn.beziehung_von =n. gml_id356 JOIN alkis_beziehungen bng ON n. gml_id= bng.beziehung_von357 JOIN ax_buchungsblatt g ON bng.beziehung_zu = g. gml_id358 JOIN ax_buchungsblattbezirk b ON g. land = b.landAND g.bezirk = b.bezirk359 JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g. gml_id360 JOIN ax_buchungsstelle s ON s. gml_id= bgs.beziehung_von354 JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p.GL_ID 355 JOIN ax_namensnummer n ON bpn.beziehung_von =n.GL_ID 356 JOIN alkis_beziehungen bng ON n.GL_ID = bng.beziehung_von 357 JOIN ax_buchungsblatt g ON bng.beziehung_zu = g.GL_ID 358 JOIN ax_buchungsblattbezirk b ON g.LAND = b.LAND AND g.bezirk = b.bezirk 359 JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.GL_ID 360 JOIN ax_buchungsstelle s ON s.GL_ID = bgs.beziehung_von 361 361 JOIN ax_buchungsstelle_buchungsart art ON s.buchungsart = art.wert 362 JOIN alkis_beziehungen bsf ON bsf.beziehung_zu = s. gml_id363 JOIN ax_flurstueck f ON f. gml_id= bsf.beziehung_von364 JOIN ax_gemarkung k ON f. land = k.landAND f.gemarkungsnummer = k.gemarkungsnummer362 JOIN alkis_beziehungen bsf ON bsf.beziehung_zu = s.GL_ID 363 JOIN ax_flurstueck f ON f.GL_ID = bsf.beziehung_von 364 JOIN ax_gemarkung k ON f.LAND = k.LAND AND f.gemarkungsnummer = k.gemarkungsnummer 365 365 WHERE p.nachnameoderfirma LIKE 'Gemeinde %' 366 366 AND bpn.beziehungsart = 'benennt' … … 393 393 f.nenner AS fs_nenner, 394 394 f.amtlicheflaeche AS flaeche, 395 f. ora_geometryAS geom,395 f.ORA_GEOMETRY AS geom, 396 396 b.bezeichnung AS bezirkname, 397 397 g.BUCHUNGSBLATTNUMMERMITBUCHSTAB AS gb_blatt, … … 405 405 p.nachnameoderfirma AS nachname 406 406 FROM ax_person p 407 JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p. gml_id408 JOIN ax_namensnummer n ON bpn.beziehung_von =n. gml_id409 JOIN alkis_beziehungen bng ON n. gml_id= bng.beziehung_von410 JOIN ax_buchungsblatt g ON bng.beziehung_zu = g. gml_id411 JOIN ax_buchungsblattbezirk b ON g. land = b.landAND g.bezirk = b.bezirk412 JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g. gml_id413 JOIN ax_buchungsstelle sh ON sh. gml_id= bgs.beziehung_von407 JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p.GL_ID 408 JOIN ax_namensnummer n ON bpn.beziehung_von =n.GL_ID 409 JOIN alkis_beziehungen bng ON n.GL_ID = bng.beziehung_von 410 JOIN ax_buchungsblatt g ON bng.beziehung_zu = g.GL_ID 411 JOIN ax_buchungsblattbezirk b ON g.LAND = b.LAND AND g.bezirk = b.bezirk 412 JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.GL_ID 413 JOIN ax_buchungsstelle sh ON sh.GL_ID = bgs.beziehung_von 414 414 JOIN ax_buchungsstelle_buchungsart arth ON sh.buchungsart = arth.wert 415 JOIN alkis_beziehungen bss ON sh. gml_id= bss.beziehung_von416 JOIN ax_buchungsstelle sd ON sd. gml_id= bss.beziehung_zu415 JOIN alkis_beziehungen bss ON sh.GL_ID = bss.beziehung_von 416 JOIN ax_buchungsstelle sd ON sd.GL_ID = bss.beziehung_zu 417 417 JOIN ax_buchungsstelle_buchungsart artd ON sd.buchungsart = artd.wert 418 JOIN alkis_beziehungen bsf ON bsf.beziehung_zu = sd. gml_id419 JOIN ax_flurstueck f ON f. gml_id= bsf.beziehung_von420 JOIN ax_gemarkung k ON f. land = k.landAND f.gemarkungsnummer = k.gemarkungsnummer418 JOIN alkis_beziehungen bsf ON bsf.beziehung_zu = sd.GL_ID 419 JOIN ax_flurstueck f ON f.GL_ID = bsf.beziehung_von 420 JOIN ax_gemarkung k ON f.LAND = k.LAND AND f.gemarkungsnummer = k.gemarkungsnummer 421 421 WHERE p.nachnameoderfirma LIKE 'Stadt %' 422 422 AND bpn.beziehungsart = 'benennt' … … 447 447 FROM alkis_beziehungen AS bezalt 448 448 WHERE EXISTS 449 (SELECT ogr_fid449 (SELECT OGR_FID 450 450 FROM alkis_beziehungen AS bezneu 451 451 WHERE bezalt.beziehung_von = bezneu.beziehung_von 452 452 AND bezalt.beziehung_zu = bezneu.beziehung_zu 453 453 AND bezalt.beziehungsart = bezneu.beziehungsart 454 AND bezalt. ogr_fid< bezneu.ogc_fid454 AND bezalt.OGR_FID < bezneu.ogc_fid 455 455 ); 456 456 COMMENT ON VIEW BEZIEHUNGEN_REDUNDANT IS 'alkis_beziehungen zu denen es eine identische neue Version gibt.'; … … 460 460 FROM alkis_beziehungen AS bezalt 461 461 WHERE EXISTS 462 (SELECT ogr_fid462 (SELECT OGR_FID 463 463 FROM alkis_beziehungen AS bezneu 464 464 WHERE bezalt.beziehung_von = bezneu.beziehung_von 465 465 AND bezalt.beziehung_zu = bezneu.beziehung_zu 466 466 AND bezalt.beziehungsart = bezneu.beziehungsart 467 AND bezalt. ogr_fid< bezneu.ogc_fid467 AND bezalt.OGR_FID < bezneu.ogc_fid 468 468 ) 469 469 AND EXISTS 470 (SELECT ogr_fid470 (SELECT OGR_FID 471 471 FROM delete 472 472 WHERE bezalt.beziehung_von = substr(featureid, 1, 16)
Note: See TracChangeset
for help on using the changeset viewer.