Road Bridges - Road Bridge General Identification and Location

A standardised set of descriptive, administrative, and classification data that provides a comprehensive overview of a bridge asset. It includes identifiers, location, ownership, structural type, and other key attributes.

Data Dictionary

Field Name	Name	Type	Description	Fixed Values
NAME	Name	NVARCHAR(250)	Unique ID, a combination of Structure ID and Historic separated by "_"	-
BRIDGE TYPE	Bridge Type	TEXT(1)	Bridge types code and description.	SA-ROAD OVER ROAD(GRADE SEPARATION), SB-ROAD OVER RAIL(RAIL UNDERPASS), SC-RAIL OVER ROAD(RAIL OVERPASS), SD-ROAD OVER PERENNIAL WATERCOURSE, SE-ROAD OVER SEASONAL WATERCOURSE , SF-ROAD OVER FLOODPLAIN, SG-SLAB ON PILES, SH-WEIGH BRIDGE, SI-ROAD OVER IRRIGATION CHANNEL, SL-TUNNEL, SM-SIGN STRUCTURE, SN-WILD LIFE CROSSING, SO-PEDESTRIAN OVERPASS , SP-PEDESTRIAN UNDERPASS, SQ-NOISE WALL, SR-MURRAY RIVER BRIDGES & PUNTS, SS-STOCK UNDERPASS, ST-STOCK OVERPASS, SU-UTILITY UNDERPASS, SV-UTILITY OVERPASS, SW-DISUSED BRIDGES SX-RETAINING WALL, SY-PEDESTRIAN BRIDGE, SZ-OTHER
FEATURE_CROSSED	Feature Crossed	NVARCHAR(100)	Describes what the structure crosses	-
STRUCTURE_FORM	Structure Form	TEXT(1)	Structure forms code and description, corresponds to Structure Type in RSIM, except "SN" = "Bridge" and "SC" = "Major Culverts. User select as drop down list	SA-ARCHITECTURAL FEATURE, SB-BRIDGES, SC-MAJOR CULVERTS, SE-EMERGENCY BRIDGING SYSTEM, SG-EMERGENCY GATES SL-LIGHT MASTS SP-CONCRETE PAVEMENT ON PILES SR-RETAINING WALLS SS-MAJOR SIGN STRUCTURES ST-TUNNEL SW-WEIGH BRIDGE SZ-NOISE BARRIERS
STRUCTURE_TYPE	Structure Type	TEXT(1)	Structure's Type sub level description.	Please refer to Appendix B for the complete list
TRAFFIC_WIDTH	Traffic Width	DECIMAL(7)	Structure's traffic width	-
YEAR_CONSTRUCTED	Year Constructed	DATETIME(1)	The year the structure is constructed if it's known	-
CD_DIRECTION	Direction	TEXT(1)	The road direction, where “F” = Forward and “R” = Reverse	F-Forward, R-Reverse
LAT	Latitude	DECIMAL(15)	Latitude Coordinate	-
LONGIT	Longitude	DECIMAL(15)	Longitude Coordinate	-
REGION_PHYS	Physical Region	TEXT(1)	The Departments regional operational boundary	1-WESTERN, 2-NORTH EASTERN, 3-NORTHERN, 4-METRO SOUTH EASTERN, 5-SOUTH WESTERN, 6-METRO NORTH WESTERN, 10-GREATER METRO, 11-INNER METRO, 43-GIPPSLAND, 44-HUME, 45-LODDON MALLEE, 46-GRAMPIANS, 47-BARWON SOUTH WEST
LOCAL_ROAD_NAME	Local Road Name	NVARCHAR(100)	Local road name	-
STRUCTURE_STATUS	Structure Status	TEXT(1)	Status of a structure	DU-Disused, LE-Leased, OT-Other, PR-Proposed, SO-Structure Open, UC-Under Construction
HEIGHT_OF_CELL	Height of Cell	DECIMAL(6)	Height of the Cell	-
CD_STATE_CLASS	State Classification	TEXT(2)	State Road Classification (i.e. Main Road, Highway, Freeway, Tourist Road)	FR (Forest), HF (Highway / Freeway), MR (Main), RA (Ramps), TR (Tourist)
NM_ROAD_PART	Road Name	NVARCHAR(250)	DTP declared Road Name	-
NM_ROAD_TYPE	Road Type	NVARCHAR(100)	Road category based on their lane configurations, such as highways, freeways, boulevard, road, ramp etc.	-

