topic Re: Sort the 'Coded Values' of Domains in Geodatabase in Data Management Questions

Sort the 'Coded Values' of Domains in Geodatabase

MG — Thu, 05 Dec 2013 19:37:33 GMT

Does anyone know how to sort the values in the drop-down list in the attribute table of a feature, or to sort the 'Coded Values' of Domains in geodatabase?

Re: Sort the 'Coded Values' of Domains in Geodatabase

WilliamCraft — Thu, 05 Dec 2013 23:18:14 GMT

I believe the domain values are sorted by their code rather than their description. To change the sort order such that it displays differently within the attribute table's drop-down menu, I believe you would need to refine which codes match up to which descriptions. This is typically done via ArcCatalog when logged in as an administrator such as the SDE user. Once connected, right click the geodatabase and then choose Properties. Select the Domains tab and then select the domain associated with the field in question. Toward the bottom of the dialog box, I recommend copying and pasting the various descriptions into the appropriate lines that match up with the numeric code.

Re: Sort the 'Coded Values' of Domains in Geodatabase

RussellBrennan — Mon, 09 Dec 2013 17:08:13 GMT

There is a tool available to sort coded value domains named 'Sort Coded Value Domain' it can be used to sort on either the code or the description in either ascending or descending order.

http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000016t000000

Re: Sort the 'Coded Values' of Domains in Geodatabase

JeffLegato — Fri, 10 Jan 2014 19:38:52 GMT

There is a tool available to sort coded value domains named 'Sort Coded Value Domain' it can be used to sort on either the code or the description in either ascending or descending order.

http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000016t000000

Perfect. Thanks!

FYI, the tool needs an exclusive schema lock on the domain to work.