idea Live functions to calculate geometry like excel in ArcGIS Pro Ideas

Live functions to calculate geometry like excel

graharg_MAO — Thu, 26 May 2022 13:08:25 GMT

Can we make an attribute have a function for calculating geometry? Re-Calculating the Acres field after an edit can lead to data trust issues. Many people assume that editing the shape of a polygon will automatically update the added Acres field like the SHAPE_Length and SHAPE_Area fileds. Having the ability to add a live function to the definition of an attribute would decrease the error of forgetting to go back and re-calculate an Acres field.

I would love to hear how others have solved this issue with GDB design, Domains or workflows. I was hopeful that the Data Engineering tool would help but I am not seeing it.

The ability to have a column function has been part of Excel and should be available in ArcGIS PRO too.

Re: Live functions to calculate geometry like excel

jcarlson — Thu, 26 May 2022 13:14:17 GMT

This is simple enough with Attribute Rules. You can configure an attribute rule to update a field any time the feature is edited.

Re: Live functions to calculate geometry like excel - Status changed to: Already Offered

KoryKramer — Thu, 26 May 2022 13:23:31 GMT

As @jcarlson noted, this is possible through the use of Attribute Rules. Here is an example maintaining x, y, z Get to the Point: Automatically maintain x,y,z attribute values with ArcGIS Pro and attribute rules

The same concept can be applied to maintain an Acres field.

Re: Live functions to calculate geometry like excel

ScottFedak2085 — Thu, 26 May 2022 14:00:16 GMT

I will reiterate what @jcarlson and @KoryKramer said and add a little more. Set up an Attribute Rule on the field you'd like to store the data, set it to run when a feature is edited / updated, and use the following arcade expression (area given as example).

Area($feature, 'acres')

One note about Attribute Rules, they will prevent you from using the Feature Class they apply to in ArcMap, so if you have people who will edit the data in ArcMap, Attribute Rules may not be a viable option.

Re: Live functions to calculate geometry like excel

MErikReedAugusta — Fri, 20 Sep 2024 20:11:27 GMT

I stumbled upon this while looking for a solution for an auto-updating point feature class field that shows its X,Y,Z coordinates, similar to SHAPE_LENGTH & SHAPE_AREA for line & polygon feature classes.

I know this idea is two years old and a little niche, but I feel like Attribute Rules only partially solve the problem.

We are not currently able to deploy Attribute Rules, because a feature class with AR can't be opened in ArcMap. Not only do we still have some users that haven't made the switch, a number of our feature classes are tied to external legacy services that either don't yet support Pro GDBs or will require significant R&D time to make that switch.

My team has been ready & waiting to deploy ARs for over a year now. But our larger organization that manages our SDE is looking at something like a year or more still to go before we are allowed to deploy them because of those interlinked services.

Until a more significant percentage of the GIS world has made the full switch to supporting Pro, I think it's unrealistic to rely on a Pro-specific feature being the only option.

Re: Live functions to calculate geometry like excel

Bud — Tue, 24 Sep 2024 17:41:45 GMT

@graharg_MAO What kind of geodatabase? For example, Oracle 18c 10.7.1 enterprise geodatabase.