There is an App for That! SSO Mobile Application Achieves Better Reporting

Client: City of Lawrence, Massachusetts

Justin deMello October 26, 2015

NEWEA Specialty Conference

Sewer System Background ¡  Population: 80,000 ¡  Size of City: 7.4 Sq. Mi. ¡  Miles of Sewer Pipe: 133 miles ¡  No. of Manholes: 3,200 ¡  No. of Catch basins: 4,100 ¡  Percentage Combined: 60% ¡  No. of CSOs: Zero ¡  Avg. Pipe Age: 94 Years ¡  No. of Full Time Sewer Staff: 5

¡  Aging system ¡  High FOG Users ¡  Lack of Preventative

Maintenance ¡  Minimal Capital Improvement

Plan

¡  Has lead to: Ø  Structural and

O&M pipe defects Ø  Frequent sewer backups, SSOs,

other permit violations

Sewer System Issues

Sanitary Sewer Overflows ¡  SSOs

Ø  Unintentional discharges of raw sewage from municipal sanitary sewers

¡  Consequences: Ø  Public Health & Safety Ø  Environmental Contamination Ø  Compliance and Financial

Sanitary Sewer “Explosions”

Historical SSO Reporting ¡  Minimal ¡  Out of sight, out of mind… ¡  Thin folder with Regulators ¡  BIG Problem

System Audit EPA/DEP Audit in July 2012

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

                                                                                                                                                         

Regulatory Reporting Requirements ¡  U.S. Dept. of Justice Consent Decree

Ø  Draft received May 2014 Ø  Lodged April 2015

¡  24 hr. SSO Notification ¡  Full SSO Report within 5 days ¡  DOJ/EPA Requirements in addition to standard

MassDEP SSO Reporting Form

Lawrence Water and Sewer Division’s Trailer Pipe Jetter

Step #1 – SSO ERP

¡  SSO Emergency Response Plan Ø  Preparation Ø  Field Response Ø  Reporting with

Step by Step Instructions Ø  Follow-up

Step #2 – Updated Mapping

Step #2A – Asset Mapping

Step #3 – Reporting Options ¡  The City Needed a Simplified Reporting Solution ¡  SSO Reporting Tool Selection

Ø  Necessary Features and Drivers: ▪  Mapping to locate assets in the field ▪  Means of entering specific data ▪  Communication

¡  Alternatives Considered: Ø  Paper Reports Ø  Computerized Maintenance Management System (CMMS) and

Work Order Management System Ø  Other….

ESRI Collector Mobile Application ¡  Features:

Ø  ArcGIS Mobile mapping interface Ø  GPS Location Assistance Ø  Asset Selection and Attribute Modification Ø  Online or Offline Capabilities Ø  Multiple Users Ø  Link Photos and Videos to Reports Ø  Cloud Based Data Storage Ø  Export Data to Excel Tables

SSO Reporting Workflow Diagram

SSO Data Collection

•  Location Toggle •  Layers/Basemaps •  Favorites •  Search •  Measure •  Add Features •  Edit Features •  Update    

Web Reporting Interface

Review, Edit and Approve

Results ¡  Effective digital and

streamlined solution ¡  Familiarize staff

with solutions ¡  Intro. to CMMS ¡  Data for Compliance

Reporting Maps ¡  Data for Asset

Management and Capital Improvement Planning Input

¡  Dev. Cost ~ $10,000

SSO ID SSO Begin Date

Discovered Date

Discovered By

Discovered By

Name

SSO Stopped

SSO End Date

Nearest Address

Discharged From

Discharged From

Ownership Weather Discharge

d To Estimated Gallons

Released

Estimated Gallons To

CB

Estimated Gallons To

Surface Water

Estimation Method

Distance to Nearest Downstream CB (ft)

Nearest Downstream Surface

Water

Surface Water Entry

Location Cause

2001 11/2/2014 21:33 Other

Lawrence Fire

Department

