zip code DB? - GoFuckYourself.com

farkedup · 04-25-2008, 04:43 PM

anybody have a DB of zip codes? I need something that has the city and state for me so instead of filling in those 2 fields I'll only have to put in the zip code.

AlienQ - BANNED FOR LIFE · 04-25-2008, 05:06 PM

Lee Noga!

farkedup · 04-25-2008, 05:25 PM

http://www.micahcarrick.com/04-19-20...lculation.html

ended up importing that DB and yanking out the shit I didn't need so many places trying to charge for this LOL

brandonstills · 04-25-2008, 05:30 PM

google is your friend. I remember it took me a while to find one but you can find freely available ones that are a few years old.

GrouchyAdmin · 04-25-2008, 07:19 PM

This is the best one I've found.

GrouchyAdmin · 04-25-2008, 07:40 PM

They updated in Jan '08. I figured I might as well get a new import. This is a really bad DB schema, but it was mostly just to get it out of CSV. Enjoy.

Code:

CREATE TABLE `zipCityData` (
  `localid` int(10) NOT NULL auto_increment,
  `zip` varchar(5) NOT NULL,
  `city` varchar(64) NOT NULL,
  `state` varchar(2) NOT NULL,
  PRIMARY KEY  (`localid`),
  KEY `zip` (`zip`)
) TYPE=INNODB  AUTO_INCREMENT=41755;

localid is just for a numeric index so you have a non-zipcode key. Since this is probably going into MySQL of an unknown version (3.2.23 to 5.x), I decided to ensure it wouldn't corrupt the numbers by making them varchar. Whatever you wanna do with it, it's yours.

04-25-2008, 04:43 PM	#1
farkedup Confirmed User Join Date: Nov 2007 Location: Kalamazoo, MI Posts: 2,490	zip code DB? anybody have a DB of zip codes? I need something that has the city and state for me so instead of filling in those 2 fields I'll only have to put in the zip code. __________________ -- QUOTE ME IT MAKES ME FEEL SPECIAL --

04-25-2008, 05:06 PM	#2
AlienQ - BANNED FOR LIFE best designer on GFY Join Date: Mar 2003 Location: IALIEN.COM - High Definition Video and Photographic Productions -ICQ 78943384 Posts: 30,307	Lee Noga! __________________ NAKED HOSTING FTW!11 I'm On The INSANE PLAN $9.95/mo! \| The Alien Blog Adult News Worth Reading Updated Daily \| Content For Sale! 641 PICS 216 MINUTES OF VIDEO $350.00 \|ICQ: 78943384 \|

04-25-2008, 05:25 PM	#3
farkedup Confirmed User Join Date: Nov 2007 Location: Kalamazoo, MI Posts: 2,490	http://www.micahcarrick.com/04-19-20...lculation.html ended up importing that DB and yanking out the shit I didn't need so many places trying to charge for this LOL __________________ -- QUOTE ME IT MAKES ME FEEL SPECIAL --

04-25-2008, 05:30 PM	#4
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	google is your friend. I remember it took me a while to find one but you can find freely available ones that are a few years old. __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

04-25-2008, 07:19 PM	#5
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	This is the best one I've found. __________________ AIM: GrouchyGfy

04-25-2008, 07:40 PM	#6
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	They updated in Jan '08. I figured I might as well get a new import. This is a really bad DB schema, but it was mostly just to get it out of CSV. Enjoy. Code: CREATE TABLE `zipCityData` ( `localid` int(10) NOT NULL auto_increment, `zip` varchar(5) NOT NULL, `city` varchar(64) NOT NULL, `state` varchar(2) NOT NULL, PRIMARY KEY (`localid`), KEY `zip` (`zip`) ) TYPE=INNODB AUTO_INCREMENT=41755; localid is just for a numeric index so you have a non-zipcode key. Since this is probably going into MySQL of an unknown version (3.2.23 to 5.x), I decided to ensure it wouldn't corrupt the numbers by making them varchar. Whatever you wanna do with it, it's yours. __________________ AIM: GrouchyGfy