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

CSN wrote:
> 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
>

Have a look at pgSphere
   http://gborg.postgresql.org/project/pgsphere/projdisplay.php

It has no release yet, but I want to do it this summer.
Check it out and send me possible bug reports.

Regards,
   Janko Richter