field calculator python script with coded values

Question

I am trying to run a field calculator python script that will take a value from one field in the attributes table and create an abbreviation in another field that was designated for it.

Here is a example of the code that was written for this function:

def checkValue(c,d):
    if c == 'ARTERIAL_CRACKSEAL':
        return 'ACS'

The problem is that once I created coded value domains for these attributes the code stopped working (i.e. code:1 description: ARTERIAL_CRACKSEAL ; code:2 description ARTERIAL_microseal ; etc.). Would anyone know how to adjust the code so the script runs successfully? I need to keep coded value domains for this attribute field.

Answer 1

In a coded value domain, the values are stored as 1, 2, 3 and not as ARTERIAL_CRACKSEAL, ARTERIAL_MICROSEAL, ARTERIAL_OVERLAY.

To make your code work with the coded values, change your if lines to refer to the codes:

def checkValue(c, d):
    if c == 1:
        return 'ACS'
    if c == 2:
        return 'AMS'
    if c == 3:
        return 'AOL'
    if c == 4:
        return 'TRM'
    if c == 5:
        return 'FST'