RESULTS - Activity Treatment Units

717 views (22 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Resource Practices
Licensed under Open Government Licence - British Columbia

An opening's disturbance and silviculture activities reported into RESULTS. Most activities are within opening boundaries with the exception of broadcast treatments. An opening may have more than one activities associated with it. Activities may also overlap each other. Reporting of disturbance and silviculture attribute information is a mandatory requirement while the map is optional. This is part of the Silviculture and Land status Tracking dataset, which includes tracking harvesting and silviculture obligations on Crown Land

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Required by legislation (silviculture obligations) or policy to track disturbance and silviculture activities for the opening.

Contact Information

NameCaroline MacLeod (pointOfContact)
EmailCaroline.MacLeod@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationResource Practices
NameMatt Leroy (pointOfContact)
EmailMatthew.Leroy@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationResource Practices

Access & Security

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

Metadata Information

Record Published 2011-10-12
Record Last Modified 2019-05-31
Resource Status completed

Object Description

Object Name: WHSE_FOREST_VEGETATION.RSLT_ACTIVITY_TREATMENT_SVW

Short Name: RSLT_ACTRT
Comments: The spatial representation of opening's Disturbance and silviculture activities reported into RESULTS. Note that silviculture may have planned activities.

Column Name Short Name Data Type Data Precision Comments
ACTIVITY_TREATMENT_UNIT_ID ATU_ID NUMBER 10 The ACTIVITY TREATMENT UNIT ID is a system generated value by RESULTS to uniquely identify the disturbance or silviculture activity.
ACTIVITY_LICENSEE_ID AL_ID VARCHAR2 30 The ACTIVITY LICENSEE ID is a unique identifier provided by the Licensee or submitter to identify the disturbance or silviculture activity
OPENING_ID OPEN_ID NUMBER 10 The OPENING ID is a system generated value by RESULTS to uniquely identify the opening.
MAP_LABEL MAP_LABEL VARCHAR2 14 The default label to be used when displaying the feature on a map. Consists of the SILV BASE CODE, SILV TECHNIQUE CODE, DISTURBANCE CODE, and ATU COMPLETION YEAR.
SILV_BASE_CODE ACT_BASE VARCHAR2 2 The SILV BASE CODE identifies primary category of the completed disturbance or silviculture activity (eg. DN - disturbance, SU - survey, PL-planting etc.)
SILV_TECHNIQUE_CODE ACT_TECH VARCHAR2 2 The SILV TECHNIQUE CODE describes the broad category of technique associated with the completed silviculture activity (eg. Site Prep/Burn - Base Code-SP, Technique Code-BU)
SILV_METHOD_CODE ACT_METH VARCHAR2 5 The SILV METHOD CODE describes the specific machinery or method used for the completed silviculture activity base/technique combination (eg. Site Prep/Burn/Broadcast: Base Code-SP, Technique Code-BU, Method Code -BROAD)
SILV_OBJECTIVE_CODE_1 ACT_OBJ1 VARCHAR2 3 The SILV OBJECTIVE CODE 1 describes the objective for performing the completed silviculture activity.
SILV_OBJECTIVE_CODE_2 ACT_OBJ2 VARCHAR2 3 The SILV OBJECTIVE 2 describes the objective for performing the completed silviculture activity.
SILV_OBJECTIVE_CODE_3 ACT_OBJ3 VARCHAR2 3 The SILV OBJECTIVE 3 describes the objective for performing the completed silviculture activity.
SILV_FUND_SOURCE_CODE ACT_FUND VARCHAR2 3 The SILV FUND SOURCE CODE describes the actual funding source for the completed silviculture activity on the opening.
ATU_START_DATE START_DT DATE 7 The ATU START DATE is the start date for the disturbance activity. The first disturbance start date for the opening is used to start the milestones for silviculture obligation.
ATU_COMPLETION_DATE COMPL_DT DATE 7 The ATU COMPLETION DATE is the disturbance or silviculture completion date for the activity.
ACTUAL_TREATMENT_AREA CTLTRTMNTR NUMBER 11 The ACTIVITY TREATMENT AREA is the completed area for the disturbance/silviculture activity.
ACTUAL_TREATMENT_COST CTLTRTMNTC NUMBER 9 The ACTIVITY TREATMENT COST is the completed silviculture cost for the silviculture treatment.
ACTUAL_PLANTED_NUMBER ACT_PLT_NO NUMBER 10 The ACTUAL PLANTED NUMBER is the total number of trees planted for the completed planting activity. This is the sum of the trees by species reported.
RESULTS_IND RES_YN VARCHAR2 1 The RESULTS IND is a system controlled Yes/No indicator to indicate planned or completed activity.
PLAN_SILV_TECHNIQUE_CODE PLND_TECH VARCHAR2 2 The PLAN SILV TECHNIQUE CODE describes the broad category of technique associated with the planned silviculture activity (eg. Site Prep/Burn - Base Code-SP, Technique Code-BU)
PLAN_SILV_METHOD_CODE PLND_METH VARCHAR2 5 The PLAN SILV METHOD CODE describes the specific machinery or method used for the planned silviculture activity base/technique combination (eg. Site Prep/Burn/Broadcast: Base Code-SP, Technique Code-BU, Method Code -BROAD)
PLAN_SILV_OBJECTIVE_CODE_1 PLNSLVBJCT VARCHAR2 3 The PLAN SILV OBJECTIVE CODE 1 describes the objective for performing the planned silviculture activity.
PLAN_SILV_OBJECTIVE_CODE_2 PLNSLVBJC1 VARCHAR2 3 The PLAN SILV OBJECTIVE CODE 2 describes the objective for performing the planned silviculture activity.
PLAN_SILV_OBJECTIVE_CODE_3 PLNSLVBJC2 VARCHAR2 3 The PLAN SILV OBJECTIVE CODE 3 describes the objective for performing the planned silviculture activity.
PLAN_SILV_FUND_SRCE_CODE PLND_FUND VARCHAR2 3 The PLAN SILV FUND SRCE CODE describes the planned funding source for the planned silviculture activity on the opening.
PLANNED_DATE PLND_DT DATE 7 The PLANNED DATE is the planned date for the disturbance or silviculture activity either specify by the user or derived through treatment regime.
PLANNED_TREATMENT_AREA PLNNDTRTMN NUMBER 11 The PLANNED TREATMENT AREA is the planned amount (based on reported unit of measure) for the disturbance/silviculture activity. Majority of activity reporting will be in hectares.
PLANNED_TREATMENT_COST PLND_COST NUMBER 9 The PLANNED TREATMENT COST is the planned estimated silviculture cost for the silviculture treatment.
SILVICULTURE_PROJECT_ID SLVCLTRPRJ VARCHAR2 13 The SILVICULTURE PROJECT ID is a RESULTS system-generated unique identifier is assigned to an activity which identified a unit within a RESULTS's project.
FIA_PROJECT_ID FIA_PRJ_ID VARCHAR2 10 The FIA PROJECT ID is a unique identifier provided by user that links to other agencies' databases "Inter-agency Number".
DISTURBANCE_CODE DISTURB_CD VARCHAR2 3 The DISTURBANCE CODE is the disturbance origin for the disturbance activity. Some of the Disturbance Code include: L-Logged, B-Burned, S-Salvage, W-Windrow, etc.
SILV_SYSTEM_CODE SYS_CD VARCHAR2 5 The SILV SYSTEM CODE describes the silvicultural systems used for the harvesting activity. Eg. CLEAR-Clearcut, CCRES-Clearcut with reserves, SELEC-Selection, SHELT-Shelterwood, etc.
SILV_SYSTEM_VARIANT_CODE SYS_VR_CD VARCHAR2 3 The SILV VARIANT CODE describes the silvcultural system's distribution or removal pattern of the silvicultural system. Eg. GRP-Group; IRR-Irregular; SIN-Single, etc.
SILV_CUT_PHASE_CODE CUT_PH_CD VARCHAR2 5 The SILV CUT PHASE CODE is the code for the actual silvicultural system cut phase. The cut phase of a silvicultural system variant describes the function of a harvest to extract merchantable timber and achieve regeneration.
CUT_BLOCK_OPEN_ADMIN_ID CB_OPEN_ID NUMBER 10 The CUT BLOCK OPEN ADMIN ID is a RESULTS system-generated unique identifier that associates the tenure (licence, cutting permit, timbermark, cutblock) that is reported for disturbance activity.
DISTURBANCE_COMPLETED_IND DST_CMP_YN VARCHAR2 1 The DISTURBANCE COMPLETED IND is a Yes/No indicator set by the licensee/submitter for the disturbance to identify harvesting is complete on the cutblock. When the indicator is set to "Yes", the cutblock status changes to LC-Logging Complete.
GEOMETRY_EXIST_IND GMTRXSTND VARCHAR2 1 The GEOMETRY EXIST IND indicates if there is geometry for the opening. A value of 'Y' indicates there is geometry. A value of 'N' indicates there is no geometry.
FEATURE_AREA FTRR NUMBER 11 The FEATURE AREA is the area of the feature in square meters.
FEATURE_PERIMETER FTRPRMTR NUMBER 11 The FEATURE PERIMETER is the perimeter of the feature in meters.
CAPTURE_METHOD_CODE CAP_MTH_CD VARCHAR2 30 The CAPTURE METHOD CODE is a code defining the capture method. (e.g. digitize).
DATA_SOURCE_CODE DAT_SRC_CD VARCHAR2 10 The DATA SOURCE CODE is a code defining the source of the spatial feature (e.g. GPS, TRIM).
FEATURE_CLASS_SKEY FEAT_CL NUMBER 10 The FEATURE CLASS SKEY is the unique key assigned to a Feature Class by the Ministry of Forests.
OBSERVATION_DATE OBSERV_DT DATE 7 The OBSERVATION DATE is the geometry collection date.
DATA_QUALITY_COMMENT DATA_QLTY VARCHAR2 255 The DATA QUALITY COMMENT is a comment indicating the Geometry accuracy.
ATU_WHO_CREATED TWHCRTD VARCHAR2 30 The ATU WHO CREATED is the USERID of the individual who created the activity record.
ATU_WHEN_CREATED TWHNCRTD DATE 7 The ATU WHO UPDATED is the date and time when the activity record was created.
ATU_WHO_UPDATED TWHPDTD VARCHAR2 30 The ATU WHEN UPDATED is the USERID of the individual who last updated the activity record.
ATU_WHEN_UPDATED TWHNPDTD DATE 7 THE ATU WHEN UPDATED is the date and time when the activity record was last updated.
FEATURE_AREA_SQM NUMBER 19
FEATURE_LENGTH_M NUMBER 19
GEOMETRY GEOMETRY SDO_GEOMETRY 64 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000