Propuesta de un sistema de visualización de los principales delitos sucedidos en el Distrito Metropolitano de Quito a partir de datos públicos de la web

Abstract

This academic article proposes the design and implementation of a heatmap visualization system based on publicly available data obtained from the web, focusing on the graphical presentation of crime incidence in the Metropolitan District of Quito (DMQ). The objective is to provide an accessible tool that allows for the visualization of the most frequent crimes and their occurrence in specific circuits over time. To carry out this article, web scraping was used to extract data from the public news website of El Comercio newspaper. Then, a data cleaning process was performed using Python, and it was further processed using Power BI to obtain the dashboards that are exported and visualized on a free web page. The final product presents different dashboards, including bar graphs and heatmaps, which allow for differentiation of the most and least committed crimes through color. Another dashboard shows the crimes georeferenced and nested according to their type, providing a date selection tool. One of the obtained results shows the "threat" crime in first place with 26.58 % and the "domestic violence" crime in last place with 0.53 % during the period from 2009 to 2023, while highlighting the Eloy Alfaro circuit as having the highest quantity of crimes.