distance calculation usng lat and long in miles

Поиск
Список
Период
Сортировка
От
Тема distance calculation usng lat and long in miles
Дата
Msg-id 005101c642d3$ef082960$1301a8c0@sf.vagabond.com
обсуждение исходный текст
Ответы Re: distance calculation usng lat and long in miles  (brew@theMode.com)
Re: distance calculation usng lat and long in miles  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: distance calculation usng lat and long in miles  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
I have the lat and long data. I have created the geom column based on the
lat and long data as below.


     UPDATE property SET geom =GeometryFromText('POINT(' || long ||
     ' ' || lat || ')',4326);

Now I have the geom columns in two tables

I am calculating the distance as below

select distance(geom1, geom2)* 69.055


It seems to be right. But I want to make sure.

Thanks for help in advance.



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

Предыдущее
От:
Дата:
Сообщение:
Следующее
От: brew@theMode.com
Дата:
Сообщение: Re: distance calculation usng lat and long in miles