RESULTS - Planting

349 views (15 recent)

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

Planting activities reported on openings into RESULTS. More than one planting activitiy may occur within an opening. Planting activiites may also overlap. Planting attribute reporting is mandatory requirement while planting maps are optional. Planting reports includes species and seedlot information. This is a part of Silviculture and Land Status dataset, which includes tracking achievement of 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 provide planting reports 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-03-09
Record Last Modified 2019-09-05
Resource Status completed

Object Description

Object Name: WHSE_FOREST_VEGETATION.RSLT_PLANTING_SVW

Short Name: RSLT_PLNTG
Comments: The spatial representation for a planting activity that occurs within an opening. Specific information about the planting activity, including the tree species planted and the where the trees were sourced from (seedlot or veg lot) are included.

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 55 The default label to be used when displaying the feature on a map. Consists of the SILV TREE SPECIES CODE, NUMBER PLANTED, and ATU COMPLETION DATE.
SILV_BASE_CODE ACT_BASE VARCHAR2 2 The SILV BASE CODE identifies primary category of the completed planting activity: PL-Planting
SILV_TECHNIQUE_CODE ACT_TECH VARCHAR2 2 The SILV TECHNIQUE CODE describes the broad category of technique associated with the completed planting activity (eg. PL-Planting, FP-Fill Planting; RP-Replanting)
SILV_METHOD_CODE ACT_METH VARCHAR2 5 The SILV METHOD CODE describes the specific machinery or method used for the planned silviculture activity base/technique combination (eg. Planting/Planting/Containert: Base Code-PL Technique Code-PL Method Code -CTAIN)
SILV_OBJECTIVE_CODE_1 ACT_OBJ1 VARCHAR2 3 The SILV OBJECTIVE CODE 1 describes the objective for performing the completed planting activity.
SILV_OBJECTIVE_CODE_2 ACT_OBJ2 VARCHAR2 3 The SILV OBJECTIVE CODE 2 describes the objective for performing the completed planting activity.
SILV_OBJECTIVE_CODE_3 ACT_OBJ3 VARCHAR2 3 The SILV OBJECTIVE CODE 3 describes the objective for performing the completed planting activity.
SILV_FUND_SOURCE_CODE ACT_FUND VARCHAR2 3 The SILV FUND SOURCE CODE describes the actual funding source for the completed planting activity on the opening.
ATU_COMPLETION_DATE ACT_DATE DATE 7 The ATU COMPLETION DATE is the planting completion date for the activity.
ACTUAL_TREATMENT_AREA ACT_AREA NUMBER 11 The ACTUAL TREATMENT AREA is the completed amount (based on reported unit of measure) for the planting activity in hectares.
ACTUAL_TREATMENT_COST ACT_COST NUMBER 9 The ACTUAL TREATMENT COST is the cost for the completed planted treatment.
SILVICULTURE_PROJECT_ID SIL_PRJ_ID 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 submitter that links to other agencies' databases "Inter-agency Number".
PLANTING_RESULTS_SEQ_NUMBER PL_SEQ_NO NUMBER 5 The PLANTING RESULTS SEQ NUMBER is a system-generated number to order the species reported into RESULTS for the planting activity
SILV_TREE_SPECIES_CODE PL_SPP VARCHAR2 8 The SILV TREE SPECIES CODE is the tree species for the completed planting activity for the seedlot/veglot. Note that each species seedlot/veglot is reported separately.
NUMBER_PLANTED PL_NO NUMBER 10 The NUMBER PLANTED is the number of trees planted for the tree species seedlot/veglot for the planted activity. Note that each species seedlot/veglot is reported separately.
PLANTED_NO_BEYOND_XFER_LIMIT PL_NO_BEY NUMBER 10 The PLANTED NO BEYOND XFER LIMIT is the number of trees planted beyond the seed transfer limit guidelines for the species seedlot/veglot for the activity.
SEEDLOT_NUMBER SEEDLOT_NO VARCHAR2 5 The SEEDLOT NUMBER is the unique number (key) assigned by SPAR to seed source and quality collected at a given time and location.
VEG_LOT_ID VEG_LOT_ID VARCHAR2 5 The VEG LOT ID is the unique number (key) assigned by SPAR to vegetative cutting collected at a given time and location.
REQUEST_SKEY REQ_SKEY NUMBER 10 The REQUEST ID is a unique planting request number form SPAR which indicates the ordered seedlings. This field is optional.
GENETIC_CLASS_CODE GEN_CL_CD VARCHAR2 1 The GENETIC CLASS CODE is a code which represents the genetic quality of material (seed or cuttings). 'A' class represents superior orchard produced seed or cuttings. 'B' class represents naturally collected seed or cuttings.
SUPERIOR_PROVIDENCE_IND S_PROV_YN VARCHAR2 1 The SUPERIOR PROVIDENCE IND is an indicator identifying whether the material originated from a superior provenance ('Y' - yes) or not ('N' - No).
REGISTERED_SEED_IND REGIS_YN VARCHAR2 1 The REGISTERED SEED IND is an indicator which represents whether a seed lot is registered for crown land reforestation use ('Y' yes) or not ('N' no).
GEOMETRY_EXIST_IND GEOM_YN 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 FEAT_AREA NUMBER 11 The FEATURE AREA is the area of the feature in square meters.
FEATURE_PERIMETER FEAT_PERIM 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 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 CREAT_BY VARCHAR2 30 The ATU WHO CREATED is the USERID of the individual who created the activity record.
ATU_WHEN_CREATED CREAT_DT DATE 7 The ATU WHO UPDATED is the date and time when the activity record was created.
ATU_WHO_UPDATED UPDATE_BY VARCHAR2 30 The ATU WHEN UPDATED is the USERID of the individual who last updated the activity record.
ATU_WHEN_UPDATED UPDATE_DT DATE 7 THE ATU WHEN UPDATED is the date and time when the activity record was last updated.
FEATURE_CLASS_SKEY FEAT_CL NUMBER 10 The DATA SOURCE CODE is a code defining the source of the spatial feature (e.g. GPS, TRIM).
FEATURE_AREA_SQM FEAT_AREA NUMBER 19
FEATURE_LENGTH_M FEAT_LEN 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