On Fri, May 21, 2010 at 9:19 PM, Frank Bax <fbax@sympatico.ca> wrote:
I'd like to create a small database for GPS positions that are currently in the format "N 42° 57.750 W 081° 37.200".
What's an easy way to store these points and how would I query data, if if the only question I need answered is:
Which positions are within 5km of a given position; where "within" can be a square or circle or whatever; accuracy is not critical (let's say 0.5km) is accurate enough for my purposes.
Are there datatypes within base install of pgsql to do this?