Assignment 3: Chicago Crimes

MSDS420

Author : Atef Bader, PhD
Last Edit : 3/30/2019

Submit a single zip-compressed file that has the name: YourLastName__5 that has the following files:
Your PDF document that has your Source code and output
Your ipynb script that has your Source code and output

Use SQL to execute different queries to retrieve data from Crime dataset and Police stations dataset
Use Geospatial queries to locate police stations and gun related (with arrest or no arrest) in every district on Choropleth map
Use Geospatial queries to provide descriptive stat for every district on Choropleth map
Use Geospatial queries to locate the Block that is the furthest (Maximum Distance) from the police station that has gun related crime resulted in arrest

Create a folder or directory with all supplementary files with your last name at the beginning of the folder name, compress that folder with zip compression, and post the zip-archived folder under the assignment link in Canvas. The following files should be included in an archive folder/directory that is uploaded as a single zip-compressed file. (Use zip, not StuffIt or any 7z or any other compression method.)
Complete IPYNB script that has the source code in Python used to access and analyze the data. The code should be submitted as an IPYNB script that can be be loaded and run in Jupyter Notebook for Python
Output from the program, such as console listing/logs, text files, and graphics output for visualizations. If you use the Data Science Computing Cluster or School of Professional Studies database servers or systems, include Linux logs of your sessions as plain text files. Linux logs may be generated by using the script process at the beginning of your session, as demonstrated in tutorial handouts for the DSCC servers.
List file names and descriptions of files in the zip-compressed folder/directory.
Formatting Python Code When programming in Python, refer to Kenneth Reitz’ PEP 8: The Style Guide for Python Code: http://pep8.org/ (Links to an external site.)Links to an external site. There is the Google style guide for Python at https://google.github.io/styleguide/pyguide.html (Links to an external site.)Links to an external site. Comment often and in detail.

Chicago Crimes
In his first state of the union address , president Trump mentioned Chicago violance 10 times Trump’s State of the Union Address
Chicago has more homicides than New York and Los Angeles combined
Columnist Clarence Page wrote an article , published by the Chicago Tribune stated that the city of Chicago had more homicides in the past two years than New York and Los Angeles combined

Chicago police department CPD issues and publishes on daily basis on its website crime alerts, and press releases for the different districts .

The CSV file for crimes dataset for the city of Chicago is obtained from the data portal for the city of Chicago. Here is the link for the city of Chicago data portal City of Chicago Data Portal

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA  PhD. Writers)