High-high cluster and high-low outlier road intersections for motorcycle road traffic crashes resulting in injuries within the CoCT in 2017, 2018 and 2019

This dataset offers a detailed inventory of road intersections and their corresponding suburbs within Cape Town, meticulously curated to highlight instances of high motorcycle (Motorcycle: Above 125cc, Motorcycle: 125cc and under, Quadru-cycle, Motor Tricycle) crash counts that resulted in injuries (slight, serious, fatalities) observed in "high-high" cluster and "high-low" outlier fishnet grid cells across the years 2017, 2018 and 2019. To enhance its utility, the dataset meticulously colour-codes each month associated with elevated crash occurrences, providing a nuanced perspective. Furthermore, the dataset categorises road intersections based on their placement within "high-high" clusters (marked with pink tabs) or "high-low" outlier cells (indicated by red tabs). For ease of navigation, the intersections are further organised alphabetically by suburb name, ensuring accessibility and clarity.Data SpecificsData Type: Geospatial-temporal categorical data with numeric attributesFile Format: Word document (.docx)Size: 157 KBNumber of Files: The dataset contains a total of 158 road intersection records (11 "high-high" clusters and 147 "high-low" outliers)Date Created: 22nd May 2024MethodologyData Collection Method: The descriptive road traffic crash data per crash victim involved in the crashes was obtained from the City of Cape Town Network InformationSoftware: ArcGIS Pro, Open Refine, Python, SQLProcessing Steps: The raw road traffic crash data underwent a comprehensive refining process using Python software to ensure its accuracy and consistency. Following this, duplicates were eliminated to retain only one entry per crash incident. Subsequently, the data underwent further refinement with Open Refine software, focusing specifically on isolating unique crash descriptions for subsequent geocoding in ArcGIS Pro. Notably, during this process, only the road intersection crashes were retained, as they were the only incidents with spatial definitions.Once geocoded, road intersection crashes that involved either a motor tricycle, motorcycle above 125cc, motorcycle below 125cc and quadru-cycles and that were additionally associated with a slight, severe or fatal injury type were extracted so that subsequent spatio-temporal analyses would focus on these crashes only. The spatio-temporal analysis methods by which these motorcycle crashes were analysed included spatial autocorrelation, hotspot analysis, and cluster and outlier analysis. Leveraging these methods, road intersections with motorcycle crashes identified as either "high-high" clusters or "high-low" outliers were extracted for inclusion in the dataset.Geospatial InformationSpatial Coverage:West Bounding Coordinate: 18°20'EEast Bounding Coordinate: 19°05'ENorth Bounding Coordinate: 33°25'SSouth Bounding Coordinate: 34°25'SCoordinate System: South African Reference System (Lo19) using the Universal Transverse Mercator projectionTemporal InformationTemporal Coverage:Start Date: 01/01/2017End Date: 31/12/2019

本数据集详尽地记录了开普敦地区道路交叉口及其对应郊区的清单，经过精心编制以凸显不同年份（2017年、2018年及2019年）中“高-高”簇群和“高-低”异常网格单元内摩托车事故（摩托车：排量超过125cc，摩托车：排量125cc以下，四轮摩托车，三轮摩托车）的伤亡情况（轻微伤害、严重伤害、死亡）。为提升其实用性，数据集对与事故高发月份相关的月份进行了细致的彩色编码，从而提供了一种细腻的视角。此外，数据集根据交叉口在“高-高”簇群（以粉色标签标记）或“高-低”异常单元（以红色标签指示）中的位置对道路交叉口进行了分类。为便于导航，交叉口还按照所在郊区名称的字母顺序进行了组织，确保了数据的可访问性和清晰度。

数据具体信息
数据类型：带有数值属性的地理时空分类数据
文件格式：Word文档（.docx）
大小：157 KB
文件数量：数据集中包含总计158条道路交叉口记录（11个“高-高”簇群和147个“高-低”异常）
创建日期：2024年5月22日

研究方法
数据收集方法：通过开普敦市网络信息获取了每起事故中涉及的事故受害者描述性道路交通事故数据
软件：ArcGIS Pro，Open Refine，Python，SQL
处理步骤：使用Python软件对原始道路交通事故数据进行了全面精炼，以确保其准确性和一致性。随后，消除了重复条目，仅保留每起事故事件的一条记录。接着，使用Open Refine软件对数据进行进一步精炼，重点关注提取独特的事故描述，以便在ArcGIS Pro中进行地理编码。值得注意的是，在此过程中，仅保留了具有空间定义的道路交叉口事故，因为它们是唯一具有空间定义的事故。

一旦完成地理编码，涉及三轮摩托车、排量超过125cc的摩托车、排量低于125cc的摩托车和四轮摩托车，并且与轻微伤害、严重伤害或致命伤害类型相关的事故交叉口被提取出来，以便后续的时空分析仅针对这些事故进行。分析摩托车事故所采用的时空分析方法包括空间自相关分析、热点分析以及簇群和异常分析。通过利用这些方法，提取了被标识为“高-高”簇群或“高-低”异常的道路交叉口，并将它们纳入数据集中。

地理空间信息
地理覆盖范围：
西经边界坐标：18°20'EE
东经边界坐标：19°05'EE
北纬边界坐标：33°25'S
南纬边界坐标：34°25'S
坐标系：使用通用横轴墨卡托投影的南非参考系统（Lo19）

时空信息
时空覆盖范围：
开始日期：01/01/2017
结束日期：31/12/2019