Appendix 3-F(1)

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

Grouping Scenarios in Mark Twain Lake Basin, MO

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 Mark Twain Lake 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 Mark Twain 

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 Mark Twain Lake (MO) Test Basin Area.
 

 
Worksheet Tab

SummaryByYear

MO-01_4989415_basin

MO-02_5042380_basin

MO-04a_4989385_basin

MO-04b_4989739_basin

MO-05_5042400_basin

MO-05b_5039952_basin

MO-08_2508563_basin

AEMP_Monitoring1

AMP_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 MO-01 (NHD+ comid 4989415)

Results for AEEMP site MO-02 (NHD+ comid 5042380)

Results for AEEMP site MO-04a (NHD+ comid 4989385)

Results for AEEMP site MO-04b (NHD+ comid 4989739)

Results for AEEMP site MO-05 (NHD+ comid 5042400)

Results for AEEMP site MO-05b (NHD+ comid 5039952)

Results for AEEMP site MO-08 (NHD+ comid 2508563)

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

Monitoring data for each of the AMP 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)