annotate flys-backend/doc/schema/oracle-spatial_idx.sql @ 4380:19754e5227c8

Add facets for fixanalysis data from the datacage Add facets for fixanalysis data from the datacage to the bed difference height year, bed difference year and bed difference epoch output modes.
author Björn Ricks <bjoern.ricks@intevation.de>
date Fri, 02 Nov 2012 15:54:41 +0100
parents bb116a8d6e19
children eecd1ebba128
rev   line source
2864
bb116a8d6e19 Changed the geometry type of 'catchments' from polygon to multipolygon.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2365
diff changeset
1 CREATE INDEX catchment_spatial_idx ON catchment(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=multipolygon');
1254
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
2 CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point');
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
3 CREATE INDEX buildings_spatial_idx ON buildings(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
4 CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');
3d4eb1abe23e Added inital oracle-spatial_idx.sql script.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff changeset
5 CREATE INDEX river_axes_spatial_idx ON river_axes(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
6 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
7 CREATE INDEX hws_spatial_idx ON hws(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
8 CREATE INDEX floodplain_spatial_idx ON floodplain(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POLYGON');
2365
60532f75396b Adapted 'lines' relation and made lines queryable for a given river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 1254
diff changeset
9 CREATE INDEX lines_idx ON lines(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE');

http://dive4elements.wald.intevation.org