District Of Columbia Government Tableau Capstat

CapStat: Selection of Tableau Charts from CapStat Sessions

June, 2008

Office of the City Administrator Dan Tangherlini, City Administrator and Deputy Mayor 1

CapStat

CapStat: • • • • • •

CapStats with Tableau Charts

7/24/2007 – Fire and Emergency Medical Services 8/1/2007 - Homicides 9/25/2007 – Customer Service Operations 10/12/2007 – School Security 10/23/2007 – Department of Motor Vehicles 10/30/2007 - Special Education Transportation

2

CapStat

CapStat: • • • • • • • •

Fire/EMS

Fire/EMS 911 Calls “Fire” Incidents Staff Hours worked on Fire Events by Day Deployment of Engines and Trucks Major Fire Responses – FY2007 Investigated Fires by Type and Cause Structure Fire Damage Staff Hours Worked on Fire and EMS Events by Day

3

CapStat

Fire/EMS 911 Calls

CapStat: FIRE

MEDICAL

2007

2007 9,700

Incidents

10K

10,327

9,858

21,053

19,910

11,063

10,470

22,801

21,708

30,257

28,535

May

June

7,598

5K 2,453

2,765

2,626

2,659

2,793

2,578

Responses

0K 19,985

20K

10K

15,627 7,178

7,628

7,314

7,029

7,523

6,888

0K

Staff Hours

30K

25,747

20,901

20K 10K

27,824

25,979

10,201

11,895

10,666

11,361

10,899

10,295

February

March

April

May

June

0K January

January

February

March

April

Source: Intergraph CAD data, Jan-June 2007.

4

CapStat

“Fire” Incidents

CapStat: 1,585

Fire-Smoke 900

Gas-Hazmat 2006

9,636

14,480

2,438 3,289

Alarm

4,188 5,493

4,170

Q4 1,991

Other Detail Mass Event

2,786

177

3,987

534

98

1,552

929

1,645

1,503

Fire-Smoke

9,609

866

Gas-Hazmat

15,624

2,584 3,115

Alarm

4,788 5,295

4,231

Q1 2,084

2007

Other Detail

163

Mass Event

116

2,901

3,898

526

1,565

1,107

1,871

1,814

Fire-Smoke

9,479

785

Gas-Hazmat

16,655

2,379 3,115

Alarm

4,406 5,201

3,953

Q2 2,027

Other Detail Mass Event

2,767

173

574

108 0K

3,706 2,062

938 1K

2K Incidents

3K

4K 0K

1,627 5K Responses

10K

0K

5K

10K Staff Hours

Source: Intergraph CAD data, FY 2007. Does not include staff hours worked by Fire Prevention Division, or scheduled non-911 deployments. For details of what’s included in each Event Family, see Event Family Membership document. 5

15K

20K

CapStat

Staff Hours

CapStat:

Staff HoursWorked on Fire Events by Day: April toJune 2007

Source: CAD, FEMS, April to June 2007

6

CapStat

6

5

4

3

2

1

CapStat:

Deployment of Engines and Trucks June 24, 2007

Source: CAD, FEMS, April to June 2007

7

CapStat

6

5

4

3

2

1

CapStat:

Deployment of Transport Units June 15, 2007

Source: CAD, FEMS, April to June 2007

8

CapStat

CapStat:

Major Fire Responses FY 2007

Significant fire responses occur in all parts of the city.

Source: CAD, FEMS, Sept 2006 to June 2007 Only incidents with 100 or more staff hours; n=65

9

CapStat

Investigated Fires by Type and Cause

All Investigated Fires

Incendiary

Structure

Investigated Fires

FY05: 763 FY06: 700

Cause of Structure Fires

By Type

Investigated Fires

CapStat:

40

20

0

0

40

20

0 Investigated Fires

Undetermined

2007

Other

2006 Date

Investigated Fires

2005

Investigated Fires

20

Structure

40

Accidental

Vehicle

60

Investigated Fires

80

40

20

0 2005

Source: DC Fire Marshal monthly reports, investigation unit section. Other includes brush, outdoor, etc. Incendiary includes arson. Not all fires require investigation. 10

2006 Date

2007

CapStat

