A full-stack platform for monitoring dam water resources across New South Wales, Australia. Features a React dashboard, Flask REST API, and flexible database support for MySQL and PostgreSQL.
https://github.com/obj809/frontend-water-dashboard-nsw
React 18, TypeScript, Vite, Redux Toolkit (RTK Query), React Router v6, Recharts, Chart.js, D3.js, SCSS, Vitest
- Real-time data fetching with RTK Query caching
- Search functionality and stacked-pages navigation
- Interactive visualizations (Recharts, Chart.js, D3)
- Full-screen graph views and dam detail pages
https://github.com/obj809/backend-water-dashboard-nsw
Flask 3.1, Flask-RESTX, Flask-SQLAlchemy, Flask-Migrate, PostgreSQL/MySQL, pytest, Gunicorn
- CRUD operations with geolocation data
- Historical time-series data with date filtering
- Multi-period analysis (12-month, 5-year, 20-year averages)
- Interactive Swagger UI and CI/CD with GitHub Actions
Local database: https://github.com/obj809/local-db-water-dashboard-nsw
Python 3, MySQL 8.0+, PostgreSQL (Supabase), Pandas, OpenPyXL, psycopg2-binary
- NSW dams with metadata, coordinates, and grouping system
- 24-month historical snapshots with time-series data
- Rolling average analysis (12-month, 5-year, 20-year)
- Visit my LinkedIn for more details.
- Check out my GitHub for more projects.
- Or send me an email at obj809@gmail.com
Thanks for your interest in this project. Feel free to reach out with any thoughts or questions.
Oliver Jenkins © 2025