image

This page provides guidance that accompanies a Phosphorus Street Sweeping Credit Calculator (Calculator). More detailed documentation may be developed at a later date, and the Tool (Calculator) itself is subject to change at a later date.

The Calculator is an Excel workbook developed by Tetra Tech for MPCA based research and guidance compiled by the University of Minnesota and evaluations of Program for Predicting Pollution Particle Passage through Pits, Puddles, and Ponds (P8) urban catchment model results conducted by Tetra Tech using the same street sweeping data collected by the University of Minnesota. The Calculator has four tabs, two of which are informational (Read Me and Methodology), and two of which are for data entry and output (Calculator), and tracking results (Tracking). Below is a description of the information on each of these four tabs, and how different types of data may be input, and how to interpret output from the Calculator.

Note that if the user desires to seek additional complexity for total phosphorus removal credit, they may explore the Planning Calculator for estimating nutrient and solids load recovery through street sweeping as developed and calibrated to data from the City of Prior Lake, Minnesota (Kalinosky et al. 2013).

Read Me tab

screen shot of Read Me tab in the street sweeping calculator
Screen shot of Read Me tab in the street sweeping calculator

The Read Me tab is the first tab at the bottom of the workbook. It provides introductory text for the Calculator, including an explanation of inputs and outputs and the background of the tool development. Data entry options for the Calculator are based on 3 different data types, depending on the data available.

  1. Dry mass
  2. Wet mass
  3. Curb miles swept

Calculator output is described as the phosphorus load reduced based on the inputs provided. For example, if a single sweeping event is entered into the Calculator, the result is the amount of phosphorus reduced from sweeping for that event, whereas if the data from an entire season is entered into the Calculator, the result is the amount of phosphorus reduced for that season.

This tab is locked so the user may not change any values or text on this tab.

Information: Credit refers to the stormwater runoff volume or pollutant reduction achieved toward meeting a runoff volume or water quality goal. In the case of the Calculator, credit refers to pounds of phosphorus removed as a result of street sweeping

Methodology tab

screen shot of Street Sweeping Calculator Methodology tab
Screen shot of Street Sweeping Calculator Methodology tab. Click on image to enlarge.

The Methodology tab contains the reference information used by the equations on the Calculator tab. The details in this tab may be helpful for the user to understand the assumptions built into the Calculator. Information on this tab includes the following:

  • Unit Conversions: Unit conversions used in the Calculator are hard linked here
  • Season Options: The University of Minnesota data analysis found there are distinct patterns and relationships between nutrient concentrations and swept material that occur seasonally due to when leaf-fall typically occurs. The calculator has two options for season. Fall Leaf Collection season is based on the University of Minnesota sweeper data from October through November. The Non-Fall Collection season is based on the sweeper data from March through September (winter months were not included in the study). The user should select the most appropriate season based on when sweeping occurred. For example, if leaf drop occurred late in the season, and early October sweeping activities were not collecting fall leaves, the user can select Non-Fall Collection for these events to better reflect the materials swept. If the user has data for organic matter and enters this into the Calculator worksheet, the season of collection is not used for the equations in the Calculator. The University of Minnesota found that phosphorus is statistically better correlated to the percent organic matter than the season, so a separate statistical relationship is used when these data are available.
Information: If the user has data for organic matter and enters this into the Calculator worksheet, the season of collection is not used for the equations in the Calculator.
  • P Load Calculation: Specific information related to how phosphorus load reductions are calculated, including regressions from the U of M study.
  • Mass Tables/Calcs: Presentation of how sweeper load dry mass is calculated from sweeper load wet mass and dry basis moisture content as documented by the University of Minnesota. The seasonal average dry basis moisture content and seasonal 25th quantile phosphorus concentration from mass are presented as they are used in the “Calculator” tab depending on the season and the type of data input.
  • P8 Calculations: Calculation of the 25th quantile estimation of phosphorus removal rate developed by P8 model results, as well as presentation of phosphorus load reduction equation as it relates to length of road swept, sweeper width, and phosphorus removal rate. The statistical analysis associated with the P8 phosphorus removal rate was based on ten years of simulation across 4 municipalities and 23 routes. The P8 model was set up according to the parameterization recommended by MPCA in the Recommendations and Guidance for Utilizing P8 to Meet TMDL Permit Requirements.

This tab is locked so the user may not change any values or text on this tab.

