1.0 DESCRIPTION OF SUBCONTRACT WORK

The current Riverine Spill Modeling System (RSMS) that is operational with the Ohio River main stem and
major tributaries needs to be updated with additional data inputs to provide a more accurate
representation of the watershed flow, precipitation, and sources of contamination. These results will be
useful for emergency planning, as well as for designing mitigation and adaptation strategies improving
long-term resilience. They also expand the capabilities of the RSMS making it more flexible and adaptable
to a broader range of emergency and contaminant response scenarios and watersheds across the nation.

This work shall include the following tasks:

- Task 1, Quality Assurance Project Plan (QAPP).
Assist APTIM with preparing a new QAPP for the study within 30 days.

- Task 2, Azure Subscription License.
Acquire monthly Azure subscription license.

- Task 3, Upgrade the Web-based application model.
Upgrade the web-based application model described above to work seamlessly with the time stamped
HEC-RAS data. The subcontractor shall change the river spill model API such that it can receive and
process the upgraded binary flow files from HEC-RAS. This conversion shall include upgrading the
programming, testing the code, and rerunning previous tests to ensure that the results are compatible.
The subcontractor shall verify the software is operational on contractor hosted systems.

- Task 4, Incorporate Other Databases.
Incorporate important upstream information from other databases (to the extent feasible where such
datasets are easily available) such as railroad bridges, pipelines, barge traffic, Comprehensive
Environmental Response Compensation and Liability Act (CERCLA) and Resource Conservation and
Recovery Act (RCRA) sites, Toxic Substances Control Act (TSCA) and Toxic Release Inventory (TRI)
facilities, Pesticide use, National Pollutant Discharge Elimination System (NPDES) permits and many
other potential threats to source water. The link to bridges database will have to be upgraded to the last
US Army Corps of Engineers standard.

- Task 5, Leverage Flow History.
Leverage the existing 12 years of flow history to establish flow trendlines and their implications for spills
and algal blooms that can be modeled as spill events.