Sistema para el reporte y alerta de riesgos relacionados con seguridad ciudadana en Bogotá por medio de una aplicación e infraestructura telemática

Abstract

This work presents the design and development of a telematic system that seeks to provide an application for citizens to participate in reporting public safety issues in Bogotá, with the generation of alerts and collaborative reports. The system is based on a client-server architecture deployed on infrastructure as a service (IaaS) on Google Cloud Platform, integrating Firebase services for push notification management and unstructured storage.

The backend component was built using .NET Core under a modular monolith architecture, protected by a strict perimeter security topology (Cloud Firewall) and a reverse proxy (Nginx) for TLS cryptographic tunnel termination. MongoDB was used as a NoSQL database for flexible document management and Websocket for real-time event transmission. The mobile application was developed in Flutter, allowing for the geolocation of incidents and the activation of a panic button that creates live streaming rooms to share the location with emergency contacts. Additionally, an open data web portal was implemented in React for querying and downloading statistical information. Prototype validation included unit and functional testing to ensure the technical reliability of the proposed solution.