Ministry of Transportation (MOT) Road Structures

1136 views (14 recent)

Published by the Ministry of Transportation and Infrastructure - Construction and Maintenance
Licensed under Open Government Licence - British Columbia

The Road Structures on the highway that are maintained by the Ministry. Highway structures include bridges, culverts (greater than or equal to 3m diameter), retaining walls (perpendicular height greater than or equal to 2m), sign bridges, tunnels/snowsheds. Information is recorded in the Bridge Management Information System (BMIS)

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

To show structures on the highway that are maintained by the MoT.

Data Quality
Lineage Statement

Contact Information

NameJenna Sparks (pointOfContact)
EmailJenna.Sparks@gov.bc.ca
OrganizationMinistry of Transportation and Infrastructure
Sub-OrganizationConstruction and Maintenance

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2012-03-22
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.MOT_ROAD_STRUCTURE_SP

Short Name: ROAD_STRUC
Comments: ROAD STRUCTURE SP represents the roads that the Structures are found on. Structures include Bridges, Culverts (greater than or equal to 3m diameter), Marine, Retaining Walls (perpendicular height greater than or equal to 2m), Sign Bridges and Tunnels (includes Snowsheds). It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
HWY_STRUCTURE_CLASS_ID HWY_STR_ID NUMBER 18 HWY STRUCTURE CLASS ID contains a system generated identifier to insure row uniqueness
CHRIS_HWY_STRUCTURE_ROAD_ID ITT_PRIMAR VARCHAR2 50 CHRIS HWY STRUCTURE ROAD ID is the identifier of the Structure inventory item derived by the CHRIS application. e.g., 2455305
ADMIN_UNIT_CODE ADMIN_CODE VARCHAR2 10 ADMIN UNIT CODE contains the MoT Service Area identifier. There are 28 service areas in MoT's jurisdiction. Each Service Area represents a geographic area within the province. Example - 13.
ADMIN_UNIT_NAME ADMIN_NAME VARCHAR2 80 ADMIN UNIT NAME contains the MoT Service Area Name identifier. There are 28 service areas names in MoT's jurisdiction. Each Service Area Name represent a geographic area within the province. Example - Lower Mainland
CROSS_SECTION_POSITION X_SECTION VARCHAR2 80 CROSS SECTION POSITION contains the cross sectional position of structure in relationship to the road, example: over, under, through etc.
BMIS_STRUCTURE_ROAD_ID STR_RD_ID VARCHAR2 50 BMIS STRUCTURE ROAD ID contains a number which identifies the section of road which is in relationship to the actual structure. The number is comes from the Bridge Management Information System (BMIS).
BMIS_STRUCTURE_NUMBER STR_NUMBER VARCHAR2 5 BMIS STRUCTURE NUMBER is the BMIS Number of the Structure in the form of nnnnA (the Alpha character is optional) that identifies the individual Structure. e.g., 1598S
BMIS_STRUCTURE_NAME STR_NAME VARCHAR2 40 BMIS STRUCTURE NAME contains the Structure Name as recorded in BMIS.
BMIS_STRUCTURE_TYPE STR_TYPE VARCHAR2 20 BMIS STRUCTURE TYPE contains the Structure Type description for example Bridge, Culvert, Retaining Walls, Tunnel, Snowshed and Sign Bridge.
BMIS_STRUCT_STATUS_TYPE_DESC STR_DESC VARCHAR2 100 BMIS STRUCT STATUS TYPE DESC is a textual description of current status of the Structure. e.g. Open/In Use, In Design, Under Construction, etc.
CHRIS_ANCHOR_SECTION_ID CHRIS_ANCH NUMBER 9 CHRIS ANCHOR SECTION ID contains a CHRIS application internal unique identifier for the anchor section segment.
START_EVENT_LOCATION START_LOC NUMBER 14 START EVENT LOCATION contains the start measure for MC event along the anchor section. Measures are in km (example 42.2002 km).
END_EVENT_LOCATION END_LOC NUMBER 14 END EVENT LOCATION contains the end measure for MC event along the anchor section. Measures are in km (example 136.684 km).
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier only populated when the Structure is located on a MoT Numbered Route. e.g., 99. If the Structure is not on a Numbered Route the field is left blank.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters

Comments

No comments have been posted yet.