Software Development
TUKLAS | Missing & Unidentified Persons Information System
A full-stack web platform that centralizes the reporting, tracking, and matching of missing and unidentified persons across all 128 barangays of Baguio City. (Cases in the image are not real cases and for demo purposes only)
Problem
- No centralized digital platform for tracking missing persons citywide.
- Cross-referencing missing and unidentified cases was entirely manual.
- The public had no way to browse or submit reports online.
- No audit trail, role controls, or structured verification workflow for staff.
Solution
- Public report submission with photo upload — no account required
- Automated case matching engine using TF-IDF, Haversine distance, age overlap, and gender filtering
- Admin dashboard with 3-tier role system, case verification workflow, and Excel export.
- Immutable audit log enforced at the database level.
- Multi-layer security: JWT auth, PostgreSQL RLS, Helmet.js, and per-endpoint rate limiting.
Impact
- Single source of truth for missing persons cases across Baguio City
- Reduces match identification from manual comparison to automated ranked results.
- Tamper-proof action history for government accountability and DPA compliance.
