1

I want to check whether there is a way to trace all the creation, modification and deletion events in the editing session. What I aware now is how to get the latest updated information of an object in the attribute table of a layer.

I am using ArcMap 10.2.2.

7
  • 1
    Do you have SDE? are you interested in an ArcObjects soloution? Commented Aug 20, 2014 at 0:53
  • Hi Michael, yes I have a SDE, I am also interested in ArcObjects.
    – ppLily
    Commented Aug 20, 2014 at 1:01
  • 1
    You can respond to the IEditEvents OnCreateFeature, OnChangeFeature and OnDeleteFeatue events to get this information as it happens and then copy the feature out to a temporary workspace to catch each "version" of the feature as it's modified/removed. Simplest case is to use replica (check-out) and then export to a delta table to show what features were added and removed (modify is removed and then added) Commented Aug 20, 2014 at 1:04
  • Hi Michael, thanks for the idea. I am using enterprise geodatabase, the check-out replica target geodatabase should be enterprise geodatabase right? I tried to use XML file but failed.
    – ppLily
    Commented Aug 20, 2014 at 2:21
  • No, the check-out target is a file/personal geodatabase that is edited as normal and doesn't require connection to SDE until the check-in. Enterprise to enterprise replication can be a two-way replica or one-way replica but is not usually a check-out. Commented Aug 20, 2014 at 2:37

1 Answer 1

1

To identify changes before they are committed to the SDE database it is best to use a check-out replica (see http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000v5000000). A replica database references a version in the SDE database (see http://resources.arcgis.com/en/help/main/10.1/index.html#/Replicas_and_geodatabases/003n000000vp000000/), if you have multiple check-outs each one must have its own version; to remove a check-out simply delete the version from SDE and it is no longer referenced this can not be undone, a check-out that no longer has a version cannot be reconciled.

A replica (check-out) is a personal or file geodatabase that has a copy of the SDE data referenced by that version and internally has delta tables, which cannot be seen in Catalog. To view the delta tables you can export them using Export to Delta which will provide a feature class of the added features and a table of the OIDs of the deleted features. A feature that is modified is present in the delete table and the add feature class.

Note: export to delta does not destroy the version, you can still use the data and export delta tables again as many times as you need prior to synchronizing changes.

When you want to apply the changes to SDE use Synchronize Changes to post the replica.

To simplify the workflow I find it easier to use the distributed geodatabase tools - they used to be on a toolbar but now are not:

enter image description here

Create a toolbar and drag these tools onto it using the customize dialog; there are wizards here that make the whole process much easier.

1
  • Thanks a lot Michael. The distributed geodatabase still on my toolbar. :)
    – ppLily
    Commented Aug 20, 2014 at 4:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.