Re: formula of findinf a distance between two zip codes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PC Datasheet (nospam_at_nospam.spam)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 15:32:41 GMT

E=MC2 happens to be Einstein's formula!

In the formula you reference, you aren't getting the distance between two
zipcodes; you're getting the distance between two points on the earth based on
certain assumptions. The two points being the centre of the region defined by a
zipcode and again assumptions are made regarding what constitutes a centre.
Trying to get the distance between two zipcodes as you asked is meaningless
because zipcodes do not define a a specific point.

Steve
PC Datasheet

"Galsaba" <galsaba@aol.com> wrote in message
news:20040718063111.12089.00001910@mb-m01.aol.com...
> PC Datashit, I am surprise to see your answer. (you wrote MC2..)
> Please see the next thread, which was not only more intelegent answer, i tried
> it and it also works!
>
> Aaron
>
> here are some thoughts
> http://sqljunkies.com/WebLog/ktegels/archive/2003/12/22/652.aspx
>

Relevant Pages

  • Re: Zip code
    ... >> I have a database of zipcodes with latitude and longitude. ... >> method of calculating the distance between two zipcodes. ... Imagine a circle of the specified range centred on the target zip code. ...
    (comp.lang.php)
  • Re: Zip code
    ... > I have a database of zipcodes with latitude and longitude. ... > method of calculating the distance between two zipcodes. ... Indexing latitude and longitude might help. ...
    (comp.lang.php)
  • Re: Zip code
    ... >>I have a database of zipcodes with latitude and longitude. ... >>method of calculating the distance between two zipcodes. ... have you looked at a zip code map for Manhattan? ...
    (comp.lang.php)
  • Zip code
    ... I have a database of zipcodes with latitude and longitude. ... method of calculating the distance between two zipcodes. ...
    (comp.lang.php)