ZipCode POI Searchable by ZipCode

 
H Hannah's picture

Login or register to download files

Last updated 01/23/2009

Raw file: ZipCodes_All.csv (2.88 MB)

Includes 42914 locations in the following areas:

  • United States: AK, AL, AR, AZ, CA, CO, CT, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI, WV, WY
  • Canada: ON
  • some may be in: AB, DC, MB, MEX, NB, QC, SK (near a border)

276 location(s) outside USA/Canada

ZipCode POI Searchable by ZipCode

If anyone is interested, I have compiled a ZIP Code POI DB (CSV) that is searchable by zip code.

It is quite large (43190 zip codes, but because the state abbreviation is the first 2 letters of column 4 it would be easy to extract the state or states you want and be able to make the data suit you.

All the data was taken from the last US Census data available with this data.

It returns: State, City, TimeZone and GMT-x

So ZipCode 00612 returns "PR,Arecibo - Atlantic Time Zone GMT-4"

ZipCode 62922 returns " IL,Creal Springs - Central Time Zone GMT-6"

ZipCode 99583 returns "AK,False Pass - Alaska Time Zone GMT-9"

ZipCode 96796 returns "HI,Waimea - Hawaii-Aleutian Time Zone GMT-10"

ect, ect.....

It covers all 50 states, Puerto Rico, US Virgin Isls.

I left out Guam and all the Pacific Rim US Protectorates such as Yap, Palau and Saipan... These places may have multiple zips but only one actual location (LON-LAT)per island. So using these zips for finding a city won't work. The only exception I can find is the Wake Island is listed but that is because it does have a Honolulu HI zip code assigned to it.

See also

Discussion Topics