Download a free zipcode database with latitude and longitude. Blackberry mep unlock code calculator free download. For almost every person in the US, five short digits that are readily recalled, freely divulged, and commonly recorded in administrative data provide considerable information about the individual. EDIT 8/3/2015 The free non-commercial ZIP Code database I mentioned below has moved to softwaretools.com.Note: greatdata.com still has the premium ZIP Code data for enterprises. Just a small note. Most of these 3rd party city/state/zip to lat/lng databases are.
- Zip Code Lat Long Csv
- Free Zip Code Lat Long Database Download 2016
- Free Zip Code Lat Long Database Download Free
- Lat Long To Zip Code Converter
Area Codes for North America with city, state, latitude and longitude in easy to read CSV format.
This data pairs up NPA (area) codes with one or more cities, as well as a latitude / longitude pair.
There have been a number of times where I wanted to be able to map (roughly) where a phone number was, or to find 'nearby' numbers. This seems to be a fairly rare thing to do, as it's much harder to find area code data than it is to find (eg) zip code data. There are commercial versions out there that cost anywhere from a hundred dollars to well over a thousand, on an ongoing/subscription basis. It seemed silly to pay that much money for for public data, so I finally sat down and used that public data to compile a list that could be shared. No commercial products were used when compiling these documents, all sources are listed below if you wish to verify that. A fair amount of data cleansing was done to match everything up and (hopefully) end up with useful / authoritative city and state/province names.
Keep in mind that area codes do not guarantee a location, since numbers can easily be ported across the country. It does give a good indication of where the number was originally assigned, however, and in most cases probably indicates the rough location of the number.
I am, of course, trusting that the sources I used were 'accurate'. It's possible (likely even) that there are errors. Please do not use this data to dispatch ambulances and fire trucks.
File Formats
Files begin with the country code (currently the United States and Canada) and are all UTF-8 encoded CSVs. Pretty much anything should be able to open them, including random text editors and your favorite programming language.
Field Lists
xx-area-code-cities.csv
- Area Code
- City Name
- Province/State Name
- Country Code
- Latitude (of the city)
- Longitude (of the city)
xx-area-code-geo.csv
- Area Code
- Latitude (average of the cities using this code)
- Longitude (average of the cities using this code)
Sources
US/American area code listings were pulled from NANPA (North American Numbering Plan) at http://www.nationalnanpa.com/reports/area_code_relief_planning.html, field definitions can be found at http://www.nationalnanpa.com/area_codes/AreaCodeDatabaseDefinitions.xls. More information on these files is available at http://www.nationalnanpa.com/area_codes/index.html. The cities in each area code were queried from the form at http://www.nanpa.com/enas/npa_city_query.do.
Zip Code Lat Long Csv
Canadian area codes were pulled from the CNA (Canadian Numbering Administrator) at http://www.cnac.ca/data/COCodeStatus_ALL.zip. More information on this file is available at http://www.cnac.ca/co_codes/co_code_status.htm.
Geolocation data (specifically, the coordinates of each city) was pulled from Geonames at http://download.geonames.org/export/dump/cities5000.zip. More information on that file is available at http://download.geonames.org/export/dump/.
Proper (accented) state and province data is somehow unavailble from Geonames. Fortunately Tony Showoff compiled a list at http://tonyshowoff.com/files/supplement/geonames/admin1Codes.txt. More information is available at http://tonyshowoff.com/articles/geonames-the-only-terrible-choice-we-have/. Samsung unlock code generator for free.
Alternate province / state short names / codes pulled from http://englishplus.com/grammar/00000057.htm.
License
You are free to use this compilation for any purpose (commercial or not). I believe (although cannot provide a legal guarantee) that the data used while compiling these files is public domain.
Free Download of the zip code CSV file available at the bottom of this post.
Free Zip Code Lat Long Database Download 2016
Free Zip Code Lat Long Database Download Free
Why this is so hard to track down I don’t know. We were looking for a comma
delimited list which would map zip code to county since county is the lowest
grain available in the out of the box SQL Server Reporting Services (SSRS) maps. There are plenty of vendors offering this data for a fee, but who wants to pay a fee for a proof of concept project? Not I. As an added bonus this free list has latitude and longitude coordinates as well.
delimited list which would map zip code to county since county is the lowest
grain available in the out of the box SQL Server Reporting Services (SSRS) maps. There are plenty of vendors offering this data for a fee, but who wants to pay a fee for a proof of concept project? Not I. As an added bonus this free list has latitude and longitude coordinates as well.
The attached file contains the following fields:
Zip Code
Latitude
Longitude
City
State
County
Zip Class
Lat Long To Zip Code Converter
Sample Data Format:
“91941”,”+32.761050″,”-116.998102″,”LA MESA”,”CA”,”SAN DIEGO”,”STANDARD”
Of note: We have not used the data in this file yet so I’m not sure if
there are any issues with it.
there are any issues with it.
The original source of the file was the site below. In addition to providing this file they also have a Canadian Postal Code CSV and a few files mapping IP addresses to city or country.
Without further ado, here is the link to the compressed zip code file: