San Francisco Crime Incidents

Darianne Lopez

Top 7 Incident Types Called into the San Francisco Police Department




Individual Categories

Assault02040 Burglary0102030 Larceny Theft050100150200 Lost Property0102030 Malicious Mischief02040 Non-Criminal02040Other Miscellaneous0204011/16/1801/08/1801/25/1801/31/1804/17/1808/19/1809/06/1812/26/1801/16/1803/11/1804/06/1804/12/1805/31/1806/17/1809/27/1812/10/1801/03/1801/18/1802/19/1803/15/1804/01/1805/04/1808/16/1810/02/1810/19/1810/22/1810/30/1811/15/1811/18/1811/26/1812/01/1812/03/1801/15/1802/23/1804/15/1804/24/1808/01/1808/12/1809/10/1810/09/1810/14/1810/26/1811/07/1811/29/1812/24/1801/21/1802/16/1802/28/1803/20/1803/28/1805/02/1807/10/1807/20/1808/09/1809/22/1810/15/1810/24/1811/17/1811/27/1812/11/1812/25/1801/02/1801/26/1802/20/1803/01/1803/26/1804/29/1805/07/1806/13/1809/05/1810/12/1811/08/1811/21/1811/30/1812/05/1812/21/1812/23/1803/06/1803/19/1803/21/1805/29/1806/18/1807/03/1807/18/1807/21/1807/26/1808/08/1809/15/1809/16/1809/17/1809/30/1811/20/1812/07/1812/19/1801/29/1802/11/1802/14/1802/26/1803/25/1805/14/1806/07/1807/09/1808/05/1809/12/1809/13/1809/26/1810/08/1810/16/1811/06/1812/13/1812/22/1801/07/1801/22/1802/25/1805/03/1805/10/1805/28/1806/14/1806/22/1807/17/1807/22/1808/04/1808/24/1810/11/1810/23/1810/27/1811/05/1811/11/1811/12/1811/13/1801/17/1801/24/1802/08/1802/10/1802/13/1802/18/1802/21/1802/22/1803/03/1803/05/1803/12/1804/10/1804/27/1805/15/1805/20/1805/23/1805/30/1806/10/1807/11/1807/12/1808/15/1808/23/1810/05/1810/10/1811/04/1811/23/1812/16/1801/23/1803/07/1803/24/1805/08/1806/04/1806/12/1807/05/1807/23/1807/28/1808/10/1808/18/1808/28/1808/29/1808/31/1809/11/1809/18/1809/20/1809/23/1809/25/1810/18/1812/04/1801/09/1801/10/1801/12/1801/27/1803/09/1803/13/1803/27/1804/04/1804/21/1804/30/1805/24/1806/02/1806/15/1806/21/1807/06/1807/13/1808/14/1809/03/1811/19/1811/22/1811/24/1812/20/1812/27/1801/11/1801/14/1802/27/1804/05/1805/21/1805/22/1806/19/1806/25/1806/29/1807/31/1809/04/1809/08/1809/09/1809/14/1809/19/1809/24/1810/21/1811/25/1812/02/1812/28/1801/01/1802/05/1803/10/1803/16/1803/29/1804/08/1804/14/1804/25/1805/26/1806/08/1806/28/1807/15/1807/30/1808/07/1809/21/1810/04/1810/13/1811/03/1812/12/1812/17/1812/30/1801/04/1802/09/1803/02/1803/04/1803/22/1804/03/1805/13/1805/19/1806/11/1806/26/1806/27/1807/02/1807/25/1808/06/1808/17/1809/28/1810/25/1810/29/1811/28/1812/18/1801/06/1801/19/1801/28/1802/12/1802/15/1802/17/1802/24/1804/02/1804/18/1804/23/1804/26/1805/17/1806/05/1808/20/1808/21/1809/01/1810/01/1810/03/1811/10/1812/06/1801/05/1803/14/1804/11/1804/16/1805/01/1805/06/1805/09/1805/11/1805/16/1807/16/1808/03/1808/13/1808/26/1802/03/1802/07/1804/09/1805/05/1806/01/1806/03/1806/06/1806/09/1807/01/1807/07/1808/25/1809/07/1810/06/1810/28/1811/01/1811/02/1812/14/1812/15/1812/29/1803/08/1803/23/1806/30/1807/04/1807/27/1808/22/1810/07/1810/20/1811/14/1812/09/1801/13/1801/20/1802/06/1803/30/1803/31/1804/22/1805/12/1807/19/1807/29/1810/17/1802/02/1803/18/1806/16/1808/02/1802/04/1803/17/1804/28/1806/23/1807/14/1807/24/1808/27/1809/02/1809/29/1811/09/1802/01/1806/24/1804/07/1806/20/1808/11/1804/13/1805/25/1807/08/1808/30/1812/08/1810/31/1805/27/1801/30/1804/20/1804/19/1805/18/1812/31/18

About these Visualizations

This stacked area chart visualization's purpose is to get an idea of what types of crimes comprise most of San Francisco's crime. I limited the number of crime categories to seven for the purpose of this area chart, as there were many categories from the data. In this chart we notice that Larceny Theft is the main offense recorded by SFPD in 2018. This followed by Other Miscellaneous, Assault, Non-Criminal, Malicious Mischief, Burglary, and Lost Property. This is a stacked area chart where the date column, which was wrangled as the month of the incident, is encoded as x position on a linear scale and the number of incidents (i.e., the count of all incident categories on a specified day) is encoded on the y axis. The areas are differenciated by the incident categories column and is limited to show only the top seven incident categories sorted by the count of incident categories.
Below the stacked area chart you will find individual area charts allowing you to probe the data. Stacked area charts often make it difficult to imagine an area chart on its own, so the chart here is intended to help with just that. From this chart we can notice that over time, assault report counts have risen over 2018.

Alpha Release Prototype: