idea List Domains in ArcGIS Pro Ideas

List Domains

PetreUrsaru — Mon, 29 Apr 2024 20:44:10 GMT

i'm working with a large geodatabase, where exists over 50 domains
my goal is to find each field that uses domains (name, type and description of the domain)

i know it is possible using python
however, a new geoprocessing tool would be very useful

Thanks,
Petre Ursaru - Esri Romania

Re: List Domains

RobertBorchert — Thu, 23 Apr 2015 19:53:44 GMT

ArcGisDiagrammer will show you these things.

It is not a terribly friendly program but it does this.

There used to be a database reporter tool for 9.3 that was the cats meow. It would list each feature class and the attributes and each domain for those attributes.

It was replaced by ArcGisDiagrammer. Yes it was a step backwards

Re: List Domains

KarenFolger — Wed, 28 Jun 2017 18:45:38 GMT

I am trying to write just such a tool in python but it keeps bombing when I do a describe on the fields for the layer. Anyone have any ideas? Code below

import arcpy
#
inWorkspaceString = arcpy.GetParameterAsText(0)
arcpy.env.workspace = inWorkspaceString
outTable = "OTHER_ListDomains_tbl"

# Delete old and Create new output table each time
if arcpy.Exists(outTable):
arcpy.Delete_management(outTable)
#
arcpy.CreateTable_management(inWorkspaceString, outTable)
arcpy.AddField_management(outTable, "DomainName", "TEXT", "", "", 255, "", "NULLABLE", "REQUIRED")
arcpy.AddField_management(outTable, "Feature_Class", "TEXT", "", "", 255, "", "NULLABLE", "NON_REQUIRED")
#
newRows = arcpy.InsertCursor(outTable, "") # Create cursor to store new rows for output table
arcpy.MakeTableView_management(outTable, "outTableView", "", "", "") # Create table view for output table (for searching for existing records)
#
layers = arcpy.ListFeatureClasses() # Adds feature classes to list
for layer in layers:

   desc = arcpy.Describe(layer)
   if desc.featureType == "Simple":
# Create list of fields
      fields = arcpy.ListFields(layer)
      for field in fields:
         descf = arcpy.Describe(field)
         dom = descf.domain
# Write items from list to output table if they don't already exist there
         arcpy.SelectLayerByAttribute_management("outTableView", "NEW_SELECTION", "\"DomainName\" = \'" + dom + "\' AND \"Feature_Class\" = \'" + layer + "\'")
         if int(arcpy.GetCount_management("outTableView").getOutput(0)) == 0:
            newRow = newRows.newRow()
            newRow.DomainName = dom
            newRow.Feature_Class = layer
            newRows.insertRow(newRow)
del newRows # Removes lock on output table

Re: List Domains - Status changed to: Implemented

KoryKramer — Thu, 01 Jul 2021 16:14:53 GMT

The ability to identify domain usage was added in ArcGIS Pro.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-domains.htm#ESRI_SECTION1_09CF28B04D4547849DD3A0C15381D558