I’m an idiot.

I am working on a project doing some work with latitudes and longitudes, and finding the distances between them. I had a dump from somewhere of all the zip codes in the country with all the city names, etc.

So I hooked up with the Google geolocater service and started hitting their server with requests, to return the lat and long.

I hit it with 50,000 + requests, and they shut me out. Unfortunatly this won’t work, as I need to get the project done. So I started looking through the tubes (the internet is series of tubes you know) and right after I pass a goomba, I find this place…

Its called sourceforge. You have heard of it. Even if you dont realize it. They have everything. Apparently, they have the thing I was trying to create too. I should have known.

The moral is: “If you need all the zip codes, all the cities, and their latitudes and longitudes go here“;

All the latitudes and longitudes you need

Also if you are importing it into mysql, and don’t want to fight the importer of your choice you can download the file: zipssql.zip

It has the sql for creating the table, and inserting all the data, as well as indexing.

Bookmark to: