ron G Posted September 8, 2009 Share Posted September 8, 2009 CONTAINS: City, State, County and Zip If anyone wants it, here it is... Have fun! USZipCodes.fp7.zip Link to comment Share on other sites More sharing options...
David Jondreau Posted September 9, 2009 Share Posted September 9, 2009 Cool. Any tips for keeping it up to date? Zip code data changes pretty frequently. Link to comment Share on other sites More sharing options...
amgdba Posted September 9, 2009 Share Posted September 9, 2009 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. Link to comment Share on other sites More sharing options...
XJoe Posted October 23, 2009 Share Posted October 23, 2009 I too am in need of an up to date zip code list. Looking forward to your conversion. Thanks in advance. Link to comment Share on other sites More sharing options...
aholtzapfel Posted November 18, 2009 Share Posted November 18, 2009 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. Link to comment Share on other sites More sharing options...
XJoe Posted November 18, 2009 Share Posted November 18, 2009 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. Link to comment Share on other sites More sharing options...
Newbies Rick Beitler Posted April 19, 2010 Newbies Share Posted April 19, 2010 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. Link to comment Share on other sites More sharing options...
Zcast Posted April 27, 2010 Share Posted April 27, 2010 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 Link to comment Share on other sites More sharing options...
HunterBoss Posted September 1, 2010 Share Posted September 1, 2010 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 Link to comment Share on other sites More sharing options...
HunterBoss Posted September 1, 2010 Share Posted September 1, 2010 and, if I have updates that I find, I'll try to remember to return the favor and post an updated table here Link to comment Share on other sites More sharing options...
Lee Smith Posted September 1, 2010 Share Posted September 1, 2010 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 Link to comment Share on other sites More sharing options...
HunterBoss Posted September 7, 2010 Share Posted September 7, 2010 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 Link to comment Share on other sites More sharing options...
Newbies RionaReese Posted September 27, 2010 Newbies Share Posted September 27, 2010 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 Link to comment Share on other sites More sharing options...
Newbies gowa Posted April 11, 2012 Newbies Share Posted April 11, 2012 There's this one. ZIP Code Database, Maps, and Boundary Data http://www.zip-codes.com/ Link to comment Share on other sites More sharing options...
ron G Posted May 22, 2012 Author Share Posted May 22, 2012 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. Link to comment Share on other sites More sharing options...
Lee Smith Posted May 22, 2012 Share Posted May 22, 2012 The link does not work. Its been over 2 years, ******* happens! Link to comment Share on other sites More sharing options...
Newbies informbd Posted March 11, 2014 Newbies Share Posted March 11, 2014 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. Link to comment Share on other sites More sharing options...
LaRetta Posted March 11, 2014 Share Posted March 11, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3725 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now