topic Editing Attribute Values in ArcMap Questions

Editing Attribute Values

JD1016 — Wed, 12 Oct 2022 11:07:26 GMT

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

Re: Editing Attribute Values

Kara_Shindle — Wed, 12 Oct 2022 13:05:08 GMT

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.

Re: Editing Attribute Values

JD1016 — Wed, 12 Oct 2022 12:39:12 GMT

Hi Kara,

Your code suggestion worked perfectly!

As a follow-up, is there a way to select all instances of the words "N Maple"? Otherwise, I will have to manually select 101 N Maple, 102 N Maple, 103 N Maple,...you get the idea.

Thanks.

Jeff

Re: Editing Attribute Values

Kara_Shindle — Wed, 12 Oct 2022 12:53:48 GMT

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%'

Re: Editing Attribute Values

JD1016 — Wed, 12 Oct 2022 12:57:52 GMT

PERFECT!

I had employed the use of the LIKE operator with the percent sign before but I had the percent "only" at the end of the code and therefore it would look for those beginning with that instead of ending. In adding the other %, everything was selected regardless of position.

Thank you, Kara!