CN-370000-BS029-T3CO12.pdf

Department of Environmental Protection ROSS/OSSI Project Scope of Work

November 12, 2014

Introduction: In an effort to better understand the geologic evolution of the coastal regions of Florida that would aid in the search for offshore sources of beach compatible sand, a geologic conceptual model and report was created for each region. These reports and GIS products included a geologic background, identification of paleo-features and/or physiographic units in the region, and an identification and classification (where possible) of potential sand resources.

Each phase of the Reconnaissance Offshore Sand Search (ROSS) project included an original field data collection effort to fill in gaps in data coverage on a reconnaissance level and to corroborate the geologic model created for each region. As a result of ROSS, the Florida Department of Environmental Protection (Department) Bureau of Beaches and Coastal Systems (BBCS) has identified regions of the State where geotechnical data does not exist on a reconnaissance level. As such, regional data collection will continue to be a part of maintaining and ‘upgrading’ the ROSS database.

Maintaining the ROSS project includes the incorporation of new data. As part of the sand search and permitting portions of beach nourishment projects, geotechnical data is required to be submitted to the Department. This also aids with completing the Offshore Sand Source Inventory (OSSI) database.

Under previous contracts with the Department, the ROSS/OSSI database and website has been created, hosted, upgraded, and updated over the past years by URS Corporation (URS). In January 2001, the Department developed a geologic model and report of sand sources offshore of the Florida Panhandle known as SandPan. Existing geologic and geophysical data that represented the beach, nearshore, and offshore regions of the Panhandle were collected in order to understand the geologic evolution of the Florida Panhandle. Following the review of existing data, new data were collected in areas where little or no data existed. This information was included in a searchable database and the maps of that data served up on the web. Following the completion of SandPan, the Department continued this effort with the development of the database and online components of the ROSS database with the southwest region of the State, and eventually the east coast of Florida. The initial creation and population of a state wide ROSS database was completed in December 2007.

The OSSI project was created in 2007 when the Legislature created Chapter 161.144, F.S., to require the Department to develop and maintain a comprehensive inventory of identified offshore sand sources. The requirement included the creation of a report that provides information on the location and classification of sand sources as potential, proposed, or permitted borrow areas. A preliminary inventory report was created and posted to the ROSS website for public review in 2008.

After the creation of the preliminary report, work for the OSSI project focused on creating a comprehensive inventory. In 2009, the structure for the comprehensive OSSI database was created and partially populated with existing ROSS data. The work done to date on OSSI has been completed under Contract BS016, Task 19, which has since expired. The comprehensive OSSI will include information for each borrow area regarding sediment quality, volume estimates, and its borrow area designation (such as potential, proposed, permitted, etc.). The OSSI database structure was created as part of the ROSS database such that data can be shared and entered only once for both databases and the OSSI data can be served up on the existing

November 12, 2014

ROSS website and MapViewer. As part of the sand search and permitting process, geologic data on the borrow areas would be provided to the Department for inclusion in the ROSS/OSSI database. As such, the OSSI database and report would serve as a tool for researchers interested in understanding the amount and type of data available on a potential, proposed, or permitted borrow area throughout the State and Federal waters off of Florida. It would be a tool to aid in the planning of future sand search investigations.

Following the completion of the previous OSSI tasks, the goal of the current task assignment is to populate the database with sediment quality and quantity data from past projects. Once the initial “historic/existing” data gathering is complete, the database will be populated mainly by receiving information from sand searches and permit applications. In addition to basic data gathering and reporting, the designation of the borrow areas will be updated at each stage of the sand search investigation and permitting process as the quantity and quality of the data changes.

The sediment quality and volumetric estimates of the remaining material in the borrow area(s) will be updated so that future investigators will have data on the volume of material that remains in a given area and the basic sediment quality of the material.

Of the work described below, Task 1E will be completed by COASTAL TECH; all other work will be completed by URS via subcontract with COASTAL TECH. Additional URS personnel included in this scope, but not listed on the existing rate sheet, are Eric Songer (Tasks 2E, 2F, Task 3 and Task 4) and Diane Ripandelli (Tasks 2F and Task 4). Eric Songer is included for his expertise in database creation and documentation and Diane Ripandelli is included for her expertise as a technical writer.

Task 1: Geologic Information Management

Task 1A: Processing of geologic data from nourishment projects FDEP requires consultants to submit geotechnical information suitable for inclusion in the database as part of the individual beach nourishment project. Once consultants submit data to FDEP, the geotechnical data will be forwarded to COASTAL TECH for QA review and inclusion into the database.

