| Attributes | [{"attribute_display_order_id": 1, "db_format": "STRING(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</p>", "fixed_values": "", "id": "7067", "name": "Accident Number", "ref_number": "AT-7067"}, {"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": "7084", "name": "Accident Date", "ref_number": "AT-7084"}, {"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": "7075", "name": "Accident Time", "ref_number": "AT-7075"}, {"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": "7070", "name": "Accident Type", "ref_number": "AT-7070"}, {"attribute_display_order_id": 5, "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": "7056", "name": "Day of Week", "ref_number": "AT-7056"}, {"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": "7047", "name": "DCA Code", "ref_number": "AT-7047"}, {"attribute_display_order_id": 7, "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": "7059", "name": "Light Condition", "ref_number": "AT-7059"}, {"attribute_display_order_id": 8, "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": "7039", "name": "Node ID", "ref_number": "AT-7039"}, {"attribute_display_order_id": 9, "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": "7086", "name": "Number of Vehicles involved", "ref_number": "AT-7086"}, {"attribute_display_order_id": 10, "db_format": "INTEGER(10)", "db_name": "NO_PERSONS_KILLED", "definition": "Number of people who have died in the crash", "fixed_values": "", "id": "7049", "name": "Number of Lives lost", "ref_number": "AT-7049"}, {"attribute_display_order_id": 11, "db_format": "INTEGER(10)", "db_name": "NO_PERSONS_INJ_2", "definition": "Number of people with a serious injury", "fixed_values": "", "id": "7077", "name": "Number of Person/s with Serious Injury", "ref_number": "AT-7077"}, {"attribute_display_order_id": 12, "db_format": "INTEGER(10)", "db_name": "NO_PERSONS_INJ_3", "definition": "Number of people with an other injury", "fixed_values": "", "id": "7037", "name": "Number of Person/s with other injury", "ref_number": "AT-7037"}, {"attribute_display_order_id": 13, "db_format": "INTEGER(10)", "db_name": "NO_PERSONS_NOT_INJ", "definition": "Number of people with no injuries", "fixed_values": "", "id": "7035", "name": "Number of Person/s not injury", "ref_number": "AT-7035"}, {"attribute_display_order_id": 14, "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": "7036", "name": "Number of Persons", "ref_number": "AT-7036"}, {"attribute_display_order_id": 15, "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": "7044", "name": "Police attendance", "ref_number": "AT-7044"}, {"attribute_display_order_id": 16, "db_format": "CHAR(1)", "db_name": "ROAD_GEOMETRY", "definition": "Code for layout of the road where the accident occurred", "fixed_values": "1-9", "id": "7045", "name": "Road Geometry", "ref_number": "AT-7045"}, {"attribute_display_order_id": 17, "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": "7042", "name": "Severity", "ref_number": "AT-7042"}, {"attribute_display_order_id": 18, "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": "7052", "name": "Speed Zone", "ref_number": "AT-7052"}, {"db_format": "DECIMAL(18)", "db_name": "LONGITUDE", "definition": "Longitude coordinate of the crash", "fixed_values": "", "id": "7046", "name": "Longitude", "ref_number": "AT-7046"}, {"db_format": "DECIMAL(18)", "db_name": "LATITUDE", "definition": "Latitude coordinate of the crash", "fixed_values": "", "id": "7062", "name": "Latitude", "ref_number": "AT-7062"}, {"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": "7468", "name": "Accident Type Description", "ref_number": "AT-7468"}, {"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": "7469", "name": "DCA Description", "ref_number": "AT-7469"}, {"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": "7470", "name": "Road Geometry Description", "ref_number": "AT-7470"}, {"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": "7471", "name": "Day of Week Description", "ref_number": "AT-7471"}] |
|---|