Google Address Geocoder

Go to Product

This node allows geocoding of street addresses, such as “1600 Amphitheatre Parkway, Mountain View, CA”, to geographic coordinates, such as (37.423021, -122.083739) using Google’s geocoding API.

API Key Setup

To use the Google Maps API, a free API key for the Open Data API is required, which can be obtained here. Enter your API key in the KNIME Preferences under KNIME → Palladian → Geocoders. The free plan allows 15,000 requests/month.

Options

Input
The column in the input table which contains the addresses.

Input Ports

Icon
Table with a string column which contains the address data.

Output Ports

Icon
Table with an appended column which holds the geographic coordinates for the input addresses. In case, no coordinate could be resolved by the geocoder, a missing value cell is appended instead.

Popular Predecessors

  • CSV Reader12 %
  • Excel Reader (XLS)7 %
  • Column Aggregator5 %
  • Excel Reader (XLS)4 %
  • Excel Reader (XLS)3 %
  • XLS Reader3 %
  • Partitioning3 %
  • Database Reader2 %
  • Tag Filter2 %
  • Row Splitter2 %
  • Java Snippet (simple)2 %
  • Java Snippet2 %
  • String Manipulation2 %
  • Twitter Search2 %
  • Table Creator2 %
  • TimeDelay Loop Start2 %
  • Row Filter1 %
  • String Replacer1 %
  • Rule Engine1 %
  • Read Excel Sheet Names (XLS)1 %
  • Excel Reader1 %
  • Chunk Loop Start1 %
  • Concatenate1 %
  • Column Combiner1 %
  • Column Merger1 %
  • Column Resorter1 %
  • Column Filter1 %
  • Rule-based Row Splitter1 %
  • Color Manager1 %
  • MapQuest Geocoder1 %
  • Wait...< 1 %
  • File Reader< 1 %
  • Row Sampling< 1 %
  • Coordinate to Latitude/Longitude< 1 %
  • Geo-Coordinate Row Filter< 1 %
  • Number To String< 1 %
  • Extract Column Header< 1 %
  • Reference Row Filter< 1 %
  • XPath< 1 %
  • Location Extractor< 1 %
  • String To Number< 1 %
  • Duplicate Row Filter< 1 %
  • XML Reader< 1 %
  • Cell Splitter< 1 %
  • Database Connection Table Reader< 1 %
  • String To Number< 1 %
  • Column Rename< 1 %
  • Transpose< 1 %
  • Rule-based Row Filter< 1 %
  • Parallel Chunk Start< 1 %
  • Google Analytics Query< 1 %
  • Country Extractor< 1 %
  • MapzenGeocoder< 1 %
  • String Similarity< 1 %
  • Wait< 1 %
  • Generic Loop Start< 1 %
  • Cell Splitter< 1 %
  • Many to One< 1 %
  • Reverse Location Lookup< 1 %
  • HTTP Retriever< 1 %
  • Read from Shapefile< 1 %
  • Sorter< 1 %
  • Shapefile Point Reader< 1 %
  • Address Creator< 1 %
  • Counting Loop Start< 1 %
  • Group Loop Start< 1 %
  • Concatenate (Optional in)< 1 %
  • Binner (Dictionary)< 1 %
  • GroupBy< 1 %
  • Joiner< 1 %
  • Bag Of Words Creator< 1 %
  • GET Request< 1 %
  • Twitter Streaming< 1 %
  • Google Address Geocoder< 1 %
  • Read REST Representation< 1 %
  • Spotfire File Reader< 1 %
  • Chunk Loop Run-for-time Loop Start< 1 %
  • Chunk Loop Run-to-time Loop Start< 1 %
  • Table Row To Variable Run-for-time Loop Start< 1 %
  • Benchmark End (Memory Monitoring)< 1 %
  • Table Row To Variable Loop Start< 1 %
  • Variable to Table Row< 1 %
  • Cell Replacer< 1 %
  • Cell Splitter By Position< 1 %
  • Number To String< 1 %
  • Insert Column Header< 1 %
  • Constant Value Column< 1 %
  • HiLite Row Splitter< 1 %
  • Pivoting< 1 %
  • Missing Value< 1 %
  • IF Switch< 1 %
  • Extract Table Spec< 1 %
  • Shape Manager< 1 %
  • Size Manager< 1 %
  • Counter Generation< 1 %
  • Empty Table Creator< 1 %
  • Mahalanobis Distance< 1 %
  • Column Expressions< 1 %
  • Read XLS Sheet Names< 1 %
  • Document Data Extractor< 1 %
  • Strings To Document< 1 %
  • Google Sheets Reader< 1 %
  • String Input< 1 %
  • String to JSON< 1 %
  • Latitude/Longitude to Coordinate< 1 %
  • Column Distance< 1 %
  • Derive Fields< 1 %
  • Variable to Table Row< 1 %
  • CSV Reader< 1 %
  • Simple File Reader< 1 %
  • Variable Creator< 1 %
  • DB Reader< 1 %
  • String Configuration< 1 %

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.