Thursday 24 November 2016

Horse Riders killed or injured 2005-2015 | Map


For a larger version of the map, click here.


STATS19 mapping implementation notes


These maps are based on the data from 2005-2015 inclusive (11 years of data), which has been edited down to make the file sizes more manageable. If you want the full details on specific a specific incident or want to search by area I recommend using www.cyclestreets.net/collisions/.

The data for "Journey_Purpose_of_Driver", "Vehicle_Type", "Make" and "Model" refers to the other vehicle involved where that has been possible to match*. For pedestrians, the data records which vehicle (first) hit them. For other road users we inferred a collision where there was just one other vehicle involved. When there were more vehicles it was not possible to infer which vehicles collided with which.

*Bicycles, horses and mobility scooters are all counted as vehicles.

For a few of the entries we have found errors in the data, such as missing location data which may means they have not been mapped. Examples of this are accident references 2005600GN6024 and 200504BB05106.

Care has been taken to avoid errors or emissions while creating these maps, however if you spot an issue please let us know.

Alternative map of KSIs involving Heavy Goods Vehicles

In my previous post I presented a map created using Google Fusion Tables. This post shows an alternative map produced using the same data fed in to Google Maps. Due to limits on the file size, the collisions resulting in minor injuries have been omitted.

Vulnerable road users killed or seriously injured in collisions involving HGVS for the years 2005-2015




For a larger version of the map, click here.

'Vulnerable Road Users' refers to pedestrians, cyclists, motorcyclists, horse riders & mobility scooter riders. Due to the number of dangerous goods vehicles classed as 'Other', that category has been included and the maps will also include some collisions involving different vehicles in the 'Other' category.


STATS19 mapping implementation notes


These maps are based on the data from 2005-2015 inclusive (11 years of data), which has been edited down to make the file sizes more manageable. If you want the full details on specific a specific incident or want to search by area I recommend using www.cyclestreets.net/collisions/.

The data for "Journey_Purpose_of_Driver", "Vehicle_Type", "Make" and "Model" refers to the other vehicle involved where that has been possible to match*. For pedestrians, the data records which vehicle (first) hit them. For other road users we inferred a collision where there was just one other vehicle involved. When there were more vehicles it was not possible to infer which vehicles collided with which.

*Bicycles, horses and mobility scooters are all counted as vehicles.

For a few of the entries we have found errors in the data, such as missing location data which may means they have not been mapped. Examples of this are accident references 2005600GN6024 and 200504BB05106.

Care has been taken to avoid errors or emissions while creating these maps, however if you spot an issue please let us know.

Wednesday 23 November 2016

Mapping KSIs involving Lorries

Lorries and other large vehicles are a serious danger to vulnerable road users.

Using the STATS19 data I've produced maps showing collisions involving these vehicles where pedestrians, cyclists, motorcyclists, horse riders or mobility scooter riders were killed or injured. Due to the number of dangerous goods vehicles classed as 'Other' (details here) the maps will also include some collisions involving different vehicles in the 'Other' category.

Deaths & Injuries involving HGVs, 2005-2015




Key: 
Fatality = Symbol
Serious Injuries = Yellow dot
Minor Injuries = Blue dot

This is a map I produced showing where vulnerable road users have been killed or injured 2005-2015. Click here for full size version, produced using Google Fusion tables.

Other mapping:


In addition to this, I have tried presenting the data using Google 'Maps' rather than 'Fusion Tables'. This has several advantages however it limits each layer to 2000 data points, which poses challenges when dealing with data for the whole of the UK (except Norther Ireland). Due to this limitation it is necessary to filter the data down, reducing the years, casualty types or casualty severities shown.

Click here for a map showing where pedestrians, cyclists and motorcyclists have been killed or injured in collisions involving Heavy Goods Vehicles for the years 2012-2015. This is a subset of the data shown in the map above.

STATS19 mapping implementation notes


These maps are based on the data from 2005-2015 inclusive (11 years of data), which has been edited down to make the file sizes more manageable. If you want the full details on specific a specific incident or want to search by area I recommend using www.cyclestreets.net/collisions/.

The data for "Journey_Purpose_of_Driver", "Vehicle_Type", "Make" and "Model" refers to the other vehicle involved where that has been possible to match*. For pedestrians, the data records which vehicle (first) hit them. For other road users we inferred a collision where there was just one other vehicle involved. When there were more vehicles it was not possible to infer which vehicles collided with which.

*Bicycles, horses and mobility scooters are all counted as vehicles. 

For a few of the entries we have found errors in the data, such as missing location data which may means they have not been mapped. Examples of this are accident references 2005600GN6024 and 200504BB05106.

Care has been taken to avoid errors or emissions while creating these maps, however if you spot an issue please let us know.




Tuesday 22 November 2016

Croud-sourcing information for collision maps

The police STATS19 reports contain few details about victims and the circumstances of collisions. Linking these to press reports, blog posts & local campaigns can give more information on the people involved, the incident, the investigations and any court cases.

Finding, linking and mapping press reports about all road fatalities in the UK would be a huge task to undertake. Therefore I wanted to look at ways of allowing members of the public to submit reports online in a way which could be easily mapped and linked to other data.

I've created the form below as a prototype - please try it out and let me know what you think.



The main challenge was getting the location data. Ideally the user would be able to click on a map and have the location recorded. I wasn't able to do that, so the user has to copy the latitude and longitude in to the form - OK on desktop, but really not phone/tablet friendly.

Output


The form populates this table (email addresses removed):


This probably needs a disclaimer 'This data includes links and information submitted by the community, please contact us if you believe any of the information is inaccurate or inappropriate'.

Using the data


  • This data could be mapped to provide real time logging of incidents.
  • Once the STATS19 collision reports are published it would be possible to link the data sets. These could be matched with a good degree of accuracy using the date and a search radius, however this might still need a final check by a human. 
  • Similarly, this could be used to link historic reports to the STATS19 data to improve our understanding of the accident history of locations.
  • This form (or similar) could be used by people currently recording collision reports to put the data in a consistent format which would allow it to more easily mapped in future.
Mapping of collision reports is already being undertaken by a few people (here for instance) and if efforts were to be put in to this it would be good to coordinate to avoid duplicating efforts and ensure data could be transferred across if needed.