240 likes | 338 Views
Innovative/Alternative Septic System Performance. System Performance and Tracking it with the Carmody Database. Barnstable County Department of Health and Environment. By The Numbers. Permit Breakdown by System Type. Numbers are for the town of Wellfleet only. Box-Whisker Diagrams.
E N D
Innovative/Alternative Septic System Performance System Performance and Tracking it with the Carmody Database Barnstable County Department of Health and Environment
By The Numbers Permit Breakdown by System Type Numbers are for the town of Wellfleet only.
Box-WhiskerDiagrams What are they? Min/Max Value Min/Max Value Box Median – Middle Value Whiskers 50% 25% 25% Probability Density Graph (“Bell Curve”)
Box-Whisker Diagrams What Can We Use Them For? A – A “Good” System. Box and whiskers are short and compact. B – A “Bad” System. Results are all over the place. Box and whiskers are stretched out. C – A “Consistently Bad” System. Compact but well above TN limit (19 mg/l) D – A “Usually Pretty Good” System. Compact but maybe a couple of high results. A B C D
Single Family all Types by Individual System Three or More Samples with Full Nitrogen Series • 761 systems with 3 or more TN samples • 569 of 761 (75%) with median TN <19 mg/l
Single Family all Types by Individual System Three or More Samples with Full Nitrogen Series • 42 systems with 3 or more TN samples • 29 of 42 (69%) with median TN <19 mg/l
Single Family all Types by System Type Three or More Samples with Full Nitrogen Series
Single Family Advantex Three or More Samples with Full Nitrogen Series • 7 systems with 3 or more TN samples • 6 of 7 (85%) with median TN <19 mg/l
Single Family Bioclere Three or More Samples with Full Nitrogen Series • 7 systems with 3 or more TN samples • 7 of 7 (100%) with median TN <19 mg/l
Single Family FAST Three or More Samples with Full Nitrogen Series • 10 systems with 3 or more TN samples • 7 of 10 (70%) with median TN <19 mg/l
Single Family Orenco Three or More Samples with Full Nitrogen Series • 4 systems with 3 or more TN samples • 1 of 4 (25%) with median TN <19 mg/l
Single Family Generic RSF Three or More Samples with Full Nitrogen Series • 2 systems with 3 or more TN samples • 0 of 2 (0%) with median TN <19 mg/l
Single Family Septitech Three or More Samples with Full Nitrogen Series • 7 systems with 3 or more TN samples • 5 of 7 (71%) with median TN <19 mg/l
Single Family Singulair Three or More Samples with Full Nitrogen Series • 2 systems with 3 or more TN samples • 2 of 2 (100%) with median TN <19 mg/l
Single Family Waterloo Biofilter Three or More Samples with Full Nitrogen Series • 3 systems with 3 or more TN samples • 1 of 3 (33%) with median TN <19 mg/l
Single Family Septitech Three or More Samples with Full Nitrogen Series
Single Family all Types by System Type Three or More Samples with Full Nitrogen Series
Keeping Track of it All… Quickly Identifying Poorly Performing Systems Sample Reports Use to obtain a list of the most recent sample exceedances (anything over 19 mg/l) Two 25% Exceedances Use to generate a list of systems with two samples exceeding 19mg/l by 25% (24mg/l). One 50% Exceedance Use to generate a list of systems with one sample exceeding 19 mg/l by 50% (30 mg/l)
Keeping Track of it All… Sample Reports Messages Amount of the Exceedance Exceedance Percentage Exceeding Parameter Number of Consecutive Exceedances 25.83 mg/L > 19mg/L(36%) for Total Nitrogen 1 Consecutive 4 Non-Consecutive (25.83,8.54,43.4,29.35,24.1) Number of Non-Consecutive Exceedances Results from the Last Five Samples
Keeping Track of it All… Quickly Identifying Poorly Performing Systems Sample Reports Use to obtain a list of the most recent sample exceedances (anything over 19 mg/l) Two 25% Exceedances Use to generate a list of systems with two samples exceeding 19mg/l by 25% (24mg/l). One 50% Exceedance Use to generate a list of systems with one sample exceeding 19 mg/l by 50% (30 mg/l)
Keeping Track of it All… Sample Exceedance Report Select the Report Type: 2 over 24mg/l, 1 over 30mg/l or merged report. Export the current list to MS EXCEL List of the last 5 samples Remove the flag for this system. Will reappear on this list with another exceedance.
Keeping Track of it All… Exporting the Sample Exceedance Report to EXCEL
Keeping Track of it All… “Cleaned Up” Sample Exceedance Report • Exceedance reports will be delivered quarterly. • BOH will decide what action to take, since each BOH will likely have a different policy.
Innovative/Alternative Septic System Performance Brian Baumgaertel 508-375-6888 bbaumgaertel@barnstablecounty.org Barnstable County Department of Health and Environment