Select to view content in your preferred language

Select index data as rows from ST_GEOMETRY spatial index?

420
0
06-04-2022 11:55 AM
Bud
by
Esteemed Contributor

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.

 

0 Kudos
0 Replies