topic Re: Fixing attributes...from St to Street in Data Management Questions

Fixing attributes...from St to Street

VaneiriKeme — Mon, 04 Jan 2016 21:10:07 GMT

Hi,

I am trying to fix my attribute records in Arcmap.

Is there a way to do a bulk fixing, to find all my St and change it to Street?

Re: Fixing attributes...from St to Street

DarrenWiens2 — Mon, 04 Jan 2016 21:11:27 GMT

There is Find and Replace in Table options.

Re: Fixing attributes...from St to Street

ChrisDonohue__GISP — Mon, 04 Jan 2016 21:12:07 GMT

Yes, this can be done in Python. The Python code can be placed in the field calculator, or a pure Python run can be done.

Chris Donohue, GISP

Re: Fixing attributes...from St to Street

JoeBorgione — Mon, 04 Jan 2016 21:14:03 GMT

Or select thuroghfare trailingtype = 'ST' and then calc thuroghfare trainingtype = "STREET"

Re: Fixing attributes...from St to Street

ChrisDonohue__GISP — Sat, 11 Dec 2021 23:53:30 GMT

Here's a simple Python field calculator example:

!fieldnamehere!.replace(' ST', ' STREET')

Longer example for addressing multiple changes. Use your fieldname instead of FacilityAddress.

def StreetSuffix(FacilityAddress):
  list = FacilityAddress.split()
  for item in range(len(list)):
    if list[item] == 'STREET':
      list[item] = list[item].replace("STREET", "ST")
    if list[item] == 'STREET,':
      list[item] = list[item].replace("STREET,", "ST")
    if list[item] == 'STR.':
      list[item] = list[item].replace("STR.", "ST")
    if list[item] == 'STR,':
      list[item] = list[item].replace("STR,", "ST")
    if list[item] == 'ST.':
      list[item] = list[item].replace("ST.", "ST") 
    if list[item] == 'ST,':
      list[item] = list[item].replace("ST,", "ST")
    if list[item] == 'WAY':
      list[item] = list[item].replace("WAY", "WY") 
    if list[item] == 'WAY,':
      list[item] = list[item].replace("WAY,", "WY") 
    if list[item] == 'WY.':
      list[item] = list[item].replace("WY.", "WY")
    if list[item] == 'WY,':
      list[item] = list[item].replace("WY,", "WY")
  return " ".join(list)

Credit to Darren Wiens and several others knowledgeable in Python for coming up with this, which I gratefully stole borrowed.

Chris Donohue, GISP

Re: Fixing attributes...from St to Street

VaneiriKeme — Mon, 04 Jan 2016 21:54:58 GMT

Thanks Darren!

Re: Fixing attributes...from St to Street

VaneiriKeme — Mon, 04 Jan 2016 21:55:34 GMT

Got it fixed. Saved me tons of hours.

Re: Fixing attributes...from St to Street

DarrenWiens2 — Sat, 11 Dec 2021 23:53:32 GMT

Now that I see this again, a more compact alternative may be (only lightly tested):


def StreetSuffix(FacilityAddress):  
  replace_dict = {
    'ST':['STREET','STREET,','STR.','STR,','ST.','ST,'],
    'WY':['WAY','WAY,','WY.','WY,']
  }

  list = FacilityAddress.split()  
  for item in range(len(list)):
    for key, value in replace_dict.iteritems():
      if list[item] in value:
        list[item] = key
  return " ".join(list)

Re: Fixing attributes...from St to Street

JonM32 — Tue, 08 Oct 2024 18:52:03 GMT

@ChrisDonohue__GISP

I just wanted to thank you for posting this field calculator expression. I needed to update addresses in a single field to change all abbreviations to fully spelled out words. I used this expression in ArcGIS Pro, created a list of changes I needed, and updated over 16000 records with little issues. It worked great!! A huge time saver, and I learned some good skills from it.

Thank you!

Jon