Wrong distance shown in miles for extension earthdistance

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Wrong distance shown in miles for extension earthdistance
Дата
Msg-id 161638666232.653.1286667599530703498@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Wrong distance shown in miles for extension earthdistance  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/earthdistance.html
Description:

Hi,
 I have installed 
CREATE EXTENSION CUBE;
CREATE EXTENSION earthdistance;

Post which I ran the following query:
SELECT (POINT (19.974, 72.756)<@> POINT (19.195, 72.959)) AS DISTANCE;

The answer came back as 21.17534 miles whereas the actual distance (as crow
flies) is 55.42 miles which I have checked from 2-3 websites. (Google maps
gives a greater distance which is travel by road & this value has been
ignored).

I know both the places and the distance between both of them cannot be 22
miles. It has to be in excess of 50 miles atleast. What am I missing?

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: "there is no way to insert less than one row"
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Wrong distance shown in miles for extension earthdistance