Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-spatial_idx.sql @ 5291:66d9389c80cb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added tables for jetties in spatial schema
author Tom Gottfried <tom@intevation.de>
date Thu, 14 Mar 2013 12:16:58 +0100
parents 8aac391871f9
children 81ad2c717b9c
comparison
equal deleted inserted replaced
5285:05eaecd2be42 5291:66d9389c80cb
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 -- TODO: index prevents importing on 11g.
14 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 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=LINE'); 15 -- CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
16 16
17 -- TODO: index prevents importing on 11g. 17 -- TODO: index prevents importing on 11g.
18 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 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'); 19 -- CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
20 20
24 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein" 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=MULTILINE'); 25 -- CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
26 26
27 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');
28 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE'); 28 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
29
29 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); 30 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
31
30 CREATE INDEX gauge_location_idx ON gauge_location(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); 32 CREATE INDEX gauge_location_idx ON gauge_location(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
31 CREATE INDEX hydr_boundaries_poly_idx ON hydr_boundaries_poly(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); 33 CREATE INDEX hydr_boundaries_poly_idx ON hydr_boundaries_poly(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
32 34
35 CREATE INDEX jetties_idx ON jetties(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
36
http://dive4elements.wald.intevation.org