A7_NCS000249 Durham Stormwater Dashboard

Public Works Department, Water Quality Unit
Fiscal Year 2018-2019 Unit Tracking (Old Director's Report)
Citywide Water Quality Index
83 84
79
74
69
67 66 63
1 1
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of New Water Quality Investigations
FY2018: 367
�335
23 15 35 30 14 35 27 37 26 36 18
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of Notices of Violation/Requirement
FY2018: 162
155 II
Number of Pollution Sources Controlled
FY2018: 186
N PDES
149
14 20 14 18
11 5 7 8 12 10 10
■ = = 1 ■ ■ M ■ M
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of Inspections & Follow-ups
FY2018: 189
21
16 12 12 13 15 9 12 13 16 11 18 - 20 23 12 21 28 33 16 28
, ■ ■ ■ _ ■ E ■ ■ 0 ■ 0 0 M 0 ■ 1 ■ j _
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Jul 1
it
Average number of hours per monitoring site (goal: 1.35 hours)
FY2018: 1.30
1.29
Average number of days to issue an NOV (goal: 3.5 days)
FY2017: 1.92
1.44

Public Works Department, Water Quality Unit
Fiscal Year 2018-2019 Unit Tracking (Investigations Program)
Number of New Water Quality Investigations
FY2018:
FY 2017-
3
66 2019:
335
FY2016:
279
23 15 35 30 14 35 27 37 26 36 18
■ . ■ ■ . ■ ■ ■ ■ ■ ■
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of Inspections & Follow-ups
FY 2017: , F, 2019:
282 , , ' 239
'2011
9
)18:
18 12 20 23 12 21 28 33 16 28
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of Notices of Violation/Requirement
Number of Pollution Sources Controlled
Jul 1
Investigation Efficiency
FY 2017: FY2017: 56%
204 - ' FY2018:
FY2016: 58%
FY2016:186 FY2015: 59%
163 43
FY 2019:
149
11 5 14 7 8 20 18 14 12 10 10
■ _ ■ = . ■ ■ ■ . ■ .
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
#
#
# City
# Car
Enforcement
Training
Employees
Wash
Month
Meetings
Sessions
Trained
Demos
July
0
0
0
0
August
0
0
0
m
September
0
0
0
m
October
0
1
❑ 15
m
November
0
1
0 9
0
December
0
0
0
0
January
0
2
r--Tnr—1
0
February
0
0
0
0
March
0
1
O 29
0
April
r__k
1
=41
E=h
May
0
1
lZ3 34
0
June
m
2
E==
E=h
Total
3
9
314
8
Average Cost per Investigation
Monthly
draft- the
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Average number of days to issue an NOV (Goal: 3.3 days) Fall/Winter Outfall Screening (Group Goal: 225)
FY2017: FY2018
FY2017: 1.92
185
FY2016: 2.7
162
FY 201
:
155
1.44
FY2016:
121
16 7.1 —12 12 13 5 15 9 12 13 16 11
1111 Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
FY2017: 278
FY2016: 275
252
H: �My Documents)Projects)Management�CY20181dashboard play 3a FY2019.x1sx

