| 11:23 pm on Sep 2, 2004 (gmt 0)|
I can give you some US links:
U.S. Gazetteer: 2000 and 1990 [census.gov]
T I G E R [census.gov]
| 11:27 pm on Sep 2, 2004 (gmt 0)|
There's a free one on SourceForge at
I haven't used it, myself, but I will warn you I've heard it's not entirely up-to-date or thorough.
(You get what you pay for... in other words).
| 11:52 pm on Sep 2, 2004 (gmt 0)|
I used a free PHP script from Sanisoft called "Ziploc" that you can use for applications where you'd like customers to find a "store" or "dealer" near them.
... uses a database of zip codes and latitude and longitude, which is included (USA only, I believe).
|Small Website Guy|
| 1:28 am on Sep 3, 2004 (gmt 0)|
A database of zipcodes, with the latitude and longitude of the geogrpahical center, can be purchased quite inexpensively. I think I paid $40 a year ago.
You calculate the distance using the Pythagorean Formula. Hope you remember your high school algebra clss.
| 8:51 am on Sep 3, 2004 (gmt 0)|
Shannon: great link, I'll try that! (don't need pinpoint accuracy yet). I've also been looking for ages for one that does Belgian 'postcodes' (equivalent of zip codes), other European db's would also be nice if anyone has got any.
| 5:37 pm on Sep 4, 2004 (gmt 0)|
Actually, Small Website Guy, the Pythagorean Formula becomes inaccurate the greater the distance, because you're calculating distance across a sphere, and not a flat plane.
To be accuate, you need to use a little calculus... or someone's script.
|Small Website Guy|
| 8:47 pm on Sep 4, 2004 (gmt 0)|
If you account for the fact that the distance between longitude lines grows smaller, then the Pythagorean Formula will work just fine for locations in the United States.
| 12:06 am on Sep 6, 2004 (gmt 0)|
"Great Circle" distance calculation is probably more accurate.
However, most of the cheap zip code lists are inaccurate to start with, and unless you go with a very expensive solution, you won't be getting anything very accurate. Even when accurate, those are only centroids- the center most point inside a zip/postal code- customers can be quite a bit away from the center of the postal code.
Not only that, those distances are not driving distances. When I used online dating sites, they consistently messed up distance from my home because they didn't account for the harbour. I could swim there as fast as I could walk there.
All that to say... this is not incredibly accurate, so I wouldn't sweat the small stuff. It's more important to get the UI in a decent shape then fret about theoretical accuracy.
| 4:43 am on Sep 6, 2004 (gmt 0)|
Good points, danieljean.
Regarding the calcs...
One of my first web-based trigonmetric applications was a distance calculator. I enjoyed the project tremendously and did some extensive testing on formulas.
I prefer a second version of the Haversine formula developed by Bob Chamberlain. It will give mathematically and computationally exact results, except when the two points are antipodal (on opposite sides of the Earth), then the formula is ill-conditioned, but the error, perhaps as large as 1 mile, is in the context of a distance near 12,000 miles. Bob has graciously granted use of the formula with no more than a humble request of recognition and a link to the census bureau site...
Mr. Chamberlain's discussion and the formula:
| 1:21 pm on Sep 6, 2004 (gmt 0)|
You can free distance calculation from this website.
You can subscribe full zip code database with latitude and longitude from [zipcodeworld.com...]