topic Re: How can i find not members of the domain value in Data Management Questions

How can i find not members of the domain value

GIS_Solutions — Tue, 16 Nov 2021 12:15:01 GMT

Hi all,

How can I detect data entries that are not members of the domain value field.

For example, the "PARCEL" content written in the Ownership field in the attached image is not defined in the domain assignment. I want to detect all records that warn me with red like this. How can I do that.

Re: How can i find not members of the domain value

MelissaJarman — Tue, 16 Nov 2021 13:33:09 GMT

Attribute rules could work for this to run check on your existing data - validation rules.

Data Reviewer also has domain checks for this.

Re: How can i find not members of the domain value

Matt-Huser — Fri, 19 Nov 2021 21:42:41 GMT

I agree that Data Reviewer and Attribute Rules are the better option when it comes to long term data quality and mistake proofing workflows. However, for a quick analysis, ArcMap made it really easy to spot incorrect domain values in the Select By Attribute tool. In my example below, the "Village of Itasca and Village of Schaumburg" were added incorrectly. Visually it is super straightforward to spot them in ArcMap since they don't have the format of [Code - Description]. As far as I can see, ArcGIS Pro does not mimic this functionality with the same tool unfortunately.

Someone asked about this functionality for ArcGIS Pro here

Re: How can i find not members of the domain value

MelissaJarman — Wed, 24 Nov 2021 19:14:30 GMT

I hadn't thought about doing it that way with the Select By Attribute tool. It looks like this equivalency idea you linked is under consideration.

I also found out that you can make a selection in the map view and then use the Attributes pane > Selection tab. When you initially open the Attributes pane it will give a warning about the violation of the attribute domain.

From here you can further use the context menu to change the selection to ONLY include the invalid features.

https://pro.arcgis.com/en/pro-app/latest/help/editing/edit-feature-attributes.htm#ESRI_SECTION1_8F13A8C397F349C9BF97D3DF2353E69F

Re: How can i find not members of the domain value

KG_427 — Wed, 04 Mar 2026 14:16:45 GMT

Whoops - editing my own reply. I wasn't seeing it at first but my selection was wrong. It's still there!