topic Re: arcpy desc hasSpatialindex in Python Snippets Questions

arcpy desc hasSpatialindex

venaktesa_kumarNatarajan — Thu, 18 Jul 2019 07:44:27 GMT

Hi,

I run python script using following code

desc = arcpy.Describe(fc)
sindex = str(desc.hasSpatialIndex)
stype = desc.featureType
print str(fc)+ "--"+sindex + "--"+stype

it returns the feature class name and type correctly. but it doesnt return the correct value for hasSpatialIndex.

It returns the values as true when the ArcCatelog show that the layer doesnt have spatial index.

any idea

Re: arcpy desc hasSpatialindex

DanPatterson_Retired — Thu, 18 Jul 2019 09:02:09 GMT

Was catalog refreshed when you checked?

Did you try to delete the spatial index? You will get an error if the spatial index doesn't exist which would confirm that it doesn't exist.

Re: arcpy desc hasSpatialindex

venaktesa_kumarNatarajan — Thu, 18 Jul 2019 12:33:30 GMT

Hi,

I refreshed the catalog but still the same result.

Actually we migrated SDE database from Oracle 11g to Oracle 12c Exadata. it was migrated using data dump process. During the migration, we got error randomly that spatial index exist for some layers.

After the migration, we found that many layers missing their spatial index using the Arccatalog.

I used the above script to get the list instead of viewing each layer in Arccatalog. unfortunately the script provided wrong results.

Also, in Arccatalog, the spatial index buttons (add,delete, rebuild) options are not enabled even though it displays the message that the layer has no spatial index.

Re: arcpy desc hasSpatialindex

TomasPokorny — Thu, 14 Jan 2021 12:20:39 GMT

got the same issue with ArcGIS Desktop 10.6.1, ArcSDE 10.6.1 on Oracle11g