How to Parse Unique Address Data

المشرف العام

Administrator
طاقم الإدارة
I'm trying to parse some funky address data into separate fields either using ArcMap's Field Calculator or a Python Script. Currently, my address data including street number, street name, and unit/apt/suite number are all in one field. Some examples of the diversity in my data include:

1111 2ND ST
1753 21ST ST 2ND FLOOR
2125 ARIZONA AVE #303
2424 12TH ST SUITE 100


Thankfully, there are only a handful of suffixes which include:

AV | AVE | BL | CT | DR | LANE | PKWY | PL | RD | ST | TER | WAY

What python methods could I employ to search for these unique identifiers and then split whatever follows them (e.g., "2ND FLOOR", "#303", "SUITE 100")?



أكثر...
 
أعلى