Select to view content in your preferred language

Provide option to use domain values instead of codes when using the Summary Statistics tool

157
1
2 weeks ago
Status: Open
Labels (1)
GlennWolf2
Emerging Contributor

When doing a utility network conversion, it's extremely helpful to be able to compute summary statistics to validate the expected conversion counts for all GIS assets.

However, the current tool creates a table that has domain codes instead of values.  The workaround to this is to:

1) Add two new string columns AG and AT

2) Compute each new column to contain the domain value of Asset Group and Asset Type using arcade or python expressions

3) Run the Summary Statistics tool using the new columns

4) Copy the values into a spreadsheet

5) Delete the extra columns from the geodatabase

6) Repeat for each feature class

Thanks for your consideration!

1 Comment
MErikReedAugusta

As another workaround in the interim for those who aren't able to add fields to a schema, you could always copy the entry in the Domains List, paste it into the GDB that's receiving the results of your Summary Statistics, and add that domain to the field(s) in question in the resulting table.

But that's definitely a workaround and at least somewhat of a pain to do, so I definitely second the option of an Environment setting that can pull forward either Domain Codes or Domain Description/Aliases, according to user preference.  Setting the default value of that Environment setting to Codes would easily maintain backwards compatibility without need for any other changes.