{"id":34482,"date":"2022-10-05T02:23:56","date_gmt":"2022-10-05T06:23:56","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=34482"},"modified":"2022-10-10T18:15:11","modified_gmt":"2022-10-10T22:15:11","slug":"commuting-to-work-from-flatbush-brooklyn","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/commuting-to-work-from-flatbush-brooklyn\/","title":{"rendered":"Commuting to Work from Flatbush, Brooklyn"},"content":{"rendered":"\n

Background and Question<\/strong><\/p>\n\n\n\n

One of the first things I noticed about living in Flatbush was how infrequently the B41 bus came and how frequently unmarked white vans came. I\u2019d often wait over 15 minutes for the bus even though the B41 is the primary route for accessing Downtown Brooklyn, as well as critical connections to other parts of Brooklyn and Midtown Manhattan. When the bus did come, it inched slowly down Flatbush Avenue, especially during rush hour. It eventually felt impossible to depend on. Such has been noted by MTA Chair and CEO Janno Lieber, who, along with Mayor Eric Adams, have plans to improve transit service for various New York communities. Flatbush has been labeled a Bus Priority Project because of its criticality as a cross-borough transportation corridor, its high number of average daily bus riders, slow bus speeds, and the number of people killed or seriously injured on Flatbush Ave between 2016-2021 (Flatbush Avenue Bus Priority Plan).<\/p>\n\n\n\n

I came to find out that much more frequent, unmarked white vans were \u201cdollar vans\u201d that shuffled folks up and down Flatbush Ave, letting you off wherever you needed to go until the Barclays Center. When I worked at the Navy Yard, I ended up taking these vans right past Grand Army Plaza, grabbing a coffee, and walking the remaining 30 minutes to work. To get home,  I\u2019d take the Yard\u2019s shuttle to Barclay\u2019s Center and another dollar van back home. As journalist Aaron Reiss noted in his article mapping and detailing this system, \u201cdollar vans and other unofficial shuttles make up a thriving shadow transportation system that operates where subways and buses don\u2019t\u2014mostly in peripheral, low-income neighborhoods that contain large immigrant communities and lack robust public transit\u201d (Reiss, “New York’s Shadow Transit”).<\/p>\n\n\n\n

It\u2019s this last point that I\u2019d like to explore in this report. Are commute times to work in Flatbush longer than those of other Brooklyn neighborhoods? Where are the longest commute times in Brooklyn? What is the median household income of these communities? Is there a relationship between median household income and commute time to work?<\/p>\n\n\n\n

Materials<\/strong><\/p>\n\n\n\n

For this project, I used Microsoft Excel for data cleaning, Social Explorer for data collection and mapmaking, and Datawrapper to make a chart. I used data from the 2019 American Community Survey 5-Year Estimates. I used \u201cTable A09003: Average Commute to Work (In Min)\u201d;  \u201cTable A09002B: Travel Time to Work for Workers 16 Years and Over 45 Minutes (In 15 Min Intervals) – Cumulative (More);\u201d and \u201cTable A14008: Average Household Income (In 2019 Inflation-Adjusted Dollars).\u201d<\/p>\n\n\n\n

Methodology<\/strong><\/p>\n\n\n\n

Data exploration and cleanup were the bulk of this project. The 2019 ACS data described above provided information for all of New York City. I filtered the data to only show values of Brooklyn and chose to visualize census-tract data because it was granular enough to allow neighborhood-specific exploration.<\/p>\n\n\n\n

The only other option was visualization by county, and since all of Brooklyn falls under Kings County, this view would not have been useful for my visualizations. During this phase, I calculated that the average commute time in Brooklyn was 45 minutes and chose to use this figure as a point of comparison.<\/p>\n\n\n\n

Because there are so many census tracts in Brooklyn, I was worried that my choropleth maps would look too crowded, since each tract would represent a data value. To help make my maps more legible, I chose only 6 classes for the cutpoints and grouped the data by quantiles, which resulted in maps that showed sufficient variation amongst the various data points. <\/p>\n\n\n\n

My choice of color scale depended on the emphasized variable. For \u201cAverage Commute to Work (In Min),\u201d for example, I chose a sequential scale from light yellow to dark orange, with the darker hues signifying longer commute times. \u201cAverage Household Income\u201d uses a green sequential scale where darker hues represent a higher median income. Orange\u2019s cultural association with negativity and green\u2019s cultural association with money proved useful here. For my map showing the percentage of workers who commuted over 45 minutes to work, I used a diverging color scale from dark blue to dark red. The diverging scale allows visualization using 50% as a midpoint \u2013 the redder a tract appears, the larger the percentage of workers commuting over 45 minutes. The bluer the tract, on the other hand, the smaller the percentage.<\/p>\n\n\n\n

I then decided to place these maps side by side for easy comparison of commute times and income across Brooklyn as a whole and between different Brooklyn census tracts. The green line outlines zip code 11226, an area of Flatbush.<\/p>\n\n\n\n

For my chart, I chose split bars because I was showing two different types of data in different units \u2013 average household income in USD and average commute time in minutes by census tract. I visualized the data of the five highest and lowest earning Brooklyn tracts to not overwhelm the reader. There are essentially two bar charts \u2013 average household income by census tract and average commute time by census tract. These are then grouped by where they rank relative to the average commute time in Brooklyn. Grouping the bars allows the reader to see variations within the data and how different tracts relate to each other. I used green bars for household income and yellow bars for commute time as fairly neutral colors. Even though it may not be clear to everyone where these census tracts are, I chose this labeling because zip codes and neighborhood names often contain multiple census tracts.<\/p>\n\n\n\n

Results, Interpretation, and Visualizations<\/strong><\/p>\n\n\n\n

I chose to create three side-by-side maps to compare all of the variables I was interested to one another. Those variables are: average commute time in minutes, average household income, and percent of workers commuting over 45 minutes to work. The maps appear to show a relationship between income and commute time, but statistical analysis would be needed to explore this topic further.\u00a0As mentioned previously, I aimed to reveal both overall patterns in Brooklyn and <\/em>more granular community-level patterns particularly through the maps visualizing the percentage of workers who commute for longer than 45 minutes.<\/p>\n\n\n\n

<\/span>\"\"
\n

Average Commute Time to Work (mins) and Average Household Income (USD)<\/a><\/p>\n<\/div><\/div>\n\n\n\n

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

<\/span>\"\"
\n

Average Household Income and Percent of Workers Commuting Longer than 45 Minutes to Work<\/a><\/p>\n<\/div><\/div>\n\n\n\n

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

<\/span>\"\"
\n

Average Commute to Work (mins) and Percentage of Workers Who Commute Longer than 45 Minutes to Work<\/a><\/p>\n<\/div><\/div>\n\n\n\n

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

The Datawrapper chart visualizes data from ten census tracts \u2013 the five highest- and lowest- earning. The data is grouped by whether the census tract\u2019s commute time is above or below the borough average.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Reflection and Future Work<\/strong><\/p>\n\n\n\n

Comparing volume when variables have different units of measurement and thus different scales presented a problem while building my chart in Datawrapper. I also wanted to visualize 3 variables \u2013 community, commute time, and income. I look forward to learning more about how to better approach this task. Because Datawrapper only allows a certain amount of editing and customization, I feel the bars showing household income do not communicate much meaningful information on their own since their size is arbitrary, though as a whole I do think the chart appears to show patterns between commute time and income.<\/p>\n\n\n\n

Future work could include incorporating transportation methods and availability and quality of public transportation.<\/p>\n","protected":false},"excerpt":{"rendered":"

Background and Question One of the first things I noticed about living in Flatbush was how infrequently the B41 bus came and how frequently unmarked white vans came. I\u2019d often wait over 15 minutes for the bus even though the B41 is the primary route for accessing Downtown Brooklyn, as well as critical connections to…<\/p>\n","protected":false},"author":4027,"featured_media":34507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":true,"_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":[340,149,341,1],"tags":[1810,5,31,19,1823],"coauthors":[1805],"class_list":["post-34482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-charts","category-labs","category-maps","category-visualization","tag-datawrapper","tag-information-visualization","tag-maps","tag-nyc","tag-social-explorer"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2022\/10\/image-1.png?fit=2880%2C1472&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-8Ya","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34482","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\/4027"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=34482"}],"version-history":[{"count":11,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34482\/revisions"}],"predecessor-version":[{"id":34512,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/34482\/revisions\/34512"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/34507"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=34482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=34482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=34482"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=34482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}