StreetName0 must split into 2 seperate fields, street name and street type. For example "Main ST", must split into streetName as 'Main', StreetType as 'ST'.
Why I need to do that anyway?
Because of implementing NG 9-1-1 standard, see standards here
NENA Standards for GIS Data Model
referencing pages 24-25 & 30-31).
https://cdn.ymaws.com/www.nena.org/resource/resmgr/standards/nena-sta-006.2-2022_ng9-1-1_.pdf
The St_Name (Street Name) and St_PosType (Street Name Post Type) are separated fields.
County assessor office all using combined style for all street center line and parcel address.
So you have to convert from county combined style into NENA ng911 standard style.
Step 1. use Arcgis Pro Split address tool
https://pro.arcgis.com/en/pro-app/latest/tool-reference/geocoding/split-address-into-components.htm
Step 2. clean up the missed address
https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/review-addresses-split-into-components.htm
Step 3. with ArcMap, use this tool
https://resources.arcgis.com/en/help/main/10.1/index.html#//00260000000m000000
Step 4. python library for US address
It has REST api for browser use
https://github.com/datamade/usaddress
Step 5.
Write a python function to get last word of street name
Step 6.
call last word function to populate field st1,
Step 7.
create a new function extract first part except last word
Step 8.
run first part except last word function to populate field st2
Step 9.
drag and drop field st1, st2 next to StreetName, StreetType, so you can easily compare
Step 10.
Now street name split into 2 column, st1 and st2
Step 11.
Improving the case if street name only have 1 part for example
Step 12.
Click edit, then click select all
Step 13.
Street type (st1) field need improve code by add only if street name has more than one part,
Step 14.
run last word for street type again
Step 15.
Problem fixed
broadway does not have street type.
Step 16.
Street Name (st2) field need improve code by add only if street name has more than one part,
Step 17.
run first part except last word for street name(st2) again
Step 18.
Final result, street name success split, 2 column name(st2) type(st1)