COASTAL TECH will conduct a Quality Assurance/Quality Control (QA/QC) process on each dataset that is entered into ROSS. This will include automated as well as manual procedures. Automated procedures are those designed into the purpose-built Access Front End and the Data Loader used to format gINT output data for inclusion into ROSS. As data is input by users, built-in constraints will prohibit users from entering data in an incorrect or incompatible format. A technically qualified reviewer will detect data that may be consistent with the automated procedures, but not correct from a geotechnical standpoint.

COASTAL TECH will employ a technically-qualified reviewer that has experience in reviewing the types of geotechnical data that is included in ROSS/OSSI. Knowledge of the coastal geology of Florida is also needed. For example, for sediment grain size analysis, sieve sizes are to be determined at the project level, thereby setting a template that allows only those pre-chosen sizes to be able to accept data. Other constraints include data integrity related to format and type. An understanding of geotechnical data by the reviewer is needed

November 12, 2014 to understand some of the issues that may arise when the data is entered into the OSSI comprehensive database. For example, understanding that there is more than one unit to express grain size can help avoid problems with data entry and identify issues that may arise from the use of one unit rather than another unit.

Manual procedures include reviewing data to look for completeness and spatial accuracy. To address completeness, data will be cross-checked. This includes, but is not limited to, a review of internal consistency of the datasets. As an example, to be sure the dataset is complete; the reviewer will check that the number of cores on a site plan matches the number of core logs submitted. After reviewing the core logs and determining the number of samples, the technical reviewer can check to see that the number of sieve data sheets and granularmetric plots submitted are correct. The technical reviewer will also check whether the plots provided are representative of the data provided. The COASTAL TECH reviewer shall have an understanding of the meaning of each of these geotechnical components that are vital to the ability to QA/QC the data. Checking location data (such as latitude and longitude) and elevation information is especially important. The technical ability to recognize issues with vertical and horizontal datums and convert between them is needed to determine if the location information is acceptable and correct minor issues with that data.

URS will provide a memorandum of its QA/QC review that identifies problems and omissions in the dataset, and recommend corrections as appropriate. The memorandum will be in the form of an email sent to BBCS within two weeks of receipt the data by COASTAL TECH. This timeline is needed so that any information request can be handled in a timely manner by the project engineer/geologist and be handled under the BBCS project review timeline.

After the data have gone through a technical review and BBCS is informed that no further information is needed, COASTAL TECH will process the information such that it can be loaded into the database and hyperlinked accordingly on the website and to the MapViewer.

Reformatting of some data may be needed and will vary based on the format of the information delivered to BBCS for inclusion. Typically the pdf files that are included in reports will have to be split and renamed in order to be hyperlinked correctly. Each core log, core photo set, and individual sample sieve data sheets and grain size curves will be a separate pdf so that it can be hyperlinked. The data provided in the gINT format will be processed using the data converter to export database compatible files to be uploaded. Data provided in the Access Front End Loader will be uploaded directly. Once the data is prepared, the appropriate layers in the ArcIMS will be updated to include the new information. The FTP site will also be updated if the information from the project, such as the sub-bottom seismic data, is to be made available there.

Once the upload is complete and the ArcIMS is updated, COASTAL TECH will inform BBCS by email that the information is available on the website for BBCS staff to review. A description of the work done and a statement of completion of the task for a particular project shall be included in the monthly status report.

November 12, 2014

Because BBCS can not accurately determine the number or content of the datasets that will be processed, two different costs estimates are presented. For budgeting purposes it has been decided to estimate costs based on eight nourishment projects of between 16 and 30 cores each, and 16 nourishment projects of between one and 15 cores each. Both estimates include processing the associated trackline and timestamp spatial data sets, and associated pdf files. The total for this task is $24,639.05. Billing for this subtask will be based on a three month cycle for a total of six cycles for the term of this Work Authorization.

COASTAL TECH will enter data until the budget amount for this task has been expended. If during the course of this project, it is determined that more datasets become available to BBCS and need to be entered into the ROSS/OSSI System, a contract modification with COASTAL TECH will be required and may be approved by the Department.

Once the modifications to the OSSI database (performed under Task 2A, of this SOW) are complete such that the database can be populated with composite geotechnical and volumetric data, updates to that data and reclassification of borrow areas (as needed) will be performed under this subtask. Updates will include adding composite and volumetric data to the new fields in the appropriate relational tables in ROSS. Reclassification will consist of renaming existing borrow areas to match the new classification names designated by the BBCS. The deliverable for this will be a listing of data sets that new data were added to, and borrow area files that were changed. Cost for this will be $5,473.93.

