Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-spatial_idx.sql @ 5252:f8efe733dc24

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove outdated config files. Those are now taken directly from the sources
author Andre Heinecke <aheinecke@intevation.de>
date Tue, 12 Mar 2013 16:53:20 +0100
parents 8aac391871f9
children 66d9389c80cb
rev   line source
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
1 -- TODO: index prevents `DELETE FROM rivers' on 11g
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
2 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
3 -- 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
4
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
5 -- 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
6 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
7 -- 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
8
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
9 -- TODO: index prevents `DELETE FROM rivers' on 11g
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
10 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
11 -- 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
12
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
13 -- 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
14 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
15 -- 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
16
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
17 -- TODO: index prevents importing on 11g.
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
18 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
19 -- CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
20
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
21 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON');
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
22
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
23 -- TODO: index prevents importing on 11g.
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
24 -- Error: "Ebenendimensionalitat stimmt nicht mit Geometrie-Dimensionen uberein"
5182
8aac391871f9 SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
Andre Heinecke <aheinecke@intevation.de>
parents: 5137
diff changeset
25 -- CREATE INDEX hydr_boundaries_idx ON hydr_boundaries(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
26
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
27 CREATE INDEX hws_points_spatial_idx ON hws_points(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
5137
04eb62eae722 River Axes and HWS_lines are now multiline
Andre Heinecke <aheinecke@intevation.de>
parents: 5114
diff changeset
28 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
29 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
30 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
31 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
32
http://dive4elements.wald.intevation.org