[postgis-users] How to store coordinates correctly

[Burgholzer,Robert]

Marcelo,

What you are looking for is a POINT or MULTIPOINT geometry type.  This needs to be stored as decimal degrees, so yes, you should convert it from "Degrees,Minutes,Seconds" before putting it into the table.

 

Chapter 4 in the docs has a good example along with data and insert statements that should prove to be quite illuminating.

 

http://postgis.refractions.net/docs/ch04.html#id2592221 

 

Robert W. Burgholzer

Surface Water Modeler

Office of Water Supply and Planning

Virginia Department of Environmental Quality

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of MaRcELo PeReiRa
Sent: Monday, May 26, 2008 10:19 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] How to store coordinates correctly

 

Hi there,

It's my first post in this list, and here is my first question:

Which is the correct way to store in a table some geografic coordinates???

I have a point: 
- S 22º 04' 2,5''
- W 46º 50' 34,9''

How can I store it??? Should I convert it??

Thanks in advance,
Marcelo / Brasil

-- 
People are very open-minded about new things - as long as they're exactly like the old ones. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080527/0dad14ad/attachment.html>