Task 1B: Management of data/layers not associated with nourishment projects There are currently several GIS layers located on the ROSS website that augments information available from the ROSS map viewer. The sources of these layers are the My Florida FDEP webpage http://www.dep.state.fl.us/gis/datadir.htm and the Florida Geographic Data Library (FGDL) webpage http://www.fgdl.org/download/index.html. Periodically these organizations update these files. COASTAL TECH will search the FDEP and FGDL GIS download websites for current updates to existing GIS layers incorporated in the ROSS system. This will be based on review and update sessions every four months. For budgeting purposes it is estimated that this task will take four hours to download new or updated information per review and update for a total of 16 hours over the 18-month period. An additional ten hours per review and update will be included to modify (i.e. clip to study area and rewrite metadata) and place for viewing and download, for applicable datasets, on the ROSS website per cycle for a total of 40 hours. Based on the above assumptions the total estimated time for this task is 56 hours. Total cost is $3,034.46

Task 1C: Website operation COASTAL TECH will host and perform maintenance to the ROSS/OSSI web site for the 18 month period-of-performance. This will include, but not be limited to, daily back-ups to the system, day-to-day monitoring and periodic maintenance normal to such site operation.

There will also be time allocated for emergency maintenance of the hardware and software utilized by ROSS/OSSI. For budgeting purposes, one hour per week for maintenance (80 hours) and one half hour per week (40 hours) for emergency maintenance for a total of 120 hours over the expected period of performance will be used. Total cost for maintenance will be $7,939.41.

November 12, 2014

Task 1D: Project Management/ Status Reports Day to day coordination of activities of Contractor’s staff needed for the continuation of the project will be carried out under this sub-task. This includes tracking budgets and preparing status reports.

COASTAL TECH will provide monthly status reports to accompany the monthly invoice to the Department for all tasks in this work authorization. Status reports will include, when applicable, a listing of projects entered to date, those entered during the month in question, and those waiting to be entered. The Department will be notified by email when projects have been added. This work will be delivered to the Department in the form of posting the data on the website. The cost for this subtask is $14,372.89.

Task 1E: Geotechnical Services This task provides for laboratory analysis of coastal sediment associated with proposed beach nourishment activities. Consultants routinely submit data, often including sediment samples, to FDEP as part of the compliance and permitting processes. In some cases, laboratory analyses may help FDEP to better review the data and expedite the necessary reviews. In these cases, COASTAL TECH will be tasked to perform the analysis and provide data certified by a Professional Geologist. These analyses may include grain size analysis and determinations of carbonate content. In some cases, FDEP may need samples or other information to be collected by way of field work or office study. Should field work need to be performed, an investigation plan will the submitted to the Department for review and approval. The costs related to this task will be on a time and materials basis. The cost for this subtask is $5,000.00.

The total cost for Task 1 is $60,459.74.

Task 1 Deliverables:

Task 1A:

An email to BBCS listing datasets from nourishment projects that were processed and entered into ROSS.

An email listing of tables and borrow area files that were updated and entered into ROSS.

Task 1B:

An email to BBCS listing FGDL and FDEP layers checked for compatibility with those currently on ROSS, layers that were updated and new layers that were added.

Task 1C:

Backup and periodic maintenance of the ROSS website, and hosting fees. Information listing activities under this task will be included in the Monthly Status Report.

Task 1D:

Monthly status reports which will include the following items, if applicable

November 12, 2014 o Statement of new datasets from nourishment projects entered to date, those entered during the month in question, and those waiting to be entered o Statement of tables and borrow area files that were updated.

o Statement of FDEP and FGDL layers checked and updated, if needed, on a quarterly basis.

o Statement of monthly hosting and maintenance activities for the website o Status of all tasks in this document

Task 1E:

PDF file of gINT Draft Granularmetric Curves & Tables (Up to 20) Laboratory results of the carbonate content.

Letter of certification of laboratory results from a Professional Geologist or Professional

Engineer registered in the State of Florida.

Task 2: Completion of Updating ROSS/OSSI Website and Map Viewer

This task was initially begun under a previous task assignment in a contract that has now expired. This is a continuation of the work under Contract BS016, Task 5. The task was not completed before the contract expired due in part to the need for additional review and beta testing by Department staff. Our estimated costs are based on the basic borrow area data structure changes underway at the conclusion of the previous contract, and do not include time and budget for major changes to this data structure or development of new requirements.

These modifications will be applied to certain areas of the ROSS/OSSI database, website, and MapViewer to fulfill the goal of the legislative mandate (Chapter 161.144, F.S.), and incorporate the previous comments from Department staff. No additional functionality needs to be developed under this task.

Task 2A: The following work will be performed by COASTAL TECH under this task:

Modification to the structure of the Borrow Area layer and the documentation of this layer and it’s attributes, based on review comments from BBCS on the borrow area data dictionary. BBCS has decided to change the current three borrow area classifications to four and reassign the current borrow areas into these new classifications. BBCS will supply COASTAL TECH with information on what the new classifications will be, as well as how to reassign the current borrow areas. The tables that the borrow areas are based on will also be updated to include new data entry columns, two of which will be to store volumetric and composite information. The borrow area classifications, new column names and the information used to populate these new columns will be supplied by BBCS by the end of the sixth week from the execution of this Work Authorization. Failure to meet this schedule will result in the need for a contract amendment to adjust the delivery schedule of Tasks and subtasks related to this information. The cost for this Task is $2,444.52.

Task 2B: Modification to the symbology of layers in the new ArcGIS Server (AGS) Map Viewer. The cost for this Task is $2,444.52.

Task 2C: Addition of alias names to fields in the layers in the Map Viewer. Alias names will be derived from field names when clear and unambiguous (e.g.: AREA_NAME = “Area

November 12, 2014

Name”) or from existing metadata. Other desired alias names will be provided by BBCS after review of the fields included in layers that make up the Map Viewer. This information is found in the ROSS/OSSI Data Dictionary which will be supplied to BBCS upon execution of this Work Authorization. Currently, with the exception of the Borrow Area and Range Monument layers, the field names as provided in original datasets are included. The cost for this Task is $1,484.18.

Task 2D: Modification to the Map Viewer configuration file to select a subset of the fields to be displayed when using the “identify” and “search functions” of the Map Viewer.

Currently, the Map Viewer is configured to display all fields. The cost for this Task is $1,083.31.

Task 2E: Creation of a step-by-step outline, based on the Map Viewer user documentation, as a guideline for BBCS staff to use when beta testing. The cost for this Task is $7,409.96.

Task 2F: Update and completion of a user help document for the MapViewer and the various pages and functions of the ROSS/OSSI website. The cost for this Task is $15,619.02.

The total cost for Task 2 is $30,485.51

Task 2 Deliverables:

The completion of items listed under Tasks 2A, 2B, 2C, and 2D will be verified by BBCS personnel performing a check of the ROSS/OSSI website for the items. COASTAL TECH will send a statement of completion to BBCS with notification that the items have been completed.

The deliverable for Task 2E will be the documentation itself. The deliverable for Task 2F will be the User Help Document and verification by BBCS personnel that it has been posted to the ROSS/OSSI website.

Task 2A Statement of completion (email to BBCS) that modifications have been completed by

COASTAL TECH.

Task 2B Statement of completion (email to BBCS) that modifications to layer symbology have been completed.

Task 2C Statement of completion (email to BBCS) that field alias names modifications have been completed.

Task 2D Statement of completion (email to BBCS) that Map Viewer configuration file modifications have been completed.

November 12, 2014

Task 2E Step-by-step guideline for beta test of Map Viewer. Two hard copies and two CD’s containing this document will be delivered to BBCS.

Task 2F User Help Document for the Map Viewer and the various pages and functions of the

ROSS/OSSI website. Two hard copies and two CD’s containing this document will be delivered to BBCS.

Task 3: Technical Documentation for ROSS/OSSI

Existing URS ROSS/OSSI Technical Documentation will be reviewed and completed for delivery to BBCS and the Office of Technology and Information Services (OTIS). Technical Documentation covers the ROSS database, the ROSS Web Site, and the ROSS/OSSI ArcIMS Map Viewer. Updating the Technical Documentation for ROSS/OSSI began under a previous task assignment in a contract that has now expired. This is a continuation of the work under Contract BS016, Task 5.

Since the creation of the original SandPan database, an ad-hoc Change Management spreadsheet has been in the first stage of development and is being used in-house by URS. It is deemed useful to review, improve, and formalize this system. A process will be put in place where database and GIS changes will be recorded in the Change Management spreadsheet.

This includes time expended tracking changes to the datasets previously uploaded to the Oracle database, including additions to previously loaded datasets when new information or data concerning these studies is made available (i.e. previously undiscovered core logs or photos).

This process tracks project ID changes, project name changes and data additions. No database or web development will be needed for this subtask. Along with formal Technical Documentation and Change Management, a formal site map will be developed.

The end result is that this documentation will aid OTIS in the migration of the ROSS/OSSI site if it is decided to place the site under their control. These documents will be delivered to the Department for review and approval prior to this task being deemed complete. Status of this task will be noted in the monthly progress reports. The cost for the Technical Documentation documents will be $14,454.87, the cost for the Change Management spreadsheet will be $9,051.65 and the cost for the Formal Site Map will be $5,360.08.

Total cost for Task 3 is $28,866.60.

Task 3 Deliverables:

1. Technical Documentation documents. Two hard copies and two CD’s containing this document will be delivered to BBCS.

2. Change Management spreadsheet. Two hard copies and two CD’s containing this document will be delivered to BBCS.

