Abstract
Trash discharge in a water body is a major concern. Aquatic litter is present in most of the country's waterways, and it mostly comes from land-based sources. According to California's statewide Trash Amendments, all MS4 permittees, including municipalities and public institutions, must achieve zero waste discharged to receiving water bodies by 2030. California State University, Sacramento is developing an application to support Municipal Separate Storm Sewer System (MS4) permittees by developing an information exchange system known as TRADE. Trash Rapid Assessment Data Exchange (TRADE) will be used to present and analyze the trash collected by the state of California. This project includes the development of a prototype to visualize the trash data. The prototype is built on Django, which is a popular python-based framework. The dataset used in this project is accumulated from the Survey123 application. The gathered data was in the .csv and .xls formats. The raw data is migrated to a MySQL database schema for further processing. Data processing scripts are created in MySQL to generate the normalized schema. After the successful database design, Django REST Framework is used to write the API methods. This project's front-end is designed using HTML, CSS and JavaScript. Google maps and Google charts are also integrated to provide better visualizations. The front end uses jQuery Ajax to call the backend API methods. This prototype is working as a web application over the Survey 123 data and will potentially reduce MS4 permittees’ burden of trash data monitoring and reporting.