topic Re: Recalculate Extent in Python Questions

Recalculate Extent

gismoe — Thu, 07 Feb 2013 05:44:12 GMT

I want to recalculate the Extent of some feature classes. I found some vba, c# code but the job has to be done with python.
arcpy.Describe will show me the extent but there seems to by no way to set the extent.

Any ideas?

Re: Recalculate Extent

JakeSkinner — Sat, 11 Dec 2021 13:44:12 GMT

Hi Ernst,

Do your feature classes reside in a File/Personal Geodatabase, or an SDE Geodatabase? If they reside in an SDE geodatabase you can use the 'sdelayer -o alter' command to recalculate the extent. Ex:

import os
os.system("sdelayer -o alter -l parcels,shape -E calc -i sde:sqlserver:serverA -D GIS -u vector -p vector")

The '-E calc' option will recalculate the extent based on all the features. Or you can optionally specify it:

-E -75.17,39.88,-75.13,39.92

Re: Recalculate Extent

gismoe — Thu, 07 Feb 2013 11:04:36 GMT

Thank you. I will try this for me data in my ArcSDE.

But i have further data in File/Personal Geodatabases. Do you have code for this problem? i can't find any solution.

Re: Recalculate Extent

NeilAyres — Thu, 07 Feb 2013 12:11:03 GMT

I have noticed in the past, when using a feature class as a "template". ie Copy it, delete all the features out of it, when re-populate it with new stuff. The extent somehow still reflects the old stuff.
So, I would also love to know how to do this for F & P gdb's.
Cheers
Neil

Re: Recalculate Extent

gismoe — Fri, 08 Feb 2013 08:33:00 GMT

Ok, sdelayer -alter...... works pretty well. Thank you!

But now the next step is to recalculate the extent for feature classes in File/Personal Geodatabases.......

Re: Recalculate Extent

JakeSkinner — Fri, 08 Feb 2013 10:06:12 GMT

Hi Ernst,

At 10.1, there is a way to recalculate the extent through the properties of the feature class. In the Catalog window > right-click on the feature class > Properties > Feature Extent tab.

[ATTACH=CONFIG]21603[/ATTACH]

The only way I was able to find a way to do this using python is to execute the Feature Class to Feature Class tool. So, what you could do is execute the following tools:

arcpy.FeatureClassToFeatureClass_conversion
arcpy.Delete_management (delete the original feature class)
arcpy.Rename_management (rename the copied feature class to the original name)

Re: Recalculate Extent

gismoe — Sat, 11 Dec 2021 13:44:15 GMT

Hi Jake,

the way:

arcpy.FeatureClassToFeatureClass_conversion
arcpy.Delete_management (delete the original feature class)
arcpy.Rename_management (rename the copied feature class to the original name)

works pretty well.

I also tried

sdelayer -o alter -l parcels,shape -E calc -i sde:sqlserver:serverA -D GIS -u vector -p vector

on my sde data. I get the message "...successful" but when i load the data in ArcMap it seems that nothing happend to the extent. I will only see a small point that represents my whole data. So the extent is too big.

The data in the ArcSDE is versioned. May this cause a problem? Before i ran sdelayer i stopped all running services.

Re: Recalculate Extent

JakeSkinner — Tue, 12 Feb 2013 18:17:25 GMT

If the feature class is registered as versioned, you will need to reconcile the child versions and then perform a compress. If you are running ArcGIS for Desktop 10.1 you can make a connection as an administrator > right-click on the database connection > Administration > Administer Geodatabase > Reconcile Order tab. Right-click on each version > Reconcile. After each version is reconciled and no locks exist within the geodatabase, right-click on the database connection > Administration > Compress Geodatabase. After the geodatabase is compressed, you can execute the 'sdelayer -o alter' command and the extent will recalculate. You can also script the above using the Versioning toolset for the Data Management tools.

Re: Recalculate Extent

DianaUmpierre — Tue, 04 Jun 2013 00:33:13 GMT

JSkinn3;271206 wrote:
Hi Ernst,

At 10.1, there is a way to recalculate the extent through the properties of the feature class. In the Catalog window > right-click on the feature class > Properties > Feature Extent tab.

[ATTACH=CONFIG]21603[/ATTACH]
QUOTE]

I have 10.1 SP1, but recalculate using the Feature Extent tab did not work for me. It still recalcuated to incorrect extent, covering for areas than what is in my current feature class. In my case, the data resides in ArcSDE, but in a 9.3 SDE on Oracle. Only my client is ArcGIS Desktop 10.1. Is this a bug in 10.1 SP1? Has ESRI created a bug # for this issue?

Re: Recalculate Extent

FrédéricPRALLY — Thu, 14 Jan 2016 08:54:08 GMT

Hi Ernst,

You could also use this tool GP Update Extent FClass.

Hope this help you,

Fred

Re: Recalculate Extent

curtvprice — Tue, 12 Apr 2016 17:10:06 GMT

ArcGIS 10.4 has a new tool (this used to be the workstation command REBOX). It finally has made it to ArcGIS! It's funny how some things got left behind, and 15 years later we didn't know how much we missed it.

Recalculate Feature Class Extent—Help | ArcGIS for Desktop

If you have previous versions I found a workaround on Stack Exchange: Compress and uncompress the geodatabase.