Examples for completing the TMDL reporting form
Revision as of 15:23, 28 January 2015 by Jstock (talk | contribs) (→‎City A)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Examples for completing the TMDL reporting form

This site is currently undergoing revision. For more information, open this link.
This site is under construction. Anticipated completion date is early January, 2015.

List of BMPs included in this example section. The BMPs are from the dropdown list in Column E of the BMP-activities completed tab of the TMDL spreadsheet.

This page provides step-by-step examples on how to fill out the four required tabs in the Commissioner-approved Total Maximum Daily Load (TMDL) Form. These are the BMP-Activites completed tab, the Cumulative reductions tab, the "Category 3 BMPs- Activities" tab, and the Adaptive management strategy tab. (Note: the terms "tab" and "worksheet" are used interchangeably. Tabs are individual Microsoft Excel worksheets and are displayed at the bottom of an Excel spreadsheet.)

Permittees are not required to report on every Best Management Practice (BMP) or activity that has been implemented, but instead just on those BMPs or activities that are being applied to applicable TMDL Wasteload Allocations (WLAs). Each BMP contained in the dropdown box of column E of the BMP-Activities completed tab will be covered in the examples. Please become familiar with the Guidance for completing the TMDL reporting form before continuing on with the examples.

In order to complete the TMDL form, it is important that the permittee have a means to

inventory BMPs applicable to TMDL WLAs
define the watersheds of applicable TMDLs;
plot structural BMPs within their jurisdiction, and
determine which BMPs are treating discharges to which impaired waters.

This information is necessary to determine which BMPs or activities can be applied to specific TMDLs. TMDL reports provide maps and acreages for TMDL study areas. Shapefiles of TMDL study areas can be found at [1]. Permittees are required to develop maps showing locations of structural BMPs, so this information should already exist. By overlaying the TMDL study areas on the map containing structural BMPs, permittees can determine which BMPs can be applied to specific TMDLs. For BMPs and activities that are not mapped, permittees will have to determine if the BMP or activity lies within a particular TMDL study and therefore can be applied to that TMDL.

This type of information is provided in the hypothetical scenarios and figures shown below. The subsequent sections will demonstrate how to take that information and translate it to the TMDL form.

Scenario 1: Metro Watershed WRAPS

Map 1 - BMPs requiring estimated reductions (Category 1)

Map 2 - BMPs not requiring estimated reductions (Category 2)

This example set uses Maps 1 and 2, which appear on the left and right hand side of the page. Each map covers the same area and the same TMDLs. Map 1 depicts BMPs that require estimated cumulative reductions (Category 1 BMPs) and Map 2 depicts BMPs that do not (Category 2 BMPs)(see cumulative reductions section for more information). Additional Category 2 BMPs that cannot be mapped as points, such as education and street sweeping, are not shown on the maps but are included in the examples below.

The example covers a theoretical Twin Cities Metro Area TMDL called the Metro Watershed WRAPS, with four MS4 permittees (City A, City B, City C, and MS4 College) and four impaired waters (the examples do not cover protection aspects of a WRAPS because they are not subject to NPDES permitting requirements). The following TMDLs have been completed to address the impairments:

Lake 1: Phosphorus
Lake 2: Phosphorus
Lake 3: Phosphorus
Metro Watershed WRAPS: TSS (Stream 1)
Metro Watershed WRAPS: E. coli (Stream 1)

Information: Note: For the examples, we assume the baseline year for each of the five TMDLs is 2010.

BMP-Activities completed worksheet

This is the portion of the TMDL form where information on all completed BMP/activities resulting in a reduction in pollutant loading, and that apply to an approved TMDL WLA/s must be provided.

City A

