Re: storing latitude and longitude - Mailing list pgsql-general

From Gregory Williamson
Subject Re: storing latitude and longitude
Date
Msg-id 8B319E5A30FF4A48BE7EEAAF609DB233021F2FBB@COMAIL01.digitalglobe.com
Whole thread Raw
In response to Re: storing latitude and longitude  ("Brent Wood" <b.wood@niwa.co.nz>)
List pgsql-general

Top posting because of a challenged reader ... try <http://postgis.refractions.net/> for packages and documentation.

Greg Williamson
Senior DBA
DigitalGlobe Inc


-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Brent Wood
Sent: Thu 7/10/2008 3:16 PM
To: markkicks@gmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] storing latitude and longitude

Hi Mark,

Look at Postgis, to do this properly. It adds full OGC spec support for managing spatial/querying spatial data within a Postgres database.

It is an option included with the Windows Postgres installer, but is generally extra packages under Linux.


Cheers,

   Brent Wood


>>> mark <markkicks@gmail.com> 07/11/08 5:34 AM >>>
hi..
i want to store latitude and longitude in a users table.. what is the
best data type to use for this? i want to be able to find use this
info to find users within a distance..
how do i go about doing this?
thanks

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Brent Wood"
Date:
Subject: Re: storing latitude and longitude
Next
From: Klint Gore
Date:
Subject: Top N within groups?