On 12/31/2013 03:06 PM, John R Pierce wrote:
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 a
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 Longitu
Perfect. That answers it. Thanks for providing that link.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Format-of-Pioint-datatype-lat-long-or-long-lat-tp5784939p5784960.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-
On 12/31/2013 02:16 PM, peterlen wrote:
Adrian - Thanks for the reply. The example was from
http://www.postgresql.org/docs/9.1/static/tutorial-populate.html with the
example of:
INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)');
That is not a valid coordinate but it is clear that t
On 12/31/2013 01:09 PM, John R Pierce wrote:
On 12/31/2013 12:45 PM, peterlen wrote:
PostgreSQL has a geometric data type of "point". The format is listed
as (x,
y) but I am not sure if the X is to represent latitude or longitude.
I have
seen different systems that us X for either. Typically,
John - Appreciate the response. The reason why I asked this question is
specifically for operations within PostGIS that will utilize the point
values and so it is pretty important that the point values are entered
correctly. Your description of X representing east/west and Y representing
north/so
Adrian - Thanks for the reply. The example was from
http://www.postgresql.org/docs/9.1/static/tutorial-populate.html with the
example of:
INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)');
That is not a valid coordinate but it is clear that they are trying to
declare it as longitude
On 12/31/2013 12:45 PM, peterlen wrote:
PostgreSQL has a geometric data type of "point". The format is listed as (x,
y) but I am not sure if the X is to represent latitude or longitude. I have
seen different systems that us X for either. Typically, coordinates should
be read as lat/long but I
On 12/31/2013 12:45 PM, peterlen wrote:
PostgreSQL has a geometric data type of "point". The format is listed as (x,
y) but I am not sure if the X is to represent latitude or longitude. I have
seen different systems that us X for either. Typically, coordinates should
be read as lat/long but I
PostgreSQL has a geometric data type of "point". The format is listed as (x,
y) but I am not sure if the X is to represent latitude or longitude. I have
seen different systems that us X for either. Typically, coordinates should
be read as lat/long but I have seen the opposite as well. An exampl
10 matches
Mail list logo