3. Formal site map. Two hard copies and two CD’s containing this document will be delivered to BBCS.

November 12, 2014

Task 4: Data Transfer Standards Documentation

COASTAL TECH will provide step-by-step guidelines for providers of data to be included in the OSSI Website and Map Viewer. The guidelines will document how one prepares a package of data for submittal to administrators of the ROSS/OSSI Website, and will cover:

Track Lines Sample/Core Data Borrow Area Data Critically Eroded Beaches Data “One-off” datasets Update of Metadata

The guidelines will also cover the information contained within the OSSI comprehensive database that needs to be updated for a given borrow area at each phase of an investigation to update OSSI and its report. After review and approval by the Department, the guidelines will be posted on the main page of the ROSS/OSSI website.

Total cost for Task 4 is $19,637.54.

Task 4 Deliverables:

Guidelines write-up for data providers. Two hard copies and two CD’s containing this document will be delivered to BBCS.

Task 5: Revisions and Enhancements to the ROSS Database Interface

Task 5A-Legend Enhancements: The current legend is a static document that only displays specific ROSS layers. FDEP has expressed a preference for a dynamic legend, which will display all ROSS map layers that are visible at the current map scale. The legend was not an option provided in the ESRI Sample Map Viewer and is not a built-in function of ArcGIS Server.

COASTAL TECH will develop a dynamic legend that toggles individual elements (graphic icon representing the symbols shown on the map with layer name) based on the currently visible layers in the map. Note that this will increase the cost of maintenance of the map services—any time layers are added, reordered or their symbology changed, the legend will need to be updated. The deliverable for this task will include electronic copies of user manual pages that are updated.

Task 5B-Enhanced Query Builder Download: The table of results is a Java applet that, depending on the configuration of a user’s browser, may not function as intended. The applet is a powerful display tool, but was written over ten years ago and has been supplanted by better technologies that offer the same functionality and work more universally.

ROSS requires the ability to download relatively large datasets via the query builder. If a user selects a large dataset, the website may fail to respond before the browser stops waiting

November 12, 2014 for a response (“timeout”). To prevent timeouts, the system has been configured to return a maximum of 500 records. COASTAL TECH proposes to allow for larger sets of data to be downloaded. The results page will be modified to display only a certain number of records on the screen at a time (the specific amount to be determined during testing), with a “More records” link to retrieve another set of data (i.e., paging the data). The form will display an indication of the current number presented and the total number returned by the query, e.g.:

“Showing records 1-50 of 1075”.

Task 5C-Wait Cursor: FDEP has requested that an hourglass/wait cursor be displayed when the application isn’t immediately responding, such as after clicking the map with the Identify tool, during map loading, or waiting for query builder results. This is not a directly supported function of the current map viewer and requires extensive investigation to identify and modify ESRI code to be enabled. URS will work through the source code of the ESRI JavaScript map viewer to find the code that executes when a map is requested and insert code to display a wait cursor, hiding it when the map is received from the server.

The total cost for Task 5 is $12,418.72

Task 5 Deliverables:

Task 5A Email to BBCS stating Legend running on ROSS/OSSI map viewer.

Task 5B Email to BBCS stating Enhanced Query Builder with Data Paging complete

Task 5C Email to BBCS stating Wait Curser running on ROSS/OSSI map viewer

Task 6: Tasks Related to the Southeast SAND Study Data

Task 6A-Website Operation and Hosting: The COASTAL TECH Hosting facility charges $300 per month for 12 months hosting, licensing and maintaining the physical infrastructure necessary to support the ROSS site. This charge includes the following services:

Oracle database server ArcGIS Server Web Server

FTP Server

There will also be time allocated for emergency services to be rendered to the hosting facility and in-house monitoring.

Task 6B-Project-Specific Map: FDEP has requested the ability to have the map open to the extent of the southeast counties of the State of Florida included in the SAND Study, in addition to the current state-wide view. The project-specific map will open to the full extent

November 12, 2014 of the project, with only the project-specific data visible, including sample points, associated borrow areas, and re-analyzed track lines. (See task 6D for additional details on the data the project comprises.) The project-specific map will be accessed via a new link to be added to the ROSS/OSSI home page immediately below the current Mapping link.

Task 6C-Project Management and Monthly Status Reports Creation: Day-to-day Contractor staff coordination of the project will be carried out under this task. This includes tracking budgets, preparing status reports and invoicing.

COASTAL TECH will provide monthly status reports to accompany the monthly invoices to the Department for all tasks in this scope of work.

