Skip to main content
The Seguridad system provides comprehensive reporting capabilities for generating official documentation, statistical summaries, and data exports.

​
Overview

The reporting module enables users to create structured reports, fill out statistical forms (planillas), and export data for analysis or official documentation.

​
Report Types

​
Incident Detail Reports

Detailed reports showing individual crime incidents with complete information.

Preventivos Detail Report

Generated via preventivos_detalle.php, this report displays:
  • Regional Unit (UR)
  • Department (Dependencia)
  • Incident description (Hechos)
  • Location (Lugar)
  • Date (Fecha)
  • Complainant (Denunciante)
  • Case status (Esclarecido)
Access Method: Submit the crime query form with desired filtersOutput: Opens in a new window with formatted table results

​
Statistical Summary Reports

Shows all crimes registered within a specific date range, organized by regional unit.Features:
  • Province-wide or unit-specific reporting
  • Date range filtering
  • Organized by category
  • Includes case clearance information
File: resultado_delito.php (in dirgral folder)
Specialized reports for domestic violence and violence against women cases.Query Parameters:
  • d1, m1, a1: Start date (day, month, year)
  • d2, m2, a2: End date (day, month, year)
File: resultadoPlanillaViolenciaFamiliar.php
Reports on police operations including:
  • Roadblocks (Corte de Ruta)
  • Patrols
  • Special operations
  • Control points
Files:
  • resultadoPlanillaCorteRuta.php
  • resultado_estadistica_operativos.php

​
Statistical Forms (Planillas)

​
Overview

The planillas.php system provides structured forms for entering monthly crime statistics manually.

​
Form Structure

​
anio
text
required
YearFour-digit year for the statistical period.
​
mes
select
required
MonthSelect month from:
  • ENERO (January)
  • FEBRERO (February)
  • MARZO (March)
  • ABRIL (April)
  • MAYO (May)
  • JUNIO (June)
  • JULIO (July)
  • AGOSTO (August)
  • SEPTIEMBRE (September)
  • OCTUBRE (October)
  • NOVIEMBRE (November)
  • DICIEMBRE (December)
​
ur
select
required
Regional UnitSelect the regional unit for which statistics are being entered.

​
Crime Categories in Forms

The statistical forms are organized into expandable sections (accordion panels) for each major crime category:
14 distinct crime types including:
  • Hurto (Theft)
  • Robo (Robbery)
  • Robo Calificado (Aggravated Robbery)
  • Daño (Damage)
  • Estafas (Fraud)
  • Usurpación (Usurpation)
  • Extorsión (Extortion)
Each entry includes:
  • Total incident count
  • Number of cases solved (esclarecidos)
17 crime types including:
  • Homicidios (Homicides) - various categories
  • Lesiones (Injuries) - simple and with firearms
  • Amenazas (Threats)
  • Secuestro (Kidnapping)
  • Suicidio (Suicide)
  • Motochorro (Motorcycle robbery)
7 categories of sexual offenses:
  • Abuso Sexual Simple (Simple Sexual Abuse)
  • Abuso Sexual sin/con Acceso Carnal (With/without penetration)
  • Corrupción de Menores (Corruption of Minors)
  • Exhibiciones Obscenas (Indecent Exposure)
  • Delitos Contra la Libertad (7 types): Crimes against freedom
  • Delitos Contra la Administración Pública (5 types): Crimes against public administration
  • Delitos Contra el Orden Público (3 types): Crimes against public order
  • Delitos Contra la Seguridad Pública (2 types): Crimes against public safety
  • Delitos Contra el Honor (1 type): Crimes against honor
  • Delitos Contra el Estado Civil (2 types): Crimes against civil status
  • Otros Delitos y Leyes Especiales (5 types): Other crimes and special laws

​
Form Submission

1

Select Period

Choose the year and month for which you’re entering statistics.
2

Select Unit

Choose the regional unit.
3

Enter Crime Data

Expand each crime category section and enter:
  • Total number of incidents (var1, var2, etc.)
  • Number of solved cases (e1, e2, etc.)
4

Submit Form

Click “GUARDAR” (Save) to submit the statistical data.
Default values are set to “0” for all fields. Only update fields with actual data.

​
Data Export Formats

​
Available Export Options

PDF Export

Generate official PDF reports with formatted tables and headers, suitable for printing and archival.

Excel/CSV Export

Export raw data to spreadsheet formats for further analysis, charting, or integration with other systems.

Print View

Browser-optimized print layout for generating physical copies of reports.

Screen Display

Interactive on-screen tables with sorting and filtering capabilities.

​
Report Generation Workflow

1

Navigate to Report Type

Access the appropriate report module based on your needs:
  • Crime statistics
  • Operations reports
  • Statistical forms
  • Specialized reports (violence, traffic, etc.)
2

Set Parameters

Configure report parameters:
  • Date ranges
  • Geographic scope (units, departments)
  • Crime types or categories
  • Additional filters
3

Generate Report

Click the “BUSCAR” or “GUARDAR” button to generate the report or save data.
4

Review Results

Examine the generated report for accuracy and completeness.
5

Export or Print

Use export functions to save the report in your desired format, or print directly from the browser.

​
Specialized Reports

​
Traffic Accident Reports

Transit Reports

Specialized reports for traffic accidents and violations.Features:
  • Accident location mapping
  • Vehicle information
  • Injury/fatality tracking
  • Date and time analysis
Access: resultado_transito.php

Motocicleta Reports

Reports focusing on crimes involving motorcycles, including motorcycle theft and “motochorro” incidents.Access: resultado_motocicleta.php

​
Vehicle Search Reports

Vehicle Domain Search

Search and report on vehicles by license plate (domain).Features:
  • License plate lookup
  • Vehicle involvement in incidents
  • Stolen vehicle database checks
Access: resultado_buscar_dominio.php

​
Report Tables

​
Standard Report Format

Most reports use a consistent table structure:
ColumnDescription
URRegional Unit
DependenciaPolice Department/Station
HechosIncident Description
LugarLocation
FechaDate
DenuncianteComplainant/Reporter
EsclarecidoCase Status (Solved/Unsolved)

​
Report Headers

Reports typically include:
  • Report title with date range
  • Geographic scope (province, unit, department)
  • Query parameters used
  • Generation timestamp

​
Data Validation

Important Validation Rules:
  • Date ranges must be valid (start date before end date)
  • Year fields must be 4 digits
  • Month selections must be from the predefined list
  • Unit and department selections must match database records
  • Numeric fields in forms must contain valid numbers

​
Database Integration

Reports query and display data from key tables:
  • delitos - Main crime incidents
  • operativos - Police operations
  • tipo_delito - Crime type definitions
  • ur - Regional units
  • dependencia - Police departments
  • estadistica_delictual - Statistical summaries

​
Best Practices

Regular Updates

Enter statistical form data regularly (monthly) to maintain accurate records.

Data Verification

Review generated reports for accuracy before exporting or distributing.

Backup Reports

Export and save important reports in multiple formats for redundancy.

Consistent Formatting

Follow standard naming and formatting conventions for exported files.

Statistics

Query and analyze crime statistics with flexible filtering

Maps

Visualize crime data and operations geographically

Build docs developers (and LLMs) love

Get started for freeTalk to us