Satinforlingua · used by the local police
DANA vehicle tracker
A web app that replaced the spreadsheet the local police used to track vehicles damaged in the DANA floods.
The problem
During the DANA floods, the police tracked towed vehicles by hand in a spreadsheet: where each one was, which compound held it and its compensation status. Finding a single car was slow and only possible from a desktop.
What I did
- Migrated the working spreadsheet to a web app that runs on any device.
- Built search and filters by plate, VIN, compound and model.
- Designed a responsive interface meant to be used on a phone, out in the field.
Outcome
The team stopped scanning a spreadsheet by hand: finding an affected vehicle became faster and more reliable.