Skip to main content
The Vehicle Tracking module provides a complete system for registering stolen vehicles, tracking recoveries, and searching the stolen vehicle database using multiple criteria.

Overview

This module enables law enforcement to:
  • Register stolen vehicle reports
  • Track vehicle recovery status
  • Search by license plate, chassis, or engine number
  • Monitor vehicle theft patterns
  • Document vehicle and owner information
  • Update recovery status and location

Vehicle Registration System

Stolen Vehicle Report

When a vehicle theft is reported, comprehensive information is captured:
1

Jurisdictional Information

  • Regional Unit (Unidad): Select from UR-1 through UR-12
  • Dependency (Dependencia): Select the specific police station
  • Auto-populated based on Regional Unit selection
2

Report Details

  • Date (Fecha): Date of theft report
  • Preventive Number (NRO PREV): Case number
  • Preventive Year (AÑO PREV): Report year
  • Location (Localidad): City or town where theft occurred
3

Owner Information

  • DNI: National ID of vehicle owner
  • Name (APELLIDO NOMBRE/S): Full name of owner
4

Vehicle Information

  • Vehicle type, identification numbers, and characteristics

Vehicle Identification

Tipo de Rodado (Vehicle Class):

AUTOMOTOR

Standard automobiles

MOTOVEHICULO

Motorcycles and motorbikes

CAMION

Trucks and commercial vehicles

TRACTOR

Tractors and agricultural vehicles

Duplicate Prevention

The system validates each vehicle registration:
// Duplicate check logic
$sql = "SELECT COUNT(cod)
        FROM vehiculos_robados
        WHERE dominio='$dominio'";
        
if ($row[0] > 0) {
    alert('EL DOMINIO $dominio YA ESTA CARGADO');
    // Registration blocked
}
If a license plate is already registered as stolen, the system prevents duplicate entry and alerts the officer.

Recovery Tracking

Recovery Status

The system tracks whether stolen vehicles have been recovered:
HABIDO (Located/Recovered):
  • SELECCIONAR: Default/Not yet determined
  • SI: Vehicle has been recovered
  • NO: Vehicle still missing
When a vehicle is recovered (HABIDO = SI), additional fields capture:
[
  "fecha2"       => "Recovery date",
  "lugarHabido"  => "Location where found"
]
These fields document:
  • Exact date of recovery
  • Precise location where vehicle was found
  • Can be updated after initial report

Database Storage

Complete vehicle records are stored with all details:
INSERT INTO vehiculos_robados VALUES(
    '$ur',           // Regional unit
    '$depe',         // Dependency
    '$fecha',        // Report date
    '$dni',          // Owner DNI
    '$apeynom',      // Owner name
    '$vehiculo2',    // Vehicle characteristics
    '$habido',       // Recovery status
    '$fecha2',       // Recovery date
    '$localidad',    // Theft location
    '$lugarHabido',  // Recovery location
    '$vehiculo',     // Make/model
    '$vehiculo3',    // Vehicle type
    '$dominio',      // License plate
    '$chasis',       // Chassis number
    '$motor',        // Engine number
    $nro,            // Preventive number
    $anio            // Preventive year
)

Vehicle Search System

The search interface (buscar_dominio.php) provides multiple search methods:

Search Options

License Plate Search

NRO DE DOMINIOSearch by license plate number
  • Format: XXX123
  • Case-insensitive
  • Partial matching supported

Chassis Number Search

NRO DE CHASISSearch by chassis/VIN
  • Up to 30 characters
  • Partial matching supported
  • Exact identification

Engine Number Search

NRO DE MOTORSearch by engine number
  • Up to 30 characters
  • Partial matching supported
  • Alternative identification

Brand Search

MARCASearch by vehicle brand
  • Make/model matching
  • Partial text search
  • Broad category search

Search Implementation

Each search method uses pattern matching:
SELECT fecha, ur, depe, dni, apeynom, dominio,
       datos_vehiculo, fecha_ubicacion, lugar_habido,
       cod, habido, nro, anio, chasis, motor
FROM vehiculos_robados 
WHERE dominio ILIKE '%$dominio%'
Partial Matching: All searches use ILIKE for case-insensitive partial matching, allowing flexible searches even with incomplete information.

Search Results Display

Results are presented in a comprehensive table format:

Results Table Columns

ColumnDescription
FECHADate theft was reported
UNIDADRegional Unit handling case
NRO PREVENTIVOCase number (NRO/AÑO format)
DEPENDENCIASpecific police station
DNIOwner identification
APELLIDO Y NOMBRESOwner full name
DOMINIOLicense plate
MARCAVehicle make/model/characteristics
CHASISChassis number
MOTOREngine number
HABIDORecovery status (SI/NO)
FECHA HABIDORecovery date (if found)
LUGAR HABIDORecovery location (if found)

No Results Handling

if ($row[0] == 0) {
    echo "NO SE ENCONTRO NINGUN REGISTRO";
    // Display "No records found" message
}
The system provides clear feedback when searches return no results, allowing officers to refine their search criteria.

Workflow Examples

Registering a Stolen Vehicle

1

Access Registration Form

Navigate to Vehicle Tracking module and select “Register Stolen Vehicle”
2

Select Jurisdiction

  • Choose Regional Unit
  • Select Dependency (auto-populates based on UR)
3

Enter Report Details

  • Date of theft
  • Preventive case number and year
  • Location of theft
4

Document Owner

  • Owner’s DNI
  • Owner’s full name
5

Vehicle Information

  • Select vehicle type
  • Enter license plate (format: XXX123)
  • Enter chassis number
  • Enter engine number
  • Describe make, model, and characteristics
6

Initial Recovery Status

  • Set HABIDO to “NO” (not yet recovered)
  • Leave recovery date and location blank
7

Submit Registration

Click GUARDAR (Save) - system validates uniqueness and saves

Updating Recovery Status

1

Search for Vehicle

Use license plate, chassis, or engine number to find the record
2

Open Record for Edit

Access the vehicle record from search results
3

Update Recovery Fields

  • Change HABIDO to “SI”
  • Enter recovery date (FECHA UBICACION)
  • Enter recovery location (LUGAR HABIDO)
4

Save Changes

System updates record with recovery information

Best Practices

Always verify chassis and engine numbers carefully as these are primary identifiers for vehicle recovery.
Incorrect identification numbers can prevent successful recovery identification.
Include as much detail as possible in the vehicle characteristics field:
  • Exact color
  • Distinctive marks or damage
  • Aftermarket modifications
  • Special features or accessories
Register stolen vehicles immediately to maximize chances of recovery and enable rapid database checks.
Update recovery status promptly to maintain database accuracy and prevent unnecessary searches.

Data Integrity

Validation

  • License plate uniqueness check
  • Required field validation
  • Date format verification
  • Regional unit assignment

Data Quality

  • Standardized vehicle types
  • Consistent date formats
  • Normalized location data
  • Complete identification numbers

Build docs developers (and LLMs) love