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

From: peterlen <peteralen(at)earthlink(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Format of Pioint datatype.... lat/long or long/lat??
Date: 2013-12-31 22:16:23
Message-ID: 1388528183783-5784953.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 (-194) for x and latitude (53) for y. Yes, I would
understand that it is up to other GIS clients to interpret those values as
coordinates but they would need to know which value is which (lat or long).
In the case above it would be easy to identify any value over 90 as being a
longitude value but what if the values were listed as 10,40. That would
represent two completely different points on the map if it were interpreted
as lat/long compared to long/lat. This is why I was asking the question.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Format-of-Pioint-datatype-lat-long-or-long-lat-tp5784939p5784953.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message peterlen 2013-12-31 22:28:19 Re: Format of Pioint datatype.... lat/long or long/lat??
Previous Message Adrian Klaver 2013-12-31 22:08:04 Re: pg_upgrade & tablespaces