topic Re: Calculating real distance between locations using Longitude and latitude in App Development

Calculating real distance between locations using Longitude and latitude

Anonymous — Wed, 04 Jul 2018 09:57:32 GMT

I have an excel file with longitudes and latitudes, i would like to know if it's possible to get a real representation of the distances between the locations taking into account streets as in Google map. So far i found a way to find the distances but i am wondering if there's a possibility to get distances to be realistic taking into account streets and not just a simple A to B distance.

Re: Calculating real distance between locations using Longitude and latitude

micheledenardi — Wed, 04 Jul 2018 10:19:59 GMT

I think the only solution to calculate the real distance between two points is by using Qlik GeoAnalytics.

Routes and travel areas in IdevioMaps

Re: Calculating real distance between locations using Longitude and latitude

richard_pearce6 — Fri, 13 Nov 2020 09:35:14 GMT

if you have two lat longs this will convert to km:

DataShort:
Load *

     ,6371 * (2 *
           Atan2( 
                   sqrt((sin(((lat2-lat1) * Pi() /180) /2) * sin(((lat2-lat1) * Pi() /180) /2) +sin(((lon2-lon1) * Pi() /180) /2) * sin(((lon2-lon1) * Pi() /180) /2) * cos(((lat1) * Pi() /180) ) * cos(((lat2) * Pi() /180) )))
               ,  sqrt(1-(sin(((lat2-lat1) * Pi() /180) /2) * sin(((lat2-lat1) * Pi() /180) /2) +sin(((lon2-lon1) * Pi() /180) /2) * sin(((lon2-lon1) * Pi() /180) /2) * cos(((lat1) * Pi() /180) ) * cos(((lat2) * Pi() /180) )))

            ))  AS Distance
Resident Data;