Recent Posts
- (09/10) Fixing Warning: the ECDSA host key for 'github.com' differs from the key for the IP addressTAGS:Web Server Admin
- (12/26) CakePHP 3 - Getting List of Column Definitions from a Table (like schema())TAGS:CakephpCake3
- (09/14) Change Order of Loaded Behaviors in CakePHP 3TAGS:Cake3CakephpWeb ProgrammingPhp
- (05/29) CakePHP 3 - Accept JSON Header Only Working When Debug FalseTAGS:Web ProgrammingCakephpCake3
- (05/23) Remove All Events from Google Calendar (Reset Calendar)TAGS:Web ProgrammingPhp
- (11/08) Google Tag Manager (GTM) Not Firing Default PageView EventTAGS:Web ProgrammingJavascriptGoogle Tag Manager
- (10/13) In PHP, how do you get __toString() Magic Method Result without calling echo?TAGS:CakephpCake3Cakephp 13PhpWeb Programming
- (11/14) Getting output from shell_exec() at all timesTAGS:Web ProgrammingWeb Server Admin
Subscribe to my feed
MainelyDesign.com Blog
Best Free Mysql Zip code Database
Posted on 04/20/2010 at 04:42 pm by Kevin Wentworth
Viewed 20,144 times | 0 comments
I'm sure every developer reaches a point when they will need to use a mysql database of zip codes in the United States. Say you want to make a store locator and show how many miles a customer is from your store, or if you have some custom php logic that uses zip codes, you will inevitably need a mysql database of zipcodes.
The Best Free Mysql Zip Code Database
So here it is- my vote for the best database of zipcodes available in native mysql format on the Internet. From my limited testing and usage of this database it doesn't have any errors. Best of all it was updated within the past year. I would love to know about any errors people have found and if there is a better zipcode database out there.
Want a Great Zipcode Database without Portsmouth, NH?
If you're interested, I was using another zipcode database in production. At the time I was living in Portsmouth, NH and did a search using the 03801 Portsmouth zip code, and it didn't come up (I think, or it was mis-coded, it's been a long time). I had searched for 'Open Source Mysql Zip Code Database' and it obviously came up. I looked around for a better solution (i.e. one that had been updated prior to 2005) but my search didn't result in anything better.
Hopefully after the 2010 census is complete and the zip code information becomes public, the database above will be more accurate. Until then, use the first database.
Cheers,
-Kevin Wentworth
Tags for Best Free Mysql Zip code Database
Web Programming | Usage | Database | Mysql | Php
Comments for this Posting
No comments. Be the first to post a reply.
Sorry, comments are closed for this posting.
Please Email Kevin if you have any questions. Thanks!