Reporting chart changes

Aviation data is constantly updated, and it can be challenging to determine which charts have been affected by the data changes. The Change Reporter tool allows you to view changes made to individual feature classes and tables in a geodatabase as well as the products that have been affected. The geodatabase you want to use with the Change Reporter tool must have versioning and archiving enabled, meaning the tool can only be run on an enterprise geodatabase. Using this tool, you can find differences between different versions of the geodatabase or the default version of the production database at different points in time.

The changes are displayed in a table once the process is complete and are reported using ArcGIS Data Reviewer. They can be viewed in the Reviewer table.

The Change Reporter tool reports changes to the main feature classes and tables in the aviation production database. Changes to cartographic, masking, and annotation feature classes are not reported in the results.

Enabling the geodatabase for versioning

Versioning isolates your work across multiple edit sessions, allowing you to edit without locking features in the production version or immediately impacting other users. Versioning must be enabled on the geodatabase that you want to use with the Change Reporter tool.

For more information, visit An overview of traditional versioning.

1. Start ArcMap.
2. In the Catalog window, right-click the dataset, feature class, or table in the production database and point to Manage.
3. Click Register As Versioned.

   The Register As Versioned dialog box appears.

4. Click OK.

Enabling the geodatabase for archiving

Archiving in ArcGIS provides the functionality to record and report changes (additions, modifications, and deletions) made to any or all data in a geodatabase. Geodatabase archiving is the mechanism for capturing, managing, and analyzing data changes. The archiving model supports the complete geodatabase data model. Stand-alone feature classes, feature datasets, tables, relationship classes, networks, topologies, and terrains can all participate in archiving. Once archiving is enabled, all changes that are saved or posted to the default version are maintained in the corresponding archive class. The archive class is a complete copy of the archive-enabled class, plus all the edits that have been saved or posted to the default version. The Change Reporter tool allows you to query the historical archives, read changes from the geodatabase history tables, and write those changes to a Reviewer table. You can choose which feature classes or tables are to be searched and specify a date and time range. Any records in the feature classes or tables that changed within the specified date and time range are recorded in the Reviewer table.

Geodatabase archiving allows you to analyze your data as it changes over time. It helps preserve data changes and assists in identifying the type of changes made. The Change Reporter tool accesses these archiving tables and writes those changes to the Reviewer table.

1. In the Catalog window, browse to the geodatabase for which you want to enable archiving.
2. Select and right-click a feature dataset, feature classes, or tables, and click Archiving > Enable Archiving.

Setting up a Reviewer workspace

Data Reviewer allows you to conduct visual and automated reviews of data in support of database production. The Data Reviewer environment is made up of a series of tools that support the visual review of geodatabase and shapefile data quality. It is used to analyze data in your geodatabase and identify anomalies where corrections, additions, and deletions must be made to spatial data and its attributes. Data validation is performed during Reviewer sessions using data checks as well as the analysis tools that are part of Data Reviewer. Features are symbolized in a consistent manner to facilitate interpretation.

A Reviewer workspace needs to be created for the Change Reporter tool to write the records in the Reviewer table. In a Reviewer session, you can review your data, write records to the Reviewer table, and interact with records in the Reviewer table.

Caution:

It is recommended that an desktop geodatabase or an enterprise geodatabase be used as the Reviewer workspace so the NOTES field length can be modified to accommodate the full length of the results. The recommended length is 4,000 or more characters. The NOTES field length cannot be modified in a file geodatabase and is limited to 255 characters.

1. Start ArcMap.
2. Browse to the geodatabase that you want the Reviewer tables and feature datasets to be created in.
3. In the Catalog window, right-click your Reviewer database and point to Import > XML > Workspace Document.
4. Click the Data button in the What do you want to import section of the Import XML Workspace Document dialog box.
5. Click the browse button and browse to the UpdatedReviewerSchema.xml file.

   Tip:

   You must create a Reviewer workspace using the XML located at <Installation location>\Program Files(x86)\ArcGIS\AviationCharting\Desktop<version>\Utilities\Reviewer

   The Change Reporter tool requires this schema to function in the Change Details window.

6. Choose the UpdatedReviewerSchema.xml document and click Open.
7. Click Next.
8. To change a suggested name in the Target Name column, you can overwrite the name.

   Caution:

   Any naming conflicts are displayed in red.

9. If you are importing into a file or an enterprise geodatabase and you want to use a configuration keyword, you can choose one from the Config Keyword drop-down menu.
10. Click Finish to import the information from the XML document.

Registering elements with the element catalog

