This information is provided “as-is” with no warranty, support, or guarantee of accuracy.
Here’s a convenient file with all the US zip codes and their associated latitude, longitude, city, state, and county. Mapping modules in Drupal and WordPress may require this database which isn’t always included due to size.
Download:
24 replies on “Download: Zip Code Latitude Longitude City State County CSV”
This is great, very useful. Can you tell me what the source of this data is or how you made it?
This was compiled from a city/county/state database and geocoded with Google Maps.
Thanks very much.
you're a blessing for doing this. Thank you!
Thai, you’re my hero.
Thank you very much!
Thanks Thai!
Thank you! This is a godsend.
I appreciate what you are trying to do, but some of those coordinates are way off. Look at zip code 85732, your coordinates are 20 miles away from the center of the actual zip code. This is not the only one, I found many in Arizona, not sure how wide spread it is. Please add a disclaimer because if someone needs accuracy, these are not going to work well.
I agree with Valerie, this is a great effort, however in checking Los Angeles County zip codes, the same Lat/Lon is used for each zip code; this would be incorrect if working with data associated to a particular address or within a zip code.
I agree with Don and Valerie. The Los Angeles zip codes aren't accurate. Good effort but I wouldn't use these for geographic analysis.
you can get one here that is pretty good and regularly maintained: http://greatdata.com from the menu choose ‘more’ > ‘free products’.
However long term developing a very large theme blog with quality
content can be lucrative and a good way to do Internet marketing.
An Internet marketing company will provide detailed monthly reports on
the performances of your various campaigns which will help you track
your business’s performance and improve your ROI. Even if
you’re working by yourself, being enthusiastic will
make a major difference to your overall progress, and it will show in your work.
Thai, Thanks so much for this.
Thank you very much Thai for collecting this data. I will reference your contribution in my work.
I have associate this file into MATLAB code to find the distance between two Zip Codes using your data of the Lat and lon data found in the cvs file.
Please feel free to check it out and let me know if you have any concerns.
http://www.mathworks.com/matlabcentral/fileexchange/45905-zip-code-latitude-longitude-city-state-county
Thanks Thai!
Hi Thai,
Disclaimer: I work for GreatData.com. We provide a commercial ZIP Code product and a free one.
I appreciate that you’re trying to help people!
We understand that most people can’t check lat/long data to see if it’s accurate, so I made a program to see how the data compared, since others said that it wasn’t always correct. We found 1,564 bad ZIP Codes. About half of the lat/long was at least 3 miles off and 2,266 were over 20 miles off. It’s not easy creating a ZIP Code lat/long database (we’ve been working on it for about 20 years and still have challenges keeping it current!)
If you would like to link to our free product from this page, feel free. We maintain it quarterly and a lot of people use it. We know that not everyone can afford a commercial product, so our free product was created to ensure that people have reasonably accurate info.
Paul – UPDATE: now there isn't any 'free' database @ GreatData.com
Hi Shan,
That's correct. We no longer have the free data page, but have a low-cost site for a ZIP Code database with latitude and longitude at SoftwareTools.com.
I wanted to defend Thai so I did some R analysis to compare the two data sources. I had to end up agreeing with Paul though. I was able to merge 25k of the roughly 42k sites on each list.
I converted each lat/long from here (gl) and the GreatData site (gd) and compared the difference in mileage calculated by conferting to radians and then using the linked paged to calculate distance.
Degrees to radians: http://www.r-bloggers.com/r-function-to-convert-degrees-to-radians/
Distance: http://andrew.hedges.name/experiments/haversine/
I found the mean distance discrepancy was 6 miles, and the median was 2.7 miles. So most of the time it was pretty good. Hawaii was for some reason way off though and remote areas were also bad in CA. when I did a one for one on the bad locations GD data landed on the map and GL data dropped me in the ocean or a desert.
Very Useful, Thanks a lot.
Thank you so much. This is very useful for me
Life saver. Thank you Thai.