Friday, August 7th, 2020 Open Data Journeys 001
Motor Vehicle Collisions and Safe Streets
Link to these slides: <https://docs.google.com/presentation/d/1v8TjSbsgJ6zlbUsH0uHsCYNlIOlsBYjJ2TrG5vxwCHs/edit?usp=sharing >
🌴
✈️
Let’s go on Open Data Journeys!
Explore open data and civic technology with BetaNYC on Fridays at 12:00pm. Open Data Journeys are virtual sessions that demonstrate how you can use publicly accessible datasets and tools to gain insight into your community.
In each journey, BetaNYC Civic Innovation Fellows and Apprentices will pose a topic question and take you on a step by-step investigation to answer it. You will gain insight into a process of accessing, cleaning and manipulating data, and become acquainted with a set of tools to conduct an analysis. At the end of each journey, we will hold a brief Q&A.
Email kate@beta.nyc if you have a topic or issue you want to do an exploration on.
Agenda
12:00pm Doors Open
12:05pm Welcome from NYC Council Member Kallos
12:10pm Introduction to the Open Data Journey
12:15pm Part I Gabby
12:25pm Part II Ameen
12:35pm Part III Onedeige
12:45pm Q&A
1:00pm End
Today’s Co-Hosts
Gabby Langston, Civic Innovation Apprentice
Ameen Alhubaishi, Civic Innovation Fellow
Onedeige James, Civic Innovation Apprentice
Kate Nicholson, BetaNYC
Council
Member
Ben Kallos
Council District 5
👋
“New Yorkers can use this data to make informed decisions, become more engaged in their communities, solve tough problems, or turn their dreams into a reality.”
NYC Open Data for All Report, 2015
Open Data Journey 001�Motor Vehicle Collisions & Safe Streets
Today we will explore trends in traffic collisions in NYC:
{DOT dataset name}�< link >
{NYPD dataset name}�< link >
{NYC 311 dataset name}�< link >
open datasets
Motor Vehicle Collisions & Safe Streets
Vision Zero Map�< http://www.nycvzv.info/ >
Crashmapper�< https://crashmapper.org/ >
BoardStat�< boardstat.beta.nyc >
tools
Motor Vehicle Collisions & Safe Streets
Part I. Use DOT’s Vision Zero Map to identify number of crashes
Part II. Use Crashmapper to view more details and compare
Part III: Use Boardstat to look at crash-related 311 complaints
methods
Motor Vehicle Collisions & Safe Streets
Part I
Using NYC Department of Transportation’s Vision Zero Map to identify a hot spot
Presented by:
Gabby Langston, BetaNYC Apprentice
Vision Zero View
< https://vzv.nyc/ >
Introduction to Vision Zero!
What is Vision Zero?
A policy first introduced in Sweden in 1990’s; made its way to NYC in 2014 to implement safer streets.
Mantra: traffic deaths and serious injuries are NOT inevitable, but preventable, through “engineering, enforcement and education.”
DOT designed an interactive Vision Zero map for the people in order to monitor progress.
Important Notes on Vision Zero
Fatality crash data is acquired by DOT fatality database, which the NYPD populates.
Injury crash data is accessed through FORMS, which the NYPD maintains.
Crashes on highways are EXCLUDED from the map.
Data from current year is from January 2020 to latest full month. Last updated June 30th.
Vision Zero in New York City: {https://www1.nyc.gov/content/visionzero/pages/ }
Vision Zero in US and World:
{https://visionzeronetwork.org/}
Vision Zero Map:
{https://vzv.nyc/}
Let’s look at the features of the vision zero map...
Orange dots represent injuries while red dots represent fatalities, as indicated by the legend to the left.
In the upper left corner, you can toggle between different filters.
There are 95 fatalities and 18,586 injuries as of 6/30/2020, this year.
At the bottom left, you can compare the amount of collisions by time of day.
Use these icons to zoom in or out of the map.
The arrows at the bottom of the screen allow you to navigate between years (2009-2020).
Filtering!
I want to narrow down my analysis to:
If we set the filter to monthly, we see that there were 29 fatalities and 3,485 injuries in June 2020
Let’s explore some hotspots...
Manhattan 2020 Hotspot
Scroll to an intersection you think may be dangerous near your home, school, place of work, and notice the volume of crashes, or lack thereof.
Record the intersection, and the number of injuries/fatalities…
Based on the Yearly filter, can we select a range of months from 2019? For example Jan - June 2019?
Reminder: data from year of interest is from January to latest full month.
Manhattan 2019 Hotspot
?
The citywide totals now illustrate % changes as well.
The % change comparisons are a mean between pre Vision Zero (2009-2013) and the current year on the map.
It is only available for full years( 2014-2019)
Does this intersection have fewer or more problems than I expected?
🤔
Final Thoughts
The Vision Zero map is not updated in real time. The DOT powers the tool with a private dataset received monthly from the NYPD, because they are required to process the source data.
Fear not! There are tools people have created for us to view the data in real time.
Part II
Using NYC Crashmapper for a more detailed analysis
Presented by:
Ameen Alhubaishi, BetaNYC Civic Innovation Fellow
NYC Crashmapper
NYC Crashmapper is a powerful tool!
Let’s look at the features...
Filter by Date Range
Crashmapper shows a map of fatalities (red), injuries (orange), and other collisions (yellow).
Legend
Filter by Boundary
Contributing Factors
Total
Crashes
and
Injuries
Crash Type
Total Fatalities
Vehicle Type
Access Data & Share
Let’s compare
Jan - Jun 2019 to 2020
January - June: 2019 Total Crashes: 21,759
January - June: 2020 Total Crashes: 14,151
Why do you think it’s different?
… COVID…. ?
Anything else?
Now I want to look at the same intersection that we looked at with NYC Vision Zero Map.
Location: Essex & Delancey
(Click the orange marker / hotspot.)
Total Crashes: 4
Total Injuries: 1
Total Fatalities: 0
Reflection… is that more or less than I expected?
How does the data compare between Vision Zero and Crash Mapper?
Are they the same or different?
Vision Zero Map
Location: Essex & Delancey
Date Range: Jan 2020 - June 2020
(Click the orange marker / hotspot.)
Total Crashes: Not Available
Total Injuries: 10
Total Fatalities: 0
NYC Crashmapper
Location: Essex & Delancey
Date Range: Jan 2020 - June 2020
(Click the orange marker / hotspot.)
Total Crashes: 4
Total Injuries: 1
Total Fatalities: 0
DIFFERENT
I wonder…
Is the community there concerned about this hotspot?
Maybe I can use 311 data...
Part III
Using BoardStat to look at crash-related 311 complaints
Presented by:
Onedeige James, BetaNYC Apprentice
Introduction to BoardStat!
About BoardStat
A simple 311 data analytics tool (dashboard) customized for each Community Board, created by BetaNYC Civic Innovation Lab.
Data is pulled directly from the NYC Open Data Portal.
Designed with Community Boards for Community Boards (also for the public, City Council, BPs, etc).
Partnered with Microsoft Civic to develop �the tool using Power BI.
Overview
BoardStat DEMO
< https://boardstat.beta.nyc/ >
Select your Borough
Select a Community Board
I chose Manhattan CB 3 because it is the location we looked at in Part I and II
Select Date Range Jan 1 - June 30, 2020
We are focusing on the same data range we used with the previous tools we looked at
Explore the Map
Navigate to page 4 (P4)
Select: Illegal Parking and Blocked Bike Lane
Note where the clusters of complaints are located.
Are there any�blocked bike lane complaints�at Delancey and Essex?
Zoom into the Intersection: Delancey and Essex Streets
The arrow shows the location we looked at on crashmapper and vision zero.
No blocked bike lane complaints found for this date range
Let us check other complaint types at this location
Explore All Complaint types on the Map
No complaint types were found at this location.
Let us Compare data tools at another location:
BoardStat and CrashMapper
What other complaint types can use to check against collision sites?
How does this year’s blocked bike lane complaints compare to 2019?
Comparing Complaints for 2019 and 2020
What do you think this means?
Points to Note!!
In review!
First, we used NYC DataViz Mapper to do a preliminary analysis of a location where there are a lot of collisions.
Then we dug deeper using NYC Crashmapper.
Finally, we used Boardstat to see if our collision hot spot reflected any hot spots in community 311 complaints.
Q&A
Raise your hand… unmute yourself...
or post your question in the chat
more resources...
RADAR - service we provide to support data literacy in NYC… show you what data can do with you...
Research and Data Assistance Requests
Reports
Maps / Story Maps
Letters to Agencies
Reports
Maps
Letters to Agencies