Google Maps API Geocoding

KNIME Analytics Platform
1

Hi,

is there any way to convert street names to longitude and latitude using KNIME Rest API and Google API? Can you describe me a process?

Regards,

Hrvoje

2

It is not trivial, but I believe it can be done with the Geocoding API and the REST nodes from Cenix in our community contributions section. You can use a URL like:

https://maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&key=API_KEY
 
where API_KEY is your google api key.  
 
For details on the api, see here:
 
https://developers.google.com/maps/documentation/geocoding/index
3

Hi

I already did similiar things. My aim was to convert addresses from university institutes into coordinates. Sometimes there was a complete address with streets, sometimes not.  This is an example:

http://maps.googleapis.com/maps/api/geocode/xml?address=Wageningen,+The+Netherland.&sensor=true_or_false

I generate the URL with a JavaSnippet, use the TableRow2LoopStart to transfer the URL into a variable that is used to feed an XMLReader. With a LoopEnd I collect all results from the google service.

Maybe you need to play around with the settings for the timeout (File/Preferences).

Frank

 

 

4

Hi Frank,

I'm trying to do something similar. Do you have a worflow snippet that you can share ?

Thanks in advance !

1 Like