Ask A Cartographer

auto calculate acreage

March 16 2010 | 2 comments
Categories: Map Data

Hello,

I was wondering if it is possible to either change the units of the Shape_Area field in a feature class to acres so that it is always automatically updated with the correct acreage or somehow create an acreage field and have it auto recalculate itself based on the Shape_Area field.

Thanks!

Mapping Center Answer:

There is no way to do this out of the box.  I did find the following on the ArcGIS Desktop Discussion Forum - it is a custom button to calculate acreage (note that I have not tried this out myself): http://forums.esri.com/Thread.asp?c=93&f=992&t=271615

You can search for other related resources on the ESRI Support Site.

If you only need to do this once, add a new field in the attribute table and calculate the new acreage value.  Here is the VBA code to use (check the "Advanced" option in the Field Calculator dialog - the first four lines go in the Pre-Logic VBA Script Code area and the last line goes in the bottom one - I assume here that you will call the new field "Acres"):

Dim dblArea as double
Dim pArea as IArea
Set pArea = [shape]
dblArea = pArea.area

Acres=
dblArea*0.000247104369225325 

If you anticipate having to repeat this process a number of times, you could also create a very simple model that will do this.  It would contain the tools for adding a field and then calculating the field value. If you already have the acreage field in the attribute table adn you jsut want to update it, then you can add a first step that deletes the existing field before it adds the new field and calculates the values. 

Alternatively, you could write a Python script to do the same, but in the script it could check for the existence of the existing field before deleting it.

Here's a tip: you can use the model template we recently posted on Mapping Center to start making your model -- this will save you even more time!

For more help with models and scripts, visit the Geoprocessing Resource Center.

Auto Calculate Acres Tool posted by Matthew Syvertson on Feb 17 2011 2:08PM
I have installed GIS Workshop's Assessor Toolbar and it has a checkbox in the toolbar that when checked, will auto populate the Acres field with the new acreage. This is not the reason I installed the toolbar, but a pleasant bonus. So, it is possible to do this with other units/fields I am sure.
Thanks for the tip! posted by Aileen Buckley on Feb 19 2011 9:22AM
Matthew:

Thanks for the tip -- this is a great tool to know about! Glad you shared your discovery!

If you would like to post a comment, please login.

Contact Us | Legal | Privacy |