Problem: Coded value domain descriptions are not maintained after exporting data

Description

When exporting the table of a feature class with coded value domain descriptions in ArcMap, the coded value is displayed instead of the descriptions.

Cause

This is a known limitation. ArcGIS, by default, exports domain codes instead of domain descriptions.

Solution or Workaround

Select one of the solutions shown below. Option A allows the particular table to display the coded value domain descriptions, whereas Option B allows all tables exported to display the coded value domain descriptions. Option C can be used to display both coded domain values and descriptions.

Option A

1. Open the exported table.
2. Click Table Options > Appearance.
3. Check the Display coded value domain and subtype descriptions check box.
   The coded value domain descriptions are displayed.

Option B

Change the Environment settings, and use the Table to Table tool.

1. Click the Geoprocessing menu > Environments. This opens the Environment Settings window.
2. Click Fields, and check the Transfer field domain descriptions check box. Click OK.

3. Navigate to Conversion Tools in the Catalog window > To Geodatabase > Table to Table.
4. Select a table as the input, and specify the output location and the name of the output table. Click OK.

Option C

1. Use the Domain to Table tool to export the domain and domain descriptions.
2. Join the table to the source feature class.
3. Export the joined table to a shapefile.

Note:
Option C adds a new field for domain descriptions. For more information on exporting a feature class to a shapefile containing domain descriptions instead of domain codes, refer to the following article, HowTo: Export a feature class to a shapefile that contains domain descriptions instead of domain codes.

Related Information

• An overview of the Domains toolset
• Domain to Table tool
• ArcGIS Help: Creating a new coded value domain
• HowTo: Display coded value domains and subtype codes instead of descriptions
• HowTo: Export a table to include domain descriptions and coded values
• Problem: Exporting a feature service with domains to a CSV file shows coded values instead of descriptions

Last Published: 3/25/2018

Article ID: 000012593

Software: ArcMap 10.3.1, 10.3