Victoria road crash data
The GeoJSON data is a single flat file containing a subset of the attributes from the various 'Victoria Road Crash Data' csv files. It provides a single set of attributes for each road crash that has occurred within Victoria. Supporting documentation in the metadata will provide further details of the attributes.
There are no views created for this resource yet.
Data Dictionary
| Field Name | Name | Type | Description | Fixed Values |
|---|---|---|---|---|
| ACCIDENT NO | Accident No | CHAR(12) | ACCIDENT NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values. First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number | |
| ACCIDENT DATE | Accident Date | DATE(10) | TBC | |
| ACCIDENT TIME | Accident Time | TIME(16) | hh.mm.ss. Original date stored in 24 hour format (ie 1pm = 1300 hours) Note the common practice used by the Police, when originally coding up the accident details, of 'rounding off the time' to the nearest 5 minutes or even nearest hour. This naturally occurs because in the vast majority of accidents police arrive at the scene well after the accident occurred and so the 'REAL' time of the accident is never precisely known. | |
| ACCIDENT TYPE | Accident Type | VARCHAR(100) | Is a character field indicates the type of accident. It is a basic description of what occurred, based on nine categories. E.g. Collision with Vehicle | 1 Collision with vehicle 2 Struck pedestrian 3 Struck animal 4 Collision with a fixed object 5 Collision with some other object 6 Vehicle overturned (no collision) 7 Fall from or in moving vehicle 8 No collision and no object struck 9 Other accident |
| DAY OF WEEK | Day Of Week | NVARCHAR(30) | The field indicates the day of the week upon which the accident occurred | 1 Sunday 2 Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7 Saturday |
| DCA CODE | DCACode | CHAR(3) | The field indicates the Definitions for Classifying Accidents. It cannot contain NULL values. | 100-781 |
| DCA CODE DESCRIPTION | Dca Code Description | VARCHAR(100) | DIVIDED is a descriptive field indicating divided portion of road. | |
| LIGHT CONDITION | Light Condition | VARCHAR(100) | Indicates the light condition or level of brightness at the time of the accident. This field cannot contain NULL values. | 1 Day 2 Dusk/dawn 3 Dark street lights on 4 Dark street lights off 5 Dark no street lights 6 Dark street lights unknown 9 Unknown |
| POLICE ATTEND | Police Attend | VARCHAR(100) | Indicates whether the police attended the scene of the accident or not. | Code Description 1 Yes 2 No 9 Not known |
| ROAD GEOMETRY | Road Geometry | VARCHAR(100) | Code for layout of the road where the accident occurred | Code Description 1 Cross intersection 2 'T' Intersection 3 'Y' Intersection 4 Multiple intersections 5 Not at intersection 6 Dead end 7 Road closure 8 Private property 9 Unknown |
| SEVERITY | Severity | VARCHAR(100) | Estimation of the severity or seriousness of the accident | 1 Fatal accident 2 Serious injury accident 3 Other injury accident 4 Non injury accident |
| SPEED ZONE | Speed Zone | VARCHAR(100) | the speed zone at the location of the accident. The speed zone is generally assigned to the main vehicle involved. | 040 40 km/hr 050 50 km/hr 060 60 km/hr 075 75 km/hr 080 80 km/hr 090 90 km/hr 100 100 km/hr 110 110 km/hr 777 Other speed limit 888 Camping grounds, off road 999 Not known |
| RUN OFFROAD | Run Off Road | VARCHAR(3) | If the crash is considered a run off road (DCA Codes: 151, 170-173, 180-183) | Yes/No |
| ROAD NAME | Road Name | NVARCHAR(50) | TBC | |
| ROAD TYPE | Road Type | NVARCHAR(22) | TBC | |
| ROAD ROUTE 1 | Road Route 1 | INTEGER(10) | TBC | |
| LGA NAME | LGA Name | NVARCHAR(100) | LGA NAME is a character field contains the LGA name for the location of the crash | |
| DTP REGION | DTP Region | NVARCHAR(35) | TBC | |
| LATITUDE | Latitude | DECIMAL(10) | Geographical coordinates | |
| LONGITUDE | Longitude | DECIMAL(10) | Geographical coordinates | |
| VICGRID X | Vicgrid X | NUMERIC(38) | VicGrid94 coordinates | |
| VICGRID Y | Vicgrid Y | NUMERIC(38) | VicGrid94 coordinates | |
| TOTAL PERSONS | Total Persons | INTEGER(10) | the number of people involved in the accident | |
| INJ OR FATAL | Inj Or Fatal | INTEGER(10) | the number of people involved in the accident killed or injured | |
| FATALITY | Fatality | INTEGER(10) | Number of people who have died in the crash | |
| SERIOUSINJURY | Serious Injury | INTEGER(10) | Number of people with a serious injury | |
| OTHERINJURY | Other Injury | INTEGER(10) | Number of people with an other injury | |
| NONINJURED | Non Injured | INTEGER(10) | Number of people with no injuries | |
| MALES | Males | INTEGER(10) | Number of males involved in the crash | |
| FEMALES | Females | INTEGER(10) | Number of females involved in the crash | |
| BICYCLIST | Bicyclist | INTEGER(10) | Number of bicyclists involved in the crash | |
| PASSENGER | Passenger | INTEGER(10) | Number of passengers involved in the crash | |
| DRIVER | Driver | INTEGER(10) | Number of drivers involved in the crash | |
| PEDESTRIAN | Pedestrian | INTEGER(10) | Number of pedestrians involved in the crash | |
| PILLION | Pillion | INTEGER(10) | Number of pillion passengers involved in the crash | |
| MOTORCYCLIST | Motorcyclist | INTEGER(10) | Number of motorcyclists involved in the crash | |
| UNKNOWN | Unknown | INTEGER(10) | Number of unknown road users involved in the crash | |
| PED CYCLIST 5 12 | Ped Cyclist 5-12 | INTEGER(10) | Number of pedestrians and cyclists between the ages 5 and 12 | |
| PED CYCLIST 13 18 | Ped Cyclist 13-18 | INTEGER(10) | Number of pedestrians and cyclists between the ages 13 and 18 | |
| OLD PED 65 AND OVER | Old Ped 65 And Over | INTEGER(10) | Number of pedestrians aged 65 and over | |
| OLD DRIVER 75 AND OVER | Old Driver 75 And Over | INTEGER(10) | Number of drivers aged 75 and older | |
| YOUNG DRIVER 18 25 | Young Driver 18-25 | INTEGER(10) | Number of drivers aged between 18 and 25 | |
| NO OF VEHICLES | No Of Vehicles | INTEGER(10) | the number of vehicles involved in the accident. Includes bicycles but not objects, property, toys (skate boards), etc. | |
| HEAVYVEHICLE | Heavy vehicle | INTEGER(10) | Number of heavy vehicles involved in the crash | |
| PASSENGERVEHICLE | Passenger Vehicle | INTEGER(10) | Number of passenger vehicles involved in the crash | |
| MOTORCYCLE | Motorcycle | INTEGER(10) | Number of motorcycles involved in the crash | |
| PT VEHICLE | Pt Vehicle | INTEGER(10) | Number of public transport vehicles involved in the crash (tram, bus, train) | |
| DEG URBAN NAME | Degree Urban Name | NVARCHAR(40) | DEG URBAN NAME is a character field indicates degree of urban name for the location of the crash. | |
| SRNS | SRNS | VARCHAR(1) | State road numbering system code | |
| RMA | RMA | VARCHAR(16) | RMA Classification of the road contains VicRoads road classification. | |
| DIVIDED | Divided | VARCHAR(9) | DIVIDED is a character field indicating divided portion of road. | |
| STAT DIV NAME | Stat Div Name | CHAR(40) | STAT DIV NAME is a character field indicates statistical division name for the location of the crash. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 18 March 2025 |
| Metadata last updated | 18 March 2025 |
| Created | 18 March 2025 |
| Format | GeoJSON |
| License | Creative Commons Attribution 4.0 International |
| Attributes | [{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT NO", "definition": "ACCIDENT NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values. First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number", "fixed_values": "", "id": "7343", "name": "Accident No", "ref_number": "AT-7343"}, {"attribute_display_order_id": 2, "db_format": "DATE(10)", "db_name": "ACCIDENT DATE", "definition": "TBC", "fixed_values": "", "id": "7333", "name": "Accident Date", "ref_number": "AT-7333"}, {"attribute_display_order_id": 3, "db_format": "TIME(16)", "db_name": "ACCIDENT TIME", "definition": "hh.mm.ss. Original date stored in 24 hour format (ie 1pm = 1300 hours) Note the common practice used by the Police, when originally coding up the accident details, of 'rounding off the time' to the nearest 5 minutes or even nearest hour. This naturally occurs because in the vast majority of accidents police arrive at the scene well after the accident occurred and so the 'REAL' time of the accident is never precisely known.", "fixed_values": "", "id": "7320", "name": "Accident Time", "ref_number": "AT-7320"}, {"attribute_display_order_id": 4, "db_format": "VARCHAR(100)", "db_name": "ACCIDENT TYPE", "definition": "Is a character field indicates the type of accident. It is a basic description of what occurred, based on nine categories. E.g. Collision with Vehicle", "fixed_values": "1 Collision with vehicle 2 Struck pedestrian 3 Struck animal 4 Collision with a fixed object 5 Collision with some other object 6 Vehicle overturned (no collision) 7 Fall from or in moving vehicle 8 No collision and no object struck 9 Other accident", "id": "7328", "name": "Accident Type", "ref_number": "AT-7328"}, {"attribute_display_order_id": 5, "db_format": "NVARCHAR(30)", "db_name": "DAY OF WEEK", "definition": "The field indicates the day of the week upon which the accident occurred", "fixed_values": "1 Sunday 2 Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7 Saturday", "id": "7318", "name": "Day Of Week", "ref_number": "AT-7318"}, {"attribute_display_order_id": 6, "db_format": "CHAR(3)", "db_name": "DCA CODE", "definition": "The field indicates the Definitions for Classifying Accidents. It cannot contain NULL values.", "fixed_values": "100-781", "id": "7309", "name": "DCACode", "ref_number": "AT-7309"}, {"attribute_display_order_id": 7, "db_format": "VARCHAR(100)", "db_name": "DCA CODE DESCRIPTION", "definition": "DIVIDED is a descriptive field indicating divided portion of road.", "fixed_values": "", "id": "7340", "name": "Dca Code Description", "ref_number": "AT-7340"}, {"attribute_display_order_id": 8, "db_format": "VARCHAR(100)", "db_name": "LIGHT CONDITION", "definition": "Indicates the light condition or level of brightness at the time of the accident. This field cannot contain NULL values.", "fixed_values": "1 Day 2 Dusk/dawn 3 Dark street lights on 4 Dark street lights off 5 Dark no street lights 6 Dark street lights unknown 9 Unknown", "id": "7336", "name": "Light Condition", "ref_number": "AT-7336"}, {"attribute_display_order_id": 9, "db_format": "VARCHAR(100)", "db_name": "POLICE ATTEND", "definition": "Indicates whether the police attended the scene of the accident or not.", "fixed_values": "Code Description 1 Yes 2 No 9 Not known", "id": "7352", "name": "Police Attend", "ref_number": "AT-7352"}, {"attribute_display_order_id": 10, "db_format": "VARCHAR(100)", "db_name": "ROAD GEOMETRY", "definition": "Code for layout of the road where the accident occurred", "fixed_values": "Code Description 1 Cross intersection 2 'T' Intersection 3 'Y' Intersection 4 Multiple intersections 5 Not at intersection 6 Dead end 7 Road closure 8 Private property 9 Unknown", "id": "7353", "name": "Road Geometry", "ref_number": "AT-7353"}, {"attribute_display_order_id": 11, "db_format": "VARCHAR(100)", "db_name": "SEVERITY", "definition": "Estimation of the severity or seriousness of the accident", "fixed_values": "1 Fatal accident 2 Serious injury accident 3 Other injury accident 4 Non injury accident", "id": "7345", "name": "Severity", "ref_number": "AT-7345"}, {"attribute_display_order_id": 12, "db_format": "VARCHAR(100)", "db_name": "SPEED ZONE", "definition": "the speed zone at the location of the accident. The speed zone is generally assigned to the main vehicle involved.", "fixed_values": "040 40 km/hr 050 50 km/hr 060 60 km/hr 075 75 km/hr 080 80 km/hr 090 90 km/hr 100 100 km/hr 110 110 km/hr 777 Other speed limit 888 Camping grounds, off road 999 Not known", "id": "7316", "name": "Speed Zone", "ref_number": "AT-7316"}, {"attribute_display_order_id": 13, "db_format": "VARCHAR(3)", "db_name": "RUN OFFROAD", "definition": "If the crash is considered a run off road (DCA Codes: 151, 170-173, 180-183)", "fixed_values": "Yes/No", "id": "7358", "name": "Run Off Road", "ref_number": "AT-7358"}, {"attribute_display_order_id": 14, "db_format": "NVARCHAR(50)", "db_name": "ROAD NAME", "definition": "TBC", "fixed_values": "", "id": "7341", "name": "Road Name", "ref_number": "AT-7341"}, {"attribute_display_order_id": 15, "db_format": "NVARCHAR(22)", "db_name": "ROAD TYPE", "definition": "TBC", "fixed_values": "", "id": "7322", "name": "Road Type", "ref_number": "AT-7322"}, {"attribute_display_order_id": 16, "db_format": "INTEGER(10)", "db_name": "ROAD ROUTE 1", "definition": "TBC", "fixed_values": "", "id": "7327", "name": "Road Route 1", "ref_number": "AT-7327"}, {"attribute_display_order_id": 17, "db_format": "NVARCHAR(100)", "db_name": "LGA NAME", "definition": "LGA NAME is a character field contains the LGA name for the location of the crash", "fixed_values": "", "id": "7321", "name": "LGA Name", "ref_number": "AT-7321"}, {"attribute_display_order_id": 18, "db_format": "NVARCHAR(35)", "db_name": "DTP REGION", "definition": "TBC", "fixed_values": "", "id": "7319", "name": "DTP Region", "ref_number": "AT-7319"}, {"attribute_display_order_id": 19, "db_format": "DECIMAL(10)", "db_name": "LATITUDE", "definition": "Geographical coordinates", "fixed_values": "", "id": "7348", "name": "Latitude", "ref_number": "AT-7348"}, {"attribute_display_order_id": 20, "db_format": "DECIMAL(10)", "db_name": "LONGITUDE", "definition": "Geographical coordinates", "fixed_values": "", "id": "7342", "name": "Longitude", "ref_number": "AT-7342"}, {"attribute_display_order_id": 21, "db_format": "NUMERIC(38)", "db_name": "VICGRID X", "definition": "VicGrid94 coordinates", "fixed_values": "", "id": "7310", "name": "Vicgrid X", "ref_number": "AT-7310"}, {"attribute_display_order_id": 22, "db_format": "NUMERIC(38)", "db_name": "VICGRID Y", "definition": "VicGrid94 coordinates", "fixed_values": "", "id": "7324", "name": "Vicgrid Y", "ref_number": "AT-7324"}, {"attribute_display_order_id": 23, "db_format": "INTEGER(10)", "db_name": "TOTAL PERSONS", "definition": "the number of people involved in the accident", "fixed_values": "", "id": "7332", "name": "Total Persons", "ref_number": "AT-7332"}, {"attribute_display_order_id": 24, "db_format": "INTEGER(10)", "db_name": "INJ OR FATAL", "definition": "the number of people involved in the accident killed or injured", "fixed_values": "", "id": "7331", "name": "Inj Or Fatal", "ref_number": "AT-7331"}, {"attribute_display_order_id": 25, "db_format": "INTEGER(10)", "db_name": "FATALITY", "definition": "Number of people who have died in the crash", "fixed_values": "", "id": "7329", "name": "Fatality", "ref_number": "AT-7329"}, {"attribute_display_order_id": 26, "db_format": "INTEGER(10)", "db_name": "SERIOUSINJURY", "definition": "Number of people with a serious injury", "fixed_values": "", "id": "7337", "name": "Serious Injury", "ref_number": "AT-7337"}, {"attribute_display_order_id": 27, "db_format": "INTEGER(10)", "db_name": "OTHERINJURY", "definition": "Number of people with an other injury", "fixed_values": "", "id": "7313", "name": "Other Injury", "ref_number": "AT-7313"}, {"attribute_display_order_id": 28, "db_format": "INTEGER(10)", "db_name": "NONINJURED", "definition": "Number of people with no injuries", "fixed_values": "", "id": "7339", "name": "Non Injured", "ref_number": "AT-7339"}, {"attribute_display_order_id": 29, "db_format": "INTEGER(10)", "db_name": "MALES", "definition": "Number of males involved in the crash", "fixed_values": "", "id": "7338", "name": "Males", "ref_number": "AT-7338"}, {"attribute_display_order_id": 30, "db_format": "INTEGER(10)", "db_name": "FEMALES", "definition": "Number of females involved in the crash", "fixed_values": "", "id": "7349", "name": "Females", "ref_number": "AT-7349"}, {"attribute_display_order_id": 31, "db_format": "INTEGER(10)", "db_name": "BICYCLIST", "definition": "Number of bicyclists involved in the crash", "fixed_values": "", "id": "7354", "name": "Bicyclist", "ref_number": "AT-7354"}, {"attribute_display_order_id": 32, "db_format": "INTEGER(10)", "db_name": "PASSENGER", "definition": "Number of passengers involved in the crash", "fixed_values": "", "id": "7326", "name": "Passenger", "ref_number": "AT-7326"}, {"attribute_display_order_id": 33, "db_format": "INTEGER(10)", "db_name": "DRIVER", "definition": "Number of drivers involved in the crash", "fixed_values": "", "id": "7344", "name": "Driver", "ref_number": "AT-7344"}, {"attribute_display_order_id": 34, "db_format": "INTEGER(10)", "db_name": "PEDESTRIAN", "definition": "Number of pedestrians involved in the crash", "fixed_values": "", "id": "7346", "name": "Pedestrian", "ref_number": "AT-7346"}, {"attribute_display_order_id": 35, "db_format": "INTEGER(10)", "db_name": "PILLION", "definition": "Number of pillion passengers involved in the crash", "fixed_values": "", "id": "7347", "name": "Pillion", "ref_number": "AT-7347"}, {"attribute_display_order_id": 36, "db_format": "INTEGER(10)", "db_name": "MOTORCYCLIST", "definition": "Number of motorcyclists involved in the crash", "fixed_values": "", "id": "7360", "name": "Motorcyclist", "ref_number": "AT-7360"}, {"attribute_display_order_id": 37, "db_format": "INTEGER(10)", "db_name": "UNKNOWN", "definition": "Number of unknown road users involved in the crash", "fixed_values": "", "id": "7359", "name": "Unknown", "ref_number": "AT-7359"}, {"attribute_display_order_id": 38, "db_format": "INTEGER(10)", "db_name": "PED CYCLIST 5 12", "definition": "Number of pedestrians and cyclists between the ages 5 and 12", "fixed_values": "", "id": "7311", "name": "Ped Cyclist 5-12", "ref_number": "AT-7311"}, {"attribute_display_order_id": 39, "db_format": "INTEGER(10)", "db_name": "PED CYCLIST 13 18", "definition": "Number of pedestrians and cyclists between the ages 13 and 18", "fixed_values": "", "id": "7317", "name": "Ped Cyclist 13-18", "ref_number": "AT-7317"}, {"attribute_display_order_id": 40, "db_format": "INTEGER(10)", "db_name": "OLD PED 65 AND OVER", "definition": "Number of pedestrians aged 65 and over", "fixed_values": "", "id": "7350", "name": "Old Ped 65 And Over", "ref_number": "AT-7350"}, {"attribute_display_order_id": 41, "db_format": "INTEGER(10)", "db_name": "OLD DRIVER 75 AND OVER", "definition": "Number of drivers aged 75 and older", "fixed_values": "", "id": "7334", "name": "Old Driver 75 And Over", "ref_number": "AT-7334"}, {"attribute_display_order_id": 42, "db_format": "INTEGER(10)", "db_name": "YOUNG DRIVER 18 25", "definition": "Number of drivers aged between 18 and 25", "fixed_values": "", "id": "7323", "name": "Young Driver 18-25", "ref_number": "AT-7323"}, {"attribute_display_order_id": 43, "db_format": "INTEGER(10)", "db_name": "NO OF VEHICLES", "definition": "the number of vehicles involved in the accident. Includes bicycles but not objects, property, toys (skate boards), etc.", "fixed_values": "", "id": "7314", "name": "No Of Vehicles", "ref_number": "AT-7314"}, {"attribute_display_order_id": 44, "db_format": "INTEGER(10)", "db_name": "HEAVYVEHICLE", "definition": "Number of heavy vehicles involved in the crash", "fixed_values": "", "id": "7335", "name": "Heavy vehicle", "ref_number": "AT-7335"}, {"attribute_display_order_id": 45, "db_format": "INTEGER(10)", "db_name": "PASSENGERVEHICLE", "definition": "Number of passenger vehicles involved in the crash", "fixed_values": "", "id": "7357", "name": "Passenger Vehicle", "ref_number": "AT-7357"}, {"attribute_display_order_id": 46, "db_format": "INTEGER(10)", "db_name": "MOTORCYCLE", "definition": "Number of motorcycles involved in the crash", "fixed_values": "", "id": "7330", "name": "Motorcycle", "ref_number": "AT-7330"}, {"attribute_display_order_id": 47, "db_format": "INTEGER(10)", "db_name": "PT VEHICLE", "definition": "Number of public transport vehicles involved in the crash (tram, bus, train)", "fixed_values": "", "id": "7312", "name": "Pt Vehicle", "ref_number": "AT-7312"}, {"attribute_display_order_id": 48, "db_format": "NVARCHAR(40)", "db_name": "DEG URBAN NAME", "definition": "DEG URBAN NAME is a character field indicates degree of urban name for the location of the crash.", "fixed_values": "", "id": "7355", "name": "Degree Urban Name", "ref_number": "AT-7355"}, {"attribute_display_order_id": 49, "db_format": "VARCHAR(1)", "db_name": "SRNS", "definition": "State road numbering system code", "fixed_values": "", "id": "7315", "name": "SRNS", "ref_number": "AT-7315"}, {"attribute_display_order_id": 50, "db_format": "VARCHAR(16)", "db_name": "RMA", "definition": "RMA Classification of the road contains VicRoads road classification.", "fixed_values": "", "id": "7351", "name": "RMA", "ref_number": "AT-7351"}, {"attribute_display_order_id": 51, "db_format": "VARCHAR(9)", "db_name": "DIVIDED", "definition": "DIVIDED is a character field indicating divided portion of road.", "fixed_values": "", "id": "7325", "name": "Divided", "ref_number": "AT-7325"}, {"attribute_display_order_id": 52, "db_format": "CHAR(40)", "db_name": "STAT DIV NAME", "definition": "STAT DIV NAME is a character field indicates statistical division name for the location of the crash.", "fixed_values": "", "id": "7356", "name": "Stat Div Name", "ref_number": "AT-7356"}] |
| Dataset last updated date | 3 weeks ago |
| Datastore active | False |
| Datastore contains all records of source file | False |
| Edc sync | True |
| Has views | False |
| Historical | False |
| Id | 92b63aed-6d64-42a0-b708-66c2c23dae7d |
| Last updated date | 3 weeks ago |
| Mimetype | application/geo+json |
| Open dataset title | Victoria Road Crash Data |
| Package id | 4de2a60e-d87e-41cb-8bb5-bca17b7f679f |
| Period end | 2024-07-31 |
| Period start | 2012-01-01 |
| Position | 9 |
| Publication date | 13 years ago |
| State | active |
| File Size | 291.2 MB |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 July 2024 |