Can someone guide me on how to collect the information that Google Maps provides in a geographical area in Excel by entering a keyword in Knime? For example, I want to have information about restaurants in Paris (such as name, address, email, and phone number).
First of all: Welcome to the world of KNIME.
I’m not aware of such features in G***** Maps as I’m not using this service. Furthermore I would expect that such a use might cause problems with their license of use.
May I point you to OpenStreetMap https://www.openstreetmap.org/? That’s something like Wikipedia for geo data. The map is only one of many ways to present the colected data.
The OSM license grants you the right to extract data and re-use it quite freely Copyright and License | OpenStreetMap
There is an interface to the database on https://overpass-turbo.eu
To get the information about the restaurants in Paris you may use this request overpass turbo
The result is available as JSON set (of course just the first data sets)
{
"version": 0.6,
"generator": "Overpass API 0.7.62.5 1bd436f1",
"osm3s": {
"timestamp_osm_base": "2025-05-18T12:35:00Z",
"timestamp_areas_base": "2025-02-06T02:17:44Z",
"copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL."
},
"elements": [
{
"type": "node",
"id": 158603712,
"lat": 48.8298353,
"lon": 2.3228662,
"tags": {
"air_conditioning": "yes",
"alt_name": "Le Moulin Vert",
"amenity": "restaurant",
"cuisine": "pizza",
"diet:halal": "no",
"diet:kosher": "no",
"diet:vegan": "yes",
"diet:vegetarian": "yes",
"happy_hours": "15:00-20:00",
"indoor_seating": "yes",
"name": "The Village Terrazza",
"opening_hours": "Mo-Sa 11:30-23:30",
"outdoor_seating": "yes",
"payment:credit_cards": "yes",
"payment:debit_cards": "yes",
"phone": "+33 1 45 39 31 31",
"smoking": "outside",
"wheelchair": "yes"
}
},
{
"type": "node",
"id": 175539450,
"lat": 48.8319911,
"lon": 2.3245334,
"tags": {
"addr:housenumber": "8",
"addr:postcode": "75014",
"addr:street": "Rue des Plantes",
"air_conditioning": "yes",
"amenity": "restaurant",
"cuisine": "french",
"indoor_seating": "yes",
"name": "Le Severo",
"opening_hours": "Mo-Fr 12:00-14:00,19:30-21:30",
"outdoor_seating": "no",
"payment:credit_cards": "yes",
"payment:debit_cards": "yes",
"smoking": "no",
"wheelchair": "yes"
}
},
1 Like
Hello @AKNILOUR ,
As far as I know there is no Google Maps node in KNIME. However you can use the OSM POIs node to do something similar. To see the node in action check out this example workflow.
To get started with Geospatial in general have a look at this collection.
Bye
Tobias
Hi @AKNILOUR
See this overview of elements you can query with the OSM Pois node.
https://wiki.openstreetmap.org/wiki/Map_features
And take a look at this story
gr. Hans