EAUBC Lakes

831 views (12 recent)

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

River and Lake Ecosystem Types nest within both Ecological Drainage Units and Freshwater Ecoregions. They are therefore defined by zoogeographic, physiographic and climatic patterns but also take into account more localized physical habitat and dominant environmental processes that shape freshwater ecosystems. The units of analysis for lake ecosystems in BC are at a scale of 1:50,000. Biological information is sparse at this scale of the classification and is therefore not explicitly used to delineate ecosystem types. However, fish assemblages can be inferred for each Ecosystem Type based on the Ecological Drainage Unit it is nested within. Twelve Lake Ecosystem Types are identified in BC.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

EAU BC is a hierarchical classification of BC?s freshwater ecosystems. It is a spatially explicit classification designed to aid in the management and conservation of BC?s freshwater ecosystems and their associated biodiversity.

Specifically, EAU BC was developed with the following applications in mind:

  • Provide an environmental characterization of freshwater ecosystem types in BC that will aid in their specific conservation and management;

  • Provide a spatially explicit data management system for freshwater ecosystems in BC;

  • Enable regional comparisons of freshwater ecosystems;

  • Help inform species / habitat relationships; and

  • Provide a stratification framework for freshwater inventory / monitoring programs and state of the environment reporting on freshwater ecosystems in BC.

Data Quality
Lineage Statement

Contact Information

NameCraig Mount (businessExpert)
EmailCraig.Mount@gov.bc.ca
OrganizationMinistry of Environment and Climate Change Strategy
Sub-OrganizationKnowledge Management
NameDave McEwan (pointOfContact)
EmailDave.McEwan@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-05-07
Resource Status completed

Object Description

Object Name: WHSE_LAND_AND_NATURAL_RESOURCE.EAUBC_LAKES_SP

Short Name: EABC_LAKES
Comments: LAKE is a spatial layer representing River and Lake Ecosystem Types nest within both Ecological Drainage Units and Freshwater Ecoregions. They are therefore defined by zoogeographic, physiographic and climatic patterns but also take into account more localized physical habitat and dominant environmental processes that shape freshwater ecosystems. Biological information is sparse at this scale of the classification and is therefore not explicitly used to delineate ecosystem types. However, fish assemblages can be inferred for each Ecosystem Type based on the Ecological Drainage Unit it is nested within. Twelve Lake Ecosystem Types are identified in BC.

