tracking septic system data for forecasting risk...
TRANSCRIPT
![Page 1: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/1.jpg)
Tracking Septic System Data for Forecasting Risk, Improving Management & Preventing
Impacts
David Rush – Land & Resource Director Pat Schultz – Environ. Planning Technician
![Page 2: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/2.jpg)
Perfect Storm = Paradigm Shift What triggers a county to want to completely overhaul their septic regulatory efforts? Failures of the past Collapse of large-scale central sewer expansion project Impending rule change (7080-83) New administration
![Page 3: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/3.jpg)
2010 Comprehensive SSTS Enhancement Program
Applied to BWSR for a Clean Water Legacy SSTS Program Enhancement Grant
Worked Cooperatively with UMN On Site Program
Included ordinance update to new MPCA Rules
![Page 4: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/4.jpg)
2010 Comprehensive SSTS Enhancement Program
Enhance County’s ability to administer comprehensive program Systematic compliance inspection and
operation and maintenance based on risk Develop single permitting, compliance, and
maintenance database Associate administrative effort (cost) with
level of risk/management
Improve operation and maintenance of individual SSTS by improving user knowledge
![Page 5: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/5.jpg)
2010 Comprehensive SSTS Enhancement Program
Forecast risk associated with various SSTS using data
Create an effective SSTS ordinance tailored to Douglas County that considers risk and costs
Create a State-wide model to share with other jurisdictions.
![Page 6: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/6.jpg)
Create a management program, not a permitting or inspection program Checking that everyone has a treatment system Making sure they are performing
Monitoring
Keeping them performing Operation and Maintenance
Knowing they are performing Reporting
Dealing with solids
![Page 7: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/7.jpg)
Douglas County SSTS Professionals
Douglas County
Residents
Douglas County
SSTS Staff
Cooperation with Stakeholders
![Page 8: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/8.jpg)
Counties can and do collect volumes of data on properties and septic treatment systems
How do we make that data useful?
Site
System
Use
![Page 9: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/9.jpg)
What is a database? A database is a tool to organize and store pieces of information. Everyday examples would be a rolodex or a phone book. The main goals of a database are to: Make sure the data stored in the database is accurate
and complete Avoids redundancy, reduces “wasted space” (if stored
in other places), cut down on easy errors Make retrieving and analyzing the data easy
![Page 10: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/10.jpg)
How would the database be used by a County? To determine system types and locations in the County To track maintenance and management by
homeowners and professional maintainers Tracking compliance To determine risk and therefore permits required and
inspection frequency To answer questions related to MPCA or other
reporting requirements
![Page 11: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/11.jpg)
Determining system types and locations in the County
![Page 12: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/12.jpg)
Tracking maintenance and management by homeowners and
professionals
![Page 13: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/13.jpg)
Tracking Compliance
![Page 14: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/14.jpg)
Risk Assessment Tool Collaboration with UMN On Site Program Develop a tool that would use available data (user, site,
system) to quantify the potential “risk” of a SSTS Area-wide risk evaluation Site/system specific evaluation
Risk values are based on the sum of weighted scores for over 40 characteristics of a system.
Results provide a quantifiable basis for local programs to prioritize inventory and upgrade efforts and/or determine appropriate management strategies
![Page 15: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/15.jpg)
• Cabin to mansion expansion • Bedroom to ft2 ratio?
• Educated SSTS Owner
Use = Who is using the system?
![Page 16: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/16.jpg)
Site Conditions = Where is the effluent going?
• Shore land • Soil conditions and perc test results • Aquifer sensitivity, shallow wells • Lot size, replacement sites • Setbacks and variance prevalence • Comp plan and other local land-use initiatives
![Page 17: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/17.jpg)
Determining Risk – single parcel
![Page 18: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/18.jpg)
![Page 19: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/19.jpg)
Determining Risk – multiple parcels
![Page 20: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/20.jpg)
![Page 21: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/21.jpg)
![Page 22: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/22.jpg)
MPCA Reporting Requirements
![Page 23: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/23.jpg)
![Page 24: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/24.jpg)
![Page 25: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/25.jpg)
Event logs and triggers
![Page 26: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/26.jpg)
Letter writing
![Page 27: Tracking Septic System Data for Forecasting Risk ...mowa-mn.com/wp-content/uploads/2017/03/Tracking... · Collaboration with UMN On Site Program Develop a tool that would use available](https://reader034.vdocuments.us/reader034/viewer/2022042314/5f01c65a7e708231d400f907/html5/thumbnails/27.jpg)
Special thank you goes to: University of Minnesota OSTP Department MPCA Alexandria Technical Community College Data Dimensions