Twenty-three percent of the city's 2013 car-related fatalities occurred in just 5 percent of its neighborhoods.

The New York Police Department doesn't make it easy to crunch the city's traffic fatality and injury numbers, releasing the data in a PDF format that's difficult for developers to use. A group called betaNYC has been pushing the cops to make their data machine-readable, and new mayor Bill de Blasio's Vision Zero plan might help their case.

In the meantime, it's up to some hard-working data nerds to liberate the information locked inside the files. One civic-minded hacker named John Krauss has been scraping the data from the monthly PDF releases and making it available to anyone on the NYPD Crash Data Band-Aid. Krauss runs a site called NYC Crashmapper, where you can play around with a map that displays crashes by date, what type of user was involved, and severity of crash.

The numbers he's working with have some limitations – crashes are mapped to the nearest intersection by the NYPD, so it's unclear exactly where on a block they've taken place, for instance – but it's a start.

A few others have used Krauss's data for their own visualizations. One is Ben Wellington, a visiting assistant professor at Pratt Institute's Grad Center for Planning who teaches urban planning students about statistics by having them look at real open data about New York.

"I made the whole course around open data for people who are actually studying the city," says Wellington. "It's very applied. My goal is to take people that aren't very interested in statistics and make it interesting."

Wellington recently started a blog called I Quant NY, devoted to quantitative analysis of New York data, and he's gotten a huge response to the maps he's created with the Crash Data Band-Aid numbers. One map shows how certain neighborhoods, including Williamsburg, Brooklyn; Queens Boulevard; and the Grand Concourse in the Bronx, are hotspots for traffic fatalities. Wellington’s analysis shows that 23 percent of New York's 2013 traffic-related fatalities occurred in just 5 percent of its neighborhoods He also did a map that shows all 2013 bike crashes that resulted in injuries reported to the police, a 3,800-dot visualization that he, a regular bike commuter, calls "terrifying."

2013 bike crashes that resulted in injuries reported to the police.

Being the numbers guy that he is, though, Wellington doesn't draw hasty conclusions from the way the data looks. Factors such as density and traffic patterns all need to be accounted for. "You have to be careful about looking at a map with colors," he says. "I do my best. If I make a conclusion, I try to make it clear that it's a hypothesis." And he doesn’t necessarily want to get fixated in the most sensationalist aspect of the visualizations, those hot spots. Fully 60 percent of the city's 2013 traffic fatalities took place in neighborhoods with two or fewer deaths. And looking at "bright spots" where there are no deaths might yield other important insights about how to make New Yorkers safer on the street.

A heat map of 2013's traffic fatalities.

Wellington has been struck by the intensity of demand for a thoughtful treatment of this data in a city with a growing awareness of traffic safety as a public health issue. He also understands why the police might be wary about putting detailed information in the public realm, even if he thinks they should.

"Nobody likes being watched," he says. "It can be a little scary. They have a point, people can use data to tell any story they want." But as a statistician, he believes that opening up government data allows the most reasonable conclusions to rise to the top, ultimately benefiting the public.

He acknowledges the importance of the newly prominent emotion-based campaign to change the city’s traffic culture, which is being led by family members of victims. But emotion alone won’t be enough to get bureaucrats and elected officials to make life-saving changes, Wellington says.

"People have the feeling that the city is unjust in some ways, but feelings don't drive policy," he says. "Sometimes you need data. When people try to change policy, they use data."

About the Author

Most Popular

  1. Life

    What Happened When Tulsa Paid People to Work Remotely

    The first class of hand-picked remote workers moved to Tulsa, Oklahoma, in exchange for $10,000 and a built-in community. The city might just be luring them to stay.

  2. photo: a man with a smartphone in front of a rental apartment building in Boston.
    Equity

    Landlords Are Using Next-Generation Eviction Tech

    As tenant protections get stronger, corporate landlords use software to manage delinquent renters. But housing advocates see a tool for quicker evictions.

  3. animated illustration: cars, bikes, scooters and drones in motion.
    Transportation

    This City Was Sick of Tech Disruptors. So It Decided to Become One.

    To rein in traffic-snarling new mobility modes, L.A. needed digital savvy. Then came a privacy uproar, a murky cast of consultants, and a legal crusade by Uber.

  4. Photo: A protected bike lane along San Francisco's Market Street, which went car-free in January.
    Transportation

    Why Would a Bike Shop Fight a Bike Lane?

    A store owner is objecting to San Francisco’s plan to install a protected bike lane, because of parking worries. Should it matter that it’s a bike shop?

  5. Maps

    For Those Living in Public Housing, It’s a Long Way to Work

    A new Urban Institute study measures the spatial mismatch between where job seekers live and employment opportunities.

×