Dam inspection reporting
Dam-inspection dashboard: anomalies by category, dam and month, PDF and Excel reports, email alarms and configurable rules.
What it is
A web application to make use of the dam inspections already recorded in another system, which it reads read-only: the rules and alarms live in its own database. Built on my own, from zero to production.
What it does
- Dashboard with period, dam and template filters that apply to the whole view: inspections, completed, not correct and anomalies by category, dam and month, with critical ones separated from warnings.
- Reports by dam, by route, a template’s history and anomalies by category and site, on screen, as PDF and as Excel.
- Email alarms for inspections that are not correct, with a log of what was sent.
- Configurable rules: which value makes an item incorrect and from which level an anomaly is critical.
- Access from the source system with a signed token that the API exchanges for a session.
How it’s built
Svelte 5, TypeScript, Vite, Tailwind 4 and TanStack charts. Async FastAPI API with SQLAlchemy; PDFs are generated with Chromium (Playwright) and Excel files with openpyxl. E2E tests in three browsers, ruff, mypy and pytest.
Other work with a related technical focus:
Reservoir and Dam Emergency Management
Digitises a dam's Emergency Plan: scenarios, mandatory actions, an auditable log and drills across several dams. WCAG 2.2 AA.
Executive monitoring dashboard
Strategic-management panel for infrastructure monitoring: advanced data table, cascading filters, reactive KPIs and interactive maps, in 4 languages, WCAG AA.
Structural health monitoring
Web platform that auscultates bridges and buildings via vibrations: automatic operational modal analysis (OMA), tracking and damage alerts.