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

NYPD’s Lax Crash Investigations May Violate State Law

|
Unacceptable. Absurd. “Next to useless.” Those were just a few terms employed by City Council members today describing the NYPD approach to traffic enforcement. During a four-hour hearing, so packed with spectators and media that some were pointed to an overflow room to listen to testimony, council members grilled department brass on traffic crime prevention […]

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 […]

After NYPD Kills Bill, Council Pushes for Traffic Safety Data From DOT

|
The City Council Transportation Committee held a hearing yesterday on four bills that would release new information about traffic crashes and how the Department of Transportation decides whether to install traffic calming measures and traffic control devices like stop lights and stop signs. All together, the bills would cover a wide spectrum of information, but […]