Calculator tab

screen shot of Calculator tab
Screen shot of the Calculator tab. Click on image to enlarge.
image of sweeping decision tree
Street sweeping decision tree and process of data collection for phosphorus credit with the Calculator.

On the Calculator tab, users enter street sweeping information and phosphorus reductions are calculated. On this tab, yellow cells may be modified by the user, but all other cells are locked so the user may not change values or text.

At the top of the worksheet the user can provide a name and/or description of the project or watershed area. (for example “Fall Sweeping Data for Municipality A”, or “June 10th, 2020 Sweeping Event for Municipality B”).

In the Input Data section on this tab, the user may input data based on three different data type options, following this decision tree or order of operations including both field and/or laboratory sampling. This is described below.

Option 1: Dry Mass

The user enters the known dry mass of materials swept for their period of interest. The season must also be provided if there is no organic matter data, due to the various equations used to calculate phosphorus concentration. If the percent organic matter (determined by laboratory analysis) is used as an input, “Not Applicable” must be selected for the Season of Data Collection.

Information: If the percent organic matter is used as an input, “Not Applicable” must be selected for the Season of Data Collection.

The default phosphorus concentration based on the selected season or percent organic matter is displayed in Row 22 and the resulting pounds of phosphorus removed is shown in Row 26.

For guidance on collection, measurement and analysis of street sweepings, see Methods for sampling street sweeping material - Standard Operating Procedures.

Option 2: Wet Mass

This option should be used when the dry mass has not been determined. The user enters the known wet mass and selects a season, if the percent organic matter (determined by laboratory analysis) is unknown. The user may optionally include the dry basis moisture content and/or the percent organic matter (both determined by laboratory analysis), if one or both values is known. Otherwise seasonal average assumptions will be applied based on University of Minnesota data. It is important to note that dry basis moisture content is not the same as percent moisture. Dry basis moisture content (used in the Calculator) is the mass of water divided by the oven-dried mass of the solids, which can range from 0 - >100%. Alternatively, percent moisture typically refers to the wet basis and represents the mass of water divided by the total weight of sample (solids+water) and ranges 0 - 100%.

Information: NOTE: Dry basis moisture content is not the same as percent moisture. Dry basis moisture content (used in the Calculator) is the mass of water divided by the oven-dried mass of the solids, which can range from 0 - >100%.

The resulting dry mass and phosphorus concentration, based on the user inputs, are shown in Rows 21 and 22. The resulting pounds of phosphorus removed is shown in Row 26.

For guidance on collection, measurement and analysis of street sweepings, see Methods for sampling street sweeping material - Standard Operating Procedures.

Option 3: Miles Swept

This option should be used if no information is available on the mass of sweeper material collected. The user enters the curb miles swept. Curb miles differ from "road miles" in that any curb line that is swept can be considered in tabulation. For example, if 1 mile of road is swept on 1 curb line, that is 1 curb mile. If the same 1-mile road is swept on both sides of the street, that is 2 curb miles. Multiple passes on a given roadway should be counted separately. For example, if one curb line of a road is swept for 2 miles in the eastbound direction and one curb line of the same road is swept for 2 miles in the westbound direction, 4 curb miles swept should be entered. Similarly, if 2 miles of the eastbound lane are swept 3 times during the data calculation period, 6 curb miles should be entered. For inputs of curb miles of roadway swept, there is no required input for season.

The Calculator will calculate the resulting acres of roadway swept and apply the default phosphorus removal rate. The resulting pounds of phosphorus removed is provided in Row 26.

The Calculator can be used after any street sweeping event to calculate phosphorus removal from individual sweeping events or sweeping data can be aggregated outside of the Calculator and summary data entered in the Calculator to provide phosphorus removal for multiple sweeping events over the course of a season in a single calculation.

Tracking tab

On this tab, the user may track inputs and outputs from any individual run of the Street Sweeper Credit Calculator for tracking purposes. The user may record the project or watershed name, event or route name, date or date range of the sweeping event, season, and numerical measurements such as sweeping load wet mass (pounds), curb miles swept (miles), and/or results of laboratory analyses such as dry basis moisture content (percentage), sweeping load dry mass (pounds), and organic matter content (percentage). The user can then track the input option used for a specific Calculator application (e.g. Option 1 if dry mass data was used), and the results of the Calculator for total phosphorus removed (pounds). There is also a column for the user to enter project-specific or Calculator application notes (e.g. route modifications due to unexpected conditions, unexpected heavy leaf drop due to storms, etc.) Additionally, the Calculator can be used to evaluate which credit calculator option is most favorable for a given sweeping event (e.g. a user may have data for curb miles swept and wet mass, and can run the same sweeping event with both options and record the results to see which Calculator input option offers the most favorable phosphorus removal credit).

