Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Domain Social Science Focus CreatingWebMapBusiness challenge / requirementYou are a data analyst in SanFrancisco ( SFO ) City IT Department. SFO Police has shared crime

Domain
Social Science Focus
CreatingWebMapBusiness challenge
/
requirementYou are a data analyst in SanFrancisco
(
SFO
)
City IT Department. SFO Police has shared crime data fortheyear
2016.
Data contains various incidents thathave happened throughout the year, along with the geolocationdataof the crime.You need to prepare effective webmaps to analyze and present the data. SFO Commissioner of Police will reassign the forces based on the density of various crime.Key issuesData should be displayed pictorially in a map to get the desired attention of top authorities. Considerations NONE Data volume Approx.
150
K records
file Police
_
Department
_
Incidents
_
Year
_
2016
_
.
csv Additional information NA Business benefits SFO City Corporation is looking to mitigate thecrime rate based on the effective relocation of police personnel,thus reducingtheoverall security cost. Aproach to Solve You must use the fundamentals of Web Mapping and create three maps. Display the first
100
records from the data.
1.
For the latest
7
days of data,createaWebMap of crimes,categorized as ROBBERY.
2.
For the latest
15
days of data,create aWebMap of crimes,categorized as FRAUD and GAMBLING.
3.
BONUS ASSIGNMENT
-
-
Displayheatmap for Divvy Bikes. Divvy Bikes runs bike rental servicesin Chicago,and their bike station geolocation data is shared. Refer to BikesHeatMap.py
,
Divvy
_
Stations
_
2016
_
Q
3.
csv
,
andDivvy
_
Stations
_
2016
_
Q
4.
csvEnhancements for codeYou can try these enhancements in code
1.
A lot of visual options are available forchangingthe map.
2.
Change the code to create a WebMap for
BURGLARY
forthe last
7
days
3.
BONUS ASSIGNMENT
Uncomment the code to see the changes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions