Presentation to OpenOakland.org

17 June 2014

All talk slides (PDF, 5 Meg)

• Rik Belew
• Lt. Chris Bolton
• José Dorado

Grounding local news

• Violent crime plummets in Oakland [SFGate, Will Kane, May 19 2104]

• The Thin Blue Privatized Line [SanFrancisco Magazine, Justin Berton, June 3, 2014]

• Six Neighborhoods to Know [Susan Kuchinskas, Oakland Magazine, April 2014]

Getting data from OPD

• OPD IT

  • www2.oaklandnet.com/Government/o/OPD/s/Statistics/

  • ftp://crimewatchdata.oaklandnet.com/

• CrimeMapping.com

  • Omega Group sells Oakland IT other products, giving them special access to OPD data

  • They are dropping ~ 30-50% of the data!

• Other Commercial interests

  • CrimeReports.com

  • City-Data.com

  • Trulia.com

OpenOakland data

• Data model

• Geo-located (most addresses have been resolved to LAT/LONG coordinates)

• Crime classificaiton

• Delivered at data.openoakland.org

  • CSV

  • JSON

  • SQLite

Sample application: Evaluation of Rockridge patrols

• “Measuring the Effectiveness of Private Security Patrols in Lower Rockridge” May 5, 2014 [Paul Liu, http://goo.gl/PTTaeB]

• “To me the best thing is connecting folks. Learning more, and being more aware of the community. … more accountability by our Police Force and City Council to respond to crime.”

MeasureY

• MeasureY @ OaklandWiki
• Going after causes: OaklandUnite
• What comes next?
• NCPC in a box!

Be prepared to VOTE Nov 4, 2014!