Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-spatial_idx.sql @ 5324:807fa01b498b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SCHEMA CHANGE: added spatial indices in Oracle that work again
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Mar 2013 19:00:49 +0100
parents 81ad2c717b9c
children 7b35f2c070c3
comparison
equal deleted inserted replaced
5323:c7ce7c9e405e 5324:807fa01b498b
1 -- TODO: index prevents `DELETE FROM rivers' on 11g 1 -- TODO: index prevents `DELETE FROM rivers' on 11g
2 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 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'); 3 -- CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point');
4 4
5 -- TODO: index prevents importing on 11g. 5 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
6 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
7 -- CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
8 6
9 -- TODO: index prevents `DELETE FROM rivers' on 11g 7 -- TODO: index prevents `DELETE FROM rivers' on 11g
10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 8 -- 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'); 9 -- CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
12 10
13 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); 11 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
14 12
15 -- TODO: index prevents importing on 11g. 13 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
16 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
17 -- CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
18 14
19 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON'); 15 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON');
20 16
21 -- TODO: index prevents importing on 11g. 17 CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
22 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
23 -- CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
24 18
25 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); 19 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
26 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); 20 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
27 21
28 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); 22 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
http://dive4elements.wald.intevation.org