Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-spatial_idx.sql @ 5109:357938c64967 dami

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added TODOs to spatial indeces that prevent from importing into Oracle 11g
author Tom Gottfried <tom@intevation.de>
date Wed, 27 Feb 2013 11:17:42 +0100
parents 57a845da72bd
children 3003c45f8a00
rev   line source
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
1 CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point');
5109
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
2
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
3 -- TODO: index prevents importing on 11g.
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
4 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
5 CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
5109
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
6
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
7 CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
5109
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
8
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
9 -- TODO: index prevents importing on 11g.
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
11 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
5109
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
12
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
13 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
14 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON');
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
15 CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
16 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
17 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
18 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
19 CREATE INDEX gauge_location_idx ON gauge_location(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
20 CREATE INDEX hydr_boundaries_poly_idx ON hydr_boundaries_poly(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
5013
eecd1ebba128 SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines')
Tom Gottfried <tom.gottfried@intevation.de>
parents: 2864
diff changeset
21
http://dive4elements.wald.intevation.org