Hello folks,

Anyone worked with coordinates ? What would be a good practise and format to
store coordinates data ? Data type ? Degrees and minutes as integers and
seconds as float ? Maybe a composite ?

TIA,

--
Aarni Ruuhimäki
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core** linux system
--------------

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Depending on what you would like to do with the co-ordinates, you
should check out PostGIS in the contrib modules - You can store all
kinds of geographical data with indexes for efficient queries:

http://postgis.refractions.net

I'm planning on using it, but haven't started playing yet so can't
give you specific advice - Sorry!


On 12/7/05, Aarni Ruuhimäki <aarni@kymi.com> wrote:
> Hello folks,
>
> Anyone worked with coordinates ? What would be a good practise and format to
> store coordinates data ? Data type ? Degrees and minutes as integers and
> seconds as float ? Maybe a composite ?
>
> TIA,
>
> --
> Aarni Ruuhimäki
> --------------
> This is a bugfree broadcast to you
> from **Kmail**
> on **Fedora Core** linux system
> --------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org