Frank,

Your point about different precincts doing a better job than others collecting data on contributing factors got me thinking. I wanted to see if I could create a simple chart totaling the number of accidents where contributing factors were collected by precinct for Brooklyn.

I think I'm doing this right, but if anyone sees anything funny let me know. Quick chart showing totals by precinct for Brooklyn where contributing factors were recorded is here:

http://mheadd.github.io/nypd-accident-data/

Also, this little experiment gave me a chance to play with a new chart library I just came across. I must say, its pretty nice - very easy to use. Highly recommended for those interested.

Cheers,

On Thu, May 8, 2014 at 12:50 AM, fkh <[address removed]> wrote:

Andrew, your contributing factors map is an interesting look at how the different precincts are recording data -- the 94th in Greenpoint are doing a much more thorough job compared to others in Brooklyn, shown by the diversity of dot colors. Vs other places who appear to default to "unspecified" for most crashes.

On Wed, May 7, 2014 at 5:56 PM, Andrew W. Hill <[address removed]> wrote:

Very interesting. Not to be too predictable, but here are a couple of maps

https://nyc.cartodb.com/

http://nyc.cartodb.com/viz/d78d3f88-d630-11e3-b32f-0e73339ffa50/embed_map?title=true&description=true&search=false&shareable=true&cartodb_logo=true&layer_selector=false&legends=true&scrollwheel=true&fullscreen=true&sublayer_options=1&sql=&sw_lat=40.60561205826015&sw_lon=-74.19822692871094&ne_lat=40.80965166748851&ne_lon=-73.75534057617188

http://nyc.cartodb.com/viz/ff10409a-d631-11e3-a9e6-0e10bcd91c2b/embed_map?title=true&description=true&search=false&shareable=true&cartodb_logo=true&layer_selector=false&legends=true&scrollwheel=true&fullscreen=true&sublayer_options=1&sql=SELECT%20*%20FROM%20nypd_motor_vehicle_collisions%20ORDER%20BY%20number_of_persons_killed%2C%20number_of_persons_injured%20ASC&sw_lat=40.584756547011764&sw_lon=-74.31221008300781&ne_lat=40.79041954961681&ne_lon=-73.4930419921875

I'd love to find some time to try and link these to the data to make them refresh each day... in time. 

On Wed, May 7, 2014 at 5:29 PM, fkh <[address removed]> wrote:

Great statement John and Noel. 

Regarding update frequency, my understanding is that this will be updated daily. Not sure how quickly a crash report is entered into the database though, and whether some precincts will lag. 

Regarding locations: I believe we are getting exactly what the PD has. There's no more detailed location data available for this data set, due to limitations in how the paperwork is filled out at the scene of the crash. Some crashes get a more thorough investigation by the Collision Investigation Service (CIS), but the more accurate location data doesn't get merged into the regular crash records we have here. Options for improved location quality:

- sharing the written description of the crash from the crash report

- sharing the sketch diagram from the crash report

- sharing CIS reports in an additional data set

- collecting better location data, by instructing precincts to fill out the form more completely (could happen at the precinct level(

- switching to mobile data collection tools with gps. 

On Wednesday, May 7, 2014, Noel Hidalgo | BetaNYC <[address removed]> wrote:

This IS a big deal. We've won one more open data set!!! Some of us have been fighting for this data since 2011!!!!

Read about it here http://blog.betanyc.org/post/85050036452/on-the-release-of-nypds-crash-data-and-nyc-bigapps

On Wed, May 7, 2014 at 3:52 PM, fkh <[address removed]> wrote:

This is a big deal -- it's disaggregate crash data, including date and time. No more bundling by intersection and month. 

Locations are still the closest intersection, but it's the best we can expect from the source data. 

On Wednesday, May 7, 2014, Ellen McDermott <[address removed]> wrote:

This is pretty exciting. Andrew Nicklin tweeted this, which looks like it's being rolled out especially for the BigApps kick off tonight. You can sort data by borough, street, injury, fatality, and more. The data looks up to date as of yesterday!

https://data.cityofnewyork.us/NYC-BigApps/NYPD-Motor-Vehicle-Collisions/h9gi-nx95

Best,

Ellen. 

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Ellen McDermott ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about Ellen McDermott, visit his/her member profile
To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])

This message was sent by fkh ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about fkh, visit his/her member profile

To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

This message was sent by Noel Hidalgo | BetaNYC ([address removed]) from #betaNYC, a Code for America Brigade for NYC.

To learn more about Noel Hidalgo | BetaNYC, visit his/her member profile
To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

--

Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by fkh ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about fkh, visit his/her member profile
To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

--

Andrew W. Hill, PhD, Senior Scientist 

www.vizzuality.com | @andrewxhill

Map, analyze and build applications with your data

www.cartodb.com

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])

This message was sent by Andrew W. Hill ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about Andrew W. Hill, visit his/her member profile

To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by fkh ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about fkh, visit his/her member profile
To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]

--

Mark

@mheadd

http://civic.io

github.com/mheadd

--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Mark Headd ([address removed]) from #betaNYC, a Code for America Brigade for NYC.
To learn more about Mark Headd, visit his/her member profile
To report this message or block the sender, please click here
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]