Select index data as rows from ST_GEOMETRY spatial index?

Bud — Sat, 04 Jun 2022 18:55:54 GMT

Oracle
Feature classes that use ST_Geometry storage use a separate table to store information for the spatial index. The spatial index table is named S<n>_IDX$, where <n> is the geometry index value for the table. The geometry index value is stored in the SDE.ST_GEOMETRY_COLUMNS geodatabase system table. The spatial index table is created as an Oracle Indexed Organized Table (IOT). The spatial index on the ST_Geometry attribute appears as A<n>_IX1 when viewed through Oracle Enterprise Manager. The value of <n> represents the LAYER_ID value stored in the LAYERS geodatabase system table.
Spatial indexes and ST_Geometry

https://oracle-base.com/articles/8i/index-organized-tables

Does that bolded blurb in the docs mean it’s possible to select the index data as rows in a query from the ST_GEOMETRY stpatial index?

Like this:

select * from _;

spatial_index_data
----------------------
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
…

Background: Get map to use function-based spatial index (ST_GEOMETRY)

Thanks.

topic Select index data as rows from ST_GEOMETRY spatial index? in ArcGIS Enterprise Questions

Select index data as rows from ST_GEOMETRY spatial index?