ROAD CRASH DATA VISUALISATION AND ANALYTICS USING TABLEAU FOR MOUNTAINOUS ROADWAY AREAS IN CAMERON HIGHLANDS, MALAYSIA

Authors

  • Fatin Najwa Mohd Nusa Malaysia Institute of Transport (MITRANS), UNIVERSITI TEKNOLOGI MARA (UiTM), SELANGOR MALAYSIA
  • Siti Zaharah Ishak Malaysia Institute of Transport (MITRANS), UNIVERSITI TEKNOLOGI MARA (UiTM), SELANGOR MALAYSIA
  • Rusdi Rusli School of Civil Engineering, College of Engineering, UNIVERSITI TEKNOLOGI MARA (UiTM), SELANGOR MALAYSIA
  • Che Maznah Mat Isa Centre of Studies for Civil Engineering, UNIVERSITI TEKNOLOGI MARA (UiTM), PULAU PINANG, MALAYSIA
  • Muhammad Marizwan Abdul Manan Malaysian Institute of Road Safety Research (MIROS), SELANGOR, MALAYSIA
  • Sonya Sulistyono Department of Civil Engineering, Faculty of Engineering, UNIVERSITAS JEMBER (UNEJ), EAST JAVA, INDONESIA

DOI:

https://doi.org/10.21837/pm.v21i28.1314

Keywords:

Road Accident, Accident Profiling, Road Traffic Injury, Tourism City, Secondary Data

Abstract

Despite government efforts and enforcement, alarming statistics in road crashes with high fatality rates in mountainous roadways are a significant concern to the authorities and community. This research has aimed to produce road crash profiling of Cameron Highlands based on secondary data using Tableau software. Results show that 66 cases involving motorcycles less than 251cc are the most dominant type of vehicle involved in road crashes, followed by tour or excursion vehicles, lorry trailers, four-wheel drive, and cars. The most frequent crash locations in Cameron Highlands are at the boundary of Jalan Keramat Pulai (45 cases) and Jalan Ringlet – Kg. Raja – Blue Valley (50 cases). These cases involved hitting pedestrians, sideswipe collisions, forced collisions, hitting the roadside animal, head-on collisions, vehicles out of control, and right-angle side, which lead to fatal injuries. These findings may assist in identifying intervention planning to control and manage road crashes in mountainous areas.

Downloads

Download data is not yet available.

References

Abdul Manan, M. M., Mohd Zulkiffli, N. S., & Jamil, H. M. (2016). Motorcycle Crash Causation Study ( MCCS ) along Malaysian Expressways. International Journal of Road Safety, 1(1), 26–34.

Cáceres, L., Fernández, M. A., Gordaliza, A., & Molinero, A. (2021). Detection of geometric risk factors affecting head-on collisions through multiple logistic regression: Improving two-way rural road design via 2+1 road adaptation. International Journal of Environmental Research and Public Health, 18(12). https://doi.org/10.3390/ijerph18126598 DOI: https://doi.org/10.3390/ijerph18126598

Duddu, V. R., Pulugurtha, S. S., & Kukkapalli, V. M. (2020). Variable categories influencing single-vehicle run-off-road crashes and their severity. Transportation Engineering, 2(November), 100038. https://doi.org/10.1016/j.treng.2020.100038 DOI: https://doi.org/10.1016/j.treng.2020.100038

Elshamly, A. F., El-Hakim, R. A., & Afify, H. A. (2017). Factors Affecting Accidents Risks among Truck Drivers in Egypt. MATEC Web of Conferences, 124, 10–14. https://doi.org/10.1051/matecconf/201712404009 DOI: https://doi.org/10.1051/matecconf/201712404009

Hamednia, A., Murgovski, N., & Fredriksson, J. (2018). Predictive velocity control in a hilly terrain over a long look-ahead horizon. IFAC-PapersOnLine, 51(31), 485–492. https://doi.org/10.1016/j.ifacol.2018.10.107

Idris, A., Hamid, H., & Teik Hua, L. (2019). Factors contributing to motorcycle accidents in Malaysia. IOP Conference Series: Earth and Environmental Science, 357(1). https://doi.org/10.1088/1755-1315/357/1/012039 DOI: https://doi.org/10.1088/1755-1315/357/1/012039

Ingle, A., & Gates, T. J. (2023). Crash Modification Functions for Rural Skewed Intersections. In Transportation Research Record: Journal of the Transportation Research Board (pp. 1604–1617). https://doi.org/10.1177/03611981221105272 DOI: https://doi.org/10.1177/03611981221105272

Ishak, S. Z., Allyana, S., & Rahim, S. (2020). Where is Malaysia at the End of the Decade of Action for Road Safety 2011-2020 ? 1(1), 1–3.

Jain, M. P., Mane, A., Arkatkar, S. S., Joshi, G. J., Hamednia, A., Murgovski, N., … Jover, E. (2020). Predictive velocity control in a hilly terrain over a long look-ahead horizon. Transportation Research Part D: Transport and Environment, 51(March 2018), 3197–3210. https://doi.org/10.1016/j.ifacol.2018.10.107

