Introduction

This final project expands upon my geospatial analysis of crimes in San Francisco. We will explore the top crimes based on neighborhood, taking a look at location based crime.

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, cleaned up my data and categorized location into neighborhoods, and focused the incident crime column into a subcategory of property crimes. After cleaning up the data in Tableau Prep, I was ready to create visualizations and charts to make sense of the data.

##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: Proportion of Crimes in San Francisco

This map highlighs the areas in San Francisco where crimes occur most frequently. We can see how crimes are linked to specific areas in the city. Certain areas of the city hold a large percetage of the overall percent of crime reported.

Neighborhood Rankings by Crime Rate

To discover the most dangerous areas in the city in terms of property crime, I decided to look into crimes based on neighborhoods with the highest reported crimes. This graph shows that Mission, Financial District/South Beach and South of Market were the top three most crime ridden neighborhoods.

Top Three Most Dangerous Neighborhoods by Crimes Committed

Number 1: Misson

The Misson neighborhood reported high rates of theft and burglary from houses/apartments and vehicles.

Number 2: Financial District/ South Beach

The Financial District/South Beach shows high rates of larceny and burglary of non-residential places like stores and commercial buildings.

Number Three: South of Market

South of Market reported similar crimes to Mission and Financial District. It’s ranking as #3 among the neighborhoods may be due to its smaller size.

Conclusion

Crime rates in San Francisco are extremely high in comparison to the rest of the cities in the United States. My analysis proved that crimes in San Francisco are strongly linked to certain locations. With this knowledge in mind, lawmakers and police can optimize their force to solve the dangers to those who live near those areas by combating these frequent occurances of larceny and burglary.