Structure Fire Damage

CapStat: Structure 1500K

1000K

Damage from 2 April 30 fires, estimated at $35 million, exceeds the total damage from all other structure fires in past 30 months combined.

500K

0K 1500K

1000K

500K

0K 1500K

1000K

500K

0K Jan 1 05 May 1 05 Sep 1 05 Jan 1 06 May 1 06 Sep 1 06 Jan 1 07 Date

Source: DC Fire Marshal monthly reports, investigation unit section. Chart scale adjusted to cut off damages exceeding $1.5M per month. 11

CapStat

Sum of Staff Hours

CapStat:

Staff Hours Worked on Fire and EMS Events: Daily, January to June 2007

Source: CAD, FEMS, January to June 2007

12

CapStat

CapStat:

Homicides

• Hospital Transports

13

CapStat

CapStat:

Hospital Transports

Transports to Trauma Hospitals of Shooting/Stabbing Victims 10/1/06 to 6/30/07

Source: Intergraph CAD; Includes only incidents resulting in transports, with valid time intervals (X=573). 14

CapStat

CapStat:

Customer Service

• Snowfall in the District • Service Request Completion vs. Callback Rating • Customer Service Perception Gap

15

CapStat

CapStat:

Snow/Ice Removal: Background

Snow Accumulation, Winter 1999-2000 to 2006-2007

Snow Mobilizations: Spending:

--

--

$4.1M

$2.5M

-$5.8M

-$3.2M

12

7

$5.3M

$4.2M

13 $6.8M

Source for upper chart: NOAA data, DDOT StormTrak Manager, CapStat research. Snowfall by month, bucketed in 0, 1-5, 6-10, etc. Source for lower chart: DDOT; dollars are not adjusted for inflation; figures in gray do not include spending on National Highway System streets, estimated between $1-3M per year.

16

CapStat

CapStat:

Quality of Call per request

17

CapStat

CapStat: Customer Service Perception Gap

Source: Monthly Service Delivery On-time Performance Report, Sep 2006 to Aug 2007; Customer Surveys Apr – Sep 2007 (n = 2,840). Gap is difference. Omits graffiti and vacant lots, which have no on-time targets

18

CapStat

CapStat:

School Security

• Results from Youth Risk Behavior Survey

19

CapStat

CapStat:

What do Students Think?

20%

19%

20%

18% 14%

15% 10%

14%

13%

15%

16%

13%

14%

Carried a weapon on school property

30%

0% 30%

20%

13% 10%

30%

20%

17.0% 8.9%

10%

9.3%

10.6% 6.7%

8.5% 6.9%

6.4%

6.1%

7.4%

6.5%

0%

13%

7% 8%

11% 9%

13%

9%

12%

11%

8%

0%

1997

1999

2001

2003

2005

Feel too unsafe to go to school

Threatened or injured with a weapon on school property

Engaged in a physical fight on school property

Selected results from recently completed Youth Risk Behavior Survey

30%

19%

20%

12%

11%

9%

10%

4%

0%

2007

1997

14%

14%

5%

7%

5%

6%

1999

2001

2003

2005

2007

Source: Centers for Disease Control, Youth Risk Behavior Survey. Sample for DC 9-12 graders in Spring 2007 = 1,732.

20

CapStat

CapStat:

• • • •

Dept of Motor Vehicles Charts

Driver/Vehicle Transactions Inspections Lane Utilization Renewals by Channel

21

CapStat

Driver/Vehicle Transactions

CapStat:

Type Driver

200K

Vehicle 100K 0K 200K 100K

33,252

33,775

49,799

49,423

81,965

76,000

175,150

176,369

20,189 25,950

26,060

21,751 53,553

53,616

2003

2004

39,363

33,729 44,316

44,883

67,657

65,487

34,235 45,802

35,773 197,727

204,918

164,182

100K 0K

43,415

35,114 31,320

41,757

46,587

23,864 49,425

22,849 46,831

2005

2006

2007

200K 100K 0K

Internet

200K

Inspection Station

0K

Source: Destiny. K St NE no longer in service.

22

CapStat

Inspections

CapStat:

Average Hourly Inspections by Day of Week and Hour of Day 50

