Ministry of Transportation (MOT) Surface Type

517 views (4 recent)

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

Surface Type describes the type of surface material used on road

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To show the type of surface material used on road.

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_SURFACE_TYPE_SP

Short Name: ROAD_SUR_T
Comments: ROAD SURFACE TYPE SP describes the type of surface of the road. It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
ROAD_SURFACE_TYPE_ID ROAD_SR_ID NUMBER 18 ROAD SURFACE TYPE ID contains a system generated identifier to insure row uniqueness.
CHRIS_ROAD_SURFACE_TYPE_ID ITT_PRIMAR VARCHAR2 50 CHRIS ROAD SURFACE TYPE ID is the unique identifier of the Surface Type 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
SURFACE_TYPE SURF_TYPE VARCHAR2 80 SURFACE TYPE contains a description of the road surface material for example; Hot mix, Cold Mix, Concrete, Surface Treated, Gravel, Dirt, Other, Cleared, Uncleared.
YEAR_PAVED YEAR_PAVED VARCHAR2 4 YEAR PAVED Indicates the year the road surface was paved.
YEAR_HOT_IN_PLACE YEAR_HOT VARCHAR2 4 YEAR HOT IN PLACE Indicates the year the road surface was treated with hot-in-place asphalt. Hot in place includes asphalt recycling.
YEAR_SURFACE_TREATED YEAR_SURF VARCHAR2 4 YEAR SURFACE TREATED Indicates the year the road surface was seal coated (gravel roads that have never been hot mix, cold mix or concrete paved).
YEAR_MICRO_SURFACED YEAR_MICRO VARCHAR2 4 YEAR MICRO SURFACED Indicates the year the road surface was Micro Surfaced.
YEAR_QUIET_SURFACED YEAR_QUIET VARCHAR2 4 YEAR QUIET SURFACED Indicates the year the road surface was Quiet Surfaced.
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 SURFACE TYPE event along the anchor section. Measures are in km (example 76.092 km).
END_EVENT_LOCATION END_LOC NUMBER 14 END EVENT LOCATION contains the end measure for SURFACE TYPE event along the anchor section. Measures are in km (example 76.662 km).
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier only populated when the Suface Type is located on a MoT Numbered Route. e.g., 99. If the Suface Type 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