Freese and Nichols was obtained by the Town of Morrisville Stormwater Department to develop three departmental tools to improve their organization, efficiency and effectiveness. These three tools include a departmental stormwater project ranking system; a GIS-linked database to store complaints, stormwater projects and BMP inspections; and an Android and Apple mobile app to perform annual BMP inspections in the field.
The stormwater project ranking system is a departmental tool that will assist the Town in prioritizing their projects for their annual budgeting. The process of developing this ranking system is an iterative process of developing criteria, a scoring system for the criteria and a weighting factor for the criteria. The iterative process allows buy-in by the departmental staff and city leadership, and ultimately creates the “right” system for their department and community.
The second part of the project consists of developing a GIS-linked Access database to store complaints along with their proposed resolutions. Typical resolutions may include private property issue, maintenance issue or stormwater project requiring study or design. The database also will house the stormwater project ranking system and perform the basic math computations to rank projects based on the final system. The graphical interface and queries of the database are customized to Morrisville’s requests. Query examples include the ability to automatically create one-page PDF reports of each database record and annual budgeting reports.
The final component of the project includes using the fillable PDF BMP inspection reports to create an Android and Apple mobile app for each BMP. This app will work offline while in the field and allow capture of images and completion of the inspection checklist. Upon return to the office, the app will automatically upload to a second BMP database, developed by Freese and Nichols, to house BMP inspection information. This database will have reporting features to automatically generate a PDF record of each inspection. All three of these departmental tools have the potential to improve their organization, efficiency and effectiveness as a department.