| 86 | }}} |
| 87 | |
| 88 | * neue Tabelle für die Eigentümersuche |
| 89 | |
| 90 | {{{ |
| 91 | CREATE TABLE mb3_eigentuemer_suche_union AS |
| 92 | |
| 93 | SELECT |
| 94 | * FROM |
| 95 | |
| 96 | (SELECT |
| 97 | f.flurstueckskennzeichen, |
| 98 | f.flurnummer AS flur, |
| 99 | f.zaehler AS fs_zaehler, |
| 100 | f.nenner AS fs_nenner, |
| 101 | f.amtlicheflaeche AS flaeche, |
| 102 | f.wkb_geometry AS geom, |
| 103 | |
| 104 | b.bezeichnung AS bezirkname, |
| 105 | g.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt, |
| 106 | g.blattart, |
| 107 | s.laufendenummer AS bvnr, |
| 108 | art.bezeichner AS buchgsart, |
| 109 | n.laufendenummernachdin1421 AS name_num, |
| 110 | p.nachnameoderfirma AS nachname, |
| 111 | p.vorname |
| 112 | FROM ax_person p |
| 113 | JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p.gml_id |
| 114 | JOIN ax_namensnummer n ON bpn.beziehung_von = n.gml_id |
| 115 | JOIN alkis_beziehungen bng ON n.gml_id = bng.beziehung_von |
| 116 | JOIN ax_buchungsblatt g ON bng.beziehung_zu = g.gml_id |
| 117 | JOIN ax_buchungsblattbezirk b ON g.land = b.land AND g.bezirk = b.bezirk |
| 118 | JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.gml_id |
| 119 | JOIN ax_buchungsstelle s ON s.gml_id = bgs.beziehung_von |
| 120 | JOIN ax_buchungsstelle_buchungsart art ON s.buchungsart = art.wert |
| 121 | |
| 122 | JOIN alkis_beziehungen bf ON s.gml_id = bf.beziehung_zu |
| 123 | JOIN ax_flurstueck f ON f.gml_id = bf.beziehung_von |
| 124 | |
| 125 | UNION |
| 126 | |
| 127 | SELECT |
| 128 | f.flurstueckskennzeichen, |
| 129 | f.flurnummer AS flur, |
| 130 | f.zaehler AS fs_zaehler, |
| 131 | f.nenner AS fs_nenner, |
| 132 | f.amtlicheflaeche AS flaeche, |
| 133 | f.wkb_geometry AS geom, |
| 134 | |
| 135 | b.bezeichnung AS bezirkname, |
| 136 | g.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt, |
| 137 | g.blattart, |
| 138 | s.laufendenummer AS bvnr, |
| 139 | art.bezeichner AS buchgsart, |
| 140 | n.laufendenummernachdin1421 AS name_num, |
| 141 | p.nachnameoderfirma AS nachname, |
| 142 | p.vorname FROM ax_person p |
| 143 | JOIN alkis_beziehungen bpn ON bpn.beziehung_zu = p.gml_id |
| 144 | JOIN ax_namensnummer n ON bpn.beziehung_von = n.gml_id |
| 145 | JOIN alkis_beziehungen bng ON n.gml_id = bng.beziehung_von |
| 146 | JOIN ax_buchungsblatt g ON bng.beziehung_zu = g.gml_id |
| 147 | JOIN ax_buchungsblattbezirk b ON g.land = b.land AND g.bezirk = b.bezirk |
| 148 | JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.gml_id |
| 149 | JOIN ax_buchungsstelle s ON s.gml_id = bgs.beziehung_von |
| 150 | JOIN ax_buchungsstelle_buchungsart art ON s.buchungsart = art.wert |
| 151 | |
| 152 | |
| 153 | JOIN alkis_beziehungen bg ON s.gml_id = bg.beziehung_von |
| 154 | JOIN ax_buchungsstelle bs ON bs.gml_id = bg.beziehung_zu |
| 155 | |
| 156 | JOIN alkis_beziehungen bf ON bs.gml_id = bf.beziehung_zu |
| 157 | |
| 158 | JOIN ax_flurstueck f ON f.gml_id = bf.beziehung_von) AS foo |
| 159 | |