Ministry of Transportation (MOT) Guardrail

390 views (10 recent)

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

A Guardrail is a barrier fastened to the end of a bridge abutment, along the shoulder of a road or between travel lanes of opposing traffic. 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 Guardrail is a barrier fastened to the end of a bridge abutment, along the shoulder of a road or between travel lanes of opposing traffic.

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_GUARDRAILS_SP

Short Name: GUARDRAILS
Comments: GUARDRAIL SP represents Guardrails. A Guardrail is a barrier fastened to the end of a bridge abutment, along the shoulder of a road or between travel lanes of opposing traffic. It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
GUARDRAIL_ID GUARD_ID NUMBER 10 GUARDRAIL ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_GUARDRAIL_ID ITT_PRIMAR VARCHAR2 50 CHRIS GUARDRAIL ID contains the identifier of the guardrail inventory item derived by the CHRIS application. E.g., 2422439
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
CROSS_SECTION_POSITION X_SECTION VARCHAR2 80 CROSS SECTION POSITION contains the cross sectional position of the guardrail in relationship to the road, E.g., Ditch - Left, Right of Way - Left, Shoulder - Left etc.
GUARDRAIL_TYPE GUARD_TYPE VARCHAR2 80 GUARDRAIL TYPE contains a physical description of the type of guardrail. E.g., 460mm NP, Standard W-Beam, Cable Barrier etc.
INSTALLATION_DATE INSTA_DATE DATE 7 INSTALLATION DATE indicates the date that the guardrail was installed (YYYY-MM-DD).
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 the guardrail 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 the guardrail event along the anchor section. Measures are in Kilometer (km). E.g., 136.684 km
HIGHWAY_NUMBER HW_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier populated when the guardrail 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 NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters

Comments

No comments have been posted yet.