{"id":5299,"date":"2016-10-01T14:11:33","date_gmt":"2016-10-01T18:11:33","guid":{"rendered":"http:\/\/research.prattsils.org\/?p=5299"},"modified":"2016-10-01T14:11:33","modified_gmt":"2016-10-01T18:11:33","slug":"making-grade-visualizations-restaurant-grades-manhattan","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/making-grade-visualizations-restaurant-grades-manhattan\/","title":{"rendered":"Making The Grade: Visualizations of Restaurant Grades in Manhattan"},"content":{"rendered":"

<\/a><\/p>\n

For this visualization, I started with noticing letter grades in windows of restaurants. Using NYC open data site, initial<\/p>\n

lines of inquiry included questions such as \u201cWhich parts of Manhattan had the most restaurants with \u2018B\u2019 or lower?\u201d, and \u201cWhich<\/p>\n

restaurants in Hell\u2019s Kitchen had the best grades?\u201d, and \u201cHow many grade \u2018A\u2019 restaurants are there in the city?\u201d, and \u201cHow<\/p>\n

many grade \u2018A\u2019 restaurants are there in ZIP 10036?\u201d That last question is the one I focused on and discuss below.<\/p>\n

As described above, my initial questions were exploratory in nature. I did not have a specific theory in mind to prove or<\/p>\n

disprove.<\/p>\n

Working with restaurant data<\/a>, I was able to pull data for all boroughs, but narrowed it to Manhattan. I decided to focus<\/p>\n

on Zip code in which I live (10036), and see what the grades were for the restaurants there. Looking at the ZIP-specific data, I<\/p>\n

had a concern about it being too narrow. After filtering the data for 10036, it had more than enough (over 1,800 restaurants), so<\/p>\n

the minimum data requirements were exceeded. The associated visualization is here.<\/a><\/p>\n

\u00a0Additionally, I looked at restaurant grades and inspection dates for all Manhattan ZIP codes, primarily to see what the<\/p>\n

visualization would look like, as well obtaining an overall picture of grades by ZIP. Though not the main focus of this lab, it is<\/p>\n

included as an example of Tableau outputs.<\/p>\n

\u00a0Visualization # 1 (Figure 1) was what I had in initially envisioned mind when looking for data. It looked like it would be<\/p>\n

easily read and understood (aside from the use of red\/green, for color-blind folks), and is somewhat close to what I used for the<\/p>\n

lab. The ultimate end product looked similar to Figure 1.<\/p>\n

(Figure 1, below. Source: https:\/\/harvarddatasciencerestaurantinspections.files.wordpress.com\/2014\/12\/health-grades-by-borough.png)<\/a>)<\/p>\n

\"picture1\"<\/a><\/p>\n

Visualization #2 (Figure 2) was also similar to what I had in mind, as it had restaurant data, though I was not focusing on<\/p>\n

violations in my visualization. I wound up using the bar chart format though they were oriented horizontally instead of<\/p>\n

vertically. I stayed away from including the violations (detailed in the NYC open data site), as there are over 20 different<\/p>\n

infractions, and their associated descriptions. Representing that data in a way people could understand seemed challenging, at<\/p>\n

first glance. The violation descriptions were very wordy, so presenting them would have altered my design, as well as the focus<\/p>\n

of the visualization. A legend would be needed to help readers decode the violations and what they meant.<\/p>\n

(Figure 2, below. Source: https:\/\/www.linkedin.com\/pulse\/nyc-restaurant-health-grades-visualizing-results-john-bencina<\/a>)<\/p>\n

\"picture2\"<\/a><\/p>\n

Visualization #3 (Figure 3) was more of a hypothetical idea, in the vein of \u201cthis could also work in a map format, but I\u2019m<\/p>\n

not sure how to execute it\u201d. It has a great deal of data, that may take someone a bit of time to process, as it is rather complex,<\/p>\n

not only in colors, but also in how it presents the data. As I was looking to create something simpler, the visualization below did<\/p>\n

not quite fit the bill.<\/p>\n

(Figure 3, below. Source http:\/\/opendatabits.com\/nyc-restaurant-inspections-results-open-data\/)<\/p>\n

\"picture-3\"<\/a><\/p>\n

To create the visualization, I used Tableau Public 9.3, MS Excel, and Firefox web browser for conducting data searches. The<\/p>\n

data set came from the NYC open data site, focusing on restaurants<\/a> in particular. Looking for information, I had located other<\/p>\n

data sets, including one on commuting times and census areas, but it seemed too complex to work with, so it was not used.<\/p>\n

Restaurants seemed like a good idea, as most everyone goes out to eat at some point.<\/p>\n

Method-wise, I started looking at NYC open data and other sites to get a feel for what was out there. Some looked good,<\/p>\n

but did not pan out for various reasons: not enough data, or uncertainty around what exactly I would do with the data. The<\/p>\n

commuting time and census areas data had some issues: different years measured, census areas changed over time, which<\/p>\n

seemed like it would take a fair amount of reconciliation to get something usable.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Looking at restaurant data, I drafted a few exploratory questions (mentioned above) to frame what to look for once I<\/p>\n

found what appeared to be a solid data set. Ultimately, my questions were relatively simple, quantitative ones. I used Excel to<\/p>\n

download and filter data to show Manhattan (overall) as well as ZIP 10036, to see what was available.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The Department of Health grading schedule<\/a>\u00a0 details the violations and associated points, as well as the point thresholds<\/p>\n

for \u2018A\u2019, \u2018B\u2019, and \u2018C\u2019 grades. Note: No seemingly reliable information was found for meanings of Grade \u2018P\u2019 and Grade \u2018Z\u2019<\/p>\n

restaurants, so they are not addressed in the visualizations.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Tableau, I tried different variations on the data to get a feel for what the visualizations would look like.<\/p>\n

Several of them were similar, with minor revisions, such as filtering out cells with null data. The most detailed was the bar chart<\/p>\n

breaking down the grades by zip code,<\/a> in terms of volume of data presented.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In terms of results, data available as of September 17, 2016, showed 336 restaurants with an \u2018A\u2019 grade in 10036. Looking<\/p>\n

at data from 2012 to 2015, the number of \u2018A\u2019 grade restaurants increased from 9 in 2012 (the first year in which restaurant<\/p>\n

grades were used), to 235 in 2013, up to a high point of 451 in 2015.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Grade \u2018B\u2019 restaurants in 10036 showed a different pattern. 2012 had no establishments with \u2018B\u2019 grades. 2013 had 56,<\/p>\n

2014 had 71, dipping slightly in 2015 to 69, and falling off in 2016 to a total of 38 with a \u2018B\u2019 grade.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Grade \u2018C\u2019 establishments in 10036 peaked in 2013, with 40. Subsequent years showed a decline \u2013 2014, with 29, 2015<\/p>\n

had 27, and 2016 had only 5.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 In ZIP 10036, the \u2018A\u2019 grade establishment decline was rather large \u2013 over 100 fewer restaurants from 2015 to 2016. This<\/p>\n

could be possibly<\/em> attributed to establishments closing, or not being inspected in 2016, though further research would be needed<\/p>\n

to compare 2015 data to 2016. One thing to consider would be the number of restaurants open in 2015 versus 2016, to<\/p>\n

determine if there are any trends in terms of openings or closings. Additionally, 2016 is not yet complete, and the data reflected<\/p>\n

is only through September, not a full calendar year.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The number of lower-graded (B and C) restaurants declined after 2014. That decline could possibly<\/em> be attributed to<\/p>\n

restaurants becoming used to the inspection process, or establishments closing for various reasons (redevelopment, rent<\/p>\n

increases), that are beyond the scope of this visualization. Without having a baseline of sorts, and different data than what was<\/p>\n

used here, making anything other than a semi-educated guess is difficult.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Future research could include looking at what restaurants were open in one year versus another for a specific time<\/p>\n

period [September 1, 2015 to August 31, 2016 for example], to get a feel for what is behind the decrease of \u2018A\u2019 rated places in<\/p>\n

2016, in ZIP 10036. Is it because places have closed? Have they not been re-inspected? Have their grades declined over that<\/p>\n

year?<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Other areas to investigate include what were the most common violations for a given ZIP, or borough. That could be<\/p>\n

conducted with the existing data set. Though whether or not one would really want to know is open for debate.<\/p>\n

 <\/p>\n

Resources<\/u><\/p>\n

Links to Visualizations, Data Sources, and Department of Health Inspection Scoring<\/p>\n

Visualization #1 https:\/\/public.tableau.com\/profile\/tony.volpe#!\/vizhome\/Lab2_64\/Sheet1<\/a><\/p>\n

Restaurant Grades and Inspection Dates (ZIP 10036)<\/p>\n

Visualization #2<\/p>\n

https:\/\/public.tableau.com\/profile\/tony.volpe – !\/vizhome\/AllRestaurantsByZip\/Sheet3<\/a><\/p>\n

Grades and Inspection Dates for all restaurants in Manhattan<\/p>\n

NYC Restaurant Data<\/p>\n

https:\/\/data.cityofnewyork.us\/Health\/DOHMH-New-York-City-Restaurant-Inspection-Results\/43nn-pn8j<\/a><\/p>\n

Department of Health Restaurant Scoring<\/p>\n

http:\/\/www1.nyc.gov\/assets\/doh\/downloads\/pdf\/rii\/how-we-score-grade.pdf<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

For this visualization, I started with noticing letter grades in windows of restaurants. Using NYC open data site, initial lines of inquiry included questions such as \u201cWhich parts of Manhattan had the most restaurants with \u2018B\u2019 or lower?\u201d, and \u201cWhich restaurants in Hell\u2019s Kitchen had the best grades?\u201d, and \u201cHow many grade \u2018A\u2019 restaurants are…<\/p>\n","protected":false},"author":432,"featured_media":5298,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[],"class_list":["post-5299","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-1nt","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/5299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/432"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=5299"}],"version-history":[{"count":0,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/5299\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=5299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=5299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=5299"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=5299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}