Freshwater Atlas 20K-50K Waterbody Cross Reference Table

372 views (4 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Open Government Licence - British Columbia

Contains all primary and secondary matches between 1:20K and 1:50K waterbody polygons. This attribute table links the new Freshwater Atlas watershed codes with the existing 1:50K Watershed Atlas watershed codes for cross reference purposes

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This attribute table can be used as a look-up table to cross reference new Freshwater Atlas watershed codes and existing 1:50K Watershed Atlas watershed codes for waterbodies.

Lineage Statement

Automated, mathematical and statistical algorithms were applied against the TRIM I stream network and the TRIM I elevation surface model.

Contact Information

NameGeoBC Inquiries (pointOfContact)
EmailGeoBCInfo@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

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

Metadata Information

Record Published 2011-03-09
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_BASEMAPPING.FWA_WATERBODIES_20K_50K

Short Name: FWWTRBDS20
Comments: Contains all primary and secondary matches between 1:20K and 1:50K waterbody polygons. This table is provided to allow users to join the 1:20K waterbody features in this dataset to the 1:50K waterbody features from the BC Watershed Atlas.

Column Name Short Name Data Type Data Precision Comments
WATERBODY_20K_50K_ID WTRBD20K50 NUMBER 18 Unique key used to identify a single mapping.
WATERSHED_GROUP_ID_20K WTRSHDGRPD NUMBER 18 An automatically generate id that uniquely identifies the watershed group feature.
WATERBODY_TYPE_20K WTRBDTP20K VARCHAR2 1 The type of waterbody. Possible values include: 'L' - lake 'R' - double lined river 'W' - wetland 'X' - manmade river or lake 'M' - land
WATERBODY_POLY_ID_20K WTRBDPLD20 NUMBER 18 The id of the 20k waterbody feature mapped by this record.
WATERBODY_KEY_20K WTRBDK20K NUMBER 10 The 20k waterbody key matched to a 50k key feature.
FWA_WATERSHED_CODE_20K FWWTRSHDCD VARCHAR2 143 The controlling route of the matched 20k waterbody.
LOCAL_WATERSHED_CODE_20K LCLWTRSHDC VARCHAR2 143 The local watershed code associated with the 20k waterbody.
WATERSHED_GROUP_CODE_20K WTRSHDGRPC VARCHAR2 4 The watershed group of the 20k waterbody feature.
WATERBODY_TYPE_50K WTRBDTP50K VARCHAR2 1 The type of waterbody from the 1:50K dataset. Possible values include: lake, double lined rive, wetland, manmade river or lake, or land
WATERBODY_KEY_50K WTRBDK50K NUMBER 10 The 50k waterbody key of the matched waterbody.
WATERSHED_GROUP_CODE_50K WTRSHDGRP1 VARCHAR2 4 The 50k watershed group code of the matched waterbody.
WATERSHED_CODE_50K WTRSHDCD50 VARCHAR2 45 The controlling route of the matched 50k waterbody.
MATCH_TYPE MATCH_TYPE VARCHAR2 7 A string identifying the type of match. One of 'Primary', indicating the best match, or 'X-Ref', indicating cross reference or secondary match.