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?