Maksim Pecherskiy
Performance & Analytics Department
I'm terrible at designing slides
Opening Data ties in directly with each of our Strategic Goals and allows us to monitor how we're doing at meeting them
Draws on other existing policies.
Defines terms, making sure data meets "open criteria"
Assigns responsibilities to Chief Data Officer and to City Departments
Sets timeline
Includes reporting requirements to Mayor and Council
Total Time: 1 Hour
"Open data is not just about putting spreadsheets on the internet.
It means being deliberate and thoughtful about what is released, how it's released, and how it's described.
Treating data like an asset and releasing it properly goes directly hand-in-hand with making sure that it's secure and mitigating opportunities for misuse"
A value or set of values representing a specific concept or concepts.
Data become “information” when analyzed and possibly combined with other data in order to extract meaning and to provide context.
The meaning of data can vary depending on its context.
"Data is something you can take, and do something else with."
(Besides print it or send it in an e-mail).
"Data is something you can take, and do something else with."
(Besides print it or send it in an e-mail).
Data in an Open Machine Readable Format
Data
Not Beautiful
A Website
A Dashboard or Chart
A Map
A PDF / Word Doc or E-Mails
Data
OR
OR
Data
Data Visualization
We MUST allow the capability to separate data from how it's shown in order for it to have value beyond what the visualization intended
The user may not share your opinion of what and how they want to visualize the same data.
"Data" can be separated from how it's displayed.
Technology or system that stores data, including databases, named spreadsheets, information systems, business applications, etc.
Contents of a single database table, worksheet or defined view; data is provided as a single combination of unique rows (or records) and corresponding columns (or fields) describing that row
Example - Database: A database may contain several data tables - each data table constitutes a dataset. However, you could also create new datasets by combining data from different tables into a new table.
Anything used to build a table / chart / map
Technology or system that stores data, including databases, named spreadsheets, information systems, business applications, etc.
NOT every single spreadsheet your department owns.
Some examples of spreadsheets we're not looking for:
Timesheets.
Project plans / Gantt charts.
Personal tracking sheets.
One-time documents developed for a specific project.
Some examples of what we are looking for:
List of fire hydrants.
Performance measures.
Potholes list.
Street sweeping locations and times.
PRA request history.
Workforce centers.
Street names.
Libraries - locations and hours.
List of Lists (Dataset that contains information about other datasets)
Reference data (data and provides reference to another data set.)
Multiple divisions produce / use data
Known group of people / handlful of individuals have a good handle on who produces what data and for what purpose
Even if department is large and you don't know all your colleagues, you can quickly id the right person to talk to about your department's data
Questions can be answered easily over e-mail / quick call or a quick walk around the building
Nearly every division/group uses/maintains/reports on data and there is no readily defined group / set of individuals who have a good handle on all the data in the department.
Even if each division/group has an individual that understands their respective data, and there may still be blindspots to explore.
Your department may be spread over different buildings or many floors of a building and getting answers to questions may take many phone loops or emails to find the “right” person.
Contents of a single database table, worksheet or defined view; data is provided as a single combination of unique rows (or records) and corresponding columns (or fields) describing that row
Example - Database: A database may contain several data tables - each data table constitutes a dataset. However, you could also create new datasets by combining data from different tables into a new table.
Anything used to build a table / chart / map
What data populates your monthly / quarterly reports
What departmental data is currently publicly available?
What data does your department use for internal performance and trend analysis
What information is published as a KPI in the budget or performance metric elsewhere
If you were to build a dashboard for your department, what would the metrics be and where would the data come from?
What data is reported to federal, state or local agencies
What data requests do you receive under the PRA act.
What data do other departments ask for, or you share with other departments now
What kinds of open data are similar agencies across the country publishing
data.cityofchicago.org
nycopendata.socrata.com
data.sfgov.org
Complete Metadata as described in the provided file
Presentation: http://bit.ly/odkickoff
Handout: http://bit.ly/invhandout
maksimp@sandiego.gov