The element catalog is a table in the production database that stores information about each data-driven element, including the products for which they have been created and the data used to generate them. To verify that the elements are referencing the correct data sources, you can verify they are registered in the element catalog so they can be compared along with the feature classes and tables. Registering the elements ensures that any changes to the data on which they are based or their position can also be reported by the Change Reporter tool.

This process also repairs elements that have become unregistered and removes entries for elements that are no longer in the product layout.

1. If necessary, on the main menu, click Customize > Production > Product Library to open the Product Library window.
2. Get a local copy of each product for which data-driven elements need to be registered in the element catalog.
3. If necessary, change to layout view.
4. Click the Element Catalog Viewer button on the Aviation Layout toolbar.

   The Element Catalog Viewer dialog box appears. Any elements that are in the map but do not have records in the element catalog are listed under Unregistered. Elements that have records in the element catalog but do not appear in the map appear under the Missing heading.

   Note:

   You can optionally click Expand All and Collapse All to expand or collapse the Source Data tree view, respectively.

   

5. Click Update Element Catalog.
6. Click Close.

Creating a preference to define what is analyzed by the Change Reporter tool

A preference is a set of saved settings that define the feature classes and tables to be evaluated by the Change Reporter tool. It also includes information such as the product instances to be analyzed and any supplementary areas of interest (AOIs) to be used in analyzing the data. Once a preference is created, it can be saved in the aviation production database and reused after more edits have been made to your data.

If a supplemental AOI feature class is used, it must be a polygon feature class that is currently in the aviation production database. A supplemental AOI is an additional region of interest that you can add to a preference and that can be used to identify features that may have changed outside of the existing product AOIs but may still be of interest to report. This means that even if not all of the instances are selected in the preference, they may still be analyzed due to the supplemental AOIs being used.

1. Ensure that the correct product library and production database are set.
2. On the main menu, click Customize > Production > Production Properties.

   The Production Properties dialog box appears.

3. Click Aviation Properties in the list on the left side of the Production Properties dialog box.
4. Click the cell next to Change Reporter Preferences and click the ellipsis button (...) that appears.

   The Change Reporter Preferences dialog box appears. The production database is analyzed to determine which feature classes and tables have versioning and archiving enabled.

5. Click OK to close the message.

   The Change Reporter Preferences dialog box appears.

   

6. Check the check boxes next to the instances to be analyzed using the Change Reporter tool.

   Only instances that are considered maintained instances appear in the Instances To Process list. Additions, modifications, and deletions that fall within the geometry of the instance AOIs are reported.

   You can click Select All or Clear All to check or uncheck all the instances at once, respectively.

7. Check the check boxes next to the tables and feature classes to be analyzed by the Change Reporter tool.

   Only feature classes and tables that have versioning and archiving enabled can be included in the preference. You can click Select All or Clear All to check or uncheck all the feature classes and tables at once, respectively.

8. Optionally, expand a selected table or feature class and uncheck individual fields so they are not analyzed.
9. To use a supplemental AOI feature class, do the following:
   1. Click the ellipsis button (...) next to the Supplemental AOI Feature Class field.

      The Supplemental AOI Feature Class dialog box appears.

      

   2. Click the AOI Feature Class drop-down arrow and choose the feature class with the supplemental AOI features.
   3. Click the Identifier Field drop-down arrow and choose the field that identifies the AOI in the MAPID_TXT field on the Reviewer table and in the tree view displayed on the Change Reporter Results dialog box.
   4. Optionally, click SQL and define a definition query to limit the number of features used for analysis in the AOI feature class.
   5. Check the check boxes next to the types of changes based on the AOI feature extents.

      Additions are reported when features or table rows are added. Modifications are reported when the geometry or attributes of a feature are modified. Deletions are reported when features or table rows are deleted.

   6. Click OK.

      The Change Reporter Preferences dialog box appears.

10. Click Save As.

    The Preference Name dialog box appears.

11. Type a name for the preference in the Enter Name text box.
12. Click OK.

    The Change Reporter Preferences dialog box appears.

13. Click OK.

    The Production Properties dialog box appears.

14. Click OK.

Finding changes in tables and feature classes using the Change Reporter tool

The Change Reporter tool allows you to find changes made to individual feature classes or an entire geodatabase between specified dates and times. You can find these changes by comparing two versions of the aviation production database or by comparing the default version of the database based on a date range. The changes reported are feature additions, modifications, and deletions. Once found, these changes are automatically committed to the Reviewer table for further examination.

1. On the main menu, click Customize > Toolbars > Aviation Data Management.
2. Click the Change Reporter button on the Aviation Data Management toolbar.

   The Change Reporter dialog box appears.

   

