Addresses with more than 1 House Number

[mattyschell]

7,842 subaddresses will not have house numbers despite appearing in the 3rd party geocoded data. Most of these subaddresses appear to be un-house-number-able because they are associated with multiple house numbers in the geocoded data.

These are probably data errors in the CSCL source, many of which have been cleaned up in the last year. Here's an example. Addresspointid 127454 is a ranged address point that sat alone on a building footprint in 2020. Today it shares the building footprint with a second address point.

Addresspointid	Unit	House Number
127454	APT 1A	147-45
127454	APT 1A	147-47
127454	APT 1B	147-45
127454	APT 1B	147-47

In the source geocoded data both house numbers have been smushed onto the one addresspoint.

[mattyschell]

When we process 2021 Melissa into CSCL we’ll:

1. For new address points: Add new subaddresses (with usps_hnum)
2. For old address points: Delete any subaddress records that are now associated with new address points

However any existing subaddress records correctly associated with the old address points will not change. I think this means that we will need to re-run this usps_hnum update process again.