Seed Planning Unit Table

144 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

Seed Planning Unit Table lists valid combinations of Seed Planning Zones (SPZ) and elevation ranges. Each SEED_PLAN_UNIT_ID relates to a SEED_PLAN_ZONE for a specific tree species and minimum/maximum elevation in meters. Seed Planning Units only apply to Genetic Class A (orchard/parent tree). Some coastal species also have a latitude range. SPUs are designated as Primary (Y or N) for use in the Seed Planning and Registry application. SPUs may have a Program Rank and Total Seedling Requirements from the Forest Genetics Council of BC business plan.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Seed Planning Units are used for forest genetics tree breeding, parent tree registration, seedlot registration and planning for seed orchard development. Seed Plan Unit table originates in the Seed Planning and Registry database (SPAR).

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-16
Record Last Modified 2017-01-16
Resource Status onGoing

Object Description

Object Name: WHSE_FOREST_VEGETATION.SEED_PLAN_UNIT

Short Name: SDPLNNT

Column Name Short Name Data Type Data Precision Comments
SEED_PLAN_UNIT_ID SDPLNNTD NUMBER 10
PRIMARY_IND PRMRND VARCHAR2 1
SEED_PLAN_ZONE_ID SDPLNZND NUMBER 10
ELEVATION_BAND LVTNBND VARCHAR2 10
ELEVATION_MAX LVTNMX NUMBER 5
ELEVATION_MIN LVTNMN NUMBER 5
CREATE_DATE CRTDT DATE 7
LATITUDE_BAND LTTDBND VARCHAR2 5
LATITUDE_DEGREES_MIN LTTDDGRSMN NUMBER 2
LATITUDE_MINUTES_MIN LTTDMNTSMN NUMBER 2
LATITUDE_DEGREES_MAX LTTDDGRSMX NUMBER 2
LATITUDE_MINUTES_MAX LTTDMNTSMX NUMBER 2
PROGRAM_RANK PRGRMRNK NUMBER 3
TOTAL_SEEDLING_REQUIREMENTS TTLSDLNGRQ NUMBER 5
UPDATE_DATE PDTDT DATE 7
REVISION_COUNT RVSNCNT NUMBER 5