DataTaunew | comments | leaders | submitlogin
Finding Nearest Neighbors in SQL (periscopedata.com)
7 points by jonathanbishop 3010 days ago | 2 comments


1 point by alexengler 3009 days ago | link

I don't think you can do euclidiean distance calculations like this. The distance associated with one degree of latitude changes as you move closer or further from the poles.

-----

1 point by mmitchell 3009 days ago | link

I believe you're correct. Terrestrial navigation usually uses non-euclidean spherical geometry so the haversine or great circle formulas would be more appropriate here. I've done similar analysis in the past and that's what I used.

-----




RSS | Announcements