Postgres Pro
Downloads
Home   >   mailing lists

Re: earthdistance results seem to be wrong. - Mailing list pgsql-general

From Chris Mair
Subject Re: earthdistance results seem to be wrong.
Date
Msg-id 1096817341.15333.9.camel@dell
Whole thread Raw
In response to earthdistance results seem to be wrong.  (mikecoxlinux@yahoo.com (Mike Cox))
List pgsql-general
Tree view 
> select
> earth_distance(ll_to_earth('122.55688','45.513746'),ll_to_earth('122.396357','47.648845'));
>
> The result I get is this:
>
> 128862.563227506
>
> The distance from Portland to Seattle is not 128862
> miles.

It is 128000m = 128km.

Welcome to the metric system :)

Bye, Chris.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: sequence rename?
Next
From: Jean-Luc Lachance
Date:
Subject: Re: earthdistance is not giving correct results.