Task 6D-Southeast SAND Study Data Load: The Southeast Sand Study comprises a larger-than-average dataset of approximately 198 core logs, 300 core logs, and associated sieve analyses, grain curves, and core photos. Associated with this data will be a set of project-specific borrow areas (some of which may already be loaded into the ROSS database—USACOE started with existing borrow areas and then modified some borrow areas and delineated some new ones). In this task, COASTAL TECH will compare the project-specific borrow areas with the existing set, and provide a short report on which borrow areas are new, which are changed, and which are unchanged. After review of the report and approval from FDEP, COASTAL TECH will upload the new and updated borrow areas.

There will also be track lines with new analyses, provided in jpg format. The track lines will require a new link format to display these results.

The total cost for Task 6 is $26,187.23

Task 6 Deliverables:

Task 6A Statement of Hosting Fees in Quarterly Status Report

Task 6B Project-Specific Map

Task 6C Monthly Status Reports

Task 6D Borrow-Area Review Document; Loaded Dataset

Task 7: Additional ROSS/OSSI Database Enhancements

Task 7A-Website Operation and Hosting: The COASTAL TECH Hosting facility charges $473.74 per month for 11 months of hosting, licensing and maintaining the physical infrastructure necessary to support the ROSS site. These fees are currently covered through

November 12, 2014

December 31, 2013 under the existing contract; this task includes estimated costs to extend the hosting fees through November 30, 2014. This charge includes the following services:

o Oracle database server o ArcGIS Server o Web Server o FTP Server

This task also allocates time for emergency services to be rendered to the hosting facility and in-house monitoring. After November 30, 2014, the work for this task will be performed under a new task assignment.

Task 7B-Additional Datasets Load: COASTAL TECH, at FDEP’s request, will load an undetermined number of sand datasets that are not currently in the ROSS/OSSI system.

For this task 7B, COASTAL TECH shall submit detailed Scopes of Work for each dataset requested; the DEPARTMENT shall review the Scopes of Work as to content, deliverables, schedule and cost. COASTAL TECH shall be notified by a written Letter of Authorization from the DEPARTMENT’s Coastal Geologist, of approval of the detailed Scope of Work for the datasets requested by the DEPARTMENT. A Letter of Authorization must be received by COASTAL TECH prior to initiating any work on a Task 7B Scope of Work. Upon satisfactory completion of work described in a Letter of Authorization, the DEPARTMENT’s Coastal Geologist shall provide a Letter of Acceptance. Copies of the Letter(s) of Authorization and Letter(s) of Acceptance, which includes a copy of the approved detailed Scope of Work, shall be sent to the DEPARTMENT’s Contract Manager and must accompany each request for reimbursement for that Scope of Work. The total of all Letters of Authorization shall not exceed the total for this subtask: $62,298.50.

Task 7C-Project Management and Monthly Status Reports Creation: Day-to-day coordination of activities of Contractor's staff needed for the continuation of the project will be carried out under this sub task. This includes tracking budgets and preparing status reports.

COASTAL TECH will provide a monthly status report to accompany the monthly invoice to the Department for all tasks in this work authorization. After November 30, 2014, the work for this task will be performed under a new task assignment.

The total cost for Task 7 is $74,963.45.

Task 7 Deliverables:

Task 7A Statement of Hosting Fees in Quarterly Status Report

Task 7B Email to BBCS stating the datasets have been uploaded and are available

November 12, 2014

Task 7C Monthly Status Reports

Task 8: Populate ROSS/OSSI Database

Introduction for Task 8: In 2009, the structure for the comprehensive OSSI database was created and partially populated with existing ROSS data. The work conducted on OSSI to date had been completed under expired Contract BS016, Task 19. The comprehensive OSSI will include information for each borrow area regarding sediment quality, volume estimates, and associated borrow area designation (such as potential, proposed, permitted, etc.). The OSSI database structure was created as part of the ROSS project so that data can be shared and entered only once for both databases. The OSSI data is then served on the existing ROSS website and MapViewer. As part of the sand search and permitting process, geologic data on the borrow areas is typically provided to the state for inclusion in the ROSS/OSSI database.

An evaluation must be made of the current OSSI database and the compatibility and quantity of the Southeast Florida Sediment Assessment and Needs Determination (SAND) study data available for population of OSSI. It is anticipated that this phase of work will be conducted primarily via collaboration between Engineering, Hydrology, and Geology (EHG, formerly BBCS) representative Jennifer Coor and COASTAL TECH. In addition to the data evaluation, guidelines will be established for creating geologic descriptions of borrow areas. Information that may be included in the summary includes:

Basic description of borrow area Depositional environment (if applicable) Geomorphology

Basic grain descriptions (e.g. color, size, etc.)

Existing sand volumes and volumes of sand removed for projects (provided by

EHG)

Information included in the SAND study report (e.g. narrative, description) as deemed appropriate by EHG

Seismic data from the Blue Horizon profiles, as deemed appropriate by EHG

