
Team Little Harpeth Team
3rd Place
Helping river advocates keep up with the bills that affect Tennessee's water.
Harpeth Conservancy protects clean water and healthy river ecosystems across Tennessee through science, advocacy, education, and community engagement.
Staff follow state bills that could affect Tennessee's rivers using a spreadsheet system that often breaks, wipes out their notes when data refreshes, and doesn't show what changed between bill versions.
This project builds a reliable workspace that keeps each bill's history, changes, and research in one place, so staff spend less time wrangling data and more time on the policy work that protects Tennessee's water.
The team's showcase: their solution to the brief above.
The Harpeth Conservancy wishes to track bills in the Tennessee legislature that impact water quality, which affects communities, ecosystems, and the movement of water through natural pathways and infrastructure in Tennessee. So Harpeth Conservancy recently had to step into the role of leading efforts to monitor legislative activity in Tennessee that affects the previously stated areas. Their work impacts everyone in Tennessee. The current workflow was created quickly using Google sheets and pulling from the Legiscan API, and it is more time-consuming for accomplishing the tasks they need and prevents employees from quickly tracking the relevant bills in the State House/Senate. (Over 1000 get filed in a legislative session.) They also could not make notes or organize easily, their data would get overwritten each day.
They had 4 main requirements for a new system:
Our team created a new workflow after speaking with the non-profit about what they envisioned would improve their tracking processes. We built a new web UI using a PostgreSQL database to store Legiscan API bill data that streamlines the process of reviewing and editing bills and saves the organization hundreds of working hours. Our project supports their work which in turn will benefit communities and natural habitats across the state.