{"id":23341,"date":"2021-04-21T18:05:26","date_gmt":"2021-04-21T22:05:26","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=23341"},"modified":"2021-04-21T18:05:30","modified_gmt":"2021-04-21T22:05:30","slug":"philadelphias-crime-stats-of-2020","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/philadelphias-crime-stats-of-2020\/","title":{"rendered":"Philadelphia’s Crime Stats of 2020"},"content":{"rendered":"\n

Introduction <\/h2>\n\n\n\n

For this article, I focused on showing Police Incident data of 2020 for Philadelphia. Using the Ring Neighbor App, I have recently noticed many incidents such as package thieves or gunshots in the City of Philadelphia, and I got concerned about the ongoing crimes in the city. Philadelphia has marked 2020 as its most violent year in three decades, reported by Philly Trib.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Inspiration<\/h2>\n\n\n\n

I looked into our blog to see past examples and found several that are inspirational for this article. I would like to show a map with incidents and also showing other data such as police districts or tourist attractions. <\/p>\n\n\n\n

  1. DRUG-RELATED ARRESTS IN CHICAGO by Sofia Ni https:\/\/studentwork.prattsi.org\/infovis\/visualization\/drug-related-arrests-in-chicago\/<\/a><\/li>
  2. SCHOOL IMPROVEMENT PROJECTS IN NYC by Anna Size https:\/\/studentwork.prattsi.org\/infovis\/visualization\/school-improvement-projects-in-nyc\/<\/a><\/li><\/ol>\n\n\n\n

    Process<\/h2>\n\n\n\n

    Step 1 Data Gathering and Setup<\/h4>\n\n\n\n

    All of my data were download from\u00a0OpenDataPhilly<\/a>. I have downloaded the\u00a0Crime Incident<\/a>\u00a0dataset,\u00a0Police Districts<\/a>\u00a0dataset, and\u00a0City Landmark<\/a>\u00a0dataset. The primary dataset I used is the Crime Incident dataset, and I used the other two as complementary data. The Crime Incident dataset has 138,780 rows of crime incident records, including homicide, rape, Aggravated Assault with\/without firearms, theft, burglary, and other Assaults.<\/p>\n\n\n\n

    I Imported the files(CSV files) to Carto. The Crime Incident dataset was easy to connect, and all data show up on the map. I had a difficult time with City Landmark; the nodes or boundaries did not show up.<\/p>\n\n\n\n

    \"\"
    Crime Incident dataset<\/figcaption><\/figure>\n\n\n\n
    \"\"
    Police District, I added district number<\/figcaption><\/figure>\n\n\n\n
    \"\"
    This dataset is very similar to Police District Dataset. I tried using Polygon and manually add in the data, still did not work.<\/figcaption><\/figure>\n\n\n\n

    Step 2 Visualization <\/h4>\n\n\n\n

    The Crime Incidents map was hectic due to the amount of data it contained. I started to work with style to distinguish the incidents and added a filter to filter the incidents.<\/p>\n\n\n\n

    \"\"
    Adjusted the style. Crime incidents by color<\/em><\/figcaption><\/figure>\n\n\n\n

    I added widget to show summary for the crimes within the whole city. <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Next, I incorporated the Police District dataset with the Crime Incidents dataset. I added a filter to the Crime Incident data to only show homicide so it’s easier to read and a filter for Police District to narrow down the location. With this map, you can analyze each district’s safety and incident data.<\/p>\n\n\n\n

    \"\"
    Filter by Column Value, Only showing the crime I am looking for.<\/em> Example: Homicide<\/figcaption><\/figure>\n\n\n\n
    \"\"
    Q: How to only show data within that purple region(District 16)?<\/figcaption><\/figure>\n\n\n\n

    Finally, I did an animated map\/timeline showing the location crime that happened during 2020. It’s nice that you can click on a specific crime to filter the map. <\/p>\n\n\n\n

    \n