nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Address filed split into fields

CCWeedcontrol

I have a table with about 6k road names. only the FULLSTNAME field is populated. I need to populate the PERDIR (pre directional) STNAME (Street name only), STTYPE (Street type) and POSTDIR (post directional) from the field FULLSTNAME.

To start off i started with field calculator but only a handful of fields get populated.

def myParser(inString):
&nbsp; splitString = inString.split(' ')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ###splits the address into a list
&nbsp; a = splitString[0]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### list item 0 is the first part of name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; b = splitString[1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### list item 1 is the prefix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; c = ' '.join(splitString[2:-1])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ###&nbsp; this rerurns the street name
&nbsp; d = splitString[-1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### this returns the suf dir or street type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; return a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### depending on what you want to return,
&nbsp; #return b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### un-comment and re-comment out the
&nbsp; #return c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ### appropriate value(s)
&nbsp; #return d

myParser(!FULLSTNAME!)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Even looking at just populating "PREDIR" field with the above filed calculator i would run into problems, for example the road name "New Castle Dr" it would put "New" in the PREDIR field which correct because it is not a Pre- directional. Some roads have two words for names like "New Castle Dr" has "New Castle". if used return c it would only populate the STNAME field with just "New".

I tried looking at using arpy with the following but get an invalid syntax line 15

import arcpy

from arcpy import env
inputTable = "Road_Names_1"
arcpy.AddMessage ("input " + inputTable)

#split field loop
rows = arcpy.UpdateCursor (inputTable)&nbsp; #gets all vlaues for table

for row in rows:&nbsp; #loops through vlaues and updates new field 
&nbsp;&nbsp;&nbsp; row.Type = row.FULLSTNAME.split(" ")[-1] if ',' in !FULLSTNAME! then !STNAME!=!FULLSTNAME!.split(',',1)[-1] else ""
&nbsp;&nbsp;&nbsp; rows.updateRow(row)

del row
del rows<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I also tried to look at at a post by Ted Kowal of his Address Parase but i am not sure how to use it.

If anyone already has a python script that works and would be willing to share i would really appreciate it.

Thanks.

Table.png

Vind meer berichten getagd met

Accepted answers

All comments

CCWeedcontrol

ok, i am see it now. Thank you very much for your help.

Although i am getting an error and i am not sure why. Is it not liking the actual values( Ave, Rd, Ct, Dr, St, Way, Ln, Blvd, Pl,Cir, Trl) and if so how can tell which one it doesn't like?

line 17, in <module>

cursor.updateRow([predir, stname, sttype, postdir, fullstname])
RuntimeError: Invalid column value [STTYPE]

import arcpy, usaddress
from collections import OrderedDict

# Get feature class through parameter
Table = "RoadNameTabl"

fields = ['PREDIR','STNAME','STTYPE','POSTDIR','FULLSTNAME']

try:
with arcpy.da.UpdateCursor(Table,fields) as cursor:
&nbsp;&nbsp;&nbsp; for predir, stname, sttype, postdir, fullstname in cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parse = usaddress.tag(fullstname)[0]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; predir = parse.get("StreetNamePreDirectional", "")
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stname = parse.get("StreetName", "")
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sttype = parse.get("StreetNamePostType", "")
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; postdir = parse.get("StreetNamePostDirectional", "")
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow([predir, stname, sttype, postdir, fullstname])

print 'Done'<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

bixb0012

You just need to spend some time exploring the data structure of the output from usaddress.tag. Tagging returns a tuple with an ordered dict and a string classifying the address.

Using your code example, I think the following is what you are after:

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> usaddress
<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> OrderedDict



<SPAN class="comment token"># Get feature class through parameter</SPAN>
Table <SPAN class="operator token">=</SPAN> <SPAN class="string token">"RoadNameTabl"</SPAN>

fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'PREDIR'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'STNAME'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'STTYPE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'POSTDIR'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'FULLSTNAME'</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>Table<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> predir<SPAN class="punctuation token">,</SPAN> stname<SPAN class="punctuation token">,</SPAN> sttype<SPAN class="punctuation token">,</SPAN> postdir<SPAN class="punctuation token">,</SPAN> fullstname <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parse <SPAN class="operator token">=</SPAN> usaddress<SPAN class="punctuation token">.</SPAN>tag<SPAN class="punctuation token">(</SPAN>fullstname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; predir <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"StreetNamePreDirectional"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stname <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"StreetName"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sttype <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"StreetNamePostType"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; postdir <SPAN class="operator token">=</SPAN> parse<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"StreetNamePostDirectional"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>predir<SPAN class="punctuation token">,</SPAN> stname<SPAN class="punctuation token">,</SPAN> sttype<SPAN class="punctuation token">,</SPAN> postdir<SPAN class="punctuation token">,</SPAN> fullstname<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

CCWeedcontrol

thanks for the reply yes i did read the docs my apologies for not understand how to use the parser .

I am not quit sure how updating/populating the fields using a cursor.

This is what i have came up with but i am not sure if i am using usaddress correctly. I am getting an error on

row[1] = addr_dict[row[4]]
TypeError: tuple indices must be integers, not unicode

import arcpy, usaddress
from collections import OrderedDict



# Get feature class through parameter
Table = "RoadNameTabl"

field1 = "PREDIR"
field2 = "STNAME"
field3 = "STTYPE"
field4 = "POSTDIR"
field5 = "FULLSTNAME"
'''
fields = ['PREDIR','STNAME','STTYPE','POSTDIR','FULLSTNAME']


fields = (field1,field2,field3,field4,field5)
with arcpy.da.UpdateCursor(Table,fields) as cursor:
&nbsp;&nbsp;&nbsp; for row in cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field2 = row[fields.index(field5)]
'''

with arcpy.da.UpdateCursor(Table,(field1, field2, field3, field4, field5)) as cursor:
&nbsp;&nbsp;&nbsp; for row in cursor:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; addr_dict = usaddress.tag(row[4])

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # say you want to put the address name in field 2
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[1] = addr_dict[row[4]]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow(row)

del row

print 'Done'
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

TedKowal

When I wrote those parsing routines, there were no freely available parsers in existence. Secondly, I was not necessarily interested in parsing the addresses but to "cleanup" some very bad data I received from our tax authority database. Lastly, I cannot claim credit for all the routines -- they are a collection of snippets from lots of python folks... I took a look at the usaddress parser. Sorta funny, I will be getting a 5 Million record dump from the same tax authority shortly and I intend to use the parser suggested by Joshua Bixby this time around.

Addresses are very messy as you are finding out ... best to use something that has already been developed! (And is free!). Here in Miami, I have found out that the US Postal system aka address does not always use the official street names and nomenclature so I had to interject a lot of exceptions to clean up the data for my use to relate the addresses to our inventory of roads.

BTW: I am attaching a cal file which I used during the cleanup. The cal file imports the script you mentioned and returns the StreetNumber in this example. But in my case I am going the opposite direction you are... I have a bunch of addresses for which I am trying to find a related Roads Inventory street for.....

StreetNumber.cal.zip

bixb0012

Did you read the docs for usaddress, try something, and it didn't work? What part don't you understand, the parsing of the addressing, updating/populating the fields using a cursor?

Using usaddress and a couple of addresses from your screenshot:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> usaddress
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN>v <SPAN class="keyword token">in</SPAN> usaddress<SPAN class="punctuation token">.</SPAN>tag<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'N Windsor Park Ct'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> k<SPAN class="punctuation token">,</SPAN> v
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
StreetNamePreDirectional N
StreetName Windsor Park
StreetNamePostType Ct
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN>v <SPAN class="keyword token">in</SPAN> usaddress<SPAN class="punctuation token">.</SPAN>tag<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Noahs Landing Cir'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> k<SPAN class="punctuation token">,</SPAN> v
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
StreetName Noahs Landing
StreetNamePostType Cir
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

CCWeedcontrol

Joshua,

thank you for the replay and link to the address parse. So an Address parse breaks up a single address strings into individual parts, which i get but i am not sure how use it to accomplish what i am trying to do.

bixb0012

Just say "no" to rolling your own address parser. There is no way you can make something that will work better than some of the Python address parsers that already exist. There are several available, just do an internet search. Personally, I use GitHub - datamade/usaddress: a python library for parsing unstructured address strings into address components quite a bit.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.