PNP E-P.A.T.R.O.L.
Enhanced Police Activity Tracking and Recording Operational Log — a production patrol logging system supporting the daily operations of 200+ police officers across PNP Bacoor City and PNP Santa Rosa City, enabling centralized patrol tracking and operational reporting.
The problem
PNP units recorded patrol and beat activities on paper and ad-hoc message threads, making it impossible to audit patrol history, verify officer location, or generate operational reports for supervisors in real time.
Role & responsibilities
Primary full-stack developer. Coordinated with PNP Bacoor stakeholders through 15+ client meetings, translated field requirements into features, and owned frontend, backend, database, authentication, deployment, and maintenance.
Architecture
Node.js/Express REST API with TypeScript on the backend; MongoDB for patrol logs and PostgreSQL for structured personnel data; React + Tailwind CSS on the frontend; Railway for hosting and managed data/storage.
Key features
- Real-time activity logging with timestamps, geolocation, and photo evidence
- Role-based access control and secure patrol officer authentication
- Automated operational reports and exportable activity summaries
- Mobile-responsive patrol views used in the field
- Production deployments on Railway with managed databases and storage buckets
Outcomes
200+
police officers supported daily
15+
client meetings for requirement refinement
2
PNP city commands covered
Stack
Node.jsExpressTypeScriptMongoDBPostgreSQLReactTailwind CSSRailway