earthdistance is not giving correct results.

From: mike cox <mikecoxlinux(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: earthdistance is not giving correct results.
Date: 2004-10-01 01:23:07
Message-ID: 20041001012307.82207.qmail@web52803.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running PostgreSQL 8.0 beta 1. I'm using the
earthdistance to find the distance between two
different latitude and logitude locations.
Unfortunately, the result seems to be wrong.

Here is what I'm doing:
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.


__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-10-01 03:22:45 Re: POSTGRES
Previous Message Tom Lane 2004-09-30 22:59:20 Re: Accessing an array element from a function