Zip Code DB Searchable by Zip
16 years
|
If anyone is interested, I have compiled a ZIP Code POI DB (CSV) that is searchable by zip code.
I can upload it to POIFactory if any of you want it.
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.
POI Files
thanks
Yes, lots of work. I'd have packed it in long before completion....
Happy Holidays
John Nuvi 750 765T Winnipeg, MB
Sharing
Tumwater:
98501
98511 (PO BOX) [What is Special Cases?]
98512
Tumwater and Olympia share 98501,98511 and 98512.
Olympia:
98501
98511 (PO BOX) [What is Special Cases?]
98512
That is bizarre. I searched businesses in this vicinity to confirm.
47.01785, -122.90015
Different city, same zip code.
1490LMT 1450LMT 295w
If you lived here you'd understand.
Delete