ArcGIS converting list of enumeration in single field of s-57 data?

Question

Im storing s-57 data in an MDB which is being symolised via a layer. Some attributes in s-57 data can be a list of enumerations and I want to find a way to show the actual values the enumeration represents, please see example below.

My feature has a column called colour, this can be represented as a single number (i.e. 1 = white) or it can be represented by a list (ie. 2,3,2 = black, red, black).

I have included the enumeration table in the MDB which has values similar to those shown below.

VALUE COLOUR

1 white

2 black

3 red

where a single colour is listed in the field a simple join to the enumeration table works fine and I can set it up so the users see the full attribute values instead of the enumeration but when a list of enumerations I still need to convert it to full attribute values, is this possible?

so in summary if I have a colour field that contains '2,3,2' using the enumeration table above I would like to be able to get the layer to display black, red, black instead of 2,3,2 in the attribute table, is this possible?

Answer 1

In Field Calculator, you can try this Python code:

",".join({"1":"White","2":"Black","3":"Red"}[val.strip()] for val in !INPUT_FIELD_NAME!.split(","))

All you need to do is to pick your enumeration field for !INPUT_FIELD_NAME! and make sure you are using Python Parser!

UPDATE

---

OK, the below is another solution by creating a look-up table (dbf table in this case) to join your original data in ArcMap. I have not tested it but should work in built-in Python Interpreter.

Create a dbf file in a temporary location and add two fields for look-up.

look_up_table=arcpy.CreateTable_management(r"C:\Temp","s_57_LookUp.dbf")[0]
look_up_fields=["Color_Coded","Color_Expanded"]
for field in look_up_fields:
    arcpy.AddField_management(look_up_table,field,"TEXT",field_length=255)

Collect unique colour entries and add them into look-up table.

source_s_57_file=r'C:\Temp\Scratch.mdb\My_s57_file' #YOUR TABLE
look_up_values=[]
ins_cursor=arcpy.InsertCursor(look_up_table)
with arcpy.da.SearchCursor(source_s_57_file,"Color") as cursor: #THE FIELD WHERE COLOR INFO IS GIVEN CODED
    for row in cursor:
        if row[0] not in look_up_values:
            look_up_values.append(row[0])
            ins_row=ins_cursor.newRow()
            [ins_row.setValue(field,val) for field,val in zip(look_up_fields,[row[0],",".join({"1":"White","2":"Black","3":"Red"}[val.strip()] for val in row[0].split(","))])]
            ins_row.insertRow(ins_row)

del ins_cursor

I hope you would not come across any 64-bit geoprocessing issue as explained here.