Given a table with latitude/longitude (GPS) coordinate pairs, this workflow retrieves all nearest earth locations from a LoopUp file of LAT-LON positions provided by www.geonames.org. Distances are calculated using the Palladian -Geo Distances- and -Column DIstances- nodes.
GPS coordinates not found in this files are searched using the -Reverse Location Lookup- node by Palladian. The workflow is built so that bulk requests do not clog the GeoNames.com server. Every request is scheduled to be done after waiting 2 seconds from previous request. If the request is unsuccessful because too many requests have been done, the workflow detects it and waits for 1 hour before executing new requests.
The GeoNames.com file needed to run this workflow is not included in the workflow (just a dummy minimal version to show how the workflow works)
The full content file is called "allCountries.txt" and can be downloaded from https://download.geonames.org/export/dump as a zipped file.
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.1 Note: Not all extensions may be displayed.
- Go to item
Palladian for KNIME
This is an unpublished or unknown extension.
palladian.ws
Version 2.4.1
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.