CN-550000-BEA16-00100000.pdf

STATE OF FLORIDA DEPARTMENT OF TRANSPORTATION

TASK WORK ORDER FOR PROFESSIONAL SERVICES

375-030-25

PROCUREMENT

06/17

Consultant:

Address:

Date:

7/21/2025

*Limiting or Estimating/Budgeted Amount.

Distribution:

Task Work Order No.:

Contract No.: Payment FM No.:

BEA16 435445-1-82-04

$409,900.00

(name) (title) Signature

James S. Stroz, Jr., P.E. District Traffic Operations Engineer

Other Notes:

An independent assessment of the staff hours and quantities for the proposed services has been performed, and found to be fair, reasonable, and competitive.

(LS2) Lump sum paid based on % of completion

Page 1 Total

Page 2 thru 6 Subtotal

Total

Scope of Work attached

VANASSE HANGEN BRUSTLIN, INC.

225 E. Robinson Street

Suite 300

Orlando, FL 32801

(To be entered upon execution of T.W.O.)

Brief Task Description:

In accordance with the above referenced contract, you are authorized to perform the tasks detailed in attached Exhibit A (Scope of Services).

Compensation elements are as follows:

Element Description Amount Estimate/LimitMethod of Compensation

The total amount or the limiting amount of the compensation will be:

All services required under this Task Work Order will be completed on or before:

$55,516.00

$55,516.00 Limit

SunStore Data Maintenance, Environment and Management Support & D5 ITS ArcGIS Server and ArcGIS Portal Support

Signature

SE Regional Manager

$55,516.00

$0.00

(name) (title)

David Mulholland

$55,516.00

Payment will be authorized based on hours submitted for each monthly progress estimate and is defined in ATTACHMENT "B".

Total authorizations to date (including this one):

Departmental Approval:

Consultant Acceptance:

DocuSign Envelope ID: 7C0D64B5-3CCF-43C0-912B-398EBE9F0B8F

9/28/2021 | 8:12 AM EDT

Total

Pay Item Quantity Unit Price Total

1 20 HR 131.00$ 2,620.00$

1 32 HR 98.00$ 3,136.00$

1 96 HR 95.00$ 9,120.00$

1 128 HR 160.00$ 20,480.00$

1 168 HR 120.00$ 20,160.00$

Total Hours = 444 Task Work Order Total = 55,516.00$

Description

BEA16 - Task Work Order 08 Details

Junior Programmer

Traffic Data Scientist

Junior Traffic Data Scientist

Junior Visualization Specialist

Programmer

ATTACHMENT A

SCOPE OF SERVICES

ITS Software Integration & Maintenance Services for the SunStore and Future Deployments

Financial Project ID No. 435445-1-82-04

Contract BEA16

District Five

TWO 08 - SunStore Data Maintenance, Environment and Management Support & D5 ITS ArcGIS Server and ArcGIS Portal Support

A. SCOPE OF SERVICE

Vanasse Hangen Brustlin (VHB) will provide the following services related to continuation of data maintenance, server environment and management support of data in the SunStore and support of the current D5 ITS ArcGIS Server and ArcGIS Portal for the Florida Department of Transportation (FDOT)

District 5 (District).

PROJECT GOALS AND OBJECTIVES

The purpose of this project to provide the District with the continuation of support and maintenance of the FDOT SunStore.

The objectives of the project are summarized as follows:

- VHB will provide the District with maintenance and support of the data and APIs within the

SunStore o Including updates to SunGuide Data Dictionary and API page for additional changes

- VHB will provide the District with support of the SunStore environment including o WebAPI Server o ElasticSearch Cluster o Ingestion Nodes o SQL Server Environment

- VHB will provide support for the administrative component of the SunStore’s Token and Role

Manager and web applications

- Support and Maintenance for the D5 ITS ArcGIS Server and ArcGIS Portal (Production server)

- VHB will provide data and application support and updates to SunStore existing applications including the SunStore Data Picker and RTMC Map

B. TASKS

TASK 1: SunStore Maintenance and Support

VHB will provide the District with the management and support of data, server and APIs within the

SunStore. As part of this support and maintenance of the SunStore, VHB may assist the District with the following scope areas:

- Provide the District with maintenance support of the existing data and APIs in the SunStore

- Creation and deployment of specialized APIs for existing data in the SunStore

- Provide the District with support for the integration of data and APIs within the SunStore to other

District initiatives

