Node
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.
There are no views created for this resource yet.
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. | |
| 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. | |
| NODE_TYPE | Node Type | NVARCHAR(1) | NODE_TYPE is a character field indicates location type identified by the RCIS spatial system. This field cannot contain NULL values. | Code Description I Intersection N Non-Intersection O Off Road U Unknown |
| AMG_X | AMG X Coordinate | NUMERIC(38) | 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. | |
| AMG_Y | AMG Y Coordinate | NUMERIC(38) | 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 | |
| LGA_NAME | LGA | NVARCHAR(100) | LGA_NAME is a character field contains the LGA name for the location of the crash. This field cannot contain NULL values | |
| DEG_URBAN_NAME | Degree Urban Name | NVARCHAR(40) | DEG_URBAN_NAME is a character field indicates degree of urban name for the location of the crash. This field refers DEG_URBAN_NAME in DEGREE_OF_URBAN table. This field cannot contain NULL values. | |
| LATITUDE | Latitude | DECIMAL(10) | latitude coordinate of the crash | |
| LONGITUDE | Longitude | DECIMAL(10) | Longitude coordinate of the crash | |
| POSTCODE_CRASH | Postcode Crash | INTEGER(10) | Postcode of the crash |
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": "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"}] |
| 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 | d09df07aa061f944090cfa8436c1c922 |
| Historical | False |
| Id | 466fd3b5-201b-42b5-b10d-e926324fa215 |
| Ignore hash | False |
| Last updated date | 3 weeks ago |
| Mimetype | text/csv |
| 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-07-31 |
| Period start | 2012-01-01 |
| Position | 6 |
| Publication date | 13 years ago |
| Resource id | 466fd3b5-201b-42b5-b10d-e926324fa215 |
| Set url type | False |
| State | active |
| Task created | 2025-03-18 11:35:49.812597 |
| File Size | 18.4 MB |
| Temporal Coverage Start | 1 January 2012 |
| Temporal Coverage End | 31 July 2024 |