Zipe Code Locator

[prashidi]

Maybe you can post those values somewhere on hotscripts or something similar to that. I doubt that the person who started this thread is seeking the information but it would be good to have it somewhere just in case someone else does.

[zoordaan]

Everah, could you make those files available as a zip etc.?

[Everah]

Sorry for not getting back to you sooner, I thought this thread died.

Everah, could you make those files available as a zip etc.?

Sure, what would you like? After looking at my files, I have a really accurate datafile (52,600 US Zipcodes with lats, longs, states, GMT offsets) but they are nowhere near SQL ready, so you will have to either edit the file or write a script to get them into a table. I also have a flatfile with just cities and zips. I have another datafile that is SQL ready, but it only has zips, lats and longs and is only 42,000 lines, so I am not sure how accurate it is. I also have a MySQL command line that will pull all records in a client table that are within a proximity to a supplied zip code using spherical surface distance of the Earth.

Just let me know. And again, sorry for not checking this out sooner.

[zoordaan]

Probably the first option, and I'll just write something to carve it up however I want it. And the mysql command line too.

I use winrar 3.2 for compressed files so a zip or rar is good.

Thanks

As for the thread dying, I've been interested in this topic for a few years so it's in my subscribed threads and I always check back whenever someone posts to it

[Everah]

Probably the first option, and I'll just write something to carve it up however I want it. And the mysql command line too.

I use winrar 3.2 for compressed files so a zip or rar is good.

Thanks

As for the thread dying, I've been interested in this topic for a few years so it's in my subscribed threads and I always check back whenever someone posts to it

OK, give me a couple of days. The file I have that is the most accurate is now in two formats; MySQL AND flat text. The MySQL ready version is formatted to insert with my table name. I can run a dump to get the table structure and zip data all in one file (but again, it will have my table name in it). How do you want it?

[zoordaan]

The mysql with the dump structure is fine.

[Everah]

The mysql with the dump structure is fine.

OK, go to this link:
http://www.purelyauto.com/zipcodes/p...p_codes.sql.gz

The file is about 970K gzipped. Extracted and installed it is about 3.5 MB.

Good luck!

PS If anyone is looking for a goodwill gesture to offer for this data, my automotive forum just went up and could use some members

[zoordaan]

Thanks. I've downloaded the zip file.

[beetle]

I wrote a class for this almost two years ago. I can't find all the code right now, but I managed to dig up the SQL query I used from an old post I made here.

$sql = "
    SELECT
        $this->zipCol 
    FROM
        $this->zipTable 
    WHERE (    
        POW((69.172*($this->lonCol-\"$this->lon\")*cos($this->lat/57.3)),2) +
        POW((69.172*($this->latCol-\"$this->lat\")),2)
        ) < ($this->radius*$this->radius)
    "; 

As you can see, I use quite a few member variables, but you should be able to put your own data in there.

This is a sql query that performs the arithmetic of the haversine forumla - something you absolutely need when doing lat/lon stuff.

[ReindeerF]

OK, go to this link:
http://www.purelyauto.com/zipcodes/p...p_codes.sql.gz

The file is about 970K gzipped. Extracted and installed it is about 3.5 MB.

Good luck!

PS If anyone is looking for a goodwill gesture to offer for this data, my automotive forum just went up and could use some members

Hey thanks!

I lurk these forums a lot looking for code help and today they provided me with a free zip database that I thought was going to be impossible to find. I thought I'd register and say thanks for the help

p.s. - I'd help by joining the auto forum but I have absolutely no interest in automotive stuff so I don't think it'd do much good sorry.

[mrWoot]

Wonderful. Just wonderful. I was wondering if anyone has a full script done? I'm almost done with mine.

[mrWoot]

I wrote a class for this almost two years ago. I can't find all the code right now, but I managed to dig up the SQL query I used from an old post I made here.

$sql = "
    SELECT
        $this->zipCol 
    FROM
        $this->zipTable 
    WHERE (    
        POW((69.172*($this->lonCol-\"$this->lon\")*cos($this->lat/57.3)),2) +
        POW((69.172*($this->latCol-\"$this->lat\")),2)
        ) < ($this->radius*$this->radius)
    "; 

As you can see, I use quite a few member variables, but you should be able to put your own data in there.

This is a sql query that performs the arithmetic of the haversine forumla - something you absolutely need when doing lat/lon stuff.

I figured out what everything was except $this->lonCol and $this->latCol. What are those?

[beetle]

Those are column names in the DB that hold the necessary latitude and longitude coordinates.

[Everah]

Hi everyone. I hope the zipcode data has been helpful. I am going to be taking the data down tonight. There has been an awful lot of folks downloading the thing, so I believe I am going to take it a step further and package a locator. I am finishing up a class right now that will search the database for clients that are in a proximity to a user. That is what I was looking for originally.

Can I get an opinion? If this data was sold at a fair price (say $10), would you have considered buying it? All responses are welcome. Thanks for your feedback.

[DmS]

I did this recently, try this out.
Zipcodes, + PHP/MySQL queries
http://www.ozoneasylum.com/21781

Cheers/Dan