| Author |
Topic |
|
JustinBigelow
SQL Gigolo
1157 Posts |
 Posted - 2004-05-09 : 14:11:39
|
Hey everybodyI haven't posted in awhile due to work  But now I'm stuck and have decided to come crawling back to the community to look for help bailing my ass out  Anyway, I need either a UDF or sproc that implements the Haversine Function http://www.census.gov/cgi-bin/geo/gisfaq?Q5.1To sum up what it does is it takes a Latitude and Longitude (in decimal form) and compares it against another Latitude and Longitude and returns the distance. I need to get that number in miles or kilometers. Normally I would bust out the old trig notes and give it whirl myself but I need this done before Christmas so that rules me out. I'm willing to pay for this, either via Paypal or Money Order. Anybody interested drop me a line, Thanks.Justin"Hit me with a shovel 'cause I can't believe I dug you." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-05-09 : 22:55:08
|
| Dude, you suck at google http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci523000,00.html?Offer=dbtraff09Damian |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2004-05-10 : 01:34:44
|
| It was that damn "function" word that screwed me. Caused a whole bunch of postgre crap to bubble up to the top. But thanks! "Hit me with a shovel 'cause I can't believe I dug you." |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2004-05-10 : 09:19:01
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12572 |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-10 : 11:28:06
|
| Great Circle?http://gc.kls2.com/faq.html#$gc-calcBrett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2004-05-10 : 15:32:11
|
quote:
Originally posted by X002548
Also...http://mathworld.wolfram.com/search/What are you doing where you need to know distance?Routing algorithyms?
Search rings. Finding buildings with matching criteria within a designated target radius."Hit me with a shovel 'cause I can't believe I dug you." |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-05-10 : 15:48:27
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30843&SearchTerms=zipcode |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2004-05-10 : 17:51:02
|
You guys kick ass! Never again shall I stray from SQL Team (I went straight to google and didn't even bother searching here, I feel like such an amatuer )Justin"Hit me with a shovel 'cause I can't believe I dug you." |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-05-11 : 10:40:02
|
| Well you've got a lot to keep you busy and all, what with the gigilo thing and allBrett8-) |
|
|
|
|
Haversine function