Graffit ffiti i Data a Analy lysis sis Philip lip Santarp - PDF document

12/17/2015 Graffit ffiti i Data a Analy lysis sis Philip lip Santarp tarpia ia Pro rof. Chun un BDA 761 Inquiries about the Graffiti Data • What is the Average clean up time per borough? • What is the largest problem area in each borough by precinct (MAP) • Which precincts have the most reported incidents (Top 10) • Seasonal Analysis – NYPD Awareness • Who would consider this data useful? 1

12/17/2015 Original Data Set Analytic Tools & Data Source • Tools: • Data Source: – R Studio – Analytics & – NYC Open Data Cleaning Data – Tableau – Visual Effects & Mapping – Excel – Cleaning & Filtering data 2

12/17/2015 Graffiti Borough Analysis Average Days Clean-up STATEN ISLAND 106 QUEENS 93 MANHATTAN 96 BROOKYLN 95 BRONX 87 0 20 40 60 80 100 120 TOTAL INCIDENTS STATEN ISLAND 246 QUEENS 2424 MANHATTAN 2438 BROOKYLN 6805 BRONX 2234 0 1000 2000 3000 4000 5000 6000 7000 8000 Problem Areas by Borough 3

12/17/2015 Highest Incident Occurrences by Precinct Seasonal Analysis/NYPD Awareness The Winter & Spring • Incidents over 1 YR Span (Nov. 2014 months had more - Nov. 2015) incidents occurring over this one year span This analysis shows • that in 2016 the Citywide Vandals 1830 Taskforce should be more alert during the 3425 Winter & Spring months WINTER The NYPD, more • SPRING specifically the SUMMER 2411 Citywide Vandals FALL Taskforce could find this information very useful 3405 4

12/17/2015 SEASONAL ANALYSIS SEASONAL ANALYSIS 5