Skip to main content
The Seguridad system provides comprehensive statistical analysis tools for crime data, allowing users to generate detailed reports based on various criteria.

​
Overview

The statistics module enables authorized users to query crime data across different time periods, geographic regions, and crime types. The system supports both detailed incident-level reporting and aggregated statistical summaries.

​
Statistical Query Features

​
Date Range Filtering

Query crime data within specific date ranges:
​
desde
date
required
Start date for the query range (format: DD-MM-YYYY or YYYY-MM-DD)
​
hasta
date
required
End date for the query range (format: DD-MM-YYYY or YYYY-MM-DD)
When querying with “TODOS” (all units/dependencies), the date range cannot exceed 12 months to prevent database overload.

​
Geographic Filters

​
ur
select
Unidad Regional (Regional Unit)Select a specific regional unit or “TODOS” for all units. Options are dynamically loaded from the ur table.
​
dependencia
select
Dependencia (Department/Station)Cascading dropdown that loads departments based on the selected regional unit. Disabled until a unit is selected.

​
Crime Type Classification

The system categorizes crimes into major groups:
  • Hurto (Theft)
  • Hurto en Grado de Tentativa (Attempted Theft)
  • Hurto de Ganados y Abigeato (Livestock Theft)
  • Hurto de Automotores (Motor Vehicle Theft)
  • Hurto de Motovehículo (Motorcycle Theft)
  • Robo (Robbery)
  • Robo Calificado (Aggravated Robbery)
  • Daño (Property Damage)
  • Estafas y Otras Defraudaciones (Fraud)
  • Usurpación (Usurpation)
  • Extorsión/Secuestro Virtual (Extortion/Virtual Kidnapping)
  • Abandono de Persona (Abandonment)
  • Amenazas (Threats)
  • Lesiones Simples (Simple Injuries)
  • Lesiones con Armas de Fuego (Firearm Injuries)
  • Homicidios (Homicides)
  • Homicidio con Arma Blanca (Stabbing Homicide)
  • Homicidio con Arma de Fuego (Firearm Homicide)
  • Suicidio (Suicide)
  • Secuestro (Kidnapping)
  • Motochorro (Motorcycle Robbery)
  • Abuso Sexual Simple (Simple Sexual Abuse)
  • Abuso Sexual sin Acceso Carnal (Sexual Abuse without Penetration)
  • Abuso Sexual con Acceso Carnal (Sexual Abuse with Penetration)
  • Corrupción de Menores (Corruption of Minors)
  • Exhibiciones Obscenas (Indecent Exposure)
  • Delitos Contra la Libertad (Crimes Against Freedom)
  • Delitos Contra la Administración Pública (Crimes Against Public Administration)
  • Delitos Contra el Orden Público (Crimes Against Public Order)
  • Delitos Contra la Seguridad Pública (Crimes Against Public Safety)
  • Delitos Contra el Honor (Crimes Against Honor)

​
Additional Filter Criteria

​
tipo_delito
select
Crime TypeFilter by specific crime type from the tipo_delito table, or select “TODOS” for all types.
​
modus_operandi
select
Modus OperandiFilter by the method or pattern of crime execution. Options loaded from modus_operandi_preventivos table.
​
esclarecidos
select
default:"T"
Case Status
  • T: TODOS (All cases)
  • S: SI (Solved cases only)
  • N: NO (Unsolved cases only)

​
Statistical Reports

​
Crime Statistics Report

Accessed via consultaDelito.php, this report provides:
  • Detailed incident listings
  • Crime counts by type and location
  • Temporal analysis of crime patterns
  • Case clearance rates

​
General Statistics

The consultaEstadistica.php module provides:
  • Monthly and annual crime summaries
  • Crime type breakdowns by unit
  • Comparative statistics across regions
  • Trend analysis over time

​
Monthly Statistical Forms

The planillas.php system allows manual entry of monthly statistics organized by crime category, including:
  • Year and month selection
  • Regional unit assignment
  • Detailed crime counts by category
  • Solved cases (esclarecidos) tracking
Statistical forms use an accordion interface to organize the extensive list of crime categories, making data entry more manageable.

​
Data Export

Export Functionality

Reports can be exported in various formats:
  • PDF reports for official documentation
  • Excel/CSV exports for further analysis
  • Printable formatted views
Export functions are typically accessed through the report results pages (preventivos_detalle.php, resultadoDelito.php).

​
Query Execution

1

Select Filters

Choose the regional unit, department, date range, and crime type criteria for your query.
2

Apply Additional Criteria

Optionally filter by modus operandi and case status (solved/unsolved).
3

Execute Query

Click the “BUSCAR” (Search) button to generate the report. Results open in a new window.
4

Review Results

Analyze the detailed results table showing incidents matching your criteria.
5

Export Data

Use export functions to save or print the report for further use.

​
Database Schema

The statistics module queries the following key tables:
  • delitos - Main crime incidents table
  • tipo_delito - Crime type classifications
  • ur - Regional units
  • dependencia - Police departments/stations
  • modus_operandi_preventivos - Crime methods/patterns

​
Performance Considerations

Large queries (e.g., all units over extended periods) may take significant time to process. The system enforces a 12-month maximum for province-wide queries to maintain performance.

Map Visualization

View crime statistics on interactive maps

Reports

Generate formatted reports and forms

Build docs developers (and LLMs) love

Get started for freeTalk to us