Member
> ---
>
>
> > From: Hank <[EMAIL PROTECTED]>
> > Reply-To: Hank <[EMAIL PROTECTED]>
> > Date: Sun, 9 Oct 2005 11:12:10 -0400
> > To: "Steffan A. Cline" <[EMAIL PROTECTED]>
lications
Lasso Partner Alliance Member
---
> From: Hank <[EMAIL PROTECTED]>
> Reply-To: Hank <[EMAIL PROTECTED]>
> Date: Sun, 9 Oct 2005 11:12:10 -0400
> To: "Steffan A. Cline" <[EMAIL PROTECTED]>
>
Don't forget that you're not caclucating "driving distance", but
"great circle" distance, which is roughly a straight line over short
distances. If you radius is great than, say 50 miles, people might
complain that the actual driving distance is much greater than the
straight line distance you pro
> To: "mysql@lists.mysql.com"
> Subject: Distance between Zip codes
>
> I was wondering if anyone might have a canned query I could use for the
> following scenario.
>
> I need to search for a list of locations within a certain distance of a user
> given zip code
tions
Lasso Partner Alliance Member
---
> From: "Steffan A. Cline" <[EMAIL PROTECTED]>
> Date: Sat, 08 Oct 2005 15:59:35 -0700
> To: "mysql@lists.mysql.com"
> Sub
At 05:59 PM 10/8/2005, you wrote:
I was wondering if anyone might have a canned query I could use for the
following scenario.
I need to search for a list of locations within a certain distance of a user
given zip code and order them by driving distance calculated from a table of
zip codes contai
I was wondering if anyone might have a canned query I could use for the
following scenario.
I need to search for a list of locations within a certain distance of a user
given zip code and order them by driving distance calculated from a table of
zip codes containing lon and lat info from zipwise.
