FWCP Columbia Basin Dam Units

229 views (5 recent)

Published by the Ministry of Environment and Climate Change Strategy - Fish and Wildlife Compensation Program
Licensed under Open Government Licence - British Columbia

Units dividing the Columbia Basin in to BC Hydro reservoir-based watersheds

Data and Resources

Dataset Extent

Latitude: 48.4° to 53.0°
Longitude: -120.5° to -113.4°

Additional Information

Purpose

To improve conservation planning in the Columbia Basin by providing science-based information about biodiversity to a broad range of audiences.

Contact Information

NameAmy Waterhouse (pointOfContact)
EmailAmy.Waterhouse@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationFish and Wildlife Compensation Program
NameJohn Krebs (pointOfContact)
EmailJohn.Krebs@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationFish and Wildlife Compensation Program

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 completed

Object Description

Object Name: REG_LAND_AND_NATURAL_RESOURCE.FWCP_COLUMBIA_BSN_DAM_UNT_POLY

Short Name: F_CBDU_P

Column Name Short Name Data Type Data Precision Comments
DAM_UNIT_ID DAM_UNT_ID NUMBER 5
HYDROGRAPHIC_EXTENT REACH_NAME VARCHAR2 50
DAM_UNIT_CODE DAMUNIT_CD VARCHAR2 3
RESERVOIR_NAME RESERVOIR VARCHAR2 20
BCHYDRO_DAM_CODE BCHYDRO_CD VARCHAR2 3
FEATURE_CODE FCODE VARCHAR2 10
GEOMETRY SHAPE 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_AREA_SQM NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters