Urban Data Pioneers Initiative Overview
U
r
b
a
n
D
a
t
a
P
i
o
n
e
e
r
s
T
e
a
m
F
o
r
m
a
t
i
o
n
M
e
e
t
-
U
p
September 6, 2018
A
g
e
n
d
a
Purpose:
Create multi-disciplinary learning teams of city
employees and non-employees to deeply understand problems
that can be informed by data analysis.
Outcomes
•
Learn from each other
•
Balanced teams created
•
Plan for next steps and meeting times
•
Clear picture of the problem you’re exploring
Process
•
Presentation
•
Form teams
•
Work in teams and identify next meeting date
U
D
P
M
i
s
s
i
o
n
,
V
i
s
i
o
n
,
V
a
l
u
e
s
Mission: Improve the use of data throughout
the City of Tulsa
Vision:
Urban Data Pioneers are the trailblazers
within the City of Tulsa who lead the way in identifying
best ways to utilize data, educating others, and
delivering results based upon data.
Values:
•
A Learning Culture
•
Respect
•
Integrity
•
Transparency
H
i
s
t
o
r
y
o
f
U
r
b
a
n
D
a
t
a
P
i
o
n
e
e
r
s
G
o
a
l
s
1.
Increase data analytics skills
2.
Deeply understand relevant problems at
City Hall through analytics
3.
Practice storytelling about data
4.
Work across silos and with residents
F
o
c
u
s
o
n
U
n
d
e
r
s
t
a
n
d
i
n
g
t
h
e
P
r
o
b
l
e
m
1.
Understand the Problem
2.
Ideate on strategies (optional)
3.
Choose a strategy
4.
Test a strategy (or two)
5.
Measure & Iterate
6.
Scale up
Our focus
Understanding data is the beginning of knowledge.
-Former Mayor Rodger Randle
O
p
t
i
o
n
1
:
U
r
b
a
n
D
a
t
a
P
i
o
n
e
e
r
s
L
e
v
e
l
-
U
P
Sign up at
DataCamp.com
Enroll in and complete
I
n
t
r
o
t
o
S
Q
L
f
o
r
D
a
t
a
S
c
i
e
n
c
e
a
n
d
A. Intro to Python for Data Science
-OR-
B. Introduction to R
When complete, send your certificate to
Catherine (Erica) Moore
emoore@cityoftulsa.org
1
2
3
Must complete by October 1
T
w
o
T
r
a
c
k
s
http://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1523009719/main-qimg-
9dcf536c501455f073dfbc4e09798a51_vpijr0.png
O
p
t
i
o
n
2
:
U
r
b
a
n
D
a
t
a
P
i
o
n
e
e
r
s
L
e
v
e
l
-
U
P
L
i
t
e
Sign up at
DataCamp.com
Enroll in and complete
Spreadsheet Basics
Data Analysis with Spreadsheets
When complete, send your certificate to
Catherine (Erica) Moore
emoore@cityoftulsa.org
1
2
3
P
r
o
j
e
c
t
#
1
P
r
o
j
e
c
t
#
2
P
r
o
j
e
c
t
#
3
P
r
o
j
e
c
t
#
4
P
r
o
j
e
c
t
#
5
P
r
o
j
e
c
t
#
6
F
o
r
m
T
e
a
m
s
Each team needs:
1.
Team Lead (project manager)
2.
Data Analyst
(Excel, Tableau, GIS, Python, R, SQL)
3.
Subject Matter Expert
4.
Data Storyteller
5.
Learners!
S
u
g
g
e
s
t
e
d
M
i
l
e
s
t
o
n
e
s
•
Week 2: Sept. 20 - Datasets collected
•
Oct. 1 – (optional) DataCamp Prerequisites complete
•
Week 5: Oct. 11 – Preliminary Data Analysis
•
Week 8: Nov. 1- Refined Data Analysis/Visualization
•
Week 10: Nov. 15 –Draft Slide Deck
•
Week 12: November 29 – Presentations
M
e
e
t
-
U
p
S
p
a
c
e
s
–
C
i
t
y
H
a
l
l
•
Small meeting rooms available –
Ben Harris can
book for you
•
Public Wi-Fi
•
Only between 7:00am-6:00pm M-F
M
e
e
t
-
U
p
S
p
a
c
e
s
–
T
u
l
s
a
C
e
n
t
r
a
l
L
i
b
r
a
r
y
•
PC and Mac Laptops available for checkout
•
Small meeting rooms available
•
Requires library card
S
l
a
c
k
h
t
t
p
s
:
/
/
u
r
b
a
n
d
a
t
a
p
i
o
n
e
e
r
s
.
s
l
a
c
k
.
c
o
m
Recommend installing Slack App (Windows, Mac, iOS, Android)
V
i
r
t
u
a
l
M
e
e
t
i
n
g
s
U
b
e
r
C
o
n
f
e
r
e
n
c
e
•
Screen Sharing (Need Google Chrome)
•
Call-in or VOIP
•
Call Recording
•
Limited to 10 people for free version
•
Fun hold music!
A
w
a
r
d
s
B
e
s
t
O
v
e
r
a
l
l
T
e
a
m
:
T
h
e
t
e
a
m
t
h
a
t
e
x
h
i
b
i
t
e
d
s
t
r
o
n
g
t
e
a
m
w
o
r
k
a
n
d
c
o
l
l
a
b
o
r
a
t
i
o
n
,
e
x
h
i
b
i
t
e
d
b
y
d
a
t
a
a
n
a
l
y
s
i
s
,
p
r
e
s
e
n
t
a
t
i
o
n
,
a
n
d
l
e
a
r
n
i
n
g
.
M
o
s
t
U
n
i
q
u
e
I
n
s
i
g
h
t
:
T
h
e
m
o
s
t
u
n
u
s
u
a
l
o
r
u
n
e
x
p
e
c
t
e
d
o
b
s
e
r
v
a
t
i
o
n
.
H
e
l
p
!
U
D
P
P
r
o
j
e
c
t
s
Ben Harris
bharris@cityoftulsa.org
918.576.5139
James Wagner
jwagner@cityoftulsa.org
918.576.5578
U
D
P
L
e
v
e
l
U
P
Enrollment
Catherine Moore
emoore@cityoftulsa.org
Advisement
Kevin Gustavson
kgustavson@cityoftulsa.org
1
2
3
Choose a Project
Form a Team
Roster & Charter
Post charter on Slack!
4
Meet & Repeat
The Urban Data Pioneers program in the City of Tulsa focuses on creating multi-disciplinary teams to deeply understand and solve city problems using data analysis. The initiative's mission, vision, values, history, goals, and options for upskilling are outlined to empower participants in improving data utilization throughout the city.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Urban Data Pioneers Team Formation Meet-Up September 6, 2018 Image result for oregon trail
Agenda Purpose: Create multi-disciplinary learning teams of city employees and non-employees to deeply understand problems that can be informed by data analysis. Outcomes Learn from each other Balanced teams created Plan for next steps and meeting times Clear picture of the problem you re exploring Process Presentation Form teams Work in teams and identify next meeting date
UDP Mission, Vision, Values Mission: Improve the use of data throughout the City of Tulsa Vision: Urban Data Pioneers are the trailblazers within the City of Tulsa who lead the way in identifying best ways to utilize data, educating others, and delivering results based upon data. Values: A Learning Culture Respect Integrity Transparency
History of Urban Data Pioneers April 2017 1st cohort presentations 5 projects August 2017 2nd Cohort Presentations 3 Projects Feb. 2017 Kickoff first cohort March 2017 Data Fields of Dreams June 2017 Kickoff 2nd Cohort October 2017 Kickoff 3rd Cohort May 2018 Engaged Cities Award Jan. 2018 May 2018 3rd cohort presentations 5 projects Feedback Session and Survey Results July 2018 Call for Projects Sept. 2018 Kickoff 4th Cohort August 2018 Project Scoping November 2018 4th Cohort Presentations
Goals 1. Increase data analytics skills 2. Deeply understand relevant problems at City Hall through analytics 3. Practice storytelling about data 4. Work across silos and with residents
Option 1: Urban Data Pioneers Level-UP Sign up at DataCamp.com 1 Enroll in and complete Intro to SQL for Data Science and A. Intro to Python for Data Science -OR- B. Introduction to R 2 When complete, send your certificate to Catherine (Erica) Moore emoore@cityoftulsa.org 3 Must complete by October 1
Two Tracks http://res.cloudinary.com/dyd911kmh/image/upload/f_auto,q_auto:best/v1523009719/main-qimg- 9dcf536c501455f073dfbc4e09798a51_vpijr0.png
Option 2: Urban Data Pioneers Level-UP Lite Sign up at DataCamp.com 1 Enroll in and complete Spreadsheet Basics Data Analysis with Spreadsheets 2 When complete, send your certificate to Catherine (Erica) Moore emoore@cityoftulsa.org 3
Project #1 Analyzing Tulsa s 311 Customer Care Data Overview Analyze 311 Customer Service call center data to understand patterns of interaction with the City s Interactive Voice Response (IVR) system Key Question What pathways are most likely to be successful (i.e. bulky waste, missed trash pickup, etc.)? Dataset(s) Individual IVR records for calls regarding the city s water and refuse utilities Project Sponsor Michael Radoff mradoff@cityoftulsa.org Dianna Phillips diannaphillips@cityoftulsa.org
Project #2 Nuisance Frequent Fliers Overview The City can abate (clean up) any high grass/weeds or junk/debris complaints if the property and owner have had the same violation within two years. We want to create optimized routes for inspectors to optimize neighborhood health. Key Question Which properties and/or owners are the most frequent violators of city code? Can we identify property that is continually receiving nuisance complaints so that WIN can schedule routine inspections and abatements? Dataset(s) Nuisance Complaints (high grass/weeds, junk/debris) Summary Abatements Project Sponsor Dwain Midget dmidget@cityoftulsa.org
Project #3 Zoning and Sales Tax: How can Land Use Policy Impact City Services? The City relies on sales tax revenue for operations. Zoning districts that allow taxable sales may impact the city s ability to provide services. Overview Key Question Can we estimate the sales tax productivity potential of each of the different zoning districts in the City of Tulsa? What attributes of each district have the greatest effect on tax productivity? Zoning, Aggregated Sales Tax Dataset(s) Project Sponsor Stephen Lassiter stephenslassiter@gmail.com Nathan Pickard npickard@cityoftulsa.org
Project #4 Eviction Prevention Overview Evictions can have a dramatic effect on families. Tulsa ranks 11th in eviction rates nationwide. Key Question How can multiple datasets be leveraged to build an eviction risk score for properties where eviction is likely to occur in the future? Dataset(s) Historic eviction data, Property ownership data, Utility turnovers Project Sponsor April Merrill, Legal Aid Services of Oklahoma April.Merrill@laok.org Ryan Gentzler, OK Policy, rgentzler@okpolicy.org
Project #5 Reducing Injury Rates at City Hall Overview The City collects data on injuries that occur at city hall, but lacks a repeatable method for measuring rates by department and division. Key Question What is the City of Tulsa s workplace injury rate by department and division? What other factors (age, experience, supervisor, etc.) correlate with injury rates? City of Tulsa Injury Reports, Employment by Department Dataset(s) Project Sponsor Brannon Dodd bdodd@cityoftulsa.org
Project #6 Improving 911 Answer Times Overview The Tulsa 911 Public Safety Center could optimize overtime offering by analyzing patterns in call volume over the past two years. Key Question How can 911 use call volume data to optimize resource allocation and prioritize work for impact ? / If we could identify a pattern for calls, we could align the shifts and staffing to the known pattern and optimize the offering of overtime. 911 Calls (ECaTS) and Dispatch (CADS) data, Weather data Dataset(s) Project Sponsor Terry O Malley tomalley@cityoftulsa.org Belinda McGhie BMcGhie@cityoftulsa.org
Form Teams Each team needs: 1. Team Lead (project manager) 2. Data Analyst (Excel, Tableau, GIS, Python, R, SQL) 3. Subject Matter Expert 4. Data Storyteller 5. Learners!
Suggested Milestones Week 2: Sept. 20 - Datasets collected Oct. 1 (optional) DataCamp Prerequisites complete Week 5: Oct. 11 Preliminary Data Analysis Week 8: Nov. 1- Refined Data Analysis/Visualization Week 10: Nov. 15 Draft Slide Deck Week 12: November 29 Presentations
Meet-Up Spaces City Hall Small meeting rooms available Ben Harris can book for you Public Wi-Fi Only between 7:00am-6:00pm M-F
Meet-Up Spaces Tulsa Central Library PC and Mac Laptops available for checkout Small meeting rooms available Requires library card
Slack https://urbandatapioneers.slack.com Recommend installing Slack App (Windows, Mac, iOS, Android)
Virtual Meetings Uber Conference Screen Sharing (Need Google Chrome) Call-in or VOIP Call Recording Limited to 10 people for free version Fun hold music!
Awards Best Overall Team: The team that exhibited strong teamwork and collaboration, exhibited by data analysis, presentation, and learning. Most Unique Insight: The most unusual or unexpected observation.
Help! UDP Projects Ben Harris James Wagner jwagner@cityoftulsa.org 918.576.5578 bharris@cityoftulsa.org 918.576.5139 UDP Level UP Enrollment Advisement Catherine Moore emoore@cityoftulsa.org Kevin Gustavson kgustavson@cityoftulsa.org
1 Choose a Project 2 Form a Team Roster & Charter Post charter on Slack! 3 4 Meet & Repeat
