it's what you do with the data- brett goldstein
DESCRIPTION
Today, data is an essential tool for government decisionmaking. This session highlights how governments are using data tools and analytics to gain a more complete understanding of problems and the ability to more clearly define goals, measure effectiveness, and adjust as needed. Brett Goldstein, Code for America Board Member, on aggregating datasets through geospatial and time identifiers to better understand urban ecosystems. Watch the video online: https://www.youtube.com/watch?v=s31N6Vybcjc&list=PL65XgbSILalWFStqV0z0N9pvftstJ8AAh&index=8 Get involved with Code for America: www.codeforamerica.org/actionTRANSCRIPT
![Page 1: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/1.jpg)
Plenario:The Next Stage in Open Data
Brett GoldsteinCfA Summit
September 23, 2014@bjgol
![Page 2: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/2.jpg)
But first... what a year
![Page 3: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/3.jpg)
We’ve gone from 0 1How do we go further?
![Page 4: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/4.jpg)
Two friends got together...
and with a lot of help...
![Page 5: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/5.jpg)
One APIOne query
Central data store
Socrata, CKAN, and CSV
City, county, state, and federal
Single spatial index
Single temporal index
Rich context and joins
![Page 6: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/6.jpg)
Plenar.io
![Page 7: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/7.jpg)
http://plenar.io/v1/api/detail/ ?dataset_name=crimes_2001_to_present &obs_date__ge=2014-1-1 &iucr=0110 &weather=true
goo.gl/NaFQ4r
![Page 8: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/8.jpg)
objects: [{observation: {
case_number: "HX268077", domestic: false, primary_type: "HOMICIDE", district: 8, arrest: true, location: "(41.740149334, -87.702275654)", description: "FIRST DEGREE MURDER", beat: 834, date: "2014-05-19T17:04:00", ward: 18, iucr: "0110", location_description: "ALLEY", fbi_code: "01A", block: "084XX S KEDZIE AVE"
},weather: {
wind_speed: 21, sealevel_pressure: 29.98, sky_condition: "SCT070 BKN140 OVC200", wind_direction: "160", visibility: 10.0, wind_direction_cardinal: "SSE", relative_humidity: 34, hourly_precip: null, drybulb_fahrenheit: 70.0, station_pressure: 29.32, wban_code: "14819"
}}, {
observation: {case_number: "HX332990", domestic: false, primary_type: "HOMICIDE", district: 22, arrest: false, location: "(41.703648763, -87.635632145)", description: "FIRST DEGREE MURDER", beat: 2233, date: "2014-07-06T00:07:00", ward: 34, iucr: "0110", location_description: ”HOUSE", fbi_code: "01A", block: "104XX S NORMAL AVE"
},weather: {
wind_speed: 9, sealevel_pressure: 30.01, sky_condition: "SCT038 SCT080", wind_direction: "230", visibility: 10.0, wind_direction_cardinal: "SW", relative_humidity: 73, hourly_precip: null, drybulb_fahrenheit: 69.0, station_pressure: 29.38, wban_code: "14819"
}}, {
observation: {case_number: "HX343780", domestic: true,
goo.gl/NaFQ4r
![Page 9: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/9.jpg)
http://plenar.io/examplesTell me the story of 700 Howard Street.
Give me weekly counts of 311 requests for every city in the country.
Let me download all pothole reports from the census tract containing the Sears Tower.
What recent traffic accidents in Manhattan resulted in a fatality—and what was the weather like?
Show me civilizational collapse during Winter Storm Nemo (Feb 2013).
![Page 10: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/10.jpg)
Extensible tools: goo.gl/CpeuFa
![Page 11: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/11.jpg)
You build the apps
We built the API
![Page 12: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/12.jpg)
Let’s be smarter
![Page 13: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/13.jpg)
Behind the curtain
id
![Page 14: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/14.jpg)
Where the $$$ came from
• UrbanCCD• University of Chicago• DataMade AWS Schema
Who made it
• National Science Foundation EAGER grant
• MacArthur Foundation
![Page 15: It's What You Do With the Data- Brett Goldstein](https://reader034.vdocuments.us/reader034/viewer/2022052600/557c7e9fd8b42ab0788b46b8/html5/thumbnails/15.jpg)
Thank youhttp://plenar.io
@bjgol