Ministry of Transportation (MOT) Railroad Crossing

293 views (5 recent)

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

A Railroad Crossing is where the road surface is common to both the Railway Authority and the Ministry of Transportation Road Network; also includes overhead and under passes. 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 Railroad crossing is where the road surface is common to both the Railway Authority and the Ministry of Transportation Road Network; also includes overhead and under passes.

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_RAILROAD_CROSSINGS_SP

Short Name: RLRD_CRSS
Comments: RAILROAD CROSSING SP represents Railroad Crossings. A Railway Crossing is where the road surface is common to both the Railway Authority and the Ministry of Transportation Road Network; also includes overhead and under passes. It is a Point feature.

Column Name Short Name Data Type Data Precision Comments
RAILROAD_CROSSING_ID RRX_ID NUMBER 10 RAILROAD CROSSING ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_RAILROAD_CROSSING_ID ITT_PRIMAR VARCHAR2 50 CHRIS RAILROAD CROSSING ID contains the identifier of the railroad crossing 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 railroad crossing in relationship to the road. E.g., Overhead - Left, Underpass - Left, Level etc.
CROSSING_ID CROSS_ID VARCHAR2 50 CROSSING ID indicates the identification number of the crossing within railroad crossing information system. E.g., 196
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 Railroad Crossing 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 railroad crossing 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.