Measure distance between coordinates

KNIME Analytics Platform
1

Hello all,

I have several coordinates with an exact time stamp and I would like to measure the distance between them. The best option would be to include also the road network to have an even more exact distance. Nevertheless, the single distance between them, without including the road, would also be nice :)

 

Thanks for your support.

 

Ralph

2

Hi Ralph,

afaik there is no specialized node for calculating the shortest (road-)route between two coordinates. As a quick win you could use the Palladian Geo Nodes (you have to install this community extension) to calculate a distance matrix containing the Haversine distance. I attached a simple workflow as example for you. Hope that helps.

Best

Marten

3

Hi Marten,

thanks for your answer :)

I did it already with the geo nodes, but I don't know how to continiue with the date from the Matrix. Because the Matrix shows me the distance between each point and any other. I need the distance from point 1 to point 2, From point 2 to point 3 and so on. 

Any idea how this works?

 

Ralph

4

Hi Ralph,

I guess there are several ways to do that, but i managed it this way:

After the Distance Matrix Calcuate-node I used the distance matrix pair extractor and set the name column to timestamp (I appenped that column to my example-dataset). Afterwards I grouped on the "Object 2"-column (containing the "arrival" timestamp) and set last(Distance) as aggregation function. As the timestamps should be unique, you can then easily join the distances to your original dataset.

Cheers,
Marten