You are on the right way. As Scott already mentioned, the Palladian nodes are what you are searching for – you already have used them to generate the coordinates. Have a look at the Geo distances in combination with the ColumnDistanceNode.
Use two Geo distances nodes to calculate distance matrices for each column and feed your data plus the matrices into the ColumnDistanceNode to calculate the distances in km. The output for your first example is 33,44 km:
Thank you so much for you help and I am so grateful to you guys
I have One more question about the significant shift between the latitude longitude that give mapquestgeocoder and GoogleAdressesGeocoder so great diffirence between the distances.
For example for the first example by mapquest gives 33.44 km but by googleGeocoder it gives 1.1 km ?
What I can do for correct this in what gives MapQuest ?!
This is either caused by different databases used by Google vs MapQuest, or probably by different parsing algorithms to parse the input address, or just by different resolution strategies (an input string ‘1 RUE DES SARCELLES’ is quite ambiguous likely exists in more than one city)
MapQuest as well as Google Maps would theoretically allow to narrow down the search to a given bounding box or region, but we currently do not support this in the nodes.
hoping you can help me too…I am absolutely new to using KNIME and I want to the get a distance in kilometres or miles between two given latitude and longitude values.
The LatitudeLongitudeToCoordinate nodes have an error saying
“No suitable column with any of the name(s) lat,latitude found”
What does this mean please?
I have manually added a few rows of data so I can run and see the results (Ive manually created the rows and named the rows latitude respective longitude)
Can you please help me understand?
Sure. You are almost there! The problem is your input table. Row0 is the first row of your table but it contains your column headers. You need to properly define your column headers, column types and contents in your Table Creator node.
As seen in the screen, open the configuration of your Table Creator and double-click on the table header. This opens a dialog that let you define the column name and its type. Give it a proper name and select Number (double) as type.
I tried to use something similar to your WorkFlow but I have a different situation. I don’t want to calculate the distance beetween every point I have in a table because I have 46.590 geolocations, so it would give me more than 2 billion rows. I created a file with 46.590 GeoLocations and I need to find the distance from these points to other 70 geolocations. I will have something with around 3 million rows.
You might want to check the links in this thread. Most of them are links to this thread, they’re found below each post. There should still be something useful to be found in some of them. Especially this one:
If computational resources are of concern, looping over one input vector definitely is the way to go. It’s also hella slow, so if you want execution speed, and your machine can handle it, you might want to try out the Cross Joiner after all. 4 million rows is a lot, but not a crazy amount. Maybe save your workflow before trying