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

12/17/2015 1

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?

12/17/2015 2

Original Data Set Analytic Tools & Data Source

• Tools:

– R Studio – Analytics & Cleaning Data – Tableau – Visual Effects & Mapping – Excel – Cleaning & Filtering data

• Data Source:

– NYC Open Data

12/17/2015 3

Graffiti Borough Analysis

2234 6805 2438 2424 246 1000 2000 3000 4000 5000 6000 7000 8000 BRONX BROOKYLN MANHATTAN QUEENS STATEN ISLAND

TOTAL INCIDENTS

87 95 96 93 106 20 40 60 80 100 120 BRONX BROOKYLN MANHATTAN QUEENS STATEN ISLAND

Average Days Clean-up

Problem Areas by Borough

12/17/2015 4

Highest Incident Occurrences by Precinct Seasonal Analysis/NYPD Awareness

• The Winter & Spring

months had more incidents occurring

• ver this one year span
• This analysis shows

that in 2016 the Citywide Vandals Taskforce should be more alert during the Winter & Spring months

• The NYPD, more

specifically the Citywide Vandals Taskforce could find this information very useful

3425 3405 2411 1830

Incidents over 1 YR Span (Nov. 2014

• Nov. 2015)

WINTER SPRING SUMMER FALL

12/17/2015 5

SEASONAL ANALYSIS SEASONAL ANALYSIS