University of Cape Town
Association_Analysis_HHCluster_Motorcycle_Crashes_2017_2018_2019_Injuries.xlsx (29.85 kB)

Association analysis of high-high cluster road intersection crashes involving motorcycles that resulted in injuries within the CoCT in 2017, 2018 and 2019

Download (29.85 kB)
Version 2 2024-06-06, 11:15
Version 1 2024-06-05, 12:59
posted on 2024-06-06, 11:15 authored by Simone VieiraSimone Vieira, Simon HullSimon Hull, Roger Behrens

This dataset provides comprehensive information on road intersection crashes involving motorcycles (Motor tricycle, Motorcycle: under 125cc, Motorcycle: Above 125cc, Quadru-cycle) that have resulted in injuries recognised as "high-high" clusters within the City of Cape Town. It includes detailed records of all intersection crashes and their corresponding crash attribute combinations, which were prevalent in 33% of the total "high-high" cluster motorcycle road intersection crashes resulting in injuries for the years 2017, 2018 and 2019. The dataset is meticulously organised according to confidence metric values presented in descending order.

Data Specifics

Data Type: Geospatial-temporal categorical data

File Format: Excel document (.xlsx)

Size: 29,8 KB

Number of Files: The dataset contains a total of 576 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-high" cluster fishnet grid cells from a cluster and outlier analysis, all the road intersection crashes involving a motorcycle resulting in injuries that occurred within the "high-high" cluster 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,30 support metric value. Consequently, commonly occurring crash attributes among at least 33% of the "high-high" cluster road intersection motorcycle crashes resulting in injuries 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/2019


Centre for Transport Studies UCT



Department of Architecture, Planning and Geomatics

Product Type

  • Site Map File Set