Ministry of Transportation (MOT) Road Features Inventory (RFI)

3246 views (32 recent)

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

The Road Features Inventory spatial layer shows all highways under the administration and control of BC MoT for which the Ministry has maintenance responsibility

Data and Resources

Dataset Extent

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

Additional Information


To show all highways under the administration and control of BC MoT for which the Ministry has maintenance responsibility.

Contact Information

NameJenna Sparks (pointOfContact)
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 2021-04-26
Resource Status onGoing

Object Description


Short Name: ROAD_FT_IN
Comments: ROAD FEATURE INVENTORY SP contains all roads under the administration and control for which the Ministry has maintenance responsibility. It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
ROAD_FEATURE_INVNTRY_ID RFI_ID NUMBER 10 ROAD FEATURE INVNTRY ID is a system generated unique id. e.g. 1
CHRIS_RFI_HIGHWAY_ID ITT_PRIMAR NUMBER 9 CHRIS RFI HIGHWAY ID is the identifier of the RFI (Road Features Inventory) Highway derived by the CHRIS application. e.g., 2455305
RFI_HIGHWAY_NAME RFI_NAME VARCHAR2 30 RFI HIGHWAY NAME is a unique identifier which defines a RFI (Road Features Inventory) Highway. e.g., 06-B-@-08210S
RFI_HIGHWAY_DESCRIPTION DESCRPTION VARCHAR2 240 RFI HIGHWAY DESCRIPTION is a description of the RFI (Road Features Inventory) Highway. Usually the street name that is either officially known as or, at least, commonly referred to. e.g., Allen Way
RFI_HIGHWAY_DIRECTION DIRECTION VARCHAR2 80 RFI HIGHWAY DIRECTION indates the Cardinal Direction for a RFI (Road Features Inventory) Highway. e.g,, Eastbound, Westbound, Southbound, Northbound or Unkown
RFI_HIGHWAY_LENGTH RFI_LENGTH NUMBER 13 RFI HIGHWAY LENGTH indicates the length of the RFI (Road Features Inventory) highway measured in kilometers. e.g., 28.422
SERVICE_AREA SERVICE_AR VARCHAR2 80 SERVICE AREA contains a unique number assigned to a geographic area for the purpose of managing Roads and Bridges Maintenance Contracts (Service Areas) and also concession contracts (Concession Areas).
AREA_MANAGER_AREA A_M_AREA VARCHAR2 8 AREA MANAGER AREA contains a geographic area within a Service Area that is the responsibility of Ministry Area Manager(s).
SUB_AREA SUB_AREA VARCHAR2 2 SUB AREA is used to define a smaller grouping of roads within a Service Areas. (It may represent a Foremen Areas, an isolated area such as an island.) @ represents no sub area.
RFI_HIGHWAY_TYPE HWY_TYPE VARCHAR2 80 RFI HIGHWAY TYPE is the type of highway. e.g., Road, Easement, or Notional Highway
RFI_HIGHWAY_NUMBER RFI_NUMBER VARCHAR2 80 RFI HIGHWAY NUMBER is assigned by the district and there can be duplicate numbers within a district. This is a 4 character text field which uses leading 0. Generally reflects the highway number. e.g., 0105
RFI_HIGHWAY_ALPHA HWY_ALPHA VARCHAR2 80 RFI HIGHWAY ALPHA is an attribute which defines a possible relationship of one or more RFI segments with the same highway number. e.g., A
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 30 HIGHWAY NUMBER is the MoT Numbered Route identifier only populated when the RFI (Road Features Inventory) Highway is located on a MoT Numbered Route. e.g., 99. If the RFI Highway 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 FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters