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?


3 Answers 3


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
    – Nicolas Raoul
    Commented Oct 29, 2014 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
    Commented Oct 31, 2014 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.
    – Nicolas Raoul
    Commented Nov 3, 2014 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 and acknowledge you have read our privacy policy.

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