University of Cape Town
Association_Analysis_HLOutlier_Public_Transport_Crashes_common_2017_2018_2019_2021_.xlsx (65.91 kB)

Association analysis of high-low outlier road intersection crashes involving public transport within the CoCT in 2017, 2018, 2019 and 2021

Download (65.91 kB)
posted on 2024-06-06, 11:18 authored by Simone VieiraSimone Vieira, Simon HullSimon Hull, Roger Behrens

This dataset provides comprehensive information on road intersection crashes involving public transport (Bus, Bus-train, Combi/minibusses, midibusses) recognised as "high-low" outliers within the City of Cape Town. It includes detailed records of all intersection crashes and their corresponding crash attribute combinations, which were prevalent in at least 10% of the total "high-low" outlier public transport road intersection crashes for the years 2017, 2018, 2019, and 2021.The dataset is meticulously organised according to support metric values, ranging from 0,10 to 0,17, with entries presented in descending order.

Data Specifics

Data Type: Geospatial-temporal categorical data

File Format: Excel document (.xlsx)

Size: 65,9 KB

Number of Files: The dataset contains a total of 1280 association rules

Date Created: 23rd May 2024


Data Collection Method: The descriptive road traffic crash data per crash victim involved in the crashes was obtained from the City of Cape Town Network Information

Software: ArcGIS Pro, Python

Processing Steps: Following the spatio-temporal analyses and the derivation of "high-low" outlier fishnet grid cells from a cluster and outlier analysis, all the road intersection crashes involving public transport that occurred within the "high-low" outlier fishnet grid cells were extracted to be processed by association analysis. The association analysis of these crashes was processed using Python software and involved the use of a 0,10 support metric value. Consequently, commonly occurring crash attributes among at least 10% of the "high-low" outlier road intersection public transport crashes were extracted for inclusion in this dataset.

Geospatial Information

Spatial Coverage:

West Bounding Coordinate: 18°20'E

East Bounding Coordinate: 19°05'E

North Bounding Coordinate: 33°25'S

South Bounding Coordinate: 34°25'S

Coordinate System: South African Reference System (Lo19) using the Universal Transverse Mercator projection

Temporal Information

Temporal Coverage:

Start Date: 01/01/2017

End Date: 31/12/2021 (2020 data omitted)


Centre for Transport Studies UCT



Department of Architecture, Planning and Geomatics

Product Type

  • Site Map File Set