topic Re: Attribute Editing in ArcGIS Pro Questions

Attribute Editing

GISIntern21 — Mon, 17 Mar 2025 16:07:23 GMT

Hello!
I need some assistance with how to edit a few attributes. I did a calculate field process that worked, but it duplicated some of my values in the process. I am editing some data in relation to streets and street types, so some of my values now have duplicated street type information. What are a few ways I can go about editing this? I am working on this through ArcGIS Pro.

Thanks!

Re: Attribute Editing

ZachBodenner — Mon, 17 Mar 2025 16:16:08 GMT

Looks like your field calculator was something like NAME + " " + TYPE? You'll notice that 905th Park Rd for example already has Rd in the NAME field, so when you tacked on TYPE, you got two "Rd"s. Depending on how big your dataset is, you might want to sort through and remove those. You could do a Select By Attribute NAME LIKE '%RD' which will highlight all instances where there is text where the last two characters are RD. Then just change for all your different street types.

Re: Attribute Editing

JamesPoeschel — Tue, 18 Mar 2025 15:27:53 GMT

If you did NAME + " " + TYPE to calculate the RoadName field, you need to clean up your NAME field first. I'd recommend using the arcade Replace function or the .replace python method. You could replace " RD", " AVE", " TRAIL", " CIR", etc. with "", to remove all the types from the name field.. since the type is already in the type field. Making sure to include the space before the road type.

Then you can do NAME + " " + TYPE

Re: Attribute Editing

GISIntern21 — Tue, 18 Mar 2025 16:18:40 GMT

Thank you!! Would I utilize this with an if/else statement? How would the formatting look for a replace function?

Re: Attribute Editing

GISIntern21 — Wed, 19 Mar 2025 14:14:40 GMT

When removing/replacing the duplicate values in the NAME field, how would I format a script that would obtain this objective? I'm still very new to Python, and the help pages I've looked at so far have directed me to utilize a Reclassification to change those values. Is this the correct method to utilize? I've used the .replace() to initially change values such as 'Block' to 'BL,' so I would assume I would have to use that function to some degree to replace 'DR' to ' ' as an example.

Re: Attribute Editing

ZachBodenner — Wed, 19 Mar 2025 14:24:43 GMT

You could use an Arcade replace function.

// Set up the street name var n = NAME // Search NAME for the string ' St' and replace with no characters. Repeat for other street types. var r = replace(NAME,' St','') return r