advancing the police data initiative
TRANSCRIPT
![Page 1: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/1.jpg)
Advancing the Police Data InitiativePeter Moore
![Page 2: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/2.jpg)
About Me
Data Analyst at Socrata
Peter Moore
“Data! Data! Data!” he cried impatiently. “I can't make bricks without clay.”
![Page 3: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/3.jpg)
The Police Data Initiative
Task Force on 21st Century Policing
![Page 4: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/4.jpg)
The Police Data Initiative2014 White House Initiative:
Open Data and Policing (External)Use open data to increase transparency, build community trust, and support innovation.
• Departments share disaggregated data about police-citizen interactions with the public in machine-readable formats
• Identify and disseminate best practices through a community of practice
Internal Accountability (Internal)Better use data and technology to improve early warning systems, internal accountability, and decrease inappropriate uses of force
• Departments work alongside, and share data (primarily through data-sharing agreements) with, researchers and data scientists for analysis
• Develop, share, and adopt best practices around IT system procurement, and internal accountability systems
![Page 5: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/5.jpg)
Map of Police Data Initiative Partners source: Police Foundation
![Page 6: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/6.jpg)
The Challenge:Collect and automatically update police
data into a combined Open Data portal
![Page 7: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/7.jpg)
Police Foundation – Socrata Partnership
Police Foundation• Policing policy
research and services• Subject matter
experts• A lead organization in
the police data initiative
• Open Data Solution• Technical help and
consulting• Data integration
Socrata
![Page 8: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/8.jpg)
Open Data
• NOT data published in PDFs or locked behind online maps or other data visualizations
• NOT data only about crimes, but rather data about the activity of policing, and interactions with citizens
Source: Police Foundation
![Page 9: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/9.jpg)
Getting the Data
Or, how useful the python creator is.
![Page 10: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/10.jpg)
Python
Steps:1. Create the Socrata APIQuery to pull a maximum of50,000 rows that were updated 2 days ago.2. Pull the csv3. Output the individual rows
![Page 11: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/11.jpg)
Our (sample) Workflow
![Page 12: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/12.jpg)
Automation: Enter FME Server
![Page 13: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/13.jpg)
Data Movement!
![Page 14: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/14.jpg)
Lessons Learned• Not so uniform data• Open Data is just the start• PythonCreator (and caller) don’t
automatically create attribute names• FME Server is very useful for
scheduling jobs
![Page 15: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/15.jpg)
Next Steps
Greater integration with source systems (e.g. IAPRO)
Greater awareness
More standardization
![Page 16: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/16.jpg)
Thank you!Peter [email protected]
Get the data:http://publicsafetydataportal.org/https://data.policefoundation.org/browse& Check with your local Police Department
![Page 17: Advancing the Police Data Initiative](https://reader031.vdocuments.us/reader031/viewer/2022020300/589d6aef1a28abd91d8b5e61/html5/thumbnails/17.jpg)
Love Open Data?
We’re hiring!
careers.socrata.com/jobs