Loading...
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