Part 1: Excel

1. Sort and filter the Crime CSV obtained from the Vancouver Police Department to include only crime data from 2016

Part 2: ArcGIS

1. Create a geodatabase using the Neighbourhoods and CT shapefiles.

2. Clip the CT shapefile using the Neighbourhoods layer as the output feature. This new layer (CT_Clip) will be used later on to perform the hotspot analysis.

3. Import the 2016 Crime data using the Add XY data function and export it as a layer file.

4. Join the 2016 Crime data table to the Neighbourhoods layer. Added a field (Crime Type) and assigned each type of crime a numerical value. 

5. Select by Attributes using an SQL Query to extract the winter (December, January, February) and summer (June, July, August) months from the 2016 Crime table.

6. Use the Collect Events tool from the Spatial Statistics toolbox on 2016 Crime layer to create a feature class containing weighted points. These weighted points are calculated by summing all incidents at each unique location. Repeat this step for the Winter and Summer Crime layers.

7. Perform an Optimized Hotspot Analysis using the 2016 collect events output layer. Count incidents analyzed within fishnet polygons using the CT_Clip layer as the bounding polygon. Repeat for Winter and Summer Crime layers. For choropleths count incidents were analyzed within aggregate polygons

8. Create a density surface using the Geostatistical Analyst Wizard using the newly created Hotspot layers.