Programming Forums > Web Development and Design > PHP

jman05 · Nov 21st, 2006, 1:34 PM

Does anyone have this or know how to set it up? I also need it to find places by zip code search.

big_k105 · Nov 21st, 2006, 1:58 PM

http://geonames.usgs.gov/domestic/download_data.htm

it isn't a mysql db but you can import it someway I am sure, I haven't looked at the data so I am not sure how you would have to go about it but thought I would give you the link.

Pizentios · Nov 21st, 2006, 2:00 PM

well, i suggest looking at the mysql documentation. It holds the answer you seek.

I doubt there is a public accessible db with the information in it that you are seeking, you'll have to create your own.

Infinite Recursion · Nov 21st, 2006, 2:25 PM

A long time ago, I had a need for such a DB... I ended up writing a spider for usps.gov and pulled the zip codes along with their cities/states... not sure how their site is formatted now though... and I no longer have that particular DB.

DaWei · Nov 21st, 2006, 3:25 PM

You might also want to look through these and here and here.

Nov 21st, 2006, 1:34 PM	#1
jman05 Newbie Join Date: Nov 2006 Posts: 16 Rep Power: 0	A Mysql database of all us cities and states Does anyone have this or know how to set it up? I also need it to find places by zip code search.

Nov 21st, 2006, 1:58 PM	#2
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,650 Rep Power: 10	http://geonames.usgs.gov/domestic/download_data.htm it isn't a mysql db but you can import it someway I am sure, I haven't looked at the data so I am not sure how you would have to go about it but thought I would give you the link. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Nov 21st, 2006, 2:00 PM	#3
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	well, i suggest looking at the mysql documentation. It holds the answer you seek. I doubt there is a public accessible db with the information in it that you are seeking, you'll have to create your own. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Nov 21st, 2006, 2:25 PM	#4
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	A long time ago, I had a need for such a DB... I ended up writing a spider for usps.gov and pulled the zip codes along with their cities/states... not sure how their site is formatted now though... and I no longer have that particular DB. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Nov 21st, 2006, 3:25 PM	#5
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	You might also want to look through these and here and here. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

A Mysql database of all us cities and states