Icon

06_​Google_​Geocode_​API-OSM-text_​file

Will they blend? Text File - Google Geocode API - Open Street Maps
Will they blend? Text File - Google Geocode API - Open Street MapsThis workflow blends together data from Text Files and from Google Geocode REST API.In particular it reads the list of the smallest and largest cities in the world from 2 text files, queries the Google GeocodeREST service for their geo-corrdinates, and displays them on a Open Street Maps world map.Blog post available at https://www.knime.org/blog/OSM-meets-CSV-file-and-Google-API ... and yes! They blend. CSV Text Files Google REST Service Open Street Map Runs allquery URLsfrom the input tableConvert from JSON Pathto table visualizeon OSMworld mapCleaning upresult stringsassign colorand sizeBuild Google Geocode APIREST URL usingCity and Country from input table andflow variable API KeyTag =smallest cities+from sq milesto sq KmTag =largest cities+select top 10Largest cities in theworld according tohttp://www.citymayors.com/statistics/largest-cities-population-125.htmlTop 10 smallest townsin the world accordingto http://top10for.com/top-10-smallest-towns-world/ GET Request JSON Path OSM Map View StringManipulations Build GoogleGeocode REST URL Concatenate ETL ETL File Reader File Reader Will they blend? Text File - Google Geocode API - Open Street MapsThis workflow blends together data from Text Files and from Google Geocode REST API.In particular it reads the list of the smallest and largest cities in the world from 2 text files, queries the Google GeocodeREST service for their geo-corrdinates, and displays them on a Open Street Maps world map.Blog post available at https://www.knime.org/blog/OSM-meets-CSV-file-and-Google-API ... and yes! They blend. CSV Text Files Google REST Service Open Street Map Runs allquery URLsfrom the input tableConvert from JSON Pathto table visualizeon OSMworld mapCleaning upresult stringsassign colorand sizeBuild Google Geocode APIREST URL usingCity and Country from input table andflow variable API KeyTag =smallest cities+from sq milesto sq KmTag =largest cities+select top 10Largest cities in theworld according tohttp://www.citymayors.com/statistics/largest-cities-population-125.htmlTop 10 smallest townsin the world accordingto http://top10for.com/top-10-smallest-towns-world/ GET Request JSON Path OSM Map View StringManipulations Build GoogleGeocode REST URL Concatenate ETL ETL File Reader File Reader

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: rosy
Created at: 2016-10-28
On NodePit since: 2019-07-12
Last update: 2024-04-20
Created with KNIME version: v4.5.1
Tags: data blendingRESTGoogle APIgeolocalizationOpen Street MapOSMWill they blend

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

Try NodePit Runner!