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?