nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I find a shapefile of all restaurants and bakeries in California? Or a free list of addresses to Geocode?

MelissaTraverso1

Hi I am currently trying to search for restaurant (of all types) and bakeries in California. I am thinking finding a shapefile of this is pretty unlikely but was wondering where I might find a free comprehensive list of addresses that I could then geocode within arcmap? Can google maps or google earth provide this for me?

Thanks,

Melissa

Find more posts tagged with

Accepted answers

All comments

JoeBorgione

Have you tried Google? How are you going to know if you don't start digging?

There must be a trade association that could provide you addresses of members. Or you can start calling city business license departments. Statewide? Without even knowing your age, my guess is that'll keep you going until retirement...

TimWitt2

Here in Florida, if you are part of the government you can go to the department of transportation gis page and download a shapefile that has all restaurants in florida in it.

I know it is not what Melissa is looking for, but some states seem to have it

MelissaTraverso1

I typed in "Restaurants in California" in google earth. A ton of points all over the map popped up. I zoomed into these locations to check that they were restaurants and it looks like they are. The only issue is roughly 20 of these points actually show up in my table of contents in google earth that I can save to my places and use these addresses to geocode. Is it possible to get all the points that show up on the map without having to go one by one and adding a placemark?

Thanks,

Melissa

JoeBorgione

Wow. That's a nice piece of data. Maybe the state health dept has what she's after.

ChristiNelson1

If you just need names and point locations, try the Geographic Names Information System U.S. Geographic Names Information System (GNIS) - Data.gov

Or Open Street Map should have Points Of Interest that include restaurants. http://download.geofabrik.de/north-america/us/california.html

http://download.geofabrik.de/north-america/us/california.html

A hub of free gis data exists here Free GIS Datasets - Categorised List.

evtguy

I think Joe Borgione is on the right track with the Health Department or possibly department of licensing. Restaurants need licenses to operate so you may be able to get a tabular list that you would then need to geocode. I did something similar in my local county to map out the locations of all hotels using the license list provided by my state's Department of Licensing.

LauraCremin

Hi Melissa,

Cnngis.org sounds like just what you are looking for. You can download a list of food retailers + addresses for a geographic region you select, and filter it by food-store type (general grocery, convenience group, etc.). Then it just has to be geocoded.

Open up the Layer List (top left-hand corner), and there is a drop down to filter by Retail Food Channel. I can't remember the categories, but I believe once downloaded you'll see another column that further categorizes with a bakery group.

Also, I'm not sure how often it is updated (you'd have to check, but at least yearly).

Some of it can be a little messy (stores closed, duplicate addresses and store names, etc.) so it is a good idea to sift through it a bit and possibly ground-truth some with google maps & yelp. I found it to be generally good data!

JoeBorgione

The term Big Data comes to mind.....

MelissaTraverso1

Hi Laura,

It looks like the most it will let me download are 1000 features at a time. It would be hard to break down California and make sure I get 1000 within each section of california. If I am wrong about this please let me know.

Thanks,

Melissa

TimothyHales

Although not a free option, Esri Community could easily provide this data set. There is a free trial too - Esri Community Analyst | Free Trial

MelissaTraverso1

Hi Timothy,

Are you familiar with using the community analyst tool? I have registered for a free trial and I am on the interface right now. I am trying to search business locations by searching "restaurants in california" and only about 10 locations pop up. Is this because it is the free trial and won't give me roughly all 79,000 I need? It allows me to export the table into excel which is perfect but I can't get it to search for very many options. if you have any tips please let me know.

Thanks,

Melissa

DanPatterson_Retired

It would make a huge amount of sense to me that the trial version is severely limited/impaired. Was there anything in the documentation about it. It won't happen that you are going to get all the data you want unless that company is really, really clueless

RakeshSinha

Hi Melissa,

In order to search for businesses or facilities with Community Analyst or for that matter BAO, you need to directly use the term such as ‘Restaurants’ and it will pull the list of all the restaurants in the USA. If you are just looking for restaurants in California you can add geography of California and then limit the number of restaurants within the California boundary.

The limitation for the number of search results is 5000 and hence you might have to break down the geography (California) into counties to pull all the Restaurants in California.

The trial version comes with all the functionalities that the application offers. It’s just that you get 200 credits to work with and once that is consumed you won’t be able to access the application.

I hope this helps!

MelissaTraverso1

Hi Rakesh,

Thanks for the help! Do you know what counts as a "credit" within this tool?

Thanks,

Melissa

MelissaTraverso1

Is anyone familiar with R? R apparently has several "packages" that include functions purpose-built for extracting data from Google Maps. The big one is called "ggmap" and "ggplot2". Wondering if I might be able to extract lat long points from this directly in order to create a shapefile.

Thanks,

Melissa

nimitz

An even better dataset (shapefile, GEODB, or whatever format) is a list of all the donut shops in the greater Sacramento region!

ChrisSmith7

I read through the forum postings and didn't see a mention of infoUSA (paid service):

Restaurant Database | Restaurant Mailing Lists | InfoUSA

They should already have the addresses geocoded; there may be license/usability constraints on the data, however. You'd have to inquire for more information.

I know you asked for a free resource, but just wanted to make you aware in case you were unsuccessful in this venture.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.