script to list domains and FC, Tables associated

JoseSanchez

Hello everyone,

I am looking for a script that lists all the domains and Feature Classes or tables where the domain is referenced.

Also I am interested also in passing as a parameter a specific domain name and listing all Feature Classes and Tables where the domain is referenced.

Thanks

RandyBurton

Here are a couple of scripts that I have used.  This one reads the domain information:

<SPAN class="keyword token">import</SPAN> arcpy

dbName <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\path\to\file.gdb"</SPAN> <SPAN class="comment token"># your geodatabase path</SPAN>

<SPAN class="keyword token">print</SPAN> dbName
<SPAN class="keyword token">print</SPAN>

domains <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>ListDomains<SPAN class="punctuation token">(</SPAN>dbName<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> domain <SPAN class="keyword token">in</SPAN> domains<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Domain name: {0}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>domain<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">if</SPAN> domain<SPAN class="punctuation token">.</SPAN>domainType <SPAN class="operator token">==</SPAN> <SPAN class="string token">'CodedValue'</SPAN><SPAN class="punctuation token">:</SPAN>
        coded_values <SPAN class="operator token">=</SPAN> domain<SPAN class="punctuation token">.</SPAN>codedValues
        <SPAN class="keyword token">for</SPAN> val<SPAN class="punctuation token">,</SPAN> desc <SPAN class="keyword token">in</SPAN> sorted<SPAN class="punctuation token">(</SPAN>coded_values<SPAN class="punctuation token">.</SPAN>iteritems<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0} : {1}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>val<SPAN class="punctuation token">,</SPAN> desc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">elif</SPAN> domain<SPAN class="punctuation token">.</SPAN>domainType <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Range'</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Min: {0}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>domain<SPAN class="punctuation token">.</SPAN>range<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Max: {0}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>domain<SPAN class="punctuation token">.</SPAN>range<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This one reads the field information.  Note specifically the field.domain property. 

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># Set the current workspace</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\path\to\file.gdb"</SPAN> <SPAN class="comment token"># your geodatabase path</SPAN>

<SPAN class="keyword token">print</SPAN> env<SPAN class="punctuation token">.</SPAN>workspace
<SPAN class="keyword token">print</SPAN>

<SPAN class="comment token"># Get the list of standalone tables in the geodatabase</SPAN>
<SPAN class="comment token">#</SPAN>
tableList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># for features</SPAN>
<SPAN class="comment token"># tableList = arcpy.ListTables() # for tables</SPAN>

<SPAN class="keyword token">print</SPAN> tableList
<SPAN class="keyword token">for</SPAN> table <SPAN class="keyword token">in</SPAN> tableList<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN>
    <SPAN class="keyword token">print</SPAN> table
    dbTable <SPAN class="operator token">=</SPAN> env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> table
    fieldList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\t['</SPAN>
    <SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fieldList<SPAN class="punctuation token">:</SPAN>
        <SPAN class="comment token"># print("\t{0} is a type of {1} with a length of {2}"</SPAN>
        <SPAN class="comment token">#     .format(field.name, field.type, field.length))  </SPAN>
        <SPAN class="comment token"># Print field properties</SPAN>
        <SPAN class="comment token">#</SPAN>
        <SPAN class="comment token"># print("Name:  {0}".format(field.name))</SPAN>
        <SPAN class="comment token"># print("\tBaseName:    {0}".format(field.baseName))</SPAN>
        <SPAN class="comment token"># print("\tAlias:       {0}".format(field.aliasName))</SPAN>
        <SPAN class="comment token"># print("\tLength:      {0}".format(field.length))</SPAN>
        <SPAN class="comment token"># print("\tDomain:      {0}".format(field.domain))</SPAN>
        <SPAN class="comment token"># print("\tType:        {0}".format(field.type))</SPAN>
        <SPAN class="comment token"># print("\tIs Editable: {0}".format(field.editable)) </SPAN>
        <SPAN class="comment token"># print("\tIs Nullable: {0}".format(field.isNullable)) </SPAN>
        <SPAN class="comment token"># print("\tRequired:    {0}".format(field.required))</SPAN>
        <SPAN class="comment token"># print("\tScale:       {0}".format(field.scale))</SPAN>
        <SPAN class="comment token"># print("\tPrecision:   {0}".format(field.precision))</SPAN>
        <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\t["'</SPAN> <SPAN class="operator token">+</SPAN> field<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">'",'</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">==</SPAN> <SPAN class="string token">"String"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'"TEXT", '</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'"'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'",'</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\"{0}\", "</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
            <SPAN class="keyword token">print</SPAN> '"<SPAN class="comment token">#",',</SPAN>
        <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'"'</SPAN> <SPAN class="operator token">+</SPAN> field<SPAN class="punctuation token">.</SPAN>aliasName <SPAN class="operator token">+</SPAN> <SPAN class="string token">'",'</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>domain<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'"'</SPAN> <SPAN class="operator token">+</SPAN> field<SPAN class="punctuation token">.</SPAN>domain <SPAN class="operator token">+</SPAN> <SPAN class="string token">'"],'</SPAN><SPAN class="punctuation token">,</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> '"<SPAN class="comment token">#",',</SPAN>
        <SPAN class="keyword token">print</SPAN> '"<SPAN class="comment token">#"],' # Default</SPAN>
    <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\t]'</SPAN>

<SPAN class="comment token"># Fields: [ 0:Name, 1:Type, 2:Size, 3:Alias, 4:Domain 5:Default ]  use "#" for blanks</SPAN>

<SPAN class="comment token"># Field type is returned as:</SPAN>
<SPAN class="comment token"># SmallInteger, Integer, Single, Double, String, Date, OID, Geometry, Blob‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

See also:

ListDomains

ListFeatureClasses

ListFields