Wildlife Species Inventory Wildlife Observations - Sensitive (View)

206 views (2 recent)

Published by the Ministry of Environment and Climate Change Strategy - Knowledge Management
Licensed under Access Only

(DEPRECATED) Wildlife Species Inventory Wildlife Observations - Sensitive (View). Superseded by: WHSE_WILDLIFE_INVENTORY.SPI_SURVEY_OBS_ALL_SP

Data and Resources

Dataset Extent

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

Additional Information


The dataset was created to provide better information for wildlife management, the protection of biodiversity and to support the Forest Practice Code. The intent on having a central repository for inventory data is to facilitate the storage and access of inventory results needed to make informed management decisions.

Lineage Statement

Data from inventories conducted all over the province has either been directly entered into the SPI_DC data capture tool or uploaded to it using a MS Excel Template Tool and MS Access Import Tool.

More Information

Contact Information

NameWildlife Species Inventory Mailbox (pointOfContact)
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge 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 2019-02-06
Resource Status obsolete
Replacement Recordhttps://catalogue.data.gov.bc.ca/dataset/b0a8767d-b78d-40f9-a9ad-5f0418090e39

Object Description


Short Name: SPI_W_SENV
Comments: SPI WILDLIFE SENSITIVE SVW provides data about non-telemetric wildlife observations that is considered of a sensitive nature. It is used for replication to SPI WILDLIFE SENSITIVE SP, using FME.

Column Name Short Name Data Type Data Precision Comments
SPECIES_CODE SPCSCD VARCHAR2 105 Code commonly used to identify a taxon
SPECIES_ENGLISH_NAME SPCSNGLSHN VARCHAR2 150 The common English name of the species
OBSERVED_NUMBER BSRVDNMBR NUMBER 5 The number of individuals detected during an observation.
OBSERVATION_DATE BSRVTNDT DATE 8 The date this detection point data was collected
OBSERVATION_TIME BSRVTNTM VARCHAR2 5 The time this detection point data was collected in 24-hour format HH:MI
OBSERVATION_DATE_TIME BSRVTNDTTM DATE 7 The date and time this detection point data was collected
OBSERVATION_ID BSRVTND NUMBER 10 System generated identifier for Wildlife Observation.
COMMENTS COMMENTS VARCHAR2 1024 Additional comments about the observation
PROJECT_NAME PRJCTNM VARCHAR2 600 The name of the inventory project that collected this point data
PROJECT_ID PROJECT_ID NUMBER 10 A system generated unique identifier of the inventory project that collected this point data
SURVEY_NAME SRVNM VARCHAR2 300 The name of the survey as assigned by the project leader.
SURVEY_METHOD SRVMTHD VARCHAR2 300 The name of the surveying method used for the survey that collected this data point
PROJECT_WEB_PAGE PRJCTWBPG VARCHAR2 154 A Uniform Resource Locator (URL) for reports associated with the observation
UTM_ZONE UTM_ZONE NUMBER 4 Universal Trans Mercator (UTM) Zone coordinate
UTM_EASTING TMSTNG NUMBER 6 Universal Trans Mercator (UTM) Easting coordinate
UTM_NORTHING TMNRTHNG NUMBER 7 Universal Trans Mercator (UTM) Northing coordinate
WLO_DRAFT_IND WLDRFTND VARCHAR2 3 Indicates whether or not this is a draft verion of the WildLife Observation
FEATURE_CODE FTRCD VARCHAR2 10 A feature code is a means of linking a geographic feature to its name and definition
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.