Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial_idx.sql @ 5322:81ad2c717b9c
SCHEMA CHANGE: added spatial index for river_axes in Oracle
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 15 Mar 2013 17:19:16 +0100 |
| parents | 66d9389c80cb |
| children | 807fa01b498b |
comparison
equal
deleted
inserted
replaced
| 5321:6dd354e7abfc | 5322:81ad2c717b9c |
|---|---|
| 8 | 8 |
| 9 -- TODO: index prevents `DELETE FROM rivers' on 11g | 9 -- TODO: index prevents `DELETE FROM rivers' on 11g |
| 10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" | 10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" |
| 11 -- CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); | 11 -- CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); |
| 12 | 12 |
| 13 -- TODO: index prevents importing on 11g. | 13 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); |
| 14 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" | |
| 15 -- CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); | |
| 16 | 14 |
| 17 -- TODO: index prevents importing on 11g. | 15 -- TODO: index prevents importing on 11g. |
| 18 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" | 16 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" |
| 19 -- CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); | 17 -- CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); |
| 20 | 18 |