get 9 digit zip code from 5 digit zip code, programmatic, api

Question

I have 5 digit zip codes, these are retrieved from Google Maps Api.

My dilemma is that I have to connect to a remote database which also contains addresses. If the address does not exist in that database, I have to write it, if it does exist then I do nothing except store the ID that database has assigned to the address. The problem arises since the api to check this database does not take wildcards, the addresses in that database have 9 digit zip codes (5+4) and will not return that the rest of the address matches my address with 5 digit zip codes.

The remote system will tell me that the address does not exist with the ones I send it.

So to prevent duplicate addresses from being written to the database I would need to find the 9 digit version of the zip code I have before sending it.

How would this be done? Is there a formula for determining what the last 4 digits of a 5 digit address are? Does the USPS have an API? Does the Census have a giant table?

Insight appreciated

Isoelectronic

Yeah, the USCB has a "giant table", but it's in shapefile form, broken down by cities. I've looked at them, and used them with Python scripts. (Boy that was fun!) And actually, the USCB doesn't use ZIP codes for their data, but because of popular demand, have created "ZCTAs" (ZIP Code Tabulation Areas) to try to link their census blocks into ZIP codes... anyway, that's trivia, probably not what you're looking for. – Grau

Answer 1

You are only allowed to use the USPS API for information if you are using the USPS to send out mail...

But you could check out SmartyStreets (I used to work there) or another CASS-Certified vendor. They are licensed for address verification, and you can also perform city-state and ZIP code lookups without an address (depending on who you choose).

I think you'll find them much easier and more comprehensive than the default USPS web service.

Here's some sample code... take your pick: https://github.com/smartystreets/LiveAddressSamples

Grau

Answer 2

The US Postal Service have a number of APIs. Their "Address Information APIs" include:

Address Standardization

Eliminate addressing errors and help ensure accurate and timely delivery. This tool corrects errors in street addresses, including abbreviations and missing information. It also supplies a ZIP+4® Code.

ZIP Code™ Lookup

Find matching ZIP Codes or ZIP+4 Codes for any given address, city, and state in the U.S.

City/State Lookup

Use a ZIP Code to get accurate city and state information.

The Address Information APIs require permission to use.

Apeman

True, but this is only permitted if doing mailings via the USPS. See their Terms of Service. – Grau