Mercurial > dive4elements > river
annotate backend/doc/schema/oracle-spatial_idx.sql @ 6152:0587819960c3
Waterlevel differences & bed height differences: Add new model LinearInterpolated intented to unify the two very similiar calculations. The focus of the current implementation is correctness and not speed! The fact that the data sets more mostly sorted by station is not exploited. Doing so would improve performance significantly.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Sun, 02 Jun 2013 17:52:53 +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'); |