Mapping Bicycle Crash-Prone Areas in Ohio Using Exploratory Spatial Data Analysis Techniques: An Investigation into Ohio DOT’s GIS Crash Analysis Tool Data
Abstract
1. Introduction
2. Literature Review
2.1. Existing Studies on Macrolevel and Microlevel Analysis of Non-Spatial Data
2.2. Existing Studies on Spatial Data Analysis
3. Datasets and Methodology
3.1. Datasets
3.2. Methodology
3.2.1. Nearest Neighborhood Index (NNI)
3.2.2. Global Moran’s I
3.2.3. Hotspot and Cold Spot Analysis
3.2.4. Local Indicators of Spatial Analysis (LISA)
4. Results
4.1. Nearest Neighborhood Index (NNI)
4.2. Global Moran’s I
4.3. Hotspot and Cold Spot Analysis (Getis-Ord GI* Statistic)
4.4. Local Indicators of Spatial Association (LISA)
5. Discussion
6. Conclusions
Author Contributions
Funding
Institutional Review Board Statement
Informed Consent Statement
Data Availability Statement
Conflicts of Interest
References
- Guo, Y.; Osama, A.; Sayed, T. A cross-comparison of different techniques for modeling macro-level cyclist crashes. Accid. Anal. Prev. 2018, 113, 38–46. [Google Scholar] [CrossRef]
- EPA. Transportation Sector Emissions. Available online: https://www.epa.gov/ghgemissions/transportation-sector-emissions (accessed on 26 February 2025).
- EIA. Use of Energy Explained: Energy Use for Transportation. Available online: https://www.eia.gov/energyexplained/use-of-energy/transportation.php (accessed on 27 February 2025).
- EIA. U.S. Energy-Related Carbon Dioxide Emissions. 2023. Available online: https://www.eia.gov/environment/emissions/carbon/ (accessed on 27 February 2025).
- Statista. Carbon Monoxide Emissions from Transportation in the United States from 1990 to 2023, by Source. Available online: https://www.statista.com/statistics/999680/us-carbon-monoxide-emissions-from-storage-and-transport/#:~:text=Transportation%20CO%20emissions%20in%20the%20U.S.%201990%2D2023%2C%20by%20source&text=Carbon%20monoxide%20emissions%20from%20highway,the%20U.S.%20(excluding%20wildfires) (accessed on 27 February 2025).
- Vanparijs, J.; Panis, L.I.; Meeusen, R.; De Geus, B. Exposure measurement in bicycle safety analysis: A review of the literature. Accid. Anal. Prev. 2015, 84, 9–19. [Google Scholar] [CrossRef]
- Klassen, J.; El-Basyouny, K.; Islam, M.T. Analyzing the severity of bicycle-motor vehicle collision using spatial mixed logit models: A City of Edmonton case study. Saf. Sci. 2014, 62, 295–304. [Google Scholar] [CrossRef]
- Kim, J.-K.; Kim, S.; Ulfarsson, G.F.; Porrello, L.A. Bicyclist injury severities in bicycle–motor vehicle accidents. Accid. Anal. Prev. 2007, 39, 238–251. [Google Scholar] [CrossRef] [PubMed]
- Liu, J.; Khattak, A.J.; Li, X.; Nie, Q.; Ling, Z. Bicyclist injury severity in traffic crashes: A spatial approach for geo-referenced crash data to uncover non-stationary correlates. J. Saf. Res. 2020, 73, 25–35. [Google Scholar] [CrossRef]
- Alam, B.M.; Spainhour, L.K. Contributing factors for young at fault drivers in fatal traffic crashes in Florida. J. Transp. Saf. Secur. 2009, 1, 152–168. [Google Scholar] [CrossRef]
- Chen, P.; Shen, Q. Built environment effects on cyclist injury severity in automobile-involved bicycle crashes. Accid. Anal. Prev. 2016, 86, 239–246. [Google Scholar] [CrossRef] [PubMed]
- Alam, B.M.; Spainhour, L.K. Contribution of behavioral aspects of older drivers to fatal traffic crashes in Florida. Transp. Res. Rec. 2008, 2078, 49–56. [Google Scholar] [CrossRef]
- Mukoko, K.K.; Pulugurtha, S.S. Examining the influence of network, land use, and demographic characteristics to estimate the number of bicycle-vehicle crashes on urban roads. IATSS Res. 2020, 44, 8–16. [Google Scholar] [CrossRef]
- Myhrmann, M.S.; Janstrup, K.H.; Møller, M.; Mabit, S.E. Factors influencing the injury severity of single-bicycle crashes. Accid. Anal. Prev. 2021, 149, 105875. [Google Scholar] [CrossRef]
- Dash, I.; Abkowitz, M.; Philip, C. Factors impacting bike crash severity in urban areas. J. Saf. Res. 2022, 83, 128–138. [Google Scholar] [CrossRef] [PubMed]
- Amoh-Gyimah, R.; Saberi, M.; Sarvi, M. Macroscopic modeling of pedestrian and bicycle crashes: A cross-comparison of estimation methods. Accid. Anal. Prev. 2016, 93, 147–159. [Google Scholar] [CrossRef] [PubMed]
- Wei, F.; Lovegrove, G. An empirical tool to evaluate the safety of cyclists: Community based, macro-level collision prediction models using negative binomial regression. Accid. Anal. Prev. 2013, 61, 129–137. [Google Scholar] [CrossRef] [PubMed]
- Marshall, W.E.; Garrick, N.W. Evidence on why bike-friendly cities are safer for all road users. Environ. Pract. 2011, 13, 16–27. [Google Scholar] [CrossRef]
- Jacobsen, P.L. Safety in numbers: More walkers and bicyclists, safer walking and bicycling. Inj. Prev. 2015, 21, 271–275. [Google Scholar] [CrossRef]
- Elvik, R.; Bjørnskau, T. Safety-in-numbers: A systematic review and meta-analysis of evidence. Saf. Sci. 2017, 92, 274–282. [Google Scholar] [CrossRef]
- Fyhri, A.; Sundfør, H.B.; Bjørnskau, T.; Laureshyn, A. Safety in numbers for cyclists—Conclusions from a multidisciplinary study of seasonal change in interplay and conflicts. Accid. Anal. Prev. 2017, 105, 124–133. [Google Scholar] [CrossRef]
- Shoman, M.M.; Imine, H.; Acerra, E.M.; Lantieri, C. Evaluation of cycling safety and comfort in bad weather and surface conditions using an instrumented bicycle. IEEE Access 2023, 11, 15096–15108. [Google Scholar] [CrossRef]
- Bíl, M.; Bílová, M.; Müller, I. Critical factors in fatal collisions of adult cyclists with automobiles. Accid. Anal. Prev. 2010, 42, 1632–1636. [Google Scholar] [CrossRef]
- Apardian, R.E.; Alam, B.M. Pedestrian fatal crash location analysis in Ohio using exploratory spatial data analysis techniques. Transp. Res. Rec. 2020, 2674, 888–900. [Google Scholar] [CrossRef]
- Saha, D.; Alluri, P.; Gan, A.; Wu, W. Spatial analysis of macro-level bicycle crashes using the class of conditional autoregressive models. Accid. Anal. Prev. 2018, 118, 166–177. [Google Scholar] [CrossRef]
- Siddiqui, C.; Abdel-Aty, M.; Choi, K. Macroscopic spatial analysis of pedestrian and bicycle crashes. Accid. Anal. Prev. 2012, 45, 382–391. [Google Scholar] [CrossRef] [PubMed]
- Raihan, M.A.; Alluri, P.; Wu, W.; Gan, A. Estimation of bicycle crash modification factors (CMFs) on urban facilities using zero inflated negative binomial models. Accid. Anal. Prev. 2019, 123, 303–313. [Google Scholar] [CrossRef] [PubMed]
- Yasmin, S.; Eluru, N. Latent segmentation based count models: Analysis of bicycle safety in Montreal and Toronto. Accid. Anal. Prev. 2016, 95, 157–171. [Google Scholar] [CrossRef] [PubMed]
- Lovegrove, G.R.; Sayed, T. Using macrolevel collision prediction models in road safety planning applications. Transp. Res. Rec. 2006, 1950, 73–82. [Google Scholar] [CrossRef]
- Alam, B.M.; Spainhour, L. Logit and case-based analysis of drivers’ age as a contributing factor for fatal traffic crashes on highways and state roads in Florida. In Proceedings of the Transportation Research Board 93rd Annual Meeting, Washington, DC, USA, 12–16 January 2014; pp. 1–12. [Google Scholar]
- Yan, X.; Ma, M.; Huang, H.; Abdel-Aty, M.; Wu, C. Motor vehicle–bicycle crashes in Beijing: Irregular maneuvers, crash patterns, and injury severity. Accid. Anal. Prev. 2011, 43, 1751–1758. [Google Scholar] [CrossRef]
- Alam, B.M. Case-Based Analysis of Age and Sex Distribution of Drivers Causing Fatal Crashes: Evidence from Florida, USA. In ICTIS 2011: Multimodal Approach to Sustained Transportation System Development: Information, Technology, Implementation; American Society of Civil Engineers (ASCE): Reston, VA, USA, 2011; pp. 1113–1121. Available online: https://ascelibrary.org/doi/10.1061/41177%28415%29141 (accessed on 17 July 2025).
- Kondo, M.C.; Morrison, C.; Guerra, E.; Kaufman, E.J.; Wiebe, D.J. Where do bike lanes work best? A Bayesian spatial model of bicycle lanes and bicycle crashes. Saf. Sci. 2018, 103, 225–233. [Google Scholar] [CrossRef]
- Apardian, R.; Alam, B.M. Methods of crossing at roundabouts for visually impaired pedestrians: Review of literature. Int. J. Transp. Sci. Technol. 2015, 4, 313–336. [Google Scholar] [CrossRef]
- Osama, A.; Sayed, T. Evaluating the impact of bike network indicators on cyclist safety using macro-level collision prediction models. Accid. Anal. Prev. 2016, 97, 28–37. [Google Scholar] [CrossRef]
- Loidl, M.; Traun, C.; Wallentin, G. Spatial patterns and temporal dynamics of urban bicycle crashes—A case study from Salzburg (Austria). J. Transp. Geogr. 2016, 52, 38–50. [Google Scholar] [CrossRef]
- Delmelle, E.C.; Thill, J.-C. Urban bicyclists: Spatial analysis of adult and youth traffic hazard intensity. Transp. Res. Rec. 2008, 2074, 31–39. [Google Scholar] [CrossRef]
- Chimba, D.; Emaasit, D.; Cherry, C.R.; Pannell, Z. Patterning Demographic and Socioeconomic Characteristics Affecting Pedestrian and Bicycle Crash Frequency. In Proceedings of the TRB 93rd Annual Meeting Compendium of Papers, Washington, DC, USA, 12–16 January 2014; Available online: https://trid.trb.org/view/1287401 (accessed on 17 July 2025).
- Loidl, M.; Wallentin, G.; Wendel, R.; Zagel, B. Mapping bicycle crash risk patterns on the local scale. Safety 2016, 2, 17. [Google Scholar] [CrossRef]
- Chen, P. Built environment factors in explaining the automobile-involved bicycle crash frequencies: A spatial statistic approach. Saf. Sci. 2015, 79, 336–343. [Google Scholar] [CrossRef]
- Chun, U.; Lim, J.; Lee, S.; Park, S. An analysis of bicycle accidents with respect to spatial heterogeneity. Sci. Rep. 2023, 13, 21812. [Google Scholar] [CrossRef]
- Obelheiro, M.R.; da Silva, A.R.; Nodari, C.T.; Cybis, H.B.B.; Lindau, L.A. A new zone system to analyze the spatial relationships between the built environment and traffic safety. J. Transp. Geogr. 2020, 84, 102699. [Google Scholar] [CrossRef]
- Lee, J.; Wong, D.W. Statistical Analysis of Geographic Information with ArcView GIS and ArcGIS; John Wiley & Sons, Incorporated: Hoboken, NJ, USA, 2005. [Google Scholar]
- Chen, Y. An analytical process of spatial autocorrelation functions based on Moran’s index. PLoS ONE 2021, 16, e0249589. [Google Scholar] [CrossRef] [PubMed]
- Ord, J.K.; Getis, A. Local spatial autocorrelation statistics: Distributional issues and an application. Geogr. Anal. 1995, 27, 286–306. [Google Scholar] [CrossRef]
- Getis, A.; Ord, J.K. The analysis of spatial association by use of distance statistics. Geogr. Anal. 1992, 24, 189–206. [Google Scholar] [CrossRef]
- Zeren, F.; Akbulut, S.; Ozer, A.; Islek, H.; Bentli, R.; Mentese, E.Y. Spatial clustering and hot spot analysis of the COVID-19 pandemic in Malatya province. Medicine 2022, 11, 1030–1035. [Google Scholar] [CrossRef]
- Anselin, L. Local indicators of spatial association—LISA. Geogr. Anal. 1995, 27, 93–115. [Google Scholar] [CrossRef]
- Nunn, S.; Newby, W. Landscapes of risk: The geography of fatal traffic collisions in Indiana, 2003 to 2011. Prof. Geogr. 2015, 67, 269–281. [Google Scholar] [CrossRef]
- Cai, Q.; Lee, J.; Eluru, N.; Abdel-Aty, M. Macro-level pedestrian and bicycle crash analysis: Incorporating spatial spillover effects in dual state count models. Accid. Anal. Prev. 2016, 93, 14–22. [Google Scholar] [CrossRef]
- Wang, J.; Olivier, J.; Grzebieta, R.; Walter, S. Statistical errors in anti-helmet arguments. In Proceedings of the Australasian College of Road Safety Conference—“A Safe System: The Road Safety Discussion”, Adelaide, Australia, 6–8 November 2013. [Google Scholar]
- Aldred, R.; Goel, R.; Woodcock, J.; Goodman, A. Contextualising Safety in Numbers: A longitudinal investigation into change in cycling safety in Britain, 1991–2001 and 2001–2011. Inj. Prev. 2019, 25, 236–241. [Google Scholar] [CrossRef] [PubMed]
- Teschke, K.; Harris, M.A.; Reynolds, C.C.; Winters, M.; Babul, S.; Chipman, M.; Cusimano, M.D.; Brubacher, J.R.; Hunte, G.; Friedman, S.M. Route infrastructure and the risk of injuries to bicyclists: A case-crossover study. Am. J. Public Health 2012, 102, 2336–2343. [Google Scholar] [CrossRef] [PubMed]
- Brown, M.J.; Scott, D.M.; Páez, A. A spatial modeling approach to estimating bike share traffic volume from GPS data. Sustain. Cities Soc. 2022, 76, 103401. [Google Scholar] [CrossRef]
- Morrison, C.N.; Thompson, J.; Kondo, M.C.; Beck, B. On-road bicycle lane types, roadway characteristics, and risks for bicycle crashes. Accid. Anal. Prev. 2019, 123, 123–131. [Google Scholar] [CrossRef]
- Vandenbulcke, G.; Thomas, I.; Panis, L.I. Predicting cycling accident risk in Brussels: A spatial case–control approach. Accid. Anal. Prev. 2014, 62, 341–357. [Google Scholar] [CrossRef]
- Pearson, L.; Reeder, S.; Gabbe, B.; Beck, B. Designing for the Interested but Concerned: A qualitative study of the needs of potential bike riders. J. Transp. Health 2024, 35, 101770. [Google Scholar] [CrossRef]
- Pearson, L.; Berkovic, D.; Reeder, S.; Gabbe, B.; Beck, B. Adults’ self-reported barriers and enablers to riding a bike for transport: A systematic review. Transp. Rev. 2023, 43, 356–384. [Google Scholar] [CrossRef]
- Apardian, B.; Alam, B.M. A study of the effectiveness of midblock pedestrian crossings: Analyzing a selection of high-visibility warning signs. Interdiscip. J. Signage Wayfinding 2017, 1, 26–59. [Google Scholar] [CrossRef]
- Alam, B.M.; Spainhour, L. Behavioral aspects of younger at-fault drivers in fatal traffic crashes in Florida. In Proceedings of the Transportation Research Board 88th Annual Meeting, Transportation Research Board, Washington, DC, USA, 11–15 January 2009. [Google Scholar]
- Alam, B.M. Evaluation of Age as a Contributing Factor for Fatal Crashes in the State of Florida. Master’s Thesis, College of Engineering, Florida State University, Tallahassee, FL, USA, 2005. [Google Scholar]
Observed Mean Distance: | 755.28 m |
Expected Mean Distance: | 2099.04 m |
Nearest Neighbor Ratio: | 0.36 |
z-score: | −110.22 |
p-value: | 0.00 |
Nearest Neighbor Index Analysis | ||
---|---|---|
Geographic Unit of Analysis | NNI Value | Significance and p-Value |
State | 0.36, which indicates a clustered pattern of bicycle crashes. | Significant (p-value = 0.00) |
Global Moran’s I Analysis | ||
Geographic Unit of Analysis | Global Moran’s I Value | Significance and p-value |
County | 0.10 (slight positive spatial autocorrelation). | Not significant (p-value = 0.14) |
Census Tract | 0.17 (high positive spatial autocorrelation). | Significant (p-value = 0.00) |
Block Group | 0.14 (high positive spatial autocorrelation). | Significant (p-value = 0.00) |
Hotspots and Cold Spots Analysis | ||
Geographic Unit of Analysis | Hotspots | Cold Spots |
County | Six northeast Ohio counties are in the hotspot region at a 99% confidence level, four central Ohio counties are in hotspot regions at a 95% confidence level, and four counties are in hotspot regions at a 90% confidence level. | No cold spots were found. |
Census Tract | Hotspots (99% confidence level) are in or around big cities like Toledo, Cleveland, Dayton, Columbus, Cincinnati, and Akron. | Most cold spots (99% confidence level) are found in the eastern side of the state of Ohio. |
Block Group | Most of the hotspots (99% confidence level) are found in or around the big cities in Ohio. | Cold spots (at a 90% confidence level) were found mostly in the eastern and southern sides of Ohio. |
Local Moran’s I Analysis or LISA | ||
Geographic Unit of Analysis | Similar Values | Dissimilar Values |
County | Two northeastern counties (Summit and Lake) display a cluster pattern with high–high values of bicycle crashes. Low–low clusters were found in the south and southeastern side of Ohio. | Three rural counties in northeast Ohio (Geauga, Portage, and Medina) are outliers in terms of having low–high bicycle crashes. |
Census Tract | High–high clusters of bicycle crashes are seen in or near Cincinnati, Toledo, Columbus, Dayton, and Cleveland metropolitan areas. Low–low clusters of bicycle crashes are visible on the southern and eastern sides of Ohio. | Patches of low–high outliers are noticeable around Cleveland, Akron, and Columbus. |
Block Group | High–high clusters of bicycle crashes are present in or around big metropolitan areas like Toledo, Cleveland, Columbus, Akron, Dayton, and Cincinnati. Low–low clusters of bicycle crashes can be seen again in the eastern and southern parts of Ohio. | High–low values can be found scattered over the state. |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2025 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Rizwan, M.; Alam, B.M.; Kwarteng, Y. Mapping Bicycle Crash-Prone Areas in Ohio Using Exploratory Spatial Data Analysis Techniques: An Investigation into Ohio DOT’s GIS Crash Analysis Tool Data. Future Transp. 2025, 5, 103. https://doi.org/10.3390/futuretransp5030103
Rizwan M, Alam BM, Kwarteng Y. Mapping Bicycle Crash-Prone Areas in Ohio Using Exploratory Spatial Data Analysis Techniques: An Investigation into Ohio DOT’s GIS Crash Analysis Tool Data. Future Transportation. 2025; 5(3):103. https://doi.org/10.3390/futuretransp5030103
Chicago/Turabian StyleRizwan, Modabbir, Bhuiyan Monwar Alam, and Yaw Kwarteng. 2025. "Mapping Bicycle Crash-Prone Areas in Ohio Using Exploratory Spatial Data Analysis Techniques: An Investigation into Ohio DOT’s GIS Crash Analysis Tool Data" Future Transportation 5, no. 3: 103. https://doi.org/10.3390/futuretransp5030103
APA StyleRizwan, M., Alam, B. M., & Kwarteng, Y. (2025). Mapping Bicycle Crash-Prone Areas in Ohio Using Exploratory Spatial Data Analysis Techniques: An Investigation into Ohio DOT’s GIS Crash Analysis Tool Data. Future Transportation, 5(3), 103. https://doi.org/10.3390/futuretransp5030103