Help with storing spatial (map coordinates) data?

From: John Tregea <john(at)debraneys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with storing spatial (map coordinates) data?
Date: 2006-06-12 06:18:19
Message-ID: 448D072B.6030200@debraneys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have recently switched to PostgreSQL and had no problem bringing our
existing (my)SQL databases and data into the environment. I am now
extending the functionality of our databases and want to start storing
spatial information.

The information is made up of latitude and longitude coordinates that
define a point or location on the earth's surface. e.g. degrees, minutes
and seconds north/south and degrees, minutes and seconds east/west.

I have read up on custom data types (with input and output functions) in
the docs but am not sure if that is the best way to go. Can anyone point
me to a simple, workable implementation of storing and managing this
type of data or advise me on how to structure a series of fields that
could combine to the required string?

I am running postgreSQL 8.1.4 under WinXP Pro and currently evaluating
an X-Talk front end called Revolution for the GUI development and have
only some general experience with SQL.

Thanks in advance

John Tregea

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2006-06-12 06:34:41 Re: Help with storing spatial (map coordinates) data?
Previous Message A. Kretschmer 2006-06-12 05:01:53 Re: can i use a string in where clause such as "id in (str)"