Skip site navigation (1) Skip section navigation (2)

GPS positions

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: GPS positions
Date: 2010-05-22 01:19:15
Message-ID: BLU0-SMTP427AEFEABE670EB568CC04ACE50@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2010-05-22 01:22:12
Subject: Re: GPS positions
Previous:From: AndreasDate: 2010-05-22 00:04:09
Subject: Re: Best starter book

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group