Sensitive Ecosystems Inventory (SEI) Detailed Polygons with Short Attribute Table Spatial View

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Open Government License - British Columbia

SEI_Polygons contains Sensitive Ecosystems Inventory polygons with key and amalgamated (concatenated) attributes derived from the RISC (Resource Inventory Standards Committee) standard attributes. SEI identifies and maps rare and fragile terrestrial ecosystems. Ecosystems mapped may include (but are not limited to) older forests, woodlands, coastal bluffs, herbaceous and sparsely vegetated ecosystems, grasslands, riparian ecosystems and wetlands. SEI methods include manual air photo interpretation or theming of other Ecosystem Mapping, each supported by selective field checking. This layer is derived from the STE_TEI_ATTRIBUTE_POLYS_SP layer by filtering on the PROJECT_TYPE attribute.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The purpose of a Sensitive Ecosystems Inventory (SEI) is to identify remnants of rare and fragile terrestrial ecosystems and to encourage land-use decisions that will ensure the continued integrity of these ecosystems. SEI is intended for use in a variety of land-use planning processes particularly at the regional district and municipal level. SEI polygon attributes provide scientific information about ecosystems and site conditions. The mapping should be used to flag potentially sensitive areas; detailed site specific evaluation is required before any land development decisions are made.

Data Quality
Lineage Statement

Varies between projects. Data is from individual inventories conducted across the province from the early 1990s to present. Some projects have undergone several phases of data conversion including different data formats (e.g., DGN to ArcInfo to Geodatabase) and different vintages of inventory standards.

More Information

Contact Information

NameJo-Anne Stacey (businessExpert)
EmailJoanne.Stacey@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems
NameTerrestrial Ecosystem Information (TEI) Mailbox (pointOfContact)
EmailTEI_Mail@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 2011-03-09
Record Last Modified 2017-04-12
Resource Status onGoing

Object Description

Object Name: WHSE_TERRESTRIAL_ECOLOGY.STE_SEI_ATTRIBUTE_POLYS_SVW

Short Name: STSTTRBTPL
Comments: STE_SEI_ATTRIBUTE_POLYS_SVW contains Sensitive Ecosystems Inventory (SEI) polygons with key and amalgamated (concatenated) attributes derived from the RISC (Resource Inventory Standards Committee) standard attributes. SEI identifies and maps rare and fragile terrestrial ecosystems. Ecosystems mapped may include (but are not limited to) older forests, woodlands, coastal bluffs, herbaceous and sparsely vegetated ecosystems, grasslands, riparian ecosystems and wetlands. SEI methods include manual air photo interpretation or theming of other Ecosystem Mapping, supported by selective field checking. This layer is derived from the STE_TEI_ATTRIBUTE_POLYS_SP layer by filtering on the PROJECT_TYPE attribute.

