Postgres Pro
Downloads
Home   >   mailing lists

Latitude/Longitude data types and functions - Mailing list pgsql-general

From CSN
Subject Latitude/Longitude data types and functions
Date
Msg-id 20040712185259.61556.qmail@web52906.mail.yahoo.com
Whole thread Raw
Responses Re: Latitude/Longitude data types and functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Latitude/Longitude data types and functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Latitude/Longitude data types and functions  (Janko Richter <jankorichter@yahoo.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: (Again) Datacorruption using 7.4.2 on XFS/raid1
Next
From: Bruce Momjian
Date:
Subject: Re: Latitude/Longitude data types and functions