Domain Code and Description Attribute Query Problem

Discussion created by Wolseley on Jul 20, 2013
Latest reply on Jul 27, 2014 by rfairhur24
I added a Domain to the Location Field in our Abandoned Pipes Feature Class. When I go to Select By Attributes, choose Location field, and unique attribute, I am seeing the field values derived from the Domain. But, I also see the Domain Code and Description shown like this:

Bur - Buried

Why is the Code shown alone, then Code and Description shown together? not for all the values, just the buried. This problem also occurs with different domains across all my Feature Classes. I would assume that the values shown should all be either the Code OR the Description, not a mix of the two.

When I choose "Buried" it selects all the records, but 4. When I choose "Bur - Buried" it selects only 4 records. I checked the field values in the attribute table and they all show the Description (Buried). I then switched to have them show the code, and they show "Bur".

The problem is only with this one Domain Code, the other Codes and Descriptions are ok.

See the attached screen capture for a better explanation.

I am using ArcGIS Desktop Advanced 10.1, ArcGIS Server Enterprise Standard 10.1, ArcSDE 10.1, SQL Server Express 2008 R2.

I have not installed 10.1 SP1.