Appendix 3-F(3)

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

Grouping Scenarios in White River (East Fork) Basin, IN

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 White River (East Fork) 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 White River 

(East Fork) 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 White River (East Fork) (IN) Test Basin Area.
 
Worksheet Tab

SummaryByYear

IN-10_18459870_basin

IN-04 river_18454511_basin

IN-06 river_18450057_basin

IN-07 river_18445592_basin

IN-08 river_18445664_basin

IN-13 river_18451035_basin

Monitoring

Each basin tab includes the follo 

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 IN-10 (NHD+ comid 18459870)

Results for AMP site IN-04 river (NHD+ comid 18454511)

Results for AMP site IN-06 river (NHD+ comid 18450057)

Results for AMP site IN-07 river (NHD+ comid 18445592)

Results for AMP site IN-08 river (NHD+ comid 18445664)

Results for AMP site IN-13 river (NHD+ comid 18451035)

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)