Road Traffic Incident (RTI) Data for Sydney Greater Metropolitan Area

The curated Road Traffic Incident (RTI) Data includes 85,611 incidents (crashes, vehicle breakdowns, and others) that took place in the entire Sydney Greater Metropolitan Area, New South Wales, Australia from 1st January 2017 to 31st July 2022. Here, the datasets are presented in the form of Excel files, shapefiles, Python codes (APIs) The raw (File name: "Road Traffic Incident Dataset-Raw.csv") and curated RTI (File name: "Final Road Traffic Incidents.xlsx") datasets are presented in the form of Excel files. Further, metadata (File name: Metadata for final road traffic incidents.xlsx) explain the variables in the curated dataset and is presented in the form of an Excel file. The curated RTI dataset is linked with the zonal information as well such that analysis can be performed at both microscopic and macroscopic levels. The Independent variables such as road network characteristics, public transport network characteristics, socioeconomic characteristics, and travel characteristics at statistical area level-2 (SA2) were curated and presented in the form of an Excel file (File name: Sydney Zones SA2 variables_4.xlsx). Further, metadata (File name: Metadata for Sydney Zones SA2 variables_4.xlsx) that explains the independent variables in the curated dataset is presented in the form of an Excel file. In the shape files folder, 1. "Breakdowns at Sydney zones SA2.zip" is the file where all the breakdown incidents that took place in Sydney MSA are linked to the zones at SA2 2. "Crashes at Sydney zones SA2.zip" is the file where all the crash incidents that took place in Sydney MSA are linked to the zones at SA2 3. "Incidents at Sydney zones SA2.zip" is the file where all the all incidents that took place in Sydney MSA are linked to the zones at SA2 4. "Sydney zones SA2 breakdown count.zip" is the breakdown count at SA2 zones in Sydney MSA 5. "Sydney zones SA2 crash counts.zip" is the crash count at SA2 zones in Sydney MSA 6. "Sydney zones SA2 incident counts.zip" is the count of all incidents at SA2 zones in Sydney MSA 7. "Sydney zones SA2 Edges.zip" - all the edges in the Sydney MSA are linked to SA2 zones 8. "Sydney zones SA2 Nodes.zip"- all the nodes in the Sydney MSA are linked to SA2 zones 9. "Sydney zones SA2 MeshBlocks.zip" - the mesh blocks that tell about the land use in the Sydney MSA are linked to SA2 zones 10. "Sydney zones SA2.zip" - Sydney MSA zonal details for SA2 In the Python code for the API folder, "API code for RTI Data.py" is the Python script for API. The code can be used for extracting incident data from OpenDataHub. Interested users may use the code by simply replacing their own API key for retrieving the data.经整理的道路交通事故（Road Traffic Incident, RTI）数据集包含85611起事件，涵盖碰撞事故、车辆抛锚及其他类型事件，采集时间为2017年1月1日至2022年7月31日，覆盖澳大利亚新南威尔士州整个悉尼大都会区（Sydney Greater Metropolitan Area）。本数据集提供Excel、形状文件（shapefile）与Python代码（应用程序编程接口, API）三类载体：其中原始RTI数据集（文件名为"Road Traffic Incident Dataset-Raw.csv"）与经整理的RTI数据集（文件名为"Final Road Traffic Incidents.xlsx"）均以Excel格式存储。此外，配套元数据（文件名为"Metadata for final road traffic incidents.xlsx"）同样采用Excel格式，用于说明经整理数据集内各变量的具体含义。 经整理的RTI数据集已与分区信息完成关联，支持微观与宏观多尺度分析。数据集还包含经整理的第二级统计区域（Statistical Area Level 2, SA2）维度的自变量数据，涵盖道路网络特征、公共交通网络特征、社会经济特征及出行特征，以Excel文件形式存储（文件名为"Sydney Zones SA2 variables_4.xlsx"）。对应的元数据（文件名为"Metadata for Sydney Zones SA2 variables_4.xlsx"）以Excel格式存储，用于说明该自变量数据集的各变量信息。 形状文件文件夹内包含以下文件： 1. "Breakdowns at Sydney zones SA2.zip"：存储悉尼大都会区所有车辆抛锚事件与SA2分区的关联数据； 2. "Crashes at Sydney zones SA2.zip"：存储悉尼大都会区所有碰撞事故与SA2分区的关联数据； 3. "Incidents at Sydney zones SA2.zip"：存储悉尼大都会区所有事件与SA2分区的关联数据； 4. "Sydney zones SA2 breakdown count.zip"：存储悉尼大都会区SA2分区的车辆抛锚事件统计计数； 5. "Sydney zones SA2 crash counts.zip"：存储悉尼大都会区SA2分区的碰撞事故统计计数； 6. "Sydney zones SA2 incident counts.zip"：存储悉尼大都会区SA2分区的所有事件统计计数； 7. "Sydney zones SA2 Edges.zip"：存储悉尼大都会区所有道路边与SA2分区的关联数据； 8. "Sydney zones SA2 Nodes.zip"：存储悉尼大都会区所有道路节点与SA2分区的关联数据； 9. "Sydney zones SA2 MeshBlocks.zip"：存储悉尼大都会区所有用于表征土地利用的网格块与SA2分区的关联数据； 10. "Sydney zones SA2.zip"：存储悉尼大都会区SA2分区的详细分区信息。 API相关Python代码文件夹内包含"API code for RTI Data.py"脚本，该脚本可用于从OpenDataHub平台提取事件数据。感兴趣的用户仅需替换为自身的API密钥，即可使用该代码完成数据拉取。

搜集汇总

背景与挑战

背景概述

该数据集整理了2017年至2022年悉尼大都会区的85,611起道路交通事故（包括碰撞和故障等），提供Excel、shapefile和Python代码等多种格式，并关联区域信息以支持微观和宏观分析。数据集包含丰富的独立变量（如道路特征和社会经济数据），适用于交通工程和安全研究，采用CC BY 4.0许可协议。