I would like to see the total number of edits made in my Default.SDE before the reconcile/post/compress process. I know you can view the number of edits made in versions with the Version Changes tool but it wont allow it for the Default.

The data does not have to be specific, just total number of created features/deleted/modified features (one number for all edits works).

For example, if I run my reconcile/post/compress script every Friday, I want to be able to see how many edits were made to this gdb before I start the process.

I'm sure there has to be an easy solution for this or something arcpy can handle (preferred method would be arcpy so I can add this to my reconcile/post/compress script to print the number of edits so I can catalog in my invoices. But I am not finding much on GeoNet.

  • One thing you can do is capture the row counts in the Adds and Deletes tables. You'd have to do more sophisticated queries to determine how many insert, update, and delete transactions were present. – Vince Apr 12 '17 at 14:38
  • Was hoping this could be done in Catalog/arcpy but SQL Server queries may be my only option. – NULL.Dude Apr 12 '17 at 14:44
  • Any SQL query solution can be implemented in ArcPy through an arcpy.ArcSDESQLExecute cursor, so now I need to figure out the syntax for this anyone familiar with it? – NULL.Dude Apr 19 '17 at 15:40
  • The cross-posted GeoNet question has SQL. Instead of reposting my comments from there here, you should alter the question here to contain the SQL you intend to execute and the Python you have started to implement it, along with a description of where you have gotten stuck (unless the code works first time, which is quite possible, at which point you can answer this yourself). – Vince Apr 20 '17 at 0:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.