2

ArcGIS 10.3.1

ArcSDE 10.2.2

SQL Server 2012

I'm reading documentation on how to Rebuild a spatial index. Will rebuilding the spatial index automatically recalculate the feature extent of the feature class?

5
  • 1
    I doubt it. Please edit the question to specify the data source (FGDB, enterprise GDB,..., and if enterprise which exact database product), since that may make a difference.
    – Vince
    Jul 20, 2016 at 19:52
  • "Exact database product" would include the version.
    – Vince
    Jul 20, 2016 at 20:09
  • Have you tried removing some features at the edge of a map (e.g., HI and AK from a US dataset), and rebuilding the index? Testing this is the only way to be sure.
    – Vince
    Jul 20, 2016 at 20:21
  • @Vince I've tested some. The dataset is very large, 2.5 million records, and I would not want to create any locks since it's actively being used. I did run the Check Geometry tool - this returned a few hundred problem records (all self intersecting issues). However, I checked all of these and they were not even close to the edges of the feature extent. But before running spatial index test (and possibly creating locks while actively being used), I wanted to know if the feature extent will automatically recalculate, as a quick work around until the bad data is located.
    – a1234
    Jul 20, 2016 at 20:54
  • 2
    There's no reason to run this test on a production layer. All you need is the generalized US states from Data & Maps. Insert all, get envelope, delete two, reindex, get envelope. Check Geometry result is outside the scope of the question.
    – Vince
    Jul 20, 2016 at 21:02

1 Answer 1

3

From your link Rebuild a spatial index:

Recalculate the spatial index and feature class extent on a Geometry feature class in a database or geodatabase in Microsoft SQL Server.

This appears to be the case only on SQL Server databases, but as that's what you're using then it appears that the answer to your question is "Yes".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.