Ford, Shelly R

From: Bouza, Eddy

Sent: Thursday, June 27, 2024 9:27 AM

To: Ford, Shelly R

Subject: FW: Requested Schedule Mod

Categories: TA21 CN335

Shelly, I’ve gotten this change approved by leadership, can you prep the amendment to be ready for signature on Monday

July 1?

From: Michael DelCharco <mdelcharco@taylorengineering.com>

Date: Monday, June 10, 2024 at 3:29"PM

To: Bouza, Eddy <Eddy.Bouza@FloridaDEP.gov>

Cc: Ford, Shelly R <Shelly.R.Ford@FloridaDEP.gov>, Ashley Lein <ALein@TaylorEngineering.com>, Natalie Lamb <nlamb@taylorengineering.com>

Subject: Re: Requested Schedule Mod

EXTERNAL MESSAGE

This email originated outside of DEP. Please use caution when opening attachments, clicking links, or responding to this email.

Hello Eddy -

Thank you for the email and clarification. We are find with phases as opposed to draft and final.

Thank you, Michael

Michael DelCharco, P.E., CFM Senior Vice President/Coastal Strategies

From:

Sent:

To:

Cc:

Subject:

Sorry I forgot to mention I did tweak some of the language below, most notably, referring to the submissions in phases as opposed to draft and final. If you are amenable to this compromise, we can maintain our compliance with current statute, and have something that we use (with disclaimer) for when the portal opens on July 1 in case there are communities that don’t have a VA or VA is still underway.

From:

Sent:

To:

Cc:

TASK ASSIGNMENT CHANGE ORDER NO. 3

TO TASK ASSIGNMENT NO. 21

REVISED SCOPE OF WORK

STATEWIDE VULNERABILTY ASSESSMENT

RESILIENT FLORIDA PROGRAM

BACKGROUND: The Resilient Florida Program, within the Office of Resilience and Coastal Protection of the Florida Department of Environmental Protection (Department), is tasked with the development of a comprehensive statewide flood vulnerability and sea level rise assessment (Statewide Assessment).

Pursuant to Subsection 380.093(4), Florida Statutes (F.S.), the Department shall complete the Statewide Assessment, which identifies inland and coastal infrastructure, geographic areas, and communities in the state that are vulnerable to flooding and sea level rise and the associated risks. Three (3) elements of this study include:

1) The Department will use the comprehensive statewide flood vulnerability and sea level rise data set (Comprehensive Data Set) to conduct the assessment.

2) The Statewide Assessment must incorporate local and regional analyses of vulnerabilities and risks, including, as appropriate, local mitigation strategies and post-disaster redevelopment plans.

3) The Statewide Assessment must include an inventory of critical assets, including regionally significant assets, that are essential for critical government and business functions, national security, public health and safety, the economy, flood and storm protection, water quality management, and wildlife habitat management, and must identify and analyze the vulnerability of and risks to such critical assets. When identifying critical assets for inclusion in the Statewide Assessment, the Department shall also take into consideration the critical assets identified by local governments and submitted to the Department through a statutorily compliant vulnerability assessment conducted pursuant to s. 380.093(3), F.S.

PROJECT OVERVIEW: Taylor Engineering (Contractor) will develop a statewide vulnerability assessment using consistent flood risk databases across the state. This statewide vulnerability assessment will produce a large quantity of data and graphics. The project will be conducted such that the data can be incorporated into a webtool suitable for the Department. The project team anticipates coordination with the Department’s Office of Technology and Information Services (OTIS) and OTIS contractors in development of the webtool to allow the public and local governments to interactively explore data relevant to their geographic area of interest.

The spatial analysis shall identify the critical assets that are vulnerable to the different flood scenarios and planning horizons (Exposure Analysis). Where information allows, the assessment shall also determine the severity of the vulnerability of the asset in the specific flood scenario(s) and assign a “risk score” for individual assets that can be used in prioritization (Combination of Exposure and Sensitivity Analysis results). Finally, the tool shall create a detailed report listing all vulnerable critical assets categorized by asset type and a summary of all findings. The required completion time for the project is no later than July 31, 2024.

