Module 1: Crime Analysis

Part C of the Module 1 assignment was to create hotspot analysis of homicides in the City of Chicago using three different methods. All three methods would utilize a point feature class of the total homicides for 2017 and the City of Chicago boundary. A second feature class of the total homicides for 2018 would then be used to see how well the hotspot predicted the location of homicides.

Grid-based thematic mapping

This method utilized feature classes for the total homicides for 2017, the City of Chicago boundary, and a ½ mile grid cell clipped to the Chicago boundary. All three feature classes were added to a map. The Spatial Join tool was used to create a new feature class that would contain the count of homicides for each grid cell. The Select By Attribute tool was used to select only the cells where the number of homicides was greater than 0. Next, the count column was sorted and the top 20% was selected and then exported to a new feature class. The final feature class was dissolved to create a single polygon for the hotspots.














Kernal Density

This method utilized feature classes for the total homicides for 2017 and the City of Chicago boundary. The Kernel Density tool was used to create a grid with cell size of 100 square miles.













Local Moran’s I

The last method utilized feature classes for the total homicides for 2017, the City of Chicago boundary, and the Census tracts polygons for the Chicago area. The Spatial Join tool was used to create a new feature class that includes the homicide counts in each of the census tract polygons. A new crime rate field was added to the attribute table and the rate was calculated using the below formula:

                !Join_Count! / !total_households! * 1000

The Cluster and Outlier Analysis tool was then used to determine the significant clusters of high crime. A SQL query was performed to select just the high-high clusters features. The selected features were exported to a new feature class and a dissolve was performed to create a single hotspot polygon.














The Kernel Density hotspot polygon contained 73% of the 2018 homicides but also the largest area. This would probably not be the best choice to present to the police chief. The Local Moran’s I hotspot polygon contained 45% of the 2018 homicides and would be my recommendation since it less area for the police force to cover.




Comments

Popular posts from this blog

GIS Programming Module 1 – Python Environments & Flowcharts

GIS Programming Module 2 – Python Fundamentals

GIS 5935 Lab 1 - Calculating Metrics for Spatial Data Quality