IIPublic Works Department, Water Quality Unit
Fiscal Year 2018-2019 Unit Tracking (Ambient Program)
Citywide Water Quality Index
87
FY2017: 77 83 84
79
Annual Average 74
67 66 69
III 1 I I H
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Average number of hours per monitoring site (goal: 1.35 hours)
FY2017: 1.39
1.29
Third Fork Creek Water Quality Index (Sustainability Roadmap) 1I Northeast Creek Water Quality Index (Sustainability Roadmap) �
7s
72 Third Fork Creek
67 monitored in Even years,
63 61 except TFI. OTC
I 1 51
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Monitoring Labor Hours
Ambient
Lake
Benthic
Total
FY 2018
Jul
28
50.5
22
_ —
E:I=
85.5
Aug
40
52.5
0
75.5
Sept
28.5
47
0
73.5
Oct
31.5
54.25
0
75.5
Nov
27.75
2
0
—
E:19.75
33
Dec
29.25
0
0
E
E=t9.25
39
Jan
28.5
0
0
M
028.5
43
Feb
25
0
0
0
O 25
29
Mar
Apr
May
Jun
30
28.75
24
24.5
0
41.5
32.5
32
0
0
21.5
5
M
E
_ —
—
O 30
E:=
E::=
r—?M5
39.5
61.75
71.5
73.75
68 Northeast Creek
monitored in Even years
60
50 ,56 55 '
.
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of monitorim locations
Ambient Lake Benthic
CY2019
21
2
6
CY2018
23
3
7
CY2017
21
3
7
CY2016
23
3
7
CY2015
23
3
8
Even year watersheds: Eno, Lick, Little Lick, Little, Northeast Third Fork
Odd year watersheds: Crooked (Southwest), Ellerbe, New Hope, Panther, Stirrup Iron.
i
l 1

