spatial index grid size for empty table

deleted-user-y3Dh51Ea5xkh — Tue, 02 Jun 2015 15:07:22 GMT

I'm trying to write the SQL to create a feature class and spatial index in an Oracle SDE geodatabase using ST_Geometry. This is how I'm making the table:

CREATE TABLE STREETS (ID NUMBER(11) NOT NULL PRIMARY KEY, SEG_ID NUMBER(11) NOT NULL, SHAPE SDE.ST_GEOMETRY NULL)

Next I need to make the index which will look something like:

CREATE INDEX STREETS_IDX ON STREETS(SHAPE) INDEXTYPE IS sde.st_spatial_index PARAMETERS('st_grids=0 st_srid=4326')

The problem is I'm not sure what would be an appropriate grid size. I found this article which suggested using "one grid level with a cell size three times the average feature extent size", but the table is empty so I don't see how I would calculate that. Secondly, the spatial reference is WGS84 so what units would I be passing in? Degrees?

Re: spatial index grid size for empty table

VinceAngelo — Tue, 02 Jun 2015 16:21:03 GMT

This question has already been answered over in GIS.StackExchange.

topic spatial index grid size for empty table in Data Management Questions

spatial index grid size for empty table

Re: spatial index grid size for empty table