Summary of BMP/activities City A has implemented toward reducing pollutant loads for TMDLs.
a INF1 and MD2 were constructed as a joint project between City A and City B
b These BMPs do not appear on the maps because they are not associated with a discrete location
c SR1 is owned by MS4 College, but City A contributes to maintenance (note that shared responsibility of maintenance can constitute a partnership between MS4s but continued maintenance of BMPs is a core permit requirement and cannot be used to demonstrate progress on a yearly basis)

In this example we included information for a second year of reporting (2015) and a theoretical compliance schedule submitted by City A at the time of application (Part III.E.3).

City A has been assigned WLAs for three TMDLs included in the Metro Watershed WRAPS project.

Lake 1: Phosphorus
Lake 2: Phosphorus
Lake 3: Phosphorus

As noted in the previous section, the baseline year for each TMDL is 2010. Since the baseline, City A has implemented 14 BMPs and activities that can be credited as progress toward achieving one or more applicable WLA. The table to the left illustrates to which TMDL and Category each BMP can be credited. See Map 1 for location of Category 1 BMPs and Map 2 for location of Category 2 BMPs (location information for Category 2 BMPs is not required for TMDL reporting but is included for purposes of the example). There are four BMPs (employee education, establish ordinance, public education, and street sweeping) listed under Category 2 that are not located on maps because they cannot be associated with a single point within the watershed (i.e. they are applied over broad areas). One Category 3 BMP, a feasibility study for a rain garden retrofit, is listed in the table but will not be included in the BMP-Activities completed tab. Category 3 BMPs constitute progress, which meets the permit requirement for a given year, but cannot be associated with a reduction in pollutant loading. These activities will remain in the Category 3 BMPs-Activities worksheet for the duration of the permit term.

Schematic showing how information for one BMP, in this case INF1, would be input to the TMDL form by City A. Click on image for full sized version of the image.

The schematic to the right illustrates how data are entered for one BMP, INF1 (see Map 1 for location of INF1). The first entry is the Reporting Year, which is selected from a dropdown list in Column D. For this example, the permittee selects 2014. Cells A through C are autofilled once the reporting year is selected. The permittee then enters data in Columns E through M (Column F is optional). Because INF1 is a structural BMP, the geographic coordinates (x and y location coordinates) must be entered as well as the type of coordinate system used. Columns N and O are optional. Once the information for INF1 is entered, the permittee selects all the TMDLs to which the BMP is applied. This starts in Column Q. Once completed, the permittee moves on to the next row where the next BMP and associated information are entered. City A would continue this process until all 14 BMPs have been translated to the BMP-Activites completed worksheet.

When completed, City A's BMP-Activites completed worksheet for 2014 may look similar to the following screenshot.

screenshot of completed BMP-activities tab

Screen shot of City A's completed BMP-activities completed worksheet for the 2014 Annual Report. The worksheet includes 6 Category 1 BMPs (depicted on Map 1), 4 Category 2 BMPs (depicted on Map 2), and 4 Category BMPs not depicted on a map. Note the 4 Category 2 BMPs not depicted on a map are applied across the entire city and can therefore be applied toward each of the three TMDLs.

For purposes of this example, assume the screenshot below is the compliance schedule submitted by City A at the time of application. Two of the three BMPs with a 2014 implementation date appear in the BMP-Activities completed worksheet to the right for the first reporting year. The third BMP, the "Raingarden retrofit assessment", will remain in the Category 3 BMPs-Activities worksheet for the duration of the permit term. See the Category 3. Non-implemented Activities (Reported in Category 3 BMPs - Activities tab) section of the guidance for the definition of a Category 3 activity.

screen shot of City A compliance schedule

Screen shot of City A's compliance schedule submitted at the time of permit application. All BMPs listed in this spreadsheet must be included in the Category 3 BMPs-Activities worksheet until the reporting year in which it was fully implemented. At that time, the BMP will be translated to the BMP-activities completed worksheet. Note that BMPs fully implemented in the first annual reporting year (2014) and that achieve a reduction in pollutant loading (Category 1 and Category 2 BMPs), do not appear in the Category 3 BMPs-Activities worksheet.

