The SSP All Edits Reporting & QA Tool (AKA "All Edits Report") answers some of the most common questions for GIS or QA managers: "who" did "what", "when" and "where" in the GIS. Popular with larger utilities, this tool provides users the ability to track edits that were made within a version in an Esri versioned geodatabase. It accomplishes this by analyzing the version before it gets posted to create a textual and graphical report of all the edits (additions, changes and deletions) that have occurred within the version. The end result is far fewer "bad" edits are posted, providing a more realistic, healthy and safe dataset, ultimately bolstering utility efficiency.
This application can run either manually (typically at the point of QA/QC) or automatically (as part of a Batch Reconcile & Post process).
Textual List: If used manually, the All Edits Report is initiated with a button in the ArcMap toolbar. When clicked, a reconcile is run against SDE.default and a sortable, clickable list of all the edits is presented.
Deletes are listed with record type (pole, transformer, etc), the object id of the deleted record, and optionally all of the non-spatial attributes of the deleted record.
Additions are shown with the record type, the object id, and optionally all of the non-spatial attributes of the added record.
Updates are shown with the record type, the object id, a listing of the fields that were changed, and the values of both the original and updated value.
Interactive Review Options to Facilitate Effective QA: The tool includes many different options to allow the QA personnel to quickly and effectively review the edits listed in the report.
Toggling the check-boxes updates the textual report in real time showing the user only what they want to review. This can be very useful when QA’ing a session against a written service request or work order.
Report Visualization: Next, users may visualize the edits directly on the map for a graphical view of "who" did "what" "when" and "where":
Visualize Report: Clicking this button creates graphics on the map corresponding to each of the edited features. The graphics are shown on top of the existing GIS features. Additions are shown in blue, deletions in red, and updates in forest green (along with orange for spatial updates).
The map is automatically zoomed to the extent of the edits to allow the QA user to review the entire job from a bird’s eye view. This provides an easy way for the QA user to determine if other edits (not in the same area as the job) were made in the session.
Zoom to Selected: The Zoom to Selected function will zoom the map in to the record level of a selected edit. This is useful in combination with the Visualize Report function as it allows for the quick review of each edit currently visualized on the screen.
Flash Selected: The Flash Selected button flashes the geometry of the currently selected edit on the screen. It can be especially useful when looking at a congested area of edits within a version.
Visualize Selected: After a user has selected an added, deleted, or updated feature on the textual report, they can then click the Visualize Selected button to visualize only the selected edit.
This allows the QA user to drill down to a more detailed record level.
If the geometry of the feature was updated, the original geometry is shown in orange with the new geometry shown in green.
Visualize Clear: This function simply clears the current visualized graphics off of the map so that only the GIS features are shown once again.
Report QA and Storage: The All Edits tool provides additional functionality designed to provide a more efficient QAQC as well as the historical storage of the report for audit and informational purposes:
View Attributes: The View Attributes function shows the user a side-by-side view of the attributes in the current session and the attributes in the parent session.
For updated records, this can be used to further evaluate and QA the changes in the record. For added or deleted records, this can be used to further identify attributes of a feature that was added or deleted within the version.
Run QAQC: Built for those customers using Schneider Electric’s ArcFM™ tool, the Run QAQC function first makes a feature selection of all features (and their related objects) that were edited on the map. It then taps directly into the SE QAQC tool to execute all configured QA rules against the selected data. This is an easy way to ensure you have run the QAQC tool on all edits within the current session.
Export Report: The final function of the tool is the Export Report button. Many organizations have realized significant value by capturing/storing a report on all the edits performed in a given session/version once the user has completed the QA of the current session. Clicking this button will establish a meaningful name for the report including the version name and the date, and present it in a standard SAVE dialog.
The user can then browse to any location and click Save to create a formatted text file with all of the details from the All Edits report. By default, the exported report will show ALL attributes of both added and deleted records. This allows the organization to keep track of when edits occurred to the system, who performed the edits, and the exact details of the edit. This information can be crucial to organizations during any type of audit scenario when they need to determine when specific updates were made.
The report can alternatively be saved to a database.
Auto-All Edits Report: The Auto-All Edits Report is a version of the tool which is utilized behind-the-scenes, typically as part of a Batch Reconcile & Post (BRP) process. Some utilities prefer to skip the manual interrogation of the edits, opting for an automatic save to a DB table.
In this scenario, the All Edits Report will be inserted into the BRP as a sub-task which will produce the same attribute-level report described above for all versions being posted, and automatically save it to the database destination of your choice. All of the audit value is there, providing the utility a depiction of "who" did "what" "when" and "where".
New Functionality: Recently new, optional functionality has been built with a large customer to allow for a geographical view of the edits in a version after it has been posted and deleted (not just textual). In other words, you may visualize the version and its edits on the map as if it still existed, even though it does not. This functionality is available optionally with the tool. Read more about it here.
Additional Enhancements: New enhancements are released for the All Edits Tool each year. You can read about several of the enterprise enhancements here:
January, 2014: The Auto All Edits is now available as a Schneider Electric Geodatabase Manager™ (GDBM) Action Handler
October, 2014: This update included allowing users to search for past (posted) edits based on field attribution like work order number, managing an archive data storage for older edits, configurable search for version names, and more.
May, 2015: This update included significant speed enhancements for saving All Edits reports to the database as well as a new "Restore Delete" button that allows QA users to easily recreate deleted records on the map based on the All Edits Report.
All trademarks remain the property of their respective owners. Unless otherwise specified, no association between SSP Innovations and any trademark holder is expressed or implied. For example, ArcFM™ is the registered trademark of Schneider Electric, and no endorsement of SSP Innovations or its products and services is expressed or implied by the mention of ArcFM™ in this website and blog.