ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.
\\nFirst 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\": \"14411\", \"name\": \"Accident Number\", \"ref_number\": \"AT-14411\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"DATE(10)\", \"db_name\": \"ACCIDENT DATE\", \"definition\": \"ACCIDENT_DATE is a date field indicates the date that the accident occurred. The data is in yyyymmdd format in the database but appears in dd/mm/yyy format in the application. Field can contain null values.\", \"fixed_values\": \"\", \"id\": \"14412\", \"name\": \"Accident Date\", \"ref_number\": \"AT-14412\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"TIME(16)\", \"db_name\": \"ACCIDENT TIME\", \"definition\": \"hh.mm.ss. Original date stored in 24 hour format (i.e. 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\": \"14432\", \"name\": \"Accident Time\", \"ref_number\": \"AT-14432\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"CHAR(1)\", \"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 -9\", \"id\": \"14410\", \"name\": \"Accident Type\", \"ref_number\": \"AT-14410\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"ACCIDENT_TYPE_DESC\", \"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\": \"14429\", \"name\": \"Accident Type Description\", \"ref_number\": \"AT-14429\"}, {\"attribute_display_order_id\": 6, \"db_format\": \"INTEGER(10)\", \"db_name\": \"DAY OF WEEK\", \"definition\": \"The field indicates the day of the week upon which the accident occurred\", \"fixed_values\": \"1-7\", \"id\": \"14425\", \"name\": \"Day of Week\", \"ref_number\": \"AT-14425\"}, {\"attribute_display_order_id\": 7, \"db_format\": \"NVARCHAR(30)\", \"db_name\": \"DAY_WEEK_DESC\", \"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\": \"14431\", \"name\": \"Day of Week Description\", \"ref_number\": \"AT-14431\"}, {\"attribute_display_order_id\": 8, \"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\": \"14422\", \"name\": \"DCA Code\", \"ref_number\": \"AT-14422\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"DCA_DESC\", \"definition\": \"Description for the Accident Classification\", \"fixed_values\": \"100 Pedestrian near side hit by vehicle from the right 101 Pedestrian emerges from in front of parked or stationary vehicle 102 Pedestrian far side hit by vehicle from the left 103 Pedestrian playing, lying, working, standing on carriageway. 104 Pedestrian walking with traffic 105 Pedestrian walking against traffic. 106 Vehicle strikes pedestrian on footpath, median, traffic island 107 Pedestrian on footpath struck by vehicle entering/leaving driveway 108 Pedestrian struck walking to/from or boarding/alighting vehicle 109 Any manoeuvre involving Pedestrian not included in DCAs 100-108. 110 Cross traffic (intersections only) 111 Right far (intersections only) 112 Left far (intersections only) 113 Right near (intersections only) 114 Two right turning (intersections only) 115 Right/left far (intersections only) 116 Left near (intersections only) 117 Left/right far (intersections only) 118 Two left turning (intersections only) 119 Other adjacent (intersections only) 120 Head on (not overtaking) 121 Right through 122 Left through 123 Right/left (one vehicle turning right the other left) 124 Right/right (both vehicles from opposite directions turning right) 125 Left/left (both vehicles from opposite directions turning right) 129 Other opposing (manoeuvres not included in DCAS 120 125) 130 Rear end (vehicles in same lane) 131 Left rear 132 Right rear 133 Lane side swipe (vehicles in parallel lanes) 134 Lane change right (not overtaking) 135 Lane change left (not overtaking) 136 Right turn sideswipe 137 Left turn sideswipe 139 Other same direction (manoeuvres not included in DCAs 130-137) 140 U turn 141 U turn into fixed object/parked vehicle 142 Leaving parking 143 Entering parking 144 Parked vehicles only 145 Reversing in stream of traffic 146 Reversing into fixed object/parked vehicle 147 Vehicle strikes another vehicle while emerging from driveway 148 Vehicle off footpath strikes vehicle on carriageway 149 Other (manoeuvres not included in DCAs 140 148) 150 Head on (overtaking) 151 Out of control (overtaking) 152 Pulling out (overtaking) 153 Cutting in (overtaking) 154 Pulling out rear end 159 Other overtaking (manoeuvres not included in DCAs 150 154) 160 Vehicle collides with vehicle parked on left of road 161 Double parked 162 Accident or broken down 163 Vehicle strikes door of parked/stationary vehicle 164 Permanent obstruction on carriageway 165 Temporary roadworks 166 Struck object on carriageway 167 Struck animal 169 Other on path 170 Off carriageway to left 171 Left off carriageway into object/parked vehicle 172 Off carriageway to right 173 Right off carriageway into object/parked vehicle 174 Out of control on carriageway (on straight) 175 Off end of road/T intersection 179 Other accidents off straight not included in DCAs 170 175 180 Off carriageway on right bend 181 Off right bend into object/parked vehicle 182 Off carriageway on left bend 183 Off left bend into object/parked vehicle 184 Out of control on carriageway (on bend) 189 Other accidents on curve not included in DCAs 180 184 190 Fell in/from vehicle 191 Load or missile struck vehicle 192 Struck train 193 Struck railway crossing furniture 194 Parked car run away 198 Other accidents not classifiable elsewhere 199 Unknown no details on manoeuvres of road users in accident 775 RUN OFF ROAD + SOME HEAD ONS 777 SPEEDING DCA GROUP FOR POLICE 778 Pedestrian DCAs 779 Cross - Rears Cross traffic rear ends 780 Run Off Road DCAs 170 - 184 781 R Taylor (TAC)\", \"id\": \"14433\", \"name\": \"DCA Description\", \"ref_number\": \"AT-14433\"}, {\"attribute_display_order_id\": 10, \"db_format\": \"CHAR(1)\", \"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-9 - 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\": \"14426\", \"name\": \"Light Condition\", \"ref_number\": \"AT-14426\"}, {\"attribute_display_order_id\": 11, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NODE_ID\", \"definition\": \"The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.\", \"fixed_values\": \"\", \"id\": \"14418\", \"name\": \"Node ID\", \"ref_number\": \"AT-14418\"}, {\"attribute_display_order_id\": 12, \"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\": \"14428\", \"name\": \"Number of Vehicles involved\", \"ref_number\": \"AT-14428\"}, {\"attribute_display_order_id\": 13, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_PERSONS_KILLED\", \"definition\": \"Number of people who have died in the crash\", \"fixed_values\": \"\", \"id\": \"14423\", \"name\": \"Number of Lives lost\", \"ref_number\": \"AT-14423\"}, {\"attribute_display_order_id\": 14, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_PERSONS_INJ_2\", \"definition\": \"Number of people with a serious injury\", \"fixed_values\": \"\", \"id\": \"14427\", \"name\": \"Number of Person/s with Serious Injury\", \"ref_number\": \"AT-14427\"}, {\"attribute_display_order_id\": 15, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_PERSONS_INJ_3\", \"definition\": \"Number of people with an other injury\", \"fixed_values\": \"\", \"id\": \"14417\", \"name\": \"Number of Person/s with other injury\", \"ref_number\": \"AT-14417\"}, {\"attribute_display_order_id\": 16, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_PERSONS_NOT_INJ\", \"definition\": \"Number of people with no injuries\", \"fixed_values\": \"\", \"id\": \"14415\", \"name\": \"Number of Person/s not injury\", \"ref_number\": \"AT-14415\"}, {\"attribute_display_order_id\": 17, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_PERSONS\", \"definition\": \"Indicates the number of people involved in the accident. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"14416\", \"name\": \"Number of Persons\", \"ref_number\": \"AT-14416\"}, {\"attribute_display_order_id\": 18, \"db_format\": \"CHAR(1)\", \"db_name\": \"POLICE_ATTEND\", \"definition\": \"Indicates whether the police attended the scene of the accident or not. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 1 Yes 2 No 9 Not known\", \"id\": \"14420\", \"name\": \"Police attendance\", \"ref_number\": \"AT-14420\"}, {\"attribute_display_order_id\": 19, \"db_format\": \"CHAR(1)\", \"db_name\": \"ROAD GEOMETRY\", \"definition\": \"Code for layout of the road where the accident occurred\", \"fixed_values\": \"1-9\", \"id\": \"14421\", \"name\": \"Road Geometry\", \"ref_number\": \"AT-14421\"}, {\"attribute_display_order_id\": 20, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"ROAD_GEOMETRY_DESC\", \"definition\": \"Descriptions of the 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\": \"14430\", \"name\": \"Road Geometry Description\", \"ref_number\": \"AT-14430\"}, {\"attribute_display_order_id\": 21, \"db_format\": \"CHAR(1)\", \"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\": \"14419\", \"name\": \"Severity\", \"ref_number\": \"AT-14419\"}, {\"attribute_display_order_id\": 22, \"db_format\": \"CHAR(3)\", \"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\": \"14424\", \"name\": \"Speed Zone\", \"ref_number\": \"AT-14424\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-08-04T06:03:27.482191", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "Table of road crash accidents that includes information about how the crash occurred, date, time and severity of the incident.", "edc_sync": true, "filesize": 31656302, "format": "CSV", "hash": "e573337499c83063b522dc3a5789110d", "historical": false, "id": "20772c1a-8b19-424a-a733-eb84f725f611", "ignore_hash": false, "last_modified": "2025-08-04T06:03:27.409005", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.901698", "mimetype": "text/csv", "mimetype_inner": null, "name": "Accident", "open_dataset_title": "Accident", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/20772c1a-8b19-424a-a733-eb84f725f611/download/accident.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 0, "publication_date": "2012-01-01T00:00:00", "resource_id": "20772c1a-8b19-424a-a733-eb84f725f611", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.156496", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/20772c1a-8b19-424a-a733-eb84f725f611/download/accident.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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\": \"7384\", \"name\": \"Accident Number\", \"ref_number\": \"AT-7384\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_ID\", \"definition\": \"VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7382\", \"name\": \"Vehicle ID\", \"ref_number\": \"AT-7382\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"INTEGER(10)\", \"db_name\": \"VEHICLE_YEAR_MANUF\", \"definition\": \"VEHICLE_YEAR_MANUF is an integer field indicates the year in which the vehicle was built or manufactured. The data is stored in yyyy format.\", \"fixed_values\": \"\", \"id\": \"7387\", \"name\": \"Vehicle Year of Manufacture\", \"ref_number\": \"AT-7387\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_DCA_CODE\", \"definition\": \"VEHICLE_DCA_CODE is a character field indicates that links the vehicle with the movement depicted in the DCA table. For example, if the DCA code for the accident is 111 and the vehicle DCA code is 2, then an inspection of the DCA chart will show that the second vehicle involved in the accident was turning right.\", \"fixed_values\": \"Code Description 1 Vehicle 1 2 Vehicle 2 3 Not known which vehicle was number 1 8 Not involved in initial event\", \"id\": \"7379\", \"name\": \"Vehicle DCA Code\", \"ref_number\": \"AT-7379\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"CHAR(2)\", \"db_name\": \"INITIAL_DIRECTION\", \"definition\": \"INTIAL_DIRECTION is a character field indicates the initial or first direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction.\", \"fixed_values\": \"Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known\", \"id\": \"7366\", \"name\": \"Initial Direction\", \"ref_number\": \"AT-7366\"}, {\"attribute_display_order_id\": 6, \"db_format\": \"CHAR(1)\", \"db_name\": \"ROAD_SURFACE_TYPE\", \"definition\": \"Road surface type describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc)\", \"fixed_values\": \"Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known\", \"id\": \"7376\", \"name\": \"Road Surface Type\", \"ref_number\": \"AT-7376\"}, {\"attribute_display_order_id\": 7, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"ROAD_SURFACE_TYPE_DESC\", \"definition\": \"Road surface type its a descriptive field that describes the type of road surface the crash occurred on (e.g. paved, unpaved, gravel etc)\", \"fixed_values\": \"Code Description 1 Paved 2 Unpaved 3 Gravel 9 Not known\", \"id\": \"7364\", \"name\": \"Road Surface Type Description\", \"ref_number\": \"AT-7364\"}, {\"attribute_display_order_id\": 8, \"db_format\": \"CHAR(1)\", \"db_name\": \"REG_STATE\", \"definition\": \"REG_STATE is a character field indicates the state which is the vehicle is registered in. This field will also indicate if the registration is overseas. This field cannot contain NULL values.\", \"fixed_values\": \"A Australian Capital Territory B Commonwealth D Northern Territory N New South Wales O Overseas Q Queensland S South Australia T Tasmania V Victoria W Western Australia Z Not known _ (Blank value entered)/Not available\", \"id\": \"7394\", \"name\": \"Registration State\", \"ref_number\": \"AT-7394\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"CHAR(6)\", \"db_name\": \"VEHICLE_BODY_STYLE\", \"definition\": \"VEHICLE_BODY_STYLE is a character field indicates the body type of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description AFRAME A Frame AG IMP Agricultural Implement For Prim.Prod. AMB Ambulance Emergency Vehicle AMPHIB Amphibian Land And Water Craft AMUS Amusement ARM V Armoured Vehicle B BIN Bulk Bin B HOE Back Hoe B TR Boat Trailer B/TR Boat Trailer BD/PMR B Double Prime Mover (Feds Only) BOX Box Trailer BUGGY Buggy Beach Buggy, Golf Buggy BUS Bus Used For Passenger Carriage C CAR Car Carrier Used For Car Carriage C MIX Concrete Mixer CARAVN Caravan CARVN Mobile Caravan Self Propelled Caravan CHAIR Motor Chair Motorized Wheelchair COMPAC Compactor CONT C Container Carrier CONVRT Convertible Car with removable top COUPE Coupe Car With 2 Doors CRANE Mobile Crane CYCLE Motor Cycle DITCH Ditch Witch DOLLY Dolly DOZER Bulldozer DUMPER Dumper EDUCTR Eductor EXCVTR Excavator F LIFT Fork Lift F UNIT Fire Unit FLOAT Moomba Float FLUSH Flusher FRAME Frame G UNIT Garbage Unit GRADER Grader H FLT Horse Float H/FLT Horse Float HEARSE Hearse HOE B Hoe HOR FL Horse Float IND/CN Individual Construction INDCON Individual Construction JEEP Jeep JINKER Jinker L FRM Log Frame (Rigid) L LOAD Low Loader L MARK Line Marker LADDER Ladder Truck LOADER Loader M BILL Mobile Billboard M CCH Mourning Coach M STDO Mobile Studio M STND Mobile Grandstand MACH Machine MACHNE Machine MISC Miscellaneous MOPED Motor Cycle MOWER Mower MULTI Multi MULTIX Multix OF SHD Office Shed OF/SHD Office Shed OUTFIT Motor Cycle P CARR Personnell Carrier P MVR Prime Mover P VAN Panel Van PMAMUS Prime Mover Amusement R AMUS Rigid Amusement RDSTR Roadster Convertible with 2 seats RLINER Road Liner ROLLER Roller S AMB Semi Ambulance S AMRV Semi Armoured Vehicle S AMUS Semi Amusement Vehicle S BULK Semi Bulk Bin S CAR Semi Car Carrier S CONT Semi Container Carrier S CRVN Semi Mobile Caravan S DCMP Semi Decompression Chamber S FLSH Semi Flusher S FLT Semi Float S FRM Semi Frame S JINK Semi Timber Jinker S LOAD Semi Loader S MACH Semi Machine S SERV Semi Service S SPRD Semi Lime Spreader S SPRY Semi Sprayer S TANK Semi Tanker S TRL Semi Trailer S TTWR Semi Travel Tower S VAN Semi Trailer Van S WAG Station Wagon Car With Internal Boot SCOOP Shovel SCOOTR Scooter SED Sedan - Car with external boot SEDAN Sedan - Car with external boot SWV1 Quad Bike SWV2 4 Wheel Drive \\u2013 All Terrain Vehicle\", \"id\": \"7390\", \"name\": \"Vehicle Body Style\", \"ref_number\": \"AT-7390\"}, {\"attribute_display_order_id\": 10, \"db_format\": \"CHAR(6)\", \"db_name\": \"VEHICLE_MAKE\", \"definition\": \"VEHICLE_MAKE is a character field indicates the vehicle make or manufacturer. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description AEC A E C ALBION Albion ALFA R Alfa Romeo ALLARD Allard ALLIS Allis ANSAIR Ansair ASI A S I ASIA Asia ASTON Aston Martin ATHEY Athey ATKINS Atkinson AUDI Audi AUSTIN Austin AUSTRL Austral B KNOX Blaw Knox BED Bedford BED IS Bedford Isuzu BELARS Belarus BENFRD Benford BENT Bentley BERL Berliet BHB B H B BMW B M W BOMBDR Bombardier BSA B S A BUICK Buick CAD Cadillac CASE Case CATPLR Caterpillar CHAMB Chamberlain CHAMP Champion CHEV Chevrolet CHRYS Chrysler CITRN Citroen COLES Coles COMMER Commer CONQ Conquip CUMMIN Cummins D BRN David Brown DAEWOO Daewoo DAF D A F DAIHAT Diahatsu DAIM Daimler DATSUN Datsun DENING Denning DENNIS Dennis DETOM Detomaso DEUTZ Deutz DIA R Diamond Reo DIA T Diamond T DIAMON Diamond DIATTO Diatto DODGE Dodge DOMINO Domino DYNAPC Dynapac ENFLD Enfield ERF E R F ESSEX Essex EUNOS Eunos500 EUREKA Eureka F LINE Freightliner FENDT Fendt FERG Ferguson FERRAR Ferrari FIAT Fiat FMC F M C FORD Ford FORDSN Fordson FRANNA Franna FRGHTR Freighter-Lawton FRMLNR Farmliner FSM F S M FUJI Fuji FURUKA Furukawa GALANT Galant(Chrysler) GALION Galion GMC G M C GRAD Gradall H COCK Hancock H DAV Harley Davidson H MADE Homemade HAFL Haflinger HANOM Hanomag HILL Hillman HITACH Hitachi HOLDEN Holden HSQVRN Husqvarna HUST Hustler HYNDAI Hyundai HYSTER Hyster I RAND Ingerson Rand INTERN International ISEKI Iseki ISUZU Isuzu J DEER John Deere JAGUAR Jaguar JBJ J B J JCB J C B JEEP Jeep JENSEN Jensen KATO Kato KAWASA Kawasaki KENWTH Kenworth KIA Kia L ROV Land Rover LADA Lada LOTUS Lotus MAZDA Mazda MERC B Mercedes-Benz NISSAN Nissan OLDS Oldsmobile PEUGEOT Peugeot PONT Pontiac PORSCH Porsche R ROV Range Rover RAMBLR Rambler REN Renault ROLLS Rolls-Royce ROVER Rover SAAB Saab SUBARU Subaru SUZUKI Suzuki TOYOTA Toyota VOLKS Volkswagen VOLVO Volvo YAMAHA Yamaha\", \"id\": \"7396\", \"name\": \"Vehicle Make\", \"ref_number\": \"AT-7396\"}, {\"attribute_display_order_id\": 11, \"db_format\": \"CHAR(6)\", \"db_name\": \"VEHICLE_MODEL\", \"definition\": \"VEHICLE_MODEL is a character field indicates the model of the vehicle.\", \"fixed_values\": \"E.g. FALCON 0 Unknown 66 Sleeper 75 Tow\", \"id\": \"7370\", \"name\": \"Vehicle Model\", \"ref_number\": \"AT-7370\"}, {\"attribute_display_order_id\": 12, \"db_format\": \"INTEGER(10)\", \"db_name\": \"VEHICLE_POWER\", \"definition\": \"VEHICLE_POWER is an integer field indicating the power of the vehicle, in CCs or horsepower. For motor cycles, motor scooters and mopeds, the units will be CCs and for all other vehicles the units are rated horsepower. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.\", \"fixed_values\": \"Code Description 0 Unknown 1-1000 Horsepower 1-9999 CCs\", \"id\": \"7363\", \"name\": \"Vehicle Power\", \"ref_number\": \"AT-7363\"}, {\"attribute_display_order_id\": 13, \"db_format\": \"CHAR(2)\", \"db_name\": \"VEHICLE_TYPE\", \"definition\": \"VEHICLE_TYPE is a character field indicates the type or category of vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover \\u2013 Single Trailer 62 Prime Mover \\u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\\\"\\\" tonnes=\\\"\\\" gvm=\\\"\\\" 72=\\\"\\\" heavy=\\\"\\\" vehicle=\\\"\\\" (rigid)=\\\"\\\"> 4.5 Tonnes 99 Not known\", \"id\": \"7372\", \"name\": \"Vehicle Type\", \"ref_number\": \"AT-7372\"}, {\"attribute_display_order_id\": 14, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"VEHICLE_TYPE_DESC\", \"definition\": \"VEHICLE_TYPE_DESC is a descriptive field that indicates the type or category of vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 19 Parked Trailers 20 Quad Bike 27 Plant machinery and Agricultural equipment 60 Prime Mover Only 61 Prime Mover \\u2013 Single Trailer 62 Prime Mover \\u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\\\"\\\" tonnes=\\\"\\\" gvm=\\\"\\\" 72=\\\"\\\" heavy=\\\"\\\" vehicle=\\\"\\\" (rigid)=\\\"\\\"> 4.5 Tonnes 99 Not known\", \"id\": \"7385\", \"name\": \"Vehicle Type Description\", \"ref_number\": \"AT-7385\"}, {\"attribute_display_order_id\": 15, \"db_format\": \"INTEGER(10)\", \"db_name\": \"VEHICLE_WEIGHT\", \"definition\": \"VEHICLE_WEIGHT is an integer field indicating the weight or mass of the vehicle. The unit of measurement is kilograms. NULL values are valid entries.\", \"fixed_values\": \"Code Description 01 Car 02 Station wagon 03 Taxi 04 Utility 05 Panel van 06 Prime Mover (No of Trailers Unknown) 07 Rigid Truck (Weight Unknown) 08 Bus/coach 09 Mini bus (9 13) seats 10 Motor cycle 11 Moped 12 Motor scooter 13 Bicycle 14 Horse (ridden or drawn ) 15 Tram 16 Train 17 Other vehicle 18 Not Applicable 60 Prime Mover Only 61 Prime Mover \\u2013 Single Trailer 62 Prime Mover \\u2013 B-Double 63 Prime Mover B-Triple 71 Light Commercial Vehicle (Rigid) <= 4.5=\\\"\\\" tonnes=\\\"\\\" gvm=\\\"\\\" 72=\\\"\\\" heavy=\\\"\\\" vehicle=\\\"\\\" (rigid)=\\\"\\\"> 4.5 Tonnes 99 Not known\", \"id\": \"7375\", \"name\": \"Vehicle Weight\", \"ref_number\": \"AT-7375\"}, {\"attribute_display_order_id\": 16, \"db_format\": \"CHAR(1)\", \"db_name\": \"CONSTRUCTION_TYPE\", \"definition\": \"CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.\", \"fixed_values\": \"A Articulated P Interpretation is not known R Rigid _ (Blank value entered) Unknown\", \"id\": \"7374\", \"name\": \"Construction Type\", \"ref_number\": \"AT-7374\"}, {\"attribute_display_order_id\": 17, \"db_format\": \"CHAR(1)\", \"db_name\": \"FUEL_TYPE\", \"definition\": \"FUEL_TYPE is a character field indicates the type of fuel used by the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description D Diesel E Electric G Gas M Multi P Petrol R Rotary Z Unknown\", \"id\": \"7377\", \"name\": \"Fuel Type\", \"ref_number\": \"AT-7377\"}, {\"attribute_display_order_id\": 18, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_OF_WHEELS\", \"definition\": \"NO_OF_WHEELS is an integer field indicates the number of wheels that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7378\", \"name\": \"Number of Wheels\", \"ref_number\": \"AT-7378\"}, {\"attribute_display_order_id\": 19, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NO_OF_CYLINDERS\", \"definition\": \"NO_OF_CYLINDERS is an integer field indicates the number of engine cylinders that the vehicle has. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7362\", \"name\": \"Number of Cylinders\", \"ref_number\": \"AT-7362\"}, {\"attribute_display_order_id\": 20, \"db_format\": \"INTEGER(10)\", \"db_name\": \"SEATING_CAPACITY\", \"definition\": \"SEATING_CAPACITY is an integer field indicates the number of seats in the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7368\", \"name\": \"Seating Capacity\", \"ref_number\": \"AT-7368\"}, {\"attribute_display_order_id\": 21, \"db_format\": \"INTEGER(10)\", \"db_name\": \"TARE_WEIGHT\", \"definition\": \"TARE_WEIGHT is an integer field indicates the tare or unladen weight of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7395\", \"name\": \"Tare Weight\", \"ref_number\": \"AT-7395\"}, {\"attribute_display_order_id\": 22, \"db_format\": \"INTEGER(10)\", \"db_name\": \"TOTAL_NO_OCCUPANTS\", \"definition\": \"TOTAL_NO_OCCUPANTS is an integer field indicates the number of occupants or people in the vehicle at the time of the accident. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7386\", \"name\": \"Total Number of Occupants\", \"ref_number\": \"AT-7386\"}, {\"attribute_display_order_id\": 23, \"db_format\": \"INTEGER(10)\", \"db_name\": \"CARRY_CAPACITY\", \"definition\": \"CARRY_CAPACITY is an integer field indicates the carry or load capacity of the vehicle. The unit of measurement is kilograms. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. NULL values are valid entries.\", \"fixed_values\": \"\", \"id\": \"7361\", \"name\": \"Carry Capacity\", \"ref_number\": \"AT-7361\"}, {\"attribute_display_order_id\": 24, \"db_format\": \"INTEGER(10)\", \"db_name\": \"CUBIC_CAPACITY\", \"definition\": \"CONSTRUCTION_TYPE is a character field indicates the construction or formation of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7373\", \"name\": \"Cubic Capacity\", \"ref_number\": \"AT-7373\"}, {\"attribute_display_order_id\": 25, \"db_format\": \"CHAR(2)\", \"db_name\": \"FINAL_DIRECTION\", \"definition\": \"FINAL_DIRECTION is a character field indicates the final or last direction of travel of the vehicle. For a vehicle that is turning, the initial direction will be different to the final direction. For a non-turning vehicle, the initial direction will be the same as the final direction.\", \"fixed_values\": \"Code Description E East N North NE North east NW North west S South SE South east SW South west W West NK Not known\", \"id\": \"7383\", \"name\": \"Final Direction\", \"ref_number\": \"AT-7383\"}, {\"attribute_display_order_id\": 26, \"db_format\": \"CHAR(2)\", \"db_name\": \"DRIVER_INTENT\", \"definition\": \"DRIVER_INTENT is a character field indicates what the driver of the vehicle was attempting to undertake at the time of the accident. This information is meant to obtain via an interview of the vehicle's driver..\", \"fixed_values\": \"Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known\", \"id\": \"7371\", \"name\": \"Driver Intent\", \"ref_number\": \"AT-7371\"}, {\"attribute_display_order_id\": 27, \"db_format\": \"CHAR(2)\", \"db_name\": \"VEHICLE_MOVEMENT\", \"definition\": \"VEHICLE_MOVEMENT is a character field indicates the actual movement of the vehicle prior to the accident.\", \"fixed_values\": \"Code Description 01 Going straight ahead 02 Turning right 03 Turning left 04 Leaving a driveway 05 'U' turning 06 Changing lanes 07 Overtaking 08 Merging 09 Reversing 10 Parking or unparking 11 Parked legally 12 Parked illegally 13 Stationary accident 14 Stationary broken down 15 Other stationary 16 Avoiding animals 17 Slow/stopping 18 Out of control 19 Wrong way 99 Not known _ (Blank value entered)\", \"id\": \"7393\", \"name\": \"Vehicle Movement\", \"ref_number\": \"AT-7393\"}, {\"attribute_display_order_id\": 28, \"db_format\": \"CHAR(1)\", \"db_name\": \"TRAILER_TYPE\", \"definition\": \"TRAILER_TYPE is a character field indicates the type of trailer towed by the vehicle involved in the accident, as reported by the police.\", \"fixed_values\": \"Code Description A Caravan B Trailer (general) C Trailer (boat) D Horse float E Machinery F Farm/agricultural equipment G Not known what is being towed H Not applicable I Trailer (Exempt) J Semi Trailer K Pig Trailer L Dog Trailer\", \"id\": \"7367\", \"name\": \"Trailer Type\", \"ref_number\": \"AT-7367\"}, {\"attribute_display_order_id\": 29, \"db_format\": \"CHAR(3)\", \"db_name\": \"VEHICLE_COLOUR_1\", \"definition\": \"VEHICLE_COLOUR_1 is a character field indicates the primary or main colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name.\", \"fixed_values\": \"Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable\", \"id\": \"7381\", \"name\": \"Vehicle Colour 1\", \"ref_number\": \"AT-7381\"}, {\"attribute_display_order_id\": 30, \"db_format\": \"CHAR(3)\", \"db_name\": \"VEHICLE_COLOUR_2\", \"definition\": \"VEHICLE_COLOUR_2 is a character field indicates the secondary colour of the vehicle. The quality of the data is dependent on a successful match between the accident and vehicle (VRIS) databases. This match is based on the registration number with confirmation of the date of expiry and the owner's name. Valid entries for this field are same as VEHICLE_COLOUR_1.\", \"fixed_values\": \"Code Description BLK Black BLU Blue BRN Brown CRM Cream FWN Fawn GLD Gold GRN Green GRY Grey MRN Maroon MVE Mauve OGE Orange PNK Pink PUR Purple RED Red SIL Silver WHI White YLW Yellow ZZ Unknown or Not applicable\", \"id\": \"7365\", \"name\": \"Vehicle Colour 2\", \"ref_number\": \"AT-7365\"}, {\"attribute_display_order_id\": 31, \"db_format\": \"CHAR(1)\", \"db_name\": \"CAUGHT_FIRE\", \"definition\": \"CAUGHT_FIRE is a character field indicates whether or not the vehicle caught fire as a result of the accident.\", \"fixed_values\": \"Code Description 0 Not applicable 1 Yes 2 No 9 Not known\", \"id\": \"7388\", \"name\": \"Caught Fire\", \"ref_number\": \"AT-7388\"}, {\"attribute_display_order_id\": 32, \"db_format\": \"CHAR(1)\", \"db_name\": \"INITIAL_IMPACT\", \"definition\": \"INITIAL_IMPACT is a character field indicates the position on the vehicle where the initial impact occurred.\", \"fixed_values\": \"Code Description 0 Towed unit 1 Right front corner 2 Right side forwards 3 Right side rearwards 4 Right rear corner 5 Left front corner 6 Left side forwards 7 Left side rearwards 8 Left rear corner 9 Not known/not applicable F Front N None R Rear S Sidecar T Top/roof U Undercarriage _ (Blank value entered)\", \"id\": \"7391\", \"name\": \"Initial Impact\", \"ref_number\": \"AT-7391\"}, {\"attribute_display_order_id\": 33, \"db_format\": \"CHAR(1)\", \"db_name\": \"LAMPS\", \"definition\": \"LAMPS is a character field indicates whether the lamps or headlights for the vehicle (under the ambient lighting conditions) were alight (on).\", \"fixed_values\": \"Code Description 0 Not applicable 1 Yes 2 No 9 Not known\", \"id\": \"7195\", \"name\": \"LAMPS\", \"ref_number\": \"AT-7195\"}, {\"attribute_display_order_id\": 34, \"db_format\": \"CHAR(1)\", \"db_name\": \"LEVEL_OF_DAMAGE\", \"definition\": \"LEVEL_OF_DAMAGE is a character field indicates the damage level of the vehicle.\", \"fixed_values\": \"Code Description 1 Minor 2 Moderate (driveable vehicle) 3 Moderate (unit towed away) 4 Major (unit towed away) 5 Extensive (unrepairable) 6 Nil damage 9 Not known\", \"id\": \"7392\", \"name\": \"Level of Damage\", \"ref_number\": \"AT-7392\"}, {\"attribute_display_order_id\": 35, \"db_format\": \"CHAR(1)\", \"db_name\": \"TOWED_AWAY_FLAG\", \"definition\": \"TOWED_AWAY_FLAG is a character field indicates whether or not the vehicle was towed from the accident site.\", \"fixed_values\": \"1,2\", \"id\": \"7380\", \"name\": \"Towed Away Flag\", \"ref_number\": \"AT-7380\"}, {\"attribute_display_order_id\": 36, \"db_format\": \"CHAR(2)\", \"db_name\": \"TRAFFIC_CONTROL\", \"definition\": \"TRAFFIC_CONTROL is a character field indicates the traffic control facing that was facing the vehicle, prior to the accident.\", \"fixed_values\": \"\", \"id\": \"7369\", \"name\": \"Traffic Control\", \"ref_number\": \"AT-7369\"}, {\"attribute_display_order_id\": 37, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"TRAFFIC_CONTROL_DESC\", \"definition\": \"TRAFFIC_CONTROL_DESC is a descriptive field that indicates the traffic control facing that was facing the vehicle, prior to the accident.\", \"fixed_values\": \"\", \"id\": \"7389\", \"name\": \"Traffic Control Description\", \"ref_number\": \"AT-7389\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:37.864554", "dataset_last_updated_date": "2025-08-01T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "The VEHICLE table contains the details of the vehicles involved with an accident. There is a many-to-one relationship with the ACCIDENT table. i.e. there can be one or more vehicles involved with one accident only. The accident_no and vehicle_id fields are the primary keys.
", "edc_sync": true, "filesize": 42931576, "format": "CSV", "hash": "c443ca7bfd6a3ca47ded2d8468fc723e", "historical": false, "id": "6d0b21f7-583a-4991-a168-f15a70c13ec4", "ignore_hash": false, "last_modified": "2025-08-01T14:01:51.662701", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.901835", "mimetype": "text/csv", "mimetype_inner": null, "name": "Vehicle", "open_dataset_title": "Vehicle", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/6d0b21f7-583a-4991-a168-f15a70c13ec4/download/vehicle.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 1, "publication_date": "2012-01-01T00:00:00", "resource_id": "6d0b21f7-583a-4991-a168-f15a70c13ec4", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.301306", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/6d0b21f7-583a-4991-a168-f15a70c13ec4/download/vehicle.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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.\\nFirst 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\": \"7215\", \"name\": \"ACCIDENT_NO\", \"ref_number\": \"AT-7215\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"INTEGER(10)\", \"db_name\": \"EVENT_SEQ_NO\", \"definition\": \"EVENT_SEQ_NO is an integer field that starts with 1 and incremented for more than one event in the same accident. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7221\", \"name\": \"SEQUENCE\", \"ref_number\": \"AT-7221\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"CHAR(1)\", \"db_name\": \"EVENT_TYPE\", \"definition\": \"EVENT_TYPE is a character field indicates type of incident event. This field cannot contain NULL values.\", \"fixed_values\": \"0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision\", \"id\": \"7217\", \"name\": \"EVENT TYPE\", \"ref_number\": \"AT-7217\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"EVENT_TYPE_DESC\", \"definition\": \"Is a descriptive field that indicates type of incident event. This field cannot contain NULL values.\", \"fixed_values\": \"0 Not applicable 1 Rollover on/off carriageway 2 Fell from vehicle 3 Ran off carriageway 4 Mechanical failure 5 Struck by stone/projectile/load 6 Fell in vehicle 8 Other 9 Not known C Collision\", \"id\": \"7473\", \"name\": \"EVENT TYPE DESC\", \"ref_number\": \"AT-7473\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_1_ID\", \"definition\": \"VEHICLE_1_ID is character field indicates first vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7219\", \"name\": \"FIRST PARTICIPANT VEHICLE ID\", \"ref_number\": \"AT-7219\"}, {\"attribute_display_order_id\": 6, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_1_COLL_PT\", \"definition\": \"VEHICLE_1_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7216\", \"name\": \"POINT OF COLLISION 1\", \"ref_number\": \"AT-7216\"}, {\"attribute_display_order_id\": 7, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"VEHICLE 1 COLL PT DESC\", \"definition\": \"Its a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U Undercarriage\", \"id\": \"7475\", \"name\": \"VEHICLE 1 COLL PT DESC\", \"ref_number\": \"AT-7475\"}, {\"attribute_display_order_id\": 8, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_2_ID\", \"definition\": \"VEHICLE_2_ID is character field indicates second vehicle involved in the event. Vehicle ID has a letter value assigned to them. This field cannot contain NULL values\", \"fixed_values\": \"\", \"id\": \"7222\", \"name\": \"SECOND PARTICIPANT VEHICLE ID\", \"ref_number\": \"AT-7222\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_2_COLL_PT\", \"definition\": \"VEHICLE_2_COLL_PT is a character field indicates collision point on the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7213\", \"name\": \"POINT OF COLLISION 2\", \"ref_number\": \"AT-7213\"}, {\"attribute_display_order_id\": 10, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"VEHICLE 2 COLL PT DESC\", \"definition\": \"It's a descriptive field that indicates collision point on the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"0 Towed unit 1 Right front corner 2 Right side (forwards) 3 Right side (rearwards) 4 Right rear corner 5 Left front corner 6 Left side (forwards) 7 Left side (rearwards) 8 Left rear corner 9 Not known or Not Applicable F Front N None R Rear S Sidecar T Top/Roof U\", \"id\": \"7474\", \"name\": \"VEHICLE 2 COLL PT DESC\", \"ref_number\": \"AT-7474\"}, {\"attribute_display_order_id\": 11, \"db_format\": \"CHAR(2)\", \"db_name\": \"PERSON_ID\", \"definition\": \"Uniquely identifies each person involved in the accident. Persons who are drivers of a vehicle have a letter value assigned to them and persons who are not drivers have a numerical value assigned to them.\", \"fixed_values\": \"\", \"id\": \"7218\", \"name\": \"PERSON_ID\", \"ref_number\": \"AT-7218\"}, {\"attribute_display_order_id\": 12, \"db_format\": \"CHAR(2)\", \"db_name\": \"OBJECT_TYPE\", \"definition\": \"OBJECT_TYPE is a character field that identifies object involved in the specific accident event. This field cannot contain NULL values.\", \"fixed_values\": \"1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island\", \"id\": \"7214\", \"name\": \"OBJECT TYPE\", \"ref_number\": \"AT-7214\"}, {\"attribute_display_order_id\": 13, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"OBJECT_TYPE_DESC\", \"definition\": \"It's a descriptive field that identifies object involved in the specific accident event. This field cannot contain NULL values.\", \"fixed_values\": \"1 Pole (telephone/electricity) 2 Tree (shrub/scrub) 3 Fence/Wall (including gates) 17 Traffic island\", \"id\": \"7476\", \"name\": \"OBJECT TYPE DESC\", \"ref_number\": \"AT-7476\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:41.168417", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "The ACCIDENT_EVENT table contains information about sequence of accident events. There is a one-to-many relationship with the ACCIDENT table. The accident_no and event_seq_no fields are the primary keys.", "edc_sync": true, "filesize": 25510169, "format": "CSV", "hash": "8ae1296dffdeb6fcd85f1c418fdc455a", "historical": false, "id": "b83605e0-cb32-49a2-9c3d-3d17544f2a3d", "ignore_hash": false, "last_modified": "2025-07-31T14:01:58.606791", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.901919", "mimetype": "text/csv", "mimetype_inner": null, "name": "Accident Event", "open_dataset_title": "Accident Event", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/b83605e0-cb32-49a2-9c3d-3d17544f2a3d/download/accident_event.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 2, "publication_date": "2012-01-01T00:00:00", "resource_id": "b83605e0-cb32-49a2-9c3d-3d17544f2a3d", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.467895", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/b83605e0-cb32-49a2-9c3d-3d17544f2a3d/download/accident_event.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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.\\nFirst 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\": \"7273\", \"name\": \"Accident Number\", \"ref_number\": \"AT-7273\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"CHAR(1)\", \"db_name\": \"ATMOSPH_COND\", \"definition\": \"Weather and atmospheric conditions at the time of the crash\", \"fixed_values\": \"Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known\", \"id\": \"7271\", \"name\": \"Atmospheric Condition\", \"ref_number\": \"AT-7271\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"INTEGER(10)\", \"db_name\": \"ATMOSPH_COND_SEQ\", \"definition\": \"1 and incremented by 1 if more than one atmospheric condition is entered for the same incident\", \"fixed_values\": \"\", \"id\": \"7272\", \"name\": \"Atmospheric Condition Sequence\", \"ref_number\": \"AT-7272\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"ATMOSPH_COND_DESC\", \"definition\": \"ATMOSPH_COND_DESC is a Descriptive field. it can be 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 and Not known\", \"fixed_values\": \"Code Description 1 Clear 2 Raining 3 Snowing 4 Fog 5 Smoke 6 Dust 7 Strong winds 9 Not known\", \"id\": \"7479\", \"name\": \"Atmospheric Condition Description\", \"ref_number\": \"AT-7479\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:44.398612", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "Weather and atmospheric conditions at the time of the crash", "edc_sync": true, "filesize": 4611127, "format": "CSV", "hash": "ef2991db279bca85aa6319c793c5f225", "historical": false, "id": "bf8656b4-49a2-4d64-9b87-9ca48e31ef02", "ignore_hash": false, "last_modified": "2025-07-31T14:02:06.159483", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.901998", "mimetype": "text/csv", "mimetype_inner": null, "name": "Atmospheric Condition", "open_dataset_title": "Atmospheric Condition", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/bf8656b4-49a2-4d64-9b87-9ca48e31ef02/download/atmospheric_cond.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 3, "publication_date": "2012-01-01T00:00:00", "resource_id": "bf8656b4-49a2-4d64-9b87-9ca48e31ef02", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.621703", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/bf8656b4-49a2-4d64-9b87-9ca48e31ef02/download/atmospheric_cond.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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.\\nFirst 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\": \"7269\", \"name\": \"ACCIDENT NO\", \"ref_number\": \"AT-7269\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"CHAR(3)\", \"db_name\": \"SUB_DCA_CODE\", \"definition\": \"SUB_DCA_CODE is character field indicates SUB_DCA code of the accident. This field cannot contain NULL values.\", \"fixed_values\": \"A01 Vehicle entering intersection A02 Vehicle leaving intersection A03 Vehicle within intersection A04 Vehicle in left turn slip lane B01 Vehicle going straight through B02 Vehicle turning right B03 Vehicle turning left B04 Vehicle reversing C01 Pedestrian stepped off median strip C02 Pedestrian stepped off safety zone/tram shelter D01 Pedestrian emerged from behind car etc D02 Pedestrian emerged from behind truck D03 Pedestrian emerged from behind bus D04 Pedestrian emerged from behind tram D05 Pedestrian emerged from behind motorcycle D06 Pedestrian emerged from behind other vehicles D07 Pedestrian emerged from behind vehicle not known E01 Pedestrian playing E02 Pedestrian walking E03 Pedestrian lying E04 Pedestrian standing E05 Pedestrian working/pushing or working on vehicle E06 Pedestrian activity not known F01 No paved footpath F02 Paved footpath F03 Footpath unknown F04 Not on Footpath G01 Vehicle moving forward - under control G02 Vehicle moving forward - out of control G03 Vehicle moving back - under control G04 Vehicle moving back - out of control H01 Vehicle forward entering H02 Vehicle reverse entering H03 Vehicle forward departing H04 Vehicle reverse departing I01 Private driveway/laneway I02 Hotel/motel/hostel driveway or laneway I03 Factory(including loading bays) driveway/laneway I04 Commercial(includes shops/school/station) driveway I05 Not known I06 Laneway J01 Boarding J02 Alighting K01 Median K02 Other separator L01 Road straight at intersection L02 Road curved at intersection L03 Road straight at mid-block L04 Road curved at mid-block M01 Vehicle turning through median opening N01 Intersection N02 Mid-block NRQ Not Required O01 Parked vehicle causes vehicle to change lanes P01 Hit by veh from same dir as initial dir of U-turning veh P02 Hit by veh fr dir opposite to initial dir of U-turning veh Q01 Poles (telephone/electricity) Q02 Tree (shrub/scrub) Q03 Fences (including gates) Q04 Embankments Q05 Guide posts (including km/posts) Q06 Traffic signs (No parking No standing etc) Q07 Guard rail Q08 Fire hydrant Q09 Buildings Q10 Other objects (Telephone/Culvert/RX) Fixed/Not Fixed Q11 Object hit not known Q12 Traffic signals(i.e.Traffic lights) Q13 Bridge(When it is NOT on path) Q14 Barriers (Road Closure) Q17 Traffic island Q21 Bridge (When it is ON path - see 1) Q23 Roadworks (Dirt sign/barrier/excavation) Q24 Safety zone (i.e. Tram safety zone) Q30 Protruding kerb Q31 Animals - Domestic (Cats and Dogs) Q32 Animals - Cattle Q33 Animals - Sheep Q34 Animals - Horse (not ridden) Q35 Animals - Other tame animals Q36 Animals - Kangaroo or Wallaby Q37 Animals - Wombat Q38 Animals - Other wild animal or bird Q39 Unknown animals R01 Kerb parking - angle R02 Kerb parking - parallel R03 Centre of road parking - angle R04 Centre of road parking - parallel R05 Parking offroad/footpath S01 Collision on first half of carriageway S02 Collision on second half of carriageway S03 On footpath U01 Opposing direction vehicle present V01 No vehicle mounted/struck V02 Kerb(roadside) mounted/struck V03 Traffic island mounted/struck V04 Safety zone mounted/struck V05 Median mounted/struck V06 Separation mounted/struck V07 Roundabout mounted/struck W01 Leaves carriageway to left W02 Leaves carriageway to right X01 Fell in vehicle X02 Fell from vehicle Y01 Any vehicle (include trailer or parked car) Z01 On freeway (between interchanges) Z02 At entrance ramp/local road intersection Z03 On entrance ramp Z04 At entrance ramp/freeway Z05 At freeway/exit ramp (vehicle about to leave freeway) Z06 On exit ramp Z07 At exit ramp/local road intersection Z08 Freeway/freeway interchange Z09 At local rd I/S or M/B with RRP/RS spanning part of freeway\", \"id\": \"7270\", \"name\": \"Sub DCA\", \"ref_number\": \"AT-7270\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"INTEGER(10)\", \"db_name\": \"SUB_DCA_SEQ\", \"definition\": \"Starts with 1 and incremented by 1 if more than one Sub DCA is entered for the same incident Link to DCA Chart and Sub DCA Codes\", \"fixed_values\": \"\", \"id\": \"7268\", \"name\": \"Sub DCA Sequence\", \"ref_number\": \"AT-7268\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"SUB_DCA_CODE_DESC\", \"definition\": \"is a descriptive field that indicates SUB_DCA code of the accident. This field cannot contain NULL values.\", \"fixed_values\": \"A01 Vehicle entering intersection A02 Vehicle leaving intersection A03 Vehicle within intersection A04 Vehicle in left turn slip lane B01 Vehicle going straight through B02 Vehicle turning right B03 Vehicle turning left B04 Vehicle reversing C01 Pedestrian stepped off median strip C02 Pedestrian stepped off safety zone/tram shelter D01 Pedestrian emerged from behind car etc D02 Pedestrian emerged from behind truck D03 Pedestrian emerged from behind bus D04 Pedestrian emerged from behind tram D05 Pedestrian emerged from behind motorcycle D06 Pedestrian emerged from behind other vehicles D07 Pedestrian emerged from behind vehicle not known E01 Pedestrian playing E02 Pedestrian walking E03 Pedestrian lying E04 Pedestrian standing E05 Pedestrian working/pushing or working on vehicle E06 Pedestrian activity not known F01 No paved footpath F02 Paved footpath F03 Footpath unknown F04 Not on Footpath G01 Vehicle moving forward - under control G02 Vehicle moving forward - out of control G03 Vehicle moving back - under control G04 Vehicle moving back - out of control H01 Vehicle forward entering H02 Vehicle reverse entering H03 Vehicle forward departing H04 Vehicle reverse departing I01 Private driveway/laneway I02 Hotel/motel/hostel driveway or laneway I03 Factory(including loading bays) driveway/laneway I04 Commercial(includes shops/school/station) driveway I05 Not known I06 Laneway J01 Boarding J02 Alighting K01 Median K02 Other separator L01 Road straight at intersection L02 Road curved at intersection L03 Road straight at mid-block L04 Road curved at mid-block M01 Vehicle turning through median opening N01 Intersection N02 Mid-block NRQ Not Required O01 Parked vehicle causes vehicle to change lanes P01 Hit by veh from same dir as initial dir of U-turning veh P02 Hit by veh fr dir opposite to initial dir of U-turning veh Q01 Poles (telephone/electricity) Q02 Tree (shrub/scrub) Q03 Fences (including gates) Q04 Embankments Q05 Guide posts (including km/posts) Q06 Traffic signs (No parking No standing etc) Q07 Guard rail Q08 Fire hydrant Q09 Buildings Q10 Other objects (Telephone/Culvert/RX) Fixed/Not Fixed Q11 Object hit not known Q12 Traffic signals(i.e.Traffic lights) Q13 Bridge(When it is NOT on path) Q14 Barriers (Road Closure) Q17 Traffic island Q21 Bridge (When it is ON path - see 1) Q23 Roadworks (Dirt sign/barrier/excavation) Q24 Safety zone (i.e. Tram safety zone) Q30 Protruding kerb Q31 Animals - Domestic (Cats and Dogs) Q32 Animals - Cattle Q33 Animals - Sheep Q34 Animals - Horse (not ridden) Q35 Animals - Other tame animals Q36 Animals - Kangaroo or Wallaby Q37 Animals - Wombat Q38 Animals - Other wild animal or bird Q39 Unknown animals R01 Kerb parking - angle R02 Kerb parking - parallel R03 Centre of road parking - angle R04 Centre of road parking - parallel R05 Parking offroad/footpath S01 Collision on first half of carriageway S02 Collision on second half of carriageway S03 On footpath U01 Opposing direction vehicle present V01 No vehicle mounted/struck V02 Kerb(roadside) mounted/struck V03 Traffic island mounted/struck V04 Safety zone mounted/struck V05 Median mounted/struck V06 Separation mounted/struck V07 Roundabout mounted/struck W01 Leaves carriageway to left W02 Leaves carriageway to right X01 Fell in vehicle X02 Fell from vehicle Y01 Any vehicle (include trailer or parked car) Z01 On freeway (between interchanges) Z02 At entrance ramp/local road intersection Z03 On entrance ramp Z04 At entrance ramp/freeway Z05 At freeway/exit ramp (vehicle about to leave freeway) Z06 On exit ramp Z07 At exit ramp/local road intersection Z08 Freeway/freeway interchange Z09 At local rd I/S or M/B with RRP/RS spanning part of freeway\", \"id\": \"7478\", \"name\": \"SUB DCA CODE DESC\", \"ref_number\": \"AT-7478\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:46.987726", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "The SUB_DCA table contains additional information on Definitions for Classifying Accidents (DCA). ACCIDENT_NO and SUB_DCA_SEQ are the primary keys of the table.", "edc_sync": true, "filesize": 11158882, "format": "CSV", "hash": "96c565bf3d0eb5b9a36adacbb18b14f4", "historical": false, "id": "04e7d74b-cfec-4496-813c-c3d5aaa07153", "ignore_hash": false, "last_modified": "2025-07-31T14:02:11.712486", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902072", "mimetype": "text/csv", "mimetype_inner": null, "name": "SUB DCA", "open_dataset_title": "SUB DCA", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/04e7d74b-cfec-4496-813c-c3d5aaa07153/download/sub_dca.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 4, "publication_date": "2012-01-01T00:00:00", "resource_id": "04e7d74b-cfec-4496-813c-c3d5aaa07153", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.782433", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/04e7d74b-cfec-4496-813c-c3d5aaa07153/download/sub_dca.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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\": \"7290\", \"name\": \"Accident Number\", \"ref_number\": \"AT-7290\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"CHAR(2)\", \"db_name\": \"PERSON_ID\", \"definition\": \"Uniquely identifies each person involved in the accident. Persons who are drivers of a vehicle have a letter value assigned to them and persons who are not drivers have a numerical value assigned to them.\", \"fixed_values\": \"\", \"id\": \"7299\", \"name\": \"Person ID\", \"ref_number\": \"AT-7299\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"CHAR(1)\", \"db_name\": \"VEHICLE_ID\", \"definition\": \"VEHCILE_ID is a character field that uniquely identifies each vehicle involved in the accident. Vehicles have a letter value assigned to them\", \"fixed_values\": \"\", \"id\": \"7298\", \"name\": \"Vehicle ID\", \"ref_number\": \"AT-7298\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"CHAR(1)\", \"db_name\": \"SEX\", \"definition\": \"This indicates the driver's sex and is a user editable field.\", \"fixed_values\": \"Code Description M Male F Female U Not known\", \"id\": \"7245\", \"name\": \"Sex\", \"ref_number\": \"AT-7245\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"VARCHAR(7)\", \"db_name\": \"AGE_GROUP\", \"definition\": \"The age grouping of the person involved in the crash\", \"fixed_values\": \"\", \"id\": \"7287\", \"name\": \"Age Group\", \"ref_number\": \"AT-7287\"}, {\"attribute_display_order_id\": 6, \"db_format\": \"CHAR(1)\", \"db_name\": \"INJ_LEVEL\", \"definition\": \"This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident. It is calculated field using inj_police_level and taken_hospital. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured\", \"id\": \"7293\", \"name\": \"Injury Level\", \"ref_number\": \"AT-7293\"}, {\"attribute_display_order_id\": 7, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"INJ_LEVEL_DESC\", \"definition\": \"This is a character field indicates the level or degree of injury that the person has experienced as a result of the accident\", \"fixed_values\": \"Code Description 1 Fatality 2 Serious injury 3 Other injury 4 Not injured\", \"id\": \"7288\", \"name\": \"Injury Level Desc\", \"ref_number\": \"AT-7288\"}, {\"attribute_display_order_id\": 8, \"db_format\": \"CHAR(2)\", \"db_name\": \"SEATING_POSITION\", \"definition\": \"This is a character field indicates where the person was located on the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description CF Centre-front CR Centre-rear D Driver or rider LF Left-front LR Left-rear NA Not applicable NK Not known OR Other-rear PL Pillion passenger PS Motorcycle sidecar passenger RR Right-rear\", \"id\": \"7295\", \"name\": \"Seating Position\", \"ref_number\": \"AT-7295\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"CHAR(1)\", \"db_name\": \"HELMET_BELT_WORN\", \"definition\": \"This is a character field indicates whether or not the person was wearing a helmet or seatbelt at the time of the accident. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 1 Seatbelt worn 2 Seatbelt not worn 3 Child restraint worn 4 Child restraint not worn 5 Seatbelt/restraint not fitted 6 Crash helmet worn 7 Crash helmet not worn 8 Not appropriate 9 Not known\", \"id\": \"7265\", \"name\": \"Seat Belt/Helmet Worn\", \"ref_number\": \"AT-7265\"}, {\"attribute_display_order_id\": 10, \"db_format\": \"CHAR(2)\", \"db_name\": \"ROAD_USER_TYPE\", \"definition\": \"ROAD_USER_TYPE is a character field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known\", \"id\": \"7297\", \"name\": \"Road User Type\", \"ref_number\": \"AT-7297\"}, {\"attribute_display_order_id\": 11, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"ROAD_USER_TYPE_DESC\", \"definition\": \"ROAD_USER_TYPE is a descriptive field indicates what the role of the person was at the time of the accident. It is calculated field using person_status and vehicle_type from vehicle table.\", \"fixed_values\": \"Code Description 1 Pedestrian 2 Driver (of V-type 1-9 17 60-63 70-71) 3 Passenger (of V-type 1-9 17 60-63 70-71) 4 Motorcyclist 5 Pillion Passenger 6 Bicyclist (incl. passengers) 7 Other driver (V-type 14-16 99) 8 Other passenger (V-type 14-16 99) 9 Not known\", \"id\": \"7291\", \"name\": \"Road User Type Desc\", \"ref_number\": \"AT-7291\"}, {\"attribute_display_order_id\": 12, \"db_format\": \"CHAR(1)\", \"db_name\": \"LICENCE_STATE\", \"definition\": \"This is a character field indicates the state of issue of the person s driver license. This field cannot contain NULL values.\", \"fixed_values\": \"A Australian Capital Territory B Commonwealth D Northern Territory N New South Wales O Overseas Q Queensland S South Australia T Tasmania V Victoria W Western Australia Z Not known _ Not available (Blank value entered)\", \"id\": \"7289\", \"name\": \"Licence State\", \"ref_number\": \"AT-7289\"}, {\"attribute_display_order_id\": 13, \"db_format\": \"CHAR(1)\", \"db_name\": \"TAKEN_HOSPITAL\", \"definition\": \"This is a character field indicates whether or not the person was taken to hospital. This field cannot contain NULL values.\", \"fixed_values\": \"Y Yes N No _ Not Known\", \"id\": \"7294\", \"name\": \"Taken to hospital\", \"ref_number\": \"AT-7294\"}, {\"attribute_display_order_id\": 14, \"db_format\": \"CHAR(1)\", \"db_name\": \"EJECTED_CODE\", \"definition\": \"This is a character field indicates whether or not the person was ejected or thrown out of the vehicle. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description 0 Not applicable 1 Total ejected 2 Partially ejected 3 Partial ejection involving extraction _ Not known\", \"id\": \"7292\", \"name\": \"Ejected Code\", \"ref_number\": \"AT-7292\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:50.144422", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "The PERSON table contains the details of the people involved with an accident. There is a many-to-one relationship with the ACCIDENT table. I.e. there can be one or more people involved with one accident only. The accident_no and person_id fields are the primary keys.", "edc_sync": true, "filesize": 31656302, "format": "CSV", "hash": "d4a7dd56a083dbc33e08234fda8b5d48", "historical": false, "id": "60c8fc0c-2806-40f3-bb33-5c52691120e8", "ignore_hash": false, "last_modified": "2025-07-31T14:02:16.733064", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902146", "mimetype": "text/csv", "mimetype_inner": null, "name": "Person", "open_dataset_title": "Person", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/60c8fc0c-2806-40f3-bb33-5c52691120e8/download/person.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 5, "publication_date": "2012-01-01T00:00:00", "resource_id": "60c8fc0c-2806-40f3-bb33-5c52691120e8", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:20.920212", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/60c8fc0c-2806-40f3-bb33-5c52691120e8/download/person.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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.\\nFirst 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\": \"7278\", \"name\": \"Accident No\", \"ref_number\": \"AT-7278\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NODE_ID\", \"definition\": \"The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.\", \"fixed_values\": \"\", \"id\": \"7281\", \"name\": \"Node ID\", \"ref_number\": \"AT-7281\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"NVARCHAR(1)\", \"db_name\": \"NODE_TYPE\", \"definition\": \"NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values.\", \"fixed_values\": \"Code Description I Intersection N Non-Intersection O Off Road U Unknown\", \"id\": \"7276\", \"name\": \"Node Type\", \"ref_number\": \"AT-7276\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"NUMERIC(38)\", \"db_name\": \"AMG_X\", \"definition\": \"AMG_X is a decimal field that contains AMG coordinate X value. This field cannot contain NULL values. This will have zero value for location unknown accidents.\", \"fixed_values\": \"\", \"id\": \"7283\", \"name\": \"AMG X Coordinate\", \"ref_number\": \"AT-7283\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"NUMERIC(38)\", \"db_name\": \"AMG_Y\", \"definition\": \"AMG_Y is a decimal field that contains AMG coordinate Y value. This field cannot contain NULL values. This will have zero value for location unknown accidents\", \"fixed_values\": \"\", \"id\": \"7282\", \"name\": \"AMG Y Coordinate\", \"ref_number\": \"AT-7282\"}, {\"attribute_display_order_id\": 6, \"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. This field cannot contain NULL values\", \"fixed_values\": \"\", \"id\": \"7279\", \"name\": \"LGA\", \"ref_number\": \"AT-7279\"}, {\"attribute_display_order_id\": 8, \"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. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values.\", \"fixed_values\": \"\", \"id\": \"7274\", \"name\": \"Degree Urban Name\", \"ref_number\": \"AT-7274\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"DECIMAL(10)\", \"db_name\": \"LATITUDE\", \"definition\": \"latitude coordinate of the crash\", \"fixed_values\": \"\", \"id\": \"7280\", \"name\": \"Latitude\", \"ref_number\": \"AT-7280\"}, {\"attribute_display_order_id\": 10, \"db_format\": \"DECIMAL(10)\", \"db_name\": \"LONGITUDE\", \"definition\": \"Longitude coordinate of the crash\", \"fixed_values\": \"\", \"id\": \"7277\", \"name\": \"Longitude\", \"ref_number\": \"AT-7277\"}, {\"attribute_display_order_id\": 11, \"db_format\": \"INTEGER(10)\", \"db_name\": \"POSTCODE_CRASH\", \"definition\": \"Postcode of the crash\", \"fixed_values\": \"\", \"id\": \"7275\", \"name\": \"Postcode Crash\", \"ref_number\": \"AT-7275\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:53.848168", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "Table contains information about where accident is located on the map. NODE_ID is the primary key of the table. NODE_ID is referred by ACCIDENT and FATAL_ACCIDENT table. Same node_id can be assigned to more than one accident.", "edc_sync": true, "filesize": 21439898, "format": "CSV", "hash": "43d04f7a979a13feb15dc53e03a468ec", "historical": false, "id": "466fd3b5-201b-42b5-b10d-e926324fa215", "ignore_hash": false, "last_modified": "2025-07-31T14:02:24.435011", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902217", "mimetype": "text/csv", "mimetype_inner": null, "name": "Node", "open_dataset_title": "Node", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/466fd3b5-201b-42b5-b10d-e926324fa215/download/node.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 6, "publication_date": "2012-01-01T00:00:00", "resource_id": "466fd3b5-201b-42b5-b10d-e926324fa215", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:21.062123", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/466fd3b5-201b-42b5-b10d-e926324fa215/download/node.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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\": \"7286\", \"name\": \"Accident Number\", \"ref_number\": \"AT-7286\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"CHAR(1)\", \"db_name\": \"SURFACE_COND\", \"definition\": \"Road surface conditions on which the crash occurred e.g. dry, wet, muddy\", \"fixed_values\": \"Code Description 1 Dry 2 Wet 3 Muddy 4 Snowy 5 Icy 9 Unknown\", \"id\": \"7284\", \"name\": \"Surface Condition\", \"ref_number\": \"AT-7284\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"INTEGER(10)\", \"db_name\": \"SURFACE_COND_SEQ\", \"definition\": \"Starts with 1 and incremented by 1 if more than one road surface condition is entered for the same incident.\", \"fixed_values\": \"\", \"id\": \"7285\", \"name\": \"Surface Condition Sequence\", \"ref_number\": \"AT-7285\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"VARCHAR(100)\", \"db_name\": \"SURFACE_COND_DESC\", \"definition\": \"A descriptive field that indicates Road surface conditions on which the crash occurred e.g. dry, wet, muddy\", \"fixed_values\": \"Code Description 1 Dry 2 Wet 3 Muddy 4 Snowy 5 Icy 9 Unknown\", \"id\": \"7477\", \"name\": \"SURFACE COND DESC\", \"ref_number\": \"AT-7477\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:01:57.374547", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "Road surface conditions on which the crash occurred e.g. dry, wet, muddy", "edc_sync": true, "filesize": 4097984, "format": "CSV", "hash": "df218c35f5ebf022509b97282a581052", "historical": false, "id": "17965f05-2dda-4351-b32c-67038c74b6b3", "ignore_hash": false, "last_modified": "2025-07-30T23:24:49.317865", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902327", "mimetype": "text/csv", "mimetype_inner": null, "name": "Road Surface Condition", "open_dataset_title": "Road Surface Condition", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/17965f05-2dda-4351-b32c-67038c74b6b3/download/road_surface_cond.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 7, "publication_date": "2012-01-01T00:00:00", "resource_id": "17965f05-2dda-4351-b32c-67038c74b6b3", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:21.214179", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/17965f05-2dda-4351-b32c-67038c74b6b3/download/road_surface_cond.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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.\\nFirst 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\": \"7307\", \"name\": \"Accident Number\", \"ref_number\": \"AT-7307\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NODE_ID\", \"definition\": \"The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified.\", \"fixed_values\": \"\", \"id\": \"7300\", \"name\": \"Node ID\", \"ref_number\": \"AT-7300\"}, {\"attribute_display_order_id\": 3, \"db_format\": \"INTEGER(10)\", \"db_name\": \"ROAD_ROUTE_1\", \"definition\": \"ROAD_ROUTE_1 is character field indicates primary route for Road_Name_1. Null Values are valid entries.\", \"fixed_values\": \"Group Classifications are: 2000-2999 Freeways or Highways 3000-3999 Forest Rds 4000-4999 Tourist Rds 5000-5999 Main Rds 7000-7999 Ramps (mainly Freeway ramps) 9999 Unclassified Roads e.g. Council / \\u201fLocal\\u201f roads\", \"id\": \"7304\", \"name\": \"Road Route 1\", \"ref_number\": \"AT-7304\"}, {\"attribute_display_order_id\": 4, \"db_format\": \"NVARCHAR(50)\", \"db_name\": \"ROAD_NAME\", \"definition\": \"ROAD_NAME is character field indicates highest priority road at intersection OR road on which accident took place.\", \"fixed_values\": \"\", \"id\": \"7303\", \"name\": \"Road Name\", \"ref_number\": \"AT-7303\"}, {\"attribute_display_order_id\": 5, \"db_format\": \"NVARCHAR(22)\", \"db_name\": \"ROAD_TYPE\", \"definition\": \"ROAD_TYPE is character field indicates type of Road_Name\", \"fixed_values\": \"\", \"id\": \"7305\", \"name\": \"Road Type\", \"ref_number\": \"AT-7305\"}, {\"attribute_display_order_id\": 6, \"db_format\": \"NVARCHAR(50)\", \"db_name\": \"ROAD_NAME_INT\", \"definition\": \"ROAD_NAME_INT is character field indicates other road at intersection OR nearest intersecting road (on_road)\", \"fixed_values\": \"\", \"id\": \"7302\", \"name\": \"Road Name Int\", \"ref_number\": \"AT-7302\"}, {\"attribute_display_order_id\": 7, \"db_format\": \"NVARCHAR(22)\", \"db_name\": \"ROAD_TYPE_INT\", \"definition\": \"ROAD_TYPE_INT is character field indicates type of Road_Name_Int at intersection OR nearest intersecting road (on_road)\", \"fixed_values\": \"\", \"id\": \"7306\", \"name\": \"Road Type Int\", \"ref_number\": \"AT-7306\"}, {\"attribute_display_order_id\": 8, \"db_format\": \"INTEGER(10)\", \"db_name\": \"DISTANCE_LOCATION\", \"definition\": \"DISTANCE_LOCATION is an integer field indicating the distance (in metres) of the accident from the nearest intersecting road (if the crash is a non-intersection or mid-block accident).\", \"fixed_values\": \"\", \"id\": \"7308\", \"name\": \"Distance\", \"ref_number\": \"AT-7308\"}, {\"attribute_display_order_id\": 9, \"db_format\": \"NVARCHAR(2)\", \"db_name\": \"DIRECTION_LOCATION\", \"definition\": \"DIRECTION_LOCATION is a character field indicating the direction of the accident from the nearest intersecting road (if the crash is a non-intersection or mid-block accident). This field cannot contain NULL values.\", \"fixed_values\": \"Code Description N North NE North East E East SE South East S South SW South West W West NW North West UK Not known\", \"id\": \"7301\", \"name\": \"Direction\", \"ref_number\": \"AT-7301\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-03-17T13:02:00.457085", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "Table contains information from the master location table - NB subset of accident table", "edc_sync": true, "filesize": 11464025, "format": "CSV", "hash": "d0b70f8e04ccffaced8f6cb1c3510129", "historical": false, "id": "e1beb92b-5836-448a-9769-e7aa6a9e7413", "ignore_hash": false, "last_modified": "2025-07-31T14:02:34.813379", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902399", "mimetype": "text/csv", "mimetype_inner": null, "name": "Accident Location", "open_dataset_title": "Accident Location", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/e1beb92b-5836-448a-9769-e7aa6a9e7413/download/accident_location.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 8, "publication_date": "2012-01-01T00:00:00", "resource_id": "e1beb92b-5836-448a-9769-e7aa6a9e7413", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:21.365773", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/e1beb92b-5836-448a-9769-e7aa6a9e7413/download/accident_location.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "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\": \"14370\", \"name\": \"Accident No\", \"ref_number\": \"AT-14370\"}, {\"attribute_display_order_id\": 2, \"db_format\": \"DATE(10)\", \"db_name\": \"ACCIDENT_DATE\", \"definition\": \"TBC\", \"fixed_values\": \"\", \"id\": \"14373\", \"name\": \"Accident Date\", \"ref_number\": \"AT-14373\"}, {\"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\": \"14404\", \"name\": \"Accident Time\", \"ref_number\": \"AT-14404\"}, {\"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\": \"14406\", \"name\": \"Accident Type\", \"ref_number\": \"AT-14406\"}, {\"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\": \"14377\", \"name\": \"Day Of Week\", \"ref_number\": \"AT-14377\"}, {\"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\": \"14372\", \"name\": \"DCACode\", \"ref_number\": \"AT-14372\"}, {\"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\": \"14364\", \"name\": \"Dca Code Description\", \"ref_number\": \"AT-14364\"}, {\"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\": \"14360\", \"name\": \"Light Condition\", \"ref_number\": \"AT-14360\"}, {\"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\": \"14365\", \"name\": \"Police Attend\", \"ref_number\": \"AT-14365\"}, {\"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\": \"14398\", \"name\": \"Road Geometry\", \"ref_number\": \"AT-14398\"}, {\"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\": \"14393\", \"name\": \"Severity\", \"ref_number\": \"AT-14393\"}, {\"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\": \"14405\", \"name\": \"Speed Zone\", \"ref_number\": \"AT-14405\"}, {\"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\": \"14409\", \"name\": \"Run Off Road\", \"ref_number\": \"AT-14409\"}, {\"attribute_display_order_id\": 14, \"db_format\": \"NVARCHAR(50)\", \"db_name\": \"ROAD NAME\", \"definition\": \"Name of the road\", \"fixed_values\": \"\", \"id\": \"14380\", \"name\": \"Road Name\", \"ref_number\": \"AT-14380\"}, {\"attribute_display_order_id\": 15, \"db_format\": \"NVARCHAR(22)\", \"db_name\": \"ROAD TYPE\", \"definition\": \"Type of road\", \"fixed_values\": \"\", \"id\": \"14379\", \"name\": \"Road Type\", \"ref_number\": \"AT-14379\"}, {\"attribute_display_order_id\": 16, \"db_format\": \"INTEGER(10)\", \"db_name\": \"ROAD ROUTE 1\", \"definition\": \"TBC\", \"fixed_values\": \"\", \"id\": \"14376\", \"name\": \"Road Route 1\", \"ref_number\": \"AT-14376\"}, {\"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\": \"14388\", \"name\": \"LGA Name\", \"ref_number\": \"AT-14388\"}, {\"attribute_display_order_id\": 18, \"db_format\": \"NVARCHAR(35)\", \"db_name\": \"DTP REGION\", \"definition\": \"TBC\", \"fixed_values\": \"\", \"id\": \"14378\", \"name\": \"DTP Region\", \"ref_number\": \"AT-14378\"}, {\"attribute_display_order_id\": 19, \"db_format\": \"DECIMAL(10)\", \"db_name\": \"LATITUDE\", \"definition\": \"Geographical coordinates\", \"fixed_values\": \"\", \"id\": \"14375\", \"name\": \"Latitude\", \"ref_number\": \"AT-14375\"}, {\"attribute_display_order_id\": 20, \"db_format\": \"DECIMAL(10)\", \"db_name\": \"LONGITUDE\", \"definition\": \"Geographical coordinates\", \"fixed_values\": \"\", \"id\": \"14374\", \"name\": \"Longitude\", \"ref_number\": \"AT-14374\"}, {\"attribute_display_order_id\": 21, \"db_format\": \"NUMERIC(38)\", \"db_name\": \"VICGRID X\", \"definition\": \"VicGrid94 coordinates\", \"fixed_values\": \"\", \"id\": \"14381\", \"name\": \"Vicgrid X\", \"ref_number\": \"AT-14381\"}, {\"attribute_display_order_id\": 22, \"db_format\": \"NUMERIC(38)\", \"db_name\": \"VICGRID Y\", \"definition\": \"VicGrid94 coordinates\", \"fixed_values\": \"\", \"id\": \"14389\", \"name\": \"Vicgrid Y\", \"ref_number\": \"AT-14389\"}, {\"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\": \"14369\", \"name\": \"Total Persons\", \"ref_number\": \"AT-14369\"}, {\"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\": \"14391\", \"name\": \"Inj Or Fatal\", \"ref_number\": \"AT-14391\"}, {\"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\": \"14368\", \"name\": \"Fatality\", \"ref_number\": \"AT-14368\"}, {\"attribute_display_order_id\": 26, \"db_format\": \"INTEGER(10)\", \"db_name\": \"SERIOUSINJURY\", \"definition\": \"Number of people with a serious injury\", \"fixed_values\": \"\", \"id\": \"14361\", \"name\": \"Serious Injury\", \"ref_number\": \"AT-14361\"}, {\"attribute_display_order_id\": 27, \"db_format\": \"INTEGER(10)\", \"db_name\": \"OTHERINJURY\", \"definition\": \"Number of people with an other injury\", \"fixed_values\": \"\", \"id\": \"14384\", \"name\": \"Other Injury\", \"ref_number\": \"AT-14384\"}, {\"attribute_display_order_id\": 28, \"db_format\": \"INTEGER(10)\", \"db_name\": \"NONINJURED\", \"definition\": \"Number of people with no injuries\", \"fixed_values\": \"\", \"id\": \"14363\", \"name\": \"Non Injured\", \"ref_number\": \"AT-14363\"}, {\"attribute_display_order_id\": 29, \"db_format\": \"INTEGER(10)\", \"db_name\": \"MALES\", \"definition\": \"Number of males involved in the crash\", \"fixed_values\": \"\", \"id\": \"14362\", \"name\": \"Males\", \"ref_number\": \"AT-14362\"}, {\"attribute_display_order_id\": 30, \"db_format\": \"INTEGER(10)\", \"db_name\": \"FEMALES\", \"definition\": \"Number of females involved in the crash\", \"fixed_values\": \"\", \"id\": \"14396\", \"name\": \"Females\", \"ref_number\": \"AT-14396\"}, {\"attribute_display_order_id\": 31, \"db_format\": \"INTEGER(10)\", \"db_name\": \"BICYCLIST\", \"definition\": \"Number of bicyclists involved in the crash\", \"fixed_values\": \"\", \"id\": \"14399\", \"name\": \"Bicyclist\", \"ref_number\": \"AT-14399\"}, {\"attribute_display_order_id\": 32, \"db_format\": \"INTEGER(10)\", \"db_name\": \"PASSENGER\", \"definition\": \"Number of passengers involved in the crash\", \"fixed_values\": \"\", \"id\": \"14390\", \"name\": \"Passenger\", \"ref_number\": \"AT-14390\"}, {\"attribute_display_order_id\": 33, \"db_format\": \"INTEGER(10)\", \"db_name\": \"DRIVER\", \"definition\": \"Number of drivers involved in the crash\", \"fixed_values\": \"\", \"id\": \"14392\", \"name\": \"Driver\", \"ref_number\": \"AT-14392\"}, {\"attribute_display_order_id\": 34, \"db_format\": \"INTEGER(10)\", \"db_name\": \"PEDESTRIAN\", \"definition\": \"Number of pedestrians involved in the crash\", \"fixed_values\": \"\", \"id\": \"14394\", \"name\": \"Pedestrian\", \"ref_number\": \"AT-14394\"}, {\"attribute_display_order_id\": 35, \"db_format\": \"INTEGER(10)\", \"db_name\": \"PILLION\", \"definition\": \"Number of pillion passengers involved in the crash\", \"fixed_values\": \"\", \"id\": \"14395\", \"name\": \"Pillion\", \"ref_number\": \"AT-14395\"}, {\"attribute_display_order_id\": 36, \"db_format\": \"INTEGER(10)\", \"db_name\": \"MOTORCYCLIST\", \"definition\": \"Number of motorcyclists involved in the crash\", \"fixed_values\": \"\", \"id\": \"14403\", \"name\": \"Motorcyclist\", \"ref_number\": \"AT-14403\"}, {\"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\": \"14402\", \"name\": \"Unknown\", \"ref_number\": \"AT-14402\"}, {\"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\": \"14382\", \"name\": \"Ped Cyclist 5-12\", \"ref_number\": \"AT-14382\"}, {\"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\": \"14387\", \"name\": \"Ped Cyclist 13-18\", \"ref_number\": \"AT-14387\"}, {\"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\": \"14397\", \"name\": \"Old Ped 65 And Over\", \"ref_number\": \"AT-14397\"}, {\"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\": \"14358\", \"name\": \"Old Driver 75 And Over\", \"ref_number\": \"AT-14358\"}, {\"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\": \"14367\", \"name\": \"Young Driver 18-25\", \"ref_number\": \"AT-14367\"}, {\"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\": \"14385\", \"name\": \"No Of Vehicles\", \"ref_number\": \"AT-14385\"}, {\"attribute_display_order_id\": 44, \"db_format\": \"INTEGER(10)\", \"db_name\": \"HEAVYVEHICLE\", \"definition\": \"Number of heavy vehicles involved in the crash\", \"fixed_values\": \"\", \"id\": \"14359\", \"name\": \"Heavy vehicle\", \"ref_number\": \"AT-14359\"}, {\"attribute_display_order_id\": 45, \"db_format\": \"INTEGER(10)\", \"db_name\": \"PASSENGERVEHICLE\", \"definition\": \"Number of passenger vehicles involved in the crash\", \"fixed_values\": \"\", \"id\": \"14401\", \"name\": \"Passenger Vehicle\", \"ref_number\": \"AT-14401\"}, {\"attribute_display_order_id\": 46, \"db_format\": \"INTEGER(10)\", \"db_name\": \"MOTORCYCLE\", \"definition\": \"Number of motorcycles involved in the crash\", \"fixed_values\": \"\", \"id\": \"14366\", \"name\": \"Motorcycle\", \"ref_number\": \"AT-14366\"}, {\"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\": \"14383\", \"name\": \"Pt Vehicle\", \"ref_number\": \"AT-14383\"}, {\"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\": \"14400\", \"name\": \"Degree Urban Name\", \"ref_number\": \"AT-14400\"}, {\"attribute_display_order_id\": 49, \"db_format\": \"VARCHAR(1)\", \"db_name\": \"SRNS\", \"definition\": \"State road numbering system code\", \"fixed_values\": \"\", \"id\": \"14386\", \"name\": \"SRNS\", \"ref_number\": \"AT-14386\"}, {\"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\": \"14408\", \"name\": \"RMA\", \"ref_number\": \"AT-14408\"}, {\"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\": \"14407\", \"name\": \"Divided\", \"ref_number\": \"AT-14407\"}, {\"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\": \"14371\", \"name\": \"Stat Div Name\", \"ref_number\": \"AT-14371\"}]", "cache_last_updated": null, "cache_url": null, "ckan_url": "https://discover.data.vic.gov.au", "created": "2025-08-04T06:03:21.982202", "dataset_last_updated_date": "2025-07-31T00:00:00", "datastore_active": true, "datastore_contains_all_records_of_source_file": true, "description": "The csv 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.", "edc_sync": true, "filesize": 66645357, "format": "CSV", "hash": "dff9d58df0abcc023057544e46ab75ce", "historical": false, "id": "5df1f373-0c90-48f5-80e1-7b2a35507134", "ignore_hash": false, "last_modified": "2025-08-04T06:03:21.917252", "last_updated_date": "2025-08-08T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902469", "mimetype": "text/csv", "mimetype_inner": null, "name": "Victorian Road Crash Data", "open_dataset_title": "Victoria Road Crash Data", "original_url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/5df1f373-0c90-48f5-80e1-7b2a35507134/download/victorian_road_crash_data.csv", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "period_end": "2024-11-30", "period_start": "2012-01-01", "position": 9, "publication_date": "2012-01-01T00:00:00", "resource_id": "5df1f373-0c90-48f5-80e1-7b2a35507134", "resource_type": null, "set_url_type": false, "size": null, "source": "", "state": "active", "task_created": "2025-08-08 20:05:21.507892", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/5df1f373-0c90-48f5-80e1-7b2a35507134/download/victorian_road_crash_data.csv", "url_type": null, "zip_extract": false}, {"api_url": "", "cache_last_updated": null, "cache_url": null, "created": "2024-12-04T05:06:00.758569", "dataset_last_updated_date": "2024-12-10T00:00:00", "datastore_active": false, "datastore_contains_all_records_of_source_file": false, "description": "Table of Definition for Classifying Accidents", "edc_sync": false, "filesize": 198919, "format": "PDF", "hash": "", "historical": false, "id": "b658d974-4ff1-4de2-9c12-e47bb0fdbbac", "last_modified": "2024-12-04T05:06:00.674185", "last_updated_date": "2024-12-10T00:00:00", "metadata_modified": "2025-08-09T08:45:57.902540", "mimetype": "application/pdf", "mimetype_inner": null, "name": "DCA Chart and Sub DCA Codes", "open_dataset_title": "DCA Chart and Sub DCA Codes", "package_id": "4de2a60e-d87e-41cb-8bb5-bca17b7f679f", "position": 10, "publication_date": "2012-01-01T00:00:00", "resource_type": null, "size": null, "source": "", "state": "active", "url": "https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/b658d974-4ff1-4de2-9c12-e47bb0fdbbac/download/dca_chart_and_sub_dca_codes.pdf", "url_type": null, "zip_extract": false}], "tags": [{"display_name": "accident", "id": "9172dd17-7832-4cf8-b1ca-448945542006", "name": "accident", "state": "active", "vocabulary_id": null}, {"display_name": "age", "id": "1dae4b43-9d28-4e4a-ad3a-3ed3db162e16", "name": "age", "state": "active", "vocabulary_id": null}, {"display_name": "crash", "id": "ba8b040b-01e9-4b1e-b492-4e7187832cbf", "name": "crash", "state": "active", "vocabulary_id": null}, {"display_name": "dca", "id": "1f61206f-0b7c-4946-b2ec-335446256f00", "name": "dca", "state": "active", "vocabulary_id": null}, {"display_name": "injury", "id": "e790df19-a82f-47b2-bd63-6ecbece8e8aa", "name": "injury", "state": "active", "vocabulary_id": null}, {"display_name": "killed", "id": "f95843c7-a92b-412a-8c00-edc69dded26f", "name": "killed", "state": "active", "vocabulary_id": null}, {"display_name": "location", "id": "0598e3c0-b1e0-4054-b9f2-cfef70e4332f", "name": "location", "state": "active", "vocabulary_id": null}, {"display_name": "person", "id": "08e9ebcc-8384-4513-ba94-836743a10aba", "name": "person", "state": "active", "vocabulary_id": null}, {"display_name": "road crash", "id": "35aa8d6d-c2ee-42e3-b1e8-21f4364030e5", "name": "road crash", "state": "active", "vocabulary_id": null}, {"display_name": "road surface", "id": "af897b90-d6cb-4810-85d6-489cc956f2a9", "name": "road surface", "state": "active", "vocabulary_id": null}, {"display_name": "serious injury", "id": "9170c2b1-c6a1-46b7-b97d-41f2a606a2dc", "name": "serious injury", "state": "active", "vocabulary_id": null}, {"display_name": "spatial", "id": "ad7830ef-1647-4fb9-b05d-becc9ecf0288", "name": "spatial", "state": "active", "vocabulary_id": null}, {"display_name": "vehicle", "id": "708a0a2d-b591-4326-85f7-f3d9cb3efecc", "name": "vehicle", "state": "active", "vocabulary_id": null}, {"display_name": "vehicle crash", "id": "12c09b12-34ac-4afb-9349-255ef09cf228", "name": "vehicle crash", "state": "active", "vocabulary_id": null}, {"display_name": "vehicle type", "id": "e8f916d9-7d3b-45b4-b827-67b05b4eea00", "name": "vehicle type", "state": "active", "vocabulary_id": null}, {"display_name": "weather", "id": "73338637-447a-46ac-9c0b-1dd82a484c16", "name": "weather", "state": "active", "vocabulary_id": null}], "groups": [], "relationships_as_subject": [], "relationships_as_object": []}}