How to calculate the road distance between two cities using databricks?

Question

We need to calculate road distance between two cities in databricks.

• The available datas are city name,State name.

Can we use azure maps to calculate it.

Answer 1

Hi @Deepak Raj Lingadurai

You will want to combine two different types of steps (the examples are in Python so you should be using that language in Azure Databricks).

1) You will want to get the longitude and latitude of the cities:

How To Get Latitude & Longitude with python

https://stackoverflow.com/questions/25888396/how-to-get-latitude-longitude-with-python

There are a couple of answers (one using Google Maps API and some other alternatives using python requests library).

2) You can use the longitude and latitude calculation to calculate the distance between two points:

How can I quickly estimate the distance between two (latitude, longitude) points?

https://stackoverflow.com/questions/15736995/how-can-i-quickly-estimate-the-distance-between-two-latitude-longitude-points

If you have a mathematics background you can also take a look at the calculation for further understanding:

https://en.wikipedia.org/wiki/Haversine_formula

---

If this is helpful please accept answer.

Answer 2

Hi

Thank you for posting query in Microsoft Q&A Platform.

Databricks notebooks can execute python code, so you can make API calls to Azure Maps to get distance information using Python code from Databricks notebook.

Below is documentation of one such Azure Maps API, which gives us Route direction details between origin and destination. You can think of using this API.
https://learn.microsoft.com/en-us/rest/api/maps/route/get-route-directions?tabs=HTTP

Regarding making API calls from python code there are so many resources available online, you can go through them.

Hope this helps. Please let me know how it goes.

-------------

Please consider hitting Accept Answer button. Accepted answers help community as well.