TUgis Conference 2019

The National Pollutant Discharge Elimination System (NPDES) permit program, helps address water pollution by regulating point sources that discharge pollutants to waters of the United States. As part of the NPDES municipal separate storm sewer systems (MS4s) permit, Maryland Department of the Environment (MDE) is required by law to report stormwater management and watershed restoration activity to the Maryland Department of the Environment. Multiple agencies in Prince George’s County, supported by various consultants, work together to ensure stormwater management compliance, as well as planning and executing water quality projects to improve watershed health in Prince George’s County. As part of this program, County is required to track stormwater management facilities installed within the county.

In order to effectively coordinate between various County agencies and public stakeholders to meet permit conditions, as well as produce a comprehensive annual report, it was obvious that the County needed to develop a central Geodatabase that would support the various stakeholders workflows, standardize data collection, data entry, perform summary analytics to track permit compliance, and allow for the MDE Geodatabase to be updated on an annual basis to submit.

An Enterprise Stormwater Management Geodatabase was implemented to track all NPDES data as well as support the missions of the County departments as they pertained to stormwater. Workflow manager was used to create workflows for the entry of BMP data from developers and the inspection of BMPs. A field collection application was developed using Collector and Survey 123 for the inspection of BMPs. The application also provides summary analytics based on the condition of the BMPs. Operations Dashboard was used to pull data from ESM and give summary analytics on pollutant reduction and watershed restoration progress.