Changeset 281 for trunk/import/sichten_ORACLE.sql
- Timestamp:
- 04/30/13 15:10:57 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/import/sichten_ORACLE.sql
r277 r281 296 296 SELECT DISTINCT art 297 297 FROM s_allgemeine_texte; 298 CREATE OR REPLACE VIEW FLURSTUECKS_MINMAX AS 299 SELECT min(st_xmin(ORA_GEOMETRY)) AS r_min, 300 min(st_ymin(ORA_GEOMETRY)) AS h_min, 301 max(st_xmax(ORA_GEOMETRY)) AS r_max, 302 max(st_ymax(ORA_GEOMETRY)) AS h_max 303 FROM ax_flurstueck f 304 WHERE f.endet IS NULL; 298 299 -- ToDo: 300 --CREATE OR REPLACE VIEW FLURSTUECKS_MINMAX AS 301 -- SELECT min(st_xmin(ORA_GEOMETRY)) AS r_min, 302 -- min(st_ymin(ORA_GEOMETRY)) AS h_min, 303 -- max(st_xmax(ORA_GEOMETRY)) AS r_max, 304 -- max(st_ymax(ORA_GEOMETRY)) AS h_max 305 -- FROM ax_flurstueck f 306 -- WHERE f.endet IS NULL; 305 307 -- COMMENT ON VIEW FLURSTUECKS_MINMAX IS 'Maximale Ausdehnung von ax_flurstueck fuer EXTENT-Angabe im Mapfile'; 306 308 … … 509 511 AS 510 512 SELECT * 511 FROM alkis_beziehungen ASbezalt513 FROM alkis_beziehungen bezalt 512 514 WHERE EXISTS 513 515 (SELECT OGR_FID 514 FROM alkis_beziehungen ASbezneu516 FROM alkis_beziehungen bezneu 515 517 WHERE bezalt.beziehung_von = bezneu.beziehung_von 516 518 AND bezalt.beziehung_zu = bezneu.beziehung_zu … … 528 530 -- WHERE EXISTS 529 531 -- (SELECT OGR_FID 530 -- FROM alkis_beziehungen ASbezneu532 -- FROM alkis_beziehungen bezneu 531 533 -- WHERE bezalt.beziehung_von = bezneu.beziehung_von 532 534 -- AND bezalt.beziehung_zu = bezneu.beziehung_zu
Note: See TracChangeset
for help on using the changeset viewer.