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 2018 to Present') fg.query('Year>=2018')['Incident'].value_counts()
List of Events in Frogtown (nearby) from 2018 to Present
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
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 11/13/20XX
This table maps All incidents up to Day 11/13/20XX
15 rows × 33 columns
How do we compare to our neighbors and what are some trends?
This graph maps All incidents of Saint Paul neighborhoods up to 11/13/20XX
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.