Ministry of Transportation (MOT) Culverts

1017 views (16 recent)

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

A Culvert is a pipe (less than 3m in diameter) or half-round flume used to transport or drain water under or away from the road and/or right of way. Culverts that are greater than or equal to 3m in diameter are stored in the MoT Bridge Structure Road Dataset. 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

Culverts are used to transport or drain water under or away from the road and/or right of way.

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-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.MOT_CULVERTS_SP

Short Name: MOT_CLVRT
Comments: CULVERT SP represents Culverts. A Culvert is a pipe (less than 3m in diameter) or half-round flume used to transport or drain water under or away from the road and/or Right of Way. Culverts that are greater than or equal to 3m in diameter are stored in the MoT Bridge Structure Road Dataset. It is a Point feature.

Column Name Short Name Data Type Data Precision Comments
CULVERT_ID CULVERT_ID NUMBER 10 CULVERT ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_CULVERT_ID CHRS_CL_ID VARCHAR2 50 CHRIS CULVERT ID contains the identifier of the culvert inventory item derived by the CHRIS application. E.g., 2455305
ADMIN_UNIT_CODE ADM_UNITCD 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 ADMN_NT_NM VARCHAR2 80 ADMIN UNIT NAME contains the MoT Service Area Name identifier.
CROSS_SECTION_POSITION CRSS_SCTNN VARCHAR2 80 CROSS SECTION POSITION contains the cross sectional position of the culvert in relationship to the road, E.g., Ditch - Left, Right of Way - Left, Shoulder - Left etc.
CULVERT_TYPE CLVRT_TYPE VARCHAR2 80 CULVERT TYPE contains a physical description of the type of culvert, E.g., down drain, entrance, roadway etc.
CULVERT_DIAMETER CLVRT_DMTR NUMBER 11 CULVERT DIAMETER contains the physical measure of the diameter of the culvert in millimetres. E.g., 100, 2999, etc.
CULVERT_MATERIAL CLVRT_MTRL VARCHAR2 80 CULVERT MATERIAL contains a physical description of the type of material the culvert is made of. E.g., Concrete, Galvanized, Plastic etc.
CONFINED_SPACE_IND CONF_SPACE VARCHAR2 3 CONFINED SPACE IND indicates whether the Culvert is enclosed or partially enclosed, not designed for human occupancy, and large enough so the worker can enter e.g., Yes or No
INSTALLATION_DATE INSTLLTN_E DATE 7 INSTALLATION DATE indicates the date that the culvert was installed (YYYY-MM-DD).
FISH_SENSITIVE_CODE FISH_SENSI VARCHAR2 80 FISH SENSITIVE CODE indicates whether a Culvert contains fish bearing water or not. e.g., Yes, No or Unknown
FISH_PASSAGE_TYPE FSH_PSSG_E VARCHAR2 80 FISH PASSAGE TYPE contains a physical description of the fish passage type, E.g., bottomless, baffle, fish ladder etc.
GRATE_CODE GRATE VARCHAR2 10 GRATE CODE indicates whether a culvert has a grate or not. e.g., Yes, No or Unknown
FLAP_GRATE_CODE FLAP_GRATE VARCHAR2 10 FLAP GRATE CODE indicates whether a culvert has a flap grate or not. e.g., Yes, No or Unknown
CHRIS_ANCHOR_SECTION_ID CHRS_NC_ID NUMBER 9 CHRIS ANCHOR SECTON ID contains the CHRIS application internal unique identifier for the anchor section segment. E.g., 2777363
EVENT_LOCATION EVNT_LCTN NUMBER 14 EVENT LOCATION contains the Measure for the Culvert along the Anchor Section. Measures are in Kilometers. e.g., 42.200
HIGHWAY_NUMBER HGHWY_NMBR VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier only populated when the culvert is located on a MoT Numbered route. E.g., 99 If the culvert is not on a numbered route the field is 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.