Assign Domain To Field (Data Management)

Summary

Sets the domain for a particular field and, optionally, for a subtype. If no subtype is specified, the domain is only assigned to the specified field.

Usage

• Domain management involves the following steps:

  1. Create the domain using the Create Domain tool.
  2. Add values to or set the range of values for the domain using the Add_Coded_Value_to_Domain tool or Set Value For Range Domain tool.
  3. Associate the domain with a feature class using this tool.

• When an attribute domain is associated with a table or feature class, an attribute validation rule is created in the database. This attribute validation rule describes and constrains the valid values of a field type.

• One attribute domain can be associated with multiple fields in the same table, feature class, or subtype as well as in multiple tables and feature classes.

• The Input Table parameter accepts feature layers or table views.

• Workspace domains can also be managed in ArcCatalog or the Catalog window. Domains can be created and modified through the Domains tab on the Database Properties dialog box.

• The Subtype parameter Add Value button is used only in ModelBuilder. In ModelBuilder, where the preceding tool has not been run, or its derived data does not exist, the Subtype parameter may not be populated with values. The Add Value button allows you to add expected values so you can complete the Assign Domain To Field dialog and continue to build your model.

Syntax

AssignDomainToField_management (in_table, field_name, domain_name, {subtype_code})

Parameter	Explanation	Data Type
in_table	The name of the table or feature class containing the field that will be assigned a domain.	Table View
field_name	The name of the field to be assigned a domain.	Field
domain_name	The name of a geodatabase domain to assign to the field name. Available domains will automatically be loaded.	String
subtype_code [subtype_code,...] (Optional)	The subtype code to be assigned a domain.	String

Code Sample

Assign Domain to Field Example (Python Window)

The following Python window script demonstrates how to use the AssignDomainToField function in immediate mode.

import arcpy
from arcpy import env
env.workspace = "C:/data"
arcpy.AssignDomainToField_management("montgomery.gdb/Landbase/Parcels", "ZONING_S", "ZoningFields", "1: government")

Assign Domain to Field Example 2 (Stand-alone Script)

The following script uses the AssignDomainToField function as part of a workflow to create an attribute domain, assign values to the domain, and assign the domain to a field.

# Name: MakeDomain.py
# Description: Create an attribute domain to constrain pipe material values
# Author: ESRI

 
#Import system modules
import arcpy
from arcpy import env
 
try:
    # Set the workspace (to avoid having to type in the full path to the data every time)
    env.workspace = "C:/data"
 
    # Set local parameters
    domName = "Material4"
    gdb = "montgomery.gdb"
    inFeatures = "Montgomery.gdb/Water/Distribmains"
    inField = "Material"
 
    # Process: Create the coded value domain
    arcpy.CreateDomain_management("montgomery.gdb", domName, "Valid pipe materials", "TEXT", "CODED")
    
    #Store all the domain values in a dictionary with the domain code as the "key" and the 
    #domain description as the "value" (domDict[code])
    domDict = {"CI":"Cast iron", "DI": "Ductile iron", "PVC": "PVC", \
                "ACP": "Asbestos concrete", "COP": "Copper"}
    
    # Process: Add valid material types to the domain
    #use a for loop to cycle through all the domain codes in the dictionary
    for code in domDict:        
        arcpy.AddCodedValueToDomain_management(gdb, domName, code, domDict[code])
    
    # Process: Constrain the material value of distribution mains
    arcpy.AssignDomainToField_management(inFeatures, inField, domName)
 
except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message

Environments

Auto Commit, Current Workspace

Licensing Information

ArcView: Yes

ArcEditor: Yes

ArcInfo: Yes