| 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. |
- |
