Routeline
Fleet, fuel and driver performance backed by Postgres. Real rows, real totals, real anomaly detection — not a polished mock.
Category
Web App
Scope
Fleet operations dashboard
Role
Backend + dashboard engineer
Timeline
5 months · 2024
Overview
The story
Routeline is a logistics operations dashboard that tracks fleet expenses, fuel consumption and driver performance. It consolidates trip logs, fuel receipts and maintenance entries into one place so operations leads can compare trucks, spot anomalies and budget routes with real numbers.
Problem
Fuel fraud was suspected on long-haul routes. Receipts came in on paper weeks later and there was no way to compare drivers, routes or trucks fairly.
Solution
Driver companion app captures expenses at source. Backend computes per-truck km/L, flags anomalies vs that truck's own baseline, and surfaces the worst offenders weekly.
Business value
Turns scattered fuel and trip slips into structured operational data fleet managers can act on within the same day.
Outcome
Identified a 14% monthly fuel leak in the first month, recovered KES 380k/quarter, and gave drivers a fair, transparent scoring system.
Highlights
- Per-truck expense breakdown
- Fuel consumption tracking
- Anomaly detection (baseline vs current)
- Driver performance metrics
- Live totals and KPIs
- Database-backed trip log
Tech stack
- Node + ExpressAPI & analytics
- PostgreSQL + TimescaleDBTrip & fuel time-series
- React + TanStack QueryOps dashboard
- FlutterDriver companion app
Fuel leak caught
14%
month one
Quarterly savings
KES 380k
first 90 days
Trucks tracked
24
across 3 depots
Anomaly latency
<24h
from receipt to alert
How it was built
Process
- 1
Audit
Sampled 3 months of paper receipts to model the real noise floor in fuel consumption.
- 2
Baseline
Computed per-truck rolling km/L baselines so alerts are fair to old vs new trucks.
- 3
Capture
Shipped a Flutter app for drivers so receipts get photographed at the pump, not weeks later.
- 4
Act
Weekly digest emailed to ops lead with the top 3 anomalies and suggested next actions.
"We stopped arguing about fuel. The dashboard just shows it."
S. Wanjiru · Operations Manager
Live demo
Try it now
Real interface wired to a live database — changes you make persist for every visitor.
Fleet spend (wk)
KES 0
this week
Completed trips
0
across fleet
Avg km / litre
—
fleet-wide
Active rigs
0 / 0
now on road
Fuel burn (14 days)
Peak
73 L
Avg
59 L
Trend
+8% w/w
Live route map
0 rigs streaming GPS via the driver companion app.
Active fleet
Loading fleet…
Spend by truck
Alerts
- All other trucks on schedule