Wednesday, November 21, 2012

Yelp Transit Maps

Yelp-rated routes in Boston. Click to embiggen.
I noticed a while ago—as did some other folks—that Yelp users have been, for some time, rating transit lines. I was intrigued. Here was really interesting data about how people felt about different transit lines, distilled in to a simple 1-to-5 rating. While not every line was ranked in Boston (my first search) there were plenty that were, and I compiled a list of routes, star-ratings and the number of Yelps.

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.
That. Is. Sexy. The N-Judah has nearly 200 reviews. Wow. And in case the downtown area is too clustered for you, there's an inset to the right.

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 typeRoutesAvg ReviewsAvg StarsWeighted Avg
Bus39223.032.77
Trolleybus12412.952.79
Cable Car3643.813.87
PCC11143.423.42
Light Rail5652.312.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.
LineVehicleStars# RatingsLineVehicleStars# Ratings
1Trolleybus2.967848Bus2.7117
2Bus2.532649Bus2.3340
3Trolleybus4.531752Bus2.58
5Trolleybus2.735554Bus2.610
6Trolleybus2.881666Bus41
9Bus2.422667Bus3.45
10Bus32471Bus2.5627
12Bus3.3315108Bus2.516
14Bus2.554401AXBus3.676
17Bus3.67601BXBus3.3113
18Bus3.251608XBus2.5618
19Bus2.664114LBus43
21Trolleybus3.583114XBus46
22Trolleybus2.749228LBus4.333
23Bus3930XBus3.235
24Trolleybus2.813231AXBus3.569
27Bus2.072831BXBus3.758
28Bus2.484238AXBus3.7114
29Bus2.53638BXBus3.297
30Trolleybus1.988238LBus3.4461
31Trolleybus2.482371LBus3.510
33Trolleybus3.2433CaliforniaCable Car4.1369
36Bus2.110FPCC Streetcar3.42114
37Bus3.4212JLight Rail2.4945
38Bus2.45119KTLight Rail2.1323
41Trolleybus2.8217LLight Rail2.1338
43Bus2.8228MLight Rail2.2331
44Bus2.8324NLight Rail2.55189
45Trolleybus2.6221Powell-HydeCable Car3.7899
47Bus2.1323Powell-MasonCable Car3.5225

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.

