mattyschell / cscl-subaddress-adhoc

Creative Commons Zero v1.0 Universal
0 stars 0 forks source link

Same addresspoint, different house number #1

Open mattyschell opened 3 years ago

mattyschell commented 3 years ago

Subaddresses belonging to 4683 distinct address points have varying usps_hnum values across a set of subaddress. These appear to a result of updates before vs after switching the house number source to f1_normalized_hn.

SUB_ADDRESS_ID AP_ID CREATED_DATE USPS_HNUM
4295206 191490 2021-06-24 00:00:00 6719
1328221 191490 67-19
470009 191490 67-19
2275360 191490 67-19
2275361 191490 67-19
1328220 191490 67-19