Skip to content
Back to projects
Completed

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.