Socrata

Close
Author
Engelking, Derek (CI-StPaul)
Description
The data that this map is created from was provided by the St. Paul Police Department and contains all available information relating to bike and pedestrian crashes in St. Paul. As part of its commitment to improving pedestrian and bike safety, the city of St. Paul began aggressively tracking bike and pedestrian crashes in 2016. Data comes from traditional sources such as the State of MN Police Crash Report System and police reports. It also comes from social media, community conversations, police calls (911 and non-emergency) where no report was made, and other non-traditional ways to verify that a crash occurred. By collecting this level of detail for every pedestrian and bike crash in St. Paul, we are hoping to find patterns and answers to help us reach our goal of reducing the number of crashes and improving safety for all residents and visitors of St. Paul. For more information, please visit the city of Saint Paul's website: https://www.stpaul.gov/departments/police/pedestrian-and-bike-crash-data-city-st-paul Less
Category
Public Safety
Rating
Current value: 0 out of 5
Data Provided By
Saint Paul Police Department
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Crash Type
crash_type
Report Made?
report_made
Date / Time
date_time
Case Number
cn
District
district
Crash Location
location
Road Type
road_type
Ticket/Arrest?
ticket_arrest
Citation To
citation_to
Pedestrian Age
ped_age
Pedestrian Gender
ped_gender
Pedestrian City Of Residence
ped_city_res
Pedestrian Zip Code
ped_zip_code
Biker Age
biker_age
Biker Gender
biker_gender
Biker City of Residence
biker_city_of_res
Biker Zip Code
biker_zip_code
Driver Age
driver_age
Driver Gender
driver_gender
Driver City Of Residence
driver_city_res
Driver Zip Code
driver_zip_code
Injury to Pedestrian?
injury_to_ped
Level of Injury to Pedestrian
level_of_injury_to_ped
Pedestrian to Hospital?
ped_to_hospital
Injury to Biker?
injury_to_biker
Level of Injury to Biker
level_of_injury_to_biker
Biker to Hospital?
biker_to_hospital
Count
count
Crash Lat/Long Location
location_1

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.