{"id":20937,"date":"2020-11-13T15:22:30","date_gmt":"2020-11-13T20:22:30","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=20937"},"modified":"2021-01-18T16:59:18","modified_gmt":"2021-01-18T21:59:18","slug":"mapping-bicycle-accidents-in-nyc","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/mapping-bicycle-accidents-in-nyc\/","title":{"rendered":"Mapping Bicycle accidents in nyc"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-1.01.42-PM.png?resize=414%2C672&#038;ssl=1\" alt=\"\" class=\"wp-image-20941\" width=\"414\" height=\"672\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-1.01.42-PM.png?w=588&amp;ssl=1 588w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-1.01.42-PM.png?resize=185%2C300&amp;ssl=1 185w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-1.01.42-PM.png?resize=111%2C180&amp;ssl=1 111w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>New York City is experiencing an increase of accidents amongst cyclist every year and as a results the summer of 2020 reported the highest number of bicycle accidents. In a report created on September 2020, I created a graph detailing the number of accident each month from August 2017 to August 2020. The graph contained information on the accidents happening in each month but did not have any information on the areas in which the accidents were occuring. The purpose of this lab is to create a map that will allow viewers to identify the regions that have the highest number of bicycle accidents.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Inspirations<\/h2>\n\n\n\n<p>In my previous report, I was inspired by a heat map of the accidents in NYC. While the heat map pointed out the areas that are high in accidents, the map was not specified in the areas accidents occured and also did not have any other bit of information for the viewers to read.  <\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.sherpashareblog.com\/wp-content\/uploads\/2017\/02\/Screen-Shot-2017-02-13-at-2.49.32-PM.png?w=840&amp;ssl=1\" alt=\"\" data-id=\"\" \/><\/figure><\/li><\/ul><\/figure>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/cdn.toddwschneider.com\/collisions\/cyclists_injured_map.png?w=840&#038;ssl=1\" alt=\"\" data-id=\"\" \/><figcaption class=\"blocks-gallery-item__caption\">https:\/\/cdn.toddwschneider.com\/collisions\/cyclists_injured_map.png<\/figcaption><\/figure><\/li><\/ul><\/figure>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Methodology<\/h2>\n\n\n\n<p>The dataset used for this lab was used previously in a report I created counting the number of accidents per month from August 2017 to August 2020. The data was reviewed and processed through Openrefine and analyzed with Tableau. <\/p>\n\n\n\n<p>This lab specifically focuses on illustrating the number of accident in each zip code using Carto which is a Software that provides GIS, web mapping, and spatial data science tools.<\/p>\n\n\n\n<p>To add another layer of information, A Dataset on bicycle routes was obtained through <a href=\"https:\/\/data.cityofnewyork.us\/\">data.cityofnewyork.us\/<\/a>. The data contains the Geojson information that would create the bike routes found in the final results of this lab.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.37.29-PM-1024x566.png?resize=628%2C346&#038;ssl=1\" alt=\"\" class=\"wp-image-20949\" width=\"628\" height=\"346\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.37.29-PM.png?resize=1024%2C566&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.37.29-PM.png?resize=300%2C166&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.37.29-PM.png?resize=325%2C180&amp;ssl=1 325w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.37.29-PM.png?w=1430&amp;ssl=1 1430w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure><\/div>\n\n\n\n<p>The base layer in Carto contained a basic map of New York City, in order to illustrate the zip code and its boundaries the information had to be obtained using data.cityofnewyork.us\/. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM-1024x537.png?resize=582%2C305&#038;ssl=1\" alt=\"\" class=\"wp-image-20948\" width=\"582\" height=\"305\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?resize=1024%2C537&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?resize=768%2C403&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?resize=800%2C420&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?resize=343%2C180&amp;ssl=1 343w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.36.33-PM.png?w=1347&amp;ssl=1 1347w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Results<\/h2>\n\n\n\n<p>The result produced a map that contained nyc&#8217;s map divided by it zip code borders. Combining the three different datasets in Carto allows the creation of a interactive map that the viewers can click around and selecting a location to see the name of the borough, population and the zip code of the selected area. Carto also can create widget with informations from the csv. The widget displays information on the top contributing factor of accidents.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-cartodb\"><div class=\"wp-block-embed__wrapper\">\n<iframe width='100%' height='520px' frameborder='0' src='https:\/\/cruzjay188.carto.com\/viz\/cc54ecbe-058b-458b-8403-268e869a9477\/embed_map' allowfullscreen webkitallowfullscreen mozallowfullscreen oallowfullscreen msallowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"650\" src=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1-1024x792.png?resize=840%2C650&#038;ssl=1\" alt=\"\" class=\"wp-image-20957\" srcset=\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?resize=1024%2C792&amp;ssl=1 1024w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?resize=300%2C232&amp;ssl=1 300w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?resize=768%2C594&amp;ssl=1 768w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?resize=800%2C619&amp;ssl=1 800w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?resize=233%2C180&amp;ssl=1 233w, https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2020\/11\/Screen-Shot-2020-11-13-at-3.52.14-PM-1.png?w=1117&amp;ssl=1 1117w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>The areas in red indicate the zip code regions with higher than average accidents while the blue regions represent lower than average accidents.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Reflections<\/h2>\n\n\n\n<p>While examining the map I noticed that the regions with the highest number of accident usually occur near the entrances of the bridges. In a previous lab I created a heatmap that highlighted the hours in which accidents occur. Taking in these sets of information I would like to observe the flow of traffic near the entrances of the bridges during the hours of highest accident. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction New York City is experiencing an increase of accidents amongst cyclist every year and as a results the summer of 2020 reported the highest number of bicycle accidents. In a report created on September 2020, I created a graph detailing the number of accident each month from August 2017 to August 2020. The graph&hellip;<\/p>\n","protected":false},"author":728,"featured_media":0,"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":[341,1],"tags":[],"coauthors":[553],"class_list":["post-20937","post","type-post","status-publish","format-standard","hentry","category-maps","category-visualization"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-5rH","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/20937","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\/728"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=20937"}],"version-history":[{"count":20,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/20937\/revisions"}],"predecessor-version":[{"id":21041,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/20937\/revisions\/21041"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=20937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=20937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=20937"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=20937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}