![]() |
Yelp-rated routes in Boston. Click to embiggen. |
In Boston, only some routes were rated, and they were, not surprisingly, centered in the more student- and hipster-centric part of the city. For instance, no bus line in Dorchester or Mattapan got Yelped, but most in Cambridge and Somerville have many reviews. I figured the best way to show these data was on a map, and after some machinations (especially in resorting the shapefile so the thinner lines would display on top of the thicker ones) I got the map above. It's pretty cool—click it to enlarge. (Here's the full MBTA system map if you're not familiar with the lines; I left off route numbers for clarity.)
But I realized that pretty cool wasn't cool enough. There was probably a much richer data set out there. Boston has about 750 Yelp reviews, 450 of those for rail lines. Was there city with a wired-in community, lots of bus and transit routes, and high transit ridership? Did I just describe San Francisco to a T? And, voila, there are nearly 2000 Yelp reviews of transit lines in San Francisco, at least one (and usually many more) for nearly every line Muni runs (see exceptions below). (Here's the Muni system map.)
![]() |
Muni Lines, as reviewed by Yelp. Click to Embiggen. |
![]() |
San Francisco inset. Click to embiggen. |
I also realized that I had a pretty fun data set here, too. I went to a talk by Jarrett Walker the other day at MIT where he mentioned, amongst other things, that we should not focus on the technology used for transit, but whether if fulfills the mission of getting people from one place to another. In San Francisco, we have a jumble of buses, trolleybuses, streetcars and even cable cars and we have a pretty good way of quantifying whether they are accomplishing the job of transit. (In Boston, even though the B Line serves tens of thousands of passengers a day it manages a 1.36 Yelp rating—remarkable as the lowest possible rating is 1. None of its 34 raters give it a 4 or a 5. Still, it moves a lot of people marginally faster than they could walk.)
First, I averaged the ratings by technology type. Trolleybus route get more reviews than bus routes, probably because they are more heavily used. The average rating for these, however, is quite similar. (The average is a straight average of each line, the weighted average weighs more frequently-rated lines by the number of ratings). Cable cars and PCCs (F-Marked and Wharves) have higher ratings but many are likely by tourists. Light rail lines, however, are frequently rated, and given low ratings, significantly lower than the bus routes.
Vehicle type | Routes | Avg Reviews | Avg Stars | Weighted Avg |
Bus | 39 | 22 | 3.03 | 2.77 |
Trolleybus | 12 | 41 | 2.95 | 2.79 |
Cable Car | 3 | 64 | 3.81 | 3.87 |
PCC | 1 | 114 | 3.42 | 3.42 |
Light Rail | 5 | 65 | 2.31 | 2.43 |
A forthcoming post will compare local and express bus routes. (Hint: people like riding expresses more than locals.)
I am so interested in San Francisco's Yelp bus ratings that I've tabled the whole of the network.
I am so interested in San Francisco's Yelp bus ratings that I've tabled the whole of the network.
Line | Vehicle | Stars | # Ratings | Line | Vehicle | Stars | # Ratings | |
1 | Trolleybus | 2.96 | 78 | 48 | Bus | 2.71 | 17 | |
2 | Bus | 2.53 | 26 | 49 | Bus | 2.33 | 40 | |
3 | Trolleybus | 4.53 | 17 | 52 | Bus | 2.5 | 8 | |
5 | Trolleybus | 2.73 | 55 | 54 | Bus | 2.6 | 10 | |
6 | Trolleybus | 2.88 | 16 | 66 | Bus | 4 | 1 | |
9 | Bus | 2.42 | 26 | 67 | Bus | 3.4 | 5 | |
10 | Bus | 3 | 24 | 71 | Bus | 2.56 | 27 | |
12 | Bus | 3.33 | 15 | 108 | Bus | 2.5 | 16 | |
14 | Bus | 2.55 | 44 | 01AX | Bus | 3.67 | 6 | |
17 | Bus | 3.67 | 6 | 01BX | Bus | 3.31 | 13 | |
18 | Bus | 3.25 | 16 | 08X | Bus | 2.56 | 18 | |
19 | Bus | 2.66 | 41 | 14L | Bus | 4 | 3 | |
21 | Trolleybus | 3.58 | 31 | 14X | Bus | 4 | 6 | |
22 | Trolleybus | 2.74 | 92 | 28L | Bus | 4.33 | 3 | |
23 | Bus | 3 | 9 | 30X | Bus | 3.2 | 35 | |
24 | Trolleybus | 2.81 | 32 | 31AX | Bus | 3.56 | 9 | |
27 | Bus | 2.07 | 28 | 31BX | Bus | 3.75 | 8 | |
28 | Bus | 2.48 | 42 | 38AX | Bus | 3.71 | 14 | |
29 | Bus | 2.5 | 36 | 38BX | Bus | 3.29 | 7 | |
30 | Trolleybus | 1.98 | 82 | 38L | Bus | 3.44 | 61 | |
31 | Trolleybus | 2.48 | 23 | 71L | Bus | 3.5 | 10 | |
33 | Trolleybus | 3.24 | 33 | California | Cable Car | 4.13 | 69 | |
36 | Bus | 2.1 | 10 | F | PCC Streetcar | 3.42 | 114 | |
37 | Bus | 3.42 | 12 | J | Light Rail | 2.49 | 45 | |
38 | Bus | 2.45 | 119 | KT | Light Rail | 2.13 | 23 | |
41 | Trolleybus | 2.82 | 17 | L | Light Rail | 2.13 | 38 | |
43 | Bus | 2.82 | 28 | M | Light Rail | 2.23 | 31 | |
44 | Bus | 2.83 | 24 | N | Light Rail | 2.55 | 189 | |
45 | Trolleybus | 2.62 | 21 | Powell-Hyde | Cable Car | 3.78 | 99 | |
47 | Bus | 2.13 | 23 | Powell-Mason | Cable Car | 3.52 | 25 |
The only lines not Yelped are the 35-Eureka and 56-Rutland. These lines have 30-minute headways (as does the 17-Parkmerced, see this route service chart with headways for all lines) while most lines in San Francisco have service every 15 minutes or better.
Next up: New York's subways. And beyond.
The train ratings match my experience well. Let's put the lower-ridership Blue Line aside, since I've only used it once and it serves a different part of the city. Of the other three, the Red Line is the best in terms of frequency, train modernity, and station quality (at least from South Station north; south of South Stations it's probably not as nice, but fewer people use it so it doesn't weigh down the ratings too much). The Orange is better than the Green in terms of rolling stock quality, and also in terms of frequency unless you're using the Green Line's shared section. Really the problem is that in the off-off-peak, the Green Line branches and the Orange Line drop to really bad frequencies, like 13 or 16 minutes; the Red Line branches do the same, but most ridership is north of JFK-UMass so it's less of a problem.
ReplyDeleteNow if only the MBTA turned those off-peak headways into 15-minute clockface patterns, posted clearly at each station...
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Centres in Chennai
DeletePython Training in Chennai Python Training in Chennai The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training Project Centers in Chennai
Great post, lot of good data in here.
ReplyDeleteWe think Yelp isn't the ideal way for people to rate and review their MBTA rides so we're building a site just for riders and commuters. Check us out at RateTheMBTA.com.
Our data so far from Twitter has shown that the REd Line is the most reviewed line and also among the poorest. Daily delays and breakdowns. The Green Line is right behind it while the Orange Line ranks higher.
@ratethembta, that's a great idea. I think this is helpful in the sense that these are ratings from a wider population; RateTheMBTA will probably pull from a different subset than Yelpers.
ReplyDelete@Alon, agree with most points. The OL frequencies are pretty awful off-peak, and it would be helpful if they were clockface, although the real time prediction apps (and new signage at most stations) help it. The GL can be unpredictable and there's no way to know where the trains are; they really need some technology there. The one saving grace is that inbound during the evenings the D Line at least runs on a pretty good schedule although, again, it's nowhere near clockface (every 13 minutes or something silly).
This is such a great resource that you are providing and you give it away for free. Buy Yelp Reviews Cheap
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteIt is in rare cases do brands become viral within a short period using the twitter followers.How To Get Twitter Followers
ReplyDeleteBy psychological insight, while an individual sees a high societal following, he inevitably is skilled to see you as an expert figure. Kind of like while you see a police force on the street or a celeb being followed through paparazzi. It’s a natural human nature and it can make enormous chances probable for your brand.How To Get Twitter Followers
ReplyDeleteReviews are the links of the local globe. They drive a new brand, product, service or bossiness and are imperative to growth.Get Google Reviews & Rating
ReplyDeleteBusiness can power up their relationship with customers by straightly linking with reviewers on Google. Buy Google Reviews
ReplyDeleteBefore purchasing that tries in accordance through keep complete concerning the products.Buy 5 star Google Reviews
ReplyDeleteGoogle reviews can either be positive or negative for your business, stores, office, restaurant, service or requirements. Google is the largest search engine, as well as the most efficient advertisement website.Buy 5 star Google Reviews
ReplyDeleteGoogle allows users to write reviews directly on the business’s Google or Google map listing. Since Google reviews are obviously favored by the search engine and show up upon every relevant result, the best place to start a business firm is getting involved with Google Reviews.
ReplyDeleteBuy 5 star Google Reviews
The key features of this service are that all page reposts are permanent). Second, you’ll get 100% satisfaction assurances. The service delivery time is 10 hours. No programs, bots, or software are used in this service. When you buy this service, it’s a 100 %stable and safe account, with real high-class campaigns as well as 100 % safety and security, as well as customer satisfaction. With this service, you’ll save time and effort. You’ll experience improvements within 24 hours.
ReplyDeleteBuying SoundCloud Plays
Google To FACEBOOK people are sharing their experiences on all, and what they say has a huge impact. Over 90% of contributors claimed that online positive reviews influenced their purchasing decision, and 85% said their decision was influenced by minus reviews.Buy Google Reviews
ReplyDeleteSoundCloud has given a significant career toward numerous new performers. It has given them a chance toward showcase their talent in all above the world.Buy SoundCloud Plays Cheap
ReplyDeleteOne of the reasons why artists should buy SoundCloud plays is acquiring intrinsic inspiration.Buy Real SoundCloud Plays
ReplyDeletewow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated.
ReplyDeleteBuy Soundcloud Plays
Buying Google reviews CLEAN SMM does not use system software; the system software is the operating system as well as every other utility which enables the computer to work smoothly. There is nothing like using application software which is also the programs which do the real job in the computer system. Buy Google Negative Reviews
ReplyDeleteDelivery time is ten hours before you know it your work is online waiting for likes and followers. There is nothing like wasting time unlike other social media. Buy Real Google Reviews
ReplyDeleteThe top positions on page one get the most clicks niche-relevant
ReplyDeleteAre you want to Buy Yelp Reviews?
ReplyDeleteYou can’t just sit watch your Yelp account suffer a lack of reviews, you will have to do your possible best to make your yelp content reviews increase. Yelp is also a social media platform; it is now an open place for you and me to earn cash without stress. That is if you make use of it in the right way. You can buy yelp reviews for your content with low reviews. This is the easiest way to attract more reviews to your stunning content. The Mangocity IT has made it easy for you to buy yelp reviews at any time you want, which will be delivered speedily.Buy Yelp Reviews
Why Do You Need to Buy Yelp Reviews ?
ReplyDeleteMoney is able to purchase a lot of things. But money can never buy you a good reputation especially when it comes to Yelp. Things could have been so simple if you could just be able to pay for some positive reviews on your Yelp page or if you could give discounts and prices to your customers so that they throw positive reviews. Buy 5 Star Yelp Reviews
Top Promoter This is really a nice and informative, containing all information and also has a great impact on the new technology. Check it out here: Mixcloud Promotion
ReplyDeleteTop SEO Work Excellent information on your blog, thank you for taking the time to share with us. Amazing insight you have on this, it's nice to find a website that details so much information about different artists. Facebook Reviews
ReplyDeleteThanks for this article very helpful. thanks. Premium Google Reviews
ReplyDeleteI read that Post and got it fine and enlightening. If you don't mind share more like that... Buy SoundCloud Reposts
ReplyDeleteBuy Soundcloud Service
ReplyDeleteThis is my first time i visit here. I discovered such a large number of fascinating stuff in your online journal particularly its dialog. From the huge amounts of remarks on your articles, I figure I am by all account not the only one having all the satisfaction here! keep doing awesome BUY GOOGLE PLUS REVIEWS
Seo Smm Blog Awesome post I might want to thank you for the endeavors you have made in composing this intriguing and educated article. Buy Reviews On Yelp
ReplyDeleteThis comment has been removed by the author.
ReplyDeletethank you I like this post I visit every day for your website. I will be waiting for the new post-buy Facebook review
ReplyDeleteI think this is an informative post and it is very beneficial and knowledgeable. Therefore, I would like to thank you for the endeavors that you have made in writing this article. All the content is absolutely well-researched. Thanks... Buy Verified Yelp Reviews
ReplyDeleteThank you for very usefull information. Buy 5 Star Yelp Reviews
ReplyDelete
ReplyDeleteI recently found many useful information in your website especially this blog page.nice informastion. Thanks for sharing .
Buy Google Places Reviews
ReplyDeleteWhy you should buy Yelp Reviews?
Business is no longer the same. Since the dawn of the internet, so much has changed in terms of how people do business. Initially, you simply had put a superior product in the market and your customer will tell another and another and your business grows. Currently, it is hard to run a business completely ignoring the internet – especially in the developed world. The perception of your business on the internet is extremely important .
Most customers will not buy a product without checking online what previous customers say about the product. Most customers are also likely to visit business websites with better reviews. 90% of customers read reviews before visiting business websites.
Shopping for Google Opinions could be a highly effective strategy to promote your website or weblog. You would possibly suppose that having the voice of your organization heard on Google is an efficient technique to construct up your model, however sadly, that goodwill is not going to come low cost. On common, the value of a Google search range from $35 - $70, whereas the value varies significantly for various firms. It's due to this fact necessary to grasp simply what you'll be able to count on while you Buy Positive Reviews Online, the best way to use them in your marketing campaign, and the place to purchase them from, to be sure you get one of the best worth for money.
ReplyDeleteThanks a lot for sharing this excellent article. Visitors will feel enjoy finding important things in your content. I am happy for myself and visitors for sharing this article.
ReplyDeletebuy soundcloud plays
buy instagram likes
buy instagram accounts
buy google voice numbers
Thanks a lot of sharing your experience... Buy Yelp Reviews
ReplyDeleteSuperb! Buy Old Gmail Accounts
ReplyDeleteBuy Yelp Reviews, Buying Yelp Reviews, from These Buying USA UK Real Active Organic Cheap Service Buy Yelp Reviews Cheap,
ReplyDeletebuy yelp reviews
ReplyDeleteReviews are a part of every man’s decision-making process nowadays. People rely on digital or even print media’s reviews, to be able to come up with a decision whether to buy this product or not. It is the same when people need some services.
In digital marketing, where businesses aim to reach out to millions of potential buyers, they need to find ways to be able to catch the attention of the audience.
One of your of the popular ways of doing it is to Buy Facebook Reviews
Get More Clients & Their Satisfaction By Using Google Map
ReplyDeleteGoogle Maps reviews make your client's mind set up to buy your product. It helps your business grow.it also helps you to increase your business. Google reviews give you target customers who really want to buy related to your product. it also gives your actual product quality.if you want to make an order or wants more information please visit this site
Buy Google Reviews
You are the only person whom I follow for Blogs and Articles. You deliver your message and positivity in such a Great manner that it is easy to understand. Thank You and Keep it up.Buy Verified PayPal Accounts
ReplyDeleteI read your article , your content is well and I like it Thank you For this.Buy Verified PayPal Account
ReplyDeleteExcellent Blog! I would like to thank for the efforts you have made in writing this post. I really like your writing style, wonderful information, thank you for posting. Quality content is what always gets the visitors coming.Buy Facebook Ads Accounts
ReplyDeleteI read your aritacle And it's very good.Check this links for
ReplyDeleteMore Information
Buy Facebook Ads Accounts
I recently found many useful information in your website especially this blog page.nice informastion. Thanks for sharing .
ReplyDeleteBuy Verified PayPal Accounts