A GIS-based Sewer Fee and Maintenance Application

Publication Date


Committee Chair

Karen K. Kemp, Ph.D.

Committee Members

Clay Jarvenin


The City of Montclair Public Works department needs to maintain and manage its sewer infrastructure and connection information in a more efficient and effective manner. Fees are miscalculated, connections are unknown and questions are answered with uncertainty. Information is scattered across the department and some records are even stored by other departments. Staff would like to see an application with the ability to maintain and manage sewer and connection information in a more centralized fashion.

This report discusses the design and implementation of a customized ArcGIS application for the Public Works department. The application allows staff to calculate and store sewer connection fees within a database and have access to sewer mains and manholes in a spatial format. The application also offers access to additional information stored by other departments. The application maintains the look and feel of the original hardcopy forms used by staff for the same tasks. The application will be user friendly, simple to use, and easy to maintain.

In order to design the application and data structure, staff was consulted and questioned about their needs, wants and concerns. The end users were always asked about decisions that were to be made regarding the interface and functionality of the application. This user-centric approach has been proven to be effective in providing the client with what they truly want, not what someone else thinks they want. Some design elements were constrained to existing data or existing projects already underway. Existing parcel data limited access to information through parcel numbers primarily, and addresses secondarily. A current project that occurred during this project was a database of information that the Public Works department could work on in cooperation with other departments. This database, created by staff, was an attempt to join a variety of information about parcels within the City’s limits.

This application will be used by Public Works staff to perform sewer related tasks and to aid in creation of reports and maps for presentation to commissions and councils. It will also help maintain data more efficiently and improve efficiency when responding to inquiries from residents. The application will aid staff in providing a higher level of service to residents within the City and eventually, within the City’s sphere of influence. Future enhancements and applications can be created, based on this project, to help provide greater service to City residents.

Full text is available at the University of Redlands


Article Location