- Update of data dictionaries and metadata within the SunStore’s Token and Role Manager to reflect changes and updates to data existing in the SunStore

- Update of data dictionary content in the SunStore web page to reflect download and query ability and time period

- Provide administration component support of the SunStore’s Token and Role Manager including creation of roles, approval of users, assignment of APIs, and additional support of the Token and

Role Manager

- Maintenance and monitoring of data processes within the SunStore including ingestion, data requests, APIs, and updates

- Perform necessary hardware and software maintenance, support, and updates to the internal components with the SunStore

- Provide continued communication with the District to identify storage, hardware, and data recommendations

- Provide support to the District’s ITS program in various elements of the SunStore

DELIVERABLES:

- Continuation of data maintenance, server environment and management support of the FDOT

District 5 SunStore

TASK 2: Support and Maintenance of D5 ITS ArcGIS Server and ArcGIS Portal (Production)

Under this task VHB will provide support and maintenance to the ArcGIS Server and ArcGIS Portal server in the production server and the development server. VHB will provide technical question support on details of the production environment configuration, if necessary, to aid in ensuring the development environment is a mirror of the Production environment. Once the Development Environment is configured and accepted by FDOT as deployed, VHB will provide support and maintenance of the

Development ArcGIS Server and ArcGIS Portal. Support and Maintenance under this task are limited to these two servers and do not include additional ArcGIS software, extensions, patches or upgrade deployed on separate servers.

The development ArcGIS environment will be deployed and initially configured by FDOT, once that environment is configured and operating, VHB will provide support for this environment. This development environment will be deployed and configured on a separate server from the deployed D5

ITS ArcGIS Server and ArcGIS Portal environment. This environment will be configured to serve a mirror version to the deployed environment with the same ArcGIS software packages and versions installed to provide fail over and testing opportunities which will not impact the D5 ITS production ArcGIS Server and

ArcGIS Portal environment. This environment is meant to serve as a development and testing environment to allow scripts, processes, procedures, or applications to be tested prior movement to the production environment. VHB will maintain this environment and oversee the mirror configuration between the Production and Development ArcGIS environment.

Maintenance of the ArcGIS Portal and ArcGIS Server currently in Production and the Development server may include but is not limited to the following:

- Update and Installation of patches, licenses, upgrades, and recommended ESRI best practices for the servers where ArcGIS Portal or ArcGIS Server are installed and configured

- Support of ArcGIS Server services currently existing with data in the SunStore registered database that published under the following folders of the ArcGIS Services:

o SunStore Applications

Services specific to SunStore applications, scripts, or for use in other SunStore needs o RCI

Services included in this folder are specific to the pass through from Central Office for the static RCI datasets shared by Central Office or specifically in use for a

SunStore application need o Hosted*

The hosted folder includes all services directly published to the SunStore ArcGIS and ArcGIS Portal environment. Support for services in this folder are limited to those in use for SunStore applications. All other services published by other users not specific to the SunStore are not included in this support

- Support of existing scripts within the SunStore ArcGIS desktop workstation that publish data currently available in the SunStore into specific services via the ArcGIS Server and ArcGIS Portal environment.

- Support and maintenance of the ArcGIS Server and Portal instance in production and development server. This support and maintenance refer to review and configuration of ArcGIS

Server and ArcGIS Portal software platforms or software components related directly to the ESRI platform install in the server currently containing the ArcGIS Server and ArcGIS Portal, this maintenance may include:

o Periodic or as needed reboots of the ArcGIS Server or ArcGIS Portal o Review of existing service configuration within the ArcGIS Server or ArcGIS Portal o Management or Updates as requested by the District to users assigned roles in the ArcGIS

Portal

- Review and update of Jira trouble tickets for the ArcGIS Server or ArcGIS Portal in the identified production or development environment.

- SunStore Change Management Jira ticket TSD-3637/TSD-3671 enhancements.

DELIVERABLES:

- Support and maintenance of the ArcGIS Server and ArcGIS Portal server (production and development)

- Update and push of code and scripts to the FDOT Code Repository

Task 3: SunStore Application Base Data Update and Functionality Check

Under this task, VHB will perform ongoing maintenance to the base data network used by applications in the SunStore including the SunStore’s Data Picker and RTMC Interactive map. This effort will be focused on updating the underlying base data network of the HERE.com dataset which provides the ability to identify roadway segments available in the SunStore based on the updated roadway network configuration which accounts for changes in the network such as alignments or new construction. This network is used as the primary query network of the SunStore applications which rely on the HERE probe data to relay speed, travel time, and other metrics.