For this example, assume the screenshot below illustrates what City A's BMP-Activities completed worksheet looks like in 2015. The highlighted record is the only BMP added to the worksheet because it was the only BMP fully implemented by City A in 2015. This BMP was included in the permittee's compliance schedule as "Implement raingarden retrofit". Note this BMP was scheduled for implementation in 2015 and is a retrofit of an existing BMP (INF1). The BMP was reported in the Category 3 BMPs-Activities worksheet for the 2014 Annual Report but was completed in 2015, and therefore translated to the BMP-Activities completed worksheet in the 2015 Annual Report. See the Category 3 BMPs-Activities worksheet section of this document for screen shot examples.

No record should be altered from a previous reporting year. Thus, the entry for INF4 will not be modified. The "BMP improvement enhancement retrofitting" category from the dropdown list in Column E, accompanied by an explanation in Column O, will be sufficient since this is not a new BMP but instead an enhancement of an existing BMP. If a unique situation presents itself, contact MPCA Stormwater staff for further guidance.

screenshot of BMP-activities completed tab for the year 2015

Screen shot of City A's completed BMP-activities completed worksheet for the 2015 Annual Report. Note that only one BMP was added. This BMP was an enhancement of an existing BMP (INF1). The original entry for INF1 is not modified; instead, the retrofit is included as a new BMP for the 2015 reporting year.

City B

Schematic showing the BMPs-activities implemented by City B that can be applied to one or more TMDL WLAs. Note that all four BMPs-activities belong to Category 2. FIL1, which is a structural BMP, cannot be claimed as a Category 1 BMP because it is within the jurisdiction of another regulated MS4 (MS4 College). BMPs marked with the superscript ^a do not appear on the maps because they are not associated with a discrete location.

City B has been assigned WLAs for two TMDLs in the Metro Watershed WRAPS project:

Lake 1: Phosphorus
Lake 2: Phosphorus

Since the baseline of the TMDLs (2010), City B has implemented four BMP/Activities that can be credited as progress toward achieving an applicable WLA. As depicted on Map 1, no structural BMPs are constructed within City B's jurisdiction. However, City B has collaborated with other MS4 permittees on the following projects:

provided funding to MS4 College on FIL1 for the Lake 1: Phosphorus TMDL; and
shares responsibility with City A for maintenance of MD2.

City B may also record their supplemental street sweeping program because they do sweeping within the Lake 1 and Lake 2 watersheds. They may also take credit for eliminating an illicit discharge. Note that all these BMPs/activities must have been implemented since 2010, the baseline year. For example, street sweeping may have been implemented prior to 2010, but enhancements to the existing street sweeping program would qualify as a Category 2 BMP.

All BMPs implemented by City B are recorded as a Category 2 reduction unless the permittee can reasonably demonstrate an appropriate method for quantifying it in Category 1.

The permittee enters information for each of the four BMPs/activities as described above for City A. The screenshot below is an example of how the BMP-Activities completed worksheet may look when complete.

screenshot of completed worksheet for City B

Screen shot of City B's completed BMP-activities completed worksheet for the 2014 Annual Report. Note in rows 4 and 6, columns L and M, that partnerships with the MS4 College and City A are indicated.

City C

Summary of BMPs and activities implemented by City C and that can be applied toward on or more TMDL WLA.

City C has been assigned WLAs for all five TMDLs included in the Metro Watershed WRAPS project:

Lake 1: Phosphorus
Lake 2: Phosphorus
Lake 3: Phosphorus
Metro Watershed WRAPS: TSS (Stream 1)
Metro Watershed WRAPS: E. coli (Stream 1)

