<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by RBarryYoung
»
Calculate Distance in Miles from Latitude and...
48 posts, Page 1 of 5
1
2
3
4
5
»
»»
Calculate Distance in Miles from Latitude and Longitude
Rate Topic
Display Mode
Topic Options
Author
Message
RBarryYoung
RBarryYoung
Posted Friday, February 06, 2009 7:32 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
Comments posted to this topic are about the item
Calculate Distance in Miles from Latitude and Longitude
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #651657
Henk Schreij
Henk Schreij
Posted Tuesday, February 17, 2009 1:16 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, May 13, 2013 3:02 AM
Points: 235,
Visits: 560
Please could you supply us a "km version" of this nice script.
In Europe, Australia, Asia, etc. we don't use miles or feet. ;)
Post #658276
Tim Pain
Tim Pain
Posted Tuesday, February 17, 2009 2:52 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 42,
Visits: 672
Really neat and just what I was looking for.
Many thanks
Tim
Tim
Post #658315
jcrawf02
jcrawf02
Posted Tuesday, February 17, 2009 6:21 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:29 AM
Points: 2,551,
Visits: 18,885
RBarryYoung, am I missing something here? the function name is LatLonDistance(), but the tests use calculateDistance()?
Is there a missing piece to this, or is it just a naming convention typo?
Thanks,
Jon
---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #658425
kevin-657318
kevin-657318
Posted Tuesday, February 17, 2009 7:14 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, April 15, 2011 2:01 PM
Points: 2,
Visits: 19
Because the earth is not strictly spherical (it "flattens" a bit due to its rotation), there's a mathematical adjustment that can be made which makes the result even more accurate, given any two locations worldwide.
(I researched this about a year ago for a web application involving searching for points of interest within a specified radius of a reference point. I found various algorithms and chose one, which I translated to VBScript. It's nice to see the SQL implementation.)
Post #658477
jcrawf02
jcrawf02
Posted Tuesday, February 17, 2009 7:17 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:29 AM
Points: 2,551,
Visits: 18,885
kevin (2/17/2009)
Because the earth is not strictly spherical (it "flattens" a bit due to its rotation), there's a mathematical adjustment that can be made which makes the result even more accurate, given any two locations worldwide.
(I researched this about a year ago for a web application involving searching for points of interest within a specified radius of a reference point. I found various algorithms and chose one, which I translated to VBScript. It's nice to see the SQL implementation.)
And that adjustment is?
---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #658480
fredsimpson
fredsimpson
Posted Tuesday, February 17, 2009 7:19 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, February 15, 2012 6:37 AM
Points: 9,
Visits: 31
As you are using Lat/Long and I do not see any conversion, I am assuming that the distance is measured in Nautical Miles not Statute Miles is it not?
Post #658483
Ninja's_RGR'us
Ninja's_RGR'us
Posted Tuesday, February 17, 2009 7:27 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
Henk Schreij (2/17/2009)
Please could you supply us a "km version" of this nice script.
In Europe, Australia, Asia, etc. we don't use miles or feet. ;)
Just do Result time 1.6. Easy enough to include in the function :D.
Post #658492
Henk Schreij
Henk Schreij
Posted Tuesday, February 17, 2009 7:43 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, May 13, 2013 3:02 AM
Points: 235,
Visits: 560
Quote:
"Just do Result time 1.6. Easy enough to include in the function."
I was hoping for new constants in the formula ;)
But I realize the formula doesn't need a 6 or more numbers precision.
Post #658514
Ninja's_RGR'us
Ninja's_RGR'us
Posted Tuesday, February 17, 2009 7:48 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 21,357,
Visits: 9,539
I'm sure it's possible... but to avoid redoing 1 year of maths or waiting for someone to redo the calculations for that constant, I'll just take the small perf hit and do result * 1.6
.
Post #658522
« Prev Topic
|
Next Topic »
48 posts, Page 1 of 5
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
