A Good Zip Code Database Schema

[eluser]idealws[/eluser]
Hello,

I am new here to the forums as well as CI, but I am finding it to be very useful.

I noticed this thread about zip codes and figured I would give you what I have in hopes
it will be some help to you.

In the zip file you will find US zip codes something like 42,624 I believe it is complete.
Also I have included the Zipcode.php class that was listed in the wiki on this site.
I have modified the class to work with the database I have attached here. I hope this helps
those of you in need.

To use the class upload it to the library folder and call like so in your controller:

Code:

$this->load->library('zipcode');

After it has been loaded you can use it like this:

Code:

// Get the zip codes in range my miles
$this->zipcode->get_zips_in_range('92505', '10');

// Get the distance between two zip codes
$this->zipcode->get_distance('92505', '92555');

// Get the points for a zip code lat and lon
$this->zipcode->get_zip_point('92557');

// Get the zip details, lat, lon, city, stateprefix, state, county, areacode, timezone
$this->zipcode->get_zip_details('92557');

I think that pretty much sums it up. Again I hope this is some help to
those of you that were looking for a solution like myself.

Link to files: Download zip file

Regards,
Ray