Icon

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

Will they blend? Text File - Google Geocode API - Open Street Maps

This 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 Geocode REST service for their geo-corrdinates, and displays them on a Open Street Maps world map. ... and yes! They blend.

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