topic Re: Remove predirectional from attribute table in Python Questions

Remove predirectional from attribute table

CCWeedcontrol — Fri, 10 Dec 2021 20:21:37 GMT

I have a table that i am trying to remove just the street predirectional's of the table. I have the following code but it removes more than just the predirectional's from the street name. For example N St Alphonusu Way to turn into T Alphonsus Way. I just want to remove the "N", "E", "W" & "S" from the street name. How can do this correctly?

lyr = "C:\Temp\Default.gdb\CurrntRoadNamesTableTest_1"


for field in arcpy.ListFields(lyr, "*", "String"):  
    with arcpy.da.UpdateCursor(lyr, ['STREET']) as cursor:  
        for row in cursor:  
          s = row[0]
          row[0] = s.lstrip('W ')
          a = row[0]     
          row[0] = a.lstrip('E ')
          b = row[0]
          row[0] = b.lstrip('N ')
          X = row[0]
          row[0] = X.lstrip('S ')

          cursor.updateRow(row)
del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Remove predirectional from attribute table

MitchHolley1 — Fri, 10 Dec 2021 20:21:40 GMT

This is a quick/dirty way to do it. I'm sure there is a more elegant way.

lyr = "C:\Temp\Default.gdb\CurrntRoadNamesTableTest_1"

preDir = ['N ','S ','E ','W ']

#for field in arcpy.ListFields(lyr, "*", "String"): <- i don't know why you need this 
with arcpy.da.UpdateCursor(lyr, ['STREET']) as cursor:  #since you're specifying field in cursor item
    for row in cursor:
        if row[0][:2] in preDir:
            row[0] = row[0][2:]
            cursor.updateRow(row)
del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Remove predirectional from attribute table

CCWeedcontrol — Thu, 12 Apr 2018 15:43:51 GMT

can you explain what lines 8 & 9 are doing please?

Re: Remove predirectional from attribute table

JoshuaBixby — Thu, 12 Apr 2018 15:56:59 GMT

In Python, strings are a sequence type (Sequence Types — str, unicode, list, tuple, bytearray, buffer, xrange), and sequences support slicing, which is what lines 8 & 9 is doing. row[0] returns the first item in a list, which happens to be a string in this case, and [2:] slices the string.

Re: Remove predirectional from attribute table

CCWeedcontrol — Fri, 20 Apr 2018 18:37:43 GMT

So after a closer look it seems as this is remove a lot of street names what begin with 'N ','S ','E ','W ' not just the pre directionals. Any ideas?

Re: Remove predirectional from attribute table

JoshuaBixby — Fri, 20 Apr 2018 18:53:48 GMT

Can you give a few sample addresses, especially ones you are having issues with?

Re: Remove predirectional from attribute table

CCWeedcontrol — Mon, 23 Apr 2018 16:18:12 GMT

I need to remove just the pre-directionals and keep the name.

Thanks.

E El Jay Ct --> El Jay Ct

E Elgin St --> Elgin St

E Elk River St --> Elk River St

Re: Remove predirectional from attribute table

CCWeedcontrol — Fri, 10 Dec 2021 20:21:43 GMT

I have some what of a solution starting at line 9 - 12 but the problem is that i am not sure how to do more than just one at a time.

currently the following just does 'N ', i need it to do 'N ','S ','E ','W '. How can accomplish this?

'''
prefixes = ('N ','S ','E ','W ')
with arcpy.da.UpdateCursor(lyr, 'STREET') as cursor:
    for street, in cursor:
        if street and street.lstrip(prefixes):
            cursor.updateRow()
'''

field = 'STREET'
for field in [f.name for f in arcpy.Describe(lyr).fields if f.type == "String"]:  
    exp = "!{0}!.strip('N ')"  
    arcpy.management.CalculateField(lyr, field, exp.format(field), "PYTHON")
‍‍‍‍‍‍‍‍‍‍‍‍