The Contractor may subcontract with other qualified firms for services to expand the project team to meet the goals of this scope. All subcontractor requests must be submitted to the Department in writing in accordance with Section sixteen (16) of the Original Contract.

Statewide Vulnerability Assessment July 1, 2024

GENERAL REQUIREMENTS

Florida Flood Hub (Flood Hub) Coordination: The Contractor will discuss available inland flood hazard datasets with the Flood Hub and understands the Flood Hub does not have a comprehensive inland, future conditions dataset. The Contractor will continue to work with and coordinate data and programming tools with the Flood Hub.

Catastrophic Flood Risk Data: The Contractor may work with a private catastrophic risk analysis firm that can provide a comprehensive flood hazard dataset for the State. The data provided may have some restrictions on release and this will require coordination with the Contractor and the State to ensure the data are available in an appropriate manner to end users.

GIS Data Format: All Florida state agencies and commissions exclusively leverage Esri’s GIS software and infrastructure. Therefore, all GIS products generated by this task assignment must be delivered in a file format compatible with the Esri’s ArcGIS software ecosystem. Example of acceptable file formats are listed below:

Esri Hosted Feature Service

Esri File Geodatabase

Esri Project Package

Shapefile

A complete list of compatible file formats for vector data can be found online at https://pro.arcgis.com/en/pro-app/latest/help/projects/supported-data-types-and-items.htm

A complete list of compatible file formats for raster data can be found online at https://pro.arcgis.com/en/pro-app/latest/help/data/imagery/supported-raster-dataset-file-formats.htm

GIS Metadata: All associated metadata to be delivered must comply with the Federal Geographic Data Committee (FGDC) Content Standard for Digital Geospatial Metadata. A copy of these standards can be found online at https://www.fgdc.gov/metadata/csdgm-standard.

Programming Language: The codebase for the assessment is intended to be developed using the Python programming language, version 3.7.11 or later. The code will make use of the ArcGIS Pro module arcpy, and the ArcGIS API for Python, where applicable. If the Contractor deems it not possible to complete any part of the assessment using the required programming language, the Contractor shall submit a list of alternate programming languages compatible with ArcGIS Pro software as part of the TP, for review and approval by the Department.

Programming Style: The code and programming style shall follow the recommendations from the Python Enhancement Proposals, PEP 8 – Style Guide for Python Code (PEP 8 guide). A copy of the PEP 8 guide can be found online at https://peps.python.org/pep-0008.

Use and Distribution Rights: The Department shall hold all rights and interests in the development project and resulting script tool under this SOW. However, some of the catastrophic flood risk datasets may have restrictions regarding the use and distribution.

DATASET REQUIREMENTS

Comprehensive Data Set: The analysis shall make use of the Department’s compiled critical infrastructure dataset to perform the assessment. The compiled dataset can be found online at:

https://fdep.maps.arcgis.com/home/item.html?id=8f8043e84f694fb695adc8be67c9ba62

Supplemental Datasets: The Contractor shall analyze and compile supplemental datasets, not included in the Comprehensive Data Set, that might be relevant to perform the assessment. The Contractor shall include the list to the Department as part of the TP for review and approval before implementation into the final dataset.

Climate Hazard Dataset: The Contractor shall use publicly available climate hazard datasets for the following flood risk scenarios:

Sea Level Rise: Sea level rise projection datasets from Florida Flood Hub for Applied Research and Innovation (Flood Hub), NOAA, or other appropriate publicly available data.

Storm Surge: At a minimum, current storm surge dataset from FEMA for the 100-year storm event or other appropriate publicly available data.

Tidal Flooding: Current tidal flooding dataset from NOAA, or other appropriate publicly available data.

Rainfall-Induced Flooding: Data from USGS, FEMA, or Florida Flood Hub are limited to current conditions and events modeling. Once available, any future conditions rainfall-induced flooding data that is approved by the Department should be able to be incorporated into the project, or in future updates of the Statewide VA.

The Contractor will explore catastrophic risk modeling datasets for applicability to this statewide analysis.

Elevation Data: The Contractor shall use the statewide Digital Elevation Model (DEM) included in the Comprehensive Data Set. Elevation certificates and more accurate elevation datasets can be used where available.

