{"id":25225,"date":"2021-07-31T00:45:47","date_gmt":"2021-07-31T04:45:47","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infovis\/?p=25225"},"modified":"2021-10-05T14:40:05","modified_gmt":"2021-10-05T18:40:05","slug":"improving-cycling-safety-in-nyc","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/projects\/improving-cycling-safety-in-nyc\/","title":{"rendered":"improving cycling safety in nyc"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">Cycling is great as exercise, leisure, or a mode of transportation. It\u2019s one of the most efficient ways to get around (and friendly to the environment), while offering great health benefits. More and more people in New York City have taken up cycling in the past two decades, according to <a href=\"https:\/\/www.nyc.gov\/html\/dot\/downloads\/pdf\/cycling-in-the-city.pdf\">the city\u2019s report in 2019<\/a>. 24% of adult New Yorkers reported to have ridden a bike <em>at least<\/em> once in the year of 2017, and of those New Yorkers, 53% of them (793,000) reported that they ride a bike regularly, or several times a month. The city estimates about 490,000 cycling trips are made per day.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">With these rising numbers, <a href=\"https:\/\/www.nyc.gov\/html\/dot\/downloads\/pdf\/cycling-in-the-city.pdf\">the city has also rapidly increased the number of bike lanes<\/a>: in the past seven years, NYC DOT has expanded the on-street bike network by more than 330 miles, including more than 82 protected lane miles. So how safe is it to bike around in New York today?<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\"><a href=\"https:\/\/www1.nyc.gov\/html\/dot\/html\/bicyclists\/bike-ridership-safety.shtml\">Cycling appears to be generally safe in the city<\/a>, though incidents (including fatalities) are more frequent than they should be. Where are these incidents occurring and what are the causes? Are there any patterns that can be established to better inform the city\u2019s planning to make cycling safer? This project provides a snapshot of cycling incidents (collisions with pedestrians, vehicles, or other cyclists) in New York from 2012-2021. It aims to uncover insights into how the city could potentially improve bike infrastructure, visualizing different factors that may impact safety.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\"><a href=\"https:\/\/www.bicycling.com\/news\/a31122171\/nyc-cycling-crash-data\/\">Data has shown<\/a> that motorists are significantly more likely to be at fault in crashes with cyclists. This comes as no surprise; we all share the same road, and those of us on bikes are far more vulnerable than those in cars. One obvious approach to improving safety is to build more bike lanes; the city reports that, between 2006 and 2016, <a href=\"https:\/\/www1.nyc.gov\/html\/dot\/html\/bicyclists\/bike-ridership-safety.shtml\">only 11% of cyclist fatalities occurred on streets with a bicycle facility<\/a> (the vast majority of fatalities on streets with no bike lanes). <a href=\"https:\/\/www.aarp.org\/livable-communities\/getting-around\/info-2016\/why-bicycling-infrastructure-is-good-for-people-who-dont-ride-bikes.html\">Many would also agree<\/a> that a more robust bike infrastructure makes streets safer for everyone: cyclists, drivers, and pedestrians alike. This report is intended for anyone interested in making New York streets safer for all.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Methods<\/h2>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\"><strong>Process<\/strong><\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">To first get a sense of overall trends of cycling incidents in the city, I used data from the <a href=\"https:\/\/data.cityofnewyork.us\/Public-Safety\/Motor-Vehicle-Collisions-Crashes\/h9gi-nx95\">NYC OpenData on Motor Vehicle Collisions<\/a>, which tracks all collisions involving vehicles and bicycles from 2012-2021. I added a column that summed up the number of injuries or fatalities involving a cyclist, and plotted the data by type, time, and location (borough and zip code) into <a href=\"https:\/\/public.tableau.com\/app\/profile\/staci1152\/viz\/NYCCyclingIncidents\/Dashboard3\">Tableau<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-jetpack-slideshow aligncenter\" data-effect=\"slide\"><div class=\"wp-block-jetpack-slideshow_container swiper-container\"><ul class=\"wp-block-jetpack-slideshow_swiper-wrapper swiper-wrapper\"><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"508\" alt=\"\" class=\"wp-block-jetpack-slideshow_image wp-image-25227\" data-id=\"25227\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1-1024x619.png?resize=840%2C508&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=1024%2C619&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=300%2C181&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=768%2C465&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=1536%2C929&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=2048%2C1239&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=800%2C484&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?resize=298%2C180&amp;ssl=1 298w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash1.png?w=1680 1680w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-block-jetpack-slideshow_caption gallery-caption\">General trends by time, by type, and by location.<\/figcaption><\/figure><\/li><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"503\" alt=\"\" class=\"wp-block-jetpack-slideshow_image wp-image-25228\" data-id=\"25228\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=840%2C503&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?w=2506&amp;ssl=1 2506w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=300%2C180&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=1024%2C613&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=768%2C460&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=1536%2C919&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=2048%2C1226&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=800%2C479&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?resize=301%2C180&amp;ssl=1 301w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash2.png?w=1680 1680w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><li class=\"wp-block-jetpack-slideshow_slide swiper-slide\"><figure><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"503\" alt=\"\" class=\"wp-block-jetpack-slideshow_image wp-image-25229\" data-id=\"25229\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=840%2C503&#038;ssl=1\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?w=2514&amp;ssl=1 2514w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=300%2C179&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=1024%2C613&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=768%2C459&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=1536%2C919&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=2048%2C1225&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=800%2C479&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?resize=301%2C180&amp;ssl=1 301w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/dash3.png?w=1680 1680w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/figure><\/li><\/ul><a class=\"wp-block-jetpack-slideshow_button-prev swiper-button-prev swiper-button-white\" role=\"button\"><\/a><a class=\"wp-block-jetpack-slideshow_button-next swiper-button-next swiper-button-white\" role=\"button\"><\/a><a aria-label=\"Pause Slideshow\" class=\"wp-block-jetpack-slideshow_button-pause\" role=\"button\"><\/a><div class=\"wp-block-jetpack-slideshow_pagination swiper-pagination swiper-pagination-white\"><\/div><\/div><\/div>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">This provided a good bird\u2019s eye view, but in order to make this information useful and applicable, I had to drill down further. Using <a href=\"https:\/\/carto.com\/\">Carto<\/a>, I mapped out all incidents by their coordinates, to see if any major clusters or hotspots could easily be identified on certain streets or intersections. The sheer number of incidents, however, created an overly cluttered visualization, with too many dots (representing incidents) densely packed on the map. I tried to separate them out by year, but couldn\u2019t identify any clear trends year to year either, at least not at a citywide scale.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"541\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1-1024x659.png?resize=840%2C541&#038;ssl=1\" alt=\"\" class=\"wp-image-25235\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=1024%2C659&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=300%2C193&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=768%2C494&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=1536%2C989&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=2048%2C1318&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=800%2C515&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?resize=280%2C180&amp;ssl=1 280w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-1.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Individual incidents plotted by year<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">To understand the spread of incidents more easily, I grouped them by zip code, summing up the total number per area over 2012-2021. To create zip code polygons for the city, I used <a href=\"https:\/\/data.cityofnewyork.us\/Business\/Zip-Code-Boundaries\/i8iw-xf4u\">this dataset<\/a>, also from NYC OpenData. A color gradient immediately calls out the \u201chot\u201d areas with high numbers of incidents.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"550\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1-1024x671.png?resize=840%2C550&#038;ssl=1\" alt=\"\" class=\"wp-image-25234\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=1024%2C671&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=300%2C196&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=768%2C503&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=1536%2C1006&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=2048%2C1341&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=800%2C524&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?resize=275%2C180&amp;ssl=1 275w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/incidents-by-zip-1.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Incidents by zip code<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">I also mapped out current bike lanes to see if the incidents might be occurring in areas lacking infrastructure, and if there might be a difference in number between types of lanes. I found geospatial data on bike lanes from <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/Bicycle-Routes\/7vsa-caz7\">this dataset<\/a>, also from NYC OpenData. The dataset includes type of \u201cfacility\u201d per lane: whether they are protected (physically separated from vehicles), conventional (marked lanes on pavement), or shared (pavement markings of arrows and bicycle signs only to indicate that the road is shared). I color coded the lanes by type, matching the colors used in the <a href=\"https:\/\/www1.nyc.gov\/html\/dot\/downloads\/pdf\/nyc-bike-map-2021.pdf\">official city map<\/a>.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"545\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1-1024x664.png?resize=840%2C545&#038;ssl=1\" alt=\"\" class=\"wp-image-25237\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=1024%2C664&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=300%2C195&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=768%2C498&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=1536%2C996&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=2048%2C1328&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=800%2C519&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?resize=278%2C180&amp;ssl=1 278w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes-1.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Bicycle lanes in the city<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">I also found <a href=\"https:\/\/data.cityofnewyork.us\/Transportation\/VZV_Bike-Priority-Areas\/ii5c-g6sq\">a dataset <\/a>published by NYC DOT that highlighted <a href=\"https:\/\/www1.nyc.gov\/html\/dot\/html\/bicyclists\/bike-ridership-safety.shtml\">\u201cPriority Bicycle Districts,\u201d<\/a> which are neighborhoods currently flagged for increasing infrastructure. These 10 districts are neighborhoods the city has prioritized for future bicycle network expansion. The city reports that these districts represent only 14% of the city\u2019s existing network but have 23% of incidents of cyclists KSI (killed or severely injured).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"623\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends-1024x759.png?resize=840%2C623&#038;ssl=1\" alt=\"\" class=\"wp-image-25238\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=1024%2C759&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=300%2C222&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=768%2C569&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=1536%2C1138&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=800%2C593&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?resize=243%2C180&amp;ssl=1 243w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?w=1898&amp;ssl=1 1898w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/trends.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Incident trends by zip code<\/figcaption><\/figure>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">Lastly, I took the data on incidents and uploaded them into <a href=\"https:\/\/carto.com\/help\/tutorials\/predict-trends-and-volatility\/\">Carto\u2019s \u201cPredict Trends and Volatility\u201d tool<\/a>. This tool predicts whether a future value at a given location will increase, decrease, or remain the same, based on previous values equally spaced in time of that location. In order to input data, I had to transform my original dataset: first, I counted total incidents by year per zip code, then I spread each year into its own column (all transformations done in R).<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\"><strong>User Testing<\/strong><\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">I tested my maps with two participants, to gauge overall clarity of the visualization and to see how they would interpret the data. Both users commented on how the incidents seemed to be \u201ceverywhere,\u201d even on streets and intersections with protected bike lanes, and how they \u201call look the same\u201d from year to year.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">User 1 (Eric) assumed that the incidents are \u201cin more densely populated places,\u201d and was curious to see a map showing population per zip code.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">User 2 (Susan) observed that it seemed like there are \u201cmore incidents where there are bike lanes,\u201d which surprised her, before she rationalized that \u201cmore traffic means more accidents.\u201d She then wondered if the areas with a higher number of incidents are also areas with higher traffic in general, and thought it would be helpful to see a layer with car traffic data.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">I was curious about both factors, population and vehicle traffic. Population was easy to plot out; the data was already part of the city\u2019s <a href=\"https:\/\/data.cityofnewyork.us\/Business\/Zip-Code-Boundaries\/i8iw-xf4u\">Zip Code geospatial dataset<\/a>. Data on vehicle traffic, however, was tricky: I couldn\u2019t find any dataset that tabulated number of vehicles per street or neighborhood, but I figured that, in place of traffic data, I could use the data I already had on vehicular incidents (the same <a href=\"https:\/\/data.cityofnewyork.us\/Public-Safety\/Motor-Vehicle-Collisions-Crashes\/h9gi-nx95\">Motor Vehicle Collisions dataset<\/a> I used for cyclist incidents).<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"549\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2-1024x669.png?resize=840%2C549&#038;ssl=1\" alt=\"\" class=\"wp-image-25247\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=1024%2C669&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=300%2C196&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=768%2C502&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=1536%2C1004&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=2048%2C1339&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=800%2C523&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?resize=275%2C180&amp;ssl=1 275w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/population-by-zip-2.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Population by zip code<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"551\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2-1024x672.png?resize=840%2C551&#038;ssl=1\" alt=\"\" class=\"wp-image-25248\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=1024%2C672&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=300%2C197&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=768%2C504&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=1536%2C1007&amp;ssl=1 1536w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=2048%2C1343&amp;ssl=1 2048w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=800%2C525&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?resize=274%2C180&amp;ssl=1 274w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/car-accidents-by-zip-2.png?w=1680 1680w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Car accidents by zip code<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">As for the trends map, user 1 (Eric) understood it immediately, especially once he noticed the trends widget. User 2 (Susan), however, found the map unclear, since it didn\u2019t correlate with the original incidents map. More context is definitely needed for the trends map, even if just in the form of an accompanying description. Unfortunately, Carto limits the amount of descriptive text allowed for a map (and the title isn\u2019t large or noticeable enough). Susan understood the trends map once I described it to her, and wondered why the areas in the outer areas of Queens and Staten Island were trending up, assuming that Covid must have had an impact since \u201ceveryone is biking now.\u201d<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Results<\/h2>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">The main conclusion to be drawn from all this data is that cyclist safety involves many factors: sheer volume of bike ridership, infrastructure needs based on ridership, and also volume of vehicle traffic in a given area (generally, how busy the streets are). I think the city\u2019s prioritized areas for future bicycle facilities seem mostly correct in addressing opportunity areas, but perhaps too much focus is on expansion only. Resources could also be directed to improving existing infrastructure, especially investigating the impact of converting a shared or conventional lane into a protected lane.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">I debated whether or not to remove the layer on individual incidents since it was difficult to analyze and interpret, even when separated out into different years. The animation was interesting, but not helpful \u2014 there was no discernible pattern in clusters of incidents from year to year. Perhaps a zoomed in view at the street level could reveal patterns for that specific street, but not at the city scale. Both users I spoke with were interested in seeing data by year, even if their takeaway was that number of incidents didn\u2019t change much over time.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-cartodb wp-block-embed-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/shou70.carto.com\/viz\/14802d8b-5eb9-4862-b675-2d6d5505a5ce\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><figcaption>Incidents map<\/figcaption><\/figure>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">The overarching question then becomes: If the city has already invested so much in building more bike lanes, especially strategically in opportunity areas, then why aren\u2019t these numbers going down? It should be noted that these numbers are absolute and do not represent a percentage of total ridership. This may explain why Manhattan still has so many incidents while its streets seem to all be equipped with bike lanes. Type of bike lane also likely makes a difference; they shouldn\u2019t all be treated the same.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">When comparing the number of cycling incidents vs. population vs. number of car accidents, all by zip code, a few correlations emerge. There\u2019s a strong overlap between areas with high cycling incidents and areas with high car accidents; there\u2019s only 2-3 areas where cycling incidents are high while car accidents are relatively lower. There\u2019s less of a correlation between the population map and the other two, however. A lot of midtown Manhattan and central Brooklyn zip codes have high incidents (both cycling and car) but low population, likely because these are business areas with high traffic, where people commute in for work but few reside there.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-cartodb wp-block-embed-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/shou70.carto.com\/viz\/dd350989-3614-44a6-914f-43ea43f8df57\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><figcaption>Comparison of population and car accidents by zip code<\/figcaption><\/figure>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">As mentioned, the trends map doesn\u2019t quite stand alone on its own; it requires some descriptive or introductory text so the user can better understand how to interpret the map. Once explained, however, it\u2019s clear what the color gradient means, and why this map doesn\u2019t correlate directly with the incidents map.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">Since the trends map is highlighting areas where incidents have been ticking up in recent years (from 2012 to early 2021), it\u2019s measuring any large percentage in growth from previous numbers. This information seems helpful, but I\u2019m assuming the outer areas of Queens and Staten Island still have overall lower numbers than ones in Manhattan and central Brooklyn, even if trends are staying about the same there. As User 2 (Susan) mentioned, this is likely because people in the outer areas have picked up cycling recently, and with higher ridership comes more incidents. This might explain why the areas marked for priority for future bike infrastructure aren\u2019t necessarily the areas that have been trending up in recent years. It seems like half of the areas marked (mostly in central Brooklyn and central Queens) are trending up while the other half of them are remaining the same.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-cartodb wp-block-embed-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/shou70.carto.com\/viz\/a002561f-9704-45dc-8ab0-28c98cf1b243\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><figcaption>Trends map<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Reflections<\/h2>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">These maps help capture the complexity of the problem: ensuring cycling safety in the city requires taking into account several different factors. One major factor at play is volume of vehicle traffic, which takes place in areas even with smaller populations. Another factor is number of cyclists and if current bicycle infrastructure really meets the needs of ridership in different streets and intersections. It would be helpful to get accurate information on ridership overall, to understand which street lanes are busiest and require either conversion to protected lanes, or for neighboring streets to have lanes as well (so one street\u2019s bike lane isn\u2019t overwhelmed with cyclists).<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">More research is definitely needed on the different types of bike lanes, with the assumption that protected bike lanes are the safest, conventional bike lanes come in second, and shared lanes perhaps offering no measure of protection at all. With this data in place, the city can weight the lanes differently, so it\u2019s not just a blanket quantification of bike lanes in a given area.<\/p>\n\n\n\n<p class=\"has-dark-gray-color has-text-color\">Lastly, data on types of injuries would be helpful. This is where the city has already done some research, in order to calculate cyclists KSI (killed or severely injured), which factored into their decision making on the priority areas for planned bike lanes. In the dataset that I worked with, injuries are all equally counted, obscuring any insight on areas with higher incidence of severe injuries (if not fatalities).<\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Sources:<\/strong><\/p>\n\n\n\n<ul class=\"has-dark-gray-color has-text-color wp-block-list\"><li><span style=\"color: initial;, sans-serif\">NYC DOT Safer Cycling: Bicycle Ridership and Safety in New York City (2017) (<\/span><a rel=\"noreferrer noopener\" style=\", sans-serif\" href=\"https:\/\/www1.nyc.gov\/html\/dot\/html\/bicyclists\/bike-ridership-safety.shtml\" target=\"_blank\">link<\/a><span style=\"color: initial;, sans-serif\">)<\/span><\/li><li>NYC DOT Cycling in the City (2019) (<a rel=\"noreferrer noopener\" href=\"https:\/\/www1.nyc.gov\/html\/dot\/html\/bicyclists\/cyclinginthecity.shtml\" target=\"_blank\">link<\/a>)<\/li><li>Roe, D. &amp; Jackson, D. (2020, Feb. 28). What\u2019s Really Killing New York\u2019s Cyclists. Bicycling. (<a rel=\"noreferrer noopener\" href=\"https:\/\/www.bicycling.com\/news\/a31122171\/nyc-cycling-crash-data\/\" target=\"_blank\">link<\/a>)<\/li><li>Walljasper, J. (2016, Sep.) 10 Ways Bicycle-Friendly Streets Are Good for People Who Don&#8217;t Ride Bikes. AARP. (<a href=\"https:\/\/www.aarp.org\/livable-communities\/getting-around\/info-2016\/why-bicycling-infrastructure-is-good-for-people-who-dont-ride-bikes.html\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a>)<\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Cycling is great as exercise, leisure, or a mode of transportation. It\u2019s one of the most efficient ways to get around (and friendly to the environment), while offering great health benefits. More and more people in New York City have taken up cycling in the past two decades, according to the city\u2019s report in&hellip;<\/p>\n","protected":false},"author":3036,"featured_media":25236,"comment_status":"open","ping_status":"open","sticky":true,"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":[150],"tags":[],"coauthors":[1389],"class_list":["post-25225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-projects"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/07\/bike-lanes.png?fit=2106%2C1366&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-6yR","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/25225","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\/3036"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=25225"}],"version-history":[{"count":6,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/25225\/revisions"}],"predecessor-version":[{"id":25250,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/25225\/revisions\/25250"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/25236"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=25225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=25225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=25225"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=25225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}