Ok, the data extent is
Top: 78.929747 dd
Right: 33.634100 dd
Bottom: 24.163067 dd
Left: 31.133161 dd
Initially we created the layer with the default commands New>FeatureClass>etc., granded privileges and registered it as versioned.
The layers are quite dynamic, meaning that there are (daily) attribute changes and/or geometry adds/deletions.
And not all layers are affected...others work pretty well.
No, there are no common properties. Different areas, different geometries, etc.
Not sure what you mean with 'rowid'...we have the default OBJECTID without any negative values.
These are the reports for the layers with and without spatial index:
1) result for the layer that�??s spatial index has been removed, and that now denies editing (even for the owner VFR)
Layer Description ....: <None>
Table Owner ..........: VFR
Table Name ...........: GEOC_AVI_RWYL_COPY
Spatial Column .......: SHAPE
Layer Id .............: 1338
SRID .................: 8
Auth SRID.............: 7
Minimum Shape Id .....: 1
Offset ...............:
falsex: -400.000000
falsey: -400.000000
System Units .........: 1000000000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.000000008983
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=0.034,FULL
exist: No
array form: 0.034,0,0
Layer Envelope .......:
minx: -31.13316, miny: 24.16307
maxx: 33.63410, maxy: 78.92975
Entities .............: nslc+
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: 05/15/13 09:38:09
I/O Mode .............: LOAD
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
Layer Configuration ..: DEFAULTS
2) result for the layer that does not display properly (not all features) and that has a spatial index.
Layer Description ....: <None>
Table Owner ..........: VFR
Table Name ...........: GEOC_AVI_RWYL
Spatial Column .......: SHAPE
Layer Id .............: 1205
SRID .................: 8
Auth SRID.............: 7
Minimum Shape Id .....: 1
Offset ...............:
falsex: -400.000000
falsey: -400.000000
System Units .........: 1000000000.000000
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.000000008983
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=0.034,FULL
exist: Yes
array form: 0.034,0,0
Layer Envelope .......:
minx: -31.13316, miny: 24.16307
maxx: 33.63410, maxy: 78.92975
Entities .............: nslc+
Layer Type ...........: Extended SQL Type/ST_GEOMETRY
Creation Date ........: 01/22/13 15:04:40
I/O Mode .............: NORMAL
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]
Layer Configuration ..: DEFAULTS