Wildlife Species Inventory Feature Observations - All

349 views (5 recent)

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

A wildlife feature observation is an encounter with the a habitat feature (e.g. nest, or wildlife tree) for the focal species (taxa). An observation is made when a surveyor makes a visit to a Design Component on a specific date at a specific time. Each observation may be geo-referenced in itself or simply by association with a specific Design Component. Observations are recorded on the General Survey form, and may include information on species, sex, age class, activity, and/or measurements, depending on whether the animal is in-hand or roaming free. Sensitive information means: any information on a species at risk that in the opinion of the Director, Ecosystems Branch, Ministry of Environment (MoE) or a Regional Environmental Stewardship manager (MoE) could reasonably be expected to result in damage to the species, the residence of a species or the population, or interfere with the conservation of that species at risk, if the location were to be disclosed.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The dataset was created to provide better information for wildlife management, the protection of biodiversity. 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.

Contact Information

NameWildlife Species Inventory Mailbox (pointOfContact)
EmailSPI_Mail@gov.bc.ca
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 2017-04-12
Resource Status onGoing

Object Description

Object Name: WHSE_WILDLIFE_INVENTORY.SPI_FEATURE_OBS_ALL_SP

Short Name: SPFTRBSLLS
Comments: All Wildlife Habitat Feature (WHF) observations of wildlife that originate from the Species Inventory (SPI) database. These WHF observations are joined with various attributes from various Oracle tables to provide metadata, location, and species information about each observation.

