Access & Security

Metadata Information

Record Published

2012-03-22

Record Last Modified

2019-12-17

Resource Status

onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.MOT_ROAD_FEATURES_INVNTRY_SP

Short Name: ROAD_FT_INComments: 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

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

About Tracking

Google Analytics uses "cookies," which are text files stored on your computer that enable an analysis of your use of the website. Some of the information generated by the cookie about your use of this website may be transmitted to and stored on Google servers outside of Canada. You may refuse the use of cookies by selecting the appropriate settings in your browser; however, please note that if you do so, you may not be able to use the full functionality of this website. Furthermore, you can prevent Google’s collection and use of data generated by the cookie and related to your use of the website by downloading and installing the browser plug-in available at (http://tools.google.com/dlpage/gaoptout?hl=en).