Florida Flood Hub Dataset: The Contractor shall work in collaboration with the Flood Hub and prepare to incorporate the Florida specific flood risk and/or rainfall datasets they are currently developing.

ANALYSIS & RESULTS REQUIREMENTS

Exposure Analysis: The assessment should identify critical assets that are vulnerable to the appropriate flood scenarios. The flood scenario will be identified into the asset dataset following the provided base table schema.

Sensitivity Analysis: The assessment should determine the severity of vulnerability of the asset to the specific flood scenario. This can be accomplished by analyzing specific asset attributes, asset elevation, and other relevant information available of the asset. The flood scenario asset and vulnerability information will be identified into the asset dataset following the provided base schema.

Assessment Report: The script tool shall be able to create and export a report of all the findings for the assessment for each specified flooding scenario and consider including the following information:

Summary of the geographic extent (county, municipality, elevation statistics, etc.)

Summary of the critical asset being analyzed, including a breakdown of the asset groups and types as defined in F.S. 380.093(2)(a), and showed in the GIS Standards for Resilient Florida. A copy of these standards with the asset classification can be found online at:

https://floridadep.gov/sites/default/files/GIS%20Data%20Standards%20for%20Resilient%20Flor ida_final_0.pdf.

Summary of the flood scenario(s), including relevant metadata information.

Summary of the planning horizon

Inventory of all vulnerable critical assets from the Exposure Analysis

Inventory of all vulnerable critical assets from the Sensitivity Analysis

Map of the general geographic extent to a relevant scale.

In addition to the requirement sections noted above, the following tasks comprise this scope of work.

Task 1: Technical Proposal

Description: The Contractor shall submit a detailed Technical Proposal (TP) containing information on the Contractor’s approach to develop the assessment and complete the full scope listed in this task assignment. At minimum, the TP will consider:

The workplan for the project.

List of recommended publicly available datasets for use in the assessment.

Any identified additional sources of information or contractual services needed to complete the project.

Discussion of methodology and approach for exposure and sensitivity analyses.

If applicable, alternate programming languages Contractor desires to use which are compatible with ArcGIS Pro software.

Overview of the Project Management Team roles and responsibilities.

Deliverables: The Contractor shall submit:

1.1: A final technical proposal.

Due Date: within fourteen (14) calendar days from execution of the task assignment.

Summary of Fees: $21,221.04

TASK 1: Technical Proposal

Labor Hourly

Rate Hours Burdened

Cost Task Totals Principal $200.94 56.0 11,252.64 Project Manager $145.53 40.0 5,821.20 Staff Professional $86.40 48.0 4,147.20

Total Labor Hours 144.0 Total Labor Cost $21,221.04

Total Task 1 $21,221.04

Task 2: Project Management and Meetings

Description: The Contractor will conduct a virtual kickoff meeting within seven (7) working days from the execution of the task assignment. The kickoff meeting shall provide an overview of project and scope.

The Contractor shall provide a meeting agenda within one (1) business day ahead of the kickoff meeting.

For the duration of the project, the Contractor shall conduct bi-weekly (every two weeks) virtual or in person meetings to inform the Department of ongoing progress and potential blockers. As the project progresses, the Department may elect to receive a monthly progress report in lieu of bi-weekly meetings.

The Department shall notify Contractor via email if monthly progress reports shall begin replacement of bi-weekly meetings.

Deliverables: The Contractor shall submit:

2.1: Kickoff meeting agenda, list of attendees, and meeting minutes.

2.2: Bi-weekly meeting minutes within ten (10) days following the conclusion of the meeting(s).

If the Department has elected to receive monthly progress reports in lieu of bi-weekly meetings, Contractor shall submit monthly progress reports by the fifth (5th) day of the month.

Due Date: June 30, 2024

Summary of Fees: $27,933.27

Total Fixed Price Cost

Month 1 $ 3,491.66 Month 2 $ 3,491.66 Month 3 $ 3,491.66 Month 4 $ 3,491.66 Month 5 $ 3,491.66 Month 6 $ 3,491.66 Month 7 $ 3,491.66 Month 8 $ 3,491.66

Total $27,933.27

TASK 2: Project Management

Labor Hourly

Rate Hours Burdened