Column Name Short Name Data Type Data Precision Comments
WSA_LAKE_ID WSLKD VARCHAR2 9 WSA LAKE ID is a Unique ID - PRIMARY KEY,.
FRESHWATER_ECOREGION FRSHWTRCRG VARCHAR2 40 Freshwater Ecoregions are defined based on zoogeographic patterns in fish recolonization following the last glacial recession. Five Freshwater Ecoregions are identified in BC.
FRESHWATER_ECO_DRAINAGE_UNIT FRSHWTRCDR VARCHAR2 40 Ecological Drainage Units are nested within Freshwater Ecoregions and take into account zoogeographic, climatic, and physiographic patterns that define freshwater systems. Ecological Drainage Units incorporate the known distribution of native freshwater fishes in BC. Thirty-six Ecological Drainage Units are identified in BC.
WSA_CODE_SHORT WSCDSHRT VARCHAR2 55 WSA CODE SHORT is a short version of WS_CODE (Watershed Code).
WSA_AREA WSA_AREA NUMBER 13 WSA AREA is the area of polygon in square metres.
WSA_TYPE WSA_TYPE VARCHAR2 1 WSA TYPE is an area feature identifier that indicates whether the polygon is a lake,wetland, river, man-made waterbody, land, or outside the watershed.
WSA_GAZETTED_NAME WSGZTTDNM VARCHAR2 30 WSA GAZETTED NAME is the Gazetted Name of Waterbody.
WSA_ELEVATION_IN_METER WSLVTNNMTR NUMBER 4 WSA ELEVATION IN METER is the lake elevation in metres above sea level (masl).
LAKE_ELEVATION_CALCULATED_DEM LKLVTNCLCL NUMBER 4 LAKE ELEVATION CALCULATED DEM is the lake elevation in metres above sea level (masl) calculated based on most recent DEM.
WSA_STREAM_ORDER_50K WSSTRMRDR5 NUMBER 2 WSA STREAM ORDER 50K is the stream order based on 1:50000 scale mapping (after Strahler).
WSA_STREAM_MAGNITUDE_50K WSSTRMMGNT NUMBER 5 WSA STREAM MAGNITUDE 50K is the stream magnitude based on 1:50000 scale mapping.
WSA_PERIMETER WSPRMTR NUMBER 10 WSA PERIMETER is perimeter in coverage units in metres.
WSA_SHORELINE_COMPLEXITY WSSHRLNCMP NUMBER 6 WSA SHORELINE COMPLEXITY is the Lake Shoreline Complexity - calculated by dividing the length of the shoreline by 2 times the square root of the product of the area of the lake and pi.
WSA_SURFACE_AREA_HECTARE WSSRFCRHCT NUMBER 9 WSA SURFACE AREA HECTARE is the Surface Area in Hectares.
WSA_NUMBER_OF_INLETS WSNMBRFNLT NUMBER 3 WSA NUMBER OF INLETS is the number of recorded stream or river inlets on this lake.
WSA_NUMBER_OF_OUTLETS WSNMBRFTLT NUMBER 2 WSA NUMBER OF OUTLETS is the number of recorded stream or river outlets on this lake.
WSA_WATERSHED_CODE WSWTRSHDCD VARCHAR2 45 WSA WATERSHED CODE is a 45 digit numeric code that uniquely identifies (province wide) the lowest order watershed associated with the stream at its mouth.
MAXIMUM_DEPTH MXMMDPTH NUMBER 5 MAXIMUM DEPTH is the BC government maximum depth measurements on selected lakes.
FLUSHING_RATE FLSHNGRT NUMBER 6 FLUSHING RATE is the BC government flushing rate measurements on selected lakes.
PH_MEASUREMENTS PHMSRMNTS NUMBER 6 PH MEASUREMENTS is the BC government pH measurements for selected lakes.
TOTAL_DISSOLVED_SOLIDS TTLDSSLVDS NUMBER 5 TOTAL DISSOLVED SOLIDS is the BC government total dissolved solids measurements for selected lakes.
SECCHI_DEPTH SCCHDPTH NUMBER 6 SECCHI DEPTH is the BC government secchi depth measures for selected lakes.
UPSTREAM_DRAINAGE_AREA PSTRMDRNGR NUMBER 9 UPSTREAM DRAINAGE AREA is the upstream drainage area for the lake lake in square kilometres.
PCT_LAKE_SURF_INT_META PCTLKSRFNT NUMBER 3 PCT LAKE SURF INT META is the percent of lake surface area in each underlying bedrock geology class: intrusive and metamorphic bedrock.
PCT_LAKE_SURF_VOLCANIC PCTLKSRFVL NUMBER 3 PCT LAKE SURF VOLCANIC is the percent of lake surface area in each underlying bedrock geology class: volcanic bedrock.
PCT_LAKE_SURF_HARD_SED PCTLKSRFHR NUMBER 3 PCT LAKE SURF HARD SED is the percent of lake surface area in each underlying bedrock geology class: hard sedimentary bedrock.
PCT_LAKE_SURF_SOFT_SED PCTLKSRFSF NUMBER 3 PCT LAKE SURF SOFT SED is the percent of lake surface area in each underlying bedrock geology class: soft sedimentary bedrock.
PCT_LAKE_SURF_CARB_SED PCTLKSRFCR NUMBER 3 PCT LAKE SURF CARB SED is the percent of lake surface area in each underlying bedrock geology class: carbonate sedimentary bedrock.
PCT_LAKE_SURF_CHEM_SED PCTLKSRFCH NUMBER 3 PCT LAKE SURF CHEM SED is the Percent of lake surface area in each underlying bedrock geology class: serpentine and other chemical sedimentary bedrock.
PCT_LAKE_SURF_ALLUVIUM PCTLKSRFLL NUMBER 3 PCT LAKE SURF ALLUVIUM is the percent of lake surface area in each underlying bedrock geology class: alluvium.
PCT_GLACIAL_INFLUENCE PCTGLCLNFL NUMBER 6 PCT GLACIAL INFLUENCE is the percent glacial influence of the lake (glacier area / total upstream drainage area of the lake).
PCT_TUNDRA_INFLUENCE PCTTNDRNFL NUMBER 6 PCT TUNDRA INFLUENCE is the percent tundra influence of the lake (tundra area / total upstream drainage area of the lake).
NUM_OF_DEGREE_DAYS_ABOVE_4C NMFDGRDSBV NUMBER 7 NUM OF DEGREE DAYS ABOVE 4C is the Number of degree days above 4 degrees Celsius per lake (based on air temperature data from ClimateSource).
NUM_OF_DEGREE_DAYS_ABOVE_8C NMFDGRDSB1 NUMBER 6 NUM OF DEGREE DAYS ABOVE 8C is the Number of degree days above 8 degrees Celsius per lake (based on air temperature data from ClimateSource).
ACCUMULATIVE_PRECIP_YIELD CCMLTVPRCP NUMBER 13 ACCUMULATIVE PRECIP YIELD is the accumulative precipitation yield (accumulated gridded precipitation average annual precipitation total the entire upstream drainage area of each lake)
MAXIMUM_JULY_TEMPERATURE MXMMJLTMPR NUMBER 6 MAXIMUM JULY TEMPERATURE is the maximum July air temperature (in Celsius) per lake.
LIMNOLOGICAL_REGION LMNLGCLRGN VARCHAR2 254 LIMNOLOGICAL REGION is the Limnological Region: Insular and Coastal Mountains; Insular Lowland; Lower Fraser Valley; Southern Interior Plateau; Southern Interior Highland; Columbia Mountains; Rocky Mountain Trench; Northern Interior Plateau and Mountains; Rocky Mountains and Foothills; Liard Plain; Peace River Basin; Fort Nelson River Basins.
NUM_OF_LAKE_INFLOWS_REVISED NMFLKNFLWS NUMBER 3 NUM OF LAKE INFLOWS REVISED is the number of recorded stream or river inlets on this lake based on 1:50,000 watershed atlas hydrography.
NUM_OF_LAKE_OUTFLOWS_REVISED NMFLKTFLWS NUMBER 3 NUM OF LAKE OUTFLOWS REVISED is the number of recorded stream or river outlets on this lake based on 1:50,000 watershed atlas hydrography
PCT_LAKE_SURF_BAFA PCTLKSRFBF NUMBER 3 PCT LAKE SURF BAFA is the percent of lake surface area in each BEC Zone - Boreal Altai Fescue Alpine.
PCT_LAKE_SURF_BG PCTLKSRFBG NUMBER 3 PCT LAKE SURF BG is the percent of lake surface area in each BEC Zone - Bunchgrass.
PCT_LAKE_SURF_BWBS PCTLKSRFBW NUMBER 3 PCT LAKE SURF BWBS is the percent of lake surface area in each BEC Zone - Boreal White and Black Spruc.
PCT_LAKE_SURF_CDF PCTLKSRFCD NUMBER 3 PCT LAKE SURF CDF is the percent of lake surface area in each BEC Zone - Coastal Douglas-Fir.
PCT_LAKE_SURF_CMA PCTLKSRFCM NUMBER 3 PCT LAKE SURF CMA is the Percent of lake surface area in each BEC Zone - Coastal Mountain-heather Alpine.
PCT_LAKE_SURF_CWH PCTLKSRFCW NUMBER 3 PCT LAKE SURF CWH is the percent of lake surface area in each BEC Zone - Coastal Western Hemlock.
PCT_LAKE_SURF_ESSF PCTLKSRFSS NUMBER 3 PCT LAKE SURF ESSF is the percent of lake surface area in each BEC Zone - Engelmann Spruce-Subalpine Fir.
PCT_LAKE_SURF_ICH PCTLKSRFC1 NUMBER 3 PCT LAKE SURF ICH is the percent of lake surface area in each BEC Zone - Interior Cedar-Hemlock.
PCT_LAKE_SURF_IDF PCTLKSRFDF NUMBER 3 PCT LAKE SURF IDF is the percent of lake surface area in each BEC Zone - Interior Douglas-fir.
PCT_LAKE_SURF_IMA PCTLKSRFM NUMBER 3 PCT LAKE SURF IMA is the percent of lake surface area in each BEC Zone - Interior Mountain-heather Alpine.
PCT_LAKE_SURF_MH PCTLKSRFMH NUMBER 3 PCT LAKE SURF MH is the percent of lake surface area in each BEC Zone - Mountain Hemlock.
PCT_LAKE_SURF_MS PCTLKSRFMS NUMBER 3 PCT LAKE SURF MS is the percent of lake surface area in each BEC Zone - Montane Spruce.
PCT_LAKE_SURF_PP PCTLKSRFPP NUMBER 3 PCT LAKE SURF PP is the percent of lake surface area in each BEC Zone - Ponderosa Pine.
PCT_LAKE_SURF_SBPS PCTLKSRFSB NUMBER 3 PCT LAKE SURF SBPS is the percent of lake surface area in each BEC Zone - ub-Boreal Pine-Spruce.
PCT_LAKE_SURF_SBS PCTLKSRFS1 NUMBER 3 PCT LAKE SURF SBS is the percent of lake surface area in each BEC Zone - Sub-Boreal Spruce.
PCT_LAKE_SURF_SWB PCTLKSRFSW NUMBER 3 PCT LAKE SURF SWB is the percent of lake surface area in each BEC Zone - Spruce-Willow - Birch.
BEC_ZONE BEC_ZONE VARCHAR2 16 BEC ZONE is the overall dominant BEC zone for each lake.
MODELLED_MEAN_DEPTH MDLLDMNDPT NUMBER 8 MODELLED MEAN DEPTH is the MODELLED MEAN DEPTH is the modelled mean depth of a lake in metres using a multiple linear regression equation.
MODELLED_SURF_TEMPERATURE SURFTEMP_C NUMBER 3 MODELLED SURF TEMPERATURE is the modelled temperature classes in Celsius 1 = cold; 2= cool; and 3 = warm.
MODELLED_LAKE_VOLUME MOD_VOL NUMBER 10 MODELLED LAKE VOLUME is the modelled lake volume in cubic metres calculated using modeled lake mean depth [MOD_MDEPTH] multiplied by lake surface area [AREA].
MODELLED_LAKE_FLUSHING_RATE FLRATE_MOD NUMBER 12 MODELLED LAKE FLUSHING RATE is the modelled lake flushing rate is calculated as a lake's accumulative precipitation yield [ACC_PPT_YL] divided by modeled lake volume [MOD_VOL] If a lake is isolated (no inflow or outflow), then it is given a flushing rate value of 1.00
MODELLED_LAKE_FLUSH_RATE_CLASS FLRATE_CLA NUMBER 3 MODELLED LAKE FLUSH RATE CLASS is the modelled lake flushing rate classes derived from five equal area intervals of BC lakes ranked in order of their modeled flushing rates from high to low. 1 = very low; 2 = low; 3 = moderate; 4 = high; and 5 = very high.
NUM_DEGREE_DAYS_ABV_4C DD4_CLASS NUMBER 3 NUM DEGREE DAYS ABV 4C is the modelled degree days above 4oC (Celsius) classes based on natural breaks in variability (Jenk's optimization) of the DD4 variable for all BC lakes.
MODELLED_SURF_TEMP_CLASS TEMP_CLASS NUMBER 3 MODELLED SURF TEMP CLASS is the modeled temperature classes based on a cross of a lake's surface temperature class [SURFTEMP_C] with its degree day class [DD4_CLASS]. First number = surface temperature class; second number = degree day class.
MODELLED_DISSLVD_NUTRNT_CLASS DISSNUTR_C NUMBER 3 MODELLED DISSLVD NUTRNT CLASS is the modelled dissolved nutrient classes based on a cross of a lakes flushing rate class [FLRATE_CLA] with its geology class [GEO_CLASS]
BEDROCK_GEOLOGY_CLASSES GEO_CLASS NUMBER 3 BEDROCK GEOLOGY CLASSES are: Aluvium; Serpentine and other Chemical Sediments; Carbonates; Hard Sedimentary Rock; Soft Sedimentary Rock; Volcanic; Intrusives and Metamorphics; and Mixed (No dominant geology type (i.e., at least 50% of the lake surface area)).
LAKE_ECOSYSTEM_CLASS LKCSSTMCLS VARCHAR2 16 LAKE ECOSYSTEM CLASS is the lake ecosystem class. Hydrologic Connectivity Classes:I: IsolatedU: HeadwaterD: Drainage
LAKE_ECOSYSTEM_TYPE LKCSSTMTP VARCHAR2 16 LAKE ECOSYSTEM TYPE is the lake ecosystem type:I1, U1, D1: Coastal. I2: Interior, Low Relief in the NE. I3: Interior excluding the NE. U2:Interior, Foothills. U3: Small. U4: Large. D2: Interior, Low Relief in the NE. D3: Interior, Low Relief in the Central Interior. D4: Moderate to High Relief. D5: Large. - 999: Undefined.
LAKE_TYPE_LABEL LKTPLBL VARCHAR2 16 LAKE TYPE LABEL is the Lake ecosystem type after eliminating the code for undefined ("- 999") from the Lake Ecosystem Type values for presentation purpose.
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE CODE is a standard alphanumeric code to identify the type of feature represented by the spatial data.
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.
FEATURE_AREA_SQM NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters

Comments

No comments have been posted yet.