Column Name Short Name Data Type Data Precision Comments
TEIS_ID TEIS_ID NUMBER 10 TEIS ID (aka TEIS_ID) contains the unique identifier (PK) for the TEIS Polygon Attributes detailed geometry. This key may change between snapshots of the database. For example: TBT_4741_082M066_124975.
PROJECT_POLYGON_IDENTIFIER PRJCTPLGND VARCHAR2 50 PROJECT POLYGON IDENTIFIER (aka PROJPOLYID) contains a polygon identifier for linking attribute data to spatial data for TER, TEM, PEM and SEI data. It is not provincially unique. This field can be used for linking foreign key data (user defined fields, report references, etc.). It contains the attribute previously known as TER_TAG and ECP_TAG. For example: 12345, X17YK4.
BUSINESS_AREA_PROJECT_ID BSNSSRPRJC NUMBER 5 BUSINESS AREA PROJECT ID (aka BAPID) contains a numeric project identifier assigned by the Ministry of Environment, Ecosystem Information Section. The project BAPID is used to identify all information relating to a project and is the unique identifier (PK) for the project and is the linking key used to join or relate other TEIS data sets such as the TEIS Polygon Attribute. For example: 1234.
MODIFICATION_DATE MDFCTNDT DATE 7 MODIFICATION DATE (aka MOD_DATE) contains the year, month and day that the attribute data or the corresponding spatial data (i.e. polygon boundaries) for the given data record was last altered in any way. For example: 3/28/2001.
PROJECT_TYPE PRJCTTP VARCHAR2 9 PROJECT TYPE (aka PROJ_TYPE) contains a 3-9 letter code indicating the specific type of mapping and attributes gathered for the project. For example: TEM, PEM, SEI, TIM, TSM, TBT, TEMSEI, TEMNSS and PRETEM.
PROJECT_NAME PRJCTNM VARCHAR2 100 PROJECTNAME (aka PROJ_NAME) contains the common name of the project, usually a well known local place or feature. For example: Penticton Cr, and Kelowna South Slopes.
PROJECT_MAP_SCALE PRJCTMPSCL NUMBER 10 PROJECT MAP SCALE (aka PROJ_SCALE) contains the scale of the project maps produced. For example: 10000, 20000, 50000, and 100000.
ECOSECTION_LABEL CSCTNLBL VARCHAR2 3 ECOSECTION_LABEL (aka ECO_SEC) contains the three-letter code for the Ecosection in which the polygon occurs. For example: SOK, NKM.
BIOGEOCLIMATIC_LBL BGCLMTCLBL VARCHAR2 10 BIOGEOCLIMATIC LBL (aka BGC_LBL) contains a string of numeric and character codes indicating the Biogeoclimatic unit in which the polygon occurs. This field is a concatenation of polygon attributes from the RISC Long Table including Biogeoclimatic zone, subzone, variant and phase. For example: ESSFwcp2a.
SNSTVE_ECOSYSTEM_LBL_CPNT_1 SNSTVCSST3 VARCHAR2 7 SNSTVE ECOSYSTEM LBL CPNT 1 (aka SEILBL_1) contains a string of numeric and character codes representing the sensitive ecosystem label for SEI component 1. This field is a concatenation of polygon attributes from the RISC Long Table including decile, sensitive ecosystem class and subclass codes. For example: 10MF:co.
ECOSYSTEM_DECILE_CPNT_1 CSSTMDCLCP NUMBER 38 ECOSYSTEM DECILE CPNT 1 (aka SDEC_1) contains a number from 4-10 indicating the proportion of the polygon covered by ecosystem component 1. Enter zero (0) when not recorded. For example: 10.
SNSTVE_ECOSYSTEM_CLASS_CPNT_1 SNSTVCSSTM VARCHAR2 2 SNSTVE_ECOSYSTEM_CLASS_CPNT_1 (aka SECL_1) contains a string of upper case character codes indicating the sensitive ecosystem class for SEI component 1. SEI classes group ecosystems based on similar disturbance sensitivity or at-risk status. For example: WN.
SNSTVE_ECOSYSTEM_SUBCLS_CPNT_1 SNSTVCSST6 VARCHAR2 2 SNSTVE_ECOSYSTEM_SUBCLS_CPNT_1 (aka SESUBCL_1) contains a string of lower case character codes indicating the sensitive ecosystem subclass for SEI component 1. Subclasses further define the ecosystem class based on ecological criteria. For example: sw.
SITE_SERIES_MAP_CDE_LBL_CPNT_1 STSRSMPCDL VARCHAR2 11 SITE SERIES MAP CDE LBL CPNT 1 (aka SITEMCLBL1) contains a string of character codes indicating the type of plant community present in ecosystem component 1. This field is a concatenation of polygon attributes from the RISC Long Table including site series mapcodes and seral community types. Codes are unique within individual Biogeoclimatic subzones and variants. For example: DS:sa.
STRUCTURAL_STAGE_LBL_CPNT_1 STRCTRLSTG VARCHAR2 3 STRUCTURAL STAGE LBL CPNT 1 (aka STRCTLBL_1) contains a string of numeric and character codes indicating the structure and composition of the vegetation cover for ecosystem component 1. This field is a concatenation of polygon attributes from the RISC Long Table including structural stage and stand composition codes. For example: 7mC.
CONDITION_CPNT_1 CNDTNCPNT1 VARCHAR2 1 CONDITION CPNT 1 (aka COND_1) contains a single numeric code indicating the condition of the sensitive ecosystem in SEI component 1. Condition is an integrated measure of the quality of biotic and abiotic factors, structures, and processes within the ecosystem and the degree to which they affect the continued existence of the ecosystem. For example: 2.
VIABILITY_CPNT_1 VBLTCPNT1 VARCHAR2 1 VIABILITY CPNT 1 (aka VIAB_1) contains a single numeric code indicating the probability the sensitive ecosystem for SEI component 1 will persist based on its size, condition, and landscape context. For example: 3.
SNSTVE_ECOSYSTEM_LBL_CPNT_2 SNSTVCSST4 VARCHAR2 7 SNSTVE ECOSYSTEM LBL CPNT 2 (aka SEILBL_2) contains a string of numeric and character codes representing the sensitive ecosystem label for SEI component 2. This field is a concatenation of polygon attributes from the RISC Long Table including decile, sensitive ecosystem class and subclass codes. For example: 5WN:sp.
ECOSYSTEM_DECILE_CPNT_2 CSSTMDCLC1 NUMBER 38 ECOSYSTEM DECILE CPNT 2 (aka SDEC_2) contains a number from 0-5 indicating the proportion of the polygon covered by ecosystem component 2. Enter zero (0) when not recorded. For example: 4.
SNSTVE_ECOSYSTEM_CLASS_CPNT_2 SNSTVCSST1 VARCHAR2 2 SNSTVE_ECOSYSTEM_CLASS_CPNT_2 (aka SECL_2) contains a string of upper case character codes indicating the sensitive ecosystem class for SEI component 2. SEI classes group ecosystems based on similar disturbance sensitivity or at-risk status. For example: WN.
SNSTVE_ECOSYSTEM_SUBCLS_CPNT_2 SNSTVCSST7 VARCHAR2 2 SNSTVE_ECOSYSTEM_SUBCLS_CPNT_2 (aka SESUBCL_2) contains a string of lower case character codes indicating the sensitive ecosystem subclass for SEI component 2. Subclasses further define the ecosystem class based on ecological criteria. For example: MF.
SITE_SERIES_MAP_CDE_LBL_CPNT_2 STSRSMPCD1 VARCHAR2 11 SITE SERIES MAP CDE LBL CPNT 2 (aka SITEMCLBL2) contains a string of character codes indicating the type of plant community present in ecosystem component 2. This field is a concatenation of polygon attributes from the RISC Long Table including site series mapcodes and seral community types. Codes are unique within individual Biogeoclimatic subzones and variants. For example: GRsa1:sa
STRUCTURAL_STAGE_LBL_CPNT_2 STRCTRLST1 VARCHAR2 3 STRUCTURAL STAGE LBL CPNT 2 (aka STRCTLBL_2) contains a string of numeric and character codes indicating the structure and composition of the vegetation cover for ecosystem component 2. This field is a concatenation of polygon attributes from the RISC Long Table including structural stage and stand composition codes. For example: 3bM.
CONDITION_CPNT_2 CNDTNCPNT2 VARCHAR2 1 CONDITION CPNT 2 (aka COND_2) contains a single numeric code indicating the condition of the sensitive ecosystem in SEI component 2. Condition is an integrated measure of the quality of biotic and abiotic factors, structures, and processes within the ecosystem and the degree to which they affect the continued existence of the ecosystem. For example: 2.
VIABILITY_CPNT_2 VBLTCPNT2 VARCHAR2 1 VIABILITY CPNT 2 (aka VIAB_2) contains a single numeric code indicating the probability the sensitive ecosystem for SEI component 2 will persist based on its size, condition, and landscape context. For example: 3.
SNSTVE_ECOSYSTEM_LBL_CPNT_3 SNSTVCSST5 VARCHAR2 7 SNSTVE ECOSYSTEM LBL CPNT 3 (aka SEILBL_3) contains a string of numeric and character codes representing the sensitive ecosystem label for SEI component 3. This field is a concatenation of polygon attributes from the RISC Long Table including decile, sensitive ecosystem class and subclass codes. For example: WN:sp.
ECOSYSTEM_DECILE_CPNT_3 CSSTMDCLC2 NUMBER 38 ECOSYSTEM DECILE CPNT 3 (aka SDEC_3) contains a number from 4-10 indicating the proportion of the polygon covered by ecosystem component 3. Enter zero (0) when not recorded. For example: 0.
SNSTVE_ECOSYSTEM_CLASS_CPNT_3 SNSTVCSST2 VARCHAR2 2 SNSTVE ECOSYSTEM CLASS CPNT 3 (aka SECL_3) contains a string of upper case character codes indicating the sensitive ecosystem class for SEI component 3. SEI classes group ecosystems based on similar disturbance sensitivity or at-risk status. For example: WN.
SNSTVE_ECOSYSTEM_SUBCLS_CPNT_3 SNSTVCSST8 VARCHAR2 2 SNSTVE ECOSYSTEM SUBCLS CPNT 3 (aka SESUBCL_3) contains a string of lower case character codes indicating the sensitive ecosystem subclass for SEI component 3. Subclasses further define the ecosystem class based on ecological criteria. For example: WN:sp.
SITE_SERIES_MAP_CDE_LBL_CPNT_3 STSRSMPCD2 VARCHAR2 11 SITE SERIES MAP CDE LBL CPNT 3 (aka SITEMCLBL3) contains a string of character codes indicating the type of plant community present in ecosystem component 3. This field is a concatenation of polygon attributes from the RISC Long Table including site series mapcodes and seral community types. Codes are unique within individual Biogeoclimatic subzones and variants. For example: GRsa1:sa
STRUCTURAL_STAGE_LBL_CPNT_3 STRCTRLST2 VARCHAR2 3 STRUCTURAL STAGE LBL CPNT 3 (aka STRCTLBL_3) contains a string of numeric and character codes indicating the structure and composition of the vegetation cover for ecosystem component 3. This field is a concatenation of polygon attributes from the RISC Long Table including structural stage and stand composition codes. For example: 7mC.
CONDITION_CPNT_3 CNDTNCPNT3 VARCHAR2 1 CONDITION CPNT 3 (aka COND_3) contains a single numeric code indicating the condition of the sensitive ecosystem in SEI component 3. Condition is an integrated measure of the quality of biotic and abiotic factors, structures, and processes within the ecosystem and the degree to which they affect the continued existence of the ecosystem. For example: 2.
VIABILITY_CPNT_3 VBLTCPNT3 VARCHAR2 1 VIABILITY CPNT 3 (aka VIAB_3) contains a single numeric code indicating the probability the sensitive ecosystem for SEI component 3 will persist based on its size, condition, and landscape context. For example: 3.
THEME_DISPLAY_1 THMDSPL1 VARCHAR2 20 THEME DISPLAY 1 (aka THEME_1) is a field created to hold an alphanumeric code representing a theme derived from terrain and ecosystem attribute(s). For example: low.
THEME_DISPLAY_2 THMDSPL2 VARCHAR2 20 THEME DISPLAY 2 (aka THEME_2) is a field created to hold an alphanumeric code representing a theme derived from terrain and ecosystem attribute(s). For example: 123.
THEME_DISPLAY_3 THMDSPL3 VARCHAR2 20 THEME DISPLAY 3 (aka THEME_3) is a field created to hold an alphanumeric code representing a theme derived from terrain and ecosystem attribute(s). For example: poor condition.
POLYGON_COMMENTS PLGNCMMNTS VARCHAR2 254 POLYGON COMMENTS (aka POLY_COM) contains notes or comments for the polygon. For example: The polygon contained a salt lick at the southeast end, near the pond; Original Project: FRBC_3b.
MAP_LEGEND_DESCRIPTION MPLGNDDSCR VARCHAR2 140 MAP LEGEND DESCRIPTION (aka LEGEND_COM) contains a description of the generic map legend found at MAP LEGEND DATA DOWNLOAD LINK (MAP_LEG). For example: Information on how to interpret terrain labels is available at the following site.
MAP_LEGEND_DATA_DOWNLOAD_LINK MPLGNDDTDW VARCHAR2 100 MAP LEGEND DATA DOWNLOAD LINK (aka LEGEND_URL) contains the URL for the website or FTP site where the generic map legend is available. For example: http://a100.gov.bc.ca/pub/acat/public/viewReport.do?reportId=1531.
POLYGON_STABILITY_CLASS_TYPE PLGNSTBLTC VARCHAR2 1 POLYGON STABILITY CLASS TYPE (aka PSTBCLS_TP) contains a one character code indicating the classification system used to classify slope stability for the polygon. For example: R (Reconnaissance), D (Detailed), or E (Es).
ERROR_SUMMARY RRRSMMR VARCHAR2 500 ERROR SUMMARY (aka ERROR_SUM) contains a list of attribute code and geometry errors found by automated data quality control tools including errors relating to invalid codes, values outside a valid range, cross field (paired attribute) rules, and geometry. Erroneous attribute entries are in ().
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE CODE (aka FEATURE CODE, FCODE) contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
FEATURE_AREA_SQM NUMBER 19
FEATURE_LENGTH_M NUMBER 19
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000

Comments

No comments have been posted yet.