Column Name Short Name Data Type Data Precision Comments
FEATURE_OBSERVATION_ID FTRBSRVTND NUMBER 10 FEATURE OBSERVATION ID is a unique identifier for a wildlife habitat feature observation as supplied by the business area which is used as the primary key.
FEATURE_LABEL FTRLBL VARCHAR2 50 FEATURE LABEL is a unique identifier manually assigned to the wildlife habitat feature.
OBSERVED_NUMBER BSRVDNMBR NUMBER 5 OBSERVED NUMBER is the number of wildlife habitat features detected at the point location.
FEATURE_TYPE FTRTP VARCHAR2 100 FEATURE TYPE is the type of wildlife habitat feature observed. e.g., Nest.
ACTIVE_FEATURE CTVFTR VARCHAR2 100 ACTIVE FEATURE is a flag to indicate whether the wildlife habitat feature was active or not, or unknown. Valid values are Y, N, and UN (unknown).
SPECIES_CODE SPCSCD VARCHAR2 35 SPECIES CODE is a unique Resource Information Standards Committee (RISC) standard code for a plant or animal species, based on its scientific or common name. e.g., M-URAR
SPECIES_ENGLISH_NAME SPCSNGLSHN VARCHAR2 50 SPECIES ENGLISH NAME is a standard provincial English name of the species or taxa. e.g., Grizzly Bear
SCIENTIFIC_NAME SCNTFCNM VARCHAR2 150 SCIENTIFIC NAME is a standard provincial scientific name of the species or taxa. e.g., Ursus arctos
BCSEE_SPECIES_CODE_URL BCSSPCSCDR VARCHAR2 255 BCSEE SPECIES CODE URL is a standard web interface for deep-linking to the British Columbia Species and Ecosystem Explorer search engine using the species code or Element Subnational ID.
OBSERVATION_DATETIME BSRVTNDTTM DATE 7 OBSERVATION DATETIME is the date and time that a species was observed.
OBSERVATION_YEAR BSRVTNR NUMBER 4 OBSERVATION YEAR is the year, in 4-digit format, that a species was observed.
OBSERVATION_MONTH BSRVTNMNTH NUMBER 2 OBSERVATION MONTH is the month (1 through 12) that a species was observed.
OBSERVATION_DAY BSRVTND NUMBER 2 OBSERVATION DAY is the day (1 through 31) that a species was observed.
UTM_ZONE UTM_ZONE NUMBER 4 UTM ZONE is a segment of the Earth's surface 6 degrees of longitude in width. The zones are numbered eastward starting at the meridian 180 degrees from the prime meridian at Greenwich. There are five zones numbered 7 through 11 that cover British Columbia, e.g., Zone 10 with a central meridian at -123 degrees.
UTM_EASTING TMSTNG NUMBER 6 UTM EASTING is the distance in meters eastward to or from the central meridian of a UTM zone with a false easting of 500000 meters.
UTM_NORTHING TMNRTHNG NUMBER 7 UTM NORTHING is the distance in meters northward from the equator.
LATITUDE LATITUDE NUMBER 8 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653
LONGITUDE LONGITUDE NUMBER 8 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544
OBSERVER_NAME BSRVRNM VARCHAR2 512 OBSERVER NAME is the full name of the person who observed the wildlife habitat feature.
COMPANY_NAME CMPNNM VARCHAR2 100 COMPANY NAME is the company or affiliation of the Forest Licensee.
TREE_SPECIES TRSPCS VARCHAR2 100 TREE SPECIES is the code that uniquely identifies the species of tree in which the feature is located.
TREE_DECAY_CLASS TRDCCLSS VARCHAR2 100 TREE DECAY CLASS is the standard decay class of the tree using the BC Wildlife tree classification system. e.g., D1
TREE_DBH TREE_DBH VARCHAR2 100 TREE DBH is diameter at Breast Height (DBH) of feature trees in centimetres.
TREE_HT TREE_HT VARCHAR2 100 TREE HT is height of feature trees in metres.
PHYS_DESC PHYS_DESC VARCHAR2 100 PHYS DESC is physical description, qualitative estimate of feature condition, indicating whether the wildlife habitat feature is intact and appears to be in good useable condition, etc.
FRPA_WHF_IND FRPWHFND VARCHAR2 100 FRPA WHF IND is a flag indicating whether this feature is designated as a wildlife feature in the FRPa (Forest and Range Practices Act). Valid values are Y and N.
NOTES NOTES VARCHAR2 2000 NOTES is Informative notes regarding this wildlife feature observation.
PROJECT_NAME PRJCTNM VARCHAR2 200 PROJECT NAME is the name of a wildlife species inventory project.
PROJECT_ID PROJECT_ID NUMBER 10 PROJECT ID is the unique numerical identifier of a wildlife species inventory project in the SPI database.
PROJECT_WEB_PAGE PRJCTWBPG VARCHAR2 255 PROJECT WEB PAGE is the standard web interface for deep-linking to the Species Inventory Web Explorer search engine using the project ID.
PROJECT_COORDINATOR PRJCTCRDNT VARCHAR2 70 PROJECT COORDINATOR is the full name of the main contact for this project.
GLOBAL_RANK GLBLRNK VARCHAR2 15 GLOBAL RANK is the global conservation status rank for the observed species or natural plant community, assigned by NatureServe International.
PROVINCIAL_RANK PRVNCLRNK VARCHAR2 15 PROVINCIAL RANK is the sub-national (provincial) conservation status rank for the observed species or natural plant community, assigned by the CDC.
PROVINCIAL_LIST PRVNCLLST VARCHAR2 15 PROVINCIAL LIST is the provincial List status for the observed species or natural plant community. Possible values are; RED, BLUE, YELLOW, INTRODUCED, ACCIDENTAL, EXTINCT and SPECIAL. SPECIAL records include record sized trees.
COSEWIC_CD COSEWIC_CD VARCHAR2 10 COSEWIC CD is a Code indicating the Committee on the Status of Endangered Wildlife in Canada (COSEWIC) designation for the observed species ( http://www.cosewic.gc.ca/)
COSEWIC_CD_DATE CSWCCDDT VARCHAR2 11 COSEWIC CD DATE is the date the Committee on the Status of Endangered Wildlife in Canada (COSEWIC) Code was granted.
COSEWIC_COMMENT CSWCCMMNT VARCHAR2 512 COSEWIC COMMENT is the comment associated with the attribute COSEWIC CD.
ENDEMIC_TO_BC NDMCTBC VARCHAR2 3 ENDEMIC TO BC is a flag indicating whether the observed species is endemic to BC. Possible values are Y or N.
BREEDS_IN_BC BRDSNBC VARCHAR2 1 BREEDS IN BC is a flag indicating whether the observed species breeds in BC or uses the province only as a migratory corridor or wintering habitat. Possible values are Y or N.
IDENTIFIED_WILDLIFE_CD DNTFDWLDLF VARCHAR2 1 IDENTIFIED WILDLIFE CD indicates whether the observed species has subnational protection via Identified Wildlife. Possible values are Y or N.
IDENTIFIED_WILDLIFE_DATE DNTFDWLDL2 VARCHAR2 11 IDENTIFIED WILDLIFE DATE is the date the Identified Wildlife Status was granted.
IDENTIFIED_WILDLIFE_COMMENT DNTFDWLDL1 VARCHAR2 255 IDENTIFIED WILDLIFE COMMENT is comments relevant to the Identified Wildlife Code (IDENTIFIED WILDLIFE CD)
WILDLIFE_ACT_STATUS WLDLFCTSTT VARCHAR2 15 WILDLIFE ACT STATUS is the Provincial Wildlife Act status code for the observed species. e.g., Endangered
FURBEARER FURBEARER VARCHAR2 1 FURBEARER is a flag indicating whether the observed species is designated as a Furbearer according to BC Hunting and Trapping Regulations. e.g., Y or N
ACCIDENTAL_ID CCDNTLD NUMBER 1 ACCIDENTAL ID is the numeric value of the accidental status of the observed species in BC. ID Values/Descriptions are: 1 - Regularly occurring, 2 -Accidental/Nonregular, 3 - Unknown/Undetermined
EXOTIC_ID EXOTIC_ID NUMBER 1 EXOTIC ID is the ID describing the observed species exotic status to BC. Possible ID /Description options are: 1 -Native, 2 - Exotic, 3 -Unknown/Undetermined.
SPECIES_TRACKED_BY_CDC SPCSTRCKDB VARCHAR2 3 SPECIES TRACKED BY CDC is a flag indicating whether the observed species is tracked by the Conservation Data Centre. Possible values are Y or N.
ELEMENT_OCCURANCE_EXISTS LMNTCCRNCX VARCHAR2 3 ELEMENT OCCURANCE EXISTS is a flag indicating whether the Conservation Data Centre has any Element Occurrences (EOs) recorded for the observed species. Possible values are Y or N.
CF_PRIORITY_HIGHEST CFPRRTHGHS VARCHAR2 30 CF PRIORITY HIGHEST is the Conservation Framework highest priority rank (1-6) of the observed species received across the three goals.
SARA_SCHEDULE SRSCHDL VARCHAR2 3 SARA SCHEDULE is the Species at Risk Act (SARA) schedule number for the observed species.
NATIONAL_GENERAL_STATUS NTNLGNRLST VARCHAR2 10 NATIONAL GENERAL STATUS is the National General Status of the observed species. Possible codes and their descriptions (from www.wildspaces.ca): 0 - Extirpated/Extinct, 1 - At Risk, 2 - May be at risk, 3 - Sensitive, 4 - Secure, 5 - Undetermined, 6 - Not Assessed, 7 - Exotic, 8 - Accidental.
NAME_TYPE NAME_TYPE VARCHAR2 30 NAME TYPE is a description of the high-level category of life the observed species belongs to. Examples are A = Animal, P = Plant, C = Ecological Community.
NAME_TYPE_SUB NMTPSB VARCHAR2 100 NAME TYPE SUB categorizes the observed species into the following groups: Vertebrate Animal, Invertebrate Animal, Vascular Plant, Nonvascualr Plant, and Terrestrial Community - Other Classification.
TAXONOMIC_LEVEL TXNMCLVL VARCHAR2 100 TAXONOMIC LEVEL is the level of the observed species in the taxonomic hierarchy. e.g., species, subspecies, population, or variant.
PHYLUM_NAME PHLMNM VARCHAR2 50 PHYLUM NAME is the taxonomic phylum the observed species belongs to.
CLASS_NAME CLASS_NAME VARCHAR2 50 CLASS NAME is the taxonomic class the observed species belongs to.
CLASS_ENGLISH CLSSNGLSH VARCHAR2 50 CLASS ENGLISH is the English name of the taxonomic class the observed species belongs to.
ORDER_NAME ORDER_NAME VARCHAR2 50 ORDER NAME is the taxonomic order the observed species belongs to.
FAMILY_NAME FMLNM VARCHAR2 50 FAMILY NAME is the taxonomic family the observed species belongs to.
SECURED_FLAG SCRDFLG VARCHAR2 1 SECURED FLAG is a flag indicating whether this observation is secured. Possible values are Y and N.
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE CODE is a means of linking a geographic feature to its name and definition.
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 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.