GIS case study

Crime Incident Analysis and ArcPy Automation

A repeatable geoprocessing workflow for incident analysis, spatial joins, summary tables, sorting, and geodatabase cleanup.

Objective

Build a repeatable ArcPy workflow for organizing and summarizing multiple crime incident datasets within a file geodatabase.

Workflow

  1. Prepare burglary, assault, and arson feature classes.
  2. Use spatial joins to connect incidents with precincts or nearby landmarks.
  3. Create summary tables and sort counts in descending order.
  4. Remove unnecessary fields and clean intermediate geodatabase outputs.
  5. List the final feature classes and tables to verify the deliverables.

Skills demonstrated

ArcPy, geoprocessing automation, spatial joins, summary statistics, table sorting, field management, file geodatabases, and workflow validation.

Portfolio evidence to add

Add a workflow diagram, one final map, a short code excerpt, and a table showing the final summarized output. Include only results produced from the completed analysis.

← Back to all projects