References

Appendix A: Credit Calculator Technical Reference

Methodology and technical justification for the equations and relationships incorporated into the MPCA Street Sweeping Credit Calculator are summarized here.

The mass-based approach for street sweeping credit is backed by research-based empirical relationships developed using research conducted by the University of Minnesota Water Resources Center (the University). The University research involved evaluating relationships among wet mass, dry mass, organic carbon content, and phosphorus concentrations of collected sweeper loads for five cities. Three sweeper types (regenerative air, mechanical broom, and vacuum) were used to conduct street sweeping, and collection occurred throughout the snow-free season (April – November). Data relationships were derived from existing data from the Prior Lake Street Sweeping Study (Kalinosky et al., 2013a; Kalinosky, 2015) and new data collected in partnership with the cities of Minneapolis, Forest Lake, Roseville, and Shoreview, MN.

Including the Prior Lake data, samples were collected from 37 sweeping routes across the snow-free season for 2010-2012 (Prior Lake) and 2019 for the remaining four cities. This yielded 384 samples from Prior Lake and 191 total samples from remaining cities. Samples were processed and analyzed at the University of Minnesota’s Department of Ecology, Evolution and Behavior using methods developed in the Prior Lake Street Sweeping Study and described in detail in Kalinosky et al. (2014).

Following sample analyses, the data were analyzed using mixed linear models to determine whether dry basis moisture content, organic content, and carbon and phosphorus concentrations of the sweeper loads vary based on factors such as canopy cover and season. Two final reports summarizing the findings of the study were completed (King et al. 2020; Hobbie et al. 2020); and the data relationships documented were used in developing the MPCA crediting methodology. The University provided approaches for approximating phosphorus removed from street sweeping based on inputs such as sweeper dry mass, wet mass, dry basis moisture content, and/or percent organic matter.

Equations for creating the Calculator

MPCA, Tetra Tech, and the University explored various potential crediting options based on the anticipated predictive relationships that would be derived from the University research. The group explored several methods of calculating phosphorus reduction credits, expressed as pounds reduced per year from street sweeping and selected options which balanced the amount of data that a permittee would need to collect and the predictive error in the statistical relationship with phosphorus concentration.

The statistical relationships developed by the University and employed in the Calculator are related to potential inputs of dry mass, wet mass, percent organic matter, and/or dry basis moisture content to derive phosphorus reduction credits.

The crediting method using miles swept was derived from Tetra Tech’s analysis of phosphorus reductions using the MPCA recommended default setup for the P8 model with inputs derived from the University’s sweeping study. This option was developed for jurisdictions without the capacity to collect the more detailed data required to derive the phosphorus removal rate using the University’s statistical relationships. If a user chooses to input miles swept, the reductions are significantly less than would be expected from the methods based on the amount of sweeper material collected because this is a coarser method of estimating phosphorus removal.

After input of available street sweeping data, the Calculator uses the equations summarized below and statistical methods developed by the University to estimate the amount of phosphorus reduced due to the street sweeping effort.

The relationship between seasonality and phosphorus was incorporated into the Calculator. Based on the data from the University, there is a pronounced difference in both moisture content and phosphorus concentration depending on the season. The Calculator is designed to represent two periods of street sweeping throughout the year, fall leaf collection and non-fall collection. The default values for the non-fall collection period were derived from data from March through September, and the values for the leaf collection period were derived from the data from October and November.

This distinction allows permittees the ability to report with greater accuracy whether leaf collection was a major component of sweeping, and also allows the flexibility to report leaf collection when it actually occurs, rather than being tied to a specific month, e.g., if leaf drop is early one year, the leaf collection values could be applied to September collections, or if leaf drop is late, the non-fall collection values could be applied in October. In general, any street sweeping that occurs in December through August could be assumed to be part of a non-fall collection period. Because the Calculator is fundamentally based on the amount of street swept and the amount of materials collected, it provides municipalities the flexibility to calculate reductions on an annual basis, or on other metrics, such as monthly, seasonally or by sweeper route or date of collection. This allows jurisdictions who choose to collect more advanced data on their sweeper program to evaluate the results at a finer scale and determine the crediting method that is advantageous to their program.

