Vegetative Lot

173 views (2 recent)

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

Vegetative Lot MVW is a materialized view of the VEG_LOT_POINT geometry and includes attribute data from the VEG_LOT table.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Vegetative lot point geometry provides the mean collection source of a vegetative lot in the Seed Planning and Registry application following the Chief Forester's Standards for Seed Use .

Data Quality
Lineage Statement

Based on Seed Planning and Registry System user intrepretion of the Natural Stand seedlot collection area, drawn by the user in the SeedMap environment at time of seedlot registartion.

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? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_FOREST_VEGETATION.SEED_VEG_LOT_POINT_MVW

Short Name: SDVGLTPNTM
Comments: snapshot table for snapshot WHSE_FOREST_VEGETATION.SEED_VEG_LOT_POINT_MVW

Column Name Short Name Data Type Data Precision Comments
VEG_LOT_ID VEG_LOT_ID VARCHAR2 45 The unique identifier (key) assigned to a source of cuttings of a particular species with the same genetic class and suitability factors.
ACTIVE_IND ACTIVE_IND VARCHAR2 3 'Y' when active, 'N' otherwise.
VEGETATION_CODE VGTTNCD VARCHAR2 72 A code describing various Vegetation Species.
COLLECTION_LATITUDE CLLCTNLTTD VARCHAR2 122
COLLECTION_LONGITUDE CLLCTNLNGT VARCHAR2 122
COLLECTION_ELEVATION CLLCTNLVTN VARCHAR2 126
BEC_ZONE BEC_ZONE VARCHAR2 30
SUPERIOR_PRVNC_IND SPRRPRVNCN VARCHAR2 9 'Y' when a superior provenance id exists, 'N' otherwise
USE_LATITUDE_MEAN SLTTDMN VARCHAR2 122 The latitude for the Cutting Lot.
USE_LATITUDE_MIN SLTTDMN1 VARCHAR2 81 The latitude for the Cutting Lot.
USE_LATITUDE_MAX SLTTDMX VARCHAR2 81 The latitude for the Cutting Lot.
USE_LONGITUDE_MEAN SLNGTDMN VARCHAR2 122 The logitude for the Cutting Lot.
USE_LONGITUDE_MIN SLNGTDMN1 VARCHAR2 81 The logitude for the Cutting Lot.
USE_LONGITUDE_MAX SLNGTDMX VARCHAR2 81 The logitude for the Cutting Lot.
USE_ELEVATION SLVTN VARCHAR2 126 The representative elevation in meters where the cutting lot parent trees originated.
MORE_INFO MORE_INFO VARCHAR2 99 Additional Information in the form of a URL.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 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

Comments

No comments have been posted yet.