US and Canadian zipcode/city db needed...

**Phoenix** · 04-28-2009, 08:04 AM

i think the ip data guys can give you this

you can get either...city and state...or also...city state and zip/postal code

**fris** · 04-28-2009, 08:12 AM

http://www.zipcodedownload.com/

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

http://www.zipcodeworld.com/

http://www.zipcodeguy.com/blog/free-zip-code-database/

**ExLust** · 04-28-2009, 08:37 AM

Thanks fris.

**acctman** · 04-28-2009, 08:53 AM

Originally posted by fris

http://www.zipcodedownload.com/

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

http://www.zipcodeworld.com/

http://www.zipcodeguy.com/blog/free-zip-code-database/

thanks, i think i'm going to go with this one http://www.zip-codes.com/zip-code-database.asp the standard package seems to have everything I need plus a 1yr sub.

**acctman** · 04-28-2009, 09:11 AM

which format would be more compatible with MySql?
Microsoft® Access
Microsoft® Excel
dBASE IV
Comma-delimited ASCII

**nation-x** · 04-28-2009, 09:14 AM

Originally posted by acctman

thanks, i think i'm going to go with this one http://www.zip-codes.com/zip-code-database.asp the standard package seems to have everything I need plus a 1yr sub.

I am using that exact package... it's pretty up to date. I used the comma delimited version and I think they have a mysql schema and instructions to import the data in the members area...

**rowan** · 04-28-2009, 09:49 AM

Originally posted by acctman

which format would be more compatible with MySql?
Microsoft® Access
Microsoft® Excel
dBASE IV
Comma-delimited ASCII

Comma delimited (CSV) is probably the best since it's a neutral (and human readable) format. You should be able to import it into a mysql database with a single LOAD DATA INFILE command.

**fusionx** · 04-28-2009, 09:53 AM

Whatever you use, be sure to get one with a subscription to monthly changes. It's amazing how often zip codes split and merge.

**koreanbbque** · 04-28-2009, 10:33 AM

http://www.maxmind.com/app/geolitecity

Lite is their free version and it's available in CSV to import into a db.

US and Canadian zipcode/city db needed...

US and Canadian zipcode/city db needed...

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment