Page History

The following step-by-step instructions and screenshots are based on the Windows 10 operating system with the Windows Classic desktop theme and ArcGIS Pro 2.1.3 software. If your personal system configuration varies, you may experience minor differences from the instructions and screenshots.

PART I: Install the R-ArcGIS bridge1.

1. Download R and RStudio
   R link:
   R Studio link:
   

1. 
   
2. Prepare data on Houston crime statistics
   2.1. Houston crime GIS data (shapefile) link:
   https://cohgis-mycity.opendata.arcgis.com/datasets/hpd-nibrs-crime
   Note:

1. 
   
   2.2. Houston crime statistics (supplementary) link:
   https://www.houstontx.gov/police/cs/Monthly_Crime_Data_by_Street_and_Police_Beat.htm
   Note:

To use it, you need to select your interested area (general areas listed in the website with link above) of Houston as well as a specific beat (each beat is described in detail, with general street boundaries and landmarks / neighborhoods, ZIP codes that are within that beat, a detailed map, and a text description of the boundaries of the beat).

Since this is the monthly date, you also need to choose the month you want.

After choosing the month to view, you will be presented with a table containing the stats for the below crimes for which we wrote police reports in the selected beat and month. The table will show the type of offense, date and time, district and beat, premise code of the location, block numbers and street name. For privacy reasons, exact addresses are not shown, only the hundred blocks. Each month's statistics are posted by the end of the following month

1. 
   
2. Create a new project in ArcGIS Pro

1. Install the R-ArcGIS bridge: automatical method/manual method

PART II: Basic statistical analysis1.

1. Aggregate point data by counts within a defined location

1. 
   
2. Analyze crime hot spots: One step forward

PART III: Enhance the dataset with additional attributes1.

1. Add additional attributes to the original dataset

1. 
   
2. Further prepare the dataset

PART IV (KEY SECTION): Conduct statistical analysis using R and ArcGIS Pro

1. Bridge your data into R
   
   
2. Calculate smoothed crime rates
   
   
3. Continue analysis in ArcGIS Pro
   
   
4. Identify areas with unusually high crime rates
   

PART V (KEY SECTION): Identify attributes that influence crime

1. Create a correlation matrix in R to evaluate attribute relationships