Data Description
Crime Incident Report
This file contains information on each incident report from August 14, 2014 to the present. Columns include:
- Case Number
- Date
- Time
- Police Code
- Incident Type - More detailed description of incident
- Incident - More general category of incident
- Police Grid Number
- Neighborhood Number
- Neighborhood Name
- Block
- Call Disposition Code
- Call Disposition
Download
In order to conduct some of the analyses in this project, the Incident column was recasted to have five categories instead of twelve. This change took a significant amount of time to occur when running the code. As a result, I have placed this updated CSV file in a repository on GitHub in order to save time running the code.
To download this CSV file, use the following code snippet: (removed to preserve anonymity)
If you wish to see the original data file, use the following: "wget -O crimeincidentoriginal.csv https://information.stpaul.gov/api/views/gppb-g9cg/row
s.csv?accessType=DOWNLOAD"
Traffic Stops
This file contains information on St. Paul traffic stops from 2001 to the present. Columns include:
- Year of Stop
- Date of Stop
- Race of Driver
- Gender of Driver
- Driver Searched?
- Vehicle Searched?
- Citation Issued?
- Age of Driver
- Reason For Stop
- Police Grid Number
- Location of Stop By Police Grid - Originally Lat/Long, is converted into a POINT object in code.
Download
To download this CSV file, use the following code snippet: "wget -O trafficstop.csv https://information.stpaul.gov/api/views/kkd6-vvns/rows.csv?accessType=DOWNLOAD"
Vacant Buidings
This file contains information on the vacant buildings currently in St. Paul. Columns include:
- Address
- Vacant As Of
- Dwelling Type
- Vacant Building Category
- Ward
- District
- Census Tract
- Map Location - Originally Lat/Long, is converted into a POINT object in code.
Download
To download this CSV file, use the following code snippet: "wget -O vacantbuildings.csv https://information.stpaul.gov/api/views/fgbn-288b/rows.csv?
accessType=DOWNLOAD"
Pedestrian And Bike Crash Data
This file contains information about different types of crashes in St. Paul from 2016 to the present. These crashes are not included in the previous Crime Incident Report file. While thirty three columns exist in this file, many of them are mostly empty. Columns important to my analyses include:
- Date/Time
- Case Number
- Crash Lat/Long Location - Converted to a POINT object in the code.
Download
To download this CSV file, use the following code snippet: "wget -O crash.csv https://information.stpaul.gov/api/views/bw92-5h94/rows.csv?accessType
=DOWNLOAD"
Parks Graffiti Report
This file contains information on graffiti incidences in St. Paul from 2013 to 2015. These incidences are included in the Crime Incident Report file. Columns include:
- Location Name
- Work Performed Date
- Location Address
- Issue
- Description
- Labor Cost ($)
- Material Cost ($)
- Total Cost ($)
- Location - Originally Lat/Long, converted to a POINT object in the code.
Download
To download this CSV file, use the following code snippet: "wget -O graffiti.csv https://information.stpaul.gov/api/views/gcu2-spkd/ro
ws.csv?accessType=DOWNLOAD"
Liquor Licenses
This file contains information on the liquor licenses currently issued within St. Paul. Columns include:
- License Number
- Business Name
- License Type
- License Expiration Date
- license Status
- PIN
- Ward
- District Council
- Address
- Location - Originally Lat/Long, converted to a POINT object in the code.
Download
To download this CSV file, use the following code snippet: "wget -O liquor.csv https://information.stpaul.gov/api/views/hsci-rniw/rows
.csv?accessType=DOWNLOAD"
Saint Paul Police Grid
This file contains a geopandas data set containing information on the location of each grid number within the St. Paul police grid. Columns include:
- District
- Grid Number
- Geometry - POLYGON objects.
Download
To download this CSV file, click here. Click on Export --> Shapefile.
District Council
This file contains a geopandas data set containing information on the location of each of the twelve districts that make up St. Paul. Columns include:
- District
- Name 1
- Name 2 - Alternate, Shorter Name
- Geometry - POLYGON objects
Download
To download this CSV file, click here. Click on Export --> Shapefile.
Bikeways
This file contains a geopandas data set containing information on the location of each of St. Paul's bikepaths. Columns used in my analyses include:
- Object ID
- Geometry - MULTILINESTRING objects
Download
To download this CSV file, click here. Click on Export --> Shapefile.