48

43

52

64

77

76

73

72

61

65

56 36

0 67 50

54

55

68

78

78

74

73

70

62

53 35

Total FY2007 Inspections:

34

209,472

0 66 50

50

54

64

75

76

71

73

67

63

51

0 63 50

49

52

65

77

77

76

73

71

63 48 30

0 64 50

55

56

66

76

77

77

75

71

63

48

34

0 77

76

70

74 48

50

72

68

13

14

56

0 6

7

8

9

10

11

12

Source: DMV Inspections system. FY2007 data. Corrected for holidays. Does not reflect lane availability

23

15

16

17

CapStat

CapStat:

Inspection Station – Lane Utilization

Note – this was a Saturday when the line at 7:25am extended to the corner of Delaware and M streets. Note that lanes 4 and 5 got off to a slow start, and lane 2 apparently stopped service at 8:30am. Green color indicates vehicles with OBD (on board detection), for model years 1996 and after.

Source: DMV Inspections system. Each tile represents an inspection. Green have on board detection, orange do not. Lane 9 used for special inspections.

24

CapStat

Renewals by Channel

CapStat:

Vehicle Registration 100K

Walk-in

102,387

99,854

90,092

Driver's License 85,572

52,769

46,127

50K

36,690 17,875

0K 100K

Mail-in

50K 21,351

31,815

27,092 15,435

0K 100K

Internet

50K 16,698

20,323

25,944

29,341

0K 2004

Source: Destiny

2005

2006

2007

2,634

3,029

4,683

3,946

2004

2005

2006

2007

25

CapStat

CapStat:

Special Education Transportation Charts

• Route Histogram • Staggered Bell Times

26

CapStat

CapStat:

Routes by Number of Riders Routes by Number of Riders 97

100

92

91

80

Routes

80 61

60

52

40

37

34

33

22

20

20

8 2

0 1

2

3

4

5

6

7

8

9

10

11

12

13

5

3

1

14

15

17

22 routes, or 3.4%, have one rider.

Source: Edulog transport ridership extract as of October 12, 2007

27

CapStat

CapStat:

Staggered Bell Times

1500

1000

500

9:30 AM

9:00 AM

8:55 AM

8:50 AM

8:45 AM

8:40 AM

8:30 AM

8:28 AM

8:25 AM

8:20 AM

8:15 AM

8:10 AM

8:05 AM

8:01 AM

8:00 AM

7:55 AM

7:50 AM

7:45 AM

7:40 AM

7:30 AM

0

• Most schools start at 8:45 (DCPS) or 8:30 (St. Coletta, Accotink) • Three DCPS learning centers for special ed children start at 7:45: Mamie D. Lee, Prospect, and Taft • The earlier start enables crews on these routes to make a second round of pickups on 65 of the 68 routes serving those schools • Could DCPS start more schools earlier? • Could DCPS offer special “before/after” classes for special ed students, in exchange for part of the savings generated by enabling buses to cover multiple routes? 28

CapStat

CapStat:

Slides from other sessions

• Ex-Offender Affairs – Status Transitional Employment Class

• Children/Youth Investment Trust – Program Participation Rates – Grantee Performance Matrix

• DCPS Test Scores

29

CapStat

Closed Closed

Pvt

Not Success

S.

CapStat:

Pvt Job Ready Job Rea.. Pubsub

Job Search

Status of Class Starting Jan 8, 2007

METRO N/A

1622 1561 1569 1572 1577 1578 1580 1596 1598 1601 1608 1610 1619 Duvalls Hair Co., Inc. 1607 1570 N/A 1582 N/A 1604 N/A 1565 DDOT 1620 1593 DPR 1595 Office of Administrativ.. 1626 1571 N/A 1573 1579 1581 1594 1599 1609 1614 1633 N/A 1584 1576 DDOT 1600 DPR 1585 1564 DPW 1597 DPW,SWMA,SWDD,FT.. 1615 MVS 1631 Backus Middle School 1592 Battles Transportation.. 1623 Bowie Trash 1590 Career Team 1589 Classic Concierge, Inc. 1586 Communication Unlim.. 1603 Goodwill 1602 1587 MarLaw Systems Technology, Inc. 1611 MVS, Inc. 2859 YMCA of Metropolitan .. 1566 N/A 1632 N/A 1568 N/A 1322

