{"id":5482,"date":"2015-01-27T07:00:12","date_gmt":"2015-01-27T14:00:12","guid":{"rendered":"http:\/\/spacing.ca\/edmonton\/?p=5482"},"modified":"2015-01-23T12:32:51","modified_gmt":"2015-01-23T19:32:51","slug":"bike-collisions-edmonton","status":"publish","type":"post","link":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/","title":{"rendered":"Bike Collisions in Edmonton"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

On November 26, 2014, the Edmonton Bike Coalition\u00a0presented\u00a0to Edmonton’s City Council in support of\u00a0the creation\u00a0of a core network of bike lanes. To understand more about where the bike lanes should go, I asked the City’s Transportation Department if they had a comprehensive list of bike collisions. They forwarded me a data set with over 1000 bike related collisions from 2009 – 2014. The complete and original data set can be found here<\/a>, on Google Drive. I\u00a0encourage you to download it\u00a0<\/strong>and have a look.<\/p>\n

Preliminary Analysis<\/strong><\/p>\n

When I looked\u00a0at the spreadsheet, I could see that there were eight\u00a0fatalities and 1096 injuries during the\u00a0almost 6 year period. To\u00a0further the\u00a0analysis, I geocoded the data using Cartographica<\/a>, and put this\u00a0data on\u00a0a map of Edmonton that included the core bike path network under discussion (See bike-car collisions figure).<\/p>\n

There are some problems with this map. The data provided by the City described the bike collisions by the nearest cross street, which means that the data is displayed on the map as a rough grid, and\u00a0if two or more accidents occur on the same block they are spatially identical to the\u00a0geocoder. As such, collision locations on the same block are overlaid on the map, but may not have actually occurred at the same point as any other collision in any other year. \u00a0All we can conclude by the overlaid points is that those collisions occurred somewhere<\/em> on that block.<\/p>\n

Looking at the map of downtown, it seems that we can predict where bike accidents will occur. For instance,\u00a0<\/strong>there are clusters of accidents on the same block on 100th Avenue,\u00a0109th Street, 106th Street and\u00a0104th Street.<\/p>\n

The\u00a0Whyte Avenue map, on the other hand, indicates that a bike lane on 83rd Ave might not prevent accidents. Since 2009, there have been no\u00a0bike collisions on 83rd Avenue. Rather, from this\u00a0analysis, it seems\u00a0that a north\/south bike lane on\u00a0Gateway Boulevard\u00a0<\/strong>and Calgary Trail would be of greater benefit.<\/p>\n

On the other hand, Tyler Golly who is the General Supervisor, Sustainable Transportation at the City of Edmonton notes that:<\/p>\n

“…the purpose of the (83rd Avenue) route is to have a high quality east-west cycling route to serve the many destinations along Whyte Ave, to get people to\/from the University and to\/from existing north-south routes like Mill Creek Ravine….we know people will ride one or two blocks out of their way if a good bike route exists. So, for 83rd Avenue, we really need to consider Whyte Ave (82 Ave) and even 81 and\/or 84 Ave because a route along these corridors will attract riders that are currently using other routes. So, the 83 Ave route doesn’t exist because of collision history along 83 Ave but rather to provide a safe route because the data shows numerous collisions along 82 Avenue.”<\/p><\/blockquote>\n

Conclusions\u00a0<\/strong><\/p>\n

These are my initial conclusions, however there are problems with my analysis. The geocoder that I used did not include all of the data points from the original file on the final map, and I don’t have the skill to find those\u00a0points not included (other than a laborious manual search).<\/p>\n

While the analysis is somewhat suspect, it does raise the following\u00a0interesting questions that might be addressed with better geocoding and data validation (and with more people looking at the\u00a0data):<\/p>\n

    \n
  1. Would the clusters of downtown bike accidents be avoided with the proposed bike network?<\/li>\n
  2. Do we need a bike lane on 83rd Avenue, or would our money be better spent putting bike lanes on Gateway Boulevard and Calgary Trail?<\/li>\n
  3. Is there a seasonality to the accidents?<\/li>\n
  4. Does age or gender of the cyclist play a role in the likelihood of bike accidents?<\/li>\n
  5. How often, and in what ways, do motor vehicles play a role in bike accidents?<\/li>\n<\/ol>\n

    This process of obtaining and mapping the data has also raised some transparency issues, given the City of Edmonton’s commitment to open data. Specifically\u00a0why does the Edmonton Police Service (EPS) not capture and report\u00a0accident data with a GPS and coordinates.\u00a0Furthermore, why does the City of Edmonton ‘Mid-Block Collisions<\/a>‘ open data set only document a small fraction of these collisions? For instance, the 2010-2011 dataset that I linked to has only 16 incidents, while the\u00a0data released by the Transportation Branch has 323 incidents for the same time period.<\/p>\n

    It is imperative that the City of Edmonton release full (rather then partial) data sets. Data sets that are discovered to be partial erode the City’s credibility within the open data community and subtly call into question all other data sets (Are they complete? Has the data been manipulated?). If the City of Edmonton and its citizens are to fully realize a partnership in the creation of public policy, then we should all be working with the same data.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction On November 26, 2014, the Edmonton Bike Coalition\u00a0presented\u00a0to Edmonton’s City Council in support of\u00a0the creation\u00a0of a core network of bike lanes. To understand more about where the bike lanes should go, I asked the City’s Transportation Department if they had a comprehensive list of bike collisions. They forwarded me a data set with overContinue reading “Bike Collisions in Edmonton”<\/span><\/a><\/p>\n","protected":false},"author":8228,"featured_media":5499,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ngg_post_thumbnail":0,"_ef_editorial_meta_paragraph_assignment":"","_ef_editorial_meta_date_first-draft-date":"","_ef_editorial_meta_checkbox_needs-photo":"","_ef_editorial_meta_number_word-count":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-5482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bikes"],"acf":[],"yoast_head":"\nBike Collisions in Edmonton - Spacing Edmonton<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matthew Dance\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/\",\"url\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/\",\"name\":\"Bike Collisions in Edmonton - Spacing Edmonton\",\"isPartOf\":{\"@id\":\"https:\/\/spacing.ca\/edmonton\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png\",\"datePublished\":\"2015-01-27T14:00:12+00:00\",\"author\":{\"@id\":\"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/c8a34dce18d8766ed79ae7e68a603c63\"},\"breadcrumb\":{\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage\",\"url\":\"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png\",\"contentUrl\":\"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png\",\"width\":924,\"height\":857,\"caption\":\"Bike-car collisions in Edmonton\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/spacing.ca\/edmonton\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bike Collisions in Edmonton\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/#website\",\"url\":\"https:\/\/spacing.ca\/edmonton\/\",\"name\":\"Spacing Edmonton\",\"description\":\"Canadian Urbanism Uncovered | Edmonton Architecture, Urban Design, Public Transit, City Hall, Parks, Walking, Bikes, Streetscape, History, Waterfront, Maps, Public Spaces\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/spacing.ca\/edmonton\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/c8a34dce18d8766ed79ae7e68a603c63\",\"name\":\"Matthew Dance\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecaca69093a4dd69a221882a39d299d0?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecaca69093a4dd69a221882a39d299d0?s=96&d=blank&r=g\",\"caption\":\"Matthew Dance\"},\"sameAs\":[\"https:\/\/x.com\/@mattdance\"],\"url\":\"https:\/\/spacing.ca\/edmonton\/author\/mattdance\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bike Collisions in Edmonton - Spacing Edmonton","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/","twitter_misc":{"Written by":"Matthew Dance","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/","url":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/","name":"Bike Collisions in Edmonton - Spacing Edmonton","isPartOf":{"@id":"https:\/\/spacing.ca\/edmonton\/#website"},"primaryImageOfPage":{"@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage"},"image":{"@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage"},"thumbnailUrl":"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png","datePublished":"2015-01-27T14:00:12+00:00","author":{"@id":"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/c8a34dce18d8766ed79ae7e68a603c63"},"breadcrumb":{"@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#primaryimage","url":"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png","contentUrl":"https:\/\/spacing.ca\/edmonton\/wp-content\/uploads\/sites\/9\/2014\/11\/ScreenShot_2014-11-27_14-08-34.png","width":924,"height":857,"caption":"Bike-car collisions in Edmonton"},{"@type":"BreadcrumbList","@id":"https:\/\/spacing.ca\/edmonton\/2015\/01\/27\/bike-collisions-edmonton\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/spacing.ca\/edmonton\/"},{"@type":"ListItem","position":2,"name":"Bike Collisions in Edmonton"}]},{"@type":"WebSite","@id":"https:\/\/spacing.ca\/edmonton\/#website","url":"https:\/\/spacing.ca\/edmonton\/","name":"Spacing Edmonton","description":"Canadian Urbanism Uncovered | Edmonton Architecture, Urban Design, Public Transit, City Hall, Parks, Walking, Bikes, Streetscape, History, Waterfront, Maps, Public Spaces","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/spacing.ca\/edmonton\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/c8a34dce18d8766ed79ae7e68a603c63","name":"Matthew Dance","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/spacing.ca\/edmonton\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecaca69093a4dd69a221882a39d299d0?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecaca69093a4dd69a221882a39d299d0?s=96&d=blank&r=g","caption":"Matthew Dance"},"sameAs":["https:\/\/x.com\/@mattdance"],"url":"https:\/\/spacing.ca\/edmonton\/author\/mattdance\/"}]}},"_links":{"self":[{"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/posts\/5482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/users\/8228"}],"replies":[{"embeddable":true,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/comments?post=5482"}],"version-history":[{"count":19,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/posts\/5482\/revisions"}],"predecessor-version":[{"id":5774,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/posts\/5482\/revisions\/5774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/media\/5499"}],"wp:attachment":[{"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/media?parent=5482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/categories?post=5482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spacing.ca\/edmonton\/wp-json\/wp\/v2\/tags?post=5482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}