| 162 | * View Grundbuchsuche |
| 163 | |
| 164 | {{{ |
| 165 | |
| 166 | |
| 167 | |
| 168 | -- DROP VIEW qry_mb3_grundbuch_suche; |
| 169 | |
| 170 | CREATE OR REPLACE VIEW qry_mb3_grundbuch_suche AS |
| 171 | SELECT foo.buchungsart, |
| 172 | foo.bezirkname, |
| 173 | foo.bezirk, |
| 174 | foo.gb_blatt, |
| 175 | foo.blattart, |
| 176 | foo.flurstueckskennzeichen, |
| 177 | foo.geom, |
| 178 | foo.endet |
| 179 | FROM ( SELECT s.buchungsart, |
| 180 | b.bezeichnung AS bezirkname, |
| 181 | b.bezirk, |
| 182 | g.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt, |
| 183 | g.blattart, |
| 184 | f.flurstueckskennzeichen, |
| 185 | f.wkb_geometry AS geom, |
| 186 | f.endet |
| 187 | FROM ax_buchungsblatt g |
| 188 | JOIN ax_buchungsblattbezirk b ON g.land::text = b.land::text AND g.bezirk::text = b.bezirk::text |
| 189 | JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.gml_id |
| 190 | JOIN ax_buchungsstelle s ON s.gml_id = bgs.beziehung_von |
| 191 | JOIN ax_buchungsstelle_buchungsart art ON s.buchungsart = art.wert |
| 192 | JOIN alkis_beziehungen bf ON s.gml_id = bf.beziehung_zu |
| 193 | JOIN ax_flurstueck f ON f.gml_id = bf.beziehung_von |
| 194 | WHERE g.endet IS NULL AND b.endet IS NULL AND s.endet IS NULL AND f.endet IS NULL |
| 195 | UNION |
| 196 | SELECT s.buchungsart, |
| 197 | b.bezeichnung AS bezirkname, |
| 198 | b.bezirk, |
| 199 | g.buchungsblattnummermitbuchstabenerweiterung AS gb_blatt, |
| 200 | g.blattart, |
| 201 | f.flurstueckskennzeichen, |
| 202 | f.wkb_geometry AS geom, |
| 203 | f.endet |
| 204 | FROM ax_buchungsblatt g |
| 205 | JOIN ax_buchungsblattbezirk b ON g.land::text = b.land::text AND g.bezirk::text = b.bezirk::text |
| 206 | JOIN alkis_beziehungen bgs ON bgs.beziehung_zu = g.gml_id |
| 207 | JOIN ax_buchungsstelle s ON s.gml_id = bgs.beziehung_von |
| 208 | JOIN ax_buchungsstelle_buchungsart art ON s.buchungsart = art.wert |
| 209 | JOIN alkis_beziehungen bg ON s.gml_id = bg.beziehung_von |
| 210 | JOIN ax_buchungsstelle bs ON bs.gml_id = bg.beziehung_zu |
| 211 | JOIN alkis_beziehungen bf ON bs.gml_id = bf.beziehung_zu |
| 212 | JOIN ax_flurstueck f ON f.gml_id = bf.beziehung_von |
| 213 | WHERE g.endet IS NULL AND s.endet IS NULL AND b.endet IS NULL AND s.endet IS NULL AND f.endet IS NULL) foo; |
| 214 | |
| 215 | |
| 216 | }}} |
| 217 | |