Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Celebrating Memorial Day!
Go Back   City-Data Forum > U.S. Forums > General U.S. > City vs. City
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 06-22-2014, 02:10 AM
 
273 posts, read 323,297 times
Reputation: 93

Advertisements

So I decided to do a comparison of density of stores and restaurants for select North American cities using Yelp. I searched number of stores by using the term "shopping", and number of restaurants using "restaurants". I set the distance at both "4 blocks" and "1 mile" using the checkboxes available, and moved the maps around the various downtowns (and Midtown Manhattan) trying to maximize the number.

This is very inexact, as there are some problems:

1. Some places are omitted (especially newer places)
2. Some places are counted twice under slightly different names
3. Some places long since closed are still included

There are additional problems by using "shopping" to search for number of stores:

1. Malls get an entry (we really only want an entry for each store within the mall, not the mall itself)
2. Things like weekend outdoor markets sometimes get an entry
3. Some things that aren't stores at all sometimes get an entry simply because they've been tagged with "Shopping" (like some companies)

Nonetheless, I think this is a good way to estimate the number of stores/restaurants in a given area. And I see no reason to think the problems would affect one city disproportionately more than another.

I compared the following areas. If anyone feels like adding more, go ahead. To keep it consistent though, do it the same as I did (search "shopping" and "restaurants" within a 4 block and 1 mile radius, and move the map around until youve maximized the count).

Here are the numbers. Below the numbers are screenshots of the maps, so you can see where the map was centred for each city to get the count. Im going to add more cities in the future.


Stores, 4 blocks:

New York City: 4200
San Francisco: 1075
Toronto: 889
Seattle: 758
Vancouver: 651
Boston: 570
Portland: 423
Denver: 296
Houston: 202
Dallas: 158
Minneapolis: 148


Restaurants, 4 blocks:

New York City: 797
San Francisco: 515
Toronto: 435
Boston: 418
Portland: 418
Seattle: 409
Vancouver: 403
Houston: 348
Dallas: 259
Denver: 238
Minneapolis: 230



Stores, 1 mile:

New York City: 13,405
San Francisco: 4514
Toronto: 4347
Vancouver: 2730
Boston: 2051
Seattle: 1575
Portland: 1521
Dallas: 962
Denver: 771
Houston: 710
Minneapolis: 523


Restaurants, 1 mile:

New York City: 5984
Toronto: 2658
San Francisco: 2647
Vancouver: 1554
Boston: 1532
Seattle: 1330
Portland: 1175
Dallas: 1002
Houston: 755
Denver: 702
Minneapolis: 568



Maps:


Stores, 4 blocks:

New York City:

http://i1292.photobucket.com/albums/...psfd8ade1d.png

San Francisco:

http://i1292.photobucket.com/albums/...ps00f2e54e.png

Toronto:

http://i1292.photobucket.com/albums/...psf86155c3.png

Seattle:

http://i1292.photobucket.com/albums/...pse5425c3a.png

Vancouver:

http://i1292.photobucket.com/albums/...pse379e328.png

Boston:

http://i1292.photobucket.com/albums/...pscf765bd7.png

Portland:

http://i1292.photobucket.com/albums/...ps48095394.png

Denver:

http://i1292.photobucket.com/albums/...ps9994d9a4.png

Houston:

http://i1292.photobucket.com/albums/...ps2f8dcbca.png

Dallas:

http://i1292.photobucket.com/albums/...ps0a694365.png

Minneapolis:

http://i1292.photobucket.com/albums/...psffba1410.png


Restaurants, 4 blocks:

New York:

http://i1292.photobucket.com/albums/...ps870c4f4f.png

San Francisco:

http://i1292.photobucket.com/albums/...ps70cb26bc.png

Toronto:

http://i1292.photobucket.com/albums/...psd348e239.png

Boston:

http://i1292.photobucket.com/albums/...ps5c87540f.png

Portland:

http://i1292.photobucket.com/albums/...psf8dcec19.png

Seattle:

http://i1292.photobucket.com/albums/...ps0264e4ff.png

Vancouver:

http://i1292.photobucket.com/albums/...ps00b4b77a.png

Houston:

http://i1292.photobucket.com/albums/...ps9b70e133.png

Dallas:

http://i1292.photobucket.com/albums/...ps22dad104.png

Denver:

http://i1292.photobucket.com/albums/...psb245667d.png

Minneapolis:

http://i1292.photobucket.com/albums/...psba249e35.png


Stores, 1 mile:

New York City:

http://i1292.photobucket.com/albums/...psa7412e02.png

San Francisco:

http://i1292.photobucket.com/albums/...ps43c72f8d.png

Toronto:

http://i1292.photobucket.com/albums/...ps4fe4c289.png

Vancouver:

http://i1292.photobucket.com/albums/...pse72abfe8.png

Boston:

http://i1292.photobucket.com/albums/...ps3e29fcf9.png

Seattle:

http://i1292.photobucket.com/albums/...ps059ad200.png

Portland:

http://i1292.photobucket.com/albums/...ps88006a3f.png

Dallas:

http://i1292.photobucket.com/albums/...psfe625f79.png

Denver:

http://i1292.photobucket.com/albums/...psbc0b1e2f.png

Houston:

