Civic News

A Code for DC project just automated a source for unreported car crash data. Here’s how technologists did it

Project lead Charlotte Jackson and OpenMHz creator Luke Berndt break down how open data fueled the Crash Bot project. The new database pulls information from multiple open data sources to create accurate, real-time updates on car crashes in the District involving bikers and pedestrians.

A view of the DC Crash Bot data. (Courtesy photo)

The new tech tools continue to launch for pedestrians and cyclists in the DMV looking for safer streets: Developers behind Code for DC‘s Crash Bot project just automated a system for car crash data.

Project creator and Women Who Code director Charlotte Lee Jackson tweeted earlier this week that the project, which collects car crash data and compares it to DC Department of Transportation (DDOT) reports, completed a crucial step. It now automatically collects and refreshes data from multiple sources, and places it in an easy-to-read dashboard that compares whether or not it showed up in DDOT data.

The database starts by pulling from an app called Pulse Point, which shows what incidents fire and emergency services responded to. The problem there, Johnson said, is that the app doesn’t show what kind of traffic collision occurred. So it then turns to a site called OpenMHz, created by Luke Berndt, which collects crash report audio and converts it in .WAV files. This distinguishes which accidents involved pedestrians or cyclists. The Crash Bot code runs the audio files through AWS Transcribe. On top of that, it pulls information from a few Twitter accounts that report local crashes and sources data from the Citizen app to track down as many incidents as possible, and compare what’s been recorded across multiple sources.

Johnson noted that open data sources were a crucial part of the project coming together.

“It’s not like I’m scraping encrypted data from a secret source or anything,” Johnson said. “It’s all here.”

Berndt’s OpenMHz in particular was a key point in getting the data together, since it had the audio files for all calls made. Berndt, who is based in DC, built the system using a software defined radio, which he said works like a police or fire scanner but can tune into more than one channel, so it can hear what dispatchers are saying to each other. He uses an RTL-SDR device to find radio and an open source program called GNU Radio to build a “software version of any radio receiver out there.” Some C++ code pulls the whole thing together, he added, to provide the .WAV files.

Ideally, DDOT will start using this data when they are making these infrastructure and policy decisions about what changes to make to our streets.

“I put it out there and then I started with just what I was capturing in DC, but the software is open source and people have just started using it and contributing from around the country,” Berndt said.

OpenMHz mostly gets used by media outlets, Berndt said, but it has expanded nationwide. Firefighters use it for trainings, and regular citizens look into what’s going on in their neighborhood.

“[OpenMHz] started off with personal curiosity and I think it’s sort of grown into—there’s lots of people who just want to be more aware of what’s happening in their community and what’s around them, and figuring out what’s happening,” he said.

For Jackson, that meant compiling crash data for more accurate policy decisions. Good Hope Road SE, she said, is an example of a problem point that often gets missed by DDOT data. The Crash Bot project showed that DDOT reported three crashes in the area in the last six weeks, when there were at least five found via the project. She hopes that such firm examples can help with residents submitting traffic safety requests to show urgency, or that DDOT will use the project data itself.

“Ideally, DDOT will start using this data when they are making these infrastructure and policy decisions about what changes to make to our streets. Because it’s very different rates of unreported crashes by ward,” Jackson said. “And the data that DDOT is using right now for East of the [Anacostia] river…you can see exactly how incomplete it is.”

Berndt added that uses like the Code for DC project are an important aspect of OpenMHz that he would hate to lose if he made the site fully encrypted.

“Having that data and information be accessible, and not just as a boring record, but also the actual calls and sort of emotion and context around the things, is really important for just really telling the civic story around what cities and the people who work in them actually are doing on the day-to-day,” Berndt said.

View the Crash Bot project
Companies: Civic Tech DC

Before you go...

Please consider supporting Technical.ly to keep our independent journalism strong. Unlike most business-focused media outlets, we don’t have a paywall. Instead, we count on your personal and organizational support.

3 ways to support our work:
  • Contribute to the Journalism Fund. Charitable giving ensures our information remains free and accessible for residents to discover workforce programs and entrepreneurship pathways. This includes philanthropic grants and individual tax-deductible donations from readers like you.
  • Use our Preferred Partners. Our directory of vetted providers offers high-quality recommendations for services our readers need, and each referral supports our journalism.
  • Use our services. If you need entrepreneurs and tech leaders to buy your services, are seeking technologists to hire or want more professionals to know about your ecosystem, Technical.ly has the biggest and most engaged audience in the mid-Atlantic. We help companies tell their stories and answer big questions to meet and serve our community.
The journalism fund Preferred partners Our services
Engagement

Join our growing Slack community

Join 5,000 tech professionals and entrepreneurs in our community Slack today!

Trending

19 tech and entrepreneurship events to check out before the holidays

EDA officials are ‘hopeful’ Tech Hubs program will live on under Trump

DC’s year in tech: An interactive timeline for 2024

AI is being used in more and more of the hiring process, especially at high-volume companies

Technically Media