Since the 2010 baseline of the TMDLs, City C has implemented eleven BMPs that can be credited as progress toward achieving an applicable WLA. these are summarized in the table to the right. Note that several BMPs are applied to more than one TMDL (e.g. the swale, S2, is applied to the Lake 3 TMDL and the two stream impairments). As with City A and City B, City C implements BMPs that cover their entire jurisdictional area (e.g. employee education) and these BMPs can be applied to all five impairments.

in this example, Maps 1 and 2 do not show the watershed boundaries for the impaired stream. The City will have to determine those boundaries prior to determining if BMPs can be applied to the stream impairments. The City must also determine if a particular BMP will actually reduce pollutant loads. For example, swales typically are ineffective at removing bacteria. the swale included in the worksheet may have been designed such that bacteria will be removed. However, if that is not the case, the BMP should not be applied to the bacteria TMDL.

The screenshot below is an example of how the BMP-Activities completed worksheet may look when complete.

screen shot of BMP-activities tab for City C

Screen shot of City C's completed BMP-activities completed worksheet for the 2014 Annual Report. Note that several BMPs and activities apply to multiple TMDL WLAs.

MS4 College

Summary of BMPs implemented by MS4 College that can be applied toward TMDL WLAs. SR1 is owned by MS4 College, but City A contributes to maintenance. City A therefore also claims this as a Category 2 credit. Similarly, City B contributed funding to INF1 and thus claimed a Category 2 credit on their form.

MS4 College has been assigned a WLA for one TMDL included in the Metro Watershed WRAPS project:

Lake 1: Phosphorus

Since the 2010 baseline of the TMDL, MS4 College has implemented five BMPs that can be credited as progress toward achieving an applicable WLA. The table to the right illustrates the category applicable for each BMP and activity. Note that MS4 College is located entirely within the jurisdiction of City A. This provides a unique partnership opportunity for the two MS4 permittees. As a result, the two have an agreement in place for City A to perform street sweeping on campus. Each permittee can therefore claim a Category 2 credit. MS4 College, however, indicates on its form that City A is the owner/operator of this BMP.

BMP FIL1 is owned and operated by MS4 College. City B claimed a category 2 credit for this BMP because it contributed funding for the BMP, but only MS4 College can claim this as a Category 1 BMP because it occurs within their jurisdiction.

The screenshot below is an example of how the BMP-Activities completed worksheet may look when complete.

screen shot of BMP-activities tab for MS4 College

Screen shot of MS4 College's completed BMP-activities completed worksheet for the 2014 Annual Report.

Cumulative reductions worksheet

This is the portion of the TMDL report form that the permittee will report the cumulative reduction achieved for each TMDL WLA. See the cumulative reductions section of the guidance for information on each of the reporting categories.

Information: Though not required to be provided with each annual report, MS4 permittees are strongly advised to keep detailed records on production of Category 1 reductions (methodology, input values, etc.).

City A

The screenshot below illustrates how the cumulative reductions worksheet should look for City A for 2014. City A chose to estimate load reductions using the MPCA estimator. Details for how this tool was used can be found in the guidance and examples for using the MPCA Simple Estimator.

screen shot of MPCA estimator with cumulative reductions worksheet

Screen shot showing the 2014 Cumulative reductions worksheet and MPCA estimator calculations for City A.

The following screenshot is an example of City A's 2015 cumulative reductions submission. It is very similar to what was submitted for 2014 because only one BMP was implemented, that being the retrofit of INF1. This record was labeled as "Implement raingarden retrofit" in the 2014 cumulative reductions worksheet (row 23) and because the project was completed in 2015, it has been translated to the BMP-Activities completed worksheet to show the interim milestone has been fully implemented. This update is also reflected in Category 3, which is illustrated in the following section (Category 3 BMP-Activities worksheet).

Because the implemented BMP improved the pollutant reduction capability of an existing structural BMP, INF1, it can be quantified in Category 1. Prior to the retrofit, INF1 treated 2 acres of Residential-medium density. Assuming the retrofit doubled the area treated by INF1 for the same land use, the cumulative reduction reported in 2015 for the Lake 2: Phosphorus TMDL would increase from 2.004 pounds to 4.008 pounds.

