topic Re: Street name abbreviation replacement script works only sometimes in ArcMap. in Python Questions

Street name abbreviation replacement script works only sometimes in ArcMap.

DamienDi_Vittorio — Sun, 12 Dec 2021 05:11:48 GMT

I am trying to write a field calculation script that changes road names with abbreviations to the full name. Example: Day Dr. => DAY DRIVE or Phillips Rd. => PHILLIPS ROAD. I wrote and tested the function in Jupyter notebook and everything works fine. I got the script to work on my points feature class but the same script will not work on the same field in my line feature class. Any suggestions?

def street_name_fix(StreetName):
    StreetName = StreetName.rstrip('.')
    if StreetName is not None:
        if StreetName != '': 
            if StreetName.split()[-1].upper() == 'RD':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'ROAD')

            elif StreetName.split()[-1].upper() == 'CIR':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'CIRCLE').upper()

            elif StreetName.split()[-1].upper() == 'DR':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'DRIVE').upper()

            elif StreetName.split()[-1].upper() == 'LN':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'LANE').upper()

            elif StreetName.split()[-1].upper() == 'CT':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'COURT').upper()

            elif StreetName.split()[-1].upper() == 'PL':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'PLACE').upper()

            elif StreetName.split()[-1].upper() == 'ST':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'STREET').upper()

            elif StreetName.split()[-1].upper() == 'BLVD':
                return '{} {}'.format(' '.join(StreetName.split()[:-1]), 'BOULEVARD').upper()
            
           

            else:
                return StreetName.upper()
    
        else:
            return ''
    
    else:
        return StreetName‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

PeteCrosier — Wed, 12 Dec 2018 12:57:19 GMT

It is failing because you are .split-ing a string that contains a single whitespace in to a list - the result of this is an empty list.

>>> a = u" "
>>> a.split()
[]

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

DamienDi_Vittorio — Wed, 12 Dec 2018 14:58:11 GMT

Thanks Pete Crosier‌! I guess check for the space string first? Any suggestions on how to do this for 1 or multiple spaces?

Cheers,
Damien

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

MichaelVolz — Wed, 12 Dec 2018 15:18:00 GMT

What is the business need to using the full name? Are you keeping the abbrevation and just adding the full name to a new field? I'm asking because ESRI's local government information model (LGIM0 which is used as the schema for out-of-the-box (OOTB) solutions uses abbreviations so you would want to keep the original field information if you ever plan to use the OOTB solutions. At the least just something to think about.

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

DanPatterson_Retired — Wed, 12 Dec 2018 15:21:59 GMT

throw this line at the top of your scripts

# -*- coding: utf-8 -*-‍

it is a caution for Unicode encoding vs other forms, especially if you are using python 2.7 and your data may have been developed in a post 2.7 world

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

DamienDi_Vittorio — Wed, 12 Dec 2018 15:30:16 GMT

I realized when I converted to ansi in Notepad++ that it would run. Maybe this is related.

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

DamienDi_Vittorio — Wed, 12 Dec 2018 15:30:46 GMT

This is how the client wants it in the end...

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

PeteCrosier — Sun, 12 Dec 2021 05:11:51 GMT

My solution would look something like this:

def street_name_fix(StreetName):
    replacements = {'RD': 'ROAD',
                    'CIR': 'CIRCLE',
                    'DR': 'DRIVE',
                    'LN': 'LANE',
                    'CT': 'COURT',
                    'PL': 'PLACE',
                    'ST': 'STREET',
                    'BLVD': 'BOULEVARD'}
                    
    StreetName = StreetName.upper().strip().rstrip('.')

    try:
        return '{} {}'.format(' '.join(StreetName.split()[:-1]), replacements[StreetName.split()[-1]])

    except IndexError:
        return StreetName
    
    except KeyError:
        return StreetName‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Street name abbreviation replacement script works only sometimes in ArcMap.

DamienDi_Vittorio — Wed, 12 Dec 2018 15:43:36 GMT

Pete Crosier‌ thank you so much! Much more Pythonic and simple!!! Much appreciated! This works beautifully!