Zip Code DB Searchable by Zip

 

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

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600
Page 1>>

is this different from the present zip poi?

H Hannah wrote:

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.

I would like a copy of it...

--
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ

please upload it

I would be interested too mrgreen

--
— (Garmin nuvi 765T) — "people who say money can't buy happiness, don't know where to shop"

Zip Codes

Hi everyone,

Please upload your file. I'd like to take a look.

Thanks, Miki

ZipCode_All.csv POI uploaded

I just uploaded the file ZipCode_All.csv which is searchable by ZipCodes.....

Not sure when they will be available to the general population.....
That will be up to Our Miss Brooks. Woops I mean POI

Only some old timers will remember Our Miss Brooks

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

Routing to ZipCode 98222

For a very interesting looking route, try routing to ZopCode 98222 (Blakely Island WA N48.57605 W122.80998)

It can be routed from anywhere.

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

I would like a copy of it...

I would like a copy of it...

Our Miss Brooks

H Hannah wrote:

I just uploaded the file ZipCode_All.csv which is searchable by ZipCodes.....

Not sure when they will be available to the general population.....
That will be up to Our Miss Brooks. Woops I mean POI

Only some old timers will remember Our Miss Brooks

guilty as charged...sigh rolleyes

--
— (Garmin nuvi 765T) — "people who say money can't buy happiness, don't know where to shop"

Email me a copy

Email me a copy too.........Thanks!!

--
Your Portion Of Light Whether you are a brilliant flame or but a tiny spark matters not-for the world needs whatever portion of light is yours to give.

Availibility

clint45 wrote:

Email me a copy too.........Thanks!!

I uploaded it to POIFactory. It should be available in a day or two.

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

Ok, I'll just PRAY Maryann

Ok, I'll just PRAY Maryann get's it downloadable VERY SOON! (LOL) Did I mention I like to push buttons?!.....push push push!! (LOL)

--
Your Portion Of Light Whether you are a brilliant flame or but a tiny spark matters not-for the world needs whatever portion of light is yours to give.

nice!

Having the time zone and GMT iffset is a nice feature. Thanks!

Iffset ? or isset

Micropterus wrote:

Having the time zone and GMT iffset is a nice feature. Thanks!

It's not IFFSET to GMT-x, it ISSET to GMT-x!!!!

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

.

I think MaryAnn is a little more organized and level headed than the other. I do not seem to feel a sense of panic here. and I was born in '77 btw.

thanks for the file.

Daniel

--
Garmin StreetPilot c580 & Nuvi 760 - Member 32160 - Traveling in Kansas

Duplicate file

Can you tell me what is different from the file located here: http://www.poi-factory.com/node/2356 Please contact the author of the file on this page and see if the new one is an improvement over the old file.
I only have room for one file for zip codes.

I also did a youtube search on the Miss Brooks item and it is quite funny. http://www.youtube.com/watch?v=tZaSIZRBsOw http://www.youtube.com/watch?v=-4sMGKvUu8Y&NR=1 http://www.youtube.com/watch?v=uuQekYecPsA&feature=related

Miss POI

SUPER DUMB question... Can

SUPER DUMB question...

Can someone kindly tell me what the purpose of the zip code poi is for?

Zips by City or Zips ...... That is the question

With the existing Zip Code POI file you can only search by name of the city.

I have seen on here where people have asked to be able to search by zip code. Therefor the reason for the new one.

You should have room for both ZipCode files just label one as searchable by city and the other bt ZipCode.

As for the new file being an improvement over the old one is for the users to determine. I have seen where people have asked to be able to search either way.

Also I have added the Time zone by name and also the GMT-x factor.

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

Glad You Asked

Fantasigraphic wrote:

SUPER DUMB question...

Can someone kindly tell me what the purpose of the zip code poi is for?

I can understand wanting to use the Zip Code instead of the State/City to look up an address, but, sadly, most of us in the US cannot do that. I, too, am confused as to why someone would want to route themselves to a Zip Code. Is the file aimed at using the GPS as a reference tool rather than a routing device?

--
Nuvi 660 -- and not upgrading it or maps until Garmin fixes long-standing bugs/problems, and get maps to where they are much more current, AND corrected on a more timely basis when advised of mistakes.

I have sent a note over to