Yes 11/2/2014 21:45

18 Everett Street

Interior Plumbing Public Dry Building

Interior 4 0 0 Ponded None Sewer System

Blockage

4801 12/2/2014 6:17

Property Owner Don Yes 12/2/2014

6:27 23 Shaw

Street MH Public Dry CB to

Combined Sewer

8 8 0 Velocity 38 None N/A Grease Blockage

7601 12/29/2014 16:59

Property Owner Jim Yes 12/29/201

4 17:29 193 Maple

Street MH Public Dry Ground Surface 30 30 0 Velocity 35 None

Sewer System

Blockage

10001 1/18/2015 18:12

Property Owner Jose Yes 1/18/2015

18:12 77-79 Cross Street

MH Public Wet CB to

Combined Sewer

1000 1000 0 Velocity 300 None Sewer System

Blockage

14003 2/23/2015 13:22

Property Owner Jose Yes 2/23/2015

14:00 50 Cedar

Street Interior

Plumbing Private Dry Building Interior 40 0 0 Ponded None Pipe

Collapse

6034 3/24/2015 8:30

3/24/2015 8:58

Public Works

Sam Torrisi Yes 3/24/2015

9:32 511

Riverside Drive

MH Public Dry CB to

Surface Water

500 500 500 Velocity 225 Merrimack River

Riverside Drive and

Essex Street outfall

Sewer System

Blockage

6347 3/25/2015 14:50

3/25/2015 14:53

Property Owner Gilcita Yes 3/25/2015

18:47 126-128 Haverhill

Street

Interior Plumbing Private Dry Building

Interior 20 0 0 Ponded 30 None Grease Blockage

6041 4/4/2015 15:00

4/4/2015 15:05

Property Owner Bali Yes 4/4/2015

17:12 59 Essex

Street Interior

Plumbing Public Dry Building Interior 30 0 0 Ponded 150 None Grease

Blockage

6349 4/29/2015 15:02

4/29/2015 15:46

Property Owner Alex Yes 4/29/2015

17:32 165

Margin Street

CB Public Dry CB to

Combined Sewer

100 100 0 Ponded 0 None Grease Blockage

6048 4/30/2015 10:12

4/30/2015 11:12

Property Owner Mason Yes 4/30/2015

11:23 329

Winthrop Avenue

MH Public Dry Direct to Surface Water

375 0 375 Ponded 100 Shawseen River

Behind Rte. 114

Lift Station

Pump Station Failure

6053 6/3/2015 15:30

6/3/2015 16:45

Property Owner Jose Yes 6/3/2015

16:55 48 Brook

Street Interior

Plumbing Private Dry Building Interior 5 0 0 Ponded 30 None Grease

Blockage

12388 6/4/2015 12:00

6/4/2015 12:55

Public Works Tom Yes 6/4/2015

13:35 59 Steiner

Street MH Public Dry CB to

Combined Sewer

150 150 0 Ponded 6 None Grease Blockage

6350 6/17/2015 17:32

6/17/2015 17:37

Property Owner Yes 6/17/2015

17:37 39

Jefferson Street

Interior Plumbing Private Dry Building

Interior 20 0 Ponded 120 None Sewer System

Blockage

Attachment B-2: Sanitary System Overflows (as of July 31, 2015)

Discovered During This Reporting Period Discovered Prior to This Reporting Period

Challenges ¡  Limitations of Collector Application

Ø  Some minor bugs Ø  Selection of assets

¡  Collector App. ESRI Online W&C ArcGIS Server Manager W&C ArcGIS Desktop Web Reporting Interface

¡  Staff Training

Other Uses? ¡  CMMS (Light) ¡  Construction Site Stormwater Inspections ¡  Manhole/Catchbasin Inspections ¡  FSE Grease Trap Inspections ¡  Wet Weather

Ø  Flooding Response/Documentation Ø  MS4 Outfall Monitoring

Questions?

THANK YOU!