Following establishment of the protocol for descriptions, the existing database structure will be amended to include detailed data pertaining to the borrow areas. COASTAL TECH previously developed a draft schema and data dictionary to accommodate information that is routinely collected as part of the borrow area inventory and delineation. EHG staff may elect to exclude or modify any of the database items in the attached database dictionary. It should be noted that the previous design was based on three borrow area designations: potential, proposed and permitted. These categories were modified as part of the southeast SAND study to:

potential/unverified, permitted, proven, and expended. The database will be updated to reflect this revision and COASTAL TECH anticipates the schema will be finalized in February, in conjunction with the geologic descriptions, and will not be altered for the duration of the 2014 contract period except under separate scope and cost.

November 12, 2014

The amount of data population that can be accomplished in the target time period and budget is a function of the availability of EHG staff for collaboration, the complexity of the geologic interpretation, and the amount of borrow area data readily available. For areas where no composite data have been received, COASTAL TECH staff will search FDEP’s online permitting database and collect the required information. Alternatively, COASTAL TECH may calculate the missing values using the vibracore data through a combination of spreadsheet calculations and geospatial analyses. Further analyses will be performed in GIS to determine the spatial components (e.g. range monument, range monument county, bearing, distance from centroid of borrow area to range monument, etc.).

COASTAL TECH will work with EHG staff to create a spreadsheet of borrow areas that will be used to track progress for the project. The borrow areas will be grouped by county and columns will be added that detail the data necessary to populate the database. The spreadsheet will be passed between EHG project lead, Jennifer Coor, and COASTAL TECH, to track progress. COASTAL TECH will submit geologic descriptions to EHG for review as they are completed and COASTAL TECH will send a weekly to biweekly email summarizing project progress.

Once the information is populated in OSSI it will be accessed via the map viewer using the identify tool to click on a borrow area polygon:

Clicking the borrow area id (e.g. SL5-R70) will display an option to view the full record:

November 12, 2014

Clicking on the “Full Record” hotlink accesses the attributes for the borrow area:

The missing project information will be filled in as part of the database population and new section will be inserted after the “Borrow Area Polygon Location” to accommodate the “Geologic Interpretation”. During the scoping meeting, EHG and COASTAL TECH project leads will determine if additional fields should be displayed (e.g. Munsell color, grain size, etc.).

November 12, 2014

Data population will be conducted by county beginning with St. Lucie and moving south through Miami-Dade. COASTAL TECH estimates one month to prepare for the data population and one to two months to create the geologic descriptions, collect the data, and update ROSS/OSSI for each county.

COASTAL TECH will continue to create geologic descriptions and add data to OSSI until upload of the borrow area SAND data is complete. In the event work progresses more quickly than anticipated and/or substantial budget remains, COASTAL TECH will submit a change order to perform one of the additional recommended enhancements listed in the next section.

The total cost for Task 8 is $49,904.10.

Task 8 Deliverables:

Emails to EHG stating the data have been populated and are available via the web server.

Task 9: OSSI Population & Platform Upgrade

Introduction for Task 9 (Change Order 11/June 2014): In 2009, the structure for the comprehensive OSSI database was created and partially populated with existing ROSS data.

The comprehensive OSSI will include information for each borrow area regarding sediment quality, volume estimates, and associated borrow area designation (such as potential, proposed, permitted, etc.). The OSSI database structure was created as part of the ROSS project so that data can be shared and entered only once for both databases. The OSSI data is then served on the existing ROSS website and MapViewer. As part of the sand search and permitting process, geologic data on the borrow areas is typically provided to the state for inclusion in the ROSS/OSSI database. Data from the Southeast Florida Sediment Assessment and Needs Determination (SAND) study are being incorporated into OSSI under Task 8 for the current contract and will be completed in 2014.

COASTAL TECH is providing this change order at the request of Engineering, Hydrology, and Geology (EHG, formerly BBCS) representative Dr. Jennifer Coor. EHG has requested that COASTAL TECH provide a cost for 16 additional months of hosting fees, this will be a modification to Task 7B (above). EHG has requested COASTAL TECH complete two additional phases of work, (1) population of OSSI for all borrow areas that have been delineated in the state of Florida and (2) upgrade of the ROSS web platform. COASTAL TECH anticipates beginning this next phase of work in 2014 as Task 9 to be conducted concurrently with Task 8.

Task 9A – Populate OSSI:

Population of OSSI with data for the borrow areas for remainder of the state will be significantly more labor intensive than for the southeast SAND study data. With the SAND study, much of the data were submitted in a gINT® format, which is nothing more than a database. Data were statistically analyzed where appropriate and imported into the OSSI framework without much manipulation for many of the required database

November 12, 2014 fields. Geologic descriptions were compiled from the SAND study final stakeholder report and did not require a significant amount of research into other sources.

