Ministry of Transportation (MOT) Storm Sewer

324 views (2 recent)

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

A Storm Sewer is an enclosed system of pipes or drains that divert water away from the road and/or right of way. Also includes culverts that run under enclosed ditches. 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 Storm Sewer is an enclosed system of pipes or drains that divert water away from the road and/or right of way. Also includes culverts that run under enclosed ditches.

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_STORM_SEWERS_SP

Short Name: STRM_SEWRS
Comments: STORM SEWER SP represents Storm Sewers. A Storm Sewer is an enclosed system of pipes or drains that divert water away from the road and/or Right of Way. It also includes culverts that run under enclosed ditches. It is a linear feature with measure values.

Column Name Short Name Data Type Data Precision Comments
STORM_SEWER_ID STM_SWR_ID NUMBER 10 STORM SEWER ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_STORM_SEWER_ID ITT_PRIMAR VARCHAR2 50 CHRIS STORM SEWER ID contains the identifier of the storm sewer 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 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 storm sewer in relationship to the road. E.g., Right of Way - Left, Shoulder - Left, Right of Way - Right etc.
STORM_SEWER_DIAMETER SS_DIAM NUMBER 11 STORM SEWER DIAMETER contains the physical measure of the diameter of the storm sewer in mm.
STORM_SEWER_MATERIAL SS_MAT VARCHAR2 80 STORM SEWER MATERIAL contains a physical description of the type of material making the storm sewer. E.g., Concrete, Galvanized, multiplate etc.
CONFINED_SPACE_IND CONF_SPACE VARCHAR2 3 CONFINED SPACE IND indicates whether the Storm Sewer is enclosed or partially enclosed, not designed for human occupancy, and large enough so the worker can enter or not. e.g., Yes or No
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 storm sewer 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 storm sewer event along the anchor section. Measures are in Kilometer (km). E.g., 136.684 km
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier populated when the storm sewer 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.
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters