Species and Ecosystems at Risk - Publicly Available Occurrences - CDC
2874 views (36 recent)
Published by the Ministry of Environment and Climate Change Strategy - EcosystemsLicensed under Open Government Licence - British Columbia
Data and Resources
-
BC Geographic Warehouse Custom Downloadother
-
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
-
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
Additional Information
Purpose | Prevent accidental destruction of a location of a species or ecological community at risk and for research and analysis. |
Lineage Statement | The Conservation Data Centre follows NatureServe Element Occurrence Data Standards (2003). Records mapped prior to 2003 were mapped to an older standard. |
Contact Information
Name | CDC Data Requests (pointOfContact) |
cdcdata@gov.bc.ca | |
Organization | Ministry of Environment and Climate Change Strategy |
Sub-Organization | Ecosystems |
Name | Debbie Webb (pointOfContact) |
debbie.webb@gov.bc.ca | |
Organization | Ministry of Environment and Climate Change Strategy |
Sub-Organization | Ecosystems |
Access & Security
Who can view this dataset? | Public |
Who can download this dataset? | Public |
Metadata Information
Record Published | 2011-03-09 |
Record Last Modified | 2021-03-01 |
Resource Status | onGoing |
Object Description
Object Name: WHSE_TERRESTRIAL_ECOLOGY.BIOT_OCCR_NON_SENS_AREA_SVW
Short Name: BIO_NS_SVW
Comments: This view exposes the BIOTIC occurrence area with the attributes for a non sensitive BIOTIC occurrence. An Occurrence is a specific geographic location that represents a habitat capable of sustaining or contributing to the survival of specified species. This view does not includes Endangered Species, nor Record Trees.
Column Name | Short Name | Data Type | Data Precision | Comments |
---|---|---|---|---|
OCCR_AREA_SP_ID | OCCR_R__ID | NUMBER | 10 | Primary unique numeric identifier for a Polygon. |
FEATURE_CODE | FEATURE_CD | VARCHAR2 | 10 | A standard numeric code to identify the type of feature represented by the spatial data. A feature code is most importantly a means of linking a feature to its name and definition. For example, the code GB15300120 on a digital geographic feature links it to the name "Lake - Dry" with the definition "A lake bed from which all water has drained or evaporated." The feature code does NOT mark when it was digitized, what dataset it belongs to, how accurate it is, what it should look like when plotted, or who is responsible for updating it. It only says what it represents in the real world. It also doesn't even matter how the lake is represented. If it is a very small lake, it may be stored as a point feature. If it is large enough to have a shape at the scale of data capture, it may be stored as an outline, or a closed polygon. The same feature code still links it to the same definition. |
SHAPE_ID | SHAPE_ID | NUMBER | 10 | Shape ID is the unique identifier for each polygon. Used to label occurrences on map products. |
OCCR_ID | OCCR_ID | NUMBER | 38 | Occurrence ID is the Element Occurrence Primary Key. |
SCI_NAME_F | SCI_NAME_F | VARCHAR2 | 1500 | Scientific Name Formatted is the RISC (Resource Information Standard Committee) standard Scientific name, including html tags for italics. |
SCI_NAME | SCI_NM | VARCHAR2 | 750 | Scientific Name in the scientifc name written in sentence case. |
ENG_NAME_F | ENG_NAME_F | VARCHAR2 | 1200 | English Name formatted is the RISC standard English common name, including html tags for italics. |
ENG_NAME | ENG_NM | VARCHAR2 | 750 | English Name is the Common English name written in title case. |
EL_TYPE | EL_TYPE | VARCHAR2 | 210 | Element Type identifies the element (species or natural plant community) as belonging to one of the following groups: Vertebrate Animal, Invertebrate Animal, Vascular Plant, Nonvascular Plant, Alga, Terrestrial Community - Other Classification, Other (Botanical). |
EL_TYPE_CD | EL_TYPE_CD | VARCHAR2 | 18 | Element Type Code is a code representing the type of element that this occurence relates to. Potential value include "ANIMAL","PLANT", or "NPC" (Ecological Comunity). |
TAX_CLASS | TAX_CLASS | VARCHAR2 | 4000 | Taxonomic Class is the taxonomic class, in English, to which the species belongs. For example, Monocots, Dicots, Mammals, Birds, Reptiles, Insects. |
DATA_SENS | DATA_SENS | CHAR | 3 | Data Sensitivity is a single character indicating whether the record is sensitive, and the data protected.N - DATA NOT PROTECTED, MAY BE RELEASED TO PUBLICY - DATA PROTECTED, MUST NOT BE RELEASED TO PUBLIC |
GLOB_RANK | GLOB_RANK | VARCHAR2 | 36 | Global Rank is the global conservation status rank for the species or natural plant community, assigned by NatureServe International. |
PROV_RANK | PROV_RANK | VARCHAR2 | 60 | Provincial Rank is the sub-national (provincial), conservation status rank for the species or natural plant community, assigned by the CDC. |
COSEWIC | COSEWIC | VARCHAR2 | 93 | COSEWIC is the Committee on the Status of Endangered Wildlife in Canada designation for this element ( http://www.cosewic.gc.ca/) |
BC_LIST | BC_LIST | VARCHAR2 | 150 | BC 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. |
SARA_SCHED | SARA_SCHED | CHAR | 3 | SARA Schedule is the SARA (The Species at Risk Act) schedule number for this element. |
SURV_SITE | SURV_SITE | VARCHAR2 | 1050 | Survey Site is a short description of the location of the occurrence, e.g. "Duncan, 2 km east of". Most often the nearest Gazetted place name. There will sometimes be several occurrences at the location. |
DIRECTIONS | DIRECTIONS | VARCHAR2 | 4000 | Directions provides directions to the site of the occurrence. If the DATASENS field is marked with a 'Y', this information is not to be released to the public. |
FIRST_OBS | FIRST_OBS | VARCHAR2 | 150 | First Observation Date is the date that the occurrence was first reported at the site. |
LAST_OBS | LAST_OBS | VARCHAR2 | 150 | Last Observation Date is the date on which the species or community was last observed to be extant at the occurrence site. Format is yyyy-mm-dd OR yyyy-aaaa OR yyyy-mm1987-07-15 1965-SPRG 1981-07 |
OCCR_DATA | OCCR_DATA | VARCHAR2 | 4000 | Occurrence Data provides details such as number of fledglings from nest site, number of plants in flower etc. |
RANK | RANK | VARCHAR2 | 6 | RANK (Occurrence Rank) is a single letter or 2 or 3-letter code combination signifying the overall quality of the individual occurrence, e.g., A (highest quality), D (lowest quality). Not all occurrences have a rank. |
RANK_DESC | RANK_DESC | VARCHAR2 | 180 | Rank Description indicates the relative value of the Occurrence with respect to other occurrences of the Element, based on an assessment of estimated viability (species) or ecological integrity (communities). |
RANK_DATE | RANK_DATE | VARCHAR2 | 150 | Rank Date is the date of the field survey on which the Element Occurrence (EO) rank is based. |
RANK_COM | RANK_COM | VARCHAR2 | 4000 | Occurrence Rank Comment is a short comment justifying the EORANK. Records which do not have an EORANK will not have this field, and some of the records which DO have an EORANK will not yet have had this field completed. |
CONDITION | CONDITION | VARCHAR2 | 4000 | Condition is an integrated measure of the quality of biotic and abiotic factors, structures, and processes within the Element Occurrence (EO), and the degree to which they affect the continued existence of the occurrence. |
OCCR_SIZE | OCCR_SIZE | VARCHAR2 | 4000 | Occurrence Size is a quantitative measure of the area and/or abundance of the Element Occurrence (EO). |
LAND_CONT | LAND_CONT | VARCHAR2 | 3440 | Landscape Context is an integrated measure of the quality of biotic and abiotic factors, structures, and processes surrounding the Element Occurrence (EO), and the degree to which they affect the continued existence of the occurrence. |
GEN_DESC | GEN_DESC | VARCHAR2 | 4000 | General Description is a description, or "word picture", of the area where the Element Occurrence is located. For plant and animal records, the natural plant community in which the occurrence is found may be given. Information on surrounding land use is included, if available. |
VEG_ZONE | VEG_ZONE | VARCHAR2 | 600 | Vegetation Zone is one of five possible zones; LOWLAND, STEPPE, MONTANE, ALPINE and SUBALPINE. |
HABITAT | HABITAT | VARCHAR2 | 4000 | Habitat is a series of words or phrases from a controlled vocabulary which describe the general habitat in which the element occurrence is found. Keyword groups are separated by semi colons:TERRESTRIAL;WOODLAND NEEDLELEAFTERRESTRIAL;WOODLAND BROADLEAF; SUBURBANMARINE;EXPOSEDRIVERINE |
BGC | BGC | VARCHAR2 | 4000 | BGC is semicolon seperated value list of Biogeoclimatic (BGC) Units that apply to this occurrence. |
REFERENCES | REFERENCES | VARCHAR2 | 4000 | References is a list of the Reference Citation relevant to this Occurrence. If multiple references exists, they are seperated by an HTML break <BR>. |
VERS_DATE | VERS_DATE | DATE | 7 | Version Date is the date of the current version of this Element Occurrence (EO) record (i.e., the date that this record was first completed, or since then, comprehensively revised). |
VERS_AUTHOR | VRS_THR | VARCHAR2 | 300 | VERS AUTHOR is the name of the person principally responsible for preparing this version of the Element Occurrence (EO) record. |
EST_RA | EST_RA | VARCHAR2 | 90 | Estimated Representational Accuracy is the percentage of the polygon actually occupied by the occurrence.VH Very High Accuracy (>95%)H High Accuracy (80% - 95%)M Medium Accuracy (20% - 80%)L Low Accuracy (>0%-20%) U Unknown (?) |
CON_EXTENT | CON_EXTENT | CHAR | 3 | Confidence Extent indicates whether the full extent of the Element is known (i.e., has been determined through field survey) at that location and, therefore, is represented by the Element Occurrence (EO). |
CON_EXTENT_DESC | CN_XTNT_DC | VARCHAR2 | 180 | CON EXTENT DESC is a description indicating whether the full extent of the Element is known (i.e., has been determined through field survey) at that location and, therefore, is represented by the Element Occurrence (EO). |
ECOSECTIONS | ECSCTNS | VARCHAR2 | 4000 | ECOSECTIONS is a list of the ecosections relevant to this Occurrence. If multiples exists, they are seperated by commas. |
ENVIRONMENT_COM | ENVRNMNT_M | VARCHAR2 | 4000 | ENVIRONMENT COM is comments on other important aspects of the environment that affect this particular community Element Occurrence (EO). |
SOIL_COM | SOIL_COM | VARCHAR2 | 4000 | SOIL COM is the description of any other important features of the soil influencing the community Element Occurrence (EO). |
MIN_ELEV_METERS | MN_LV_MTRS | NUMBER | 38 | MIN ELEV METERS is the minimum elevation of the area covered by the Element Occurrence (EO), in metres. |
MAX_ELEV_METERS | MX_LV_MTRS | NUMBER | 38 | MAX ELEV METERS is the maximum elevation of the area covered by the Element Occurrence (EO), in metres. |
ADDITIONAL_INV_NEEDED_IND | ADDTNL_NVD | VARCHAR2 | 3 | ADDITIONAL INV NEEDED IND indicates that additional survey work is needed for this Element Occurrence (EO). |
ADDITIONAL_INV_NEEDED_COM | ADDTNL_NVM | VARCHAR2 | 3000 | ADDITIONAL INV NEEDED COM is comments related to any additional survey work that is needed for this Element Occurrence (EO). |
INVENTORY_COM | INVNTRY_CM | VARCHAR2 | 4000 | INVENTORY COM is the description of the sampling scheme used for the Element Occurrence (EO). |
REP_ACCURACY_COM | RP_CCRCY_M | VARCHAR2 | 3000 | REP ACCURACY COM is comments relating to Representational Accuracy (the level of accuracy associated with the Element Occurrence Representation (EO Rep)). |
SPECIMEN_DESC | SPCMN_DSC | VARCHAR2 | 4000 | SPECIMEN DESC is citation(s) for old specimens or other vouchers for this Element Occurrence (EO). Contains semi-colon seperared list if multiple citations. |
EO_NUM | EO_NUM | NUMBER | 38 | EO NUM is a number that identifies this particular occurrence of the Element. |
ELCODE | ELCODE | CHAR | 10 | ELCODE is an alternate unique identifier for each Element in the CDC database. The first 10 characters identify the species/plant community. eg. PGPIN01010 |
ELEMENT_SUBNATIONAL_ID | ELMNT_S_ID | NUMBER | 38 | ELEMENT SUBNATIONAL ID is a unique identifier for all elements that occur subnationally (provinicially). |
ECOSYSTEM_GRP | ECSYSTM_GP | VARCHAR2 | 4000 | ECOSYSTEM GROUP is a classification of ecological communities into broad ecosystem types. eg. Terrestrial - Alpine: Alpine. |
GEOMETRY | GEOMETRY | SDO_GEOMETRY | 64 | ArcSDE spatial column: coordinates defining the features. |
FEATURE_AREA_SQM | AREA_SQM | NUMBER | 19 | |
FEATURE_LENGTH_M | FEAT_LEN | NUMBER | 19 | |
OBJECTID | OBJECTID | NUMBER | 38 | OBJECTID is a required attribute of feature classes and object classes in a geodatabase. |
SE_ANNO_CAD_DATA | BLOB | 4000 |