Accident Location
Table contains information from the master location table - NB subset of accident table
There are no views created for this resource yet.
Data Dictionary
| Field Name | Name | Type | Description | Fixed Values |
|---|---|---|---|---|
| ACCIDENT_NO | Accident Number | 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" | |
| NODE_ID | Node ID | INTEGER(10) | The node id of the accident. It starts with 1 and incremented by one when a new accident location is identified. | |
| ROAD_ROUTE_1 | Road Route 1 | INTEGER(10) | ROAD_ROUTE_1 is character field indicates primary route for Road_Name_1. Null Values are valid entries. | 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 / ‟Local‟ roads |
| ROAD_NAME | Road Name | NVARCHAR(50) | ROAD_NAME is character field indicates highest priority road at intersection OR road on which accident took place. | |
| ROAD_TYPE | Road Type | NVARCHAR(22) | ROAD_TYPE is character field indicates type of Road_Name | |
| ROAD_NAME_INT | Road Name Int | NVARCHAR(50) | ROAD_NAME_INT is character field indicates other road at intersection OR nearest intersecting road (on_road) | |
| ROAD_TYPE_INT | Road Type Int | NVARCHAR(22) | ROAD_TYPE_INT is character field indicates type of Road_Name_Int at intersection OR nearest intersecting road (on_road) | |
| DISTANCE_LOCATION | Distance | INTEGER(10) | 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). | |
| DIRECTION_LOCATION | Direction | NVARCHAR(2) | 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. | 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 |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 18 March 2025 |
| Metadata last updated | 18 March 2025 |
| Created | 18 March 2025 |
| 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": "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"}] |
| Ckan url | https://discover.data.vic.gov.au |
| Dataset last updated date | 3 weeks ago |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Edc sync | True |
| Has views | False |
| Hash | 254beb376607029e7ac0f3b9579c5bdd |
| Historical | False |
| Id | e1beb92b-5836-448a-9769-e7aa6a9e7413 |
| Ignore hash | False |
| Last updated date | 3 weeks ago |
| Mimetype | text/csv |
| 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-07-31 |
| Period start | 2012-01-01 |
| Position | 8 |
| Publication date | 13 years ago |
| Resource id | e1beb92b-5836-448a-9769-e7aa6a9e7413 |
| Set url type | False |
| State | active |
| Task created | 2025-03-18 11:35:50.078342 |
| File Size | 10.7 MB |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 July 2024 |