R18-136 1 RESOLUTION NO. R18-136
2
3 A RESOLUTION OF THE CITY OF BOYNTON BEACH,
4 FLORIDA, APPROVING AND AUTHORIZING THE CITY
5 MANAGER TO SIGN TASK ORDER NO. UT-1C-01 WITH
6 CAROLLO ENGINEERS,INC.,IN ACCORDANCE WITH RFQ NO.
7 046-2821-17/TP, GENERAL CONSULTING SERVICES, FOR GIS
8 WORK IN CONNECTION WITH UTILITY INFRASTRUCTURE
9 MANAGEMENT NOT TO EXCEED $189,135.00; AND PROVIDING
10 AN EFFECTIVE DATE.
11
12 WHEREAS, Carollo Engineers was awarded a General Consulting Services Contract,
13 Scope C, on August 7, 2018 in accordance with RFQ No. 046-2821-17/TP; and
14 WHEREAS, Carollo Engineering and their sub-consultant, Florida Technical
15 Consultants (FTC) have been working on the City Utility Infrastructure base map in order to
16 prepare hydraulic models and assist with management of the Utility Systems;
17 WHEREAS, this Task Order will provide staff with assistance updating the base map
18 and enable improved research of field conditions while additionally, FTC will migrate the date
19 into the City/Utility SQL server which will facilitate the use of other existing software systems;
20 and
21 WHEREAS, staff is recommending that the City Commission approve Task Order No.
22 UT-1C-01 with Carollo Engineers, Inc., for GIS work in connection with Utility Infrastructure
23 Management in an amount not to exceed$189,135.00 utilizing the City's existing contract RFQ
24 046-2821-17/TP "GENERAL CONSULTING SERVICES".
25 NOW, THEREFORE, BE IT RESOLVED BY THE CITY COMMISSION OF
26 THE CITY OF BOYNTON BEACH, FLORIDA, THAT:
27 Section 1. The foregoing "Whereas" clauses are hereby ratified and confirmed as
28 beim true and correct and are hereby made a specific part of this Resolution upon adoption
29 hereof.
C'\Users\StanzioneT' ppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\Y9FBE411\Carollo Engineers Task Order No UT-1C-01-Reso docx
1 Section 2. The City Commission of the City of Boynton Beach,Florida does hereby
2 approve and authorize the City Manager to sign Task Order No. UT-1C-01 with Carollo
3 Engineers, Inc., for GIS work in connection with Utility Infrastructure Management in an
4 amount not to exceed $189,135.00 utilizing the City's existing contract RFQ 046-2821-17/TP
5 "GENERAL CONSULTING SERVICES", a copy of which is attached hereto as Exhibit "A".
6 Section 3. This Resolution shall become effective immediately upon passage.
7 PASSED AND ADOPTED this 20th day of September, 2018.
8 CITY OF BOYNTON BEACH, FLORIDA
9
10 YES NO
11
12 Mayor— Steven B. Grant
13
14 Vice Mayor—Christina L. Romelus
15
16 Commissioner—Mack McCray t'
17
18 Commissioner—Justin Katz
19
20 Commissioner—Joe Casello
21
22
23 VOTE -0
24 ATTEST:
25
26
27 41;(� �—�- a ibl
28 Juditl/ 1. Pyle, CMC
29 City 'lerk
30
31
32
(Corporate Seal)
.\N\\\\\\\\\
•
�f O T'0 t„*,,
IPS
d.0;;..
•
. . f r-
•
'.r ter ``c��, ••' —`-',:
in ::,.5 A C:\Users\St`rvi eTWppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\Y9FBE411\Carollo Engineers Task Order No UT-1C-01-Reso.docx
Engineers...Working Wonders With Water.,
August 24, 2018
Mr. Michael Low
City of Boynton Beach
124 E. Woolbright Rd.
Boynton Beach, FL 33435
Subject: Task Order No. UT-1C-01
Dear Mr. Low:
Attached is our proposal for GIS services for the year 2018.
We look forward to working with the City on this important project.
Sincerely,
CAROLLO ENGINEERS, INC.
Elizabeth Fujikawa, PE, LEED AP
Vice President
tg:n
Boynton Beach\SOW_2014_081 i I GIS for Year 2018 docx 2056 Vista Parkway,West Palm Beach Florida 33411
P.561.8684400 F 561868:640,1;
carollo.com
Florida Technical Consultants,LLC
1111 533 East Ocean,Suite 02
Boynton Beach, FL 33435
Tel 954-914-84 S8
°""Cbbi"""' jbarton@tttechinc_com
Elizabeth Fujikawa<EFujikawa@carollo.com> August 20,2018
Elizabeth Fujikawa
Carob Engineers
Subject: Boynton Beach Utilities GIS Work Plan
Dear Ms.Fujikawa,
Florida Technical Consultants(FTC)is pleased to provide this Work Plan and Scope for GIS Support services
to the Boynton Beach GIS Implementation. There are several initiatives to be supported by GIS_ The following
work plan addresses the priority work items identified by the City. Each task will have a deliverable which can
be measured and reported. The priorities are:
• Data Migration into City Water System
• Additional Applications and Data to support Operations
Task 1:Migrate Background Layers
The systems have been updated by staff. The Water system has been implemented for Hydrants. The base
data has to be migrated into the server and converted to background serves used by(Water. As additional
information is updated by field crews,this data will be entered into GIS,validated and loaded.
The following systems will be migrated into the City/Utility SQL Server and processed for iWater.
• Potable Water
• Reclaim Water
• Sanitary Gravity
• Sanitary Pressure
• Stormwater
Additional layers posted for SQL server may include:
• As-Built Layer
• Communications
• Other Layers as necessary
Data that was updated by staff will be:
• validated by FTC and
• migrated into LGIM
• Loaded into SQL Server
• Posted for NVater
• Posted for City hosted ArcGIS Online
ArcGlS Online Support
• Online supported by City GIS
• FTC will coordinate with City GIS to set up groups,data access,etc.
pw://Carolb/Documents/Client/FUPompano Beach/8683D10 Phase II/Specilications/SOW_2014_0811 2
Deliverables
FTC will provide the following deliverables.
Technical Memo outlining the results of coordination with The City GIS Department to:
• Identify Users and Departments
• Establish data storage and backup
• Define access and permissions
Maps,Apps and Data to support operations
• Background data migrated to City I Utility Server
• ArcGIS Online Interface for Groups and Users on City System
• Online Maps and Applications on City System
• All data updated to City System
Training
• Training Schedule defining dates and subjects
• On-Site training
• Training support manuals I videos
Monthly Report:FTC will provide Carollo monthly project status report outlining:
• Activities
• Status of data updates
• New Maps and Apps
Assumptions
• The City will provide access to all relevant utility drawings,CAD plans and background information.
• The City will provide access to staff necessary to research and digitize data
• The City will provide access to staff necessary for training
• The City will provide a training location with a strong intemet connection
Fees and Schedule
All tasks will be billed on an hourly basis according to the following schedule.
Task GIS Trainer Senior GIS Analyst Fees Schedule
$135/hr $115/hr
Task 1:Migrate Background Layers 80 120 $24,600 2 Months
Task 2:Operations Support 300 850 $138,250 12 Months
Total Hours 380 970 $162,850
Any funds remaining in a task upon completion of that task will be reallocated to another task or to Data
Completion according to budget Carollo will be billed monthly according to the services and deliverables
provided.
FLORIDA TECHNICAL CONSULTANTS Page 3 of 4 8/2012018
Boynton Beach GIS Services
pw:llCarollo/Documents/ChenURlPompano Beach/8683010 Phase II/Specifications/SOW_2014_0811 4
Thank you for including us on your team. If you approve the proposed scope of not to exceed 5162,850 please
sign this proposal in the area provided below. Should you have any questions,please do not hesitate to
contact me at my office at(954)954-8488,or send me an electronic message at jbartongrfltechinc.com.
Respectfully submitted,
i
111
.40
Flo echnical Consultants
James Barton,P.E.
Approved by Carollo: President
(Print Name) (Date)
(Signature)
FLORIDA TECHNICAL CONSULTANTS Page 4 of 4 8/20/2018
Boynton Beach GIS Services
pw:llCarolb/Documents/Client/FUPompano Beach/8683D10 Phase IIISpecifications/SOW_2014_0811 5
Task 2:Operations Support
Mobile/Desktop GIS Applications
The City continues to expand the use of GIS in operations. FTC will support this growth through development
of applications specific to maintenance and train staff on their use. Applications will be built according to the
priorities of the City and may include:
• As-Built Tracker Linking as-built drawings to the mapped points
• Emergency / Disaster Response: Specific to teams reporting damage and tracking repairs for
emergency operations including hurricanes.
• Civic Engagement I Call Center. Tracking customer calls and issues, mapping the locations and
recording the same information presently recorded. This tool will allow everyone in the organization to
review the status and location of calls.
• Sanitary Manhole Inspection: Sanitary teams will inspect manholes, take photos and provide rapid
condition assessments.
• Project Status Tracker.mapping CIP and Developer Projects found i eBuikier and allowing everyone
to review the status.
• Water Support:As additional systems are added to Water,FTC will support the form development.
• Dashboards:Management will be able to track key metrics on all system contents.
Data Updates and Development
The Potable Water System has been updated for pressure modeling. There are over 10,000 system valves that
need to be added. FTC will work with staff to identify, map and catalog the system valves. These will be
loaded into Water in advance of the valve crew maintenance. FTC will work with staff to:
• Identify areas where valves are missing
• Research records to find valves
• Field verify locations
• Map valves
• Snap water lines
• Enable valve isolation
FTC will continually work with staff to update GIS Data based on
• Information from field data collection.
• Historical as-builts in paper scanned format(non-CAD)
• Internal construction projects
• Internal maintenance operations
Training:FTC will provide an extensive training program to utilities staff including but not limited to:
• GIS Desktop:General training to create maps,edit data and perform analysis
• ArcGIS Online:General training on data viewing and editing. Specific training for field crews
• As-Built tracking:Provide training on collecting,reviewing and converting as-built data into GIS
• Training Manuals I Videos:Training manuals/videos will be provided for staff to review in the future
FLORIDA TECHNICAL CONSULTANTS Page 2 of 4 8/20/2018
Boynton Beach GIS Services
pw:llCarolb/Documents/Client/FUPompano Beach/8683D10 Phase II/Specifications/SOW_2014_0811 3
GIS Services for the Year 2018
Contract No.: 046-2821-17/TP-General Consulting Services
Scope Category"C"
Task Order No. . UT-1C-01
SCOPE OF SERVICES
Background
The City of Boynton Beach (City)wants to enhance the use of their GIS through standardization
of data management and increase in usage by City staff.
Scope of Work
This work will be done by Florida Technical Consultants as detailed in the attached pages.
Fee
The method of payment for this project will be the hourly billing rates plus reimbursables plus a
subconsultant markup of 10 percent by Carollo. Total cost not to exceed $189,135.
Schedule
Work will be completed over the course of the year 2018-2019.
pw:llCarollo/Documents/Client/FUPompano Beach/8683D10 Phase II/Specifications/SOW_2014_0811 1