Mark Headd

This is what happens when a city releases its data.

Back in December, the city of Philadelphia published its first really major municipal dataset, a record of all “Part I” crimes in the city (these are the really bad ones: homicides, rapes, robberies, aggravated assaults and thefts) dating back to Jan. 1, 2006. Each incident is tagged to a location in the city, making it possible to map assaults across the years, or vehicle thefts near your home address within the last 30 days.

Not surprisingly, in the short time since the city released this trove, a number of developers have already repackaged it. Nearly every week, says Mark Headd, Philadelphia’s chief data officer, the city has stumbled across some new application of the material created by local residents. “It’s really interesting when you put valuable data out there, data that resonates with people – and this clearly does, and we make it really, really easy to use," Headd says. "It’s amazing what pops up."

The city itself initially mapped the data here:

Phila.gov

But the really impressive applications are coming from outside of City Hall. This is the PHL Crime Mapper, created by software developer David Walk. His tool enables users to draw a polygon around any area in the city. PHL Crime Mapper then maps crimes within that territory during a given time span (and spits out some relevant statistics):

PHL Crime Mapper

This one is the Philly Crime Map, created by Andrew McGill. Here we’re looking at recent aggravated assaults within one corner of the city:

Philly Crime Map

Detailed information on the suspect arrested in any given crime then links to another project of McGill’s, the Philly Rap Sheet, which scans the city’s court systems every half hour for data on the arresting officer, assigned judge, charges and bail for each crime. Here is the corresponding Rap Sheet page for the above assault:

This tool, from AXIS Philly, allows you to sort data at the neighborhood level, comparing trends across time in both violent and property crimes:

AXIS Philly

Headd also created a visualization of his own, an animation of homicides across the city since 2006 (below is just a static screen grab, but you should click here for the full effect of the time series):

All of these tools have taught the city, Headd says, that municipal data is most valuable when people can parse it down to the level of their own communities. “In a city like Philadelphia, the story on crime can be starkly different neighborhood to neighborhood,” Headd says. “People want to be able to ask their own questions, or present their own take on this data.”

And that lesson, he adds, will likely inform how the city rolls out its next big datasets (look next for some financial and budget data). When a city releases data like this, an interesting thing also happens beyond its borders. That homicide time series Headd recently built on an open platform? It’s already been copied in Oakland. Here’s a video, from Steve Spiker, illustrating 18 years of homicides in two minutes:

About the Author

Most Popular

  1. Transportation

    Why New York City Stopped Building Subways

    Nearly 80 years ago, a construction standstill derailed the subway’s progress, leading to its present crisis. This is the story, decade by decade.

  2. Life

    Why Are Newspaper Websites So Horrible?

    The pop-up ads! The autoplaying videos!

  3. A sign warns non-resident drivers to avoid using a street in Leonia, New Jersey.
    Transportation

    What Happens When a City Bans Non-Resident Drivers?

    Besieged by commuters taking Waze-powered shortcuts, Leonia, New Jersey, closed its side streets to non-residents. Not everyone is happy with the results.

  4. Equity

    How New York Is Building an Entire Neighborhood on Top of a Rail Yard

    Hudson Yards, a 26-acre space with 17 million square feet of buildings, will be suspended over 30 active train tracks.

  5. Transportation

    How to Pedestrianize a Vital Urban Street

    London’s plans for Oxford Street show that even the busiest roads can ban vehicles—but there's one major misstep.