Appendix 3-F(2)

Comparison of SAM Outputs Generated Using Individual Soil Map Unit Scenarios or Soil WQI 

Grouping Scenarios in Scioto River Basin, OH

This appendix, the first of three spreadsheets, is provided in support of the comparison of 

model outputs using scenarios based on individual soil map units (MU) or on soils grouped 

according to USDA Water Quality Index (WQI) groupings in Section 3.3 of the SAP document 

Development of a Spatial Aquatic Model (SAM) for Pesticide Assessments. The outputs are 

also compared with monitoring data from the Atrazine Ecological Exposure Monitoring Program 

(AEEMP) and the Atrazine Monitoring Program (AMP) in the Scioto River area. Monitoring data 

and descriptions can also be found in Appendix 2C.

The table to the right describes each tab linked to the monitoring sites found in the Scioto River 

test basin. Figures 1 and 2 (below) shows the locations of the test sites. Each basin is identified 

both by the original study ID and by the NHDplus (version 2) comid for the catchment that is 

associated with the monitoring sampling site (pour point).

Figure 1: Location of Test Basin Areas for SAM Model Development and Evaluation.

Figure 2: AEEMP and AMP Monitoring Sites in the Scioto River (OH) Test Basin Area.
 
Worksheet Tab

SummaryByYear

OH-04_3483775_basin

OH-10rvr_5214753_basin

OH-11res_5213585_basin

Monitoring

Each basin tab includes the foll 

Field

Data for Soil Groupings:

Date

Est. Conc (ug/L), Aggreg 

Scenarios

Rmass (kg), Aggreg Secnarios

Runoff(m)

RConc(ug/L)

TotalFlow(m3)

baseflow(m3)

Cumul. Runoff Loss, Aggreg 

Scenarios

Data for Individual Map Units:

JulD

Est. Conc (ug/L), Indiv. MU 

Scenarios

Rmass (kg), Indiv. MU 

Scenarios
Runoff(m)

RConc(ug/L)

TotalFlow(m3)

baseflow(m3)

Cumul. Runoff Loss, Indiv. MU 

Scenarios
Contents

Summary of annual (2000-2014) total runoff, total mass lost, and maximum atrazine 

concentrations based on individual soil map units or soil WQI groupings for each test 

basin site. Includes graphs comparing concentration estimates, cumulative mass 

losses.

Results for AEEMP site OH-04 (NHD+ comid 3483775)

Results for AMP site OH-10 river (NHD+ comid 5214753)

Results for AMP site OH-11 reservoir (NHD+ comid 5213585)

Monitoring data for each of the test basin sites (used for graphs)

owing fields:

Description/source

Daily dates from scenario, 1/1/2000 - 12/31/2014

Estimated daily concentrations generated using aggregated scenarios (soils grouped 

by WQI criteria)

Daily pesticide mass flux lost in runoff generated using aggregated scenarios (soils 

grouped by WQI criteria)

Daily runoff volume using aggregated scenarios (soils grouped by WQI criteria)

Daily runoff concentration using aggregated scenarios (soils grouped by WQI criteria)

Total flow estimate in stream mixing cell, based on NHD+ data

Base flow estimate for stream mixing cell (see Section 2.1)

Cumulative pesticide mass lost in runoff (summing daily Rmass values)

Julian dates from scenario, 1/1/2000 - 12/31/2014

Estimated daily concentrations generated using individual soil map units

Daily pesticide mass flux lost in runoff generated using individual soil map units
Daily runoff volume using individual soil map units

Daily runoff concentration using individual soil map units

Total flow estimate in stream mixing cell, based on NHD+ data

Base flow estimate for stream mixing cell (see Section 2.1)

Cumulative pesticide mass lost in runoff (summing daily Rmass values)