http://i1292.photobucket.com/albums/...ps5c173860.png

Minneapolis:

http://i1292.photobucket.com/albums/...psac11586d.png



Restaurants, 1 mile:

New York City:

http://i1292.photobucket.com/albums/...ps891f95d1.png

Toronto:

http://i1292.photobucket.com/albums/...ps8fac8e3d.png

San Francisco:

http://i1292.photobucket.com/albums/...ps325e50ee.png

Vancouver:

http://i1292.photobucket.com/albums/...ps714a446e.png

Boston:

http://i1292.photobucket.com/albums/...ps9dc414dd.png

Seattle:

http://i1292.photobucket.com/albums/...psf842d4a5.png

Portland:

http://i1292.photobucket.com/albums/...ps93bbaa1a.png

Dallas:

http://i1292.photobucket.com/albums/...ps083b471d.png

Houston:

http://i1292.photobucket.com/albums/...ps6f02f5e2.png

Denver:

http://i1292.photobucket.com/albums/...psddf24b10.png

Minneapolis:

http://i1292.photobucket.com/albums/...ps73508b85.png

Last edited by JMT; 06-22-2014 at 07:15 AM..
Reply With Quote Quick reply to this message

 
Old 06-22-2014, 01:42 PM
 
2,821 posts, read 2,288,061 times
Reputation: 3742
Interesting, I'm surprised to not see Philly, Chicago, and DC. I assume this is a list of selected cities?
Reply With Quote Quick reply to this message
 
Old 06-22-2014, 02:46 PM
 
Location: Maryland
4,675 posts, read 7,409,141 times
Reputation: 5369
Quote:
Originally Posted by jpdivola View Post
Interesting, I'm surprised to not see Philly, Chicago, and DC. I assume this is a list of selected cities?
Yeah the OP hasn't done the analysis on those cities (yet?), but you could expect them to be near the top with SF and TO.
Reply With Quote Quick reply to this message
 
Old 06-22-2014, 02:52 PM
 
Location: Seattle, WA
2,985 posts, read 4,887,965 times
Reputation: 3419
Interesting study, OP. I'm looking forward to you analyzing Chicago, Philly, New Orleans, Miami, Denver, and LA.
Reply With Quote Quick reply to this message
 
Old 06-22-2014, 02:57 PM
 
273 posts, read 323,297 times
Reputation: 93
Quote:
Originally Posted by jpdivola View Post
Interesting, I'm surprised to not see Philly, Chicago, and DC. I assume this is a list of selected cities?
I haven't done any of those cities yet.
Reply With Quote Quick reply to this message
 
Old 06-22-2014, 02:57 PM
 
895 posts, read 1,240,801 times
Reputation: 610
Do Austin too
Reply With Quote Quick reply to this message
 
Old 06-23-2014, 09:53 AM
 
11,289 posts, read 26,209,063 times
Reputation: 11355
Did you pull the maps back when you clicked on "4 blocks", because I noticed the Chicago "4 blocks" was a much much smaller area than the other screen shots. I looked at the other cities and it seems if you click "4 blocks" for them it's also a much smaller area than the screen shots listed. They're only around 25% of the size.
Reply With Quote Quick reply to this message
 
Old 06-23-2014, 11:45 AM
 
Location: Los Angeles, CA
5,003 posts, read 5,986,699 times
Reputation: 4328
Actual distances are probably a better measure than blocks since block lengths aren't uniform. 16 square blocks in LA may be 36 square blocks in NYC. That's a huge difference.
Reply With Quote Quick reply to this message
 
Old 06-23-2014, 02:34 PM
 
273 posts, read 323,297 times
Reputation: 93
Quote:
Originally Posted by Chicago60614 View Post
Did you pull the maps back when you clicked on "4 blocks", because I noticed the Chicago "4 blocks" was a much much smaller area than the other screen shots. I looked at the other cities and it seems if you click "4 blocks" for them it's also a much smaller area than the screen shots listed. They're only around 25% of the size.
I'm not really sure what you're getting at. I did the "4 blocks" thing for Chicago, and compared the vertical distance of the map to Toronto and New York at "4 blocks" using this:

Distance Calculator

They were all around the same: between 0.5 and 0.6 miles.

I was able to max. out the Chicago "shopping" count at 859 results, centred at roughly the corner of Randolph and Dearborn Streets. The vertical distance of the map is about 0.53 miles, the same as the vertical distance of the Toronto map at 4 blocks.
Reply With Quote Quick reply to this message
 
Old 06-23-2014, 02:35 PM
 
273 posts, read 323,297 times
Reputation: 93
Quote:
Originally Posted by 2Easy View Post
Actual distances are probably a better measure than blocks since block lengths aren't uniform. 16 square blocks in LA may be 36 square blocks in NYC. That's a huge difference.
"4 blocks" is an actual distance. It's obviously not 4 of that city's blocks. It's a set distance. Around 0.53 miles vertically. Did you even bother looking at the maps? If you had you'd have seen that it's the same distance for each city.

I did a rough measurement of the vertical distance of the maps of Toronto and Chicago using the Google Planimeter tool, and got 0.529 miles for Toronto, and 0.527 miles for Chicago. It's obviously an identical distance.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > U.S. Forums > General U.S. > City vs. City

All times are GMT -6.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top