| From: | "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com> |
|---|---|
| To: | "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz>, <markkicks(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: storing latitude and longitude |
| Date: | 2008-07-10 22:33:07 |
| Message-ID: | 8B319E5A30FF4A48BE7EEAAF609DB233021F2FBB@COMAIL01.digitalglobe.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org on behalf of Brent Wood
Sent: Thu 7/10/2008 3:16 PM
To: markkicks(at)gmail(dot)com; pgsql-general(at)postgresql(dot)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(at)gmail(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klint Gore | 2008-07-11 03:24:28 | Top N within groups? |
| Previous Message | Brent Wood | 2008-07-10 22:16:16 | Re: storing latitude and longitude |