NYC Open Data Law Will Sort Out NYPD’s Jumbled Traffic Crash Data

Traffic crash data as the NYPD currently provides it is not mappable, sortable, or even easily searchable.

When the City Council passed Jessica Lappin’s Saving Lives Through Better Information bill last year, traffic safety and open government advocates cheered. Under the law, the NYPD is required to provide monthly data on both traffic crashes and traffic summonsing, shedding light on the hazards of city streets and what steps police take to protect New Yorkers from dangerous drivers.

The information the NYPD finally provided under that law turned out to be informative — showing, for example, that the police hand out more than twice as many tickets for seat belt violations than for speeding — but formatted in a clunky way almost guaranteed to stymie people looking to analyze the data systematically. The data is released as PDF files: not mappable, not sortable, and not even easy to search.

New Yorkers may finally be getting access to the high-quality traffic data they are entitled to, however, thanks to a wide-ranging open data law passed by the City Council. In general, any data that could be obtained under a Freedom of Information Law request would be proactively released under the new policy, according to the Gotham Gazette.

In announcing the passage of the open data law, City Council Speaker Christine Quinn specifically highlighted the need for better traffic data. “While we can currently get this data, it is not in an open format,” Quinn said in a press release. “It cannot be sorted by community board, by frequency of accidents or by contributing factor. Being able to analyze this information will help us to better target safety efforts, utilize resources and save lives.”

At the press conference announcing the bill’s passage, Quinn specifically cited her inability to see where crashes had taken place on Ninth Avenue in her district using the NYPD’s current data.

  • Anonymous

    In the interim, I’m keeping a parallel database of traffic crash data CSVs (including archives) available here:

    http://nypd.openscrape.com/

    Enjoy!

ALSO ON STREETSBLOG

CrashStat Upgrade Provides Interactive, Up-To-Date Street Safety Data

|
Transportation Alternatives launched an updated version of its CrashStat website today, providing a wealth of new data about street safety in New York City and where pedestrians and cyclists are most at risk. The upgrade adds four years of geo-coded data about traffic injuries and fatalities, a smoother interface, and a wealth of interactive features. […]

NYPD Goes Out of Its Way to Obscure Street Safety Data

|
It took several months and some needling from the Daily News, but NYPD this week finally complied with a new city law requiring the department to release data on traffic crashes. Unless you have the time and resources to comb through and analyze hundreds of pages of rows and columns, however, good luck getting much […]

City Council Bills to Release Traffic Data Pass Committee Unanimously

|
Three bills to open up information about traffic and street safety to the public cleared the City Council’s transportation committee unanimously today. According to committee chair James Vacca, the bills are scheduled for a floor vote this Wednesday. Two of the bills, in particular, should provide New Yorkers with a much clearer picture of what’s […]