title: get 9 digit zip code from 5 digit zip code, programmatic, api
body: <p>I have 5 digit zip codes, these are retrieved from Google Maps Api.</p>
  
  <p>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.</p>
  
  <p>The remote system will tell me that the address does not exist with the ones I send it.</p>
  
  <p>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.</p>
  
  <p>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?</p>
  
  <p>Insight appreciated</p>