Icon

20220118 Pikairos Street Address from LAT-LON locations based on Palladian Plugin

20220118 Pikairos Street Address from LAT-LON locations based on Palladian Plugin
GPS LocationsSearch not FoundGPS Locationsthrough Reverse Location LookupGeoNames.comAllCountriesText FileYou need to download the fileallCountries.txtfrom GeoNames.comand store it in the workflowdata folder(Current file is Dummy for Demo)GeoNamesHeaders &MeaningComputeEuclidean Similarity(Euclidean Distanceis accurate enoughat close neighbouringdistances withoutneeding to calculatea Haversine Distance)RenameLatitude &LongitudeJoin both Sourcesbased on MatchesSet an AcceptableGPS Distance ThresholdHere.Set to 330 meters(4th decimal approx. 11 meters)Set this thresholddepending onwhat is reasonablefor your workLocations that were not foundor were found too far from Locationare treated again separatelyby calling the web service :)1st Coordinates2nd CoordinatesDistancein MetersMinimum Radius is 1Kmso many different addressesmay be returned for justone single QueryIt seems thatevery row answer is count asa query to computeand limitthe use of the API serviceResultKO(reachedToo Many Requests)ResultOK(Good Answer)ResultOK(Empty Answer)Recover InitialRequest to forwardSet Timerdepending ofSuccess orFailureSet Variablewith Result(OK or KO)Wait2 seconds * #ReturnedRowsor1 hour Depending onBulk RequestSuccess or FailureFound GPS Locationsbased on Query Coordinateson GeoNames.comAllCountriesText FileCalculate # ofReturned RowsGroup byCoordinates &Keep Nearestto RequestedLocationFilter IN onlythe nearestfound answerFound GPS Locationsbased on GeoNames.comRemote QueringGeoNamesHeaders &MeaningLatitude/Longitudeto Coordinate File Reader Chunk Loop Start File Reader Table Creator GeoNames SetColumn Headers Similarity Search Column Rename Joiner Row Splitter Column Filter Latitude/Longitudeto Coordinate Latitude/Longitudeto Coordinate Joiner Column Distance Geo Distances Geo Distances ReverseLocation Lookup ConstantValue Column ConstantValue Column Try (Data Ports) Empty Table Switch ConstantValue Column CASE SwitchData (End) Concatenate Java Edit Variable Loop End Table Rowto Variable Wait... Catch Errors(Data Ports) Column Filter InteractiveTable (local) Extract TableDimension GroupBy Joiner Missing Value InteractiveTable (local) InteractiveTable (local) GPS LocationsSearch not FoundGPS Locationsthrough Reverse Location LookupGeoNames.comAllCountriesText FileYou need to download the fileallCountries.txtfrom GeoNames.comand store it in the workflowdata folder(Current file is Dummy for Demo)GeoNamesHeaders &MeaningComputeEuclidean Similarity(Euclidean Distanceis accurate enoughat close neighbouringdistances withoutneeding to calculatea Haversine Distance)RenameLatitude &LongitudeJoin both Sourcesbased on MatchesSet an AcceptableGPS Distance ThresholdHere.Set to 330 meters(4th decimal approx. 11 meters)Set this thresholddepending onwhat is reasonablefor your workLocations that were not foundor were found too far from Locationare treated again separatelyby calling the web service :)1st Coordinates2nd CoordinatesDistancein MetersMinimum Radius is 1Kmso many different addressesmay be returned for justone single QueryIt seems thatevery row answer is count asa query to computeand limitthe use of the API serviceResultKO(reachedToo Many Requests)ResultOK(Good Answer)ResultOK(Empty Answer)Recover InitialRequest to forwardSet Timerdepending ofSuccess orFailureSet Variablewith Result(OK or KO)Wait2 seconds * #ReturnedRowsor1 hour Depending onBulk RequestSuccess or FailureFound GPS Locationsbased on Query Coordinateson GeoNames.comAllCountriesText FileCalculate # ofReturned RowsGroup byCoordinates &Keep Nearestto RequestedLocationFilter IN onlythe nearestfound answerFound GPS Locationsbased on GeoNames.comRemote QueringGeoNamesHeaders &MeaningLatitude/Longitudeto Coordinate File Reader Chunk Loop Start File Reader Table Creator GeoNames SetColumn Headers Similarity Search Column Rename Joiner Row Splitter Column Filter Latitude/Longitudeto Coordinate Latitude/Longitudeto Coordinate Joiner Column Distance Geo Distances Geo Distances ReverseLocation Lookup ConstantValue Column ConstantValue Column Try (Data Ports) Empty Table Switch ConstantValue Column CASE SwitchData (End) Concatenate Java Edit Variable Loop End Table Rowto Variable Wait... Catch Errors(Data Ports) Column Filter InteractiveTable (local) Extract TableDimension GroupBy Joiner Missing Value InteractiveTable (local) InteractiveTable (local)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2022-01-12
On NodePit since: 2022-01-19
Last update: 2024-04-23
Created with KNIME version: v4.4.1
Tags: GPSPalladianPikairosLongitudeLatitudeGEO DistancesReverse Location Lookup

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!