Pest Infestation Overview (Generalized)

308 views (7 recent)

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

PEST_INFESTATION_OVERVIEW_POLY is a generalized version of PEST_INFESTATION_POLY for viewing and presentation purposes. For download please refer to WHSE_FOREST_VEGETATION.PEST_INFESTATION_POLY

Data and Resources

Dataset Extent

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

Additional Information


Non-analytical analysis and viewing

Data Quality

See description for Pest_infestation_points and Pest_infestation_polygons

Lineage Statement

Data originates from the Canadian Forest Services' Forest Insect and Disease survey (FIDS) from 1907 to 1996. From 1999 to the present, all data has been collect by the province.

More Information

Contact Information

NameTim Ebata (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationResource Practices

Access & Security

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

Metadata Information

Record Published 2014-12-15
Record Last Modified 2019-12-17
Resource Status onGoing

Object Description


Comments: PEST_INFESTATION_OVERVIEW_POLY is a generalized version of the PEST_INFESTATION_POLY. The main purpose of the generalization is to be able to display the site infestation as an overview at higher scales. Feature type : polygon multipart.

Column Name Short Name Data Type Data Precision Comments
POLYGON_NUMBER POLY_NUM NUMBER 12 POLYGON_NUMBER: A unique number that is assigned to an infestation area by the business.
PEST_SEVERITY_CODE PST_SEV_CD VARCHAR2 3 PEST_SEVERITY_CODE: The acronym used to identify pest severity. i.e. T(race), (L)ight, (M)oderate, (S)evere, (V)ery Severe.
PEST_SEVERITY_DESC PST_SEV_DS VARCHAR2 16 PEST_SEVERITY_DESC: The full length pest severity description. i.e. Trace, Light, Moderate, Severe, Very Severe.
PEST_SPECIES_CODE PST_SPC_CD VARCHAR2 16 PEST_SPECIES_CODE: The code used to identify the pest, e.g. I, DR, DM, IBM.
PEST_SPECIES_COMMON_NAME PST_CMN_NM VARCHAR2 75 PEST_SPECIES_COMMON_NAME: The full common name of the identified pest, e.g. insects, root disease, dwarf mistletoe, mountain pine beetle.
PEST_SPECIES_LATIN_NAME PST_LTN_NM VARCHAR2 75 PEST_SPECIES_LATIN_NAME: The full latin genus and species name (for biotic pests only) of the pest, e.g. Dendroctonus ponderosae, Arceuthobium douglasii.
PEST_CAPTURE_METHOD_CODE PST_CM_CD VARCHAR2 3 PEST_CAPTURE_METHOD_CODE: A code that describes the survey method used to capture the data, e.g. OS, DS, FR, VL.
PEST_CAPTURE_METHOD_DESC PST_CM_DS VARCHAR2 40 PEST_CAPTURE_METHOD_DESC: A full description of the survey method used to capture the data, e.g. Overview Survey Fixed Wing; Detailed Survey, FIDS Report, Vernon Labs, Walkthrough Survey.
CAPTURE_YEAR CPTR_YR NUMBER 4 CAPTURE_YEAR: The calendar year when the data was captured.
AREA_HA AREA_HA NUMBER 14 AREA_HA: The area of the polygon in Hectares.
ORG_UNIT_NO ORG_UNITNO NUMBER 10 ORG_UNIT_NO: Unique physical identifier for the storage of organizational unit codes. Values stored here are for the computer's use only.
TREE_SPECIES_CODE TR_SPCS_CD VARCHAR2 3 TREE_SPECIES_CODE: The code used to describe the host tree species that has been infested by the pest, e.g. PL, FDI.
TREE_SPECIES_COMMON_NAME TR_CM_NM VARCHAR2 75 TREE_SPECIES_COMMON_NAME: The full common name of the host tree species that has been infested by the pest, e.g. Lodgepole Pine, Interior Douglas Fir.
COMMENTS COMMENTS VARCHAR2 256 COMMENTS: A text string column used to record general comments recorded during the surveys, often used to describe additional damage symptoms or patterns that are not adequately captured by the available coding.
FEATURE_AREA_SQM AREA_SQM 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.
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 column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
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.