Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-spatial_idx.sql @ 5348:4b1d8f367428

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove commented code that could be copied from below. Fix indentention of hws check
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 20 Mar 2013 16:35:47 +0100
parents 807fa01b498b
children 7b35f2c070c3
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
5324
807fa01b498b SCHEMA CHANGE: added spatial indices in Oracle that work again
Tom Gottfried <tom@intevation.de>
parents: 5322
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
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
7 -- 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
8 -- 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
9 -- 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
10
5322
81ad2c717b9c SCHEMA CHANGE: added spatial index for river_axes in Oracle
Tom Gottfried <tom@intevation.de>
parents: 5291
diff changeset
11 CREATE INDEX river_axes_spatial_idx ON river_axes(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
5109
357938c64967 added TODOs to spatial indeces that prevent from importing into Oracle 11g
Tom Gottfried <tom@intevation.de>
parents: 5038
diff changeset
12
5324
807fa01b498b SCHEMA CHANGE: added spatial indices in Oracle that work again
Tom Gottfried <tom@intevation.de>
parents: 5322
diff changeset
13 CREATE INDEX CrossSectionTracks_spatial_idx ON cross_section_tracks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');
5114
3003c45f8a00 spatial indices not working on Oracle 11g commented out, added TODOs
Tom Gottfried <tom@intevation.de>
parents: 5109
diff changeset
14
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
15 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
16
5324
807fa01b498b SCHEMA CHANGE: added spatial indices in Oracle that work again
Tom Gottfried <tom@intevation.de>
parents: 5322
diff changeset
17 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
18
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
19 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
20 CREATE INDEX hws_lines_spatial_idx ON hws_lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTILINE');
5291
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
21
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
22 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON');
5291
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
23
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
24 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
25 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
26
5291
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
27 CREATE INDEX jetties_idx ON jetties(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
28
http://dive4elements.wald.intevation.org