I have compared some distance calculations between geopy and PostGIS ST_Distance_Sphere, and it seems that PostGIS ST_Distance uses a calculation that is similar to the great circle distance rather ...
Imagine a table of points of interest along with lat/long. The user identifies two of these points. I want to do the following: Calculate a great-circle path between these points Find all POIs that ...
Using PostGIS 2.0.0 I'd like to find the point on a LINESTRING that is closest to a given point. The LINESTRING represents a great circle line (ie. geography type). ST_ClosestPoint appears to do ...