topic Re: Mass update of attributes in ArcGIS Pro Questions

Mass update of attributes

Krobertson943 — Thu, 14 Nov 2024 19:08:08 GMT

Hi~ Everyone,

I want to do a mass update of the attributes in 2 existing feature classes. One has over 57,000 rows and the other over 65,000. I just want to use a table to refresh the attributes and not change the geometry. Any tools or methods that can quickly can do this?

Thank you

Re: Mass update of attributes

DanPatterson — Thu, 14 Nov 2024 19:15:25 GMT

If you have a common key field,

Join Field (Data Management)—ArcGIS Pro | Documentation

Re: Mass update of attributes

BrianBulla — Thu, 14 Nov 2024 19:23:24 GMT

I guess it depends on what you are doing....maybe give more details.

You can always just do a selection, and update through the Attribute window if you are changing all features to the same thing....or use definition queries and break it down into chunks.

If you have access to the backend, you can just fire an update query in SQL. That would be the fastest.

Re: Mass update of attributes

Krobertson943 — Thu, 14 Nov 2024 19:23:31 GMT

I do have a common field but it bogs my system down to do a join and a calculate field with these large tables.

Re: Mass update of attributes

Krobertson943 — Thu, 14 Nov 2024 19:32:03 GMT

Our account management system is completely separate from our GIS. We have parent accounts and service locations that have had account detail changes that need to be updated in GIS. This will be multiple fields (12-15) for each feature class. A simple join and field calculate does not work.

Re: Mass update of attributes

BrianBulla — Thu, 14 Nov 2024 19:41:16 GMT

Yeah, joins in ArcMap/Pro are pretty sketchy.

Get a DBA involved and do all the updates directly on the backend. If you have FME, that might be a good option too.

Re: Mass update of attributes

Krobertson943 — Thu, 14 Nov 2024 20:02:07 GMT

I wish I had access to either of those but I do not. I am a one person shop.