8

I am looking for any open data set that maintains restaurants (or places in general) with their address. If a place closes I am hoping this database will reflect that quickly.

  • Are you only interested in restaurants or in places in general? If it's the latter, you might want to change the title of your question accordingly. Also, are you only interested in places in the US or elsewhere too? – Patrick Hoefler May 31 '13 at 7:26
  • 3
    I think your best bet would be to connect to the restaurant/pub elements in OpenStreetMap data - and possibly report back mistakes and changes to OSM. – relet May 31 '13 at 7:58
  • Point of Interest data from OSM is certainly one of your best starting points. But it's created by volunteers - don't expect to have all POI updated constantly or just after a restaurant closed. If you want to be up-to-date immediately you will most likely need to create yourself an app that derives information on change from various source like business registers, restaurant recommendations (e.g. when a new restaurant is at an existing address), local news, social networks etc - depending for which country / region / city you want to track that there might be specific sources – fpp May 31 '13 at 12:26
  • 1
    What's your geography? Restaurant inspection data can do this, but you there's not single national source? – fgregg May 31 '13 at 16:31
  • As close to national as possible, global would be best but take what I can get. – Dan Ciborowski - MSFT Jun 4 '13 at 7:12
11

OpenStreetMap has quite an easily accessible database of restaurants (and other places), which you can easily query using their Overpass API. An example query for Overpass's Query Form which gets all restaurants in greater London:

<query type="node">
  <has-kv k="amenity" v="restaurant"/>
  <bbox-query s="51.28" n="51.686" w="-0.489" e="0.236"/>
</query>
<print/>

An easier way of creating a query is to use Overpass Turbo, which allows you to navigate a map to reflect your area of interest, again an example of all restaurants in greater London (click on Run and move to the Data tab on the upper right to see the 'raw' data).

Another source is OpenCorporates, which often holds official registrations of companies and whether they are active or not. Many restaurant registrations don't have their address listed, but you might want to use their data to find out whether restaurants are still active or not (see their video on how to use Google/OpenRefine to reconcile names from a certain dataset (in this case OpenStreetMaps) with the OpenCorporates dataset).

7

The SimpleGeo point of interest dump of 21m places is the best open data set I know of, though it's getting pretty long in the tooth these days and so won't have the up-to-date-ness you're looking for:

http://archive.org/details/2011-08-SimpleGeo-CC0-Public-Spaces

5

Wikivoyage has open data about restaurants and bars, worldwide, pretty up-to-date.

The data is licensed under Creative Commons Attribution/Share-Alike.

The format is like this:

{{eat
| name=Atelier de Joel Robuchon | url=http://www.robuchon.jp/latelier | email=
| address=Roppongi Hills Hillside 2F, 6-10-1 Roppongi
| lat=35.660197 | long=139.728804 | directions=
| phone=+81 3 5772-7500 | tollfree= | fax=
| hours=11:00–22:00 daily | price=
| content=The first overseas venture of the eponymous [[Paris]]-based Michelin-starred chef.  Each dish is a work of art almost as breathtaking as the price tag, as courses cost ¥2900–¥12,800 &mdash; still a steal by Tokyo gourmet standards.  No reservations are accepted, so prepare to queue.
}}

You are probably interested in the name and address field. Concatenate the the name of the article (country and city) to the address, and tha makes the full address.

Notes:

  • It does not contain ALL restaurants, but rather a selection of about 10 restaurants for each small city (or each part of a big city).
  • As far as I know, DBpedia does not parse Wikivoyage yet. This means you will have to download the XML dump (enwikivoyage-xxx-pages-articles.xml.bz2) and write a small script to extract the name-address couples.
  • I like it because I think it has a lot of future potential, but how do you access the data? Any API or dump? – Dan Ciborowski - MSFT Jun 5 '13 at 5:19
  • 1
    @djc391: Thanks for the feedback! I added the information about how to access the data. – Nicolas Raoul Jun 5 '13 at 5:26
1

Local health departments are often the agencies that keep license and inspection information. Yelp and a few cities have been working to develop a national standard for inspection data (LIVES), but not too many places have adopted this yet.

1

open tables sounds like the ticket:
http://www.opentable.com/state.aspx

edit: although i just clicked through state and onto a city...doesn't look like a straightforward list. @ least not offhand.

0

Yelp has a search and business API and you can find more details on their developers page.

  • 2
    Thanks for your answer! However, since this is the Open Data SE, we are looking for open datasets. The data from Yelp is copyrighted, so it's not really helpful here. – Patrick Hoefler May 31 '13 at 7:25
  • That's very helpful. Is it ok to delete a bad answer? – LAB May 31 '13 at 21:08
  • 1
    If you think you can improve your answer, you can edit it. Of course it's also fine to delete your answer. These tips on how to answer might also be helpful :) – Patrick Hoefler Jun 1 '13 at 0:17
  • Yelp is not open data. Yelp is owned by google and can't be used but thank you. – Dan Ciborowski - MSFT Jun 1 '13 at 8:52
  • 1
    On some other stack exchange sites, I've edited the answer to strike it out -- to mark that my answer was flawed, if there was a good chance that someone else might give the same response. – Joe Jun 1 '13 at 11:39

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.