|
|
| (99 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| − | {{alert|This site is under construction. Anticipated completion date is early January, 2015.|alert-under-construction}}
| |
| | | | |
| − | This User Guide is intended to assist Municipal Separate Storm Sewer System (MS4) Permittees in the completion of the Commissioner-approved [[Upload page with TMDL forms|TMDL Annual Reporting Form]] (TMDL Form). | + | {{alert|This guidance is for Phase II MS4 permittees (i.e., those covered under the 2020 MS4 General Permit). Phase I MS4 permittees should refer to [[Phase I MS4 Guidance for completing the TMDL Annual report form]].|alert-danger}} |
| | + | {{alert|The MPCA is in the process of developing a new e-service for both the Phase II MS4 annual report and the TMDL annual report. There will be no TMDL Annual Report submission in calendar year 2023 for Phase II MS4 permittees (i.e., those covered under the 2020 MS4 General Permit). |alert-danger}} |
| | | | |
| − | Quickguides have been created for two of the worksheets in the form.
| + | ==Purpose of the TMDL Annual Report== |
| − | #[[Quick Guide: BMP-Activities completed tab]]
| + | If you (an MS4 Permittee covered under the 2020 MS4 General Permit) are assigned one or more [[Glossary#W|Wasteload Allocation]] (WLA) in a [[Glossary#T|Total Maximum Daily Load]] (TMDL) that was approved by the United States Environmental Protection Agency (USEPA) prior to November 16, 2020, and were not meeting the WLA(s) when you applied for permit coverage, you must complete the TMDL Annual Report to demonstrate progress toward meeting the WLA(s). |
| − | #[[Quick Guide: Cumulative reductions tab]]
| |
| | | | |
| − | ==A note on terminology== | + | ==E-service TMDL Annual Reporting for Phase II MS4 permittees== |
| − | *The TMDL form is a Microsoft Excel file. A Microsoft Excel file or spreadsheet file refers to the entire Excel document. An Excel file may contain one or more worksheets or spreadsheets.
| + | The MPCA is in the process of developing a new e-service for both the MS4 annual report and the TMDL annual report. There will be no TMDL Annual Report submission in calendar year 2023. Permittees will be expected to report on 2022 activities once the e-service is operational. |
| − | *We use the term worksheet to refer to a single sheet within the Excel file.
| |
| − | *A workbook includes all the worksheets in an Excel file. The TMDL form includes 9 worksheets, 5 of which are visible when first opening the Excel file.
| |
| − | *A worksheet tab refers to the tab at the bottom of the Excel file. You will see 5 worksheet tabs when opening the form. Four worksheet tabs are hidden but can be made visible.
| |
| | | | |
| − | ==Purpose of the TMDL Annual Report form== | + | === Permit Requirements related to TMDLs=== |
| − | If you are assigned a [[Glossary#W|Wasteload Allocation]] (WLA) in a [[Glossary#T|Total Maximum Daily Load]] (TMDL) that was approved by the United States Environmental Protection Agency (USEPA) prior to August 1, 2013, and were not meeting that WLA(s) when you applied for permit coverage, you must complete this form to demonstrate progress toward meeting those WLA(s).
| + | *[[Summary of TMDL requirements in stormwater permits]] |
| | + | *'''''NEW''''' The list of best management practices (BMPs) or activities that will be considered as progress toward meeting wasteload allocations (WLAs) for Total Maximum Daily Loads can be found in this spreadsheet: [[File:2020_MS4_General_Permit_BMP_List_for_Manual_April2023.xlsx]] |
| | | | |
| − | Submission of this form fulfills the [[MS4 PART III.STORMWATER POLLUTION PREVENTION PROGRAM (SWPPP)#E. Discharges to Impaired Waters with a USEPA-Approved TMDL that Includes an Applicable WLA|permit requirement]] (Part III.E) to demonstrate continuing progress toward achieving WLAs . This is achieved by including information on one or more of the following in the TMDL Form.
| + | Until the e-service is operational, permittees should keep track of the following: |
| − | *An inventory of [[Glossary#S|structural stormwater BMPs]] and non-structural (e.g. establish ordinance, education and outreach, illicit discharge elimination, etc.) BMPs within the watershed tributary to the impaired water. To determine watershed boundaries [http://www.pca.state.mn.us/index.php/water/water-types-and-programs/minnesotas-impaired-waters-and-tmdls/tmdl-projects/tmdl-projects-and-staff-contacts.html#approved see the specific TMDL report] or [http://www.pca.state.mn.us/index.php/water/water-types-and-programs/minnesotas-impaired-waters-and-tmdls/maps-of-minnesotas-impaired-waters-and-tmdls.html retrieve shapefiles] from the MPCA.
| |
| − | *An estimate of annual cumulative pollutant load reductions for certain structural BMPs.
| |
| − | *A summary of the number of BMPs or activities implemented and applied to an [[Glossary#A|applicable WLA]].
| |
| − | *A description of planned and in-progress BMPs and other pollutant management strategies that have not yet been implemented.
| |
| | | | |
| − | ==TMDL requirements in stormwater permits== | + | ====For Total Phosphorus, Total Suspended Solids, and Oxygen Demand WLAs not being met or requiring further analysis at time of the 2020 MS4 general permit application submittal==== |
| | + | *Updates on BMPs included in the compliance schedule submitted by the permittee as part of the application for the 2020 MS4 general permit |
| | + | *Implemented BMPs for each applicable WLA since the Total Maximum Daily Load (TMDL) baseline year, including: |
| | + | **BMP type, BMP subtype (see [https://stormwater.pca.state.mn.us/index.php?title=File:2020_MS4_General_Permit_BMP_List_for_Manual_April2023.xlsx list here]), year when BMP was implemented and associated TMDL. <!--(and BMP status see TMDL annual report webpage for more information)--> |
| | + | *Additionally, for constructed basins, filtration, infiltration, stormwater reuse BMPs: |
| | + | **Any MS4 permittee partners for that practice |
| | + | **Location (i.e., geographic coordinates) |
| | + | **Quantitative pollutant reductions per BMP |
| | + | *For street sweeping and chemical treatment of stormwater practices: |
| | + | **Quantifying reductions is optional |
| | | | |
| − | Specific language that requires MS4 Permittees to submit progress towards meeting a WLA is contained in [[MS4 PART III.STORMWATER POLLUTION PREVENTION PROGRAM (SWPPP)#E. Discharges to Impaired Waters with a USEPA-Approved TMDL that Includes an Applicable WLA|Part III.E of MPCA Permit No: MNR040000]], effective August 1, 2013. Requirements include SWPPP development and Annual Reporting.
| + | ====For chloride TMDLs==== |
| | + | *Amount of deicing salt used each winter maintenance season |
| | + | *Certify completion of an annual winter maintenance assessment |
| | + | **[[Guidance for meeting chloride TMDL MS4 permit requirements]] |
| | | | |
| − | ===SWPPP Development=== | + | ====For temperature TMDLs==== |
| − | All MS4 Permittees that manage a stormwater discharge to an impaired water with a TMDL approved by the USEPA prior to August 1, 2013, have incorporated information for each applicable WLA in their SWPPP documents, as required in [[MS4 PART II. APPLICATION REQUIREMENTS#D. Stormwater Pollution Prevention Program (SWPPP) Document|Part II.D.6 of MPCA Permit No: MNR040000]], effective August 1, 2013.
| + | *Status of temperature management plan |
| | + | **[[Guidance for meeting temperature TMDL MS4 permit requirements]] |
| | + | ====For bacteria TMDLs==== |
| | + | *Status of inventory and prioritization plan |
| | + | **[[Guidance for meeting bacteria TMDL MS4 permit requirements]] |
| | | | |
| − | ===Annual Reporting Schedules=== | + | ==Anticipated changes== |
| − | Permittees with applicable WLAs shall submit the TMDL Form along with the MS4 Annual Report to the MPCA by June 30th of each calendar year, beginning in 2015. Additional information regarding the MS4 General Permit schedule and the SWPPP Submittal Schedule can be found in [[MS4 APPENDIX A: SCHEDULES|Appendix A of the MS4 General Permit]] and on the [http://www.pca.state.mn.us/index.php/water/water-types-and-programs/stormwater/municipal-stormwater/annual-reports-for-municipal-separate-storm-sewer-systems-ms4.html MPCA’s MS4 Annual Report] web page.
| + | If you submitted TMDL Annual Reports under the 2013 MS4 General Permit, there will be some changes to the BMP categories and types (herein referred to as the BMP list). |
| | + | The draft BMP list can be [https://stormwater.pca.state.mn.us/index.php?title=File:2020_MS4_General_Permit_BMP_List_for_Manual_April2023.xlsx found here]. The BMP list is the naming convention for different BMPs and is important for consistency in annual reporting. Using the BMP list will help you be prepared to easily enter and label BMPs to demonstrate progress towards achieving applicable WLAs in the new annual report e-service. |
| | | | |
| − | ==TMDL Annual Report form== | + | ==Questions?== |
| − | Each Permittee will have a custom TMDL Form created by the MPCA that lists WLAs affecting the Permittee. All WLAs applicable to a Permittee may not be included in the form. There are two scenarios in which this may occur:
| + | Refer to your submitted Custom TMDL Application if you are unsure of which TMDL WLAs need to be reported on, or reference this [https://stormwater.pca.state.mn.us/index.php?title=File:2020_MS4_WLA_List_with_App_info_Manual.xlsx list]. Contact [mailto:anna.bosch@state.mn.us Anna Bosch] with questions. |
| − | *When the TMDL report explicitly states no reduction in pollutant loading is needed for an MS4 WLA, that WLA will not be included in the TMDL Annual Report Form.
| |
| − | *When the Permittee has stated they are meeting a WLA at the time of application, that WLA will not be included in the TMDL Annual Report Form.
| |
| | | | |
| − | {{alert|In the Annual Report Form, TMDL WLAs are expressed differently depending on the type of receiving water.
| + | For more information about the non-TMDL portion of the MS4 annual report, visit the [https://stormwater.pca.state.mn.us/index.php/MS4_Annual_Report MS4 annual report webpage.] |
| − | *Lake TMDLs: Will be labeled by Waterbody + Pollutant.
| |
| − | *Stream TMDLs: 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. For example, if the Permittee has TSS WLAs on four stream reaches in a single project, these will be grouped into one TMDL to report on. If the Permittee has been assigned WLAs for bacteria on the same four stream reaches in the same project, the Permittee would have two TMDLs to report on. Note that a Permittee may request to have the form customized to allow for individual reach reporting, however, the grouping convention will be the default.|alert-info}}
| |
| | | | |
| − | The MPCA will not modify and resend the TMDL Form during the current permit cycle (effective through July 31, 2018). The Permittee will therefore be responsible for maintaining the TMDL Form. The same form will be updated by the Permittee throughout the permit cycle. The Permittee will submit the form each annual reporting year, starting with the 2014 Annual Report. The MPCA will maintain copies of all submitted files.
| |
| | | | |
| − | The TMDL Form is an Excel workbook that includes eight (9) color coded tabs (worksheets):
| + | [[Category:Level 3 - Regulatory/Municipal (MS4)/TMDLs]] |
| − | *Green tabs include worksheets in which the User will enter specific information. These tabs must be completed by the Permittee.
| + | [[Category:Level 2 - Regulatory/Municipal (MS4)]] |
| − | *Blue tabs are worksheets that track optional information for each User.
| + | [[Category:Level 3 - Regulatory/Municipal (MS4)/Guidance, outreach materials, miscellaneous information]] |
| − | *Yellow tabs contain reference lists and values used to help populate the information in the green tabs or in the MPCA Estimator.
| |
| − | *Some of these tabs will are hidden and may be accessed, if needed, by navigating to Home->Cells->Format->Hide & Unhide->Unhide Sheet
| |
| − | *A brief description of each worksheet is given below.
| |
| − | | |
| − | '''Spreadsheet user information''' (Blue Tab) is an optional worksheet that contains general information for the User. The MPCA recommends that Permittees keep this sheet updated as a means of tracking entries into the TMDL Form.
| |
| − | | |
| − | '''BMPs-Activities completed''' (Green Tab) is a '''required''' worksheet. The User enters data related to specific BMPs or activities that were completed during the reporting period (January 1 - December 31 of the year prior to form due date or since baseline for the first year of reporting) and that are applied to meeting an applicable WLA. BMPs/activities are associated with each applicable TMDL WLA.
| |
| − | | |
| − | '''Cumulative reductions''' (Green Tab) is a '''required''' worksheet. The User enters data regarding the estimated pollutant load reduction(s) resulting from implementation of BMPs/activities and information on BMPs/Activities being applied to applicable WLAs.
| |
| − | | |
| − | '''Category 3 BMPs-Activities''' (Green Tab) is a '''required''' worksheet. The User enters data regarding non-implemented activities.
| |
| − | | |
| − | '''Adaptive management strategy''' (Green tab) is a '''required''' worksheet. The User provides a narrative describing any adaptive management strategies used for making progress toward achieving each applicable WLA.
| |
| − | | |
| − | '''List of TMDLs''' (Yellow Tab) is a reference worksheet, which contains a list of all the TMDLs in Minnesota with MS4 stormwater WLAs approved by the USEPA before the effective date of the MS4 General Permit, August 1, 2013. The MPCA is responsible for maintaining this information. The User cannot edit this information.
| |
| − | | |
| − | '''MPCA estimator''' (Blue Tab) is an optional User input tab that allows the User to estimate the cumulative reduction (mass or percent removal) of a pollutant of concern achieved by implementation of BMPs. The reductions calculated here can be used when entering information into the quantitative reductions portion of the Cumulative reductions tab ([[Guidance and examples for using the MPCA Estimator]]).
| |
| − | | |
| − | '''Input values for the MPCA estimator''' (Yellow Tab) contains the information used in the MPCA estimator worksheet. Information here is based on literature reviews and therefore general in nature and may not accurately reflect the User site conditions. Therefore, the User is encouraged, as much as is possible, to use their own site data to fill in the cells in the MPCA estimator worksheet.
| |
| − | | |
| − | '''Dropdown lists''' (Yellow Tab) contains a list of the inputs for the dropdown lists found in the BMPs-Activities completed and Cumulative reductions worksheets. The MPCA is responsible for maintaining this tab. The User cannot edit this information.
| |
| − | | |
| − | [[file:Spreadsheet user information tab.png|300px|thumb|alt=screen shot of User information tab|<font size=3>Screen shot of the TMDL Annual Report Form User information tab.</font size>]]
| |
| − | | |
| − | ===Spreadsheet User information tab===
| |
| − | The tab titled ''Spreadsheet user information'' contains an optional worksheet that can be used to track the most current version of the form. There are two boxes contained in this worksheet.
| |
| − | *'''Form Information''' describes the TMDL Form and tracks the dates when the form was created by the MPCA. Cells containing the Permittee name and Permit ID are locked and cannot be edited.
| |
| − | *'''User Information''' allows MS4 Permittees to track dates pertaining to submission of the TMDL Form. Users should note that the MPCA will fill in the Permittee Name and Permit ID but the Permittee can indicate the most recent update in this part of the TMDL Form. These cells will be locked and should not be changed by the MS4 Permittee.
| |
| − | | |
| − | ===BMPs-activities completed worksheet===
| |
| − | The worksheet tab called BMP-Activities completed is used to record compliance with the requirement to demonstrate continuing progress towards meeting applicable WLAs. The Permittee is only required to report BMPs being applied toward applicable WLAs.
| |
| − | | |
| − | The content of this worksheet is shown in the two figures below. Grey cells are filled out by the MPCA and cannot be edited by the Permittee. White cells are MS4 User input cells. Brown cells are optional MS4 User input cells but are highly encouraged. Note that some of these white cells are optional or may be auto-filled depending on inputs in other white cells. Information required in this worksheet includes:
| |
| − | *Reporting year,
| |
| − | *BMP/Activity,
| |
| − | *BMP/activity owner, and
| |
| − | *TMDL WLA(s) to which the BMP/activity is being applied.
| |
| − | | |
| − | If the BMP chosen in Column E of the tab is a constructed basin, filter, infiltrator, or swale or strip, the User is required to enter, in columns H through K,
| |
| − | *BMP ID,
| |
| − | *y-coordinate,
| |
| − | *x-coordinate, and
| |
| − | *Coordinate system (e.g. lat-long, UTM).
| |
| − | | |
| − | If another BMP is entered in Column E, cells in Columns H through K will auto fill with “NA”. Optional information includes the year that the BMP was implemented and any additional notes. Detailed guidance on each of these columns can be found below.
| |
| − | | |
| − | ====Detailed guidance for completing the BMP-activities completed worksheet====
| |
| − | [[file:BMP activities completed tab 1.png|300px|thumb|alt=screen shot of BMP activities completed tab|<font size=3>Screen shot of the BMP-Activities completed tab, Columns A through M, of the TMDL spreadsheet.</font size>]]
| |
| − | | |
| − | [[file:BMP activities completed tab 2.png|300px|thumb|alt=screen shot of BMP activities completed tab|<font size=3>Screen shot of the BMP-Activities completed tab, Columns N and beyond, of the TMDL spreadsheet.</font size>]]
| |
| − | | |
| − | =====Column A – Entry ID=====
| |
| − | *Description: BMP line number. MPCA uses this ID for compiling data from all Permittees into a single database. The worksheet allows up to 1000 entries.
| |
| − | *Input: None
| |
| − | *Source of Information: The MPCA inputs this data.
| |
| − | | |
| − | =====Column B – Permittee=====
| |
| − | *Description: Name of the TMDL Permittee
| |
| − | *Input: None
| |
| − | *Source of Information: This cell autofills when a value is entered for reporting year (Column D)
| |
| − | | |
| − | =====Column C – MS4 ID=====
| |
| − | *Description: The MS4 ID number assigned to the Permittee by the MPCA
| |
| − | *Input: None
| |
| − | *Source of Information: This cell autofills when a value is entered for reporting year (Column D)
| |
| − | | |
| − | =====Column D – Reporting year=====
| |
| − | *Description: The reporting year in which the BMP or activity was implemented
| |
| − | *Input: Reporting year
| |
| − | *Source of Information: User
| |
| − | | |
| − | {{alert|If this is the first year using this form, BMPs should be entered for the previous calendar year and all prior years back to the baseline year of the TMDL. These records should all be reported as 2014 entries. Reports in subsequent years will accumulate any BMPs added in the reporting year (ex. The 2016 Annual report will show BMPs back to the baseline year, as well as those added in 2015. If a baseline year is not provided in the [[Forms and guidance for TMDLs#Guidance Documents#List of approved TMDLs with MS4 Wasteload Allocations|List of approved TMDLs with MS4 Wasteload Allocations]] the Permittee should use Best Professional Judgment to determine it or contact the MPCA. If Best Professional Judgment is used, the Permittee should be able to logically explain their conclusion.|alert-info}}
| |
| − | | |
| − | =====Column E – BMP/Activity=====
| |
| − | *Description: The type of BMP used or activity conducted
| |
| − | *Input: Dropdown
| |
| − | *Source of Information: The User selects the appropriate BMP from a dropdown menu contained in the cell. For the first year of reporting, this will include Category 1 and Category 2 BMPs in operation since the baseline year of the TMDL and indicated in the MS4 Permit TMDL Attachment Spreadsheet that was submitted at the time of permit application. Subsequent reporting years will include BMPs put into operation in the previous year. If a particular BMP/activity you implemented is not listed, open the Excel worksheet [[File:Cross-Reference list.xlsx]] to determine the appropriate selection from the dropdown list. If the BMP/activity is not listed in the reference list, use Best Professional Judgment or contact the MPCA.
| |
| − | | |
| − | {{alert|The BMP/Activities contained in the drop-down list is a short-list containing categories of BMPs. Users who are interested in referencing a more specific BMP name should enter that information in Column F or Column O.|alert-info}}
| |
| − | | |
| − | =====Column F – BMP Description (Optional)=====
| |
| − | *Description: Specific BMP/Activity description.
| |
| − | *Input: BMP or Activity name
| |
| − | *Source of Information: Dropdown list or User
| |
| − | | |
| − | =====Column G – Location and ID Information Needed?=====
| |
| − | *Description: A description of whether an ID and location information is needed for the BMP
| |
| − | *Input: None
| |
| − | *Source of Information: This cell autofills depending on the input for Column E. For structural BMPs (constructed basins, filter, infiltrator, swale or strip) this cell autofills with the statement "Complete columns H through K" and the User is required to fill in Columns H through K. If any other BMP is entered in Column E in this row, the cell autofills with the statement "No ID information needed" and the User is not required to fill in Columns H though K in this row.
| |
| − | | |
| − | =====Column H – BMP ID=====
| |
| − | *Description: ID Number assigned to the BMP by the Permittee or Owner
| |
| − | *Input: ID Number. The User will input data only if the BMP is a structural BMP (constructed basin, filter, infiltrator, swale or strip). If it is not, then the cell will auto fill with NA. If the BMP was included in the Permit TMDL Attachment Spreadsheet (your permit application), the ID Number must match the ID in the Permit TMDL Attachment Spreadsheet.
| |
| − | *Source of Information: User and MS4 Permit TMDL Attachment Spreadsheet. The permittee may have a database with ID numbers for BMPs. It is recommended that the permittee use the ID from their database for this field.
| |
| − | | |
| − | =====Columns I & J – Geographic Coordinates=====
| |
| − | *Description: Geographic coordinates for structural BMPs (constructed basin, filter, infiltrator, swale or strip)
| |
| − | *Input: x- and y-coordinates. The User will input data only if the BMP is structural. If it is not then the cell will auto fill with NA. For constructed stormwater ponds, x, y coordinates should match those submitted with the MS4 Pond, Wetland, and Lake Inventory Form (see [http://stormwater.pca.state.mn.us/index.php/MS4_PART_III.STORMWATER_POLLUTION_PREVENTION_PROGRAM_%28SWPPP%29#2._Inventory_.282009_Minnesota_Session_Law.2C_Ch._172._Sec._28.29. permit language]). Please enter in decimal degree format.
| |
| − | *Source of Information: User
| |
| − | | |
| − | {{alert|The permittee may have a database with geographic coordinates for BMPs. It is recommended the permittee use the coordinates from their database for this field. If the permittee has not determined coordinates for a BMP, it is recommended that BMP coordinates represent the centroid of the BMP. If the permittee has BMPs mapped as polygons, it is recommended they provide x,y coordinates at the approximate center of the polygon.|alert-info}}
| |
| − | | |
| − | {{alert|HOW DO I DETERMINE THE COORDINATES OF MY BMP IF I DON'T HAVE THEM?
| |
| − | | |
| − | If the permittee does not use a Global Positioning System (GPS) or mapping software, such as ArcMap, there are numerous tools on the Internet to determine location information. Examples include [http://maps.cga.harvard.edu/gpf/], [http://universimmedia.pagesperso-orange.fr/geo/loc.htm], [http://www.latlong.net/], as well as Google Earth.|alert-info}}
| |
| − | | |
| − | =====Column K – Coordinate System=====
| |
| − | *Description: The coordinate system used when measuring the x- and y-coordinates of the structural/quantifiable BMP
| |
| − | *Input: Dropdown with an option for the User to enter a different value. The User will input data only if the BMP is structural (constructed basin, filter, infiltrator, swale or strip). If it is not then the cell will auto fill with NA.
| |
| − | *Source of Information: User
| |
| − |
| |
| − | =====Column L – Who Owns this BMP/Activity?=====
| |
| − | *Description: Users will have three options to select from: Permittee (you), Other MS4 Permittee, or Other. The purpose of this data is to allow multiple Permittees to demonstrate progress using the same BMP/activity while providing MPCA a mechanism for avoiding double counting of a single BMP. Ownership is important to report for those situations where the Permittee and owner are different.
| |
| − | *Input: Dropdown
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Column M – If applicable name other owner(s)=====
| |
| − | *Description: Name of MS4 permittee that owns or co-owns a BMP that the Permittee reports as reducing the pollutant load associated with a WLA. For example, if you contributed funding to a BMP that is owned and operated by another permittee, you may include this BMP in this form but indicate who the owner is in this column.
| |
| − | *Input: Column M will autofill with NA (not applicable) when the user selects “Permittee (you)” or “Other” from the dropdown list of Column L. User should fill in the name of the BMP owner for only those BMPs that are owned, or co-owned by another MS4 permittee.
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Column N – Year when BMP was implemented (Optional)=====
| |
| − | *Description: The year in which the BMP/activity was implemented. This refers to the date when the BMP became operational.
| |
| − | *Input: Date
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Column O – Note(s) (Optional)=====
| |
| − | *Description: Any additional information that the User would like to enter into the spreadsheet to track progress, provide additional detail, etc. This is an optional input. Examples are shown in the Example TMDL Form.
| |
| − | *Input: Notes
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Columns Q and beyond – TMDL Project with TMDL WLAs=====
| |
| − | *Description: The number of columns for each MS4 form will be unique to the number of [http://www.pca.state.mn.us/index.php/water/water-types-and-programs/minnesotas-impaired-waters-and-tmdls/tmdl-projects/tmdl-projects-and-staff-contacts.html#approved USEPA-approved TMDLs] and WLAs applicable to the MS4 Permittee. The MPCA will insert the column headings specific to each MS4 Permittee. The listed projects may include multiple WLAs for the same receiving water and pollutant. For example, a TMDL report may include WLAs for different flow regimes and different reaches of the same river. These have been combined when appropriate to simplify the reporting process. The name of the TMDL Study is shown in the cell above each WLA for User reference.
| |
| − | | |
| − | :Permittees may wish to report on all discrete stream reaches or flow conditions for which they are assigned a WLA. If you wish to do this, contact the MPCA for a customized TMDL Form.
| |
| − | *Input: ‘X’ to designate a TMDL for which a unique BMP/activity is being applied.
| |
| − | *Source of Information: User
| |
| − | | |
| − | ===Overview of categories for Cumulative Reductions tab and Category 3 BMPs - Activities tab===
| |
| − | | |
| − | A BMP may only be reported in one of the three categories. While BMPs may move from one category to another between years, they may not be reported in more than one category in a single report.
| |
| − | | |
| − | ====Category 1 - Summary of quantitative reductions====
| |
| − | <div style="background-color: none; border-style: solid;">
| |
| − | *Use Category 1 if '''all''' of the following apply.
| |
| − | **Pollutant loadings from the BMP/activity can be estimated using an [[Dummy page#Estimation of pollutant load reduction for the Cumulative reductions tab|appropriate method]]
| |
| − | **The pollutant is phosphorus, TSS, fecal coliform, or E. coli
| |
| − | **The BMP/activity was constructed '''within your jurisdiction''' (upstream of your MS4's outfall)
| |
| − | **The BMP/activity was in operation the past year
| |
| − | *Recommend using Category 2 if the pollutant is chloride, but Category 1 may be used if you have detailed records and can justify your methodology.
| |
| − | </div>
| |
| − | | |
| − | | |
| − | The purpose of this category is to provide a quantitative estimate of the cumulative reductions in loading achieved for each TMDL WLA applicable to the permittee. This category should be used when reductions in pollutant loading are achieved by BMPs constructed '''within a permittee's jurisdiction''' and can be quantified using an [[Dummy page#Estimation of pollutant load reduction for the Cumulative reductions tab|appropriate method]] for one of the following pollutants.
| |
| − | *Total phosphorus
| |
| − | *Total suspended solids
| |
| − | *E. coli
| |
| − | *Fecal coliform
| |
| − | *Chloride – NOTE: The MPCA recommends that Permittees with chloride WLAs choose Category 2 for reporting.
| |
| − | | |
| − | The following options exist for reporting load or load reduction.
| |
| − | *pounds or number (for bacteria) reduced
| |
| − | *kilograms or number (for bacteria) reduced
| |
| − | *percent load reduction
| |
| − | *pounds or number (for bacteria) per acre reduced
| |
| − | *kilograms or number (for bacteria) per hectare reduced
| |
| − | *load (pounds or number of bacteria)
| |
| − | *load (kilograms or number of bacteria)
| |
| − | | |
| − | {{alert|Reductions from all BMPs/activities included in this category are reported as a single cumulative number. For example, if 5 rain gardens (bioretention systems) were in operation and each rain garden reduced phosphorus loading by 10 pounds per year, and no other BMPs can be quantified, then the Permittee would report a cumulative reduction of 50 pounds of phosphorus.|alert-info}}
| |
| − | | |
| − | The following BMP/activities require estimated reductions in loading under Category 1:
| |
| − | *Infiltrator: examples include infiltration trench, infiltration basin, tree trench/box, permeable pavement, infiltration vault, bioinfiltration
| |
| − | *Constructed basin: examples include wet pond, stormwater wetland, dry pond
| |
| − | *Filter: examples include sand filter, green roof, biofiltration, iron enhanced sand filter
| |
| − | *Swale or strip: examples include filter strip, swale, wet swale, grass waterway
| |
| − | These BMPs are included or can be simulated in most water quality models and calculators used for estimating stormwater loading. The Minnesota Stormwater Manual also provides typical reduction efficiencies for these BMPs. Note that you may have information that allows for quantifying pollutant reductions for BMPs other than those listed above, or you may have different pollutant removal values based on local data. For example, many water quality models and calculators will calculate pollutant reductions associated with [[Street sweeping for trees|street sweeping]]. MPCA encourages permittees to keep a record of methodology used to calculate reductions.
| |
| − | | |
| − | The following BMPs may be quantifiable. However, the Stormwater Manual either provides limited or no pollutant removal efficiencies or guidance for these BMPs, so it is suggested that they be reported under Category 2.
| |
| − | *Manufactured Device: examples include drain inlet insert, geocells, grit chamber, gross pollutant trap, hood, hydrodynamic separator, manufactured filter, oil/grit separator, pollutant trap, SAFL Baffle, SAFL Baffle sump manhole, sump, sump manhole, swirl separator, water quality inlet
| |
| − | *Street sweeping if records are kept for material added to roads (e.g. sand) and removed through sweeping. See [[Street sweeping for trees]].
| |
| − | *Removal of an illicit discharge if the volume of discharge and pollutant concentration are known
| |
| − | *Stormwater capture and reuse if the volume of runoff captured and pollutant concentrations are known. See [[Stormwater re-use and rainwater harvesting]]
| |
| − | *Improved lawn, turf, vegetation, soil practices if the practice results in decreased pollutant application (e.g. fertilizer) or increased infiltration (e.g. improved soil or turf). See [[Turf]].
| |
| − | *Chemical treatment of stormwater: if the volume, pollutant concentrations, and removal efficiency are know, or if monitoring is conducted. See [[Iron enhanced sand filter (Minnesota Filter)]]
| |
| − | | |
| − | {{alert|The MPCA encourages the use of local data in determining BMPs that can be quantified and in establishing a pollutant removal value for a specific BMP.|alert-info}}
| |
| − | | |
| − | ====Category 2. Number of BMPs implemented====
| |
| − | | |
| − | <div style="background-color: none; border-style: solid;">
| |
| − | *Use Category 2 if '''any''' of the following applies.
| |
| − | **Pollutant is Biochemical Oxygen Demand (BOD), Nitrogenous Biochemical Oxygen Demand (NBOD), chloride, or thermal loading
| |
| − | **Pollutant reduction information from the BMP/activity is not readily available using an [[Dummy page#Estimation of pollutant load reduction for the Cumulative reductions tab|appropriate method]]
| |
| − | **You contribute(d) to the implementation of the BMP/activity but the reduction in pollutant loading occurs '''outside your jurisdictional area''' (e.g. you contributed funding to a BMP in another MS4's jurisdiction)
| |
| − | **The BMP/activity was in operation the past year
| |
| − | </div>
| |
| − | | |
| − | | |
| − | The purpose of this category is to acknowledge BMPs/activities that likely reduce pollutant loads but '''lack information for estimating load reductions''' or '''reduce pollutant loads outside the permittee's MS4'''. Entires in this category are numbers of BMPs; not a reduction value. This category should be used to track those BMPs or activities that operate in one or more of the following conditions.
| |
| − | *BMPs or activities that lack information for estimating pollutant load reductions. These include non-structural BMPs such as education and structural BMPs for which pollutant removal values are not in the Stormwater Manual (e.g. hydrodynamic devices).
| |
| − | *Structural BMPs and non-structural BMPs within watersheds tributary to impaired waters that have a WLA for Biochemical Oxygen Demand (BOD), Nitrogenous BOD (NBOD), thermal loading, or chloride. Removal efficiencies for these pollutants are generally lacking in the literature.
| |
| − | *The permittee contributed to the BMP or activity (e.g. contributed funding) but reductions in pollutant loading from the BMP/activity occur outside the jurisdictional area of the permittee. These BMPs cannot be included in Category 1 because they do not decrease the load leaving the permittee's MS4.
| |
| − | As with Category 1, the value entered represents a cumulative value, in this case the total number of BMPs/activities that are applied to a TMDL Project. All BMPs and activities included in this number must be included in the BMPs-Activities completed tab.
| |
| − | | |
| − | ====Category 3. Non-implemented Activities (Reported in Category 3 BMPs - Activities tab)====
| |
| − | | |
| − | <div style="background-color: none; border-style: solid;">
| |
| − | *Use Category 3 if the BMP/activity was not in operation during the past year. This Category will also store records that constitute progress but do not achieve a reduction (e.g. planning, feasibility studies, acquisition of funding, etc.).
| |
| − | </div>
| |
| − | | |
| − | | |
| − | The purpose of this category is to capture progress made that did not directly result in a pollutant reduction. In this section, the Permittee must report on 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 could include both structural and non-structural BMPs/activities. Activities that constitute progress but do not achieve a reduction, such as planning, feasibility studies, acquisition of funding, etc., will be left in Category 3. When activities that can reduce pollutants are implemented, those reductions should be reported in Category 1 or 2, and removed from this worksheet.
| |
| − | | |
| − | ===Cumulative reductions worksheet===
| |
| − | [[File:Cumulative reductions tab screen shot.png|300px|thumb|alt=screen shot of cumulative reductions tab|<font size=3>Screen shot of the Cumulative reductions tab from the TMDL Annual Report Form.</font size>]]
| |
| − | | |
| − | The worksheet called ''Cumulative reductions'' is used to track the annual cumulative progress towards reduction of pollutants discharged to an impaired water with a USEPA approved TMDL. Cumulative progress may be reported in terms of measured or calculated pollutant reductions or number of BMPs implemented. Completion of this, the Category 3 BMPs - Activities, and Adaptive management worksheets fulfill compliance with [[MS4 PART III.STORMWATER POLLUTION PREVENTION PROGRAM (SWPPP)#E. Discharges to Impaired Waters with a USEPA-Approved TMDL that Includes an Applicable WLA|Section III.E.3 of the MS4 General Permit]] (Permit Number MNR040000).
| |
| − | | |
| − | The contents of this worksheet are shown in the figure to the right. As with the BMPs-Activities completed worksheet, cells that are grey are column/row headings and cells that the MPCA will fill out for each MS4. Cells that are white are User input cells.
| |
| − | | |
| − | {{alert|The information in this worksheet is summary in nature. MS4 permittees are advised to maintain a record of the data used to complete this form, including information such as BMP name, total annual pollutant load reduction, technique used to compute pollutant load reduction, date the BMP went into operation, and other information that may assist the MS4 Permittee. Some of this information may be included in the BMPs-Activities completed worksheet.|alert-info}}
| |
| − | | |
| − | Three categories of reporting are described in detail above. The choice of category for reporting is dependent on whether the BMPs/activities are required to be quantified for the pollutant of concern. Recommendations for the choice of Category are provided above. For Category 1 and Category 2, it is assumed the BMP/activity was in operation during the previous year, or if this is your first reporting year, between the baseline year or BMP condition of the TMDL and the past year (see the information box under [[Guidance for completing the TMDL reporting form#Detailed guidance for completing the BMP-activities completed tab|Column D - Reporting year]] for explanation of a missing baseline).
| |
| − | | |
| − | ====Detailed guidance for the Cumulative reductions tab - Category 1====
| |
| − | =====Columns A and B – MS4 Information=====
| |
| − | *Description: MS4 Permittee Name and MS4 ID
| |
| − | *Input: None
| |
| − | *Source of Information: The MPCA will input this information.
| |
| − | | |
| − | =====Column C – TMDL project=====
| |
| − | *Description: The name of the TMDL project. A stream TMDL may include multiple TMDL WLAs that have been combined for ease of reporting. A TMDL project has only one pollutant. The project name(s) match(es) the names listed starting in Column Q of the ''BMPs-Activities completed'' tab.
| |
| − | *Input: Column D or Column C from the List of TMDLs tab. The project name(s) match(es) the names listed starting in Column S of the ''BMPs-Activities completed'' tab.
| |
| − | *Source of Information: The MPCA will input this information.
| |
| − | | |
| − | =====Column D – Units=====
| |
| − | *Description: The units of measurement for the pollutant reduction (e.g. pounds, kilograms, %) for each TMDL project. The user may select the units of measurement in which to illustrate reductions. MPCA encourages consistent units for the duration of the permit term.
| |
| − | *Input: Dropdown with an option for the User to enter a different value
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Columns E through K – Years=====
| |
| − | *Description: Annual pollutant load reduction for the total of all BMPs within the specific TMDL watershed. If the User is reporting on more than one BMP within one TMDL watershed, the reductions should be totaled and presented as one value for that year. For subsequent years, include reductions from all BMPs, including BMPs included in the previous year’s reporting. For example, if 5 rain gardens (bioretention) achieved 50 pounds reduction in 2014 and 5 newly built rain gardens achieved 40 pounds reduction in 2015, the total reduction is 90 pounds, assuming all rain gardens have been maintained and are still performing as designed. Similarly, if a BMP is removed or no longer functioning properly, it should not be included in estimates of total reduction. The Permittee is thus reporting on cumulative reductions over a period of several years when several BMPs or activities may be implemented.
| |
| − | *Input: Calculated or measured pollutant reduction (e.g. pounds, kilograms, %, etc.).
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Column L – Calculation Method (Optional)=====
| |
| − | *Description: This optional column allows the user to track the method used to compute the WLA reduction.
| |
| − | *Input: Description of monitoring, if obtained. Name of model or calculator, if utilized.
| |
| − | *Source of Information: User
| |
| − | | |
| − | {{alert|MPCA highly recommends using the same methodology for estimating reductions for all reporting years of this permit issuance.|alert-warning}}
| |
| − | | |
| − | =====Column M – Notes (Optional)=====
| |
| − | *Description: Users may describe background information or other data that could further explain the progress towards meeting the WLA.
| |
| − | *Input: User defined.
| |
| − | *Source of Information: User
| |
| − | | |
| − | ====Detailed guidance for the Cumulative reductions tab - Category 2====
| |
| − | These are numbers of BMPs or activities that have been implemented but are not quantified in terms of pollutant reduction.
| |
| − | | |
| − | =====Columns A and B – MS4 Information=====
| |
| − | *Description: MS4 Permittee Name and ID
| |
| − | *Input: None
| |
| − | *Source of Information: The MPCA will input this information.
| |
| − | | |
| − | =====Columns C and D– TMDL project=====
| |
| − | *Description: The name of the TMDL project. A TMDL project may include multiple TMDL WLAs and multiple receiving waters that have been combined for ease of reporting. A TMDL project has only one pollutant.
| |
| − | *Input: None
| |
| − | *Source of Information: The MPCA will input this information.
| |
| − | | |
| − | =====Columns E through K – Years=====
| |
| − | *Description: The number of BMPs meeting Category 2 criteria (see [[Guidance for completing the TMDL reporting form#Overview of categories for Cumulative Reductions tab and Category 3 BMPs - Activities tab|Overview of categories]]) that were implemented in the reporting year. This includes BMPs or activities operated in previous years, assuming the BMP or activity is still implemented and achieving pollutant reductions.
| |
| − | *Input: Number of BMPs in operation during reporting year
| |
| − | *Source of Information: User
| |
| − | | |
| − | =====Columns L and M – Notes (Optional)=====
| |
| − | *Description: Users may describe background information, computational details or other data that could further explain the progress towards meeting the WLA.
| |
| − | *Input: User defined.
| |
| − | *Source of Information: User
| |
| − | | |
| − | ====Estimation of pollutant load reduction for the Cumulative reductions tab====
| |
| − | The TMDL Form requires Permittees to estimate pollutant reductions for BMPs/activities that have established pollutant removal values for phosphorus, TSS, fecal coliform bacteria, or E. coli bacteria. “Established pollutant removal value” means the Stormwater Manual provides values for pollutant removal or MPCA has included a pollutant removal value in the Input values for MPCA estimator worksheet tab of the TMDL Form.
| |
| − | | |
| − | In addition to the values provided in the TMDL Form, MS4 Permittees have multiple options for determining the pollutant load reduction of a specific BMP. The Permittee may opt to use any of these techniques. Permittees are encouraged to record the methodology utilized for computing pollutant load reductions in order to manage the data and changes that can occur each reporting year.
| |
| − | | |
| − | =====Models and calculators=====
| |
| − | The Minnesota Stormwater Manual contains an up-to-date list of [[Available stormwater models and selecting a model|models and calculators]] that can be used to compute the pollutant removal of a specific BMP. The models range from complex software that calculate hydrology/hydraulics/water quality such as USEPA SWMM, to User friendly calculators such as the MIDS calculator. Permittees are advised to consider the following.
| |
| − | *Stand-alone water quality models, such as P8, work well for situations that do not require a hydraulic analysis.
| |
| − | *Complex models such as SWMM work well for watersheds with multiple BMPs, but may require a MS4 Permittee to hire a modeling expert or consultant.
| |
| − | *Most water quality models will compute reductions in Total Phosphorus and Total Suspended Solids. A few models will assess additional pollutants.
| |
| − | *The model/calculator list of BMPs should be reviewed before selecting a model to utilize. For example, load reductions from a green roof can be computed using the MIDS Calculator, but is not in the list for P8. Some models, including P8, do have the capability of computing the load reduction from a User-defined BMP.
| |
| − | | |
| − | =====Credits=====
| |
| − | The Minnesota Stormwater Manual sections on Stormwater Management Credits offer four options to calcuate the pollutant removal for a number of BMPs. The term Credit implies pollutant loading and volume reductions. BMPs that have Credit sections include:
| |
| − | *[[Permeable pavement]]
| |
| − | *[[Bioretention]]
| |
| − | *[[Infiltration trench]]
| |
| − | *[[Infiltration basin]]
| |
| − | *[[Filtration]]
| |
| − | *[[Filtration|Swales]]
| |
| − | *[[Green roofs]]
| |
| − | *[[Trees|Tree trenches/boxes]]
| |
| − | *[[Stormwater ponds|Constructed ponds]]
| |
| − | *[[Stormwater wetlands|Constructed wetlands]]
| |
| − | Four calculation methods are described in detail in each of these BMP Credit sections.
| |
| − | *Credits Based on Volume Reduction and BMP Parameters. Details hand calculation methods to compute volume reduction, Total Phosphorus, and Total Suspended Solids removal for a single BMP.
| |
| − | *Credits Based on Models. Provides detail on model selection. Also includes information on using the Minimal Impact Design Standards (MIDS) calculator.
| |
| − | *Credits Based on Literature. MS4 Permittees may opt to apply percentage removal values based on published literature values. Users of this technique are advised to use only values from peer-reviewed literature of BMPs that closely resemble the MS4 Permittee’s BMP. Values included in the TMDL Form are based on literature review.
| |
| − | *Credits Based on Field Measurement. MS4 Permittees and BMP owners may determine that the most accurate method of computing pollutant reduction is through direct monitoring of the BMP.
| |
| − | | |
| − | =====MPCA Estimator=====
| |
| − | Included in the TMDL Form is a worksheet that has been created for the purpose of estimating pollutant load reductions using published reductions in Event Mean Concentration (EMC). Use of this worksheet is optional. This estimator is intended solely for computing load reductions for this form, only, and is not intended to report on the exact performance of an individual BMP. See [[Guidance and examples for using the MPCA Estimator]] for more information.
| |
| − | | |
| − | ===Category 3 BMPs - Activities Tab===
| |
| − | | |
| − | This tab contains a worksheet that should include all BMPs and activities listed in the compliance schedule of the permit application that have not been completed. Over time these BMPs or activities may be completed and then moved into Category 1 or Category 2. Activities that constitute progress but do not achieve a reduction, such as planning, feasibility studies, acquisition of funding, etc., are the only records that will remain in Category 3.
| |
| − | | |
| − | ====Columns A and B – MS4 Information====
| |
| − | *Description: MS4 Permittee Name and ID
| |
| − | *Input: None
| |
| − | *Source of Information: The MPCA will input this information.
| |
| − | | |
| − | ====Column C and D – BMP Description====
| |
| − | *Description: Description of planned BMP or activity. This description should match what was given at the time of application. For example, “Stormwater Pond located at the intersection of Main Street and Central Ave”.
| |
| − | *Input: BMP
| |
| − | *Source of Information: User
| |
| − | | |
| − | ====Column E – Status====
| |
| − | *Description: Status of planned BMP
| |
| − | *Input: Planned, funded, under construction, or other user-specified status
| |
| − | *Source of Information: Dropdown box
| |
| − | | |
| − | ====Column F – Reporting Year====
| |
| − | *Description: Year the BMP is to be constructed or implemented
| |
| − | *Input: Year
| |
| − | *Source of Information: Dropdown box
| |
| − | | |
| − | ====Column G – Notes (Optional)====
| |
| − | *Description: Users may describe background information or other data that could further explain the progress towards meeting the WLA.
| |
| − | *Input: User defined.
| |
| − | *Source of Information: User
| |
| − | | |
| − | ====Column H and beyond – TMDL Project with TMDL WLAs)====
| |
| − | *Description: The number of columns for each MS4 form will be unique to the number of USEPA-approved TMDLs and WLAs applicable to the MS4 Permittee. The MPCA will insert the column headings specific to each MS4 Permittee. The listed projects may include multiple WLAs for the same receiving water and pollutant. For example, a TMDL report may include WLAs for different flow regimes and different reaches of the same river. These have been combined when appropriate to simplify the reporting process.
| |
| − | *Input: ‘X’ to designate a TMDL for which a unique BMP/activity is being applied.
| |
| − | *Source of Information: User
| |
| − | | |
| − | ===Adaptive Management Strategy tab===
| |
| − | [[file:adaptive management screen shot.png|300px|thumb|alt=screen shot of adaptive management screen|<font size=3>Screen shot of the Adaptive management tab in the TMDL worksheet. Click on image to enlarge.</font size>]]
| |
| − | | |
| − | The NPDES MS4 permit requires permittees to provide “(a)n up-dated narrative describing any adaptive management strategies used (including projected dates) for making progress toward achieving each applicable WLA”. This tab contains a text box for users to submit this narrative.
| |
| − | | |
| − | [[file:example adaptive management.png|300px|thumb|alt=example of adaptive management strategy|<font size=3>Example of an adaptive management strategy entered into the TMDL spreadsheet. Click on image to enlarge.</font size>]]
| |
| − | | |
| − | Adaptive management (AM) is a formal process for continually improving management policies and practices by learning from their outcomes. This portion of the annual report should describe the permittee's plan for continuing to demonstrate progress toward achieving applicable WLAs through development and implementation of structural and non-structural BMPs (e.g., project funding details, details of a feasibility study, efforts to establish partnerships, updates on construction of a structural BMP, etc.). This is also the portion of the annual report that would describe any changes to the compliance schedule the permittee wishes to pursue based on past observations and recognized program enhancement opportunities.
| |
| − | | |
| − | Example: The city has used the first year of the permit term to evaluate its status in regard to WLAs for two lake phosphorus TMDLs. An assessment of implemented BMPs found that additional reductions will need to be made in order to achieve the WLAs. The city is currently determining the most cost effective strategies for meeting these goals. There is a stormwater utility fee in place that will be used to fund these Capital Improvement Projects going forward. A creative approach will need to be applied being that the city is completely built out. As redevelopment occurs, additional stormwater management practices will be evaluated and installed. Construction schedules are variable and future annual reports submitted to the MPCA by the city will provide updates made to the city’s compliance schedule. New and improved technology will also be monitored throughout the current permit term and implemented when feasible going forward.
| |
| − | | |
| − | ===Reference tabs===
| |
| − | The three yellow tabs within the TMDL form are reference tabs. The Dropdown lists tab was created solely to build the form and does not contain information helpful to the User. The other tabs are the List of TMDLs and the Input values for MPCA estimator. These are described in more detail below.
| |
| − | | |
| − | ====List of TMDLs====
| |
| − | [[file:screen shot list of tmdls tab.png|300px|thumb|alt=screen shot of list of TMDLs tab|<font size=3>Screen shot of the List of TMDLs tab.</font size>]]
| |
| − | | |
| − | *Description: A list of the EPA-approved TMDLWLAs prior to August 1, 2013. Each TMDL is classified by waterbody, pollutant, and Permittee.
| |
| − | *Input: None
| |
| − | *Source of Information: MPCA
| |
| − | | |
| − | ====Input values for MPCA estimator====
| |
| − | [[file:screen shot estimator inputs.png|300px|thumb|alt=screen shot of estimator inputs tab|<font size=3>Screen shot of the Estimator inputs tab.</font size>]]
| |
| − | | |
| − | This tab contains three types of information. The first is the fraction of pollutant removed from the stormwater runoff due to the presence of a BMP. The values apply to stormwater runoff that does not infiltrate into underlying soil. For water that infiltrates into the underlying soil, the pollutant removal is 100 percent. Any remaining runoff will bypass the system and cannot be considered for pollutant removal. Therefore the removal fraction for these BMPs is 0 because it only applies to the water that is not infiltrating into underlying soil. The pollutant removal fraction for infiltrated water equals the fraction of water that infiltrates. These values are included in cells C37, C58, C79, and C100 in the MPCA estimator tab. The default value for fraction that infiltrates is 0.90, which corresponds approximately with a BMP designed to capture a 1 inch rain event. All removal fractions are based on the assumption that BMPs were properly designed, constructed and maintained. See specifications and guidance for design, construction and maintenance of individual BMPs in the Minnesota Stormwater Manual. Removal fractions are consistent with values presented in the Stormwater Manual and the [[MIDS calculator|Minimal Impact Design Standards calculator]].
| |
| − | | |
| − | The second type of information is the event mean concentration (EMC) of total phosphorus, TSS, E. coli, and fecal coliform in stormwater runoff in the various land use areas. The [http://rpitt.eng.ua.edu/Publications/4_Stormwater_Characteristics_Pollutant_Sources_and_Land_Development_Characteristics/Stormwater_characteristics_and_the_NSQD/NSQD%203.1%20summary%20for%20EPA%20Cadmus.pdf 2011 National Stormwater Quality Database] is the primary source of this information. Cells in the worksheet are populated with mean or median values from the Upper Midwest (Zone 1), but the User may enter a different value if they have reliable data.
| |
| − | | |
| − | The third type of information is the runoff coefficient (Rv) for the various land use types. The input values are based on literature. The default is set at the median of values from the literature. The User may enter a value if available data supports the value. For a discussion of runoff coefficients, see [http://www.brighthubengineering.com/hydraulics-civil-engineering/93173-runoff-coefficients-for-use-in-rational-method-calculations/#imgn_1].
| |
| − | | |
| − | If a user wishes to provide any of the above information specific to their site for input into the Estimator, they may change the numbers here in the input tab and they will be transferred to the Estimator. These values are locked in the Estimator tab to avoid accidental edits.
| |
| − | | |
| − | ===Other resources, information and guidance for the TMDL spreadsheet===
| |
| − | ====Cross-reference list of BMPs====
| |
| − | Download here: [[file:Cross-Reference list.xlsx]]
| |
| − | *Description: For the purpose of the TMDL form, the MPCA has opted to develop a naming convention that organizes BMPs into common categories. The cross-reference list is an Excel spreadsheet, separate from the TMDL form, for Users that have a different BMP naming convention than that used in this form.
| |
| − | *Discussion: To ensure a TMDL form that was functional, it was necessary to limit the list of BMPs to a manageable number. A particular BMP may have several names or variants. For example, bioretention BMPs are often called rain gardens or rain water gardens. Permeable pavement has several variants, including porous asphalt, porous concrete, and permeable interlocking concrete pavers (PICP).
| |
| − | | |
| − | :The cross-reference spreadsheet contains an extensive list of terms for BMPs and identifies the BMP to select from the BMP dropdown list in Column E of the ''BMPs-Activities completed'' worksheet. The information is sorted by BMPs in the dropdown list (Column A). Column B contains different names and variants of a BMP. Find your BMP in Column B and select the corresponding name in Column A when selecting a BMP from the dropdown list in Column E of the ''BMP-activities completed'' worksheet. If you cannot find your BMP, do a word or term search using the Find command on the Home toolbar in Excel. If your BMP term is not listed, use Best Professional Judgment to select the appropriate BMP from the dropdown.
| |
| − | *Input: None
| |
| − | *Source of information: MPCA
| |
| − | | |
| − | The cross-reference list is included in a separate Excel spreadsheet rather than the TMDL spreadsheet because the MPCA realizes the BMP list is likely to grow over time. The cross-reference file will be updated as needed.
| |
