baltimore-city-crash-analysis

Data

This data reflects reports from crashes that resulted in an injury or fatality. The data was downloaded from the Maryland State Police's Maryland Crash Data Download tool.

To download this data set, we used the following filters to pull the desired data from 2018-01-01 to 2023-12-11 image

There are many data points either with erroneously generated latitude and longitude or mislabeled county information.

Unfortunately, there are not enough data fields available for download to properly investigate these cases.

image

Since we are just focused on Baltimore City to generate our heatmap, we can use a spatial join to filter out the data points that fall outside of the city line.

NOTE: To determine whether a non-motorist was involved in the crash, we have to use the presence of a non-motorist ID as a proxy, since that information is not offered in the dataset directly.

image

If we hear back from the team responsible for the data download tool, this method may change.