idea Allow updating geometry in Field Calculator in ArcGIS Pro Ideas

Allow updating geometry in Field Calculator

GreggRoemhildt1 — Wed, 02 Mar 2022 23:45:54 GMT

Lets say I have two feature class,

- Points A. All the points have a unique point_id.

- Points B, these points have an ID that matches the point_id in the Points A class.

I can join these two tables using the point_id.

Now I would like to update the geometry of the points A feature class with the geometry with points B. This would be trivial in an SQL server...It would be very useful in ArcGIS file geodatabases.

    UPDATE Point_A a
    INNER JOIN Point_B
    ON a.point_id=b.point_id
    SET A.geom=B.geom;

Perhaps this could apply to any type of geometry also.

Re: Allow updating geometry in Field Calculator

AnthonyClark3 — Wed, 27 Jul 2016 23:16:39 GMT

This be done using Python. You can do an arcpy.da.UpdateCursor (point a) and store the point_id as a variable. Then nest an arcpy.da.SearchCursor on the second feature class (point b), with an if statement.

If point_id1 == point_id2:

geometery1 = geometry2

Here's the link to UpdateCursor. And note, "Geometry properties can be accessed by specifying the token SHAPE@ in the list of fields."

UpdateCursor—Help | ArcGIS for Desktop

Re: Allow updating geometry in Field Calculator - Status changed to: Closed

DrewFlater — Tue, 03 Jan 2023 18:25:08 GMT

The workflow described can be accomplished starting in Pro 3.1, but not using the Calculate Field tool. The Append tool has a new geometry update mode and parameters to configure how the update should be made. This was covered in this newer Idea: https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-batch-replace-geometries-from-one-fc-to/idi-p/1139522

Re: Allow updating geometry in Field Calculator

Bud — Sun, 09 Apr 2023 20:17:01 GMT

Re: Allow updating geometry in Field Calculator

Bud — Sun, 09 Apr 2023 20:31:14 GMT

Just to clarify:

This idea is called "Allow updating geometry in Field Calculator". But I wonder if that title is misleading. At first glance, that title makes it sound like it's not possible to update a FC's geometry using the Field Calculator. But we can update the geometry of FC using the field calculator:

That works as expected.

What we can't do is update a FC's geometry using the geometry from a different FC. At least not using the Field Calculator.

Reason: When we join to a different FC, the SHAPE column from that FC doesn't get brought in as a joined field. So, it's not a valid input.

But in Pro 3.1, it can be done using a different tool: the Append tool.

@DrewFlater Is that correct?

Re: Allow updating geometry in Field Calculator

DrewFlater — Mon, 17 Apr 2023 19:25:25 GMT

@Bud your summary is correct. ArcGIS in general has a hard limitation that any table can only have one Shape column. I talked to a few developers and our system would destabilize if we lifted a limitation that two Shape columns could be in one table as a result of a join or other process.

The Append/Upsert enhancement you explained is an easy solution for this problem, or you can write a few lines of Python code using a search and update cursor to read one feature geometry then write/calculate/update the geometry of another feature based on it.

Re: Allow updating geometry in Field Calculator

Bud — Mon, 17 Apr 2023 20:08:55 GMT

Ok. Thanks @DrewFlater.