Tag Info

New answers tagged

0

create view track_with_distance as select to.*, cast(case when from.latitude=to.latitude and from.longitude=to.longitude then 0 else 1852*acos(sin(from.latitude/180*pi())*sin(to.latitude/180*pi())+cos(from.latitude/180*pi())* cos(to.latitude/180*pi())*cos(from.longitude/180*pi()-to.longitude/180*pi()))* ...



Top 50 recent answers are included