The Near Repeat Calculator, developed by Jerry H. Ratcliffe, of the Department of Criminal Justice at Temple University, Philadelphia PA., can help you determine if there is a meaningful repeat and near repeat victimization pattern found within your data. It can also help you determine the space and time ranges where those patterns are most evident. The Near Repeat calculator has very specific input data requirements. The Repeat and Near Repeat Analysis toolset includes a tool to export incidents from a feature class or shapefile to a CSV file in the format required by the Near Repeat Calculator.

To generate a CSV file of incidents formatted for the Near Repeat Calculator, complete the following steps:

1. Browse to the MapsandGeodatabase folder and open the Burglaries.mxd map document.
2. In ArcCatalog or the Catalog window in ArcMap, browse to MapsandGeodatabase\CrimeAnalysisTools.tbx\Repeat and Near Repeat Analysis toolset and open the Export Incident CSV tool.
3. In the Input Feature Class parameter, choose the Burglaries layer.
4. In the Date Field parameter, choose the OFFENDATE field.
5. In the Output Spreadsheet Location parameter, browse to the MapsandGeodatabase folder and select the Output folder, then click Add.
6. In the Output Spreadsheet Name parameter, and provide a name for the new CSV file.
7. Click OK to run the tool, and use the output CSV file as input for the Near Repeat Calculator.