We needed suggestions or inputs on a workflow our client would like to implement. Here is the situation:
Our client has a parcel layer which is edited ( attributes of existing parcels are updated or new parcels are added or existing parcels are deleted) on a daily basis. They have another system (mainframe) where they need to enter\upload this updated information once the editing is finished.
For this, at the end of the day they would like to find out\extract ONLY the parcels which were updated\added\deleted on that particular day from the entire parcel feature class. Once they get this data they will pass it on to other team who will be responsible for updating their mainframe with this information.
They are working with
SQL Server 2012
ArcGIS 10.3 , geodatabase is also at 10.3
Data is registered as versioned
Archiving is enabled
Editor tracking is enabled
They are looking for a dynamic method of generating this information on a daily basis.
Any ideas or inputs for this would be much appreciated.