VRI - Forest Vegetation Composite Polygons and Dead Layer

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

Geospatial forest inventory dataset updated for depletions, such as harvesting, and projected annually for growth. Sample attributes in this dataset include: age, species, volume, height.

The Vegetation Resources Inventory (VRI) determines both where a resource is located and how much of a given vegetation resource (for example, timber or coarse woody debris) is within an inventory unit.

This data was and can be derived from the following available datasets: VEG_COMP_POLY and VEG_COMP_LAYER

Data and Resources

Dataset Extent

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

Additional Information

Purpose

This layer tracks the endemic due to natural disturbances such as Mountain Pine Beetle

Data Quality
Lineage Statement

Contact Information

NameMarc Rousseau (pointOfContact)
EmailMarc.Rousseau@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationForest Analysis and Inventory

Access & Security

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

Metadata Information

Record Published 2017-02-06
Record Last Modified 2017-02-06
Resource Status onGoing

Object Description

Object Name: WHSE_FOREST_VEGETATION.VEG_COMP_LYR_D_POLY

Comments: This instantiated table is a join between VEG_COMP_POLY and VEG_COMP_LYR_D_VW on FEATURE_ID.

Column Name Short Name Data Type Data Precision Comments
FEATURE_ID NUMBER 38 Provincially unique identifier for an instance of a spatial feature.
MAP_ID VARCHAR2 7 Identifies the Forest Cover Map corresponding to the FIP file. It is the British Columbia Geographic System"s (BCGS) Key Reference Number of the Forest Cover Map. The mapsheet most commonly used is the 6" X 12" BCGS mapsheet.
POLYGON_ID NUMBER 9 The polygon number is a reference number ( non unique) assigned to each Vegetated or Non-Vegetated polygon after it is delineated. The polygon number provides a link between the graphic and descriptive files. The business assigned unique identifier for a polygon. Typically this has been uniquely assigned within a BCGS 6 X 12 Mapsheet.
OPENING_IND VARCHAR2 1 Indicates whether or not the polygon represents a silviculture opening.
OPENING_SOURCE VARCHAR2 5 Defines whether the opening came from ISIS or MLSIS This field is not populated in the current data model.
OPENING_NUMBER VARCHAR2 4 A unique number assigned to each opening in the forest caused by a disturbance (e.g. fire, logging, etc.) for which there will be management activities.
FEATURE_CLASS_SKEY NUMBER 38 Unique identifier for a feature class.
INVENTORY_STANDARD_CD VARCHAR2 10 Code indicating under which inventory standard the data was collected. Values are: "V:" for Vegetation Resources Inventory (VRI), "F" for Forest Inventory Planning (FIP) and "I" for Incomplete (when a full set of VRI attributes is not collected).
POLYGON_AREA NUMBER 15 The area of a polygon; usually derived from geographic information system processing software. The total area, in hectares, of the forest cover polygon. The total area should be equal to the sum of the areas for all resultants in that polygon.
NON_PRODUCTIVE_DESCRIPTOR_CD VARCHAR2 5 A unique code that references the classes or type of non-productive areas or land that is incapable of supporting commercial forests. This is a FIP classification based attribute only, and is retained for the purposes of business transition from FIP to Vegetation Inventory. There is no expectation that this attribute would be updated or created under Vegetation Inventory classification practise.
NON_PRODUCTIVE_CD VARCHAR2 10 A unique numeric code that references the classes or type of non-productive areas. This is a FIP classification based attribute only, and is retained for the purposes of business transition from FIP to Vegetation Inventory. There is no expectation that this attribute would be updated or created under Vegetation Inventory classification practise.
INPUT_DATE DATE 7 The date the forest cover information was entered into the Provincial Data Base.
COAST_INTERIOR_CD VARCHAR2 1 A code indicating that the stand is located in the Coast or Interior Region of the Province. The Coast Region is defined as the mainland west of the Cascade and Coast Mountains, including the off-shore islands. Forest Inventory Zones (FIZ) A to C are included in the Coast region. The Interior Region is defined as the mainland east of the Cascade and Coast Mountains. Forest Inventory Zones (FIZ) D to L are included in the Interior Region.
SURFACE_EXPRESSION VARCHAR2 10 The form of surficial material apparent on the medium scale photography. A simplified attribution is used owing to the likelihood that the trees will mask suficial features. Decription Source: p. 3-5, Photo Interpretation Procedures, Phase 1, May 14, 1996. Data Value Source: Table 3-2, from Description Source
MODIFYING_PROCESS VARCHAR2 10 A natural mechanism of weathering, erosion and soil material deposition that result in the modification of surficial materials and landforms. Used for terrain classification, site classification, soil condition and identification of potential hazards such as avalanches, slope instability and flooding. Data Definition Source: p.3-7, Photo Interpretation Procedures, Phase 1, May 14, 1996 Data Value Source: Table 3-3, from Data Definition Source.
SITE_POSITION_MESO VARCHAR2 10 A code denoting the relative position of the sampling site within a catchment area with the intent to be consistent within the scale of topography affecting surface water flow. The vertical difference is usually between 3 and 300m, and the surface area generally exceeds 0.5 has in size. Also known as slope position or meso site position. Definition Source: "Describing Ecosystems in the Field", MOE Manual 11, Province of B.C. 1990, p. 31.
ALPINE_DESIGNATION VARCHAR2 10 The location of the land unit with respect to location and elevation. An interpretation is applied as to whether the tree unit is above or below the tree line, that is, the upper elevation limit of continuous tree, or potential tree if cut-over, cover. If the land unit is above the the elevation line, a code of "A" is applied, otherwise "N", the default. Description Source: p. 3-11, Photo Interpretation Procedures, Phase 1, May 14, 1996. Data Value Source: Table 3-5, from Description Source
SOIL_NUTRIENT_REGIME VARCHAR2 10 A code to denote, on a relative scale, the available nutrient supply for plant growth. The soil"s nutrient regime (trophotope) integrates many environmental and biotic parameters which, in combination, determine the actual amounts of available nutrients. Definition Source: Reference: "Describing Ecosystems in the Field", MOE Manual 11, Province of B.C. 1990, p37-40 Soil Nutrient Regime (SNR) refers to the amount of essential soil nutrients, particularly nitrogen, available to vascular plants over a period of several years. SNR classes include A (very poor), B (poor), C (medium), D (rich), E (very rich) and F (ultra rich, saline).
ECOSYS_CLASS_DATA_SRC_CD VARCHAR2 10 The source of the data used in the interpretation of the ecological attributes (Surface expression, modifying process, site position meso, alpine designation, and soil nutrient regime) that describe the polygon.
BCLCS_LEVEL_1 VARCHAR2 10 The code for the land cover classification. The codes are approved by the Resource Inventory Committee, RIC. Level 1 identifies a Vegetated or Non-vegetated state, with further dichotomous refinement to Level 5, which identifies the Vegetation Density Class related to Vegetated land, or specific Non-vegetated state cover such as beaches, mudflats etc.
BCLCS_LEVEL_2 VARCHAR2 10 The second level of the BC land cover classification scheme classifies the polygon as to the land cover type: treed or non-treed for vegetated polygons; land or water for non-vegetated polygons.
BCLCS_LEVEL_3 VARCHAR2 10 The location of the polygon relative to elevation and drainage, and is described as either alpine, wetland, or upland. In rare cases, the polygon may be alpine wetland.
BCLCS_LEVEL_4 VARCHAR2 10 Classifies the vegetation types and Non-Vegetated cover types (as described by the presence of distinct types upon the land base within the polygon).
BCLCS_LEVEL_5 VARCHAR2 10 Classifies the vegetation density classes and Non-Vegetated categories.
INTERPRETER VARCHAR2 30 The name of the person who provided the estimates for the data associated with each polygon.
INTERPRETATION_DATE DATE 7 The date on which the data was photo interpreted.
PROJECT VARCHAR2 100 The business assigned name of the project. The name typically reflects a Timber Supply Area, an initiating Agency, or a land area.
REFERENCE_YEAR NUMBER 4 The year of the source data on which the interpretation is based. Known as the "Reference Year" in the VIF file.
SPECIAL_CRUISE_NUMBER NUMBER 4 The numeric code of the Public Sustained Yield Unit(s) (PSYU) that fall within the forest cover polygon. PSYUs are areas of land, usually a natural topographic unit determined by drainage areas. Includes PSYUs, Tree Farm Licences (TFL), Tree Farms (TF), Major Parks and Ecological Reserves, Woodlot licences, and miscellaneous areas.
SPECIAL_CRUISE_NUMBER_CD VARCHAR2 1 The numbers of the Public Sustained Yield Unit (PSYU) Block(s) that fall within the forest cover polygon. PSYU Blocks are subdivisions of a PSYU, and indicate the presence of a sub-unit survey (i.e. 1:10,000 scale inventory).
INVENTORY_REGION NUMBER 2 The Inventory Region(s) that fall within the forest cover polygon. Inventory Regions are an administrative and planning level boundary used to subdivide the Province into 88 units. Inventory Region is also part of the reference key for identifying the geographic location of all Inventory Branch samples. Inventory Region, along with Inventory Compartment and Compartment Letter, form the key to identifying the Inventory samples.
COMPARTMENT NUMBER 3 The Inventory Compartment(s) that fall within the forest cover polygon. Inventory Compartments are a geographic subdivision of an Inventory Region, usually defining a watershed or part thereof. Inventory Compartment is also part of the reference key for identifying the geographic location of all Inventory Branch samples. Inventory Compartment, along with Compartment Letter and Inventory Region form the key to identifying Inventory samples.
COMPARTMENT_LETTER VARCHAR2 1 The Compartment Letter(s) that fall within the forest cover polygon. Compartment Letter is a geographic subdivision of an Inventory Compartment. Compartment Letter only applies to some Inventory Compartments (e.g. only in Inventory Regions 1, 3, 5, 6, 7, 9, 10, 11, 56). Compartment Letter is also part of the reference key for identifying the geographic location of all Inventory Branch samples. Compartment Letter, along with Inventory Compartment and Inventory Region form the key to identifying Inventory samples.
FIZ_CD VARCHAR2 1 The Forest Inventory Zone(s) (FIZ) that fall within the forest cover polygon. FIZ zones were developed to provide a broadly based ecological classification of the forestland in British Columbia. FIZ zones closely follow the early Biogeoclimatic zones developed by Dr. Krajina. The province of British Columbia is split into 12 FIZ zones.
FOR_MGMT_LAND_BASE_IND VARCHAR2 1 An indicator placing the polygon in the Forest managemnt Land Base.
ATTRIBUTION_BASE_DATE DATE 7 The date that the information about this polygon is considered to be based on. This is not currently populated in the LRDW.
PROJECTED_DATE DATE 7 The date to which time dependent stand information is projected. Attributes that are projected to a future date include: - Age, - Age Class, - Height, - Height Class, - Type Identity, - Stocking Class, etc.
SHRUB_HEIGHT NUMBER 4 The average height of the shrubs contained in the polygon as interpreted from medium scale photography. Note that this attribute only applies to the Shrub component. Definition Source: p. 7-2, PIP
SHRUB_CROWN_CLOSURE NUMBER 3 Shrub crown closure is the percentage of ground area covered by the vertically projected crowns of the shrub cover visible to the photo interpreter. Shrub crown closure is expressed as a percentage of the entire polygon.
SHRUB_COVER_PATTERN VARCHAR2 10 Shrub cover pattern is a code that describes the spatial distribution of the shrubs within the polygon. Shrub cover pattern is used to describe the shrub layer spatial distribution. Examples include clumps of shrubs on rocky patches or individual shrubs or solid, continuous cover
HERB_COVER_TYPE VARCHAR2 10 This set of attributes describes the portion of herb cover that is no obscured by the vertical projection of the crowns of either trees or shrubs. Herbs are defined as non-woody (vascular) plants, including graminoids (sedges, rushes, grasses), forbs (ferns, club mosses, and horsetails) and some low, woody species and intermediate life forms.
HERB_COVER_PATTERN VARCHAR2 10 Herb cover pattern is a code that describes the spatial distribution of the herbaceous species within the polygon. Herb cover pattern is used to describe the herb layer spatial distribution. Examples include clumps of herbaceous species on rock outcrops, scattered patches or individual herbs or solid, continuous herbaceous cover.
HERB_COVER_PCT NUMBER 3 Herb cover percent is the percentage of ground area covered by herbaceous cover visible to the photo interpreter. Herb cover percent is analogous to tree and shrub crown closures and is expressed as a percentage of the entire polygon.
BRYOID_COVER_PCT NUMBER 3 The percent cover of Bryoids: includes bryophytes (mosses, liverworts, hornworts) and non-crustose lichens.
NON_VEG_COVER_PATTERN_1 VARCHAR2 10 Non-vegetated cover pattern_1 describes the spatial distribution of the most prevalent non-vegetated cover type based on percent area covered within the polygon. Definition Source: pp.7-4 (fig. 7-2), 8-5 (fig. 8-2), same as pp. 10-7, fig. 10-2, PIP
NON_VEG_COVER_PCT_1 NUMBER 3 The area the predominate non-vegetated portion covers expressed as a percentage of the entire polygons area. Definition Source: p. 10-5, PIP
NON_VEG_COVER_TYPE_1 VARCHAR2 10 Non-vegetated cover type_1 is the designation for the predominate observable non-vegetated land cover within the polygon.
NON_VEG_COVER_PATTERN_2 VARCHAR2 10 Non-vegetated cover pattern_2 describes the spatial distribution of the second most prevalent non-vegetated cover type based on percent area covered within the polygon. Definition Source: pp. 7-4 (fig. 7-2), 8-5 (fig. 8-2), same as pp. 10-7, fig. 10-2, PIP
NON_VEG_COVER_PCT_2 NUMBER 3 The area the second most prevalent non-vegetated portion covers expressed as a percentage of the entire polygons area. Definition Source: p. 10-5, PIP
NON_VEG_COVER_TYPE_2 VARCHAR2 10 Non-vegetated cover type_2 is the designation for the second most prevalent observable non-vegetated land cover within the polygon.
NON_VEG_COVER_PATTERN_3 VARCHAR2 10 Non-vegetated cover type_3 is the designation for the third most prevalent observable non-vegetated land cover within the polygon.
NON_VEG_COVER_PCT_3 NUMBER 3 The area the third most prevalent non-vegetated portion covers expressed as a percentage of the entire polygons area. Definition Source: p. 10-5, PIP
NON_VEG_COVER_TYPE_3 VARCHAR2 10 Non-vegetated cover type_3 is the designation for the third most prevalent observable non-vegetated land cover within the polygon.
LAND_COVER_CLASS_CD_1 VARCHAR2 10 The Land Cover Classification Code_1 describes the predominate land cover type by percent area occupied within the polygon that contribute to the overall polygon description, but may be too small to be spatially identified. The sub-division of a polygon by a quantified Land Cover Component, allowing non-spatial resolution for modeling of wildlife habitat capability.
EST_COVERAGE_PCT_1 NUMBER 3 The amount the polygon occupied by the predominate Land Cover Component. The sub-division of a polygon by a quantified Land Cover Component allows a higher degree spatial resolution for modelling wildlife habitat capability. Generally, sizes under 10% would not be estimated. Definition Source: p. 4-6, PIP
SOIL_MOISTURE_REGIME_1 VARCHAR2 10 The average amount of soil water annually available for evapotranspiration by vascular plants averaged over many years within the predominate cover type. Soil Moisture Regime is an interpretative attribute for estimation of site potential and site series classification. Definition Source: p. 4-7, PIP
LAND_COVER_CLASS_CD_2 VARCHAR2 10 The Land Cover Classification Code_2 describes the second most dominate land cover type by percent area occupied within the polygon that contribute to the overall polygon description, but may be too small to be spatially identified. The sub-division of a polygon by a quantified Land Cover Component, allowing non-spatial resolution for modelling of wildlife habitat capability.
EST_COVERAGE_PCT_2 NUMBER 3 The amount the polygon occupied by the second most dominate Land Cover Component. The sub-division of a polygon by a quantified Land Cover Component allows a higher degree spatial resolution for modelling wildlife habitat capability. Generally, sizes under 10% would not be estimated. Definition Source: p. 4-6, PIP
SOIL_MOISTURE_REGIME_2 VARCHAR2 10 The average amount of soil water annually available for evapotranspiration by vascular plants averaged over many years within the second most dominate cover type. Soil Moisture Regime is an interpretative attribute for estimation of site potential and site series classification. Definition Source: p. 4-7, PIP
LAND_COVER_CLASS_CD_3 VARCHAR2 10 The Land Cover Classification Code_3 describes the third most dominate land cover type by percent area occupied within the polygon that contribute to the overall polygon description, but may be too small to be spatially identified. The sub-division of a polygon by a quantified Land Cover Component, allowing non-spatial resolution for modelling of wildlife habitat capability.
EST_COVERAGE_PCT_3 NUMBER 3 The amount the polygon occupied by the third most dominate Land Cover Component. The sub-division of a polygon by a quantified Land Cover Component allows a higher degree spatial resolution for modelling wildlife habitat capability. Generally, sizes under 10% would not be estimated. Definition Source: p. 4-6, PIP
SOIL_MOISTURE_REGIME_3 VARCHAR2 10 The average amount of soil water annually available for evapotranspiration by vascular plants averaged over many years within the second most dominate cover type. Soil Moisture Regime is an interpretative attribute for estimation of site potential and site series classification. Definition Source: p. 4-7, PIP
AVAIL_LABEL_HEIGHT NUMBER 38 The available height for a label, in meters for a 1:15,000 map presentation. This is derived during the label generation process to calculate if the VRI label will fit within a polygon shape or be written the map side.
AVAIL_LABEL_WIDTH NUMBER 38 The available width for a label, in meters for a 1:15,000 map presentation. This is derived during the label generation process to calculate if the VRI label will fit within a polygon shape or be written the map side.
FULL_LABEL VARCHAR2 1000 The full Vegetation Map label. It contains the polygon id, Opening number, species composition, projected age, projected height, site index and crown closure, and indicator of shrub, herb, bryoid, or non vegetative components, and the historic disturbance and forest management activities. It is at most 8 lines. Back slashes represent carriage returns.
LABEL_CENTRE_X NUMBER 38 The x co-ordinate of the suggested centre of the label.
LABEL_CENTRE_Y NUMBER 38 The y co-ordinate of the suggested centre of the label.
LABEL_HEIGHT NUMBER 38 The height of the full label for a 1:15,000 map presentation in meters. It is calculated as 30 times the number of lines in the full label.
LABEL_WIDTH NUMBER 38 The width of the full label for a 1:15,000 map presentation in meters. It is calculated as 18 times the number of characters in the longest line.
LINE_1_OPENING_NUMBER VARCHAR2 4 The MOF District Silviculture opening number to which the polygon applies to.
LINE_1_OPENING_SYMBOL_CD VARCHAR2 1 The opening symbol code is represented as one of the following characters: "x", "|", or "~". If the opening number is null, line 1 is not populated, so there is no opening symbol. If the adjoining NTS map number is in the form "num num num char num / char", it is an NTS number, the corresponding opening symbol is a hexagon with an "N" in it, and is represented here by "~". If the adjoining NTS map number is in the form "num num num char num num num", it is a BCGS number, the corresponding opening symbol is a hexagon with an "X" in it, and is represented here by "|". Otherwise the opening symbol is an empty hexagon, and is represented here by "x".
LINE_2_POLYGON_ID VARCHAR2 10 The polygon ID for which this is the label. This is followed by /L (a multi-layered stand) or /S (a separate silviculture description is available in the data base).
LINE_3_TREE_SPECIES VARCHAR2 50 A list of major species (minor species), ordered by percentage. The species symbols are F (Douglas fir), C (western red cedar), H (hemlock), B (balsam), S (spruce), Sb (black spruce), Yc (yellow cedar), Pw (western white pine), Pa (whitebark pine), Pf (limber pine), Pl (lodgepole pine), Pj (jack pine), Py (yellow pine), L (larch), Ac (cottonwood), D (red alder), Mb (broadleaf maple), E (birch), Al (aspen).
LINE_4_CLASSES_INDEXES VARCHAR2 12 Line 4 is made up of 4 numerical characters followed by a hyphen, the site index, a slash, and the estimated site index. The four numerical characters represent projected age class, projected height class, projected stocking class, and crown closure class in that order.
LINE_5_VEGETATION_COVER VARCHAR2 11 A listing of the non-vegetated descriptors or the non tree vegetative cover types ordered from most to least common. Possible values in the list are sh (shrub), he (herb), by (bryoid), or the non-vegetative cover codes.
LINE_6_SITE_PREP_HISTORY VARCHAR2 10 The site preparation history represented by a list of abbreviations for the techniques used, followed by the years each technique was used. Possible values for the abbreviations are B (broadcast burn) C (chemical), G (grass seeded), H (hand preparation), RB (range management burn), S (spot burn), M (mechanical), MS (mechanical and spot burn), and W (windrow).
LINE_7_ACTIVITY_HIST_SYMBOL VARCHAR2 1 A symbol representing what techniques where used in the labelled area. The symbol is a circle with 0 to 4 radius lines. Each line represents a technique applied to the labelled area.If RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST(stand tending) then & as circle with a radius line pointing leftIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI(regeneration/site preparation) then % draw as circle with a radius line pointing (up/down)If RESOURCE_INVENTORY_HISTORY.SILV_BASE = DI(disturbance) then $ draw as circle with a radius line pointing rightIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = PL(regeneration/site preparation) then % draw as circle with a radius line pointing (up/down)If RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then < draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then ` draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then : draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI then * draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI then X draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = DI then ; draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then ¿ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then @ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = PL then [ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI then \ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST then ^ draw as combination of the above circles and radius lines
LINE_7A_STAND_TENDING_HISTORY VARCHAR2 39 The stand tending history represented by a list of abbreviations for the techniques used followed by the years each technique was used. Possible values for the abbreviations are F (fertilization), H (hand and squirt), J (juvenile spacing), M (mistletoe control), P (pruning), R (conifer realize), S (sanitation spacing), T (commercial thinning), W (brushing and weeding).
LINE_7B_DISTURBANCE_HISTORY VARCHAR2 40 The disturbance history described as a list of abbreviations for the techniques along with the years each technique was employed. Possible values are B (wildfire), BE (escaped burn), BG (ground burn), BR (range burn), BW (wildlife burn), D (disease), F (flooding), I (insect), K (fume kill), L (logging), L% (logged with percentage), R (site rehabilitation), S (slide), and W (wind throw).
LINE_8_PLANTING_HISTORY VARCHAR2 80 The planting (or regeneration) history described as a list of years during which artificial planting was performed.
PRINTABLE_IND VARCHAR2 1 "Y" means print the label. "N" means do not print the label.
SMALL_LABEL VARCHAR2 200 The two-line (or Format 3) version of the label. This label contains, at most, 2 lines build from the line 1 and 2 attributes. A back slash represents a carriage return.
OPENING_ID NUMBER 10 System generated value uniquely identifying the opening.
ORG_UNIT_NO NUMBER 10 Number from Org Unit code table representing the organization that collected the data.
ORG_UNIT_CODE VARCHAR2 6 Identifies any office within the ministry. First character identifies Exec, HQ branch, Region, or District. Next two chars identify the office name; next two the section (HQ Branch) or program (Region or District); last char identifies the subsection.
ADJUSTED_IND VARCHAR2 1 Indicates whether or not the polygon has been adjusted.
BEC_ZONE_CODE VARCHAR2 4 Code indicating the polygon"s Biogeoclimatic Zone.
BEC_SUBZONE VARCHAR2 3 A code indicating the polygon"s biogeoclimatic sub zone.
BEC_VARIANT VARCHAR2 1 A code indicating the polygon"s biogeoclimatic variant.
BEC_PHASE VARCHAR2 1 A code indicating the polygon"s biogeoclimatic phase.
EARLIEST_NONLOGGING_DIST_TYPE VARCHAR2 10 Represents the polygons earliest non-logging disturbance date.
EARLIEST_NONLOGGING_DIST_DATE DATE 7 Represents the polygons earliest non-logging disturbance date.
STAND_PERCENTAGE_DEAD NUMBER 3 Represents the percent of the stand that has had an epidemic loss.
FREE_TO_GROW_IND VARCHAR2 1 Indicates whether or not the polygon represents a Free To Grow opening.
HARVEST_DATE DATE 7 The date in which the polygon was last harvested.
GEOMETRY SDO_GEOMETRY 64 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
FEATURE_AREA_SQM NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters.
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters.
LAYER_ID VARCHAR2 10 The unique business identification of a layer, or horizontal stratum, in a stand. Each layer is normally characterized as a distinct canopy containing a common forest cover structure with timber of similar ages (at least 40 years between layers) and heights (at least 10 meters between layers). Layers are assigned from the tallest layer downward.
FOR_COVER_RANK_CD VARCHAR2 10 A numeric designation of the relative importance of the layer component in the stand as determined by the business. The level of importance decreases as the numeric designation increases. For Vegetation Cover originated data, this value is assigned via business rule based on the supplied order of the layer records as recorded by the interpreter. For FIP originated data, this value is known as the RANK CD, and is explicitly supplied by the interpreter. The RANK CD, or ranking, is based on Regional guidelines at the time of interpretation. This value is retained for FIP transition purposes, as tree volumes are only calculated by VDYP, the current software/mathematical model in production. The RANK CD will be superseded in time when Vegetation Inventory projection tools are developed.
NON_FOREST_DESCRIPTOR VARCHAR2 10 Non commercial forest vegetation on a polygon that is capable of supporting commercial forests. Maps directly to the FIP attribute, NON FOREST DESCRIPTOR and is also utilized for the determination of the BC Land Cover Classification. This is a FIP classification based attribute only, and is retained for the purposes of business transition from FIP to Vegetation Inventory.
INTERPRETED_DATA_SRC_CD VARCHAR2 10 The source of the data that contributed to the determination of the classification description. All values taken from Table 3-1, PIP This list of values is similar, but not identical to the FIP DATA SOURCE which will be used to validate the FIP file prior to loading. Non-conforming FIP DATA SOURCE values will be converted to the VEGETATION DATA SOURCE values on load to the Vegetative Cover database.
QUAD_DIAM_125 NUMBER 8 The quadratic mean stand diameter (breast height), at the projection date, based on the 22.5 cm utilization level. Calculated for Rank 1 stands only, type id (TYPID) 1 through 3.
QUAD_DIAM_175 NUMBER 8 The quadratic mean stand diameter (breast height), at the projection date, based on the 17.5 cm utilization level. Calculated for Rank 1 stands only, Type id (TYPID) for 1 through 3.
QUAD_DIAM_225 NUMBER 8 The quadratic mean stand diameter (breast height), at the projection date, based on the 22.5 cm utilization level.Calculated for Rank 1 stands only, type id (TYPID) 1 through 3.
EST_SITE_INDEX_SPECIES_CD VARCHAR2 10 The species to which the estimated site index applies.
EST_SITE_INDEX NUMBER 5 Estimated site index is an interpreter estimated site index for tree layers with a leading species age less than 31 years. Site index is the mean height of the dominant and codominant trees will attain at a base index age (50 years) used for the purposes of estimating forest site growth capability. The site index is based on a normalized set of coefficients calibrated to reflect the range of heights for a given tree species.
EST_SITE_INDEX_SOURCE_CD VARCHAR2 10 The species to which the estimated site index applies.
CROWN_CLOSURE NUMBER 3 The percentage of ground area covered by the vertically projected crowns of the tree cover for each tree layer within the polygon.
CROWN_CLOSURE_CLASS_CD VARCHAR2 2 The percentage of ground area covered by the vertically projected crowns of the tree cover for each tree layer within the polygon. Represented by a code value in the code list.
REFERENCE_DATE DATE 7 The date of the source data on which the interpretation is based. Known as the "Reference Year" in the VIF file.
SITE_INDEX NUMBER 5 Site index is an estimate of site productivity for tree growth (height in metres at breast height age of 50 years). The mean height of the dominant and codominant trees will attain at a base index age used for the purposes of estimating forest site growth capability. The site index is based on a normalized set of coefficients calibrated to reflect the range of heights for a given tree species.
DBH_LIMIT NUMBER 2 A code indicating the minimum diameter breast height (DBH) for measuring trees (i.e. stems) in the field sample. For example, a code of 3 indicates that stems were measured if they had a DBH greater than or equal to 7.5cm.
BASAL_AREA NUMBER 10 Confidence indices are a subjective value that reflect confidence of the photo interpreter in the estimation of basal area for each layer.
DATA_SOURCE_BASAL_AREA_CD VARCHAR2 10 The source of data used for the interpretation of basal area.
VRI_LIVE_STEMS_PER_HA NUMBER 8 The average number of living trees visible to the photo interpreter in the dominant, codominant and high intermediate crown positions in each tree layer in the polygon. It is expressed as stems per hectare.
DATA_SRC_VRI_LIVE_STEM_HA_CD VARCHAR2 10 The source of data used for the interpretation of stand density.
VRI_DEAD_STEMS_PER_HA NUMBER 8 The number of VRI dead tree stems on an unitary per hectare basis.
TREE_COVER_PATTERN VARCHAR2 10 The spatial distribution of the tree cover within each tree layer in the polygon. Definition Source: p 6-1, PIP Data Value Source; Figure 6-1
VERTICAL_COMPLEXITY VARCHAR2 10 The subjective classification that describes the form of each tree layer as indicated by the relative uniformity of the forest canopy as it appears on mid-scale aerial photographs. Vertical complexity is influenced by stand age, species (succession as it relates to shade tolerance) and degree and age of past disturbances. The tree height range is calculated as the total difference in height between the tallest and shortest visible dominant, codominant, and high intermediate trees. To most adequately represent the tree layer of interest, occasional occurrences of either very tall or very short trees should be ignored so that the vertical complexity indicated is for the majority of stems in the dominant, codominant, and high intermediate portion of each tree layer.
SPECIES_CD_1 VARCHAR2 10 The code indicating the type of tree species predominate or leading in the tree layer. A "leading" species is identified as being the highest percent basal area or, if a very young stand, the relative number of stems per hectare. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_1 NUMBER 5 Percentages of the layer that the leading species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
SPECIES_CD_2 VARCHAR2 10 The code indicating the type of tree species second most dominate in the tree layer. A "second" species is identified in descending order of species percent from the "leading" species. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_2 NUMBER 5 Percentages of the layer that the second most dominate species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
SPECIES_CD_3 VARCHAR2 10 The code indicating the type of tree species third most dominate in the tree layer. A "third" species is identified in descending order of species percent from the "leading" species. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_3 NUMBER 5 Percentages of the layer that the third most dominate species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
SPECIES_CD_4 VARCHAR2 10 The code indicating the type of tree species fourth most dominate in the tree layer. The "fourth" species is identified in descending order of species percent from the "leading" species. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_4 NUMBER 5 Percentages of the layer that the fourth most dominate species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
SPECIES_CD_5 VARCHAR2 10 The code indicating the type of tree species fifth most dominate in the tree layer. The "fifth" species is identified in descending order of species percent from the "leading" species. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_5 NUMBER 5 Percentages of the layer that the fifth most dominate species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
SPECIES_CD_6 VARCHAR2 10 The code indicating the type of tree species sixth most dominate in the tree layer. The "sixth" species is identified in descending order of species percent from the "leading" species. Species are described in terms of Genus, Species and variety.
SPECIES_PCT_6 NUMBER 5 Percentages of the layer that the sixth most dominate species occupies. For older stands, tree species percentage is based on percent basal area or, if a very young stand, the relative number of stems per hectare. Tree species percentage is estimated to the nearest percent for all living trees above a specified diameter.
PROJ_AGE_1 NUMBER 4 The age projected to the adjustment area ground sample date, for Species 1.
PROJ_AGE_CLASS_CD_1 VARCHAR2 1 The age projected to the adjustment area ground sample date, for Species 1. Classified by standard age classes.
PROJ_AGE_2 NUMBER 4 The age projected to the adjustment area ground sample date, for Species 2.
PROJ_AGE_CLASS_CD_2 VARCHAR2 1 The age projected to the adjustment area ground sample date, for Species 2. Classified by standard age classes.
DATA_SOURCE_AGE_CD VARCHAR2 10 The source of data used for the interpretation of year of origin (age), for Species 1.
PROJ_HEIGHT_1 NUMBER 5 The height projected to the adjustment area ground sample date, for Species 1.
PROJ_HEIGHT_CLASS_CD_1 VARCHAR2 1 The height projected to the adjustment area ground sample date, for Species 1. Classified by standard height classes
PROJ_HEIGHT_2 NUMBER 5 The height projected to the adjustment area ground sample date, for Species 2.
PROJ_HEIGHT_CLASS_CD_2 VARCHAR2 1 The height projected to the adjustment area ground sample date, for Species 2. Classified by standard height classes
DATA_SOURCE_HEIGHT_CD VARCHAR2 10 The source of data used for the interpretation of height, for Species 1.
LIVE_VOL_PER_HA_SPP1_125 NUMBER 8 Net live volume per hectare of the leading species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP1_175 NUMBER 8 Net live volume per hectare of the leading species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP1_225 NUMBER 8 Net live volume per hectare of the leading species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
LIVE_VOL_PER_HA_SPP2_125 NUMBER 8 Net live volume per hectare of the second species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP2_175 NUMBER 8 Net live volume per hectare of the second species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP2_225 NUMBER 8 Net live volume per hectare of the second species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
LIVE_VOL_PER_HA_SPP3_125 NUMBER 8 Net live volume per hectare of the third species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP3_175 NUMBER 8 Net live volume per hectare of the third species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP3_225 NUMBER 8 Net live volume per hectare of the third species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
LIVE_VOL_PER_HA_SPP4_125 NUMBER 8 Net live volume per hectare of the fourth species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP4_175 NUMBER 8 Net live volume per hectare of the fourth species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP4_225 NUMBER 8 Net live volume per hectare of the fourth species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
LIVE_VOL_PER_HA_SPP5_125 NUMBER 8 Net live volume per hectare of the fifth species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP5_175 NUMBER 8 Net live volume per hectare of the fifth species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP5_225 NUMBER 8 Net live volume per hectare of the fifth species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
LIVE_VOL_PER_HA_SPP6_125 NUMBER 8 Net live volume per hectare of the sixth species determined by percent basal area of the tree layer at the 12.5 cm utilization level.
LIVE_VOL_PER_HA_SPP6_175 NUMBER 8 Net live volume per hectare of the sixth species determined by percent basal area of the tree layer at the 17.5 cm utilization level.
LIVE_VOL_PER_HA_SPP6_225 NUMBER 8 Net live volume per hectare of the sixth species determined by percent basal area of the tree layer at the 22.5 cm utilization level.
DEAD_VOL_PER_HA_SPP1_125 NUMBER 8 Net dead volume per hectare of the leading species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP1_175 NUMBER 8 Net dead volume per hectare of the leading species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP1_225 NUMBER 8 Net dead volume per hectare of the leading species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP2_125 NUMBER 8 Net dead volume per hectare of the second species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP2_175 NUMBER 8 Net dead volume per hectare of the second species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP2_225 NUMBER 8 Net dead volume per hectare of the second species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP3_125 NUMBER 8 Net dead volume per hectare of the third species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP3_175 NUMBER 8 Net dead volume per hectare of the third species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP3_225 NUMBER 8 Net dead volume per hectare of the third species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP4_125 NUMBER 8 Net dead volume per hectare of the fourth species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP4_175 NUMBER 8 Net dead volume per hectare of the fourth species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP4_225 NUMBER 8 Net dead volume per hectare of the fourth species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP5_125 NUMBER 8 Net dead volume per hectare of the fifth species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP5_175 NUMBER 8 Net dead volume per hectare of the fifth species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP5_225 NUMBER 8 Net dead volume per hectare of the fifth species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP6_125 NUMBER 8 Net dead volume per hectare of the sixth species determined by percent basal area of the tree layer at the 12.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP6_175 NUMBER 8 Net dead volume per hectare of the sixth species determined by percent basal area of the tree layer at the 17.5 cm utilization level and at the year of death.
DEAD_VOL_PER_HA_SPP6_225 NUMBER 8 Net dead volume per hectare of the sixth species determined by percent basal area of the tree layer at the 22.5 cm utilization level and at the year of death.
LIVE_STAND_VOLUME_125 NUMBER 8 Total net volume per hectare of all live species determined by percent basal area of the tree layer at the 12.5 cm utilization level
LIVE_STAND_VOLUME_175 NUMBER 8 Total net volume per hectare of all live species determined by percent basal area of the tree layer at the 17.5 cm utilization level
LIVE_STAND_VOLUME_225 NUMBER 8 Total net volume per hectare of all live species determined by percent basal area of the tree layer at the 22.5 cm utilization level
DEAD_STAND_VOLUME_125 NUMBER 8 Total net volume per hectare of all dead species determined by percent basal area of the tree layer at the 12.5 cm utilization level at the year of death for the stand
DEAD_STAND_VOLUME_175 NUMBER 8 Total net volume per hectare of all dead species determined by percent basal area of the tree layer at the 17.5 cm utilization level at the year of death for the stand
DEAD_STAND_VOLUME_225 NUMBER 8 Total net volume per hectare of all dead species determined by percent basal area of the tree layer at the 22.5 cm utilization level at the year of death for the stand
WHOLE_STEM_BIOMASS_PER_HA NUMBER 8 The total stem biomass per hectare of all species on a minimum diameter utilization of 4.0cm expressed as tonnes/ha.
BRANCH_BIOMASS_PER_HA NUMBER 8 The total branch biomass per hectare of all species on a minimum diameter utilization of 4.0cm expressed as tonnes/ha.
FOLIAGE_BIOMASS_PER_HA NUMBER 8 The total foliage biomass per hectare of all species on a minimum diameter utilization of 4.0cm expressed as tonnes/ha.
BARK_BIOMASS_PER_HA NUMBER 8 The total bark biomass per hectare of all species on a minimum diameter utilization of 4.0cm expressed as tonnes/ha.
OBJECT_ID NUMBER 38 OBJECT_ID 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.

Comments

No comments have been posted yet.