58 comments:

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

    Now if only the MBTA turned those off-peak headways into 15-minute clockface patterns, posted clearly at each station...

    ReplyDelete
  2. Great post, lot of good data in here.

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

    ReplyDelete
  3. @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.

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

    ReplyDelete
  4. This is such a great resource that you are providing and you give it away for free. Buy Yelp Reviews Cheap

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. It is in rare cases do brands become viral within a short period using the twitter followers.How To Get Twitter Followers

    ReplyDelete
  7. By 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

    ReplyDelete
  8. Reviews 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

    ReplyDelete
  9. Business can power up their relationship with customers by straightly linking with reviewers on Google. Buy Google Reviews

    ReplyDelete
  10. Before purchasing that tries in accordance through keep complete concerning the products.Buy 5 star Google Reviews

    ReplyDelete
  11. Google 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

    ReplyDelete
  12. Google 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.
    Buy 5 star Google Reviews

    ReplyDelete
  13. 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.
    Buying SoundCloud Plays

    ReplyDelete
  14. 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

    ReplyDelete
  15. SoundCloud 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

    ReplyDelete
  16. wow, 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.
    Buy Soundcloud Plays

    ReplyDelete
  17. 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

    ReplyDelete
  18. Delivery 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

    ReplyDelete
  19. Are you want to Buy Yelp Reviews?
    You 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

    ReplyDelete
  20. Why Do You Need to Buy Yelp Reviews ?
    Money 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

    ReplyDelete
  21. 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

    ReplyDelete
  22. Top 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

    ReplyDelete
  23. I read that Post and got it fine and enlightening. If you don't mind share more like that... Buy SoundCloud Reposts

    ReplyDelete
  24. Buy Soundcloud Service

    This 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

    ReplyDelete
  25. 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

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. thank you I like this post I visit every day for your website. I will be waiting for the new post-buy Facebook review

    ReplyDelete
  28. I 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

    ReplyDelete

  29. I recently found many useful information in your website especially this blog page.nice informastion. Thanks for sharing .
    Buy Google Places Reviews

    ReplyDelete

  30. Why 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.

    ReplyDelete
  31. Thanks 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.

    buy soundcloud plays

    buy instagram likes

    buy instagram accounts

    buy google voice numbers

    ReplyDelete
  32. Thanks a lot of sharing your experience... Buy Yelp Reviews

    ReplyDelete
  33. I read your article , your content is well and I like it Thank you For this.Buy Verified PayPal Account

    ReplyDelete
  34. I read your aritacle And it's very good.Check this links for
    More Information
    Buy Facebook Ads Accounts

    ReplyDelete
  35. Exceptional article, This website's content is filled with optimism and motivation. It makes me happy to read it. You're doing a fantastic job. Thank you very much.Gali result

    ReplyDelete
  36. " hey like to know the precious information on your blog i have a simliar piece on "keyword"" Australian email list

    ReplyDelete
  37. Thank you for useful information. We would like to introduce our service Buy Google Reviews. Our reviews are very genuine and real. For more info please visit our website : Buy Google Reviews

    ReplyDelete
  38. You made some excellent points here. Amazing stuff I believe you brought up some excellent points. Continue your wonderful work.Online Quran teaching

    ReplyDelete
  39. All of your entries on your website caught my attention, and I read them all. Thank you for providing this information.Buy Verified Binance Account

    ReplyDelete
  40. Good post! I will most definitely return to this blog more frequently this year because it is quite lovely! Many thanks for this useful post. Buy Verified PayPal Accounts

    ReplyDelete
  41. Buy Verified PayPal Accounts. USA, UK, CA phone number and Bank verified and Card and Passport verified PayPal account. 100% No Limit.Buy Verified PayPal Accounts

    ReplyDelete
  42. Typing Legend free typing speed test website. We will issue a typing certificate based on your typing speed. Join the typing legend to get fast typing and get a typing job. Here you can practice typing Bangla typing, you can practice typing English, you can practice Hindi typing, you can practice bahasa indonesia typing, you can practice tamil, telegu, marathi and more. Take a one minute typing test, three minute typing test, or five minute typing test. Learn your WPM for free, Test your typing speed now. take a typing speed test and get typing speed certificate for free.online bangla typing

    ReplyDelete
  43. Buy Verified Paxful Account. Buy UK, USA, CA, AUS phone number and Bank verified and Credit Card verified Paxful account. 100% Verified.Buy Verified Paxful Account

    ReplyDelete
  44. Check out NFT_GuruCreator's NFTs on OpenSea, the largest marketplace for crypto collectibles.low price NFT

    ReplyDelete
  45. Buy Verified PayPal Accounts. Buy USA, UK, CA Verified PayPal Accounts, High quality verified personal & Business Accounts. 100% No limit.Buy Verified PayPal Accounts

    ReplyDelete
  46. Buy Facebook Ads Accounts. USA, UK, CA Buy Verified Facebook Business Managers. Buy Facebook 5 Ads Creat and BM With Verified Profile.Buy Facebook Ads Accounts

    ReplyDelete
  47. Buy Verified Binance Accounts. USA, UK, CA kyc-verified binance account. All Documents buy fully verified binance account.Buy Verified Binance Accounts

    ReplyDelete
  48. Buy Verified Cash App Account. USA UK CA Verified Cash App Account. Bank, Card, SSN, Number, Passport Verfied Bitcoin Enabled Cash AppBuy Verified Cash Account

    ReplyDelete
  49. Buy Verified PayPal Accounts. You can buy verified PayPal accounts to make your business work more smoothly. help you buy Verified PayPal accounts..Buy Verified PayPal Accounts

    ReplyDelete
  50. Buy Verified PayPal Accounts. You can buy verified PayPal accounts to make your business work more smoothly. help you buy Verified PayPal accounts...Buy Verified PayPal Accounts

    ReplyDelete
  51. Buy Verified PayPal Account. Buy USA, UK, CA, AUS phone number and Bank verified and Credit Card verified Cheap Old PayPal account. No limit.Buy Verified PayPal Accounts

    ReplyDelete
  52. Buy Verified PayPal Accounts. You can buy verified PayPal accounts to make your business work more smoothly.Buy Verified Paypal Accounts

    ReplyDelete
  53. Buy Verified Cash App Account. fully BTC enable the account. We provide fully verified US, CA BTC enable account worldwide service. Shop Now.Buy Verified Cash App Accounts

    ReplyDelete
  54. Increase your credibility and customer trust with authentic Google 5 star reviews. Buy Google 5 star reviews to enhance your online reputation today.Buy Google 5 Star Reviews

    ReplyDelete
  55. When you buy TrustPilot reviews, you're paying someone to leave a positive review of your business on TrustPilot.Buy Trustpilot Reviews

    ReplyDelete