OSSI Data Population Methodology Following are the steps that will be employed to populate OSSI with data for the remaining borrow areas:

1. The remainder of the state will be divided into three regions, the southwest, the northeast, and the panhandle (see Figure 1 below), and will be populated in that order. However, the work for the “northeast” region will be conducted under a new task assignment; this task assignment will only include the southwest and panhandle regions.

2. EHG representative Dr. Coor will review the borrow areas on a county by county basis for any irregularities and to inform COASTAL TECH if specific areas are outdated or have been superseded with newer borrow area delineations.

3. Spatial analysis will be conducted in GIS to populate the pertinent fields as necessary including: County, County Utilizing Sand, Range Monument, Range Monument County, Bearing, Distance, etc. The defaults for these fields will be the closest if no other information is available.

4. Granularmetric data will be collected from existing sediment core data available on ROSS/OSSI then from permits, if necessary.

5. Permits will be searched for each borrow area and information extracted to create a geologic description.

6. Seismic data (imagery) will be reviewed, where available, and pertinent information will be added to the geologic description (e.g. seismic reflector, filled in channels, etc.).

Populating OSSI with the SAND Study data was simpler and less time consuming than addressing the remainder of the state’s borrow areas because the core data for the SAND Study was received electronically and easily transferred to the borrow areas. COASTAL TECH anticipates the largest cost will come from manually searching the Joint Coastal Permits (JCPs) for the data that are not readily available in any other place.

Task 9B – Platform Upgrade:

The existing ArcGIS Server Map Interface is based on a sample viewer originally written by ESRI, with extensive customization by COASTAL TECH. ESRI is no longer developing or supporting this sample map viewer, and only provided minimal documentation. The sample map viewer is based on an outdated version of the ESRI JavaScript API for ArcGIS Server (JSAPI), which supports fewer features and functions than more recent versions of the JSAPI.

Recently, COASTAL TECH developed a custom, JavaScript-based map viewer for FDOT, based on the most recent version of the JSAPI. This custom map viewer incorporates the jQuery framework to simplify coding across multiple browser platforms and the jQueryUI toolkit for form controls, dialogs and other user interface elements.

A key advantage of the COASTAL TECH map viewer is that the code is comparatively light. The ESRI map viewer is written as a “generic” map viewer, with hooks for

November 12, 2014 extending it, many features that are not necessary for the ROSS viewer, multi-language support, and customization via configuration files. The COASTAL TECH map viewer does not need the extensive code necessary to support customization and multi-language support, and instead only includes code to do those specific functions needed by the ROSS system. Adding new functions to the map viewer is comparatively easier, as there is less code to work through, and all of it written by COASTAL TECH staff available to form the work in adapting it for ROSS.

A second advantage to replacing the map viewer would be improvements to the user interface. The Dojo dialogs used by the existing viewer, while stylistically very attractive, have usability issues. As has been noted by FDEP staff, the placement, size and behavior of these dialogs and controls are fixed. Replacing these dialogs with jQueryUI dialogs would allow for better usability while still maintaining an attractive, modern interface.

Requests for enhancements to the current viewer also include the ability to “deep link” to functions within the map, in particular to have a link from the main website page that opens the map and starts the query builder. This functionality is not supported by the current map viewer, but could be by the proposed replacement.

It is important to note that replacing the map viewer would not be a complete scrap-and-replace effort. The customizations made by COASTAL TECH to the ESRI map viewer to support ROSS functionality, such as the enhanced Identify tool, links to project documents, the incorporation of the “Sand search” query builder, among others, can be converted for inclusion in the COASTAL TECH custom viewer.

The enhancements described in other recent proposals to FDEP for map and site enhancements would be either included in, or made redundant by the replacement of the map viewer, including:

Combination Search/Identify Tool Deep-Link to Query Builder or other tools Data Export from Query Builder Dynamic Legend Displaying data and documents from non ROSS-format projects Wait Cursor Links to FTP from Identify tool for track lines and shot point layers Improvements to interactive map navigation Performance Enhancements

Other functionality included in the current version of the map viewer will also be included:

Quick zoom to county, range monuments and projects by ID or Name Ability to toggle between a variety of base map services, including satellite and street map, and most notably a high quality benthic/oceanographic basemap service Ability to toggle visibility of individual layers in the ROSS/OSSI map service Overview map

November 12, 2014

Display Coordinates Integrated sand search query builder Metadata

The total cost for Task 9 is $103,432.12.

Task 9 Deliverables:

Task 9A Email Summary of Review and Geologic Interpretation Guidelines and a List of Borrow

Areas that have been Completed for Each Area

Task 9B Documentation that the Platform has been Upgraded and is Running

Figure 1.