Water Survey of Canada Sub-Sub-Drainage Areas

1514 views (12 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Open Government Licence - Canada

Atlas of Canada 1,000,000 National Frameworks Data, Hydrology - Drainage Areas (WSC sub-sub drainage areas) from the Natural Resources Canada GeoGratis website. The dataset has been clipped to drainage areas within or adjacent to B.C.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

For use in showing the 4th level drainages (sub-sub-drainages) in the national Drainage Area Framework and for use in determining the Water Survey of Canada alphanumeric codes that are used in hydrometric station numbering.

Lineage Statement

Downloaded from Natural Resources Canada GeoGratis website (http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/30b33615-6dda-51a5-a9dd-308802714a28.html) and clipped to the area around B.C, then re-projected to BC Albers projection. Some attribute fields were removed, and other attribute field names were changed.

More Information

Contact Information

NameSam Albers (businessExpert)
EmailSam.Albers@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management

Access & Security

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

Metadata Information

Record Published 2016-01-07
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.DRP_SUB_SUB_DRAINAGES_1M_SP

Short Name: SSDA
Comments: Water survey of Canada Administrative areas, related to numbering of Hydrometric Stations for British Columbia. This feature class contain polygons

Column Name Short Name Data Type Data Precision Comments
SUB_SUB_DRAINAGE_1M_ID SB_SB_D_ID NUMBER 10 SUB_SUB_DRAINAGE_1M_ID is a system generated unique identification number.
SUB_SUB_DRAINAGE_AREA_CD SB_SB_DRND VARCHAR2 4 SUB_SUB_DRAINAGE_AREA_CD is the Water Survey of Canada sub-sub-drainage area code (WSCSSDA) that consists of two numerals and then two letters. When given a WSCSSDA code, truncating one letter gives code of the WSCSDA (subdrainage area) containing this sub-sub drainage area. Truncating both letters gives code of the WSCMDA (major drainage area) containing this sub-sub-drainage area, e.g., 05AA.
SUB_SUB_DRAINAGE_AREA_NAME SB_SB_DRNM VARCHAR2 70 SUB_SUB_DRAINAGE_AREA_NAME is the Water Survey of Canada sub-sub-drainage area English proper name (WSCSSDA_EN), e.g., Upper Oldman.
SUB_DRAINAGE_AREA_CD SB_DRNG_RD VARCHAR2 3 SUB_DRAINAGE_AREA_CD is the Water Survey of Canada sub-drainage area code (WSCSDA) that consists of two numerals and a single letter. Truncating the letter gives code of the WSCMDA (major drainage area) containing this subdrainage area, e.g., 05A.
SUB_DRAINAGE_AREA_NAME SB_DRNG_RM VARCHAR2 60 SUB_DRAINAGE_AREA_NAME is the Water Survey of Canada sub-drainage area English proper name (WSCSDA_EN), e.g., Upper South Saskatchewan.
MAJOR_DRAINAGE_AREA_CD MJR_DRNG_D VARCHAR2 2 MAJOR_DRAINAGE_AREA_CD is the Water Survey of Canada major drainage area code (WSCMDA) that consists of two numerals, e.g., 05.
MAJOR_DRAINAGE_AREA_NAME MJR_DRNG_M VARCHAR2 60 MAJOR_DRAINAGE_AREA_NAME is the Water Survey of Canada major drainage area English proper name (WSCMDA_EN), e.g., Nelson River Drainage Area.
OCEAN_DRAINAGE_AREA_NAME OCN_DRNG_M VARCHAR2 20 OCEAN_DRAINAGE_AREA_NAME is the Water Survey of Canada ocean drainage area English proper name (OCEAN_EN), e.g., Hudson Bay.
FEATURE_AREA_SQM FEAT_AREA NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters
SHAPE SHP SDO_GEOMETRY 1 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
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.