Zip Code DB Searchable by Zip

I would like a copy of it...

I would be interested too

Hi everyone,

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

Thanks, Miki

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

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

It can be routed from anywhere.

I would like a copy of it...

guilty as charged...sigh

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

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

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)

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

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

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

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 someone kindly tell me what the purpose of the zip code poi is for?

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.

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?

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

Radio or TV?

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.

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.

Radio or TV?[/quote]
Both !

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

I always had the hots for the TV Miss Brooks

Radio - this is a gpsr forum right:)

daniel

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...

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.

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

Thanks for the clarification.

Miss POI

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.

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.

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.

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!

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.

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.

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.

Aren't you ambitious?! Good for you! 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!

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...

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

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.

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.

Seems they yanked it/them off my N1490 too.

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

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.

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

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.

This is a great POI and will be very useful.

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

Delete

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