Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-spatial_idx.sql @ 6061:e9a76ffa0f9a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use maxOverlap to get the correct gauge for the MainValues Previously just the first matching gauge was taken even if it's range ended with the minimum value. This code is clearly intended to get one gauge for one range so the best match should be taken.
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 22 May 2013 18:10:48 +0200
parents 5aa05a7a34b7
children cc53aae06303
rev   line source
5363
7b35f2c070c3 re-added spatial indices for Oracle that work since importer forces correct dimensions
Tom Gottfried <tom@intevation.de>
parents: 5324
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
5324
807fa01b498b SCHEMA CHANGE: added spatial indices in Oracle that work again
Tom Gottfried <tom@intevation.de>
parents: 5322
diff changeset
3 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
4
5363
7b35f2c070c3 re-added spatial indices for Oracle that work since importer forces correct dimensions
Tom Gottfried <tom@intevation.de>
parents: 5324
diff changeset
5 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
6
5322
81ad2c717b9c SCHEMA CHANGE: added spatial index for river_axes in Oracle
Tom Gottfried <tom@intevation.de>
parents: 5291
diff changeset
7 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
8
5324
807fa01b498b SCHEMA CHANGE: added spatial indices in Oracle that work again
Tom Gottfried <tom@intevation.de>
parents: 5322
diff changeset
9 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
10
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
11 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
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 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
14
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 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
16 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
17
5038
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');
5291
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
19
5038
57a845da72bd Fix some oracle syntax problems and move indicies to _idx.sql
Andre Heinecke <aheinecke@intevation.de>
parents: 5028
diff changeset
20 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
21 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
22
5291
66d9389c80cb added tables for jetties in spatial schema
Tom Gottfried <tom@intevation.de>
parents: 5182
diff changeset
23 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
24
5409
8b29a94ebdd8 SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Tom Gottfried <tom@intevation.de>
parents: 5363
diff changeset
25 CREATE INDEX flood_marks_idx ON flood_marks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
http://dive4elements.wald.intevation.org