Available with Data Reviewer license.
Summary
The ArcGIS Data Reviewer Unique Field Value check finds rows in feature classes and standalone tables that contain nonunique values in a field or a list of fields that are editable. This can include point, line, or polygon feature classes.
Overview
The purpose of the Unique Field Value check is to identify attribute values that are recurring within the fields you define. Features or rows from the input data source are returned as errors when attribute values are not unique. You can configure this check on fields with Raster or Blob data types and on editable fields; it excludes non-editable fields such as OBJECTID, GlobalID, editor tracking fields, and other fields that have been configured as Read Only.
Industry scenarios
The following are scenarios in which you can use this check:
- In indoor data management, the site, facility, and level ID fields must be unique to identify the feature’s associated site, facility, and level features in floor-aware maps, which you can then use in other apps for routing or to find assets.
- In tax parcel management, the record name must be unique to avoid creating records with the same name in legal plans or records of survey.
Supported workflows
ArcGIS Data Reviewer checks support multiple methods for implementing automated review of data. The following table identifies the supported implementation methods for this check:
Validation | Constraint | ||
---|---|---|---|
Reviewer batch job | Reviewer map rule | Attribute (validation) rule | No |
Yes | No | Yes (ArcGIS Pro 2.9 or later) |
Syntax
Parameter | Required | Description | Workflow |
---|---|---|---|
Subtype | No | The subtype to which the rule is applied. | Validation |
Attribute | No | A query that identifies the features to which the rule is applied. | Validation |
Attributes to Compare | Yes | A list of editable fields in the input data source that is used to evaluate for unique field values. | Validation |
Name | Yes | A unique name for the rule. This information is used to support data quality requirement traceability, automated reporting, and corrective workflows. | Validation |
Description | No | A description you define of the error when a noncompliant feature is found. This information is used to provide guidance to facilitate corrective workflows. | Validation |
Severity | No | The severity of the error assigned when a noncompliant feature is found. This value indicates the importance of the error relative to other errors. Values range from 1 to 5, with 1 being the highest priority and 5 being the lowest. | Validation |
Tags | No | The tag property of the rule. This information is used in rule authoring and management workflows to support traceability and reporting of data quality requirements. | Validation |
Notes
If you configure a rule with multiple fields, multiple conditions are displayed and separated by a semicolon in the same error result for the feature class.