Harnessing Crime Mapping and GIS Technologies for Public Safety: Analyzing Crime Patterns and Optimizing CCTV Coverage in Apayao, Philippines

Abstract

This study evaluated crime mapping for the strategic placement of Closed-Circuit Television (CCTV) and other targeted security interventions in the province of Apayao. Anchored on Routine Activity Theory, Situational Crime Prevention Theory, and Social Control Theory, the research examined index crimes from 2021 to 2023, categorized into crimes against persons and crimes against property. Utilizing spatial analysis tools, particularly Quantum Geographic Information System (QGIS), the study visualized crime distribution across seven municipal police stations in Apayao. Data were obtained from the Crime Information Reporting and Analysis System (CIRAS) through the Provincial Investigation and Detective Management Unit (PIDMU). Findings revealed that rape consistently ranked as the most prevalent crime against persons, while theft dominated crimes against property. Crime Clearance Efficiency (CCE) ranged from 91.6% to 100%, and Crime Solution Efficiency (CSE) from 75.76% to 92% over the three-year period. Thematic crime maps demonstrated patterns and hotspots, which informed recommendations for optimized CCTV deployment. Qualitative data further reinforced the quantitative insights, highlighting community perceptions and the need for enhanced surveillance. The study recommends a data-driven approach for CCTV allocation, integrated community involvement, and sustained police-community partnerships to strengthen crime prevention efforts in Apayao.

Keywords: Crime mapping, CCTV placement, Apayao, crime prevention, QGIS, index crimes, police efficiency, spatial analysis, public safety