New York City Motor vehicle Collision Data Visualization

Every year more than 200,000 vehicle collisions occur in the five boroughs of New York City. The NYPD began publishing a data set of every recorded vehicle collision in the city in July of 2011. The aim of this project is to analyze the Traffic Collision dataset and present visually identifiable patterns that would enable city planners, traffic management, and commuters to make informed choices and reduce the risk of collisions.

The visualization below processes 1.23 million data points for traffic collisions in the city of New York every day from August 2012 to March 2020.

The data set used is from the city government's OpenData Website, Where a lot of useful data sets archived by city government are provided.

Questions

Looking at such a huge data set, some interesting questions come into mind they are:

• How is the Data look like on a map?
• Can we find which particular region is at high risk?
• What their collision history data look like.
• What is the trend of the total number of collisions from year to year? What can we predict for 2020? 

Objective

1. Develop an interactive map tool to easily check and explore collision case info on a real city map.
2. Conduct some preliminary exploratory data analysis to get overview results on interesting questions.

Interactive Map Tool

To help easily visualize and explore the spatial details of the collision data, a comprehensive and flexible interactive map tool is developed using the Streamlit package of Python.

How many collisions occur during a given time of day?

Vehicle collisions between 0:00 and 1:00

Breakdown by minute between 0:00 and 1:00

Top 5 dangerous streets 

Finally, That data and analysis help to reduce vehicle collision in features.

Thank you! 🙂