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
- Prepare burglary, assault, and arson feature classes.
- Use spatial joins to connect incidents with precincts or nearby landmarks.
- Create summary tables and sort counts in descending order.
- Remove unnecessary fields and clean intermediate geodatabase outputs.
- 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.