How to Update AssetTypceCode field at a time for all feature class

Question

Dear Friends,

Here Attached for gdb & Asset_Type_Code Excel sheet.

I have number of Datasets & feature class in that feature class have Asset Type Code field. Each subtype have asset_type_code in the excel sheet .How can update at a time for all feature class and Subtypes.

Example : See the Image or SW_Fitting Feature class.

Thanks

Santhosh

Asset_TypeCode.xlsx

COBW_WS_FA_HVAC_SO_SW_FP.gdb.rar

ClintonDow1 · Answer

The reason dictionary keys must be cast to a tuple is because the keys must be hashable - since the items in a list can be added/deleted/swapped after instantiation it is considered 'mutable' meaning the values can be changed. A tuple is 'immutable', meaning that they can't be changed. Namedtuples are handy as keys in lots of cases.  A frozenset is another acceptable collection to use as a key.

These objects can only be used for keys if their contents are hashable objects as well (implements __hash__), if you define a class without that method, it can't be used in a key.

RandyBurton · Answer

Thanks, Richard.  I'll check out the blog post you mentioned. And I've noticed several other of your postings that I want to check out, too.

RichardFairhurst · Answer

Randy:

Thanks for trying out code based on my Blog.  I wanted to mention that since I wrote my Turbo Charging blog that I discovered that a composite key in a dictionary does not have to be concatenated into a string and can contain multiple values of any field type if you cast the list of values to a tuple.  This means that the dictionary tuple keys will sort according to the native data type rules of each tuple component value and each component that makes up the dictionary key can be directly referenced with a tuple index.  My Multiple Field Key to Single Field Key tool uses a tuple dictionary key to create a single field value in two data sources that can be used to create a standard join and that will sort the same way that the set of original fields would sort, with an ascending or descending sort independently applied to each field.  That tool also optionally supports string matching that is case insensitive and that trims white space from one or both ends of the string.