By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

converting POINT(-43.16 -0.876) to Latitude and Longitude

P: 2
Hi, Postgresql/PostGIS Guru

I am new for both Postgresql/PostGIS and need help for converting point () to latitude and longitude degrees using some kind of PostGIS functions. I have a ship's point position in my postsql table as:

ship-name POINT(-43.18375956 -0.87618425) and want to get the position in degrees. An example will be greatly appreciated.

Thanks

Monkey
Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
Hi, Postgresql/PostGIS Guru

I am new for both Postgresql/PostGIS and need help for converting point () to latitude and longitude degrees using some kind of PostGIS functions. I have a ship's point position in my postsql table as:

ship-name POINT(-43.18375956 -0.87618425) and want to get the position in degrees. An example will be greatly appreciated.

Thanks

Monkey
Maybe degrees function would help. See here
http://www.postgresql.org/docs/8.1/s...ions-math.html
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.