WA0003-CN001117CITY COUNCIL MEETING: November 14, 2000 ITEM
ITEM CAPTION:
Consider approval of entering into a contract with Shimek, Jacobs & FinIdea for a Water Distribution System
Master Plan Update in an amount not to exceed $62,300; and authorizing the City Manager to s~gn.
STAFF COlrID:CELTS: --' '
APPROVED
BY
CITY COUNCIL
DATE 11-14- Or~
See attached memo.
BUDGET AMT. $
FINANCIAL COMMENTS:
Funds for this
DIR. INITIALS:
Agenda Request Form - Revised 5/00
AMT. EST. $ +X-BID
contract are available in Water/Sever CIP.
~7 FIN. REVIEW: ~ CITY MANAGER REVB~
Document Name: #eng2
MEMORANDUM
FROM THE
DEPARTMENT OF ENGINEERING
To:
From:
Date:
RE:
Mayor and City Council Members
Kenneth M. Griff'm, P.E., Dir. of Engineering/Public Works
November 14, 2000
Consider approval of entering into a contract with Shimek, Jacobs & FinIdea for a
Water Distribution System Master Plan Update in an amount not to exceed $62,300;
and authorizing the City Manager to sign.
In 1994, the City received an updated Water Distribution System Master Plan prepared by Rady and
Associates. That master plan was used to determine our water impact fees and as a guideline to
identify capital improvement projects. The City of Coppell has implemented numerous projects from
the 1994 study including: the 6 million gallon ground storage tank at Village Parkway, Village
Parkway Pump Station improvements, 2nd elevated storage tank, and numerous water lines throughout
the City.
In 1997, Shimek, Jacobs and Finklea updated our Water System Master Plan. Several components of
the 1997 update were: to determine the appropriate water line size of the transmission line in Sandy
Lake Road, since constructed with the Sandy Lake Road project, and to verify the appropriate size for
the new elevated storage tank on the west side of the City, since constructed and brought on line in
1999.
However, one item that has been noticed through the years is that real life situations do not always
match the model. My opinion is that there shotrid be a strong effort to calibrate our model with this
update. With a calibrated model you can input various scenarios into the computer system and get
reliable information as an output. With the current model we have we can also input various scenarios;
however, the output is not always in line with real field conditions.
This update will concentrate on utilizing our most recent water consumption and pumping information
to determine the demands on the existing system. This update will also input into the system model
any water lines, 8" or larger, constructed since the 1997 update. Once the system model has been
updated, then the calibration effort will take place. One component of this update is to purchase 6
hydrant pressure recorders and place those on fire hydrants throughout the City. The actual pressure
from those recorders will then be compared to the computer model in an effort to fine tune and
calibrate the model to real life situations. The calibration effort is one of the most important
components of this study.
"CITY OF COPPELL ENGINEERING - EXCELLENCE BY DESIGN"
During the course of updating the study, Shimek, Jacobs and Finklea will also be evaluating
oppommities for the City of Coppell to obtain water from other sources. To our knowledge, the only
other water source in the area is the Upper Trinity Regional Water Supply Corporation. Their
transmission lines are very remote to the City of Coppell and the cost of bringing those lines to Coppell
and building pump stations on the west side of Coppell could be astronomical. However, because we
are single fed by the City of Dallas we will at least explore that option.
Once the system as been updated and calibrated, then system demands will be placed into the computer
model to determine deficiencies in the current system and also to determine necessary capital
improvements to meet demands in the future.
We are currently in the preliminary stages of formulating a plan to build a second pump station and
ground storage tank. This could be the last pump station and ground storage tank for Coppell.
Therefore, it is imperative that we have a correct model to assist us in determining the correct sizes of
the pumps and the ground storage necessary to serve Coppell through buildout.
Staff recommends approval of entering into a contract with Shimek, Jacobs & Finklea for a Water
Distribution System Master Plan Update in an mount not to exceed $62,300. Staff will be available to
answer any questions at the Council meeting.
"CITY OF COPPELL ENGINEERING - EXCELLENCE BY DESIGN"
RONALD V. CONWAY, P.E.
JOHN W. BIRICHOFF, P.E.
JOE R. CARTER, P.E.
GARY C. HENDRICKS, P.E.
PAUL A. CARLiNE, P.E.
MATT HICKEY, P.E.
ROSS L. JACOBS, P.E.
I. C. FINKLEA, P.E.
SHIMEK, JACOBS & FINKI,EA, L.L.P.
CONSULTING ENGINEERS
8333 Douglas Avenue, #820 Dallas, Texas 75225-5816 Fax (214) 361-0204
October 30, 2000
Phone (214) 361-7900
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Post Office Box 478
Coppell, Texas 75019
Re: Water Distribution System Master Plan Update
Dear Mr. Griffin:
As you requested in our recent meeting with you, we are pleased to submit this proposal for
professional engineering services for the Water Distribution System Master Plan Update and
Hydraulic Analysis. The current hydraulic model was last updated in May 1997 by our firm, and was
based on the data set(s) created by Rady & Associates in December 1994. The purpose of this master
plan analysis is to re-visit the assumptions made and technical approach used in the last report, re-
evaluated the master plan and make specific recommendations for proposed system improvements in
report form, graphically on a new master plan map and in the electronic data files. We understand the
City of Coppell currently has a single use license of Cybemet 3.0 software for a 2000 pipe system.
Our engineering services for this project shall include the following:
PRELIMINARY EVALUATION AND REPORT
A. Prepare a Water Demand Study based on year 2000 water consumption data provided by
the City of Coppell in the form of:
1)
Available water records provided by the City for the months of January, July, August
and September, including:
a) Hourly pumping records
b) Hourly elevated storage tank level data
c) Dallas Water Utility meter data
1: \6160\coppell\water system master plan 2000. doc
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 2 of 2
d) Data on any unique or large water demand customers in the City
e) Customer meter reading data for the highest use month of the year
2) Current population estimates and projections provided by the City in the recent City
of Coppell Comprehensive Plan or other current basis provided by the City.
3) Existing and projected land use assumptions provided by the City in the recent City
of Coppell Comprehensive Plan or other current basis provided by the City.
Evaluate the historic water demand data, population projections and projected land use
assumptions and prepare a Preliminary Water System Letter Report outlining:
1) Historic overall system demands.
2) Historic unit demands based on Residential, Commercial and Institutional
categorized uses.
3) Historic residential unit demands based on geographic location within the City. We
anticipate dividing the residential unit demands into at least four (4), but no more
than six (6) geographic regions.
Recommended unit demands based on land use categories and geographic regions of
the City.
Evaluate the City's current and expected maximum day water supply and make
recommendations for supply options from the Dallas Water Utilities and/or City of
Irving.
Initiate discussions with the Upper Trinity Regional Water Supply Corporation for a
potential new or altemative source of treated water for the City of Coppell.
Evaluate City's current and required pumping capacity and make recommendations
for pump station expansions, pump station additions, schedules and capital cost.
Evaluate City's current and required ground storage tank capacity and make
recommendations for ground storage tank additions, schedules and capital cost.
4)
5)
6)
7)
8)
l:\6160\coppcll\water system master plan 2000.doc
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 3 of 3
9) Evaluate City's current and required ground storage tank capacity and make
recommendations for ground storage tank additions, schedules and capital cost.
Prepare a conceptual layout for any recommended pump station and/or ground
storage additions. The conceptual pump station layout will be based on either
property under consideration by the City, or on a generic property boundary layout.
11) Deliver a draft preliminary report to the City for review and comment
12) Deliver final version of the Preliminary Water System Letter Report for use by
City.
WATER DISTRIBUTION SYSTEM - EXISTING SYSTEM HYDRAULIC MODEL
& EVALUATION
A. Convert the City's current existing water distribution system hydraulic model data set to
the current version of the Cybernet hydraulic model.
Update the existing system model with the recommend revised unit demands as outlined
in the Preliminary Water System Letter Report. Apply the hydraulic system demands
based on existing land use assumptions.
C. Model all existing pump stations utilizing actual pump flow data or pump curves, where
available from the City.
Add existing water lines to the model at the City's direction and as required to properly
evaluate the existing distribution system. This effort will be coordinated with the City's
Graphic Information System database and is expected to include all 8-inch diameter and
larger water lines. Water lines smaller than 8-inches will be modeled where their
inclusion is critical to the calibration of the existing system and where their inclusion is
within the capacity of the City's hydraulic computer model soft-ware license.
E,
Update the existing system hydraulic map showing the water system elements contained
in the hydraulic model including:
1) Line sizes and numbers of critical lines.
2) Junction nodes and numbers.
l:X6160\coppell\water system master plan 2000.dec
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 4 of 4
3) Existing elevated and ground storage tanks.
4) Existing pump station layouts.
3. EXISTING SYSTEM MODEL CALIBRATION:
Purchase for City six (6) Telog HPR 2109e hydrant pressure recorders, one software
package and transfer cable. Cut sheet for the Telog HPR2019e hydrant pressure recorder
is attached. Establish with City programmable ranges.
B. Work with City staff to locate hydrants to establish pressure recorders. Check recorders
within two days after deployment.
C. Download data, plat data and compare to the existing system hydraulic computer model.
Make adjustments in the hydraulic model to converge on pressure range found in field
data. Adjustments are expected to be made in minor losses, "C" factor and/or flow
distribution within the model.
E. Erratic reading form any particular recorder will be discarded. The meters will then be
re-deployed to narrow down the potential problem in the system.
F. Meters will become property of City when calibration is complete.
G. Calibration of the model will conclude at the direction of the City or when established
funds are expended.
WATER DISTRIBUTION SYSTEM - MASTER PLAN SYSTEM HYDRAULIC
MODEL & EVALUATION
A. Convert the City's Master Plan water distribution system hydraulic model data set to the
current version of the Cybemet hydraulic model.
Update the Master Plan hydraulic model with the recommend revised unit demands as
outlined in the Preliminary Water System Letter Report. This includes the application of
varying residential unit demands per geographic region. Junction node demands will be
calculated based on specific land us at the node and the unit demands recommend for
each land use. Demands will be calculated in spreadsheet format for easy manipulation
l:~6160Xcoppcll\water system master plan 2000.doe
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 5 of 5
D,
E,
F,
5. FINAL
and modification and linked to the hydraulic model. Apply the hydraulic system
demands based on existing and proposed land use assumptions.
Model existing and recommended pump stations utilizing actual pump flow data or pump
curves, where available from the City.
Add proposed water lines to the model at the City's direction and as required to properly
evaluate the Master Plan distribution system as it is envisioned at the build-out scenario.
This effort will be coordinated with the City's Graphic Information System database and
the City's current thoroughfare plan. The hydraulic model is expected to include all
future 8-inch diameter and larger water lines.
Update the Master Plan system hydraulic map
contained in the hydraulic model including:
1) Line sizes and numbers of critical lines.
2) Junction nodes and numbers.
3)
4)
showing the water system elements
Existing and proposed elevated and ground storage tanks.
Existing and proposed pump station layouts.
The master plan map will be prepared based on the electronic street map provided by the
City of Coppell.
REPORT AND RECOMMENDATIONS
Evaluate and make recommendations for system improvements for the existing system
and the master plan. The evaluation is to include recommendations for:
1) Alternative Water Supply Sources and Points of Delivery
2) Elevated Storage Tanks
3) Ground Storage Reservoirs
4) Booster Pump Stations
5) Pump Stations
6) Distribution Lines
1:\6160\coppell\water system master plan 2000.doc
I !
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 6 of 6
D,
Prepare and deliver twenty-five copies of the existing conditions water distribution map.
Prepare and deliver twenty-five copies of the projected master plan water distribution
map.
Prepare and deliver 25 copies of the water system master plan report including
methodology of the analysis, recommendations, schedules, and probable cost for system
improvements. Ten of the 25 copies of the water system master plan report will contain
the computer analysis input and output data sets in the appendix.
Deliver AutoCAD drawing files and associated Cybernet data files of the existing
conditions and master plan water distribution systems models. The electronic files will be
delivered under the following conditions:
1) The files are compatible with AutoCAD Release-14 by AutoDesk, and Cybernet
Version 3.0 by Haestad Methods. The Shimek, Jacobs & Finklea, L.L.P. does not
make any warranty as to the compatibility of these files beyond the release of
AutoCAD Release-14 or Cybemet Version 3.0.
2)
Because data stored on electronic media can deteriorate undetected or be modified, it
is agreed that Shimek, Jacobs & Finklea, L.L.P. will not be held liable for
completeness or correctness of electronic media after an acceptance period of thirty
days after delivery of these files.
3)
The electronic files are an instrument of Shimek, Jacobs & Finklea, L.L.P.'s service.
Where a conflict exists between the hard copy drawings, data printouts and the
electronic files, the hard copy drawings and data printouts will govern in all cases.
4)
Both parties acknowledge mutual non-exclusive ownership of the electronic files and
each party may use, alter, modify or delete the files without consequence to the other
party.
5) The electronic files provided to the City, do not contain engineers' seals, handwritten
dates, nor signatures.
F. Present the findings to the City staff and/or City Council as necessary.
1: \6 [ 60\ccrppellXwater sysl~m master plan 2OO0. doc
I ! ·
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 7 of 7
6. SPECIAL SERVICES
In addition to the basic services outlined above, the following Special Services are to be
performed if authorized by the City. These Special Services are not included in the above
described basic services, and are described as follows:
Investigations involving detailed consideration of operation, maintenance and overhead
expenses, and the preparation of rate schedules, eamings and expense statements,
feasibility studies, appraisals, evaluations, and assessment schedules required by the City
of Coppell.
B. Preparing applications and supporting documents for government grants, loans, or
planning advances and providing data for detailed applications.
Appearing before regulatory agencies or courts as an expert witness in any litigation with
third parties, including the preparation of engineering data and reports for assistance to
the City of Coppell.
Evaluation water distribution system improvements required to meet the needs of
altemative water supply and point of delivery scenarios. These are to be completed on a
case by case basis once the existing system model and master plan models are complete
and acceptable to the City of Coppell. As each scenario is analyzed, a brief letter report
will be prepared which outlines the results and recommendations.
Eo
Evaluation of water distribution system improvements required to meet the needs of
various development scenarios. These are to be completed on a case by case basis once
the existing system model and master plan models are complete and acceptable to the
City of Coppell. As each scenario is analyzed, a brief letter report will be prepared which
outlines the results and recommendations.
F. Any additional services required by the City of Coppell not included in Basic Services.
1:\6 160Xeoppell\water system master plan 2000.doc
!
Mr. Kenneth M. Griffin, P.E.
City of Coppell
Engineering Services Agreement
October 30, 2000
Page No. 8 of 8
COMPENSATION
For the above-described services Items I, II, IV and V, we propose to be compensated on a
lump sum basis in accordance with the following schedule:
I. Preliminary Evaluation and Report Phase .......................................$12,700
II. Existing System Hydraulic Model and Evaluation ............................$9,800
III. Existing System Model Calibration .............................To be Billed Hourly
IV. Master Plan System Hydraulic Model and Evaluation .....................$10,700
V. Final Report and Recommendation ................................................$9,400
Total Amount Item I, II, IV, V ~ Lump Sum: $42,600
Item III and Special Services
Compensation for Item III, Existing System Model Calibration and the Special Services shall
be based on salary cost times 2.35, with expenses at actual invoice cost times 1.10. We
suggest you budget approximately $16,200 for work associated with Item III and $3,500 for
the Special Services outlined above. The total amount of compensation of Items III and
Special Services shall not exceed $19,700 without written authorization by the City.
If you are in agreement with this proposal, please have one copy executed on behalf of the City of
Coppell and returned to our office, or if you prefer we will be pleased to assist in the preparation of
the standard engineering agreement on the City's contract form. We look forward to working with
you and the City of Coppell on this important project and are available at your convenience to discuss
)
this proposal further.
APPROVED FO T. HF, cITy OF COPPELL
te:
Sincj~e;ySincerely yodri~k~_,/~
I: \6160\coppel I\water system master plan 2000. doc
P~I V$. TIme; E;l~t
Isure
Monitoring
Pressure
in
water Distribution
Systems
· Installs on 21/2" hydrant nozzle
· Security cover available
· Environmentally rugged
· One year battery life
· Stores 21,000 data values
· Windows software support
· Easy data collection
To monitor the water pressure within any water
distribution system, you can simply attach the
HPR-2109e hydrant pressure recorder on the 21/2
inch hose nozzle outlet of a common fire hydrant.
The rugged aluminum enclosure of the HPR-2109e
is approximately the same size as the hydrant
nozzle cap.
Once installed, the HPR-2109e measures water
pressure once every second with its internal
pressure transducer. You can determine how often
such data is summarized for reporting. The
recorder computes any combination of minimum,
average and maximum of the pressure
measurement at each interval according to your
selection of statistics and recording interval.
Data collection is accomplished via a water tight
RS-232 connector accessible at the end of the
recorder enclosure. There is no need to dismantle
the installation and interrupt data recording to
collect data.
PSI vs. TIme; East MaJn Q Elm
HPR-2109e Specifications
Input
Range
Resolution
Accuracy
Temperature Effect
Recording
Sample Rate
Statistics
Statistical Interval
Memory Size
Strain gauge, isolated pressure sensor
0 to 100, 200 and 300 psi
0.025% of full scale, 12-bit
-+ 0.3% of full scale
at constant temperature
_+ 1.0% of full scale
over 0 to 60°C range
Variable from 1 second to 8 hours
Any combination of minimum, average and
maximum per interval
Variable from I second to 8 hours, based on
sample rate
32K EPROM; 32K RAM available for storage of
2K, 4K, 8K, or 21K values, user selectable
Serial Interface
Baud Rates
Bit Format
Connector
RS-232C
300, 1200, or 9600 baud
I start, 8 data, 1 stop
9-pin, sub-'D', water proof
Power
Battery
Battery Life
9 volt lithium or alkaline battery
Up to 15 months with lithium batteries and
Up to 6 months with alkaline batteries,
dependent on sample rate
Environmental and Mechanical
Temperature
Operating
Storage
Humidity
Enclosure
Size
Thread
-40° to 60°C (-40°to 140°FI
-40° to 70°C (-40° to 158°F)
0 to 100% relative humidity
Aluminum, NEMA 4X/IEC IP65
12.70 cm diameter x 8.89 cm
5" diameter x 3.5"
2.50" NHT standard, contact Telog for non-
standard thread
Computer Requirements
For S-2 1 PC Dos-based support software
IBM Compatible personal computer with 640K
bytes of rAM and MS-DOS version 3.3
Or higher
IBM compatible computer with a 586/133
MHz or higher processor running on
Microsoft Windows 95/98 or Windows NT
4.0, at least 24 MB Of RAM, a hard disk with at
least 200 MB of free space, and a pointing
device.
HPR-2109e Enclosure
Cover: top view
Connector
A
5.00'
side view
........ n~ 1o ........ '~'
I
I
I
I
I_ ....
2.00"
1.50"
·
2.50" NHT
Base: bottom view
3.50"
Since we are continually improving our products,
the specifications within this brochure are
subject to change without notification.
Telog is a registered trademark and Telogers is a trademark of Telog Instruments, Inc.
iVE. crosof~ Windows 95/98 and Windows NT are registered trademarks of Micro~o~ Corporation.
IBM is the registered trademark of International Business Machines.
Telog Instruments, Inc.
830 Canning Parkway, Victor, NY 14564-8940, U.S,A.
Phone: 716-742-3000 · Fax: 716-742-3006
~Vebsite: www. telog.com, E-mail: TelogSales~telog.com
12/98 hpr2109e.cdr