ESRI-Based Dashboards for Stormwater Management Facility Inspection, Maintenance, and Enforcement Tracking

ArcGIS dashboards provide a framework for strategic planning for the City of Rockville’s stormwater facility maintenance program.

The City of Rockville has over 1,300 public and private stormwater management (SWM) facilities within its jurisdiction that the NPDES MS4 Phase II Permit requires the city to inspect and ensure proper function. To improve the city’s outdated and inefficient public and private stormwater facility inspection, maintenance, and enforcement program, Biohabitats helped develop a solution that utilizes ESRI-based applications to ensure compliance and provide a framework for strategic planning for the city’s public stormwater facility maintenance efforts.

Biohabitats created a series of ArcGIS dashboards that allow the city to access and view public stormwater facility status, determine upcoming inspection needs, and input data into key fields. The dashboards include the ability to pull up what is due for inspection within a given date range and provide a projection of the number of SWM facilities due for inspection within the next six months; open an edit session to allow for easy data entry; track enforcement and compliance milestones; document additional types of inspections including dam safety, pre-storm, and routine inspections; track and summarize the frequency and cost of city-performed maintenance activities; and real-time synchronization of photo attachments and documents with SharePoint, where the city saves all inspection reports and enforcement documentation.

This project improved the city’s ability to track and schedule inspections and identify maintenance and enforcement needs, and solutions developed under this project were documented for city staff to use in the future.

TAGS

• Policy, Program + System Support
• Conservation