3. Browse to the directory of the Workspace field you want to review to choose a Reviewer workspace.
4. Choose a Reviewer session to report Change Reporter results by doing one of the following:

   To use an existing Reviewer session that does not have Change Reporter records	Click the Session drop-down arrow and choose a session name.
   To create a session	Click New to create a session, type a name for the session in the Enter Name text box on the New Session Name dialog box, and click OK.

5. Click the Preference drop-down arrow and choose the settings to run on the production database.
6. Choose one of the following options for comparing the production database at different points in time:
   • Transactional Version—Compares versions of the production database to find records that have been modified. The base version is typically the primary (Default) version of the production database, and the Version to Compare is the secondary version.

     Note:

     This option requires versioning to be enabled on the production database.

   • By Date (Only Applies to Default Version)—Searches the Default version of the production database for records that have been modified within the specified date range.

     Note:

     This option requires archiving to be enabled on the production database.

7. Configure one of the following options to compare versions:

   Compare transactional versions	Click the Base Version drop-down arrow and choose the primary version of the production database. Click the Version to Compare drop-down arrow and choose the production database secondary version to be compared to the base version.
   Compare by version date	Click the drop-down arrow in the Beginning Date field and choose the start of the date range. Click the drop-down arrow in the End Date field and choose the end date for the date range. Note: To avoid all features in the database being marked as a change, set a start date later than the archive date on the geodatabase.

8. Click OK to start processing.

   The Change Reporter Results dialog box appears when processing is complete.

   Use the Instances To Process tree to review differences based on primary features, solutions, product classes, series, charts, and instances affected. The number of changes found appears in parentheses next to each node. The table illustrates the change types that have been reported and the quantity for each.

   

9. Click Close on the Change Reporter Results dialog box.
10. Click OK.

Viewing changes in the Reviewer table

After the Change Reporter tool has been run, the Reviewer table is populated with records identifying changes to the specified feature classes and tables. Each change is categorized as an addition, modification, or deletion.

The Reviewer table displays the changes made to feature classes and tables in a specified geodatabase once the Change Reporter tool processing is complete. The Change Details window provides a simplified view of the changes that have been made to a feature or table record.

For information on navigating the Reviewer table, visit Browsing table records.

Field	Label	Description
LIFECYCLEPHASE	Phase	The current quality control phase for a record, indicated by an icon.
LIFECYCLESTATUS	Status	The current status of the record, which is based on the status assigned to it on the Update Results dialog box.
ORIGINTABLE	Source	Feature class or table from which the change was detected.
RECORDID	ID	Sequential record number that is autopopulated by Data Reviewer.
ORIGINCHECK	Check Type	The process that created the change records in the Reviewer table.
PARAMETERS	Check Parameters	The names of the Base and Comparison versions or the Start and End date and time range on which the Change Reporter tool was run. The process that created the change records in the Reviewer table. Note: This field is not displayed by default. To show it in the Reviewer table, you must check the box next to the field name on the Fields tab on the Reviewer Table Properties dialog box.
NOTES	Check Notes	Detailed information about the change made to the feature, table row, or element, including the GFID; if an attribute modification was made, the old and new values are also included.
SEVERITY	Severity	The default severity is 5, but can be changed.
REVIEWSTATUS	Description	Change type: Add, Attribute Modification, Geometry Modification, or Delete.
REVIEWTECHNICIAN	Created By	The name of the user from the Reviewer session.

1. Start the Reviewer session that contains the Change Reporter tool records.
2. Click the Reviewer Table button to open the Reviewer table and review the records.

   The records can be corrected and evaluated as needed.

3. Click the Change Details button on the Aviation Data Management toolbar.

   The Change Details window appears.

   

4. If necessary, dock the window in ArcMap.
5. Double-click a Change Reporter tool record in the Reviewer table to view detailed information on the changes to the feature or element.

   The information presented in the Change Details Viewer window is from the NOTES field in the Reviewer table.

   Note:

   You can group the records by the Check Title field to identify the records generated by the Change Reporter tool more easily.

6. Repeat step 5 for each record to be reviewed.
7. Stop the Reviewer session once you are finished reviewing the records.

This workflow is a step-by-step description of working with the Change Reporter tool. It describes steps that need to be completed before running the Change Reporter tool, explains the relationship between geodatabase versioning and archiving and the Change Reporter tool, and describes steps for starting a Reviewer session. Finally, the workflow guides you through running the tool and reviewing the results in the Reviewer table. The outcome of the workflow is a table that contains the records of all the changes made to feature classes and tables inside of the specified geodatabase and within the given dates and times. These records can then be corrected and evaluated as needed.