Extracts a unique list of values from an attribute table and converts it into an coded value domain.

convertListToCVD.py

#
# @date 31/05/2013
# @author Cindy Williams
#
# Extracts a unique list of values from an attribute table
# and converts it into an coded value domain.
#
# For use as a script tool in an ArcGIS Toolbox.
#

import arcpy

# Input variables
inTable = arcpy.GetParameterAsText(0) # Table containing domain values
gdb = arcpy.GetParameterAsText(1) # GDB that will contain the new domain

# Build unique list of code descriptions
lst = set([row[0] for row in arcpy.da.SearchCursor(inTable,"TYPE")])
# Build list of code values
codeList = [f for f in range(0,len(lst)+1)] 
# Create dictionary of domain values
domDict = dict(zip(codeList,lst))

arcpy.management.CreateDomain(gdb, "cvdPointType", "Elec Point Type","SHORT","CODED")

# Populate coded value domain with <code: description> pairs
for code in domDict:
    arcpy.management.AddCodedValueToDomain(gdb, "cvdPointType", code, domDict[code])
    arcpy.AddMessage("Added coded domain value {0}:{1}".format(code, domDict[code]))
    
arcpy.AddMessage("Script tool complete.")