Agenda 06/22/2021 Item #16A27 (ACUNE GeoTool Expenditure)06/22/2021
EXECUTIVE SUMMARY
Recommendation to authorize an expenditure to allow the University of Florida to update and
provide maintenance for the Adaptation of Coastal Urban and Natural Ecosystems (“ACUNE”)
GeoTool as an exemption to the competitive procurement process.
_____________________________________________________________________________________
OBJECTIVE: To complete requested updates and provide maintenance for the ACUNE GeoTool.
CONSIDERATION: The University of Florida, with funding from NOAA, has developed the ACUNE
GeoTool for Collier County and municipalities within the county to develop adaptation strategies for its
infrastructure. The ACUNE GeoTool contains the following products: (1) probabilistic coastal flood
maps for the current climate, 2030, 2060, and 2100, including the effects of sea level rise and storms
predicted by climate models (these maps are in GIS format to enable ease of use by Collier County and
the municipalities); (2) numerous asset layers for infrastructures with the County (e.g., wetlands,
buildings, bridges, roadways, highways, stormwater systems, cultural sites, archeological sites, etc.); (3)
nuisance tide flood maps, which include the highest twice-a-year tides and sea level rise); (4) bathtub
flood maps by applying sea level rise values over the entire County assuming the coastal flood plain is a
bathtub; and (5) potential residential structural damage for the current climate and future climate
scenarios.
To ensure ease of use by Collier County and the municipalities for adaptation planning, several training
workshops and vulnerability training workshops have been conducted throughout the County. As a result
of the workshops, the County received numerous comments on ways to improve the ACUNE GeoTool.
Since these requested improvements are not within the scope of the NOAA projects, funding in the
amount of $49,897 will be required for the University of Florida to produce an improved version of the
ACUNE GeoTool and provide necessary maintenance and upgrades of the tool throughout the year.
Section 8, subparagraph 1 of Collier County Procurement Ordinance 2013-69, as amended, provides that
purchases from another government agency or from a nonprofit organization authorized to do business in
the State of Florida are eligible for exemption from the competitive process upon the determination that
approval of the exemption is in the best interest of the County. The approved exemption form is attached.
Staff requests that the Board approve this expenditure to allow the Universi ty of Florida to update and
provide maintenance for the ACUNE GeoTool as an exemption under the Procurement Ordinance.
FISCAL IMPACT: The total cost will be $49,897 and funding is available Stormwater Capital Fund
(325), Project 51144.
LEGAL CONSIDERATIONS: This item is approved as to form and legality and requires majority
vote for Board approval. -SRT
GROWTH MANAGEMENT IMPACT: There is no growth management impact associated with this
Executive Summary.
RECOMMENDATION: To authorize expenditures in the amount of $49,897, as an exemption to the
competitive procurement process, to retain the University of Florida to update and provide maintenance
for the ACUNE GeoTool.
Prepared By: Trinity Scott, Deputy Department Head, Growth Management.
16.A.27
Packet Pg. 1242
06/22/2021
ATTACHMENT(S)
1. FY21 Exemption Request 069 - UF_ACUNE GeoTool (PDF)
2. UFQuoteforACUNECollierPurchaseOrder (DOCX)
16.A.27
Packet Pg. 1243
06/22/2021
COLLIER COUNTY
Board of County Commissioners
Item Number: 16.A.27
Doc ID: 16282
Item Summary: Recommendation to authorize an expenditure to allow the University of Florida
to update and provide maintenance for the Adaptation of Coastal Urban and Natural Ecosystems
(“ACUNE”) GeoTool as an exemption to the competitive procurement process.
Meeting Date: 06/22/2021
Prepared by:
Title: – Capital Project Planning, Impact Fees, and Program Management
Name: Amanda Barnwell
06/15/2021 11:56 AM
Submitted by:
Title: Division Director - IF, CPP & PM – County Manager's Office
Name: Amy Patterson
06/15/2021 11:56 AM
Approved By:
Review:
Growth Management Department Amanda Barnwell Growth Management Department Skipped 06/15/2021 11:53 AM
Growth Management Operations Support Christopher Johnson Additional Reviewer Completed 06/15/2021 12:20 PM
Procurement Services Caroline Blevins Additional Reviewer Completed 06/15/2021 12:48 PM
Growth Management Department Trinity Scott Transportation Completed 06/15/2021 1:37 PM
Procurement Services Catherine Bigelow Additional Reviewer Completed 06/16/2021 7:21 AM
Procurement Services Sandra Herrera Additional Reviewer Completed 06/16/2021 8:31 AM
County Attorney's Office Scott Teach Level 2 Attorney Review Completed 06/16/2021 8:41 AM
Office of Management and Budget Debra Windsor Level 3 OMB Gatekeeper Review Completed 06/16/2021 8:43 AM
Office of Management and Budget Susan Usher Additional Reviewer Completed 06/16/2021 11:08 AM
County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 06/16/2021 11:23 AM
County Manager's Office Amy Patterson Level 4 County Manager Review Completed 06/16/2021 12:18 PM
Board of County Commissioners Geoffrey Willig Meeting Pending 06/22/2021 9:00 AM
16.A.27
Packet Pg. 1244
Instructions
The following procurement categories may be eligible for exemption from the competitive process based upon the determination
of the County manager or Designee that approval of such an exemption is in the best interest of the County.
Purchases greater than $50,000 will require final approval by the Board of County Commissioners.
Requester Name:Vendor Name:
Division:Item / Service:
Budget Year:1RWWR([FHHG
per Fiscal Year:
One time purchase:Multiple purchases:Requested
date range:_________________
Is there an agreement
associated with this
Exemption?
Yes No
1. Government Agency/Non-
Profit
2. Registrations/dues/
training
3. Subscriptions/periodicals/
printed materials
4. Advertisements
5. Utility services –subject
to government control
6. Education/academic
programs/trainers, speakers
7. Legal services 8. Purchases required by
grants/gifts
9.Compatibility/proprietary
with current systems
10. Shop estimates on
disassembled equipment
11. Personnel/recruitment
services
2. Works of art for public
display
13. Direct purchases 14. Financial instruments 15. Entertainment services
for County sponsored events
16. Management studies as
directed by County Manager
17. Resolution/BCC direction (Indicate resolution number and approval date):
Description of Purchase:Enter a description of the item(s) items that will be purchased under this exemption.
Purpose:Describe in detail, the purpose of the requested item(s).
Requester:Signature: Date:
Division Director: Signature: Date:
Procurement Strategist: Signature: Date:
Procurement Director:
2UGHVLJQHH
Signature: Date:
For Procurement Use Only:
One time approval One year approval Multi-Year Approval: Start ____________ End ____________
Exemptions from the Competitive Process
Amy Patterson University of Florida
Capital Project Planning, Impact Fees and Program Management ACUNE Geo Tool Maintenance
FY21 $50,000
FY21-FY22
ACUNE GeoTool maintenance and upgrades. (ACUNE GeoTool was developed by UF and NOAA for use by the County updates requested are to their software) The
ACUNE GeoTool contains the following products: 1) probabilistic coastal flood maps for current climate (CC), 2030, 2060, and 2100, including the effects of sea level
rise (based on the NOAA estimated SLR values with 13, 50, and 87 percentiles) and storms predicted by climate models; these maps are in GIS format to enable ease
of use by Collier County and cities; 2) numerous asset layers for infrastructures with the County, e.g., wetlands, buildings, bridges, roadways, highways, stormwater
systems, cultural sites, archeological sites, etc.; 3) nuisance tide flood maps which include the highest twice-a-year tides and sea level rise; 4) bathtub flood maps by
applying SLR values over the entire County assuming the coastal flood plain is a bathtub; 5) potential residential structural damage for CC and future climate scenarios
To ensure ease of use of the ACUNE GeoTool by Collier County for adaptation planning, several
training workshops and vulnerability training workshops have been conducted throughout the
County. As a result of the workshops, numerous opportunities for improvements for the ACUNE
GeoTool have been identified. Since these requested improvements are not within the scope of
the NOAA projects, funding will be required for the University of Florida to produce an improved
version of the ACUNE GeoTool for Collier County and provide necessary maintenance and
upgrade of the Tool throughout the year.
Amy Patterson
Trinity Scott - Deputy Department Head
Sara Schneeberger
Catherine Bigelow
Patterson_a Digitally signed by Patterson_a
Date: 2021.05.21 13:31:20
-04'00'
ScottTrinity Digitally signed by ScottTrinity
Date: 2021.05.24 15:39:21
-04'00'
SchneebergerSara Digitally signed by
SchneebergerSara
Date: 2021.06.14 10:35:12 -04'00'
BigelowCatherine Digitally signed by
BigelowCatherine
Date: 2021.06.14 11:11:06 -04'00'
16.A.27.a
Packet Pg. 1245 Attachment: FY21 Exemption Request 069 - UF_ACUNE GeoTool (16282 : UF Adaptation of Coastal Urban and Natural Ecosystems (“ACUNE”))
ACUNE Geo Tool Maintenance Quote
Introduction
The University of Florida, with fund from NOAA, has developed an ACUNE GeoTool for Collier County and cities
within the county to develop adaptation strategy for its infrastructures. The ACUNE GeoTool contains the
following products: 1) probabilistic coastal flood maps for current climate (CC), 2030, 2060, and 2100, including
the effects of sea level rise (based on the NOAA estimated SLR values with 13, 50, and 87 percentiles) and storms
predicted by climate models; these maps are in GIS format to enable ease of use by Collier County and cities; 2)
numerous asset layers for infrastructures with the County, e.g., wetlands, buildings, bridges, roadways, highways,
stormwater systems, cultural sites, archeological sites, etc.; 3) nuisance tide flood maps which include the highest
twice-a-year tides and sea level rise; 4) bathtub flood maps by applying SLR values over the entire County assuming
the coastal flood plain is a bathtub; 5) potential residential structural damage for CC and future climate scenarios.
To ensure ease of use by Collier County and cities for adaptation planning, several training workshops and
vulnerability training workshops have been conducted throughout the County. As a result of the workshops, we
have received numerous comments on ways to improve the ACUNE GeoTool. Since these requested
improvements are not within the scope of the NOAA projects, Collier County has decided to fund the University
of Florida to produce an improved version of the ACUNE GeoTool and provide necessary maintenance and upgrade
of the Tool throughout the year.
University of Florida will invoice Collier County every quarter according to progress of various tasks listed below.
Task 1. Address ALL comments on the ACUNE tool so far (7/1/21-9/30/21)
Description: We will address the comments (about 100 in total) about the tool. Some will be addressed through
app improvements, others by adding extra metadata, interface improvements, etc.
Deliverable: Updated ACUNE Tool.
Cost: $2995.85
Task 2. Develop a comprehensive user’s manual with help materials (7/1/21-10/31/21)
Description: We will develop a comprehensive user’s manual to guide a user through the ACUNE tool and provide
additional information about products, how products were produced, how products can be used and what are the
potential limitations.
Deliverable: ACUNE user’s manual published on the ACUNE website.
Cost: $3365.00
Task 3. Produce a list of FAQs with Answers (8/1/21-9/30/21)
Description: Based on the comments and additional feedback and questions we will produce a list of frequently
asked questions with answers.
Deliverable: ACUNE FAQs and Answers published on the ACUNE website.
Cost: $2242.61
Task 4. Implement a newer version and add new asset layers (7/1/21-6/30/22)
16.A.27.b
Packet Pg. 1246 Attachment: UFQuoteforACUNECollierPurchaseOrder (16282 : UF Adaptation of Coastal Urban and Natural Ecosystems (“ACUNE”))
Description: Keep updating the ACUNE tool based on the feedback that we have received thus far and will receive
throughout this project.
Deliverable: ACUNE Tool.
Cost: $9356.69
Task 5. Training different groups of Collier, Naples, Marco (7/1/21-6/30/22)
Description: produce training materials, perform training of various groups.
Deliverable: training, training materials.
Cost: $4502.33
Task 6. Answer questions via email (7/1/21-6/30/22)
Description: Answer any questions related to the ACUNE tool via email.
Deliverable: Answers to questions.
Cost: $1938.40
Task 7. Add ACUNE+ products when available (7/1/21-6/30/22)
Description: Add all the products to be created as part of the ACUNE+ project.
Deliverable: Additional/replacement inundation and economic layers in the ACUNE tool.
Cost: $2574.89
Task 8. Improve authentication system and provide password protection on asset layers (7/1/21-9/30/21)
Description: add authentication layer to the ACUNE tool allowing for customization of layers per user or user group.
This will allow not only protecting some of the sensitive layers but creating different experiences for different
groups of users.
Deliverable: Updated ACUNE tool.
Cost: $1712.60
Task 9. Keep the system running all the time (server maintenance) (7/1/21-6/30/22)
Description: Perform necessary server maintenance (OS upgrades, ArcGIS server maintenance and upgrades,
security patches). Add additional asset layers provide by the stakeholders.
Deliverable: A working ACUNE tool.
Cost: $3992.70
Task 10. Produce maps for 2040 and 2070 per requirement by State of Florida (7/1/21-6/30/22)
Description: Per State of Florida announcement, future flood maps should be developed for 2040 and 2070,
instead of the 2030 and 2060 within the current ACUNE and ACUNE+ projects. This task will use the NOAA SLR
values for 2040 and 2070 at Naples, along with future storms for 2040 and 2070, to produce revised probabilistic
flood maps for Collier County.
Deliverable: Flood maps for 2040 and 2070.
16.A.27.b
Packet Pg. 1247 Attachment: UFQuoteforACUNECollierPurchaseOrder (16282 : UF Adaptation of Coastal Urban and Natural Ecosystems (“ACUNE”))
Cost: $14961.20
Task 11. Purchase ESRI premium services credits. These are used whenever someone accesses ESRI resources,
for example the background maps that we have are provided by ESRI services, so every time someone accesses a
map with a background or performs an address search, etc. - we use up credits. (https://www.esri.com/en-
us/arcgis/products/credits/overview).
Cost: $2256.63 (one time purchase in 2021).
Task Task Description Duration Cost
1 Address ALL comments on the ACUNE tool so far 7/1/21-9/30/21 $2995.85
2 Develop a comprehensive user’s manual with help materials 7/1/21-10/31/21 $3.365.00
3 Produce a list of FAQs with Answers 8/1/21-9/30/21 $2,242.61
4 Implement a newer version of ACUNE Tool 7/1/21-6/30/22 $9,356.69
5 Training different groups of Collier, Naples, Marco 7/1/21-6/30/22 $4,502.33
6 Answer questions via email 7/1/21-6/30/22 $1,938.40
7 Add ACUNE+ products when available 7/1/21-6/30/22 $2,574.89
8 Improve authentication system and provide password protection 7/1/21-9/30/21 $1,712.60
9 Keep the system running all the time (server maintenance) 7/1/21-6/30/22 $3,992.70
10
Produce maps for 2040 and 2070 per requirement by State of
Florida
7/1/21-6/30/22 $14,961.20
11 Purchase ESRI premium services credits - $2256.63
Total as whole
dollar amount $49,897
16.A.27.b
Packet Pg. 1248 Attachment: UFQuoteforACUNECollierPurchaseOrder (16282 : UF Adaptation of Coastal Urban and Natural Ecosystems (“ACUNE”))