R-98-05-14-10E1 - 5/14/1998RESOLUTION NO. R -98-05-14-10E1
WHEREAS, the City of Round Rock, on September 22, 1997,
entered into a contract ("Contract") with RJN Group, Inc. for
engineering services for a Sanitary Sewer Evaluation Study, and
WHEREAS, RJN Group, Inc. has submitted Amendment No. 1 to the
Contract to include mapping services to update the City's water and
wastewater maps, and
WHEREAS, the City Council desires to enter into said
Amendment No. 1 to the Contract with RJN Group, Inc., Now Therefore
BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK,
TEXAS,
That the Mayor is hereby authorized and directed to execute on
behalf of the City Amendment No. 1 to the Contract with RJN Group,
Inc. to include mapping services to update the City's water and
wastewater maps.
The City Council hereby finds and declares that written notice
of the date, hour, place and subject of the meeting at which this
Resolution was adopted was posted and that such meeting was open to
the public as required by law at all times during which this
Resolution and the subject matter hereof were discussed, considered
and formally acted upon, all as required by the Open Meetings Act,
Chapter 551, Texas Government Code, as a ended, and the Act.
RESOLVED this 14th day of May,
TEST:
ANNE LAND, City Secretary
K:\WPDOCS\RESOLUTI\R80514E1.WPD/scg
HARLES CUL EPPER, Mayor
City of Round Rock, Texas
Amendment No. 1
WHEREAS, on the twenty-second day of September 1997 the City of Round Rock,
Texas and RJN Group, Inc. made and entered into a contract for Engineering Services related
to Sanitary Sewer System Study (SSES) in the City of Round Rock and
WHEREAS, the City of Round Rock desires to add additional services to update the
City's Water and Wastewater maps in accordance with Exhibit A of this Amendment.
WHEREAS, the City of Round Rock and RJN Group, Inc. desire to amend said
Contract, so as to include therein the necessary scope of work;
NOW THEREFORE, KNOW
ALL MEN BY THESE PRESENTS:
That the City of Round Rock, Texas, hereinafter called "City" and RJN Group, Inc.,
hereinafter called "Engineer", hereby make and enter into the following agreement:
The September 22, 1997 contract between the City of Round Rock and RJN Group,
Inc. is hereby amended to include additional services required to update the City's maps in
accordance with Exhibit A, attached hereto and made part of this Amendment No. 1. The
contract entered into on September 22, 1997 is hereby amended by increasing the cost
not -to -exceed ceiling in Section V, Fees and Payment to $518,143. A revised Attachment D is
also attached hereto and made part of this agreement.
All other provisions, covenants, recitals, terms and conditions of the Contract, which
are not expressly amended herein, shall remain in full force and effect.
April 3, 1998
-1-
IN WITNESS WHEREOF, thearties hereby have executed this agreement in
triplicate originals on this date, the % day of PIA, 19 8.
y
RJN GROUP, INC.
Firm Name
CITY OF ROUND ROCK
Sign ' re Signature
Mayor
Regional Vice President
Title
ATTEST
April 3, 1998
-2-
Title
A.4a.a,,fd.c&
EXHIBIT A
April 1, 1998
RJN GROUP, INC
CITY OF ROUND ROCK MAP CONVERSION PROPOSAL
PILOT PROJECT SCOPE
1. Introduction
The project implementation approach for the Map Conversion Project has been
formulated to attain the best value and use of resources in producing a GIS. A key
aspect of the project implementation approach is to begin the overall mapping project
with a Pilot Project. The pilot project will confirm the conversion process, the
suitability of deliverables, as well as providing a solid cost estimate for full project
implementation.
The pilot project conversion will include the Woods, Hermitage, and Oak Hollow
subdivisions. The Oak Hallow subdivision will be converted from as -built plans. The
Woods and Hermitage subdivisions will be converted from existing digital maps from
the City.
2. Water Mapping
Map symbols currently used on the City's existing water atlas maps will be used in the
deliverable MicroStation GeoGraphics GIS. Map features to be included on the water
map are:
Water mains
Hydrants
Standard valves, pressure reducing valves, isolation valves
Air relief valves
Reducers
Water service connections
Water meters
End of lines
Attribute data for pipes 8" and larger in the water system will include:
Pipe size
Pipe segment length
Pressure zone
Pipe construction material (only for areas converted from as -built drawings and
when shown on as-builts )
Point feature elevations, valves, etc. (only for areas converted from as -built
drawings and when shown on as-builts )
April 3, 1998
A(1)
Water attribute data will be derived from identified as -built, or plan drawings source
documents. A reasonable effort will be made to extract as much attribute data as
possible from the identified source documents. In the event that data items are absent
from the identified source documents, additional research, field work or extensive
interviews with City staff will not be conducted to insure that every data item is added
to the GIS.
The deliverable water map (target map) will be derived form two types of source maps.
One source map is an existing AutoCad map that covers a portion of the City limits.
This AutoCad map has been created and maintained by City staff. The remainder of
the water system that is not covered by the AutoCad water map will be converted from
existing subdivision as -built drawings and plan and profile drawings in hard copy
format. Research and verification of hard copy source maps will not be included in the
portions of the City covered by the existing AutoCad water map.
Water main features in the GIS will be defined as discrete pipe segments. Pipe
segments will extend from node to node, where a node is defined as a point in the
water system where:
Flow is controlled via modulating control device (PRV valves only)
Flow can change its path in the system (pipe intersection)
There is a change in pipe diameter
Hydrants and water meters and water service connections are not considered nodes in
the GIS. Valves that are associated with hydrants will not be included in the GIS
deliverable. Hydrants will be depicted on the deliverable maps using one specific
symbol for hydrants with valves and another symbol for hydrants without valves.
Water features derived from the hard copy plan sheets will be transcribed form the
source maps to the target map. The location of features on the target map will be
based on the position of features on the source maps, as they appear relative to base
map features such as ROW and lot lines. Due to nature of this relative placement
method of positioning features, water features will be located as accurately as possible,
considering that the relative position of base map features on the source maps will not
agree exactly with the relative position of base map features on the target map.
Water features derived from the AutoCad source map will be traced directly from the
AutoCad source map using CAD snap commands. As such, the location of features on
the target map will be the same as the location of features on the source maps.
The location of hydrants will be to the nearest lot. Water lines in new subdivisions are
generally offset from the ROW line by 1 foot. The city has generally digitized water
lines with a 5 foot offset from the ROW line for the purpose of cartographic clarity.
RJN will follow this offset convention for the deliverable water map.
RJN will develop and submit a numbering system for all water system features.
Following review and approval of the numbering system by the City, all features except
hydrant valves will be numbered. The deliverable feature numbering system will
April 3, 1998
A(2)
include a feature number prefix that indicates the pressure zone that the feature is
located in.
3. Wastewater Mapping
Map symbols currently used on the City's existing wastewater atlas maps will be used
in the deliverable GeoGraphics GIS. Map features to be included on the wastewater
map are:
Manholes
Cleanouts
Sewer line segments
Interceptors
Service connections
Lift stations
Force mains
Attribute data for the wastewater system for pipes 8" diameter and larger will include:
Pipe size
Pipe segment length
Pipe slope
Pipe invert elevations Manhole rim elevation (only for areas converted from
as -build drawings and when shown on as-builts)
Pipe construction material (only for areas converted from as -build drawings and
when shown on as-builts)
Wastewater attribute data will be derived from identified as -built, or plan drawings
source documents. A reasonable effort will be made to extract as much attribute data
as possible from the identified source documents. In the event that attribute data items
are absent from the identified source documents, additional research, field work or
extensive interviews with City staff will not be conducted to insure that every data item
is added to the GIS.
Wastewater sewer line features in the GIS will be defined as discrete pipe segments.
Pipe segments will extend from node to node, where a node is defined as any structure
in the system (manholes, lift station, etc.) Pipe features are always digitized in the
direction of flow.
The deliverable wastewater map (target map) will be derived form two types of source
maps. One source map will be a MicroStation map delivered by RJN Group under a
separate contract. This MicroStation map will cover a portion of the City limits. The
remainder of the wastewater system that is not covered by the MicroStation wastewater
map will be converted from existing subdivision as -built drawings and plan and profile
drawings in hard copy format. Research and verification of hard copy source maps
will not be included in the portions of the City covered by the existing MicroStation
wastewater map.
April 3, 1998
A(3)
Wastewater features derived from the hard copy plan sheets will be transcribed form
the source maps to the target map. The location of features on the target map will be
based on the position of features on the source maps, as they appear relative to base
map features such as ROW and lot lines. Due to nature of this relative placement
method of positioning features, wastewater features will be located as accurately as
possible, considering that the relative position of base map features on the source maps
will not agree exactly with the relative position of base map features on the target map.
Wastewater features derived from the RTN MicroStation source map will be converted
directly from MicroStation to the standard GeoGraphics GIS format. As such, the
location of features on the target map will be the same as the location of features on the
source maps.
4. Map Deliverables
The deliverable maps will be MicroStation GeoGraphics standard project digital maps,
compliant with the project GIS standards of MicroStation GeoGraphics. The GIS
project will be organized into wastewater and water feature categories. The positional
accuracy of features on the deliverable maps will not be compliant with professional
standards for map accuracy.
In order to insure a high degree of quality in the final deliverable, check plots will be
furnished to the City for review and comments prior to the final deliverable. Check
plots will be overlaid on the City's existing base map. Check plots will be submitted
on a 24" x 36" format. One set of check plots in black and white format will be
provided so the City can review the usefulness of black and white print format for use
in the field. Black and white plots will display water mains as a solid line and
wastewater pipes as a dashed line.
April 3, 1998
A(4)
Attachment D- Fee Schedule
Compensation to the ENGINEER for "Basic Engineering Services" shall be made as follows:
Compensation for Basic Services provided under Attachment B: "Scope of Engineering
Services" shall be in accordance with the methods in this attachment and the specific
amounts as set forth herein.
Compensation for the Basic Engineering Services shall be on the basis of a combination
of unit costs and lump sum costs.
A. Budgetary Amount
A budgetary amount for the Basic Services set forth in Attachment B: "Scope of
Engineering Services" is hereby estimated below. It is also understood that the cost
budgets are based upon ENGINEER's best estimate or work and level of effort
required for the proposed scope of services. As the project progresses, it is
possible that the level of effort and/or scope may differ up or down from that
assumed. If there are no scope changes, the ENGINEER shall receive the full
amount shown below. If at any time during the project it appears that the cost may
be exceeded, the engineer will notify the CITY as soon as possible in writing.
B. Cost Breakdown
UNIT ESTIMATED TOTAL
TASK DESCRIPTION UNIT COST QUANTITIES COST
Mobilization and Project LS $29,340.00 1 $29,340
Administration
Data Management LS 69,122.00 1 69,122
Program/Modeling
Sewer System Mapping EA 7.13 3,300 23,526
Flow Monitoring
Site Selection meter 306.05 38 11,630
Maintain Meters meter/day 58.49 2,280 133,365
Install Meters meter 219.74 38 8,350
Flow Analysis/Interim LS 65,084.00 1 65,084
Report
ManholeNisual Pipe EA 72.52 1830 132,712
Inspection
CIP Recommendations LS 5,104.00 1 5,104
Model Software LS 20,000.00 1 20,000
Model Training LS 3,500.00 1 3.500
SUBTOTAL, Original Contract $501,733
April 3, 1998
D(1)
Attachment D (Cont.)
UNIT ESTIMATED TOTAL
TASK DESCRIPTION UNIT COST QUANTITIES COST
Additional Services
Map Updates
Task 1 - Project LS 2,930.00 1 $2,930
management/mobilization
Task 2- Convert existing LS 3,780.00 1 3,780
digital maps for pilot area
into GeoGraphics GIS
Task 3 - Convert as -built
drawings into GIS map
Oak Hollow Subdivision LS 2,960.00 1 2.960
Task 3 total 2,960
Task 4 - Project LS 4,340.00 1 4,340
Deliverables
Task 5 - Quality Assurance LS 2,400.00 1 2.400
SUBTOTAL, ADDITIONAL SERVICES $ 16.410
TOTAL REVISED CONTRACT AMOUNT $518,143
April 3, 1998
D(2)
DATE: May 8, 1998
SUBJECT: City Council Meeting - May 14,1998
ITEM: 10.E.1. Consider a resolution authorizing the Mayor to execute a contract
amendment with RJN, Inc. for mapping services. The scope of work is
a pilot project consisting of converting as -built water/wastewater
plans and existing digital planimetic into a GIS conversion process in
order to prepare a utility mapping project. This proposed pilot study
is $16,410.00. Staff Resource Person: Jim Nuse, Public Works Director.