0 ×

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

Workflow

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 top 10 smallest townsin the worldaccording tohttp://top10for.com/top-10-smallest-towns-world/visualizeon OSMworld mapcleaning upresult stringsassign colorand sizeBuild Google Geocode APIREST URL usingCity and Country from input tabletop 10 largest citiesin the worldaccording tohttp://www.citymayors.com/statistics/largest-cities-population-125.htmltag = largest citiestag =smallest cities+from sq milesto sq Km GET Request JSON Path File Reader OSM Map View StringManipulations Build GoogleGeocode REST URL File Reader Concatenate ConstantValue Column ETL 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 top 10 smallest townsin the worldaccording tohttp://top10for.com/top-10-smallest-towns-world/visualizeon OSMworld mapcleaning upresult stringsassign colorand sizeBuild Google Geocode APIREST URL usingCity and Country from input tabletop 10 largest citiesin the worldaccording tohttp://www.citymayors.com/statistics/largest-cities-population-125.htmltag = largest citiestag =smallest cities+from sq milesto sq Km GET Request JSON Path File Reader OSM Map View StringManipulations Build GoogleGeocode REST URL File Reader Concatenate ConstantValue Column ETL

Download

Get this workflow from the following link: Download

Nodes

06_​Google_​Geocode_​API-OSM-text_​file consists of the following 18 nodes(s):

Plugins

06_​Google_​Geocode_​API-OSM-text_​file contains nodes provided by the following 6 plugin(s):