Re: Coordinates question - Mailing list pgsql-novice

From Neil Saunders
Subject Re: Coordinates question
Date
Msg-id ddcd549e0512070248o3ad7bc74o5419ff550ef3c27e@mail.gmail.com
Whole thread Raw
In response to Coordinates question  (Aarni Ruuhimäki <aarni@kymi.com>)
List pgsql-novice
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
>

pgsql-novice by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Coordinates question
Next
From: John DeSoi
Date:
Subject: Re: Pl/pgsql import