ActivityDesc Job Readiness Job Club

Why isn’t this a success?

Job Search Occupational Skill Training Work Experience Unsubsidized

Are these really still in subsidized employment?

Check – still DDOT/DPW? Pvt Gov

Open

Unsub

..

Pvt

Inactive Voc Ed Job Sea..

Why still open if more than 6 months in unsubsidized?

Jan 1 07

Mar 1 07

May 1 07

•Source: DOES. List of 53 ex-offenders starting job readiness on 1/8/2007

Jul 1 07

Sep 1 07 StartDate

Nov 1 07

30

Jan 1 08

Mar 1 08

May 1 08

CapStat

CapStat:

Program Participation Rates (Cont.)

Hoop Dreams Scholarship Fund Ana's Gold Children Theatre Arch Training Center Falconsedge Male Task Force, Inc. Ethiopian Community Services and Development C.. Dance Institute of Washington Facilitating Leadership in Youth (FLY) Covenant House Washington LINK Good Samaritan Foundation The Higher Achievement Program Heads Up: A University Neighborhood Initiative Kid Power DC Beacon House Community Preservation and Development Corpor.. Northwest Settlement House Latin American Youth Center The Fishing School Reaching Inside for Self Esteem Euphemia L. Haynes Public Charter School City Gate, Inc Johenning Temple of Praise Destiny Project- Youth.. WVSA Arts Connection Perry School Community Services Center , Inc. CityDance Ensemble Recreation Wish List Committee of Washington D.C. Sexual Minority Youth Assistance League (SMYAL) NOMIS Youth Network Shakespeare Theatre Company Parklands Community Center Asian American LEAD Smithsonian Anacostia Community Museum. Thurgood Marshall Academy Public Charter High S.. East of the River Clergy Police Community Partner.. Advocates for Justice & Education, Inc.

77% 76% 75% 73% 72% 72% 71% 70% 69% 68% 68% 67% 67% 67% 64% 63% 61% 61% 60% 60% 57% 57% 55% 55% 44% 41% 33% 32% 31% 28% 27% 22% 19% 16% 11% 0%

50% Participation Rate

309

64 56 35 23 20 55 54 55 15 313

C

St t A

32 606

39 41 34

48 98 32 28

56 56 152

20

60 76

53 37 290

31

58 28 34 80 57 61 31 59 56 87 49

55 49 55 54 39 56 11 36 37 27 65 194

33 302

52

24

38 255

0

200

400 Enrollees

31

S

12

20 24 35 71 100 39 67 101 44

l i CYITC

17 600

0

20 40 60 Average Number of Sessions

CapStat

Grantee Performance Matrix

CapStat:

Goal: Move more programs to the upper right corner of the grid 100% turnout. Solution? Audit closely before reinvesting.

High Turnout, Low Intensity: 100% Solution? Increase 90% funding and expand

High Turnout, High Intensity: Solution? Reinvest in winners

80% 75%

Participation Rate

70%

60%

50%

40%

30%

20%

10% 35

0% 0

10

20

Low Turnout: Solution? Consider de-funding

•

30 40 50 Avg Number of Sessions (proxy for quality)

60

70

Need to establish a better measure of quality

Source: CapStat Analysis. CYITC Webstars tracking system.

32

CapStat

CapStat:

Attendance Patterns – SY 2006-07 Arch Training Center

Source: CYITC Webstars tracking system. Each vertical line represents a day of attendance; each horizontal row represents one student’s attendance.

33

CapStat

Reading Improvement Histogram

CapStat: Count of Students

Advanced

Change in Test Score (T2 - T1) T2Lvl Advanced Proficient

500

Basic Below Basic

Count of Students

Proficient

0

500

Count of Students

Basic

0

500

Count of Students

Below Basic

0

500

0 -18

-16

-14

-12

-10

-8

-6

-4

-2

0

2

4

6

34 Source: DC BAS extract. Rows are test 1 level; colors are test 2 level; columns are change in test score.

8

10

12

14

16

18

20

24

26

CapStat