seattle_crime_data

UW Datathon 2020 Investigation (1st place for Data Visualization)

Goal

To investigate the seattle crime dataset (see link below) and produce a useful viz dashboard that will highlight statistics and help inform decisions for crime data in seattle neigborhoods (crimes with weapons, top least crime neighborhoods and number of schools in those) through a heatmap of severity for each category of crime for families with kids

Tools Used:

R, Power BI

Team members:

rxu17, yayinc, yiranl3

Data Sources + Descriptions:

Seattle crime dataset:

• https://data.seattle.gov/Public-Safety/Crime-Data/4fs7-3vj5/data

Seattle police beats dataset (Linking police beats to latitude and longitude data the dashboard can utilize):

• https://data.seattle.gov/Land-Base/Police-Beat-and-Precinct-Centerpoints/4khs-fz35

Severity ranking dataset source:

We produced general severity rankings for crime categories as seen on our dashboard, leaning towards giving high rankings to crimes associated with children due to our target demographic.

• https://www.cfc.wa.gov/PublicationSentencing/SentencingManual/Adult_Sentencing_Manual_1992.pdf
• https://pap.georgia.gov/sites/pap.georgia.gov/files/CSL-s_Post_1-1-2006_considerations.pdf

Insights/Conclusion:

See infographic below

Dashboard:

• https://app.powerbi.com/reportEmbed?reportId=a153141b-264f-460b-99ca-70cf29c2a04d&autoAuth=true&ctid=f6b6dd5b-f02f-441a-99a0-162ac5060bd2&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXdlc3QtdXMtcmVkaXJlY3QuYW5hbHlzaXMud2luZG93cy5uZXQvIn0%3D Snapshot Image