Vegetation Composite Polygons

1385 views (25 recent)

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

A composite table comprising the polygon table attributes joined to the attributes from the non veg, non tree, land cover component, map label and history linkage tables. indicating an area on the BC land base on like Vegetation Inventory attribution. This SDE layer coverage contains vegetation cover from the Ministry of Forests. Attribute information is also maintained in this table. It will supersede F_FC. Vegetation Cover is comprised of spatial layers for the collection, manipulation and production of forest inventory data, which has a accompanying textual attributes.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Data was created to present a consolidated ARC friendly view of the Oracle table VRI datasuitable for Timber Supply analysis and high level resource management planning.

Lineage Statement

Data is quality assured to meet provincial standards prior to translation, coverage creation and loading as a layer.

More Information

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
NameEdward Fong (pointOfContact)
EmailEdward.Fong@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?Public

Metadata Information

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

Object Description

Object Name: WHSE_FOREST_VEGETATION.VEG_COMP_POLY

Short Name: VEGCOMPOLY
Comments: This is a denormalized summary table combining fields from the following tables: VEG_VEGETATION_COVER_POLYGON, VEG_DATA_SET_VERSION, VEG_LABEL, VEGETATIVE_COVER, RESOURCE_INVENTORY_HISTORY, RSLT_OPENING, NON_VEGETATIVE_COVER, LAND_COVER_COMPONENT, CORP_ORG_UNIT. This table contains a static cut of the VRI data projected to current year and will be updated annually. It is intended for strategic level resource analysis using the current GIS tools.

Column Name Short Name Data Type Data Precision Comments
FEATURE_ID FEATURE_ID NUMBER 38 Provincially unique identifier for an instance of a spatial feature.
MAP_ID 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 POLY_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 OPEN_IND VARCHAR2 1 Indicates whether or not the polygon represents a silviculture opening.
OPENING_SOURCE OPEN_SRC VARCHAR2 5 Defines whether the opening came from ISIS or MLSIS This field is not populated in the current data model.
OPENING_NUMBER OPEN_NUM 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 FEAT_SKEY NUMBER 38 Unique identifier for a feature class.
INVENTORY_STANDARD_CD INV_STD_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 POLY_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 NP_DESC 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 NP_CODE 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 INPUT_DATE DATE 7 The date the forest cover information was entered into the Provincial Data Base.
COAST_INTERIOR_CD CST_INT_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 SURF_EXP 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 MOD_PROCES 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 SITE_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 ALPN_DESIG 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 SOIL_NUTR 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 ECO_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 BCLCS_LV_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 BCLCS_LV_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 BCLCS_LV_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 BCLCS_LV_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 BCLCS_LV_5 VARCHAR2 10 Classifies the vegetation density classes and Non-Vegetated categories.
INTERPRETER INTERPRETR VARCHAR2 30 The name of the person who provided the estimates for the data associated with each polygon.
INTERPRETATION_DATE INTRP_DATE DATE 7 The date on which the data was photo interpreted.
PROJECT PROJECT_ID 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 RFRNCR 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 CRUISE_NO 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 CRUISE_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 INV_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 COMPARTMNT 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 COMP_LET 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 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 FRMGMTLNDB VARCHAR2 1 An indicator placing the polygon in the Forest managemnt Land Base.
ATTRIBUTION_BASE_DATE ATRIB_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 PROJ_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 SHRB_HT 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 SHRB_CC 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 SHRB_PATT 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 HERB_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 HERB_COVER 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 HERB_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 BRYOID_PCT NUMBER 3 The percent cover of Bryoids: includes bryophytes (mosses, liverworts, hornworts) and non-crustose lichens.
NON_VEG_COVER_PATTERN_1 NVEG_COV_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 NVEG_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 NVEG_TYP_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 NVEG_COV_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 NVEG_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 NVEG_CTY2 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 NVEG_COV_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 NVEG_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 NVEG_TYP_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 LAND_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 COV_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 SOIL_MST_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 LAND_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 COV_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 SOIL_MST_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 LAND_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 COV_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 SOIL_MST_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 AV_LBL_HT 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 AV_LBL_WD 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 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 LBL_CTR_X NUMBER 38 The x co-ordinate of the suggested centre of the label.
LABEL_CENTRE_Y LBL_CTR_Y NUMBER 38 The y co-ordinate of the suggested centre of the label.
LABEL_HEIGHT LBL_HT 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 LBL_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 LBL_OPN_NO VARCHAR2 4 The MOF District Silviculture opening number to which the polygon applies to.
LINE_1_OPENING_SYMBOL_CD LBL_OPN_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 LBL_POLYID 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 LBL_SPECIS 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 LBL_CIS_IN 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 LBL_VEGCOV 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 LBL_HIST 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 LBL_DISTUR 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 and draw 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 and 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 and SI then < draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST and DI then ` draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST and PL then : draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI and DI then * draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI and PL then X draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = DI and PL then ; draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST and PL and DI then ? draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST and SI and DI then @ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = PL and ST and SI then [ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = SI and DI and PL then \ draw as combination of the above circles and radius linesIf RESOURCE_INVENTORY_HISTORY.SILV_BASE = ST and SI and DI and PL then ^ draw as combination of the above circles.
LINE_7A_STAND_TENDING_HISTORY LBL_HIS_SY 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 LBL_TEND 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 LBL_PLANT VARCHAR2 80 The planting (or regeneration) history described as a list of years during which artificial planting was performed.
PRINTABLE_IND PRNTBLND VARCHAR2 1 "Y" means print the label. "N" means do not print the label.
SMALL_LABEL SM_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 OPEN_ID NUMBER 10 System generated value uniquely identifying the opening.
ORG_UNIT_NO ORGUNIT_NO NUMBER 10 Number from Org Unit code table representing the organization that collected the data.
ORG_UNIT_CODE ORGUNIT_CD 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 DJSTDND VARCHAR2 1 Indicates whether or not the polygon has been adjusted.
BEC_ZONE_CODE BCZNCD VARCHAR2 4 Code indicating the polygon"s Biogeoclimatic Zone.
BEC_SUBZONE BCSBZN VARCHAR2 3 A code indicating the polygon"s biogeoclimatic sub zone.
BEC_VARIANT BCVRNT VARCHAR2 1 A code indicating the polygon"s biogeoclimatic variant.
BEC_PHASE BEC_PHASE VARCHAR2 1 A code indicating the polygon"s biogeoclimatic phase.
EARLIEST_NONLOGGING_DIST_TYPE RLSTNNLGG1 VARCHAR2 10 Represents the polygons earliest non-logging disturbance type.
EARLIEST_NONLOGGING_DIST_DATE RLSTNNLGGN DATE 7 Represents the polygons earliest non-logging disturbance date.
STAND_PERCENTAGE_DEAD STNDPRCNTG NUMBER 3 Represents the percent of the stand that has had an epidemic loss.
FREE_TO_GROW_IND FRTGRWND VARCHAR2 1 Indicates whether or not the polygon represents a Free To Grow opening.
HARVEST_DATE HRVSTDT DATE 7 The date in which the polygon was last harvested.
GEOMETRY GEOMETRY SDO_GEOMETRY 64 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
FEATURE_AREA_SQM FEAT_AREA NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters.
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters.
OBJECT_ID 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.
OBJECTID OBJECTID NUMBER 38