Introduction

This project compares crimes committed in San Francisco to the police distribution throughout the city. Geo-spatial maps help aid visualization of the data to provide a clear interpretation of the overall safety of the city.

Data

The data used to conduct this analysis was found on San Francisco’s Open Data website where the data was provided by the Police Department. You can find this data at https://data.sfgov.org/Public-Safety/Police-Department-Incident-Reports-2018-to-Present/wg3w-h783 The dataset contains data from 2018- present detailing police districts, analysis neighborhoods, supervisor districts, incident categories and descriptions, incident date, week, time, and much more. To make sense of this thorough dataset, I primarily focused on the incident category and police district in my analysis. After cleaning up the data in Tableau Prep, I was ready to create visualizations.

##Layout of Project

First, I provide a map depicting all instances of property crimes. I then switched gears and provided a visual of the location of crimes that each police district responds to. To optimize readability I included a map which singled out one district to show its distribution of the crime locations based on assigned police districts notable by color distinctions of each district. The project concludes with two tables: one table comparing the crime incidents and categories across districts and the other comparing the crime incidents by category to their respective districts. Wrapping my project up with these tables provides powerful insight into how San Francisco can best allocate their police force to confront the city’s high property crime rates.

Map 1: Property Crimes 2018-2022

This map illustrates each instance of property crime violations in San Francisco from 2018-2022. We are able to see the overall extreme prevalence of property crimes in the city. It is also important to note that areas with the most prevalent crimes (Northern, Southern and Central districts).

Map 2: Police Department District and Incident Case Locations

This visualization depicts the allocation of police responses to crime locations based on police district. This visual provides an understanding of the landscape of police districts in the city. It is important to note that there were many instances where districts responded to cases outside of their reporting zone. Implications about the allocation of police in San Francisco are highlighted here.

Map 3: Police Department Case Location - Bayview

The Bayview district reported to cases in almost all of the other districts. We could imply that the other districts do not have sufficient police resources placing strain on surrounding districts in the city. Supplementing the San Francisco police work force or reallocating their police could decrease crime rates.

Top Crimes for Each Police Department District

This provides a glance at the crime incidents and categories per district. Authorities can use this information to decipher how to better allocate their police in order to address prevalent crimes within each district.

Top Crimes for Each Police Department District

This table provides a summary of crimes broken down into district they were committed in. Identifying persistent categories of crimes allows authorities to better understand where and how they should work towards a solution for San Francisco’s high property crime rate.