Latitude/Longitude data types and functions

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Latitude/Longitude data types and functions
Date: 2004-07-12 18:52:59
Message-ID: 20040712185259.61556.qmail@web52906.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12 34'
N, 12 34' W.

Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?

Thanks


__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-07-12 19:03:47 Re: Latitude/Longitude data types and functions
Previous Message Florian G. Pflug 2004-07-12 18:31:15 (Again) Datacorruption using 7.4.2 on XFS/raid1