screen shot of 2015 cumulative reductions worksheet

Screen shot showing 2015 Cumulative reductions worksheet for City A.

City B

City B had implemented no structural BMPs within its' jurisdiction from the baseline to the first year of reporting. All reductions are therefore reported as Category 2 and would appear as follows in the screenshot below.

screen shot of 2014 cumulative reductions worksheet

Screen shot showing Cumulative reductions worksheet for City B.

City C

City C had implemented a variety of BMPs from the baseline of the TMDL to the first year of reporting. Similar to City A, reductions have been reported in both Category 1 and 2. Category 1 reductions were calculated using the MPCA estimator and examples of its use can be found in the guidance and examples for using the MPCA Simple Estimator.

Screen shot showing 2014 Cumulative reductions worksheet for City C.

MS4 College

MS4 College had implemented a variety of BMPs from the baseline of the TMDL to the first year of reporting. Reductions have therefore been reported in both Category 1 and 2. Category 1 reductions were calculated using the MPCA estimator and examples of its use can be found in the guidance and examples for using the MPCA Simple Estimator.

Screen shot showing 2014 Cumulative reductions worksheet for MS4 College.

Category 3 BMPs-Activities worksheet

This is the portion of the TMDL form that must contain planned BMPs that have not yet been implemented but were submitted as a part of the compliance schedule in the MS4 Permit TMDL Attachment spreadsheet at the time of application. This Category will also store records that constitute progress but do not achieve a reduction (e.g. planning, feasibility studies, acquisition of funding, etc.). This section will only cover an example for City A.

City A

The screen shot below illustrates the Category 3 BMPs-Activites worksheet for 2014. This contains all but two of the BMPs ("Permeable pavement with no underdrain" and "Increased street sweeping") from the compliance schedule screen shot in the BMP-Actvities completed section for City A. Those BMPs have been translated to the BMP-Activities completed because they were fully implemented in 2014. You will notice that one activity ("Feasability study - Raingarden retrofit assessment") fully implemented in 2014 remains in the Category 3 worksheet. This is because it does not receive credit for a reduction in pollutant loading but does demonstrate that the permittee is making progress.

The following screen shot illustrates the Category 3 BMPs-Activities worksheet for 2015. This submission will contain all the BMPs from the previous year except for the highlighted record ("Implement raingarden retrofit"). This has now been translated to the BMP-Activities completed worksheet because it was the only additional BMP fully implemented in 2015. This process will continue for the duration of the permit term.

Screen shot illustrating City A's Category 3 BMPs-Activites worksheet for 2014

Screen shot illustrating City A's Category 3 BMPs-Activites worksheet for 2015

Adaptive management worksheet

Refer to the Adaptive Management Strategy section of the guidance for an example on how to fill out this portion of TMDL form.

Scenario 2: Big River TMDL

Map 3 - Structural BMPs

Map 4 - AUIDs

This example covers an outstate area TMDL, the Big River TMDL, with one MS4 Permittee (City D). Maps 3 and 4, which appear on the left and right hand side of the page, will be used to aid the discussion. Each map covers the same area but Map 3 depicts structural BMPs and Map 4 depicts the six AUIDs (Assessment Unit ID, or different stream reaches) included as a part of the example.

For ease of reporting, the Permittee is allowed to report on groupings of WLAs within the same report. Stream TMDLs will therefore be labeled by TMDL Project Name + Pollutant. In this example, the Permittee has been assigned TSS and E. coli WLAs on each of the six stream reaches in the Big River TMDL project (6 TSS TMDLs and 6 E.coli TMDLs). These will be grouped into two TMDLs to report on:

Big River TMDL: TSS
Big River TMDL: E. coli

Information: Note: For the sake of the example, we will assume the baseline year for each of the TMDLs is 2005.