addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: NYPD releases Motor Vehicle Collisions data

From: Richard R.
Sent on: Friday, May 9, 2014 5:22 PM
That's fabulous Akil. I had a feeling someone might have been working on something like this already.

I'm just joining the CB so I'm not an expert about what kinds of information would be most useful but I'm envisioning some kind of dashboard that shows aggregated data for the previous month (and trending to see historical data).

I made up a super simple dashboard (with fake data) here that could potentially be helpful.

Let me know what you think. If you want to email offline, I'm at [address removed].


From:akil harris
Sent on: Friday, May 9,[masked]:22 PM
I actually just started working on something like this the other night.

There's a really early version here

Right now it's just showing the last 10 accidents mapped, the last 10 accidents that caused a death and the last 10 that caused an injury, plus some simple totals. 

Somethings aren't fully working like you can click on a map marker and see a stand in popup but you cant yet click on the accident list and see a popup though I hope to get that working this weekend. 

There's lots more I want to do with it though, like filtering by by areas (precincts, zips, districts), more aggregate data (how many cyclist deaths, how many unspecified factors, most dangerous intersection, most deadly day of the year etc etc)

It's coded right now to refresh it's data from the socrata portal when that updates automatically and down the line id like to get it to notify based on some kind of basic rules like "new accident where someone died" or "new accident where a cyclist was injured." 

Give it a quick look and let me know the kind of stuff you might want to see in a tool like this and ill try to get the stuff people are asking for done as a priority.


On Fri, May 9, 2014 at 11:05 AM, Richard Robbins <[address removed]> wrote:
This is awesome.

I just joined Manhattan's CB7 and am hoping to get appointed to the transportation committee. One thing I would LOVE would be to have a simple dashboard for the community board (and NYPD / DOT) to use to show what's happening on the streets in terms of crashes (by cause, time of day, location, whether they're caused by car, bike, etc.). 

This could help inform where the CB should be focusing its efforts, whether NYPD is putting its resources behind the biggest causes of fatalities, injuries, crashes (such as ticketing for speeding, red lights, failure to yield, bikes, jaywalking) and whether DOT is looking at the right intersections and exploring other levers that could make the streets safer.

As a non-developer, non-designer, I would be ecstatic if anyone wanted to volunteer to create such a dashboard. Ideally it would eventually have citywide data that could be filtered by borough and CB so that any CB in NYC would be able to pull up its data, and it would have all kinds of bells and whistles like maps, etc. But even something really basic would be fabulous to show the members of the transportation committee what is possible and to help the CB use data to make better decisions. And for timing, the next monthly CB7 transportation committee meeting is this Tuesday night....

Anyone have any interest?



People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy