Show Me Where project
A project showing me where things are.
another headline for fun
About the dataset
The Palo Alto Police Department has posted a spreadsheet of reported incidents from up to 6 months ago. The dataset contains roughly 6,000 records and its fields include geolocations for approximate addresses of the incidents, as well as the disposition of the report.
Basic facts about the dataset
- The source of the data: City of Palo Alto, Open Data Portal, Police Department
- The data's landing page: Crime Reports
- Direct link to the data: http://data.cityofpaloalto.org/rest/datastreams/107246/data.csv
- The data format: CSV
- Number of rows: 6,658
Description of data fields
A datetime value, in this format:
Contains a text string that seems to be a standardized category for the reported incident, e.g.
"THEFT PETTY/MISC (488M)",
"THEFT GRAND/BIKE/BIKE PARTS (487B)"
Contains a text string of the status of the report, such as whether someone was arrested or cited, e.g.
Contains a text string of the street address of the incident location. The location is often described as being an intersection, e.g.
"EL CAMINO REAL & QUARRY RD", or a block, e.g.
"600 Block SAN ANTONIO AV"
Contains a text string representing the city name of the incident location, e.g.
Contains a text string representing the 5-digit ZIP code of the incident location, e.g.
Contains a float that represents the latitude coordinate of the incident location.
Contains a float that represents longitude coordinate of the incident location.
Anticipated data wrangling
I will probably filter the dataset to include burglary-type crimes, such as car/home burglaries, and thefts of bikes and vehicles.