CIRAS-Link: Crime Data Classification Tool

Transform Crime Statistics Data

Process CIRAS v2 crime data files to add OFFENSE CATEGORY classifications and standardize the 8 Focus Crimes for PNP reporting

Drag and drop files here or click to selectLimit 200MB per file • XLS, XLSX

How to Use This Tool

Upload one or more Detailed Crime Analysis Excel files (.xls, .xlsx) from CIRAS v2
Click "Process Files" to automatically:
- Merge multiple data files into a unified dataset
- Add OFFENSE CATEGORY column based on crime descriptions
- Simplify the 8 Focus Crimes into standardized classifications
- Format data for compatibility with PNP reporting systems
When processing completes, download your formatted file for immediate use in reports
Save hours of manual data formatting and classification work with a single click

Data processing is performed by a high-performance Fast API Python backend, enabling efficient handling of large datasets.