Bioterrain Mapping (TBT) Detailed Polygons with Short Attribute Table Spatial View

433 views (5 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Access Only

Bioterrain (TBT) contains polygons with key and amalgamated (concatenated) attributes derived from the RISC (Resource Inventory Standards Committee) standard attributes. TBT divides the landscape into units using the Terrain Classification System for British Columbia and ecological criteria. Polygon attributes include (but are not limited to) surficial material, surface expression, geomorphological processes, drainage class and aspect. TBT methods include manual air photo interpretation supported by selective field checking. Bioterrain mapping is integral to ecosystem mapping and its derivative products. 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

To provide a spatial index to Terrain mapping projects and to facilitate appropriate use of Terrain mapping for resource management planning and decision making. This dataset should be used and interpreted in consultation with a qualified terrain professional.

Lineage Statement

Varies between projects. Data is from individual inventories conducted across the province from 1970 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

NameTerrestrial Ecosystem Information (TEI) Contact (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 2014-12-11
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_TERRESTRIAL_ECOLOGY.STE_TER_BIOTERRAIN_POLYS_SVW

Short Name: STTRBTRRNP
Comments: STE_TER_BIOTERRAIN_POLYS_SVW contains Bioterrain (TBT) polygons with key and amalgamated (concatenated) attributes derived from the RISC (Resource Inventory Standards Committee) standard attributes. TBT divides the landscape into units using the Terrain Classification System for British Columbia and ecological criteria. Polygon attributes include (but are not limited to) surficial material, surface expression, geomorphological processes, drainage class and aspect. TBT methods include manual air photo interpretation supported by selective field checking. Bioterrain mapping is integral to ecosystem mapping and its derivative products. 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.
ECOSYSTEM_LBL_CPNT_1 CSSTMLBLCP VARCHAR2 26 ECOSYSTEM LBL CPNT 1 (aka ECOLBL_1) contains a string of numeric and character codes representing the ecosystem label for ecosystem component 1. This field is a concatenation of polygon attributes from the RISC Long Table including decile, ecosystem unit, site modifier, structural stage, stand composition and seral community codes. For example: 10CD[08]ac3bM:sa.
ECOSYSTEM_LBL_CPNT_2 CSSTMLBLC1 VARCHAR2 26 ECOSYSTEM LBL CPNT 2 (aka ECOLBL_2) contains a string of numeric and character codes representing the ecosystem label for ecosystem component 2. This field is a concatenation of polygon attributes from the RISC Long Table including decile, ecosystem unit, site modifier, structural stage, stand composition and seral community codes. For example: For example: 5DS[07]g3B:sa.
ECOSYSTEM_LBL_CPNT_3 CSSTMLBLC2 VARCHAR2 26 ECOSYSTEM LBL CPNT 3 (aka ECOLBL_3) contains a string of numeric and character codes representing the ecosystem label for ecosystem component 3. This field is a concatenation of polygon attributes from the RISC Long Table including decile, ecosystem unit, site modifier, structural stage, stand composition and seral community codes. For example: 2CF[00]2b.
TERRAIN_POLYGON_LBL TRRNPLGNLB VARCHAR2 85 TERRAIN POLYGON LBL (aka TER_LBL) contains a string of characters representing the full terrain label including surficial material texture, surficial material, and surface expression codes for the surface and subsurface of all three terrain components and the geomorphological process codes for the polygon. This field is a concatenation of polygon attributes from the RISC Long Table. For example: 6xsCv[Rs]3Mv[Ru]1sraC(I)b[Ru]-R""sVAw and F(A)fp.
TERRAIN_CPNT_1_DECILE TRRNCPNT1D NUMBER 2 TERRAIN CPNT 1 DECILE (aka TDEC_1) contains a number from 4-10 indicating the proportion of the polygon covered by terrain component 1. Enter zero (0) when not recorded. For example: 5.
FIRST_TERRAIN_LBL FRSTTRRNLB VARCHAR2 11 FIRST TERRAIN LBL (aka TERLBL_1A) contains a string of characters representing the terrain label for the surface layer of terrain component 1. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: xsCv.
FIRST_SUBSURFACE_TERRAIN_LBL FRSTSBSRFC VARCHAR2 10 FIRST SUBSURFACE TERRAIN LBL (aka TERLBL_1B) contains a string of characters representing the terrain label for the subsurface layer of terrain component 1. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: Rs.
FIRST_LBL_BEDROCK_TYPE FRSTLBLBDR VARCHAR2 2 FIRST LBL BEDROCK TYPE (aka BEDROCK_1) contains a code indicating the type of bedrock in terrain component 1. (This is only applicable where surface or subsurface material is of origin type 'R'). The intent of using the bedrock code is to provide auxiliary information, to help qualify texture and/or terrain stability information. It is not intended to provide bedrock stratigraphy.
TERRAIN_CPNT_2_DECILE TRRNCPNT2D NUMBER 2 TERRAIN CPNT 2 DECILE (aka TDEC_2) contains a number from 0-5 indicating the proportion of the polygon covered by terrain component 2. For example: .
SCND_TERRAIN_LBL SCNDTRRNLB VARCHAR2 11 SCND TERRAIN LBL (aka TERLBL_2A) contains a string of characters representing the terrain label for the surface layer of terrain component 2. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: Mv.
SCND_SUBSURFACE_TERRAIN_LBL SCNDSBSRFC VARCHAR2 10 SCND SUBSURFACE TERRAIN LBL (aka TERLBL_2B) contains a string of characters representing the terrain label for the subsurface layer of terrain component 2. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: Rs.
SCND_LBL_BEDROCK_TYPE SCNDLBLBDR VARCHAR2 2 SCND LBL BEDROCK TYPE (aka BEDROCK_2) contains a code indicating the type of bedrock in terrain component 2. (This is only applicable where surface or subsurface material is of origin type 'R'). The intent of using the bedrock code is to provide auxiliary information, to help qualify texture and/or terrain stability information. It is not intended to provide bedrock stratigraphy.
TERRAIN_CPNT_3_DECILE TRRNCPNT3D NUMBER 2 TERRAIN CPNT 3 DECILE (aka TDEC_3) contains a number from 0-3 indicating the proportion of the polygon covered by terrain component 3. For example: .
THIRD_TERRAIN_LBL THRDTRRNLB VARCHAR2 11 THIRD TERRAIN LBL (aka TERLBL_3A) contains a string of characters representing the terrain label for the surface layer of terrain component 3. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: sraC(I)b.
THIRD_SUBSURFACE_TERRAIN_LBL THRDSBSRFC VARCHAR2 10 THIRD SUBSURFACE TERRAIN LBL (aka TERLBL_3B) contains a string of characters representing the terrain label for the subsurface layer of terrain component 3. This field is a concatenation of polygon attributes from the RISC Long Table including surficial material texture, surficial material and surface expression codes. For example: Ru.
THIRD_LBL_BEDROCK_TYPE THRDLBLBDR VARCHAR2 2 THIRD LBL BEDROCK TYPE (aka BEDROCK_3) contains a code indicating the type of bedrock in terrain component 3. (This is only applicable where surface or subsurface material is of origin type 'R'). The intent of using the bedrock code is to provide auxiliary information, to help qualify texture and/or terrain stability information. It is not intended to provide bedrock stratigraphy.
GEOMORPH_PROCESS_LBL GMRPHPRCSS VARCHAR2 21 GEOMORPH PROCESS LBL (aka GEOP_LBL) contains a string of characters representing the geomorphological processes and subclasses that affect terrain within the polygon. For example: R""sVAw.
DRAINAGE_LBL DRNGLBL VARCHAR2 14 DRAINAGE LBL (aka DRAIN_LBL) contains a string of character codes indicating soil drainage class(es) of the terrain polygon. Soil drainage refers to the rapidity and extent of water removal from the soil in relation to additions. For example: w-i.
SLOPE_RANGE_LBL SLPRNGLBL VARCHAR2 15 SLOPE RANGE LBL (aka SLOPE_LBL) contains a string of numeric and character codes indicating the typical or range of slopes in percent [i.e., rise/run*100] within the terrain polygon. For example: 40-50.
SLOPE_STABILITY_CLASS_W_ROADS SLPSTBLTC1 VARCHAR2 4 SLOPE STABILITY CLASS W ROADS (aka SLPSTBCLSR) contains roman numerals and/or an upper-case letter code representing a class of slope stability for the terrain polygon and may include a road qualifier code. Stability criteria are project specific.
SURFACE_EROSION_POT_CLASS SRFCRSNPTC VARCHAR2 2 SURFACE EROSION POT CLASS (aka SFCERO_POT) contains 1-2 upper-case letter codes indicating the surface erosion potential class for the terrain polygon. A class which indicates the likelihood of soil erosion on bare or disturbed soil after logging or road construction (e.g. from ditches or cutbanks). Surface erosion refers to the removal of soil, particle by particle, by surface runoff. Erosion potential criteria are project specific.
LNDSLDE_IND_STRM_SDMNTN_CLASS LNDSLDNDST NUMBER 1 LNDSLDE IND STRM SDMNTN CLASS (aka LSSED_CLS) contains a numeric code indicating the likelihood of landslide-induced stream sedimentation for the terrain polygon. Stream sedimentation criteria are project specific.
SURFACE_EROSION_SDMNTN_CLS SRFCRSNSDM VARCHAR2 2 SURFACE EROSION SDMNTN CLS (aka SESED_CLS) contains a 1-2 lower-case letter code indicating the likelihood of stream sedimentation due to surface erosion for the terrain polygon. Erosion sedimentation criteria are project specific.
SLOPE_STABILITY_CLASS_TXT SLPSTBLTCL VARCHAR2 40 SLOPE STABILITY CLASS TXT (aka SSC_TXT) contains a text description of the terrain stability class for the terrain polygon. Stability criteria are project specific. For example: I, II, III, IV, IVR, V, U, P, or S.
SURFACE_EROSION_POT_CLASS_TXT SRFCRSNPT1 VARCHAR2 20 SURFACE EROSION POT CLASS TXT (aka SEP_TXT) contains a text description of surface erosion potential class for the terrain polygon. A class which indicates the likelihood of soil erosion on bare or disturbed soil after logging or road construction (e.g. from ditches or cutbanks). Surface erosion refers to the removal of soil, particle by particle, by surface runoff. Erosion potential criteria are project specific. For example: VL, L, M, H, or VH.
LNDSLDE_IND_STRM_SDMNTN_TXT LNDSLDNDS1 VARCHAR2 10 LNDSLDE IND STRM SDMNTN TXT (aka LISSC_TXT) contains a text description of the likelihood of landslide-induced stream sedimentation for the terrain polygon. Stream sedimentation criteria are project specific. For example: 1, 2, or 3.
SURFACE_EROSION_SDMNTN_TXT SRFCRSNSD1 VARCHAR2 20 SURFACE EROSION SDMNTN TXT (aka SESC_TXT) contains a text description of the likelihood of stream sedimentation due to surface erosion for the terrain polygon. Erosion sedimentation criteria are project specific. For example: vl, l, m, h, or vh.
POLYGON_TEXTURE_CLASS PLGNTXTRCL VARCHAR2 4 POLYGON TEXTURE CLASS (aka POLY_ TEX) contains character codes representing the generalized texture class of the dominant surficial material for the terrain polygon. Used for ecosystem mapping and modeling (e.g. Predicitive Ecosystem Mapping). For example: c, f, m, VF, F, M, C, VC, CL, VFC, W, hc, c, cl, sicl.
POLYGON_THICKNESS_CLASS PLGNTHCKNS VARCHAR2 3 POLYGON THICKNESS CLASS (aka POLY_THK) contains character codes representing the interpreted thickness of the surficial material(s) in the terrain polygon. Used for ecosystem mapping and modeling (e.g. Predicitive Ecosystem Mapping). For example: A, B, C, D, N, d, p, s, v, d, 1, 2, 3, 4.
DOMINANT_SURFICIAL_MATERIAL DMNNTSRFCL VARCHAR2 50 DOMINANT SURFICIAL MATERIAL (aka SURFM_DOM) contains a text string indicating the dominant surficial material for the terrain polygon. For example: Morainal.
FIELD_CHECK_OF_POLYGON FLDCHCKFPL VARCHAR2 1 FIELD CHECK OF POLYGON (aka SMPL_TYPE) contains a letter code indicating the level of field checking done on the current polygon. For example: d, r, or v.
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 FEAT_AREA NUMBER 19
FEATURE_LENGTH_M FEAT_LEN 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