Information: In deciding which season to use in the Calculator, the user should base the determination on conditions at the time of sweeping rather than time of year, since leaf drop occurs at different times from one year to the next.

The equations and methods employed in the Calculator are brought forward from the University documentation. The following section details the options for data input and underlying equations.

Note that the choice was made to use the 25th quantile statistic relative to a number of parameters from the research dataset. This choice was made because the Calculator is intended to be applied statewide; however, data were collected in one of the most urban areas of the state in and around Minneapolis. By using the 25th quantile of particular parameters (e.g. observed phosphorus concentration), the Calculator is able to provide an estimate for phosphorus reduction that is generally conservative, and thus provide a margin of safety to estimated reductions, given that statewide or regionally-specific dataset were not available to develop the statistical relationships.

Information: Phosphorus reductions are based on 25th quantile values rather than median values due to uncertainty in data. Sweeping entities may develop their own relationships following protocol established in this manual

Option 1: Dry Mass Data

For inputs of sweeper dry mass data, the load of phosphorus removed from the sweeping event is a function of the mass fraction of phosphorus concentration in that load.

Eq. 1 \(Phosphorus Removed = Dry Mass * Phosphorus Concentration\)

The phosphorus concentration applied in the Calculator was calculated as the 25th quantile of all observed concentrations relative to dry mass load data compiled by the University, which was found to be statistically different based on the season collected. The phosphorus concentration applied for the fall leaf collection season is 857.0 mg/kg, and for the non-fall collection season is 413.6 mg/kg.

Seasonally derived phosphorus concentration calculated from the University sampling dataset
Season 25th Quantile Phosphorus Concentration from Mass (mg/kg)
Fall leaf collection 857.0
Non-fall collection 413.6

If percent organic matter is measured along with sweeper dry mass data, the phosphorus concentration applied by the Calculator is a function of percent organic matter rather than a function of season collected.

Eq. 2 \( Phosphorus Concentration = 0.044+0.0018 * Percent Organic Matter \)

Information: The user should enter either the dry mass or percent organic matter into the calculator, but not values for both

Option 2: Wet Mass Data

For inputs of sweeper wet mass data, the load of phosphorus removed from the sweeping event is a function of the phosphorus concentration and a conversion of the wet mass to an approximate dry mass.

Eq. 3 \( Dry Mass = (Wet Mass * 100) ⁄ (Percent Moisture + 100) \)

If dry basis moisture content is known, it may be input in the equation above, otherwise a seasonally averaged dry basis moisture content developed from the University dataset is applied.

Seasonally derived phosphorus concentration calculated from the University sampling dataset
Season Average Percent Moisture (%)
Fall leaf collection 90.46
Non-fall collection 27.76

If the percent organic matter of the wet mass is known, the phosphorus concentration as a function of percent organic matter (see Equation 2), otherwise seasonally dependent concentrations are applied.

Option 3: Miles Swept Data

If there is no mass data collected and the only available data is miles swept, the Calculator approximates phosphorus load reduction as a function of areal removal determined using P8 model results. This option is the least precise method as the actual dynamics associated with street sweeping may vary widely (e.g., sweeper type, parking on the route, time of year, frequency of sweeping). Tetra Tech obtained sweeping route information from the University and applied the P8 model to the sweeping frequencies and routes for a 10-year period to capture varying precipitation conditions. The results of the modeling effort are detailed in full in a separate memorandum.

The Calculator calculates phosphorus removal from miles swept as a function of areal phosphorus removal, and area swept.

Eq. 4 \(Phosphorus Removed=Length Swept×Sweeper Width×Areal Phosphorus Removal \)

The 25th quantile statistic of areal phosphorus removal is 0.00017 pounds per acre per pass as calculated from all P8 modeling data and routes simulated. The area swept is calculated using an average assumed street sweeper width of 8.5 feet, although it should be noted that the vast amount of sediment removal from street sweepers occurs directly along the curb and gutter.

The P8 model used to calculate the phosphorus removal rate relied on MPCA recommended default values for particle fraction size distribution and total suspended solids concentrations and results in a substantially lower removal rate that the other methods.

References