Ecoregions - Columbia Basin

181 views (2 recent)

Published by the Ministry of Environment and Climate Change Strategy - Fish and Wildlife Compensation Program
Licensed under Access Only

Ecological regions of the Columbia Basin.

Data and Resources

Dataset Extent

Latitude: 47.6° to 60.6°
Longitude: -139.1° to -110.4°

Additional Information


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

Lineage Statement


Contact Information

NameCorey Erwin (pointOfContact)
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationFish and Wildlife Compensation Program

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-15
Record Last Modified 2019-08-28
Resource Status completed

Object Description


Short Name: CBCRGNS

Column Name Short Name Data Type Data Precision Comments
ECOREGION ECOREGION VARCHAR2 3 The ecoregion 3 letter acronym
ECOPROVINCE_NAME CPRVNCNM VARCHAR2 36 The full ecoprovince name
ECODIVISION_NAME CDVSNNM VARCHAR2 36 The full ecodivision name
ECOPROVINCE CPRVNC VARCHAR2 3 The ecoprovince 3 letter acronym
ECODOMAIN ECODOMAIN VARCHAR2 3 The ecodomain 3 letter acronym
CB_ECOREGION_ID CBCRGND NUMBER 9 Generated sequence number for Columbia Basin entity CB ECOREGION
ECODIVISION CDVSN VARCHAR2 3 The ecodivision 3 letter acronym
FEATURE_CODE FTRCD VARCHAR2 10 The MOEP standard numeric code to identify the type of feature represented by the spatial data.
ECOSECTION ECOSECTION VARCHAR2 3 The ecosection 3 letter acronym
ECOREGION_NAME CRGNNM VARCHAR2 36 The full ecoregion name
ECOSECTION_NAME CSCTNNM VARCHAR2 36 The full ecosection name
ECODOMAIN_NAME CDMNNM VARCHAR2 36 The full name of the ecodomain
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_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