CDC BIOTICS Element Status

220 views (1 recent)

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

This datasets provides data for use by the ESWP Web application (BC Species and Ecosystems Explorer). The data concern the status of provincial species and ecosystems.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Used by the BC Species and Ecosystems Explorer web application. Includes descriptive information about elements (species and ecological communities), including names, taxonomy, and Conservation Status. It is not meant for general query use.

Contact Information

NameCDC Data Requests (pointOfContact)
Emailcdcdata@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems
NameDebbie Webb (pointOfContact)
Emaildebbie.webb@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-16
Record Last Modified 2019-08-02
Resource Status onGoing

Object Description

Object Name: WHSE_TERRESTRIAL_ECOLOGY.BIOT_ELEMENT_STATUS

Short Name: BTLMNTSTTS
Comments: snapshot table for snapshot WHSE_TERRESTRIAL_ECOLOGY.BIOT_ELEMENT_STATUS

Column Name Short Name Data Type Data Precision Comments
ELEMENT_GLOBAL_ID LMNTGLBLD NUMBER 38 Element Global Id is a unique value for this element as it occurs globally.
ELEMENT_NATIONAL_ID LMNTNTNLD NUMBER 38 Element National Id is a unique value for this element as it occurs nationally.
ELEMENT_SUBNATIONAL_ID LMNTSBNTNL NUMBER 38 Element Subnational Id is a unique value for this element as it occurs subnationally (provincially).
ELCODE ELCODE CHAR 30 ELCODE, or Element Code is an alternate unique identifier for each Element in the CDC database. The first 10 characters identify the species/plant community.
TAXLEVEL TAXLEVEL VARCHAR2 4000 Taxonomic Level is the level of the element in the taxonomic hierarchy. Examples are species, subspecies, population, or variant.
TAXPHYLUM TAXPHYLUM VARCHAR2 4000 Taxonomic Phylum is the phylum the element belongs to.
TAXCLASS TAXCLASS VARCHAR2 4000 Taxonomic Class is the Class the element belongs to.
CLASS_ENG CLASS_ENG VARCHAR2 4000 Class English is the Taxonomic class, in English, to which the species belongs. For example, Monocots, Dicots, Mammals, Birds, Reptiles, Insects.
TAXORDER TAXORDER VARCHAR2 4000 Taxonomic Order is the Order the element belongs to.
TAXFAMILY TAXFAMILY VARCHAR2 4000 Taxonomic Family is the Family the element belongs to.
NAME_TYPE_CD NMTPCD CHAR 3 Name Type Code is a code describing the Name Type an element belong to. Examples are A = Animal, P = Plant, C = Ecological Community.
EL_TYPE EL_TYPE VARCHAR2 210 Element Type desribes the element in the following groups:Vertebrate Animal, Invertebrate Animal, Vascular Plant, Nonvascualr Plant, and Terrestrial Community - Other Classification.
GNAME GNAME VARCHAR2 750 GNAME is the Global Scientific Name of the element.
GCOMNAME GCOMNAME VARCHAR2 1200 Global Common Name is the Global Common English name of the element, written in title case.
SNAME SNAME VARCHAR2 750 SNAME is the Scientific name of the element, written in sentence case.
FORMAT_SNAME FRMTSNM VARCHAR2 1500 Formatted SNAME is the RISC (Resource Information Standard Committee) standard Scientific name, including html tags for italics.
SNAME_AUTHOR SNMTHR VARCHAR2 600 SNAME Author is Scientific Name Author.
SCOMNAME SCOMNAME VARCHAR2 750 SCOMNAME is the Subnational Common English name of the element, written in title case.
FORMAT_SCOMNAME FRMTSCMNM VARCHAR2 1200 Formatted SCOMNAME is the RISC standard English common name of the element, including html tags for italics.
GRANK GRANK VARCHAR2 36 Global Rank is the global conservation status rank for the species or natural plant community, assigned by NatureServe International.
G_RANK_CHANGE_DATE GRNKCHNGDT DATE 7 The Global Rank Change Date is the date on which the Global Conservation Status Rank for the Element was either initially entered or last changed.
G_RANK_REVIEW_DATE GRNKRVWDT DATE 7 The Global Rank Review Date is the date on which the Global Conservation Status Rank for the Element was last reviewed (i.e., assigned, reaffirmed, or changed).
SRANK SRANK VARCHAR2 60 Subnational Rank is the sub-national (provincial) conservation status rank for the species or natural plant community, assigned by the CDC.
S_RANK_CHANGE_DATE SRNKCHNGDT DATE 7 The Subnational Rank Change Date is the date on which the Provincial Conservation Status Rank for the Element was either initially entered or last changed.
S_RANK_REVIEW_DATE SRNKRVWDT DATE 7 The Subnational Rank Review Date is the date on which the Provincial Conservation Status Rank for the Element was last reviewed (i.e., assigned, reaffirmed, or changed).
LIST LIST VARCHAR2 150 LIST is the provincial "list" status for this species or natural plant community. Possible values are; RED, BLUE, YELLOW, INTRODUCED, ACCIDENTAL, EXTINCT and SPECIAL. SPECIAL records include record sized trees.
COSEWIC_COM CSWCCM VARCHAR2 4000 Cosewic Comment is the comment associated with the attribute COSEWIC_CD.
COSEWIC_CD COSEWIC_CD VARCHAR2 60 COSEWIC_CD is the Committee on the Status of Endangered Wildlife in Canada designation for this element ( http://www.cosewic.gc.ca/)
COSEWIC_DATE CSWCDT DATE 7 COSEWIC Date is the date the Cosewic Code was granted.
CDCTRACK CDCTRACK CHAR 3 CDCTrack specified whether this element is tracked by the CDC. Values are Y or N(null).
ENDEMISM ENDEMISM CHAR 3 Endemism is a flag indicating whether the element is endemic to BC. Possible values are Y or N(null).
BREEDING BREEDING VARCHAR2 4000 Breeding is a flag that Indicates whether a species Breeds in BC or uses the province only as a migratory corridor or wintering habitat. Possible values are Y or N(nul).
IDENT_WILDLIFE_CD DNTWLDLFCD VARCHAR2 150 Identified Wildlife Code indicates whether the element has Subnational protection via Identified Wildlife. Possible values are Y or N(null).
IDENT_WILDLIFE_DATE DNTWLDLFDT DATE 7 Identified Wildlife Date is the date the Identified Wildlife Status was granted.
IDENT_WILDLIFE_COM DNTWLDLFCM VARCHAR2 4000 Identified Wildlife Comment are comments relevant to the Identified Wildife Code (IDENT_WILDLIFE_CD)
ACCIDENTAL_ID CCDNTLD NUMBER 38 Accidental ID is the numeric value of the accidental status of the element in BC. ID Values/Descriptions are: 1 - Regularly occurring,2 -Accidental/Nonregular, 3 - Unknown/Undetermined
EXOTIC_ID EXOTIC_ID NUMBER 38 Exotic ID is the ID describing the element's exotic status to BC. Possible ID /Description options are: 1 -Native, 2 - Exotic, 3 -Unknown/Undetermined.
ORDER_SEQ_NUM RDRSQNM NUMBER 38 The Order Sequence Number is an index value used to sort elements by Taxonomic Orders phylogenetically.
FAMILY_SEQ_NUM FMLSQNM NUMBER 38 The Family Sequence Number is an index value used to sort elements by Taxonomic Families phylogenetically.
RISC_CODE RISC_CODE VARCHAR2 150 The RISC (Resource Information Standards Committee) Code is a unique code for a plant or animal species, based on it scientific or common name.
EO_EXISTS EO_EXISTS VARCHAR2 3 EO Exists is a flag that indicates whetherthe CDC have any Element Occurrences (EOs) recorded for this element. Possible values are Y or N(null).
SARA SARA CHAR 3 SARA is the SARA (The Species at Risk Act) schedule number for this element.
SARA_STS SARA_STS VARCHAR2 150 SARA STS is the SARA Status associated with the SARA schedule listing.
SARA_DATE SARA_DATE DATE 7 SARA Date is the date the SARA schedule number for this element was last changed / reviewed.
SARA_COM SARA_COM VARCHAR2 4000 SARA COM is comments associated with the species SARA listing.
WILDLIFE_ACT WLDLFCT VARCHAR2 150 Wildlife Act is the Provincial Wildlife Act status code for this element.
MBCA MBCA VARCHAR2 720 MBCA is the Migratory Bird Conventions Act, whose status is maintained by the Canadian wildlife Service (CWS).
NATL_STATUS NTLSTTS VARCHAR2 150 National Status is the National General Status of the element. 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.
NATL_STATUS_DATE NTLSTTSDT DATE 7
CF_PRIORITY_HIGHEST CFPRRTHGHS VARCHAR2 765 CF PRIORITY HIGHEST is the Conservation Framework highest priority rank (1-6) the species received across the three goals.
CF_PRIORITY_GOAL1 CFPRRTGL1 VARCHAR2 765 CF PRIORTY GOAL1 is the Conservation Framework priority rank in Goal 1.
CF_PRIORITY_GOAL2 CFPRRTGL2 VARCHAR2 765 CF PRIORTY GOAL2 is the Conservation Framework priority rank in Goal 2.
CF_PRIORITY_GOAL3 CFPRRTGL3 VARCHAR2 765 CF PRIORTY GOAL3 is the Conservation Framework priority rank in Goal 3.
CF_ACTION_GROUPS CFCTNGRPS VARCHAR2 765 CF ACTION GROUPS is the Conservation Framework action groups or bins assigned through the binning key.
CF_AG_DATE CF_AG_DATE DATE 7 CF AG Date is the date that the Conservation Framework Action Groups were assigned.
CF_THREAT_DECLINE CFTHRTDCLN VARCHAR2 765 CF THREAT DECLINE can be filled by an assessor if there is information that the CDC does not incorporate in its trend and threat assessments (Y or N).
CF_FEASIBILITY CFFSBLT VARCHAR2 765 CF FEASIBILITY is the Conservation Framework likelihood of recovering (species at risk) or maintaining (species not at risk) the species (Low (L), Medium (M), High (H), or unknown (U)).
CF_RESPONSIBILITY CFRSPNSBLT VARCHAR2 765 CF Responsibility is a number representing the proportion of the species global range or population within BC. This is a Conservation Framework attribute.
CF_DISJUNCT CFDSJNCT VARCHAR2 765 CF Disjunct specifies whether the population in BC is disjunct from the main population.
CF_RANGE_COLLAPSE CFRNGCLLPS VARCHAR2 765 CF RANGE COLLAPSE specifies is there evidence that the global range of the species is collapsing towards BC (i.e., is BC likely to be a "refuge" for the species?). This is a Conservation Framework attribute.
CF_TREND CF_TREND VARCHAR2 765 CF TREND is the observed, estimated, inferred, or suspected degree of change in extent of occurrence, area of occupancy, number of occurrences (EOs), and/or percent area with good viability or ecological integrity of an ecological community over the short term (generally <30 years) or long-term (ca. the past 150 years or since European settlement), within British Columbia. This is Conservation Framework attribute.
CF_NOTE CF_NOTE VARCHAR2 4000 CF NOTE is a general comment or Note related to this elements Conservation Framework attributes.
GOERT GOERT VARCHAR2 150 GOERT is the Garry Oak Ecosystem Recovery Team status.
LUO LUO VARCHAR2 150 LUO is the Land Use Objectives (eg., Ecosystem-based management) for this Ecological Community.
CITES CITES VARCHAR2 150 CITES is the Convention on International Trade in Endangered Species designation for this species
WHO_CREATED WHCRTD VARCHAR2 90 Who Created is the user who created this record.
WHEN_CREATED WHNCRTD DATE 7 When Created is the date this record was created.
WHO_UPDATED WHPDTD VARCHAR2 90 Who Updated is the user who last updated this record.
WHEN_UPDATED WHNPDTD DATE 7 When Updated is the date this record was last updated.