Know NYC Parks

Analyzing and Visualizing NYC Parks Crimes Statistics

Overview

Know NYC Parks is about visualizing NYPD's NYC Parks Crime Statistics using Pandas, Matplotlib and Seaborn.

Data

The two datasets for this project are:
  • NYPD's NYC Parks Crime Statistics. The data collected spans from the third of 2014 up to 2021, with the data spread out into four quarters for years into individual files per quarter.
  • Open Spaces (NYC Parks) Geodata. The location of each park in the NYPD statistics, alongside the number of crimes per year.

Techniques

The first technique I used for this project was cleaning up the NYPD data. Then I maded some calculations such as number of crimes committed in park, alongside a breakdown into the major seven complaints making up the total per year, average number of crimes committed in a park, most common crime committed in a park, etc. All this will make the data easier to visualize with graphs and charts, and thus more meaningful. The bar plots were created using Matplotlib and Seaborn.

Next Step

Originally the project's aim was to use NYPD's NYC Parks Crime Statistics alongside the GeoJSON data for NYC parks to create an interactive map and data visualizations (e.g., bar plots, line graphs, etc), however I couldn't achieve this goal because I misjudged the magnitude of such project. The following are some of the next steps to improve the project and reach the goal:
  • A GeoJSON file with all the parks and the total number of crimes that occurred in it for the period 2014-2021, with OpenStreetMap for the maps.
  • Two CSV files for the number of crimes per year for each park and a breakdown of the seven different crime categories used by NYPD.
  • A CSV file for each park with the total number of crimes for a specific year in the range 2014-2021.

References

Total Crimes for Bronx Parks

The following bar plots showcase the total number of crimes over the period 2014-2021 for several Bronx parks. Starting with NYC Parks Crime Statistics, the data was cleaned up using Pandas. Due to the amount of parks, I'm focusing in the first five Bronx parks with highest index of crimes for the year 2014, which are then used for the subsequent years.

Crotona Park Total Mullaly Park Total Soundview Park Total Van Cortlandt Park Total St James Park Total