Select to view content in your preferred language

Export features with domain descriptions as text

1673
4
09-22-2023 07:35 AM
EmmaVWKnowles
Emerging Contributor

Hi, I am trying to export features from a geodatabase with all fields containing domains as text descriptions instead of coded values (because I need to integrate this with other datasets that use different codes for the same values; and because I would like to use tools such as Union which don't have the option to preserve domains).

I have found a solution by using the "Feature class to feature class" tool - when I tick "Transfer field domain descriptions" in the environments for this tool, it makes a copy of the domains as text descriptions (in new fields with d_ as a prefix to their titles) as well as preserving the domains for the coded columns. Ticking the same box in the environment for Export Features does not produce a copy of the domains as text, it just preserves the connection the domains. But there is a note in the Feature Class to Feature Class tool saying that it is going to be removed in future versions. How are you going to allow people to keep domains, (without having to do table joins and manually update them every time, which is several additional steps)?

Please can you allow the option to create a domains-as-text field when exporting features?

And, ideally, can we have the option to preserve domains when running Union and Intersect queries as well.

4 Replies
kzoumis
Emerging Contributor

You can add a new text field to hold the descriptions and use the following arcade expression from field calculator. It will return the domain descriptions for the domain assigned to the "Field-Name".

DomainName($feature, 'Field-Name')

EmmaVWKnowles
Emerging Contributor

Thanks, that is helpful. It would still be useful and efficient to have adding and updating the domains-as-text fields as a single step integrated with exporting a copy or running a query - especially in situations where there are several fields with domains so that even identifying them all to add to a code takes a bit of messing about.

AhmedSaad
Emerging Contributor

Yes ... that would have been helpful. 

0 Kudos
Bud
by
Esteemed Contributor

I think this would be better as an idea, not a questionhttps://community.esri.com/t5/arcgis-pro-ideas/idb-p/arcgis-pro-ideas

You can either create a new idea. Or ask a moderator to convert this question to an idea:

Bud_0-1713455881854.png

Bud_1-1713455899779.png

 

 

0 Kudos