Seedlot Table

108 views (2 recent)

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

Seedlot number is a unique identifier for a quantity of forest tree seed of a particular species from a given natural stand location or a seed orchard, collected at a given time (date range). Several attributes for a seedlot are recorded in the SEEDLOT 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

Seedlot refers to forest tree seed that is collected and assembled for registration. Seedlots are registered in the Seed Planning and Registry system, tested and stored at the Tree Seed Centre.

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-OrganizationForest Improvement and Research Management
NameLeslie McAuley (pointOfContact)
EmailLeslie.McAuley@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationForest Improvement and Research Management

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_SEEDLOT

Short Name: SDSDLT

Column Name Short Name Data Type Data Precision Comments
SEEDLOT_NUMBER SDLTNMBR VARCHAR2 15
SEEDLOT_STATUS_CODE SDLTSTTSCD VARCHAR2 9
VEGETATION_CODE VGTTNCD VARCHAR2 24
GENETIC_CLASS_CODE GNTCCLSSCD VARCHAR2 3
COLLECTION_SOURCE_CODE CLLCTNSRCC VARCHAR2 6
SUPERIOR_PRVNC_IND SPRRPRVNCN VARCHAR2 3
ORG_UNIT_NO RGNTN NUMBER 10
REGISTERED_SEED_IND RGSTRDSDND VARCHAR2 3
TO_BE_REGISTRD_IND TBRGSTRDND VARCHAR2 3
REGISTERED_DATE RGSTRDDT DATE 7
FS721A_SIGNED_IND FS721SGNDN VARCHAR2 3
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_SECONDS LNGTDSCNDS 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_SECONDS LTTDSCNDS 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
SEED_COAST_AREA_CODE SDCSTRCD VARCHAR2 9
ELEVATION ELEVATION NUMBER 5
ELEVATION_MIN LVTNMN NUMBER 5
ELEVATION_MAX LVTNMX NUMBER 5
ORCHARD_ID ORCHARD_ID VARCHAR2 9
COLLECTION_LOCN_DESC CLLCTNLCND VARCHAR2 90
COLLECTION_CLI_NUMBER CLLCTNCLNM VARCHAR2 24
COLLECTION_CLI_LOCN_CD CLLCTNCLLC VARCHAR2 6
COLLECTION_START_DATE CLLCTNSTRT DATE 7
COLLECTION_END_DATE CLLCTNNDDT DATE 7
CONE_COLLECTION_METHOD_CODE CNCLLCTNMT VARCHAR2 9
NO_OF_CONTAINERS NFCNTNRS NUMBER 6
CLCTN_VOLUME CLCTNVLM NUMBER 6
VOL_PER_CONTAINER VLPRCNTNR NUMBER 6
NMBR_TREES_FROM_CODE NMBRTRSFRM VARCHAR2 3
EFFECTIVE_POP_SIZE FFCTVPPSZ NUMBER 5
ORIGINAL_SEED_QTY RGNLSDQT NUMBER 10
INTERM_STRG_ST_DATE NTRMSTRGST DATE 7
INTERM_STRG_END_DATE NTRMSTRGND DATE 7
INTERM_FACILITY_CODE NTRMFCLTCD VARCHAR2 9
EXTRACTION_ST_DATE XTRCTNSTDT DATE 7
EXTRACTION_END_DATE XTRCTNNDDT DATE 7
EXTRACTION_VOLUME XTRCTNVLM NUMBER 6
EXTRCT_CLI_NUMBER XTRCTCLNMB VARCHAR2 24
EXTRCT_CLI_LOCN_CD XTRCTCLLCN VARCHAR2 6
STORED_CLI_NUMBER STRDCLNMBR VARCHAR2 24
STORED_CLI_LOCN_CD STRDCLLCNC VARCHAR2 6
LNGTERM_STRG_ST_DATE LNGTRMSTRG DATE 7
HISTORICAL_TSR_DATE HSTRCLTSRD DATE 7
COLLECTION_LAT_DEG CLLCTNLTDG NUMBER 2
COLLECTION_LAT_MIN CLLCTNLTMN NUMBER 2
COLLECTION_LAT_SEC CLLCTNLTSC NUMBER 2
COLLECTION_LATITUDE_CODE CLLCTNLTTD VARCHAR2 6
COLLECTION_LONG_DEG CLLCTNLNGD NUMBER 3
COLLECTION_LONG_MIN CLLCTNLNGM NUMBER 2
COLLECTION_LONG_SEC CLLCTNLNGS NUMBER 2
COLLECTION_LONGITUDE_CODE CLLCTNLNGT VARCHAR2 6
COLLECTION_ELEVATION CLLCTNLVTN NUMBER 5
COLLECTION_ELEVATION_MIN CLLCTNLVT2 NUMBER 5
COLLECTION_ELEVATION_MAX CLLCTNLVT1 NUMBER 5
ENTRY_TIMESTAMP NTRTMSTMP DATE 7
ENTRY_USERID NTRSRD VARCHAR2 90
UPDATE_TIMESTAMP PDTTMSTMP DATE 7
UPDATE_USERID PDTSRD VARCHAR2 90
APPROVED_TIMESTAMP PPRVDTMSTM DATE 7
APPROVED_USERID PPRVDSRD VARCHAR2 90
REVISION_COUNT RVSNCNT NUMBER 5
INTERM_STRG_LOCN NTRMSTRGLC VARCHAR2 165
INTERM_STRG_CMT NTRMSTRGCM VARCHAR2 375
OWNERSHIP_COMMENT WNRSHPCMMN VARCHAR2 4000
CONE_SEED_DESC CNSDDSC VARCHAR2 750
EXTRACTION_COMMENT XTRCTNCMMN VARCHAR2 375
SEEDLOT_COMMENT SDLTCMMNT VARCHAR2 4000
BGC_ZONE_CODE BGCZNCD VARCHAR2 12
BGC_SUBZONE_CODE BGCSBZNCD VARCHAR2 9
VARIANT VARIANT VARCHAR2 3