On Fri, May 21, 2010 at 9:19 PM, Frank Bax <fbax(at)sympatico(dot)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?
>
>
http://postgis.refractions.net/
Sean