Record updates in a record to another table

322
2
Jump to solution
01-26-2021 07:56 AM
Brian_McLeer
Occasional Contributor II

We are using a custom VB add-in tool in ArcMap to record transactional history for updates to our Address feature class. 

Example:

105 Main St was entered incorrectly 3 years ago. The editor updates to the correct information, which is 110 Main St. In the SQL table, the table stores the unique ID of the address, the old address (105 Main St), the new address (110 Main St), the update time, and editor using Windows authentication. 

We are trying to migrate this custom add-in tool in ArcMap to attribute rules with arcade expressions into ArcGIS Pro. 

The question I have is can anyone point me towards a resource for recording in a separate table edits to a feature class recording the attribute value prior to the edit and what the new value is. 

0 Kudos
1 Solution

Accepted Solutions
HusseinNasser2
Esri Contributor

Ability to update other classes/tables (related or not) can be done through the DML dictionary explained in this blog

 

https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/advanced-gdb-attribute-rules-ed...

hope this helps!

 

 

View solution in original post

2 Replies
JoeBorgione
MVP Esteemed Contributor

I did a google search on 'ArcGIS Arcade Update Related Table' and found a couple. Here's one that is pretty close:

https://community.esri.com/t5/arcgis-pro-questions/arcade-update-feature-class-based-on-related-tabl...

take a look here too:  https://github.com/Esri/arcade-expressions

It might have just what you need.

@XanderBakker 

@HusseinNasser2 

can't wait to retire....
HusseinNasser2
Esri Contributor

Ability to update other classes/tables (related or not) can be done through the DML dictionary explained in this blog

 

https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/advanced-gdb-attribute-rules-ed...

hope this helps!

 

 

View solution in original post