VRI - Forest Vegetation Composite Polygons and Dead Layer
Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Forest Analysis and InventoryLicensed under Access Only
Data and Resources
-
Provincial FGDB of veg_comp_poly_and_layer.gdb.zipfgdb
The Dead layer can be derived from the VEG_COMP_LAYER and VEG_COMP_POLY...
Additional Information
Purpose
This layer tracks the endemic due to natural disturbances such as Mountain Pine Beetle
Data Quality | |
Lineage Statement |
Contact Information
Name | Marc Rousseau (pointOfContact) |
Marc.Rousseau@gov.bc.ca | |
Organization | Ministry of Forests, Lands, Natural Resource Operations and Rural Development |
Sub-Organization | Forest 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-12-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