Hi 58sniper,

i also found this page during my google search but question:

Did you try to download at least one of these files ? You would not believe it, but NONE of them work. Thanks so far but this link does not help.

I am currently investigating the first link from Oly51. Let's hope i can use this data.

Cheers,

I do have a MySQL database with 40,000+ zips in it if you need it....

Hi 58sniper,

what i need is a SQL file/source file like:

City, x-location, y-location, ZIP codes

Example:

'San Francisco', '37.65863', '122.30839','94005 94014 94044 94066 94080'

If you can provide this for US for all ZIP codes, then yes. Otherwise no.

Cheers,

Hi oly51,

i just checked out this data. This data is correct and includes the correct GEO locations ... BUT ... i am missing one important part in this database: the City names. This DB is useless for me without the city names like

94005 San Francisco x y

What they have is:

CA94005 x y

I do not know how i can get the city names into this db with all these zip codes. But this is the best source so far. With the city names this would be perfect and i could start working on the US version of this hack. But without ... no.

Cheers,

42741 zip codes here. This is the best I could do.
It's in the format:

99950 +55.542007 -131.432682 Ketchikan AK Ketchikan Gateway Standard

Which is zip, lat, lon, city, state, county, class

The only thing that this is missing (that I've determined) is the aliases. Some zips (mine included) are actually used in more than one city. Only the primary city is listed.

Hi 58sniper,

just for my understanding: What do you mean with aliases are missing ? The format i need is, that one city can have multiple ZIP codes or suburbs. In this case i have to choose one name for the city and add all the ZIP codes to this city. This is what i need. Is this what you mean ?

And another question: You can provide 42741 ZIP codes. How many are there in total ? Any idea ? So how many are you missing ?

Cheers,

As far as I know, that includes all of the zip codes in the US. Some will say that there are more than 70,000, but that's not entirely true.

In my case:
48315 is my zip code. But that zip code is used in Utica, and in Shelby Twp (where I live).

If I look up my zip code, it's in the database, but only listed as Utica. Some databases would list it twice, once with each city name. Mine lists them once with the primary city. No duplicates.

Ok. Let me check what i can do here. I will come back to you if i can use this file. Thanks so far.

Cheers,

Here's a MySQL dump of a Zip code dB

Ui. This looks good. I will install this into a db and i have run a couple of queries to make it distinct but this looks like the best source so far. Let me check now.

Now i have 2 sources where i can check. I hope one of them will work.

Thanks so far and now please be patient. In the meantime i need volunteers to install this hack on their servers and obviously this volunteers should be located in US. Who wants to be the BETA tester ?

Please make sure that you get the prerequisites running before i give you the data.

Cheers,