Field Name

Name

Type

Description

Fixed Values

NAME

Name

NVARCHAR(250)

Unique ID, a combination of Structure ID and Historic separated by "_"

BRIDGE TYPE

Bridge Type

TEXT(1)

Bridge types code and description.

SA-ROAD OVER ROAD(GRADE SEPARATION), SB-ROAD OVER RAIL(RAIL UNDERPASS), SC-RAIL OVER ROAD(RAIL OVERPASS), SD-ROAD OVER PERENNIAL WATERCOURSE, SE-ROAD OVER SEASONAL WATERCOURSE , SF-ROAD OVER FLOODPLAIN, SG-SLAB ON PILES, SH-WEIGH BRIDGE, SI-ROAD OVER IRRIGATION CHANNEL, SL-TUNNEL, SM-SIGN STRUCTURE, SN-WILD LIFE CROSSING, SO-PEDESTRIAN OVERPASS , SP-PEDESTRIAN UNDERPASS, SQ-NOISE WALL, SR-MURRAY RIVER BRIDGES & PUNTS, SS-STOCK UNDERPASS, ST-STOCK OVERPASS, SU-UTILITY UNDERPASS, SV-UTILITY OVERPASS, SW-DISUSED BRIDGES SX-RETAINING WALL, SY-PEDESTRIAN BRIDGE, SZ-OTHER

FEATURE_CROSSED

Feature Crossed

NVARCHAR(100)

Describes what the structure crosses

STRUCTURE_FORM

Structure Form

TEXT(1)

Structure forms code and description, corresponds to Structure Type in RSIM, except "SN" = "Bridge" and "SC" = "Major Culverts. User select as drop down list

SA-ARCHITECTURAL FEATURE, SB-BRIDGES, SC-MAJOR CULVERTS, SE-EMERGENCY BRIDGING SYSTEM, SG-EMERGENCY GATES SL-LIGHT MASTS SP-CONCRETE PAVEMENT ON PILES SR-RETAINING WALLS SS-MAJOR SIGN STRUCTURES ST-TUNNEL SW-WEIGH BRIDGE SZ-NOISE BARRIERS

STRUCTURE_TYPE

Structure Type

TEXT(1)

Structure's Type sub level description.

Please refer to Appendix B for the complete list

TRAFFIC_WIDTH

Traffic Width

DECIMAL(7)

Structure's traffic width

YEAR_CONSTRUCTED

Year Constructed

DATETIME(1)

The year the structure is constructed if it's known

CD_DIRECTION

Direction

TEXT(1)

The road direction, where “F” = Forward and “R” = Reverse

F-Forward, R-Reverse

LAT

Latitude

DECIMAL(15)

Latitude Coordinate

LONGIT

Longitude

DECIMAL(15)

Longitude Coordinate

REGION_PHYS

Physical Region

TEXT(1)

The Departments regional operational boundary

1-WESTERN, 2-NORTH EASTERN, 3-NORTHERN, 4-METRO SOUTH EASTERN, 5-SOUTH WESTERN, 6-METRO NORTH WESTERN, 10-GREATER METRO, 11-INNER METRO, 43-GIPPSLAND, 44-HUME, 45-LODDON MALLEE, 46-GRAMPIANS, 47-BARWON SOUTH WEST

LOCAL_ROAD_NAME

Local Road Name

NVARCHAR(100)

Local road name

STRUCTURE_STATUS

Structure Status

TEXT(1)

Status of a structure

DU-Disused, LE-Leased, OT-Other, PR-Proposed, SO-Structure Open, UC-Under Construction

HEIGHT_OF_CELL

Height of Cell

DECIMAL(6)

Height of the Cell

CD_STATE_CLASS

State Classification

TEXT(2)

State Road Classification (i.e. Main Road, Highway, Freeway, Tourist Road)

FR (Forest), HF (Highway / Freeway), MR (Main), RA (Ramps), TR (Tourist)

