Vegetative Lot Table

148 views (1 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - Tree Improvement
Licensed under Access Only

Vegetative Lot ID is a unique identifier for a quantity of forest tree seed of a particular species from a given natural stand location or a vegetative orchard, collected at a given time (date range). Several attributes for a vegetative lot are recorded in the VEG_LOT table including the mean collection geographic coordinates (latitude/longitude), minimum/maximum collection elevation, Seed Planning Zone, etc. The Chief Forester's Standards for Seed Use lists the mandatory attribute information that must be included when a seedlot is submitted for registration in the Seed Planning and Registry application SPAR).

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Vegetative lot refers to a selection of vegetative material assembled for registration in the Seed Planning and Registry application following the Chief Forester's Standards for Seed Use.

Data Quality
Lineage Statement

Based on the boundaries of the seed planning zones and the elevation constraints identified for the spus

Contact Information

NameSusan Zedel (pointOfContact)
EmailSusan.Zedel@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationTree Improvement
NameLeslie McAuley (pointOfContact)
EmailLeslie.McAuley@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationTree Improvement

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-15
Record Last Modified 2017-01-16
Resource Status onGoing

Object Description

Object Name: WHSE_FOREST_VEGETATION.SEED_VEG_LOT

Short Name: SDVGLT
Comments: snapshot table for snapshot WHSE_FOREST_VEGETATION.SEED_VEG_LOT

Column Name Short Name Data Type Data Precision Comments
VEG_LOT_ID VEG_LOT_ID VARCHAR2 15
VEGETATION_CODE VGTTNCD VARCHAR2 24
GENETIC_CLASS_CODE GNTCCLSSCD VARCHAR2 3
COLLECTION_SOURCE_CODE CLLCTNSRCC VARCHAR2 6
SUPERIOR_PRVNC_IND SPRRPRVNCN VARCHAR2 3
REGISTERD_CTNG_IND RGSTRDCTNG VARCHAR2 3
ELEVATION ELEVATION NUMBER 5
ELEVATION_MIN LVTNMN NUMBER 5
ELEVATION_MAX LVTNMX NUMBER 5
NAD_DATUM_CODE NDDTMCD VARCHAR2 6
UTM_ZONE UTM_ZONE NUMBER 5
UTM_EASTING TMSTNG NUMBER 10
UTM_NORTHING TMNRTHNG NUMBER 10
LONGITUDE_DEGREES LNGTDDGRS NUMBER 3
LONGITUDE_MINUTES LNGTDMNTS NUMBER 2
LONGITUDE_DEG_MIN LNGTDDGMN NUMBER 3
LONGITUDE_MIN_MIN LNGTDMNMN NUMBER 2
LONGITUDE_DEG_MAX LNGTDDGMX NUMBER 3
LONGITUDE_MIN_MAX LNGTDMNMX NUMBER 2
LATITUDE_DEGREES LTTDDGRS NUMBER 2
LATITUDE_MINUTES LTTDMNTS NUMBER 2
LATITUDE_DEG_MIN LTTDDGMN NUMBER 2
LATITUDE_MIN_MIN LTTDMNMN NUMBER 2
LATITUDE_DEG_MAX LTTDDGMX NUMBER 2
LATITUDE_MIN_MAX LTTDMNMX NUMBER 2
BGC_ZONE_CODE BGCZNCD VARCHAR2 12
BGC_SUBZONE_CODE BGCSBZNCD VARCHAR2 9
VARIANT VARIANT VARCHAR2 3
SEED_COAST_AREA_CODE SDCSTRCD VARCHAR2 9
ORCHARD_ID ORCHARD_ID VARCHAR2 9
SOURCE_LOT_NUMBER SRCLTNMBR VARCHAR2 15
SEED_ORCHARD_ID SDRCHRDD VARCHAR2 9
REVISION_COUNT RVSNCNT NUMBER 5
COLLECTION_LOCN_DESC CLLCTNLCND VARCHAR2 90
SRCE_INFO SRCE_INFO VARCHAR2 150

Comments

No comments have been posted yet.