Re: Format of Pioint datatype.... lat/long or long/lat??

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Format of Pioint datatype.... lat/long or long/lat??
Дата
Msg-id 52C34DFD.7050408@hogranch.com
обсуждение исходный текст
Ответ на Re: Format of Pioint datatype.... lat/long or long/lat??  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Format of Pioint datatype.... lat/long or long/lat??
Список pgsql-general
On 12/31/2013 2:34 PM, Adrian Klaver wrote:
>> point is just x,y, it doesn't understand the spherical lat/long math
>> (unless you install PostGIS and use its Geometry types which are fully
>> aware of spherical coords), that said, Latitude is generally used as X
>> (left/right, aka east/west), while Longitude is Y (up/down aka
>> north/south)
>
> I thought it was the other way around?


arrrgh, you're right.   LONGITUDE is east/west, LATITUDE Is
north/south.  so, its X = long, Y = lat.

doy!

sittin here at 37N


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



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

Предыдущее
От: peterlen
Дата:
Сообщение: Re: Format of Pioint datatype.... lat/long or long/lat??
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Format of Pioint datatype.... lat/long or long/lat??