NM_ROAD_PART

Road Name

NVARCHAR(250)

DTP declared Road Name

NM_ROAD_TYPE

Road Type

NVARCHAR(100)

Road category based on their lane configurations, such as highways, freeways, boulevard, road, ramp etc.

Additional Information

Field	Value
Data last updated	18 June 2025
Metadata last updated	21 June 2025
Created	18 June 2025
Format	CSV
License	Creative Commons Attribution 4.0 International
Attributes	[{"attribute_display_order_id": 1, "db_format": "NVARCHAR(250)", "db_name": "NAME", "definition": "Unique ID, a combination of Structure ID and Historic separated by \"_\"", "fixed_values": "-", "id": "11505", "name": "Name", "ref_number": "AT-11505"}, {"attribute_display_order_id": 2, "db_format": "TEXT(1)", "db_name": "BRIDGE TYPE", "definition": "Bridge types code and description.", "fixed_values": "SA-ROAD OVER ROAD(GRADE SEPARATION), SB-ROAD OVER RAIL(RAIL UNDERPASS), SC-RAIL OVER ROAD(RAIL OVERPASS), SD-ROAD OVER PERENNIAL WATERCOURSE, SE-ROAD OVER SEASONAL WATERCOURSE\n, SF-ROAD OVER FLOODPLAIN, SG-SLAB ON PILES, SH-WEIGH BRIDGE, SI-ROAD OVER IRRIGATION CHANNEL, SL-TUNNEL, SM-SIGN STRUCTURE, SN-WILD LIFE CROSSING, SO-PEDESTRIAN OVERPASS\n, SP-PEDESTRIAN UNDERPASS, SQ-NOISE WALL, SR-MURRAY RIVER BRIDGES & PUNTS, SS-STOCK UNDERPASS, ST-STOCK OVERPASS, SU-UTILITY UNDERPASS, SV-UTILITY OVERPASS, SW-DISUSED BRIDGES\nSX-RETAINING WALL, SY-PEDESTRIAN BRIDGE, SZ-OTHER", "id": "11506", "name": "Bridge Type", "ref_number": "AT-11506"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR(100)", "db_name": "FEATURE_CROSSED", "definition": "Describes what the structure crosses", "fixed_values": "-", "id": "11507", "name": "Feature Crossed", "ref_number": "AT-11507"}, {"attribute_display_order_id": 4, "db_format": "TEXT(1)", "db_name": "STRUCTURE_FORM", "definition": "Structure forms code and description, corresponds to Structure Type in RSIM, except \"SN\" = \"Bridge\" and \"SC\" = \"Major Culverts. User select as drop down list", "fixed_values": "SA-ARCHITECTURAL FEATURE, SB-BRIDGES, SC-MAJOR CULVERTS, SE-EMERGENCY BRIDGING SYSTEM, SG-EMERGENCY GATES\nSL-LIGHT MASTS\nSP-CONCRETE PAVEMENT ON PILES\nSR-RETAINING WALLS\nSS-MAJOR SIGN STRUCTURES\nST-TUNNEL\nSW-WEIGH BRIDGE\nSZ-NOISE BARRIERS", "id": "11509", "name": "Structure Form", "ref_number": "AT-11509"}, {"attribute_display_order_id": 5, "db_format": "TEXT(1)", "db_name": "STRUCTURE_TYPE", "definition": "Structure's Type sub level description.", "fixed_values": "Please refer to Appendix B for the complete list", "id": "11510", "name": "Structure Type", "ref_number": "AT-11510"}, {"attribute_display_order_id": 6, "db_format": "DECIMAL(7)", "db_name": "TRAFFIC_WIDTH", "definition": "Structure's traffic width", "fixed_values": "-", "id": "11511", "name": "Traffic Width", "ref_number": "AT-11511"}, {"attribute_display_order_id": 7, "db_format": "DATETIME(1)", "db_name": "YEAR_CONSTRUCTED", "definition": "The year the structure is constructed if it's known", "fixed_values": "-", "id": "11512", "name": "Year Constructed", "ref_number": "AT-11512"}, {"attribute_display_order_id": 8, "db_format": "TEXT(1)", "db_name": "CD_DIRECTION", "definition": "The road direction, where \u201cF\u201d = Forward and \u201cR\u201d = Reverse", "fixed_values": "F-Forward, R-Reverse", "id": "11513", "name": "Direction", "ref_number": "AT-11513"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL(15)", "db_name": "LAT", "definition": "Latitude Coordinate", "fixed_values": "-", "id": "11585", "name": "Latitude", "ref_number": "AT-11585"}, {"attribute_display_order_id": 10, "db_format": "DECIMAL(15)", "db_name": "LONGIT", "definition": "Longitude Coordinate", "fixed_values": "-", "id": "11586", "name": "Longitude", "ref_number": "AT-11586"}, {"attribute_display_order_id": 11, "db_format": "TEXT(1)", "db_name": "REGION_PHYS", "definition": "The Departments regional operational boundary", "fixed_values": "1-WESTERN, 2-NORTH EASTERN, 3-NORTHERN, 4-METRO SOUTH EASTERN, 5-SOUTH WESTERN, 6-METRO NORTH WESTERN, 10-GREATER METRO, 11-INNER METRO, 43-GIPPSLAND, 44-HUME, 45-LODDON MALLEE, 46-GRAMPIANS, 47-BARWON SOUTH WEST", "id": "11516", "name": "Physical Region", "ref_number": "AT-11516"}, {"attribute_display_order_id": 12, "db_format": "NVARCHAR(100)", "db_name": "LOCAL_ROAD_NAME", "definition": "Local road name", "fixed_values": "-", "id": "11517", "name": "Local Road Name", "ref_number": "AT-11517"}, {"attribute_display_order_id": 13, "db_format": "TEXT(1)", "db_name": "STRUCTURE_STATUS", "definition": "Status of a structure", "fixed_values": "DU-Disused, LE-Leased, OT-Other, PR-Proposed, SO-Structure Open, UC-Under Construction", "id": "11518", "name": "Structure Status", "ref_number": "AT-11518"}, {"attribute_display_order_id": 14, "db_format": "DECIMAL(6)", "db_name": "HEIGHT_OF_CELL", "definition": "Height of the Cell", "fixed_values": "-", "id": "11519", "name": "Height of Cell", "ref_number": "AT-11519"}, {"attribute_display_order_id": 15, "db_format": "TEXT(2)", "db_name": "CD_STATE_CLASS", "definition": "State Road Classification (i.e. Main Road, Highway, Freeway, Tourist Road)", "fixed_values": "FR (Forest), HF (Highway / Freeway), MR (Main), RA (Ramps), TR (Tourist)", "id": "11520", "name": "State Classification", "ref_number": "AT-11520"}, {"attribute_display_order_id": 16, "db_format": "NVARCHAR(250)", "db_name": "NM_ROAD_PART", "definition": "DTP declared Road Name", "fixed_values": "-", "id": "11521", "name": "Road Name", "ref_number": "AT-11521"}, {"attribute_display_order_id": 17, "db_format": "NVARCHAR(100)", "db_name": "NM_ROAD_TYPE", "definition": "Road category based on their lane configurations, such as highways, freeways, boulevard, road, ramp etc.", "fixed_values": "-", "id": "11522", "name": "Road Type", "ref_number": "AT-11522"}]
Ckan url	https://opendata.transport.vic.gov.au
Dataset last updated date	1 month ago
Datastore active	False
Datastore contains all records of source file	True
Edc sync	True
Has views	False
Historical	False
Id	8d8b54fe-2515-4b1f-8601-a134b7a88d3c
Ignore hash	False
Last updated date	1 month ago
Mimetype	text/csv
Open dataset title	Road Bridge General Identification and Location
Original url	https://opendata.transport.vic.gov.au/dataset/05efb8bc-677e-46f1-b1b1-fa5caff65067/resource/8d8b54fe-2515-4b1f-8601-a134b7a88d3c/download/road_bridges.csv
Package id	be0ccd61-c8e4-4293-8780-fa5a98d1c839
Position	0
Publication date	1 month ago
Resource id	8d8b54fe-2515-4b1f-8601-a134b7a88d3c
Set url type	False
State	active
Task created	2025-06-18 06:49:20.305482
File Size	1.3 MB

Field

Value

Data last updated

18 June 2025

Metadata last updated

21 June 2025

Created

18 June 2025

Format

CSV

License

Creative Commons Attribution 4.0 International

Attributes

[{"attribute_display_order_id": 1, "db_format": "NVARCHAR(250)", "db_name": "NAME", "definition": "Unique ID, a combination of Structure ID and Historic separated by \"_\"", "fixed_values": "-", "id": "11505", "name": "Name", "ref_number": "AT-11505"}, {"attribute_display_order_id": 2, "db_format": "TEXT(1)", "db_name": "BRIDGE TYPE", "definition": "Bridge types code and description.", "fixed_values": "SA-ROAD OVER ROAD(GRADE SEPARATION), SB-ROAD OVER RAIL(RAIL UNDERPASS), SC-RAIL OVER ROAD(RAIL OVERPASS), SD-ROAD OVER PERENNIAL WATERCOURSE, SE-ROAD OVER SEASONAL WATERCOURSE\n, SF-ROAD OVER FLOODPLAIN, SG-SLAB ON PILES, SH-WEIGH BRIDGE, SI-ROAD OVER IRRIGATION CHANNEL, SL-TUNNEL, SM-SIGN STRUCTURE, SN-WILD LIFE CROSSING, SO-PEDESTRIAN OVERPASS\n, SP-PEDESTRIAN UNDERPASS, SQ-NOISE WALL, SR-MURRAY RIVER BRIDGES & PUNTS, SS-STOCK UNDERPASS, ST-STOCK OVERPASS, SU-UTILITY UNDERPASS, SV-UTILITY OVERPASS, SW-DISUSED BRIDGES\nSX-RETAINING WALL, SY-PEDESTRIAN BRIDGE, SZ-OTHER", "id": "11506", "name": "Bridge Type", "ref_number": "AT-11506"}, {"attribute_display_order_id": 3, "db_format": "NVARCHAR(100)", "db_name": "FEATURE_CROSSED", "definition": "Describes what the structure crosses", "fixed_values": "-", "id": "11507", "name": "Feature Crossed", "ref_number": "AT-11507"}, {"attribute_display_order_id": 4, "db_format": "TEXT(1)", "db_name": "STRUCTURE_FORM", "definition": "Structure forms code and description, corresponds to Structure Type in RSIM, except \"SN\" = \"Bridge\" and \"SC\" = \"Major Culverts. User select as drop down list", "fixed_values": "SA-ARCHITECTURAL FEATURE, SB-BRIDGES, SC-MAJOR CULVERTS, SE-EMERGENCY BRIDGING SYSTEM, SG-EMERGENCY GATES\nSL-LIGHT MASTS\nSP-CONCRETE PAVEMENT ON PILES\nSR-RETAINING WALLS\nSS-MAJOR SIGN STRUCTURES\nST-TUNNEL\nSW-WEIGH BRIDGE\nSZ-NOISE BARRIERS", "id": "11509", "name": "Structure Form", "ref_number": "AT-11509"}, {"attribute_display_order_id": 5, "db_format": "TEXT(1)", "db_name": "STRUCTURE_TYPE", "definition": "Structure's Type sub level description.", "fixed_values": "Please refer to Appendix B for the complete list", "id": "11510", "name": "Structure Type", "ref_number": "AT-11510"}, {"attribute_display_order_id": 6, "db_format": "DECIMAL(7)", "db_name": "TRAFFIC_WIDTH", "definition": "Structure's traffic width", "fixed_values": "-", "id": "11511", "name": "Traffic Width", "ref_number": "AT-11511"}, {"attribute_display_order_id": 7, "db_format": "DATETIME(1)", "db_name": "YEAR_CONSTRUCTED", "definition": "The year the structure is constructed if it's known", "fixed_values": "-", "id": "11512", "name": "Year Constructed", "ref_number": "AT-11512"}, {"attribute_display_order_id": 8, "db_format": "TEXT(1)", "db_name": "CD_DIRECTION", "definition": "The road direction, where \u201cF\u201d = Forward and \u201cR\u201d = Reverse", "fixed_values": "F-Forward, R-Reverse", "id": "11513", "name": "Direction", "ref_number": "AT-11513"}, {"attribute_display_order_id": 9, "db_format": "DECIMAL(15)", "db_name": "LAT", "definition": "Latitude Coordinate", "fixed_values": "-", "id": "11585", "name": "Latitude", "ref_number": "AT-11585"}, {"attribute_display_order_id": 10, "db_format": "DECIMAL(15)", "db_name": "LONGIT", "definition": "Longitude Coordinate", "fixed_values": "-", "id": "11586", "name": "Longitude", "ref_number": "AT-11586"}, {"attribute_display_order_id": 11, "db_format": "TEXT(1)", "db_name": "REGION_PHYS", "definition": "The Departments regional operational boundary", "fixed_values": "1-WESTERN, 2-NORTH EASTERN, 3-NORTHERN, 4-METRO SOUTH EASTERN, 5-SOUTH WESTERN, 6-METRO NORTH WESTERN, 10-GREATER METRO, 11-INNER METRO, 43-GIPPSLAND, 44-HUME, 45-LODDON MALLEE, 46-GRAMPIANS, 47-BARWON SOUTH WEST", "id": "11516", "name": "Physical Region", "ref_number": "AT-11516"}, {"attribute_display_order_id": 12, "db_format": "NVARCHAR(100)", "db_name": "LOCAL_ROAD_NAME", "definition": "Local road name", "fixed_values": "-", "id": "11517", "name": "Local Road Name", "ref_number": "AT-11517"}, {"attribute_display_order_id": 13, "db_format": "TEXT(1)", "db_name": "STRUCTURE_STATUS", "definition": "Status of a structure", "fixed_values": "DU-Disused, LE-Leased, OT-Other, PR-Proposed, SO-Structure Open, UC-Under Construction", "id": "11518", "name": "Structure Status", "ref_number": "AT-11518"}, {"attribute_display_order_id": 14, "db_format": "DECIMAL(6)", "db_name": "HEIGHT_OF_CELL", "definition": "Height of the Cell", "fixed_values": "-", "id": "11519", "name": "Height of Cell", "ref_number": "AT-11519"}, {"attribute_display_order_id": 15, "db_format": "TEXT(2)", "db_name": "CD_STATE_CLASS", "definition": "State Road Classification (i.e. Main Road, Highway, Freeway, Tourist Road)", "fixed_values": "FR (Forest), HF (Highway / Freeway), MR (Main), RA (Ramps), TR (Tourist)", "id": "11520", "name": "State Classification", "ref_number": "AT-11520"}, {"attribute_display_order_id": 16, "db_format": "NVARCHAR(250)", "db_name": "NM_ROAD_PART", "definition": "DTP declared Road Name", "fixed_values": "-", "id": "11521", "name": "Road Name", "ref_number": "AT-11521"}, {"attribute_display_order_id": 17, "db_format": "NVARCHAR(100)", "db_name": "NM_ROAD_TYPE", "definition": "Road category based on their lane configurations, such as highways, freeways, boulevard, road, ramp etc.", "fixed_values": "-", "id": "11522", "name": "Road Type", "ref_number": "AT-11522"}]

Ckan url

https://opendata.transport.vic.gov.au

Dataset last updated date

1 month ago

Datastore active

False

Datastore contains all records of source file

True

Edc sync

True

Has views

False

Historical

False

8d8b54fe-2515-4b1f-8601-a134b7a88d3c

Ignore hash

False

Last updated date

1 month ago

Mimetype

text/csv

Open dataset title

Road Bridge General Identification and Location

Original url

https://opendata.transport.vic.gov.au/dataset/05efb8bc-677e-46f1-b1b1-fa5caff65067/resource/8d8b54fe-2515-4b1f-8601-a134b7a88d3c/download/road_bridges.csv

Package id

be0ccd61-c8e4-4293-8780-fa5a98d1c839

Position

Publication date

1 month ago

Resource id

8d8b54fe-2515-4b1f-8601-a134b7a88d3c

Set url type

False

State

active

Task created

2025-06-18 06:49:20.305482

File Size

1.3 MB