Re: Format of Pioint datatype.... lat/long or long/lat?? - Mailing list pgsql-general

From John R Pierce
Subject Re: Format of Pioint datatype.... lat/long or long/lat??
Date
Msg-id 52C34DFD.7050408@hogranch.com
Whole thread Raw
In response to Re: Format of Pioint datatype.... lat/long or long/lat??  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Format of Pioint datatype.... lat/long or long/lat??  (Adrian Klaver <adrian.klaver@gmail.com>)
List 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 by date:

Previous
From: peterlen
Date:
Subject: Re: Format of Pioint datatype.... lat/long or long/lat??
Next
From: Adrian Klaver
Date:
Subject: Re: Format of Pioint datatype.... lat/long or long/lat??