Wildlife Species Inventory Survey Observations - All

648 views (6 recent)

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

A wildlife observation is an encounter with the focal species (taxa) or its sign. An observation is made when a surveyor makes a visit to a sampling location (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 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 pertains to species at risk that 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 it were publicly 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 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.

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

Metadata Information

Record Published 2015-01-05
Record Last Modified 2017-04-12
Resource Status onGoing

Object Description

Object Name: WHSE_WILDLIFE_INVENTORY.SPI_SURVEY_OBS_ALL_SP

Short Name: SPSRVBSLLS
Comments: All survey observations of wildlife or their sign that originate from the Species Inventory (SPI) database. These survey 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
SURVEY_OBSERVATION_ID SRVBSRVTND NUMBER 10 SURVEY OBSERVATION ID is a unique identifier for a survey 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.
ANIMAL_ID ANIMAL_ID VARCHAR2 100 ANIMAL ID is a unique identifier permanently assigned to an animal. e.g., W40
SEX SEX VARCHAR2 2 SEX is the sex of the individual. e.g., UC - UnClassed
OBSERVED_NUMBER BSRVDNMBR NUMBER 5 OBSERVED NUMBER is usually the total number of animals detected at the point location. A Count of 0 means none of the target taxa were detected. A Count of 1 means one of three things: (1) Exactly one animal was detected, (2) At least one animal was detected and more detail is given in the survey-specific data fields, or (3) Sign of at least one animal was detected and more detail is given in the survey-specific data fields.
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.
UTM_SOURCE UTM_SOURCE VARCHAR2 25 UTM SOURCE defines from where the UTM values were derived. e.g., Wildlife Observation WLO, Design Component DC, Study Area SA
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
FIELD_OBSERVER FLDBSRVR VARCHAR2 100 FIELD OBSERVER is the name of observer.
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_START_DATE PRJCTSTRTD DATE 7 PROJECT START DATE is the starting date of the project.
PROJECT_END_DATE PRJCTNDDT DATE 7 PROJECT END DATE is the end date of the project.
PROJECT_LOCATION_DESCRIPTION PRJCTLCTND VARCHAR2 2000 PROJECT LOCATION DESCRIPTION is a description of the project location with gazetted place names.
PROJECT_COORDINATOR PRJCTCRDNT VARCHAR2 70 PROJECT COORDINATOR is the full name of the main contact for this project.
FUNDING_SOURCES FNDNGSRCS VARCHAR2 255 FUNDING SOURCES is a comma-separated-values list of acronyms of funding agencies and their identifiers for this SPI project.
REGION REGION VARCHAR2 25 REGION is the Ministry of Environment region that has primary responsible for the project.
STUDY_AREA_NAME STDRNM VARCHAR2 100 STUDY AREA NAME is the name of the Study Area(s) in which this observation occurred.
STUDY_AREA_ID STDRD NUMBER 10 STUDY AREA ID is a system generated numerical identifier for Study Area.
SURVEY_NAME SRVNM VARCHAR2 100 SURVEY NAME is the name of the Survey that generated this observation
SURVEY_ID SURVEY_ID NUMBER 10 SURVEY ID is a system generated numerical identifier for Survey
SURVEY_INTENSITY SRVNTNST VARCHAR2 2 SURVEY INTENSITY is the level of species-presence information to be derived from the survey. e.g., PN = Presence/Not detected (possible), RA = Relative Abundance, AA = Absolute Abundance
SURVEY_TARGET_SPECIES SRVTRGTSPC VARCHAR2 2000 SURVEY TARGET SPECIES is a comma-separated-values list of species codes representing the species that were targeted during this survey.
SURVEY_START_DATE SRVSTRTDT DATE 7 SURVEY START DATE is the starting date of the survey
INVENTORY_METHOD NVNTRMTHD VARCHAR2 25 INVENTORY METHOD is short description of the inventory method used during this survey. e.g., Roadside Point Counting
DESIGN_COMPONENT_LABEL DSGNCMPNN1 VARCHAR2 50 DESIGN COMPONENT LABEL is a unique user-assigned label of a Design Component.
DESIGN_COMPONENT_TYPE DSGNCMPNN2 VARCHAR2 25 DESIGN COMPONENT TYPE is the type of design component
DESIGN_COMPONENT_ID DSGNCMPNNT NUMBER 10 DESIGN COMPONENT ID is a system generated numerical identifier for this design component
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.
FIELD_NAME_1 FLDNM1 VARCHAR2 50 FIELD NAME 1 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 1 column
DATA_1 DATA_1 VARCHAR2 100 DATA 1 is data relevant to the associated datafield in the FIELD NAME 1 column
FIELD_NAME_2 FLDNM2 VARCHAR2 50 FIELD NAME 2 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 2 column
DATA_2 DATA_2 VARCHAR2 100 DATA 2 is data relevant to the associated datafield in the FIELD NAME 2 column
FIELD_NAME_3 FLDNM3 VARCHAR2 50 FIELD NAME 3 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 3 column
DATA_3 DATA_3 VARCHAR2 100 DATA 3 is data relevant to the associated datafield in the FIELD NAME 3 column
FIELD_NAME_4 FLDNM4 VARCHAR2 50 FIELD NAME 4 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 4 column
DATA_4 DATA_4 VARCHAR2 100 DATA 4 is data relevant to the associated datafield in the FIELD NAME 4 column
FIELD_NAME_5 FLDNM5 VARCHAR2 50 FIELD NAME 5 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 5 column
DATA_5 DATA_5 VARCHAR2 100 DATA 5 is data relevant to the associated datafield in the FIELD NAME 5 column
FIELD_NAME_6 FLDNM6 VARCHAR2 50 FIELD NAME 6 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 6 column
DATA_6 DATA_6 VARCHAR2 50 DATA 6 is data relevant to the associated datafield in the FIELD NAME 6 column
FIELD_NAME_7 FLDNM7 VARCHAR2 50 FIELD NAME 7 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 7 column
DATA_7 DATA_7 VARCHAR2 100 DATA 7 is data relevant to the associated datafield in the FIELD NAME 7 column
FIELD_NAME_8 FLDNM8 VARCHAR2 50 FIELD NAME 8 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 8 column
DATA_8 DATA_8 VARCHAR2 100 DATA 8 is data relevant to the associated datafield in the FIELD NAME 8 column
FIELD_NAME_9 FLDNM9 VARCHAR2 50 FIELD NAME 9 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 9 column
DATA_9 DATA_9 VARCHAR2 100 DATA 9 is data relevant to the associated datafield in the FIELD NAME 9 column
FIELD_NAME_10 FLDNM10 VARCHAR2 50 FIELD NAME 10 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 10 column
DATA_10 DATA_10 VARCHAR2 100 DATA 10 is data relevant to the associated datafield in the FIELD NAME 10 column
FIELD_NAME_11 FLDNM11 VARCHAR2 50 FIELD NAME 11 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 11 column
DATA_11 DATA_11 VARCHAR2 100 DATA 11 is data relevant to the associated datafield in the FIELD NAME 11 column
FIELD_NAME_12 FLDNM12 VARCHAR2 50 FIELD NAME 12 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 12 column
DATA_12 DATA_12 VARCHAR2 100 DATA 12 is data relevant to the associated datafield in the FIELD NAME 12 column
FIELD_NAME_13 FLDNM13 VARCHAR2 50 FIELD NAME 13 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 13 column
DATA_13 DATA_13 VARCHAR2 100 DATA 13 is data relevant to the associated datafield in the FIELD NAME 13 column
FIELD_NAME_14 FLDNM14 VARCHAR2 50 FIELD NAME 14 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 14 column
DATA_14 DATA_14 VARCHAR2 100 DATA 14 is data relevant to the associated datafield in the FIELD NAME 14 column
FIELD_NAME_15 FLDNM15 VARCHAR2 50 FIELD NAME 15 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 15 column
DATA_15 DATA_15 VARCHAR2 100 DATA 15 is data relevant to the associated datafield in the FIELD NAME 15 column
FIELD_NAME_16 FLDNM16 VARCHAR2 50 FIELD NAME 16 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 16 column
DATA_16 DATA_16 VARCHAR2 100 DATA 16 is data relevant to the associated datafield in the FIELD NAME 16 column
FIELD_NAME_17 FLDNM17 VARCHAR2 50 FIELD NAME 17 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 17 column
DATA_17 DATA_17 VARCHAR2 100 DATA 17 is data relevant to the associated datafield in the FIELD NAME 17 column
FIELD_NAME_18 FLDNM18 VARCHAR2 50 FIELD NAME 18 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 18 column
DATA_18 DATA_18 VARCHAR2 100 DATA 18 is data relevant to the associated datafield in the FIELD NAME 18 column
FIELD_NAME_19 FLDNM19 VARCHAR2 50 FIELD NAME 19 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 19 column
DATA_19 DATA_19 VARCHAR2 100 DATA 19 is data relevant to the associated datafield in the FIELD NAME 19 column
FIELD_NAME_20 FLDNM20 VARCHAR2 50 FIELD NAME 20 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 20 column
DATA_20 DATA_20 VARCHAR2 100 DATA 20 is data relevant to the associated datafield in the FIELD NAME 20 column
FIELD_NAME_21 FLDNM21 VARCHAR2 50 FIELD NAME 21 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 21 column
DATA_21 DATA_21 VARCHAR2 100 DATA 21 is data relevant to the associated datafield in the FIELD NAME 21 column
FIELD_NAME_22 FLDNM22 VARCHAR2 50 FIELD NAME 22 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 22 column
DATA_22 DATA_22 VARCHAR2 100 DATA 22 is data relevant to the associated datafield in the FIELD NAME 22 column
FIELD_NAME_23 FLDNM23 VARCHAR2 50 FIELD NAME 23 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 23 column
DATA_23 DATA_23 VARCHAR2 100 DATA 23 is data relevant to the associated datafield in the FIELD NAME 23 column
FIELD_NAME_24 FLDNM24 VARCHAR2 50 FIELD NAME 24 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 24 column
DATA_24 DATA_24 VARCHAR2 100 DATA 24 is data relevant to the associated datafield in the FIELD NAME 24 column
FIELD_NAME_25 FLDNM25 VARCHAR2 50 FIELD NAME 25 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 25 column
DATA_25 DATA_25 VARCHAR2 100 DATA 25 is data relevant to the associated datafield in the FIELD NAME 25 column
FIELD_NAME_26 FLDNM26 VARCHAR2 50 FIELD NAME 26 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 26 column
DATA_26 DATA_26 VARCHAR2 100 DATA 26 is data relevant to the associated datafield in the FIELD NAME 26 column
FIELD_NAME_27 FLDNM27 VARCHAR2 50 FIELD NAME 27 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 27 column
DATA_27 DATA_27 VARCHAR2 100 DATA 27 is data relevant to the associated datafield in the FIELD NAME 27 column
FIELD_NAME_28 FLDNM28 VARCHAR2 50 FIELD NAME 28 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 28 column
DATA_28 DATA_28 VARCHAR2 100 DATA 28 is data relevant to the associated datafield in the FIELD NAME 28 column
FIELD_NAME_29 FLDNM29 VARCHAR2 50 FIELD NAME 29 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 29 column
DATA_29 DATA_29 VARCHAR2 100 DATA 29 is data relevant to the associated datafield in the FIELD NAME 29 column
FIELD_NAME_30 FLDNM30 VARCHAR2 50 FIELD NAME 30 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 30 column
DATA_30 DATA_30 VARCHAR2 100 DATA 30 is data relevant to the associated datafield in the FIELD NAME 30 column
FIELD_NAME_31 FLDNM31 VARCHAR2 50 FIELD NAME 31 is a datafield name (i.e., Column name), specific to the inventory method, for the associated data in the DATA 31 column
DATA_31 DATA_31 VARCHAR2 100 DATA 31 is data relevant to the associated datafield in the FIELD NAME 31 column
NOTE NOTE VARCHAR2 2000 NOTE is additional information regarding the observation.
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.