Geo::StreetAddress::US - Perl extension for parsing US street addresses
Address parsing | How to parse an address into components
https://www.smarty.com/articles/address-parsing
javascript
https://github.com/hassansin/parse-address
Note: this is temporary manual process. It will be automated behind POI download button. When user click download POI button, it will auto split street name into several components. Reduce the manual steps to improve POI update more efficient, less time needed.
https://pe.usps.com/text/pub28/28apc_002.htm
Step 1.
client request to split street name into 2 column
Step 2.
create a python function named lastWord
Step 3.
call the function lastWord
Step 4.
it will create a new column named st1, which only have street type
Step 5.
now create another function to get only first part of string skip last word
Step 6.
call the function to get only the first part of string
Step 7.
Now you can see, column st2 is only first part of string. So street name column now has been split into 2 column, st1 and st2.
Step 8.
because some st2 have south, east ... pre direction, still need to further split, so use get first part function again to against st2,
Step 9.
now st3 column is only pre direction, such as south, east, ....
Step 10.
Step 11.
Step 12.
Step 13.
Step 14.