Ministry of Transportation (MOT) Sign

472 views (5 recent)

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

A Sign is a lettered board, message or other display which includes all regulatory, warning, guide, informational, advisory, construction and maintenance and route markers, but excluding electronically controlled messages/displays. It is a Point feature

Data and Resources

Dataset Extent

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

Additional Information

Purpose

A Sign is a lettered board, message or other display which includes all regulatory, warning, guide, informational, advisory, construction and maintenance and route markers, but excluding electronically controlled messages/displays.

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_SIGNS_SP

Short Name: SIGNS
Comments: SIGN SP represents Signs. A Sign is a lettered board, message or other display which includes all regulatory, warning, guide, informational, advisory; construction and maintenance and route markers, but excluding electronically controlled messages/displays. It is a Point feature.

Column Name Short Name Data Type Data Precision Comments
SIGN_ID SIGN_ID NUMBER 10 SIGN ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_SIGN_ID ITT_PRIMAR VARCHAR2 50 CHRIS SIGN ID contains the identifier of the sign 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 DMIN 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 sign in relationship to the road, example: Ditch - Left, Right of Way - Left, Shoulder - Left etc.
SIGN_CATALOG_DESCRIPTION SIGN_DESC VARCHAR2 80 SIGN CATALOG DESCRIPTION is the description of the Sign from the MoT SIGN Catalog. e.g., $2,000 Maximum Penalty for Littering, etc.
DIRECTION_FACING DIR_FACE VARCHAR2 80 DIRECTION FACING indicates cardinal direction relative to the prominent direction of the road that the outward face of the sign points towards. E.g., East, West, South, North or Unknown
SIGN_POST_TYPE POST_TYPE VARCHAR2 80 SIGN POST TYPE contains a physical description of the type of sign post. E.g., telspar, metal, wood etc.
NUMBER_OF_POSTS NUM_POST NUMBER 11 NUMBER OF POSTS indicates the number of posts which the sign is attached (if multiple signs are on one post, the post is assigned to only one sign).
LARGE_SIGN_IND LG_SIGN VARCHAR2 3 LARGE SIGN IND indicates whether a Sign is large (>3.2m2) or not. e.g., Yes or No
DISTRICT_SIGN_NUMBER DIST_NUM VARCHAR2 20 DISTRICT SIGN NUMBER indicates the MoT District sign number, utilized for identification by the Ministry Districts or Service areas. E.g., PB-25-3 A
INSTALLATION_DATE INSTA_DATE DATE 7 INSTALLATION DATE indicates the date that the sign 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
EVENT_LOCATION LOCATION NUMBER 14 EVENT LOCATION contains the Measure for the Sign along the Anchor Section. Measures are in Kilometers. e.g., 42.200
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier populated when the sign inventory item is located on a MoT Numbered route.
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.