Welcome to WebmasterWorld Guest from 107.20.34.173

Forum Moderators: phranque

Message Too Old, No Replies

How do you translate zipcodes into city/states

     

smithaa02

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

10+ Year Member



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?

Philosopher

6:23 pm on Nov 18, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.

smithaa02

7:34 pm on Nov 18, 2005 (gmt 0)

10+ Year Member



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

smithaa02

8:08 pm on Nov 18, 2005 (gmt 0)

10+ Year Member



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?

TheDoctor

9:15 pm on Nov 20, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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 :(

txbakers

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

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



get the 404, then take off the last period (dot) to get the zip file.

txbakers

1:09 am on Nov 21, 2005 (gmt 0)

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



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

Featured Threads

Hot Threads This Week

Hot Threads This Month