FT Crusader Logo

Frogtown, MN, Crime Map 10/23/19

By Frogtown Crusader (Abu Nayeem)

Purpose

As a Frogtown resident, it is important that residents are aware on what is happening around our community and how we address it. Every year, there is commotion about safety. Some community members feel that the community is getting worse, while others are saying its getting better. While the city and police department might be saying something totally different. In our current political climate, it's controversial to talk about crime given it's strong correlation with poverty. Unfortunately, this can disenfranchise some community members whom are victims of crime and live in heavy crime areas on a daily basis. These reports and graphs are met to just shed light on the issue and encourage community members to see and interact with the data themselves. Hopefully, the community and/or agencies will take action. Note: Parts of Midway, Rondo, and Union City are included.

Some questions that you may consider:

  • What are vulnerable areas or hotspots in the community?
  • Are certain crimes more frequent in your area, and how should you or the community address it?
  • What are some trends in the your community?
  • What is the frequency of calling the police in nearby area? Is there over-reporting/ under-reporting?
  • How can we address these issues as a community (i.e. organizing; etc)?

Open Source Data Initiative

It is important that data is accessible and provided to the public. This report and others will be available on Github allowing others to contribute, replicate, and use code for their own respective neighborhood. If anyone is interested in mapping out East Side, Payne Phalen, etc., please reach out to me.

You can use the data provided by this report, but understand that I'm not an official agency and not liable for incorrect data.

About the Dataset:

The Crime Incident Report - Dataset was obtained from the Saint Paul Website. It is publicly available. The report contains incidents from Aug 14 2014 through the most recent date, as released by the Saint Paul Police Department.

A few notes about the dataset:

  • The dataset have several human errors such as mis-categorizing addresses and address being designated to the wrong police grid.
  • The dataset DOES NOT PROVIDE EXACT ADDRESSES/ GEO-COORDINATES. However, I've constructed an algorithm that get a reliable proxy address for most entries.
    • The process included entering coordinate manually; if any residents are interested in mapping out their own community please feel free to connect with me.
    • Google Maps geocoder was used
    • The algorithm does not cover the intersections of Capitol Heights and Mt. Airy region. Some data was excluded from region due to inadequate mapping. They have many intersections and curved streets; it would take time to geo-code it.
  • The analysis/algorithm is restricted near the Frogtown area.

Saint Paul Police grid w/ total crime numbers all years [excluding proactive visits]

The dataset comprise this area.

title

Display Total Incidents of all years

NOTE: The following changes were made in the crime category to consolidate categories

  • Graffiti was combined into Vandalism
  • Violent Crimes combined the categories: Rape, Homicide, Aggressive Assault
  • Domestic Assault includes both Simple and Aggressive Assaults
  • Community Engagement Events and Proactive Police Visit are not crimes. Proactive Police Visit is not response to 911 call. They will be excluded for vast majority of the analysis
In [11]:
print('List of Events in Frogtown (nearby) from 2018 to Present')
fg.query('Year>=2018')['Incident'].value_counts()
List of Events in Frogtown (nearby) from 2018 to Present
Out[11]:
Proactive Police Visit        6438
Theft                         2229
Vandalism                      708
Auto Theft                     684
Narcotics                      595
Domestic Assault               456
Burglary                       393
Discharge                      389
Community Engagement Event     318
Violent                        200
Robbery                        196
Arson                           25
Name: Incident, dtype: int64

Frogtown Yearly Crime Comparison Up to Current Date

How much crime is there so far in comparison to the previous year on this date? Are certain areas increasing or decreasing? Note: the function can choose any day prior to the current date.

We choose the max date for the dataset. We can choose an earlier date if desired

In [12]:
plot_toDate_Year_Crime(Incident='All',Day=Max)
This graph maps All incidents up to 11/13/20XX

Frogtown Total Crimes toDate by Month

What are some monthly trends

In [13]:
table_toDate_Month_Crime(Incident='All',Day=Max)
This table maps All incidents up to Day 11/13/20XX
Out[13]:
Month 1 2 3 4 ... 8 9 10 11
Year 2017 2018 2019 2017 2018 2019 2017 2018 2019 2017 ... 2019 2017 2018 2019 2017 2018 2019 2017 2018 2019
Community Grid
Midway 66.0 0 1 0 0 1 1 0 0 1 4 ... 4 4 0 2 1 0 3 1 0 1
86.0 2 27 14 5 12 13 8 18 22 10 ... 20 19 17 39 13 15 15 6 4 5
Summit-University 107.0 7 18 24 4 17 10 19 22 12 25 ... 22 17 34 15 20 22 14 13 7 6
108.0 1 10 25 4 23 12 20 15 22 24 ... 22 13 19 25 17 16 32 10 14 7
109.0 1 10 3 2 6 8 3 2 6 4 ... 5 10 10 2 13 8 5 1 3 3
110.0 2 22 17 3 19 17 14 22 12 25 ... 16 26 17 12 24 18 15 8 10 4
Thomas-Frogtown 67.0 1 11 6 2 9 7 7 15 5 13 ... 13 12 10 5 10 8 9 6 2 2
68.0 0 5 3 0 0 3 2 8 4 1 ... 3 4 6 2 4 3 6 0 0 2
87.0 2 27 19 2 33 21 20 14 26 31 ... 24 32 32 24 34 16 25 14 3 4
88.0 2 18 26 4 26 19 35 25 20 34 ... 40 32 35 43 27 23 35 18 12 11
89.0 8 50 32 5 24 20 35 26 18 31 ... 46 37 32 34 26 23 41 12 16 13
90.0 0 32 16 3 18 20 14 29 19 15 ... 36 16 25 17 35 18 23 5 5 18
91.0 2 6 3 1 4 1 18 3 3 11 ... 7 9 10 6 9 10 6 2 2 3
92.0 0 0 0 0 0 0 0 1 1 1 ... 1 0 0 0 1 4 0 0 0 1
Union Park 106.0 7 33 35 9 23 41 33 43 36 25 ... 65 37 51 64 42 35 65 10 15 41

15 rows × 33 columns

Saint Paul Yearly Crime Comparison Up to Current Date

How do we compare to our neighbors and what are some trends?

In [14]:
plot_toDate_Year_SPCrime(Incident='All',Day=Max)
This graph maps All incidents of Saint Paul neighborhoods up to 11/13/20XX

Frogtown Annual Crime Map (Default 2019)

At least four crimes must occur in one location to be displayed

NOTE: It's interactive, click on the circles for more details on the total number and type of crimes committed

In [17]:
plot_Frogtown_year(2019)
Out[17]:

Frogtown Violent Crimes Map from 2017 to Present

Violent crimes are less salient or apparent to community members. We can see which areas/ blocks are safer.

  • Orange= 2017
  • Green= 2018
  • Purple= 2019
In [15]:
plot_Frogtown_long_crime('Violent')
Out[15]:

Frogtown 2019 Multi-Crime Map

  • Purple= Discharge
  • Green= Autotheft
  • Orange= Theft
  • Blue= Burglary
  • Brown= Narcotics
  • Red= Vandalism
In [16]:
plot_multicrime_byYear()
Out[16]: