Mass update of attributes

[Krobertson943]

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

[DanPatterson]

If you have a common key field,

Join Field (Data Management)—ArcGIS Pro | Documentation

[Krobertson943]

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

[BrianBulla]

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.

[Krobertson943]

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.

[BrianBulla]

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.

[Krobertson943]

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