Freshwater Atlas 20K-50K Stream Cross Reference Table

502 views (6 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 stream edges. 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.

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-02
Resource Status onGoing

Object Description

Object Name: WHSE_BASEMAPPING.FWA_STREAMS_20K_50K

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

Column Name Short Name Data Type Data Precision Comments
STREAM_20K_50K_ID STRM20K50K NUMBER 18 Unique key used to identify a single mapping.
WATERSHED_GROUP_ID_20K WTRSHDGRPD NUMBER 18
LINEAR_FEATURE_ID_20K LNRFTRD20K NUMBER 18 A unique numeric identifier used to link the arc to the database.
BLUE_LINE_KEY_20K BLLNK20K NUMBER 10 The blue line key associated with the 20k edge.
WATERSHED_KEY_20K WTRSHDK20K NUMBER 10 The watershed key associated with the 20k edge.
FWA_WATERSHED_CODE_20K FWWTRSHDCD VARCHAR2 143 The watershed code associated with the 20k edge.
WATERSHED_GROUP_CODE_20K WTRSHDGRPC VARCHAR2 4 The watershed group code associated with the 20k edge.
BLUE_LINE_KEY_50K BLLNK50K NUMBER 10 The best matched 50k blue line key.
WATERSHED_KEY_50K WTRSHDK50K NUMBER 10 The watershed key for the best matched 50k blue line key.
WATERSHED_CODE_50K WTRSHDCD50 VARCHAR2 45 The 50k watershed code of the best matched 50k blue line key.
WATERSHED_GROUP_CODE_50K WTRSHDGRP1 VARCHAR2 4 The watershed group code of the best matched 50k blue line key.
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.