Editing Attribute Values

Question

Hello,

I have a parcel attribute table with a field containing addresses.  In several instances, it appears the street type designation has been left off.  For instance, "101 N Maple" should actually be "101 N Maple Avenue".

Is there a way, without having to go through each record in the attribute table, to add the word "Avenue" every time there is a "N Maple" occurrence?

Thank you in advance!

Jeff

Kara_Shindle · Accepted Answer

I can think of a Python way and a non-Python way.  Let's start with the non-Python one.

I would select by attribute all records that have "101 N Maple" in them.  Then, change your attribute view to only the selected features, and do a Field Calculator session on only your selected values.

In field calculator, you can calculate a field using it's existing values.  So if your field name is something like

!Street!

Then your expression will be something like

!Street! + ' Avenue'

Notice I added a space before avenue in the string you are adding on, but that is dependent on if you have a space already in there or not.

Make sure you chose the Python and doublecheck your edits before you save everything to make sure it worked.

Kara_Shindle · Accepted Answer

Yes, I would use your wildcard character and the LIKE operator to build a SQL Query.  In ArcMap, that is the percent sign or %

Here's an article to get you started. https://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm#GUID-EC06FE3F-38BA-4CF2-AEAF-F69D65C7C567

I'm searching for all rows that in my street address field that have the word Church in them.  I put the wildcard before AND after church, because I know it has street numbers and road types on either side of the road name I'm looking for.

SITUSAddress1 LIKE '%CHURCH%'