thanks Adam,
I will have a play with that.
On 5/22/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
Enjoy…
SELECT suburbId, suburbName
FROM suburb
WHERE ROUND((ACOS((SIN(#suburb_latitude#/57.2958) * SIN(suburb_latitude /57.2958)) + (COS(#suburb_latitude#/57.2958) * COS(suburb_latitude /57.2958) * COS(suburb_longitude/57.2958 - #suburb_longitude#/57.2958 * 3963, 3) <= #val(surroundingRadiusMiles)#
There are other ways.. like just passing in a suburbId and surroundingRadiusMiles.. but I will leave that to you!! ;)
Cheers,
Adam
From: Taco Fleur [mailto:
[EMAIL PROTECTED]] Sent: Monday, 22 May 2006 8:56 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] [OT] Long & Lat query
Is anyone able to share a query with me that will calculate surrounding suburbs on a longitude and latitude database?
I have the database, but not the query.
Thanks-- Taco Fleur -
http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry leader with commercial IT experience since 1994 …
-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions
an industry leader with commercial IT experience since 1994 …
