Bark Beetle Susceptibility Rating

590 views (12 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Resource Practices
Licensed under Access Only

Periodically, the FLNRO Forest Health program creates bark beetle susceptibility rating polygons to spruce beetle, mountain pine beetle and Douglas-fir beetle from the most current Vegetation Resource Inventory. The current dataset was created for FLNRO's Resource Practices Branch in Victoria, by the Geospatial Services group in Kamloops in March 2014. The process for creating the hazard rating model was based upon version 10 of the Shore/Safranyik susceptibility and risk rating system. The rating system describes several major susceptibility factors used to create the final hazard rating. Sources of data: Vegetation: VRI exported from the BCGW in December of 2013; Basal Area: Present in the VRI attribute table; and TRIM DEM: GIS Warehouse.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Hazard rating systems provide an objective framework for evaluating the risk of a particular pest, at the stand level, based on a series of quantifiable factors known to be correlated with stand susceptibility to bark beetle attack (also known as beetle hazard).

Data Quality

Data quality is related to the source data sets (VRI, TRIM DEM) and the accuracy of the projected stand susceptibility.

Lineage Statement

Generated in March, 2014 from 2013 VRI data.

More Information

Contact Information

NameTim Ebata (pointOfContact)
Emailtim.ebata@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationResource Practices
NameKevin Buxton (businessExpert)
EmailKevin.Buxton@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationRegional Operations - Thompson Okanagan

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2017-01-09
Record Last Modified 2019-05-04
Resource Status completed

Object Description

Object Name: WHSE_FOREST_VEGETATION.PEST_HAZARD_SVW

Short Name: PEST_HAZ

Column Name Short Name Data Type Data Precision Comments
FEATURE_ID FEATURE_ID NUMBER 38
LAYER_ID LAYER_ID VARCHAR2 10
TSA_NUMBER TSA_NUMBER VARCHAR2 2
PERCENT_DOUGLAS_FIR PRCNT_DGLR NUMBER 20
BASAL_AREA_DOUGLAS_FIR BSL_R_DGLR NUMBER 20
DFB_FACTOR_A DFB_FCTR_A NUMBER 20
DFB_FACTOR_D DFB_FCTR_D NUMBER 20
DFB_FACTOR_P DFB_FCTR_P NUMBER 20
DFB_HAZARD_RATING DFB_HZRD_G NUMBER 20
DFB_HAZARD_RANGE_1 DFB_HZR_1 VARCHAR2 10
DFB_HAZARD_CLASS_1 DFB_HZC_1 VARCHAR2 1
DFB_HAZARD_RANGE_2 DFB_HZR_2 VARCHAR2 10
DFB_HAZARD_CLASS_2 DFB_HZC_2 VARCHAR2 1
PERCENT_MOUNTAIN_PINE PRCNT_MNTE NUMBER 20
BASAL_AREA_MOUNTAIN_PINE BSL_R_MNTE NUMBER 20
MPB_FACTOR_A MPB_FCTR_A NUMBER 20
MPB_FACTOR_D MPB_FCTR_D NUMBER 20
MPB_FACTOR_L MPB_FCTR_L NUMBER 20
MPB_FACTOR_P MPB_FCTR_P NUMBER 20
MPB_HAZARD_RATING MPB_HZRD_G NUMBER 20
MPB_HAZARD_RANGE_1 MPB_HZR_1 VARCHAR2 10
MPB_HAZARD_CLASS_1 MPB_HZC_1 VARCHAR2 1
MPB_HAZARD_RANGE_2 MPB_HZR_2 VARCHAR2 10
MPB_HAZARD_CLASS_2 MPB_HZC_2 VARCHAR2 1
PERCENT_SPRUCE PRCNT_SPRE NUMBER 20
BASAL_AREA_SPRUCE BSL_R_SPRE NUMBER 20
SB_FACTOR_A SB_FCTR_A NUMBER 20
SB_FACTOR_L SB_FCTR_L NUMBER 20
SB_FACTOR_P SB_FCTR_P NUMBER 20
SB_SITE_QUALITY SB_ST_QLTY VARCHAR2 1
SB_FACTOR_Q SB_FCTR_Q NUMBER 20
SB_FACTOR_S1 SB_FCTR_S1 NUMBER 20
SB_X_VALUE SB_X_VALUE NUMBER 20
SB_Y_VALUE SB_Y_VALUE NUMBER 20
SB_Z_VALUE SB_Z_VALUE NUMBER 20
SB_FACTOR_S2 SB_FCTR_S2 NUMBER 20
SB_HAZARD_RATING SB_HZRD_RG NUMBER 20
SB_HAZARD_RANGE_1 SB_HZRD_R1 VARCHAR2 10
SB_HAZARD_CLASS_1 SB_HZRD_C1 VARCHAR2 1
SB_HAZARD_RANGE_2 SB_HZRD_R2 VARCHAR2 10
SB_HAZARD_CLASS_2 SB_HZRD_C2 VARCHAR2 1
MAP_ID MAP_ID VARCHAR2 7
POLYGON_ID POLYGON_ID NUMBER 9
OPENING_IND OPNNG_ND VARCHAR2 1
OPENING_SOURCE OPNNG_SRCE VARCHAR2 5
OPENING_NUMBER OPNNG_NMBR VARCHAR2 4
FEATURE_CLASS_SKEY FC_SKEY NUMBER 38
INVENTORY_STANDARD_CD INVNTRY_SD VARCHAR2 10
POLYGON_AREA PLYGN_RA NUMBER 15
NON_PRODUCTIVE_DESCRIPTOR_CD NPD_DS_CD VARCHAR2 5
NON_PRODUCTIVE_CD NPD_CD VARCHAR2 10
INPUT_DATE INPUT_DATE DATE 7
COAST_INTERIOR_CD CST_NTRR_D VARCHAR2 1
SURFACE_EXPRESSION SRFC_XPRSN VARCHAR2 10
MODIFYING_PROCESS MDFYNG_PRS VARCHAR2 10
SITE_POSITION_MESO ST_PSTN_MO VARCHAR2 10
ALPINE_DESIGNATION ALPN_DSGNN VARCHAR2 10
SOIL_NUTRIENT_REGIME SL_NTRNT_E VARCHAR2 10
ECOSYS_CLASS_DATA_SRC_CD ECSYS_CLSD VARCHAR2 10
BCLCS_LEVEL_1 BCLCS_LVL1 VARCHAR2 10
BCLCS_LEVEL_2 BCLCS_LVL2 VARCHAR2 10
BCLCS_LEVEL_3 BCLCS_LVL3 VARCHAR2 10
BCLCS_LEVEL_4 BCLCS_LVL4 VARCHAR2 10
BCLCS_LEVEL_5 BCLCS_LVL5 VARCHAR2 10
INTERPRETER INTRPRTR VARCHAR2 30
INTERPRETATION_DATE INTRPRTTNE DATE 7
PROJECT PROJECT VARCHAR2 100
REFERENCE_YEAR RFRNC_YR NUMBER 4
SPECIAL_CRUISE_NUMBER SPCL_CRS_R NUMBER 4
SPECIAL_CRUISE_NUMBER_CD SPCL_CRS_D VARCHAR2 1
INVENTORY_REGION INVNTRY_RN NUMBER 2
COMPARTMENT CMPRTMNT NUMBER 3
COMPARTMENT_LETTER CMPRTMNT_R VARCHAR2 1
FIZ_CD FIZ_CD VARCHAR2 1
FOR_MGMT_LAND_BASE_IND FR_MGMT_LD VARCHAR2 1
ATTRIBUTION_BASE_DATE ATTRBTN_BE DATE 7
PROJECTED_DATE PRJCTD_DTE DATE 7
SHRUB_HEIGHT SHRB_HGHT NUMBER 4
SHRUB_CROWN_CLOSURE SHRB_CRWNE NUMBER 3
SHRUB_COVER_PATTERN SHRB_CVR_N VARCHAR2 10
HERB_COVER_TYPE HRB_CVR_TE VARCHAR2 10
HERB_COVER_PATTERN HRB_CVR_PN VARCHAR2 10
HERB_COVER_PCT HRB_CVR_PT NUMBER 3
BRYOID_COVER_PCT BRYD_CVR_T NUMBER 3
NON_VEG_COVER_PATTERN_1 NVC_PTN_1 VARCHAR2 10
NON_VEG_COVER_PCT_1 NVC_PCT_1 NUMBER 3
NON_VEG_COVER_TYPE_1 NVC_TYPE_1 VARCHAR2 10
NON_VEG_COVER_PATTERN_2 NVC_PTN_2 VARCHAR2 10
NON_VEG_COVER_PCT_2 NVC_PCT_2 NUMBER 3
NON_VEG_COVER_TYPE_2 NVC_TYPE_2 VARCHAR2 10
NON_VEG_COVER_PATTERN_3 NVC_PTN_3 VARCHAR2 10
NON_VEG_COVER_PCT_3 NVC_PCT_3 NUMBER 3
NON_VEG_COVER_TYPE_3 NVC_TYPE_3 VARCHAR2 10
LAND_COVER_CLASS_CD_1 LND_CVR_C1 VARCHAR2 10
EST_COVERAGE_PCT_1 EST_CVRG_1 NUMBER 3
SOIL_MOISTURE_REGIME_1 SL_MSTR_R1 VARCHAR2 10
LAND_COVER_CLASS_CD_2 LND_CVR_C2 VARCHAR2 10
EST_COVERAGE_PCT_2 EST_CVRG_2 NUMBER 3
SOIL_MOISTURE_REGIME_2 SL_MSTR_R2 VARCHAR2 10
LAND_COVER_CLASS_CD_3 LND_CVR_C3 VARCHAR2 10
EST_COVERAGE_PCT_3 EST_CVRG_3 NUMBER 3
SOIL_MOISTURE_REGIME_3 SL_MSTR_R3 VARCHAR2 10
AVAIL_LABEL_HEIGHT AVL_LBL_HT NUMBER 38
AVAIL_LABEL_WIDTH AVL_LBL_WH NUMBER 38
FULL_LABEL FULL_LABEL VARCHAR2 1000
LABEL_CENTRE_X LBL_CNTR_X NUMBER 38
LABEL_CENTRE_Y LBL_CNTR_Y NUMBER 38
LABEL_HEIGHT LBL_HGHT NUMBER 38
LABEL_WIDTH LBL_WDTH NUMBER 38
LINE_1_OPENING_NUMBER LN_1_PNNGR VARCHAR2 4
LINE_1_OPENING_SYMBOL_CD LN_1_PNNGD VARCHAR2 1
LINE_2_POLYGON_ID LN_2_PL_ID VARCHAR2 10
LINE_3_TREE_SPECIES LN_3_TR_SS VARCHAR2 50
LINE_4_CLASSES_INDEXES LN_4_CLSSS VARCHAR2 12
LINE_5_VEGETATION_COVER LN_5_VGTTR VARCHAR2 11
LINE_6_SITE_PREP_HISTORY LN_6_ST_PY VARCHAR2 10
LINE_7_ACTIVITY_HIST_SYMBOL LN_7_CTVTL VARCHAR2 1
LINE_7A_STAND_TENDING_HISTORY LN_7_STNDY VARCHAR2 39
LINE_7B_DISTURBANCE_HISTORY LN_7B_DSTY VARCHAR2 40
LINE_8_PLANTING_HISTORY LN_8_PLNTY VARCHAR2 80
PRINTABLE_IND PRNTBL_ND VARCHAR2 1
SMALL_LABEL SMLL_LBL VARCHAR2 200
OPENING_ID OPENING_ID NUMBER 10
ORG_UNIT_NO ORG_UNITNO NUMBER 10
ORG_UNIT_CODE ORG_NT_CD VARCHAR2 6
ADJUSTED_IND ADJSTD_ND VARCHAR2 1
BEC_ZONE_CODE BC_ZN_CD VARCHAR2 4
BEC_SUBZONE BC_SBZNE VARCHAR2 3
BEC_VARIANT BC_VRNT VARCHAR2 1
BEC_PHASE BEC_PHASE VARCHAR2 1
EARLIEST_NONLOGGING_DIST_TYPE EARLY_NLDT VARCHAR2 10
EARLIEST_NONLOGGING_DIST_DATE EARLY_NLDD DATE 7
STAND_PERCENTAGE_DEAD STND_PRCND NUMBER 3
FREE_TO_GROW_IND FR_T_GRW_D VARCHAR2 1
HARVEST_DATE HRVST_DTE DATE 7
FOR_COVER_RANK_CD FR_CVR_RND VARCHAR2 10
NON_FOREST_DESCRIPTOR NN_FRST_DR VARCHAR2 10
INTERPRETED_DATA_SRC_CD INTRPRTD_D VARCHAR2 10
QUAD_DIAM_125 QD_DM_125 NUMBER 8
QUAD_DIAM_175 QD_DM_175 NUMBER 8
QUAD_DIAM_225 QD_DM_225 NUMBER 8
EST_SITE_INDEX_SPECIES_CD ESTSI_SPCD VARCHAR2 10
EST_SITE_INDEX EST_ST_NDX NUMBER 5
EST_SITE_INDEX_SOURCE_CD ESTSI_SICD VARCHAR2 10
CROWN_CLOSURE CRWN_CLSRE NUMBER 3
CROWN_CLOSURE_CLASS_CD CRWN_CLSRD VARCHAR2 2
REFERENCE_DATE RFRNC_DTE DATE 7
SITE_INDEX SITE_INDEX NUMBER 5
DBH_LIMIT DBH_LIMIT NUMBER 2
BASAL_AREA BASAL_AREA NUMBER 10
DATA_SOURCE_BASAL_AREA_CD DT_SRC_BSD VARCHAR2 10
VRI_LIVE_STEMS_PER_HA VR_LV_STMA NUMBER 8
DATA_SRC_VRI_LIVE_STEM_HA_CD DT_SRC_VRD VARCHAR2 10
VRI_DEAD_STEMS_PER_HA VR_DD_STMA NUMBER 8
TREE_COVER_PATTERN TR_CVR_PTN VARCHAR2 10
VERTICAL_COMPLEXITY VRTCL_CMPY VARCHAR2 10
SPECIES_CD_1 SPCS_CD_1 VARCHAR2 10
SPECIES_PCT_1 SPCS_PCT_1 NUMBER 5
SPECIES_CD_2 SPCS_CD_2 VARCHAR2 10
SPECIES_PCT_2 SPCS_PCT_2 NUMBER 5
SPECIES_CD_3 SPCS_CD_3 VARCHAR2 10
SPECIES_PCT_3 SPCS_PCT_3 NUMBER 5
SPECIES_CD_4 SPCS_CD_4 VARCHAR2 10
SPECIES_PCT_4 SPCS_PCT_4 NUMBER 5
SPECIES_CD_5 SPCS_CD_5 VARCHAR2 10
SPECIES_PCT_5 SPCS_PCT_5 NUMBER 5
SPECIES_CD_6 SPCS_CD_6 VARCHAR2 10
SPECIES_PCT_6 SPCS_PCT_6 NUMBER 5
PROJ_AGE_1 PROJ_AGE_1 NUMBER 4
PROJ_AGE_CLASS_CD_1 PRJ_G_CLS1 VARCHAR2 1
PROJ_AGE_2 PROJ_AGE_2 NUMBER 4
PROJ_AGE_CLASS_CD_2 PRJ_G_CLS2 VARCHAR2 1
DATA_SOURCE_AGE_CD DT_SRC_G_D VARCHAR2 10
PROJ_HEIGHT_1 PRJHT_1 NUMBER 5
PROJ_HEIGHT_CLASS_CD_1 PRJHT_CL_1 VARCHAR2 1
PROJ_HEIGHT_2 PRJHT_2 NUMBER 5
PROJ_HEIGHT_CLASS_CD_2 PRJHT_CL_2 VARCHAR2 1
DATA_SOURCE_HEIGHT_CD DT_SRC_HGD VARCHAR2 10
LIVE_VOL_PER_HA_SPP1_125 LVPHS1_125 NUMBER 8
LIVE_VOL_PER_HA_SPP1_175 LVPHS1_175 NUMBER 8
LIVE_VOL_PER_HA_SPP1_225 LVPHS1_225 NUMBER 8
LIVE_VOL_PER_HA_SPP2_125 LVPHS2_125 NUMBER 8
LIVE_VOL_PER_HA_SPP2_175 LVPHS2_175 NUMBER 8
LIVE_VOL_PER_HA_SPP2_225 LVPHS2_225 NUMBER 8
LIVE_VOL_PER_HA_SPP3_125 LVPHS3_125 NUMBER 8
LIVE_VOL_PER_HA_SPP3_175 LVPHS3_175 NUMBER 8
LIVE_VOL_PER_HA_SPP3_225 LVPHS3_225 NUMBER 8
LIVE_VOL_PER_HA_SPP4_125 LVPHS4_125 NUMBER 8
LIVE_VOL_PER_HA_SPP4_175 LVPHS4_175 NUMBER 8
LIVE_VOL_PER_HA_SPP4_225 LVPHS4_225 NUMBER 8
LIVE_VOL_PER_HA_SPP5_125 LVPHS5_125 NUMBER 8
LIVE_VOL_PER_HA_SPP5_175 LVPHS5_175 NUMBER 8
LIVE_VOL_PER_HA_SPP5_225 LVPHS5_225 NUMBER 8
LIVE_VOL_PER_HA_SPP6_125 LVPHS6_125 NUMBER 8
LIVE_VOL_PER_HA_SPP6_175 LVPHS6_175 NUMBER 8
LIVE_VOL_PER_HA_SPP6_225 LVPHS6_225 NUMBER 8
DEAD_VOL_PER_HA_SPP1_125 DVPHS1_125 NUMBER 8
DEAD_VOL_PER_HA_SPP1_175 DVPHS1_175 NUMBER 8
DEAD_VOL_PER_HA_SPP1_225 DVPHS1_225 NUMBER 8
DEAD_VOL_PER_HA_SPP2_125 DVPHS2_125 NUMBER 8
DEAD_VOL_PER_HA_SPP2_175 DVPHS2_175 NUMBER 8
DEAD_VOL_PER_HA_SPP2_225 DVPHS2_225 NUMBER 8
DEAD_VOL_PER_HA_SPP3_125 DVPHS3_125 NUMBER 8
DEAD_VOL_PER_HA_SPP3_175 DVPHS3_175 NUMBER 8
DEAD_VOL_PER_HA_SPP3_225 DVPHS3_225 NUMBER 8
DEAD_VOL_PER_HA_SPP4_125 DVPHS4_125 NUMBER 8
DEAD_VOL_PER_HA_SPP4_175 DVPHS4_175 NUMBER 8
DEAD_VOL_PER_HA_SPP4_225 DVPHS4_225 NUMBER 8
DEAD_VOL_PER_HA_SPP5_125 DVPHS5_125 NUMBER 8
DEAD_VOL_PER_HA_SPP5_175 DVPHS5_175 NUMBER 8
DEAD_VOL_PER_HA_SPP5_225 DVPHS5_225 NUMBER 8
DEAD_VOL_PER_HA_SPP6_125 DVPHS6_125 NUMBER 8
DEAD_VOL_PER_HA_SPP6_175 DVPHS6_175 NUMBER 8
DEAD_VOL_PER_HA_SPP6_225 DVPHS6_225 NUMBER 8
LIVE_STAND_VOLUME_125 LSV_125 NUMBER 8
LIVE_STAND_VOLUME_175 LSV_175 NUMBER 8
LIVE_STAND_VOLUME_225 LSV_225 NUMBER 8
DEAD_STAND_VOLUME_125 DSV_125 NUMBER 8
DEAD_STAND_VOLUME_175 DSV_175 NUMBER 8
DEAD_STAND_VOLUME_225 DSV_225 NUMBER 8
WHOLE_STEM_BIOMASS_PER_HA WHL_STM_BA NUMBER 8
BRANCH_BIOMASS_PER_HA BRNCH_BMSA NUMBER 8
FOLIAGE_BIOMASS_PER_HA FLG_BMSS_A NUMBER 8
BARK_BIOMASS_PER_HA BRK_BMSS_A NUMBER 8
ENTRY_USERID ENTRY_USER VARCHAR2 30
ENTRY_TIMESTAMP ENTRY_TMSP DATE 7
UPDATE_USERID UPDT_USER VARCHAR2 30
UPDATE_TIMESTAMP UPD_TMSP DATE 7
FEATURE_AREA_SQM FEAT_AREA NUMBER 19
FEATURE_LENGTH_M FEAT_LEN NUMBER 19
GEOMETRY GEOMETRY SDO_GEOMETRY 64
OBJECTID OBJECTID NUMBER 38
SE_ANNO_CAD_DATA ANNO_CAD BLOB 4000

Comments

No comments have been posted yet.