Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial_idx.sql @ 5377:a5f5599f6fd5 2.9.14
merge
| author | Bettina Gruenbauer <bettina@intevation.de> |
|---|---|
| date | Fri, 22 Mar 2013 11:02:08 +0100 |
| parents | 7b35f2c070c3 |
| children | 8b29a94ebdd8 |
comparison
equal
deleted
inserted
replaced
| 5376:9b2482a3b9fe | 5377:a5f5599f6fd5 |
|---|---|
| 1 -- TODO: index prevents `DELETE FROM rivers' on 11g | 1 CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); |
| 2 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" | |
| 3 -- CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); | |
| 4 | 2 |
| 5 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); | 3 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
| 6 | 4 |
| 7 -- TODO: index prevents `DELETE FROM rivers' on 11g | 5 CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); |
| 8 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" | |
| 9 -- CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); | |
| 10 | 6 |
| 11 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); | 7 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); |
| 12 | 8 |
| 13 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); | 9 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
| 14 | 10 |