topic Re: Updating attribute information for feature classes in ArcGIS Pro Questions

Updating attribute information for feature classes

DWass — Mon, 14 Feb 2022 18:15:35 GMT

I have been tasked with updating feature class attribute information for Utility Network in ArcGIS Pro 2.9.1. This is a large dataset, there will be approximately 300 rows in a spreadsheet to update in the existing table of over 2000 features. Some data fields will need updates but others will be left as is. I will need to do a combination of adding new rows, updating data in existing rows, and deleting some as well. This process will need to be repeated for other asset types.

I was going over what options are available and found that ArcMap has a tool called Copy Linked Record in Attribute Assistant which seems well suited for updating attribute information. Does ArcGIS Pro have a similar tool that I can use or will I have to script an attribute rule (or rules) in Arcade?

Any suggestions will be greatly appreciated!

Re: Updating attribute information for feature classes

DirtDogRoj — Mon, 14 Feb 2022 19:24:08 GMT

This workflow leaves many questions unanswered. How would you know which fields will be updated and which ones left as-is? Hopefully this decision is not a row-by-row decision. But looking at your issue, the workflow I would choose is to convert the spreadsheet to a table, usually by using CSV as the interim format. Then I'd join by Unique ID and, in the join, I would exclude records that didn't join up. Then I would use Field Calculator to copy values from the table to the feature class. Then I'd remove the join. I would then join the table to the feature class and opt to keep all records. A Select by Attributes would help me find records in the table that aren't in the feature class (where featureclass.uid is null). Those are the ones I'd have to add to the feature class.

Now, this is all fine and dandy for a feature class, but you specifically mentioned utility network. One would have to know more about how this figures into your 300-record spreadsheet.

Re: Updating attribute information for feature classes

RobBurke — Mon, 14 Feb 2022 20:50:48 GMT

Also an add on question. Will you be editing the Utility Network feature services using Branch Versioning?

Re: Updating attribute information for feature classes

DWass — Mon, 14 Feb 2022 21:17:51 GMT

Thanks for the response! I will determine which fields need to be updated and left as-is when I get to analyzing and cleaning the data, most likely by comparing the updated table with the existing feature class. Right now I am going over the steps to complete this task.

Re: Updating attribute information for feature classes

DWass — Mon, 14 Feb 2022 21:19:23 GMT

I will not be using branch versioning for this task but it will be used for some future editing.

Re: Updating attribute information for feature classes

RobBurke — Tue, 15 Feb 2022 00:20:38 GMT

With all the decision making needing to be done, it seem like a great place for a Python script and using an UpdateCursor. Is it in a File or Enterprise geodatabase?

Re: Updating attribute information for feature classes

DWass — Tue, 15 Feb 2022 12:55:13 GMT

It is an enterprise geodatabase.