Up to Date - Zip Code Database? [closed]
Asked Answered
M

4

20

I've been using the zipcode information from here:

http://www.census.gov/geo/maps-data/data/gazetteer2010.html

in my mySQL database but I've noticed that it's missing quite a few zipcodes

(ex. 94142, San Francisco, CA)

....does anyone know of some more up to date zip code data?

Marrano answered 6/11, 2013 at 18:3 Comment(2)
Thanks Everyone! +1 for all...Marrano
This one seems pretty good: federalgovernmentzipcodes.us/download.htmlSublett
N
19

Try the data at http://www.geonames.org/

(There's a Free postal Code Data link there, with postal codes for lots of countries).

Nigeria answered 6/11, 2013 at 18:8 Comment(3)
Useful! The site provides a text file that can be downloaded and easily converted to other formats like CSV using Excel.Muth
this one does not have complete AK.HI,PR zipcode...Chrono
It also only lists one city per zipcode. In many cases there are multiple cities in the same zipcode. Where can I get that data?Suzisuzie
J
8

The United States Postal Service is the government entity that provisions ZIP codes. As such, the authoritative, always-correct database is theirs.

Happily, they provide free APIs that developers can use:

https://www.usps.com/business/web-tools-apis/welcome.htm

Jaramillo answered 6/11, 2013 at 18:10 Comment(1)
The terms & conditions of using the USPS API exclude any use other than to facilitate USPS shipping. So, by the terms of the agreement, you aren't supposed to use the API for, let's say, a moving company quote calculator (one example of many).Jacket
E
3

The reason why the Census Bureau doesn't have all ZIP Codes is because they only contain the ones with populations (general delivery addresses) and don't contain ZIPs for PO Boxes.

Edmond answered 8/1, 2014 at 15:45 Comment(0)
D
2

I get mine zip codes, and more, from here. This also includes latitude and longitude information, which makes calculating distances between locations possible.

Devilish answered 6/11, 2013 at 18:8 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.