cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the road distance between two cities? We can use Azure databricks and azure map.

Azure_databric1
New Contributor II

We will be given an excel file, in which we can see column sender_city and destination_city. We have to find the distance between these two cities and the distance calculated should be written in a column total_distance. All these processes should be automated. If we upload file, every process should be done automatically.

TO find distance we want map, SO we should use Azure Map.

we should not use latitude and longitude because it is calculating flight distance.

Can someone help me regarding the same.

My mailid is dpkrj11.l@gmail.com

1 REPLY 1

sher
Valued Contributor II

hey

without using latitude and longitude it is hard to find out but you can try some distance-based algorithm

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group