Record updates in a record to another table

1567
3
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. 

Brian
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

3 Replies
JoeBorgione
MVP Emeritus

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 

That should just about do it....
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!

 

 

Sothea_VOEUN
New Contributor III

Dear @HusseinNasser2:
Thank you for your contribution to the GIS Community.
Currently, I am also dealing with this type of problem in ArcGIS Pro Online 3.0.0 version, but with little difference. 
Since I am working in property management (Condominium Information Management), I need to update and track all information when one unit is sold to other entities.
My question: Is there any solution to keep all History Information (Original Information of the first Owner or even the second-third owner) in the Historical Table with an automated update method? (When the new information is entered into the table, it should be automatically stored in the Historical Table without COPY and PASTE which would take me time.)
Thank you for taking to respond.

0 Kudos