I have a point feature class in an SQL Server Geodatabase that we use for day-to-day analysis. Occasionally we receive request for copies of our data from the public and send them shapefiles. If I export to a shapefile directly the coded values are what is written. I want to find a way to produce the shapefile with the textual description of the coded values in the coded value domain in the geodatabase.

class = 00053

Attribute Table:
class = Gravel Street

Screenshot of Database Properties with coded values.

It looks like ESRI's Production Mapping Extension has a tool that could do the trick but want to avoid purchasing an extension if possible.

How can I do this?

  • 2
    The simplest means would be to use lookup tables to map codes to text, and a view to expose the text instead of the codes, then export from the view. But be careful -- dBase has a number of restrictions that make it unsuitable for export, including column name width, datetime support, string field width limitation, numeric null support, and a 4000 byte table width limitation. Any of these could impact your export process. – Vince Jul 26 '16 at 17:44
  • 1
    You could use this: desktop.arcgis.com/de/arcmap/10.3/tools/data-management-toolbox/…, then join the two tables and export the layer to a shapefile. – Andreas Müller Jul 26 '16 at 19:29

Found a solution that worked for me and though I would share it.

  1. Feature Class to Shapefile tool in ArcMap
  2. Set input and output of files
  3. Edit the Environments...
  4. Check the box next to Transfer field domain descriptions

enter image description here

This will export the data and write the description as values instead of the code.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.