Kungpeng Lui


Media is loading

Document Type


Publication Date

Summer 8-2023


In the aftermath of the COVID-19 pandemic, New York City has seen a surge in criminal activities. In 2023, major crime continues to be higher compared to pre-pandemic levels. Although progress is being made to reduce the number of murders and robberies, law enforcement is continuing to struggle with increases in felony assaults and car thefts. Our project serves to benefit members of the community and law enforcement alike. We created a heat map, which is a visual representation of data that uses colors to represent different values. In the context of crime mapping, our heat map is used to show the density of crimes in a particular area.

As of today, the NYPD utilizes two databases: Compstat 2.0 & Excel. Compstat 2.0, updated on a weekly basis, shows a change in the number of crimes compared to the week’s prior across several boroughs and precincts. The Excel data spans from 2000 to 2022 with the same type of information. The drawback here is that the average community member in New York City can’t draw any conclusions from the data available to them. This means that they have access to this data, but with no means to interpret the data in a simple manner.

In our approach, we created a visual, animated representation of the data from 2000 to 2022. Thus, we have simplified the process for anybody who wishes to understand how crime rates evolve over the years, especially for those who live in neighborhoods that are high risk. In addition, we believe law enforcement can also utilize this resource as a means to better allocate resources to underserved neighborhoods. If successful, any individual in New York City, including tourists, can analyze the heat map to study which neighborhoods are at risk for crime so that they can be wary of their surroundings. It’s important to understand that with graphics the average community member will be more inclined to take safety precautions when commuting around New York City.


© 2023 the author(s).

IN COPYRIGHT: This Item is protected by copyright and/or related rights. You are free to use this Item in any way that is permitted by the copyright and related rights legislation that applies to your use. For other uses you need to obtain permission from the rights-holder(s).

DISCLAIMER: The purpose of this statement is to help the public understand how this Item may be used. When there is a (non-standard) License or contract that governs re-use of the associated Item, this statement only summarizes the effects of some of its terms. It is not a License, and should not be used to license your Work. To license your own Work, use a License offered at

Persistent Identifier



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.