topic Re: Arcpy-Check a row for hyphens in Python Questions

Arcpy-Check a row for hyphens

DianneGray — Thu, 03 Mar 2016 19:49:49 GMT

Hi Everyone,

I'm trying to do something fairly simple with Python (ArcGIS 10.3): populate a field called StreetNum with street addresses taken from a field called StreetAddr. However, some street addresses have a one-digit unit number surrounded by spaces before the unit number (e.g. 3 - 560 Main St) and I want only the street number to appear in the StreetNum field. So in other words, I want to populate StreetNum based on criteria: if there is a hyphen present in the string for a particular row in StreetAddr, then calculate the StreetNum by skipping the first 4 values of StreetAddr; otherwise, use the values of StreetAddr the way they are.

I've tested the cases and they work. However, I cannot come up with the proper criteria to check for a hyphen in a given row (no matter how I change my criteria, the script either passes or fails all rows). How would I correctly word my loop criteria?

# Insert Search Cursor into StreetAddr field

rows = arcpy.SearchCursor(fc,["StreetAddr"])

# Check for hyphens in this field

for row in rows:

if "-" in str(row):

#Calculate the field by removing the unit number and hyphen from StreetAddr

arcpy.CalculateField_management(in_table=fc, field="StreetNum", expression="Mid( [StreetAddr],5 )", expression_type="VB", code_block="")

else:

#Calculate the field by taking the content from StreetAddr

arcpy.CalculateField_management(in_table=fc, field="StreetNum", expression="[StreetAddr]", expression_type="VB", code_block="")

del rows

del row

Re: Arcpy-Check a row for hyphens

JakeSkinner — Sat, 11 Dec 2021 09:08:55 GMT

Hi Dianne,

You can accomplish this using the Field Calculator. Ex:

Pre-logic script code:

def calc(field1):
  if "-" in field1:
    return field1.split(" ", 2)[-1]
  else:
    return field1

StreetNum=

calc(!StreetAddr!)

Be sure 'Python' is checked at the top of the field calculator:

Re: Arcpy-Check a row for hyphens

DianneGray — Thu, 03 Mar 2016 22:15:16 GMT

Hi Jake,

Can you please explain the syntax of split? What do the numbers 2 and -1 correspond to?

I tried using that section of code, but Field Calculator ended up calculating all records to match StreetAddr (in other words, nothing passed the test). Why would this be the case? There are two records that have unit numbers, and all I want is the street numbers without the unit number (e.g. 7 - 364 Lougheed Rd should become 364 Lougheed Rd) (I realize my wording above might have been a bit confusing). I know I could fix this manually but for acquiring more Python experience I'd like to know how to address this with Python. What else could you suggest?

Re: Arcpy-Check a row for hyphens

DanPatterson_Retired — Thu, 03 Mar 2016 22:31:25 GMT

if it were as simple as one case, why don't you examine the following conceptually

>>> x

'3 - 560 Main St'

>>> "- " in x

True

>>> y = x.split("- ")[1]

>>> y

'560 Main St'

Note, I am checking for "dash space" not just "dash"

If found (True), then split on the aforementioned and take the first fiddly bit (counting from 0... ergo the last piece of the split

Re: Arcpy-Check a row for hyphens

WesMiller — Fri, 04 Mar 2016 01:30:40 GMT

Have you thought about using the Standardize Addresses—Help | ArcGIS for Desktop tool and joining the table and calculating the desired results.

Re: Arcpy-Check a row for hyphens

JakeSkinner — Sat, 11 Dec 2021 09:08:58 GMT

The split method will split the string on a space (" "). The '2' in this syntax is telling the method to stop after the 2nd space is found. For example, take the following address:

7 - 364 Lougheed Rd

If I were to run the following:

text = '7 - 364 Lougheed Rd'
print text.split(" ", 2)

The following list would be returned:

['7', '-', '364 Lougheed Rd']

The '-1' in the syntax is going to return the last value in the list. In this case, it will return '364 Lougheed Rd'.

If you want to upload a sample of the data, I could take a look at it.

Re: Arcpy-Check a row for hyphens

JoshuaBixby — Fri, 04 Mar 2016 15:11:39 GMT

I second Wes's comment, especially since the tool is available at all licensing levels. There are also several Python-based packages that have similar functionality. I personally like usaddress, but I only work with US addresses.

Re: Arcpy-Check a row for hyphens

DianneGray — Fri, 04 Mar 2016 19:40:40 GMT

So here are the addresses that get calculated into StreetNum directly from StreetAddr. No splitting was done for the hyphenated fields when I copied your above code as follows:

Re: Arcpy-Check a row for hyphens

DianneGray — Fri, 04 Mar 2016 19:46:04 GMT

This is helpful generally, but the US address locator styles don't appear to recognize the hyphenated address prefixes. These addresses are Canadian

Re: Arcpy-Check a row for hyphens

JakeSkinner — Fri, 04 Mar 2016 19:47:39 GMT

In the last dialog box, where you have !StreetAddr!, you will need to call the function you created in the dialog box above. You should have the following:

calc(!StreetAddr!)

Re: Arcpy-Check a row for hyphens

DianneGray — Fri, 04 Mar 2016 19:57:54 GMT

Oh wow, it worked! That was easy! Thanks!