Track: Water Distribution, Wastewater, Sewer
Managing NPDES Permit Compliance: Development of an Integrated GIS Management System
Donna M. HueyFull implementation of the U.S. Environmental Protection Agency's National Pollutant Discharge Elimination System (NPDES) Municipal Separate Storm Sewer System (MS4) permit program has imposed extensive compliance management and reporting requirements on municipalities throughout the country. Requirements include development of storm water pollution prevention programs, adherence to detailed schedules, and monitoring of storm system maintenance and water quality sampling. ArcView GIS software in conjunction with Microsoft Access has been used to integrate the components of this permit requirements system in a user-friendly environment to facilitate the compliance process. SQL and Avenue have been utilized to link these two programs to maximize both the management of geographic entities such as storm sewer lines and outfall locations and the complex NPDES Annual Report requirements of summarizing all storm water management program goals and efforts toward meeting those goals. It is the purpose of this paper to describe the research process undergone for system development and implementation. Emphasis will be placed on the use of SQL and Avenue programming to create a workable interface between the ArcView GIS and MS Access portions of this management system. Additionally, this paper will detail the benefits of such a system with regard to postpermit compliance and permittee coordination.
Donna M. Huey
Post, Buckley, Schuh, & Jernigan, Inc.
1560 Orange Ave.
WInter Park, FLORIDA 32789
USA
Telephone: (407) 647-7275
Fax: (407) 647-0624
E-mail: dmhuey@pbsj.com