Ministry of Transportation (MOT) Drainage Appliance

327 views (2 recent)

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

A Drainage Appliance is an apparatus (that has not been described as a culvert), or earth works, designed to facilitate the movement of water in a controlled manner. Drainage Appliance include some appliances/earth works that work in conjunction with culverts. 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 Drainage Appliance is an apparatus or earth works designed to facilitate the movement of water in a controlled manner

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_DRAINAGE_APPLIANCES_SP

Short Name: MOT_DR_APP
Comments: DRAINAGE APPLIANCE SP is an apparatus (that has not been described as a culvert), or earth works, designed to facilitate the movement of water in a controlled manner. Drainage Appliance includes some appliances/earth works that work in conjunction with culverts. It is a Point feature.

Column Name Short Name Data Type Data Precision Comments
DRAINAGE_APPLIANCE_ID DRAIN_ID NUMBER 10 DRAINAGE APPLIANCE ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_DRAINAGE_APPLIANCE_ID ITT_PRIMAR VARCHAR2 50 CHRIS DRAINAGE APPLIANCE ID contains the identifier of the drainage appliance 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 the drainage appliance in relationship to the road. E.g., Ditch - Left, Right of Way - Left, Shoulder - Left etc.
DRAINAGE_APPLIANCE_TYPE DRAIN_TYPE VARCHAR2 80 DRAINAGE APPLIANCE TYPE contains a physical description of the type of drainage appliance. E.g., catch basin, dry well, manholes etc.
APPLIANCE_COUNT APPL_COUNT NUMBER 11 APPLIANCE COUNT indicates the number of appliances at a given location. E.g., 1, 5, 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
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 Drainage Appliance 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 drainage appliance 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.