topic Find ST_GRIDS using query Oracle 19c in Geodatabase Questions

Find ST_GRIDS using query Oracle 19c

yockee — Tue, 29 Nov 2022 04:50:48 GMT

Hi,

I need to rebuild my spatial indexes using query. This is the query that I am expecting to run :

CREATE INDEX SDE.A280_IX1
ON BANGKAIKAPAL_PT_1K(SHAPE)
INDEXTYPE IS sde.st_spatial_index
PARAMETERS('st_grids=1,3,0 st_srid=32748 tablespace NEW_TBS');

I need to find st_grids value using query. How can I do that ? I have been searching the web and can not find anything.

What I want is something similar in finding SRID : "SELECT sde.st_srid (SHAPE) sridcol FROM SDE.STREET;"

Thankyou

Re: Find ST_GRIDS using query Oracle 19c

FrédéricPRALLY — Tue, 29 Nov 2022 14:48:39 GMT

Hi Yockee,

From ArcCatalog you can use this tool Calculate Default Spatial Grid Index or refer to this article Guidelines for choosing a spatial index grid size

Hope this help you,

Best regards

Re: Find ST_GRIDS using query Oracle 19c

sorpigal — Wed, 15 May 2024 21:20:30 GMT

A bit late, but this is how you can find a existing st_grids value from an existing spatial index:

select sgi.grid.grid1 || ‘,’ || sgi. grid.grid2 || ‘,’ || sgi. grid.grid3 as grid from sde.st_geometry_index sgi where owner = ‘SDE’ and table_name = ‘STREET’;