Cost Task Totals Principal $200.94 61.0 12,257.34 Project Manager $145.53 81.0 11,787.93 Staff Professional $86.40 45.0 3,888.00

Total Labor Hours 187.0 Total Labor Cost $27,933.27

Total Task 2 $ 27,933.27

Task 3: Data Collection for Statewide Flood Hazard Data

Description: The Contractor will outline and detail the data collection needed for this project. This will include coordination between the providers of catastrophic risk data and the Department. The Work Plan will also lay out a schedule that will provide a Statewide Vulnerability Assessment by July 1, 2024.

This task will include review of existing flood hazard data for advanced setup of vulnerability assessments. This task is imperative to keep the time-frame of the overall statewide vulnerability analysis on track. Existing data, while not final, will serve as a surrogate for final data and allow the Contractor to setup and test vulnerabilities and sensitivities. This data is known as the existing Fathom US 3.0 Standard dataset.

Deliverables: The Contractor shall submit:

3.1: A data licensing agreement for use and application of existing Fathom US 3.0 data.

3.2: A work plan that outlines what data will be used for the vulnerability assessment and a schedule.

Due Date: Deliverable 3.1 must submitted to the Department within 14 days of execution of this task assignment. Deliverable 3.2 will be submitted by January 31, 2024.

Summary of Fees: $ 317,648.80

TASK 3: Data Collection for Statewide Hazard Plan

Labor Hourly

Rate Hours Burdened

Cost Task Totals

Principal $200.94 32.0 6,430.08

Director $178.02 20.0 3,560.40

Project Manager $145.53 120.0 17,463.60

Project Professional $116.58 120.0 13,989.60

Staff Professional $86.40 160.0 13,824.00

Senior Technical Support $139.23 24.0 3,341.52

Technical Support $101.61 80.0 8,128.80

Technical Editor $113.85 8.0 910.80

Total Labor Hours 564.0

Total Labor Cost 67,648.80

Other Direct Costs Quantity Unit Cost Cost

Fathom - existing US 3.0 standard dataset 1.00 250,000.00

Total Other Direct Costs 250,000.00

Total Task 3 317,648.80

Task 4: Generate a Comprehensive Statewide Flood Hazard Dataset

Description: The Contractor will develop a statewide flood hazard dataset for coastal and inland flooding that encompasses existing and future conditions. The Contractor will provide a description of both data sets and what future conditions are included. Coastal conditions will follow other standard guidance, such as, but not limited to, application of sea level rise scenarios defined by NOAA. The Contractor will work with the Department and the Florida Flood Hub to develop standard riverine future conditions.

This task is developing a state-of-the-art flood risk dataset for inland counties. The Contractor will provide a review of the data and comparisons to existing data such as FEMA 1% annual chance events (100-yr) and other data, as available (such as county or Water Management provided data).

This task includes the creation of coastal and riverine flood hazard datasets. The Contractor will engage industry partners or subcontractors as needed to ensure the objectives of the project can be met. This may require additional licensure or collection of data.

Development of the coastal and riverine hazard map of Florida will include:

Pluvial, fluvial, and coastal flooding layers tailored to the specific requirements of Florida;

Up to 8 different return periods;

10m resolution;

The current climate state and four (4) future climate scenarios or application of climate change factors as defined by the Department.

The data created for this task is considered the best data available for a statewide vulnerability assessment and the Contractor will proceed with the data as quickly as possible understanding that future tasks will include more in-depth discussions with stakeholders on the data sets, comparisons to other data sets, and quality comparisons.

Deliverables: The Contractor shall submit:

4.1: Fathom Initial Enablement & Setup Technical Memorandum

4.2: Flood hazard data for coastal, pluvial, and fluvial existing and future conditions.

4.3: GIS mapping coverages of the data sets.

4.4: Summary report of the flood hazard data and methodology support and documentation.

Due Date: June 30, 2024

Summary of Fees: $850,232.44

Task Fee Schedule – Days from NTP or Calendar Date Task 4.1 Initial Enablement & Setup

$400,000.00 14 days

December Technical Update $25,038.74 12/15/2023

January Technical Update $25,038.74 1/31/2024

February Technical Update $25,038.74 2/29/2024

