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?
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2010-05-22 01:22:12|
|Subject: Re: GPS positions|
|Previous:||From: Andreas||Date: 2010-05-22 00:04:09|
|Subject: Re: Best starter book|