Database & Application Miscellaneous: zipcode database

• danh / 104 / Sun, 31 Jan 2010 14:40:00 GMT / Comments (5)
• I'm building a store locator type of application and need to find a database which contains all zipcodes in the US along with the associated longitude and latitude information (needed to calculate distances). Does anyone know where I might be able to purchase the data that can then be converted into a database? I tried the US postal service, but they only offer a product that has a lot of unneeded data such as metropolitan information per zipcode and it also costs several hundred dollars. Its seems that since store locator applications are so common, there should be a lot of places to get this info.
• Keywords:

  zipcode, database, application

• http://database.itags.org/database-application/158220/«« Last Thread - Next Thread »»

• 1. This is the kind of stuff the folks at Info USA (http://www.infousa.com/) deal in.
     
     TG

     techgnome | Thurs, 06 Dec 2007 10:15:00 GMT |

  2. Thanks for the reply Techgnome. Funny you mention InfoUSA. I thought they might offer something as well. However, I just got off the phone with them a few minutes ago. It turns out they don't have anything that has a listing of zip codes along with longitude and latitude data. The guy I talked with made the comment that I've been the only person to request something like this. The search continues...

     danh | Thurs, 06 Dec 2007 10:16:00 GMT |

  3. These guys have what you need:
     http://www.msaccessconsulting.com/zipcode.htm

     bruceg | Thurs, 06 Dec 2007 10:17:00 GMT |

  4. BruceG, This is just what I'm looking for! Thanks for the link. Have you used these guys before and found their zip code listings to be updated and complete?
     
     I just found out that I'll need to find the same thing for Canadian Postal Codes. Any ideas here? I asked msAccessConsulting.com if they have anything. I didn't see anything on their website.

     danh | Thurs, 06 Dec 2007 10:18:00 GMT |

  5. danh, glad to be of help. I have only used this on one project, where the base of address data is located primarily in one state. The info seems to be accurate. I have not looked into Canadian zip codes. If you can't find what you are looking for in an easy, inexpensive format like the US db from msaccessconsulting, you may be able to find bits and pieces on the web and piece together your own db (that's a pain, I know, but just thought I'd throw it out there).
     Good luck on your search.

     bruceg | Thurs, 06 Dec 2007 10:19:00 GMT |