Task 4.2 Flood Hazard Data $300,000.00 2/29/2024

Task 4.3 GIS Mapping Data $25,038.74 3/30/2024

Task 4.4 Summary Report and Methodology and Support Documentation

$50,077.48 5/30/2024

Total Fee: $850,232.44

TASK 4: Statewide Flood Hazard Data

Labor Hourly

Rate Hours Burdened

Cost Task Totals Principal $200.94 36.0 7,233.84 Director $178.02 40.0 7,120.80 Senior Professional $162.21 40.0 6,488.40 Project Manager $145.53 212.0 30,852.36 Project Professional $116.58 240.0 27,979.20 Staff Professional $86.40 320.0 27,648.00 Senior Technical Support $139.23 48.0 6,683.04 Technical Support $101.61 240.0 24,386.40 Technical Editor $113.85 104.0 11,840.40

Total Labor Hours 1280.0

Total Labor Cost $150,232.44

Other Direct Costs Quantity Unit Cost Cost

4.1 Fathom - Initial enablement & Setup 1.00 $400,000.00

4.2 Fathom - delivery of Flood Hazard Data, Annual License, Tech Support 1.00 $300,000.00

Total Other Direct Costs $700,000.00

Total Task 4 $850,232.44

Task 5: Conduct Exposure and Sensitivity Analyses and Phase I Vulnerability Assessment

Description: The Contractor will perform an exposure analysis to identify the depth of water caused by each sea level rise, storm surge, and/or flood scenario. The Contractor will provide a sensitivity analysis focused on critical assets, including regionally significant assets, that are essential for critical government and business functions, national security, public health and safety, the economy, flood and storm protection, water quality management, and wildlife habitat management. This study will examine the flooding depth at critical infrastructures and present indices that characterize how sensitive the structure is to the flooding it could experience.

The nature of a statewide assessment allows for aggregated results, giving the Department a snapshot of big-picture vulnerabilities. For this study, the Contractor will present results by county. The Contractor will summarize each of the sixty-seven (67) counties with data tables and graphics. This Phase I statewide vulnerability assessment will give the Department a gap analysis. This gap analysis will allow the Department to target future efforts either by region or data type to add depth to the data analysis.

Deliverables: The Contractor shall submit:

5.1: A statewide exposure and sensitivity analyses with summary of statewide statistics and summaries for each of the sixty-seven (67) counties in Florida.

5.2: Phase I Vulnerability Assessment report.

Due Date: June 30, 2024

Payment Request Schedule: The Contractor will invoice on a monthly basis utilizing percentage complete for the fixed fee amount listed in the Summary of Fees for the task. The percentage increments for invoicing shall be in no less than ten percent (10%) increments. Contractor shall submit the monthly invoices within thirty (30) days after the month of service.

Summary of Fees: $343,584.66

TASK 5: Exposure Analysis, Sensitivity Analysis & Draft VA

Labor Hourly Rate Hours Burdened Cost Task Totals Principal $200.94 60.0 12,056.40 Director $178.02 92.0 16,377.84 Project Manager $145.53 392.0 57,047.76 Project Professional $116.58 220.0 25,647.60 Staff Professional $86.40 628.0 54,259.20 Senior Technical Support $139.23 260.0 36,199.80 Technical Support $101.61 956.0 97,139.16 Technical Editor $113.85 394.0 44,856.90

Total Labor Hours 3002.0 Total Labor Cost $343,584.66

Total Task 5 $ 343,584.66

Task 6: Web Tool Support & Data Presentation

Description: The large-scale nature of this project lends itself to presentation by interactive website as opposed to only a static report. Some advantages of using a story map or interactive website are interactive content, spatial context, narrative structure, real-time updates and integration of future studies, engagement, customization, broad audience appeal, data integration and links to other data sources, feedback, and interaction.

This task will include generation of maps and data tables/summaries. It also includes coordination with the Department’s contract for the web development which is separate from this project but will ensure proper coordination is in place for desired results.

Deliverables: The Contractor shall submit:

6.1: Meeting minutes within ten (10) days following the conclusion of the coordination meeting(s).

6.2: Phase I data presentations in the form of maps and summary tables (Maps, Data Tables and Summaries, Draft Presentations to Stakeholders).

