Road crash locations
Location and characteristics of crashes within Queensland for all reported Road Traffic Crashes 1 January 2001 to 30 June 2023, (property damage only crashes to 31 December 2010).
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| Crash_Ref_Number | numeric | Crash Reference Number | Unique identifier for each crash incident. Deidentified, and may not be persistent between releases. First 4 digits currently identify the year of the crash |
| Crash_Severity | text | Crash Severity | Crash severity is categorised into five levels: Fatal, Hospitalisation, Medical Treatment, Minor Injury and Property damage only. It is based on the maximum severity of all units involved in the crash. |
| Crash_Year | numeric | Crash Year | Year in which the crash occurred. |
| Crash_Month | text | Crash Month | Month in which the crash occurred. |
| Crash_Day_Of_Week | text | Crash Day Of Week | Day of the week when the crash occurred. |
| Crash_Hour | numeric | Crash Hour | Hour (0 to 23) during which the crash occurred. |
| Crash_Nature | text | Crash Nature | Nature of the initial event (Head-on, hit pedestrian, and so on) |
| Crash_Type | text | Crash Type | For vehicle based crashes it defines if the crash was single or multi vehicle. Otherwise defines non vehicle objects that the primary vehicle struck (Pedestrian, animal, unsecured load and so on) |
| Crash_Longitude | numeric | Crash Longitude | Longitude coordinate where the crash occurred (GDA2020) |
| Crash_Latitude | numeric | Crash Latitude | Latitude coordinate where the crash occurred (GDA2020) |
| Crash_Street | text | ||
| Crash_Street_Intersecting | text | ||
| State_Road_Name | text | ||
| Loc_Suburb | text | ||
| Loc_Local_Government_Area | text | ||
| Loc_Post_Code | text | ||
| Loc_Police_Division | text | ||
| Loc_Police_District | text | ||
| Loc_Police_Region | text | ||
| Loc_Queensland_Transport_Region | text | ||
| Loc_Main_Roads_Region | text | ||
| Loc_ABS_Statistical_Area_2 | text | ||
| Loc_ABS_Statistical_Area_3 | text | ||
| Loc_ABS_Statistical_Area_4 | text | ||
| Loc_ABS_Remoteness | text | ||
| Loc_State_Electorate | text | ||
| Loc_Federal_Electorate | text | ||
| Crash_Controlling_Authority | text | ||
| Crash_Roadway_Feature | text | ||
| Crash_Traffic_Control | text | ||
| Crash_Speed_Limit | text | ||
| Crash_Road_Surface_Condition | text | ||
| Crash_Atmospheric_Condition | text | ||
| Crash_Lighting_Condition | text | ||
| Crash_Road_Horiz_Align | text | ||
| Crash_Road_Vert_Align | text | ||
| Crash_DCA_Code | text | ||
| Crash_DCA_Description | text | ||
| Crash_DCA_Group_Description | text | ||
| DCA_Key_Approach_Dir | text | ||
| Count_Casualty_Fatality | numeric | ||
| Count_Casualty_Hospitalised | numeric | ||
| Count_Casualty_MedicallyTreated | numeric | ||
| Count_Casualty_MinorInjury | numeric | ||
| Count_Casualty_Total | numeric | ||
| Count_Unit_Car | numeric | ||
| Count_Unit_Motorcycle_Moped | numeric | ||
| Count_Unit_Truck | numeric | ||
| Count_Unit_Bus | numeric | ||
| Count_Unit_Bicycle | numeric | ||
| Count_Unit_Pedestrian | numeric | ||
| Count_Unit_Other | numeric |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 29 April 2024 |
| Metadata last updated | 30 May 2024 |
| Created | 4 October 2013 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 |
| do not validate | True |
| Align default schema | False |
| Archiver | {'resource_timestamp': '2021-11-03T04:40:43.661267', 'status_id': 0, 'is_broken': False, 'reason': '', 'url_redirected_to': 'https://www.data.qld.gov.au/dataset/f3e0ca94-2d7b-44ee-abef-d6b06e9b0729/resource/e88943c0-5968-4972-a15f-38e120d72ec0/download/1_crash_locations.csv', 'cache_filepath': 'resources/e88943c0-5968-4972-a15f-38e120d72ec0/1_crash_locations.csv', 'cache_url': 'https://www.data.qld.gov.au/dataset/f3e0ca94-2d7b-44ee-abef-d6b06e9b0729/resource/e88943c0-5968-4972-a15f-38e120d72ec0/download/1_crash_locations.csv', 'size': 176868736, 'mimetype': 'text/csv', 'hash': '"471875accfa84ffb37c9512dda9bd13f"', 'etag': None, 'last_modified': None, 'first_failure': None, 'last_success': '2022-03-08T04:31:12.596677', 'failure_count': 0, 'created': '2020-10-06T12:05:25.836583', 'updated': '2022-03-08T04:31:12.596677', 'status': 'Archived successfully', 'is_broken_printable': 'Downloaded OK'} |
| Ckan url | https://www.data.qld.gov.au |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | True |
| Hash | b83e46233976deb2b1d5239f9295d586 |
| Id | e88943c0-5968-4972-a15f-38e120d72ec0 |
| Ignore hash | True |
| Mimetype | text/csv |
| Nature of change | edit-resource-with-no-new-data |
| Original url | https://www.data.qld.gov.au/dataset/f3e0ca94-2d7b-44ee-abef-d6b06e9b0729/resource/e88943c0-5968-4972-a15f-38e120d72ec0/download/_1_crash_locations.csv |
| Package id | f3e0ca94-2d7b-44ee-abef-d6b06e9b0729 |
| Position | 0 |
| Qa | {'resource_timestamp': None, 'archival_timestamp': '2022-03-08T04:31:12.596677', 'openness_score': 3, 'openness_score_reason': 'Content of file appeared to be format "CSV" which receives openness score: 3.', 'format': 'CSV', 'created': '2020-10-06T05:19:53.364321', 'updated': '2022-03-08T13:00:23.254787'} |
| Resource id | e88943c0-5968-4972-a15f-38e120d72ec0 |
| Set url type | False |
| Size | 189.5 MiB |
| State | active |
| Task created | 2024-05-29 23:02:30.688964 |
| Update frequency | non-regular |
| Update frequency days | {"monthly": 30, "quarterly": 91, "half-yearly": 182, "annually": 365} |
| Url type | upload |
| Validation status | success |
| Validation timestamp | 1 year ago |
| Size | 189.5 MiB |
| Aligned with default data schema | FALSE |
Link checked: 8 March 2022