Road Casualty Data Case study

Road Casualty Data Case study

Contract Road Casualty Data Processing & Analysis
Service Accident Data Analysis for HGV and Pedestrian Incidents
Scale 2297 Records from the past 5 years
Project Location: A Borough of London
London road casualty data analysis

The analysis and presentation of information collected by members of the emergency services after a road traffic accident can provide important information to transport modellers and other key stakeholders in local councils as well as the general public. The data contains information on the nature of the incident including the classification of those involved, the location and the manner in which the accident occurred. In order to present this data it requires cleaning, classifying and presenting.

One of the largest boroughs of London needed to present their historical accident data to key stakeholders including the general public in an accessible and professional manner. In total there were 23,450 individual incident records to be sorted, analysed and presented of which 2,297 fell within the relevant criteria. Our client did not have the resources or the in-house skills and experience to produce the reports effectively and efficiently.

The raw data for the accidents was stored in spreadsheets provided by the police and other emergency services to the council. The data held within these sheets requires a significant amount of work to produce a presentable output. Tracsis Traffic and Data Services employ a team of data analysts who  have specific experience in the traffic and transport sector.

For the processing of accident data we have developed a system that firstly extracts the relevant records from the mass of raw data and then meticulously classifies and checks each record. 3 analysts work on each record and where a consensus is not reached a supervisor oversees a decision on the classification of that record. During the classification process the geographical location of the incident is verified against the description of what occurred and any anomalies are flagged for further investigation.

Once the data has been verified and classified the incidents are plotted using our Geographic Information System (GIS) capabilities.

GIS mapping road traffic collisions

GIS plotting of casualty data

The GIS plotting allows for a visual representation of the data which can ease the process of identifying historical black spots whilst also making the data more accessible. These maps of the area are presented alongside the headline statistics gained from the data.

 

 

road traffic accident data analysis

Road traffic accident data analysis

The GIS plotting allows for a visual representation of the data which can ease the process of identifying historical black spots whilst also making the data more accessible. These maps of the area are presented alongside the headline statistics gained from the data.

The processing of these 2,297 records was the second batch of work the Traffic and Data Services Division of Tracsis (as Sky High Technology at the time of the project) have completed for this Borough Council. The processes and systems developed allow us to replicate the work for other councils allowing us to aid in the clearing of any back-logs of data. The data analysis can be produced for any transport environment both urban and rural and any road user from HGV, cars or non-motorised users such as pedestrian and cyclists.

This is just one project from case studies in transport surveys and data capture sector carried out by leading international provider Traffic and Data Services.

Tracsis Traffic and Data Services data storage and processing security

Tracsis' Secure Data Centre

Tracsis’ Secure Data Centre

Customer data is stored within our secure data centre providing fast information for key personnel who have security clearance. To optimise our Data Security, we have a hybrid mix of physical and virtual servers. They are monitored 24 hours per day.

The Tracsis Traffic and Data Services network is protected by a Cisco ASA firewall in the Data centre of our ISP on an MPLS network. All machines are protected with F-Secure anti-virus software, and every email is scanned before reaching our mail servers for viruses and spam content by Websense Cloud Security.