Wildlife Species Inventory Incidental Observations - Non-secured

610 views (6 recent)

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

A wildlife feature observation is a record of a detection of a wildlife habitat feature (e.g. nest, or wildlife tree). 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 Incidental 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

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

Metadata Information

Record Published 2014-07-16
Record Last Modified 2019-09-05
Resource Status onGoing
Spatial DataSDO_GEOMETRY

Object Description

Object Name: WHSE_WILDLIFE_INVENTORY.SPI_INCIDENT_OBS_NONSENS_SP

Short Name: SPNCDNTBSN
Comments: Nonsensitive incidental observations of wildlife or their sign that originate from the Species Inventory (SPI) database. These incidental 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
INCIDENTAL_OBSERVATION_ID NCDNTLBSRV NUMBER 10 INCIDENTAL OBSERVATION ID is a unique identifier for an incidental observation in the SPI database as supplied by the business area which is used as the primary key.
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_DATE BSRVTNDT DATE 7 OBSERVATION DATE is the date 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.
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.
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
HABITAT_DESCRIPTION HBTTDSCRPT VARCHAR2 512 HABITAT DESCRIPTION is a general description of the habitat.
OBSERVATION_LOCATION BSRVTNLCTN VARCHAR2 512 OBSERVATION LOCATION is a description of the location.
ADULT_MALES DLTMLS NUMBER 5 ADULT MALES is the number of adult males observed.
ADULT_FEMALES DLTFMLS NUMBER 5 ADULT FEMALES is the number of adult females observed.
ADULTS_UNCLASSED_SEX DLTSNCLSSD NUMBER 5 ADULTS UNCLASSED SEX is the number of adults of unknown or unclassified sex observed.
JUVENILE_MALES JVNLMLS NUMBER 5 JUVENILE MALES is the number of juvenile males observed.
JUVENILE_FEMALES JVNLFMLS NUMBER 5 JUVENILE FEMALES is the number of juvenile females observed.
JUVENILES_UNCLASSED_SEX JVNLSNCLSS NUMBER 5 JUVENILES UNCLASSED SEX is the number of juveniles of unknown or unclassified sex observed.
UNCLASSED_LIFE_STAGE_AND_SEX NCLSSDLFST NUMBER 5 UNCLASSED LIFE STAGE AND SEX is the number of unknown age individuals of unknown sex observed.
EGGS EGGS NUMBER 5 EGGS is the number of eggs observed.
SIGN_OR_ACTIVITY_CD SGNRCTVTCD VARCHAR2 25 SIGN OR ACTIVITY CD is a code indicating the activity of the animal when it was first detected or the activity that caused the sign. e.g., SA
SIGN_OR_ACTIVITY SGNRCTVT VARCHAR2 200 SIGN OR ACTIVITY is the activity of the animal when it was first detected or the activity that caused the sign. e.g., Standing
SIGN_OR_ACTIVITY_DESCRIPTOR_CD SGNRCTVTD1 VARCHAR2 25 SIGN OR ACTIVITY DESCRIPTOR CD is a code indicating whether the animal was seen or heard, or gives the probable age or season of the sign. e.g., H
SIGN_OR_ACTIVITY_DESCRIPTOR SGNRCTVTDS VARCHAR2 200 SIGN OR ACTIVITY DESCRIPTOR is An indication whether the animal was seen or heard, or gives the probable age or season of the sign. e.g., Heard
AMOUNT_OF_SIGN_OR_ACTIVITY_CD MNTFSGNRC1 VARCHAR2 25 AMOUNT OF SIGN OR ACTIVITY CD is a code indicating the number of animals doing the activity, or number of sign elements made by the activity. e.g., M
AMOUNT_OF_SIGN_OR_ACTIVITY MNTFSGNRCT VARCHAR2 200 AMOUNT OF SIGN OR ACTIVITY is the number of animals doing the activity, or number of sign elements made by the activity. e.g., Moderate
OBSERVATION_COMMENTS BSRVTNCMMN VARCHAR2 2000 OBSERVATION COMMENTS is informative notes about the observation.
QUALITY_CHECK_RESULT QLTCHCKRSL VARCHAR2 25 QUALITY CHECK RESULT contains an indication of whether this observation was Quality Checked or an indication of the results of a Quality Check. Some valid codes and their meaning are �Not QCed� (Not quality checked), �Passed QC� (passed quality check)
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.
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.