topic Re: Track Number of Edits in Data Management Questions

Track Number of Edits

SharonZastre — Tue, 05 Apr 2016 13:54:11 GMT

Is there a way to track the number of edits, or the number of records edited, in a versioned enterprise geodatabase? For example, I would like to know the number of edits from last week, or the number of edits since the last sync/compress. Any ideas are appreciated!

Re: Track Number of Edits

George_Thompson — Tue, 05 Apr 2016 14:28:54 GMT

I would recommend moving to a more appropriate space like Geodatabase Managing Data

Re: Track Number of Edits

TariniMehra1 — Tue, 05 Apr 2016 14:45:29 GMT

Geodatabase Archiving would be a possible way to track your edits in a versioned enterprise geodatabase . But it would work only from the time you enable it on a particular feature class. you could connect to a historical version and track the edits made at a particular moment in time.

Below is the link for reference:

Geodatabase archiving—ArcGIS Help | ArcGIS for Desktop

-Tarini

Re: Track Number of Edits

ChrisDonohue__GISP — Tue, 05 Apr 2016 15:03:46 GMT

A rough way one could do this is to use the Version Changes function on the Versioning Toolbar for each version. The numbers in parenthesis in the pane on the left represent the number of edits made to that version. Not an optimal solution, though, as one would have to check each version and then track the amounts and how they change over time.

Chris Donohue, GISP

Re: Track Number of Edits

RebeccaStrauch__GISP — Sat, 11 Dec 2021 13:13:17 GMT

If using MSSQL, and have access to MSSQL Management Studio, you can query the number of records in the A(dd)/D(elete) tables to see how much is pending reconciling/compressions. This isn't an actual cound of edits necessarily, but give some indication about when if's time. The larger the A/D tables, the longer it takes to open for editing, etc.

My script:

use mymaster
select name, owner, version_id, state_id, parent_name, parent_owner from [mymaster].[dbo].[SDE_versions]
select * from  [mymaster].[dbo].[SDE_versions]
select * from [mymaster].[dbo].[SDE_states] order by state_id
select * from [mymaster].[dbo].[sde_state_lineages] order by lineage_name, lineage_id

This produces 4 lists and in the lower right corner there is a row count. Right now I'm at 27 rows...which isn't bad. Totally reconciled, with one version and state_id=0 is usually 6 rows. For use, when it gets 150+ plus, it's time to reconcile, but that is just our workflow (one person doing edits) since then it is usually time to roll-up and publish. Actual mileage will vary.

Re: Track Number of Edits

SharonZastre — Wed, 06 Apr 2016 15:13:07 GMT

Thanks Rebecca! I think querying the SDE_states table will work to get an idea of the number of edits made. I don't need an exact number but an estimate so that we can measure productivity.