I have sent a note over to NickJr, he is the project manager of the Zip Code project so I want him included in the discussion. I also sent him a copy of the new file to look over.

Miss POI

!

H Hannah wrote:

I just uploaded the file ZipCode_All.csv which is searchable by ZipCodes.....

Not sure when they will be available to the general population.....
That will be up to Our Miss Brooks. Woops I mean POI

Only some old timers will remember Our Miss Brooks

Radio or TV?

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

... Question

Quote:

Can someone kindly tell me what the purpose of the zip code poi is for?

I don't think it's a dumb question; there can be other uses for some POIs besides navigation. Here's one use for this one: If you travel in an RV or Big Rig, you may have a satellite dish so you can watch TV when parked 30 miles or more from the nearest outpost of civilization. The DISH receiver tells how to point the antenna based on zip code only. This POI shows the closest zip code to current location. Not all flavors of GPSrs offer a "Where Am I" feature nor do less expensive dish antennas point themselves.

--
"There's no substitute for local knowledge" nüvi 750, nüvi 3597

Zip code file

I have to agree with TXrver that is one good reason for the zip code file I had that problem a couple of years ago.

--
johnm405 660 & MSS&T

Radio or TV?

Radio or TV?[/quote]
Both !

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

TV

H Hannah wrote:

Radio or TV?

TV for me, although I did listen to radio rebroadcasts.

I always had the hots for the TV Miss Brooks grin

--
It's about the Line- If a line can be drawn between the powers granted and the rights retained, it would seem to be the same thing, whether the latter be secured by declaring that they shall not be abridged, or that the former shall not be extended.

Radio

Radio - this is a gpsr forum right:)

daniel

--
Garmin StreetPilot c580 & Nuvi 760 - Member 32160 - Traveling in Kansas

project transfered to H Hannah

I have the go ahead from NickJR to post the new file in place of the old one.

Miss POI

I still think the members need both ZipCode files...

I still think the members need both ZipCode files...

One searchable by City and the other by Zips.

I am not trying to take over someone elses project, but only trying to help those that requested a zip search by zip.

See thread: http://www.poi-factory.com/node/16555

Some of these members have valid reasons for wanting the file searchable using zips instead of cities.

My entry was only ment to be a supplement to the original., not to eliminate the original POI and/or its maintainer NickJr.

I am sorry if I seemed to have stepped on someones toes, not my intention.

I hope that you Miss POI will allow both types of zip files to be present. That way it will serve the members better.

Thanks for any of your consideration in this matter.

--
"Those that stop and smell the roses, must realize that once in awhile you may get a whiff of fertilizer."..copyright:HDHannah1986 -Mercedes GPS - UCONNECT 430N Chrysler T&C - Nuvi 2598- Nuni2555 - Nuvi855 - Nuvi295W - Nuvi 750 - Ique 3600

I am fixing this now.

I will make both files show up and will link them together.

Thanks for the clarification.

Miss POI

Zip Code web site

http://www.visitingdc.com/zip-code/ut-zip-codes.asp

Here is a link to a zip code website that I found and you can even sort it different ways. I tried it to see all the zip codes in Utah. Might use it to see if all of my zips are in the poi file.

--
johnm405 660 & MSS&T

Not exactly what I wanted.

I was hoping to find locations of post office buildings. Apparently the locations are the geographical center of the zip. A good example is Muscatine IA 52761. Mapsource puts it on the Illinois side of the river.
Thanks for all the hard work though. I will find the time zone info very useful when making plans for trips to Indiana.

--
1490LMT 1450LMT 295w

Be thankful you don't live

Be thankful you don't live in Canada. I downloaded a database of their postal codes, and god help anyone trying to load it onto their GPS.

I'll try it anyway, because I'm bored, but over 750,000 Canada postal codes might be a bit too much for any GPS to handle. I have a way to cut it down, but I'll have to work at it.

--
"Anyone who is capable of getting themselves made President should on no account be allowed to do the job." --Douglas Adams

Postal Codes

The nuvi's have postal codes already.

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Re: Postal codes

Juggernaut wrote:

The nuvi's have postal codes already.

Really? How do you use it?

If I was in say.... 01960 and I wanted to find something, how do you do that?

