HomeMy WebLinkAbout02/04/21 KRGSA AGENDABoard Members:
Rodney Palla, Chair
Gene Lundquist
Bruce Freeman
KERN RIVER GSA
REGULAR MEETING (See attached notice)
Thursday, February 4, 2021
10:00 a.m.
THERE IS NO PHYSICAL LOCATION FOR THIS MEETING
Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/loin/815325021
You can also dial in using your phone.
United States: +1 (872) 240-3311
Access Code: 815-325-021#
AGENDA
1. CALL TO ORDER
2. ROLL CALL
3. PUBLIC STATEMENTS
4. APPROVAL OF MINUTES of the January 7, 2021, Regular Meeting
5. NEW BUSINESS
A. Correspondence received (City Clerk)
B. Finance Updates (Randy McKeegan)
i. Receive and File Financial Report
C. Management Group Updates (Beard, Chianello, Teglia)
i. Water Year 2020 KRGSA GSP Annual Report Update - Todd Groundwater
ii. Kern Subbasin Annual Report / ITRC METRIC ET Cost Share
iii. Subbasin Data Management System Proposals - KRGSA Recommendation
6. COMMITTEE COMMENTS
7. ADJOURNMENT
SPECIAL NOTICE
Public Participation and Accessibility
February 4, 2021 Kern River GSA Meeting
On March 18, 2020, Governor Gavin Newsom issued Executive Order N-29-20, which includes a waiver of Brown
Act provisions requiring physical presence of the Council or the public in light of the COVID-1 9 pandemic.
Based on guidance from the California Governor's Office and Department of Public Health, as well as the County
Health Officer, in order to minimize the potential spread of the COVID-1 9 virus, the City of Bakersfield hereby provides
notice that as a result of the declared federal, state, and local health emergencies, and in light of the Governor's
order, the following adjustments have been made:
1. The meeting of the Kern River GSA scheduled for February 4, 2021, at 10:00 a.m. will have limited public
access.
2. Consistent with the Executive Order, KRGSA Board and Staff may elect to attend the meeting telephonically
and to participate in the meeting to the same extent as if they were physically present.
3. The public may participate in each meeting and address the KRGSA as follows:
• View a live video stream of the meeting at https://global.gotomeeting.com/ioin/815325021
• If you wish to comment on a specific agenda item, submit your comment via email to the City Clerk at
KRGSAa kern riveEgsa.org..no later than 1:00 p.m. prior to the KRGSA meeting. Please clearly indicate
which agenda item number your comment pertains to, comments are limited to 3 minutes.
• If you wish to make a general public comment not related to a specific agenda item, submit your comment
via email to the City Clerk at KRGSA& kern rive[gsa. org no later than 1:00 p.m., prior to the KRGSA
meeting. Comments are limited to 3 minutes.
• Alternatively, you may comment by calling (661) 326-3100 and leaving a voicemail of no more than 3 minutes
no later than 4:00 p.m. the Wednesday prior to the KRGSA meeting. Your message must clearly indicate
whether your comment relates to a particular agenda item, or is a general public comment. If your comment
meets the foregoing criteria, it will be transcribed as accurately as possible. Comments received during the
meeting may not be read, but will be included as part of the permanent public record of the meeting.
KERN RIVER GSA
MINUTES
MEETING OF January 7, 2021
https:Hglobal.gotomeeting.com/ioin/815325021
71 : 7rmmm..
United States: � +1 (87�) 240-3311
Access Code: 815-325-021# 1
1. CALL TO ORDER REGULAR MEETING - 10:00 a.m. ACTION TAKEN
2. ROLL CALL
Present: Chairman Palla,
Board Members Lundquist and Smith
3. PUBLIC STATEMENTS
None
4. APPROVAL OF MINUTES -of the November 5, 2020,
Regular Meeting
Motion by Board Member Lundquist, seconded by APPROVED
Board Member Smith, for approval of minutes.
5. NEW BUSINESS
A. Correspondence Received
None
B. Finance Report
i. Receive and File Financial Report
Randy McKeegan, Finance Director,
made staff comments.
Motion by Board Member Smith, seconded by Board APPROVED
Member Lundquist, to receive and file the financial
report.
Bakersfield, California, January 7, 2021 - Page 2
5. NEW BUSINESS continued ACTION TAKEN
C. Management Group Updates (Beard, Chianello,
Teglia)
i. Prop 68 Grant Round 2 - Subbasin
Coordination and Cost Share
Steve Teglia, General Manager, Kern
Delta Water District, made Staff
comments.
Chairman Palla, made additional
comments.
Patty Poire, Kern Groundwater Authority,
made additional comments.
Motion by Board Member Lundquist, seconded by APPROVED
Board Member Smith, to approve Prop 68 Grant Round
2 - Subbasin Coordination and Cost Share payment.
ii. Update on Subbasin Data Management
System Effort
Steve Teglia, Chief Operating Officer of
Kern Delta Water District, made staff
comments.
Dave Beard, ID4 Manager, made
additional comments.
Chairman Palla, made additional
comments.
6. COMMITTEE COMMENTS
Steve Teglia, General Manager, Kern Delta Water
District, made comments regarding the revised
agenda.
Bakersfield, California, January 7, 2021 — Page 3
7. ADJOURNMENT
Chairman Palla adjourned the meeting at 10:21 a.m.
Chair of the Kern River
Groundwater Sustainability Agency
ATTEST:
SECRETARY of the Kern River
Groundwater Sustainability Agency
Bakersfield, California, January 7, 2021 — Page 4
***THIS PAGE INTENTIONALLY LEFT BLANK***
Kern River GSA
Report of Receipts and Disbursements
for the 2020-21 Fiscal Year
Report information as of January 28, 2021
Beginning Balance of KRGSA Trust as of July 1, 2020 $ 596,746.52
Receipts
Date
Amount
Received
Received from:
Received
Amount
7/28/2020
Greenfield GSA
Member Fee
11,824.74
10/13/2020
Kern Groundwater Authority
Grant Share
4,927.72
10/15/2020
Olcese Water District
Grant Admin
1,064.92
11/5/2020
Buena Vista Water Storage Distict
Grant Admin
1,064.92
11/9/2020
Henry Miller Water Storage
Grant Admin
1,064.92
12/14/2020
Kern Groundwater Authority
Grant Admin
21,292.31
Total Receipts in this Fiscal Year
11/5/2020*
$ 41,239.53
Disbursements
* - date disbursement reported to KRGSA Board
S:\Accounting\KRGSA\report of receipts and disbursements January 2021- Trust Activity - FY 20-21
Authorized
Date
COB Check
Amount
for payment
Paid
Payee
Number
Paid
by KRGSA on:
8/4/2020
Horizon Water & Environmental
711239
2,304.23
9/3/2020*
8/27/2020
Todd Groundwater
712123
10,601.70
9/3/2020*
9/10/2020
Olcese Water District
71266
372.87
11/5/2020*
9/10/2020
Henry Miller Water Storage
71620
1,908.65
11/5/2020*
9/10/2020
Kern Groundwater Authority
712637
172,604.64
11/5/2020*
9/10/2020
Buena Vista Water Storage Distict
712571
3,502.30
11/5/2020*
10/1/2020
Horizon Water & Environmental
713437
21636.71
11/5/2020*
10/22/2020
Westside Water Authority
714473
10,295.46
11/5/2020*
11/19/2020
Todd Groundwater
715886
9,000.90
1/7/2021*
12/3/2020
Todd Groundwater
716412
9,525.25
1/7/2021*
1/7/2021
Todd Groundwater
717913
2,898.75
1/14/2021
Horizon Water & Environmental
718079
11493.45
Total Disbursements in Fiscal
Year
$ 227,144.91
Balance in KRGSA Trust as of report date
$ 410,841.14
(city trust account:
Fund 618)
$ 0.00
* - date disbursement reported to KRGSA Board
S:\Accounting\KRGSA\report of receipts and disbursements January 2021- Trust Activity - FY 20-21
Kern River GSA
Contract Monitoring Worksheet
Report information as of January 28, 2021
Aereement # 16-001 - Horizon Water & Environment LLC
Scope 4
$ 49,620.00
Scope 4 - Prop 68 Grant App
Acct. 19.043
Amount
Paid
Remaining
Contract
Balan
$ 49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM - Horizon 1/28/20218:16 AM
Amount
Date
Notes
Scope 1
Scope 2
Scope 3
Original Contract
$ 194,000.00
August 4, 2016
$199,733.32
$ 82,000.00
$ 89,263.00
Amendment #1
$ 82,000.00
Feb. 1, 2018
Grant Application
Amendment rig
$ 89,263.00
May 3, 2018
Grant Administation
Amendment k3
$ 49,620.00
Prop 68 App
Amendment #4
$ 5,733.32
March S, 2020
GSP Plan
$ 420,616.32
Scope 1-GSA/GSP (20805)
Scope 2- Grant
Application
Scope 3- Grant
Admin.i208-09j
Acct. 16.036
Acct. 17.022
Acct.
18.020
Authorized
Remaining
Remaining
Remaining
Date
COB Check
Invoice
for payment
Amount
Contract
Amount
Contract
Amount
Contract
Paid
Number
Number
by KRGSA on
Paid
Balance
Paid
Balance
Paid
Balance
Beginning Balance
$ 199,73332
$ 82,00000 '..
$ 89,263.00
12/2/2016
651494
1887
12/1/2016
$ 1,508.84
198,224.48 '..
$ -
82,000 00
$ -
89,263.00
2/10/2017
654461
1994
2/2/2017
7,434.19
190,79029 '..
82,00000
89,263.00
6/9/2017
659813
2125
6/1/2017
3,933.73
186,856.56
82,000 00
89,263.00
7/21/2017
661850
2258
7/13/2017
7,556.23
179,300.33
82,000 00
89,263.00
9/15/2017
664192
2310
9/7/2017
6,243.69
173,056 64
82,000 00
89,263.00
9/15/2017
664192
2332
9/7/2017
18,489.96
154,566.68
82,000 00
89,263.00
10/13/2017
665404
2418
10/5/2017
11,770.43
142,796.25
82,000 00
89,263.00
12/15/2017
668122
2459
12/7/2017
-
142,796 25
18,974.18
63,025 82
89,263.00
12/15/2017
668122
2467
12/7/2017
4,246.16
139,550.09
63,025 82
89,263.00
12/15/2017
668122
2501
12/7/2017
-
138 SSO 09 '..
44,825.60
18,200 22
89,263.00
2/9/2018
670500
2546
2/1/2018
3,481.05
135,069 04
18,200 22
89,263.00
2/9/2018
670500
2557
2/1/2018
-
135,069.04
17,881.04
319.18 '..
89,263.00
2/9/2018
670500
2586
2/1/2018
2,058.42
133,010 62 '..
319.18 '..
89,263.00
4/13/2018
673428
2710
4/5/2018
1,637.45
131,373.17
319.18
89,263.00
4/13/2018
673428
2761
4/5/2018
2,574.96
128,798.21
319.18
89,263.00
5/11/2018
674720
2818
5/3/2018
2,115.03
126,683 18
319.18 ''..
89,263.00
6/15/2018
676259
2878
6/7/2018
5,035.13
121,648.05
319.18
89,263.00
6/15/2018
676259
2911
6/7/2018
121,648.0S
319.18
3,909.00
85,354.00
8/10/2018
678844
2959
8/2/2018
4,705.64
116,942 41
319.18
85,354.00
8/10/2018
678844
2958
8/2/2018
116,942.41
319.18
5,219.56
80,134.44
9/14/2018
680452
3029
9/6/2018
S,S32.98
111,409.43
319.18
80,134.44
9/14/2018
680452
3032
9/6/2018
111,409 43
319.18
2,530.56
77,603.88
10/12/2018
681851
3100
10/4/2018
4,027.79
107,381.64
319.18
77,603.88
11/16/2018
683333
3155
11/8/2018
9,072.02
98,309 62
319.18
77,603.88
12/14/2018
684455
3230
11/8/2018
3,359.13
94,950.49
319.18
77,603.88
1/18/2019
685915
3281
1/10/2019
-
94,950.49 '..
319.18
5,965.12
71,638.76
1/18/2019
685915
3291
1/10/2019
3,234.36
91,716 13 ''..
319.18
71,638.76
1/18/2019
685915
3337
1/10/2019
6,120.85
85,595.28
319.18
71,638.76
3/15/2019
688388
3418
3/12/2019
-
85 S95 28 ''..
319.18
3,002.35
68,636.41
4/12/2019
689632
3480
4/4/2019
3,479.31
82,115 97 '..
319.18
-
68,636.41
4/12/2019
689632
3520
4/4/2019
-
82,115.97
319.18 '..
2,698.63
65,937.78
5/10/2019
690810
3516
5/2/2019
8,265.03
73 850 94
319.18
65,937.78
6/14/2019
692547
3691
6/6/2019
1,285.40
72,S65.54
319.18
65,937.78
7/19/2019
694131
3736
7/11/2019
72,565.54
319.18
22,267.48
43,670.30
Scope 4
$ 49,620.00
Scope 4 - Prop 68 Grant App
Acct. 19.043
Amount
Paid
Remaining
Contract
Balan
$ 49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
49,620.00
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM - Horizon 1/28/20218:16 AM
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM - Horizon 1/28/20218:16 AM
Scope 1-GSA/GSP(20805)
Scope 2- Grant Application
Scope 3- Grant
Admin.(208-09)
Scope 4 -Prop 68 Grant App
Acct. 16.036
Acct. 17.022
Acct.
18.020
Acct. 19.043
Authorized
Remaining
Remaining
Remaining
Remaining
Date
COB Check
Invoice
for payment
Amount
Contract
Amount Contract
Amount
Contract
Amount
Contract
Paid
Number
Number
by KRGSA on
Paid
Balance
Paid Balance
paid
Balance
Paid
Balance
7/19/2019
694131
3749
7/11/2019
4,990.64
67,57490 !
319.18
43,670.30
49,620.00
7/19/2019
694131
3676
7/11/2019
6757490
31918
3,401.84
40,268.46
49,620.00
7/19/2019
694131
3676
7/11/2019
67,574.90
319.18
40,268.46
49,620.00
8/29/2019
695740
3891
8/21/2019
3,941.28
63,633.62
319.18
40,268.46
49,620.00
8/29/2019
695740
3894
8/21/2019
63,633.62
319.18
11,823.23
28,445.23
49,620.00
10/17/2019
697899
3970
10/3/2019
63,633 62 '..
319.18 '..
2,769.93
25,675.30
49,620.00
10/17/2019
697899
3956
10/3/2019
10,514.03
53,119.59
319.18
25,675.30
49,620.00
12/19/2019
700645
4010
12/5/2019
11,793.21
4132638
31918
25,675.30
49,620.00
12/19/2019
700645
4052
12/5/2019
41,326 38
319.18 '..
1,039.99
24,635.31
49,620.00
1/16/2020
701627
4104
1/9/2020
12,958.51
2836787
31918
24,635.31
49,620.00
1/16/2020
701627
4101
1/9/2020
2836787
31918
24,635.31
19,520.00
30,100.00
1/16/2020
701627
4100
1/9/2020
28,36787
319.18
13,969.52
10,665.79
30,100.00
2/13/2020
702944
4169
2/6/2020
19,351.32
901655
31918
10,665.79
30,100.00
3/5/2020
703920
4254
6/4/2020*
901655 '..
31918 ''.
5,251.40
5,414.39
30,100.00
3/5/2020
703920
5255
6/4/2020*
9,016.55
319.18 '..
5,414.39
8,381.24
21,718.76
5/1/2020
706266
4381
6/4/2020*
901655 '..
31918
5,414.39
2,508.19
19,210.57
5/1/2020
706266
4382
6/4/2020*
9,01655 '..
31918
4,451.20
963.19
19,210.57
5/28/2020
707302
4253
6/4/2020*
9,016.55
(0.00)
319.18 '..
963.19
19,210.57
8/4/2020
711239
4502
9/3/2020*
(0.00)
319.18
962.98
0.21
19,210.57
8/4/2020
711239
4503
9/3/2020*
(0.00) '..
319.18
0.21
1,341.25
17,869.32
10/1/2020
713437
4750
11/5/2020'
(0.00)
319.18 '..
0.21
2,636.71
15,232.61
1/14/2021
718079
4942
2/4/2021*
(0.00)
319.18
0.21
1,493.45
13,739.16
(0.00)
319.18 ',.
0.21
13,739.16
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM - Horizon 1/28/20218:16 AM
11/10/2016
650665
Scope 1
11/3/2016
Date
Amount
Original Contract
August 4, 2016
$ 360,000.00
Amendment #1
April 6, 2017
$ (36.00)
Amendment #1
April 6, 2017
62306-02-17
Amendment #2
Sept. 6, 2018
$ 36.00
Amendment #2
Sept. 6, 2018
6/9/2017
Amendment #3
April 4, 2019
$ 173,029.00
Amendment #4
Jan.9,2020
$ 32,761.00
$ 1,187,747.00
7/21/2017
$ 565,790.00
62307-05-17
Authorized
Acct. (62306)
Date COB Check Invoice
for payment
Amount
Paid Number Number
by KRGSA on:
Paid
11/10/2016
650665
62306-9-16
11/3/2016
12/2/2016
651513
62306-10-16
12/1/2016
2/10/2017
654488
62306-11-16
2/2/2017
4/14/2017
657389
62306-02-17
4/6/2017
6/9/2017
659826
62306-03-17
6/1/2017
6/9/2017
659826
62306-04-17
6/1/2017
7/21/2017
661879
62306-05-17
7/13/2017
7/21/2017
661879
62307-05-17
7/13/2017
9/15/2017
664209
62306-06-17
9/7/2017
9/15/2017
664209
62307-06-17
9/7/2017
9/15/2017
664209
62306-07-17
9/7/2017
9/15/2017
664209
62307-07-17
9/7/2017
10/13/2017
665471
62306-08-17
10/5/2017
10/13/2017
665471
62307-08-17
10/5/2017
12/15/2017
668157
62306-09-17
12/7/2017
12/15/2017
668157
62307-09-17
12/7/2017
12/15/2017
668157
62306-10-17
12/7/2017
12/15/2017
668157
62307-10-17
12/7/2017
2/9/2018
670509
62306-11-17
2/1/2018
2/9/2018
670509
62307-11-17
2/1/2018
2/9/2018
670509
62306-12-17
2/1/2018
2/9/2018
670509
62307-12-17
2/1/2018
3/9/2018
671936
62307-04-17
3/1/2018
3/9/2018
671936
62306-01-18
3/1/2018
3/9/2018
671936
62307-01-18
3/1/2018
4/13/2018
673441
62306-02-18
4/5/2018
4/13/2018
673441
62307-02-18
4/5/2018
5/11/2018
674747
62307-03-18
5/3/2018
6/15/2018
676276
62306-03-18
6/7/2018
6/15/2018
676276
62306-04-18
6/7/2018
6/15/2018
676276
62307-04-18
6/7/2018
8/10/2018
678868
62306-05-18
8/2/2018
$ 2,256.25
15,436.42
754.30
6,360.40
10,255.60
9,080.05
15,855.15
11,480.76
6,052.13
1,927.30
12,770.02
19,612.75
8,967.85
10,009.75
32,415.05
29,575.55
42,854.09
9,899.04
29,028.50
Kern River GSA
Contract Monitoring Worksheet
Scope 3
Report information as of January 28, 2021
Acct. (62307)
Agreement # 16-00 - Todd Groundwater
Scope 2 Scope 3
Amount
Amount Amount
Notes
Balance
Paid
Balance Paid
Scope 1 adjust-
$ 431,957.00 $ -
Scope 2 amendn-
$ 431,957.00
Scope 1 adjust-
$ 190,000.00
Scope 3 amendn-
Scope 1
Scope 2
Scope 3
GSA/GSP
Acct. (62307)
Sub -basin Modeling Acct. (62306)
Contract
Amount
Contract Amount
Contract
Balance
Paid
Balance Paid
Balance
$ 565,790.00
$ 431,957.00
$ 190,000.00
563,533 75
431,957.00
190,000.00
548,097 33
431,957.00
190,000.00
547,343 03
431,957.00
190,000.00
540,982 63
431,957.00
190,000.00
530,727 03
431,957.00
190,000.00
521,646 98
431,957.00
190,000.00
505,791 83
431,957.00
190,000.00
505,79183
13,244.20
418,712.80
190,000.00
494,311 07
418,712.80
190,000.00
494,31107
19,361.80
399,351.00
190,000.00
488,258 94
399,351.00
190,000.00
488,258 94
5,012.80
394,338.20
190,000.00
486,331 64
394,338.20
190,000.00
486,33164
6,626.95
387,711.25
190,000.00
473,561 62
387,711.25
190,000.00
473,56162
9,702.25
378,009.00
190,000.00
453,948 87
378,009.00
190,000.00
453,948 87
3,391.00
374,618.00
190,000.00
444,981 02
374,618.00
190,000.00
444,98102
3,322.15
371,295.85
190,000.00
434,971 27
371,295.85
190,000.00
434,97127
2,495.95
368,799.90
190,000.00
434,97127
5,678.35
363,121.55
190,000.00
402,556 22
363,121.55
190,000.00
402,556 22
12,300.70
350,820.85
190,000.00
372,980 67
350,820.85
190,000.00
372,980 67
16,977.06
333,843.79
190,000.00
372,980 67
15,554.50
318,289.29
190,000.00
330,126 58
318,289.29
190,000.00
320,227 54
318,289.29
190,000.00
320,227 54
30,834.85
287,454.44
190,000.00
291,19904
287,454.44
190,000.00
Scope 1 amendn-
Scope 1 amendn-
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM -Todd 1/28/20218:16 AM
* - date disbursement reported to KRGSA Board
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM -Todd 1/28/20218:16 AM
Scope 1
Scope 2
Authorized
'.. Acct. (62306)
GSA/GSP
'.. '.. Acct. (62307)
Sub -basin Modeling
Acct. (62306)
Date
COB Check
Invoice
for payment
Amount
Contract
Amount
Contract
Amount
Paid
Number
Number
by KRGSA on:
Paid
Balance
Paid
Balance
Paid
8/10/2015
678868
62307-05-18
8/2/2015
291,19904
34,263.00
253,191.44
8/10/2018
678868
62306-06-18
8/2/2018
18,102.83
273,09621
253,191.44
8/10/2018
678868
62307-06-18
8/2/2018
273,096 21
28,326.97
224,864.47
9/14/2018
680462
62306-07-18
9/6/2018
21,552.22
251,543 99
224,864.47
9/14/2018
680462
62307-07-18
9/6/2018
251,543 99
44,568.85
180,295.62
10/12/2018
681868
62306-08-18
10/4/2018
24,348.77
227,19522
180,295.62
10/12/2018
681868
62307-08-18
10/4/2018
227,19522
33,997.62
146,298.00
11/16/2018
683354
62306-09-18
11/8/2018
21,405.22 pp
205,790 00
146,298.00
3,220.85 pp
11/16/2018
683354
62307-09-18
11/8/2018
205,790 00
32,255.42
114,042.58
12/14/2018
684474
62306-10-18
12/6/2018
205,790 00
114,042.58
16,628.05
12/14/2018
684474
62307-10-18
12/6/2018
205,790 00
51,501.56
62,541.02
1/18/2019
685939
62306-11-18
1/10/2019
205,79000
62,541.02
17,142.40
1/18/2019
685939
62307-11-18
1/10/2019
205,790 00
34,877.97
27,663.05
2/15/2019
687153
62306-12-18
2/7/2019
205,790 00
27,663.05
12,040.60
2/15/2019
687153
62307-12-18
2/7/2019
205,790 00
19,928.70
7,734.35
3/15/2019
688415
62306-12-18
3/12/2019
205,790 00
7,734.35
21,215.36
3/15/2019
688415
62307-12-18
3/12/2019
205,790 00
3,711.33
4,023.02
4/12/2019
689644
62306-2-19
4/4/2019
205,790 00
4,023.02
16,756.85
5/10/2019
690828
62306-3-19
5/2/2019
205,790 00
4,023.02
36,917.21
5/10/2019
690828
62307-3-19
5/2/2019
205,790 00
3,601.30
421.72
6/14/2019
692563
62306-4-19
6/6/2019
205,790 00
421.72
37,683.32
7/19/2019
694142
62306-5-19
7/11/2019
205,790 00
421.72
20,525.11
7/19/2019
694142
62307-5-19
7/11/2019
205,790 00
1,673.50
(1,251.78)
8/8/2019
694906
62306-6-19
8/1/2019
9,238.60
196,55140
(1,251.78)
7,870.25
8/29/2019
695840
62306-7-19
8/21/2019
24,791.60
171,759 80
(1,251.78)
10/17/2019
698026
62306-8-19
10/3/2019
33,786.67
137,97313
(1,251.78)
12/19/2019
700761
62306-9-19
12/5/2019
7,286.73
130,686 40
(1,251.78)
12/19/2019
700761
62306-10-19
12/5/2019
27,229.60
103,456 80
(1,251.78)
1/16/2020
701771
62306-11-19
1/9/2020
18,150.65
85,30615
(1,251.78)
2/13/2020
703068
62306-12-19
2/6/2020
13,177.11
72,12904
(1,251.78)
72,129 04
(1,251.78)
* - date disbursement reported to KRGSA Board
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM -Todd 1/28/20218:16 AM
Kern River GSA
Contract Monitoring Worksheet
Report information as of January 28, 2021
Aereement # 19-003- Todd Groundwater
'- dale disbursement reported to KRGSA Board
S:\A--ng\KRGSA\rep tofr-ptzand d.,-smenisJanua V2021-CM-Todd_2
Scope 4
Scope S
Scope 6
Date
Amount
Amount
Amount
N. -
0,,g Contract (KGA)
Feb. 7, 2019
$ 241,385.00
C2VSim Model
Ong Contract (KRGSA)
Feb. 7, 2019
$ 94,383.00
C2VSim Model
Original Contract
Jan. 9, 2020
$ 40,000.00
GSP Implementation
Original Contract
Sept3,2020
$ 150,000.00
Tech Support GSP
$ 375,768.00
$ 335,768.00
$ 40,000.00
$ 150,000.00
Scope 4
Scope 5
Scope 6
Authorxed
A-.(62309)
'.. 4cct. (62311)
Acct.(62311)
Date
COB Check
Invoice
for payment
Amount
Contract
Amount
Contract
Amount
Contract
Paid
Number
Number
by KRGSA on
Paid
Balanc
Pald
Balanc
Paid
Balanc
Begnning Balance
$ 335,768.00
$ 40,000.00
$ 150,000.00
3/15/2019
688415
62307-12-18
3/12/2019
335 768 00
40,000M
150,000.00
3/15/2019
688415
62308-1-19
3/12/2019
14,991.51
320,]]649
40,00000
150,000.00
3/15/2019
688415
62308-1-119
3/12/2019
11,124.68
30965181
40,00000
150,000.00
4/12/2019
689644
62308-2-19
4/4/2019
11,]95.76
297,356 05
40,000 00
150,000.00
4/12/2019
689644
62308-1-219
4/4/2019
5,461.71
292,39428
40,00000
150,000.00
5/10/2019
690828
62308-3-19
5/2/2019
22,16].03
270,22]25
40,00000
150,000.00
5/10/2019
690825
62308-1-319
5/2/2019
8,667.58
26155967
40,00000
150,000.00
6/14/2019
692563
62308-4-19
6/6/2019
14,532.85
24702682
40,00000
150,000.00
6/14/2019
692563
62308-1-419
6/6/2019
15,279.15
231,]526]
40,00000
150,000.00
7/19/2019
694142
62308-5-19
7/11/2019
15,901.92
215,850 75
40,000 00
150,000.00
7/19/2019
694142
62308-1-519
7/11/2019
0,90.55
20594120
40,00000
150,000.00
8/8/2019
694906
62308-6-19
8/1/2019
27,9012,17
1]802903
40,00000
150,000.00
8/8/2019
694906
62308-1-619
8/1/2019
11,133.25
166,89578
40,00000
150,000.00
8/29/2019
695840
62308-7-19
8/21/2019
29,290.45
13760533
40,00000
150,000.00
8/29/2019
695840
62308-1-719
8/21/2019
10,177.15
127,428 18
40,00000
1501000.00
10/17/2019
698026
62308-1-819
10/3/2019
41851.33
122,57685
40,00000
150,000.00
10/17/2019
698026
62308-8-19
10/3/2019
27,145.75
95,43110
40,00000
150,000.00
12/19/2019
700761
62308-9-19
12/5/2019
17,906.05
]752505
40,00000
150,000.00
12/19/2019
700761
62308-1-919
12/5/2019
4,167.40
73 357 65
40,000 00
150,000.00
12/19/2019
700761
62308-10-19
12/5/2019
10,230.SS
63,12]10
40,00000
150,000.00
12/19/2019
700761
62308-1-109
12/5/2019
4,773.03
5835407
40,00000
150,000.00
1/16/2020
701771
62308-11-19
1/9/2020
24,729.71
3362436
40,00000
150,000.00
1/16/2020
701771
62308-1-119
1/9/2020
3,379.65
3024471
40,00000
150,000.00
2/13/2020
703068
62308-12-19
2/6/2020
],095.10
23,14961
40,00000
150,000.00
2/13/2020
703068
62308-1-129
2/6/2020
1,454.20
2169541
40,00000
150,000.00
3/5/2020
704031
62308-120
6/4/2020"
9,681.10
12 014 31
40,000 00
150,000.00
3/S/202a
704031
62308-1-120
6/4/202 a'
3,070.90
8,94341
40,00000
150,000.00
3/5/2020
]04031
62311-120
6/4/2020'
8,94341
5,660.40
34,33960
150,000.00
4/3/2020
705308
62311-220
6/4/2020'
894341
12,536.10
21,50350
150,000.00
4/24/2020
706083
62311-420
6/4/2020'
894341
7,378.60
14,12490
150,000.00
S/22/2020
70]102
62308-1-420
6/4/2020'
280.50
8,662 91
14,124 90
150,000.00
5/22/2020
707102
62308-520
6/4/2020'
3,866.50
479641
14,12490
150,000.00
6/11/2020
708941
62311-520
9/3/2020`
3,510.75
128566
14,12490
150,000.00
8/28/2020
712123
62311-720
9/3/2020'
1285 66
7,746.30
6,3]8 60
150,000.00
8/28/2020
712123
62311-B20
9/3/2020'
1,285 66
2,855.40
3,523 20
150,000.00
11/19/2020
715886
62311-1020
1/7/2021'
1 285 66
3,523.20
5,477.70
144,522.30
12/3/2020
716412
62311-1120
1/]/2021"
128566
9,52525
134,997.05
1/7/2021
717913
62311-1220
2/4/2021'
1,285 66
2,898.75
132,098.30
1,285 66
132,098.30
'- dale disbursement reported to KRGSA Board
S:\A--ng\KRGSA\rep tofr-ptzand d.,-smenisJanua V2021-CM-Todd_2
Kern River GSA
Contract Monitoring Worksheet
Report information as of January 28, 2021
Kern Groundwater Authority - authorized letter from KRGSA - Sept. 1, 2016
Amount Date Notes
Original Contract $ 55,685.00 Sept. 1, 2016 letter agreement
Remaining
flat. rnR 1-h-1, I --i— A --t r—t—t
Authorized
for payment
by KRGSA on:
beginning balance
6/9/2017
659815
2017-05
$ 31,146.00
24,539.00
6/1/2017
12/15/2017
668129
2017-35
$ 12,272.00
12,267.00
12/7/2017
5/11/2018
674733
2018-39
$ 10,430.82
1,836.18
5/3/2018
Kern Groundwater Authority - authorized letter from KRGSA - May 3, 2018
Amount
Date
Notes
Original Contract
$ 9,535.44
May 3, 2018
letter agreement
Remaining
Authorized
Date
COB Check
Invoice
Amount
Contract
for payment
Paid
Number
Number
Paid
Balance
by KRGSA on:
Beginning Balance
$ 9,535.44
8/10/2018
678848
2018-69
$ 9,683.76
(148.32)
8/2/2018
Kern Groundwater Authority - authorized letter from KRGSA - January
10, 2019 (#19-001)
Amount
Date
Notes
Original Contract
$ 10,278.35
Jan. 10, 2019
letter agreement
Remaining
Authorized
Date
COB Check
Invoice
Amount
Contract
for payment
Paid
Number
Number
Paid
Balance
by KRGSA on:
Beginning Balance
$ 10,278.35
3/15/2019
688391
2019-03
$ 10,278.35
-
3/12/2019
S:\Accounting\KRGSA\report of receipts and disbursements January 2021CM - KGA 1/28/20218:16 AM
K E R N
GROUNDWATER
1iNM. THOM
ITY
January XX, 2021
To: Kern River GSA
Buena Vista WSD GSA
Henry Miller WD GSA
Olcese WD GSA
Re: Cost Share Agreement for 2021 Annual Reporting of the Kern County Subbasin
The Kern Groundwater Authority (KGA), the Kern River Groundwater Sustainability Agency
(KRGSA), the Buena Vista WSD Groundwater Sustainability Agency (BVGSA), the Henry Miller
WD Groundwater Sustainability Agency (HMGSA), and the Olcese WD Groundwater
Sustainability Agency (OGSA) wish to participate in the cost share agreement for the Kern
County Subbasin — 2021 annual reporting requirement under SGMA.
On behalf of the Subbasin, the above mentioned GSAs agreed to continue to use TODD
Groundwater as the consultant to assist in the preparation of the 2021 annual report since
TODD Groundwater was the consultant who assisted in the 2020 annual report and also was
the consultant of record on the basin wide water model (C2VSim) that was used in compliance
in the groundwater sustainability plans (GSP) and also ITRC who provided the metric data for
the demand component for the annual report.
The TODD Groundwater proposal includes a scope of work that will have the following scope of
work tasks as well as updating the water model (C2VSim) in preparation for the 2025 GSP
update for an amount not to exceed $99,875:
1) Coordinate with Local Agencies on Data Requests
2) Prepare Groundwater Elevation Contour Maps
3) Review and Compile Hydrographs
4) Compile and Present Water Supply Data
5) Analyze Change in Groundwater in Storage and Groundwater Extraction
6) Document Progress in GSP Implementation
7) Prepare Administrative Draft, and Final Annual Report and Submit to DWR
8) Communications and Meetings
The ITRC proposal include a scope of work that will have the following scope of work tasks for
an amount of $13,500:
1) Provide monthly and annual ITRC-METRIC actual crop evapotranspiration (ETc) for the Kern
Subbasin for water year 2020.
1800 30th Street, Suite 280, Bakersfield, CA 93301 • Tel: (661) 479-7171 • Fax: (661) 616-5890 • www.kerngwa.com
Page 2 of 2
2) Data will be extracted for each GSA within the subbasin and each irrigated field in each GSA
monthly for water year 2020
3) Data will be provided tabularly and monthly ETC images will be provided in GIS format
4) Short report discussing the general process will be provided
All parties agree to cost share this effort according to the following terms and conditions:
1) The participant signatories below will pay their share of the proposed budget of
$113,375.00 as shown in Exhibit 1.
2) All payments shall be due 45 days after the receipt of the invoice from the KGA
Please sign and date this letter and return to the KGA.
Sincerely,
KGA
Accepted:
Kern River GSA
Title:
Date:
Henry Miller WD GSA
By:
Title:
Buena Vista WSD GSA
Title:
Date:
Olcese WD GSA
By:
Title:
Date: Date:
0000000 uumoou
V� IW
D000000wuW
G 1111Z 1110 IIIIJ IIIsIi Illi '''lllll'lllll .Iu' !il ""'r Illfllll:- Illi
January 25, 2021
I IC
To: Kern Groundwater Authority (KGA)
Patty Poire, Kern County Subbasin GSP Plan Manager
From: Phyllis Stanin, Vice President
Michael Maley, Principal Hydrogeologist
Re: Proposal — Preparation of GSP Annual Report for WY2020
Kern County Subbasin Groundwater Sustainability Plans (GSP)
The Kern Groundwater Authority (KGA) is leading Subbasin-wide coordination efforts for
implementation of Groundwater Sustainability Plans (GSP) including annual reporting. Subbasin
GSAs are cooperating in preparation of the second GSP Annual Report covering Water Year (WY)
2020 for the Kern County Subbasin. Todd Groundwater has been asked to prepare a proposal to
prepare and submit the WY2020 Annual Report.
The Kern County Subbasin submitted adopted GSPs covering the entire Subbasin to the
Department of Water Resources (DWR) on January 31, 2020. Annual Reports are due to DWR
"by April 1 of each year following the adoption of the Plan" (§356.2). To meet the April 1
deadline, the schedule for the WY2020 Annual Report will be highly compressed with the
technical work occurring primarily in February and early March. As occurred in preparation of
the first annual report, we assume cooperation from the Kern County Subbasin Groundwater
Sustainability Agencies and Management Areas (GSA/MA) to provide required data and
information by the requested target dates to meet the submittal deadline.
1 APPROACH
Todd Groundwater successfully prepared and submitted the WY2019 Annual Report to DWR on
April 1, 2020. We will use this experience to further streamline and expedite the production of
the WY2020 Annual Report. Collectively, the extensive analyses and hydrogeologic products
developed for the previous (WY2019) Annual Report provide a firm foundation for the WY2020
Annual Report. Monitoring sites have already been identified, data are being collected, and
water budget results are readily available from WY1995 through WY2019. We envision working
cooperatively with Subbasin agencies and their consultants to compile and incorporate
information that either is currently available or is being collected as part of GSP implementation.
Preparation of the WY2020 Annual Report will follow regulatory guidance. Regulatory
requirements for the GSP Annual Reports are provided in Article 7 of the GSP regulations (§
356). Reporting standards for Annual Report data are provided in Article 3 (§352.4) and
2490 Mariner Square Loop, Suite 215 1 Alameda, CA 94501 1 510 747 6920 1 toddgroundwater.com
reporting provisions can be found in Article 4 (§353.4). Regulations require historical data for
hydrographs and change in groundwater in storage. Additional data, including reporting of
groundwater extractions, surface water, and total water use by sectors, apply only to the
preceding year and not the historical period.
For this second annual report, we propose to update the C2VSimFG-Kern model for WY2020,
consistent with the technical approach used in the first annual report. For that first report, the
model provided an efficient tool to develop numerous regulatory -required analyses. Specifically,
the model was used to develop change in groundwater in storage (maps and tables), a map of
groundwater extractions, and the four primary DWR templates for Water Use. Use of the model
for each of these analyses provided technically credible results that were internally consistent
and also consistent with those presented in Subbasin GSPs. As with the previous update, the
WY2020 update will require provision of numerous data types and sources from more than 40
Subbasin agencies. Although the update for the 2nd Annual Report only requires data from one
water year, it will continue to be a challenge to incorporate data from so many entities and
activities into the model in time for the required analyses. We assume cooperation and timely
provision of requested water management data to support this process, as occurred for the first
annual report.
As with the previous model update, we assume provision of evapotranspiration (ET) data from
satellite imagery that covers the entire Subbasin, such as the METRIC data relied on previously
for model development. It is our understanding that KGA will provide timely ET data in formats
similar to previous datasets for use in the model.
Also consistent with the WY2019 Annual Report, we propose that Subbasin-wide water level
contour maps be developed by Kern County Water Agency (KCWA) for Fall 2019 and Spring
2020. KCWA has been developing similar water level contour maps across the Subbasin for
decades, providing consistency with historical and recent interpretations. Todd Groundwater
will coordinate and assist KCWA with data and information to incorporate these maps into the
WY2020 Annual Report.
It is our understanding from the Subbasin Plan Manager, Patty Poire, that DWR is also
requesting inclusion of information on inelastic land subsidence and water quality in the
WY2020 Annual Report. We assume that such information will be provided from Subbasin
agencies for incorporation into the Annual Report. We will work with DWR and the Plan
Manager to determine how best to present and summarize this information.
Todd Groundwater will work closely with the Subbasin Plan Manager (Patty Poire) to coordinate
workflow, data compilation, and review. It is our understanding that the Plan Manager will also
coordinate communications with DWR and ensure that individual GSA/MAs comply with data
requests in a timely manner.
Proposal - WY2020 Annual
Report, Kern County Subbasin 2 TODD GROUNDWATER
2 SCOPE OF SERVICES
Tasks associated with the proposed scope of services are summarized below. Todd Groundwater
intends to follow the same approach and methodology for the WY2020 to maintain consistency
in methodology and presentation.
Task 1: Coordinate with Local Agencies on Data Requests
The first step in this process involves development of a data request memorandum by Todd
Groundwater, which will provide a list of data requirements from all Subbasin agencies and
include data templates to facilitate data compilation and presentation. Todd Groundwater will
provide the data request memorandum and templates to the Subbasin GSAs/MAs, following
similar procedures as used for the WY2020 Annual Report to begin the data collection process.
Data requests will cover the update of the C2VSimFG-Kern model as well as other components
of the WY2020 Annual Report. Todd Groundwater will download the well and water level data in
the Kern County Subbasin that currently resides on the SGMA portal. If agencies wish to
supplement portal data with additional well/water level data to use in the required hydrographs
or water level contour maps, those data will need to be collected as soon as possible following
the data request.
The issuance of a data request memorandum and associated templates are tentatively
scheduled for the first week in February assuming a timely notice to proceed. Todd
Groundwater will coordinate with the Plan Manager on this data request. Todd Groundwater
will also be available to answer questions from individual GSA/MA staff or otherwise facilitate
the request. In order to meet the DWR deadline, a response date of February 16 is planned for
all data submittals.
Task 2: Prepare Groundwater Elevation Contour Maps
DWR requires the posting of monitoring data to the SGMA portal every six months. The
groundwater level data for Fall 2019 and Spring 2020 have already been posted online. Todd
Groundwater will collect and compile portal data for preparation of groundwater elevation
contour maps (and required hydrographs). As mentioned above, if agencies want to supplement
the reported data with additional water levels for the contour maps, we will need those data
submitted by the February 16 deadline.
As was done for the WY2019 Annual Report, Todd Groundwater will coordinate with Michelle
Anderson of the KCWA to develop the Fall 2019 and Spring 2020 groundwater elevation maps.
The two KCWA maps will represent the primary Principal Aquifer over the entire Kern County
Subbasin.
Three other Principal Aquifers have been defined in the Subbasin. For the WY2019 Annual
Report, insufficient data was available to develop maps of these maps. Todd Groundwater will
coordinate with the local agencies that defined these local Principal Aquifers in their GSPs to
obtain data, maps, and input on the state of the data for these Principal Aquifers. The best
Proposal - WY2020 Annual
Report, Kern County Subbasin 3 TODD GROUNDWATER
available data for Fall 2019 and Spring 2020 for these local Principal Aquifers will be included in
the WY2020 Annual Report.
Task 3: Review and Compile Hydrographs
In compliance with regulatory requirements, a series of hydrographs will be prepared for GSP
network wells across the Subbasin and included as an appendix in the WY2020 Annual Report.
As noted above, groundwater level data for Fall 2019 and Spring 2020 have already been posted
to the online portal and will be compiled for development of the groundwater hydrographs. If
agencies wish to supplement the hydrographs with additional water level data other than what
has been uploaded to the SGMA portal, we request receipt of those data immediately following
the data request. Hydrographs will be formatted to adhere with the Data and Reporting
Standards as prescribed in §352.4(e) of the GSP regulations. In brief, each hydrograph should
include a unique site identification number, ground surface elevation, and use the same scale to
the greatest extent practical.
We will develop hydrographs that use similar graphical formats including the same horizontal
scale of October 1, 1994 through September 30, 2020 (WY 1995 — WY 2020). Closely -spaced
hydrographs will incorporate similar vertical scales to the extent practicable in adherence with
GSP regulations. Hydrographs may also include annotations to allow for easy well identification
and understanding by DWR reviewers. Hydrographs will include the minimum threshold and
measurable objective for each map; therefore, any updates to these values will need to be
provided by the reporting GSA/MA.
The hydrographs will present overall trends and fluctuations for WY 1995 through WY 2020 will
be described briefly in the context of water year type and the groundwater elevation contour
maps. A map showing the location of submitted hydrographs will be developed and PDF files of
each hydrograph will be included in an appendix of the Annual Report.
Task 4: Compile and Present Water Supply Data
DWR provides four required templates documenting water types, sources, and use within the
Subbasin. Working with the individual agencies, Todd Groundwater will compile water supply
data for the following categories:
• Groundwater Extractions tabulated by water use sector (generally Urban, Agricultural,
Managed Recharge, and Other).
• Groundwater extraction measurement methods and accuracy.
• Surface Water Supply tabulated by water use source type.
• Total Water Use.
Todd Groundwater will provide similar data templates as provided for the WY2019 Annual
Report to facilitate the data collection. In accordance with guidance from Article 7 of the GSP
regulations, Todd Groundwater will compile and review data from more than 40 GSAs, member
agencies, and other entities throughout the Subbasin who contributed data in support of the
Proposal - WY2020 Annual
Report, Kern County Subbasin 4 TODD GROUNDWATER
previous Annual Report. Reported data will be reviewed for consistency with the previous
templates and with information provided for the model update.
These data will be compiled into the appropriate DWR Water Budget Tables that will be
uploaded separately to DWR along with this Annual Report. Each of the main budget data types
will be summarized in the Annual Report along with a brief data description using a similar
format as was used for the previous Annual Report.
Task 5: Analyze Change in Groundwater in Storage and Groundwater Extraction
GSP regulations (§ 356.2 (b)(5)(13)) for the Annual Report require both a map and graph of
changes in groundwater in storage and groundwater extraction be developed over the entire
groundwater basin that meet the following requirements:
• Graphs depicting the annual and cumulative change in groundwater in storage "based
on historical data to the greatest extent available, and
• "Change in groundwater in storage maps for each principal aquifer in the basin".
Todd Groundwater will develop change in groundwater in storage maps and graphs for the
entire Kern County Subbasin using the C2VSimFG-Kern model. By doing so, we continue to
update and use the primary DWR modeling tool with our local Kern County updates for
evaluating basin conditions. For this task, we will use a methodology consistent with that used
to develop change in groundwater storage graphs for the previous Annual Report to maintain
consistency of method in presenting the basinwide change in groundwater in storage.
For this task, we will request WY2020 data from each district for measured managed water
supply and demand data following the methodology used to update the C2VSimFG-Kern model
for the Kern County historical water budgets. To meet the Annual Report schedule, Todd
Groundwater needs this data no later than February 16, 2021. We will provide data templates
to each district to provide monthly data for the following:
• Surface water imports and diversions (inflows and outflows) by source
• Application of surface water imports by category (e.g., irrigated agriculture, urban,
managed aquifer recharge, or other uses).
• Groundwater banking and managed aquifer recharge by water district or agency,
• Groundwater banking pumping for export from the basin,
• Metered district groundwater recovery pumping,
• Metropolitan Bakersfield urban water deliveries and wastewater disposal, and
• Any other locally relevant water supply use or demands.
Todd Groundwater will update the natural hydrology for precipitation and flows in gauged
streams (Kern River and Poso Creek). Precipitation data will be updated using publicly -available
precipitation data from the PRISM Climate Group at Oregon State University. The monthly
rainfall data for Kern County for WY2020 will be mapped into C2VSimFG-Kern input files. The
Kern River and Poso Creek streamflow for WY2020 will be updated based on locally measured
weir data.
Proposal - WY2020 Annual
Report, Kern County Subbasin 5 TODD GROUNDWATER
Kern County GSAs will also separately contract with the Irrigation Training & Research Center
(ITRC) at Cal Poly San Luis Obispo to deliver evapotranspiration (ET) using remote sensing data
across the entire subbasin for determining agricultural demand for WY 2020. Todd
Groundwater will utilize the ITRC ET data to develop ET rates for Kern County for this period for
model input. To meet this Annual Report schedule, this data needs to be delivered to Todd
Groundwater no later than February 16, 2021.
The updated C2VSimFG-Kern subbasin-wide results will be appended to the previous C2VSimFG-
Kern results for WY 1995 — WY 2019. One annual change in groundwater storage map and one
groundwater extraction map will be developed for WY2020 for the entire Kern County Subbasin
using the updated C2VSimFG-Kern subbasin-wide results. Map generation will follow
methodology similar to that used for the WY2019 Annual Report.
Task 6: Document Progress in GSP Implementation
For this section, Todd Groundwater will coordinate with individual GSA/MAs to obtain
descriptions and information relating to GSP implementation plans and progress. The WY2020
Annual Report we will need to document the following:
• Any ongoing activities toward plan implementation that agencies that have occurred in
2020, especially those towards meeting GSP Projects and Management Actions.
• A brief discussion on the collection of the preceding year monitoring data.
• A discussion to address any exceedances of minimum thresholds that occurred in 2020
and what actions, if any, were taken as a result.
• Any changes to the monitoring network or definition of sustainability indicators.
• Any other actions that document significant steps toward GSP implementation.
A general template will be provided to each GSA/MA to use as a guideline for reporting GSP
progress. These templates will be reviewed, and any questions will be directed to the reporting
GSA/MA. The final GSP Implementation summaries will be compiled into the WY2020 Annual
Report.
In addition, it is our understanding that DWR has communicated with the Plan Manager
regarding inclusion of information on land subsidence and groundwater quality. At this time, we
anticipate incorporating that information into subsections of the Progress on GSP
Implementation section of the Annual Report.
Task 7: Prepare Administrative Draft, Draft, and Final Annual Report and Submit to DWR
Preliminary results will be prepared for review by Subbasin agencies in early March to allow
time for agency input. It is recognized that the preliminary results will contain deficiencies, but
the early release will allow comments on analysis methods and results prior to finalization of the
technical analysis.
A Draft Final Annual Report will be provided by mid-March to provide a near-complete
document for agency review and comment. A Final Draft will also be available prior to submittal
Proposal - WY2020 Annual
Report, Kern County Subbasin 6 TODD GROUNDWATER
for any last-minute minor additions or corrections. The target for the Final Draft is March 19.
The period from March 19 to March 30 will be to address any remaining data deficiencies,
address comments, and review the report for compliance with DWR regulations. Todd
Groundwater will coordinate with the Plan Manager on submittal of the report prior to the
deadline of April 1.
Task 8: Communications and Meetings
As indicated above, there will be a need for communication with Subbasin GSAs and KGA
member agencies to obtain comparable data across the entire Subbasin for inclusion in the
WY2020 Annual Report. Communications will include individual calls/emails with Subbasin
agencies, conference calls during periodic meetings of GSA managers, and video conference
meetings to present progress to date and discuss outstanding items or issues.
To expedite the process, Todd Groundwater will coordinate directly with the Subbasin Plan
Manager, Patty Poire, to ensure timely data compilation, review, and incorporation of the
required analyses to meet GSP Annual Report requirements. In particular, any questions or
contacts with DWR regarding clarifications of Annual Report requirements will be coordinated
through the Subbasin Plan Manager.
For budget and planning purposes, three teleconference meetings are assumed as part of this
scope. Because of the large number of attendees, the KGA Managers Meetings — typically held
on Friday mornings — will be used as a forum for data requests, discussion, and comments
regarding the Annual Report preparation process. These four meetings, along with the primary
objectives and tentative dates, are summarized as follows:
• Video Conference No. 1: Provide overview of preliminary results for the WY2020 Annual
Report and discuss how to address any remaining deficiencies; tentatively scheduled for
March 5, 2021.
• Video Conference No. 2: Present results included in the Draft Final Annual Report to
provide overview for managers prior to their review; tentatively scheduled for
March 19, 2021.
• Video Conference No. 3: Discuss comments and any other remaining issues regarding
the Draft Final Annual Report; tentatively scheduled for March 26, 2021.
3 BUDGET AND SCHEDULE
Execution of the scope of work described herein is estimated to cost $99,875. This cost estimate
is considered a not -to -exceed estimate and Todd Groundwater will not exceed this cost without
written authorization from KGA. In addition, work will be conducted on a time and materials
basis and only the costs expended will be invoiced. Last year, Todd Groundwater did not spend
the full budget amount, providing cost savings to the Subbasin managers. The budget has been
lowered this year, but also covers time needed for new items and ongoing coordination with
agencies to account for ongoing changes to the GSP monitoring networks. Table 1 shows costs
by task, along with estimated labor hours and rates.
Proposal - WY2020 Annual
Report, Kern County Subbasin 7 TODD GROUNDWATER
Due to the compressed schedule for the WY2020 Annual Report, our work on the Annual Report
data requests will immediately (late January). Todd Groundwater will be supported by a
dedicated technical team to work on developing the WY2020 Annual Report in February and
March in order to meet the regulatory submittal date of April 1, 2020. These team members
worked on the first GSP Annual Report and are all familiar with the Kern County Subbasin and
GSP data.
Please let us know if you have questions regarding this proposal. For the WY2020 Annual
Report, time is of the essence, and we stand ready to move the effort forward as soon as
possible.
Proposal - WY2020 Annual
Report, Kern County Subbasin 8 TODD GROUNDWATER
"ngbllla, t: 2020 AirtirtuaIll IRarpoirt,II e� iriuluouwiult uwIG Ib asiliulu °"odd Groundwater
Proposal - WY2020 Annual Report, Kern County Subbasin 9 TODD GROUNDWATER
oaoC
Pnncipal
Pnncipal
Project
senior
start
Total
2%
GIS/
Admin
Other
10%
Task
Review
PM
Modeler
Engineer
Engineer
Hydrogen
Labor
Total
Comm
Graphics
Costs
Direct
Expense
Total
$245
$255
$NO
$235
$235
$145
Hours
Labor
Fee
$135
$125
Costs
Fee
Costs
1 Prepare and Coordinate Data
Request Process
0
6
6
8
2
0
22
$ 5,320
$ 106
$ -
$
$ -
$ 5,426
2 Prepare Groundwater Elevation
Contour Maps
0
4
0
8
0
0
12
$ 2,900
$ 58
$ 810
$
$ -
$ 3,774
3 Review and Compile Hydrographs
0
4
0
28
0
12
44
$ 9,340
$ 187
$ 1,080
$
$ -
$ 10,615
4 Compile and Present Water
Supply Data
0
4
16
0
0
20
40
$ 7,760
$ 155
$ -
$
$ -
$ 7,915
5 Analyze Change in Groundwater
in Storage
0
0
60
8
0
0
68
$ 16,280
$ 326
$ 2,160
$
$ -
$ 18,782
6 Document GSP Progress
0
12
4
0
10
20
46
$ 9,270
$ 185
$ -
$ -
$ -
$ -
$ 9,455
7 Prepare Drafts/Final Annual
Report and Submit to DWR
4
32
28
12
6
24
106
$ 23,570
$ 471
$ 5,400
$
$ -
$ 29,481
8 Management, Communication and
Meetings
0
32
16
0
0
0
48
$ 12,000
$ 240
$ 1,620
$ 500
$ 50
$ 14,426
Project Budget
4
94
130
64
18
76
386
$ 86,440
$ 1,729
$ 11,070
$ -
$ 500
$ 50
$ 99,875
Proposal - WY2020 Annual Report, Kern County Subbasin 9 TODD GROUNDWATER
moving ivaterinnew directions Agreement for ITRC-METRIC 2020
Date: 1/12/2021
To: Patty Poire, Planning Manager
Kern Groundwater Authority
P. ii_L @_kiringa_.c r, Mobile: (661)706-1989
From: Dan Howes, Ph.D., P.E.
Project Manager/Senior Engineer
Irrigation Training and Research Center
Cal Poly/ San Luis Obispo, CA 93407
Cell: 858-354-0504
djhowesff call oll .edu
Subject: Proposal for ITRC-METRIC evapotranspiration for Kern Subbasin (2020)
This proposal is being submitted to Kern Groundwater Authority (KGWA) by the Irrigation Training and Research
Center (ITRC) at Cal Poly State University, San Luis Obispo.
Update of ITRC-METRIC 2020 Water Year and Calendar Year
ITRC will provide monthly and annual ITRC-METRIC actual crop evapotranspiration (ETc) for the Kern Subbasin for
2020. The following items will be completed:
1. Data will be extracted for each GSA within the subbasin and each irrigated field in each GSA monthly for
2020. We will also provide the data for parcels/fields (larger than 5 acres).
2. Data will be provided tabularly and monthly ETc images will be provided in GIS format.
3. Short report discussing the general process and overall results will be provided.
Cost: $13,500
sliver les
ETc data in tabular (MS EXCEL) and other formats (such as imager) provided on a flash drive or file transfer service.
Tirnefine for Project
The report and data will be provided within 1 month from the time the agreement is signed.
Contract
The person responsible for technical aspects of this contract will be:
Dan Howes
Project Manager, Irrigation Training and Research Center
Cal Poly
San Luis Obispo, CA 93401-0730
djhowes@calpoly.edu
IRRIGATION TRAINING & RESEARCHCENTER
California Polytechnic State University
San Luis Obispo, CA 93407-0730
Phone: 805.756.2434 FAX: 805.756.2433 www.itrc.org
- 1 -
The contract will be administered by:
Cal Poly Corporation
Building #15
One Grand Avenue
San Luis Obispo, CA 93407
Note: Dr. Howes should be the contact person.
Budget
The total budget is a fixed price Fee for Service of $13,500. The full amount will be invoiced when the draft results
are transmitted to KGWA. The Cal Poly Corporation requests that a KGWA representative agree to the Standard
Terms and Conditions, which are attached to this proposal. The signed approval can be scanned and submitted via e-
mail to Dan Howes.
Invoicing n Payment
ITRC will submit to KGWA (Patty Poire), an invoice of the full fixed cost when transmitting the draft results.
Payment should be made payable to "Cal Poly Corporation" and sent to:
Dr. Dan Howes
Irrigation Training and Research Center (ITRC)
One Grand Ave
Bldg 8A
California Polytechnic State University
San Luis Obispo, CA 93407-0730
AuthorizationlApprovai
Name of authorized ITRC representative: Daniel Howes
Signature of ITRC representative
Named of authorized Kern GWA representative: Patty Poire
Signature of the representative:
Irrigation Training & Research Center
-2-
date
1/12/21
date
Irrigation Training & Research Center (ITRC)
Standard Terms and Conditions
THIS AGREEMENT is between the Kern Groundwater Authority ("Client") and the Cal Poly Corporation, a separate
non-profit auxiliary organization for the California Polytechnic State University, hereinafter referred to as "ITRC."
1) Ordering: Clients may order services (specify a "Scope of Work") by submitting a written purchase order, a
written request for services, by sending confirming e-mail, or by placing a telephone order. The Client must
subsequently confirm all telephone orders in writing or via e-mail confirmation prior to commencement of work.
2) Change Orders: A Client may request additions or changes to an Order, but must be confirmed by written notice.
Email is an acceptable form of writing. The Client will remain responsible for all work performed under the
original agreement up until the time ITRC is officially notified of the change.
3) Suspending or Stopping ITRC's Performance: The Client may direct ITRC to suspend a portion or all of the work
to be performed. In such case, the Client will remain responsible for all work performed up until the time ITRC
became aware of Client's desire to discontinue the services. Any uncompleted services in progress at the time
of discontinuation will be billed on a prorated basis, as determined by ITRC.
4) Confidentiality: ITRC shall keep documents and information identified by Client as confidential to the extent
permitted by law, and will not disclose any such information to third parties. ITRC may publish announcements
and summaries containing non -confidential information about this project in campus newsletters and annual
report and other published documents on campus.
5) Warranties: Client understands that ITRC performs services only as specified by Client in the Services
Agreement accepted by ITRC. ITRC does not make any express or implied warranties or guarantees of any kind
to the Client. By their very nature, technical services, testing, analysis and other ITRC services are limited to
expected measurement variability. ITRC represents that the Services shall be performed within the limits agreed
with Client, and in a manner consistent with the level of care and skill ordinarily exercised by other providers of
similar services under similar circumstances.
6) Ownership of Data: Data or information provided to ITRC by the Client shall remain the Client's property. Upon
full payment to ITRC for all services provided by ITRC, data or information generated by ITRC for the Client shall
become the Client's property. ITRC will retain exclusive ownership of any and all analytical methods, Quality
Assurance/Quality Control protocols, and equipment developed by ITRC for performance of work by ITRC. ITRC
Reports are for the exclusive use of the Client to whom they are addressed. The name of ITRC, Cal Poly
Corporation, or California Polytechnic State University, or any symbols of them are not to be used by Client
without prior written approval by the appropriate authorized representative.
7) Indemnification: Client and ITRC agree that by performing services hereunder, ITRC does not assume, shorten,
cancel or undertake to discharge any duty or responsibility of Client to any other party or parties. No one other
than Client shall have any right to rely on any Report or other representation or conduct of ITRC, and ITRC
disclaims any obligations of any nature whatsoever with respect to such person. Client and ITRC agree, in
consideration of ITRC under -taking to perform the ordered service(s) to protect, defend, indemnify, same
harmless and exonerate each other from any and all claims, damages, expenses, either direct or consequential
for injuries to persons or property arising out of or in consequence of the performance of the services hereunder
unless caused by the sole negligence of the other party.
8) Insurance: Cal Poly Corporation maintains insurance coverage for its employees to perform professional
services. If Client seeks greater protection than is provided by Cal Poly Corporation insurance, Client should
obtain appropriate protection from suppliers or insurers.
9) Limitation of Liability: If ITRC should be found liable for any losses or damages attributable to the services
hereunder in any respect, its liability shall in no event exceed the amount of the fee paid by Client for such
services and Client's sole remedy at law or in equity shall be the right to recover up to such amount.
10) Force Majeure: Whenever performance by either party is delayed or prevented by an extraordinary event
beyond the control of Client or ITRC, such delay or prevention shall be excused and the time of performance
extended for the duration of the causative factor. In no event shall the occurrence of any such conditions excuse
the Client of its obligations hereunder if services have been performed by ITRC.
11) Payment of Invoices: Client agrees to pay all invoices to ITRC within 30 days of invoice date, and if payment is
not timely received, the Client agrees to pay a late payment charge on the unpaid balance at the maximum
allowed by law.
12) Governing Law: This Agreement shall be governed in accordance with the laws of the State of California.
Irrigation Training & Research Center
-3-
SI'
G E I Pi����n
Consulranrs
Eo,H
December 3, 2020
G-sr.:pNing Patty Poire
F?ngiricr. rs and Kern Groundwater Authority
Scicridses 1800 30`h Street, Suite 280
Bakersfield, CA 93301
Subject: Proposal for the Kern Subbasin Data Management System
Dear Ms. Poire:
GEI Consultants, Inc. (GEI) submits the attached proposal for development of a web -based Data Management
System (DMS) for the Kern Subbasin (Subbasin). Our proposal recommends building upon the existing GEI
SGMA DMS platform to create a custom Kern Subbasin DMS with the objectives of meeting current needs,
accommodating future needs, and supporting long-term water management in the Subbasin.
GEI's experience includes in-house development of web -based water management DMSs since 2006 and
design and development of Sustainable Groundwater Management Act (SGMA) web tools since 2015. GEI's
SGMA experts collaborate with our internal Information Management group of over 15 programmers to
deliver specialized web applications which are designed based on SGMA and GSP Regulations and compliance
requirements. Our relevant experience includes developing SGMA web tools for the California Department of
Water Resources (DWR) and providing SGMA support to over 20 local agencies. Many of our SGMA-
specific tools built for DWR can be seen on the SGMA Portal at https://sgma.water.ca.gov/portal/.
Our existing GEI SGMA DMS has a web -based interface that is user-friendly with intuitive and easy-to-use
analysis tools for technical staff and managers. It facilitates efficient data management and displays quantitative
values in meaningful formats (i.e., tables, graphs, maps). The existing GEI SGMA DMS includes many
functions to address the reporting and data visualization needs for each of SGMA's six sustainability indicators.
Existing capabilities and recommended enhancements are summarized in the enclosed proposal and a detailed
list is provided in Appendix A. The modular framework of our platform allows for expansion to address the
complex coordination and management needed within the Kern Subbasin.
We understand that this is a grant -funded project with a firm limit on the funds available to develop the Kern
Subbasin DMS. Because there are a significant number of options to consider, GEI will work with the
Groundwater Sustainability Agency (GSA) managers to select which new elements to prioritize. This is an
important step of the process to ensure managers' needs are heard and the scope and scale of all customizations
are appropriate and budgeted for. Based on our initial conversations with GSA managers regarding some of
desired enhancements to be included in the Kern Subbasin DMS, we have developed a list of potential
additional elements (see Appendix B of the proposal) to meet those needs. The primary goals of the
recommendations are as follows:
Provide a single repository for water management data to serve numerous purposes at the various levels
of water management within the Subbasin
• Maintain flexibility for expansion to support individual district and landowner decision making
• Satisfy SGMA data management and reporting requirements at the KGA, GSA, and district levels
ww gciCon srrl9arlr S.COM GEI Consultants, Inc.
5001 California Avenue, Suite 120, Bakersfield, CA 93309
661.327.7601 fa_x:661.327.0173
0 Streamline multi -agency annual reporting for SGMA
Upon completion, the Kern Subbasin DMS will belong to the KGA and will be accessible to agencies and
landowners in the Kern Subbasin. The existing GEI SGMA DMS platform empowers our clients to import
and export data from the powerful database without the need for additional consultant support while
remaining flexible to accommodate additional expansions. Our client -defined permissions are assigned based
on roles and responsibilities of the water managers who will use the system. In addition to providing a user's
manual, staff trainings are proposed to maximize the usefulness of the Kern Subbasin DMS.
We believe the significant time invested to develop the existing GEI SGMA DMS platform puts us in an ideal
position to develop a customized Kern Subbasin DMS that provides a multifunctional database useful to
managers, technical staff, and landowners. GEI will begin building the Kern Subbasin DMS from a point
where much of the heavy lifting is already done. This enables us to concentrate our time on invaluable
management tools, such as data collection and aggregation from local agencies for SGMA annual reporting and
district -level dashboards, which will provide the best value for the Subbasin.
Sincerely yours,
GEI Consultants, Inc.
fleaA,^-1 xt�i4j 4-14"4-
Stephanie
Hearn Michael J. Cor elius
Project Manager Vice President / Principal -in -Charge
Kern Subbasin DMS
Contents
Kern Subbasin DMS
El SGM.A Expertise
GEI Consultants Inc. (GET) has led extensive statewide water planning, groundwater
ME management, and groundwater recharge projects in California for over 50 years. Most recently
VG� C� f„ to support compliance with the Sustainable Groundwater Management Act (SGMA), GEI is
assisting with policy and technical aspects for many Groundwater Sustainability Plan (GSP)
efforts, including those for critically overdrafted groundwater subbasins in Kern and Tulare counties. Our
statewide experience includes providing SGMA program support services to the California Department of Water
Resources (DWR). Our current efforts include leveraging our hydrogeologic, engineering, and water management
expertise to support GEI's in-house Information Management group as they help state and local agencies meet
the information and data management requirements of SGMA. This combined experience of our SGMA
professionals with our programming and visualization specialists has formed a powerful team that understands
how groundwater information and data will be used to comply with SGMA. Together, we created the GEI SGI\LA
Data Management System (DMS) for practitioners to support improved local water resource management.
GEI's data management experience includes over 15 years of developing web -based DMS platforms and, since
2015, the design and development of DMS platforms specifically designed to meet the requirements of SGMA.
Our existing GET SGMA DMS was created as a modular framework that allows for easy expansion to address
data management needs and the additional complex coordination and management needed by water managers in
the Kern Subbasin (Subbasin). As shown in our demonstrations of the existing GEI SGMA DIMS, our platform
is easy to use and intuitive. The existing GET SGMA DMS retrieves data from public online open sources as well
as private data from local agencies and includes the ability to compare data from different wells on the same
graph. Our existing GEI SGMA DMS provides a very strong and stable starting point for customizing the Kern
Subbasin DMS.
Project Understanding
The Kern Groundwater Authority (KGA) has a grant agreement (Grant Agreement No. 4600012955) with DWR
for development of a Kern Subbasin DMS which must meet SGMA requirements. The minimum requirements
specified in the agreement are: to coordinate with GSAs in the Subbasin to identify the data types and sources
required to monitor GSP implementation, evaluate groundwater conditions, and document progress towards
sustainability. General guidance from the SGMA regulations' regarding data management include:
• § 352.6. Data Management System: Each Agency shall develop and maintain a data management
system that is capable of storing and reporting information relevant to the development or implementation
of the [Groundwater Sustainability] Plan and monitoring of the basin.
352.4. Data and Reporting Standards: (c)(3) well information used to develop the basin setting shall
'Water Code Sections 10727.2, 10727.6, 10728, 10728.2, 10733.2, 10733.8
GEI Consultants, Inc. 2 Kern Groundwater Authority
Kern Subbasin DMS
be maintained in the Agency s data management system.
• § 354.40. Reporting Monitoring Data to the Department: Monitoring data shall be stored in the
data management system developed pursuant to Section 352.6. A copy of the monitoring data shall be
included in the Annual Report and submitted electronically on farms provided by the Department.
Grant Agreement No. 4600012955 identifies numerous activities which must be undertaken during development
of the Kern Subbasin DMS. Table 1 identifies some of those general development activities and the current status
of those activities in the existing GEI SGMA DMS. As shown on Table 1, many activities are at various levels of
completion or were already completed in earlier stages of development. Many of these completed activities require
considerable time and effort to fully implement. Because GEI already completed many of these activities, we will
not have to start from scratch to create the Kern Subbasin DMS. This enables us to use most of the available
grant funds to build upon our existing system to customize a Kern Subbasin DMS with additional new
functionality identified as the highest priorities by the GSA managers and decision makers.
In addition to getting more value from the available grant budget, using the existing GEI SGMA DMS platform as
a starting point leverages our experience to start months and maybe years ahead of teams that do not have this as
a starting point. Additionally, using the existing platform allows the project to be completed within the grant
schedule that includes an end date of April 30, 2022.
Table 1 -General DMS Development Activities Identified in KGA-DWR Grant Agreement
Grant -Identified Activities
Status of Activities in
existing GEI SGMA DMS platform
Develop a Data Management System (DMS).
DONE; — Start with GEI SGMA DMS platform
which was demonstrated for GSA managers and
decision makers.
Coordinate with GSAs within the subbasin to
In Progress — GEI developed this proposal based
identify goals and basin needs for ongoing data
on feedback provided from our demonstration
management.
presentations. A kickoff or project scoping
meeting is anticipated to confirm goals and basin
data management needs with GSA managers and
decision makers, which will be documented in
the Kern Subbasin Work Plan. This workplan can
then be shared with DWR to meet the grant
agreements requirements.
Coordinate with GSAs in the subbasin to identify
In Progress — GEI to meet with GSA Managers
the data types and sources required to monitor
and decision makers to identify customized
GSP implementation, evaluate groundwater
functions and priorities for this grant. These will
conditions, and document subbasin progress
be addressed in the kickoff meeting.
toward sustainability.
Investigate and compare available DMS packages.
DONE; — Completed by GSA Managers and
decision makers in October/November 2020.
Design the selected DMS and customize as
DON]E`, — Start with existing GEI SGMA DMS
needed.
Platform and customize to meet the needs of the
Kern Subbasin DMS.
GEI Consultants, Inc. 3 Kern Groundwater Authority
Kern Subbasin DMS
Grant -Identified Activities
Status of Activities in
existing GEI SGMA DMS platform
Hold various coordination efforts with DWR on
To do as .needled— The initial step will be to
the DMS to interact.
provide DWR the Kern Subbasin DMS
Workplan.
Develop data templates that allow each GSA or
DONE; — Data input templates and data export
participating agency to submit the required data to
templates are already developed for existing data
meet DWR reporting requirements.
sets. New templates will be developed as needed.
Develop and implement protocols and a quality
DON .p; — QA/QC protocols are included in the
assurance/quality control (QA/QC) process for
data input templates to reduce input of incorrect
DMS security.
formats of data and flag those entries. Security is
already integrated into the GSI SGMA DMS
platform at the application level and system level.
This includes individual login credentials for
each user.
Develop a functional user's manual that describes
In Progress — Portions of a user's manual have
templates, outlines DMS protocols, and provides
been developed for some of the functions in the
step-by-step procedures.
existing GEI SGMA DMS. As customization is
conducted for the Kern Subbasin DMS, the
user's manual will be updated.
Conduct trial runs of the DMS to address
In Progress — Already completed and debugged
functional issues. Hold various coordination
for existing modules. GEI already has regular
efforts with DWR on the DMS.
communications with DWR staff regarding our
work on DWR's data management tools and has
a strong working relationship with DWR staff.
Coordination for the Kern Subbasin is expected
to be seamless.
Develop a Data Management System (DMS).
In Progress — Additional grant -funded work to
fully customize the added features for the Kern
Subbasin DMS to support local water
management needs.
GEI Consultants, Inc. 4 Kern Groundwater Authority
Kern Subbasin DMS
While the GSP Regulations allow for the DMS to be a spreadsheet or a desktop database, we envisioned a system
that is a powerful water management tool, designed specifically around the six sustainability indicators of SGMA.
While the focus of the DMS is to meet the requirements of SGMA, it has additional capabilities that go beyond
those listed in the previous section from the GSP Regulations and is expandable to meet additional water
management needs. The existing GEI SGMA DMS platform is a web -based interface that provides GSA
managers and decision makers the ability to spend more time evaluating and understanding the data, rather than
moving it around between multiple sources and programs to create useful information. Our user-friendly system
displays data in a meaningful format that can be used to inform decision makers, regulators, stakeholders, and the
general public. Using the GEI SGMA DMS platform as the starting point for the DMS customization, the Kern
Subbasin DMS will provide the following benefits:
• Empowers district staff to fully understand their data and information
• Saves time in conducting routine tasks
• Provides flexibility and responsiveness to address questions
• Allows `What if questions to be answered
• Allows the easy comparison of data at different wells
• Serves as a repository for `institutional knowledge' about historic conditions in basin
• Provides a centralized and secure platform for data and information
• Includes a user's manual and training to support those using the Kern Subbasin DMS
• Enables GSAs and districts to be more self-reliant in data and information needs
• Streamlines data entry into the DMS by offering field -data collection tools and automated water quality
data entry from labs
• Improves QA/QC of data prior to import to DMS
• Supports other regulatory reporting requirements
• Includes cloud -based backup for enhanced data security
• Improves data confidence
• Supports model data management and model development
Map Viewer with. Sustain.a.bility Indicator Data
The existing GEI SGMA DMS platform is structured around SGMA's six sustainability indicators: groundwater
levels, groundwater storage, water quality, land subsidence, interconnected surface water, and seawater intrusion.
A wide variety of additional data and GIS coverages are already included in the GEI SGMA DMS to provide
additional understanding and meaning to the SGMA-required information. Some of the existing elements and
potential enhancements that may be added to the Kern Subbasin DMS are described below by sustainability
indicator and presented in more detail in Appendix A — Existing SGMA DMS Elements and Appendix B —
Potential Added Elements for Customized Kern Subbasin DMS. The final list of new elements to be added to
GEI Consultants, Inc. 5 Kern Groundwater Authority
Kern Subbasin DMS
create the Kern Subbasin DMS will be created based on discussions with the GSA managers and decision makers
and based upon their priorities.
Groundwater IL v l ( IL)
Existing Features
Various sources of public data for the Kern Subbasin have been downloaded into our DMS platform to enable
visualization tools such as the groundwater level monitoring network and groundwater contours mapping. On the
map viewer, users simply scroll over the network of wells to get a pop-up image of each hydrograph to quickly
check the number of observations at the well. When the hydrograph feature is selected, the detailed well
hydrograph with color coded water years in the background and aerial images of the well location is shown and,
for Representative Monitoring Sites (RMS), minimum thresholds and measurable objectives are displayed. A key
feature of our DMS hydrographs is the ability to overlay data for multiple wells on one graph to compare trends
and interpret impacts of localized pumping.
Recommended Enhancements
To improve the completeness of this module, it is recommended to upload non-public data for sites defined in
each District's Chapter of the GSP. To enhance the ability to compare data, it is recommended to add an element
to overlay water quality trends on the existing hydrographs, including the associated sustainable management
criteria. Some functions should also be expanded such as the ability for permissioned users to import GIS layers;
to select groundwater wells and observation periods and generate water level contours on -the -fly; to create
groundwater well profile / cross-section diagrams; and the ability to search and query by well name, ID,
observation date, or owner name. A detailed list of recommendations is included in Appendix B.
Groundwater Story
Existing Features
The Groundwater Storage module includes similar features as water level, plus the ability to select C2VSIM layers
(boundary, elements, nodes, small watersheds, stream reaches, subregions).
Recommended Enhancements
To add interactivity with the groundwater model, it is recommended to add an element to visualize selected input
and output data from C2VSIM model and summarize C2VSIM estimates of subsurface flow between model
subregions within Kern Subbasin and between neighboring subbasins (historic and projected model runs).
Another element to consider is to present the change in storage from C2VSIM model outputs at the subregion
level for historic and projected model runs. A detailed list of recommendations is included in Appendix B.
Existing Features
Like the groundwater levels module, publicly available water quality data was uploaded for the groundwater
monitoring network in the Kern County Subbasin. Currently, water quality data includes a simple trendline for a
single selected water quality parameter for individual wells. If the well is part of the GSP-designated monitoring
network, sustainability indicators are displayed on the trend graph (minimum threshold, measurable objective, and
interim milestones).
Recommended Enhancements
To enhance the ability to compare data, an additional element is recommended for comparison of trends of
multiple wells or multiple parameters on a single graph. For example, within a monitoring network, a sentinel well
GEI Consultants, Inc. 6 Kern Groundwater Authority
Kern Subbasin DMS
may be designated to indicate increasing arsenic trends for an area. Ha,,Ting the ability to overlay trends between
multiple wells with the sustainability indicators could allow users to identify early warning signs of triggering an
exceedance. In other scenarios, it may be beneficial to overlay multiple parameters that have consistent or inverse
trends: this new element would allow users to easily evaluate the relationship between water levels and water
quality. Looking into the future, having the ability to compare trends between wells may also provide insight on
how deep salt and nitrate are sinking into the aquifer. This could be accomplished by comparing wells that have
similar construction features but different screened intervals. A detailed list of recommendations is included in
Appendix B.
ILand Tu l i n
Existing Features
The land subsidence module imports data from DWR and USGS extensometers as well as TRE Altamira InSAR
and NASA JPL Instar datasets. The land subsidence monitoring network displays on a map where users can view
details including the rate of subsidence plotted on a trend graph, measurements over time, and aerial images of
station locations.
Recommended Enhancements
No recommended enhancements specific to the Kern County Subbasin.
Interconnected Ssur r
Existing Features
Users can view the interconnected surface water monitoring network in a map view as well as data from
precipitation and gage stations, CDEC stations, and Natural Communities Commonly Associated with
Groundwater (NCCAG) datasets.
Recommended Enhancements
To improve the utility of the existing data, it is recommended to add C2VSIM stream flow hydrographs for
historic runs and projected model runs. A detailed list of recommendations is included in Appendix B.
M�M
The seawater intrusion sustainability indicator is not applicable for Kern County Subbasin.
Other IMapping IData
Existing Features
GEI's SGMA DMS includes a considerable amount of additional mapping information intended to provide
important relevant information for water resources planning. Visualizing sustainability indicator data in mapping
context increases understanding of how datasets affect groundwater conditions and supports decision-making.
Using the DMS mapping tools, users can compare how their pumping, project, or management actions may
impact their District and neighboring water districts. The map data is meant to improve understanding of the
hydrogeologic setting and surface conditions which impact water management in the Subbasin.
Recommended Enhancements
To customize the mapping module for the Kern Subbasin, we recommend adding a GIS layer management tool
to allow select users to customize maps by uploading, renaming, or removing GIS layers. We also recommend
adding relevant, non-public data from sources such as local datasets, Land IQ, or the Irrigated Lands Program. A
detailed list of recommendations is included in Appendix B.
GEI Consultants, Inc. 7 Kern Groundwater Authority
Kern Subbasin DMS
Data ariag rrrIen : Toohs
The management tools included in the existing GEI SGMA DMS platform provide users the ability to do much
of the work and analysis of data separate from the system developer (consultant). With the proper sign -in
authorities, district staff can conduct much of the uploading and downloading of data and conduct analysis of the
data to support SGMA compliance in the Subbasin. Existing data management tools and recommended
enhancements are listed below.
Existing Features
The existing GEI SGMA DMS includes data templates. Users download the appropriate template based on which
type of data they would like to add to the DMS (e.g., water levels), populate the template with the desired data,
and use the system's automated import tool to upload their data to the secure database. Users with the appropriate
permissions may also view, edit, import, or export data files. Currently, an administrative user may manage other
user accounts and assign roles and agencies to individual users. At present, there are built-in security and QA/QC
procedures.
Recommended Enhancements
To accommodate the Nast number of agencies and organizations that may want access to the Kern Subbasin
DMS, it is recommended to add a custom permissions element. We recommend identifying and programming
varying levels of permissions with the ability to do more or less tasks as appropriate based on user type (e.g., GSA
manager, landowner, public). Additional recommended elements include interfacing the Kern Subbasin DMS with
C2VSIM model inputs and outputs, adding capability to import lab results and field data directly to the database
from EDT or a field data collection tool, and adding QA/QC checks for new system elements as well as enhanced
data search, query, and download. A detailed list of recommendations is included in Appendix B.
Annual Reports and Dashboards
With several of the recommended enhancements listed above, the Kern Subbasin DMS will be able to expand on
the current ability to support the SGMA annual reporting requirements. Existing features and recommended
enhancements are listed below.
Existing Features
The existing GEI SGMA DMS is able to export data relevant to annual reporting, generate individual
hydrographs, and display the monitoring network on a map.
Recommended Enhancements
GEI recommends development of annual reporting templates to be distributed to local agencies in the Subbasin
for population. These templates, when complete, would then be imported to the Kern Subbasin DMS directly,
using an enhanced import tool, for aggregation and summation. We also recommend an annual reporting
dashboard to view which districts have submitted reports and the associated data. GEI also recommends a GIS -
export package for all required annual report maps as well as an export package for all required hydrographs.
Water budget templates and associated tools and viewers are recommended at district, GSA, and subbasin levels,
based on management interest. A detailed list of recommendations is included in Appendix B.
GEI Consultants, Inc. 8 Kern Groundwater Authority
Kern Subbasin DMS
In this section, we provide highlights and qualifications of key team members who will have primary
responsibilities and direct the work of our support staff. Our team is led by the three managers listed below who
have complementary skills and SGMA experience (such as working with DWR or working in the Kern Subbasin)
which provides the team with the broader vision needed to customize the Kern Subbasin DMS to meet the
current needs of SGhLA and other water management needs. These leaders are supported by over 30 staff
including engineers and hydrogeologists that have worked on GSPs and over 15 information management
professionals including engineers, programmers, and GIS analysts whom have been working on SGTNIA since
2015. All staff included on the project team are GET employees located in California. Resumes for our team
members are available upon request.
S1i IE RHI I II IE IHI IE IR IN.- IP IROJ E T IMAINAGER
Wears of Experience: 201 Wears with GE1 5
ALs. Hearn is a Project Manager in our Bakersfield Office with more than 20 years of
experience working in water resources, predominately in Kern County. She is well -versed in
groundwater conditions and management practices in the Kern Subbasin and is
knowledgeable of local SGMA planning and implementation. With her role as Project Manager, she offers a track
record of diligent project management focused on delivering projects consistent with the scope of work, within
budget, and on schedule.
11111E COIRINIEUIUS, IPS .- IPIRIIIMIIIPIL IIIA CIHAIRGIE
Wears of Experience- 30 ( Wears with GE1 16
Air. Cornelius is a professional geologist in our Sacramento office with over 30 years of
experience in water and groundwater management in California. Since 2015 he has served as
GEI's project manager supporting DWR's Sustainable Groundwater Management Office
(SGMO) implementation of their responsibilities to comply with SGMA. During this time, he has also worked on
more than 10 GSPs in subbasins throughout the State including the development of local agency DMS projects.
IDOINGIHAII WAING, IP IH I , IP IE -- IL IE ID I IMS DEVELOPER
Wears of Experience: 251 Wears with GE1 14
Dr. `Fang is a professional engineer in our Sacramento office with over 25 years of experience
in water resources data management and hydrologic modeling. His background includes
DMS development, web application design, data collection and visualization, decision support
system development, GIS mapping, spatial analysis, and programing of the Integrated Water Flow Model (IWFhl)
which is the basis of DWR's C2VSIM model. Since 2015 he has served as GEI's lead developer for the
construction of DWR's SGMA DMS and SGMA portal $taps.;gma.warcr.c.a.�;ep:�:.��eyrtal.L) as well as for the
development of local agency DMS projects.
GEI Consultants, Inc. 9 Kern Groundwater Authority
Kern Subbasin DMS
GEI's approach is to customize the Kern Subbasin DMS to help GSA managers meet their SGMA requirements
and leverage the single -DMS concept to meet other water management needs in the Subbasin, while staying in the
Emits of available grant funding. During demonstrations of the existing GEI SGMA DMS provided in October
and November, there were comments by some managers about additional functions they might want to add to the
Kern Subbasin DMS. The GEI SGMA DMS Functionality section of this proposal summarized some of the
existing GEI SGMA DMS features (listed in detail in Appendix A — Existing GEI SGMA DMS Elements) and
some recommended enhancements (listed in detail in Appendix B — Potential Added Elements for Customized
Kern Subbasin DMS) to be implemented during this project.
To make the best use of the available grant funds, GEI proposes meeting with the GSA managers and decision
makers to review the existing GEI SGMA DMS functionality and identify priorities for additional elements to
customize the Kern Subbasin DMS. The meeting(s) will focus on assessing manager needs, system design,
creation of a final task list, and a refined the scope and budget for each task. The outcome of the meeting(s) will
be documented in the Kern Subbasin DMS ilork Plan which will include refined budget allocations and task
schedules (Task 2). Often, there are economies of scale to consider when scoping modules which share common
components. There may also be certain dependencies of the customization priorities, for example, additional data
sets may be needed to support a desired customized feature. The goal of the Kern Subbasin DMS ilork Plan is to
ensure that all parties have a shared understanding of which elements will be added and the scope and scale of
each. The Kern Subbasin DMS ilork Plan can then be submitted to DWR to meet one of the grant funding
requirements.
During the Kern Subbasin DMS Customization (Task 3), GEI will provide monthly progress reports with all
invoices to support the KGA billing to DWR (included as part of Task 1). At specific milestones in the
customization of the Kern Subbasin DMS, GEI will provide demonstrations and training workshops to GSA staff
members based on the user's manual (to be developed as part of this project) that will be prepared to support the
Kern Subbasin DMS (included as part of Task 5). This will allow GSA staff to learn how to use the DMS and
populate data during the DMS customization phase. GEI will coordinate with the GSA managers to identify the
data that GEI will upload and the data that will be uploaded by GSA staff. Data uploads will follow the standard
data upload procedures and include QA/QC of the data to ensure only high-quality data is entered into the DMS.
All of these customizations will need to undergo testing during deployment to ensure their performance with the
existing modules of the DMS. Task 4 includes the testing and debugging of the modules of the DMS. Some of
the initial datasets will be uploaded to the Kern Subbasin DMS by GEI staff.
GEI will host the DMS on our servers during the customization phase. Upon completion of the work associated
with the grant, the DMS can be turned over to the KGA, or it can continue to be hosted by GEI for a small
hosting fee.
GEI Consultants, Inc. 10 Kern Groundwater Authority
Kern Subbasin DMS
We understand that this is a grant -funded project with a maximum budget that is not to be exceeded. With
that in mind, we prepared an estimated budget based on the proposed scope of work that includes Required
Elements (which will be needed regardless of the customized features selected) and Additional Elements
(which include the list of features that GSA managers will select from for customization). The project budget
will be refined based on meetings with GSA managers to align project priorities with the available budget.
Project Management and direction will be led by Stephanie Hearn, with implementation of the work and task
management distributed amongst the team's areas of expertise.
Table 2 summarizes the proposed budget by Task. This estimate is a "not -to -exceed" budget based on the
proposed Scope of Work. GEI submits invoices monthly for budget management. Labor costs will be billed
by task to track project progress and enable the Project Manager to identify potential budget issues early in
the process, and to take corrective action to deliver the project within the approved budget.
For this proposed scope of work, GEI recommends authorizing a budget of $439,785. As shown on Table 2,
Tasks 1,2,4, and 5 are identified as Required Elements and have an estimated budget of $90,000. The
remaining grant funds totaling $349,500 are available for the Additional Elements in Task 3. A cost estimate
of each additional element that is recommended for Kern Subbasin is provided in Appendix B.
hf_1-34*#-I'91104Mill ulu/_1:YA-Y&fAd21
* Cost estimates based on $150/hour average billing rate
** Required Elements necessary to support customization
GEI Consultants, Inc. 11 Kern Groundwater Authority
1**
Project Management
150
$22,500
2**
Interview Meetings, Needs Assessment, and System Design
100
$15,000
resulting in Kern DMS Vork Plan
3
Kern Subbasin DMS Customization
2330
$349,500
4**
Testing and Deployment
220
$33,000
5**
User Manual and Training
150
$22,500
Total
2,950
$439,500
* Cost estimates based on $150/hour average billing rate
** Required Elements necessary to support customization
GEI Consultants, Inc. 11 Kern Groundwater Authority
Kern Subbasin DMS
We prepared a project schedule that identifies the timeline for tasks defined in this proposal. The schedule is
developed to align with the grant schedule that includes a completion date of April 30, 2022. This schedule
assumes the project will be awarded in December 2020 with the project kickoff in January 2021. The project
will be completed by January 31, 2022 in order to complete the grant support documents and close out
reports by the April 30, 2022 grant completion date. GEI will provide monthly invoices and progress reports
identifying the status of the DMS development and pro�Tide quarterly progress reports that can be used to
support KGA grant reporting requirements.
GEI Consultants, Inc. 12 Kern Groundwater Authority
Kern Subbasin DMS
The lists below summarize the existing GEI SGMA DMS elements by sustainability indicator.
Groundwater ILevels Existing Elements
• Import data with easy-to-use import tool and templates
• Upload well site information from public databases including CASGEM
• Upload groundwater level data for representative monitoring sites from DWR's Annual Reports data
• Upload sustainable management criteria from 2019 Annual Report
• View Groundwater Level Monitoring Network on a map
• View wells outside of the monitoring network
• Select a well to see details including hydrograph and aerial image of location
• Display hydrograph(s) of selected well(s)
• View data from multiple wells on one hydrograph to compare water levels
• Print hydrographs for reporting purposes
• View groundwater contours from pre -loaded GIS layers
• View well completion reports for wells with known construction information
• View groundwater level data from external sources including DWR and USGS
Groundwater Storage Existing Elements
Includes all the Groundwater Levels elements, plus:
• Designate wells as part of your Groundwater Storage Monitoring Network
• View your Groundwater Storage Monitoring Network on a map
• View select C2VS1m layers (boundary, elements, nodes, small watersheds, stream reaches, subregions)
Water Quality Existing Elements
• Upload well information for wells tracking water quality
• Upload station information for stations tracking water quality
• Upload water quality data for 301 constituents
• Upload sustainable management criteria
• View Water Quality Monitoring Network on a map
• View Water Quality sites on a map and select a site to see details including chemographs and aerial
image of location. Chemograph of selected site includes time series measurements, and if part of
designated monitoring network; minimum threshold, measurable objective, and interim milestones
• Print chemographs for reporting purposes
ILand Subsidence Existing Elements
• Import subsidence stations and associated data
• View Land Subsidence Monitoring Network on a map
GEI Consultants, Inc. i Kern Groundwater Authority
Kern Subbasin DMS
• Click on a station to view details including graph of measurements over time and aerial image of
location
• View rate of subsidence on a graph (automatically calculated)
• View land subsidence data from these external sources including.
o DWR Extensometers
o USGS Extensometers
o TRE Altamira InSAR dataset
o NASA JPL InSAR dataset
Interconnected sur r lExisting ln
• Import precipitation and stream gage locations and associated data
• View interconnected surface water monitoring network
• View precipitation and gage stations
• View CDEC stations
• View Natural Communities Commonly Associated with Groundwater (NCCAG) datasets
Seawater Intrusion IE i ting Elernents
The seawater intrusion sustainability indicator is not applicable for Kern County Subbasin, so seawater
intrusion information is not needed in the Kern Subbasin DMS.
Other lExisting IMapping IDat
The following mapping data is included to supplement the sustainability indicator data listed above.
• Surface Geology
• Corcoran Clay
• County boundaries
• Canals and aqueducts
• Tribal trust boundaries
• Disadvantaged communities (based on census block groups, places, tracts)
• Water agency boundaries
• Groundwater basin prioritizations (2016, 2019)
• State parks / refuges
• CDFW owned and operated lands and conservation easements
• California Protected Areas Database (CPAD) Holdings
• California Conservation Easement Database (CCED)
• Regional Water Quality Control Board boundaries
• Federal lands
• Township and range section lines
• GSA boundaries
• Kern County Subbasin-specificGSA and Water District boundaries
GEI Consultants, Inc. ii Kern Groundwater Authority
Kern Subbasin DMS
Based on the meetings to -date, additional elements, their estimated costs, and a preliminary priority ranking
are provided below for the GSA managers to identify the items most important to their ongoing SGMA
efforts. Because the total of all additional elements ($526,500) exceeds the available budget of $349,500, we
will work with the GSA managers to make selections for customizing the Kern Subbasin DMS.
" High priority elements because of potential dependencies of other features.
GEI Consultants, Inc. iii Kern Groundwater Authority
A` Add groundwater level data to water quality plots for
High
160
$24,000
same well and nearby wells
B
Initial data population of representative monitoring site
High
80
$12,000
(RMS) data
C
Customize user permission controls by GSA managers,
High
350
$52,500
administrator, district, super users, landowners
D
District and GSA Level Dashboards
High
160
$24,000
E`
Relevant data from other sources such as Land IQ, CV-
High
80
$12,000
Salts, and Irrigated Lands Program
F
Enhance data search, query, and download functions
High
80
$12,000
(by well, station, GSA, district)
G
Enhance field data collection tool to surrey data in the
High
160
$24,000
field and upload to the DMS directly and upload
seasonal water level data from the field
H
Automate export packages to save formats of figures/
High
100
$15,000
hydrographs at district/GSA level
I
Automate export packages to save formats and
High
300
$45,000
individual frames for GIS figures
J
Create groundwater well profile or cross-section
High
40
$6,000
diagram
K
Allow users to select groundwater wells and observation
High
200
$30,000
period to automatically generate water level contours
"on -the -fly"
L
Display sustainability indicators by proxy of water level
High
40
$6,000
" High priority elements because of potential dependencies of other features.
GEI Consultants, Inc. iii Kern Groundwater Authority
Kern Subbasin DMS
M
Groundwater level forecasting tool to evaluate 'What If
Medium
200
$30,000
scenarios
N
Annual reporting support
Medium
200
$30,000
O
Develop import tool for lab results from EDT
Medium
80
$12,000
P
Print page of the well detail information
Medium
40
$6,000
Q
C2VSIM Integration (individual elements listed below)
$0
R
C2VSIM stream flow hydrographs for historic and
Medium
60
$9,000
projected runs
S
Change in groundwater storage maps for each principal
Medium
120
$18,000
aquifer based on CVGSM subregions.
T
Groundwater extraction locations and volumes (for
Medium
100
$15,000
preceding water year) by CVGSM subregions
U
Add C2VSIM simulation model output at Monitoring
Medium
160
$24,000
Network Locations
V
Manage C2VSIM model input and output data files
Medium
160
$24,000
W
Summarize C2VSIM estimates of subsurface flow
Medium
100
$15,000
between model subregions within Kern Subbasin and
between Kern Subbasin and neighboring subbasins for
historic and projected model runs
X
Visual display of C2VSIM water budgets
Medium
150
$22,500
Y
Mapping GIS layer management tool for admin users to
Low
40
$6,000
upload, change name, or remove GIS layers
Z
Water budget templates at district level to be rolled up
Low
350
$52,500
to GSA and Subbasin level
Total of additional elements
$526,500
GEI Consultants, Inc. iv Kern Groundwater Authority
E I Illll�����llllllllulll000000nn�
Consultants
5001 California Avenue, Suite 120, Bakersfield, CA 93309 1 661.327.7601 g6clon su kants.¢:.o m
Proposal PROVOST&
December 4, 2020 PRITCHARD
An Employee Owned Company
10
W � r r
An Employee Canned Company
December 4, 2020
Kern Groundwater Authority
Patricia Poire, Planning Manager
1800 30th Street, Suite 280
Bakersfield, CA 93301
18003 01h Street, Suite 280
Bakersfield, CA 93301-1930
Tel: (661) 616-5900
Fax: (661) 616-5890
www.provostandpritchard.com
RE: Request for Proposal — Data Management System for Kern Groundwater Authority
Dear Ms. Poire:
The team of Provost & Pritchard and Houston Engineering, Inc. (HEI) is pleased to submit the
enclosed proposal for the preparation of a Data Management System (DMS) for the Kern
Groundwater Authority. Leveraging our team's experience and expertise in well data management,
geographic information systems (GIS) and hydrogeology, our approach is to work alongside the
Kern Basin Groundwater Sustainability Agencies (GSAs) to efficiently process multiple sources of
information into one cohesive dataset for the benefit of the GSAs.
Since the SGMA establishment in 2014, GSAs across California have been looking for ways to
better manage their natural resources. Our team has worked with several GSAs to develop DMSs
that provide centralized storage and reporting tools for annual reporting. Provost & Pritchard brings a
long history of local water resources knowledge and has worked for many of the GSA member water
agencies helping them understand their wells and groundwater conditions better.
HEI's GIS and Technology team was formed more than 15 years ago and has been developing
unique solutions for their clients ever since. From nationwide web applications to small district
conservation tracking databases, their expert software engineers can create a DMS that will house
all necessary data to implement your Groundwater Sustainability Plans (GSP).
Together our firms have actively managed the preparation of over a dozen GSPs and are in the
process of developing SGMA DMS software for five other subbasins. These GSPs and DMS
projects required a high level of spatial data understanding, organization, and analysis. This
experience has provided our GIS specialists, hydrogeologists and software engineers with a deep
understanding of the needs of many GSAs.
Jeff Eklund will serve as the principal -in -charge and will ensure our company resources are in place
to execute the commitments of this proposal. If you have any questions, he can be reached at (661)
616-5900. Thank you for considering us to be part of your team.
Respectfully,
Gavin O'Leary, GISP
Project Manager/GIS Specialist
Jeff Eklund, PE
Vice President
Engineering • Surveying • Planning • Environmental • GIS • Construction Services • Hydrogeology • Consulting
Fresno • Bakersfield • Visalia • Clovis • Modesto • Los Banos • Chico • Sacramento
Prepared for:
Kern Groundwater Authority
Patricia Poire, Planning Manager
1800 30th Street, Suite 280 • Bakersfield, California 93301
Telephone: (661) $79-7171 • Email: ppoire@kcrngwa.com
Submitted by:
Provost & Pritchard Consulting Group
1800 30th Street, Suite 280 • Bakersfield, California 93301
Telephone: (661) 616-5900 • Fax: (661) 616-5890
Wcbsitc: a,�,,,w.provostandpritchard.com
Cover Letter
Aboutthe Team .................................................................. ........ I
Provost & Pritchard Consulting Group
Houston Engineering, Inc.
KeyPersonnel .......................................................................................... 3
ProjectExperience ...................................................................................... 5
Provost & Pritchard
Houston Engineering
References
Project Approach and Understanding ..... ................................. ............................. 11
CostProposal .................................................................................... ..... 19
Appendix A: Resumes
M , I r roil
Provost
♦ iPritchardConsulting
Group
Tn 1968, Provost & Pritchard Consulting Group began a
tradition of engineering excellence in the San Joaquin Valley.
Over the course of more than 52 years, Provost & Pritchard
has grown in size, services offered, and geography with
eight office locations throughout California. With over 190
employees, our staff is diverse in their specialties, including
civil and agricultural engineers, hydrogeologists, Geographic
Information Systems (GIS) specialists, land surveyors,
environmental specialists, planners, construction managers
and field representatives, and support personnel.
Our diverse range of services includes:
• Water Resources Management and Engineering
• GIS
• Civil Engineering
• Agricultural and Urban Water Planning
• Land Surveying
• CEQA/NEPA Compliance
• Construction Management Services
IlirIIII l ssi lii 111
f��Iairtineirliiing Wth our dhbintsto accoirnplhth Cllh6hir goo
Icy ddlhlveirlihn Ipeirlibir vMue tllhurough VlhoughtfIII aind
effec lve sdutbins
For us at Houston Engineering, Inc. (HET), creating
solutions and designs that actively improve the future of our
communities is what keeps us moving forward into the future.
With more than 225 employees in nine locations throughout
the Midwest, we're dedicated to getting the job done and
done right.
HEI first opened its doors in Fargo, ND in 1968 as a civil
engineering and surveying firm. Since that time, we have
expanded our capabilities, our staff, and the geographic
area we serve. We regularly provide a frill range of civil
engineering, environmental, planning, and technological
consulting solutions for clients across the United States.
In order to succeed and serve our clients properly, we know
we need to invest in our staff, equipment, training, and new
technology, all while encouraging innovation and creativity.
We provide big business expertise while striving to continue
a small firm atmosphere. When our clients are successful, we
are successful.
One thing that makes HEI unique from other traditional
engineering consulting firms is our diverse team of
technological staff at HEI. One service we focus on is
developing software solutions to meet business needs of
our clients. Many of these software solutions provide an
innovative integration of water resources domain knowledge,
GIS and the latest software development technologies.
What sets us apart from other software development
companies is the domain expertise we have in natural
resources, environmental, water resources, engineering, and
government business needs.
�������UHUHUIOUS
n n e e r IIII n 9, ri c..
zaraTlwa
Following are brief biographies for the project team who
will provide services to the Kern Basin. Complete resumes
detailing individual experience, education, and credentials are
included in Appendix A of this Proposal.
Jeff Eklund is a Principal Engineer with
Provost & Pritchard and Vice President of the
firm's Bakersfield office. He has 17 years of
experience in the field of civil engineering. He has experience
on a variety of water resources projects in the areas of water
supply and distribution, groundwater recharge and recovery,
and district engineering. He has been involved in planning,
preparing construction plans and specifications, as well as
coordinating and permitting with various public agencies
and utility companies. Mr. Eklund has also been responsible
for the management of the Kern Integrated Regional water
Management JRWN� Group, including the 2020 update of
the Kern TRWM Plan and the preparation of four successful
grant application rounds resulting in $28 million in grant
funding for 17 different projects.
Gavin O'Leary, GISP
:Iir� sect II" anageir/ ;eir k)ir GS SpedMst
Provost & Pritchard
Gavin O'Leary is a senior GTS specialist with
18 years of experience and has been working
with water resources related data for his
entire career at Provost & Pritchard. He has an extensive
background in spatial analysis and database creation with
geospatial data. He is the spatial data lead for the seven
Groundwater Sustainability Agencies (GSRs) in the Kings
Subbasin and provided analysis and data management for
eight GSPs. Mr. O'Leary's areas of expertise include mapping
and analysis of groundwater well data, spatial analysis of
groundwater storage, management of water agency facilities
data, assessor parcel data, and data conversion and creation
from historic sources.
ilii Palys
ateir II: Resources Speddst
Provost & Pritchard
Kaidin Palys is an Associate Water Resources
Specialist with Provost & Pritchard,
providing technical assistance to the firm's
Watcr Resources service sector. Ms. Palys has a strong
understanding of the physical sciences behind water
resources, as well as the regulatory hurdles faced by many of
the clients. Specifically; her experience includes, water supply
and feasibility studies, SG -\Lk compliance, data management,
and water budget calculations.
Brian Fischer
lbchnlicd II...ead
Houston Engineering
Brian Fischer founded and leads the
technology and GIS services out of HEFs
Maple Grove office. He is a Vice President
and provides a leadership role in the company. Mr. Fischer
regularly provides project management in the areas of GIS
analysis, GIS mapping, database design, programming,
web application development, and mobile application
development. His GIS expertise includes agricultural and
water resource applications, web and mobile applications,
decision support systems, environmental/natural resources
applications, engineering applications, and LiDAR collection/
processing as well as GIS for California government,
irrigation districts, and (GSAs).
Josh Donato
r r
Joshua Donato serves clients as a Software
Engineer out of HEI's Maple Grove office.
His technical expertise includes ArcGIS 10.x,
Web Appbuilder for ArcGIS, GeoServer, PostgreSQL/
PostGIS, GDAL/OGR, ArcPy, SQL, HT-NIL5, X -NIL, CSS3,
Python, Django JavaScript, jQucry, ArcGIS JS, D3, Dojo,
jQuerl; React/Redux, Leaflet, OpenLayers, C#.NET, ASP.
NET Core, Visual Studio, Eclipse, RubyMine, WebStorm,
PyCharm, Windows, and Ubuntu. Josh has led the
development of SGMA Data Management Systems (DMS)
for other subbasins including Delta -Mendota, Kings, Madera
and Chowchilla.
Steve
Software II ngiiirneeir
Houston Engineering
Steve Jakala serves as a Software Engineer II
for specific projects for HEI. He has 10 years
of experience working with .NET, JavaScript,
Python, GIS, and a variety of databases. Steve has assisted
in the development of SGMA DMS for other subbasins
including Delta -Mendota, Kings, Madera and Chowchilla.
jbclhinr ical Support
Houston Engineering
Joe Jeurissen's responsibilities with HEI
include the design and development of
custom interactive GTS applications and
the development of web -based database applications. His
skills include a broad base of programming languages and
applications. Joe has the led the development of Central
California's well management database system.
Chad Nunemacher
jbclhinr ical Support
Houston Engineering
Chad Nunemacher has vast GIS and
analyst experience. As an ArcGTS Server
Implementation Technician, he has led projects
to install and configure ArcGIS servers, and is many times
responsible for the underlying GTS infrastructure. As a
project manager, he has overseen numerous projects and
has played a significant role in the software development
role as well. As an analyst and consultant, he has assisted
customers with GAP analysis, reports, flow charts, diagrams,
recommendations, potential impact statements, and more.
Chad has more than 13 years of applied GTS experience
and complementary business analyst experience. Chad has
assisted with the definition phase of the Delta -Mendota
Subbasin DMS and was the technical lead on the Tulare
County Disadvantage Communities web tool.
8 1 •
Provost & Pritchard has worked in Water Resources in
the San Joaquin Valley since 1968, and as such has done a
plethora of projects where canvasing for wells and evaluation
of well construction was integral to the work. More recently
this experience has allowed Provost & Pritchard to assist
numerous GSAs in documenting available well information
into standardized data sets. Specific recent projects and
methods used are outlined below
Community Water Needs Assessment Tool
Kern, ..L.uIaire, II:��'iresino, and IKings C ou.uiru�CJies, CMli�l' irinu
Provost & Pritchard developed the Community Water
Needs Assessment Tool with Houston Engineering for the
Tulare Kern Funding Area (TKFA) (web mapping tool)
to provide a mapping interface for users to access the data
collected through the TKFA DAC Needs Assessment. The
web mapping tool is intended for use by Integrated Regional
Water Management Regions, counties, DACs, as well as non-
governmental organizations (NGOs) or consultants working
with IRWMAs or DACs. The mapping tool provides various
data sets in a single interface, has several tools available,
and can generate reports to provide commonly needed
information for users.
"Ilf Iurovost & f°'IurliIhnurd Ilhas Il eeiiu supeir Illh6lpf'Ull liiu"u
fkilhIafling the turoull llb shwfling Wth III°°IOUS'tOlin nind ouur
staff III ure6llll nur"u't say a inough good VKhngs about the
work they Ilhave doine "
CountyofTulare
Multiple Groundwater Sustainability Agencies,
Groundwater Sustainability Plans (GSP)
CMN'oirnla
Provost and Pritchard has considerable experience working
with SGNIA projects. Our water resources team of engineers,
hydrogeologists, and water resources specialsts wrote over a
dozen Groundwater Sustainability Plans (DSPs) for Subbasins
designated as Severely Overdrafted and/or High Priority by
the
Pry
G,'
Madera
N11 Ra x ro M- =—
Aliso Water District GSA
Grassland GSA
Central & Northern DM GSA
Tranquillity Irrigation District
New Stone Water District GSA
Madera Water District GSA
Root Creek GSA
North Kings GSA
North Fork Kings GSA
Central Kings GSA
McMullin Area GSA
South Kings GSA
James GSA
Kings River East GSA
Mid Kings GSA
Southwest Kings GSA
South Fork Kings GSA
El Rico GSA
Tri County Water Authority GSA
East Kaweah GSA
Pleasant Valley GSA
San Gorgonio Pass GSA
Kern Groundwater Authority
Shafter Wasco Irrigation
District
Cuyama GSA
Kern County Water Resources Experience
<erir) County, CMlN'�orn
Provost & Pritchard has provided water resources planning,
water supply evaluations, and data management and analysis
for multiple agricultural water districts and municipal districts
within Kern County. Examples of this type of work include:
• Nlanagcmcnt and support services of the Kcrn
Integrated Regional Water Management (IRWyAI) Group
including the preparation of the 2020 Kern IRW N1 Plan
Update, the Kcrn Storm Water Resources Plan, and
the preparation of successful grant applications for 17
different projects.
• Development of Groundwater Management Plans and
production reports for many water districts.
• Preparation of Urban Water Management Plans for four
different water districts.
• Support services for the Kern River Watershed Coalition
Authority.
• Support services for the Kcrn Groundwater Authority.
Data Management System
I::Cefta Mendota ota S ubba§n and Santa IlN61a County Grier
Diistrlict, CMlN'orna
HEI has been tasked with assisting Woodard & Curran, the
San Luis & Delta Mcndota Water Authority, and the Delta -
Mendota Subbasin GSAs in assembling a web -based software
application that would meet the needs of the Santa Nella
County Water District (SNCWD) and the Delta -Mendota
Subbasin. In order to do that, a technical working group was
formed to advise and support the development and design of
the data management system (DMS). This group determined
the conceptual design of the DMS as well as data standards
and templates for importing data into the coordinated basin -
wide DMS.
To begin this project, HEI used discovery meetings with the
technical work -group to define data types, sharing rules, spatial
data, and reporting needs for the DMS. This information
was then used to create wireframes and data templates for
different monitoring types such as water levels, water quality,
subsidence, and surface/groundwater interaction.
N11 Ra X ro M_
=-
HEI then proceeded to develop the software as a web -based
application that met the requirements defined in the first
phase. Some of the unique functionality included role -based
authentication, data import from spreadsheet, GIS map
viewer, monitoring data visualization tools and SGMA annual
report generation.
HET is continuing to support the subbasin by managing
the web hosting and providing technical support and
enhancements when needed.
r
t
1' Ita-
lin alta
uaban
is
r llr �
Client Benefits
✓ A coordinated DMS for storing centralized monitoring
data and generating annual reports for the Delta Mendota
Subbasin
✓ An agency -level DMS for entering and storing well and meter
usage for the SNCWD
✓ Maintenance support by HEI for future enhancements and
hosting
GIS and SoftwareDevelopment rServices
CentrM CMiN'orna irrigation IIDiistriict, Il...os Il��l3)anos, CMiN'�orn
The Central California Irrigation District (CCID) is located in
the Central Valley of California and serves over 140,000 acres
of farmland.
Since 2011, CCID has contracted with Houston Engineering,
Inc. (HEI) to implement a variety of GIS solutions. Through
our projects, the CCID can now use their operation and
maintenance data in a GIS format to more efficiently improve
data management and visualization.
Nlost recently, HEI has developed custom data management
system to manage the districts well information including
water levels, pumping and water quality data to support
internal needs and State reporting for various programs.
With strong experience in both GIS technology and irrigation
districts, HEI was uniqucly poised to offer GIS services to
CCID.
N11 Ra X ro M_
=-
Work activities under the project included:
• CAD to GTS data conversion
• GTS data management and design
• Assistance with GPS data collection
• Map book creation
• GIS map viewer application development
• Database integration with water accounting software
• GIS training
• Custom well data management system
In addition to the original project, HET continues to provide
GIS consulting to CCID to maintain a successful ongoing
program.
' / �f r
AMp%Oi / raRJ%
/rrr
j�, / � r n i y� ✓r J r �'^;"*mw��. rm ��,�„w � ^/////�„/ / �r/j��' r �''�N'"7� n �� ;;;
r rr
/
Vk
% „„
� ���/f�,ry�aPl�ri /^I ��,� //r'•. �����fl� / / '�W i ;; %! � vr. � %�r�sr mwtomaa �sw�...;�r'ri(mu4rim..
� ly,� l �nr�igi,✓ � r/r� mrd gyr;�� � j r � ido„ ,«. ..
Msryr,
/
rn � r f � ai /� rr , �
?/ ” k1 ,
rrr �i(rr� f� uu /� ia� � � �
r r /rr ! t
/ / � ro t
If
r
yr ,
If w �✓
r o r
Client Benefits
✓ Increased accessibility to information used in decision-
making and project planning
✓ Greater transparency for the public and other governmental
agencies, which also increases productivity
✓ Ongoing support services to serve additional needs
✓ In-person training to support staff
”, e 1,n C; 1, (j u,1,1�u/rr(ei,Aufri(,,�i, fly, I'), ',rr IM i,i{1ePflei,i'C "1y, le 'n
Field to Market Fieldprint@ Calculator
Lln�ted States
Field to Market has a diverse group of members, including
a variety of agribusiness, brands, retailers, civil society,
academia, and public sector. The organization's mission is
to work collaboratively to define, measure, and advance the
sustainability of food, fiber, and fuel production in the US.
Field to Market offers the Fieldprint Platform, which is
a framework that allows brands, retailers, suppliers, and
farmers to measure and report on the environmental impacts
of crop production while identifying opportunities for
continuous improvements. The Platform is widely used as
a free and confidential tool, with many farmers using the
online Fieldprint® Calculator or utilizing the service through
a qualified data management partner. These tools aggregate
data while integrating the Platform's metrics and algorithms.
The Fieldprint® Calculator is a vital component of the
organization's supply chain sustainability program.
In 2017, HEI began a high-profile project with Field to
Market to rebuild the next generation of their Fieldprint®
Platform to a new version 3.0.
HEI is currently leading a team to take over the platform
(previously housed by another vendor), rebuild the new
version using microservices for the science based metric
algorithms, rebuild the API, and improve the user experience
of the online web application known as the FieldprintR
Calculator. The project began with a series of meetings with
the previous vendor to migrate the existing platform to HEI's
servers.
HEI attended a series of discovery meetings with Field to
Market staff, members, and users of the existing platform.
From these discussions, we were able to identify some key
areas needing improvement.
N11 Ra X ro M_
HEI worked on developing enhancements for the new
platform using an agile software development approach. This
preliminary programming was part of a collaborative process
with Field to Market. The platform integrated Natural
Resource Conservation Service erosion models, including
the Water Erosion Prediction Project and Wind Erosion
Prediction System.
The final product is an improved Fieldprint Platform that
better serves members and users to track and report on their
sustainability programs, promoting continuous improvement
across the country.
Learn more at: https://fieldtomarket.org
Client Benefits
✓ Rebuilding the platform to support microservice concepts that
are easier to modify as the science -based metrics change
✓ An improved web interface for farmers to enter data and
ter.. r r11
Management Partners
N11 Ra X ro M-
unity Water Needs Assessment Tool
� C�Counties,C�allii�foirir�iia
Kern, L.�.ullair����, Il:���ir�����w�lir���l, air��C II�CIiir�Cs
Client Name: County of Tulare
Address: 2800 W. Burrel Avenue, Visalia, CA 93291-4582
Client Contact: Denise England,
Water Resources Program Director
Ph: (559) 636-5027
Ercall: DEngland@co.tulare.ca.us
Groundwater Sustainability Plan Development
Forth IKings GSA, Il�� iresino County, CMiifoirirl
Client Name: Fresno Irrigation District
Address: 2907 S Maple Avenue, Fresno, CA 93725
Client Contact: Adam Claes, PE
Ph: (559) 233-7161 Y 7404
Email: aclaes@fresnoirrigation.com
Groundwater Sustainability PlanDevelopment
L.Ulaire Il...alike S ulbba§iinuS s �County, C�allii�foirir�iia
w��, II�Cliir��s
Client Name: Kings County Water District
Address: 200 Campus Dr., Hanford, CA 93230
Client Contact: Dennis Mills
Ph: (559) 584-6412
Email: dennis.kingscwd@gmail.com
Data Management for Northern and Central Delta
Mendota Region
San Il...0 s & C6IIa..]Mendota Water Authoirty
Client Name: San Luis & Delta -Mendota Water Authority
Address: 15990 Kelso Road, Byron, CA 94514
Client Contact: Scott Petersen
Ph: (209) 826-9696
Email: scott.petersen@sldmwa.org
GIS and SoftwareDevelopment rServices
CeintirM CMiifoirirla Ilirrigation IIDiistiriict, Il...os II��I3)anos, CMii�foirirl
Client Name: Central California Irrigation District
Address: PO Box 1234, Los Banos, CA 93635
Client Contact: Jarrett Martin
Ph: (209) 826-1421
Email: jmartin@ccidNvater.org
��� rri r�erPviUrl��iu/rt(�!�r��ufr�i'�rlf�� )rX'Crr '�rrri�X{l���rrl���rr1'C �i�/�f(�rr°rl
Provost and Pritchard and Houston Engineering were
founded on similar philosophies of building relationships,
providing quality products with practical solutions, and
responding to clients' needs. These philosophies carry
through to our project management approach.
Some of our tools used for exceptional management include
kick-off meetings, periodic project and client meetings, and
software to track the project budget and staff time.
Our companies were first introduced to each other over ten
years ago at a water resources conference. Since then, we
have worked together on numerous projects where Provost
& Pritchard is the local recognized leader in water resources
management and HET provides a team of GTS and software
engineers to assist with building solutions to help meet the
business needs of the client. Our approach to this project
will be similar to others that we have teamed on before,
and the Kern Basin will benefit from the two companies
prior experience with SG -NIA data management systems and
knowledge of the Dern Basin.
Good communication is the backbone of every successful
project. We will provide frequent, clear, and direct
communication—keeping things easy for you. Our leads
will maintain a direct line of communication with the Basin
Coordinator and others as requested throughout the entire
project.
Our team proposes an agile software engineering
methodology. Our rationale for using this approach is
motivated by:
• the undefined detail in requirements for a DMS and
• the optional features that may or may not be included in
the initial software build.
Our software methodology is further_ explained in the
Detailed Approach starting on page 12.
As part of this methodology, our management team is
committed to following communication guidelines and a clear
process to ensure work is monitored, risks are controlled, and
deliverables meet your quality expectations. This management
approach is based on our experience developing numerous
custom software applications.
Our tool for management include:
Deftek Vli§ioin
Accounting and project management software that provides
weekly project summaries with staff comments and reporting
to monitor work progress and budgets for the project
managers. Deltek Vision also brings transparency in that you
will sec where and how your funds arc used throughout the
project.
wiwie IM U a
A team collaboration tool (assctnbla.com) that provides
wiki pages for documentation, code repository, messaging,
and Agile software development tracking as well as a ticket
system. ewe rely on this heavily for internal communication,
technical correspondence, and documentation for clients.
What can you expect:
• Access to Assembla collaboration space
• Meeting agendas and notes organized in Assembla
• Regular communication with the project manager
throughout the project via phone, email, and in-person
meetings:
— Notification of issues and risks associated with tasks
and in-person meetings to discuss
— Risk mitigation strategies (if needed)
— Documentation of key decisions
— Updates on key personnel
— Detailed invoices
Our team understands that GSAs in the Kern Basin
are seeking proposals for the design, development, and
implementation of data management system (DMS) for
entering, storing, and maintaining data related to the
implementation of the Groundwater Sustainability Plans
(GSPs) and compliance with SGMA regulations. The goal
of the planning grant received by the Kern Basin is to
develop a DMS that will serve the individual GSAs while also
benefiting the cross -basin coordination effort. It is often
critical to design and define the requirements of the software
throughout the development when there are numerous
organizations involved to ensure a successful project. In the
end, these types of solutions involve consensus to find the
right balance of features versus costs and long term viability
We arc proposing a similar approach used with many other
clients, including the Delta Mendota Subbasin GSAs in
the development of their web -based DMS (page 7). At a
minimum we propose creating a baseline software solution
that will meet the SGMA regulations for a DMS as well as
support the process of centralizing data for the coordinated
subbasin's annual reporting needs. This means a DMS
capable of storing and reporting information relevant to the
development or implementation of the Plan and monitoring
of the basin. In addition, our solution provides a robust
role -based permission module to control how data is entered
and sharedwithin ithin the subbasin or to the public. We also
understand that there may be interest in developing additional
functionality in the DMS for disadvantaged communities,
public or landowners. As part of our approach, these
additional features will be discussed and brought to a decision
in our project definition phase.
Another advantage of our team is that we have a starting
point for SGMA DMS software that has already been
developed and continuing to be enhanced by other subbasins.
This provides a tremendous value to the Kern Basin and their
grant can be leveraged to add additional features or tailor
more to your unique needs. Below is a graphic of our SGMA
DMS software. Our SGMA DMS software is organized by
modules. There is currently support for a wide range of data
modules that align with your GSP plan and implementation.
Our software is configurable and extendable to be able to
add additional modules. One new module being developed
for the Madera and Chowchilla subbasin is a project
implementation tracking module.
This approach has been the recipe for other successful
solutions developed by us where similar stakeholder groups
have not formally and fully defined their requirements.
Figure 1 on the nest page outlines the general process we
are proposing for the software development project along
with a detailed description of each task, deliverable, and
commitments from GSA and Agency staff.
mom=1
:lguiire 1. �:�Iiiroposed Softwalr IDev6opiment :Iiirocess
rri C'I' lUYiAu,Ii'i'l(/, "VI CA I' I CAO I' I, I ('r I' I � """"iys l' I' 1 13
MSK 1 IICIIC IIC..OII::II:: ILII: II:...�..IIII u
Description of Work
Before starting any technical tasks, we will conduct a web -
based kick-off meeting with selected project stakeholders to
discuss our approach. This will ensure we arc on the same
page for starting the project and give us the opportunity to
discuss a variety of topics, including project definition phase,
clarification on specific features required, and the formation
of a technical workgroup made up of GSA representatives
to guide decisions. We will also discuss the vision for the
DMS and any known difference that the DMS could have
to accommodate the different GSAs business needs. Based
on our experience in the Delta Mendota Subbasin, we would
strongly recommend forming a technical workgroup to
provide input on the DMS software requirements and data
standardization. This would include GSA representatives—
whether agency staff or their consultants—along with the
Basin Coordinator. We will also discuss expectations and
outline the deliverables of the project definition phase along
with the proposed timeline.
Deliverables
• Meeting agenda
• Notes
• Assigned action items
• Updated timeline
Client Commitments
• Hours by staff to attend meeting
• Revicw notes
• Completion of action items
MSK Z IL.0 II SCO Ih: Ih X IIS Ih: Ih: PHI ", AND'
:SII: QLJWJIII II: ILII: II ..�' II::CII: II::IIII II II0JC
Description of Work
Our team is proposing a series of on-site discovery meetings
(pending COVID-19 guidelines to travel) with the GSA
technical working group. The purpose of the on-site meetings
is to introduce the consultant project team and provide
education around what a DMS is along with examples of
DMSs. The meeting would be conducted as a presentation
from the consultant followed by group discussion on
different topics. We would propose a four-hour discovery
Following the on-site discovery meeting, our team will
conduct follow-up discovery meetings with individual
GSAs and stakeholder staff to capture their individual
needs. The meetings may be one-on-one or full work -group
meetings. Another set of discovery meetings will also be
conducted with local stakeholders, non-member agencies,
and disadvantaged communities (DACs), such as the Cities
of Shafter and Arvin and portions of the City of Bakersfield,
that have potential activities, tasks, and/or components that
are complementary to the DMS development project. This
may also include other private consultants that were used in
the development and implementation of the GSP.
For the Delta Mendota DMS project, we set up re -occurring
bi-weekly meetings with the technical workgroup to discuss
topics until the requirements were fully understood.
There are numerous details that will need to be discussed
and defined as part of this process, such as integrations with
other systems, individual GSA business needs, GIS, water
deliveries and water trading software. While it is all technically
feasible to integrate with other systems, the level of effort
is in the details. There are numerous ways to integrate
depending on what each system offers for application
programming interfaces (APIs). We also feel it is important to
understand what is needed for integration and if the cost of
development and maintenance will outweigh its benefit.
The information generated in the discovery meetings will
be used to prepare a design concept for the software. Our
approach is to define a baseline set of requirements, that
at minimum, meets the SGMA regulation and assist with
reporting requirements. Then we will add the optional
features we heard during the discovery meetings so there
is a comprehensive list of items that could be added to the
baseline DMS but would ultimately be decided upon by the
technical workgroup based on costs, return on investment
and other factors that should be considered.
After this collaboration, we propose to formally document
the design concept of the software. To accomplish this task,
our team will use a couple of industry -standard mechanisms.
First, wireframes will be created for the software. Wireframes
are illustrations of the interfaces that show how different
elements relate to each other. While we may not develop a
wireframe for every screen, these representations will give the
project team a good idea of what the application will look like
before programming begins. We envision focusing on some
meeting.
I�;:� rr� ���r�w�ur�����,irt(�r�,ufrnv�r�f�i 11rx'Crt I'Jlrtri�all�� rr7�� nt �,�i� f��rr�r7 'll
:lid �uu Z�r :�rDr��r�I .���rll Vrv�rv���r trv���� ° rv���V
II: urv�.
w ,,
��� :wn few the
�r rn�
Vim. �A AO
nit
GSAs the opportunity
Cu rfordWator et a Odwwjtse� 1, 2018 - Sektemtw,,
y . 2019
AA 11111'.tb g
PNR�jfi%wtn NUrrv!Xoomvs #,wsmq'Ww dWA.l`;wmi4mwl U` 10
to reviewandedit the
final t roduct concept
� iw wmraw A �. °N�r mAm Wn:. mu mww nu,w,w,u.,,ww
' i� �,.Wawim2;e,
#P., U,— mow Wha<
betbre its created
t 0 60b"I'l 01 w#UU/NW 44
meaning you will have
t°
Nil control of what
ilum?�rl�Xits`�rfP4U� ��rN�m/�/rttmrr�lr� �JA,t
your system requires
WA. 94&Ao"1."0���„� � Dr1."PA f) Of,.—IR "0.,row
A
e1�A��li f(��Ic�7
x"w wow Avo*
,pOH
and assurance that
out funding h; w�roft
-0.0111 0 a 11
ma"
e01—^ LANII'A.@
k1XV/1�A
W 00, fi W vel MI,A ! U* AM), 0
+'+w: ))*19 mGY
I w Y ✓ A w �,Atliw-M
hep kG'
t( A, -)I)W -PAW P A
*evwm
e wspent.
AMiv:'MAu.¢eM
UfDV/lbf A�
'erAhs' 'd1A++W,gOUh"+m'Q'� rtpw7r�a�r,-kAVi
AA9fi GN'Wa�r mAA
kNVJiiMM f".OINA, 11.1 A%IY�!�Und*hn!�bU bPo`a�N aY�M "NXY ,MmF Sir✓'-�gf w+fbtiiPov i�Nn'.
.�('jl�IW wwa�Wo�ao�ro°.d°'w1�4.
nb dQ P,N,w �mv,�$nww -eaikwbllP'.aAaNgpv' 9�epyw
WOO,., 001ml,
NAW 1.0—
V.,�W!;/&dA�w';G IxPWP:MePI. iAr 'gig wm�MlGrten M�mawsiw&�
n ,wAnmuw: awmmarw,a AF 0
1"W111
WO, 01104, 9,0 wwN"'w
e7d rom. A1&`Iavra,wAw ^� wwvor sir
r� oti+ANfAWr mM 3iwUF AAA- c
P
ft)YIN 00
q' #uLdU^maWYryo!A n
AU. znr V'r AmM,Ofi"w $10 Uww/AutAt Udair
[1.11A1W
w,wh 41AI of
6f
Pr uvi �wmwwa. .4Anmial All m 6
$
.0mrarf hI 'wwsox
e!�nwm *A'aeuA-sww ,ug,
' g1AYL Av,NA)&A,,W0 l"No"''uv' (W
AwmmlrA5mA0
vbw, Al" AF
0* �,vJo-o of mm) 012'
41>•+/w�PW �,4 vwfdMOaw& "' (A9W60
wmAOWN uro
'�aumA wwa annn�w+ amm��r wr.
�IIIUUVVVVVV II��UIIUU,IIIIIIIIIIIIVI�IIy,V�illl,l�lllUuY„II�II,�IIIIIU1uU�
II�IUI,IIII,�„I,III�IIII,
� m �.
i ,0 oli—
key screens, such as users' dashboards (i.e., Homepage), data
entry screens, import wizards, data visualizations, and report
mockups.
Process
The project team will produce wireframes depicting the
software interface. Our w,ireframes are fully annotated,
explaining the function of each interactive element present
on a given screen. Designing the experience is an iterative
process; once an idea is put to paper, it is easier to correct,
criticize, or flesh out in greater detail.
Rationale
Wireframes are the primary vehicle for knowledge transfer
from software users to developers. They are a touchstone
that all parties can review, agree on, and reference before and
during development.
Finally, the remainder of this task will focus on creating
data standards and templates that will be used for importing
information into the DMS from the various GSAs' systems.
This is extremely important to ensure all GSAs know
the expectations for data formats and schedule for data
submissions and will meet one of the deliverables in the grant
workplan. We spent a significant amount of time working
with GSAs in the Delta Mendota subbasin to determine
what was minimally required based on the SGMA regulations
and annual reporting. We also spent significant time cross
referencing monitoring location site attributes and time series
data against the GSPs, representative monitoring networks,
and SGMA regulations. We believe a lot of this work can be
re -used for the Kern Basin.
We will also finalize the software technology stack used to
build the application and discuss hosting arrangements. This
information will then be compiled into a DMS software
requirements draft report and presented to the technical
workgroup for review
Deliverables
• Discovery meetings agenda and notes
• Draft D�tS software requirements report including:
wircframes, data templates, integration requirements,
report mockups and proposed hosting environment
Client Commitments
• Hours by staff to attend meetings and provide data.
MSK : II:IIII IL..II 11: ILII: C: �W�IIIICII: ILII: IIS II::)0(" Wp1W1 N 11V11::
CCCC II: II:�..�. IIS CC II:
Description of Work
Our team vnll then conduct a web -based meeting to present
the draft requirement documents to the technical workgroup.
The technical workgroup will be given the opportunity to
provide feedback on the wireframes and other requirement
documents. The wireframes will then be revised and
submitted to the workgroup for final acceptance. Our team
will ask the workgroup to sign off on the requirements of
the software. Our team understands from experience that in
custom software development projects, new ideas come up
at any point during the process and need to be incorporated
into the software. This process will be handled in the Agile
development phase to allow for collaboration between
the technical workgroup and consultant team. One of the
primary acceptance items within the software reduurements
document will be an agreement that there will be no major
deviations in features or reports that would significantly, alter
the costs without approval.
Deliverables
• Revised wireframes
• Vorkflows
• Data standards, as needed
r
• Hours by staff to attend review meeting with additional
hours to review and provide feedback for revisions to
requirement documents.
�AS IK 4 ': CCWJII: ;II:
Description of Work
We will begin this task by configuring the Assembla space
as a code repository and set up a ticketing system to be used
during the Agile development process. Our team will set up
and configure development servers on our own infrastructure
for initial programming. We also propose hosting the
production DMS(s) on Amazon Wcb Services (AWS).
Deliverables
• Codc repository
• Ticket system
• Initial setup of the development environment.
Client Commitments
None.
MSK ;C: C"u11IL..II: CY1::..�..IICII: ILII: VII: IL..CII:IIII: IIS
Description of Work
Our team unll use an Agile software development
methodology to schedule the programming into numerous
sprints. This method allows our team to get feedback from
the technical workgroup along the way by demonstrating and
testing prototypes and early versions of the software.
One unique offering our team has is the ability to re -use
existing code from other DMSs and software we have
developed to save time and money. We envision being able to
reuse a significant amount of code from the Delta Mendota
and Kings Subbasin DMS as well as the CCTD well database
system. The amount of code that can be re -purposed will be
determined after the definition/design phase.
The coding sprints will be designed around the requirements
defined in Milestone 1. Some of the anticipated sprints
include:
• Landing page and user authentication pages
• General user interface (UI) design, layout, and navigation
styling
• Monitoring site module configuration (including wells,
surface water and subsidence) and attribute screens
• Import wizards based on data standards and templates to
upload time series data (water levels, water quality, river
levels, and subsidence)
• Specific defined permissions for read and write roles
by GSA, public, administrators and other user types
identified in requirements gathering.
• Administration screens (user management, annual data
submission status, monitoring site management, annual
reporting, summary statistics, exports, etc.)
• Configure GIS layers and functionality
• Integration with other third -party systems determined as
a requirement during the definition phase
• Program remaining miscellaneous features determined as
a requirement during the project definition phase
• Fully functional web UI including administration, data
entry, reporting, and other features determined for
inclusion in the product.
`1 x/111 11`1
Hours by staff to provide further clarification on specific
features, test prototypes, and provide feedback.
MSK & WA II...MA IN G
Description of Work
Before releasing the web application for testing by the
technical work -group, we will load historic monitoring site
locations and measurement data into the new system. We
assume there will be no need for manual data entry and data
will be provided by GSAs in spreadsheet or GIS templates
defined as part of Milestone 1.
• Imported subbasin data available for testing in the Beta
version of the wcb application.
KGA and or GSRs will be responsible for providing GTS
layers and spreadsheets for both the monitoring site locations
and attributes as well as the time series data in the format
agreed upon in the development of the data standards in the
project definition phase.
MilestoneTesting, Revisions,Deployment,
Training`
Description of Work
Before our team releases the Beta application for testing,
we will conduct a web -based meeting to demonstrate the
application and provide an opportunity for questions.
After the demonstration meeting, our team will release the
software to the project team for testing. Stakeholders will
be responsible for reporting bugs found during the testing
phase by using either a bug ticketing system we provide or a
consolidated Word document.
In our experience, users find subjective things (such as user
interface design changes) that have already been defined in
the project definition phase using the wireframes.
In general, we arc flexible with changes to the software within
the scope of work and estimated revision hours. Once our
team receives the list of revisions and feedback, we will
work with KGA staff to prioritize the revisions based on an
allocated set of hours included in the cost estimate. Our team
has budgeted 100 programming hours of revisions in this
phase.
Deliverables
• Test plan and instructions to report issues.
•
Link to online testing version of the web application.
Client Commitments
Hours by the technical workgroup to test and provide
feedback or report bugs.
MSK 3': ILII: II: IL..Ol(IIWI IIN
Description of Work
Our team will set up and configure production servers on
ANUS. After the production servers are set up, the code will
be deployed to the server and a final URL will be configured.
After the application is set up, our team will also refresh the
loaded data in case any of it has been altered during testing.
Deliverables
• Final application to be considered version 1.0.
Client Commitments
• None.
i. II< 9 ':..i RAll I IIN II IIN G
Description of Work
Project Schedule Overview
Our team understands that the Kern Basin's desire to have
Our team will begin this task creating a series of short how-to the system launched within 18 months after a contract is
videos focused around management of the system, importing
of annual data, and reporting. we have found short how-to
videos are used more than a lengthy training manual. They
are also more cost-effective to create and maintain. Based on
feedback from the technical workgroup we could also create a
simple illustrated user manual by user type. This also may be
useful in satisfying the grant deliverables.
Our team will also conduct wcb-based trainings based on
user types. This may include administration of the system,
GSA district staff for inputting their data, possible landowner
training and other user types that were outlined in the project
definition phase.
The trainings could be recorded for future viewing and
posted on a website.
Deliverables
• How-to videos training videos.
• DlVS user manual.
• DMS user training sessions by user type.
Client Commitments
• Hours by technical workgroup for the training sessions.
Milestone 4: Maintenance, Support, and Enhancement
Phase
Description of Work
Our team is always committed to supporting the software
solutions we develop. We arc proposing this phase mill be
setup as part of this project contract to leverage the grant.
Under this optional phase, we are proposing three (3) years
of web hosting for the DAIS, starting at the time the DMS
is setup so this should provide around 18-24 months of web
hosting covered while it is in production. `ye also propose a
block of hours for general technical support in the form of
helping end users, block of hours for fixes/revisions and a
third block of hours for enhancements that the users bring
to the technical workgroup for consideration. In the Fees
section (page 19), we describe the budget we recommend for
this DMS project. This stems from our experience with other
software applications.
signed to follow a grant workplan schedule. We do not see an
issue with meeting this type of timeline assuming the Kern
Basin technical workgroup have sufficient time to work with
the consultant on the requirements and testing phases. An
estimated timeline would be:
• Project Definition Phase: 4 months
• Development Phase: 8 months
• Testing, Revision and Deployment Phase: 4 months
The schedule could vary a bit depending on what features
are determined as a requirement in the project definition
phase. We would propose at the time of the kickoff meeting
to develop a schedule for the project definition phase as well
as a rough timeline for the development. Then during the
project definition phase, the schedule can be refined for the
development through deployment phases.
Our team used the information provided in discussions with
KGA, knowledge of other DMS software development
projects, and our creative ideas to estimate this cost proposal.
We understand that the Kern Basin has received planning
grant money to develop a DMS and contains other tasks
such as outreach and putting together data templates. They
received $500,000 award but approximately $57,000 is
contingent upon future allocations.
We also understand that there are parts of the project yet to
be defined, which makes it challenging to accurately estimate
the total project cost. We are committed to working with the
Kern Basin to develop the most cost-effective solution based
on the requirements defined in the project definition phase.
Our team always strives to provide the highest value services
and the most competitive costs. We will educate the technical
workgroup on ideas they may propose that could affect
future DMS maintenance costs and challenge the group to
think about the return on investment of ideas or the business
need it is trying to solve. If our clients are successful, we are
Successfi>l.
Our cost estimates were based on 2021 fee schedule for
services.
A summary of our cost estimate is provided on the following
page. The cost estimates are based on blended rates between
project team members. Since we have proposed a custom
software solution, there are no costs due to HFI for software
licensing or per users. KGA will be receiving great value
by using our team that can leverage their other DMS work.
The costs estimates were developed assuming there will be
a significant amount for planning and outreach put into the
project definition phase to explore and bring to consensus the
full range of functionality for the DMS. Our development
costs also assume that the DMS will at a minimum, support
SGMA regulations, annual reporting generation tools and
a centralized database for sharing information within the
basin. If other functionality is brought up during the planning
phase, we can provide an optional cost estimate for those
items. At this point we did not feel it was reasonable to make
any other assumptions about functionality for the DMS,
but instead focused on aligning our tasks with your grant
workplan details.
As you will see our costs are well below your grant award
amount, which provides a lot of opportunity and flexibility
to develop additional features if they are deemed required.
Money could also be used to pay for additional data migration
services if the GSAs do not have staff to do this themselves
or fund the KGA staff coordination time or time from other
consultants in the GSP development to provide their input
and ideas in the discovery process.
WHOM=
iii r
Task 1: Project Start-up and Kick-off Meetings 80 $13,500 $0 $13,500
Task 2: Discovery Meetings and Requirement 287 $60,000 $5,000 $65,000
Documents
Task 3: Finalize Requirement Documents 76 $12,500 $0 $12,500
Task 4: Set Up Servers and Project 25 $3,500 $0 $3,500
Management Software
Task 5: Software Development and 560 $75,000 $0 $75,000
Implementation
Task 6: Historic Data Gathering and Loading 70 $11,000 $0 $11,000
Task 7: Testing and Revisions
204 $30,000
$0
$30,000
Task 8: Deployment
20 $3,000
$0
$3,000
Task 9: Training
26 $4,500
$0
$4,500
1 abor costs °sic:: caCUa°s i 3 USS Ilg IAinded rat:,s frons 2021 fee schefis.
**1DI-Eld Casts W()Llci be travcfl hvsc; costs fo cine sc.rl s ofon sl :, iiceelngs
The table below represents an optional cost that could be included in the contract for a two-year MIS maintenance period and
possibly covered by the grant.
User Technical Support 100 $14,000 $0 $14,000
Fixes / Revisions 100 $14,000 $0 $14,000
Enhancements 100 $14,000 $0 $14,000
�� rr� ��r�w�ur��fcirt(� r�,uflnv�rrf�i 11rx'Crt I'Jlrtri�a;1� rrr��nt ,�i�f�rrrr �?0
Appendix A: Resumes
Jeff Eklund, PE Professional
IFlrndpaIl...lin..Charge
Education
✓ B.S. Civil Engineering,
California State University Fresno
✓ A.S. Engineering,
Bakersfield College, California
Licenses/Registrations/Certifications
✓ Civil Engineer, California #75680
Affiliations
✓ American Society of Civil Engineers (ASCE)
Areas of Expertise
✓ Irrigation District Systems
✓ Water Supply Studies
✓ Groundwater Wells
✓ Canals
✓ Groundwater Banking
✓ Recycled Water Systems
✓ Water Distribution Systems
✓ Wastewater Collection Systems
✓ Grading & Drainage
✓ Pump Station Design
✓ Grant Funding
Jeff Eklund is a principal engineer and vice president at Provost &
Pritchard with over 17 years of experience in the field of civil engineering.
He has design experience on a variety of municipal infrastructure projects
in the areas of water supply and distribution, groundwater, wastewater
collection, grading and drainage, and pipelines. In addition, he has been
involved in the preparation of feasibility studies and construction plans,
and as well as coordinating and permitting with various public agencies
and utility companies. Mr. Eklund has been responsible for coordinating
all aspects of projects including preparing and managing construction
contracts, managing the quality and financial aspects of projects,
documentation of construction work, and coordination and management
of with contractors.
TCP Mitigation Project, Water Resources Department, Bakersfield, California,
Principal -In -Charge — The project consisted of the evaluation of the City's
domestic water system to recommend supply and treatment alternatives
to mitigate for water quality regulations that went into effect on January 1,
2018. Factors considered included water supply availability, water quality,
hydraulics, constructability, and schedule constraints. The recommended
alternative to design and construct Granular Activated Carbon treatment
systems at 35 well sites was contracted to WTV. Lyles Company and
Provost & Pritchard as a progressive design -build project. The project
was completed on a fast-track schedule ensuring compliance with the new
regulation. Mr. Eklund served as principal -in -charge overseeing all aspects
of the project administration, design, and construction support services.
✓ Rate Studies Steuber Well, Golden Hills Community Services District, Tehachapi, County
of Kern, California, Project Manager — Mr. Eklund was the project manager
for the Antelope Conjunctive Use Project — Stcuber Phase for the
Golden Hills Community Services District. The scope of work included
design and development of construction and bidding documents for the
construction of a 690 -foot public water supply production well, and the
design and development of construction and bidding documents for the
construction of 4,100 -feet of 14 -inch diameter pipeline, 600 -feet of 8 -inch
pipeline, installation of a precast concrete pumphousc, and associated
electrical facilities. Mr. Eklund also provided construction phase services
and construction oversight during the construction of the well and pipeline
improvements.
6 I
rri�e�viUPl�iu/rJt(!r��U(rli'irl(�/ )rX'trr'drJYirX(l(Y�1(rY1'C i�/�((^Y°1 A 1
Jeff Eklund, PE • ed
IirindpM in Charge
Lerdo Campus Water Improvements, County of Kern, California,
Principal -In -Charge — Provost & Pritchard evaluated and
designed water and wastewater infrastructure improvements
required to accommodate for a new 822 bed jail at an
existing Kern County Sheriff's Office detention campus.
The Project consisted of providing engineering and design
services for the water system improvements, which included
the construction and equipping of two (2) new groundwater
supply wells, sulfide removal treatment, a 1.25 million gallon
water storage tank, a 3,500 gpm high pressure fire pump,
a high service pumping station, and water distribution
system improvements. Engineering oversight was provided
throughout the course of construction.
Recharge and Recovery Enhancement, Kern Water Bank
Authority, Kern County, California, Project Manager — Mr. Eklund
provided planning and design engineering services for the
Recharge and Recovery Enhancement Project for the Kern
Vater Bank Authority. Mr. Eklund managed the project team
in preparing planning documents needed for a successful
grant application under the TRWMP program. The project
scope of work included the construction of 190 net acres of
new recharge ponds, three new recovery wells and 1.7 miles
of pipelines. Mr. Eklund reviewed proposed designs, assisted
with permitting, and assisted with construction management.
Well No. 5, Buttonwillow County Water District, Kern County,
California, Principal -In -Charge — Mr. Eklund was the principal -
in -charge for the Well No. 5 Project for the Buttonwillow
County Water District. The Project consisted of the
construction of anew groundwater supply well. Due
to water quality concerns, the new groundwater supple
well included depth zone specific water quality formation
sampling in the pilot hole and the well was constructed with
polyvinyl chloride (PV'C) well casing. The final groundwater
supply well was constructed to a depth of 810 -feet. The
groundwater supply well design successfully mitigated for
water quality concerns.
Abajo Avenue Transmission Pipeline, Golden Hills Community
Services District, Kern County, California, Project Manager— Nfr.
Eklund was responsible for the planning and design of a
one -mile long, 18 -inch water transmission pipeline project
that connects two storage tanks improving water system
performance. The planning and California Environmental
Quality Act (CEQA) portion of the project consisted of
the preparation of an initial study and mitigated negative
declaration for the project. A right-of-way analysis was
conducted at the beginning of the project to determine
the pipeline alignment alternatives and potential conflicts
with existing utility easements. The project also included
the acquisition of pipeline easements along the proposed
alignment, including assistance with eminent domain
proceedings with one landowner. Design aspects consisted
of preparing a WaterCAD model of the distribution
system to assist in sizing the pipeline and ensuring that
the project objectives would be met. Construction plans,
specifications, and a construction cost estimate were prepared
in coordination with District staff and the project was
advertised for public bid in December 2012. Mr. Eklund
coordinated the bidding process and assisted the District
with management of the construction contract including
construction inspection. The pipeline was completed April
2013 and currently operates in accordance with the design
parameters.
Agricultural Water Supply System Master Planning, Newhall
Land and Farming Company, Valencia, California, Assistant
Engineer — This project consisted of an 8 -mile large diameter
pipeline system for the Newhall Ranch. The facilities
include nine new wells with supervisory control and data
acquisition (SCADA) system integration, and connections
to multiple farmer turnouts with different pressure zones.
Analyses of the system consisted of master planning of the
facilities, coordination with the land development staff and
consultants, hydraulic analyses utilizing WaterCAD, review of
potential water -hammer effects, and preliminary design of the
well sites. Sonic portions of this phased project have been
designed and are currently in construction.
^,.( i'n ( i,n A
Gavin O'Leary, GISP
IFlroect I inager/Sinlbr GIS Spedi Ihst
Education
✓ B.S. Fisheries Biology & Management,
Humboldt State University; California
Licenses/Registrations/Certifications
✓ Certified GIS Professional (GISP), #99203
✓ Geographic Information Systems (GIS)
Certificate Program, American River College
Areas of Expertise
✓ Geographic Information Systems (GTS)
✓ Disadvantaged Communities
✓ Groundwater Analysis
✓ Water Facilities Data
✓ irrigated Lands Regulatory Program
✓ Sustainable Groundwater Management Act
✓ Proposition 218
✓ Global Positioning Systems (GPS)
✓ Cartography
Gavin O'Leary is a geographic information systems (GIS) specialist
and project manager with 18 years of experience. He has an extensive
background in spatial analysis and database creation with geospatial data.
Mr. O'Leary's areas of expertise include mapping and analysis of well water
depth data, spatial analysis of groundwater storage, management of water
agency facilities data, assessor parcel data, and data conversion and creation
from historic sources. He has also worked as an aquatic scientist for the
California Department of Water Resources (DWR) and has supported
resource management and conservation planning with GIS while working
in a contract position for the California Department of Fish and Wildlife.
Multiple Groundwater Sustainability Agencies, Groundwater Sustainability Plan
(GSP) Preparation, California, GIS Specialist — Mr. O'Leary supported the
spatial data needs for more than 10 GSP documents currently in process
for critically over drafted groundwater basins. This includes a variety of
tasks for each GSP.
• Managing large data sets (+100,000 records) for multiple disciplines
• Performing spatial analysis to calculate groundwater floe direction,
change in groundwater storage, and aquifer_ characteristics
• Analysis of groundwater quality data
• Review of historic groundwater conditions
• Review of local agency service areas and disadvantage communities'
locations
• Classification of groundwater wells from construction details
• Data cleaning and conversion for analysis
• Merging data from multiple stakeholders for coordinated subbasin
analyses
• Preparation of map figures for final report
• Generate statistical data summaries
• Implement data management systems to organize data for SGMA
compliant data collection and annual reporting
• Proposition 218 support services
Multiple Groundwater Sustainability Agencies, Annual Report Preparation,
California, GIS Specialist — Mr. O'Leary is currently supporting data
gathering and analysis for multiple Annual Reports for Groundwater
Sustainability Agencies in the Southern San Joaquin Valley. This includes
data analysis of changes in groundwater levels, land use, and surface water
usage over a defined period.
^,.( i'n ( i,n A
Gavin O'Leary, GISP (continued)
:rirt aptII" airnageir/Seir k)ir GIS Sped4llst
Tulare Kern Funding Area IRWM DAC Involvement Program,
DAC Needs Assessment, Tulare County, California, GIS Specialist
— Mi. O'Leary was the lead spatial data analyst leading
the GIS needs of the project. Data for incorporated and
unincorporated communities was compiled and standardized
for review by the project working group and stakeholders. A
GIS web -based Story Map was created to convey information
about communities in the study area and a geodatabase was
compiled to contain all of the standardized information
collected about each community. A report was generated (in
DRAFT) showing summaries of the compiled GIS data as
maps and tables.
Kern River Watershed Coalition Authority (KRWCA), Kern County,
California, GIS Specialist — Mr. O'Leary performs ongoing
data management and spatial analysis in support of the State
Water Resources Control Board reporting requirements
for the KRNVCA. This included managing coalition
membership and associated parcels to support reporting and
outreach needs. The analysis included combining data from
hydrogeologic, topographic, soils, water quality and field level
crop data in a GIS to prioritize vulnerable lands. Extensive
analysis maps and tabular summaries were created in support
of this ongoing project.
Kings County Water District (KCWD), Kings County, California,
GIS Specialist — Mr. O'Leary provides ongoing GIS support
for KCNVD. This includes data creation, locating historic
data, converting data formats, analysis and map creation.
District data is maintained in a geodatabase. A wide variety
of data is utilized to help answer questions and solve
problems that relate to spatial data.
San Joaquin Valley IRWMP Support, Fresno, Kings, Tulare,
and Kern Counties, California, GIS Specialist — Mr. O'Leary
has performed GIS mapping support for successful IRW'XI
grant applications as well as GIS data analysis for several
IRWM projects. Tasks included review of disadvantage
communities, potential project locations, census data, historic
and current irrigated crop information from multiple sources,
review of natural and artificial waterways, NRCS soils, and
FEMA flood data. Final products included detailed maps and
data summary tables to support projects and grant proposals.
Enterprise Canal Watershed Survey, City of Clovis and City of
Fresno, California, GIS Specialist — Mr. O'Leary performed a
sanitary survey to assess possible sources of contamination
to the Enterprise Canal which provides drinking water for the
cities of Clovis and Fresno. He utilized a global positioning
system (GPS) -enabled mobile GIS (moving map display) to
collect feature locations, evaluated potential source threats,
and summarized survey findings with detailed GIS map book.
Groundwater Contaminant Plume Mapping, City of Merced,
California, GIS Specialist — This project consisted of the
preparation of bi-annual report map figures showing analysis
surfaces and contours for predicted values of constituents
in groundwater. Mr. O'Leary worked with a hydrogeologist
to interpret data from lab samples to create representative
surfaces in GIS.
Historic Landfill Mapping, Fresno Irrigation District, Fresno
County, California, GIS Specialist — This project included
creating a map interface for desktop GIS users to access
historic landfill and contaminant plume information that was
previously not referenced to spatial locations. Historic report
figures were georeferenced, digitized, and linked to original
reports for easy access in GIS. Parcel data was also associated
with site locations.
Historic Groundwater Mapping Project, Lower Tule River Authority,
Tulare County, California, Project Manager— Mr. O'Leary was
responsible for accumulating and organizing 10 years of
historic well water measurement data over a 750 square -mile
area in Tulare County. He worked with a hydrogeologist
to analyze and map well water elevation and depth data of
approximately 900 wells. In addition, he created a GIS to
manage water level data and store spatial analysis data.
Relational Database, Fresno Irrigation District, Fresno County,
California, GIS Specialist —This project involved the creation
of a relational database to manage well water level reading
data and an active link to a GIS. Mr. O'Leary created custom
GIS tools for groundwater data retrieval and designed custom
forms for data entry and reporting from the relational
database. Mr. O'Leary also completed comprehensive high
precision GPS surveys of approximately 200 wells.
, i'n ei,n Ai
Kaitlin Palys
Water Resources '�
��I CIiIIIiSt
Education
✓ B.S., Environmental Science, Water Science
& Quality Option, Wetland Science Minor,
Virginia Polytechnic Institute & State
University (Virginia Tech
Licenses/Registrations/Certifications
✓ Virginia Department of Mines, Minerals and
Energy (DI\I ME) Certified
✓ Mine Safety & Health Administration
(1\ISHA) Certified
Areas of Expertise
✓ Environmental Regulations
✓ Sustainable Groundwater :Management Act
✓ Integrated Regional Water Management
Program
✓ Water Budgets
✓ Environmental Planning (CEQA/NF,PA)
✓ Data Management
✓ Water Quality
✓ Wetland Soils & Mitigation
✓ Groundwater Well Installation and Sampling
✓ Infiltration Tests
✓ Wetland Delineation
✓ Soil Descriptions
Kaitlin Palys is an Associate Water Resources Specialist with Provost &
Pritchard, providing technical assistance to the firm's Water Resources
service sector. A recent graduate from Virginia Tech University, Ms. Palys
has a strong understanding of the physical sciences behind water resources,
as well as the regulatory hurdles faced by many of the clients. Specifically,
her experience includes, water supply and feasibility studies, SGMA
compliance, data management, and water budget calculations. Ms. Palys is
also skilled in groundwater well installation and sampling, infiltration tests,
wetland delineation, soil descriptions, field soil and water chemistry.
San Gorgonio Pass Groundwater Sustainability Plan — Ms. Palys is
involved with the development of the San Gorgonio Pass Groundwater
Sustainability Plan (GSP) due in January, 2022. She provides technical,
report, presentation, and data inventory services for their respective GSP
development. Ms. Palys assists on data management, GSP report writing
and review, sustainable management criteria development, monitoring
network development, GIS coordination, groundwater dependent
ecosystem determinations, data review, and stakeholder outreach.
Grassland Groundwater Sustainability Plan — Ms. Palys assisted the
development of the Grassland Groundwater Sustainability Plan (GSP)
and is involved in providing technical, report, and data inventory services
for their respective Annual Reporting. Ms. Palys assists on water budget
development, GSP report writing and review, sustainable management
criteria development, monitoring network development, GIS coordination,
groundwater dependent ecosystem determinations, data review and
inventory, and stakeholder outreach.
✓ Field Soil and `Fater Chemistry Northern & Central Delta -Mendota Groundwater Sustainability Plan — Ms.
✓ CalEEMod 2016.3.2 Palys was involved in providing data management, technical, and report
services for the Northern & Central Delta -Mendota GSP group, which is
comprised of nine Groundwater Sustainability Agencies and spans from
Patterson, CA to Tranquillity CA. Her responsibilities include assisting
with data requests, inventory and review, GIS coordination, groundwater_
dependent ecosystem determinations, and data specific GSP or technical
memo writing She is now a project manager on the Northern & Central
Delta Mendota Region's 2020 Annual Reporting and implementation
efforts.
Aliso Water District Groundwater Sustainability Plan — Ms. Palys assisted the
development of the Aliso Water District Groundwater Sustainability Plan
(GSP) and is involved in providing technical and report services. Ms. Palys
assists on water budget review, GSP report writing and review, sustainable
management criteria development, groundwater dependent and ecosystem
determinations.
"' i'n ,y, l i'n A 5
Kaitlin Palys (continued)
Water Resources Speddhist
Tranquillity Irrigation District Annual Report and Data
Management System —Tranquillity Irrigation District (TID) is
developing an Annual Report and Data Management System
in response to growing reporting requirements. Ms. Palys is
involved in the Annual Report writing and Data Management
System development. 1\Is. Palys is also involved in TID's
monitoring and reporting requirements associated with its
involvement in the North & Central Delta -Mendota GSP
Group.
Delta -Mendota Subbasin Coordinated Effort — The Delta -
Mendota Subbasin is comprised of six GSP groups and
is developing a common chapter to meet coordination
requirements identified in regulations associated with the
Sustainable Groundwater Management Act (SG -MA). Ms.
Palys is involved in GIS coordination, data management
system facilitation, and coordinated decision recording for
the Delta -Mendota Subbasin's technical and coordination
committees.
Kings River East Groundwater Sustainability Agency Water
Budget — Ms. Palys assisted the data requests and development
of the historic, current, and projected water budgets for the
Kings River East Groundwater Sustainability Agency.
Westside -San Joaquin Integrated Regional Water Management
Program —Ms. Palys assisted in the Westside -San Joaquin
Integrated Regional Water Management (WSJ IRWT\1) Plan
2018 Update. Ms. Palys' responsibilities included public
outreach and project inventory, selection, and prioritization.
Ms. Palys is also involved in developing the Prop 1 grant
application for the WSJ IRWAT Plan's projects in the San
Joaquin River Funding Area.
Pleasant Valley Water District Prop 1 Grant Services — FIs. Palys
was involved in providing grant services for Pleasant Valley
Water District (PVWD). PVWD is located in the WSJ IRWM
Region and overlaps the Tulare Kern Funding Area. Ms.
Palys is specifically involved in Project Information Form
development and submission of projects to the WSJ IRW`X1
Plan 2018 Update.
Surface Water Monitoring and Consulting, Kern River Watershed
Coalition Authority, Kern County, California, Project Planner—
Ms. Palys was involved in providing monitoring and report
support services for the surface water component of the
Monitoring and Reporting Program (MRP) for the Kern
River Watershed Coalition Authority (KRWCA).Her specific
responsibilities included assisting with monthly water quality
monitoring and quarterly submittals.
Surface Water Monitoring and Consulting, Kaweah Basin
Water Quality Association, Tulare County, California, Project
Planner —Ms. Palys assisted the Kaweah Basin Water Quality
Association (KBWQA) in the surface water component
of the Monitoring and Reporting Program (XIRP). Her
responsibilities included assisting with the preparation of
monthly water quality monitoring and quarterly submittals.
^,.( i'n ( i,n A 6
Brian Fischer
jbdhirnlicd II...ead
Houston Engineering, Inc.
Education
✓ M.S., Geographic Information Science,
University of Minnesota -Twin Cities
✓ B.A., Geography and Environmental Studies,
University of Nebraska -Lincoln
Brian Fischer founded and leads the technology and GIS services out of
HEI's Maple Grove office. He is also on HEI's Board of Directors and
provides a leadership role in the company. Brian regularly provides project
management in the areas of GIS analysis, GIS mapping, database design,
programming, web application development, and mobile application
development. His GIS expertise includes agricultural and water resource
applications, web and mobile applications, decision support systems,
environmental/natural resources applications, engineering applications, and
UDAR collection/processing as well as GIS for California government,
irrigation districts, and groundwater sustainability agencies (GSRs).
Delta -Mendota Subbasin Data Management System, Woodard & Curran, Inc.,
Sacramento, California, Project Manager — HEI is working with Woodard
& Curran and the Delta -Mendota Subbasin Groundwater Sustainability
Agencies in developing two unique Data Management Systems (DMSs)
for Santa Nella County Water District's and Delta -Mendota Subbasin. The
project includes project conceptualization with a working group, software
requirements definition, data standards, and the build out of a web -based
DMS application.
Kings Subbasin Data Management System, Provost & Pritchard Consulting
Group, Visalia, California, Project Manager — HEI is workkg with Provost
& Pritchard and the Kings Subbasin GSAs in developing a DMS for
the coordinating Kings subbasin plan. The project includes project
conceptualization with a working group, software requirements definition,
data standards, and the build out of a web -based DMS application.
Well Database Management System, Central California Irrigation District,
Los Banos, California, Project Manager — HEI developed a web -based
management system to help manage wells, subsidence, and related
district data. The project began with a focus on defining the needs of the
software through data gathering and discovery meetings. HEI was then
responsible for the subsequent development, testing and revisions, hosting,
and ongoing maintenance. The DMS has continued to serve the San
Joaquin River Exchange Contractors GSA as a DMS for use within their
coordinated basin plans.
GIS Program Development, Central California Irrigation District, Los Banos,
California — GTS Project Manager in developing districtwide GTS data
management system to support operations and maintenance. The project
involved data conversion from AutoCAD to ArcGIS, web -based map
viewer integration with water accounting software, and training. HEI
continues to support the district on an annual basis with their GIS needs.
"' i'n�eriwiUY�iiu/rJ�(!r�Uflfi'irlfi/ )rX'CrJ'drJY�rX(1(�Y�1(rY1'C ""iy, l(i'n A 7
Joshua Donato
Software II igiirneer
Houston Engineering, Inc.
Education
✓ M.S., Civil Engineering,
University of Minnesota
✓ M.A., Geography,
State University of New York at Binghamton
✓ B.A., Physics,
State University of New York at Cortland
Joshua Donato serves clients as a Software Engineer II out of HEI's
Maple Grove office. His technical expertise includes ArcGIS 10.x, Web
Appbuilder for ArcGIS, GeoServer, PostgreSQL/PostGIS, GDAL/
OGR, ArcPy, SQL, HTNILS, XML, CSS3, Python, Django JavaScript,
jQuery; ArcGIS JS, D3, Dojo, jQuery, React/Redux, Leaflet, OpenLayers,
C#.NET, ASRNET Core, Visual Studio, Eclipse, RubyMine, webStorm,
PyCharm, Windows, and Ubuntu.
Delta -Mendota Subbasin Data Management System, Woodard & Curran,
Inc., Sacramento, California, Developer — HEI is working with Woodard
& Curran and the Delta -Mendota Subbasin Groundwater Sustainability
Agencies in developing two unique Data Management Systems (DMSs)
for Santa Nella County Water District's and Delta -Mendota Subbasin. The
project includes project conceptualization with a working group, software
requirements definition, data standards, and the build out of a web -based
DMS application.
Madera and Chowchilla Subbasin Data Management System, Madera
County, Madera, California, Developer — HEI is working with the GSRs
in these two subbasins to define the requirements and then develop two
unique Data Management Systems (DMSs). The project includes project
conceptualization with a working group, software requirements definition,
data standards, and the build out of a web -based DMS application.
Fieldprint® Calculator, Field to Market, Washington DC, Software Engineer
— Field to Market hired Houston Engineering, Inc. (HEI) to update the
Fieldprint® Calculator to the next generation and provide continual
maintenance. Joshua's tasks include updating the software to improve its
various functions, data, and features; testing applications and scenarios;
generating the FieldprintOO application; and coding.
Water Supply Decision Dashboard, Weber Basin Water Conservancy District,
Layton, Utah, Developer — The Weber Basin Conservancy District contracted
HEI to develop an online dashboard for users to display and download
water resource data, view the current drought level, and provide an
interactive map with man-made features and landscape scale features
affecting eater movement. Joshua's responsibilities include developing a
database to store dashboard data, writing software to extract water resource
data from various online resources and insert into the database, and
develop the Water Resources Dashboard website. Joshua utilized ASP.NET
Core for his work on this project.
o,.( i'n ( i'n A i;4
Steve Jakala
Software II igiilrneeir
Houston Engineering, Inc.
Education
✓ M.S., Geographic Information Science,
Saint Mary's University of Minnesota
✓ B.A., Marketing with focus in GIS,
University of St. Thomas
Steve Jakala serves as a Software Engineer II for specific projects for HEI.
He has 10 years of experience working with .NET, JavaScript, Python,
GIS, and a variety of databases.
Delta -Mendota Subbasin Data Management System, Woodard & Curran,
Inc., Sacramento, California, Developer — HEI is working with Woodard
& Curran and the Delta -Mendota Subbasin Groundwater Sustainability
Agencies in developing two unique Data Management Systems (DMSs)
for Santa Nella County Water District's and Delta -Mendota Subbasin. The
project includes project conceptualization with a working group, software
requirements definition, data standards, and the build out of a web -based
DMS application.
Madera and Chowchilla Subbasin Data Management System, Madera
County, Madera, California, Developer — HET is working with the GSA's
in these two subbasins to define the requirements and then develop two
unique Data Management Systems (DMSs). The project includes project
conceptualization with a working group, software requirements definition,
data standards, and the build out of a web -based D1\IS application.
Enterprise GIS Applications, Best Buy, Richfield, Minnesota, Developer — Built
multiple Enterprise GIS applications supporting the work of Best Buy's
Global Properties team with over 1,500 corporate and field users across
the company. These GTS applications and the ETI, processes that gather
datasets, which are sourced from a vide range of enterprise databases
provide users a view of store performance, competition, demographics,
and custom GTS analysis tools.
Reporting Solution Development, Best Buy, Richfield, Minnesota, Developer —
Built multiple reporting solutions for Best Buy's Global Properties team
utilizing SQL Server Reporting Services, and custom .NET solutions to
automate ETL processes, report generation, and delivery.
National Institute of Health (NIH) —As a sub -consultant, helped build
reporting tools that integrated AutoCAD files, ArcGIS, and Crystal reports
using Python and .NET to automate the production of building floorplan
reports, which combined maps and tabular data stored in an Oracle
database.
Invision Suite, PenBay Solutions. Developer—Worked on multiple parts
of PenBay Solutions Invision Suite software, including backend APIs,
installation and deployment tools, ArcGTS Desktop extensions, and custom
Python -based CAD ETL tools (converting CAD to GIS data).
eI'I"i ail"I7
G 'f
Joe Jeurissen
�bdhinr icd Support
Houston Engineering, Inc.
Education
✓ AAS, Programming,
Hennepin Technical College
Joe Jcurissen's responsibilities with HEI include the design and
development of custom interactive GIS applications and the development
of web -based database applications. His skills include a broad base of
programming languages and applications.
Kings Subbasin Data Management System, Provost & Pritchard Consulting
Group, Fresno, California, Developer — HEI is working with Provost &
Pritchard and the Kings Subbasin Groundwater Sustainability Agencies
in developing a DMS for the coordinating Kings subbasin plan. The
project includes project conceptualization with a working group, software
requirements definition, data standards, and the build out of a web -based
DMS application.
Fieldprint® Calculator, Field to Market, Washington DC. Software Engineer
— Field to Market hired HEI to update the Fieldprint® Calculator to the
next generation and provide continual maintenance. Joe provides coding;
maintains the application's homepage; fixes bugs as they arise; updates
the database; incorporates various agricultural characteristics into the
application's database, such as crop rotations, seeding rates, and crop
orders; and performs server testing.
Well Database Management System, Provost & Pritchard Consulting Group,
Los Banos, California, Lead Developer — HEI developed a web -based
management system to help manage well attributes and activities. The
project began with a focus on defining the needs of the software through
data gathering and discovery meetings. HEI was then responsible for
the subsequent development, testing and revisions, hosting, and ongoing
maintenance.
MS4Front Permitting Assistance, Minneapolis, Minnesota, Programmer — HEI
worked with City staff to implement MS4Front to help with permitting for
the City. Features of the application include centralized storage of private
and public stormwater BMP inventories, a field inspection application
for mobile devices, and automated letter correspondence to regulate
storm -water utility credit program private BMP program enforcement.
Integrated Database and Web Interface for the Irrigated Lands Regulatory
Program, Provost & Pritchard Consulting Group, Tulare Lake Basin Area,
California, Assistant Developer — HEI worked with Provost & Pritchard
Consulting, Kern River Watershed Coalition Authority, and Kaweah
Basin Water Quality Coalition to develop a web -based database to meet
data management needs and assist members in reporting requirements
to the California Water Quality Board based on the Waste Discharge
Requirements General Order for Growers within the Tulare Lake Basin
Area. Separate interfaces were designed to provide access to coalition staff,
coalition members, and consultants supporting coalition members.
�erfviUrl�"iU/rJ�(!r�Uflfi'irlfi� )rX'CrJ'drJY�rX(�(�Yrl(rY1'C ii/�((^Y"�1 A 10
Chad Nunemaeher
�bdhinn Bpd Support
Houston Engineering, Inc.
Education
✓ B.S., Geographic Information Systems,
University of Wisconsin -La Crosse
Chad Nunemacher has vast GIS and analyst experience. As an ArcGIS
Server Implementation Technician, he has led projects to install and
configure ArcGIS servers, and is many times responsible for the underlying
GIS infrastructure. As a project manager, he has overseen numerous
projects and has played a significant role in the softxvare development
role as well. As an analyst and consultant, he has assisted customers with
GAP analysis, reports, flow charts, diagrams, recommendations, potential
impact statements, and more. Chad has more than 13 years of applied GIS
experience and complementary business analyst experience.
Delta -Mendota Subbasin Data Management System, Woodard & Curran, Inc.,
Sacramento, California, Senior GIS Analyst — HEI is working with Woodard
& Curran and the Delta -Mendota Subbasin Groundwater Sustainability
Agencies in developing two unique Data Management Systems (DMSs)
for Santa Nella County Water District's and Delta -Mendota Subbasin. The
project includes project conceptualization with a working group, software
requirements definition, data standards, and the build out of a web -based
DMS application.
Web GIS App for Consolidated Irrigation District, Provost and Pritchard
Consulting Group, Selma, California, GIS Project Manager— On behalf of
the Consolidated Irrigation District in Selma, CA, Provost and Pritchard
Consulting Group hired HEI to develop a new web GIS application.
Chad's responsibilities include using Esri's Web AppBuilder (WAB) for
ArcGIS to create the application, coordinating and communicating with
project partners, configuring the website map, participating in several
meetings with the client to review WAB options and decisions, providing
troubleshooting support, developing a custom ArcGIS N eb AppBuilder
widget, and completing application testing.
Web GIS App for Disadvantaged Communities, Provost and Pritchard
Consulting Group, Tulare, California, GIS Project Manager— On behalf of the
State of California Department of Water Resources and Tulare County,
Provost & Pritchard hired HEI to develop an ArcGIS StoryMap comprised
of informative/ GIS interactive pages as well as tabs embedded with
custom Web AppBuilder applications. Chad's responsibilities include using
WAB for ArcGIS to create the storymap application, coordinating and
communicating with project partners and HEI development staff, creating
a complex python script for automated data harvesting, manipulation, and
GIS services publishing, configuring the website map, leading the ArcGIS
Online to Portal for ArcGIS data migration, participating in several
meetings with the client to review WAB options and decisions, providing
troubleshooting support, and completing application testing.
ei'n ei'n A 1
PROVOST&
PRITCHARD
An Employee Owned Company
Fresno • Clovis • Visalia • Bakersfield • Modesto • Los Banos • Chico • Sacramento
www.provostandpritchard.com • info@ppeng.com