On Jan 25, 10:57 am, srikanth <[email protected]> wrote: > > Data is provided fromhttp://220.225.231.147/gmaps/testing.asp > using SQL Query
The first result contains lat="37.386339" lng="-122.085823" distance="2627.24169360985" which is obviously incorrect. If that is generated by this query... > select top 10 * from (SELECT *, ( 3959 * acos( cos( radians(37) ) * > cos > ( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin > ( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM maps ) as > results where distance < 10000 ...then it's obviously calculating the distance incorrectly. Your formula is correct as the spherical law of cosines, so I guess that it's calculating the distance correctly and the points you are measuring are wrong. You do get the results you're getting if your "lat" variable is zero and you measure the distance from the equator. Perhaps that will give you something to look at. As an aside, you are introducing extra spaces into your XML when you encode the special characters, but that's not related to distance calculations. Andrew -- You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.