(I'm using a Noovy 1490T)

Thanks for the education!

Postal Codes, not Zip Codes

Unfortunately, Garmin decided to take ZIP Codes off the nuvi in my 775T on the 3.9 FW update.

However, the postal codes referred to by Strephon_Alkhalikoi are for Canadian postal codes, not the US. You can DL the POI file for the ZIP's.

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Postal codes

mtiernan wrote:
Juggernaut wrote:

The nuvi's have postal codes already.

Really? How do you use it?

If I was in say.... 01960 and I wanted to find something, how do you do that?

(I'm using a Noovy 1490T)

Thanks for the education!

First off we start our postal codes off with a Letter and they are 6 digits example mine is V5A 4G5. "Hit Where To?" then "Address" then "Change State or Country" then "Change Country" Type in Canada, should give you two options as soon as you put in the "c". Then type in the province and it will put you back into the "Change State or Country" Screen where you will see the postal code.

--
nüvi®3580LMT,nüvi®2598LMT| We do not live in Igloo's, and do not all ride to work on snow mobiles.

I know Garmin handles Canada Postal Codes but...

Just for the record, I was bored and the postal codes file is a huge one. However, I should be able to find out what city or town is attached to a Forward Sortation Area (the first half of a Canadian postal code) without having to know an entire postal code. I know that I have encountered instances where I've wanted to look at some place in Canada on the GPS and couldn't because it insisted on a whole postal code that I didn't know.

I think I'll keep doing this file simply to alleviate boredom. I also think I'll slip in an Easter Egg while I'm at it. wink

--
"Anyone who is capable of getting themselves made President should on no account be allowed to do the job." --Douglas Adams

:)

Aren't you ambitious?! Good for you! smile You didn't state what your intent was behind this project, and I thought I might save you hours of work... However, now that you've stated it, this would be a great POI to have for searching.

I'll thank you in advance for this Herculean task!

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Go for it

Strephon_Alkhalikoi wrote:

Just for the record, I was bored and the postal codes file is a huge one. However, I should be able to find out what city or town is attached to a Forward Sortation Area (the first half of a Canadian postal code) without having to know an entire postal code. I know that I have encountered instances where I've wanted to look at some place in Canada on the GPS and couldn't because it insisted on a whole postal code that I didn't know.

I think I'll keep doing this file simply to alleviate boredom. I also think I'll slip in an Easter Egg while I'm at it. wink

Postal or not, the new map still has my address wrong. As a matter of fact, punching in the address or even using the postal code which BTW you still need a house number gives me a location which does not exist. I'm not sure why it does that. I can google it and it finds me. Bin here for over 20 years and nothing has changed. Boggles my mind... laugh out loud

--
nüvi®3580LMT,nüvi®2598LMT| We do not live in Igloo's, and do not all ride to work on snow mobiles.

@Speed2

I dropped your postal into my nuvi, and Google. Both returned the same area in Burnaby.

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Smarty

Juggernaut wrote:

I dropped your postal into my nuvi, and Google. Both returned the same area in Burnaby.

Now type in 8710 as house number, you'll get 9300 which doesn't exist. 8710 is as high as it gets

--
nüvi®3580LMT,nüvi®2598LMT| We do not live in Igloo's, and do not all ride to work on snow mobiles.

.

Speed2 wrote:

Now type in 8710 as house number, you'll get 9300 which doesn't exist. 8710 is as high as it gets

When I type in a Postal Code, I just skip the number if I don't have it, and it gives me what it has for the general area.

So, typing in 8710, I get 9200 Maple Grove Cres. But according to Google Earth, 8710 doesn't exist either... it just shows the intersection at Forest Grove.

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Took less time than I thought.

Juggernaut wrote:

I'll thank you in advance for this Herculean task!

I got lucky, though despite my luck this file was very annoying. I'll explain.

1. I did a search for Canada Postal Codes and came across a link on the following page: http://drupal.org/node/255995 . The zip file I downloaded from one of the links on that page contained a CSV file that was set up for MySQL. The file itself once extracted from the zip file, turned out to be almost 60MB in size with over 750,000 entries in it.

2. The good news about the file is it had coordinates in the file. The annoying news was that the postal codes were complete, meaning not only the Forward Sortation Area but the Local Delivery Unit (the second half of the postal code) as well. There were a couple minor issues besides this, but those were related to the file being set up for MySQL and easily fixed.

3. There were a ton of false starts on this one. Using EPE was useless because trying to find the duplicates would have taken forever. It took a few tries in Excel before I hit on a combination to cut down the file, as I'm not as familiar with Excel as I am with Word. I used ASAP Utilities to strip the LDU from the file. After ASAP Utilities, I fixed the minor issues, then deleted all the duplicate entries. End result?

765,344 entries cut down to 7,660. A 99% decrease in the number of entries and an over 99% decrease in the file size (58MB to 387KB).

I did a test run of the file through Google Earth, though as of yet I've not loaded the file into my GPS. I'll test it properly later on today or sometime tomorrow before upping it to the site.

--
"Anyone who is capable of getting themselves made President should on no account be allowed to do the job." --Douglas Adams

Re: Zip/Postal codes on Nuvi 1490T

Juggernaut wrote:

Unfortunately, Garmin decided to take ZIP Codes off the nuvi

Seems they yanked it/them off my N1490 too. sad

Always some one

Juggernaut wrote:
Speed2 wrote:

Now type in 8710 as house number, you'll get 9300 which doesn't exist. 8710 is as high as it gets

When I type in a Postal Code, I just skip the number if I don't have it, and it gives me what it has for the general area.

So, typing in 8710, I get 9200 Maple Grove Cres. But according to Google Earth, 8710 doesn't exist either... it just shows the intersection at Forest Grove.

Google some more and when you get it right, call me. 8710 does exist i can even use satellite imagery and it shows me my drive way. 9200 Maple Grove does not exist. 9200 Forest grove does exist. This will keep you busy and out of harms way for a bit....lol

--
nüvi®3580LMT,nüvi®2598LMT| We do not live in Igloo's, and do not all ride to work on snow mobiles.

great work

Strephon_Alkhalikoi wrote:

Just for the record, I was bored and the postal codes file is a huge one. However, I should be able to find out what city or town is attached to a Forward Sortation Area (the first half of a Canadian postal code) without having to know an entire postal code. I know that I have encountered instances where I've wanted to look at some place in Canada on the GPS and couldn't because it insisted on a whole postal code that I didn't know.

I think I'll keep doing this file simply to alleviate boredom. I also think I'll slip in an Easter Egg while I'm at it. wink

Great file and easy to use, found the Easter Egg but my Nuvi 250 won't zoom out far enough to get the full route.

--
All the worlds indeed a stage and we are merely players. Rush

The Easter Egg

It was exactly what I thought it was. Thanks for the file, and the chuckle!

--
nüvi 3790T | nüvi 775T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK

Tumwater, WA

File lists 98500 for Tumwater, WA.

Zip Code 98500 does not exist.

According to a search USPS.com for Zip 98500:
"Find a list of cities that are in a ZIP Code.

The ZIP Code you entered could not be found in our database.
Please confirm the ZIP Code and try again.

If you are certain the ZIP Code entered is valid, please send an email
including your address to incsc@email.usps.gov."

Don't know how you handle shared Zips but just in case.

Tumwater:
98501
98511 (PO BOX) [What is Special Cases?]
98512

Tumwater and Olympia share 98501,98511 and 98512.

Lacey, WA:
98503
98506
98509 (PO BOX) [What is Special Cases?]
98513
98516

Lacey and Olympia share 98503, 98506, 98509, 98513 and 98516

Olympia:
98501
98502
98503
98504 (UNIQUE) [What is Special Cases? ]
98505 (UNIQUE) [What is Special Cases? ]
98506
98507 (PO BOX) [What is Special Cases?]
98508 (PO BOX) [What is Special Cases?]
98509 (PO BOX) [What is Special Cases?]
98511 (PO BOX) [What is Special Cases?]
98512
98513
98516
98599

Unique – The ZIP Code™ is used for a specific company or organization.

PO Box Only – This ZIP Code is for a specific PO Box.

Great POI

This is a great POI and will be very useful.

Helpful link

This shows the map boundaries of every zip.
http://www.usnaviguide.com/zip.htm

--
1490LMT 1450LMT 295w

98500 does not exist

Delete

Thank You, lot of hard work

Thank You, lot of hard work and effort here!!

--
Garmin Nuvi 255W
Page 1>>