Is there an open database where I can get the list of all restaurants (or bakeries, etc) for a given city ?

Since I'd need theses places so as to be able to put them on a map, like Google maps, i would need the following:

  • geo cordinates
  • name

Does such a database exists? If not, is it possible to get the request results from Google maps?



Here is my obligatory pointer to overpass turbo, a "graphic" way to explore the data quality for certain POIs (points of interest) in the OpenStreetMap database.

This examplary query for amenity=restaurant in Rome (patience: the query takes several seconds to execute) yields (probably incomplete) 543 locations with varying metadata.

543 restaurants in/around rome as points on a map

How-to: For a given POI, find out its most canonical way of tagging through the page Map Features on the OSM Wiki. Then use the "Wizard" button on overpass turbo to generate the query. Browse the map to a suitable test location and hit execute. The map then can be navigated and the POIs inspected for data quality.


I would take a look at these sources:

  • Note: Foursquare and Yelp are not Open Data Oct 29 '14 at 3:49
  • Thanks @NicolasRaoul. Despite the name of the site, answers with "closed" data are also appreciated. meta.opendata.stackexchange.com/q/203/1511
    – philshem
    Oct 31 '14 at 10:22
  • @philshem: I think that adding a small note should be expected when adding non-open data. Ideally all items should mention the license. Nov 3 '14 at 3:09

For Great Britain, the Food Standards Authority make available an API which has the food hygiene ratings for every place that serves food in the local authorities that operate the scheme.

Whilst this data does include places not normally open to the public (there are some office canteens, schools, etc.) their data is reasonably well classified and free to use - as always, the should read and understand the licence prior to using the data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.