December 9, 2014 at 11:21 am
ZZartin (12/9/2014)
Eric M Russell (12/9/2014)
There are many commercial providers of address data. This would be better than attempting to make a web service call for each record in an ETL process.The USPS one is free 😛
:unsure: The USPS web service, even if free and unlimited, doesn't scale for hundreds of thousands or millions of records.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 9, 2014 at 11:40 am
However, one limitation of most commercially and publicly available address databases is that they don't include exact house number, but instead a range of valid numbers, so would have to perform a non-equijoin.
The USPS claims that privacy laws passed by Congress prohibit it from making available an exact street address database. Like all other databases based on the USPS ZIP+4 address database, the National ZIP+4 Address Database does not actually contain every street number to which mail can be delivered. Instead, the database contains more than 40 million address records, many of which define address ranges, especially in residential areas.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply