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 |
|---|---|---|---|---|
| DCA CODE | DCACode | CHAR(3) | The field indicates the Definitions for Classifying Accidents. It cannot contain NULL values. | 100-781 |
| VICGRID X | Vicgrid X | NUMERIC(38) | VicGrid94 coordinates | |
| PED CYCLIST 5 12 | Ped Cyclist 5-12 | INTEGER(10) | Number of pedestrians and cyclists between the ages 5 and 12 | |
| PT VEHICLE | Pt Vehicle | INTEGER(10) | Number of public transport vehicles involved in the crash (tram, bus, train) | |
| OTHERINJURY | Other Injury | INTEGER(10) | Number of people with an other injury | |
| 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. | |
| SRNS | SRNS | VARCHAR(1) | State road numbering system code | |
| 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 |
| PED CYCLIST 13 18 | Ped Cyclist 13-18 | INTEGER(10) | Number of pedestrians and cyclists between the ages 13 and 18 | |
| 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 |
| DTP REGION | DTP Region | NVARCHAR(35) | 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. | |
| LGA NAME | LGA Name | NVARCHAR(100) | LGA NAME is a character field contains the LGA name for the location of the crash | |
| ROAD TYPE | Road Type | NVARCHAR(22) | TBC | |
| YOUNG DRIVER 18 25 | Young Driver 18-25 | INTEGER(10) | Number of drivers aged between 18 and 25 | |
| VICGRID Y | Vicgrid Y | NUMERIC(38) | VicGrid94 coordinates | |
| DIVIDED | Divided | VARCHAR(9) | DIVIDED is a character field indicating divided portion of road. | |
| PASSENGER | Passenger | INTEGER(10) | Number of passengers involved in the crash | |
| ROAD ROUTE 1 | Road Route 1 | INTEGER(10) | TBC | |
| 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 |
| FATALITY | Fatality | INTEGER(10) | Number of people who have died in the crash | |
| MOTORCYCLE | Motorcycle | INTEGER(10) | Number of motorcycles involved in the crash | |
| INJ OR FATAL | Inj Or Fatal | INTEGER(10) | the number of people involved in the accident killed or injured | |
| TOTAL PERSONS | Total Persons | INTEGER(10) | the number of people involved in the accident | |
| ACCIDENT DATE | Accident Date | DATE(10) | TBC | |
| OLD DRIVER 75 AND OVER | Old Driver 75 And Over | INTEGER(10) | Number of drivers aged 75 and older | |
| HEAVYVEHICLE | Heavy vehicle | INTEGER(10) | Number of heavy vehicles involved in the crash | |
| 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 |
| SERIOUSINJURY | Serious Injury | INTEGER(10) | Number of people with a serious injury | |
| MALES | Males | INTEGER(10) | Number of males involved in the crash | |
| NONINJURED | Non Injured | INTEGER(10) | Number of people with no injuries | |
| DCA CODE DESCRIPTION | Dca Code Description | VARCHAR(100) | DIVIDED is a descriptive field indicating divided portion of road. | |
| ROAD NAME | Road Name | NVARCHAR(50) | TBC | |
| LONGITUDE | Longitude | DECIMAL(10) | Geographical coordinates | |
| 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 | |
| DRIVER | Driver | INTEGER(10) | Number of drivers involved in the crash | |
| 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 |
| PEDESTRIAN | Pedestrian | INTEGER(10) | Number of pedestrians involved in the crash | |
| PILLION | Pillion | INTEGER(10) | Number of pillion passengers involved in the crash | |
| LATITUDE | Latitude | DECIMAL(10) | Geographical coordinates | |
| FEMALES | Females | INTEGER(10) | Number of females involved in the crash | |
| OLD PED 65 AND OVER | Old Ped 65 And Over | INTEGER(10) | Number of pedestrians aged 65 and over | |
| RMA | RMA | VARCHAR(16) | RMA Classification of the road contains VicRoads road classification. | |
| 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 |
| BICYCLIST | Bicyclist | INTEGER(10) | Number of bicyclists involved in the crash | |
| 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. | |
| 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. | |
| PASSENGERVEHICLE | Passenger Vehicle | INTEGER(10) | Number of passenger vehicles involved in the crash | |
| 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 |
| UNKNOWN | Unknown | INTEGER(10) | Number of unknown road users involved in the crash | |
| MOTORCYCLIST | Motorcyclist | INTEGER(10) | Number of motorcyclists involved in the crash |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 16 November 2024 |
| Metadata last updated | 20 November 2024 |
| Created | 16 November 2024 |
| Format | GeoJSON |
| License | Creative Commons Attribution 4.0 International |
| Attributes | [{"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"}, {"db_format": "NUMERIC(38)", "db_name": "VICGRID X", "definition": "VicGrid94 coordinates", "fixed_values": "", "id": "7310", "name": "Vicgrid X", "ref_number": "AT-7310"}, {"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"}, {"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"}, {"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"}, {"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"}, {"db_format": "VARCHAR(1)", "db_name": "SRNS", "definition": "State road numbering system code", "fixed_values": "", "id": "7315", "name": "SRNS", "ref_number": "AT-7315"}, {"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"}, {"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"}, {"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"}, {"db_format": "NVARCHAR(35)", "db_name": "DTP REGION", "definition": "TBC", "fixed_values": "", "id": "7319", "name": "DTP Region", "ref_number": "AT-7319"}, {"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"}, {"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"}, {"db_format": "NVARCHAR(22)", "db_name": "ROAD TYPE", "definition": "TBC", "fixed_values": "", "id": "7322", "name": "Road Type", "ref_number": "AT-7322"}, {"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"}, {"db_format": "NUMERIC(38)", "db_name": "VICGRID Y", "definition": "VicGrid94 coordinates", "fixed_values": "", "id": "7324", "name": "Vicgrid Y", "ref_number": "AT-7324"}, {"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"}, {"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"}, {"db_format": "INTEGER(10)", "db_name": "ROAD ROUTE 1", "definition": "TBC", "fixed_values": "", "id": "7327", "name": "Road Route 1", "ref_number": "AT-7327"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"db_format": "DATE(10)", "db_name": "ACCIDENT DATE", "definition": "TBC", "fixed_values": "", "id": "7333", "name": "Accident Date", "ref_number": "AT-7333"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"db_format": "NVARCHAR(50)", "db_name": "ROAD NAME", "definition": "TBC", "fixed_values": "", "id": "7341", "name": "Road Name", "ref_number": "AT-7341"}, {"db_format": "DECIMAL(10)", "db_name": "LONGITUDE", "definition": "Geographical coordinates", "fixed_values": "", "id": "7342", "name": "Longitude", "ref_number": "AT-7342"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"db_format": "DECIMAL(10)", "db_name": "LATITUDE", "definition": "Geographical coordinates", "fixed_values": "", "id": "7348", "name": "Latitude", "ref_number": "AT-7348"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}, {"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"}] |
| Dataset last updated date | 2 weeks ago |
| Datastore active | False |
| Datastore contains all records of source file | False |
| Filesize | 296,853,831 |
| Has views | False |
| Historical | False |
| Id | 62961ec1-3623-42bc-9ccb-2139c2668f36 |
| Last updated date | 1 week ago |
| Mimetype | application/geo+json |
| Open dataset title | Victoria Road Crash Data |
| Package id | e03104fe-fd02-4045-aa05-e916c6d46433 |
| Period end | 2024-03-31 |
| Period start | 2012-01-01 |
| Position | 9 |
| Publication date | 13 years ago |
| State | active |
| Filesize | 283.1 MB |
| Release Date | |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 March 2024 |
| Data Quality Statement | |
| Attribution Statement |