6.3 Phase II data presentation in the form of maps and summary tables (Maps, Data Tables and Summaries, Presentations to Stakeholders, Final Maps).

Performance Period: October 23, 2023, to July 31, 2024 Due Date: Task 6.2 Phase I deliverables must be submitted by June 30, 2024. Task 6.3 Phase II deliverables must be submitted by July 31,2024.

Summary of Fees: $97,931.76

Task Unit Fee Total Fee Deliverable Due Date

Task 6.1 Coordination Meetings #1

- #5

$2,710.03/meeting $13,550.16

(assume 5 meetings total)

Ten (10) days following the meeting

Task 6.2 Technical Update #1 $42,190.80 5/30/2024

Task 6.2 Phase I Technical Update $21,095.40 6/30/2024

Task 6.3 Phase II Technical Update $21,095.40 7/31/2024

Total Fee: $97,931.76

TASK 6: Web Tool Support and Data Presentation

Labor Hourly Rate Hours Burdened Cost Task Totals Principal $200.94 56.0 11,252.64 Project Manager $145.53 96.0 13,970.88 Project Professional $116.58 136.0 15,854.88 Staff Professional $86.40 224.0 19,353.60 Technical Support $101.61 136.0 13,818.96 Technical Editor $113.85 208.0 23,680.80

Total Labor Hours 856.0 Total Labor Cost 97,931.76

Total Task 6 $97,931.76

Task 7: Project Close out and Final Deliverables

Description: The Contractor will provide a statewide vulnerability assessment that includes coastal storm surge and sea level rise, inland flooding determined by rainfall runoff (pluvial and fluvial) modeling for existing and future conditions. The Contractor shall adhere to DEP Branding Guidelines when preparing the final report or provide a version of the report devoid of any branding for DEP Communications and Marketing. Branding guidelines will be provided upon request. All code files generated from developed of the analysis, with proper code guide comments. Python files shall be in .py format. Jupyter Notebooks files shall be in .ipynb format. Toolbox in .tbx format with the script tool and defined parameters to allow the execution of the assessment. All supplemental datasets compiled to perform the assessment, with the associated metadata.

Deliverables: The Contractor shall submit:

7.1: Phase II Vulnerability Assessment report, and as applicable, any of the following:

o code files o final GIS toolbox, o supplemental datasets, o summary document with simple table of all data provided.

The Phase II Vulnerability Assessment report must incorporate or address all comments and edits provided by the Department in deliverable 5.2. The Department will have from June 30, 2024, until July 10, 2024 to make comments and deliver them via email to the Contractor.

Due Date: July 31, 2024

Summary of Fees: $22,229.52

TASK 7: Project Closeout and Final Deliverables

Labor Hourly

Rate Hours Burdened Cost Task Totals Principal $200.94 20.0 4,018.80 Project Manager $145.53 48.0 6,985.44 Staff Professional $86.40 120.0 10,368.00 Administrative $53.58 16.0 857.28

Total Labor Hours 204.0 Total Labor Cost $22,229.52

Total Task 7 $22,229.52

PERFORMANCE MEASURES

Delivery Method: All deliverables submitted to the Department will be delivered in digital format through email or the Department’s secure FTP if the deliverable size exceeds email limitations. All reports and documents shall be submitted in standard Microsoft Office format and .PDF format. Delivery of data to the Flood Hub shall be in accordance with the Flood Hub’s requirements.

Inspection and Acceptance: The Department will review and approve each deliverable for completeness and functionality and provide any necessary comments, if applicable, to the Contractor within ten (10) working days of the delivery. Department requested corrections shall be resolved and resubmitted by the Contractor within ten (10) working days from notification.

Payment Request Schedule: Unless indicated otherwise within the task information, the Contractor will invoice within thirty (30) days following acceptance of the deliverables from the Department’s Contract Manager and utilizing the fixed-fee rate listed within the task’s invoice schedule.

Consequence for Non-Performance: The Department will reduce the monthly invoice amount by five percent (5%) for each calendar day that deliverable(s) are not received. Should a Change Order or Amendment be requested on the date of or after the most current due date, the five percent (5%) reduction will be imposed until the date of the requested change is received via email by the Department.