Once the underlying base network update has been completed, VHB will perform necessary updates in the Data Picker and RTMC map to allow this new layer to be used. This may include updates to the following:

- Roadway network query API for selecting connected HERE TMC

- Updates to the HERE TMC network links

- Updates to the Corridor reference in the RTMC map

- Updates of select field query values needed in the update process

- Publish to the D5 ITS ArcGIS Portal environment of the updated base layer

- Configuration of the SunStore Data Picker to use HERE data

In addition to the main base layer updates, VHB will also perform a general workflow maintenance update in the Data Picker to account for changes in data availability. This update will also revisit an API update that is needed to allow the Data Picker to perform searches across data sets which may return incomplete or missing records such as known gaps in ITSIQA or HERE data.

DELIVERABLES:

- Updated base network for use in SunStore Data Picker and RTMC application

- Update and framework updates for SunStore Data Picker

C. Services Not Provided

Under this task the following services will not be provided or included in relation to maintenance or support:

- VHB will not support the server environment where the ArcGIS GeoEvent Server is installed.

This includes providing updates, patches, estimating growth sizes of the ArcGIS GeoEvent server hardware or software since the production and future development ArcGIS GeoEvent servers are operated and maintained by the R-ICMS contract.

- VHB will not provide support for scripts running on the ArcGIS GeoEvent server which publish services to the ArcGIS Server or ArcGIS Portal.

- VHB will not provide support for services which are published by users in the SunStore ArcGIS

Server or ArcGIS Portal which are not contained in the following service folders:

o SunStore Applications o RCI o Hosted

- VHB will not provide support for any new ArcGIS Server services requested to be published in

SunStore Applications, RCI, or Hosted service folders under this TWO.

D. PROJECT SCHEDULE

The project is anticipated to be completed by January 14, 2022

E. FEE ESTIMATE

Details of the estimated man-hours, out of pocket expenses, and fees for this task assignment are transmitted separately.

A-T-T-A-C-H-M-E-N-T "B"

GENERAL ENGINEERING CONSULTANT

Work Order No. 8

JOB CLASSIFICATION MANHOURS SALARY

TOTAL

SALARIES

Financial ID No.: 435445-1-82-04 Traffic Data Scientist 20 131.00$ 2,620.00$

(Agreement) Junior Traffic Data Scientist 32 $98.00 3,136.00$

Visualization Specialist 0 $102.00 -$

Financial ID No. Junior Visualization Specialist 96 $95.00 9,120.00$

N/A Programmer 128 $160.00 20,480.00$

(Services) Junior Programmer 168 $120.00 20,160.00$

Loaded Salary Total - Office Overhead 444 55,516.00$

BRIEF DESCRIPTION

Loaded Salary Total - Field Overhead 0

Work Order No. 8

FEE ESTIMATE (Computations)

Total Loaded Salary Costs - Office Costs 55,516.00$

(a) Office Overhead @ 0.00%

NAME OF CONSULTANT (b) Operating Margin @ 0.00%

(c) FCCM @ 0.00%

VHB (d) Expenses @ 0.00%

Subtotal Subconsultant - Office Costs 55,516.00$

Total Loaded Salary Costs - Field Costs

(a) Field Overhead @ 0.00%

(b) Operating Margin @ 0.00%

(c) FCCM @ 0.00%

(d) Expenses @ 0.00%

Subtotal Subconsultant - Field Costs

TOTAL UPSET LIMIT FEE 55,516.00$

SunStore Data Maintenance, Environment and Management Support &

D5 ITS ArcGIS Server and ArcGIS Portal

WORK ACTIVITY

Traffic Data

Scientist

Junior Traffic

Data Scientist

Visualizatio n Specialist

Junior

Visualization

Specialist Programmer

Junior

Programmer TOTAL

1 SunStore Maintenance and Support 8 80 40 120 248

Support and Maintenance of D5 ITS ArcGIS

Server and ArcGIS Portal 4 32 16 8 8 68

3 SunStore Application Base Data Update 8 80 40 128

GRAND TOTAL 20 32 0 96 128 168 444

General Engineering Consultant Services

Financial ID No.: 435445-1-82-04

MANHOUR ESTIMATE SHEET

SunStore Data Maintenance, Environment and Management Support & D5 ITS ArcGIS Server and ArcGIS Portal Support

Work Order No. 8

VHB