ArcGIS Blog

Data Management

ArcGIS Data Reviewer

Improving Data Quality for Water Utilities Webinar Q&A

By Mary Mozingo and Mike Miller and Jay Cary

On November 13, 2024, we held a webinar on Improving Data Quality for Water Utilities.

In today’s rapidly evolving utility landscape, ensuring high-quality data for efficient operations, compliance, and customer satisfaction is essential for water utilities.

In this webinar we covered the critical role of data quality management in optimizing water utility performance. We explore best practices for ensuring accurate, reliable data and migrating to ArcGIS Utility Network—the next-generation spatial information system that enhances network modeling, data analysis, and decision-making.

You can now watch the webinar recording and explore our Q&A from the live session in this blog. If you cannot find the answers you were looking for, please post your questions on the ArcGIS Data Reviewer community place.

Technical questions

What types of geodatabases are supported with Data Reviewer-based attribute rules?

Data Reviewer’s automated checks are supported in both validation and constraint attribute rules. In ArcGIS Pro 3.4 and ArcGIS Enterprise 11.4, validation and batch calculation attribute rules are supported in file, mobile, and branch-versioned enterprise geodatabases. Constraint and immediate calculation attribute rules are supported in file, mobile and enterprise geodatabases (branch, traditional, and non-versioned).

How are the attribute rule error layers created?

Attribute rule error layers are a series of system-maintained datasets that store error features created during evaluation of either a batch calculation or validation attribute rule. These datasets are automatically created when the first batch calculation or validation rule is created in a geodatabase. See the evaluate attribute rules documentation for more information.

Does data reviewer have to be in a utility network model in order to use data reviewer in Pro?

No, the data reviewer rules can be configured for any geodatabase based feature class or table.  If you want to define attribute rules on data in the Asset Package, you will need to enable Global IDs as the GlobalID field is set as a GUID type.

Is Utility Network only available through ArcGIS Enterprise?

The Utility Network is available in File and Mobile Geodatabases, as well as ArcGIS Enterprise.

Could you provide a link to the new data dictionary mentioned in the slides?

All of the data dictionaries are now included with the solution when it is deployed.  We are working on adding a link to our help site.

Is it possible to export Reviewer-based attribute rules to see the Arcade expression?

Validation attribute rules implemented using Data Reviewer checks do not rely on Arcade to perform data validation. Instead, checks leverage a validation engine that is purpose-built to efficiently query and analyze spatial data. This engine provides improved performance by optimizing queries on your geodatabase, combining multiple rules during validation and generating error results that more precisely depict error conditions.

Would a utility network prevent or not permit these types of issues?

The utility network error model does capture some errors we configured Data Reviewer to discover, but does not provide all the validation of attributes, such as ensuring all valves have a valid status.

Are all Data Reviewer checks that were available in ArcMap available in attribute rule workflows?

Integration of Data Reviewer’s automated checks in attribute rule-based workflows began with the ArcGIS Pro 2.5 and ArcGIS Enterprise 10.8 releases. With each successive release, additional checks were implemented and, in some cases, enhanced to better support attribute rule workflows. Except for the Valency check, all checks planned for migration are now available. See the ArcGIS Data Reviewer product roadmap for additional information on what’s planned in the future.

What are the plans for support of Data Reviewer’s ArcMap-based quality control capabilities in ArcGIS Pro and ArcGIS Enterprise?

Several of Data Reviewer’s most used ArcMap workflows are available in ArcGIS Pro to support those organizations who have a mixed environment of ArcMap and ArcGIS Pro deployments. These workflows include the use of existing Reviewer Batch Jobs to automate data validation, visual review tools, and the storage of error results in a Reviewer workspace.

With the upcoming retirement of ArcMap, customers are strongly encouraged to migrate their QC workflows to attribute rules as soon as possible. See the Migration from ArcMap to ArcGIS Pro for data validation topic for more information.

How can we clean our source data without Data Reviewer? Can the errors be identified and addressed manually as a one-time cleanup prior to migration?

You can use Arcade expressions in Attribute rules to validate your data.  Also, you can use the available core ArcGIS Pro geoprocessing tools to identify data issues.  However, Data Reviewer makes it more efficient.

What is the difference between Topology Rules and Data Reviewer?

Geodatabase topology and Data Reviewer are both capabilities that support the creation and management of high-quality data. There are advantages to using both capabilities in data management workflows. A key difference between these capabilities is the aspects of a feature’s quality that can be assessed. Data Reviewer checks are used to assess multiple aspects of a feature’s quality. This includes the ability to identify data quality issues related to a feature’s integrity, attribution, as well as a feature’s spatial relationship to other features. For a complete list of Data Reviewer checks, review the ArcGIS Data Reviewer Checks poster.

A geodatabase topology is used to enforce a spatial relationship between features in a geodatabase. This includes assessment of spatial relationships such as overlaps, intersections, and gaps. For a complete list of topology rules, review the ArcGIS Geodatabase Topology Rules poster.

Is it possible to migrate from the Esri Local Government Information Model (LGIM) to a Utility Network?

The updated migration tools provided with the ArcGIS Solutions and the tutorial simplify this process.  The migration from the LGIM to the sewer essential models is documented in the tutorial we just released.

Licensing questions

How is ArcGIS Data Reviewer licensed?

ArcGIS Data Reviewer is an integrated extension to ArcGIS Pro and ArcGIS Enterprise that supports quality control workflows across multiple industries and data types. In ArcGIS Pro, Data Reviewer is available for all license levels as an add-on to a Named User, Single Use, or Concurrent Use license type. See the ArcGIS Pro license type documentation for more information.

In ArcGIS Enterprise, Data Reviewer is available for the Standard and Advanced editions of ArcGIS GIS Server. The extension is a CPU-based license that is required for each GIS server that is federated with the organization. See the ArcGIS GIS Server capabilities and extensions documentation for more information.

Is ArcGIS Data Reviewer required for identifying and resolving data issues when migrating to the Utility Network, or can they be addressed without a Data Reviewer license?

No, Data Reviewer is not required.  You can enable the Utility Network to identify Utility Network Errors.  Data review can identify many of these errors, as well as many other data issues that are not considered Utility Network errors, but should be resolved, such as a dangle on a water main/service.

 

For more information on ArcGIS Data Reviewer, please visit the product page. Did not find the answer you were looking for? Join us on the Esri Community to ask your questions there and share your ideas.

Watch the webinar recording:

Share this article