generate address from street line (911 dispatch)

Question

Step 1.

bearing line spatially join with street line

Step 2.

bearing line spatially join with street line

Step 3.

so far, bearing line have street name, block range

Step 4.

text point join bearing line by FID

Step 5.

Step 6.

so far text point number now have street name, block range link with.

Step 7.

export joined result 

Step 8.

delete unwanted field, 

Step 9.

add new houseNum text field, and others

Step 10.

Step 11.

Step 12.

Step 13.

Step 14.

save script for next time use, so you don't have to type script again, just import.

Step 15.

as result, text 07, have been convert to real house number based on street block range 3600, 

3607

Step 16.

Step 17.

Step 18.

Step 19.

Step 20.

Step 21.

Step 22.

Step 23.

Step 24.

Step 25.

Step 26.

Step 27.

Step 28.

Step 29.