Postgres Pro
Downloads
Home   >   mailing lists

Re: earthdistance is not giving correct results. - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: earthdistance is not giving correct results.
Date
Msg-id 20041003182232.GA10253@wolff.to
Whole thread Raw
In response to Re: earthdistance is not giving correct results.  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Responses OT: spherical geometry (Re: earthdistance is not giving ...)  (Holger Klawitter <lists@klawitter.de>)
List pgsql-general
Tree view 
On Sun, Oct 03, 2004 at 11:36:20 -0400,
  Jean-Luc Lachance <jllachan@sympatico.ca> wrote:
> I agree, NS or EW long lat should be the same.
> I was just pointing to the wrong figure.  Also, if ll_to_earth takes lat
> first, it should report an error for a |lat| > 90...

I disagree with this. Latitudes greater than 90 degrees have a reasonable
meaning and it can be useful to use 0 to 180 instead of -90 to 90.
The same thing applies to longitude.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: guaranteeing that a sequence never skips (fwd)
Next
From: "Gary Doades"
Date:
Subject: Re: [HACKERS] OT moving from MS SQL to PostgreSQL