Archives of the TeradataForum

Message Posted: Thu, 17 May 2001 @ 11:10:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hey,

Has anyone ever tried to calculate the Great Circle Distance (GCD) using SQL? GCD is the distance between to places.

GCD can be calculated using the lattitude and logitude of two places as follows:

GCD = 60 * arccos[ sin(Lat1)*sin(Lat2) +
cos(Lat1)*cos(Lat2)*cos(abs(Lon1-Lon2))]

I know 4. something will have trig functions - but if someone has worked it out without them, I would be most appreciative.

Thanks,

Bob Doss

Spirit Lake Consulting Pty. ltd.

	<Prev	Next>		<<First	<Prev	Next>	Last>>