ITEM 4. 9
CITY MANAGER' S REPORT
FEBRUARY 13, 2023 CITY COUNCIL REGULAR MEETING
ITEM: APPROVE AMENDMENT NO. 2 WITH EKI TO
UPDATE THE INTEGRATED WATER RESOURCES
MASTER PLAN, CIP PW 22- 19 AND CIP WW 22-
24 AND APPROVE BUDGET AMENDMENT
RECOMMENDATION: Adopt Resolution Approving Amendment No. 2 with EKI Environment & Water, Inc. to update
the Integrated Water Resources Master Plan,
CIP PW 22- 19 & CIP WW 22- 24 and Approve
Budget Amendment
CEQA STATUS: The project is exempt according to California Environmental Quality Act Article 18 § 15262,
Feasibility and Planning Studies"
SUMMARY:
The Integrated Water Resources Master Plan ( IWRMP) is necessary to implement the City' s General Plan and supports utility operations, budget, and rate studies. The Master Plan is also the basis for CIP programming, developing land use planning and development fees. On April 11, 2022, Council approved an agreement with Environment & Water, Inc. ( EKI) to update the IWRMP. Additional services from EKI are essential to update the City' s geodatabase for the water, wastewater and recycled water systems.
Staff is requesting that Council approve Amendment No. 2 with EKI to provide the geodatabase updates needed to support the IWRMP Amendment in the amount of 89, 500.
Sufficient funds were not included in the adopted FY 22/ 23 budget for CIPs PW 22- 19 and WW 22- 24. Staff requests that Council approve a budget amendment allocating $ 30, 670 from the Water System Capital Replacement Fund 5600 to CIP PW 22- 19 and $ 23, 035 from the MBR Capital Replacement Fund 6110 plus $ 12, 957 from the Wastewater Capital Replacement Fund 6060 enterprise funds to CIP WW 22- 24.
The remainder of the cost for the EKI Amendment No. 2 will be allocated from the project contingency available in CIP PW 22- 19 ( Water) and CIP WW- 24 ( Wastewater and Recycled Water).
BACKG ROU N D:
The Public Works Department is responsible for managing and maintaining the City' s water, sewer, and recycled water facilities.
CITY MANAGER' S REPORT PAGE 2
FEBRUARY 13, 2023 CITY COUNCIL REGULAR MEETING
APPROVE AMENDMENT NO. 2 WITH EKI FOR IWRMP AMENDMENT, CIP PW 22- 19 AND CIP WW 22- 24, AND APPROVE BUDGET AMENDMENT
The IWRMP will forecast and update the water and sewer demand projections and address modifications in regulatory requirements, population and growth projections, proposed land use, climate change, and other factors.
On April 11, 2022, Council approved an agreement with EKI to update the IWRMP.
Additional services from EKI are needed to update the City' s water, sewer, and recycled water systems geodatabase to complete the IWRMP amendment.
REASON FOR RECOMMENDATION:
The IWRMP is necessary for the implementation of the City' s General Plan and supports utility operations, budget, and rate studies. The Master Plan is also the basis towards CIP programming, developing land use planning and development fees.
CEQA STATUS:
Staff has determined the CEQA status for the project as exempt according to California Environmental Quality Act Article 18 § 15262, Feasibility and Planning Studies".
The De Novo Planning Group prepared the Environmental Impact Report for the current IWRMP that was adopted in 2019, and Staff will be retaining De Novo to prepare an Initial Study/ Mitigated Negative Declaration for this project.
FISCAL IMPACT:
The cost of Amendment No. 2 to provide geodatabase support for the IWRMP is for an amount of $89, 500. The table below represents the cost breakdown for each task.
Master Plan U date Component Cost
U date Water S stem Geodatabase PW 22- 19 29, 700
U date Wastewater S stem Geodatabase WW 22- 24 42, 600
U date Rec cled Water S stem Geodatabase WW 22- 24 17, 200 Sufficient funds were not included in the adopted FY 22/ 23 budget for CIPs PW 22- 19 and WW 22- 24. Staff requests that Council approve a budget amendment allocating $ 30, 670 from the Water System Capital Replacement Fund 5600 to CIP PW 22- 19 and $ 23, 035 from the MBR Capital Replacement Fund 6110 plus $ 12, 957 from the Wastewater Capital Replacement Fund 6060 enterprise funds to CIP WW 22- 24.
Staff requests Council approve the following budget amendment:
CITY MANAGER' S REPORT PAGE 3
FEBRUARY 13, 2023 CITY COUNCIL REGULAR MEETING
APPROVE AMENDMENT NO. 2 WITH EKI FOR IWRMP AMENDMENT, CIP PW 22- 19 AND CIP WW 22- 24, AND APPROVE BUDGET AMENDMENT
Increase Transfer Out
5600- 99- 00- 990- 9010 30, 670
Increase Transfer Out
6110- 99- 00- 990- 9010 23, 035
Increase Transfer Out
6060- 99- 00- 990- 9010 12, 957
Increase Transfer In
5690- 99- 00- 393- 00- 00 CIP PW 22- 19 30, 670
Increase Transfer In
6090- 99- 00- 393- 00- 00 CIP WW 22- 24 35, 992
Increase Appropriation
5690- 80- 00- 420- 83- 00 CIP PW 22- 19 30, 670
Increase Appropriation
6090- 80- 00- 420- 83- 00 CIP WW 22- 24 35, 992
ATTACH M ENTS:
A. Resolution Approving Amendment No. 2 with EKI Environment & Water, Inc. to update the Integrated Water Resources Master Plan, CIP PW 22- 19 & CIP WW 22- 24 and Approve Budget Amendment
B. Amendment No. 2 with EKI Environment & Water, Inc., to provide geodatabase support for the IWRMP
CITY MANAGER' S REPORT PAGE 4
FEBRUARY 13, 2023 CITY COUNCIL REGULAR MEETING
APPROVE AMENDMENT NO. 2 WITH EKI FOR IWRMP AMENDMENT, CIP PW 22- 19 AND CIP WW 22- 24, AND APPROVE BUDGET AMENDMENT
APPROVALS:
if" y`' o / o y3
Greg son Date
Senio Civil Engineer
I 3 I/ zo'L3
Brad ylor Date
City Engineer
Z- I- ZoZ3
Michael King Date
Assistant City Manager
i%
f '
a
Cari Jame' s Date
Finance Di` e tor
Z..- Zo z.;
Salvador Navarrete Date
City Attorney
2•si• 2-3
Stephen J. Salvatore Date
City Manager
RESOLUTION NO. 23-
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF LATHROP APPROVING AMENDMENT NO. 2 WITH EKI ENVIRONMENT & WATER, INC.
TO UPDATE THE INTEGRATED WATER RESOURCES MASTER PLAN
AMENDMENT, CIP PW 22- 19 & CIP WW 22- 24 AND APPROVE BUDGET
AMENDMENT
WHEREAS, the City' s water, sewer and recycled water master plan documents, collectively referred to as the City' s Integrated Water Resources Master Plan ( IWRMP) is used to forecast and update water and sewer demand projections, address changes in regulatory requirements, population and growth projections, proposed land use, climate change and other factors; and WHEREAS, in 2016, EKI Environment & Water, Inc. ( EKI) and De Novo Planning Group ( De Novo) assisted the City to update the IWRMP and prepare the associated project Environmental Impact Report which were approved and adopted by Council in December, 2019; and
WHEREAS, since adoption of IWRMP, significant changes in projected water demands and water supplies, planned land development and other factors have necessitated a comprehensive amendment to the IWRMP; and WHEREAS, on April 11, 2022, Council approved an agreement with EKI to update the IWRMP to account for recent development, proposed land use changes, regulatory requirements and other factors; and
WHEREAS, additional services from EKI are requested to update the City' s geodatabase for the water, wastewater and recycled water systems in order for EKI to complete the IWRMP update as the geodatabase updates were not included in EKI' s original scope and were originally planned to be performed by another consultant; and
WHEREAS, at the request of staff, EKI provided a proposal to provide the geodatabase update services. Amendment No. 2 is for $ 89, 500, and the cost breakdown for each task is as follows:
Master Plan U date Com onent Cost
U date Water S stem Geodatabase PW 22- 19 29, 700
U date Wastewater S stem Geodatabase WW 22- 24 42, 600
U date Rec cled Water S stem Geodatabase WW 22- 24 17, 200 WHEREAS, sufficient funds were not included in the adopted FY 22/ 23 budget for CIPs PW 22- 19 and WW 22- 24. Staff requests that Council approve a budget amendment allocating $ 30, 670 from the Water System Capital Replacement Fund 5600 to CIP PW 22- 19 and $ 23, 035 from the MBR Capital Replacement Fund 6110 plus $ 12, 957 from the Wastewater Capital Replacement Fund 6060 enterprise funds to CIP WW 22- 24; and
WHEREAS, the project is exempt according to California Environmental Quality Act ( CEQA) Article 18 § 15262, Feasibility and Planning Studies".
NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of Lathrop hereby approves the following actions:
1. Amendment No. 2 with EKI Environment and Water, Inc. ( EKI) is hereby approved to provide an update to the City' s Integrated Water Resources Master Plan in the amount of $ 89, 500.
2. The following budget amendment:
Increase Transfer Out
5600- 99- 00- 990- 9010 30, 670
Increase Transfer Out
6110- 99- 00- 990- 9010 23, 035
Increase Transfer Out
6060- 99- 00- 990- 9010 12, 957
Increase Transfer In
5690- 99- 00- 393- 00- 00 CIP PW 22- 19 30, 670
Increase Transfer In
6090- 99- 00- 393- 00- 00 CIP WW 22- 24 35, 992
Increase Appropriation
5690- 80- 00- 420- 83- 00 CIP PW 22- 19 30, 670
Increase Appropriation
6090- 80- 00- 420- 83- 00 CIP WW 22- 24 35, 992
BE IT FURTHER RESOLVED, the City finds the Integrated Water Resources Master Plan Amendment is exempt according to California Environmental Quality Act ( CEQA) Article 18 § 15262, Feasibility and Planning Studies".
The foregoing resolution was passed and adopted this 13th day of February 2023, by the following vote of the City Council, to wit:
AYES:
NOES:
ABSTAIN:
ABSENT:
Sonny Dhaliwal, Mayor
ATTEST: APPROVED AS TO FORM:
Teresa Vargas, City Clerk Salvador Navarrete, City Attorney
ATTACHMENT
M R
AMENDMENT NO. 2
TO THE AGREEMENT BETWEEN THE CITY OF LATHROP AND
EKI ENVIRONMENT & WATER, INC. DATED APRIL 11, 2022
TO UPDATE THE WATER, WASTEWATER AND RECYCLED WATER SYSTEMS
GEODATABASE FOR THE INTEGRATED WATER RESOURCES MASTER PLAN AMENDMENT, CIP PW 22- 19 ( WATER) AND CIP WW 22- 24
WASTEWATER AND RECYCLED WATER)
THIS CONTRACT AMENDMENT ( hereinafter " AMENDMENT NO. 2") to the agreement between EKI Environment & Water, Inc. and the City of Lathrop dated April 11, 2022, ( hereinafter AGREEMENT") dated for convenience this 13th day of February, 2023 , is by and between EKI Environment & Water, Inc. (" CONSULTANT") and the City of Lathrop, a California municipal corporation (" CITY");
RECITALS:
WHEREAS, CONSULTANT is specially trained, experienced, and competent to provide the Integrated Water Resources Master Plan Amendment, CIP PW 22- 19 ( Water) and CIP WW 22- 24 ( Wastewater and Recycled Water), which are required by this agreement; and WHEREAS, CITY selected the CONSULTANT pursuant to said qualifications; and WHEREAS, on April 11, 2022, CONSULTANT and CITY entered into an AGREEMENT to provide the Integrated Water Resources Master Plan Amendment ( IWRMP), CIP PW 22- 19 Water) and CIP WW 22- 24 ( Wastewater and Recycled Water), and WHEREAS, Amendment No. 1, dated August 4, 2022, was issued for CONSULTANT to perform an evaluation of the City' s Biochemical Oxygen Demand contributions to the City of Manteca' s Water Quality Control Facility by amending the scope of work for Task 3 Flow Monitoring of the original Agreement, and did not change the amount of $ 421, 900 of the AGREEMENT dated April 11, 2022; and
WHEREAS, CONSULTANT has provided CITY with a proposal for updating the water, wastewater and recycled water systems geodatabase that is needed to complete the IWRMP; for a time and materials cost, not to exceed $ 89, 500 which is to be performed under this AMENDMENT NO. 2; and
WHEREAS, CONSULTANT is willing to render such tasks under AMENDMENT NO. 2 needed for the geodatabase update for the Integrated Water Resources Master Plan, as hereinafter defined, on the following terms and conditions.
NOW, THEREFORE, CONSULTANT and the CITY agree as follows:
AMENDMENT NO. 2 TO AGREEMENT
1) Scope of Service. Section ( 1) of the AGREEMENT is hereby amended to add the following:
CITY OF LATHROP — AMENDMENT NO. 2 WITH EKI ENVIROMENT & WATER, INC. TO
UPDATE THE WATER, WASTEWATER AND RECYCLED WATER SYSTEMS GEODATABASE FOR THE IWRMP, CIP PW 22- 19 AND CIP WW 22- 24
CONSULTANT agrees to provide Integrated Water Resources Master Plan in accordance with the scope of work and fee proposal provided by CONSULTANT, attached hereto as Exhibit " A" and shall provide proof of payment for equipment rental on their invoices in addition to the scope of work in the original AGREEMENT dated April 11, 2022.
CONSULTANT agrees to diligently perform these services in accordance with the upmost standards of its profession and to CITY' S satisfaction. 2) Compensation. Section ( 2) of the AGREEMENT for Consulting Services is hereby amended as follows:
CITY hereby agrees to pay CONSULTANT an additional sum not to exceed $ 89, 500 for the Professional Consulting Services set forth in Exhibit "A" of this AMENDMENT NO. 2.
CONSULTANT shall be paid within thirty ( 30) days of receipt of progress billings containing all information contained in Paragraph 5 of the original AGREEMENT. In no event shall CONSULTANT be entitled to compensation for work not included in the original scope of work, and this AMENDMENT NO. 2 unless a written change order or authorization describing the extra work and payment terms has been executed by CITY' S Authorized Representative prior to the commencement of the work. 3) Effective Date and Term
The effective date of AMENDMENT NO. 2 is February 13, 2023, and it shall terminate no later than June 30, 2024.
All other terms of the original AGREEMENT shall remain in full force and effect. 4) Applicabilitv to Oriqinal Consultant AGREEMENT
All terms and conditions set forth in the AGREEMENT dated April 11, 2022 are still in effect and are incorporated by reference herein and said AGREEMENT is incorporated by reference herein.
5) Siqnatures
The individuals executing this AMENDMENT NO. 2 represent and warrant that they have the right, power, legal capacity, and authority to enter into and to execute this AMENDMENT NO. 2 on behalf of the respective legal entities of the CONSULTANT and the CITY. This agreement shall inure to the benefit of and be binding upon the parties hereto and their respective successors and assigns.
CITY OF LATHROP — AMENDMENT NO. 2 WITH EKI ENVIROMENT & WATER, INC. TO
UPDATE THE WATER, WASTEWATER AND RECYCLED WATER SYSTEMS GEODATABASE FOR THE IWRMP, CIP PW 22- 19 AND CIP WW 22- 24
Approved as to Form: City of Lathrop
City Attorney
Salvador Navarrete Date
Recommended for Approval: City of Lathrop
Assistant City Manager
Michael King Date
Approved by: City of Lathrop
390 Towne Centre Drive
Lathrop, CA 95330
Stephen J. Salvatore Date
City Manager
Consultant: EKI Environment & Water, Inc.
Jonathan Sutter, P. E.
2001 Junipero Serra Blvd, Suite 300
Daly City, CA 94014
Phone: ( 650) 292- 9100
Federal ID # 94- 3087395
Lathrop Business License # 20137
Signature Date
Print Name and Title
Page3of3
B
w w
environment e & water
Corporate Office
2001 Junipero Serra Boulevard, Suite 300
Daly City, CA 94014
650) 292- 9100
ekiconsult. com
9 January 2023
Brad Taylor, PE
City Engineer
City of Lathrop
390 Towne Centre Drive
Lathrop, CA 95330
Subject: Proposal for Water and Wastewater Systems Geodatabase Update Integrated Water Resources Master Plan Amendment
City of Lathrop, California
EKI C20049. 00)
EKI Environment & Water, Inc. ( EKI) is pleased to present to the City of Lathrop ( Lathrop or City) this proposal for updating the City' s water, wastewater, and recycled water systems geodatabase in support of the City' s 2022 Integrated Water Resources Master Plan ( IWRMP) Amendment.
SCOPE OF WORK
On 20 October 2022, EKI submitted a memorandum entitled Request to Update the City' s Geodatabase summarizing the required edits to the City' s water and wastewater systems geodatabase to construct the City' s hydraulic models and carry out further hydraulic modeling analysis. The scope of work associated with Tasks 1 and 2 below aligns with the October 2022 memo, included as Attachment A. Task 3 includes the scope of work to update the City' s recycled water system geodatabase.
Task 1— Update Water System Geodatabase
The following edits will be made to the water system geodatabase:
Resolve discrepancies between the geodatabase and record drawings; Add missing features and records;
Apply a unique ID system to new system features;
Reconcile system elevation datum;
Remove duplicate datasets; and
Perform project management and associated communications.
Task 2— Update Wastewater System Geodatabase
The following edits will be made to the wastewater system geodatabase:
Resolve discrepancies between the geodatabase and record drawings; Add missing features and records;
Apply a unique ID system to new system features;
Reconcile system elevation datum;
Add pipe upstream and downstream invert elevations;
Formerly known as Erler 8 Kalinowski, Inc.
Oakland, CA• Davis, CA• Marin, CA• Sacramento, CA• Irvine, CA EI Segundo, CA• Centennial, CO• Salem, NH• Saratoga Springs, NY Brad Taylor environment
City of lathrop water
9 January 2023
Remove duplicate datasets; and
Perform project management and associated communications.
Task 3— Update Recycled Water System Geodatabase
The City has not updated its recycled water system geodatabase since the 2019 IWRMP. Based a preliminary review of recent recycled water system improvements, EKI will make the following edits to the recycled water system geodatabase:
Update distribution system features to reflect improvements since 2018; Review and update ponds and agricultural irrigation areas; Review and update planned recycled water hydrant locations; Refine landscape irrigation areas in the Central Lathrop and Mossdale development areas to reflect recent and planned development; and
Update total landscape irrigation acreage for River Islands.
EKI understands that River Islands operates its own non- potable water distribution system, which will not be explicitly modeled by the recycled water hydraulic model. EKI will review and update the total landscape irrigation acreage for River Islands for water balance, storage and pump capacity analyses.
COMPENSATION
We propose that compensation for consulting services by EKI be on a time and expense reimbursement basis in accordance with our Schedule of Charges, dated 1 January 2022.
Attachment B). Based on the Scope of Work described above, we propose a budget of$ 89, 500, as outlined in Table 1 below and detailed in Attachment C. EKI will charge against this budget and will advise if additional budget becomes necessary.
Table 1— Cost Estimate by Task
Task
Task 1— Update Water System Geodatabase 29, 700
Task 2— Update Wastewater System Geodatabase 42, 600
Task 3— Update Recycled Water System Geodatabase 17, 200 Total $ 89, 500
Brad Taylor environment
City of Lathrop water
9 January 2023
PROIECT SCHEDULE
EKI is available to initiate work upon receiving authorization from the City. EKI anticipates that the above scope of work can be completed within sixteen ( 16) weeks of authorization.
TERMS AND CONDITIONS
Except as specifically modified above, all other terms of our 11 April 2022 Agreement shall remain in full force and effect. If this proposal meets with your approval, please send us an Agreement Amendment to review and execute.
We are excited about the opportunity to work with you on this project. Please call if you have any questions or wish to discuss this proposal in greater detail.
Very truly yours,
EKI Environment & Water, Inc.
10 at an Sutter, PE
Pr j ct Manager
City of Lathrop
Authorized Representative)
Date)
Attachments
A. Memorandum: Request to Update the City' s Geodatabase, dated 20 October 2022 B. 2022 Schedule of Charges
C. Budget Estimate for Proposed Scope of Work
ATTACH M E NTS
environment e & water
20 October 2022
MEMORANDUM
To: Greg Gibson ( City of Lathrop)
From: Jonathan Sutter( EKI)
Tina Wang( EKI)
Subject: Request to Update the City' s Geodatabase
City of Lathrop— Public Works Department
EKI C20049. 01)
EKI Environment and Water, Inc. ( EKI) reviewed the City of Lathrop' s ( City' s) water, wastewater, and recycled water systems geodatabase against the record drawings provided by the City and noticed data gaps. The City, EKI, and the City' s GIS consultant, Condor, met on 29 September 2022 to discuss filling in these data gaps and applying additional edits so that EKI can readily update the hydraulic models from the City' s geodatabase. Pursuant to the meeting, City requested EKI to outline the required edits for the City and Condor to implement. This memorandum summarizes the required edits for the water and wastewater systems, which includes:
Reconciling discrepancies between the geodatabase and record drawings; Add missing or complete infrastructure features; and
Apply standard protocol to existing and new features.
It appears that the City' s recycled water system geodatabase has not been updated since receiving EKI' s dataset compiled for the previous Integrate Water Resources Master Plan ( IWRMP). EKI understands that the City will reach a separate decision on updating the recycled water system geodatabase.
The required edits and discrepancies for the water and wastewater systems are further described below.
DISCREPANCIES BETWEEN THE CITY' S GEODATABASE AND RECORD DRAWINGS Discrepancies between the City' s geodatabase of the two systems( potable water and wastewater water) and the record drawings are noted in Attachment A for each record drawing. In general, the discrepancies include:
Inconsistent pipe sizes;
Duplicate datasets;
Missing system features and components; and
Missing status of systems features ( e. g., active, future, abandoned, or other[ private]).
Greg Gibson Q ( environment
City of Lathrop j water
20 October 2022
MISSING OR INCOMPLETE RECORDS IN THE CITY' S GEODATABASE Infrastructure in the southwest of River Islands ( RI) is not provided ( south of RI Pkwy and west of Dell Osso), but the development has been built based on Google aerial images. Per discussions during the September 29t`' meeting, EKI understands that plans for these areas have not been accepted by the City, however, the City will add infrastructure for these areas and note them as d raft.
As noted in Attachment A, it appears that record drawings for" Improvement Plans, Track 3811, Stanford Crossing" and " River Islands - Track 3839, Improvement Plans" are provided under two different tract number file names ( one file name contains the right tract number and one file name contains the wrong tract number [ e. g., under track numbers NH26 and Built Tract 3837, respectively]). This may imply that record drawings for NH2B and Built Tract 3837 may be missing and need to be added.
As noted in columns M and N in Attachment A, several record drawings provided by the City are not incorporated in the geodatabase.
Hydrant locations in the water system are missing in the southeast portion of River Islands.
STANDARD PROTOCOL
Several standard protocols are required for hydraulic model runs, which are described further below.
Unique ID System
New features added post 2019 does not follow the City' s unique ID naming convention developed by Stantec in 2013, which is an 11- digit ID comprised of a Grid ID, a code for the feature type, and a numerical ID. It is important that all new and existing features use this naming convention so that each feature has a unique ID and can be joined with the prior modeling features for a complete model.
Elevation Datum
Elevation recorded in the City' s geodatabase system is on a NAVG 29 datum. Data from record drawings that are not prepared using this datum needs to be converted.
Connectivity
It is recommended that the City establishes correct connectivity for new systems and newly added features. Particularly, pipelines should split at intersections, hydrant laterals, Ts, isolation valves, and control valves that are normally closed ( see example below; no need to split pipeline at surface laterals, blowouts, or other non- operational fittings).
EKI C20049. 01
Greg Gibson I
environment
City of Lathrop water
20 October 2022
tWQr R VIE W
E mine and fix th g c metry af m orted data
Lacate / ix N ci s in Clos Pro imity
x, K,
s +
u, r, w w,
Lacat t F Pip- Split Candidates
T
a
Lcx; te 1 F'tx Cic sir I I wt r5t,: tirr Pip
P e 311
u
Several pipelines in the wastewater system are not connected to their downstream network ( such as pump stations and pipes) ( see Attachment A).
Wastewater System Invert Elevations
Upstream and downstream invert elevations for every pipe that need to be populated. Currently, invert elevations for improvements added post- 2019 are only populated at manholes. However, one manhole may connect multiple pipes of different elevations and cannot represent the invert elevation and slope at each pipe.
Duplicative Datasets
It appears that multiple copies of the system exist in the geodatabase with differences in the information contained. For example:
Water System
Duplicate features exist in pw_ Mains. Per discussion during the meeting, EKI understands these duplicate features were added to reflect the final improvements accepted by the City. However, EKI C20049. 01
i
Greg Gibson environment
City of Lathrop water
20 October 2022
the City' s added features do not have necessary attributes such as Facility Identifier, Source, Grid_ No, Feature_ Type, ID, and Asset Status. EKI suggests that the City merge EKI' s attributes with the newly added features and delete duplicates as appropriate. Maintaining the same facility ID for the same feature would help us streamline system updates in the hydraulic model.
Sciurce Gred_Mn Feature_Type fD CurrentRepkacementCost AssetStatus Andy Kom J13 P VtdA i534< Mull> Actrre
rNulls < Nulb 4 dull> NuII < Nully Null>
a
w
5 x
a ti
e
1 z
e
r,. a.
s 3 i
s_.
4 ° fc
w,"
e
4 i:.:% °. .' s`" i v .., . ,., r , _
J- -' m
M
F iri 1 :' f`#: f, h +"} µ".+•.§+ ..
k s: s:'.:.= .
t„
O& IECTID' fuil' N# ntifror Install Date Wteriaf Piameter Water Type EnableA Active Flap Owned 8y ManapeA 8y Ust UpCatx Qate Last Etlf 45i4 J13PN61? fi534 1/ 12018 PaqrvinylChlefiGe B': PotebbWater Trut irue OurAgency OurAgency 6f1312017 EKLCP b0$ Q< Nulb 12f15J207fi FCIy: mylC lar e 8"; PCteCIe lFat^ r j True 7rue OurAgency OurAgency,< Nu6> eNUIb sya FL,*,`..'
Wastewater system
During the geodatabase update for the prior IWRMP, EKI superseded ss_ GravityMain and ss_ PressurizedMain with ss_ Main ( i. e., merged two layers into a single layer) and superseded ss_ Manhole and ss_ Fitting with ss_ Node. EKI merged these layers because the hydraulic model takes all pipelines, including gravity main and pressurized mains, as a single layer; and likewise for manholes and fittings. EKI provided the updated ss_ Main and ss_ Node layers to the City on 7 October 2020.
It appears that the City merged EKI' s updates with its original ss_ GravityMain, ss_ PressurizedMain, ss_ Manhole, ss_ Fitting layers, added post- 2019 improvements to these four layers, but kept EKI' s 2020 ss_ Main and ss_ Node layers in its geodatabase. The City should select one set of layers to update, delete duplicate layers, and reconcile the following:
The ss_ PressuredMain file is outdated and missing EKI' s 2020 updates. By a quick visual comparison, the following features are missing or not updated. EKI suggests the City conduct a comparison between the ss_ PressureMain and the ss_ Main file if the City wishes to continue updating the ss_ PressureMain layer.
EKI C20049. 01
Greg Gibson
I
environment
City of Lathrop water
20 October 2022
tG
i2"
r....
6„
r..
ra
24" g~
u.. , 6,
1 g ` ..« _.
f" .
9+ d $` o
s''" ` o
6 ..
a.
E
6 L. ia
1 a r
g.
a
f
k,^' b." ti
QS'.
GQ,
t•
iPs
p r,
f`' y
L 8" r .. if1 Wtr
w;$';' ,
y
R '
M S4 r g'
12tl $, ...,
W
4J
T2• i
m . Q
w 1
q
k
t*
ao<'$ CP°
a
s+*
iD .
IM`
4 s
12'
1 EKI C20049. 01
Greg Gibson
I
environment
City of Lathrop water
20 October 2022
roao.
a'">
a
a . , ..
c a 0 ;
o .
F
j .
m.
4 r` ,
a
k ;,: c t t-„
Improvements were added to the ss_ GravityMain, ss_ PressurizedMain, ss_ Manhole, and ss_ Fitting layers where there are duplicate datasets in the ss_ Main and ss_ Node. EKI understands that the added and updated features reflect the final improvements accepted by the City.
However, feature attributes including facility ID, status, and upstream and downstream invert EKI C20049. 01
Greg Gibson
I
environment
City of Lathrop water
20 October 2022
elevations are not added to the features. If the City wishes to continue updating the ss_ GravityMain, ss_ PressurizedMain, ss_ Manhole, and ss_ Fitting layers, EKI suggests that the City merge the facility IDs from the ss_ Main and ss_ Node layers and populate final upstream and downstream invert elevations in the features. Maintaining the same facility ID for the same feature would help us streamline system updates in the hydraulic model.
Attachments
Attachment A: Asbuilt Drawing Tracking Table( Electronic Copy) EKI C20049. 01
Client/ Address: City of Lathrop
390 Towne Centre Drive, eki environment
Lathrop, CA 95330 water
Proposal/ Agreement Date: 17 November 2022 EKI Proposal/ Project# C20094 SCHEDULE OF CHARGES FOR EKI ENVIRONMENT& WATER, INC. 2 January 2022 Personnel Classification Hourlv Rate
Officer and Chief Engineer- Scientist 307
Principal Engineer- Scientist 296
Supervising I, Engineer- Scientist 286
Supervising II, Engineer- Scientist 276
Senior I, Engineer- Scientist 265
Senior II, Engineer- Scientist 255
Associate I, Engineer- Scientist 244
Associate II, Engineer- Scientist 230
Engineer- Scientist, Grade 1 214
Engineer- Scientist, Grade 2 202
Engineer- Scientist, Grade 3 185
Engineer- Scientist, Grade 4 165
Engineer- Scientist, Grade 5 145
Engineer- Scientist, Grade 6 128
Project Assistant 130
Technician 116
Senior GIS/ Database Analyst 150
CADD Operator/ GIS Analyst 133
Senior Administrative Assistant 147
Administrative Assistant 115
Secretary 96
Direct Expenses
Reimbursement for direct expenses, as listed below, incurred in connection with the work will be at cost plus ten percent( 10%) for items such as:
a. Maps, photographs, reproductions, printing, equipment rental, and special supplies related to the work. b. Consultants, soils engineers, surveyors, drillers, laboratories, and contractors. c. Rented vehicles, local public transportation and taxis, travel, and subsistence. d. Special fees, insurance, permits, and licenses applicable to the work. e. Outside computer processing, computation, and proprietary programs purchased for the work.
A Communication charge for e- mail access, web conferencing, cellphone calls, messaging and data access, file sharing, local and long distance telephone calls and conferences, facsimile transmittals, standard delivery U. S. postage, and incidental in- house copying will be charged at a rate of 4% of labor charges. Large volume copying of project documents, e. g., bound reports for distribution or project- specific reference files, will be charged as a project expense as described above.
Reimbursement for company- owned automobiles, except trucks and four- wheel drive vehicles, used in connection with the work will be at the rate of sixty cents($ 0. 60) per mile. The rate for company- owned trucks and four- wheel drive vehicles will be seventy- five cents($ 0. 75) per mile. There will be an additional charge of thirty dollars($ 30. 00) per day for vehicles used for field work. Reimbursement for use of personal vehicles will be at the federally allowed rate plus fifteen percent( 15%).
CADD Computer time will be charged at twenty dollars($ 20. 00) per hour. In- house material and equipment charges will be in accordance with the current rate schedule or special quotation. Excise taxes, if any, will be added as a direct expense.
Rate for professional staff for legal proceedings or as expert witnesses will be at a rate of one and one- half times the Hourly Rates specified above.
The foregoing Schedule of Charges is incorporated into the Agreement for the Services of EKI Environment& Water, Inc. and may be updated annually.
Attachment C- Budget Estimate for Proposed Scope of Work Geodatabase Update for the Lathrop IWRMP Amendment
City of Lathrop, California
EKI Labor Expenses Ti
LLi
a a ,
a
00 > E
E vi N al fo O. c
p
w
c c 2i s U CJ z
TASKS c c °° o c co J v .-. a
w fo w ro ic p Y
v
x
w w
fp C
Y
pp V J N J
v
0 O N C - - Q Q
lJ l7 l7 3 Q d Q a
V L O
F- U H
133 165 165 230 276
ask 1 U date Water 5 stem Geodatabase
Resolve discrepancies 16 1 2, 985 0 2, 985
Add missing features and records 8 40 6 1 9, 693 0 9, 693 Add hydrant locations 4 16 1 3, 586 0 3, 586
Apply unique ID system 6 1 1, 269 0 1, 269
Remove water system duplicate datasets 16 36 4 1 9, 635 0 9, 635 Project management and communications 6 4 2 2, 560 0 2, 560 Subtoial 28 0 120 16 S $ 29, 727 0 29, 700
ask 2 U date Wastewater S stem Geodatabase
Resolve discrepancies 16 1 2, 985 0 2, 985
Add missing features and records 16 64 8 1 $ 15, 396 320 16, 036 Apply unique ID system 6 1 1, 269 0 1, 269
Reconcile system elevation datum 6 2 1 1, 795 0 1, 795
Add wastewater system invert elevations 40 4 7, 821 0 7, 821 Remove wastewater system duplicate datasets 16 36 4 1 9, 635 0 9, 635 Project management and communications 6 6 2 3, 039 0 3, 039 Subtotal 32 174 0 26 5 $ 41, 939 300 42, 600
ask 3 U date Rec cled Water S stem Geodatabase
Update distribution system features( pipes, pumps) 4 1 926 0 926 Review and update ponds and spray fields 2 343 0 343
Review and update recycled water hydrant locations 8 1 1, 612 0 1, 612 Refine landscape irrigation areas in CLSP and Mossdale 16 24 8 2 8, 819 320 9, 459 Update total RI landscape irrigation acreage 8 4 2 2, 904 0 2, 904 Project management and communications 4 4 1 1, 930 0 1, 930 Subtotai 16 0 50 18 5 $ 16, 534 400 17, 200
OTAL: 76 174 170 60 15 $ 88, 200 700 89, 500
Notes:
1) A communications charge of 4% of labor costs covers e- mail access, web conferencing, cellphone calls, messaging and data access, file sharing, local and long distance telephone calls and conferences, facsimile transmittals, standard delivery U. S. postage, and incidental in- house copying. 2)" Other Direct Costs" includes direct expenses, as listed below, incurred in connection with the work and will be reimbursed at cost plus ten percent 10%) for items such as:
a. Maps, photographs, reproductions, printing, equipment rental, and special supplies related to the work. b. Consultants, soils engineers, surveyors, drillers, laboratories, and contractors. c. Rented vehicles, local public transportation and taxis, travel and subsistence. d. Special fees, insurance, permits, and licenses applicable to the work. e. Outside computer processing, computation, and proprietary programs purchased for the work.
November 2022
C20049. 00 Page 1 of 2 EKI Environment& Water, Inc.