Jawi, Z. M., Sarani, R., Voon, W. S., Farhan, A., & Sadullah, M. (2009). Weather as a Road Safety Hazard in Malaysia - An Overview. Selangor, Malaysia.

Joseph, N. M., M., H., R., A. M. V. L., & Mathew, I. (2023). Operating Speed Prediction of Vehicles at Combined Curves Using Mixed Effect Modeling Approach. 8th International Conference on Transportation Systems Engineering and Management, CTSEM 2021, 751–761. DOI: https://doi.org/10.1007/978-981-19-2273-2_49

Maksid, N. H. M., & Hamsa, A. A. K. (2014). Evaluating the effects of road geometrical design towards spot speed distribution on arterial road. Planning Malaysia, 12, 111–126. https://doi.org/10.21837/pmjournal.v12.i3.135 DOI: https://doi.org/10.21837/pmjournal.v12.i3.135

Peng, Y., Wang, X., Peng, S., Huang, H., Tian, G., & Jia, H. (2018). Investigation on the injuries of drivers and copilots in rear-end crashes between trucks based on real world accident data in China. Future Generation Computer Systems, 86, 1251–1258. https://doi.org/10.1016/j.future.2017.07.065 DOI: https://doi.org/10.1016/j.future.2017.07.065

Rusli, R., Haque, M. M., King, M., & Voon, W. S. (2017). Single-vehicle crashes along rural mountainous highways in Malaysia: An application of random parameters negative binomial model. Accident Analysis and Prevention, 102, 153–164. https://doi.org/10.1016/j.aap.2017.03.002 DOI: https://doi.org/10.1016/j.aap.2017.03.002

Shaadan, N., Azhar Suhaimi, M. I. K., Hazmir, M. I., & Hamzah, E. N. (2021). Road accidents analytics with data visualization: A case study in Shah Alam Malaysia. Journal of Physics: Conference Series, 1988(1), 1–15. https://doi.org/10.1088/1742-6596/1988/1/012043 DOI: https://doi.org/10.1088/1742-6596/1988/1/012043

Shallam, R. D. K., Anna, V. A. B. K., Chunchu, M., & Siddagangaiah, A. K. (2022). Safety and Consistency Assessment of a Two-Lane Rural Highway Passing through Mountainous Terrain. Journal of Transportation Engineering, Part A: Systems, 148(12). https://doi.org/10.1061/jtepbs.0000761 DOI: https://doi.org/10.1061/JTEPBS.0000761

Shrestha, J., & Kumar Shrestha, J. (2018). Defining Rural Road Networks in Hilly Areas of Nepal. International Journal of Advanced Engineering and Management, 3(2), 39–42. Retrieved from https://www.researchgate.net/publication/325816827

Sunkpho, J., & Wipulanusat, W. (2020). The role of data visualization and analytics of highway accidents. Walailak Journal of Science and Technology, 17(12), 1379–1389. https://doi.org/10.48048/wjst.2020.10739 DOI: https://doi.org/10.48048/wjst.2020.10739

UNCTAD. (2017). TRANSPORT AND Series No 10 Road Safety - Considerations in Support of the 2030 Agenda for Sustainable Development Considerations in Support of the 2030 Agenda for Sustainable Development. Retrieved from https://unctad.org/system/files/official-document/dtltlb2017d4_en.pdf

Varhelyi, A. (2016). Road Safety Management ‒ The Need for a Systematic Approach. The Open Transportation Journal, 10(1), 137–155. https://doi.org/10.2174/1874447801610010137 DOI: https://doi.org/10.2174/1874447801610010137

Yusoff, Z. M., Aziz, I. S., Naharudin, N., Rasam, A. R. A., & Leh, O. L. H. (2022). Mobility and Proximity Coefficient To Hightraffic Volume in Daily School Operations. Planning Malaysia, 20(2), 321–332. https://doi.org/10.21837/pm.v20i21.1116 DOI: https://doi.org/10.21837/pm.v20i21.1116

Zhang, Q., Luo, H., Yan, J., Travesset-Baro, O., Rosas-Casals, M., Jover, E., … Joshi, G. J. (2020). Predictive velocity control in a hilly terrain over a long look-ahead horizon. Transportation Research Part D: Transport and Environment, 51(31), 3197–3210. https://doi.org/10.1016/j.ifacol.2018.10.107 DOI: https://doi.org/10.1016/j.ifacol.2018.10.107

Downloads

Published

2023-08-31

How to Cite

Mohd Nusa, F. N., Ishak, S. Z., Rusli, R., Mat Isa, C. M., Abdul Manan, M. M., & Sulistyono, S. (2023). ROAD CRASH DATA VISUALISATION AND ANALYTICS USING TABLEAU FOR MOUNTAINOUS ROADWAY AREAS IN CAMERON HIGHLANDS, MALAYSIA. PLANNING MALAYSIA, 21(28). https://doi.org/10.21837/pm.v21i28.1314