Re: Latitude/Longitude data types and functions

Поиск
Список
Период
Сортировка
От Andrew Ayers
Тема Re: Latitude/Longitude data types and functions
Дата
Msg-id 40F42119.9080304@eldocomp.com
обсуждение исходный текст
Ответ на Latitude/Longitude data types and functions  (CSN <cool_screen_name90001@yahoo.com>)
Ответы Re: Latitude/Longitude data types and functions
Список pgsql-general
Janko Richter wrote:
> 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.

pgSphere looks interesting, for spherical coordinate systems. Does
anyone know of a similar module or project for cartesian coordinate systems?

Andrew Ayers
Phoenix, Arizona

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain
informationthat is privileged, confidential and exempt from disclosure under applicable law. If you are not the
intendedaddressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use,
copy,disclose or distribute to anyone the message or any information contained in the message. If you have received
thismessage in error, please immediately advise the sender by reply email, and delete the message. Thank you. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: Where may I find Windows native port
Следующее
От: Jerry LeVan
Дата:
Сообщение: