Welcome to WebmasterWorld Guest from 54.224.164.166

Forum Moderators: phranque

Message Too Old, No Replies

How do you translate zipcodes into city/states

     
5:59 pm on Nov 18, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:June 24, 2005
posts:446
votes: 0


I collect zipcodes on my website and want to display the zipcodes with their appropriate cities and states so I know where my users are coming from. How would I do this? I was thinking about having php parse a text file with zipcode state/zip fields, but I can't find this type of information on the net. Does anybody know where you can download zipcode information or if there is any other easy way to do this?
6:23 pm on Nov 18, 2005 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 28, 2002
posts:994
votes: 2


do a quick search for "zip code database". It brings up a number of sites selling zip code databases. It's then a simple matter of comparing the entered zip to the db to know where they are.
7:34 pm on Nov 18, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:June 24, 2005
posts:446
votes: 0


If anyone is interested I found a mysql table dump containing all the zipcodes and their information for free at [civicspacelabs.org...]
8:08 pm on Nov 18, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:June 24, 2005
posts:446
votes: 0


The table I found actually include latitude and longitude for each zip code. Does anybody know a simple way to overlay this information over a dynamic map with php/mysql? So a map of the US would appear and dynamic points would be generated on the map where users supplied their zip codes?
9:15 pm on Nov 20, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 6, 2003
posts:661
votes: 0


If anyone is interested I found a mysql table dump containing all the zipcodes and their information for free at [civicspacelabs.org...]

This produces a 404 :(

10:56 pm on Nov 20, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


get the 404, then take off the last period (dot) to get the zip file.
1:09 am on Nov 21, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


be careful though, the first 7 lines were wrong, which makes me suspect the rest of the file.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members