Last updated on FEBRUARY 27, 2014

Applies to:

Goal

 Oracle Locator does not support the use of 3D indexes however you can still use your 3D data if you use one of the following methods:

1) If the geometry is not true 3D data, the Y axis is NULL or 0, then you can convert the geometry to 2D using the following method

- drop the spatial index
- update the geometries:
update my_table set my_geom = sdo_cs.make_2d(my_geom);
- update the metadata by removing the Z dimension
- re-create the spatial index.

2) If the geometry is true 3D, then you can still perform Locator functions as long as you perform them on the 2D representation

select sdo_geom.sdo_area (sdo_cs.make_2d(my_geom), 0.05) from my_table where …

3) You can create a 2D index on the 3D data

create index my_sdo_index on my_table(my_geom) indextype is mdsys.spatial_index parameters ('... sdo_indx_dims = 2 ...');

Solution