About the Project Inspiration & What It Does: This hackathon challenge tasked us with building a platform to coordinate community cleanup efforts in Birmingham. We created Community Cleanup Planner. A web application that connects volunteers with local cleanup events through interactive Google Maps integration (real coordinates for 15 Birmingham areas), real-time analytics dashboards, leaderboards with gamification, groups for organizations, and multi-format data export (Excel, CSV, JSON, PDF). The platform makes organizing and joining cleanup events as easy as a few clicks while tracking measurable environmental impact across the city. How We Built It & Challenges: Built with Python and Streamlit, we integrated Google Maps JavaScript API using iframe embedding, implemented secure authentication with session state management, and created interactive Plotly visualizations. The biggest challenges were embedding Google Maps in Streamlit (solved with HTML injection and postMessage API for clickable markers), handling Excel multi-sheet exports (switched from xlsxwriter to openpyxl), and managing authentication state across page navigations. We learned the importance of using real geographic data, supporting both individuals and organizations, and building comprehensive data export capabilities that appeal to different stakeholders from volunteers to city councils.
Built With
- api
- maps
- python
- streamlit
Log in or sign up for Devpost to join the conversation.