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:
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.
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 comprise this area.
NOTE: The following changes were made in the crime category to consolidate categories
print('List of Events in Frogtown (nearby) from 2019 to Present') fg.query('Year>=2019')['Incident'].value_counts()
List of Events in Frogtown (nearby) from 2019 to Present
Proactive Police Visit 4417 Theft 1396 Vandalism 418 Auto Theft 401 Narcotics 281 Domestic Assault 226 Discharge 225 Burglary 223 Community Engagement Event 128 Robbery 101 Violent 86 Arson 14 Name: Incident, dtype: int64
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
This graph maps All incidents up to 1/29/20XX
This table maps All incidents up to Day 1/29/20XX
How do we compare to our neighbors and what are some trends?
--------------------------------------------------------------------------- NameError Traceback (most recent call last) <ipython-input-20-ba2613de9668> in <module> ----> 1 plot_toDate_Year_SPCrime(Incident='All',Day=Max) NameError: name 'plot_toDate_Year_SPCrime' is not defined
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
Violent crimes are less salient or apparent to community members. We can see which areas/ blocks are safer.
Notice the address codes are masked and count is limited to 15
B=fgc.query('Year in [2019,2020]') B=B[['Block','Count']].groupby(['Block']).sum().reset_index() B.columns=['Block_Intersection','Count'] B.query('Count>14').sort_values(['Count'], ascending=False)
|143||130x university av w||490|
|114||123x university av w||54|
|200||27x lexington pa n||53|
|491||62x rice st||48|
|271||39x lexington pa n||38|
|844||95x lexington pa n||33|
|161||17x charles av||26|
|120||124x stanthony av||23|
|642||75x milton st n||23|
|376||50x rice st||20|
|872||98x university av w||20|
|343||46x dale st n||19|
|51||107x university av w||18|
|163||19x edmund av||16|
|483||62x aurora av||15|
We hear it all the time from many people that our awareness of shootings is based on connection to social media and officials suggesting it is safer now than years prior. Is this true? Well, let's find out. It's worth noting that weather conditions can influence the frequency of when shootings occur. Finally, the discharge category excludes a firearm being used to assist in another crime.
Why focus on shootings?
Shootings can harm innocent bystanders and creates a significant sense of fear because it can be heard from a distance. It is one of the more salient crimes.
First let's construct graph a table showing the total number of shootings up to current date in comparison to previous years. Notice that many grids are experiencing different trends, so it can be true that some neighbors are exposed to more shootings this year and others less.
This graph maps Discharge incidents up to 1/29/20XX
What are some trends at the city-wide level?
This graph maps Discharge incidents of Saint Paul neighborhoods up to 1/29/20XX
The table below displays the number of shootings by grid in Frogtown broken by month over the last two years
This table maps Discharge incidents up to Day 1/29/20XX
A police Grid can cover a lot of area. From the map we can spot parts of the community that are currently vulnerable and those in the past.
This map displays Discharge incidents up to 1/29/20XX
Daytime shooting are particularly concerning to our community as there as there are greater frequency of innocent bystanders being harmed and can influence community members behavior to go outside or parents decision to let their kids play.
This map displays Discharge incidents up to 1/29/20XX from 7AM to 8PM