Geography of Crime

Tutorial library · 80 videos

Crime analysis, step by step.

Each video solves one task. Pick a track, or search by task, like "kernel density" or "spatial join".

Excel

Cleaning, counting, and pivoting crime data.

  1. 01CSV to workbook: sorting, filtering, copy/paste, snip
  2. 02Snipping and the Data Analysis add-in
  3. 03Filtering data
  4. 04COUNTIF and SUMIF
  5. 05XLOOKUP and COUNTIF
  6. 06INDEX and MATCH to join data (VLOOKUP alternative)
  7. 07UNIQUE
  8. 08SWITCH
  9. 09Percent change
  10. 10Selecting blank cells and filling down
  11. 11Merging data with Power Query
  12. 12Ranking values
  13. 13Significant change in counts
  14. 14Blank text values
  15. 15Creating dates
  16. 16Remove duplicates, consolidate, text to columns, flash fill
  17. 17Pivot tables: row and column totals
  18. 18Pivot tables: temporal heat map
  19. 19Pivot tables: slicers
  20. 20Pivot table to map
  21. 21Treemap
  22. 22Appending data
  23. 23Law of crime concentration
  24. 2480/20 rule and risky facilities

Excel mapping

Maps without GIS software.

  1. 01County map
  2. 02State map
  3. 03State and county maps
  4. 04Point map
  5. 05VBA geocoding with Google
  6. 06Pivot table to 3D map
  7. 07Mapping police agencies as points
  8. 08Mapping different spatial units
  9. 09Custom regions: police districts
  10. 10Custom regions: neighborhoods
  11. 11Custom regions: block group data
  12. 12Firearm movement

ArcGIS for Excel

Moving between Excel and Esri.

  1. 01Adding ArcGIS to Excel
  2. 02Using ArcGIS in Excel
  3. 03Excel to ArcGIS Pro

ArcGIS Pro

Joins, fishnets, hot spots, and spatial statistics.

  1. 01Welcome to ArcGIS Pro
  2. 02Symbology examples
  3. 03Legends
  4. 04Creating a final map to share
  5. 05Select by attribute and export features
  6. 06Creating a chart
  7. 07Table joins and spatial joins
  8. 08Spatial joins for counts
  9. 09Select by location
  10. 10Select by attribute, export, and labels
  11. 11Fishnet grid and kernel density (hot spots)
  12. 12Geocoding counties and addresses
  13. 13Geocoding crime incidents
  14. 14Select by attribute and location
  15. 15Creating a fishnet grid
  16. 16Joining point data to a fishnet grid
  17. 17Select by location: points and polygons
  18. 18Projecting data
  19. 19Custom sort
  20. 20Clipping, joins, and summary statistics
  21. 21Crime Analysis toolbox
  22. 22Law of crime concentration
  23. 2380-20 tool for the law of crime concentration
  24. 24Average nearest neighbor
  25. 25Ring buffers, nearest neighbor, deviational ellipse, mean center
  26. 26Buffers and multiple ring buffers
  27. 27Select by location: 'within' and 'within distance'
  28. 28Generate near table
  29. 29Dissolve and planarize streets
  30. 30Adding and calculating fields

Google tools

Scholar, Trends, Earth, and Street View.

  1. 01Google Scholar
  2. 02Google Trends
  3. 03Geocoding with Google
  4. 04Systematic social observation with Google Earth
  5. 05Street View observation with a Google Form
  6. 06ArcGIS output for Google Earth
  7. 07ArcGIS layer to KML

Crime data sources

Where US crime data lives and how to pull it.

  1. 01Crime data sources in the US
  2. 02LEARCAT: Law Enforcement Agency Reported Crime Analysis Tool
  3. 03NIBRS and the Crime Data Explorer
  4. 04CrimeStat IV: introduction and download