SPARROW Decision Support System

Total Delivered Load Summary Report Help

Typical Usage and Examples

The Total Delivered Load Summary Report can be used to summarize the load delivered to all of the downstream reaches selected in the Downstream tracking tab of the application. These downstream reaches may be entering an estuary or a lake or crossing some boundary such as a state line. The report lists the Total Delivered Load for each individual downstream reach and the cumulative Total Delivered Load for all of the downstream reaches. In all cases, the Total Delivered Load is broken down by source.

Total Delivered Load is the total load (including load from upstream reaches) that arrives at the downstream end of the selected downstream reaches, in units of the model per year. Two examples of typical usage of this report are shown below.

Fig. 1: Example usage of load delivered to a lake

Reaches A, B and C are selected as downstream reaches to represent loading to the lake. Load that arrives at the end of these reaches (as shown by the orange circles) would be reported individually in a row in the report and would be aggregated in another row in the report, like the report in Figure 3.

Fig. 2: Example usage of load crossing a political boundary

Reaches A, B and C are selected as downstream reaches to represent the load leaving a political region, such as a state. Load that arrives at the end of these reaches (as shown by the orange circles) would be reported individually in a row in the report and would be summed in another row in the report, like the report in Figure 3.

Because rivers are broken into reaches based on hydrology, not political boundaries, it is likely that the downstream end of the selected downstream reaches will not fall on the political boundary. Thus, some load from outside the region may be included in the reported values. If an upstream area outside of the political boundary is contributing to the load at the downstream reaches, consider using the Delivered Load by Upstream region instead.

Fig. 3: Example Report for figures 1 & 2

Figures 1 & 2 might result in a delivered load summary like this one. The total load arriving the downstream end of each of the selected downstream reaches (A, B & C) is shown in a separate row in the table and summed in the last row. These loads are also broken down by source.

Avoid Nested Downstream Reaches

It is important to understand that if any of the selected reaches are upstream of another selected reach (i.e. if two or more reaches are nested), some of the load will be counted more than once and the total row will be inaccurate. It is almost always incorrect to select downstream reaches such that one reach is upstream of another.

Fig. 4: Example of nested upstream reaches

Reaches A & B have been selected as downstream reaches. The total load arriving at the downstream end of reach B will be included as a row in the report, as will the total load arriving at the downstream end of reach A, which will include some load from reach B. In this example, the total row in the report will not be the total load delivered to the lake, since some of the load from reach B will have been included twice. By selecting only reach A as a downstream reach, all of the upstream load that arrives at the downstream end of reach A, including load that originates from reaches B, C, and all reaches upstream, will be included in the load reported for reach A.

Watershed Area - Fractioned Based on Stream Flow

This report (and other parts of this application) uses Fractioned Watershed Area. For a selected reach, the Watershed Area is the area of land that drains all the upstream streams and rainfall to the stream reach, i.e., it is the area of the 'upstream' land area. Fractioned Watershed Area accounts for splits (also called diversions) in the river network, where an upstream reach splits into two downstream reaches, as shown in Fig. 5.

Fractioned Watershed Area is calculated as follows:

  1. Select a reach to calculate the Fractioned Watershed Area for and start with the incremental area of that reach.
  2. For each reach immediately upstream, multiply the upstream reach's incremental area by the fraction of the load that enters the downstream reach (called just fraction) and add these areas to the incremental area of the selected reach. The fraction of load entering the downstream reach is 1 unless there is a diversion.
  3. Repeat this process, finding all upstream reaches and adding their fraction-multiplied area. The fraction propagates upstream, such that if there is a 50/50 split at the very first reach, all upstream reach areas are multiplied by .5. Additional upstream splits are multiplicative, thus, if there was a second 50/50 split further upstream, areas above that point would be multiplied by .25.

Fractioned Watershed Areas allow for more consistent yield numbers and are a truer representation of the total land area 'responsible' for the load arriving at a reach. They will, however, not match other published watershed areas which do not fraction upstream areas by stream flow.

Fig. 5: Example of nested upstream reaches

This sample calculation how Fractioned Watershed Area would be calculated for the simple case of reaches that have only one upstream reach. Note that adding the Fractioned Watershed Areas together does not result in double counting the area.