Sub DCA
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.
Data Dictionary
| Field Name | Name | Type | Description | Fixed Values |
|---|---|---|---|---|
| ACCIDENT_NO | ACCIDENT NO | CHAR(12) | ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values. First character T indicates TIS incident and characters 2-5 typically represent the year in which the accident created in TIS system and characters 6-11 are a numeric sequencing number | |
| SUB_DCA_CODE | Sub DCA | CHAR(3) | SUB_DCA_CODE is character field indicates SUB_DCA code of the accident. This field cannot contain NULL 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 |
| SUB_DCA_SEQ | Sub DCA Sequence | INTEGER(10) | 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 | |
| SUB_DCA_CODE_DESC | SUB DCA CODE DESC | VARCHAR(100) | is a descriptive field that indicates SUB_DCA code of the accident. This field cannot contain NULL 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 |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 16 November 2024 |
| Metadata last updated | 20 November 2024 |
| Created | 16 November 2024 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 International |
| Attributes | [{"attribute_display_order_id": 1, "db_format": "CHAR(12)", "db_name": "ACCIDENT_NO", "definition": "ACCIDENT_NO is the Primary Key for the database to uniquely identify the accident and cannot contain NULL values.\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"}] |
| Ckan url | https://discover.data.vic.gov.au |
| Dataset last updated date | 2 weeks ago |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Filesize | 10,558,813 |
| Has views | True |
| Hash | b86cea83b819835acf82d8fdae211006 |
| Historical | False |
| Id | 186b7fe7-b23a-4c28-82a1-7aa8e29abf21 |
| Ignore hash | False |
| Last updated date | 1 week ago |
| Mimetype | text/csv |
| Open dataset title | SUB DCA |
| Original url | https://opendata.transport.vic.gov.au/dataset/bb77800e-1857-4edc-bf9e-e188437a1c8e/resource/186b7fe7-b23a-4c28-82a1-7aa8e29abf21/download/sub_dca.csv |
| Package id | e03104fe-fd02-4045-aa05-e916c6d46433 |
| Period end | 2024-03-31 |
| Period start | 2012-01-01 |
| Position | 4 |
| Publication date | 13 years ago |
| Resource id | 186b7fe7-b23a-4c28-82a1-7aa8e29abf21 |
| Set url type | False |
| State | active |
| Task created | 2024-11-20 01:44:33.492760 |
| Filesize | 10.1 MB |
| Release Date | |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 March 2024 |
| Data Quality Statement | |
| Attribution Statement |