Aquatic Invasive Species of British Columbia

1517 views (15 recent)

Published by the Ministry of Environment and Climate Change Strategy - Ecosystems
Licensed under Open Government Licence - British Columbia

Site locations of aquatic invasive species occurrences throughout the province. The aquatic invasive species include species of amphibians, fishes, invertebrates, plants, alga and turtles. This spatial dataset was compiled from a number of data sources including The Invasive Plant Council of BC; the Beaty Biodiversity Museum; the Royal BC Museum; the Fisheries Information Summary System; E-Flora BC; Electronic Atlas of Plants of BC; and from private data compilations(spreadsheets) and personal consultation with BC Ministry of Environment staff and other local experts, peer-reviewed articles and other unpublished technical reports. Full Citations are included

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Inform government and the public about the distribution of aquatic invasive species in BC.

Contact Information

NameMatthias Herborg (businessExpert)
EmailMatthias.Herborg@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationEcosystems
NameDon Philip (pointOfContact)
EmailDon.Philip@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-12-11
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_FISH.FISH_AQUATIC_INVASIVE_SPCS_SP

Short Name: FSHQTCNVSV
Comments: This spatial layer reports non-native flora and fauna associated with freshwater and estuarine habitats in BC

Column Name Short Name Data Type Data Precision Comments
AQUATIC_INVASIVE_SPCS_OCCUR_ID OCCURR_ID VARCHAR2 11 AQUATIC INVASIVE SPCS OCCUR ID: is a user maintained unique primary key. It is comprised of the first three characters of the genus and then species name respectively and a fivefour digit number unique for each point. e.g., the 119th report of Rana catesbeiana (American bullfrog) would be RanCat00119 numbered in the order they are entered into the database.
TAXONOMIC_GROUP TAXON_GRP VARCHAR2 20 TAXONOMIC GROUP: High level grouping of species. Note this grouping is not at a consistent taxonomic level. e.g., Plant
SCIENTIFIC_NAME SCIENCE_NM VARCHAR2 80 SCIENTIFIC NAME: Scientific Name according to NatureServe. e.g., Myosotis scorpioides
ENGLISH_NAME ENGLISH_NM VARCHAR2 80 ENGLISH NAME: English name according to NatureServe. e.g., European forget-me-not
NATURESERVE_ELEMENT_CODE ELCODE VARCHAR2 11 NATURESERVE ELEMENT CODE: Based on the ELEMENT CODE used by NatureServe, which uniquily identifies species and / or subspecies and is in turn is used by the Conservation Data Centre and their BC Species Explorer. e.g., PDBOR0P0A0
SPECIES_IN_BC_SPECIES_EXPLORER IN_BIOTICS VARCHAR2 3 SPECIES IN BC SPECIES EXPLORER: Additional information on this species is available in the BC Species Explorer. This abstraction includes all Geographic BC data warehouse data objects. The BC Species Explorer is a biodiversity database. Data intheBC Species Explorer include: The conservation status of all wild plants, animals and ecological communities in BC (Elements). Known locations of Red and Blue listed species and ecological communities (Occurrences). Sites of conservation concern (Sites). e.g., Yes or No
SPECIES_STATUS_IN_BC BC_STATUS VARCHAR2 6 SPECIES STATUS IN BC: Distinguishes between species that are native to one part of the province and have been introduced to other parts or are non-native (exotic) to all of BC. e.g., Exotic or Native
NEW_WATERSHED_CODE WS_CODE VARCHAR2 56 NEW WATERSHED CODE: A 45 digit numeric code that uniquely identifies (province wide) the lowest order watershed associated with the stream at its mouth in the 1:50,000 scale BC Watershed Atlas. The physical data model for the BC Watershed Atlas is available at: http://www.env.gov.bc.ca/fish/watershed_atlas_maps/documents/technotes.html �, e.g., Watershed code 920-079700-00000-00000-0000-0000-000-000-000-000-000-000 WDIC-BC Watershed Atlas (50K) Ref for document explaining.
WATERBODY_ID BCWSA_WBID VARCHAR2 10 WATERBODY ID: A 9 character code that uniquely identifies (province wide) a polygon water feature (e.g. lake, wetland, large river ) in the 1:50,000 scale BC Watershed Atlas. The physical data model for the BC Watershed Atlas is available at: http://www.env.gov.bc.ca/fish/watershed_atlas_maps/documents/technotes.html �; e.g., 00058CHWK
WATERBODY_TYPE BCWSA_TYPE VARCHAR2 1 WATERBODY TYPE: A single letter code that identifies a water feature in the 1:50K BC Watershed Atlas as a Lake (L), Stream(S), Wetland(W) or Unknown (' ').
BCGNIS_NAME GNIS_NAME VARCHAR2 80 BCGNIS NAME: The Official name of a water feature as it appears in the BC Geographical Names Information Service (BCGNIS) at: http://archive.ilmb.gov.bc.ca/bcnames/. e.g., MAYOR LAKE
LOCATION_INFORMATION LOCATNINFO VARCHAR2 200 LOCATION INFORMATION: Information describing where the species was found. e.g., Graham Island, Haida Gwaii
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 UTM_EAST 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. e.g., 684619
UTM_NORTHING UTM_NORTH NUMBER 7 UTM NORTHING: is the distance in meters northward from the equator. e.g., 5947083
BC_ALBERS_EASTING ALB_EAST NUMBER 7 BC ALBERS EASTING: is a BC Albers X coordinate. e.g., 591060
BC_ALBERS_NORTHING ALB_NORTH NUMBER 7 BC ALBERS NORTHING: is a BC Albers Y coordinate. e.g., 977364
COLLECTION_DATE COL_DATE VARCHAR2 10 COLLECTION DATE: Date the species was collected, format is YYYY-MM-DD. e.g., 2002-07-03
DETAILED_SPECIES_DATA COL_DETAIL VARCHAR2 300 DETAILED SPECIES DATA: Detailed data regarding the number and / or life stages of specimen collected where available. e.g., 1 animal
MISCELLANEOUS_COLLECTION_NOTES MISC_NOTES VARCHAR2 300 MISCELLANEOUS COLLECTION NOTES: Additional information associated with the collection of the specimen, like collections station, methods, habitat info, etc. e.g., DFO-Atlantic Salmon Watch Data
OCCURRENCE_INFORMATION_SOURCE OCCR_SRCE VARCHAR2 256 OCCURRENCE INFORMATION SOURCE: Author(s) or databases where species information has been obtained. e.g., Royal BC Museum
YR_OCCURRENCE_INFO_SOURCE_PUBL YEAR_PUBL NUMBER 4 YR OCCURRENCE INFO SOURCE PUBL: Year the species occurrence information was published. e.g., 1997
OCCURRENCE_SOURCE_CITATION CITATION VARCHAR2 700 OCCURRENCE SOURCE CITATION: Full citation of source the species occurrence information source. e.g., Royal BC Museum. 2010. Fish collection database [Accessed: 11/03/2010].
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.