Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-spatial_idx.sql @ 5114:3003c45f8a00 dami

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
spatial indices not working on Oracle 11g commented out, added TODOs
author Tom Gottfried <tom@intevation.de>
date Wed, 27 Feb 2013 12:55:38 +0100
parents 357938c64967
children 04eb62eae722
comparison
equal deleted inserted replaced
5113:5c07ec3e9e25 5114:3003c45f8a00
1 CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); 1 -- TODO: index prevents `DELETE FROM rivers' on 11g
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');
2 4
3 -- TODO: index prevents importing on 11g. 5 -- TODO: index prevents importing on 11g.
4 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 6 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
5 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); 7 -- CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
6 8
7 CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); 9 -- TODO: index prevents `DELETE FROM rivers' on 11g
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');
8 12
9 -- TODO: index prevents importing on 11g. 13 -- TODO: index prevents importing on 11g.
10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 14 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
11 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); 15 -- CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
12 16
13 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); 17 -- TODO: index prevents importing on 11g.
18 -- 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');
20
14 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON'); 21 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON');
15 CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); 22
23 -- TODO: index prevents importing on 11g.
24 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
25 -- CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
26
16 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); 27 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
17 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); 28 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
18 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); 29 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
19 CREATE INDEX gauge_location_idx ON gauge_location(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); 30 CREATE INDEX gauge_location_idx ON gauge_location(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
20 CREATE INDEX hydr_boundaries_poly_idx ON hydr_boundaries_poly(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); 31 CREATE INDEX hydr_boundaries_poly_idx ON hydr_boundaries_poly(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
http://dive4elements.wald.intevation.org