Open Address Data for Restaurants

Question

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.

Answer 1

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).

Answer 2

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

Answer 3

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 — 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.

Answer 4

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.

Answer 5

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.

Answer 6

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