Public Works Department, Water Quality Unit
Fiscal Year 2019-2020
iMalware attack followed by COVID19
Aug 24
Number of New Water Quality Investigations
Number of Pollution Sources
Controlled
Number of Inspections & Follow-ups
Number of Notices of Violation/Requirement
FY2017: 366
FY2017: 204
FY 2017: 282
FY2017: 185
FY2018: 3
FY2018:186
FY2018:189
FY2018: 162
FY2019: 335 35
FY2019: 149
FY2019: 239
FY2019: 155
FY 2020:
� 'FY
I� 2020:
FY 2020:
FY 2020:
100
- 66
= 66
210
108
=
25 24 15 16 23 27 6 12 8
18
4
3 0
0 2
18 10 11 9 14 13
_
11 ♦ 14
7
2
. ■
■
2
0 0 1
2 3 4 2 0 2 2
■ - - ■ _ _ _
■ -
—
Jul Aug Oct Nov Dec Jan Feb Mar Apr May Jun
Jul Aug Oct Nov Dec Jan
Feb Mar Apr
May Jun
Jul Aug Sept Oct Nov Dec Jan Feb Mar
Apr May Jun
Jul Aug Oct Nov Dec Jan Feb Mar Apr May Jun
Average number of days to issue an NOV (Goal: 4.0 days)
FY2019:
1.39
Average number of hours per monitoring site (Goal: 1.5
1.25
Citywide Water Quality Index
90 87 90
81
' 77 I
70
66
60
1 I
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
#
#
# City
# Car
Enforcement
Training
Employees
Wash
Month Meetings
Sessions
Trained
Demos
July 0
0
0
4
August 0
1
®
b
September 0
3
October 0
3
®
()
November 0
0
0
December 0
0
0
January 0
0
0
February 0
1
b 10
March 0
0
0
April 0
0
0
p
May 0
0
0
June 0
0
0
Total 2
8
270
0
Fall/Winter Outfall Screening (Group Goal: 125)
FY2019:
FY2018:
Z//
127
Monitoring Labor Hours
Ambient
Lake
Benthic
Total
FY 2019
Stream Determination Requests
July
24
41
0
■
®
100.5
August 22.25 29.5 0 5 92.5
September
36
42
0
■ ■
®
75.5
October 28.75 56.25 0 ■ ® 85.75
November
28.5
1.5
0
■ —
M30
29.75
December 25.5 2 0 ■ — 027.5 29.25
January
29.75
0
0
■
M9.75
28.5
February 30 1 0 ■ — 0 31 25
March 32 9 17.5 ■ — ® 30
April
0
10
0
■
0 10
70.25
May
11
11
0
■ ■
EZI 22
78
2 2
June
11.5
8.5
17
■ �7
61.5
0 0 , 0 , 0 0 0 0 0 0 0
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Cumulativ
�
525.5
706.5
Third Fork Creek WQ Index (Sustainability Roadmap) I Northeast Creek WQ Index (Sustainability Roadmap)
87 86
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
70
56 11
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Number of monitorine locations
Ambient Lake Benthic
CY2020
23
2
7
CY2019
21
2
6
CY2018
23
3
7
CY2017
21
3
7
CY2016
23
3
7
CY2015
23
3
8
COVID19 impact on stream monitoring:
Monitoring was not conducted in April. In May and June, stream monitoring was
reduced to six streamflow sites. Only two of seven stations in the Third Fork Creek
watershed were monitored and the Northeast Creek watershed was not monitored.
June indices are not available due to problems with Cu andn Zn analyses.
Even year watersheds: Eno, Lick, Little Lick, Little, Northeast Third Fork
f�4 YPoPGnkKfi i �'fefi�l�i6A8 flel> i4g rF3�f gayl rW2YR}..Panther, Stirrup Iron.

Public Works Department, Water Quality Unit
Fiscal Year 2020-2021
2021
Number of New Water Quality Investigations
Number of Pollution Sources Controlled
Number of Inspections & Follow-ups
Number of Notices of Violation/Requirement
FY2018:367
FY2018: 186
FY2018: 189
FY2018: 162
FY2019:335
FY2019:149
FY2019:239
:155
FY20FY201919:15
FY2020:210
FY2020:108
FY2020:100
66 '
FY 2021:
i
212
FY 2021:
i
FY 2021
113
76
FY 2021:
93
14 13 0 16 20 12 20 26 20 19 16
5 7 7 6 9 7 10 9 9 11
10 9 12
19 13
10 18 6
5 6
• 3�37�87 8 12 60■
.�'�''
■
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Jul Aug Sept Oct Nov Dec Jan
Feb Mar
Apr May Jun
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Average number of days to issue an NOV (Goal: 4.0 days)
FY2019:*
FY2018:
3.5
Average number of hours per monitoring site (Goal: 1.5
Citywide Water Quality Index
87
79 I I
70
6
61
6_ 5
1 I I
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
#
Enforcement
Month Meetings
#
Training
Sessions
# City
Employees
Trained
# Car
Wash
Demos
July
0
0
0
August
0
0
0
0
September
0
0
0
October
0
0
0
0
November
0
8
®
0
December
0
0
0
{1
January
0
1
0 9
0
February
0
0
0
b
March
0
1
l�
April
0
0
0
0
May
0
0
0
June
0
0
0
Total
1
10
111
0
Monitoring Labor Hours
Ambient
Lake
Benthic
Total FY 2020
July
20
11
2
© 65
August
24
11.5
0
51.75
September
24
13
0
© 78
October
27
9.5
0
I 85
November
24.5
5
0
—
©.5 30
December
26
0
0
=6 27.5
January
29
0
0
I■
29.75
February
26
10
0
® 31
March
24
24
0
® 58.5
April
28
13.5
13
—
— ® 10
May
27.5
17
0
® 22
June
25
11
7
_
— ® 37
Cumulative
_'W
1W
452.5 525.5
Third Fork Creek WQ Index (Sustainability Roadmap)
80 82 82 81
78 79
68 67 70
56 Off -cycle. n 2
50
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Fall/Winter Outfall Screening (Group Goal: 70)
FY2019:
FY2018:
116
Stream Determination Requests
0 0 0 0 0 0 0 0 0 0 0 0
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun
Northeast Creek WQ Index (Sustainability Roadmap) I Number of monitoring locations
I
78
66 68
57 56 1 Off -cycle. n = 0
Ambient
Lake
Benthic
CY2021
22
3
7
CY2020
23
2
7
CY2019
21
2
6
CY2018
23
3
7
CY2017
21
3
7
CY2016
23
3
7
' ' I Even year watersheds: Eno, Lick, Little Lick, Little, Northeast, Third Fork
Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun Odd year watersheds: Crooked (Southwest), Ellerbe, New Hope, Panther, Stirrup Iron.
C: jUsersAmichellewo�OneDrive - City of Durham�Desktop�Copy of H 2O200320IProjectsIManagementICy2020IDashboard play 4 Fy2021.xlsx