Abstract
California's Trash Amendment aims at having storm water permittees to achieve trash-less waterbodies by 2030. This project builds a web application for efficient permit compliance and monitoring for Municipal Separate Storm Sewer System (MS4). This project has been developed using Django Framework, a python-based library as a backend. Pyodbc, a python library, is integrated into the Django framework to establish a connection between Django Framework and Microsoft SQL server database. The dataset used in this project is collected from the Survey123 application. The accumulated raw data is in the format of .xslx. After establishing a successful connection with the database, the data collected is then migrated to the Microsoft SQL server after processing. After a successful database implementation, REST API methods are created using the Django REST framework. The project's user interface is implemented using ReactJS and Material UI components. Google maps and Chart Js library are integrated into the dashboard's user interface to visualize the trash data. This application aims at monitoring aquatic trash to reduce the burden on MS4 permittees.