Digital Road Atlas (DRA) - Master Partially-Attributed Roads

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Access Only

Digital Road Atlas Master Partially-Attributed Roads (DGTL ROAD ATLAS MPAR SP) provides partial information about roads in British Columbia. This data set represents the public data that is available for the Digital Road Atlas. For more information on the DRA program please visit the DRA info page

This dataset is updated on the 6th of every month to the warehouse

Data and Resources

Dataset Extent

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

Additional Information

Data Quality
Lineage Statement

Contact Information

NameCarol Ogborne (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2013-02-27
Record Last Modified 2017-06-01
Resource Status onGoing

Object Description


Short Name: DRA_MPAR

Column Name Short Name Data Type Data Precision Comments
DIGITAL_ROAD_ATLAS_LINE_ID DRA_LINEI NUMBER 10 DIGITAL ROAD ATLAS LINE ID is a unique numeric road segment identifier e.g. 453567.
FEATURE_TYPE FTYPE VARCHAR2 12 FEATURE TYPE is the feature type clasification, e.g. bridge, dam, ferry route, etc.
HIGHWAY_EXIT_NUMBER HWYEXITNUM VARCHAR2 6 HIGHWAY EXIT NUMBER is a numeric or alpha-numeric identifier assigned to a road segment that allows egress from a segment designated as a highway, e.g. 5a.
HIGHWAY_ROUTE_NUMBER HWYRTENUM VARCHAR2 12 HIGHWAY ROUTE NUMBER is the Highways and Arterials numbers, delimited by a plus sign, e.g. 1+5+97.
SEGMENT_LENGTH_2D SEGLNGTH2D NUMBER 10 SEGMENT LENGTH 2D is the 2D road segment length in meters e.g. 123.345.
SEGMENT_LENGTH_3D SEGLNGTH3D NUMBER 10 SEGMENT LENGTH 3D is the 3D Segment length in meters e.g. 123.345.
ROAD_NAME_ALIAS1 RDALIAS1 VARCHAR2 70 ROAD NAME ALIAS1 is the first full alias name, e.g. Trans-Canada Hwy E.
ROAD_NAME_ALIAS1_ID RDALIAS1ID NUMBER 8 ROAD NAME ALIAS1 ID is the ID of the first alias name, e.g. 123456.
ROAD_NAME_ALIAS2 RDALIAS2 VARCHAR2 70 ROAD NAME ALIAS2 is the Second full alias name, e.g. Hwy 1.
ROAD_NAME_ALIAS2_ID RDALIAS2ID NUMBER 8 ROAD NAME ALIAS2 ID is the ID of the second alias name, e.g. 123456.
ROAD_NAME_ALIAS3 RDALIAS3 VARCHAR2 70 ROAD NAME ALIAS3 is the third full alias name, e.g Hwy 5.
ROAD_NAME_ALIAS3_ID RDALIAS3ID NUMBER 8 ROAD NAME ALIAS3 ID is the ID of the third alias name, e.g. 123456.
ROAD_NAME_ALIAS4 RDALIAS4 VARCHAR2 70 ROAD NAME ALIAS4 is the fourth full alias name, e.g. Hwy 97.
ROAD_NAME_ALIAS4_ID RDALIAS4ID NUMBER 8 ROAD NAME ALIAS4 ID is the ID of the fourth alias name, e.g. 123456.
ROAD_NAME_FULL RDNAME VARCHAR2 70 ROAD NAME FULL is the complete name for the road made up of the concatenation of the individual road name components, e.g. Elk Valley Hwy.
ROAD_NAME_ID RDNAMEID NUMBER 8 ROAD NAME ID is the unique ID for each distinct full road name, e.g. 60657.
ROAD_SURFACE RDSURFACE VARCHAR2 15 ROAD SURFACE is the road surface type, e.g boat, decommissioned, loose, overgrown, paved, rough, unknown.
ROAD_CLASS ROAD_CLASS VARCHAR2 12 ROAD CLASS is the navigational road classification, e.g alleyway, arterial, collector, etc.
NUMBER_OF_LANES NUMLANES NUMBER 2 NUMBER OF LANES is the total number of lanes of through traffic on both sides of the segment, e.g. 2.
NODE_FROM_ID FNODE NUMBER 8 NODE FROM ID is the start network node topology identifier, e.g. 299876.
NODE_TO_ID TNODE NUMBER 8 NODE TO ID is the end network node topology identifier, e.g. 299877.
DATA_SUPPLIER SPPLR VARCHAR2 50 DATA SUPPLIER is the data supplier company or organization . This can be provincial agencies including Ministry of Environment, Lands and Parks, local governments, 911 service providers and Utilities, e.g. ministryOfEnvironmentLandsParks.
SUPPLIER_DETAIL SPPLR_DTL VARCHAR2 50 SUPPLIER DETAIL is additional details regarding the data supplying organization, e.g geographicDataBC.
GEOMETRY_CAPTURE_TECHNIQUE CAPTRTCHN VARCHAR2 30 GEOMETRY CAPTURE TECHNIQUE is the data capture technique or positioning method, e.g cadastre, differentialGPS, orthoPhotography, etc.
DATA_CAPTURE_DATE CPTRDATE DATE 7 DATA CAPTURE DATE is the Date of data capture in the format YYYYMMDD e.g. 20110623.
FEATURE_CODE FCODE VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping''s (CCSM) system for classification of geographic features.
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


No comments have been posted yet.