CONTAINS: City, State, County and Zip

If anyone wants it, here it is... Have fun!

USZipCodes.fp7.zip

Cool. Any tips for keeping it up to date? Zip code data changes pretty frequently.

Let me first say this. It is disgraceful, and downright ridiculous, that this information can only be obtained regularly by fee. Tax dollars still fund a portion of the postal service, as much as it runs on its own gains, and it still remains a govt service, which by definition, is not for profit and all information from said institution should be freely available to the public...

but anyways...

Keeping said list up to date once you have obtained one for free is pretty difficult. I run FMData and I have a free one from 2008 that is pretty spot on. I am in the process of converting one I found from 7/2009 and hope to have it up soon. All positive and good feelings aside from the fact that there are some free ones out there, the answer to your question is NO, not for free. If you want to be up to date, you are going to have to pay. I have seen a wide variety of pricing for these services, the claim to being more regularly updated, usually correlary to their pricing.

I too am in need of an up to date zip code list. Looking forward to your conversion. Thanks in advance.

Hey! Nice but....

Not sure how much use this really is, my experiance tells me that lookups of information from lists like this are less than accurate.

A single city st and zip can span multiple counties. It may be usefull for creating dropdown lists for data entry but if you really need to define where something is, you really need to look up information based on a full address. Lists like this are 95%+ accurate but are any number of ways this can go wrong(depending on your buisness needs). The east coast of the US is worse than the west coast (due to differances in how land has been surveyed and how cities/towns/zips have been defined.)

I guess my point is, be carefull, information like this can lead you to incorrect conclutions about where an address is and if that is a critical part of your buisness, you should be using the full address to verify where it is. (This gets worse if you try to find tax districts or municapalities based off of simaliar types of lists)

Just my 2 cents.

I'm using the city as a drop down list and then a drop down of all states with the city name. Works great for what I'm doing. I just want an more up to date before I release my run time.

Let me first say this. It is disgraceful, and downright ridiculous, that this information can only be obtained regularly by fee. Tax dollars still fund a portion of the postal service, as much as it runs on its own gains, and it still remains a govt service, which by definition, is not for profit and all information from said institution should be freely available to the public...

but anyways...

Keeping said list up to date once you have obtained one for free is pretty difficult. I run FMData and I have a free one from 2008 that is pretty spot on. I am in the process of converting one I found from 7/2009 and hope to have it up soon. All positive and good feelings aside from the fact that there are some free ones out there, the answer to your question is NO, not for free. If you want to be up to date, you are going to have to pay. I have seen a wide variety of pricing for these services, the claim to being more regularly updated, usually correlary to their pricing.

I tried the USPS website to see if they sold a zip code database, and the best I found was a set of CD's that had "maps" on them, no database on zipcode=county I could see.

So, where does one go to even price this option out? Links to available databases would be great.

Thanks.

Here is a Zip Code Database in Excel format (Ready to Import into your solution). It has much more than zip codes, current as of 4/26/2010. It is too big to simply add here, but here is a link.

Zip Codes

You guys have no idea how grateful I am for this. I've been looking everywhere for something like this. Couldn't find it.

Zcast, what does "fips" and "dst" mean? I'm sure once you tell me it's going to be painfully obvious.

Thanks again.

Christopher

and, if I have updates that I find, I'll try to remember to return the favor and post an updated table here

If it is important to have a current zip code list,

Matt Petrowsky, of ISO Filemaker Magazine shows you how to set this up in this video. Link

You have to become a subscriber to view, but there is a lot more techniques, videos, etc. that it gives you access to.

HTH

Lee

It's amazing what you can get from the Postal Service.

If anybody is interested, you can call the Post Office at 800-238-3150, option 6, option 2. I may be off by a buck or two, but the costs are as follows:

$231 for a one time CD. This has zip codes +4 and counties.

$350 for the CD with monthly CD updates for 12 months.

No, I'm not sure what the license agreement is like. I'm probably going to do the one time option.

Just in case anybody wants to know.

Christopher

What I use is usps.com. Very often zip codes change and this site is the one which is always updated. You can also use melissadata.com which is a very great look up tool. Your attachment is great to use if one doesn't have internet access. Thanks!

________________________________________

office furniture

used conference tables

There's this one.

ZIP Code Database, Maps, and Boundary Data

http://www.zip-codes.com/

Here is a Zip Code Database in Excel format (Ready to Import into your solution). It has much more than zip codes, current as of 4/26/2010. It is too big to simply add here, but here is a link.

Zip Codes

The link does not work.

The link does not work.

Its been over 2 years, ******* happens!

This type of functionality is quite common, but for some of us developers, we don’t want to pay for the data needed to make this happen. Granted, it didn’t take me too long to find a free of zip code table but I did have to do some minor work to hook it all up.

It might not be necessary to lug a zip code table around https://groups.google.com/forum/#!msg/unyfd/bg32O9MfizE/QqRIqkFbcg0J

Here is the download in case you don't spot it http://www.excelisys.com/demos/ZiptasticJSON.zip