Ministry of Transportation (MOT) Highway Profile

582 views (6 recent)

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

A Highway Profile defines the number of through travel lanes, including passing and truck lanes, and whether the road is divided or not. It is a Linear feature

Data and Resources

Dataset Extent

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

Additional Information

Purpose

A Highway Profile defines the number of through travel lanes, including passing and truck lanes, and whether the road is divided or not.

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-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.MOT_HIGHWAY_PROFILES_SP

Short Name: HWY_PRFLS
Comments: HIGHWAY PROFILE SP defines the number of through travel lanes, including passing and truck lanes, and whether the road is divided or not. It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
HIGHWAY_PROFILE_ID HWY_PRF_ID NUMBER 10 HIGHWAY PROFILE ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_HIGHWAY_PROFILE_ID ITT_PRIMAR VARCHAR2 50 CHRIS HIGHWAY PROFILE ID contains the identifier of the highway profile 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. E.g., 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 represents a geographic area within the province. E.g., Lower Mainland
NUMBER_OF_LANES NUM_LANES NUMBER 11 NUMBER OF LANES indicates the number of through travel lanes including passing or truck lanes.
DIVIDED_HIGHWAY_IND DIVIDE_HWY VARCHAR2 3 DIVIDED HIGHWAY IND indicates whether the Highway Profile meets MoT definition of divided road or not. e.g., Yes or No
CHRIS_ANCHOR_SECTION_ID CHRIS_ANCH NUMBER 9 CHRIS ANCHOR SECTON ID contains the CHRIS application internal unique identifier for the anchor section segment. E.g., 2777363
START_EVENT_LOCATION START_LOC NUMBER 14 START EVENT LOCATION contains the start measure for highway profile event along the anchor section. Measures are in Kilometer (km). E.g., 42.200 km
END_EVENT_LOCATION END_LOC NUMBER 14 END EVENT LOCATION contains the end measure for highway profile event along the anchor section. Measures are in Kilometer (km). E.g., 136.684 km
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier populated when the highway profile is located on a MoT Numbered route. E.g., 99
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 FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters